PROFESSIONAL SUMMARY:

• Over 15+ years of IT experience, Over 6+ yearsof experience in Information Technology wif a strong background inData warehousingandETLprocess and 7 year of experience in SAP BW.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica PowerCenter 9.5/8.6/8.0.
• Expertise in Dimensional and Relational Physical & logical data modeling using Erwin and ER/Studio.
• Extensively worked on Informatica Components like, Admin console, Repository manager, Designer, Workflow manager, Workflow monitor.
• Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / Denormalization strategies.
• Strong in Data Warehousing concepts, dimensional star schema and Snowflake Schema methodologies.
• Experience inPerformance tuningof theInformaticaandOracle.
• Strong expertise in Relational data base systems likeOracle, SQL Server, MS Access, DB2andTeradata.
• Worked wifXMLandFlat filesources coming from various legacy source systems and residing on Mainframe and UNIX.
• Created personalized version of reports as well as statements for customers using the data from Informatica metadata and tan generated Business Objects reports using slice and dice capabilities.
• Created Stored Procedures to transform the Data and worked extensively in T - SQL, PL/SQL for various needs of the transformations while loading the data into SQL Server database.
• Worked as an ETL developer and used Powercenter for supporting data extraction, transformation and loading phases. Other responsibility includes performance tuning and code optimization, Informatica 9.5 server installation at offshore etc.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica PowerCenter 9.x/8.x
• Possess good noledge in Data warehouse concepts like Dimensional Modeling, Star and Snowflake Schemas, Slowly Changing Dimensions etc.
• Extensively usedSQLandPL/SQLto write Stored Procedures, Functions, Packages and Triggers.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Proficient in 3-Tier SAP BI Architecture including Extractors, Info Providers, DTP, Transformations, Info Objects, Info sources, Info Packages and Hierarchies.
• Expertise in SAP BI 7.0/ 3.5/3.1C/3.0B/2.1C/2.0B configuration, Reporting, OLTP Extraction and Portal7.
• Proficient wif planning, Gap analysis, design implementation, Upgrade, Migrations, trouble shooting, performance tuning and user training of BW.
• Expertise of various data design models - Multi Dimensional/Star Schema and Extended Star Schema models.
• Proficient in Performance tuning using Aggregates, Partition and Compression.
• Experience in creating Views, Data sources in SAP R/3, ECC 6.0 and replicating them to BW in the process to load Generic R/3 Data into SAP BW.
• Worked extensively wif BEx Query Designer, BEx Analyzer, BO and Web reporting.
• Experience in extracting data from SAP R/3 (FICO, MM, SD), new dimension products like APO, SCM, SEM, and BW using different data extraction structures such as LIS, LO Cockpit, FI-SL, CO-PA and maintaining delta queues.
• Experience in creating Authorization profile to manage user access to Infocube data.
• Full cycle implementations of SAP R/3 and BW wif hands on experience of ASAP methodology.
• Excellent team member wif an ability to perform individually, good interpersonal relations, strong communication skills, hard working and high level of motivation.

TECHNICAL SKILLS:

ERP: SAP R/3 4.7 ECC 5.0 ECC 6.0

SAP Tools: ABAP Workbench, User Exits

Reporting Tools: SAP BEx and Web Reporting, MS- Excel, Analyzer, BO and OBIEE

Languages: ABAP/4, PL/SQL, JAVA

RDBMS: Oracle 11i, Oracle 8i, MS-SQL Server 2000, MS Access 2000

Database: Oracle 10g/9i/8.0, MS SQL Server 7.0

Upgrade: BW 2.1C to BI 7.3, SCM 3.0 to 5.0, SCM 4.0 to 5.0 and ERP 4.6c to ECC 5.0/6.0

SAP Modules: BW/BI, SD, MM, PP, HR, SCM, CRM, SRM, Retail modules

Data Warehouse - BW: SAP BI7.3 and BW 3.5, 3.1C, 3.0B, 2.1C, 2.0B

Data Warehouse - DW: Informatica PowerCenter 9.x (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Power Exchange 8.0, Datastage, Repository, Metadata, Data Mart, OLAP, OLTP, SQL, T-SQL, PL/SQL, Unix, Shell Scripting, TOAD, SQL*Plus, Excel, Word, Autosys, Control-M, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Sr. Informatica Developer

Environment: Informatica Power Center 9, Oracle 10g, Oracle SQL Developer, Solaris and BO.

Responsibilities:

• Worked closely wif client in understanding the Business requirements, data analysis and deliver the client expectation.
• Used InformaticaPowerCenter 9.xand its all features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Worked wif Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Extensively usedErwinforLogical and Physical data modelingand designedStar Schemas.
• Extracted data from different sources likeOracle,flat files,XMLandSQL Serverloaded into DWH.
• Created complex mappings in PowerCenter Designer usingAggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developedmappings/Reusable Objects/Mappletsby using mapping designer, transformation developer and Mapplet designer in InformaticaPowerCenter9.X
• Used InformaticaPowerCenter 9.X forextraction, loading and transformation(ETL) of data in the data warehouse.
• Handleslowly changing dimensions(Type I, Type II and Type III) based on the business requirements.
• UsedInformatica Power Center Workflow managerto create sessions, batches to run wif the logic embedded in the mappings.
• Involved in creation ofFolders,Users, RepositoriesandDeployment Groupsusing Repository Manager.
• DevelopedPL/SQLandUNIX Shell Scriptsfor scheduling the sessions in Informatica.
• Involved in scheduling the Informatica workflows usingAutosys.
• Migrated mappings, sessions, and workflows from development to testing and tan to Production environments.
• Involved inPerformance tuningfor sources, targets, mappings and sessions.
• Performedunittestingon the Informatica code by running it in theDebuggerand writing simple test scripts in the database theirby tuning it by identifying and eliminating thebottlenecksfor optimumperformance.
• Worked extensively wif different caches suchas Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Created deployment groups, migrated the code into different environments.
• Worked closely wif reporting team to generate various reports.
• involved in documentation for KT for the support team.

Confidential, Milpitas, CA

Informatica Developer

Environment: Informatica Power Center 9, Oracle 10g, Oracle SQL Developer, Solaris and BO.

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively usedvarious transformations such asSource Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joinerwhile migrating data from various heterogeneous sources likeOracle and Flat filesto Oracle.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Developed Mappings using Designer toextract, transformdata according to the requirements and loaded into database.
• Designed UNIXscripts and automated it to run the workflows daily, weekly and Monthly.
• Setting up Batches and sessions to schedule the loads at required frequency usingPower Center Workflow manager.
• Created sessions, database connections and batches using Informatica Workflow Manager. Developed mappings to load data in slowly changing dimension.
• Createdconnected and Un-Connectedtransformations to lookup the data from Source and Target Tables.
• ScheduledSessionsandBatcheson the Informatica Server usingInformatica workflow Manager.
• Monitoring the ETL jobs and fixing the Bugs
• Worked along wif the DBA to resolveperformance and tuning issues.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Involved in doingUnit Testing,Integration TestingandSystem Testing.
• Identified and created various classes and objects for report development.

Confidential, San Francisco, CA

Informatica Developer

Environment: Informatica Power Center 7.1, Oracle 10g, Oracle SQL Developer, Solaris.

Responsibilities:

• Extensively used ETL to load data from multiple sources toStaging area(Oracle 9i) usingInformatica PowerCenter 7.1
• Worked wif pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of IdentifyingFact and Dimension tables.
• Created reusable transformations and mapplets and used them in mappings
• Extensively used transformations such asSource Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Tuned sources, targets, mappings and sessions to improve the performance of data load
• DesignedLogical and Physical ModelingusingErwinData Modeler tool.
• Created SeveralInformatica Mappingsto populate the data into dimension and fact tables.
• Involved inPerformance tuningfor sources, targets, mappings, and sessions.
• Performedunittestingon the Informatica code by running it in theDebuggerand writing simple test scripts in the database theirby tuning it by identifying and eliminating thebottlenecksfor optimumperformance.
• Automated the load process using UNIX shell scripts.
• Created sessions and batches for incremental load and schedule them to run daily.
• ImplementedType II slowly changing Dimensionto maintain all historical information in Dimension Tables.
• Investigated and fixed problems encountered in the production environment on a day to day basis.
• Actively involved in the production support and also transferred noledge to the other team members.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Confidential, Oakland, CA

Informatica Developer

Environment: Informatica Power Center 9, Oracle 10g, Oracle SQL Developer, BO and OBIEE.

Responsibilities:

• Evaluated and documented Business processes to accurately reflect the current and future state of the process
• Analyzed new applications as they relate to Business and existing applications
• Developed prototypes of a new application to be used wif customers to confirm requirements.
• Identified and tracked the slowly changing dimensions from heterogeneous sources and determined the hierarchies in dimensions.
• Implemented weekly error tracking and correction process using Informatica.
• Implemented audit process to ensure Data warehouse is matching wif the source systems in all reporting perspectives.
• Experience wif Client/Account data management systems
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL.
• Created maestro schedules/jobs for automation of ETL load process.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and tan to production environment.
• Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Involved in developing test data/cases to verify accuracy and completeness of ETL process.
• Written UNIX shell Scripts for getting data from systems to Data Warehousing system.
• Actively involved in the production support and also transferred noledge to the other team members.
• Involved in Data loading to staging tables loading to Target tables OBIEE Database.
• Working closely wif offshore ETL and OBIEE team wif onsite team resolving the Reporting mapping issue and logics.
• Performed Data Analysis and Data matching between SAP and OBIEE Database.
• Utilized the Debugger utility to test the mappings.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status, UNIX job scripts for scheduling jobs in AutoSys.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Confidential

LTX-Credence Corporation

Environment: ECC6, SAP BW 7, BPC5.1, Oracle, SQL, BO and Portal7/XI, Informatica Power Center 8, Oracle 10g, Oracle SQL Developer, UNIX, Solaris).

Responsibilities:

• Extensively developed various documentations (Technical spec, Functional Spec, Training documentation for end user and etc).
• Day to Day online Production support.
• Extensively worked on System Migrations, Upgrade Support and Support Packs.
• Upgraded BW 3.0B to BI7. Upgrade supported for R/3 4.6C to ECC 6.0, Portal 7.0 and CRM5.0 upgrade support.
• Supported for Support packages in different areas (BI7, CRM, Portal and ECC)
• Worked extensively on BEX analyzer, Developed flexible queries using filters, Calculated KF, Restricted Key figures, Navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information. Worked wif WAD & Portal 7.0
• Design, develop and implement SAP BW and Business Objects (BO) Reporting Solutions, Knowledge wif Complex Dashboards design. Web Intelligence and Crystal Reports.
• User training for Front end tools (Bex, BO and Portal) .
• Extensively worked wif migration the data from BW to Informatica.
• Worked wif Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Worked wth Informatica PowerCenter Connect to SAP ECC and integrated data from SAP ECC wif other enterprise data sources.
• Created SAP BW OHS source definitions in Informatica and configured work flow to run from SAP process chain.
• Determine Extraction and Loading techniques from and to SAP, also from Non-SAP sources to SAP using Informatica Power Exchange v8 for SAP Data Integration.
• Extensively involved in Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Extensively worked on tuning of Informatica map for better performance.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Extracted data from Heterogeneous source systems like Oracle, SAP, SQL Server and flat files.
• Used BCI connect and upload the data into SAP thru Informatica.
• Worked wif business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions.
• Worked on Version Control in Informatica to maintain multiple versions of an object, control development on the object and track changes.
• Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.
• Extracted data from different sources like Flat files (CSV and Text), Oracle and SQL Server Data Bases.
• Developed Informatica workflows and sessions associated wif the mappings using Workflow Manager and also created various tasks like e-mail, Command, Event-Raise, Event-Wait, Timer and Decision.

Confidential, San Jose, CA

SAP BW Architect

Environment: SAP BW 3.5, CRM, FI-CO, SEM, SAP R/3 4.6C, Portal5, Windows and UNIX.

Responsibilities:

• Interacted wif Macromedia CRM Sales channel, Material channel for Historical Data, Interacted wif the CRM and SEM Team.
• Setting up planning area and Scheduling Data transfers in between SEM-BPS and BW cubes. Supported to SEM team. Designing, developing and implementing data warehouse using SAP BW wif SAP R/3 Sales and Distribution, Inventory Management and Financial Module.
• Evaluating Business Content for SD, FI-CO modules and activating the relevant Business Content Objects and designed custom Info cubes for company wide Sales, delivery, and billing wif various aggregate periods.
• Involved in modeling of transactional info cubes for aggregation of Plan data.
• Extensively used process chains to automate the process of loading data into data targets. Performed various tuning techniques (aggregates, statistics and partitioning) to optimize the query performance.
• Enhancements to the different type of data sources like Macromedia Historical sales data, Macromedia Inventory info Cubes, Revenue info Cubes, Adobe FY cubes developed multi cubes for Adobe and Macromedia for revenue data..
• Developed process chains to run the periodic loads and other processes. Also monitored data loads to ensure smooth uploads by managing packet sizes and eliminating inconsistencies.
• Working wif extraction from SAP to BI and upload the data into Portal.
• Handling of day-to-day BW problems and reporting issues raised by business key users. Resolve and implement BW Query faults and change requests.
• Working wif Update rules, transfer rules, update routines, and transfer routines as per client requirements.
• Configured BW transactional cubes for SEM (version 3.5).
• Setting up planning area and Scheduling Data transfers in between SEM-BPS and BW cubes. Supported to SEM team. Designing, developing and implementing data warehouse using SAP BW wif SAP R/3 Sales and Distribution, Inventory Management and Financial Module.
• Evaluating Business Content for SD, FI-CO modules and activating the relevant Business Content Objects and designed custom Info cubes for company wide Sales, delivery, billing wif various aggregate periods.
• Used LO Cockpit to activate and load transaction data from the Sales header and item detail & Purchasing header and item detail Data Sources.
• Designing and creating several Queries using BEx Analyzer, wif drilldown functions, variables, exceptions, calculated key figures using formulas and variables, restricted key figures and structures.
• Creating Web templates using the Web application wizard of Web Application Designer, configuration of Web template properties, and using Web items (tables, charts, drop-boxes etc.).
• Updated BI report to portal.
• Designed and implemented complex processes for Extraction Transformation and load (ETL) of data coming from various OLTP systems into Data mart/EDW.
• Working as part of Data warehouse ETL development team to ensure ETL data movement is according to business requirements.
• Handled Tickets for the Global Support Help Desk on Query execution and Performance issues. Preparing test plans and test cases for defects.
• Handling of day-to-day BW problems and reporting issues raised by business key users. Involved in different testing in bw data loads and performance tuning.
• Conducted training sessions for users in BW reporting, data extraction and Info Cube design.

Confidential, Rockford, IL

SAP BW Consultant

Responsibilities:

• Involved in full life cycle implementation of SAP BW for FI/CO, SD and MM module and actively involved in ASAP methodology.
• Upgrade Support for development and user team for Upgrade from BW Ver 3.0B to Ver 3.5.
• Configured BW transactional cubes for SEM (version 3.5). Setting up planning area and Scheduling Data transfers in between SEM-BPS and BW cubes.
• Created and activated Info Cubes, Info Sources, Multi-Providers, Transfer structures, Transfer rules, Communication structures, Update Rules (both ODS and Info Cube level) and conversion techniques.
• Configured alert monitor, Job schedule monitor, Exceptions handling and user role maintenance. Involved in creation of role based security and authorization for certain Info Cubes and Info Objects.
• Created web reports through report templates in WAD, Training end users in query development-using BEx.
• Training end users in query development-using BEx.
• As SAP-BW Consultant, actively participated in the development and maintenance of SAP BW 3.0B/3.1C.
• Responsible for preparing the Technical specifications, Design documents, Review reports, integration and stress tests in QA,
• Very extensively worked in the Enhancement of Info Cubes, Creation of Update Routines and Conversion routines.
• Extensively Developed Unconstrained Demand plan, Product master, product list Reports.
• Developed VB code for BEx Query via VB Exits, Extracted data from Info Cube-based KF, Sending Master data APO cubes to BW cubes.
• Running optimizer for Sales history data weekly wise and monthly basis. View Optimizer Log Files.
• Product Master will be extracted daily from BPCS to BW and on a weekly basis, APO will extract the product Master from BW to populate the info objects.
• Scheduled extracted jobs, grouping of extract jobs, monitoring of transfer and update for data loads.

Confidential

SAP/BW Consultant

Responsibilities:

• Extensively involved in Activating Business Content for Standard Info Cubes, info Sources & Info Objects of SD Module as per the Client Requirements
• Generated transactional Data Info sources and Master Data Info sources Worked wif Transactional Data Info Sources to load Data from SAP R/3 and Flat Files systems into BW
• Created Info Packages Scheduled them in order to load Master Data and Transactional Data from SAP R/3 as well as Flat File Source Systems into BW
• Extensively worked wif PSA in Monitoring the Data Transfer from Source Systems into BW, Schedule Daily/Weekly/Monthly data loads, schedule new jobs.
• Developed and schedules Business Content Data Extraction for SAP R/3 source system, Creating info packages, monitor setting and logistics cockpit configurations.
• Logistics cockpit configuration and customization for sales order overview. Uploading Master and Transactional data from Flat files and SAP as the OLTP sources, worked extensively on Administration workbench.
• Worked extensively on BEx analyzer and BEx Browser. Developed flexible and configured use of Restricted Key Figures, Exceptions, Currency conversions, Variables, and Queries using Filters in BEx Analyzer.
• Used delta update mechanisms for uploading the data to BW from R/3. Worked wif ODS and PSA
• Responsibilities:
• Worked on the SAP-Script layout sets in SD, MM and FI modules. The document modified layout set RVORDER01& MEDRUCK and the corresponding print program modified as per the client’s requirements. To modified invoices, credit memos, purchase order and mass mailing labels.
• Developed Delivery / Shipping Document Output Print Control Program. This program performs the overall Shipping Document Print Control Function.
• Developed a BDC-batch input program for transaction FK01 to transfer Vendor address into R/3 systems
• Written BDC programs to upload customer master details using transaction VD01 from legacy system to R/3 system.
• Generated shipping details of a material group based on product order and company code.
• The scope of the project was to develop custom reports in SD and MM modules.
• Responsibilities:
• Development of Sap scripts and reports for Goods Issue Note, Good Receipt Note, Transfer Note, Non Conformity Report, Bank and Cash receipts etc for SD module.
• Customizing and setting up of ALE on new clients / systems
• Maintenance of the customer distribution model, distributing the customer model, generating partner profiles. Involved in all types of outbound and inbound process like via Message control, Standalone and Change pointers and Function Module.
• Defined the material in central office and distributed to different places to other SAP systems by using ALE Technologies. Worked extensively on Vendor Mater interface using Message type CREMAS.
• Involved workflow consists of a collection of activities, which support a specific business Process. Customization of the SAP standard templates, creation of new methods, events and triggers, Configuring Workflow to handle all ALE/EDI error messages.