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:

Confidencial, Minneapolis

Role: 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

Role: 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.

Confidencial, NYC

Role: 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

Role: 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

Role: 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.
• Documented and maintained Oracle databases for material management, staff management, payroll, administration, cost data, estimates, billing and accounting and revenue records at division level.
• 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.