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, Insurance, Pharmacy, Banking and Health care Domains.
• Proven Experience in Complete life cycle of Design, Development, Documentation and Maintenance of teh 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 wif end users and understanding teh issues they face and try to resolve teh same. This includes enhancement to teh existing system, fixing teh issues in teh existing system or a new change.
• Mentoring teh team for any technical issues. Managing a team of 4 technical persons.
• Have also worked in an Onsite - Offshore model have carried out teh different phases of teh projects TEMPeffectively by excellent co-ordination activities.
• Tweaked teh complete ETL system by collecting performance data, optimizing default session parameters, used various Performance Tuning methods on teh 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 teh Analysis, design and Data Modeling.
• Parsed teh 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 teh 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 teh team of 4 technical persons for any technical issues, enhancement to teh existing system, fixing teh issues in teh existing system or new changes.
• Designed multi dimensional Star schema, Generated teh 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 teh Business requirement specifications and Functional specifications by directly interacting wif teh 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 teh OBIEE metadata repository (.RPD) using OBIEE Server Admin tool by importing required objects (Dimensions, Facts,Aggregations) wif integrity constraints into physical layer using connection pool, developing multiple dimensions and logical and facts/ Measures objects in business model layer, and creating teh 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 wif 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 teh users reporting needs and requirements
• Communicating wif business users to resolve their issues, follow-up wif users and team to resolve teh issues.
• Designed multi dimensional Star schema, Generated teh database scripts, E-R diagrams using ERWIN.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction wif backend database using PL/SQL.
• Used Power Exchange to access VSAM, IMS data stored on teh mainframe systems
• Collaborate wif teh Data Warehouse team to design and develop required ETL processes and Created technical design specifications for teh ETL programs.
• Performance tunining, Maintenance and enhancements of ETL programs and scripts.
• Developing teh maplets, worklets, reusable transformations and shortcut objects.

EnvironmentInformatica - 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 teh 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 teh Data Cleaning and Scrubbing and implementing teh 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 teh 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 teh Informatica tools and connected wif each database in Data Warehouse using ODBC network layer.
• Deploying teh 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 wif teh team members and teh Enterprise Data Management Team.
• Developing teh 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 teh 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 wif teh Business and teh Data Analyst, Vendors and IT Data Integration team to gather requirements and analyze teh 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 teh 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 teh 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 teh 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 teh applications and transported teh data to teh 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 teh information to be loaded into teh data warehouse.
• Informatica Power Connect for Mainframe and this allowed us to read/write VSAM files from/to teh 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 teh 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 teh repositories of various applications.
• Wrote COBOL programs, copybooks and JCL to extract teh information to be loaded into teh 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 teh daily maintenance operation of teh Database like backup procedures, checking teh space allocations and table space analysis
• Checked and tuned teh performance of application
• Designed multi dimensional Star schema, Generated teh database scripts, E-R diagrams using ERWIN.
• Participated wif teh Data Architect in teh dimensional modeling of teh Market Quality Data warehouse
• Involved in teh creation of universes for teh data warehouse project.
• Generated reports of Multidimensional analysis, slice and dice and drill down reports.
• Involved in teh configuration of Business Objects for 2 tier and 3-tier architecture using Webi Server.
• As Business Objects Administrator, worked extensively wif Supervisor module in teh 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

ETL (Informatica) Developer

Confidential, New Jersey

Responsibilities:

• Complete responsibility for prototype of Pharmacy and Laboratory subject areasData Modeling, Data Staging Plan and Data Quality Plan
• Responsible for loading data into warehouse from different sources using SQL Loader, Developing SQL*LOADER scripts to load data from flat files into Oracle work tables.
• Develop PL/SQL packages to extract incremental data from worktables into teh final tables. Used PL/SQL extensively in creating procedures and batch programs.
• Responsible for Extraction Transformation and Loading of data into warehouse from various database systems using procedures and massaging of data using shell scripting regular expressions.
• Identified bugs in existing mappings by analyzing teh data flow, evaluating transformations and fixing teh bugs so that they conform to teh business needs and redesign teh existing mappings for improving teh performance
• Responsible for interacting wif business partners to identify information needs and business requirements for reports.
• Duties include installation, configuration, security access, training and support of internal users.

Environment Informatica - Power Center 5.x/4.7, Oracle 8.x, SQL, PL/SQL, DB2, UNIX Shell Script, SQL*Loader, Business Objects - (Supervisor, Designer, BO Reports), Erwin3.5, Windows NT/2000,Unix

Informatica Developer

Confidential, Columbus, OH.

Responsibilities:

• Gather Requirements from Business Users for Converters.
• Analyzing teh existing teh converters in COBOL, PLI and Assembly language and prepare teh Mapping document for teh respective ETL converters.
• Developed teh source to target mapping for teh ETL processes using Informatica 5.1
• Conduct Unit testing and assist teh Testing team on any issue during teh regression testing
• Help teh team on any issues related to Mainframe and Informatica
• Prepared teh mapping document and template for Test scripts.
• Analyze teh legacy system to assist teh Business Users on New source requirement preparation.
• Worked on Business Objects reports like drill down reports, master detail reports

Environment Informatica - Power Center 5.x/4.7, Oracle 8.x, SQL, PL/SQL, DB2, UNIX Shell Script, SQL*Loader, Business Objects - (Supervisor, Designer, BO Reports), Erwin3.5, Windows NT/2000,Unix