SUMMARY:

• 11 years of IT experienceof which8 years in SAP NW Business Consolidation Systems/ NW Business Planning and Consolidation/BW/HANAand 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 & supportingNW Business Consolidation Systems/Business Planning and ConsolidationActual, ROFO, AOP and performing MEC/QEC/YEC activities.
• Extensive hands - on experience configuring NW 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 EPM Context Member, EPMRetrieveData, EPMDimensionOverride, Axis override, 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 reportsSAP Business Objects.
• Extremely familiar withInformatica 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 Monitor
• Skilled in requirement gathering, gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
• Strong functional experience onSAP 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

CORE COMPETENCIES:

• SAP NW Business Planning and Consolidation - Hands on Experience in BPC Functionalities - Data Modelling, Data Manager Packages, Script Logic, Process Chains, Dynamic Reports and Input Schedule Templates and consolidation functionalities. 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.
• SAP NW Business Consolidation Systems - Proficient in BCS functionalities - Data basis, Data Collection, Validations, Reclassifications, Interunit elimination and Reconciliation, Currency Translation, Master Data management, Balance Carry forward, System Comparison and System Sync up Activities. Active coordination in MEC/QEC/YEC-Actuals, ROFO and AOP.
• HANA MODELLING - Designing Views (Attribute View, Analytic View, and Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script, Variables and Input Parameters, Calculated and Restricted Columns, Currency Conversion, Hierarchies and CESQL scripting, Export/Import of Models, Validating Information Models, Creating Schemas, Manage Schema Mapping, Performance Tuning.
• HANA SQL SCRIPTS & CDS CORE DATA SERVICES - Strong experience on Creating SQL, Stored Procedures with SQL Scripts with Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like - Tracing, Using the SQL Script Debugger.
• BW/BI - Extensively worked in Business Information Warehouse Composite Providers, ODS Views, ADSO’s, Info Cubes, ODS Objects, Info Sources, Info objects, Transformations, Transfer rules, update rules, Info packages, Info object Catalogs, Data sources, Data Extraction, Characteristics and Key figures, Business Content, Data Marts, Process Chains, APD’s, Process chains specific to SD, MM.
• BEx Analyzer/AFO - Design the reports - Performance actions - Quick Filters - Parameters - Manage extracts - Publish to Server.
• BO - Created Universe – providing authorizations - data maintenance in Oracle tables – publishing the dash boards in web and testing in dashboard reports.
• Informatica – Mappings/Workflows development – Parameters & Variables – Push down Optimization- Scheduling – Migration
• Teradata& Oracle – Understanding the Data – Data Analysis – Query performance Tuning – Extract Data from Oracle data base.

TECHNICAL ACUMEN:

Key SAP Skills: BPC NW, 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, Massachusetts

SAP NW BPC/BCS/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 Context Member,EPMRetrieveData, EPMDimensionOverride, Axis override, Dimension List, Member Offset, Save Comment, Dimension Property Value.
• Worked on housekeeping activities to improve the report execution.
• Very good experience in Data Manager Packages.
• Had experience in SP upgrade in BPC NW.
• Input Form and Report using Dynamic Filter and Formatting.
• Developed and maintained periodic reporting, forecasts and AOP packages.
• Performed monthly Cash Flow, P&L and Balance budgets & forecasts.
• 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 NW Web.
• Validating the data in SAP NW BPC with the source data to avoid the data inconsistency.
• Created Calculation, analytical, attribute views, Composite providers and reports for the specific SD, MM, FI functionalities.
• Created ADSO’s based on the requirements and replaced the existing DSO’s for FI flows to improve the performance also supported the existing DSO’s and ODS objects.
• Extensively worked on Native HANA SQL script basedCalc views, SDA’s and Store procedures for FI and COPA report needs.
• Created and performed Data provisioning techniques for AR and GL, Material Cost reports.
• Deployed Native HANA objects from DEV to QA and PROD and transported the corresponding CP’s from BW Dev to QA and PROD accordingly.
• Created HANA based DTP’s and included in the process chains to improve the overall system loading performance.

Confidential, Massachusetts

SAP NW BPC Architect

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.
• Involved in creating ADSO’s, APD’s, CP’s based on the new reporting requirements.
• Extensively worked on Native HANA SQL script based Calc views, SDA’s and Store procedures for FI and COPA report needs.
• Created and performed Data provisioning techniques for AR and GL, Material Cost reports.
• Deployed Native HANA objects from DEV to QA and PROD and transported the corresponding CP’s from BW Dev to QA and PROD accordingly.
• Created HANA based DTP’s and included in the process chains to improve the overall system loading performance.

Confidential

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.

Confidential

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 Confidential 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
• Actively involved in E-BOSS BO testing and fixing the BO issues.

Confidential

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.

Confidential, California

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

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 informaticato 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.