SUMMARY

• Eight plus (9+) years of experience in the IT industry with skills in analysis, design, development and implementation of various projects using Object Oriented Analysis, Design and Methodologies. Worked extensively with Various Verticals viz., Insurance, Finance, HealthCare and Pharma.
• 6 years of Data Architecture & Data modeling experience in Dimension Data Modeling, Erwin Modeling (CA Erwin 4.5/4.0/3.5.5/3.5.2 ), Star Join Schema Modeling, Snowflake modeling, FACT and Dimensions tables, Physical and logical data modeling, Erwin 4.5/4.0/3.5/3.0 , Oracle Designer.
• Four Plus (4+) years of experience in Data warehousing, Data Architecture & Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center 7.x/6.x/5.x/4.x (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplets Designer, Mapping Designer, Repository manager and Informatica server), Informatica PowerMart 6.2/6.1/5.1/4.7 , ETL, Power Analyzer, Power Connect, Power Exchange OLTP, OLAP, Data Reports, Oracle Report Writer, Autosys, Control M, Crontab.
• Four Plus (4+) years of experience in Business Intelligence tools like ), Business Objects 6.5/6.0/5.1, Web Intelligence 2.5, Business Objects Designer, Business Objects Developer Suite (Broadcast Agent, Supervisor, Designer, Info View), Business Object Universe Developer, Business Objects Set Analyzer 2.0, Business Objects Reporting, Cognos Impromptu 7.0, Cognos Transformer, Cognos Power Play (Cognos Series 7 and Cognos 6.x.
• Eight plus (8+) years of experience using Oracle 9i/8i/7i, Oracle Report Writer, SQL, PL/SQL, SQL*Plus, SQL*Loader, IBM DB2 8.0/7.0, MS SQL Server 6.5/7.0.2000 , Teradata V2R5/V2R4, MS Access 2000, Developer 2000, Windows 95/98/2000/XP, Win NT 4.0 and Sun Solaris.
• Experienced in loader utilities including SQL Loader and Teradata TPump, Fast Load and MultiLoad. Good knowledge in data migration from Oracle to Teradata RDBMS. Experienced in PL/SQL scripts and extensively used bulk collect concept. Experienced in UNIX shell scripting and in VI.

TECHNICAL SKILLS

Data warehousing, ETL: Informatica PowerCenter 7.1/7.0/6.2/5.1/4.7 , PowerMart 6.2/5.1/4.7, PowerConnect for SAP/Peopesoft/DB2/Siebel, (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server) PowerConnect, PowerPlug 3.0, PowerAnalyzer, PowerExchange, ETL, Data Mining, Data mart, OLAP, OLTP, CA Autosys, BMC Control M, Crontab

Data Modeling, Data Architecture: ERwin 4.5/4.0/3.5/3.0 , Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Dimensional Data Modeling(Star Schema Modeling, SnowFlake Schema Modeling, FACT and Dimensions Tables), Entities, Attributes, Cardinality, Oracle Designer 2000

BI & Reporting: Business Objects 6.5/6.0/5.1/5.0 (Web - Intelligence 2.5, Designer 5.0, Developer Suite & Set Analyzer 2.0), Power Play Enterprise Server, Transformer, BO Designer, BO Developer Suite 6.0/5.0 (Broadcast Agent, Designer, Info View, Web Intelligence, Supervisor, Module). Cognos Series 7.0/6.0, Impromptu Web Reports (IWR), Cognos Transformer, Cognos Power Play (Cognos Series 7 and Cognos 6.x), Data Reports.

Databases: Oracle 9i/8i/7.3, MS SQL Server 2000/7.0/6.5 , IBM DB2 UDB 8.0/7.0/6.0/5.0 , DB2/400, Teradata V2R5/V2R4/V2R3, Sybase 12.0/11.x,SQL*Loader, MS Access 7.0/97/2000.

Environment: UNIX (Sun Solaris 2.6/2.7, HP-UX, IBM AIX 4.2/4.3), Novell NetWare 4.11/3.61, Windows 2003/2000/XP/98, Sun-Ultra, Sun-Spark, Sun Classic, SCO Unix, HP9000, RS6000, Compaq Tru64, OS/390, Mainframes.

Others: Java, Visual Basic 6.0, C, C++, Fortran 77/90, XML, Unix Shell Scripting, SQL, PL/SQL, ISQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, Java Script, XHTML, HTML 4.0, DHTML, COM, DCOM, ODBC, Active-X, Quest TOAD, WAP, TCP/IP, LAN, WAN.

PROFESSIONAL EXPERIENCE

Confidential, Ohio

Lead ETL Developer

Responsibilities:

• Effective implementation of Tuning and Performance enhancement Techniques both in Informatica level and Database levels.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports in data warehouse.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations.
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Designed logical models (relationship, cardinality, attributes, and Candidate keys) as per business requirements using ERwin 7.3 Data Modeler.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Responsible for Internal Delivery of ETL code from Architecture /Design/ Development/ Testing and Implementation phases.
• Developed SSIS packages using ADO.net drivers and loaded the data into Vertica database.
• Worked closely with data ware house architecture group.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Developed and scheduled the jobs via Tidal Enterprise Scheduler for different calendars.
• Worked with Unix team to set up the Mount point on Unix box to get the Tidal team install the new Tidal agent.
• Involved with Java Team to help in Hadoop MapReduce jobs to load XML source files into Vertica stage tables.

Environment: Informatica Power Center 8.6.0, Business Intelligence Development Studio (BIDS), Microsoft Visual Studio 2008 version 9.0, CA Erwin Data Modeler 7.3, TSQL, Oracle 11i, MSSQL Server 2008R2/2005, Flat Files, Windows XP, Toad for Oracle 10.6.1.3, Borland CalliberRM 10.0, TortoiseSVN 1.7.4, Subversion 1.7.2, .

Confidential, VA

Sr ETL Developer

Responsibilities:

• Responsible in Process Strategies involving in the conversion lifecycle. Laying down the ETL architecture, Process flow, data integration, data validations and error handling.
• Translated Business Requirements into Technical Specifications.
• Designed the Mapping Specifications based on the Transformation rules to load the data from source to the Target.
• As one of the projects Converted Complex Oracle Stored Procedures logic into Informatica Code. Designed and Deployed many UNIX Shell Scripts one of which was developed to generate an Email if Informatica Workflow doesn’t Start/End as per Schedule.
• Developed Re-usable transformations, Mapplets to use them for data load to data warehouse and database (Oracle).
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.
• Responsible for Performance Tuning of sources, targets, mappings and sessions.
• Effectively Used SQl Transformation in Informatica.
• Designed and developed Informatica Mappings to load data from Source systems to Staging tables and then to Data Mart.
• Effectively performed Peer to Peer Code Reviews.
• Effectively used Persistent caches, Informatica Lookup Overrides and other optimizing techniques to improve the Session performance considerably.
• Used Parameter files to pass queries, define Mapping, Session Parameters, column values that frequently change etc.
• Developed detailed Test cases for all the Informatica mappings.
• Developed Shell Scripts to perform tasks like starting the Informatica workflow from the Script, used looping techniques, naming the file with the Date file was generated.
• Developed many oracle Stored Procedures as part or requirements for PL/SQL Team.
• Developed Workflows containing different Tasks like Worklets (Both Reusable and Non Reusable), Session, Decision, Assignment, Control).
• Created User-defined variables which were part of the workflow/worklet’s link condition, used inbuilt variables as part of the conditions like target rows etc
• Involved in handling the mapping changes need to be performed according to the Heat- Tickets issued by the UAT/ PROD team.

Environment: Informatica Power Center 8.6/8.1.1, Oracle 10G/9i, Microsoft SQL Server 2000, Toad 9.0, Query Analyzer, SQL*Plus, IBM UNIX (AIX) v5.3, Windows XP, Visio.

Confidential, Spring House, PA

Sr. ETL/Teradata developer

Responsibilities:

• Responsible in Process Strategies involving in the conversion lifecycle. Laying down the ETL architecture, Process flow, data integration, data validations and error handling.
• Designed and Implemented ETL architecture with Informatica tool.
• Created mappings using the transformations like Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, and Stored Procedure transformations.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Prepared the ETL specs based on FRD provided by DA.
• Created Schema objects like Indexes, Views, and Sequences.
• Responsible for Performance Tuning of sources, targets, mappings and sessions.
• Scheduled and ran Extraction, Loading processes and monitored sessions using Informatica Workflow Manager.
• Extensively used Informatica Debugger to validate mappings and to gain troubleshooting information about data and error conditions.
• Used TOAD front-end tools to issue SQL commands matching the business requirements to Oracle RDBMS.
• Created Informatica mappings with PL/SQL Procedures / Functions to build business rules to load data.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD.
• Code MULTILOAD scripts to load data files using WIN32 Teradata for WINDOWS NT.
• Used BTEQ to transform data and implement the business logic in existing TERADATA tables.
• Designed and Developed UNIX wrapper scripts to run Bteq and mload scripts.
• Designed and Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions.
• Used Unix Shell scripts for Data Import/Export, Data Conversions and Data Cleansing, Remove Workflow and Session Logs and backing up Informatica repository.

Environment: Informatica Power center 7.1.4, ERwin 4.0, Business Objects XI, Teradata V2R5, Oracle 9i, Terdata SQL Assistant, UNIX, Win XP, Flat files, Shell Scripts,Toad, Maestro for scheduling.

Confidential, Alpharetta, GA

Lead DW/ETL Analyst

Responsibilities:

• Responsible in Process Strategies involving in the conversion lifecycle. Laying down the ETL architecture, Process flow, data integration, data validations and error handling.
• ETL Architecture and design for the Business and Functional requirements for the Warehouse.
• Data modeling using Erwin 4.5/Database designer 4.
• Extensively analyzed Ralph-Kimball Methodology and implemented it successfully.
• Worked on Dimensional modeling to design and develop Star schemas by identifying the facts and dimension.
• Designed logical models (relationship, cardinality, attributes, and Candidate keys) as per business requirements using ERwin 4.5 Data Modeler.
• For Geography dimensions, developed logical & physical data model by defining strategy for Star schema with Fact & Dimension tables with Detail, Summary, Look-up tables, Indexes and views.
• Assisting Users and Solution Architects on Functional and Business Requirements for BID.
• Integrated Data warehouse Design for enormous sources feeding the Warehouse like Billing, finance, call details, customer, usage, Business Customer integration, Product integration, Point of sales.
• ETL development includes most of the Technical usage of Informatica/ Oracle/ SQL Server/Unix Shell scripts /Cronjob.
• Effective implementation of Tuning and Performance enhancement Techniques both in Informatica level and Database levels.
• Responsible for Internal Delivery of ETL code from Architecture /Design/ Development/ Testing and Implementation phases.
• Application DBA activities involving in Table Partitions, effective indices, improving performance of Informatica sessions by including Parallel Hints in the source SQL’s. Design and Architecture of Staging Oracle Tables, objects.
• Defined and implemented effective process for Exception handling
• Tuned performance of Informatica and Oracle jobs.
• Designed and developed Unix Shell scripts for Data Import/Export, Data Conversions and Data Cleansing, Remove Workflow and Session Logs and backing up Informatica repository.
• Designed and developed Oracle PL/SQL Procedures for dropping and re creating indexes, exchange partitioning.
• Implemented exchange partitioning for increasing data load frequency.
• Automated load run on Informatica sessions, PL/SQL scripts and implemented pre and post-session scripts, Written SQL Scripts and PL/SQL Scripts to extract data from Data base.

Environment: Informatica PowerCenter 8.5.1 with Real Time and IDQ,Informatica PowerCenter 7.1.4, Oracle 9i/10g RAC, TOAD 8.6.1.0, UNIX, Cronjob, ERwin 4.5, Business Objects XI, PSTAGE (AS/400), Quality center 9.0.

Confidential, Hoboken, NJ

Senior DW/ETL Developer

Responsibilities:

• Extensively worked on installation of Informatica 7.1.3, Informatica Power Mart 6.2.2 for OEM Siebel and DAC Server on Sun Solaris machine.
• Worked on admin tasks like taking backups and restoring the Informatica repositories from backup
• Extensively used ETL to transform data from different source systems and load the data into the Siebel OLTP and Siebel Warehouse.
• Designed the Data models for Data mart. Created Logical and Physical Data models using Erwin 4.5.
• Provided solutions to resolve complex issues
• Supported ETL routines required for populating the data warehouse and Experience in loading high-volume data, Tuning and troubleshooting of mappings.
• Responsible for Troubleshooting ETL issues and bug fixes.
• Responsible for designing Load Strategy using workflow Manager
• Performed administration tasks including managing the repository, performing backups.
• Extensively used Source Qualifier, Aggregator, Filter, Expression, Lookup, Update Strategy, Router and Joiner transformation.
• Used Stored Procedure Transformations to invoke Oracle PL/SQL Procedures.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Developed Re-usable transformations, Mapplets to use them for data load to data warehouse and database (Oracle). Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.
• Responsible for Performance Tuning of sources, targets, mappings and sessions.
• Responsible for Performance Tuning of sql in Report queries.
• Designed and Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions. Scheduling of sessions and workflows.
• Scheduled and ran Extraction, Loading processes and monitored sessions using Informatica Workflow Manager.
• Created Schema objects like Indexes, Views, and Sequences.
• Designed and developed Oracle PL/SQL Procedures and extensively used bulk collect concept.
• Involved in change control of the developed mappings, sessions, workflows before moving them in to production.
• Generated reports using report studio.
• Worked with SAS queries and Cognos queries which involved automating manual reports
• Developed views necessary for structured and ad-hoc reporting using query studio.
• Created models in framework manager.
• Designed testing procedure and test plans. Assisted in Production support.
• Created documentation to support for the Application.

Environment: Informatica Power Center 7.1.3, Informatica Power Mart 6.2.2 for OEM Siebel warehouse, Data Warehouse Application Console (DAC), Cognos Report net 1.1, Erwin 4.5,Framework Manager, Report Studio, Query Studio, Powerplay 7.4, SAS, SQL Server2005,TSQL, Oracle 9i, SQL, PL/SQL, Flat Files, Windows XP, UNIX Shell Scripting, Sql*Loader, TOAD, Sun Solaris 64 bit.

Confidential, Jersey City, NJ

Senior ETL Developer

Responsibilities:

• Involved in design, development and maintenance of database for Large Property project. Designed the ETL processes using Informatica tool to load data from oracle to AS/400 with oracle (staging area).Created complex mappings which involved implementation of Business Logic to load data in to staging area.
• Worked on various interfaces of Large Property connecting following Submission, account, Producer, Policy Booking system, Renaissance (billing system).
• Worked extensively on LP-wins process (policy booking in AS/400 system).
• Worked on Renaissance (billing system) on daily basis to account for the transactions that are processed that day. Ran the batch process to process the transactions and generate a flat file which is sent to billing system.
• Developed mappings/sessions using Informatica Power Center 8.1 / 6.2 for data loading.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router, sorter, and Sequence generator.
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
• Created PL/SQL packages and stored procedures to calculate year to date earnings and to insert the data in to work tables which were used later in the process.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Worked with SQL*Loader to load the data into the staging tables.
• Involved in Unit testing and UAT for the developed process.
• Involved in change control of the developed mappings, sessions, workflows before moving them in to production.
• Involved in production support for the developed process in production.

Environment: Windows 2000, Oracle 10g/9i, SQL*Loader,AS/400, Informatica Power Center 8.1/6.X, Power Exchange, Erwin 4.1, SQL Navigator, SQL, PL/SQL, SQL Loader,TSQL, SQL Server 2005/2000, Autosys, Toad, MS-Office tools, Flat files, Unix.

Confidential, Boulder, Co

Sr. DW Informatica analyst

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Designed the Data models for Data mart. Created Logical and Physical Data models using Erwin 4.5.
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• As part of the team was involved in restructuring of Informatica folder structure categorized based on business units.
• Extensively used ETL to transform data from different source systems and load the data into the Target database.
• Extensively used Source Qualifier, Aggregator, Filter, Expression, Lookup, Update Strategy, Router and Joiner transformation.
• Used Stored Procedure Transformations to invoke Oracle PL/SQL Procedures.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Developed Re-usable transformations, Mapplets to use them for data load to data warehouse and database (Oracle). Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.
• Responsible for Performance Tuning of sources, targets, mappings and sessions.
• Designed and Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions. Scheduling of sessions and workflows.
• Scheduled and ran Extraction, Loading processes and monitored sessions using Informatica Workflow Manager.
• Used TOAD front-end tools to issue SQL commands matching the business requirements to Oracle RDBMS.
• Created Informatica mappings with PL/SQL Procedures / Functions to build business rules to load data.
• Created Schema objects like Indexes, Views, and Sequences.
• Designed and developed Oracle PL/SQL Procedures.
• Designed and developed Unix Shell scripts for Data Import/Export, Data Conversions and Data Cleansing.
• Generated reports using Business Objects Report Designer.
• Developed views necessary for structured and ad-hoc reporting.
• Designed testing procedure and test plans. Assisted in Production support.

Environment: Informatica PowerCenter 7.1/6.2, Datamodeling, Business Objects XI, ERwin 4.5, Oracle 9i, SQL, PL/SQL,SQR, MS SQL Server 2000, Flat Files, Windows XP, UNIX Shell Scripting, Sql*Loader, TOAD, AIX.

Confidential, Cincinnati, OH

Software engineer Trainee

Responsibilities:

• Study and design of entire system.
• Design of the overall database using Entity Relationship diagrams.
• Wrote triggers, menus and stored procedures in PL/SQL.
• Developed interactive forms and customization of screens using Forms 4.5.
• Building, Debugging and running forms.
• Data loading and Extracting function using SQL * Loader.
• Designed and developed all the Tables, Views for the system in Oracle.
• Designed and developed forms validation procedures for query and update of data.

Environment: Oracle 7.3, SQL, PL/SQL, Forms 4.5, Win 98.