SUMMARY:

• 12 years of IT experience in Various RDBMS, Data warehousing/ETL, OLAP Tools and Client Server applications.
• Over 10 years of Hands - on experience in Data warehousing, ETL, applications using Informatica (Power center/Power Mart)
• Solid experience in Informatica Power Center (versions 8.6/8.1/ 7.1/ 6.1/5.1 ) including Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console.
• Expertise in Oracle 10g/9i/8i/7.x, PL/SQL, Functions, Procedures, Packages, Triggers, Materialized Views.
• Worked on Data Modeling, E-R diagrams, Logical, Physical design, Star/Snow flake Schemas using Erwin
• Expertise in Administration, Developing, Implementing and Executing a project in Finance, Confidential, Pharmacy, Banking and Health care Domains.
• Proven Experience in Complete life cycle of Design, Development, Documentation and Maintenance of the Data marts and Data warehouse.
• Wrote Unix shell scripts for executing PL/SQL code, Informatica Jobs, backup, data analysis by using korn shell. Used pmcmd, pmrep, infacmd commands in scripts
• Following up with end users and understanding the issues they face and try to resolve the same. This includes enhancement to the existing system, fixing the issues in the existing system or a new change.
• Mentoring the team for any technical issues. Managing a team of 4 technical persons.
• Have also worked in an Onsite - Offshore model have carried out the different phases of the projects effectively by excellent co-ordination activities.
• Tweaked the complete ETL system by collecting performance data, optimizing default session parameters, used various Performance Tuning methods on the source, target, mapping and session.
• Microsoft Certified Professional in SQL Server
• Expertise in OLAP and Reporting tools like Brio, Business Objects and Cognos.
• Team player and self-starter, capable of working independently and motivate a team of professional.

TECHNICAL SKILLS:

Informatica Tools: Power Center, Power Mart, Power Connect/ Power Exchange, Power Analyzer, Complex data Exchange (CDE), Data profiling.

Database: Oracle, SQL Server, DB2, Siebel EIM and Teradata

Business Intelligence Tools: Brio, Business Objects, Cognos, OBIEE and Crystal reports

Oracle Tools: SQL*Plus, SQL*Loader, TOAD

Methodologies: STAR Schema, Snowflake Schema

Other Tools: VISIO, ERWIN, FirstLogic, FILE: AID, ETI, AutoSys, Cron, Control-M

Programming Languages: Unix, Shell Scripts, Perl, SQL, PL/SQL, C, C++, XML, VB, ASP, JCL, PL/I.

Operating System: Windows NT/2000/XP and Unix (IBM AIX, HP-UX, Sun Solaris)

PROFESSIONAL EXPERIENCE:

Sr. ETL Developer /Informatica Developer

Confidential, Jersey City, NJ

Responsibilities:

• Extensively involved in the Analysis, design and Data Modeling.
• Parsed the Functional specifications into a Technical document, which would provide an efficient platform for peers for development.
• Developed complex ETL Mappings and Maplets in Informatica to load data from various sources to Data warehouse. These mappings include the various transformations like Source Qualifier, Look up, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Mentoring the team of 4 technical persons for any technical issues, enhancement to the existing system, fixing the issues in the existing system or new changes.
• Designed multi dimensional Star schema, Generated the database scripts, E-R diagrams using ERWIN.
• Generated server side PL/SQL scripts for data manipulation, validation and provided DDL scripts for creation of database objects such as tables, indexes, views, sequences, object types, collection types and Materialized Views.
• Creating Informatica server administration automation scripts, shell scripts for data manipulation and process automation using UNIX shell scripting.
• Generated reports of Multidimensional analysis, slice and dice and drill down reports.
• Created, Scheduled and Monitored Batches and Sessions using Power Center Server Manager/AutoSys/Crontab

Environment: Informatica - Power Center 9.1/8.6, Oracle 11g, DB2, Netezza, SQL Server, UNIX Shell Scripts, AutoSys, Power Exchange, Oracle Mantas 5.8,Business Objects, Erwin, Windows 7, Unix (AIX)

Sr. ETL/Informatica Developer

Confidential

Responsibilities:

• Took part in JAD sessions to define the Business requirement specifications and Functional specifications by directly interacting with the users and proposing corresponding deliverables.
• Designed and created scripts for objects such as tables, indexes,views,sequences, object types and collection types.
• Used changed data capture type mappings to load slowly changing Type 1, 2 and 3 dimensions.
• Scheduled and executed sessions, sequential and concurrent batches for proper execution of mappings; sent notification e-mails using Server Manager.
• Designing automation of ETL jobs using Informatica batches and Pre-Session and Post-Session UNIX scripts using Korn shell scripting in VI editor.
• Extensively used Power Center command line utilities such as pmcmd, Pmrep embedded in shell scripts to perform various administrative tasks such as migrations, repository backup scripts, start/stop scripts, statistics collections etc.
• Tuned inefficient queries using combinations of index creation, alternate indexing strategies,join strategies and query level optimization hints
• Designed and developed the OBIEE metadata repository (.RPD) using OBIEE Server Admin tool by importing required objects (Dimensions, Facts,Aggregations) with integrity constraints into physical layer using connection pool, developing multiple dimensions and logical and facts/ Measures objects in business model layer, and creating the presentation catalogs in presentation layer.
• Developed OBIEE Repository at three layers (Physical, Business model and Presentation Layers), Interactive Dashboards and drill down capabilities using global and Filters and Security Setups.
• Developed many reports/dashboards with different analytic views(Pivot table, charts, Column selectors, view selectors)

Environment: Informatica - Power Center 8.6, Oracle 11g, DB2, SQL Server, UNIX Shell Scripts, AutoSys, Power Exchange, OBIEE, Erwin, Windows 7, Unix (AIX)

Sr. Informatica Developer

Confidential

Responsibilities:

• Analyzing business processes, functions, existing transactional database schemas and designing star schema models to support the users reporting needs and requirements
• Communicating with business users to resolve their issues, follow-up with users and team to resolve the issues.
• Designed multi dimensional Star schema, Generated the database scripts, E-R diagrams using ERWIN.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
• Used Power Exchange to access VSAM, IMS data stored on the mainframe systems
• Collaborate with the Data Warehouse team to design and develop required ETL processes and Created technical design specifications for the ETL programs.
• Performance tunining, Maintenance and enhancements of ETL programs and scripts.
• Developing the maplets, worklets, reusable transformations and shortcut objects.

Environment: Informatica - Power Center 8.6, Oracle 11g, DB2, IMS Data, UNIX Shell Script, AutoSys, Power Exchange, Business Objects XI, Erwin, Windows XP, Unix (AIX)

Sr. Informatica Developer

Confidential, Chicago, IL

Responsibilities:

• Developed the detailed database design document which included data dictionary, data estimates, entity relationship (ER) diagrams, dimensional model (Snowflake schema) using Erwin, MS Office and MS Visio
• Migrated data mappings to production and monitoring, troubleshooting and restarting batches.
• Developing UNIX korn shell scripts for data manipulation and process automation.
• Developed separate mappings for the Data Cleaning and Scrubbing and implementing the Data warehousing Standards.
• Starting Sessions and Batches and make Event based scheduling using Informatica Power Center Server Manager.
• Generated server side PL/SQL scripts for data manipulation,validation and provided DDL scripts for creation of database objects such as tables,indexes,views,sequences,object types, collection types and Materialized Views.
• Implementing the complex business rules by creating transformations, filter, Expression, Lookup, Joiner, Sequence generator transformation.
• Performed Informatica server administration tasks such as stopping/starting Informatica Repository and Server processes, performing code migration from Dev to Test, backup and restoring of Informatica Repository, upgrades and security administration.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Designed Business Objects reports to have drill down, drill up and drill across functionality.

Environment: Informatica - Power Center 7.1/8.1, Oracle 10g, DB2,SQL Server, UNIX Shell Script, AutoSys, Business Objects, Erwin, Windows XP, Unix (AIX)

Sr. Informatica Admin/Developer

Confidential, Chicago, IL

Responsibilities:

• Installed and Configured the Informatica tools and connected with each database in Data Warehouse using ODBC network layer.
• Deploying the code between different environments like DEV, Model and Production.
• Creating Informatica server administration automation scripts using UNIX shell scripting.
• Conducted multiple design reviews and approval meetings along with the team members and the Enterprise Data Management Team.
• Developing the best practices for Informatica server administration, UNIX directory structures, and migration procedures from dev to test, test to prod environments
• Performance tuning of Informatica Server, designer and workflow objects
• Writing shell scripts to automate data transmission and data load into warehouse
• Developing the Sarbanes-Oxley (SOX) Act Compliance ETL environment, Project Folder structures, Security standards, error-handling procedures and alert system
• Developed mappings using several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, Sequence Generator Transformations, Stored Procedure Transformations and Expression Transformations in Informatica.
• Repository administration such as creating repositories, folders, managing groups, users, and security.
• Created, Scheduled and Monitored Batches and Sessions using Power Center Server Manager/AutoSys/Crontab.

Environment: Informatica - Power Center 7.13, Oracle 9i, DB2, SQL Server, Flat Files, UNIX Shell Script, Crontab, Business Objects, Data Analyzer, Erwin, Windows XP, Unix

Sr. Informatica Developer

Confidential, Boston, MA.

Responsibilities:

• Worked with the Business and the Data Analyst, Vendors and IT Data Integration team to gather requirements and analyze the business needs.
• Designed system using Star and Snowflake schema using dimensional modeling for various data Marts that involved various fact tables and multiple dimensions.
• Using Informatica Repository Manager, maintained all the repositories of various applications, created users, user groups, security access control.
• Worked on Workflow Manager Tools - Task Developer, Workflow & Work let Designer.
• Extracted data from source systems to a staging database running on
• Teradata using utilities like MultiLoad and Fast Load.
• Writing Unix Shell scripts and Batch file for NT environment to automate loading process, Schedule them at Crontab, and notified the success / failure to users.
• Involved in extraction of data from Teradata and writing to flat files using BTEQ and loading data into Teradata from flat files using Multiload.
• Extensively used Informatica to load data from Oracle, DB2 and Flat Files to Oracle.

Environment: Informatica- Power Center 7.1/6.2- Teradata, PMCMD, PowerConnect, DB2, TOAD, PL/SQL, PL/I, SQL*Loader, UNIX Shell Script, Business Objects, Visio 5.0, Windows 2000/XP, Solaris 5.7/5.8.

Senior Informatica Developer

Confidential, MI.

Responsibilities:

• Reverse Engineered COBOL VSAM files including occur, redefines, and packed fields, multi-record structures formatted to Informatica standards.
• Transforming data using the following Informatica Power Center transformations:
• Source Qualifier, Normalizer, Expression, Aggregator, Filter, Rank, Update Strategy, Lookup, Stored Procedure, Sequence Generator, Joiner.
• Creating Oracle Packages and Stored Procedures, Functions, Triggers.
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica Server Manager.
• Wrote COBOL programs, copybooks and JCL to extract the information to be loaded into the data warehouse.
• Informatica Power Connect for Mainframe and this allowed us to read/write VSAM files from/to the mainframe.
• Using Informatica Power Connect for Siebel to extract and integrate customer relationship management (CRM) data stored in Siebel.
• Data mapping from VSAM to ORACLE tables using Informatica.
• Developed Documentation and Process Flow for mappings and sessions.
• Presentation of the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.
• Created new business requests by developing Informatica mappings and PL/SQL code.
• Design, partition and size new tables, allocate their storages. Determine and size their indexes, keys and constraints. Schedule analysis for cost based optimizer.

Environment: Informatica-Power Center 5.1, TOAD, Oracle 8.x, MS SQL Server, Siebel, VSAM, MVS, ETI, File-Aid, Business Objects, ERwin4.0, Striva Detail-Navigator, Windows 2000/XP, Solaris 5.6

ETL (Informatica) Developer

Confidential, OHIO.

Responsibilities:

• Used Informatica Repository Manager to maintain all the repositories of various applications.
• Wrote COBOL programs, copybooks and JCL to extract the information to be loaded into the data warehouse.
• Design and Development of pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Written Shell scripts for the daily maintenance operation of the Database like backup procedures, checking the space allocations and table space analysis
• Checked and tuned the performance of application
• Designed multi dimensional Star schema, Generated the database scripts, E-R diagrams using ERWIN.
• Participated with the Data Architect in the dimensional modeling of the Market Quality Data warehouse
• Involved in the creation of universes for the data warehouse project.
• Generated reports of Multidimensional analysis, slice and dice and drill down reports.
• Involved in the configuration of Business Objects for 2 tier and 3-tier architecture using Webi Server.
• As Business Objects Administrator, worked extensively with Supervisor module in the process of controlling universe, restricting objects and data to universes and profile management.
• Worked extensively on Business Administration, optimization of universes and SQL Query, performance and tuning.

Environment: Informatica- Power Center, Oracle 8.x, DB2, ETI, File-Aid, PL/SQL, Business Objects, UNIX Shell Script, Windows NT/2000, HP UX