Professional Summary:

• 11 years of experience in the field of IT and 9 years primarily in ETL, BI and DW using Informatica, Business Objects, Erwin, Oracle, Teradata, etc.
• Highly skilled in Planning, Designing, developing and deploying Data warehouses/Data Marts with experience of both relational & multidimensional schema following JAD and RAD methodologies.
• Database design using Data Modeling tool Erwin (Conceptual, Logical and Dimensional data models)
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Center.
• Extensive experience in database performance evaluation and tuning.
• Experience using Business Objects, Web Intelligence, Business Objects Designer, Business Objects Developer Suite (Broadcast Agent, Supervisor, Designer and Info View) and Business Objects Reporting.
• Good working knowledge in UNIX, Shell scripting.
• Excellent Analytical, Communication and Documentation skills along with efficient experience at leading development and co-ordinating cross team functionalities.
• Experience with SOX compliance and methodologies
• Brain bench certified in ANSI SQL.
• Completed two out of 3 parts of Informatica Certification program.
• Trained in SAP functional methodologies.

Industry Experience: Pharmaceutical, Stocks, Insurance, Consumer products, Telecom, Utilities, and Publishing.

Technical Skills:

Operating Systems: Windows NT/2K/XP, Digital-Unix, HP-Unix, Linux, and Sun Solaris
ETL Tools: Informatica-5.x/6.x/7.x/8.5/8.6, Datastage and Ab Initio.
CASE Tools: ER-Win 4.1, MS Visio, MS Project.
OLAP Tools: Business Objects 5.1/6.0, Web Intelligence, Cognos 6.0, Crystal Reports 8.5/9.0
Web: XML, Java, Dream Weaver 4.0 and HTML
Languages: PL/SQL, SQL, Shell programming, C, C++ and COBOL
Databases: Oracle 7.X/8.X & 9i, 10g/i, SQL Server, Teradata, DB2 UDB, MS-Access, JDE, MAXIMO, and Seibel.

Confidential,NC July ’09 – Till date
Sr. Integration Consultant

Description:

This project was initiated to integrate the existing stand alone system into the corporate data warehouse(CDW). Scope involved enhancement to visibility, avalability, and updating business logic.
Existing data was migrated by applying new business logic and updated granularity of data. Online display was supported through efficient SQL and PL/SQL. Technical specs were reviewed and redsigned.

This is a top priority project involving creation of Dashboards related to Sales, Budget, and Forecast by product, manager, region through week, month, qtr, and year. These dashboards along with determined reports are available to top business users including the CEO and CIO. My responsibilities included meetings with users, Data architect, Business analyst, and project lead to define business requirements and logical models. I created ETL design and mapping documents from the physical data model.

• Reviewed and updated tech specs based on interviews with user and architects.
• Developed ETL code to populate new type1, type 2, and type 3 dimension tables and fact tables.
• Developed migration process for existing data into data warehouse tables.
• Involved in discussions with users, DBA team, and QA team to identify changes to the scope and data model to integrate the source system with CDW.
• Worked with Amdocs onsite and off-shore development, DBA, and production support teams.
• Worked closely with front end development team to provide SQLs and PL/SQL so as to see the online search returns correct data in fastest possible time.
• Involved in cleansing the source data and tuning code for efficient performance to meet SLAs.
• Provided work flow run support for production and test cycles including rebuilds of the system.

Environment: Informatica 8.6.1, Oracle 10G/10i, Unix Scripts, Microstrategy8.0.1, Win NT/XP, UNIX, Toad, Quality Center.

Confidential,PA Feb, 09 – July, 09
Lead Analyst/Application Developer

Description:
Confidential,is one of largest pharmaceutical companies with global implementation and holding a major part of the market in over forty countries. The specific project – International commercial Business Intelligence (ICBI) has architecture of SEIBEL source system deployed on ORACLE, Informatica on LINUX box as the ETL tool, and feeds user interfaces through Business Objects and SAP ERP systems.
The current project involved in creating data marts to be integrated with EDW with over 40 entities including 7 fact tables.

Responsibilities:

• Was involved in reviewing model, design, and technical specifications. Updated specs as was necessary.
• Responsible for Siebel source system analysis and translating OLTP business requirements into technical specification documents.
• Extracted Positions, Contacts, Accounts and Address data from the Siebel base tables and loaded them into staging tables.
• Worked on staging SAP tables using Power Exchange and generating ABAP code for them.
• Extensively involved in data analysis, profiling, and validation. Also identified required data model changes based on the analysis.
• Worked with business analysts to resolve data issues
• Developed ETL code for type 1, type 2, and type 6 (Combination of types 1, 2, & 3) dimensions. Developed code for association tables to associate Products and Geography, Position and Region alignment, Sales force and prod, Formulary and Products, etc.
• Implemented robusterror-handling and error-logging within the mappings using maplets and error tables.
• Developed SQL scripts to refresh data on different databases. Worked on maintaining RI when refreshing data.
• Worked on scheduling of master workflow and individual sessions using UC4 Scheduling tool. Worked on Perl scripts to run UC4 Jobs
• Created test casesand documented Unit test case scenarios. Also involved in peer code reviews.

Environment: Informatica 8.6, Power Exchange, Oracle 10G/10i, Seibel eMedical 7.8, SAP R/3, UC4, Business Objects, Win XP, LINUX, Toad 8.6, MS Sharepoint.

Confidential,CO Dec ’07 – Jan’ 09
Lead ETL Developer
Description:
Completed two projects – Created CDC mappings to populate type 2 JDE and Maximo tables in the Data warehouse called the Information Data Bank (IDB) to enable point in time reporting.
Worked on data integration project (Load control) to load data into the fact table and dimensions sourcing from multiple data sources

Responsibilities:

• Was involved in the designing of the system and creation of tables and views.
• Developed various Subject area models and worked with team to develop the full model using Erwin 4.x.
• Extensively involved in data analysis, profiling, and validation.
• Designed and developed Conceptual, Logical, and Dimensional Data Models.
• Populating the type 2 tables included creation of complex change capture mappings using three pipelines, connected/unconnected lookup and stored proc transformations, dynamic lookups, aggregators, routers, etc in Power center.
• Created resync insert and delete mappings to capture the real time data if/when the DB is down.
• Provided detailed documentation for the process along with reload-strategy and exception management.
• Successfully completed the unit and system testing.
• Load control process is designed to load data into the fact table at 15 min. intervals.
• Involved in developing mapping, session, parameters, and workflow standards to be followed by the DW team.

Environment: Informatica 8.5, Oracle 10G/10i, SQL Server, Erwin, Cognos, Win XP, MS Sharepoint.

Confidential,NC Nov ’05 – Dec, 07
Sr. ETL Developer

Description:

RHD is currently the second largest telephone directory, white pages publisher in the USA.
The project involved modernizing the Data Warehouse from legacy to IGEN. This process has multiple steps – Conversion, rebuilding, newly built facts and Dims, reconciliation, etc.

Responsibilities:

• Gathered user requirements and developed functional specs and developed dimensional tables and fact tables.
• Followed both JAD and RAD methodologies.
• Interacted/ worked with DBA team to create tables, table spaces, indices, triggers, etc,.
• Extensively involved in ETL process using Informatica power center in order to meet requirements for extract, transformation, cleansing and loading of data form source to targets.
• Mainly involved in developing conversion mapping documents and developing ETL code for 6 fact tables, 17 dimension tables consisting of type 1 and type 2.
• Developed specs and mapping documents for recon processes and developed ETL code for the same.
• Created flat file, .CSV sources and targets for reconciliation and data profiling processes.

Used FTP and file compare and append procedures.

• Worked with testing team, data providers, reporting team and users to update the logic and fix defects (Test Director) and incidents, problems (CA Service Desk).
• Performed unit testing of code to ensure error and exception processing issues are resolved (diagnose and rectify errors/issues encountered). Also, involved in peer code validation.
• Involved in POC – comparing Informatica and Datastage.
• Involved in developing mapping, session, parameters, and workflow standards to be followed by the DW team.
• Involved in team building activities and lessons learnt sessions. Also trained Adhoc team on using Informatica tool.

Environment: Informatica 7.2/8.1.1, Oracle 10G/10i, Unix Scripts, Maestro, Microstrategy8.0.1, Teradata,Win NT/XP, Toad, Test Director, CA Service Desk.

Confidential,MI Aug. ’05 – Nov ‘05
Sr. Developer

Confidential, is a high priority project for Comerica Bank. It involved a vendor processing the data and pushing the same across to DB2 mainframes on a daily basis. The files were transformed according to the business rules provided by the project clients.

Responsibilities:

• Interviewed with File Management, subject matter experts, B. As, Project clients, vendors, and DBA teams to understand and gather requirements, applying JAD methodology.
• Assisted, advised and supervised data modelers to develop logical and dimensional models along with issues related to data types, Business Rules and RI.
• Developed various Subject area models and worked with team to develop the full model using Erwin 4.x.
• Reviewed with DMO (data management office) team and developed a document consisting of various alternatives for the process to meet the SLAs.
• Extensively involved in data analysis, profiling, and validation.
• Extensively involved in ETL process using Informatica Power center in order to meet requirements for extract, transformation, cleansing and loading of data form source to targets.
• Performed unit testing of code to ensure error and exception processing issues are resolved (diagnose and rectify errors/issues encountered).
• Developed documents and standards to be followed by the DMO team.

Environment: IBM DB2 Mainframes, Oracle 10G/9i, UDB 8.2, UNIX, Perl Scripting, ER win 4.1, Informatica, Impromptu, DB2 connect, MS-Access.

Confidential, Nov. ’04 – July ‘05
Developer

Description:
Bio-medical operational summary AKA Comshare Budget Data Project was initiated at the Biomedical Headquarters’ Business Planning group’s request for an application to enable reporting and analysis of budgeted operations data versus actual results and is in response to their need for a flexible reporting tool to enable reporting and analysis.

Responsibilities:

• Gathered requirements from business end users from finance, planning, customer & donor strategy groups and created SON and SRR documents.
• Designed and developed Conceptual, Logical, and Dimensional Data Models for the Data Warehouse using Erwin 4.1.4
• Designed and developed ETL scripts, dimensions and fact tables.
• Created mappings to load from sources using various Transformations like Normalizer, Joiner, Update Strategy, Lookup, Sorter, Aggregator, and Sequence Generator etc.
• Created Sessions for the mappings.
• Designed, created, scheduled workflows.
• Writing re-usable procedures and functions for the staging database.
• Created worklets to combine sessions for individual units.
• System and Unit Testing for the Procedures, Functions and Packages. Written Scripts, stored procedures and Database Triggers to load data.
• Developed the documentation and plan for transformation and loading the Warehouse.
• Wrote PL/SQL scripts for initial load, deleting test data and modifying bad data.
• Prepared Migration Strategy and test cases for UAT, based on design documentation, user acceptance test, end user training and system rollout and integration
• Involved in Database Monitoring and Performance tuning, investigating, Troubleshooting and resolving database problems
• Involved with a POC to opt for Netezza against Teradata, SQL server, Oracle, etc.

Environment: Informatica 7.1.1, Teradata, Netezza, Oracle9i/8i,SQL Server 2000, Business Objects6.1, PL/SQL, Erwin 4.1.4, UNIX, Shell Scripting, Perl Scripting, Win NT.

Confidential,NJ Apr’ 03 - Sep’ 04
Informatica Developer

• My major responsibilities included setting up new environment (which includes up gradation of Informatica 5.1 to 6.2).
• Extensively involved in ETL code using Informatica ETL tool in order to meet requirements for extract, transformation, cleansing and loading of data form source to target data structures.
• Performed unit testing of code to ensure error and exception processing issues are resolved (diagnose and correct errors/issues encountered).
• Helped building enterprise data warehouse data models.
• Designed and developed Conceptual, Logical, and Physical Data Models for the Data Warehouse using Erwin 4.0.
• Designed flow charts using MS Visio.
• Performed source system analysis, data transformation, loading, validation for data marts, data integration, operational data store and data warehouse.
• Developed ETL process to load and maintain metadata repository.
• Creating/ Building and Running / scheduling Batches and Sessions using the Workflow Manager.
• Used Maestro for scheduling automated load jobs.
• Extracted Customer data from XML and oracle database as source data.
• Created Data Warehousing schema and identifying the required Indexes and creating them.
• Handled or rectified the existing code to solve the problems.
• Executed Post Error Mappings, which accept the Excel file as source, which generally have rectified rows where as the original source files are flat files.
• Used Power Connect for MQSeries to get the messages and Power Connect for mainframes to get the data from VSAM, COBOL files.
• Documented Process Flow for mappings and sessions.
• Developed and implemented Universes by defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies and worked on linking of the Universes using Business objects Designer.

Environment: InformaticaPowerCenter/PowerMart5.1/6.2, Business objects 6.0, Broad Cast Agent, BO Designer, Maestro, Oracle8i/9i, SQL server, DB2 UDB7.1, PL/SQL, ERwin4.0, MS Visio.

Confidential, Jan. ’02 – Mar. ‘03
Developer

Responsibilities:

• Directed and coordinated the team in writing Stored Procedures and using Informatica for data extraction, transformation and loading purpose
• Developed, tested and Implemented extractions, transformation and load (ETL) processes
• Performed cleansing and moving data and meta data so that it can be loaded into the data warehouse
• Reviewed and validated all Informatica mappings into and out of the enterprise data warehouse, inclusive of initial and incremental client data loads
• Designed and developed Business Intelligence application using Business Objects and WebI
• Gathered reporting requirements from business end users/clients, documented requirements
• Created various classes and objects for Universe. Measure, Dimension and Detail objects were created to meet the needs of end user requirements so that every possible query can be achieved
• Designed universes using Business Objects Designer as per Business user requirements
• Generated and Analyzed Drill down, Slice and Dice, master/detail reports for analysis

Environment:
Informatica Power Center, Business Objects 5.1.3, SQL Server 2000, MS-Access, Teradata, Windows 2000 Server, SQL, Pl / SQL.

Confidential, Feb. 2000 – Nov. ‘01
Oracle Programmer

• Created back end triggers to enhance the functionality of Applications.
• Written Test scripts in PL/SQL stored procedures for checking various transactions in the billing system.
• Involved in Design, Development and implementation.
• Optimized SQL in Oracle for better performance.
• Involved in Data Migration from Access database to oracle using APIs

Environment: Oracle 8i, TOAD, PL/SQL, SQL*Plus, UNIX, Windows NT, MS-Access, SQL Server.

Worked as a Programmer for different companies between 1997 and 2000

Education: Post Grad. In Computer Applications