SUMMARY

• Over 8 years of experience in Programming(oracle), Database design, development and over 5+ Years in Data Warehousing using Informatica Power Center 9.1/9.0.1/8.6 / 8.5 / 8.1.1 / 7.1.1 .
• Extensive experience in all the phases of the Data warehouse life cycle involving design, development, and analysis and testing in the various areas of Data warehousing.
• Extensively worked on developing, monitoring and Jobs Scheduling using UNIX Shell Scripting/ Autosys.
• Experienced in BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Experienced in developing UNIX Shell and Perl Scripts for automation of ETL process.
• Good understanding of relational database management systems like Oracle, Teradata, DB2, and SQL Server and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems and mainframe Cobol files.
• Hands on Experience in writing, testing, and implementation of the triggers, cursors, procedures, and functions at database level using PL/SQL.
• Experience with various Online Analytical Processing tools (OLAP) like designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems, fact and dimension tables modeling of data at all the three levels: view, logical and physical.
• Hands on experience in Tuning Mappings, Identifying and resolving Performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Designed and developed efficient Error handling methods and implemented throughout the mappings in various projects.
• Strong experience with PL/SQL including stored procedures, packages, SQL tuning and writing shell scripts.
• Responsible for interacting with business partners to identify information needs and business requirements for Reports.

TECHNICAL SKILLS

Data Warehousing: OLAP, OLTP, Star Schema, Snowflake Schema, RDBMS.

Programming Languages: C++, SQL Plus, PL/SQL, UNIX Shell Scripting, Mainframes Cobol

Scripting Languages: HTML, XML, UNIX Shell Scripting.

Databases: Oracle 11g/10g/9i/8i, Teradata v12, MS SQL 2000, IBM DB2, MS Access.

Operating Systems: Windows 95/98/NT/2000/XP, UNIX, Linux, MS - Dos.

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x / 5.x Informatica Admin Console 9.x

Reporting Tools: MS Access Reports.

PROFESSIONAL EXPERIENCE

Confidential, CA

Lead Data Warehouse Developer

Responsibilities:

• Involved in couple of projects and worked with Business Analysts and with the project team to understand the business requirements.
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and loading strategy designing.
• Developed Informatica Mappings using Designer to extract, transform data according to the requirements and loaded into database from relational sources and non-relational sources.
• Extensively used different types of transformations like Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, Look up, Update Strategy, Source Qualifier, Joiner, Normalizer.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Resolved bugs in the existing mappings by analyzing the code using debugger.
• Extensively usedTeradata utilities(BTEQ, Fast load, Multiload, TPUMP) to import/export and load the data from oracle, flat files .
• Developed Unix shell scripts “C shells and perl “ and expert in using unix utilities(sed, awk, vi, grep)
• Extensively Used Autosys tool for batch scheduling/moniter the Jobs.
• Working knowledge on mainframes, creating the JCLs,parms,datasets and loading the data by running jobs from override library.
• Develop complex Teradata SQL queries to generate ad-hoc reports for the reporting usersofBankofAmerica(BofA) to implement complex business rules.
• Involved in different environments(SIT/UAT/PRODUCTION) and also involved in unit testing and developing test cases.
• Created and executed Unit Test Plans,test scripts for the project scenarios and raising defects in Quality Center.
• Actively involved in Solution Architect (SA) activities such as attending meetings with business, Gathering / Understanding Business Requirements, foresee any challenges, and suggest alternatives for precise solutions, Documenting LLD and HLD.
• Involved in writing scripts for loading data to target data Warehouse using Bteq, Fast Load, MultiLoad.

Environment: Informatica Power Center 9.0.1/8.6.1, Teradata V12/ V13, Oracle 10g, Toad, Mainframes, SQL, Autosys, UNIX Shell Scripting, Quality Center.

Confidential, Seattle

Senior ETL developer

Responsibilities:

• Managing ETL operations: Job-stream definition and management, parameters, scheduling, monitoring, communication and alerting.
• Developing governance for ETL audit, balance and control: Job-execution statistics, balancing and controls, rejects and error-handling, codes management.
• Designed scheme, sub-scheme for multiple IP platforms, into a single platform delivering data integration capabilities.
• Involved in data analysis, data profiling.
• Managing and designing mappings with many dimension and fact tables as sources.
• Worked on Informatica Power Center tool to transform data from multiple sources including flat files, DB2.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Performance tuning at session level by using commands which use DB2 Loader.
• Participate in project planning sessions with project managers, data analysts and team members to analyze business requirements and outline the proposed IT solution.
• Created complex mappings which involved Slowly Changing Dimensions.
• Involved in writing UNIX shell scripts for developing complex and high performance ETL solutions.
• Implementation of Business rules and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Extensively involved in Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.

Environment: Informatica Power Center 8.6, 8.1, Informatica Power Connect / Power Exchange, Oracle 10g, PL/SQL,UNIX Shell Script, Toad, SQL editor.

Confidential, New York

Data warehouse developer

Responsibilities:

• Worked with source system experts to determine source of data.
• Source Data Analysis and table design using Erwin.
• Involved in designing the data model using ERWIN and generated the DDL for DBA to implement the tables in the development and production environment. Writing and optimizing SQL queries and Complex Data Modeling.
• Using Informatica Repository Manager maintained the repository, created users, user groups and security access control.
• Created and stored metadata in the repository using Informatica Repository Manager.
• Cleanse the source data, Extract and Transform data with business rules, and built re-usable mappings, using Informatica PowerCenter Designer.
• Created complex joiners, transformations of all types as needed to smoothly pass data through ETL maps.
• Using Informatica PowerCenter created mappings and mapplets defining the transformation logic according to the business rules for the loads.
• Test all the applications and transport the data to target Warehouse Oracle tables on NT server.
• Schedule and run Extraction and Load process and monitor sessions by using Informatica Server Manager.
• Check and Tune the performance of application for optimum system performance.
• Involved in Unit testing, system testing and partly in user acceptance testing.
• Involved in production support.
• Working knowledge on scheduling software.
• Creating BI reports using Business Objects Web and Business Objects Desktop.

Environment: /Tools: Informatica Power Center 7.1/8.1, ERwin 3.5, Shell Scripts, SQL*Loader, Business Objects 6.5, UNIX, DB2, Oracle 9i, Windows NT

Confidential, Madison, Wisconsin

ETL-Informatica Developer

Responsibilities:

• Involved in Dimensional Modeling of the data warehouse to design the business process
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation
• Worked on Dimensional modeling to Design and Develop STAR Schemas and SNOWFLAKE Schemas, used ER-win 4.0, identifying Fact and Dimension Tables.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions
• Worked closely with business analysts to understand and document business needs for decision support data.
• Involved in developing & testing of ETL, Informatica mappings, workflows, sessions using Informatica.
• Extensively utilized Informatica Power Center to load data from oracle and Fixed-Width, Delimited Flat files into Data Warehouse.
• Imported various heterogeneous and homogenous sources using Informatica 7.x source analyzer.
• Involved in working with ODS (Operational Data Store) to extract data from the Data warehouse.
• Involved in writing procedures, functions in PL/SQL.
• Designed sessions using Workflow Manager and monitored using Workflow Monitor
• Created & launched scheduled tasks/sessions. Configured email notification. Setting up tasks to schedule the loads at required frequency using Power Center.
• Automated Worklets and Session schedule using Unix Shell scripts.
• Monitored Sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged Mappings for failed sessions
• Designed Star Schemas and Bridge Tables to control slowly changing dimensions
• Involved in Unit testing of Mappings and Workflows.
• For better performance created partitions, and used SQL Override option in source qualifier
• Involved in extensive Performance Tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Used session partitions, dynamic cache memory and index caches for improving Performance of Informatica Server.

Environment: /Tools: Informatica Power Center 7.1.2, Oracle 9i, DB2, Mocha Soft, Aqua Data 4.5, IBM iSeries Access, AIX Scripting

Confidential

Oracle Developer

Responsibilities:

• Involved in the design of the overall database using Entity Relationship diagrams.
• Wrote triggers, menus and stored procedures in PL/SQL.
• Involved in developing interactive forms and customization of screens using Forms4.5.
• Involved in data Loading and Extracting functions using SQL*Loader.
• Designed and developed all the tables, views for the system in Oracle.
• Designed and developing forms validation procedures for query and update of data.

Environment: /Tools: Oracle 8.0, SQL*Plus, SQL*Loader, PL/SQL.