PROFESSIONAL SUMMARY:

• 10 years of experience in the field of Data warehousing & Business Intelligence, Health care and Banking.
• Worked as an ETL Developer, Team Lead and Business Data analyst with a good exposure on the data warehousing concepts covering the entire life cycle from requirements gathering to the production live.
• Experience with pharmacy claims data, Membership data, pharmacy benefit manager (PBM) operations on health care.
• Strong experience on SQL Developer.
• Expertise in defining the business process flow and gathering business requirements.
• Expertise in preparing mapping documents with taking responsible for maintaining the Source to Target mappings as per business rules.
• Coordinating with the Data Modelers and DBAs in preparation of Data model as per mapping documents.
• Writes complex, highly optimized queries across large volumes of data to create detailed and accurate outputs with understanding of statistics.
• Create Test Plan, and Test cases based on mapping/requirement documents to perform UAT Validations to make sure that all the requirements meet as per business standards.
• Creating the defects in QC if there are any outstanding defects during UAT validation.
• Performs ad - hoc data analysis and reporting with prior knowledge on the Health care business.
• Involved in preparing the change request requirements if there are any outstanding defects in the last moment of production.
• Develop analysis, forecasting and optimization methods/models to provide the business solution to the clients.
• Conduct end to end analysis on Pharmacy claims that includes data gathering, requirements specification, analysis, and ongoing deliverables.
• Interacting with the end users and make sure all the requirements are covered in the final reporting.
• Responsible for project planning and tracking of tasks to meet the timelines and provide weekly status report to the client.
• Working knowledge of Microsoft Office Suite (MS Visio, MS Project, MS Word, and MS PowerPoint).
• Advanced proficiency with Excel (Pivot tables, pivot charts, conditional formatting, VLOOKUP, formulas)
• Extensive ETL experience using Informatica 10.2.1/9.6.1/9.1 (Designer, Workflow Manager, Workflow Monitor and Server Manager), Power Exchange
• Expertise in working with Oracle Stored Programs, Packages, Cursors, Triggers, Database Link, Roles, Privileges, Tables, Constraints, Views, Indexes.
• Experience in BI Reporting, Tableau, UNIX shell scripting, SAS, Teradata SQL Assistant.

TECHNICAL SKILLS:

Domain Knowledge: DW, BI: Healthcare and Banking

Operating System: Windows XP, Windows 10 and UNIX

Programming Languages: Informatica 10.2.1/9.6.1/9.1

Databases & Tools: Oracle SQL Developer, Tableau, BI Reporting, Teradata SQL Assistant

Other Utilities: SAS, TOAD, Putty, Shell Scripting, Control M, Tivoli, ALM and Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, Pasadena, CA

Business Analyst

Responsibilities:

• Involved in preparing mapping documents with taking responsible for maintaining the Source to Target mappings as per business rules.
• Involved in LSDD and PSDD review with the ETL development team and provides inputs in preparing LSDD and PSDD with prior experience on health care.
• Coordinating with the Data Modelers and DBAs in preparation of Data model as per mapping documents.
• Conduct end to end analysis that includes data gathering, requirements specification, analysis, and ongoing deliverables on Pharmacy claims.
• Develop SQLs to perform UAT Validations to make sure that all the requirements meet as per business standards.
• Create Test Plan, Test Scenarios and Test cases based on mapping/requirement documents.
• Creating the defects in QC if there are any outstanding defects during UAT validation.
• Involved in reviewing the SIT Test cases, test plan, Defects and the test results.
• Maintaining a log of all open items or issues and proactively solve the problems to meet the deliverables as per the project schedule
• Performs requirement analysis using the existing production data for CDW-NPS interface project including CA and ROC regions with prior knowledge on the Health care business.
• Involved in preparing the change request requirements if there are any outstanding defects in the last moment of CDW-NPS production.
• Interacting with the end users and make sure all the requirements are covered in the final reporting.
• Provide weekly status report to the client.

Environment: Oracle SQL Developer, BI Reporting, Tableau, Teradata SQL Assistant, SAS, ALM and Quality Center

Confidential, Oregon

Sr. ETL Informatica developer

Responsibilities:

• Responsible for gather the requirements from clients, analyze and provide estimates.
• Creating a technical design for the business requirements and walk through design patterns with client and loading the data into data warehouse (ETL).
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplets Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter and Source Qualifier.
• Used Informatica repository manager to backup and migrate metadata in development, test and production environments.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in writing shell scripts on Unix for Informatica ETL tool to run the Sessions.
• Worked on NCRS and Pharmacy Data Warehouse sources in pharmacy claims, also worked on Plan ID lookup and enrollment projects.

Environment: Informatica 9.5.1, SQL Server, Tivoli, UNIX shell scripting

Confidential

ETL Informatica developer

Responsibilities:

• Analyzing the procedures and developed the decommission design documents.
• Created schema related architecture and current Info1 schema process flow diagram using Visio for each schema.
• Monitor the active and inactive control-M jobs in production,
• Used to find the Active and Inactive Unix shell scripts in Production.

Environment: Informatica 9.1, Oracle 10g, UNIX, Control-M

Confidential

ETL Informatica developer

Responsibilities:

• Worked to design, develop the Informatica Mappings and Sessions based on business user requirements and business rules to load the data into target.
• Worked on extraction, transformation and loading of data from different sources like Flat Files, DB2 and COBOL file sources.
• Worked with DBA to set up the DEV and QA environment.
• Worked to monitor the workflow monitor jobs, reviewed session/workflow logs that were generated for each session to resolve issues and used Informatica debugger to identify issues in mapping execution. She Involved in Unit Testing, preparing the test case documents and code review before deployment.
• Given support during UAT and production for the jobs which we have developed.

Environment: Informatica 9.1, Oracle 10g, UNIX, Control-M