PROFESSIONAL SUMMARY:

• Over 7 years of experience in Database Analysis, Design, Application Development, Implementation and Production Support activities in a Client/Server Environment using Oracle 11g/10g/9i, Unix and Windows. Expertise in development of Data warehousing solutions using Informatica Power Center 9.x/8.x /7.x.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger).
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Understanding & working knowledge of Informatica CDC (Change Data Capture) Implementation.
• Knowledge in Data Analyzer tools like Informatica Data Quality (IDQ), Informatica Data Explorer (IDE).
• Worked on Slowly Changing Dimensions (SCD's) and implemented Type1, Type 2 to keep track of historical data.
• Specialist in creating PL/SQL Stored procedures, Functions, Packages, Constraints, Cursors, Indexes, Views and Triggers with Query optimizations as part of ETL Development process.
• Extensive domain knowledge in different lines of business - Telecom, Insurance, Banking.
• Outstanding experience in writing complex SQL queries using SQL, PL/SQL and UNIX Shell Scripting.
• Strong experience in End-To-End implementation of Data warehouse and understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT & dimensions tables, physical & logical data modeling and OLAP and OLTP concepts.
• Involved in the Designing and implementation of logical and physical data models Using ER studio data architect.
• Strong experience across all stages of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Data Mapping, Build, Unit Testing, Systems Integration, Documentation, User Acceptance Testing, Implementation, Maintenance and Production Support.
• Hands on experience in developing, monitoring and maintaining various report types.
• Worked closely with the technical teams and DBAs for issues related to privileges and space managements..
• Documented business rules, functional and technical designs, test cases, and user guides.
• Excellent technical and communication skills and ability to work effectively and efficiently in teams.
• Team player and desire to learn and share new concepts and techniques in the growing IT world.
• Exceptional analytical and problem solving skills. Ability to communicate effectively at all levels of the development process.
• Good communication, Customer support and troubleshooting skills to make effective contribution to business process

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6/8.1/7. x (Designer Workflow Manager, Workflow Monitor, Repository Manager), Informatica Data Mart, Informatica Data Quality (IDQ).

Databases: Oracle 11g/10g/9i/,MS SQL Server 2008/2005,DB2, Teradata, MS Access 7.0/’97/2000

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

Operating Systems: Sun Solaris 2.6/2.7/2.8,HP-UX,IBM AIX 4.2/4.3,MS DOS 6.22,Windows 95/98/2000/XP, Windows NT 4.0

Data Modeling: Erwin 4.x/3.x,ER Studio Data Architect 9.0,Star Schema, Snow Flake schema, Dimension Data Modeling, Fact Tables, Dimension Tables.

Tools: Toad, Sql Plus, SQL Developer, DB Visualizer.

EXPERIENCE SUMMARY

Confidential (Boston, MA)

Role: Informatica Developer

Responsibilities:

• Involved in complete software development life cycle.
• Gathered the business requirements by interacting with users.
• Responsible for making decisions on coding standards and documentation.
• Extensively worked on Informatica client tools like Designer, Workflow Manager and workflow monitor.
• Creating mappings using Aggregator, expression, filter, joiner, lookup, sequence generator and Router, Web service Provider, Web service consumer and XML Generator Transformations and preparing Documentation for the Mappings.
• Working experience in importing multiple sources like Database Tables, Flat Files, Web services, XML Files.
• Performed unit testing and Involved in Performance tuning the Session and Workflows for better Performance.
• Involved in the Deployment Process.

Environment: Informatica Power Center 9.1,Oracle 11g,Windows 7,UNIX, TOAD,DB Visualizer, SQL Developer, PL/SQL

Confidential (St.Louis, MO)

Role: Informatica Developer

Responsibilities:

• Used Informatica power center for (ETL) Extraction, Transformation and Loading data from heterogeneous source systems.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Involved in importing Source/Target Tables from the respective databases and created Reusable Transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, Aggregator), Mapplets and Mappings using Designer module of Informatica. Analyzed and created Facts, Dimension tables.
• Implemented slowly changing Dimensions Type-1 and Type-2.
• Created Stored Procedures for data transformation purpose.
• Involved in Unit testing, System Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in the production support.
• Performed unit testing and Involved in tuning the Session and Workflows for better Performance.
• Participated in status review team meetings.

Environment: Informatica 9.1, SQL Server Management Studio 2012, Windows XP, ER Studio Data Architect 9.0

Confidential (Jessup, PA)

Role: ETL Developer/ Data Modeler

Responsibilities:

• Involved in the preparation of layout designing.
• Involved in the Designing and implementation of logical and physical data models Using ER studio data architect .
• Created domains to reuse the attributes in the data dictionary.
• Created and worked on sub models in ER studio data architect.
• Designed developed and deployed Informatica mappings, workflows from Development to Testing and Production environments..
• Created New Staging tables in Staging DB to store data from client files (CMS, NY,  Medicaid Files etc)
• Wrote Postgres SQL Queries to work with the data, being loaded from external client files Into the Data Warehouse.
• Worked extensively on SQL Server 2008 and Postgres SQL.
• Worked extensively on Medicaid and Medicare and CMS files, and their corresponding File layouts.
• Prepared design, technical and functional documents from the business requirements Gathered.
• Created Mappings to move data from Oracle, SQL Server to new Data Warehouse in Green Plum.
• Created different Transformations for loading the data into target like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations
• Created and Configured Workflows, Work lets and Sessions to transport the data to target Tables using Informatica Workflow Manager
• Parsing high-level design specs to simple ETL coding and mapping standards.
• Involved in data validation to ensure that the highest levels of data quality and data Integrity is maintained.
• Complete understanding of Pushdown Optimization Utility in Informatica.
• Performed unit testing and Involved in tuning the Session and Workflows for better Performance.
• Participated in status review team meetings.

Environment: Informatica 9.1, SQL Server Management Studio 2012, PgAdmin3 (Postgres), PL/SQL, Windows XP, ER Studio Data Architect 9.0

Confidential (NJ, USA)

Role: Informatica Developer/Oracle Developer

Responsibilities:

• Used Informatica power center for (ETL) Extraction, Transformation and Loading data from heterogeneous source systems.
• Involved in importing Source/Target Tables from the respective databases and created Reusable Transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, Aggregator), Mapplets and Mappings using Designer module of Informatica. Analyzed and created Facts, Dimension tables.
• Implemented slowly changing Dimensions Type-1 and Type-2.
• Worked on Informatica Data Explorer (IDE), Informatica Data Analyzer and Informatica Data Quality (IDQ) for analysis of data and quality.
• I have involved in the Data profiling and data cleansing process.
• Created Stored Procedures for data transformation purpose.

  Generated PL/SQL and Shell scripts for scheduling periodic load processes.

• Extensively worked on the Database Triggers, Functions and Database Constraints.
• Wrote complex SQL queries and PL/SQL procedures to extract data from various source Tables of data warehouse.
• Worked on External Loader to populate the target Oracle.
• Participated in Admin activities like Upgrading power center and data quality.
• Prepared user requirement documentation for mapping and additional functionality.
• Using Informatica Designer to create complex Mappings and Mapplets.
• Creating mappings using Aggregator, expression, filter, joiner, lookup, rank, sequence generator and Router Transformations and preparing Documentation for the Mappings.
• Writing several ETL functions, procedures in PL/SQL for aggregation and summation purpose. Creating weekly and monthly batches and scheduling them according to the precedence diagrams using Server Manager.
• Involved in the Designing and implementation of logical and physical data models Using Erwin .
• Involved in the mainframe data and COBOL data loading process.
• Design and Development of pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Involved in Unit testing, System Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power Center 9.1/9.5,Informatica Data quality(IDQ)9.1/9.5,Oracle 11g, Netezza,Windows 2000, Sun Solaris 2.6/2.7/2.8,UNIX, ERWIN, TOAD, PL/SQL Developer.

Confidential, SC

Role: Oracle Developer/Informatica Developer

Responsibilities:

• Involved in complete software development life cycle.
• Gathered the business requirements by interacting with users.
• Responsible for making decisions on coding standards and documentation.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure Fast Load and Multi Load sessions.
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
• Extensively developed PL/SQL packages with procedures, functions.
• Developed various test cases including stress tests to test the efficiency and speed of the application.
• Developed procedures to run the SQL*Loader to load data from flat files into the target database tables.
• Optimized performance of the application with the help of Explain Plan for SQL queries.
• Wrote SQL, PL/SQL, stored procedures, views and cursors for implementing business rules and data transformations.
• Extensively used various data transformation functions of PL/ SQL.
• Widely used the parameters facility in UNIX and PL/ SQL to facilitate automation of the processes.
• Participated in the DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Involved in unit testing and user support.
• Involved in integration of the application.
• Involved in 24/7 on call production support.

Environment: Informatica Power Center 9.x/8.x/7.x,Tera Data, Oracle 10g, PL/SQL, TOAD, Discoverer, Microsoft Visio 2003

Confidential

Role: Oracle Developer

Responsibilities:

• Involved in requirements analysis, design and development of the system
• The project involved detailed design using E-R Diagrams and Data Flow Diagrams
• Extensively used PL/SQL features such as procedures stored procedures, functions, packages & database triggers for maintaining complex integrity constraints and implementing the complex business rules
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements
• Loaded data from flat files into database tables using SQL* loader
• Wrote complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse
• Tuned SQL queries an performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency
• Developed stored procedures, functions and packages for updating, inserting and deleting data from the tables
• Developed forms, menus, Object libraries and PL/SQL libraries using Oracle Forms 6i
• Used Oracle Reports 6i to develop daily, weekly and monthly reports for customer details, products supplied, inventory information and details of customer complaints
• Involved in Unit level testing, Module level testing and System level testing
• Documented the whole process flow, PL/SQL Packages, log files, locations and description, log tables and possible error messages, process codes and description
• Detected and corrected bugs during system integration and user acceptance testing

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, Forms 6i, Reports 6i.