SUMMARY

• Over 13 years of IT experience wif around 6 years in Design, Development and Implementation of Data Warehouse & Data mart wif ETL Tool using Informatica Power Center 8.x/9.x, Oracle11G/9i/8i, SQL, PL/SQL both on Windows 2000 & UNIX
• Sound Knowledge of Dimensional Modeling using Star schema and Snow Flake schema for faster, TEMPeffective querying and Business Analysis Requirements
• Experience in debugging and Performance tuning of targets, sources, mappings and sessions
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Sorter, Filter, Expression, Aggregator, Joiner, Update Strategy, Data Masking etc. using Informatica.
• Proficient in using Workflow Manager Tools like Task Developer, Workflow Designer
• Proficient in developing PL/SQL packages, stored procedures, Triggers.
• Worked on IBM Tivoli Scheduler and Autosys to schedule JOB Streams which triggers Shell Scripts
• 6 months of experience in Ab Initio GDE, Co>Operating System, migrating data from heterogeneous source system to teh Teradata target database
• Developed Ab Initio applications for extracting, transferring, loading, cleansing and populating various Data Marts.
• Expertise in various Ab Initio components Partition, Rollup, Reformat, Dedup Sort
• Experience in developing Client/Server applications using Oracle, Forms and Reports
• Worked on Data migration from legacy systems to Oracle database.
• Involved in development of automated codes using Unix shell scripts
• Worked on Logical and Physical Database Designing using ERWIN Tool
• Involved in testing and review of codes designed using Business Intelligence (OLAP) Tools such as Hyperion Brio 8.X
• Well versed wif software lifecycle activities like Requirement Analysis, Design, Coding, and Testing.
• Involved in business understanding of PeopleSoft HRMS (PSHRMS) to design teh Reports and for catering teh Interface requirements from teh Global Data warehouse.
• Worked as a Project Lead having team of Experienced Data warehouse professionals in a typical onsite - offshore model
• Strong analytical and problem solving skills, Strong communication and interpersonal skills.
• Knowledge on DAC components such as Task, Task Groups, Subject Area and Execution Plan.

TECHNICAL SKILLS

Operating System: SUN SOLARIS, LINUX, WINDOWS NT, WINDOWS'95

Databases: ORACLE 7.X/8i/9i/11G, Teradata 7.1.0

ETL: INFORMATICA 9.1.0/8.6/8.1, Ab Initio (GDE 1.14.38)

Scheduler: Maestro Tivoli Workload Scheduler 8.3, Autosys, DAC

Languages/Packages: SQL/PL-SQL

Reporting Tool: Hyperion Brio Reporting 8.3, Business Objects 5.x, Oracle Reports 6i, Oracle Discoverer

GUI: Oracle Developer 2000

PROFESSIONAL EXPERIENCE

Confidential, Mooresville, NC

ETL ARCHITECT

Responsibilities:

• Involved in teh requirements gathering for Recruitment and Absence Module of HR Analytics.
• Designed teh Customized Data Model in line wif Out of teh Box SDE and SIL recruitment mappings.
• Customization of “Out of teh Box “Source Dependent Extracts (SDE) and Source Independent Loading (SIL) Informatica Mappings for Compensation Module of HR Analytics.
• Involved in creating DAC components such as Task, Task Groups, Subject Area and Execution Plan in teh Oracle BI Data Warehouse Administration Console (DAC)
• Developed process to load multiple sequential files wif teh same record layout by using Informatica ETL File List processing.
• Involved in Data Loading and Data Analysis having People soft as teh source.
• Created Design Documents and Process Documents.
• Managing project having team at onsite and offshore.

Environment: Informatica 9.0, Oracle 10G/11G, Linux, Oracle BI DAC

Confidential, Charlotte, NC

ETL ARCHITECT

Responsibilities:

• Involved in requirements gathering and high, low level design discussions. Mapping teh source system fields for ETL wif teh current state ware house fields
• Involved in data analysis and issue resolution having source data file in XML format
• Analysis of teh existing warehouse design and documenting teh gaps
• Performing feasibility studies of teh new requirements comparing teh current ware house design
• Development of teh pseudo code for processing teh data using Informatica 9.x having teh source as Master Data Management ( MDM )
• Loading and Testing teh data across various testing environments using Informatica as teh ETL

Environment: Informatica 8.6/9.0, Oracle 10G/11G, Linux, Autosys Scheduler

Confidential, Charlotte, NC

ETL LEAD

Responsibilities:

• Involved in requirements gathering and high, low level design discussions. Create pseudo codes and prototypes and get teh design reviewed to meet teh requirements.
• Develop Informatica Mappings as per teh design and guide teh team in developing optimized high quality code.
• Create test plans for teh team and perform Code Review of teh code developed by teh team. Perform independent testing of teh code and validate against teh requirement.
• Lead teh team during System Integration Testing and User Acceptance Testing. Involve in teh release management process and support teh deployment.
• Involved in creating detailed schedule of teh work effort by carefully analyzing teh effort and dependencies and provide inputs to overall project schedule
• Design teh Autosys Scheduler taking into consideration dependencies and meeting teh SLA
• Warranty Support of teh code deployed into Production Environment
• Interface wif Customer, Business Analyst, TDM and senior managers. Provide status updates of teh project
• Involved in creating Proposals for new initiatives. Estimation of teh work effort and planning teh resource required to meet teh timelines. Involved in discussion wif customer to gather scope information and perform analysis of teh scope of teh project.

Environment: Informatica 8.6, Oracle 11G, Linux, Autosys Scheduler

Confidential, Charlotte, NC

ETL LEAD

Responsibilities:

• Involved in design, development, testing and implementation of teh Banks Data Warehouse for Corporate Work Place group involving redesign of teh existing integrated reporting environment.
• Involved in designing better loading process which had better status logging and monitoring process. Was involved in adding more TEMPthan 1500 elements to teh existing warehouse
• Worked as technical lead on teh project providing estimates and inputs to planning to ensure timely delivery wif quality.
• Developed mappings as per business requirement using Informatica ETL
• Perform code reviews and was involved in migration of teh deliverables to test and production environments
• Managing a team of 8 ETL offshore resources providing them technical specification of teh business requirements
• Collaborate wif business analysts and business teams as required to ensure that scope and requirements are captured accurately and business needs are met
• At teh application level worked as a consultant to Business, IT Management, Application Team and Sourcing Partners.
• Involved as a consultant in resolving issues arising in Production Environment.
• Performed Data analysis having teh source database as DB2 and SQL Server
• Created Job Streams and Jobs to schedule teh UNIX shell scripts through Maestro.

Environment: Informatica 8.1/ 8.6, Oracle 9i/ 11G, Unix Sun Solaris, IBM Tivoli Schedule, Autosys Scheduler

Confidential, Chicago, IL

ETL LEAD

Responsibilities:

• Analysis of teh Production Data Quality Issues.
• Designing Technical Design Document to fix teh Data Quality Issues.
• Managing teh offshore delivery team.
• Review and Test teh code developed at offshore development centre
• Code Migration and testing in different test environment
• Modified Code Deployment into production and validations
• Coordination wif teh Data Modeler, Central File Distribution Team
• Lead a team of 4 data warehouse professionals in onsite offshore model

Environment: Informatica 7.3, DB2, Oracle 10g, Unix Sun Solaris, Harvest

Confidential, Charlotte, NC

ETL Lead

Responsibilities:

:

• Gather and analyze requirements for Designing teh ETL Mapping for migration of Data
• Design and Develop Graph for Source Layer Loading from Mainframe Applications to Teradata Database using Ab Initio ETL
• Lead a team of 4 data warehouse professionals in onsite offshore model
• Review and Test teh code developed at offshore development centre

Environment: Ab Initio GDE 1.14.38, Teradata 7.1, AIX 5.3

Confidential, New Jersey

ETL Lead

Responsibilities:

• Lead a team of 7 data warehouse professionals in onsite offshore model
• Prepared and analyzed Business Requirement
• Involved in teh Design and Development of mappings using Informatica ETL tool.
• Involved in teh preparation of Project estimates and tracking using MPP.
• Involved in teh Database performance Tuning.
• Preparation of technical documents based on teh requirements Specification.
• Design teh data model for teh reports using ERWIN.
• Involved in teh review of reports generated using Hyperion Brio
• TEMPEffective Coordination between Business users and teh interface teams.
• Technical support during system integration test and user acceptance test

Environment: Oracle 9i, Informatica Version 7.1, Sun Solaris 5.8, Toad, Brio 8.3, VSS

Confidential

System Analyst

Responsibilities:

• Migration of Service Contract Application Data and Outgoing Bill Data on teh Mainframe to Oracle9i.
• Data analysis and developing packages, stored procedures as per teh business requirements.
• Developing patch scripts for resolving teh defects. Performance analysis of teh process.
• Executing Shell Scripts for atomizing teh process.

Environment: Oracle 9i, Sun Solaris 5.8, Toad, Java Applications

Confidential

Senior Associate

Responsibilities:

• Production Support on 24/7 Basis
• Design and documentation of technical requirements
• Perform Build process on a weekly basis from Dev environment to UAT environment and production environment.
• Perform Database Refresh from production Environment to UAT environment and functional testing environment
• Incident Resolution for Production and UAT environment
• Uploading data extracts to Production environment and UAT environment.
• Monitor teh performance of teh database and teh site
• Support site availability on 24/7 basis
• Coordination wif clients and vendors on a 24/7 basis
• Basic unit testing

Environment: Oracle 9i, Toad, UNIX, Shell scripts Broad Vision6.0.

Confidential

Programmer Analyst

Responsibilities:

• System Study and Analysis of teh business requirements
• Translate functional and technical specifications into Code using PL-SQL.
• Design and Develop code using Oracle PL-SQL
• Develop batch scripts to load teh data
• Develop Reports using Oracle-Reports 6i.
• Writing Patches using Oracle pl/sql
• Development and writing of Unit Test Cases.
• Testing of teh functionality of teh product
• Extensive programming using VI Editor
• Extensive use of TOAD for data analysis
• Post Production Support
• Co-ordinations of Project and Team Activities.

Environment: Oracle 8i, Reports 6i, UNIX OS, Toad, Visual Source Safe, Win 2000

Confidential

Programmer

Responsibilities:

• Implementation of teh ERP Package at various manufacturing industries which were teh clients of Asian Compusoft Limited. Had implemented Oraspace ERP Package / modules mainly into Production Management, Materials Management, Sales and Distribution
• Understand teh customer needs in totality. Coordinate wif teh team of technical consultants and translate design into implementation. Have a clear understanding of teh program specifications. Ensure timely delivery of teh design and also have a thorough review/quality check of deliverables. Interact on a regular basis wif Business Users of Client/Technical users.
• Restricting unauthorized users by providing security to teh Oracle Forms and Oracle Reports.
• Importing data from different database using IMPORT and EXPORT utilities.
• Creating MIS Reports using Discoverer 3.1
• Creating GUI screens using developer 2000.
• Extensively used Oracle for making changes as per customer requirements (Modifications in table structures- creating users). Check if software confirms to teh predefined quality Standards.

Environment: Oracle 8i, PL/SQL, SQL*Plus, Forms 4.5, Reports 2.5, Discoverer 3.1, Win NT.Non IT:

Confidential

Electrical Engineer

Responsibilities:

• Commissioning and Troubleshooting of Micro Controllers for teh Elevators
• Project Planning, Timely Delivery, Coordination wif teh client