SUMMARY:

• 4+ years of experience in Software Development Life Cycle in Data warehousing and Business intelligence in the Health Care Domain with strong background in Database Development and Data Warehousing.
• Proficient in the development of ETL (Extract, Transform and Load) processes with a good understanding of source to target data mapping.
• Complete understanding of Ralph - Kimball and Inmon approaches to Data Warehousing.
• Experienced with Informatica PowerCenter 9.0.1/8.x/7.x (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor).
• Well versed with Relational and Dimensional Modelling techniques like Star, Snowflake Schema, OLAP, Fact and Dimensional Tables.
• SCD Management including Type1,2,3, Hybrid Type 3,De-normalization,Cleansing,Conversion, Aggregation, Performance Optimization etc.
• Worked on data integration of multiple data sources and targets like Oracle, SQL Server, and MS Access, Flat files and XML.
• Developed Oracle PL/SQL programs (packages, procedures, functions, views) that adhere to the requirements document.
• Strong Exposure in writing Simple and Complex SQLs, creation of Oracle Objects - Tables, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Extensively worked in application development using Toad, Oracle SQL Developer, SQL, PL/SQL and UNIX Shell Scripting.
• Motivated team player with ability to work under minimal supervision possessing strong analytical, problem solving and communication skills.

TECHNICAL SKILLS:

Databases: Oracle 8.x/9.x/10g/11g, SQL Server 2005/2008/2012

Database Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL Navigator Export/Import

ETL Tools: Informatica PowerCenter 9.5/9.1/8.6.0 ss, Informatica Analyst, Web services

Data Modelling: ERWIN 4.0, Star and Snowflake Schema Modelling, Dimensional Data modelling, Fact and Dimensional Tables.

Programming: SQL, PL/SQL, C, C++, UNIX Script

Package: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word, MS Project), Visual Studio 6.0.

Environment: Windows 2000/XP/7, UNIX, Windows SERVER 2003

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, Arizona

System Analyst

Responsibilities:

• Understanding the migration of data from Source ERP system to NetSuite through a middle layer application called BOOMI.
• Identifying and fixing the errors that occur during the migration of data from Confidential - NetSuite on a daily basis.
• Giving Workaround/resolutions for the errors in the existing process due to which the data is not migrated.
• Acquired In depth knowledge of the entire end-to-end process of data migration to look for possible loopholes in the systems.
• Analysing BOOMI code (XML) and processes in place to help the systems remain stable in terms of data consistency.
• Creating Invoices, Expenses for test purposes to simulate the actual problem during the integration.
• Interacting with Business Managers, various stakeholders and informing them about the nature of each problem and its resolution.
• Pivotal in helping the team resolve 1000+ errors for Invoice & Expense related rejections within a span of 3 months.

Confidential

ETL Developer

Responsibilities:

• Based on the client requirements identifying the appropriate data sources for loading Data warehouse. Created detailed design documents based on mapping sheet.
• Extracting data from relational databases and Flat files and Loading data into the staging tables and then performed transformations before loading into the Core.
• Played a pivotal role in creating the Mapplets and Reusable Transformations as indicated by the business needs.
• Formulating the ETL mappings to implement the business logic. Used transformations like lookup, update strategy, expression, filter, router, aggregate, source Qualifier.
• Populated slowly changing dimensions tables using type 2-dimension changing and maintaining the full history of the data.
• Implemented upgrade plan including testing of all production mappings, sessions, workflows.
• Modified mappings, sessions, workflows as needed to get them to work as designed in upgraded environment.
• Directed Unit Testing, System Testing furthermore required in UAT testing.
• Resolved memory related issues like DTM buffer size, cache size to optimize session runs.
• Involved in designing worklets and reusable tasks according to the business needs.
• Helped the team by taking up responsibilities of a production support during critical weekly and monthly job runs, coordinated with offshore team.
• Implemented partitioning and bulk loads for loading large volume of data.

Confidential

Team member

Responsibilities:

• Involved in developing of the ETL ( Confidential ) strategy to populate the Data Warehouse from various source systems like Flat File and Oracle using Informatica PowerCenter.
• Involved in enhancements and maintenance activities of the data warehouse including rewriting of stored procedures for code enhancements, converting stored procedures into ETL for better performance.
• Designed/Enhanced various mappings for extracting data from various sources involving flat files, relational tables.
• Supporting the application and resolving the issues with in timelines and providing solutions to client for important enhancements.
• Created complicated Mappings, Transformations and Monitored Sessions using Informatica PowerCenter.
• Created workflows and sessions and scheduled the workflow on monthly basis.
• Scheduled sessions to update the target data using Informatica workflow manager.
• Involved in creating Sessions & Workflows and execution of Unit Test Conditions.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session to check the progress of data load.
• Analysed existing SQL queries, tables and indexes for performance tuning and advised based on the loading time.