SUMMARY:

• Software Engineering professional offering nearly 8+ years of a successful career with diverse roles distinguished by commended performance in:
• Requirement Analysis Design & Documentation ETL Development
• Performance Tuning Root Cause Analysis Scrum Management
• Customer handling Testing & Validation Team leading (Technical)
• Subject Matter Expert in Data Warehousing and ETL - Informatica Power Center.
• Strong experience in business and data analysis. Interacted with system users in gathering business requirements and project developments.
• Exceptionally strong in writing Data Mapping documents , data transformation rules, Data cleansing and Code Migration experience using Informatica.
• Good experience in Scrum management. Assisted Product Owners in creation/maintenance of Product Backlog and helped team to remove impediments by having an understanding on agile control and release processes.
• Expertise in writing large/complex SQL and PL /SQL - Stored Procedures.
• Hands on experience in tuning mappings , identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience with dimensional modelling using star schema and snowflake schema.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in resolving on-going maintenance issues and bug fixes , monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in using Scheduling tools like Control-M and Autosys .
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Experience in MicroStrategy Report development and hands-on experience on Schema objects (Hierarchies, Attributes and Facts) & Public objects (Reports, Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups).

KEY COMPETENCIES &TOOL PROFICIENCY:

Data Warehousing Tool: Informatica Power Center 9.6.1,IDQ tool.

Reporting Tools: Tableau & Microstrategy.

Programming GUI: SQL, PLSQL, UNIX Shell Scripting

Scheduling Tools: Control M, Autosys

Databases/Utilities: Oracle-SQL Developer, SQL Server 2007

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Major responsibility includes directly interacting with clients on Requirement /Design phase.
• Being a regulatory reporting project, worked closely with business in performing the LCR calculation and delivering the dashboards across the clients on daily basis.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and files. Development of ETL using Informatica 9.6.1
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, workflow designer in Workflow manager and monitored the results using workflow monitor.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Automated the Informatica jobs using UNIX shell scripting.
• Developed Tableau Visualization Reports for business analytics.
• Used RALLY tool for scrum and creating other artifacts. team members on Agile principles and providing general guidance on the methodology

Confidential

Responsibilities:

• Gathered details on the requirement, performed impact analysis and prepared design document for development activities.
• Created automated rules through stored procedures to ensure data adherence.
• Prepared manual SQL Queries to validate the data loaded in target databases.
• Created and assisted in creating test plan and generated test cases based on the requirements.
• Performed unit testing, peer reviews, Integration testing and support.

Confidential

Responsibilities:

• Involved in requirement gathering phase and prepared design document for development activities.
• Have developed scripts to load the data into target data warehouse using UNIX Shell Scripting
• Created test plan and generated test cases for performing data validation to capture all the actual and negative scenarios.
• Performed unit testing, peer reviews, Integration testing and support.

Confidential

Responsibilities:

• Worked on ETL Informatica tool for loading the data from different sources into different targets.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and files.
• Development of ETL using Informatica 9.6.1
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, workflow designer in Workflow manager and monitored the results using workflow monitor.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Worked on Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Created Test cases for the mappings developed and then created integration Testing Document.