SUMMARY

• Eight Plus (8+) years of total IT experience which includes Business Requirements Analysis, Design, Development, Implementation, and Testing of Data Warehousing applications in Supply chain, Manufacturing and Pharmaceutical industries.
• Eight (8) years of strong Data Warehousing and ETL experience using Informatica PowerCenter 9.5/9.1/8.6/8.1/7.1 , Repository Manager, Mapping Designer, Mapplet Designer, Workflow Manager, Workflow Monitor, Transformations, Source Analyzer, Server manager, Warehouse Designers, PowerExchange, IDQ, Metadata, Datamart, SQL*Plus, OLTP and OLAP.
• Five Plus (5+) years of Data Modeling experience using Dimensional Data Modeling, Star Schema/Snowflake Modeling, Normalization, Data Profiling, Data Cleansing, FACT & Dimensions tables, Physical & Logical Data Modeling, ERwin 4.x, and Oracle Designer.
• Eight Plus (8+) years of Database experience using Oracle 11g/10g, DB2 8.0/7.0, MS SQL Server 2000/7.0, MS Access 2000, SQL, PL/SQL, SQL*Plus, SQL*Loader.
• Eight (8) years of Business Intelligence experience using Business Objects 4.0/XI r3/r2/6.5/6.1 & Crystal Reports2008 and OBIEE.
• Good programming experience in Transact SQL, SQL, PL/SQL, Complex Stored Procedures, and Triggers.
• Profound experience in performing all functions of Systems/Software Development Life Cycle (SDLC) including business requirement analysis, writing Design documents and Test plans, data mapping, migration, conduct Unit, System testing, systems integration and user acceptance testing
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Filter, Expression, Lookup, Aggregator, Update Strategy, Router, Normalizer, Rank, Stored Procedure, Sorter, Sequence Generator and Joiner.
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Expertise in Data Warehouse/Data mart, OLAP and OLTP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Experience with advanced ETL techniques including staging, reusability, data validation, change data Capture (CDC) and Responsible for implementing QA testing methodologies and best practices for the various development and production support projects.
• Created ETL mappings using Informatica Power center to move Data from multiple sources like Flat files, XML, Oracle into a common target area such as Data Marts and Data Warehouse.
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/SCD Slowly Changing Dimensions (Type1/Type2/Type3) loads.
• Trained on Informatica MDM (Master Data Management).
• Extensive experience in writing UNIX shell scripts; Automation of the ETL processes using UNIX shell scripting.
• Well versed with different SQL Development Tools like TOAD & SQL Loader, MS Visio 2000 and Experience in using
• Automation Scheduling tools like Autosys, APOS.
• Capability of working with Code migration, Data migration and Extraction/Transformation/ Loading using Informatica Power Center and Power Exchange.
• Experience in OBIEE solution architecting (OBIEE 10g) in Ability to analyze source systems and business requirements, identify and document business rules, design data architecture.
• Strong experience as BI Developer in developing/modifying repositories and reports using OBIEE
• Experience in Metadata Modeling Confidential all three layers (Physical, Business Model and Presentation) using the OBI Administration Tool.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series.
• Experience in building, configuring and managing repository, creating and managing OBIA Dashboards, OBIA Answers, Delivers and iBots.
• Experienced in configuring OBIEE/OBIA Reports & Dashboards, OBIEE Delivers, advance Reports.
• Experience in setting up Object level and data level security. Configured OBIEE Variables and security Users and Groups.
• Good interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Ability to work independently as well as in any challenging team environment with strong analytical and problem-solving skills

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.5/9.1/8.6/8.1/7.1 (Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Transformations), PowerExchange, IDQ, SQL*Plus

Dimensional Data Modeling: Ralph Kimball Methodology, Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Normalization, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer and ERwin 4.x

Databases: Oracle 11g/10g, DB2 8.0/7.0, MS SQL Server 2000/7.0, Sybase and MS Access 2000

Programming: SQL, PL/SQL, Unix Shell Scripting.

Environment: HP-UX 10.20/9.0, Linux, MS DOS 6.22, Win NT 4/3.x/ 95/98/2000/XP.

OLAP Tools: OBIEE 11.X/10.X, BO 6.5/XI R2/ XI R3, SAP BO 4.0/4.1, Crystal reports

Other Tools: TOAD, SQL Loader, MS Visio 2000, Control-M, Autosys, APOS

PROFESSIONAL EXPERIENCE

Confidential, Concord, CA

Informatica Developer

Responsibilities:

• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Developed complex mappings using Informatica PowerCenter Designer to transform and load the data from various source systems like Oracle, flat files into the Oracle target database.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse for each of the areas Sales, Inventory, Shipment and HR.
• Involved in the creation of oracle Tables, Table Partitions, and Indexes.
• Involved in quality assurance of data, automation of processes.
• Involved in the development and testing of individual data marts, Informatica mappings and update processes.
• Identified and tracked the slowly changing dimensions (SCD)/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Used Task developer in the Workflow manager to define sessions
• Created application-specific Data Marts so that users can access personalized dashboards of information that is specific to their department and business unit.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Created repository, users, groups and their privileges using Informatica Repository Manager
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Connection management and scheduling of jobs to be run in the batch process
• Data profiling, validating, monitoring and cleansing across the enterprise through Informatica Data Quality (IDQ)
• Responsible for co-ordinating the work and also transfer knowledge to the offshore crew.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher
• Designed Star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.

Environment: Informatica PowerCenter 9.5, Oracle 11g, IDQ, SQL, UNIX Shell Programming, ERwin 4.0 and Windows NT, OBEE 11.

Confidential, Atlanta

INFORMATICA LEAD

Responsibilities:

• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Involved in the analysis, design and development of all the interface’s using Informatica Power center tools in interface team and interfaced with all the other tracks for business related issues.
• Used ERwin to provide initial physical models to meet current naming standards and/or DDL for assigned projects.
• Coordinating with business and preparing the estimations, technical documents and design Documents.
• Making the offshore team to understand the requirement and make them to work.
• High proficiency with PowerCenter and involved in utilizing Informatica products to move Sybase and flat-file data to oracle.
• Create ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Defined Target Load Order Plan and to load data correctly into different Target Tables.
• Used PMCMD command for running Informatica from backend.
• Created PL/SQL procedures to populate date dimension table.
• Created and ran the unit test scripts for base data mart, remediate unit test defects and modified code accordingly, along with integration and acceptance testings.
• Deployment and Migration of Informatica mappings and workflows from dev to test and deployment groups.
• Used relational sources and flat files to populate the data mart.
• Translated the business processes into Informatica mappings for building the data mart.
• Worked on SQL tools like TOAD to run SQL Queries to validate the data.
• Used Debugger to test the mappings and fix the bugs.
• Created, updated and maintained ETL technical documentation.
• Creating Reports using Business Objects and enhancing the BO universes.
• Managing the BO user security and scheduling the reports.

Environment: Informatica PowerCenter 9.5, SAP BO XI-r3, SAP BI, Oracle 11g, PL/SQL, IDQ, UNIX Scripts, ERwin 4.5, Windows XP, AIX, Microsoft Visio, Sybase, Mainframe DB2 and TOAD.

Confidential, CA

SR. INFORMATICA ETL DEVELOPER/ANALYST

Responsibilities:

• Participated in the detailed requirement analysis for the design of data marts and star schemas. Worked with Data Warehouse Architect on logical and physical model designs.
• Worked with sources from Oracle, Teradata and flat files.
• Configured the connection settings to external Oracle using ODBC Connections. Used DBLinks to access Sybase and different source systems. Created complex SQL Overrides to read data from different tables and worked extensively with Materialized views.
• Involved in data cleansing, transformation and delta capture using Slowly Changing Dimension Type 1 and SCD Type 2 for historical data in Data Warehouse environment.
• Used various transformations like Lookup, Update Strategy, Joiner, Union, Filter, Router, Aggregator, Sorter, Sequence Generator, XML Source Qualifier, Union transformation and also used Procedure transformation to compare existing data that is already existing with the new data and updating records.
• Design and Develop Complex Informatica Mappings with multiple data sources.
• Created automated scripts, defined storage parameters for the objects in the database.
• Worked with Workflow Manager for the creation of Worklets, Sessions, Batches, E-mail notifications, Decision and to Schedule jobs.
• Developed pre and post session Stored procedures to drop, recreate the indexes and keys of target tables
• Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides
• Involved inETL integrationand code migration from environment to environment which involved thorough integration testing in DEV, TEST and PROD and suggested appropriate indexes to be built in order to improve the performance, identifying the impact on the window of end to end run when running simultaneously with other applications, identifying the resource consumption etc
• Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and enhancing exiting production ETL scripts.
• Populated error tables as part of the ETL process to capture the records that failed the migration.
• Created detailed test cases and objective of the mappings, performed user acceptance testing and documented on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 9.1 Oracle 11g, IDQ, PL/SQL, Sybase 12, Fixed width flat file, Windows NT 4.0, Business Objects and Toad.

Confidential, Sunnyvale, CA

SR. Technology Consultant

Responsibilities:

• Involved in discussion of user and business requirements with business team.
• Attended the meetings with business integrators to discuss in-depth analysis of design level issues
• Developed internal and external Interfaces to send the data in regular intervals to Data warehouse systems
• Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements
• Extensively used Power Center to design multiple mappings with embedded business logic
• Created transformations like Expression, Lookup, Joiner, Rank, Update Strategy and Source Qualifier Transformation using the Informatica designer
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator and Router transformations for populating target tables in efficient manner
• Created mapplet and used them in different mappings
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using various components like Parameter files, Variable and Dynamic Cache
• Written PL/SQL Procedures and functions
• Analyzed session log files in session failures to resolve errors in mapping or session configuration
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps
• Extensively written Unix Shell scripts and connectivity using MQ-series to route the files to different systems
• Provided reports using OLAP capabilities of Crystal Reports for the purpose of data analysis
• Acted as one of the key point of contacts performing onsite/offshore coordination
• Handling Critical Data Analysis/bug fixes, Escalation tickets - P1 and P2
• Optimize, Streamline and parallelize workflows and session execution. Created session dependencies within reporting database and with Oracle Apps and Clarify database
• Perform RPD changes and implementing DAC changes.
• Perform BO admin tasks - cleaning up of log files, administer security groups in CMC, user access, connections, universes, folders, defining row level and object level securities
• Designed/enhanced universes with multiple subject areas, aggregate awareness, fact linkage
• Implemented Time transformation contexts for fiscal and calendar period and calendar objects in universe and reports
• Created and migrated linked universes with running calculations
• Create business critical, analytical and financial complex deski and Webi reports with sub-queries
• Enabled Report bursting through custom macro
• Created Xcelsius Dashboard for Partner Performance for the Customer Service Organization
• Enhance and Automated Report Bursting with dependency on ETL load completion
• Reconcile revenue data during year-end and quarter-end earnings release and month-end reconciliation with the source system and with Shipments data
• Work with Oracle and BO on bugs and patches

Environment: Informatica PowerCenter 8.6, Oracle 10g, Toad, PL/SQL, HP-UX, Windows 2000, Unix shell scripting, Business Objects XIr2, Crystal Reports.

Confidential

DATA WAREHOUSE DEVELOPER

Responsibilities:

• Worked with the business analysts and DBA to gather business requirements to be translated into design considerations
• Involved in dimensional modeling of the data warehouse to design the business process, grain, dimensions and facts.
• Created cubes, dimensions, hierarchies, mappings and mapplets using Informatica Power Center Designer 8.1.
• Resolving the production issues in production support.
• Configured the Informatica Power Connect to extract data from Oracle 10g, SQL Server data sources.
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier on data extracted according to the business rules and technical specifications.
• Used task developer in the Workflow manager to define sessions.
• Created reusable worklets and mapplets.
• Involved in data cleansing and data profiling.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the sessions.
• Developed schedules to automate the update process and Informatica Batches/Sessions.
• Monitored sessions that were scheduled, running, completed or failed.
• Debugged mappings for failed sessions.
• Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions.
• Implemented data integrity constraints like referential integrity using primary-key and foreign-keys relationships.
• Involved in extensive performance tuning by determining bottlenecks Confidential various points like targets, sources, mappings, sessions or system which led to better session performance.
• Wrote PL/SQL procedures for processing business logic in the database.
• Involved in production support.
• Created different types of reports such as Master/Detail, Cross Tab and Chart (for trend analysis) using Business Objects. Use of filters, conditions, calculations,etc
• Documented processing times, developed test cases and used them to run through each process.
• Tuned the matching parameters based on test results.
• Implemented and supported the Business Intelligence environment and User Interface.

Environment: Informatica Power Center 8.1, Oracle 10g, SQL Server (2000/7.0), SQL/PLSQL, Perl, UNIX Shell Programming, Business Objects, ERwin 4.0, Autosys and NT

Confidential

DATA WAREHOUSE DEVELOPER

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Involved in Dimensional modeling to Design and develop STAR Schemas, used ERwin, identifying Fact and Dimension Tables.
• Worked with different Sources such as Oracle, MS SQL Server, Cobol, XML and Flat file.
• Used Informatica to extract data into Data Warehouse and extensively used several transformations such as Source Qualifier, Router, Lookup (connected & unconnected), Update Strategy, Joiner, Expression, Aggregator and Sequence generator transformations.
• Identified and tracked the SCDs, heterogeneous Sources and determined the hierarchies in dimensions.
• Used Trillium as a Data Cleansing tool to correct the data before loading into the staging area.
• Created reusable transformations and Mapplets and used them in mappings.
• Used Informatica Repository Manager to maintain all the repositories of various applications.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Claim Profitability Systems to facilitate Daily, Monthly and yearly Loading of Data.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and the Target Data.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Design and Development of pre-session, post-session and batch execution routines to run Informatica sessions using Informatica Server.
• Created and Scheduled sessions & Worklets using workflow Manager to load the data into the Target Database
• Wrote PL/SQL stored Procedures and Functions for Stored Procedure Transformations.
• Used Autosys to automate the process.
• Responsible for Installing, Configuring and Administration of OBIEE 10.3.3.4 Repository for Physical, Business Model and Presentation services.
• Responsible for implementing OBIEE for the modules Retail and Sales.
• Built the Physical Layer /Logical Layer/Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
• Extensively worked on Answers, Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector and Table).
• Designed Executive Dashboards to provide Business Critical Analytical view of the Written Sales for a set of Power Users

Environment: Informatica PowerCenter 7.1, PowerExchange, Oracle 10g, PL/SQL, MS SQL Server 2000, Flat file, Cobol, XML, Autosys, Linux, UNIX scripting, TOAD, ERWIN, Windows NT.