PROFESSIONAL SUMMARY:

• Over 17 years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Application Development, Implementation and Testing of Applications in Data warehousing with business knowledge of Healthcare, Financial, Insurance domains.
• Managing team of 20 both at offshore and onsite.
• Good working experience in SDLC (Software Development Life Cycle) methodologies like waterfall and Agile.
• Experience in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center 9.x/8.6, Power Exchange and Informatic Data Transformation(B2B), Informatica MDM, IDQ
• Worked on IBM Datastage
• Experience in Installation and Configuration of Informatica Client and Repository.
• Expertise in RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL
• Extensively worked Different Database Oracle, SQLServer, DB2
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Experience in Interacting with Business Users to gather Business Requirement Specifications Document and Prepare System Requirement Specifications document.
• Extensively worked on Data extraction, transformation, loading with Oracle, SQL Server 2012, DB2 using Informatica.
• Having hands on Experience in B2B DataTranformtion for converting EDI (X12)like 835/271 to XML
• Having exposure to MDM Tool IBM Initiate inspector
• Having good Experience on Scheduler Tool Control - M, Autosys,Tidal
• Experienced with Data Extraction, Transformation and Loading(ETL) from disparate Data Source databases like Oracle, SQL Server, flat files, CSV files, EDI, XSD and XML files and loaded into target warehouse by using various transformations in Informatica.
• Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the Session logs.
• Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions and experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplet.
• Good experience with Informatica Performance Tuning.
• Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, Slowly Changing Dimensions.
• Extensive experience in onshore/offshore work model, being on both fronts.
• Having knowledge on Informatica IDQ
• Having knowledge on Big Data.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Able to work independently and collaborate proactively & cross functionally with multiple teams.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/9.1/8.6.1/ 8.1.1

Utilities: Power Exchange, Informatica Data Transformation(B2B), Informatica IDQ

Data Modeling: Dimensional Data Modeling, using Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Hadoop: Talend, Hive, PIG, HDFS

Databases: Oracle 11g/10g, SQL Server

Scripting: Unix Shell scripting, SQL stored procedures

Scheduler Tools: Dollar Universe, Control -M, Tidel

MDM Tool: IBM Initiate inspector

DB tools: SQL / PL SQL, TOAD, Oracle Developer

Operating System: UNIX (AIX, Sun), Windows

Agile Tools: Version One,Trello

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. ETL Informatica Tech Lead

Responsibilities:

• Coordinate with ODS/OLTP Enterprise Architects, Data Modelers and Product Owners and Business Analysts will review and finalize Business Requirement documents along with ETL tech leads to provide Functional and technical Specifications
• Requirement triage for each CRs and technical discussion with the functional analyst to map the requirements into a ETL Technical design document and interact with business analysts and gather information for enhancements and Change Requests.
• Analyze existing OLTP data model and identify gaps in the proposed solution, make recommendations for resolving gaps, and monitor results
• Impact analysis on claim systems and accordingly create ETL workflow process to automate or improve existing system.
• Preparing high level and low level technical designs (TDD) for each change request such as client extracts, ODS claim loads, Authorizations load to Ika systems. Mapping logic for target will be developed during this TDD process.
• Informatica power center 10.1 designer, workflow Manager is being used for building the application as per CRs and mapping Business requirements.
• Coding and development/enhancement/modification of new/existing programs using and configuring jobs with CTRL-M into Technical solutions and Design
• Preparing SFTP scrips. Deploy Code changes to MS Visual Studio to maintain versions
• Data validations, Preparing ETL patterns for all workflows
• Migrating the Code into various Environments such as TEST/STAGE/PROD by using JIRA tool
• Managing integration of application with other on premise application interfaces. And Report integration tickets for RCA(root cause analysis), permanent resolution and SLA compliance for any issue in project code functionality
• Participating in all the release management activities and providing description of project, back out plans and Implementation of enhancements in to real time environment. Involve in production support activities during warranty period after project goes live
• Supporting Production environment for various data from Premera, Nebraska, Innovare, EOB, EOP, ZO system and Fix the Production workflow bottlenecks in ETL Processes
• Demonstrating UTR to the business analysts and provide UAT support for the migrated code to TEST/STAGE.
• Interaction with different teams like application teams, interfacing teams, network teams and devise an agreeable and feasible solution, Coordinating and working with offshore team to explain project requirements, providing technical guidance and getting the deliverables
• Attending Retrospective meetings with team at the end of every iteration to discuss on the best practices and lessons learnt to adopt in future requirements
• Responsible for maintaining integration project deliverable for maintaining all tasks raised which will be used for project SLA analysis
• Extensively used Informatica power Centre loading the data from sources involving sources like Oracle, Sql server, DB2
• Created ETL mappings for various layer of data loads like Staging and Production
• Developed and scheduled Workflows using task developer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Review of the mappings, mapplets, sessions and workflows and workletes for ETL standards.
• Preparing detailed Design document, Data Element sheet, UTC & Unit Testing of Code.
• Prepared Unit Test/ Assembly Test cases and executed unit test scripts
• Created the Sample Files for SIT and Tested in SIT Environment.
• Involved in code Reviews as per ETL/Informatica standards and best practices.
• Deployed the components from DEV to QA.
• Code migration to QA.
• Prepared One-shot scripts for abended jobs and deploy this code into production.
• Maintained the Defect Tracking and fixed the Defects.
• Managing offshore team.
• Setting up and coordinating meeting with Offshore and business users.
• Reporting daily status and weekly status with client.

Environment: Informatica power Center 9.6, Oracle11g, SqlServer, UNIX (AIX), SQL.Oracle Developer, Rapid SQL. CTRLM, PPM Pro, MS Visual Studio

Confidential, Portland, OR

Sr.ETL Informatica Developer

Responsibilities:

• Interaction with client for status updates on tasks and requirements gathering for new requirements
• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Extensively used Informatica power Centre loading the data from sources involving sources like Oracle, Sql server, flat files, XML and loaded into DWH.
• Created ETL mappings for various layer of data loads like Staging, DWH.
• Developed and scheduled Workflows using task developer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Monitoring ETL loads using Dollar universe
• Reviewed the mappings, mapplets, sessions and workflows for ETL standards.
• Involved in review of detailed Design document, RDT, Data Element sheet, UTC & Unit Testing of Code.
• Prepared Unit Test/ Assembly Test cases and executed unit test scripts successfully
• Created the Sample Files for SIT and Tested in SIT Environment.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Involved in code Reviews as per ETL/Informatica standards and best practices.
• Created Turns for Code migration to QA and Prod.
• Resolved process abends, change orders, Incidents.
• Prepared One-shot scripts for abended jobs and deploy this code into production.
• Maintained the Defect Tracking and fixed the Defects.
• Assigned tasks to the offshore team.
• Setting up and coordinating meeting with Offshore and business users.
• Provide end to end Knowledge Transfer to Offshore team. scheduled daily status and weekly status meetings with offshore and client.

Environment: Informatica power Center 9.5, Flat files, XML, UNIX (AIX), SQL, PL/SQL, Mainframe, Oracle 11g, Toad, Dollar universe, Informatica MDM

Confidential

Sr.Project Lead

Responsibilities:

• Proficient in understanding business processes/requirements and translating them into technical requirements
• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Created the Source and Target XSD based on requirements.
• Created ETL mappings using Informatica Power Center to move Data from sources like XSD, XML, loaded into XML, Oracle, SqlServer.
• Created ETL mappings and mapplets for various layer of data loads like Staging, DWH, DataMart.
• Reviewed the mappings, mapplets, sessions and workflows for ETL standards.
• Involved in review of detailed Design document, RDT, UTC & Unit Testing of Code.
• Prepared Unit Test/ Assembly Test cases and executed unit test scripts successfully
• Created the XML Files for SIT and Tested in SIT Environment.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Involved in code Reviews as per ETL/Informatica standards.
• Monitoring ETL loads using Control-M
• Used PMCMD, and UNIX shell scripts for workflow automation.
• Parameterized the mappings and increased the re-usability
• Created and defined DDL’s for the tables at staging area.
• Used code debugging at mapping level and did enhancements.
• Created label, Queries and Deployment groups for Migration to QA.
• Created Turns for Code migration to QA.
• Maintained the Defect Tracking and fixed the Defects.
• Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Setting up and coordinating meeting with Offshore and business users.
• Provide end to end Knowledge Transfer to Offshore team. scheduled daily status and weekly status meetings with offshore and client.
• Provide end to end Knowledge Transfer to Offshore team.

Environment: Informatica Power Center 9.5, Oracle 11g, Sql Server, UNIX (AIX), Windows XP,TOAD, Unix Shell script, Business objects. Flat files, XSD, XML, Informatica MDM

Humana

Sr.ETL Informatica Developer

Responsibilities:

• Interaction with client for status updates on tasks and requirements gathering for new enhancements
• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Created the Source and Target XSD based on requirements.
• Created ETL mappings using Informatica Power Center to move Data from sources like XSD, XML, loaded into XML.
• Reviewed the mappings, sessions and workflows for ETL standards.
• Identify the bugs in existing mapping by analyzing the data flow.
• Responsible for writing unit test cases and performing unit testing.
• Created the XML Files for SIT and Tested in SIT Environment.
• Created the UProcs, Session, Task in $Universe Scheduler Tool.
• Scheduled the Informatica jobs by using $Universe in DEV and QA.
• Migration between Development, Test and Production Repositories
• Maintained the Defect Tracking and fixed the Defects.
• Monitored the workflows.

Environment: Informatica power Center 9.1,Flat files, XML, UNIX, Version One, Unix Shell Script, Windows XP, IBM Initiate inspector