SUMMARY:-

• Over 7 years of experience in analysis, design, development and implementation of Data warehouses, Data marts and Decision Support Systems (DSS) involving RDBMS like Oracle, MS SQL server, DB2 and Teradata databases on Windows and UNIX platforms.
• Experience with Informatica Power Center/ Power Mart (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager, and Workflow Manager/Server Manager).
• Extensively worked on Data migration; Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses using Informatica.
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Experience in integration of various data sources like SQL Server, Oracle, Sybase, Teradata, DB2, Flat Files and XML Files into staging area. Experience in the complete life cycle comprising of design, development, documentation and maintenance of the data marts and data warehouse.
• Expertise in Data modeling techniques like star and snowflake schemas.
• Experience with BI Tools such as OBIEE/Siebel Analytics and Cognos for developing warehouse reports.
• Experience installing, configuring, deploying, and tuning BI tools and analytic servers.
• Strong knowledge of Software Development Life Cycle (SDLC) and Quality Assurance Life Cycle (QALC).
• Experience in Oracle tools and utilities like TOAD, SQL* Loader.
• Working knowledge of XML technologies DTD, Schema, DOM, SAX, XSL, XPATH and XSLT.
• Experience in coding using Perl, Java, C, C++ and UNIX Shell script.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Experience leading efforts to meet business needs including defining and documenting tasks, gathering estimates, and creating and maintaining project schedules.

TECHNICAL SKILLS:-

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Informatica Power Mart 7.1/6.1/5.1
Reporting Tools: OBIEE 11g/10.1.3.x, Siebel Analytics 7.x, Oracle BI apps, Cognos
SQL Tools: PL/SQL, SQL*Loader, SQL* Plus, and TOAD
Languages: Perl, Java, C, C++, SQL, PL/SQL, UNIX Shell Scripting
Database: Microsoft SQL server, Oracle 9i, Sybase, Teradata, DB2
Job Scheduling: CA Autosys, BMC Control M, Informatica Scheduler
Operating Systems: UNIX (Linux, AIX, Solaris), Windows 2000/NT/XP/Vista

EXPERIENCE:-

Informatica Developer Jan’11-Oct-12
Confidential,Rocky Mount, NC

Confidential, is the world\'s leading video and ecommerce retailer, offering a curated collection of desirable brands to millions of customers around the globe each day through broadcast, Internet, and mobile sales outlets. The current project Customer Centricity focuses on integrating data from various source systems like Oracle, SQL Server, Flat Files, XML Files etc., into one single Enterprise Data Trust (EDT) to provide a single source of data for various independent operational units within the company. The data available in the EDW is used by these various operational units to develop reports and build triggers to generate the needed campaign information.

Responsibilities:

• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial and incremental load. Mappings were developed in Informatica employing transformations like Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router.
• Developed Informatica mappings, sessions and workflows as per the business rules and loading requirements.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and worked on scheduling of the workflows.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Involved in design, specifications, and delivery of Data Warehouse & Operational Systems; Enterprise through functional level application and data architecture and modeling.
• Involved in Data Model and Data Mapping review, including sources, staging areas, and target database.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Developed and Implemented UNIX shell scripts and scheduled different Informatica jobs using Autosys.
• Developed multi-dimensional semantic layer, BI query objects, reports, and report templates for business users.
• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Involved in documentation to describe project development, logic, coding, unit testing and any changes and corrections made.

Environment: Informatica PowerCenter 9.1/8.x, PowerMart 7.1, OBIEE 10.x/11g, MS SQL Server, Oracle 9i, XML, Autosys, UNIX Shell Scripting, Toad, Linux, Solaris, Windows XP/Vista

ETL Developer Sep’08–Nov’10
Confidential,Reston, VA

Confidential,is a leading provider of fully integrated wireless communications services and has built the largest guaranteed all-digital wireless network in the country covering thousands of communities across the United States. Sprint planned multiple phased projects to develop EDW (Enterprise Data Warehouse) and Data Marts to support Business Intelligence needs for Consumers point of view and Customer satisfaction.

Responsibilities:

• Analyzed business requirements to design, develop, and implement highly efficient, highly scalable Informatica ETL processes. Designed Informatica ETL solutions.
• Created Mappings using different transformations like Expression, Lookup, Joiner, Router, Filter, Update Strategy, Sequence Generator to perform the process of Extract, Load and Transform effectively in the Mapping Designer as per the requirement.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.
• Involved in designing and developing logical and physical data models to best suit the requirements.
• Utilized dimensional and star-schema modeling to come up with new structures to support drill down.
• Extracted date from Oracle and XML and loaded into Pipe delimited Flat files.
• Created objects like Mapplets, reusable transformations, shortcuts for ease of enhancement by facilitating reusability.
• Created Data Break points and Error Break points for debugging the mappings using debugger wizard. Developed unit test cases for the mappings developed.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Migrated Reports from Cognos 7.0 to 7.1 to Siebel Analytics.
• Designed ETL process to extract data from SQL server/Oracle 9i and performed data scrubbing, restructuring and consolidation for Web reporting.
• Involved in Designing Data Level Security for Territory/Area and Region Level reports and Dashboards.
• Created Data specification document containing the business rules for each column in Target warehouse and rules for Initial and daily incremental loads. Documented Assumptions for ETL Design.
• Developed Business Intelligence reports using Siebel Analytics.
• Created release documents for better readability of code/reports to end users.

Environment: Informatica PowerCenter 8.6/8.1, PowerMart 7.1/6.1, Cognos, Siebel Analytics, SQL Server, Oracle 9i, Teradata, Toad, Autosys, UNIX, Windows NT/XP

Informatica Developer Jan’07 – Aug’08
Confidential,Columbus, OH

Confidential,have wide variety of services like Loans, Financial Income, Home loans, Automobile loans etc., and is wide spread all over the nation with 2600 branches. The P&C Agent Gateway Marketing is the current application, which provides access to corporate published sales opportunities and service events. These activities are tracked and managed with in application and the status is feed to the warehouse to provide performance reporting and improve targeting capability. It is an integral tool of sales and service applications to support the overall insurance marketing process for the exclusive and direct sales agent. My role in AGM (Agent Gateway Marketing) involved as primary developer for the loans data mart; which is developed using Informatica 7.1.3.

Responsibilities:

• Worked with Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
• Created Informatica mappings with various transformations to build business rules to load data and to transform the existing processes that were using Java into Informatica processes.
• Created various transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. and Fine-tuned the mappings for optimal performance.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Created Informatica mappings for data conversion processes and scheduled the processes to run on every Sunday until the data is converted.
• Used Mapping Designer to join tables from various databases like Oracle, SQL Server, and DB2.
• Worked with the Informatica Scheduler for scheduling the delta loads and master loads.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Implemented various new components like increasing the DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, Validation Techniques, and load efficiency.
• For better performance, created pipeline partitions, SQL Override in source qualifier.
• Worked extensively with the business intelligence team to incorporate any changes that they need in the delivered files.
• Wrote Korn shell Scripts for extracting data from all systems to Data Warehousing system.
• Responded to trouble calls as required; coordinated with other IT groups as needed.
• Acted as Subject Matter Expert (SME) as required to assist with requirements and testing activities.
• Adopted Agile/Extreme Programming practices with the objective to increase client value code reviews to ensure consistency and quality.

Environment: Informatica PowerCenter 7.1, PowerMart 6.1/5.1, Korn Shell Scripting, Perl, Java, Oracle 9i, PL/SQL, DB2, SQL Server, ClearCase, ClearQuest, Autosys, HPUX, Windows XP.

Data warehouse Developer Apr’06–Dec’06
Confidential,Rockville, MD

Confidential,a biotechnology pioneer, discovers, develops and delivers innovative human therapeutics. Designed and developed Contract Sales System Data Mart to support Sales Representatives with Physicians and Hospitals contract information. Sales, Marketing & Contract information was collected from different tests conducted on the subjects. Data mart helps build Monthly sales report for every Professional or Organization in contract.

Responsibilities:

• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Participated in the entire Software Development Life Cycle (SDLC) phases including (Data Analysis, Data Modeling, Development, and Application Supporting).
• Used control-M for automating the Informatica jobs. This includes setting up dependencies for sequencing, triggering jobs based on fixed time, ah-hoc scheduling of on-demand processes, receiving success/failure notification mails, monitoring the process flows, weekly maintenance, etc.
• Automated the weekly maintenance scripts to ensure a hassle free maintenance window for the ETL servers, the maintenance scripts were automated. The Informatica services - startup, shutdown scripts, Purge scripts, BARE process (to backup the repository and do a restore in the restore repository), etc., were automated using the UNIX shell scripting.
• Used all Transformations such as Expression, Filter, Joiner, Aggregator, Lookup and Router, to load consistent data into Warehouse Database.
• Designed the mappings between sources (external files and databases) to operational Staging targets.
• Designed and developed the Informatica workflows/sessions to extract, transform and load the data into SQL Server.
• Worked on different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Created Informatica mappings with PL/SQL procedures to build business rules to load data. Most of the transformations were used like the Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Sequence.
• Wrote Unix Scripts for event automation.
• Involved in Testing the Informatica mappings and creating QA Test Plans.
• Monitored the daily/weekly/monthly data loads and provided support after hours.

Environment: Informatica PowerCenter 7.1, PowerMart 5.1, SQL Server, Oracle 9i, PL/SQL, SQL *Plus, Shell Scripting, Control-M, UNIX, Windows 2000/NT.

Informatica Developer Feb’05–Mar’06
Confidential,Richmond, VA

Confidential,is one of the largest world sales pharmaceutical and health care companies in US. Involved in data warehouse development for sales division, which contains the sales data for pharmaceuticals and medical products of the company. Business rules are applied to the data in the Data Warehouse and this data is finally loaded to the Data Mart for the business users.

Responsibilities:

• Developed mappings to transfer data from AS/400 to Oracle and translate data using Oracle stored procedures, lookups, and transformations with Informatica Power Center.
• Involved in Dimensional modeling of the Data warehouse and used Erwin to design the business process.
• Created mappings and complex mapplets using Informatica Power Center 6.1
• Created multiple repositories, users and privileges in Informatica repository manager.
• Extracted the Data items from different sources like Oracle, DB2, and flat files and loaded them into Oracle target
• Created sessions, database connections and batches using Informatica Server Manager.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Wrote scripts using VI Editor to schedule the ETL jobs for the development environments
• Used Informatica repository manager to backup and migrate metadata in development, test and production systems.
• Created and maintained several ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 6.1 to extract the data from multiple source systems to target star schema designed tables.
• Used several transformations and mapplets to handle complex transformations of data.
• Created Unit test case documents and prepared the Unit test logs.
• Developed the UNIX shell Scripts to start the Informatica Workflows.

Environment: Informatica PowerCenter 6.1, PowerMart 5.1, AS/400, Erwin, Oracle 8, DB2, SQL *Plus, Toad, Shell Scripting, Autosys, UNIX, Windows 2000/NT.

EDUCATION:-

Bachelor of Technology in Computer Science