PROFESSIONAL SUMMARY:

• Over 7+ years of experience in Data warehousing and ETL using Informatica Power Center 9.x/8.x/7.x.
• Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
• Had experience in data modeling using Erwin, Star Schema modeling and snow flake modeling, FACT and dimensional tables, physical and logical modeling.
• Have good understating on Data warehousing concepts (Kimball/Inman).
• Experience in dealingwith various data sources like Oracle 11g/10g/9i/8i, SQL server 2008R2/2008/2005, DB2, MS - Access, MS-Excel, flat files and Teradata.
• Worked extensively on different types of transformations like Filter, Expression, Source Qualifier, Router, Union, Aggregator, Sequence Generator, Sorter, Rank, look up, Normalizer, Update strategy and stored procedure.
• Good experience in using Oracle PL/SQL to create stored procedures, functions, packages and triggers.
• Extensively worked on Session partitioning techniques using different Informatica partitioning techniques to optimize the load time.
• Experience in debugging and performance tuning of Targets, Sources, Mappings and sessions.
• Worked on Logical and Physical design of the Data Warehouse, Identified Source/Targets and analyzed source data for dimension modeling.
• Complex Report Building Experience by using native SQL, Filters, Prompts, Conditional Formatting, Dashboard Reporting using Master/Detail queries, Ranking, Drill-through, Cross tabs and performance tuning the Cognos reports.
• Experience in developing Shell scripts on UNIX.
• Experience in migrating the workflows, sessions and mappings to a different environment using Repository manager.
• Created Documentation of the ETL processes and involved in Production Support.
• Based on the user requirements I have developed Reports using Business Objects andOBIEE reporting tools.
• Have performed various testing activities like unit testing, Integration-system Testing and user acceptance testing and ensured that the code is ideal.
• Motivated team player, outstanding organizational skills, excellent communication and Inter-personal skills.

TECHNICAL SKILLS:

ETL Tools: InformaticaPowerCenter 9.x/8.x/7.x, InformaticaPowerExchange 8.6.1

Reporting Tools: Business Objects 6.X, OBIEE, Crystal Reports 8.0/8.5, Jasper Reports, Cognos

Testing Tools: MS Visio, Oracle SQL Developer, Quality Center, Silent Upgrade

Databases: SQL Server 2008R2/2008/2005, DB2, Teradata TD13/TD12, Oracle 11g/10g/9i/8i, MS-Access2000/7.0

Languages: SQL, PL/SQL, C, C++, XML, UNIX Shell Scripting

Data Modeling: Erwin data modeler

Operating System: Windows 7/Vista/XP/2000/NT/98/95, MVS

PROFESSIONAL EXPERIENCE:

Confidential, Yonkers, NY

Consultant Database Engineer

Responsibilities:

• Experience in working on ACO (Accountable care organization) project which includes People Chart, Community report, Trupoint report and Submission process (CMS website). And have good grip on ACO - schema.
• Loaded the data from staging area into collection tables.
• Developed Informatica Mappings, Workflows and Reusable Transformations for other mappings and have done code review with other team members.
• Worked extensively on different transformations which includes Source Qualifier, Expression, Aggregator, Router, filter, Update strategy, look up, Normalizer and stored procedure.
• Used mappings parameters and variables for code reusability and documented parameterization steps. Parameterized as much as possible to ensure that we do not modify mappings, workflows and other objects that are in Production.
• Having good experience with EPIC Clarity.
• Experience with Measure Inclusion Code tables stored the codes that are used for gathering data as per ACO specifications. Each table contains the code to be searched for, which measure type ID they pertain to, and usually a type code (such as ICD9 vs. ICD10, CPT4). The information in these tables changed as requirements are changed each year.
• Have designed the tables which comes under data migration scope and having good experience in migrating from SQL Server to Oracle database.
• Have done SCD (Slowly Changing Dimensions) type 2 and type 3.

Environment: Informatica Power Center 9.6.1, Oracle 10g, SQL Server, DB2, SSIS, Windows XP, CMS Submission Process.

Confidential, Richardson, Texas

Sr. ETL Developer/Support Analyst

Responsibilities:

• As a Senior Developer involved in complete Software Development Life Cycle including Analysis, Design, Development and Testing of complex user requirements, procedures and problems to automate process and to improve existing system.
• Developed new content for standard as well as ad-hoc reporting tools and provided technical support to the various business intelligence initiatives within the Business Intelligence, Data Architecture and Reporting team.
• Worked with installing, designing and managing MS SQL Server 2008 R2.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Responsible for creating datasets using T-SQL and stored procedures
• Coordinated the Change Management process which involved driving the QA and production deployments.
• Performed profiling using Informatica Analyst and Informatica Developer.
• Created Customer master generic data profiles and scorecards to review data quality.
• Used Informatica Data Quality tool (Informatica Developer) to scrub, standardize and match customer address against the USPS database.
• Involved in Information administration including creating new users and groups, backing up the repository and domain as well as handling various upgrades.
• Working on new projects to fulfill the business needs and documented the scope of new development projects.
• Involved in writing and modifying UNIX shell scripts.
• Worked with data quality team to fix the production data issues and provide solutions to the business users.
• Involved in providing the solutions for production support job failures at Tier-2 level.
• Coordinated with offshore team to support the existing ODS system jobs.
• Coordinated with business users and across the development teams in implementing new business requests.
• Used Toad for data quality verification and unit testing the data.
• Provided 24X7 on call support which included monitoring morning and nightly jobs and emergency production fixes.

Environment: Informatica Power Center 8.6, Oracle 10g, DB2 UDB, UNIX (Sun-Solaris), UNIX (AIX 6.2), Harvest, SQL Loader, Autosys, Visio, Synsort, TOAD for Oracle, SQL Developer, Windows XP.

Confidential, New York City, NY

Informatica Developer

Responsibilities:

• Interacting with business users for requirement gathering and preparing Technical design documents.
• Participated in Technical feasibility discussions, Peer reviews and in unit testing.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Aggregator, Router, filter, Update strategy, look up, Normalizer and stored procedure.
• I have been involving in Designing and developing Informatica Mappings and Sessions based on user requirements and business rules to load data from sources involving XML files, flat files and RDBMS tables to target tables.
• Developed many Complex Informatica Mappings, Mapplets and Reusable Transformations for other mappings.
• Supporting daily loads and work with business users to handle rejected data.
• Developed complex SQL Scripts to meet the business requirements.
• Used mappings parameters and variables for code reusability.
• Wrote PL/SQL stored procedures using Toad and performed high level regression testing for Confidential, Madewell and Factory.
• Providing status on a weekly basis to the team and responsible for production support as well (24 * 7 on call support).

Environment: Informatica Power Center 9.1, Oracle 11g, DB2, Flat files, Teradata, PL/SQL, Power Exchange, Teradata, Flat files, Toad, Business Objects.

Confidential, Rochester, MN

Informatica Developer

Responsibilities:

• Designed and developed Informatica mappings and sessions based on user requirements and business rules to load data from source flat files and RDBMS tables into Teradata Data Warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Created different mappings to load the data into different stages like Landing, staging and Target tables.
• Used various transformations like Expression, Filter, Router, Sorter, Joiner, Sequence Generator, Aggregator, connected and unconnected lookup, updated strategy, connected and unconnected stored procedure.
• Created shortcuts, reusable transformations and mapplets and used them complex mappings.
• Responsible for designing, developing and implementing the ETL process which include the incremental load strategy and Full load.
• Created PL/SQL stored procedures, scripts, materialized views and views based on reporting requirements.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Applied slowly changing dimensions like type 1 and type 2 effectively to handle the delta loads.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica.
• Migrated the workflows and scripts from development environment to test and production environment.
• Created reports using OBIEE reporting tool.
• Actively involved in production support and transferred the knowledge to the other team members.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g/10g, DB2, Flat files, Teradata, PL/SQL, OBIEE, UNIX AIX.

Confidential, Marlborough, MA

Informatica Developer

Responsibilities:

• Participated in Requirement Gathering, Business Analysis and User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Developed complex mappings in Informatica to load the data from various sources using different transformations.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Extracted the data from Oracle, DB2, Flat files and load the data in to Teradata database.
• Identified the performance bottlenecks and tuned Informatica mappings for better performance.
• Created PL/SQL Stored procedure construct to automate the checking of status of target database before loading data into it.
• Created PL/SQL stored procedure to drop and re-create indexes during pre and post loading of database tables respectively.
• Developed and modified UNIX shell scripts to meet the requirements after the system modifications and was also involved in monitoring and maintenance of the batch jobs.
• Established automatic email notifications to the concerned persons.
• Scheduled workflows for daily, weekly and monthly loads.
• Responsible for migrating the code to from DEV repository to QA and PROD repository.
• Create test plans and written test cases while doing unit testing, integration testing.
• Developed reports using Business Objects and OBIEE reporting tools.
• Participated in status review meeting.

Environment: Informatica Power Center 8.5, DB2, Oracle 10g, Business Objects, OBIEESQL, PL/SQL, Flat files, UNIX Shell Script.

Confidential, Red Bank, NJ

ETL Developer

Responsibilities:

• Analyzed the systems, met with end users and business units to define the requirements.
• Created mappings using various transformations like update strategy, lookup, Router, Filter, Aggregator for Extracting Data from Flat Files according to the requirements and loading it into the Data mart.
• Generated and Executed SQL Queries to be fired on the Repository Tables to analyze the results of the Sessions.
• Involved in preparing detail design document, developing ETL documents.
• Extracted data from various source systems like, Oracle and Flat files.
• Data migration from one environment to another using Informatica.
• Worked on server to run the sessions and batches concurrently and sequentially.
• Used SQL tools like TOAD to run T-SQL queries and validate the data loaded into the target.
• Handling of rejected records, errors and reporting it to the client on daily basis.
• Worked extensively on enhancements on multiple reusable components in business logic in Informatica.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Worked along with the QA team and provided production support by monitoring the processes running daily.

Environment: Informaticapowercenter 8.5, SQL, Toad for Oracle 9.6.1, DB2, Cognos, MS tools, UNIX, Windows 2000.

Confidential

ETL Developer

Responsibilities:

• Interacting with business users for gathering, understanding & analyzing the business requirements.
• Involved in review and finalizing the technical specs of source-target mapping documents.
• Designed and developed new mappings in Mapping designer and sessions and workflows in Workflow manager and modified existing ones to extract data from SQL Server, Excel, and Flat files and load to Oracle database as per business requirements.
• Writing validation packages using PL/SQL package.
• Developed Installation scripts for all the deliverables.
• Worked Extensively on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Implemented SCD type 2 to keep track of historical data.
• Familiar with parameter file and its usage.
• Used SQL*Loader for bulk loading the data into the target tables.
• Generated various UNIX Shell scripts for automating daily load processes.

Environment: Informaticapower center 7.1.1, Oracle 9i, PL/SQL, SQL Server, Unix.