SUMMARY

• Over 7 Years of IT experience with more than 5 years in Designing, Development and Implementation of Data Warehouses & Data Marts with Informatica Power Center 8.x/7.x/6.x/5.x as an ETL tool.
• Extensive experience in all areas of Project Life Cycle including requirements, analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
• Strong working experience on DSS (Decision Support Systems) applications, directly responsible for the Extraction, Transformation and Load (ETL) of data from Legacy Systems usingInformatica.
• Worked extensively with complex mappings using Expressions, Joiners, Routers, Lookups, Update strategy, Source Qualifiers and Aggregators to develop and load data into different target types.
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and Sessions using Informatica Power Center.
• Experienceinprogramming with SQL and PL/SQL (Stored Procedures, Stored Functions, Cursors, and Database Triggers).
• Worked extensively with debugging and tuning of ETL processes to improve the overall performance. Experience in writing Unit test plans and Unit testing.
• Experience in Oracle and other Utilities/tools: TOAD, UNIX Shell Scripting, SQL*Loader.
• Hands on experience in Star schema and Snowflake schema design and Denormalization techniques.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Extensive experience in error handling and problem fixing in Informatica.
• Involved in Relational database design and development of data warehouse data feeds.
• Very strong in Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying. Experience in writing stored procedures (PL/SQL) and triggers using Oracle. Extensive experience in developing logical and physical models and implementing them in Erwin.
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries.
• Understanding in writing Test plans, Test cases, Unit testing, System testing, Integration testing and Functional testing.
• Extensively worked on various databases including Oracle 11g/10g/9i/8i, DB2, SQL Server 2005/2008.
• Possess excellent communication and interpersonal skills withability to work independently and as part of a team.

TECHNICAL SKILLS

Informatica Power Center 8.6.1/8.1.1/7.1.1/7.1.2/7.0/6.1.

Languages

PL/SQL, SQL, T-SQL, Shell Programming, Java.

RDBMS

Oracle 11g/10g/9i/8i, DB2, MS Access, SQL Server.

Database tools

SQL*PLUS, SQL*Loader, TOAD, SQL Navigator

Hardware

Sun SPARC, IBM PC/AT/XT, Intel Pentium PC

Operating Systems

Windows XP, Windows NT, Windows Server, Unix, MS-DOS

Reporting tools

Siebel Analytics 7.7, OBIEE 10.1.3

Web Development Tools

HTML, XML

EDUCATION

• Bachelor of Science
• Master of Science

Confidential, Colorado Springs, CO Apr 2010 Sept 2011
Position: ETL/Informatica Database Consultant
Confidential, provides many services such as Wireless/Mobile and video on demand to its customers. This product enables the customer to view the desired program at any time. This Project was developed to maintain the data of viewing history. The data comes from different divisions daily and maintained in the form of Incremental history in Data Mart using Informatica. Weekly and Monthly reports are given to the business users according to their requirements. Process includes providing Summary level reports to the users. Requirement was to automate the whole process of pulling data from Source, processing it through Informatica, separate the good and error records maintain incremental history of the good data and send the error records back to division for correction process.
Responsibilities:

• Involved in the complete lifecycle of the Data Warehouse creation starting from requirements gathering to putting the product into production.
• Involved in designing the data mart and creating the necessary facts and dimensions accordingly. Created constraints and indexes as per the requirement.
• Worked extensively with flat file sources, CSV sources and Oracle sources.
• Extensively used shell scripting for FTP of files, renaming the files, etc. Wrote scripts to run workflows using pmcmd command from the UNIX server.
• Extensively worked with Aggregator, Sorter, Lookup, Router, Expression, Filter, Update Strategy, and Stored Procedure transformations.
• Created reusable transformations and mapplets for better re-usability.
• Created reusable sessions and workflows and extensively used parameter files and variables.
• After development, performed extensive unit testing to check the proper and timely flow of data. Performed tuning of sessions by monitoring the cache size of the transformations.
• Once the development is complete, performed migration of the objects from development environment to the production environment. Migration of all the objects from development to production repository, and the scripts from development to production UNIX server.
• Performed production support after the project went live into production.
• Documented all the development work in the format as per the requirement.
• Used Informatica features to implement Type I and II changes in slowly changing dimension tables
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger
• Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise and Email Task, Scheduled Task and Workflow based on Client requirement.
• Worked with tables, indexes, constraints, views and synonyms
• Created functions, procedures and triggers in PL/SQL
• Participated in reconciling data drawn from multiple systems across the company like Oracle 10g, Oracle9i, andflat files into Oracle data warehouse
• Created and maintained various project related documents like high level design documents etc.
• Created, executed and documented associated test cases
• Reviewed the deliverables of peer group
• Performed troubleshooting and bug fixing in the mappings.
• Worked in production support.

Environment: Informatica Power Center 8.6.1/8.1.1/7.1, Oracle11g/10g/9i, PL/SQL, SQL*Plus, TOAD 9.01.8, Windows NT 4.0, UNIX.

Confidential, NYC, NY
Jul 2009 Mar 2010
Position: ETL/Informatica Consultant
Media Brands is action-oriented, entrepreneurial force, determined to re-invent the business of modern day media and marketing. My duties mainly involved design and development Databases and ETL applications.
Responsibilities:

• Involved in designing and development of data warehouse environment.
• Responsible for data modeling using Erwin 4.x.
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
• Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager, Repository Manager and Workflow Monitor.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using Pmcmd on Unix Environment. Conversant with the Informatica API calls.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Partitioned sources to improve session performance.
• Extensively worked on Unix Shell Scripting, using pmcmd to automate the process by Autosys on UNIX environment.
• Created flexible mappings/sessions using parameters and variables and heavily using parameter files.
• Improved session run times by partitioning the sessions. Was also involved heavily into database fine tuning (creating indexes, stored procedures, etc), partitioning oracle databases.

Environment: Informatica Power Center 8.1/8.6, Oracle 9i/10g, PL/SQL, SQL*Plus, SQL Server, SQL*Loader, Windows 2008.

Confidential, HORSHAM, PA
Jun 2008 May 2009
Position: Informatica Consultant
Confidential, is a Fortune 500 company. It has many business units. The Data center at Horsham, Pennsylvania maintains the databases of these business units. It is desired to develop e-commerce site, through which automobile parts dealer can sell his product.
Responsibilities:

• Involved in Data Mart development.
• Used database objects like Views, Partitioning and Stored Procedures for accomplishing the Complex logical situations.
• Loading data from Flat Files into the Staging area using Informatica Power Center 6.1.
• Using Informatica Designer designed Mappings that populated the Data into the target Star Schema on Oracle 8i Instance.
• Extensively used Router, Lookup, Aggregator, Expression and Update Strategy Transformations.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Created stored procedures for loading of data into data mart using Informatica on weekly and monthly basis.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Repository migration from development to production environment.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Involved in writing batch files to automate Pre-Session and Post-Sessions Processes
• Performed end to end testing of load from source to target.
• Wrote Unix Shell Scripts to automate the processes.
• Interacted with Management and Development teams to gather Business requirements for new models.

Environment: Informatica PowerCenter 8.1/8.5, SQL*Plus, SQL*Loader, Erwin 3.5, SQL Server, TOAD, HTML, MS Access, MS Excel, UNIX, and Windows2K.

Confidential, Seattle, WA June 2007 May 2008
Position: Informatica Developer
Life Insurance is an OLTP systemwhich stores the customer information regarding members and their payments and policies. The repository was running on Oracle with a web based Java/J2EE as front-end. My responsibilities included getting the requirements from the Customer Service and Claims Department and develop the Data warehouse as per the requirements and database administration.
Responsibilities:

• Analyzed the specifications and business requirements with business associates.
• Extensively coded the functions and stored procedures in Oracle.
• Involved in maintaining Data Quality & Ensuring Intra modular Data integrity.
• Created Dimensional models from 3NF schema for Data Extraction in the Warehouse.
• Integrated various application modules to create robust Data Marts for efficient query processing.
• Involved in designing the process for getting the data from various sources like Flat Files, Oracle to Data Warehousing system.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Lookup, Aggregator, Sequence Generator, Joiner and other transformations used in this populating data process.
• Used Debugger to view data flow and edit transformations output and debugging mappings.
• Implemented type 2 dimensions. Extensively used Dynamic lookup to implement the type 2 changes.
• Tuned Informatica Mappings and Sessions for optimum performance.
• Interacting with User groups/ Corporate Testing Group / Business people and production support.

Environment: Informatica PowerCenter8.1, Oracle10g, TOAD, SQL*Plus and Windows XP.

Confidential, Pune, India
Mar 2005 Apr 2006
Position: Data Warehouse Developer

Responsibilities:

• Gathered requirements from Client and analyzed the specifications.
• Create logical structure of the database using ER modeling and normalization techniques, prepared source-to-target mappings.
• Data extraction, validating and loading using SQL*Loader, database links.
• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Worked on Informatica power center tool Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data warehouse.
• Accomplished automated data extraction from various RDBMS via scripts, ETL processing using Informatica and loading into Data Mart.
• Developed complex mappings in Informatica Power Center to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
• Develop PL/SQL packages and stored procedures and functions to cleanse, transform, massage and preserve data integrity in the data warehouse
• Implement Oracle Data Replication using Snapshots to build Enterprise MIS database. Three MIS databases from three different locations were linked via database links to one Enterprise MIS database using fast refresh method.
• Schedule Oracle jobs using DBMS_JOB package for populating the staging tables across the database links for HR database.

Confidential,India
May 2004 Mar 2005
Position: Oracle Developer
Confidential, is a leading provider of integrated multi modal logistics services for all types of cargo both on sea and land across the globe. Responsible for System analysis, understanding of business requirements, expertise in understanding the complete information flow, database concepts, Normalization and creation of Database objects.
Responsibilities:

• Worked on various backend Procedures and Functions using PL/SQL
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created and customized various Database Triggers using PL/SQL
• Perform logical and Physical design of the database.
• Exception handling and cursor management in PL/SQL
• Coded triggers at various levels for cascading functionality, cross checking and for referential integrity.
• Used entity relationship and Normalization techniques.

Environment: Oracle 8i, Toad, SQL*Plus, PL/SQL, Windows NT.