MD MODASSAR AKHTAR

Client : Novartis

Environment : Informatica 10 x

Database : Oracle 11g

Responsibilities:

• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, XML Oracle into a common target area such as Staging and then into the target system.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to final target.
• Extensively used Informatica to load data from Oracle and Flat Files to Oracle.
• Involved into source code review, the mappings created by my team members.
• Used the Workflow manager to create workflows, reusable /non reusable tasks and created worklets.
• Handled slowly changing dimension of Type 2 to populate current and historical data.
• Involved in Unit testing for the mappings developed by myself. Involved in peer reviews.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
• Used SQL tools like Toad to run SQL queries and validate the data loaded into the target tables.
• Involved Actively in Table Load Delay Notifications to Business users.
• Involved in Analyzing and resolve the Service Now Requests assign to Data Integration group during shift hours.
• Sending handover email to onshore once the shift is completed.
• Actively involved in daily statues Meeting and knowledge documentation.

• Engaged in an action and product recognition project, focusing on utilizing image review tools to train deployed ML models.
• Specializing in converting unstructured data into structured formats.
• Collecting daily performance metrics and recording them in Excel.
• Employing Data Cleaning Techniques in Excel or SQL to clean collected data.
• Preparing data for analysis through visualization and providing insights to stakeholders.

• Day-to-day responsibilities involve data review.
• Specialized in the Personal Identification Information project, focusing on data collection, cleaning, and report creation using Excel.
• Engaged in data investigation projects, gathering responsive data crucial for litigation cases by law firms.
• Proficient in managing raw data, converting it into required reports through cleaning and manipulation in Excel, and timely submission to litigation stakeholders.

• Direct client : Infosys Ponton
• End Client: Apple
• Worked as a US IT recruiter.
• Recruiting for Java Developer.