SUMMARY:

• 12+ years of experience in SAP BW. (BW 3.5, BW 7.01, and BW 7.3).
• 3+ years of experience in BW on HANA (BW 7.4 & BW 7.5), and Native HANA.
• POC Project experience in BW/4HANA.
• 4+ years of experience in Business Objects (WEBI, and Analysis for Office).
• Strong experience in End - to-End Design, Development, Enhancements, Testing, Performance Tuning, Documentation, and Production Support for Reporting and Analytical Solutions.
• Worked closely with 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, DataSources, InfoPackages, Transformations, Routines, and Data Transfer Process.
• Very good experience in ETL for Master Data Extractors, Text Extractors, Hierarchy Extractors, and Transaction Data Extractors.
• Experience in Advance DSOs, Composite Provider, Exposing BW models as HANA views, Mixed scenarios, and LSA ++ Best Practice.
• Well versed with LO Cockpit Extractors, Generic Extraction, and FI/CO extraction methods.
• Good knowledge with MM, SD, FI/CO, PP, PM, QM, CS, HR, APO-DP, and AFS solutions.
• Proven ABAP/4 capability with User Exit, Enhancements, Start and End Routines.
• Extensively worked on Full and Delta Load methods during data loads.
• Experience in Open Hub (Info Spoke) to download data from InfoProviders to flat 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.
• Well versed with 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 WEBI (Web Intelligence) Reports, and Analysis Office Workbooks.
• Extensively worked on performance tuning using Indexing, Compression, Aggregates, Partitioning, and SPOs (Semantic Partitioned Objects).
• Good experience in creating Process chains to automate the 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 affected business users, and assisting with root-cause analyses for continuous improvement.
• Worked on HANA data modeling (Attributes views, Analytic Views, and Calculation views using HANA Studio), Schema Management, Content Import and Export.
• Experience in Data Provisioning including SAP LT Replication Server, and BO Data Services.
• Good knowledge of Security concepts including User Management, Roles, and Privileges.
• Experience in Technical Upgrade Planning, Upgrade, and Operating Systems DB migration.
• Good knowledge on SQL Script, HANA Analysis Process, HANA Live, CDS, and Smart Data Access (SDA).
• Knowledge of SAP HANA Enterprise Information Management (EIM) and its components Smart Data Integration (SDI) and Smart Data Quality (SDQ).
• Knowledge of Design Studio, Lumira, Crystal Reports, Life Cycle Management (LCM), and CMC (Central Management Console).
• 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

• Worked with the 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 the 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

• Extensively worked on designing HANA views like Analytical Views, Attribute Views and Calculation Views for Procurement.
• Extensively worked on Real Time replication using SAP LT (SLT) Data Provisioning for multiple SAP ECC tables.
• Worked with the business and APO functional team to understand the 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 the APO-DP archival process.
• Worked on creating process chain to automate the archival loading process.
• Extensively worked on creating the 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

• 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 Flat 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 the flat file data load by writing upload program.
• Extensively worked on End Routine (ABAP) to populate Activity details.
• Extensively worked on creating BEx Queries for the 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

• 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 closely with BASIS team to support on BW 7.4 Upgrade and HANA DB Migration Project.
• Extensively 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.
• Extensively worked on Creating Generic Extractors for Credit Master & Settlement.
• Extensively 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 the 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

• 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

• 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 the BW objects which include InfoObjects, Data Sources, DSO, InfoCube, MultiProvider, Transformations, and Data Transfer Process.
• Created CKF, RKF, Variables, Exceptions, Conditions and Formulas for the above-mentioned reports.

Confidential

SAP BW Consultant

• 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 the standard PP DataSource using ABAP to get the production quantity fields.
• Worked on Start Routine (ABAP), End Routine and Characteristic Level Routine in Transformation.
• Developed the 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 the reports.

Confidential, Exton, PA

SAP BW/BOBJ Consultant

• Build the 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 the 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 the loading process and added Event Data Change to fill OLAP cache (Broadcast Settings in Queries) content to increase the 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

• 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 the 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 the extraction process.
• Maintain Work History for all the tickets until it is closed down.
• Involved in creating BEx reports, Workbooks based on end user’s requests.

Confidential, Atlanta, GA

SAP BW Consultant

• Installed the 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 the daily data loads, fix report issues and reconciliation issues.
• Involved in the Enhancement (ABAP User-Exits) to extend the standard Data Sources for Master and Transactional data.
• Designed, developed and load the data to the Custom InfoCube, DSO for Backlog Summary and Details using Generic extractors and created the functional specification.
• Created Open Hub Services (InfoSpoke) to extract the 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 the 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 the daily data loads, fix report issues and reconciliation issues.
• Maintain list of all the activities for all the tickets until it is closed down.