SUMMARY

• Over 7+ years of IT experience in analysis, design, development and implementation of software applications in data warehousing and Client/Server environment.
• Strong expertise in analysis, design, development, testing, Data Modeling of Data warehousing applications using, Oracle 9i/8.1.7, SQL Server 2000, UNIX, and Informatica Power Center 9.x/8.x/7.x
• Experience in complete life cycle of an Enterprise Data warehouse.
• Expertise in implementing complex Business rules by creating robust mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Extensively worked with different Data sources ranging from flat files, Oracle, SQL server, and DB2.
• Excellent understanding of the difference between meta - data and meta-data repositories versus operational data.
• Experience with Agile Methodology - Scrum, V Model
• Experience in working with multiple RDBMS including Oracle 8i/9i, SQL Server and MS Access.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experience in creating Complex workflows and worklets using Informatica 9i.
• Expertise on the various data design models like Star Schema and Snow Flake models.
• Extensive experience in UNIX shell scripting (Ksh/Csh), Job scheduling using Crontab, AutoSys
• Exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively Confidential all levels of the development process.

TECHNICAL SKILLS

Operating Systems: Windows NT/95/98/XP/2000/Server 2003, Linux

Databases: MS SQL Server, Oracle 8i/9i/10g/11i, MS Access

ETL Tools: Informatica Power center 9i/8.x/6.x.

Database Tools: SQL Profiler, SQL Query Analyzer, SSManagement studio, Analyzer, DTS Import/Export, Backup Server, SQL Agents, SQL Alerts, SQL Jobs

Skills and Languages: JavaScript, Windows scripting, UNIX Scripting

Reporting Tools: Cognos, Micro strategy, Business Objects, Oracle Reports

Productivity Applications: MS Word, MS Excel

PROFESSIONAL EXPERIENCE

Confidential, Rochester Hills,MI

Data Warehouse Consultant

Responsibilities:

• Involved in the day-to-day production support for the existing warehouse.
• Actively interacted with the Business Users for determining the Business Rules for the new requirements as requested by the users.
• Actively interacted with the Data Modeler and Source system (Oracle ERP) professionals for determining the Data load strategies for loading data into the Datamart from Datawarehouse.
• Developed mapplets and reusable transformations that were used in different mappings and across different folders.
• Developed the error handling mechanism to be used for all the Informatica jobs, which load data into the data warehouse.
• Extensive utilization of Expression, Filter, Sorter, Router, Joiner, Lookup, Stored procedure, Sequence generator, Update strategy transformations.
• Scheduling sessions and batches, tuning Informatica application for better performance
• Involved in the Development and Unit Testing of the Informatica Jobs for loading data into the Datawarehouse for any new business requirements.
• Designed and developed complex Procedures to handle errors and exceptions Confidential both application and database level using PL/SQL and Shell scripts.
• Performed and documented Unit and Integration tests, and developed promotion checklists for promoting the new and modified Informatica objects between various environments.
• Identified and created different source definitions to extract data from input sources like Flat files, COBOL files, SQL Server and load into relational tables like Oracle.
• Extensively worked on creating mapping and workflow design documents for the data load strategies for initial and incremental load of data from DW to DM.

Environment: Informatica Power Center 9.x, Oracle 9i, PL/SQL, SQL Navigator 4, SQL*PLUS, SQL*Loader, FTP Pro, Erwin, Unix Shell scripts (Korn), Windows NT/XP.

Confidential, Bellevue,WA

Data Warehousing Consultant

Responsibilities:

• Involved in meetings with the business for gathering requirements and identifying the source data.
• Developed SQL packages for analyzing the source system data and also for generating the extract scripts for loading data into staging tables.
• Performed GAP analysis and also determined the cross-reference tables needed.
• Developed Complex mappings and workflows using PowerCenter designer and Workflow manager for loading data into Datawarehouse from staging.
• Troubleshooted the informatica jobs identified the performance bottlenecks and adopted various techniques to improve the performance.
• Performed unit testing on the Informatica jobs developed and documented the test results.
• Involved in updating the shell scripts and parameter files, which are used to run the workflows daily, with the new Informatica jobs developed.
• Involved in integration testing of the jobs developed and migration of jobs from one environment to another.
• Developed informatica jobs for loading data into datamart from data warehouse using reusable transformations and mapplets.
• Involved in Informatica Administrative tasks Repository and folder management, User permissions, version controlling, metadata reporting, and server management.
• Worked on performance tuning for mappings by optimizing the sources, transformations, targets and sessions.
• Developed test scripts for Unit testing the informatica jobs developed for loading data into data mart.
• Involved in production support for the data warehouse informatica jobs

Environment: MS SQL Server 2005/2008, MS SQL SSRS, SSIS, Visual SourceSafe, Windows 2003 server

Confidential

Sr. Programmer / Analyst

Responsibilities:

• Determined and located the Source data elements needed by the business client.
• Working on Informatica PowerCenter to build the ETL process for monthly, Quarterly and Standard Collection Data Marts.
• Build Balance and Control (Data Quality Assurance) mappings and implemented Error processing.
• Created mappings, mapplets and reusable objects to move data from staging area to a data warehouse.
• Effectively used transformations such as Joiner, Look-up, Rank, Expressions, Aggregator and Sequence Generator, etc. and fine-tuned SQL overrides and Look-up SQL overrides for performance Enhancements.
• Created workflows/ worklets as a single object to run the incremental loads.
• Build mappings to move data from Datawarehouse to Data Marts.
• Worked on performance tuning for mappings by optimizing the sources, transformations, targets and sessions.
• Developed test scripts by comparing the results of mappings with sources in UNIX.
• Developed Shell scripts to schedule the sessions and batches using pmcmd.
• Developed procedures for balance and control process.
• Successfully loaded initial and incremental loads with best performance.
• Working on creating the builds and user training manuals.

Environment: Informatica Power Center 8.x, Business Objects 5.1, Cognos, DB2 UDB 7.2 /5, Power Designer 6.0, UNIX (Korn), Quest Control for DB2, FTP Pro 2.0, XML, HTML and Windows NT/2000/XP.

Confidential

ETL Developer

Responsibilities:

• Involved in the business requirements gathering and analysis.
• Build strategies for merging the data, which come from EDW and Wisdem clients.
• Responsible for creating user rolls, database connections, folders, etc.
• Created different transformations such as Joiner, Look-up, Rank, Expressions, Aggregator and Sequence Generator, etc. Fine tuning SQL overrides and Look-up SQL overrides for performance Enhancements
• Created workflows/ worklets as a single object to run the incremental loads.
• Developed procedures for balance and control process.
• Worked with BI team to setup the default vales in staging area for different fields.
• Successfully loaded initial and incremental loads with best performance.
• Working on creating the builds and user training manuals.

Environment: Informatica Power Center 8.x, Oracle 9i, PL/SQL, Erwin, UNIX, TOAD, FTP Pro, COBOL, XML, HTML, Windows NT/XP.

Confidential

ETL developer

Responsibilities:

• Translated business requirements into data warehouse
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica
• Collection of data source information such as Oracle, VSAM, XML, flat files from legacy systems and existing data stores
• Maintained stored definitions, transformation rules and targets definitions using repository manager
• Used debugger to test and fixed bugs in the mappings
• Scheduled and monitored transformation processes using Informatica Server Manager
• Used Informatica repository manager to backup and migrate metadata in development, test and production systems

Environment: Informatica Power Center 8.x, Oracle 7.x/8.0, Shell Scripts, Oracle, and Windows NT.

Confidential

Developer

Responsibilities:

• Created database tables, indexes in Oracle RDBMS implementing various business rules using appropriate constraints and database triggers. Reverse engineered and reconciled the database to implement the changes in database using Designer 2000.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Involved in development of Front end Screens for entering information of the problems using Forms 4.5. Designed various Reports using Reports 2.5.
• Developed database triggers, procedures and functions to monitor the business functionality and needs.

Environment: SQL *Loader, PL/SQL, Designer 2000, Windows 98