SUMMARY

• 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.
• Functional Modules & Aras - MM, SD, PM/QM, PP, HR-PY, PA, FI-AP/GL/GLX (New GL), FM- Budgets, Actuals, Commitments & APO 3.1, SRM.
• 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 - Worked on DB Upgrade and SLT Approach for Optimized Data Loads in BW and BPC.
• 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 also 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 6.0, SAP BW 3.X/7.X, HANA, SLT, NLS, SDI, SDA

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

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, TX

SAP BI BPC Consultant

Responsibilities:

• Responsible for handling upgrade activities for BI 7.5 & BPC 10.1 EPM
• Working 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.
• Worked with Basis and Security to handle, disk space, security, roles related check points.
• 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.
• Worked with SAP to resolve pending issues in BPC Area on Transports, Log Sizing and BI 7.5 testing on data load delays.
• Worked on HANA modelling using Several (C&A) views, AMDP based solutions and migrating legacy BW data loads to HANA View based Solutions.
• In Confidential - Brakes Initiative, responsible for discovery of new data load methods using SDA from Brakes Sources (Brakes UK, newly acquired by Confidential ).
• Responsible for Work distribution, documentation for support and Issue resolution in BI & HANA & BPC Team.
• Developed User Guides for Corporate Users on new features in BPC and BW 7.5.

Confidential, GA

SAP HANA BI APO Consultant

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.
• 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.

Confidential, NC

SAP HANA Consultant & SAP BW BPC Architect

Responsibilities:

• Responsible for working with several teams at Bank to upgrade from DB2 to HDB.
• Handled 10+ upgrade cycles of BPC system to HDB with several data load scenarios.
• 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.

Confidential, GA

SAP HANA Consultant & SAP BW BPC Architect

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.