AAMIR KHAN

• Roche Diagnostics – India, is pioneering in the field of tailor made BI solutions for the end user (Professionals as well as organizations) with the products ranging from Dashboards to full-fledged BI suits.

Squad lead with responsibilities as:

• Work with Product owners to understand the requirements for any new or existing product.
• Create BI solutions as per the requirements using the in-house ETL platform and Vertica.
• Work with the QA, Visualization teams and implementation teams.
• Also working in the migration project with the aim to migrate the existing platform tools to Amazon redshift as DB solution, Apache Airflow as orchestration tool , Docker and Kubernetes as containerization tools and Apache Superset for visualization.

• Working for, one of the largest Pharma Companies in Silicon Valley, California developing and commercializing medicines for the treatment of cancers and immune-mediated diseases for which there is great unmet medical need.

Responsibilities: Lead a team of 4 members from offshore while:.

• Working as Technical Lead to analyze business requirements and derive technical solutions.
• Created document with MDM data model, source system definition, data mapping and cleansing requirements, trust score and matching rule definitions.
• Coordinated with Business Leads in making them understand Match & Merge and incorporated their requirements and ideas.
• Involved in implementing the land process of loading the customer data set into Informatica MDM from various source systems.
• Worked with Data Steward Team for merge/unmerge operations.
• Involved in on-going enhancements to ETL as well as MDM functionality.

• One of the biggest Insurance companies and a national federation comprised of more than 50 individual clubs throughout the United States, while providing valuable membership services such as roadside assistance.

Responsibilities: Lead a small team of 6 members while responsible for:.

• Responsible for the overall technical solutions to upgrades several applications from previous version (Informatica as well as batch jobs scripted on Unix) working closely with the Admin team.
• Defining technical solutions for all team members.
• Providing estimates for Informatica technical tasks to the project manager.
• Gather Requirements and IT review.
• Interact with business users in the design of technical specification documents.
• Create and maintain adequate documentation of project ETL design, technical artifacts and ETL environment.
• Conduct and provide oversight for administration and upgrades for the Informatica environments to ensure the development environment is maintained for required performance and functionality to meet the business needs.
• Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Created Stored procedure transformations to populate targets based on business requirements.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created ETL mapping specification document as well as documentation for program development, logic, coding, testing, changes and corrections and deployment documents.
• Involved in Unit and Integration testing of Mappings and sessions.
• Assisted Testing team in creating test plan and test cases.

• One of the market-leader in the Indian Retail space with multiple ventures, right from lifestyle products to electronics and more. I was responsible for development testing and providing support while extracting data using Power center designer loading the data to the target warehouse.

Responsibilities:.

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source.
• Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Conducted code reviews developed by my team members before moving the code into QA.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in production support.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Working for one of New Zealand's big four banks, with branches and extension counters and ATMs throughout the country.

This system involves an OLTP system and Data Warehouse system for loading the data coming from various sources and loading into the data warehouse and reporting.

Responsibilities:

• Developed ETL mappings, transformations using Informatica Powercenter.
• Implemented source and target definitions in workflow designer.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Mappings were designed to cater the slowly changing dimensions.
• Used various stored procedures in the mappings.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Mappings were designed to the utmost performance by optimizing expressions in expression editor of transformation, filtering source data at the source qualifier, and applying transformation logic.