SUMMARY

• 14 years of IT experience in USA.
• Primary skills are Data warehouse, Informatica, Unix shell Script, Control - m, Brio reports, Data Modeling, Database and SQL tuning,
• Demonstrated capability to quickly adapt to different project environments, embrace new technologies and techniques quickly and effectively through diligent effort.
• Specific experience in the Financial Business Sector, Brokerage compensation, Logistic systems, Manufacturing, export management system, Regulation systems.

TECHNICAL SKILLS

Operating Systems: Windows 9X/2000/XP/NT,MS-Dos,HP-UX,Unix,IBM AIX 4.3/4.2 and Solaris

ETL Tools: Informatica 9.1/8.1//7.1. x/6.2/6.1/5.1 (Power Mart/ Power Center) 6.x, Informatica Power Exchange 7.x/8.x

Languages: C, C++, JAVA, PL/SQL

Databases: Teradata 12/V2R4/V2R5, Oracle 10g/9i/8i/8.0/7.x MS SQL Server 2005/2000/7.0/6.0 , MS Access

Teradata Tools & utilities: Query Facilities Query man, BTEQ

Load & Export: Fast Load, Mload, FExp.

Programming skills: Cell scripting (K-Shell, C-Shell), PL/SQL

Data Modeling tool/ Methodology: MSVisio, ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling.

PROFESSIONAL EXPERIENCE

Confidential, DOVER, NH

ETL Lead Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Involved in the 24*7 on-call coverage to support the EDW issues.
• To Monitor ESP Daily/Monthly jobs to make sure the Prod Environment is stable.
• Involved with the DBA team to improve the performance of EDW Environments.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Created BTEQ scripts to Perform transformation logic Load Data from Teradata Staging area to the Teradata Production tables.
• Created Informatica logic to Load data from Mainframe source (VSAM), Oracle using Power Exchange when there was change in the source data sets into Flat files.
• Involved in designing and developing the data warehouse for reporting through MicroStrategy.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Validation of Informatica mappings for source compatibility due to version changes at the source.
• Trouble shooting of long running sessions and fixing the issues.
• Created Mload scripts to Load data from Flat files to Teradata Staging area. used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Implemented new SQL transformation for executing SQL statements.
• Used Exception handling logic in all mappings to handle the null values or rejected rows
• Query Optimization for improving the performance of the data warehouse.
• Involved in performance tuning of the mappings, sessions and workflows.
• Performed Type1 and Type2 mappings
• Used session parameters and parameter files to reuse sessions for different relational sources or targets.
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency.
• Created documentation on mapping designs and ETL processes.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Developed Korn shell scripts for Informatica pre-session, post session procedures

Environment: Informatica Power Center 9.1/8.6, DB2, Power Exchange 8.1, Oracle 10g, Teradata12, SQL, PL/SQL, TOAD, Erwin, MS SQL SERVER 2005, T-SQL, Shell Scripts, SQL Navigator, Mainframe, Solaris, Micro Strategy, Golden Gate

Confidential Merrimack NH

ETL LEAD

Environment: Informatica Power Center, PL/SQL, Informatica, Control-M, K-shell Scripts, Brio

Responsibilities:

• The Finance Data warehouse is designed to provide to support the finance department financial analysis and a source to various downstream applications. The warehouse is developed using TeraData,UNIX, INFORMATICA 8.x and Control - M. This data warehouse is modeled using dimension modeling
• Involved and designed the various dimensions and facts. Generated technical design document (TSD) for various modules.
• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Involved in the 24*7 on-call coverage to support the EDW issues.
• To Monitor ESP Daily/Monthly jobs to make sure the Prod Environment is stable.
• Involved with the DBA team to improve the performance of EDW Environments.
• Designed, developed and maintained database objects like tables, indexes, (Procedures,triggers, functions and packages), roles, grants,synonyms, defined storage parameters.
• Designed and developed various ETL process using INFORMATICA Power Center 8.x. Developed various Workflows, mappings using various transformations like Source qualifier, Lookup, joiner, rank, sorter, aggregator, update strategy, router to support ETL process.
• Used round robin, key range, hash key and pass thru partitioning to improve performance of INFORMATICA workflows. Improved the workflow performance by doing performance analysis.
• Provided performance tuning on the Oracle databases by defining primary keys, indexes, hints where needed, ran EXPLAIN PLAN to review the execution plans and determine which queries and procedures needed tuning and to minimize or eliminate throw away such as full scans, or improper joins, examine the execution plans for all SQL statements of various individual SQL statement to reduce or eliminate bottleneck issues
• Created generic procedures to utilize partition exchange techniques to load large volume data into FACT tables
• Involved in Legacy system decommission by migrating their functionality and historical data into Data warehouse which will include the system study, migration of Legacy data and capacity planning for data base storage.
• Provided developer on call support for the data warehouse and production cycles.

Confidential

Senior Programmer

Environment: Oracle 11i applications, PL/SQL, Oracle forms, Oracle Apps server10g R2, Oracle Reports, Oracle db 10g R2

Responsibilities:

• Developed and supported the company's Oracle database systems encompassing full lifecycle of installation, database creation, administration
• Worked on Oracle 11i application interface applications.
• Worked on CRM, Order Management, Inventory Module, HR Module, Shipment Module and delivery module.
• Created and implemented PL/SQL scripts, triggers, Procedures, packages, tables and views.
• Worked With Oracle Enterprise Manager for database Monitoring and reporting
• Involved in Develop And maintain DBA Policies And Procedures
• Liaised with users to specify and develop screen & report layouts
• Trained staff to support implementations, as well as end users in database applications
• Interacted with business representatives for requirement analysis and to define business and functional specifications, layout of screens and reports
• Involved in development of front-end interface for quotation, new-business
• Involved in creation of basic documents required for Logistic Business
• Used PL/SQL Tables And Data Base Triggers to Automate Process
• Prepared UNIX shell scripts and used SQL*Loaders to automate batch runs for data load process
• Improved performance by load sharing among multiple servers Oracle Application server parameters
• Converted Oracle forms 4.5 to Oracle forms 6.5 and further converted to Oracle forms 10g R2
• Involved in implementation of oracle 11i application and Global Logistic System interface
• Configured Oracle apps server to implement the Global Logistics software
• Worked with the DBA team and had discussion to trouble shoot the interface problems and testing and also implemented the DBMS jobs to automate interface process
• This Interface was implemented at various places around the world. (UK, ASIA) in October 2005.
• Involved in the 24*7 on-call coverage to support the shipping/logistics operations of Agere