SUMMARY:

• Accomplished in implementation, development, maintenance, and support of SAP BW / BO with 17 years of IT experience. Possess strong communication and consulting skills. Details and result oriented. A resourceful problem solver.
• Seasoned SAP BW/BO/HANA consultant with 17 years of IT experience. 11 years working in SAP environment
• Extensive end to end full life cycle implementation experience for SAP BW and BO deployments using ASAP/Agile methodology
• Performed business requirements gathering and translated them into system requirements, and functional/technical specifications
• ABAP skills for writing and debugging start, end, expert routines, transformations, and user exits, to ensure optimal performance in ETL processes
• Strong Knowledge about ODATA services and Fiori
• Experience in design, creation, configuration, maintenance of Business Content, Data Sources, DataMart’s, Info Package, Info Source, Transformations, Transfer structures, Transfer rules, Communication structures, Update rules, DTP's, Info Objects, DSO's, Info Cubes, Multi Providers, Composite providers, aDSOs, Open ODS views
• Possess functional knowledge of SAP modules including FI - CO, SD, HCM, MM, PS, and PM
• Debugged, tuned, and optimized data loads and reports for performance
• Deployed and managed change management processes
• Possess analytical skills to resolve issues related to data loads and data validation
• Provided end user and prepared BW/BO operational documents
• Strong conceptual, analytical and problem-solving skills
• Ability to work under pressure, in critical situations and under tight deadlines
• Experience creating relational and OLAP universes
• Experience working as administrator to support routine maintenance
• Production support experience managing incidents (Remedy/ITSM/BMC/Heat/Service Now) i.e. fixing day to day production issues within promised SLA, preparing root cause analysis report (RCA) and recommending procedures to prevent future occurrences
• Experience working in change management processes
• Performed housekeeping activities e.g. optimized data loading and reports' performance
• Holding reliability status Security Screening from Government of Canada valid until 2024

TECHNICAL SKILLS:

SAP BW Modeling: Data Marts, Data archiving, Semantically Partitioned Objects (SPO), Info Cubes, Info Objects, Data Sources, Info Sources, Classic DSO's, Advanced DSO, Composite providers, Open ODS Views, Multi Providers, Info Sets Transformations, Data Transfer Process, Info Packages and Process chains

SAP BW Extraction: Data Marts, Standard Extraction, LO Extraction, and Generic Extraction

SAP BW Reporting: Bex query designer, Bex query Analyzer, and Bex Web application designer

SAP BW Operations: Data Load Management (Full/Delta Up-Load), Event Processing, Scheduling Start Process and Process Chains, OLTP Data Extraction, and Monitoring

SAP BW Optimization: Aggregates, Cube partitioning, Line-Item dimensions, Cube Compression, BW Statistics, DB Statistics, Semantic partitioning, Secondary Indexes and OLAP Cache

SAP ABAP: User Exit Functions, ABAP Enhancements in ECC Generic Extractions, BI Data Modeling (Start Routines, Transformation Routines, Expert Routines, End Routines, and Customer Exit Variables)

PROFESSIONAL EXPERIENCE:

Confidential

SAP Analytics Consultant

Responsibilities:

• Performed requirements gathering, created Functional and Technical documents, designed and developed BW/BI data model to fill out CRA forms T2200 (Declaration of Conditions of Employment) and GST 370E (Employee and partner GST/HST rebate application) electronically, following tasks were performed to fulfill reporting requirements.
• Requirements gathering, as-is analysis, fit gap analysis.
• Enhancement of HCM data sources, Creation of Generic data sources, Data model design and development in BW to feed data to Crystal report
• Performed requirements gathering to design and develop HR Metrics and measures dashboards, various dashboards are needed to analyze workforce demographics, staffing and recruitments, retention, work life balance and health and safety
• Developed BEX queries to feed Design studio dashboards to fulfill HR metrics business requirements
• Developed workforce demographics dashboard and various views to analyze Max headcount by Generational breakdown, Tenure and by Gender for last 3 years
• Work in progress for staffing and recruitments, retention, work life balance and health and safety dashboards.

Environment: SAP BW 7.4, SAP ECC 6.0, BI 4.2, Chamelon, Class, eforms, Infor, Max,Google Analytics and Team Budget etc.

Confidential

SAP Analytics Consultant

Responsibilities:

• Developed end to end data flow for National Composite providers, downstream objects required were Regional Composite providers, Calculation Views, Virtual Tables, and Open ODS Views
• Created National Wholesale Daily (RSC & DSD & GI) Bex reports based on National Composite provider
• Data model for National Composite providers were constructed for Catch Weight Quantity and Promotion Situation List DSOs.
• Designed Generic extractors to extract forecast information data from WAHD, MAPR and PROW ECC tables, developed upstream data flow to populate SCM aDSOs
• Constructed data model to send weekly extracts of POS Liquor sales data for West Region Data modeling tasks performed were
• Created Open Hub destination based on CTM Retail Profitability Infocube, destination type third party tool (i.e. Data services)
• Project, batch jobs and all relevant dataflow tasks were created in Data services designer to import open hub extracts from BW source into target Flat file in data services
• Managed Unit testing, System testing, defects fixes and Transports in ALM (HP)

Environment: SAP BWoH 7.4, SAP HANA, SAP CPM, SAP SCM, SAP SRM, SAP ECC 6.0, BI 4.2, BODS 4.2

Confidential

SAP BW/HANA Consultant

Responsibilities:

• Administered, monitored and managed process chains, identified and fixed data load failure issues
• Resolved assigned Incidents related to minor enhancements and break fixes within promised SLA
• Performed BW back-end and front-end enhancements to meet business requirements
• Analyzed and fixed data reconciliation issues between ECC and BW environments
• Performed housekeeping activities to optimize data load and reports performance
• Executed, documented report layout validation, data validation to ensure that the business requirements are met
• Prepared BW documents to capture enhancements, issues, and resolutions
• Developed Attribute Views, Analytic views and Calculation views to fulfill reporting requirements in COPA, Sales and Margin, PLM
• Extracted data from SAP ECC (COPA Tables) and Legacy systems through SLT and BODS jobs
• Designed the data model for COPA retail and franchisor P&L reports in HANA
• Developed various P&L repots (COPA) to analyze data by Entity, responsibility, periods, and regions
• Enhanced various standard PLM reports for additional fields to fulfill business requirements
• Performed report layout validation, data validation for the reports generated in HANA to ensure the business requirement are met.

Environment: SAP BW 7.1, SAP HANA, SAP CRM, SAP SCM, SAP SRM, SAP ECC 6.0, Micro strategy

Confidential

SAP BW Consultant

Responsibilities:

• Designed (new), activated and modified (existing) process chains to implement End to End BW migration to BW 7.5 on HANA
• Optimized objects in process chains to make them HANA compatible
• Identified and fixed issues related to process chain activation, HANA optimization of objects, data load failure, unit testing and transport failure
• Converted existing standard Infocubes to HANA optimized Infocubes
• Designed archiving process to load historical data to near line storage (NLS)
• Designed Infocube and data flows in BW 7.5 on HANA to consolidate historical invoices and billing data from several Infocubes in legacy system
• Developed several data marts in legacy system to extract historical data from all DSOs using Installation Facts Data source (SAP IS-U), loaded Historical data to newly designed data flows in BWoH
• Modified invoices and billing Mutiprovider to reflect changes in the new system
• Re-designed various Multiproviders to replace Info set by DSOs,
• Designed Composite providers to fulfill BEX reporting requirements
• Developed advanced DOSs to replace several cumulative Infocubes
• Modified BEX reports, Universes and WEBI reports to reflect changes made to Multiproviders
• Performed Unit testing, Fixed unit test problems and transport failure issues
• Prepared BW/BO documents to capture enhancements, issues, and resolutions

Environment: SAP BW 7.5, /BI 7.0, SAP IS-U, SAP CRM, SAP SCM, SAP SRM, SAP ECC 6.0, SAP BI 4.1

Confidential, San Jose, CA

SAP BW/BO Consultant

Responsibilities:

• Designed reporting solution to meet client’s specific need
• Requirement was to analyze net value of sales organization by sales document, sales document item and partner role
• Generic extractor was created as a solution to extract data from ECC to populate newly created DSO and Infocube in BW, that would feed the required BW reports
• Resolved incidents successfully, applied break fixes within deadlines
• Performed BW back-end and front-end enhancements to meet business requirements
• Monitored data load process chains and fixed issues in case of failures
• Analyzed and fixed data reconciliation issues between ECC and BW environments
• Performed performance tuning of SAP BEX/SAP BOBJ reports
• Performed various administration tasks using CMC:
• Created and managed users and groups, including rights to folders, objects and applications.
• Published, scheduled and managed Webi Reports and Crystal reports.
• Managed universes and universe connections.
• Managed BO server’s applications and services
• Modified Business Objects reports
• Prepared BW/BO documents to capture enhancements, issues, and resolutions

Environment: SAP BW7.3/BI 7.0/BW 3.5, SAP ECC 6.0, SAP BI 4.1

Confidential

Sr. Information Systems Analyst (SAP BW)

Responsibilities:

• Extensively worked on developing various reporting packages, developed Bex/WAD reports to analyze variance between actual and budget organizational cost related to labor, material, and projects
• Created Data Sources, Info Packages, DTP’s, Info Objects, Info Cubes, SPOs, DSO’s to populate required reports
• As a requirement, business wanted to modify existing fixed assets reports to analyze them into two new reporting segments
• Enhanced Info Objects and standard data sources by adding customized fields
• Modified master data to make it fit to new reporting segments requirements
• Created new business area Info Objects and modified existing ones
• Assigned navigational attributes to General Ledger DSO’s, Infocube, and Multi Providers
• Modified and Maintained transformation rules and created new transformation routines
• Loaded master and transactional data from staging DSO layer into BW
• Developed Bex /WAD Reports to display new groupings
• Performed data validations during unit testing and system integration to verify if KPIs in the new solution match with the legacy reports
• Prepared detailed reports to capture results of unit testing and system integration testing
• Developed and enhanced various Bex/WAD/Workbooks reports that would display cost, budget and KPIs information
• Performed Unit Test, System Integration Test (SIT) and UAT
• Managed and fixed defects raised during tests
• Worked with sustainment department to perform minor enhancements and break fixes
• Prepared BW documents to capture enhancements, issues, and resolutions

Environment: SAP BW 7.3/BI 7.0/BW 3.5, SAP ECC 6.0, SAP BPC, AS400, Flat Files

Confidential

SAP Consultant

Responsibilities:

• Implemented General Ledger Line Item (FI G/L) standard reporting solutions
• Activated and customized BI contents
• Created and customized, Info Objects, Info Cube (GL C04), DSO (GL O02) Transformations, DTP’s, Info Packages, and Data Sources.
• Enhanced Data Source (FI GL 04) by adding additional fields to meet specific business requirements
• Designed and developed various BEX queries in order to use them as data sources to develop Webi and Crystal Reports:
• Financial Statements: Balance Sheet, Income Statement, and Cash Flow Statement
• Financial Reports: Capex, Real Time Balances, Cumulative Balances, Comparison with Previous Years, Key Financial Figures, Month End Summary, Quarter End Summary, Year End Summary, Account Receivables Analysis, and Inventory Analysis
• HR Reports: Executive Summary, Headcount Summary, and Overtime Summary
• Designed, developed, and supported complex and interactive dashboards to analyze actual performance and variances, leveraging financial Bex queries
• Developed and supported interactive dashboards for mobile devices and converted existing dashboards for mobile accessibility
• Scheduled Webi reports using CMC and BI Launch Pad to be delivered to recipients via emails
• Maintained BO suite of applications and troubleshooted issues faced by users
• Performed functional enhancements to meet changing business requirements
• Prepared BW/BO documents to capture enhancements, issues, and resolutions
• Configured multiple companies using BPM portal and defined global parameters including chart of account, and posting period, fiscal year, and screen variants
• Analyzed legacy chart of account to map GL Accounts between the two systems. Created secondary cost element accounts for unassigned GL accounts and uploaded new segment values
• Defined “sender/receiver cost allocation rules” for distribution/assessment and reposting of planned and actual costs
• Assisted business in posting adjusting journal entries via JESS template to balance the books
• Administered closing and opening of posting periods in test environments
• Analyzed financial statements data, including P&L and balance sheets, by accounts, cost centers, trading partners, functions, business types, to validated it against the source data extracts from ECC system
• Performed QA and Production UAT, regression testing
• Investigated and aligned out of balance P&L and Balance sheet amounts between BW and trial balance reports from SAP ECC Systems
• Developed various BW queries including revenue details by customer number, expense detail by vendor, cost center hierarchy listing, P&L by cost center, and vendor validations

Environment: SAP BW 7.0, SAP BI 4.0, SAP ECC 6.0, Hyperion, and SAP BPC

Confidential

SAP BW/BO Developer

Responsibilities:

• Gathered requirements from business executives and business user groups, to implement Account Receivable Line Item/Transactional Figures reporting solution
• Performed gap analysis and planned actions needed to fill the gaps
• Activated and customized Business Contents including Info Objects, Info Cubes, DSO’s and Data Sources
• Enhanced Data Sources (0FI AR 4/0FI AR 06) to include additional fields from read structure (BSID), performed necessary conversion from 3.5 data flow to BW 7.0 data sources
• Developed BW Bex queries including:
• A/R Due Date for Net Payment Analysis, A/R Overdue Analysis, A/R Days Agreed / Days Taken and AR aging report
• Developed following Crystal Reports over BW Multiproviders, with dynamic features:
• Cost Control Summary, Commitment vs. Incurred, Change Notice Log Report/Detail Report, reservation &Delivery and Inventory report, Statement of Income
• Configured Crystal Reports to make them available through Live Office
• Provided technical and assistance to end-users in performing day to day operations
• Maintained BO suite of applications and troubleshooted issues faced by users
• Performed functional enhancements to meet changing business requirements
• Prepared BW/BO documents to capture enhancements, issues, and resolutions

Environment: SAP ECC, BW/BO, CRM, and Solution Manager 7.0, Oracle 9i, 10g, MAXDB, Microsoft SQL Server, UNIX HPUX, Solaris

Confidential

SAP BW/BO Consultant

Responsibilities:

• As a team member gathered requirements, implemented Inventory Management data model, determined gaps, defined scope of project, created functional and technical specification documents
• Activated and customized Business Contents including Info Objects and Info Cubes
• Activated, customized, and enhanced following Data Sources to include and populate customized fields by writing ABAP User exits
• Goods movement from Inventory, Revaluation, and Stock initialization for inventory management
• Updated BW upstream data model to include new Info Objects
• Developed process chain to automate data loading process
• Developed various Bex reports including:
• Stock Overview Report, Demand Supply Match Report, Valuated Stock Report
• Inventory Aging Report, Inventory Turnover Report
• Stock in Transit Report, Scrap Report, Blocked Stock Report, Days' Supply Report
• Designed dashboards including:
• FI: Profit and Loss - Budget/Actual/Forecast/Variance, Balance Sheet, Cash Flow
• Sales performance analysis Budget/Actual/Forecast by region/Product/sales Rep
• HR: Claims-Budget to actual analysis for Medical/Dental/Vision
• Developed Universes to create following Webi reports:
• Sales/Costs Analysis, Product Analysis, Top N Customers
• Expense/Revenue Analysis, Inventory Status Raw Material/Finished Goods
• Modified existing reports developed in Dashboards, Webi and Crystal Reports, to fulfill business requirements
• Leveraged Live Office and QaaWS tools for various BO reports
• Provided BW/BO production support including monitoring process chains, fixing load failure issues, resolving user issues, accommodating user requests, and resolving assigned tickets
• Prepared BW/BO documents to capture enhancements, issues, and resolutions

Environment: SAP ECC6, BI 7.0, BOXIR3

Confidential

SAP BW Developer

Responsibilities:

• Activated and customized Business Contents including Info Objects, Info Cubes, and DSO’s in order to meet specific business requirements
• Enhanced Transaction and Master Standard Data Sources including Sales Order Item/Header level, Material movement, Sales Order Delivery
• Developed Start Routines, Transformation Rules, and End Routines using ABAP to in corporate Data Transformations needs
• Created process chains for processes involved in data loading and delta loading
• Designed following queries in Bex Query Designer
• Sales Order Fill Rate-Header, Item/Quantity Fill Rate by Product
• Order Qty/Item Fill Rate by Plant, Sales Order Item/Qty Fill Rate
• Top 10 Materials Delivered Late
• Conducted for end-users
• Developed business process documentation
• Provided post production support after Go Live phase

Environment: SAP BI 7.0, ECC6, SD.MM, SCM, FI

Confidential

SAP BW Consultant

Responsibilities:

• Managed user inquiries and issues, resolved assigned tickets within promised SLA
• Provided RCA report (root cause analysis) and recommended procedures to prevent future occurrence
• Administered change management processes, Optimized data load and report performance
• Administered, monitored and managed process chains for daily/weekly and monthly scheduled events
• Helped users to create ADHOC reports
• Performed knowledge transfer activities including preparing documentations and user manuals
• Prepared BW documents to capture enhancements, issues, and resolutions.

Environment: SAP BI 7.0, ECC 6.0, BOXIR2/R3.