PROFESSIONAL SUMMARY:

• 13 years of experience in IT industry with Data Warehousing/ETL & Oracle Database.
• Extensive experience in Planning, Designing, Developing & I mplementing Data Warehouses/ DataMart’s with exposure to both Relational & Multidimensional database design.
• Extensive working knowledge of Data Warehousing, Data Mart and Business Intelligence Solutions. Used Informatica PowerCenter 8.1/7.x/6.x/5.x as a Data Warehousing tool & Oracle Discoverer as a Business Intelligence tool.
• Working knowledge of Data Warehousing techniques/ practices, experience including ETL process, Dimensional data modeling (Star & Snowflake Schema), Fact & Dimension Tables.
• Handful experience of Troubleshooting, Debugging & Performance Tuning Informatica Mappings/ Sessions.
• Worked with various types of Sources/ Targets (Cobol/VSAM File, Flat File Fixed Width or Delimited and Relational) to extract/ load the data in the ETL Process.
• Strong technical knowledge of Oracle 10g/9i/ 8i/7.x/6 Database.
• Extensive working knowledge of Oracle Server - Side PL/SQL Development i.e. Stored Procedure, Package, Function & Trigger using various tools.
• Very good experience with SQL Tuning using Explain Plan, Tracing & TKPROF.
• Working knowledge of Unix OS, Linux OS, Win9x/2000/XP/NT.
• Involvement with Data Architects in various projects to help design the system/schema for OLTP & Data Warehousing Systems. Proficient with Data Modeling tools.
• Good Exposure of SQL*Loader, Oracle Export/Import utility, Unix Shell Scripting
• Proficient with Reporting Tool like Oracle Report Builder and ad-hoc reporting tool like Oracle Discoverer.
• Developed various OLTP systems using Oracle Developer/2000.
• Working knowledge of various types of Testing Techniques, Test Case preparations.
• Practical knowledge of all the phases of SDLC (System Development Life Cycle).
• Self-motivated and committed person with strong interpersonal and communication skill.

TECHNICAL SKILLS:

ETL Tool: Informatica PowerCenter/ PowerMart 8.1.1/7.1/6.2/5.1, Striva (Power Connect Utility for Mainframe)

ETL Data Modeling Techniques: Star Schema, Snowflake Schema

Query Tool/BI Tool: Oracle Discoverer

Automation/Scheduling Tools: Autosys, Informatica Workflow Manager

Databases: Oracle 10g/9i/8i/7.x/6, MS Access, IBM DB2

Database Development Tools: Toad, SQL Navigator, PL/SQL Developer

Programming Languages: SQL, Oracle PL/SQL, UNIX Shell scripts

Data Modeling Tool: ERwin, MS Visio, Power Designer (from Sybase)

Operating Systems: Unix, Linux, Windows 95/NT/Xp.

Advanced Options: IBM MQ Series (to communicate with Mainframe), Oracle CDC (Change Data Capture), Oracle Advanced Queuing (AQ) - Message Queuing functionality.

Management/Productivity Tools: MS Office, MS Project

Version Control Software: IBM/Rational ClearCase 7.0

Change Management/ Bug Tracking Software: Remedy (Scheduler/Trouble Ticket), IBM/Rational ClearQuest 7.0 (EBT)

Languages: C, C++, Cobol, Fortran.

OLTP GUI Development Tool: Oracle Developer/2000 (Forms Builder, Reports Builder, Graphic Builder).

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Senior Informatica/ ETL Developer

Responsibilities:

• Involved in the Development, Maintenance, Enhancement, Testing & Debugging of Informatica Mappings /Sessions/ Workflows using Informatica PowerCenter 8.1
• My role also includes interacting with Business Analyst to understand business specs, creating Technical specs, freezing the design with the Team Lead/Data Architect, analyzing the source/target data dependencies & interaction with the QA Team.
• Used PowerCenter Designer 8.1 to create complex mappings using Mapping Designer. Proficient with various transformations like Expression, Aggregator, Filter, Lookup, Stored procedure, Update Strategy, Union, Joiner Transformation etc. Also, created Mapplets to reuse the logic.
• Used Workflow Manager to create sessions/tasks & workflows to execute the mapping.
• Used Repository Manager to promote the code from one environment to another.
• Developed mapping for Dynamic Parameter File Generation logic.
• Developed Stored Procedures, Functions & Packages to implement the logic at the server end on Oracle 10g.
• Used Autosys to schedule the jobs on the Production Box. Familiar with the Ausosys schedule, commands, Jobs, Box jobs, dependencies, status of job etc.
• Developed Shell Scripts to be called from Informatica Pre/Post Session. Also, involved in the development of the Shell Scripts called by Autosys to execute Informatica Workflows using ‘pmcmd’ command.

Environment: Informatica Powercenter 8.1, Oracle10g, SQL, PL/SQL, Toad, Autosys, ClearCase, ClearQuest (EBT), Remedy, Unix, Shell Scripts, Putty, Textpad, Winscp.

Confidential, Hartford, CT

Senior Informatica/ ETL Developer, Informatica Admin, Team Lead

Responsibilities:

• Involved in the Development, Maintenance and Enhancement of Informatica Mappings, Mapplet, Transformations, Sessions/Tasks and Workflows/Batches using Informatica PowerCenter 7.1/6.2/5.1.
• My role also includes gathering/analyzing the business/user requirements, designing ODS tables in consultation with the Data Architect, analyzing the source/target dependencies & Production Troubleshooting.
• Later on, got promoted to the position of a Team Lead with 6 resources directly reporting to me. The role includes motivating & mentoring the resources, dealing with management, setting realistic expectations, prioritizing the issues (with the help of business owner), assigning resources, Production support, help Project manager come up with the project plan etc.
• Supported Informatica Admin Work using Repository Manager to manager Users, Groups, Privileges and Folder Permission. Also involved in the Object Promotion, PMServer/Repository Server Shutdown/Restart etc on a rotation basis.
• Used Striva/ Detail Navigator /Informatica PowerConnect for MainFrame to define the DataMaps for Mainframe Cobol File.
• Extensively used Informatica PowerCenter7.1/6.2/5.1 as a Data Warehousing tool to perform ETL operations. Used PowerCenter Designer to create complex mapping using Mapping Designer.
• Proficient with various transformations like expression, aggregator, filter, lookup, stored procedure, update strategy transformation etc.
• Used "Workflow Manager"/ “Server Manager” to create Sessions/Workflows/Batches to execute the mapping and to schedule the loading frequency.
• Developed Stored Procedures, Functions & Packages to implement the logic at the server end on Oracle 9.2. Performed Application/ SQL Tuning using Explain Plan, SQL Tracing & TKPROF. Also, used Materialized View for the Reporting Requirement.
• Used Oracle CDC (Change Data Capture) mechanism on the Procede Oracle Tables to capture the “Delta” records and bring them back to ODS.
• Developed interface between Oracle & Mainframe using IBM MQ Series (Request/Response mechanism to communicate with Mainframe).
• Implemented Process Control Mechanism to reconcile the data while loading to ODS tables and providing an Audit Trail for Auditing Requirement.
• On the Production Box, Autosys is used as a scheduling tool. Familiar with the Ausosys schedule, Commands, Jobs, Box jobs, Dependencies, status of job etc.

Environment: Informatica Powercenter 7.1/6.2/5.1, Striva/ Detail Navigator /Informatica PowerConnect for MainFrame, Oracle9.2, SQL, PL/SQL, SQL Navigator, Autosys, Unix, Shell Scripts, UltraEdit, Erwin, ProCede (Ceded Reinsurance Management Solution) from SunGard.

Confidential, Chicago, IL

Senior Informatica/DW Developer/Analyst

Responsibilities:

• Extensively involved in the Development, Maintenance & Enhancement of Informatica Mappings, Sessions & Batches using Informatica PowerCenter5.1.
• Used PowerCenter Designer to create complex mappings using Mapping Designer. Used various transformations to perform ETL operations.
• Used “Server Manager” to create sessions/batches to execute the mapping and to schedule execution based on the loading frequency (Daily, Weekly, Monthly).
• Developed Stored Procedures, Functions & Packages on Oracle 8.1. Performed Application/ SQL Tuning. Created Materialized Views for the performance improvement.
• Developed Shell Scripts to be called from Informatica Pre/Post Session commands.
• Responsibilities also include Gathering the Business requirements, Business Analysis, Design, QA testing and final promotion to the production as well.
• Involved in the design of the new Data Mart for Finance Department and working with Data Architect/ Designer using Erwin Data Modeling Tool.

Environment: Informatica Powercenter 5.1, Oracle8.1, SQL, PL/SQL, SQL Navigator, Toad, Unix, Shell Scripts, Erwin.

Confidential, Buffalo, NY

Senior Software Consultant/Analyst, Team Lead

Responsibilities:

• Team Lead for the Oracle Backend PL/SQL development team. This role includes dealing with management, setting realistic expectation, assigning resources, providing “technical guidance” to other team members and actively participates in all the phases of SDLC.
• Worked with Business Users to “scope out” the requirement, freeze the requirement and provide a “time estimate” to the Project manager.
• Developed Stored Procedures, Functions, Packages & Triggers on Oracle 8i. Performed SQL Tuning. Used SQL*Loader to load the data from legacy system (flat file) to relational tables.
• Involved in the development of interface to Arbor/BP through Oracle Advanced Queuing Mechanism.
• The management decided to develop the Data Warehouse for Reporting Needs and relieve OLTP from the reporting requirement. I was involved in the initial proposal to develop Data Warehouse and subsequently got involved with the Informatica Consultants for the initial training and development work.
• Used Informatica PowerCenter 5.1 Designer to develop Mappings, Mapplets, Transformations, Source & Target Definitions. Used Server Manager to create Sessions/Batches and to schedule the execution.

Environment: Oracle8i, SQL, PL/SQL, Toad, PL/SQL Developer, Unix, Shell Scripts, Power Designer, Arbor/BP, Informatica Powercenter 5.1

Confidential

Senior Developer/ Analyst

Responsibilities:

• The system deals with all post sales activities and provides MIS information about Sales Accounting. Various reporting requirements include History Analysis, Market Trend Analysis, Forecast vs. Actual comparison, Competitive Analysis etc.
• Needs a typical Data Mart that supports various types of Reporting Requirement.
• Developed Stored Procedures, Functions, Packages & Triggers on Oracle 7.3 to incorporate the Data Mart. Used Staging area to consolidate the data from various locations and to consolidate the data from various source systems like Dispatch, Sales, Marketing and Finance systems.
• Used Oracle Discoverer as a business intelligence and ad-hoc reporting tool.
• Covers entire production process and monitor the efficiency of each plant.
• Extensively involved in the GUI Development, Maintenance and Enhancement of Forms (Screens) & Reports using FormBuilder5 & ReportBuilder5 (Developer/2000 Tools) to capture/ report various information.
• Involved in the complex reporting using Report Builder to develop various types of Daily, Monthly reports including matrix reports.
• Involved in the Development, Maintenance & Enhancement of Screens (using FormsBuilder5.0) and reports (ReportBuilder3.0) to capture/ report data about Pre-sales, Sales, Invoicing, Logistics, Finished goods inventory related activities.
• Performed integration with Weighbridge software to reconcile the weight of finished goods.
• Summary Tables created to generate some summary reports like year-to-date sale using Report Builder 3.0. Developer Stored Procedures, Packages to implement business logic at the server-side on Oracle 7.3.
• Used SQL*Loader to load the data to the new system as part of Conversion Module effort.
• Forward integration with Finance and Accounts system and backward integration with production & quality control system. Introduced the concept of Day-end posting, which is essentially PL/SQL logic that “locks” relevant transaction and post data into Accounts system.
• Extensively involved in the Development & Maintenance of Oracle Forms4.5 (Developer/2000) entry screens to capture various quality assurance testing parameters and graphical presentation of the data based on Oracle Graphics2.5 (Developer/2000).
• Developed Stored Procedures, Packages, Functions & Triggers on Oracle 7.3 Database. Also, performed SQL Tuning using explain plan. Mainly “Auto” grading of product is done by a stored procedure.
• This system covers the dispatch and sales for the specific plant and covers invoice generation as well.
• Involved in the Development of data entry screens, reports using Developer/2000 Rel 1.2(Forms4.5 and Reports2.5).
• Leading the implementation team to implement the system at client place.

Environment: Oracle7.x, SQL, PL/SQL, Developer/2000 (Forms, Reports, Graphics Builder), Toad, Unix, Shell Scripts, Erwin.

Confidential

Developer/Analyst

Responsibilities:

• Developed data entry screens using Oracle Forms4.5 and reports using Reports2.5.
• Use of SQL*Loader to load the data from legacy system (flat file) to relational tables.
• Developed Stored Procedures, Functions, Packages & Triggers to incorporate the business logic in the backend and performed SQL Tuning using Explain Plan.

Environment: Oracle7.x, SQL, PL/SQL, Developer/2000 (Forms, Reports, Graphics Builder), Toad, Unix, Shell Scripts, Erwin.

Confidential

Developer

Responsibilities:

• Involved in the Code Modification/ Enhancement to handle Y2K problem.
• Provide feedback to an Automation Team to convert the code to Y2K compliant code.
• Involved in the Unit Testing & Code Review.
• Used various Y2K tools like CompareX, Verify, and HourGlass.

Environment: IBM ES-9000 Mainframe, IBM DB2, CICS, Cobol.