PROFESSIONAL SUMMARY

• Over 8 years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Testing of Applications in Data warehouse, OLAP with strong business knowledge of Financial, Insurance, Pharmaceutical industry.
• Extensive Data Warehouse experience using Informatica PowerMart/ PowerCenter v 8x/7x/6x/5x (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer) as ETL tool on Oracle, SQL Server and DB2 Databases.
• Comprehensive Knowledge of Ralph Kimball’s Data Modeling Concepts including Dimensional Data Modeling, Star/ Snowflake Schema Modeling.
• Experience in Up-grading the system from Informatica version 6.2 to version 7.1.2 and 8.1.
• Experience in integration of various data sources like Oracle, SQL Server, Flat Files, and XML into staging area.
• Experience in writing UNIX shell scripts.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Experienced in overall data warehouse, database, ETL and OLAP tuning for better performance.
• Experience of preparing FSD/TSD (Functional/Technical Specification Document) documents from BRD (Business Requirement Document) / Customer Requirements.
• Have good mentor skills in addition to excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi site development.

TECHNICAL SKILLS

Database: Oracle8i/9i/10g, SQL Server, DB2UDB7.2, Sybase.
Operating Systems: UNIX, VAX VMS, IBM Mainframes, Windows 95/NT/Xp, Sun Solaris.
Programming Languages: C, T-SQL, SQL, PL/SQL, Unix Shell scripts, HTML, XML.
ETL Tools: Informatica PowerCenter /PowerMart 8x/7x/6x/5x, SQL*Loader.
CRM Tools: Siebel 6.3/7/7.5.3, DAC (Data warehouse Application Console).
Other Tools: Mercury Test Director, Autosys, Control M, DXE Manager, CVS.

• Confidential,

Client: Confidential,
NY (June’ 08 – Till Date)
Role: Senior Data warehouse Developer/ Analyst

• Project: Reference Data Management
• Project: ArrowGlobal/ Risk-to-Price Model, Insurance Market Portal, Covered bond Monitor
• Project: Forex data distribution
• Data Migration from old to new version of Reference Data Management

Responsibilities:

• Managing high caliber offshore development team and ensured all the development work meets business requirements and is delivered as per the plan.
• Involved in implementing of integrated enterprise data management system (GoldenSource) for org level, pricing and securities Reference Master Platform.
• Worked on enriching the master data platform from various internal and external (Reuters, Anna, CRS, Cusip, Bloomberg, etc.) data sources.
• Designed and built daily FX rates distribution process (Master to downstream consumers).
• Helped with coordinating data requirements from master data platform for downstream consumers with stewardship for various projects.
• Involved in designing and developing of new Informatica process and also re-used lot of existing objects.
• Designed and built end-to-end orchestration process for key projects which helped analysts (end-users) in getting the required data near real-time.
• Migrated over one Terabyte of data from old to new Reference Data Management (Oracle DB) and addressed all the performance issues while loading the data.
• Helped Architecture and DBA team with Oracle CDC setup.
• Built Oracle CDC Monitoring and Archiving/Purging process for audit data on various DBs.
• Involved in monitoring File System and DB storage (High Watermark/ Online Shrink).
• Involved in maintenance/enhancements and production support for various projects.
• Worked on lot of ad-hoc request from users (one time load, export/import of data, data quality).
• Highlighting Key Risks\\Issues across Onsite & Offshore team and working with the team to resolve them.

Environment: Informatica Power Center 8.1/8.6, GoldenSource, Autosys, Oracle 10g, SQL, PL/SQL, SQL * Loader, SQL Navigator, Business Objects, Erwin, Test Director, CVS, Agile development methods.

• Confidential,

Client: Confidential,
NJ (July’ 05 – May’ 08)
Role: Data warehouse Developer/ Analyst

• Project: Risk and Performance.
• Project: MLIM/BlackRock Merger.

Responsibilities:

• Worked in various projects and managed onsite and offshore teams.
• Involved in Designing the specifications, Design Documents, Datamodeling and design of data warehouse.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Involved in creating the Logical Model using Normalization and Abstraction technique.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Used parallel processing capabilities and Session-Partitioning and Target Table partitioning utilities
• Extensively worked on tuning (Both Database and Informatica side) and there by improving the load time.
• Used Informatica Repository Manager for managing all the repositories (development, test & validation), was also involved in migration of folders from one repository to another.
• Verified and tested the code and migrated into Integ and UAT environments and also was involved in designing the specs with the Business Users.
• Used Autosys Scheduling Tool to schedule UNIX shell scripts, PL/SQL scripts and Informatica jobs.
• Written Unix Shell Scripts for getting the data from all systems to the data warehousing system. The data was standardized to store various business units in tables.
• Wrote User Acceptance Test cases and trained users on new products and features.
• Tested the target data against source system tables by writing Some QA Procedures.

Environment: Informatica Power Center 7.1.2/8.1, Power Exchange, MQ-Series, Eagle Pace, Autosys, Perl, HP UNIX, Oracle 9i/10g, Sybase, SQL, PL/SQL, SQL * Loader, SQL Navigator, Erwin.

Client: Confidential,
NY (Oct’ 03 – Nov’ 04)
Role: Informatica Consultant
Project: Business of future (BoF)

Responsibilities:

• Extracted data from sources like Oracle and Fixed width and Delimited Flat files. Transformed the data according to the business requirement and then loaded into Relational DB and files.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, Update Strategy.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Handled operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Created new Shell Scripts for File Renaming, Moving files from one directory to another and more. All these scripts were used in the Post Session Command within the Informatica Workflow.
• Involved in migrating PowerCenter folders from Development to Production Repository using Repository Manager.
• Created/Updated/Modified Users and Groups for PowerCenter Repositories using Repository Manager.
• Involved in Testing of all the Interfaces with huge amount of data and fixed bugs accordingly within the Mappings/ Workflows.
• Maintained a consistent Naming convention for Mappings, Transformations and Workflows name as per the business infrastructure documents.
• Maintained documentation for every process including the Mapping and Transformation Rules, Source and Target definitions, Output Flat file locations, Shell Scripts and Template files directories.

Environment: Informatica PowerCenter 5.1.2/6.2, DXE Manager, Excelon, Documentum, HP UNIX, Windows XP, Oracle 8i, TOAD, SQL*Loader, DXE Manager.

Client: Confidential,
Waukegan, IL (Jan’ 02 – Oct’ 03)
Role: Datawarehouse Analyst/Programmer
Project: Call Center (Navigator) Project

Responsibilities:

• Extracted data from sources like Oracle and Fixed width and Delimited Flat files. Transformed the data according to the business requirements and then Loaded into the Oracle.
• Modified several of the existing mappings and created several new mappings based on the user requirements.
• Produced a Unit test Document, which captures the test conditions and scripts, expected/actual results.
• Maintained existing mappings by resolving performance issues.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Created Mapping Parameters and Variables.
• Used Informatica Repository Manager for managing all the repositories (development, test & validation), was also involved in migration of folders from one repository to another.
• Ran data loads into all the environments using DAC (Data warehouse Application Console), DAC is a centralized console, providing access to the entire Siebel Data Warehouse application. It allows you to create, configure, and execute modular data warehouse applications in a parallel, high performing environment.
• Added workflows and their related sources and targets, created dependencies of each task, scheduled the load and monitored the data warehouse process using the DAC Client (A command and control interface) for both Incremental and Full loads.
• Extensively involved in testing by writing some QA procedures, for testing the target data against source data.
• Developed the design document for each ETL mapping, defining the source and target tables and all the fields, transformations and the join condition, which helped the users to better understand the type of data.

Environment: Informatica Power Center 5.1.2, Siebel 6.3/7/7.5.3, DAC (Data warehouse Application Console), HP UNIX, WindowsNT, Oracle 8i/9i, SQL, PL/SQL, SQL * Loader, TOAD, Erwin.

EDUCATION

• Bachelor of Science in Information Technology
• Minor in Management