SUMMARY

• Over 14+ years of IT experience with 12 years SAP BW experience which include 2 years in SAP ABAP. Ability to work independently and as part of a team. In - depth knowledge of ETL Concepts.
• 4 Full Life Cycles Implementations involved in Sizing, Security and Data Modeling in SD, MM, PP, Vistex, Retail, APO, FICO and COPA functional areas.
• Experience in 2 End to end migration SAP BW on HANA projects and involved in data base Migration and Green Field implementation. Involved in Sizing and modeling of In-memory optimized objects.
• Hand on experience with In-memory technologies like SAP HANA with exposure to data provisioning, modeling and Administration roles.
• Very Good knowledge on LSA++ for HANA and BW Implementation. Involved in end to end for Full Life cycle implementation Project for BW on HANA.
• Extensive knowledge of SAP BW/BI components and ETL process like creating Info Cubes, Multi Providers, Remote Cubes, Transactional Cubes, Data Marts, Info Source, Info Package, Data Source, Info Objects, DSO, Update rules, routines, Transfer rules, Process Chains and Event management for Automation process, Transformations in BI 2004s.
• Expertise in Business Objects 4.1, Design Studio, Universe Designer, Web Intelligence Dashboard Designer, SAP Crystal Reports and OLAP Analysis Involved in building reports using SAP BO 4.1 and integrating with BI 7.5 on HANA.
• Involved in SAP Net Weaver BW Accelerator (BWA) sizing and Implementation, familiar with all BWA day to day Issues and trouble shooting.
• Expertise in OLTP extractions from SAP R/3 using LO Cockpit, CO-PA, Generic Extractions and flat files.
• Written complex ABAP user exits for transaction/master data extraction and Bex variables and complex routines in start routine and update routines.
• Involved in Setting up Information Broadcasting by creating Pre-calculation servers. Worked on query and workbook-based broadcasting.
• In-depth knowledge in BPC 10.1, SEM-BPS, Planning Area, Planning Levels, Planning Layouts, Planning Folders, Planning Profiles, Planning Functions, Planning Packages.
• Expertise in Performance Tuning of OLTP, Reporting Performance, Roll-up performance, performance analysis during Extraction/Data load and System Monitoring.

TECHNICAL SKILLS

Applications: SAP BW (3.x to 7.5), SAP BW on HANA, ECC 6.0 ABAP, HANA Studio, SEM-BPS, BPC 10.1, SAP BO (3.1 and 4.1).

Reporting Tools: Query Designer, Analyzer, Web Application Designer, BOBI 4.0 (Information Design Tool, Web Intelligence, Explorer, Analysis Office, Lumira).

Programming: ABAP, VBA, C, C++, Java, SQL.

PROFESSIONAL EXPERIENCE

Confidential, TX

BW Analyst

Environment: SAP BW 7.5, BO 4.2, and SAP ECC/DBM 8.0.

Responsibilities:

• Involved in Migration Project from BW 7.3 to 7.5 on HANA, Including Sizing, preparation, Cutover activities and Testing. Converted old data flow objects to new dataflow using new in memory business content.
• Created Multiple webi reports using bex queries and HANA views and Published through dynamic recipient based on branch roles. Created/Updated Design studio dashboards using Bex queries and Visual BI Components.
• Installed IMO Inventory management data models and created dynamic No Sale, inventory turns and goods movement analysis reports.
• Involved in Production Support activities and finetuned several process chains and ABAP extractors.
• Involved in ECC/DBM 8.0 Upgrade project and responsible for all BW related extractors, ABAP user exits and upgrade cutover activities.

Confidential, Collegeville, PA

Senior Consultant

Environment: SAP BW 7.5, BO 4.1, and SAP ECC 6.0.

Responsibilities:

• Worked on BW 7.5 on HANA migration project including data flow migration from 7.0 to 7.5 and converting BW data models to ADSO and Composite providers by replacing info sets and Multi providers and related ABAP code changes.
• Worked on Migration of Bex to BOBJ conversion project, scope include Analysis, design and development of Bex and WAD reports to OLAP Analysis, Webi and Design Studio reports.
• Re-designed Genealogy Model with delta capability to improve the data load performance and related simplifications. Designed Backend model and reconciliation process to validate the Genealogy data.
• Involved in NLS Data Archiving project, was responsible for Identify and analyze the impact on Manufacturing, Quality and Packaging data models and develop the archiving process for those data models.
• Designed and developed/enhanced Design Studio dashboards for Manufacturing Production schedule adherence and Operational Metrics. Developed backend data model, BEx queries for these Dashboards.
• Responsible for analyzing and enhancing the data models and making Global Report changes for new international Rollouts.
• Responsible for onsite and offshore Co-ordination for Development work in Migration of data flows and archiving projects.

Confidential, Maryland, MD

BI Lead Consultant

Environment: SAP BW 7.4 on HANA, BO 4.1, and SAP ECC 6.0.

Responsibilities:

• Involved in Greenfield implementation of Confidential BW 7.4 on HANA project from feasibility analysis to implementation of BW 7.4 on HANA.
• Designed and developed POC for Impact Analysis of existing ECC data source feeding to BW 7.0 and BW 7.4 on HANA. Analyzed COPA and other time stamp-based extractors for delta Issues and parallel maintenance.
• Worked on HANA Modeler extensively worked on Relational Join and consumed data via IDT and published Business layer for BOBJ Reporting
• Installed HANA Optimized IMO content by activating Business functions and developed HANA optimized DSO’s and info cubes based on requirement. Implemented inventory with HANA optimized cube and build snap shot cubes for inventory aging.
• Built analytical and calculated view on MBEW and MBEWH tables to support operational reports. Consumed BW Models in HANA for BOBJ Reporting. Global Spend reporting rolled out on Business Explorer. Built analytical views and consumed in BW via Operation ODS, designed Virtual Data marts
• Consumed HANA views into BW through SAP HAP and Open ODS view to develop custom manufacturing data model by combing SAP, Hyperion and flat files data. Built operational reports for Raw material consumption and manufacturing cost.
• Created composite provider and joined DSO and HANA view for Non SAP source data and budget data.
• Replicated sales volume plan LIS table data from ECC through SLT and created HANA calculated views and exposed as analytical index and loaded data into DSO.
• Built open hubs and APD’s to migrate historical data from BW 7.0 to BW 7.4 on HANA.
• Created Webi reports for operational and dashboards with Bex queries developed on BW 7.4 on HANA.
• Redesigned existing BI data models in BI on HANA, migrated objects to HANA optimized DSO’s and SPO’s.
• Resolved performance issues in BI data loads, Bex quires and BW Accelerators.
• Front-line production support, to include help desk ticket resolution and on-call responsibilities.

Confidential, Jacksonville, FL .

Senior BI Analyst

Environment: SAP BI 7.0, SAP BO XI 3.1, and SAP ECC 6.0, BPC 10.1.

Responsibilities:

• Worked on Implementation of BI project with SD, FI, PP and Purchasing modules, Performed Requirement gathering, writing functional and Technical specs for BW and Business Object Enterprise XI.
• Responsible for complete BW Backend Design and Development, writing user-exits, extractors, Generic Data sources, Info cubes, DSO objects, Dataflow and Process chains.
• Developed BEx and Webi summary and Detail Reports and created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Performed configuration of servers, setting up user security, scheduling reports, import/export universes and reports among different environments, developing Universes, Dashboards, Web Intelligence and Crystal reports
• Proficiency in Scheduling, Publishing and Distribution of Business Objects reports using Broadcast Agent server.
• Developed complex web intelligence reports by combining multiple universes/queries. Formatting reports, generation of graphs etc as per user requested format.
• Involved in migration and deployment of the universes and webi reports across multiple domains using Import wizard.

Confidential

Senior BI Developer

Environment: SAP BI 7.0, SAP BO XI 4.0, SAP ECC 6.0.

Responsibilities:

• Worked on SAP Business Objects XI 4.0 implementation and developed Webi Reports, Summary and Detail Reports, Using the Summary as the source for the dashboard designer Detail is linked through Open Docs to view the User Selections from the Dashboard in Detail.
• Implemented BW-HR reporting for HR users. Created report for Headcount, Payroll and Benefits BEX & WEB Intelligence reports. Activated BI content heavily for the first ever BW implementation for the company. Define configuration for the implementation.
• Designed and developed MCER/WALK Analysis reports to analyze the price changes for sourcing team, data extracted on monthly basis using Analysis process design (APD) and loaded to summary level cubes and created Bex and WAD reports.
• Worked on SAP Vistex (Chargeback’s and Customer Rebates) module and related BI extractors. Involved in configuration, extraction, enhancement of Bill backs and Claims Data sources and created summary and detailed level Bex queries.
• Involved in SAP Net Weaver BI Accelerator (BIA) sizing and Implementation, familiar with all BIA day to day Issues and trouble shooting.
• Involved in the 2004s & ECC upgrade projects, pre-checks, technology upgrade, prepare, post activities, prepared test scripts and involved in all testing scenarios like integration testing and stress testing at every stage of upgrade.
• Coordinating with BI/R3-BASIS for BI load balancing, monitoring table space growth, searching and applying OSS notes.
• Extensively worked on broadcasting, broadcasted workbooks to SharePoint so that cooper agents can access their information regularly. Later we replaced some of the broadcasting workbooks with MDX query.
• Played Major role in the Cooper Connect Redesign Project, involved in gathering business requirements and conducting GAP Analysis to create generic function module delta enable extractors which replaces Matrix DB Connection solution for sales information.
• Performed design & code reviews for new developments and enhancement of the existing objects.
• Created process chains for daily data loads, created ABAP program to monitor the process chains and trigger emails based on chain status.
• Involved in SEM-BPS development/maintenance on day to day basis for Cost, sales planning Areas/Functions/Layouts and worked on cost data retraction to R/3.

Confidential, North Brook IL

Senior BW Consultant

Environment: SAP BW 3.5, SAP 4.7, ABAP/4 and VBA.

Responsibilities:

• Key member of FDW phase2 development team. FDW Phase 2 project involved collection of enhanced data (Statutory & Age of Development) from Premiums, Claims, Sales, Expenses and Profitability.
• Developed Intercompany reinsurance prototype to replacing the statutory reporting that comes from the Orion Database.
• Developed Accident year model and Report Year long tail model triangles for analyzing Estimating loss, calculating averages and trends, Estimating claim settlement using the Bex, Affinity 3.3 and VBA Macros.
• Partitioned cubes to store data annually to improve performance and data integrity. Number of cubes was increased from 6 to 25. Data was moved from old cubes to new enhanced partitioned cubes and the data validation between the new cubes and the old cubes was done using ABAP programs and Bex queries.
• Developed Infospokes and written BADI s to extract data from claims and premium cubes to validate and feed 3 rd party databases.
• Created new reports (AOD and Statutory) and modified existing reports (Premium and Claims) based on the new business requirements. Moved the old reports from old cubes to new cubes.
• Created comparison macros using VBA so that the QA team could use them to validate the reports in development and Staging systems.
• Trained offshore development team and super users on documentation and different functionality in workbooks.
• Participated in Daily status meetings and updated all the participants about current status, issues encountered and remedies.
• Assigned and tracked all the tasks that were assigned to the offshore team (5 offshore and 2 onsite resources) on a day to day basis. At onsite - handled all the high priority assignments and critical issues.

Confidential, IL

BW Consultant

Responsibilities:

• This project will consolidate all transportation and distribution information into a single SAP Business warehouse enabling comprehensive and improve responsive in identifying cost and service issues in Transportation & Logistics.
• Tasks include studying the Business Process and Interaction with the management to identify business requirements and define a Project Charter.
• Created Custom Infocubes/objects for the accommodating the global data available across the organization including COPA data from SAP, Non-SAP data using DB Connect and Flat Files.
• Participated in "wave 1" reports design and development, various testing phases (Unit testing, Integration testing, User acceptance testing, Regressions testing).
• Worked extensively on BEx Analyzer. Used Navigational attributes, Filters, Exceptions, Conditions, Jump targets (RRI), Variables, Hierarchies, etc. Created Templates for WEB Reports.
• Extensively used process chains to automate the process of loading data into data targets.
• Worked on Performance tuning in improving the load and read performance by maintaining indexes, partitioning, aggregates, query properties etc.