SUMMARY:

• SAP BW BO Senior Consultant with over 16+ years (including 3 years on HANA) of demonstrated career success in initiating, delivering and managing EDW reporting solutions across several industries.
• Lead & Managed end - to-end complete life cycle implementations - from user requirement to deployment to hyper-care
• Architected the Enterprise Data Warehouse - BW Architecture & data-model design, user security.
• Conducted several BW design workshops with technical team, business and project stakeholders
• Coordinated BI team - BW design standards, application architecture, data source(s), and reporting tools,
• Lead Production support - Onshore/Offshore teams located in Europe and Asia-Pacific region.
• Managed requirements gathering, conducting workshops, leading development, UAT testing, user training and hyper-care & post-production efforts.
• Project Management (team leading) using PMP/ASAP methodologies.
• 16+ years of strong experience in BW and BOBJ with various projects spanning FI-CO/SD/MM/PP/PS/ HCM/QM/APO functional areas across chemical, food, manufacturing, biotech and pharmaceutical industries.
• Extensive experience of 7+ end-to-end complete-life-cycle implementation which included ABAP in BW while sourcing data from SAP and non-SAP systems with SAP-BW while designing ETL, data-model and reporting layer.
• Strong background and experience in data warehouse Design, ETL processing, Enterprise Web Reporting, Confidential Query Analysis, & Development. database analysis, and SAP-BW/BI tools and Oracle RDBMS.
• Experienced with using BusinessObjects (BOBJ) Product Suite SAP-BOE XI 3.1, BO 4.0, 4.1, 4.2 SP2, WEBI, Design Studio & Power BI.
• Extensive experience with interacting with portal, basis & infrastructure teams.
• Experienced in BW 7.4 on HANA, Power BI 2.56

KEY SKILLS:

• Architected and Lead six 6 SAP-BI/BO projects from scoping & requirements through deploying, and managing them through all stages of system development lifecycle (SDLC) process.
• Lead global cross-functional project teams, as big as 9 resources, of onshore and offshore model while interacting with client, corporate sponsors and business end-users to manage scope, schedule and cost of projects.
• Extensively used PMP / ASAP methodology while managing changes, risks and project deliverables & scope with major & minor release.
• Directly interacted with C-level executives, project-sponsors, sales teams, informatics, and finance to define BW strategy to support changing business needs.

TECHNICAL SKILLS:

Business Intelligence: SAP- BW 7.4, 7.3, BI 7.0 (NetWeaver 2004s), BW 3.5, 3.1C, 3.0B, - MM/SD/WM/FI-CO, BusinessObject (BOBJ) BOE XI 3.1, 4.0, 4.1, 4.2, Power BI 2.56 (April-2018)

HANA: SAP BW ON HANA 7.40, HANA 1.0(SPS11)

SAP ERP: SAP ECC 5.0, 6.0; SAP R/3 (4.6C, 4.0B)

Language : ABAP/4, Strong Oracle SQL and PL/ SQL, T-SQL, C/C++, Unix Shell scripting, XML, Java.

Database : Oracle RDBMS (7.x, 8.0, 8i, 9i), SQL Server 2000, MS Access 2002

Software: Crystal Reports, Visio, SQL*Plus (8.0.6), OLTP.

Operating Systems: Windows 2000, Windows 7, MS/DOS, and UNIX AIX 4.3

Transport & Change Mgmt.: REV-TRAC, (SDLC), PVCS Version Manager, MS Project, SharePoint.

CAREER PROGRESSION:

Confidential, Exton, PA

SAP - BI Principal Architect

BW & ERP Environment: ECC 6.0, BW 7.3 / BW 7.4, BO 4.1, 4.2, SAP-APO 7.13, HANA 1.0 SPS-11

Responsibilities:

• Architected, developed, managed and successfully delivered projects for SNP and QM reporting solutions.
• Developed Business Requirements Specifications (URS) for Supply Network Planning (SNP) reporting requirement of the simultaneous implementation of APO - SNP in ECC.
• Developed Technical Design Specifications (TDS) for the APO-SNP reporting requirement Solution involving BW / APO / Confidential queries.
• Effectively developed the BW data model, custom extraction code using ABAP for ECC, ETL process (Transformation / DTP / Process Chain / InfoPackage), Confidential queries and BOBJ - WEBI reports.
• Developed WEBI reports using merge dimensions, tabs, conditional formatting, and prompts and jump reports and report scheduling.
• Generated user documentation, training documentation and successfully delivered the reporting solution for SNP.
• Developed Business Requirement Specifications (URS) form SAP - QM (Quality Management) reporting requirement as the SAP-QM being implemented in ECC for NA.
• Generated TDS (Technical Design Specifications) for SAP-QM reporting requirement involving extraction from SAP ECC Standard and custom extractors.
• Effectively developed the BW data model, ABAP code for Start/End routines in transformations & process chain decision branching, ETL process (Transformation / DTP / Process Chain / InfoPackage), Confidential queries and BOBJ - WEBI reports.
• Generated training document(s), conducted training sessions and rolled out WEBI platform for key-users of the application and supported the user base through this process.
• Power BI Experience - build architecture, DataSets, reports and dashboards, including security based on SAP-BW while sourcing data from CRM, SAP-BW and SQL Server.
• Built BW Data model / objects in BW 7.4 on HANA.
• Extracted data into HANA DB using SLT and BODS using SAP & non-SAP systems.
• Developed Calculation views, ABAP-programmed CDS views and AMDP (ABAP Managed Database Procedures).
• Currently working here.

Confidential, Akron, OH

SAP - BI Architect

BW & ERP Environment: ECC 6.0, BW 7.3, BO 4.0,

Responsibilities:

• Analyzed the existing data model and developed the TDS (Technical Design Specifications) document for BOBJ Report Based on underlying Confidential query on existing BW data model.
• Modified the existing BW Data model while generating new Transformations to meet the Confidential and BOBJ requirements.
• Developed the new Confidential queries.
• Designed and Developed new BOBJ - WEBI reports to source on Confidential queries. The WEBI report included normal report functions like - report-to-report interface, input controls, etc.
• Worked on SPO - InfoCubes and developed a plan to activate 250+ DTP objects once one of the TRFN is re-activated.
• Developed a WEBI Dashboard to analyze the inventory, confirmed orders, forecast and planned orders so that user can analyze individual dips and highs.

Confidential, Raleigh, NC

SAP - BI Architect

BW & ERP Environment: ECC 6.0, BW 7.3, BO 4.0, HANA 1.0 (SP6)

Responsibilities:

• Developed Business Requirements Specifications (URS) for Sale Performance Data Load for newly acquired company for Sales Performance Compensation reporting solution.
• Worked on design of a solution for Sales Performance Reporting Solution in BO 4.0. This solution uses SAP BW as Data Source and extracts data from other sources into BW.
• Generated Functional Requirements Specifications (FRS) & Technical Specifications (TDS) Document for Sales Performance Data Load for this analytics solution.
• Developed UAT scripts, Integration Testing Scripts and Co-ordinated the UAT & and Integration testing.
• Deployed ABAP Code modifications for performance improvement during data load in start routine and end routine.
• Developed WEBI Reports for Open Orders Reporting and Daily Sales Reporting.
• Validated legacy Customer data using KNB1, KNVP and CUST XREF, MARA, MARC tables.

Confidential, Baltimore, MD

SAP - BW/BO Architect

BW & ERP Environment: ECC 6.0, BW 7.3, BO 4.0, Logility

Responsibilities:

• Designed & Developed process Chains to run on event raised by file drop on FTP server.
• Designed & developed 10 new customer exit variables to be used in Confidential queries for reporting on MTD, YTD, LMTD, and LYTD periods correctly while using corporate 4-4-5 calendar.
• Worked with BI team, to in corporate the newly added fields in Master Data objects in SAP BW data model and in Confidential reports, so that it is available for WEBI reporting.
• Developed an ABAP code to trigger flat file copying and archiving in the process chain. This would help move OS commands that will not depend on BW environment.

Confidential, West Chester, PA

SAP - BW/BO Senior Consultant

BW & ERP Environment: JDE M/F, BW 7.0, BO 4.0, SAP ECC 6.0

Responsibilities:

• Lead the development of enterprise wide Business Intelligence (BI) strategy, which includes details about design, and development of standard reporting and analytics platform and enterprise data warehouse (EDW), scope of the BI solution, current state and future state, and gap analysis.
• Leveraged the SAP Business Warehouse, Business Objects (BO) Enterprise; OLAP Universes; WEBI; Dashboards (Xcelsius) and Crystal Reports while for generating the technology strategy.
• Generated a data-model design and SAP BI/BW solution architecture for purchasing data - LO extractors 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL feeding to cubes 0PUR C01 and 0PUR C04.
• Developed the URS / FRS / Tech Specs for reports and dashboard Solution for Regional Sales - involving 21 reports and 2-dashboards.
• Generated BW 7.0 data model, ABAP Code for Transformations, Confidential queries with structures and BO 4.0 WEBI Reports for Regional & Area Sales, Movements and RONA reporting solution.

Confidential, Boston, MA

SAP - BW/BO Lead

BW & ERP Environment: SAP ECC 6.0, BW 7.3, BO 4.0, HANA 1.0

Responsibilities:

• Generated data models with SAP HANA STUDIO.
• Developed Analytical and Calculation Views while using SQL SCRIPT stored procedures to perform complex calculation in SAP HANA.
• Designed and developed SLT (SAP Landscape Transformation) for Data Provisioning.
• Performed SLT Configuration and Administration (Start, Replicate, Start, Suspend, Resume) in SAP HANA..
• Developed SAP HANA Optimized InfoCubes and HANA Optimized Data Store Objects (DSO) for data migration.
• Developed SQLScript, SQL procedures, to implement functional logic for binding table variables, scalar variables
• Designed and Developed enterprise BI strategy which included details about scope of the BI solution, current state and future state, gap analysis, transformation roadmap, and implementation plan to deploy the corporate vision for business intelligence.
• Delivered the overall SAP BI/BW solution architecture for the to-be state involving data-source(s) from ECC & non-SAP systems, interfaces, BW data-model and reporting tools.
• Developed the URS / FRS / Tech Specs for controlling profitability analysis (CO-PA) reporting, Profit Center Accounting (PCA), Cost Center Accounting (CCA) reporting.
• Generated URS/FRS for Financial reports - Accounts Receivable (AR) management, credit Management, Payment Index, and Overdue Analysis for Credit management
• Developed reports for, technical specifications and KPI matrix for executive dashboard reporting on Finance, Global Delivery, and HCM functions of the corporations.

Confidential, Commack, NY

SAP-BI/BO Tech Lead / Manager

BW & ERP Environment: SAP BO XI 3.1, BI 7.0, ECC 6.0 MM, SD, WM, SCM, HR

Responsibilities:

• Architected and lead 3 Corporate-BI projects, while heading a team of 7 SAP-BI developers, system analysts, and contractors.
• Developed an interface in BI-IP for real-time data entry from excel sheet into Sales Planning InfoCube.
• Generated a planning InfoCube to receive real-time data entry, using planning modeler, and created aggregation levels, planning functions and planning sequences.
• Lead a team of offshore resources, including onsite BO lead and BW lead and 2-full time resources.
• Coordinated and worked with 2 vendors associated with projects and provided the status reporting of project to IT and business management teams.
• Generated business reporting requirements into functional specs URS, technical specs and Operational requirements.
• Developed the Order-To-Cash process data flow to extract data from SD/LE using extractors and LE-Shipping & SD-Billing extractors. Developed, tested and deployed back order report, and open orders report.
• Designed and build the ETL process, transformations, BW data model (DSO, Cubes & Infoprovider), Confidential query and WEBI reports for Order-To-Cash process stream.
• Lead the efforts to upgrade Corporate BI Environment from BW 3.5 to BI 7.0.
• Lead the on-shore and offshore team of 9 resources for the project for managing the migration of reporting solution involving 160 Confidential reports to BOBJ WEBI reporting, including security.
• Successfully worked on the performance tuning of the data load, for these extractors modifying ABAP/4 code, and improved query performance as well.

Confidential, Evansville, IN

Project Lead SAP-BI/BO

BW & ERP Environment: SAP BO XI 3.1, BI 7.0, ECC 6.0 FI-CO, MM, SD

Responsibilities:

• Architected the reporting solution consisting of BOE XI 3.1 WEBI Reports, extracting data from SD and FI-CO modules, carrying the development through all stages of life cycle - gathering user requirements, generating FRS, Design Document, construction, IT / UAT, go-live & hyper care.
• Lead efforts to develop the extractors for VISTEX - add on for SD module to develop a reporting solution for Advertising and Trade-Promotions.
• Managed the development of BOBJ Universes, and WEBI queries / reports for FI-CO, PCA & CCA areas and SCM modules.
• Monitored and advised regarding resource utilization and alignment with project needs (HR/Staffing functions). Participate in and lead Quality Assurance reviews. Manage overall project/program delivery to plan - scope, budget and milestones.
• Oversaw the production support effort while interacting with off-shore resources.

Confidential, Wilmington, DE

SAP-BI/BO Senior Consultant

BW & ERP Environment: SAP BO XI 3.1, BI 7.0, ECC 6.0 FI-CO, MM, PBF

Responsibilities:

• Managed the Universe Design and Development in BOE XI 3.1 environment interacting Confidential queries in BI 7.0., for 35 Universes.
• Initiated, Developed and implemented a plan for BOBJ Universe Version management.
• Set design standards for Confidential query feeding into BOBJ Universe and WEBI reports.
• Help troubleshoot the WEBI reports while leveraging the experience in Confidential development, ETL process and data-model in BW.
• Worked on developing functional design for PBF reports and Universes SAP-ECC & BI.
• Reviewed technical design and completed back-end development work for data extraction for finance data from ECC.