SUMMARY:

• 11 years of IT experience of which 8 years in SAP Business Consolidation Systems/Business Planning and Consolidation/BI/HANA and 3 years in Informatica / Oracle / Teradata /BO
• Proven record of success in providing solutions in Data Integration and Business consolidation and planning, Business Intelligence applications.
• Adept at implementing & supporting Business Consolidation Systems/Business Planning and Consolidation Actual, ROFO, AOP and performing MEC/QEC/YEC activities.
• Extensive hands - on experience configuring BPC objects of Models, Dimensions, Reports, Input Forms, Data Manager Packages, Process Chains, Dimension Formula, Security Profiles, and Work Status & BPF etc.
• Worked on BPC EPM Reports and Input Form based on Property and using EPM Function like EPMRetriveData, EPMDimensionOverride, Axis override, Context Member, Dimension List, Member Offset, Save Comment, Dimension Property Value.
• Extensively worked in Business Information Warehouse Info Cubes, ODS Objects, Info Sources, Info objects, Transfer rules, update rules, Info packages, Info objects Catalogs, Data sources, Data Extraction, Characteristics and Key figures, Business Content, Data Marts, Process Chains, specific to SD, MM.
• Created Universe - providing authorizations - data maintenance in Oracle tables - publishing the dash boards in web and testing in dashboard reports SAP Business Objects.
• Extremely familiar with Informatica Power center for implementation of ETL methodology in Data Extraction, Transformation and Loading
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer and Workflow Manager & Workflow Moniter
• Skilled in requirement gathering, gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning
• Strong functional experience on SAP BCS, BPC 10.0 NW, BI, HANA, Informatica, Oracle, TeraData, Business Objects.
• Thorough understanding of Data Warehousing, Data Marts, Star, Snow Flake Schema Modeling, Dimensional Modeling, Entity-Relationship Modeling, OLTP and OLAP concepts.
• Experience in coding using SQL, PL/SQL for Cursors, Stored Procedures/Functions, Triggers and exception handling
• Well versed with full Software Development Life Cycle (SDLC) - Design, Development, Testing and Implementation

TECHNICAL SKILLS:

Key SAP Skills: BPC, BCS, BW, BO, ECC

Key BOBJ Skills: Webi, Analysis Office, Design Studio

Key ETL Skills: Informatica

Key DW Skills: SAP BW, SAP HANA

Programming Language: ABAP, SQL, PL/SQL, Tera data

PROFESSIONAL EXPERIENCE:

Confidential

SAP BCS/BPC/BI Consultant

Responsibilities:

• Responsible for all Business planning and Consolidation Systems/EFR and C-BCS support activities/issues and managing BCS/EFR team
• Involved in validation, creation & modification for Monthly MEC/ROFO/AOP.
• Coordinating with various teams during MEC/QEC/YEC to resolve issues.
• Involved in Business Planning and Consolidation unit testing when sp upgrade, preparing Reports and Input Form for checking the data submission, BS, P&L and Financial statements using EPM Add- in and Input schedules for entering the Plan Data.
• Worked on Business Planning and Consolidation EPM Reports and Input Form based on Property and using EPM Function like EPMRetriveData, EPMDimensionOverride, Axis override, Context Member, Dimension List, Member Offset, Save Comment, Dimension Property Value.
• Input Form and Report using Dynamic Filter and Formatting.
• Active participation in BCS ROFO, AOP and BCS FCR implementations & Support.
• Active participation in MEC/QEC/YEC activities & interacting with business on issues.
• Adherence to SLA compliance on change requests and incidents.
• Working on performance issues in BPC.
• Created Business rules for Currency conversion, Elimination and adjustment’s, Balance carry forward.
• Reports and Input Form for checking the data submission, BS, P&L and Financial statements using EPM Add- in.
• Input schedules for entering the Plan Data and Input Form and Report using Dynamic Filter and Formatting.
• Extensive hands-on experience configuring BPC objects of Models, Dimensions, Reports, Input Forms, Data Manager Packages, Process Chains, Dimension Formula, Security Profiles, and Work Status & BPF etc.
• Involved in preparing the detailed system designing document.
• Setting up the Planning, Legal, Ownership and Rate application model.
• Setting up the application/Model parameters and work status; Setting up the Auditing from the BPC Web.
• Validating the data in SAP BPC with the source data to avoid the data inconsistency.

SAP BCS/BPC/BI Consultant

Responsibilities:

• Responsible for all BCS/EFR and C-BCS support activities/issues and managing BCS/EFR team
• Involved in validation creation and modification for Monthly MEC/ROFO/AOP.
• Working in CLOU ORU Merge Project which is merging IG&S ORU with another CL Sector ORU.
• Coordinating with various teams during MEC/QEC/YEC to resolve issues.
• Active participation in BCS/BPC ROFO, BCS AOP and BCS FCR implementations & Support.
• Active participation in MEC/QEC/YEC activities & interacting with business on issues.
• Conducted additional knowledge Transfer sessions to the team and worked on performance issues in BPC.
• Involved in BPC unit testing when sp upgrade, preparing Reports and Input Form for checking the data submission, BS, P&L and Financial statements using EPM Add- in and Input schedules for entering the Plan Data.
• Reports and Input Form based on Property and using EPM Function like EPMRetriveData, EPMDimensionOverride, Axis override, Context Member, Dimension List, Member Offset, Save Comment, Dimension Property Value.
• Input Form and Report using Dynamic Filter and Formatting.
• Extensive hands-on experience configuring BPC objects of Models, Dimensions, Reports, Input Forms, Data Manager Packages, Process Chains, Dimension Formula, Security Profiles, and Work Status & BPF etc.
• Validating the data in SAP BPC with the source data to avoid the data inconsistency.

Sr. SAP BI/BW Consultant

Responsibilities:

• Involved in System Monitoring to observe the data loads and resolving Functional issues raised by Business users
• Extensively worked on fixing the issues from front end and backend.
• Involved in weekly BIA index rebuild and resolving ACR issues which are ran by long time.

Sr. SAP BI/BW/BO Consultant

Responsibilities:

• Involved in resolving Functional issues raised by business users, handling tickets raised by users and resolving them within SLAs
• Handled Performance tuning like Creation of aggregates, roll up, Check Statistics, Indexes and Compressed the Info Cube to improve the query response.
• Involved in loading daily & weekly flat files, Rectification of Load Failure errors like Master Data Loads and Transaction Loads and checking, fixing & monitoring BI-accelerator related issue.
• Reconciliation of data loads in GSAP BW as well in GPMR BW system with the selection criteria of the load and resolving all Reconciliation issues during ME loads.
• Involved in Regression testing before and after the new changes move to production
• Involved in Year End New Changes for FPS System, CMI-MEC activity & SP and solving the B.O report issues in FPS
• Actively involved in E-BOSS BO testing and fixing the BO issues.

SAP BI/BW Consultant

Responsibilities:

• Involved in Load Monitoring Using RSPCM, RSMO, SM37, and Query monitoring Using RSRT.
• Handled the tickets of priority S1, S2 and S3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
• Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.
• Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
• Maintained list of all the activities for all the tickets until it is closed down.
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Actively and regularly involved in Load Monitoring of Daily data loads using Process Chains.
• Actively involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Monitored info packages and analyzing the reasons for frequent failures of info packages.
• Maintained Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.

SAP BI/BW Consultant

Responsibilities:

• Hands on exposure in implementation and maintenance of SAP BI Applications
• Involved in extracting the data from standard tables by using standard LO, Generic Extraction
• Extensively worked on logistics specific to SD, MM (2LIS 02 HDR, 2LIS 02 ITM)
• Involved in creating the Generic data sources and generic deltas by using function modules.
• Experience in support involving maintenance of Process Chains, data loads and resolving the errors.
• Created Transformations, DTPs and data targets such as DSO Objects and cubes for specific to the countries
• Mapped these info objects in Transformations and DTPs with the source fields.
• Created info packages and scheduled the data loads and monitored the loads
• Involved in creating process chains (RSPC) and data loading activities using load monitoring.
• Solving tickets related to various areas like load failures, report issues & data inconsistency problems.
• Involved in creating the Workbooks and Queries using BEx Analyzer
• Involved in Production support for all modules such as SD, MM.
• Responsible in creating a customized program (using ABAP) which places the flat files on the application server and these files are used to load the master data with the help of process chains.

Confidential, Milwaukee

ETL Developer

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Center 7.x from Oracle to Teradata.
• Developed end-to-end ETL process from various source systems to Staging area and from staging area to Data Marts
• Worked on Informatica to extract data from Main Frame & Oracle database and to load the data into staging Database
• Implemented the Changed Data Capture (CDC)
• Monitored sessions using the workflow monitor, which were scheduled in Redwood Cornicle, running completed or failed. Debugged mapping for failed sessions.
• Implemented the Incremental loading of Dimension and Fact tables.
• Performance tuning of the Informatica Power Center Mappings as well as the tuning of the sessions.
• Created Tasks, Workflows, and Sessions to move the data at specific intervals on demand using Workflow Manager, Workflow Monitor and Redwood Chronacle; Optimized query performance, session performance.
• Performed integrated testing for various mappings. Tested data and data integrity among various sources and target.
• Dealt with the performance issues and made necessary coding changes for improving the system Performance.
• Performed data profiling and data cleansing using Informatica to manage the data more efficiently
• Responsible for developing, unit testing the code and validating the data.
• Used Mapping Debugger to identify bugs in mappings by analyzing data flow and evaluating the transformations.
• Implemented Slowly Changing dimensions methodology to keep track of historical data.
• Worked extensively with Teradata Utility tools like Mload, BTEQ, and Fload and Query man.
• Created BTEQ scripts for extraction and transformation of data to the warehouse.
• Created the documents to help new developers understand the environment and guidelines for setting up new development environment. Also documented the execution steps for various processes for the purpose of System Testing, Unit Test Cases, Chronicle, Job Chains, MD 120 and Performance Metric.
• Used the mapping parameter to make the mapping more flexible; Prepared ETL Specs according to Business Rules.
• Performance Tuning of Sessions & Mappings for better performance; used Merge Scripts to load data into warehouse
• Created universes for Application Foundation in business objects.
• Created Metrics for the Universes.
• Developed text cases and performed Unit test.
• Generated different reports and Involved in the Unit testing to check the data consistency.