SUMMARY

• Over 16 years of IT experience in Various RDBMS, Data warehousing/ETL, OLAP Tools and Client Server applications.
• 14 years of Hands - on experience in Data warehousing, ETL, applications using Informatica (Power center/Power Mart)
• Solid experience in Informatica Power Center (versions 9.5/8.6/ 7.1/5.1 ) including Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console and Teradata
• Expertise in Oracle 10g/9i/8i/7.x, PL/SQL, Functions, Procedures, Packages, Triggers, Materialized Views.
• 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
• Worked on Data Modeling, E-R diagrams, Logical, Physical design, Star/Snow flake Schemas using Erwin
• Proven Experience in Complete life cycle of Design, Development, Documentation and Maintenance of the Data marts and Data warehouse.
• Mentoring the team for any technical issues. Managing a team of 4 technical persons.
• 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.

TECHNICAL SKILLS

Informatica Tools: Power Center, Power Mart, 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, SSIS,DTS, 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/XP/8.0 and Unix (IBM AIX, HP-UX, Sun Solaris)

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Technical Lead ETL/Informatica Developer

Responsibilities:

• Participated in meetings responsible for Business Analysis and Requirements Collection.
• Used Informatica to migrate Sim Corp data from oracle database to Flat Files which are used as Staging Files.
• Extensively used Informatica to load data fromSAM Operation System,Enterprise Master DataandTransaction Datato Oracle database SAM Datamart.
• Designed Informatica mappingsto publish daily and monthly events files via ESB to be consumed by downstream systems, and to be used for transformation into legacy ECF file format.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, XML transformation, Update Strategy and Joiner transformations.
• Created Documents such as Technical Systems Design, Source-To-Target Data mapping Document, Backroom Services Document, Metrics for ETL documents, Unit Test Cases and Migration Documents for Production support.
• Created mapplets to grab error logging information useful for process management and auditing.
• Maintained naming standards and warehouse standards for future application development.
• Developed test plans and test cases at various interfaces of the project.
• Migrated mappings, sessions and workflows from development environment to test environment.
• Assisted in creating and manage daily and monthly data operations and schedule processes.
• Designed Informatica workflows and mappings for optimal performance in a large scale Unix/RDBMS environment. Tuned Informatica workflows for better performance.

Environment: Informatica Power Center 9.5, Oracle 10g, Flat Files, XML, Unix, AIX, Autosys.

Confidential, Washington, DC

Technical Lead ETL/Informatica Developer

Responsibilities:

• Extensively involved in the Analysis, design and Data Modeling.Coordinated with Data modeler to create Star Schema data model design using Erwin.
• Developed ETL procedures to ensure conformity, compliance with CareFirst standards
• Created Migration Documentation and Process Flow for mappings and sessions.
• Developed the transformation logic; identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• 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 Informatica server administration automation scripts, shell scripts for data manipulation and process automation using UNIX shell scripting.
• Developed Shell Scripts which take care of truncate table, Archival the source and the target files and Clean up the log files
• Worked extensively on Flat Files, as the data from various Legacy Systems parsed the Functional specifications into a Technical document, which would provide an efficient platform for peers for development.
• Mentored 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.
• 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.5/8.6, Oracle 11g, DB2, SQL Server,Shell Scripts, Autosys, Power Exchange,Business Objects, Erwin, Windows 7, Unix (AIX)

Confidential, Jersey City, NJ

Lead ETL/Informatica Developer

Responsibilities:

• Analyzing business processes, functions, existing transactional database schemas and designing star schema models to support the users reporting needs and requirements
• Converting the Business rules into Technical Specifications for ETL process
• Created Conceptual data model by gathering the business requirements from various sources like discussion with functional teams, business analysts and from business documents
• Involved in Logical and Physical data models that capture current/future state data elements and data flows using Erwin.
• Used SQL * Loader to load the data from Flat files to Oracle for Common Dashboard system.
• Developed complex aggregate, join, look up, filter, router transformation logic to generate consolidated data needed.
• Worked extensively on Flat Files, as the data from various Legacy Systems is flat files.
• Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations
• Designed and optimized moderate to complex Initial load to populate SCD Type-2 using date format.
• Created mapplets using Mapplet Designer and used those Mapplets for reusable business process in development.
• Created re-usable transformations and Worklets.
• Improved the session performance by pipeline partitioning.
• Generated Unit and integration Test Plans and related documents
• Created Workflows in the Workflow designer and executed tasks such as Sessions, Commands, etc. And Monitored transformation processes using Workflow monitor
• Involved in performance tuning of the Informatica mapping and identifying the bottlenecks.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Used Shell script and Perl script to audit check on the flat files before loading the data into data mart

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

Confidential, Pittsburgh, PA

Sr. ETL/Informatica Developer

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.
• Designing automation of ETL jobs using Informatica batches and Pre-Session and Post-Session UNIX scripts using Korn shell scripting in VI editor.
• 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.
• 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)

Confidential, Connecticut

Sr. Informatica Developer

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 back-end 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 tuning, 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 Scripts, Autosys, Power Exchange,, Business Objects XI, Erwin, Windows XP, Unix (AIX)

Confidential, Chicago, IL

Sr. Informatica Developer

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 Scripts, Autosys, Business Objects, Erwin, Windows XP, Unix (AIX)

Confidential, Chicago, IL

Sr. Informatica Admin/Developer

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 Scripts, Crontab, Business Objects, Data Analyzer, Windows XP, Unix (AIX)

Confidential, Boston, MA

Sr. Informatica Developer

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

Confidential, Michigan

Sr. Informatica Developer

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 8x, MS SQL Server, Siebel, VSAM, MVS, ETI, File-Aid, Business Objects, Erwin 4.0, Striva Detail-Navigator, Windows 2000/XP, Solaris 5.6

Confidential, Cleveland, Ohio

ETL (Informatica) Developer

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.
• 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 8x, DB2, ETI, File-Aid, PL/SQL, UNIX Shell Scripts, Business Objects, UNIX Shell Scrips, Windows NT/2000, HP UX