Informatica Developer

Pavan Pandiri Voice: 610-***-****

SUMMARY

• More than 8 years of IT experience which includes experience in Business Requirement Gatherings, Analysis, Design, Data Modeling, Development, Testing and Implementation of Data warehouse/Business Intelligence using Informatica 6.x/7.x/8.X, OBIEE 10.1.X, Siebel Analytics 7.x,

• Excellent Data Analysis skills and ability to translate business logic into mappings using complex transformation logics for ETL processes.

• Involved in requirement gathering from business users and according to requirement matrix designed technical specification document.

• Designed Dimensional data model by identifying business process, Grain and identifying Source and Targets for the project.

• Proficient in using Informatica Power Center tool to design data conversions from wide variety of source system.

• Expertise in ETL methodology in Data Extraction, Transformation and Loading. Experience in Performance Tuning of sources, mappings, targets and sessions. Ability to understand available technology, tools and existing designs and work on complex problems where Analysis of situations and Data gathering is required.

• Expertise in designing Data modeling and creating data marts using Ralph Kimball and William Inmon methodologies.

• Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart Client, Server and also involved in Installation of Business Objects tools.

• Extracted Sources and targets using source analyzer and warehouse designer and created mappings in designer using different kinds of transformation according to business logic.

• Experienced in administrative work by creating users, user groups, folders, configure security and giving permissions in folders and to users in Repository manager.

• Created and scheduled workflows and worklets, configured e-mail notifications using workflow manager.

• Identified bottlenecks and tuned targets, sources, sessions, mappings for better performance of mappings and sessions.

• Expert in building Business Models, Creating Dashboard pages, and Generating Reports in Siebel Analytics.

• Strong Logical and Physical Data Modeling and Dimensional modeling skills in Physical database design, Relational Models, Star Schemas, and Snowflake Schemas.

• Strong experience in providing end-to-end business intelligence solution by configuring metadata and building Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer).

• Involved in complete lifecycle of a project including writing test scripts and performing unit-testing by writing SQL against the database and validating with end users reports.

• Expertise in PL/SQL, SQL coding, triggers Oracle 8i/9i/10g , Sybase 11.5/11.2

• Documented ETL Architecture and ordered dependency tables implemented a very good version control of Informatica mappings.

• Excellent problem solving skills with good interpersonal skills, Quick learner and excellent team player.

TECHNICAL SKILLS

ETL Tools : Informatica (Power Mart/Power Center 5.1/6.1/6.2.2/7.1.2/8.3/8.6)

Reporting/OLAP Tools : OBIEE10.1.3, Business Objects, crystal reports.

Verticals : Call Center, Sales, Finance, Pharma, Service, Marketing

Languages/GUI : C, C++, HTML, XML,

Data Modeling Tools : Erwin, Designer 2000

Scripting Languages : VB Script, eScripts, Java Scripts

Databases : Oracle 8i/9i/10g, MS SQL Server 2000, MS-Access, Sybase 11.5/11.2

Query Tools : SQL, PL/SQL, TOAD

Operating Systems : Windows 98/00/NT/XP, Sun-Solaris, UNIX.

Web & App. Server : IIS 4.0, Apache/Tomcat

Applications : MS Word, Excel, Outlook, PowerPoint

EDUCATION

Masters in Computer Science 3.8/4.0

CTU University, Colorado

PROFESSIONAL EXPERIENCE

BORDERS Group INC, MI Apr 2010 - Till Date

Informatica Consultant

Borders Group Incorporated is the second of the three largest and fastest growing bookstore chains in the United States. Borders are finding new ways to help our customers create richer and more satisfying lives through knowledge and entertainment. Borders are implementing to give warranty to products we buy online or in store. A third party is providing warranty for the products. So we created a Data-mart with all the information about products and warranty for the products.

Responsibilities

• Collaborated with Functional analysts Gathered Business requirement(s) to convert them into meaningful data for analysis

• Involved in analyzing and validating data.

• Interacted with business/end users to analyze business requirements & develop detailed requirement(s) document.

• Worked on Informatica Power Center 8.6 tool - Source Analyzer, Mapping Designer & Mapplets and Transformations.

• Created complex mappings using Lookup, Sorter, Aggregator, and Router transformations for populating target table in efficient manner.

• Created Transformations like Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, and Source Qualifier Transformations in the Informatica Designer.

• Created Schema objects like Indexes, Views, and Sequences.

• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.

• Developed mapping for warranty, claims dimension tables working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects.

• Developed and tested all the backend programs, Informatica mappings and update processes.

• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.

• Extensively dealt with the performance issues and made necessary coding changes for improving the system Performance.

• Created Workflows, re-usable Worklets and Sessions using the Workflow Monitor.

• Performed Developer testing, Functional testing, and Unit testing for the Informatica mappings.

• Involved in Documentation regarding the ETL process.

• Responsible for supporting production and development environments.

• Created the reports and export to the repository to make resources available to the users.

Environment

Informatica power center 8.6, Oracle 9i/10g, Pl/SQL, Toad, Windows XP, Microsoft Word, Microsoft Excel, PowerPoint, and UNIX.

EMD SERONA, MA Dec 2008 – Mar 2010

Informatica Consultant

EMD Serona is a Pharma company; I was involved in the OLTP to OLAP transformation of data sources. Created tables to develop reports used for business. And implemented dashboard and the functionalities using Siebel analytics which allows users to view reports and analyze the effectiveness of all the customized supporting sales.

Responsibilities

• Extensively involved in interacting with Project coordinators, Business Analysts and End-users to gather requirements.

• Prepared the ETL spreadsheet after identifying the Facts and Dimensions.

• Designed the Star Schema after identifying the Facts and Dimensions.

• Prepared the Fact Dimension Matrix Spreadsheet prior to the development of rpd for the required reports.

• Used the Informatica Power centre designer to develop the required mapping based on the ETL spreadsheet.

• Used the Informatica PowerCenter Workflow Manager to develop the required sessions for the mappings developed based on the ETL spreadsheet.

• Used different transformations Source Qualifier, Expression, Filter, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner, Router, Aggregator transformation and SQL override extensively.

• Used the Workflow Manager to create tasks, sessions, worklets and batches.

• Debugged the failed mappings.

• Implemented the best practices for creating the mappings, sessions and workflows.

• Identified bottlenecks in the ETL process and edited/corrected the mappings and sessions to improve the ETL process performance and achieved the required. Full ETL used to take 18 hours to complete which I fine tuned to 12 hours.

• Unit tested the mappings before including the developed sessions into the already existing batch.

• Integration tested the entire batch after including the individual sessions into the existing batch.

• Involved in configuring new jobs and importing the newly developed INFORMATICA sessions into DAC.

• Designed and developed the OBIEE/ Metadata Repository (.rpd) using Siebel Analytics Server Admin tool by importing the required objects.

• Worked on Siebel Answers to build OBIEE Interactive Dashboards with drill-down capabilities.

• Debugged reports and OBIEE Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.

Environment

Informatica Power Center 8.3, OBIEE10.1.3,DAC, Oracle 9i/10g, Toad, Windows XP, Microsoft Word, Microsoft Excel, PowerPoint.

ACC Capital Holdings, CA Jul 2007– Nov 2008

Informatica Consultant

ACC Capital Holdings (ACH) is a national financial services company offering a wide range of mortgage and financing products. The Project involved developing an integrated data mart for the Mortgage Division to analyze transactions across finance, collections, and brokerage and customer relations Responsibilities

• Worked on Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapple Designer and Transformation Developer.

• Extensively used ETL to load data from different source systems like, Flat files into the Staging table and load the data into the target database ORACLE.

• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse and database (oracle).

• Developed Mappings with transformations like Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update strategy, Rank Etc.

• Multi source Extraction Transformation and loading into the Repository using Informatica.

• Worked closely with multiple business units and a data solutions engineer to identify key information that will enhance business decision-making.

• Created sessions to move the data at specific intervals and on demand using Server Manager.

• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.

• Debugged the mapping of the failed session.

• Created batches to run several sessions sequentially and concurrently.

• Analyzed and Created Facts and Dimension Tables.

• Used different Data Warehouse techniques like Star-Schema.

Environment

Informatica 7.1.2, Oracle 9i, OBIEE 10.1.3, SQL Loader, PL/SQL, Windows NT 4.0, UNIX.

StorageTek, Louisville, Colorado Nov 2006 – Jun2007

Informatica Developer

.

This project is developed to increase the performance of the Speedi Plus Business sales application in some key areas of Opportunity, Sales and Order Management Modules. The Speedi Plus Business sales application is a decision support system to develop the Products across Position, Sales Rep, Territory and Opportunity.

Responsibilities

• Designed and developed ETL to load data into Data Marts and Data Warehouse using INFORMATICA Power Center.

• Developed and tested stored procedures, functions and packages in PL/SQL for Data ETL.

• Created and maintained the Metadata repository.

• Performed the role of INFORMATICA developer on an ongoing basis.

• Did data cleansing before loading it on Oracle data warehouse.

• Used complex transformations like connected and unconnected Lookup, Joiner, Router, Filter and Stored Procedure transformations for data loads.

• Worked with Memory management for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations and involved in pipeline partitioning.

• Worked with Slowly Changing Dimensions and Confirmed Dimensions for user requirements.

• Created Pre and Post Session Scripts for checking file existence.

• Extensively involved in gathering user requirements.

• Worked extensively with BMM layer to develop various business models.

• Created dimensional hierarchies and assigned levels and custom aggregation rules for each level.

• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.

• Created various aggregate tables to improve the query performance.

• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.

• Configured iBots using Siebel delivers to alert the management and sales teams regarding data consistency issues.

• Involved in implementation of Disconnected Analytics.

Environment

Informatica PowerCenter 7.1.4, Oracle 9i, Siebel Analytics 7.7, Win NT, SQL Server 7.0.

Ample Technologies, India Jan 2006 - Apr 2006

Informatica Consultant for Target Corporation

The Target corporation initial goal was to build the capability to better analyze the financial accounts for which the Financial Data warehouse was developed. One of the major objectives was to market more effectively by offering additional products to Clients that already have one or more accounts with the Company. Users want the ability to slice and dice individual accounts, as well as the residential household groupings to which they belong.

Responsibilities

• User interaction, requirements analysis and specifications.

• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer.

• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.

• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy.

• Extensively worked on all the transformations like Filter, Aggregator, Expression, Router, Lookup, and Update Strategy.

• Multi source Extraction Transformation and loading into the Repository using Informatica.

• Partitioned the Sessions to Improve the Performance.

• Created batches to run several sessions sequentially and concurrently.

• Used the command line program Pmcmd to communicate with the Informatica Server

Environment

Informatica 6.2.2, Siebel Analytics 7.5, Oracle 8i, UNIX

Ample Technologies, India Apr 2005 – Dec 2005

Informatica Developer for Cendant / RCI

Cendent is the world leader in bearing manufacturing for Automobiles Industries and Aerospace having 40 locations round the globe. Data Warehouse is developed for Sales and Marketing Departments to assist them in their business analysis.

Responsibilities

• Prepared ETL Mapping spreadsheet and Fact - Dimension Matrix. Repository Design

• Used Designer to develop the mappings based on ETL Mapping Spreadsheet.

• Worked on transformations like Source Qualifier, Expression, Filter, Lookup, Update Strategy, Sequence generator, Joiner, Router, Aggregator transformation

• Debugged and implemented the best practices in mappings, sessions for data extraction and loading from source to target databases.

• Checked the source, target and mapping bottlenecks to tune the ETL process performance.

• Worked on the Siebel Analytics Admin Tool to configure the business model based on the end user requirements.

• Created Logical dimensions, columns, and Logical Joins. Set levels to support Drill- down, and Aggregation over Columns.

• Used Time series Wizard for time comparison measures in the business model.

• Created all the Reports as per requirements using Siebel Analytics answers

Environment

Informatica Power mart 6.1.2, eHospitality, Oracle 9i, PL/SQL, UNIX, TOAD

Arackal Solutions, Trivandrum, India July 2004 – Mar 2005

Informatica/Database Developer

Project was to build a warehouse system. Developed a Vendor Information system to let vendor better manage the Inventory and Payments. Create daily sales reports for Upper management.

Responsibilities

• Initial Phase of Offshore Transition & Knowledge Transfer to Team.

• Developed various Mappings and Transformations using Informatica Designer.

• Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations. Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, External Procedure, Router and Update strategy.

• Configured the Workflow Manager to work on tasks like Assignment, Command, Control, Event, Timer and Decision tasks.

• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

• Used SQL tools like TOAD to run SQL queries and validate the data pulled in BO reports.

• Developed business models confirming to functional mapping-defined logical and complex joins for the dimension tables.

• Conversion of various SAS Programs to PL/SQL.

Environment

Informatica 6.2.2, PL/SQL, BASE SAS, Brio, MS Access, Mainframe, TOAD

Arackal Solutions, Trivandrum, India. Now 2003 - Jun 2004

ETL Developer

Responsibilities

• Extracting and loading of data from flat file, Oracle sources to oracle database (target warehouse) using transformations in the mappings.

• Created Pre and Post Session Scripts for checking file existence.

• Created stored procedures using Pl/SQL and implementing them through stored procedure transformation.

• Setting of Error Logic for streamlining and automating the data loads for cleansing and trapping incorrect data on staging servers and then loading it to the Oracle 8i data warehouse.

• Analysis of certain existing mappings, which were producing errors and modifying them to produce correct results.

• Development of a template to be used as a Mapping Specification Document.

Environment

Informatica Power Center v 5.1, Power Mart v 5.1, Oracle 8.i, PL/SQL, UNIX, Win NT, Autosys.

IRIS Technology, Hyderabad, India Sep 2002 – Oct 2003

Oracle Developer

Responsibilities

• Created and customized database with appropriate table spaces to increase the performance

• Created stored procedures and triggers to view, update and enter the check-in and checkout procedures.

• Used dynamic SQL to find out the availability of tickets.

• Optimize the SQL statements using hints.

• Created SQL scripts to tune performances and make backups.

Environment

Oracle 7.3, PL/SQL, Visual Basic, ASP, HTML, JavaScript, VB Script

Contact this candidate