SUMMARY:

• SAP HANA Business Intelligence professional with 14+ years of SAP Analytics, which includes strong functional & technical expertise in SAP BW / BI SAP BPC with BW on HANA & ABAP and BEx, EPM, BOBJ, WEBi, Power BI, Tableau as Reporting tools.
• Proficient knowledge using SAP methodologies, Project Plan & Accelerators in Analytics Design & BW & ABAP & Native HANA Development, Technical Road map, Configuration, and Performance.
• Demonstrated expertise in all phases of SDLC like Realization, Analysis, Blue Printing, Multi - Dimensional Schema Design, Functional Specification, Development, Performance tuning, testing, documentation, Support & maintenance, training, Security authorizations and troubleshooting.
• BW Upgrades - Strong Knowledge in BW Upgrades to BI 7.X BPC & HANA Upgrades.
• HANA Analysis - Worked on HANA evaluation teams to provide Pre-Sales information to clients on various aspects of System behavior, advantages of faster run times, development strategies & estimates.
• HANA/SLT/SDI - Worked on DB Upgrade and SLT /SDI for Optimized Data Loads in BW and BPC.
• BW on HANA Development - Worked on Reporting Solutions based on Composite Provider based on Calculation Views, AMDP SQL Scripting Solutions and OData Integration with UI5 & Tableau.
• BPC 7.5/10.1 - Development, Upgrades, Enhancements, Support & BPC, BW, ABAP Solutions.
• BW Reporting - Strong knowledge of BEx Query Designer, Calculated & Restricted Key Figures Exceptions, RRI jumps, Conditions, Exceptions, Queries on Multi-Providers and Web Application Designer (WAD) with table interface related development and documentation for end users.
• Performance Tuning - BW Statistics, Multi Providers, Aggregate creation, InfoCube partition & compression, Query tuning and OLAP Cache Monitoring, HANA SQL Tuning, Query Pruning.
• BW Data Reconciliation - Developed Data Reconciliation process to find the deviation between R/3 and BW Data in $ amounts for various modules like FM - Budgets, Commitments, Actuals and MM.
• ABAP - Strong Knowledge in ABAP/4 programming language, User Exits, Start & End Routines in BW, query monitoring, BADI, SQL Trace (ST05) and Tuning & Developed Function modules and Programs.
• Excellent communication, interpersonal, analytical skills and performed as a Tech Lead in Offshore-Onsite model and as an individual contributor.
• Agile - Responsible for deploying BPC Consolidation Enhancements & Projects using Agile SPRINTs.

TECHNICAL SKILLS:

Languages: ABAP/4/7.0, VB, VBA, SQL

ERP: SAP ECC, S4, SAP BW 3.X/7.X, B4HANA, SLT, SDI, SDA

Functional Modules: MM, SD, FI-AP/AR/GL, FM-BD, AC, CM, PP, PM, HR-PY, PA

Planning Modules: SAP BPC 7.5, BPC10.0/10.1

Data warehouse Tools: BW Scheduling tools - Redwood ®, Tivoli ®, Autosys

BI/ BO Reporting Suite: BEx, WAD, WEBi, Power BI, Advanced Analysis, Tableau

Project Management: Estimation, Scheduling, Resource Planning and Risk Management.

PROFESSIONAL EXPERIENCE:

Confidential, CO

SAP BI HANA Architect

Environment: B4HANA, S4HANA

Functional Modules: SAP FI, SD

Reporting: BEX, WEBi

Responsibilities:

• Actively worked with User Groups to gather reporting requirements based on PeopleSoft reports
• Identified data gaps and collaborated with functional team to create datasets for client specific data such as Partner functions, Payment Terms and customer credit data.
• Worked closely with SAP to resolve extraction issues with ACDOCA and Logistics.
• Responsible for validating SAP NOTEs and fixing system issues with Basis actions.
• Designed and developed Customer Credit Master for Canadian customer base and integrated master data in all required FICO Reports in B4HANA.
• Designed, validated CDS Views, BADI Development efforts for extractor enhancements.
• Responsible for working with Users on FUT Phase and making necessary WEBi report adjustments.

Confidential, MA

SAP BI HANA Architect

Environment: B4HANA, S4HANA

Functional Modules: SAP FI, SD, MM, PS, HR

Reporting: BEX, Power BI & WEBi, Tableau

Responsibilities:

• Developed migration strategy from PeopleSoft to SAP and delivered design solutions for each area in business process.
• Conducted requirement gathering sessions based on legacy reports from Peoplesoft and designed developed B4HANA and S4 HANA based reporting solutions.
• Responsible for system monitoring, Charm transport queue with Basis team and implementing required Notes for HANA objects
• Responsible for developing ABAP Solutions and providing AMDP recommendations for complex report needs in product costing area and other functional areas.
• Establishing development framework for each module with HANA views and ODQ based solutions.
• Designed and developed several reports in Tableau, BEx, Power BI and enabling functional and business teams to take faster decisions.
• Developing reports in WEBi for detailed analysis and deploying metrics focused reports in Power BI for dashboard view.
• Delivered Sales Analytics based on Sales, Finance data sourcing from HANA Views from S4.
• Establishing detailed document framework for each reporting solution as client is new to SAP and to increase development team’s efficiency on upcoming enhancements.

Confidential, GA

Project Manager & SAP Reporting Architect

Environment: SAP BW BI 7.4, SAP DS, MS Azure, Hadoop

Functional Modules: SAP FI, SD

Reporting: BEX, Tableau, WAD

Responsibilities:

• Engaged business stakeholders in designing and drafting automated solution for SAP Sales and Finance Team.
• Developed & Deployed Sales Analytics Solution with BW and Tableau and reduced 90% of manual tasks and improved data quality by using BI native processes and reconciliations.
• Developed reconsolidation solution between COPA, SD sources from ECC and BW & tableau to improve data quality standards and BI Reporting adoption.
• Worked with management on redesigning enterprise Datawarehouse model and consolidating several data feeds in the organization.
• Executed Operational Analytics platform migration from Hadoop to Azure and Tableau.
• Worked with Sales & Finance Users on business reporting strategy and best practices & training.

Confidential, GA

SAP BI HANA Consultant

Environment: SAP BW BI 7.5, HANA, ABAP

Functional Modules: SAP FI, PM

Reporting: BEX, BEx, Tableau

Responsibilities:

• Designed & developed Trust Funds Reporting Solution for Confidential User Community.
• Developed complex ABAP solution to simplify Trust Funds exploration requirement.
• Performed gap analysis for HANA modelling & delivered POCs to realize the improvement in development methodology.
• Provided performance improvement metrics in data loads and report readiness to User Community.

Confidential, TX

SAP BI BPC Consultant

Environment: SAP BW BI 7.5, BW on HANA, BPC, BODS

Functional Modules: SAP FI, SD, HR

Planning Modules: BPC 10.0 / 10.1

Reporting: BEX, EPM

Responsibilities:

• Responsible for handling upgrade activities for BI 7.5 & BPC 10.1 EPM
• Worked with User Groups & Performing System Evaluation during Pre-& Post upgrade Status.
• Developed minimal downtime and most optimal upgrade timeline for BW and BPC upgrades with precise cutover steps.
• Lead the effort for BW upgrade to 7.5 from 7.4 SP13 and worked closely with BW and Basis to resolve any issues.
• Worked with SAP during Max Attention phase to handle smooth transfer of support activities and cutover process approval.
• Developed User Guides for Corporate Users on new features in BPC 10.1 and BW 7.5.
• Worked on HANA modelling using Several (C&A) views, AMDP based solutions and migrating legacy BW data loads to HANA View based Solutions on FI & SD & HR Data.
• In Sysco- Brakes Initiative, responsible for discovery of new data load methods using SDA from Brakes Sources (Brakes UK, newly acquired by Sysco).
• Responsible for Work distribution, documentation for support and Issue resolution in BI & HANA & BPC Team.

Confidential, GA

SAP HANA BI APO Consultant

Environment: SAP BW BI 7.5, HANA, BPC, APO, DP

Functional Modules: SAP FI, SD APO

Planning Modules: BPC 10.1

Reporting: BEX, EPM, Tableau

Responsibilities:

• Designed & developed custom ABAP Solutions for BI APO Integration and Data loads.
• Responsible for doing gap analysis on Sales Data quality for APO demand planning.
• Responsible for preparing technical specifications on custom solutions.
• Developed BEx Reports and responsible for User Education and guidance on report usage.
• Responsible for automating manual steps in BPC Month End Load Process.
• Responsible for analyzing batch job sequence and Data Quality Analysis in BPC Models.
• Developing Custom Solution for automating data reconciliation between Staging and BPC Models.
• Developed HANA & Tableau reporting solutions with ECC Table replication using SLT and tableau reports on Sales Order Metrics.
• Redesigned legacy BI data flow on Sales Feed to HANA based approach with ADSOs and Calculation Views and Composite Providers.
• Evaluated Cloud Migration Effort for BW on HANA Instance and prepared plan and Object Analysis and Validation approach during post migration phase.
• Worked closely with Infrastructure teams & management to generate necessary effort estimates and gap analysis.

Confidential, NC

SAP HANA Consultant & SAP BW BPC Architect

Environment: SAP BW 7.4 SP13, ABAP, HANA SP11, SLT, NLS, Agile

Functional Modules: SAP FI-CO

Planning Modules: BPC 10.1 SP8

Reporting: BEX, EPM, Tableau

Tools: AutoSys

Responsibilities:

• Responsible for working with several teams at Bank to upgrade from DB2 to HDB.
• Handled 10+ upgrade cycles of several instances of BPC systems to HDB .
• Worked closely with DBA, BASIS & SAP and implemented 140+ notes for many upgrade level issues from BI 7.3 to 7.4 on HDB.
• Responsible for analyzing data loads, DTP behavior and scope for notes in HANA Parallel scenario to compare production systems with HDB and DB2 in Parallel.
• Developed several custom ABAP/BI based solutions to perform Pre-& Post Upgrade checks.
• Responsible for analyzing Code Inspector for Upgrade checks and handling required ABAP changes for HANA Compatibility.
• Worked closely with BPC and EPM teams to analyze data variances during upgrade phase and validated scope for SAP Notes.
• Provided detailed technical analysis to SAP on issues in DB Upgrade cycles.
• Handled Team Lead role to design & deploy Local Consolidation Project to accommodate
• Consolidations for India, Australia & Europe along with North America.
• Responsible for developing several programs for Local Consolidations project.
• Worked closely with business and process teams to develop POCs based on requirements.
• Responsible for delivering entire development in 6+ Sprints using Agile Methodology.
• Designed and Developed several BADi’s for F4 Customization, Enhanced WriteBack BADi and worked on Performance Issues.
• Responsible for review and analysis of AutoSys Schedule.
• Responsible for resolving several data variances and conducting toot cause analysis.
• Responsible for migrating BEx Reports to Tableau based reports with reference to BW MultiProviders and HANA based Composite Providers.
• Developed Master Data Analysis reports based on Tableau along with Stat Reports based out of BW Statistics to display Load Run Times, Job Completion Times Vs SLA metrics.
• Developed several ABAP based utility programs improve team’s efficiency to handle several checks in data load & support activities.
• Designed & Developed SPO Rotations tool to remove all manual activities in Weekly & monthly rotation requirements.
• SPO Rotations tool is 100% BI and ABAP based End to End solution & saved 100+ hours of teams work on analysis and issue efforts.
• Developed several programs for BPC DM Package Executions, EPU Processing and Ownership Copy.
• Responsible for handling Native HANA Development tasks such as BI Backend batch loads with before & after analysis on Package Read times, Volume and Duration Analysis.
• Developed HANA Model Solutions based on legacy BW Solutions using new Strategies.
• Redesigned and migrated SAP BPC Audit Reporting solution in HANA using Composite Provider, Calculation Views and BEx & Broadcast Reports.
• Worked on Native HANA Development with SQL Scripting, Procedures, UI5 and OData Services & AMDP & SLT.
• Developed Strategy for integrating multiple BI instances and integrate them on HANA with SDA features.
• Conducted Performance measurement on HANA based reporting and engaged business partners for consensus and adopting HANA based solution approach.

Confidential, GA

SAP HANA Consultant & SAP BW BPC Architect

Environment: SAP BW 7.0 & 7.3, AIX, DB6, HANA, TD, UFP, PLUS

Planning Modules: BPC 7.5

Reporting: BEx, WAD, Business Objects 4.0, Tableau

Business Objects Suite: FIM, Data Services 4.0

Tools: Tivoli, AutoSys

Responsibilities:

• Performed various roles as Solution Architect, Team Lead and Lead Developer in various phases of the project and also based Team’s bandwidth and deliverables.
• Guided a team of 10+ with day-day work plan & reviews @ Onsite and Off Shore.
• Worked with Implementation Partner’s team for seamless integration of newly developed solutions into Coke’s System.
• Responsible for guiding entire team on Coke Policies on Design & Development.
• Presented all Design approaches and responsible for gaining approvals from BI Review Board meetings.
• Responsible for gathering Data requirements and prepared Technical Specifications.
• Executed complete redesign of Data loads for BPC System from SAP & Non SAP Systems.
• Prepared End -End Data Flow Design Documents for educating team about Design Process.
• Conducted several meetings with Management to explain and convince design approaches.
• Worked with various client and implantation partner’s teams to integrate Solution and resolve any Data quality related questions.
• Responsible for designing 20+ interfaces to extract data from Sales & Non SAP Systems.
• Worked with Functional Teams to finalize design changes and lead the development.
• Responsible for organizing several data loads in the system with 300+ process chains.
• Migrated DataServices based solutions to BI based on mapping rules and extractions.
• Worked with various development team members and prepared Tivoli Sequence for batch.
• Developed and Delivered many ABAP Programs to achieve complete automated data loads.
• Designed & Developed True Up Actuals Objects and allowed business to do better planning with actuals from current month closure.
• Handled Organizational impact of Divestiture on BPC Data Loads and provided workable solution with minimal data adjustments.
• Responsible for helping Partner’s team to bring changes related to Coke’s ReOrg into Ongoing BPC Solution Development.
• Responsible for reviews of transports, post migration checks and issues resolution.
• Worked closely with Basis, Infrastructure, SAP Teams to keep team’s productivity as high as possible during system copy, Production Space, Access related issues.
• Worked on BADI, Script Logic changes for best response time with Templates.
• Worked closely with team to develop reconciliation tool (ART) for data reconciliations.
• Designed and developed Tableau based on Dashboard for BPC month end closing process updates for project team communication.
• Responsible for handling HANA POC related tasks such as BI Backend batch loads with before and after analysis on Package Read times, Volume and Duration Analysis.
• Worked with Functional Team and executed several Templates and gathered stats in BPC System with & with Out HANA.
• Performed HANA Upgrade process with pre-& post checks and post upgrade data loads.
• Developed several calculation views to evaluate HANA Advantages in Development and Performance perspective.
• Worked with SAP on potential issues and required NOTEs & evaluation of upcoming changes via Release Notes.
• Handled several pre-sales effort for HANA Evolution and worked on estimates for development, resource and road map for current & future projects.

Confidential, Rubbermaid, GA

SAP BI Techno Functional Consultant

Environment: SAP BW 7.3, APO 6.0, ECC 6.0 & ABAP 7.0, BIA, XI 4.0

Business Modules: OTC, SCM, FIN, APO, HCM, WM

Reporting: BEx, Business Objects 3.1 & 4.0, Crystal Reports

Business Objects Suite: Advanced Analysis, WEBi4.0, SP1-P16, Xcelsius

Responsibilities:

• Responsible for gathering report requirements from business users and prepared functional and technical specification documents.
• Developed Prototype solutions to give conceptual knowledge of the solution.
• Responsible for conducting GAP analysis for Europe/Global Migration based on existing applications/Reports in Production.
• Responsible for design & developing several function modules based on ECC extractors for OTC Enhancements and Applications related to EUROPE Development.
• Developed BI/ABAP based solution for Event Insight Tool from SAP.
• Designed ABAP Function modules to integrate and extract data from ECC tables and Integrated with BI Programs to provide alerts based on threshold inventory levels.
• Currently working on BEx Reports in SCM, Finance, OTC application areas to improve User Adaptability in Europe Migration.
• Responsible for fixing development gaps in HCM implementation.
• Responsible or handling several data flows related to USA / Europe / Global Data Providers.
• Responsible for developing OTC Reporting solutions for Europe VC Data.
• Developed various Function Modules to pull data for OTC Pricing, Orders and Several Europe specific data extractions and Interfaces to generate Flat Files for End Users.
• Responsible for developing and enhancing HCM data sources & PA20 Validation.
• Responsible for developing End-to-End (ABAP Screens & t-codes àBI à BEx à WEBi) solutions for C’Level Executives to view Daily Sales Flash report.
• Developed Several BEx, Crystal & WEBi Reports to accommodate Europe Requirements.
• Responsible for testing SCM, FIN, OTC reports with focus on various currencies and global implementation.
• Responsible for design and developing 80+ WEBi 4.0 Reports based on BEx in Finance, SCM, WM, OTC, Master Data and Procurement functional areas.
• Responsible for handling CMS Requests and Basis Co-ordination & Webi Migration.
• Developed several reports with Advanced Analysis and handed over to Europe Users.
• Worked on Various BEx-WEBi integration issues and responsible for regular validation of all technical features of new WEBi Patches and Service Packs & OSS Notes.
• Responsible for production Support activities and dual development related migrations.
• Handled revalidation of Universes and WEBi 3.1 Reports during Dual development and
• Responsible for T-1 Support during Post Go-Live Activities to handle Access and BEx & Webi Execution issues logged by North America and Europe Users and also updated senior management with status on the status of SD tickets.
• Responsible for handling Team’s BI & ECC transports, builds and cutover validation tasks.