SUMMARY:

• Eight years of experience in the IT industry with extensive Domain knowledge of Health Care, Insurance, Supply Chain and Pharmacy including experience in using Informatica power center/power mart and Bussiness Objects(WEBI).
• Expertise in EDI transactions used in healthcare industry and good knowledge of HIPAA X12.
• Experience on Extraction, Transformation and Load (ETL) of data from Legacysystems using Informatica (10.1/9.5.1/ 9.1.0/9.0.1 /8. x).
• Demonstrated experience with Power Exchange connectivity to SQL Server and DB2.
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server, DB2.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Experience with dimensional modeling using Star Schema and Snowflake models.
• Expertise in Data Warehousing concepts like Bill Inmon methodology and Ralph Kimball methodology, fact tables, dimension tables.
• Understand the business rules completely based on High Level document specifications and implement the data transformation methodologies.
• Strong experience in designing and developing business intelligence solutions in Data warehouse/Decision Support Systems using ETL tools Informatica Power Center 10.1/9.1/8.6.1/8.1, Power Exchange, B2B DT Studio.
• Proficient in Informatica Designer components like Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer (Re - usable transformations), Workflow Manager, Workflow Monitor.
• Worked extensively with Slowly Changing Dimensions.
• Experience in gathering requirements with end user and respond to customer requests based on priorities.
• Experience in data integration of various data sources from Databases like MS Access, DB2,Oracle, SQL Server and formats like flat-files, COBOL and XML files.
• Extensive experience in Performance Tuning -Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance and SQL Queries.
• Demonstrate the analytical ability to understand the business requirement/process, convert the business specification to technical document, data management, develop and integrate solutions to meet the requirement.
• Coordination with business users for user acceptance testing, signoffs and implementation.
• Developed test plans, test cases and test procedures for unit testing, system testing and interpreted test results.
• Ability to learn and adapt quickly to the emerging new technologies.
• Have a good exposure in company’s quality process and methodologies.
• Strong knowledge on Agile SCRUM methodology, Waterfall model and Test Driven Development
• Dedicated self-motivated achiever who is committed to success and adapt at juggling multiple tasks in a high-pressured environment.
• Certified in Base SAS.
• Ability to maintain professional demeanor in high-stress situation.
• Excellent Interpersonal Skills with the ability to work independently and with the Team.

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica 10.1/9.5.1/ 9.1.0/9.0.1 /8.6/8.1.2, B2B DX/DT Studio, Informatica Designer, Workflow Manager and Workflow monitor.

BI Tools: Business Objects, Tableau

Programming Languages: C, C++,PL/SQL, SAS Basis

Database: Oracle 8i/9i/10g/11g, IBM DB2, SQL Server 2012,Netezza, MS-Access.

Operating systems: Windows 95/2000/NT/XP/Vista, UNIX.

Data Modeling Tool: Erwin4.0/4.1.

Utilities: Oracle SQL Developer, TOAD, SQL*LOADER

Job Scheduling Tools: Informatica Scheduler, Control- M, Autosys.

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

ETL Informatica Developer

Responsibilities:

• Interact with Business to understand and analyze the requirements.
• Design, develop and test PL/SQL stored procedures, packages, ETL processes for different health programs like HIX, TANF, SNAP, Medicaid and Federal Employee Program.
• Developed mappings/sessions using Informatica Power Center 10.1 for data loading.
• Created Complex mappings that involved implementation of Business Logic to load data intostaging area.
• Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
• Received internal diploma certifications for various Confidential standard data security courses such as Privacy and information security refresher training, General Data Privacy and Information Security Training, Identifing Phishing emails, ClearQuest for Windows.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregator, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Providing 24x7 production support.
• Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
• Performed Unit testing of Informatica ETL process to ensure ETL logic.
• Designed and documented REST/HTTP APIs, including JSON data formats and API versioning strategy.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Created command files and used Control-M for running the jobs to make sure all dependencies (mappings) are in good shape before moving the code to production.
• Generated DML Queries for manipulating database objects like tables, views, using insert, update and delete commands.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Participate in test results document preparation for the project.

Environment: Informatica Power Center 10.1(Power Center Designer, workflow manager, workflow monitor), PowerExchange, HIPAA X12 transactions, WinSQL, UNIX, SQL Developer, Erwin, Putty, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g,SAP Power Connect, HIP Chat, VersionOne, Mingle, Sharepoint, Agile.

Confidential, Atlanta, GA

Sr ETL Informatica Developer/Admin

Responsibilities:

• Interact with Business to understand and analyze the requirements.
• Translated requirements into business rules & made recommendations for innovative IT solution.
• Working closely with user decision makers to develop the transformation logic to be used in Informatica Power Center.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for different types of studies for Daily, Monthly and Yearly Loading of Data.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.
• Used stored procedures drop and create indexes before and after loading data into the targets.
• Removed bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Captured data error records corrected and loaded into target system.
• Designed domain model and implemented ORM mapping using Hibernate
• Tuned Source System and Target System based on performance details, when source and target were optimized, sessions were run again to determine the impact of changes.
• Experienced in troubleshooting and fix the different Development/Production environment issues.
• Used PowerExchange CDC(change Data Capture) for pulling from DB2 source.
• Interfacing with and supporting QA/UAT groups to validate functionality.
• Responsible for regression testing ETL jobs before test to production migration.
• Involved in Workflow, Mapping deployment by using deployment group from Dev to UAT and UAT to Quality and production Repositories.
• Performed Database/ETL migrations from Dev. environment to Test/Training/UAT/Staging and PROD environments.
• Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues.
• Work on daily production incidents and triaging the defects.

Environment: Informatica Power Center 10.1/9.5.(Power Center Designer, workflow manager, workflow monitor),PowerExchange, WinSQL, UNIX, SQL Developer, Erwin, Putty, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g,SAP Power Connect, HIP Chat, VersionOne, Mingle, Sharepoint, Agile.

Confidential, Parsippany, NJ

Informatica Developer

Responsibilities:

• Analyzing the source data coming from different sources and working with business users and developers to develop the Data Model.
• Create functional specifications and work with application technical teams to create the high level and low level design documents.
• Working closely with user decision makers to develop the transformation logic to be used in Informatica Power Center.
• Developing mappings, workflows as per the requirement.
• Work closely with security architect on planning, design and strategic implementation of ISAM 8 migration
• Created flat file targets and XML file targets extensively.
• Worked with UNIX environment for maintaining parameter files.
• Prepare the implementation plan to deploy ETL jobs and batches in Dev, Test and Production environments.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design and development changes.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Implemented efficient and effective performance tuning procedures.
• Used AutoSys for scheduling the Jobs. Responsible for defect tracking in ETL. Contact point for defects in ETL team.
• Handling High priority and criticality incidents.
• Handling work requests and project requests.
• Provided backup liaison with business and IT.
• Understanding the functionality of the application from the business prospective.
• Monitoring and maintaining the scheduled jobs.
• Providing 24x7 production support.
• Resolving the issues within the SLA time to avoid business loss.
• Managing critical recovery call.
• Responsible for maintaining the Quality standards in all the phases.

Environment: Informatica Power Center 9.6.1(Power Center Designer, workflow manager, workflow monitor), WinSQL, UNIX, Business Objects, Erwin, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g,SAP Power Connect.

Confidential, Detroit, MI

Informatica Developer

Responsibilities:

• Interact with Business to understand and analyze the requirements.
• Translated requirements into business rules & made recommendations for innovative IT solution.
• Involved in Dimensional modeling to Design and develop STAR Schemas using Erwin tool to design Fact and Dimension Tables.
• Implemented the DW tables in a flexible way to cater the future business needs.
• Working closely with user decision makers to develop the transformation logic to be used in Informatica Power Center.
• Extensively used Autosys and Tidal for scheduling the UNIX shell scripts and Informatica workflows.
• Proficient in data integration between different sources to the Netezza environment and reporting the same on Tableau environment .
• Worked on Informatica Power Center components- Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
• Worked on Data Analysis and prepared the forecast document.
• Designed and Developed Mappings, sessions and workflows in Informatica.
• Developed mappings and reusable Transformations for ETL using Informatica Power Center.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Created complex mappings using expression, Unconnected Lookup, Sorter, Normalizer, Union, Aggregator, Dynamic Lookup and Router transformations for populating target table in efficient manner.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregator, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
• Performed Unit testing of Informatica ETL process to ensure ETL logic.
• Designed and documented REST/HTTP APIs, including JSON data formats and API versioning strategy.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• Developed test plans, test cases and test procedures for unit testing, system testing and interpreted test results.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation of the daily loads and process flow of the mappings and development of Ad hoc Reports.
• Follow-up on tickets and fixing the issues.

Environment: Informatica Power Center 9.1.0/9.0.1 (Power Center Designer, Tableau,Tidal, Autosys, workflow manager, workflow monitor), Business Objects, Erwin, SQL, PL/SQL, RESTful API, MS-Visio, MS Office,Netezza,DB2, Oracle 10g/11g,SAP Power Connect.

Confidential, Detroit, MI

ETL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, production, user training and support for production environment.
• Developed the mappings using needed Transformations in Informatica tool according to technical specifications.
• Developed mappings/sessions using Informatica Power Center 9.0.1 for data loading.
• Created Complex mappings that involved implementation of Business Logic to load data intostaging area.
• Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
• Design, develop and test PL/SQL stored procedures, packages, ETL processes for different health programs like HIX, Blue Health Assesment and blue health welness programs.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregator, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Developed workflows using task manager, worklet designer and workflow designer in workflow manager and monitored the results using workflow monitor.
• Effectively used Informatica parameter files for defining mapping variables.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and troubleshooting.
• Extensively worked on Data Analysis.
• Extensively worked in fixing poorly designed mappings and developed schedules to automate the Informatica workflows.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Created command files and used Control-M for running the jobs to make sure all dependencies (mappings) are in good shape before moving the code to production.
• Generated DML Queries for manipulating database objects like tables, views, using insert, update and delete commands.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Participate in test results document preparation for the project.
• Worked as a Senior ETL Lead for onsite/offshore model and leading a team.
• Providing 24x7 production support.
• Participate in bug reporting and tracking for the project.
• Monitor and communicate the availability of Informatica Environment.
• Follow-up on tickets and fixing the issues.

Environment: Informatica Power Center 9.0.1(Power Center Designer, workflow manager, workflow monitor), SQL, PL/SQL, Business Objects, Oracle 9i, TOAD, MS-Project, Visio, MS-Word, MS-Excel, DB2, Control-M.

Confidential, Long Island, NY

Informatica Developer

Responsibilities:

• Gathered requirements required by the client.
• Developed user requirements and Functional/Technical specifications.
• Worked extensively on different types of Informatica transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator and joiner.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Promoted Informatica mappings from development to test to production environment.
• Tried to implement best practices following proper naming standards, directory structure, reusability of code etc.
• Involved in Performance Tuning of sources, targets, mappings, transformations and sessions to optimize session performance .
• Performed the Unit Testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables.
• Troubleshooting production issues with quick turnaround with best possible solution and documenting it for future similar occurrences.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• Developed technical system documentation.
• Monitor and communicate the availability of Informatica Environment. Follow-up on problem tickets

Environment: Informatica Power Center 8.6, PL/SQL, Oracle 10g/9i, Erwin 4.5/4.0, DB2, HP-UNIX 10.20, Toad, OBIEE, Microsoft Tools (excel, visioetc).

Confidential

Jr ETL Developer

Responsibilities:

• Designed the ETL Mapping Documents for development team members for their implementations.
• Worked on Informatica Power Center components- Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
• Promoted Informatica mappings from development to test to production environment.
• Used Informatica to extract, transform and load data from different input sources like flat files and XML files into Oracle 10g database.
• Created Informatica Power Center Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
• Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Migration between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and System testing at ETL level in my mappings.
• Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• Follow-up on tickets and fixing the issues.

Environment: Informatica 8.1.2, Oracle 10g, SQL, PLSQL, Microsoft Excel, MS-Word, COBOL.