Tahir Ahmed

- The scope of the project is to integrate the data set from different source systems to SAP H4 Hana using Informatica and UNIX shell scripting.
- Worked with Client manager and technical functional manager for data plan flow for each interface.
- Building new mappings for Inbound interface, Source system to SAP and vice versa SAP to source system called Outbound Interface.
- Used extensive XML generators and XML parsers as data is injected in XML data into SAP s4 Hana.
- Automated the existing shell scripts and created new scripts for updated requirements.
- Worked with Toyota vendors DXC tech and Infosys for data file management.
- Optimization of Informatica codes for better performance.
- Coordinate between onsite and offshore task initialization.
- Technology & Tools Informatica Developer 10.4, UNIX shell scripting, SAP H4 Hana.

- The scope of the project is to migrate the Netezza objects to Amazon Redshift and converting the mappings to Pushdown compatible.
- To work with Onsite and SBO heads to list the objects to be migrated.
- Building new mappings to convert the existing codes to be pushed as Pushdown Optimization (PDO).
- Converting the shell scripts that are listed down in the migration scope.
- Optimization of SQL queries/Informatica codes for better performance.
- Coordinate between Onsite and offshore task initialization.
- Documenting and presenting the technical solution to the client.

- Tools and Technologies - Informatica Developer 10.2.0, Amazon Redshift 1.0.4936, UNIX shell scripting.

- The scope of the project is to migrate the Informatica 9.6 to 10.2.1 Developer and pointing the database objects to Amazon Redshift.

- Worked with client to identify the DataMart’s to be migrated in batches
- To decode the existing ETL logics available in Power Center and redesign the ETL logic in informatica version 10.2.1.
- Working on optimization of the sql macros from Teradata to AWS Redshift.
- Developed generic shell scripts for file ftp download and upload using control tables.
- Wrote Ad Hoc Queries to effectively meet the requirements
- Done the Functional testing and unit testing of the stored procedures by checking the various scenarios and tested the exception handling if the error is being handled in the right way.

• - Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
  - Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
  - Trained in coding for numerous Data Warehousing solutions, including Netezza and Terrada.
  - Mapped data between source systems and warehouses.
  - Coordinated troubleshooting support for warehouse personnel.
  - Completed quality reviews for designs, codes, test plans and documentation methods.
  - Cooperated fully with product owners and enterprise architects to understand requirements.
  - Collaborated with multi-functional roles to communicate and align development efforts.

- Switching from GNP source account to GNP2.
- Interpreted data models for conversion into ETL diagrams and code.
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Worked closely with clients to establish specifications and system designs.
- Rechurn process of the Fact tables based on client requirements/request
- Coordinated with client regarding the RECON process

- Upgradation of ETL Tool from version 9.5.1 to 10.1.1 and its respective UNIX account.
- Involved in all aspects of design and planning structure.
- Analysis of the Informatica codes to be changed and listing down the upgradation impact.
- Changed all the UNIX shell scripts and pmcmd commands those points to the previous server.
- Managed deliverables and timelines by coordinating with the team
- Lead the team to complete the deadline provided by the client.
- Coordinate with the team and maintained all the necessary checklist documents.

- Salesforce application to provide rebates information about the pharmacies tied up with Amerisource to generate the compo score to each pharmacy based on the contract signed.
- Developed mappings, workflows and tasks using Informatica.
- Developed and modified programs to meet customer requirements.
- Actively listened to customers' requests, confirming full understanding before addressing concerns.
- Developed the ETL codes to pull records from salesforce table and its respective ODS layer tables.
- Developed shell scripts that loops the process until all the records have been downloaded.
- Managed deliverables and timelines by coordinating with the team.
- Maintained and supported process continuity by identifying and fixing load failure issues.

-To develop DataMart where it stores information about patient, prescriber and all the insurance plan and its respective claim on drugs. This emdeon CHC datamarts gives us insights about the transaction level of each patient’s drug purchase.
-Preparation of high level and lowlevel design documents using ms visio
-Development of ETL Mappings, sessions, workflows and parameter files for different functionalities.
-Unit testing
-Defect analysis and defect fixing
-Preparation of module release document
-Reengineering on data extraction from SAP legacy system.
-Communicating with SAP admin and support team for source data profiling

- To develop DataMart where it stores information about sales, profits and contacts of customers. Using the existing database, the system analyzes the sales and profit for each transactions of its customer and generates reports for PRxO leakage where the client can understand the sales leakage and area of improvisation. The resulting model gives us an idea about growth in profit, prediction about increase in sales.
- Involved in all phases of the project life cycle.
- Analysis of Requirements and Preparing the Technical Design Document.
- Developed ETL code using Informatica and shell scripting.
- Automated the existing source file check and developed client Ad-hoc request for the PRxO customer wrapper process using shell scripting.
- Done the Functional testing and unit testing of the ETL codes by checking the various scenarios.
- Exposure to client interaction, user-requirement analysis and user support.
- Involved in Tuning/Optimizing Informatica and SQL codes

- The scope of this project is migration of stored procedures from SQL Server to Netezza database and redirects the Informatica mappings to the newly migrated database.
- Analyzed the stored procedures in SQL Server and the flow of the process of stored procedures.
- Developed similar stored procedures in Netezza, verifying that the logic of the procedure does not change due to the replacement of the functions specific to SQL Server.
- Changed the process involving the cross database in SQL server to new procedures as the cross-database concept does not work in Netezza.
- Perform NZLOAD to tables from source data files.
- Wrote Ad Hoc Queries to effectively meet the requirements.
- Done the Functional testing and unit testing of the stored procedures by checking the various scenarios and tested the exception handling if the error is being handled in the right way.

- The scope of this project is to automate the accrual process to reduce multiple manual steps to calculate the monthly accruals to an extent and to give better visibility to the data by leveraging the POS data from existing data mart. Digital POS Accrual automation is divided into two channels as International and Domestic to calculate the monthly accruals respectively.
- Interpreted data models for conversion into ETL diagrams and code.
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Directed data transformations and transitions.
- Verified performance and reliability of development database transformation solutions via extensive simulation testing.
- Optimized broken and inefficient assets through effectively troubleshooting technical processes and workflows.