SUMMARY

• Nine Plus (9+) years of experience in Data warehousing & Extraction, Transformation & Load (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center 9.1/8.x/7.x/6.x (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager and Informatica server), Informatica Data Quality 9.1, Address Doctor, OLAP, Data Reports, Crystal Reports, Business Objects, OBIEE,Autosys, Crontab
• Expertise in Data Modelling specially “Logical Data Partitioning Model” and STAR Architecture.
• Expertise in building Datawarehouse using ETL and BI tools like Informatica, Actuate and Business Objects
• Seven Plus (7+) years of Data Modeling experience using Star and Snow - Flake schema. Efficient utilization of “Bottom-up” and “Top-Down” methodologies.
• Nine Plus (9+) years of Database design, writing stored procedures, functions, triggers, DDL, DML SQL query performance tuning using Oracle 11gR2/10g/9i/8i, PL/SQL, SQL*Plus, SQL*Loader
• Extensive experience in tuning Informatica Mappings and Sessions for optimum performance.
• Involved in data cleansing using Informatica Data Quality and Address Doctor.
• Nine Plus (9+) years of experience in Informatica 9.x/8.x Administration and server management.
• Extensive experience in Informatica version upgrades (6.x à8.x à 9.x). Implemented Single and Multi node (“High availability”) environments.
• Extensive experience in establishing the “Native” & “ODBC” connectivity to connect the multiple databases like SQL Server, Sybase and Oracle.
• Extensive experience in connecting IBM MQSeries via Informatica and developed complex mappings on top of it.
• Extensive experience in Installing and upgrading Informatica Data Quality and implementing Address Doctor.
• Experience in Disaster recovery by using multi level backup strategy.
• Experience in PowerExchange Change Data Capture and Bulk data Movement
• Strong experience in B2B transformation and DTSTudio. Expertise in Document Processors, Mappers, Serializers and Parsers.
• Has Administrator experience with IDE, B2B and IDQ.
• Has experience working with SSIS and SSAS.
• Experience in command line programs such as pmcmd, infacmd, infasetup and pmrep.
• Good understanding of Software Development Life Cycle (SDLC) and Project Life Cycle.
• Good Understanding knowledge of Ralph Kimball & Bill Inman Methodologies.
• Experienced with dimensional and relational database design.
• Good experience of working with process models like CMMi Level5 and SOX.
• Data Processing Experience in Designing and implementing Data Mart applications, mainly transformation Process using ETL tools like Informatica.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expert in implementing business rules by creating Re-Usable Transformations like Mapplets and Mappings
• Proficient in using Informatica Repository Manager to create & schedule sessions and batches.
• Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Experience in PL/SQL development and SQL Query Tuning for better performance.
• Good working knowledge on SQL*Loader for Bulk Loading.
• Proficient in Business Objects tools like Designer, Reporter, Supervisor, and Web intelligence.
• Good knowledge in Scheduling ETL Jobs tool like Autosys.
• Experience in UNIX shell scripting, CRON, FTP, SFTP and file management in various UNIX environments.
• Production support, handling new enhancements and customer support.
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives.
• Effective in cross-functional and global environments to manage multiple tasks & assignments concurrently.

TECHNICAL SKILLS

ETL Tools: Informatica 9.1/8.6.1/8.5.1/8.1.1/7.1.4/6.2 (PowerCenter/PowerMart), SQL Loader

Data Modeling: Star Schema, Snow-Flake Modeling, ERWIN 3.5

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005, DB2 UDB, MS Access 2000, Sybase .

Reporting tools: Business Objects XI R2, crystal reports 2008

Others: Toad 9.6, Autosys, HTML 4.0, DHTML, XML, SQL, PL/SQL, Unix Shell Scripting

Environment: AIX, UNIX HP-UX, Solaris, MS DOS 6.22, Win 2000/xp/2003

PROFESSIONAL EXPERIENCE

Confidential, Costa Mesa, California

Sr. Consultatnt

Responsibilities:

• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design
• Participated in data modeling (logical and physical) and STAR/Snow Schema for designing the Data Marts for finance, Sales
• Extensively working on Data Modelling tool Erwin to design the data models.
• Created the physical design of the data models and generate all database objects to the database.
• Perform data integration is based on a common metadata framework and the integrated data is presented to the business as valid information.
• Implemented a common platform for the federated data.
• Implemented the enhancements in the existing Enterprise Data warehouse.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Most of the transformations were used are Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence
• Pulled the data from SAP R3 and Powerexchange to existing data warehouse.
• Developed functional documents and Technical design documents for implementing Informatica web services
• Converted functional specifications into technical specifications (design of mapping documents)
• Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files (Fixed Width), XML and Excel files to staging database and from staging to the target Teradata and Oracle database

Confidential, Old Tappan, NJ

Data Architect and Informatica Administrator

Responsibilities:

• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design
• Participated in data modeling (logical and physical) and STAR/Snow Schema for designing the Data Marts for finance, Sales
• Connected to MQSeries server via Informatica and developed multiple complex mappings.
• Implemented Change Data Capture and Bulk Data Movement on DB2 using PowerExchange.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Most of the transformations were used like the Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence
• Developed functional documents and Technical design documents for implementing Informatica web services
• Converted functional specifications into technical specifications (design of mapping documents)
• Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files (Fixed Width), XML and Excel files to staging database and from staging to the target Teradata (MultiLoad FastLoad, Bteq) and Oracle database
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms
• Imported XML target definitions from an XML, DTD, and XML schema files
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Setting up Batches and sessions to schedule the loads at required frequency using AIX Shell scripts and Power Center Workflow manager
• Monitored the status of Workflows/Work lets/Sessions in Gantt chart and Task view mode using Workflow Monitor
• Used SQL tools like TOAD 9.6.1 to run SQL queries and validate the data in warehouse
• Involved in Unix Shell Scripts for automation of ETL process
• Error Handling: Handled in Informatica Mappings & sessions and also through Validation Scripts
• Involved in preparing Test script documentation for Load Testing and involved in ping tests conducted on servers from different theaters across the globe
• Participated in weekly end user meetings to discuss data quality, performance issues, ways to improve data accuracy and new requirements, etc.
• Environment: Informatica Power Center 9.1 HF3 (Designer, Repository Manager, Workflow Manager), Informatica Data Quality 9.1, Autosys Batch, Oracle 11gR2, Toad 9.6.1(Query Analyzer), PL/SQL, SQL, Business Objects XI, Actuate v11, XML, XSD, MS Visio, AIX 6.1, Windows Server 2003.
• Currently in process of POC to upgrade Informatica 9.1 to 9.5.1
• Installed and upgraded Informatica Powercenter starting from 6.x à8.x to 9.1 on AIX
• Installed and upgraded DataQuality 9.1 and implemented Address Doctor.
• Builded Integration Service, Model repository Service, Data Integration Service, Analyst Service and Content management services.
• Migrated B2B Transformation from 8.1 to 9.1.
• Actively involved in installing data quality contents from Informatica Site.
• Migrated the Informatica repository DB from AIX to virtual LINUX server.
• Performed mapping and workflow deployments from QA env to production.
• Involved in setting up Role based security and users access.
• Maintaining the informatica server by performing regular maintenance like Log purging, running stats on repository DB.
• Involved in configuring the Informatica server for each repository upgrade. Recently the OIracle DB of repository was upgraded from 9i to 11gR2.
• Perform testing after TL(Technology Level) and version upgrade of AIX servers.
• Setup the sybase connectivity via "Native Connectivity".
• Setup the SQL Server connectivity via ODBC
• Worked with Informatica Support to implement fix and workarounds against the bugs.
• Used Infasetupcmd, Infacmd command line utilities to perform maintenance like repository port change.
• Informatica License evaluation and adherence.
• Involved in the License and Usage audits conducted by Informatica.

Environment: Informatica PowerCenter 9.1/8.6.1/8.1 , Informatica DataQuality, Address Doctor, Oracle 11gR2

Confidential

Software Engineer

Responsibilities:

• Analyzing the source data and working with business users to develop the Model.
• Closely worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin.
• Extracted data from flat files and Oracle Database and applied business logic and loaded in to oracle Warehouse.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Powermart 6.1.
• Created reusable transformations and mapplets and used them in mappings.
• Performed mapping and workflow deployments from QA env to production.
• Involved in setting up Role based security and users access.
• Maintaining the informatica server by performing regular maintenance like Log purging, running stats on repository DB.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Documented technical design documents based on the BRD and SRS.

Environment: Informatica Powermart 6.1, Oracle 9i, Crystal reports 8,SQL, PL/SQL, XML, UNIX, Shell Script, Business Objects.

Confidential

Software Developer

Responsibilities:

• Was responsible for creating of PL/SQL Packages, procedures, cursors.
• Created complex Sql to test the data.
• Used Sql plus for spooling the huge tables to file’s for the end user’s.
• Writing PL/SQL code using the technical and functional specifications.
• Efficiently made use of Explain Plan and TKPROF utilities.
• Building the ETL architecture for Source to Target mapping to load data into Data warehouse.
• Designed ETL process flow for entire DWH application and developed data mapping spread sheets to define transformation rules for each stage of ETL process
• Coordinated with source system owners, monitored day-to-day ETL progress, performed Data warehouse target schema Design (Star Schema) and maintenance.
• Extensively used Workflow manager to create and schedule various Workflows and Worklets.
• Extensively used Erwin for data modeling and Dimensional Data Modeling.
• Worked on loading of data from several flat files sources.
• Designed and developed UNIX scripts as a Wrapper script as well as to implement Code.
• Designed and developed Informatica mappings for data loads.
• Performed Development, Test and Production mapping migration using Repository Manager.
• Also used Repository Manager to maintain the metadata, Security and Reporting. Tuned the Informatica Repository and Mappings for optimum performance.

Environment: Oracle 8i, Informatica Powermart 6.1 (Repository Manager,Admin Console, Designer, Workflow Manager, Workflow Monitor), Toad, SqlPlus, AIX, Shell Scripting, Perl scripting.