SUMMARY

• 10+ years of experience in design and development of IT applications.
• 6 years of experience in developing of Data Warehouse/ ETL applications.
• Expertise in Data Modeling, Star Schema/Snowflake Schema, OLAP tools, Fact and Dimensions tables, Physical and logical data modeling and SCDs.
• Demonstrate in - depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy, Incremental Loads, Data reconciliation, ETL Error Handling mechanism, ETL standards and best practices.
• Experienced in Creating Informatica Transformations, Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Excellent skills in ETL tools Informatica Powercenter and SAS BI .
• Experienced in stored procedures, triggers and packages for Oracle using PL/SQL.
• Expertise in creating BI Reports for Financial and Healthcare sectors.
• Strong knowledge of software development lifecycle (SDLC) process and methodologies.
• Strong experience in creating and developing Test Strategy, Test Plans, Test cases and scripts.
• Excellent Analytical skills and communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Powercenter, SAS DI

BI Reporting: Cognos, SAS OLAP, Web Report Studio, SQL, PL/SQL, SQR, Crystal Reports, MS Excel Pivot table, MS Access, Tableau

Database: Oracle, SQL Server SSIS, DB2, Teradata, MySQL

Platforms: Windows, UNIX

Other: Autosys, Toad, Unix Shell scripts, QTP, HP ALM,XML

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis

Informatica ETL Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Developed and maintained ETL mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files using DI Transformation and loaded into Oracle.
• Developed SQL and Stored Procedures as required for the ETL processes and Data Integration activities.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Developed Informatica Workflows and sessions using Workflow Manager.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data
• Responsible for registering source and target libraries, used change management system, created project repositories in development, involved in moving metadata from development environment to QA environment.

Environment: Informatica PowerCenter, SQL Server, Oracle, Teradata, UNIX

Confidential, CT

Informatica Developer

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.

Environment: Informatica 9.1, Oracle 10g, PL/SQL, Toad, SQL Server, Oracle, UNIX, Cognos.

Confidential, NYC

Informatica Developer

Responsibilities:

• Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and SQL Server to the Data mart on Oracle database.
• Used reverse engineering in Erwin 4.x to understand the existing data model of the data warehouse.
• Worked with creating Dimensions and Fact tables for the data mart.
• Have implemented SCD (Slowly Changing Dimensions) Type I and II for data load.
• Did performance tuning of Informatica components for daily and monthly incremental loading tables.
• Developed Mapplets, reusable transformations, source and target definitions and mappings using Informatica 7.1.
• Created Informatica mappings, sessions, workflows, etc., for loading fact and dimension tables for data mart presentation layer. Created mapping using parameters and variables.
• Used Workflow Manager for creating, testing and running sequential and concurrent batches.
• Analyzed workflow, session, event and error logs for trouble shooting Informatica ETL process.
• Worked with Informatica Debugger to debug the mappings in Informatica Designer.
• Involved in creating test plans, test cases to unit test Informatica mappings, sessions and workflows.
• Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
• Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.

Environment: Informatica Power Center 8.1, Workflow Manager, Oracle, Teradata, SQL, Toad.

Confidential, San Antonio TX

ETL/BI Developer

Responsibilities:

• Validated datasets as required by the client to find the missing data and imported to SAS Environment.
• Extracted data from flat files, MS Excel and Oracle Clinical database and created SAS data sets using SAS DI.
• Developed reports to generate reports, tables and listings for clinical review.
• Generated Ad-Hoc reports for further analysis using SAS tools.

Environment:, SAS/Enterprise Guide, Informatica, Oracle, SQL

Confidential, NYC, NY

Reports Developer

Responsibilities:

• Designed and delivered on-going and back-end reporting for analysis.
• Responsible for running of programs on the weekly, monthly and quarterly reports.
• Developed Test Plans and Test Case design using Test Director.
• Did SQL scripting for querying and generated reports for analysis and improvement
• Designed, developed and tuned an Oracle database for the Budgeting and Planning department, Billing and Revenue department and Stores Inventory
• Data Modeling, database design and development, Performance & tuning

Environment: Oracle, SQL, PL/SQL, Crystal Reports.