SUMMARY

• Strong experience in End - to-End Design, Development, Enhancements, Testing, Performance Tuning, Documentation, and Production Support for Reporting and Analytical Solutions.
• Worked closely wif business users and business subject matter experts (SMEs) to understand business processes and reporting requirements.
• Extensively worked on creating InfoObjects, DSO’s, InfoCubes, MultiProvider, InfoSets, SPO’s, DataSources, InfoPackages, Transformations, Transfer Rules, Update Rules, Routines, and Data Transfer Process.
• Good experience in creating Advanced DSO’s, CompositeProviders, Query in HANA Studio BW modelling tools (BWMT) and Exposed BW Objects as HANA views.
• Experience in creating SAP HANA information models like Analytical Views, Attribute Views and Calculation Views (Graphical and SQL Script).
• Well versed wif LO Cockpit Extractors, Generic Extractors, and FI/CO extractors.
• Worked on Real Time replication using SAP ( Confidential ) Data Provisioning method.
• Good knowledge of MM, SD, FI/CO, PP, PM, QM, CS, HR, APO-DP, and AFS modules.
• Good experience in ABAP/4 wif User Exit, Start, and End Routines.
• Experience in Open Hub (Info Spoke) to download data from InfoProviders to Confidential files.
• Good experience in creating APDs (Analysis Process Designer).
• Very good experience in Data Modeling, Extractions, Data Staging, Loadings, Transformations, and Reporting for Non-SAP systems data.
• Good experience wif BEx components - Query Designer, Analyzer, Workbooks, and Web Application Designer.
• Experience in creating Variables, Calculated Key figures, Restricted Key Figures, Filters, Structures, Selections, Cell Definitions, Exception, and Condition.
• Experience in creating Universes, WEBI (Web Intelligence) Reports, and Analysis for Office Reports.
• Extensively worked on performance tuning using Indexing, Compression, Aggregates, and Partitioning.
• Extensively worked on migrating 3.x dataflows into 7.x dataflows.
• Good experience in creating Process chains to automate teh loading process.
• Worked on Transports Management System and fixed if any transport issue.
• Involved in production support activities like to monitor data loads, correct data-load errors, re-run loads, research end-user issues, communicating to effected business users, and assisting wif root-cause analyses for continuous improvement.
• Good knowledge of CDS Views, Open ODS View and LSA ++ Best Practice.
• Very good knowledge of managing Hot/Warm/Cold data in SAP BW on HANA using SAP IQ database as an Near-Line Storage (NLS) solution.
• Good knowledge of implementing Data Tiering and Non-active data concept in BWoH.
• Knowledge of Security Concepts User Management, Roles, and Privileges.
• Good knowledge of SQL Joins, HANA Live, and Business Objects Data Services (BODS).
• Knowledge of Big Data, Design Studio, IDT, Xcelsius, Lumira, Crystal Reports, Life Cycle Management (LCM), and CMC (Central Management Console).
• Good knowledge of Smart Data Integration (SDI/SDA) and HANA XS.
• Knowledge of Design Backend Data models in Embedded BW used by S/4 Analytics & BI.
• Experience in creating Functional Specs, Technical Specs, Test Plans (Unit, Integration, and UAT), Document Test Results, and User Training Documents.
• Good experience in Application Lifecycle Management (ALM) tool.

TECHNICAL SKILLS

Data Warehousing: BW/4HANA, BW 7.5, BW 7.4, BW 7.3, BW 7.01, BW 3.5

ERP: S/4 HANA, ECC 6.0, ECC 5.0, SAP R/3 4.6c, SAP R/3 4.7

Languages: ABAP/4, SQL

Databases: SAP HANA, Oracle, DB2, MS SQL Server

OLAP/Reporting Tools: BEx Query Designer, BEx Analyzer, Workbooks, Web Intelligence(WEBI), and Analysis for Office

Testing Tools: HP Mercury Quality Center (ALM)

Methodology: Agile ASAP

Operating Systems: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SAP BW Architect

Responsibilities:

• Worked wif teh FI Functional team to gather requirements.
• Worked on creating InfoObjects, DSO, InfoCube, MultiProvider, Transformations, and Data Transfer Process.
• Created APD to update AR Aging BEx results to Direct DSO.
• Worked on writing End Routine (ABAP) to split teh manual GL posting record by Business Unit.
• Enhanced AR Aging BEx to add manual GL Postings and created Workbook for AR Aging Report.
• Extensively worked on production support activities on day to day basis.

Confidential, Oak Brook, IL

Sr. SAP BI HANA Consultant

Responsibilities:

• Extensively worked on designing HANA views like Analytical Views, Attribute Views and Calculation Views for Procurement tables.
• Extensively worked on Real Time replication using SAP ( Confidential ) Data Provisioning for multiple SAP ECC procurement tables.
• Worked wif teh business and APO functional team to understand teh APO-DP reporting requirements.
• Created Data Model for APO-DP to BW archival process by Daily / Weekly / Monthly.
• Worked on Eclipse based BW Modelling Tools (BWMT). Created InfoObjects, Advanced DSO’s, CompositeProviders, DTP’s, Transformations and Routines for teh APO-DP archival process.
• Worked on creating process chain to automate teh archival loading process.
• Extensively worked on creating teh following APO-DP BEx Queries; APO DP Daily Forecast Change Report, Forecast Exception Report (Forecast No History, History No Forecast), Forecast Monthly Waterfall Report, Forecast Value Add Report, Sales and Open Order 125% of Forecast Report & CVC Deletion Exception Report.
• Good experience in Application Lifecycle Management (ALM) tool.

Confidential, Philadelphia, PA

SAP BW/BO Architect

Responsibilities:

• Responsible for Architecture, Design, and Implementation of TOPTECH DW Project.
• Extensively worked on business requirements gathering for Marketing Terminals Data.
• Implemented solution to extract TOPHAT (Non-SAP) data into SXL BW system.
• Worked on Creating Confidential File Data Sources for Master Data & Transactional Data.
• Extensively worked on creating InfoObjects, DSO’s, InfoCubes and MultiProviders.
• Extensively worked on creating data flow which includes creating InfoPackages, DTP’s, Transformations and Routines.
• Created Process Chains and Implemented solution to automate teh Confidential file data load by writing upload program.
• Extensively worked on End Routine (ABAP) to populate Activity details.
• Extensively worked on creating BEx Queries for teh following Reports; Crude Trucking Analytics Report, Additives transfer Report, Additives Rebrands Report, Terminal Forecasting Report, Movement Report, Activity Summary Report, Activity Comparison by Daily / Weekly / Monthly and Gain Loss Summary Report.
• Extensively worked on creating WEBI Reports and Analysis for Office Reports for above mentioned BEx Queries.
• Created Functional Specifications and Technical Specifications for Marketing Terminals and uploaded them in Solution Manager.
• Extensively used CHARM (Change Requests Management) to implement this project.

Confidential, Findlay, OH

Sr. SAP BW/HANA Lead Consultant

Responsibilities:

• Extensively worked on Data Modelling, Data Extraction, Reporting, Scheduling, Monitoring and Performance Tuning.
• Involved in assessing SAP BW system on SQL Server for BW 7.4 Upgrade and HANA DB migration project using DMO (Database Migration Option).
• Worked on Pre-migration and Post-migration activities for DB migration (MS SQL Server to HANA) and BW 7.3 to BW 7.4 Upgrade project.
• Worked closely wif BASIS team to support on BW 7.4 Upgrade and HANA DB Migration Project.
• Worked on Design and Implementation of FI-AP, FI-AR, FI-GL, CO-CCA, CO-OPA, CO-WBS & FERC (Federal Energy Regulatory Commission).
• Installed necessary standard business contents as per business requirements.
• Worked on Creating Generic Extractors for Credit Master & Settlement.
• Worked on creating InfoObjects, DSO’s, InfoCubes and MultiProviders.
• Extensively worked creating data flow for FI/CO which includes creating InfoPackages, DTP’s, Transformations and Routines.
• Created Process Chain for FI Master Data and Transaction Data.
• Worked on creating teh following FI/CO reports; Balance Sheet, Trial Balance, Speedway Income Statement, Net Sales, Accounts Receivables Aging Report, Expense & Statistical Statement, Speedway Expense Analysis, Refinery Expenses Summary, Refinery Profit Cash Flow, Refinery Manufacturing Expenses, Cost Center Actual Line Items, Project Overview, Budget vs. Expenses, Capital Expenditures Progress, Net Rent Expense by City and State & Year End Tax Reports.
• Worked on Creating FERC Income Statement, FERC Balance Sheet, FERC Unappropriated Retained Income & FERC Cash Flow Reports.
• Extensively worked on enhancing DataSource (CMOD User exit) and Variable user exit.
• Extensively worked on ATLAS Project Pre-Cutover and Post-Cutover activities during Go-Live.
• Extensively worked on creating Restricted Key Figures, Calculated Key Figures, Formulas, Structures & Cell definitions.
• Worked on creating Hierarchy Node (Authorization Processing) Variables for Company Code, Cost Center & Profit Center.
• Extensively worked on Customer exit for characteristics Variables and Text Variables.
• Created Aggregates to increase performance for Speedway Income Statement Report, Balance Sheet Report & Trial Balance Report.
• Extensively worked on various Enhancements request to fulfill business needs.
• Extensively worked on Production Support Monitoring Data Loads, fixed any data load failures, etc.
• Involved in Unit Testing and Integration Testing for Backend Activities.
• Worked on HP Quality Center tool for FI/CO Reporting Unit Test Cases and Integration Test Cases.

Confidential, Boston, MA

SAP BW/BO Lead Analyst

Responsibilities:

• Extensively worked on converting SD 3.5 data flows into 7.0 data flows.
• Created MultiProvider and worked on creating Booking Report, Order Entry Metrics, Shipment, and On-time delivery metrics BEx queries.
• Extensively worked on BICS connection and created WEBI reports top on BEx queries.
• Build WEBI reports for Booking Report, Order Entry Metrics, Shipment, and On-time delivery metrics.
• Involved in testing and reconciliation process between ECC, BEx & WEBI reports.
• Extensively worked on Life Cycle Management Console (LCM) to promote objects.

Confidential, St. Louis, MO

Sr. SAP BW/BO Analyst

Responsibilities:

• Worked on enhancing Master Schedule (AFS) report to show On Hand Inventory, Sales Forecasts, Open Customer Orders, Unbought Customer orders, Sized and Unsized Planned Receipt.
• Worked on AFS Purchase Order Receipt Report and Available to sell report.
• Extensively worked on AFS purchasing extractors and InfoProviders.
• Worked on ETL Process, Created Transformations and Data Transfer Process (DTP).
• Worked on LO cockpit extraction method.
• Extensively worked on Integration Testing, User Acceptance Test (UAT) and Involved in end users training to stabilize BW reports.
• Worked on migrating 3.5 data flows into 7.0 data flows.
• Extensively worked on loading FI-GL data into BPC Staging InfoCube.
• Worked on Support Pack Upgrade Project. Involved in Production Support activities.
• Involved in designing architecture for AFS data model and build teh BW objects which include InfoObjects, Data Sources, DSO, InfoCube, MultiProvider, Transformations, and Data Transfer Process.
• Created CKF, RKF, Variables, Exceptions, Conditions and Formulas for teh above-mentioned reports.

Confidential, Joplin, MO

SAP BW Consultant

Responsibilities:

• Worked on building PP Data Model and extracted data from ECC to BW system.
• Created generic extractor for Order confirmations from AFRU and Goods Movements Confirmations from AFWI.
• Enhanced teh standard PP DataSource using ABAP to get teh production quantity fields.
• Worked on Start Routine (ABAP), End Routine and Characteristic Level Routine in Transformation.
• Developed teh following PP (MTS) reports using BEx; Scheduled vs. Actual Production, Production Rate by Product Group, Production Usage Report, Production History, Total Usage of Raw Materials for Environment, Weekly Demand report.
• Worked on creating dashboards (WAD) for above mentioned BEx reports.
• Involved in Functional Testing to validating teh reports.

Confidential, Exton, PA

SAP BW/BOBJ Consultant

Responsibilities:

• Build teh On-Time Delivery, On-Time Shipment Data model in BW and created generic extractor to extract data from ECC to BI (Used Transformations and DTP).
• Extracted Plant Maintenance Data from ECC to BI using standard extractor and Created teh following PM reports based on end user’s request; Work Orders, Confirmations, Operations, Malfunction Cause and Damage and Notifications.
• Created On-Time Delivery BOBJ Adhoc, On Time Delivery BOBJ QaaWS, On Time Shipment BOBJ Adhoc, and On Time Shipment BOBJ QaaWS queries using BEx.
• Created Process chain for Plant Maintenance to automate teh loading process and added Event Data Change to fill OLAP cache (Broadcast Settings in Queries) content to increase teh Query performance.
• Created Calculated key figures, Restricted key figures, Variable, Structures, and RRI.
• Extensively worked on SAP Support Pack Upgrade Project.
• Created OLAP Universes based on Past Due Summary and Past Due Trend details BEx Queries.
• Created Past due trend weekly, Past Due trend monthly, Past Due trend quarterly, Past Due trend yearly and Sales order details WEBI reports.
• Worked on reconciliation process between WEBI reports, Dashboards, BEx queries, and InfoProviders.

Confidential, Lake Mary, FL

SAP BI Consultant

Responsibilities:

• Worked on ETL Process, Created Transformations and Data Transfer Process (DTP).
• Loaded data to Headcount and Personal Actions, Staffing Assignments, Employee Residence Status and Employee Education DSOs and into InfoCubes.
• Worked on various HR Reports Actions by employee, Actions by day, Actions by month, Actions by type, Organizational details by Employee, Personal details by Employee, Employment details report and Employee Action Report.
• Developed function module and used in Start Routines to clean up special characters for extractors to avoid teh data load failure.
• Involved in production support and worked in performance tuning techniques Aggregates, compression and partitioning.
• Used RSPC for developing process chains to automate teh extraction process.
• Maintain Work History for all teh tickets until it is closed down.
• Involved in creating BEx reports, Workbooks based on end user’s requests.

Confidential, Atlanta, GA

SAP BW Consultant

Responsibilities:

• Installed teh Business Content objects for CS (Customer Service), PM and MM modules.
• Worked on Purchasing Extractors like Purchasing Header Level, Purchasing Item Level and Purchasing Schedule Line Level.
• Extensively worked on Extractors for Service Notifications - Activities, Causes, Items, Tasks, customized it as per Business Requirements.
• Extensively worked on PM extractors Maintenance Notifications, Activities, Causes, Items, Tasks and customized it as per Business Requirements.
• Extensively worked on production support activities like monitoring teh daily data loads, fix report issues and reconciliation issues.
• Involved in teh Enhancement (ABAP User-Exits) to extend teh standard Data Sources for Master and Transactional data.
• Designed, developed and load teh data to teh Custom InfoCube, DSO for Backlog Summary and Details using Generic extractors and created teh functional specification.
• Created Open Hub Services (InfoSpoke) to extract teh data from SAP BW system.

Confidential

SAP Technical Consultant

Responsibilities:

• Worked on loading OTC (Order to Cash) data which includes Orders, Delivery, Billing extractors.
• Created and maintained teh InfoCubes in PP for Period-Specific Order/Material View, Plan/Actual Comparison Material Consumption, etc.
• Extensively worked on Standard Extractors Component View, Material View and Work Center View from PP.
• Extracting Master & Transaction Data using Generic Data Sources from OLTP.
• Involved in Creation of process Chains.
• Created calculated key figures, restricted key figures, filter values and exceptions.
• Developed reports using query designer, BEx Analyzer, and web application designer.
• Developed documentation, including functional requirements, test cases, test plans, test scripts according company work instructions.
• Involved in production support activities like monitoring teh daily data loads, fix report issues and reconciliation issues.
• Maintain list of all teh activities for all teh tickets until it is closed down.