SUMMARY

• SAP Certified BW, HANA, BO Techno Functional consultant with Sixteen plus ( 16+) years of experience in the design, development, implementation, and support of business systems
• Strong experience in Native HANA and BW on HANA involving data modeling, data provisioning, and reporting
• Strong knowledge in integrating BW with SAP SCM, XI, EP and SAP ECC modules like HR, FI, SD, MM & IS Utilities
• Implemented SAP BW projects including Business Blueprinting, Design, Development, Unit Testing, Integration Testing, UAT, Training Documentation and end user training
• As a BW Architect, experience in BI 7.0, BW 7.3, BW 7.4 End to End implementation & production support projects involving ASAP Methodology and expertise in optimizing the design of LSA core layers and moving to LSA++ for BWonHANA landscapes
• Experience in modeling BWonHANA objects like Advanced DSOs (ADSO), Open ODS View, Composite Providers and HANA Analysis Processes (HAP)
• Expertise in designing solutions involving BW models in HANA and provided solutions for Mixed Scenarios reporting for EDW on HANA Implementation projects
• SAP HANA Modeling of Attribute Views, Analytic Views, Calculation Views, Procedures, Decision Tables, Package & Schemas and Analytic Privileges and HANA security
• Sound techno - functional skills in SAP BW with regards to OTC, P2P and IS Utilities modules
• Experience in SAP BW Data modeling of InfoCube, MultiProvider, Virtual Provider, Transient Provider, Composite Provider, DSO, InfoObjects, SPO, Datasource, Transformation & DTP, Process Chains, Open Hub Destination (OHD) and APD
• Designed and developed queries for reporting using BEx Analyzer, Query Designer, and Web Application Designer and extensively worked in BEx Reporting of Selections, Formulas, RKF, CKF, Variables, Processing Types, Conditions, Exceptions, RRI & BEx Broadcasting
• Experience in SAP ABAP customizations for SAP BW Standard Datasource enhancements, Function module based Generic Datasource and develop complex data extraction logic
• Extensively involved in Data load & Report Performance tuning Techniques and handled daily data loads, data load failures, Performance issues, BIA issues, reporting issues, and resource bottleneck issues
• Experience on replicating real-time data from different SAP sources to SAP HANA using Data Services, SAP LT replication server (SLT), Direct Extractor Connection (DXC) and Smart Data Access (SDA)
• Experience in native HANA EDW modeling including design, modeling, data provisioning and SQL Script development
• Experience in building complex Scripting Calculation Views and using them within Graphical Calculation Views and vice versa
• Experience in Implementing Planning scenarios using Integrated Planning (BW - IP)
• Expertise in designing solutions for reporting requirements through Business Objects Universe Designer Tool (UDT), Information Designer Tool (IDT), Web Intelligence, Crystal Reports, Explorer, Analysis for OLAP and administration of Business Objects system
• Developed Tableau dashboards as part of Business objects to Tableau migration project.
• In Tableau, used features like Dynamic filters, Parameters, Action Filters, used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views
• Involved in extraction of planning data from APO-DP Planning Areas and APO-SNP Live Cache to BW and providing master and transactional data required for APO-DP/SNP Optimizer process
• Security: Knowledge on creating users, roles and generating roles / profiles as per business requirements
• Expertise in implementing SAP OSS notes
• Knowledge on setting up communication paths between servers with the use of ALE settings, Ports, Partner Profiles and RFC configurations
• Strong experience with Gathering requirements, Gap Analysis, writing Product requirement, functional specifications and Test Plan documents, systems testing and validation of test results against system requirements.
• Strong analytical and problem-solving skills able to identify flexible and forward-thinking IT solutions.
• Demonstrate excellent written and oral communication skills and able to communicate to all levels of organization, both Business and IT.
• Strong understanding of IT Project management SDLC processes and methodologies, such as Waterfall, Agile Scrum and associated best practices.
• Strong experienced in working with a variety of support models with onsite & offshore resources.

TECHNICAL SKILLS

SAP HANA: Versions: 2.0

SAP BW, IP: Versions: 7.5, 7.3, 7.0, 3.5, 3.0B

SAP Programming: Versions: ABAP/4, SQL for HANA

SAP BO: Versions: 4.1, 4.0, XI 3.1

SAP BODS: Versions: 4.0

SAP ERP: Versions: ECC 6.0, 5.0

Business Objects Tools: IDT, UDT, WEBI, Crystal Reports, Xcelsius, CMC, BI Launchpad, Analysis for OLAP, Lumira and Design Studio

Databases: SAP HANA, Oracle, MSSQL

BW reporting: BEx Query Designer, BEx Analyzer, BEx Web Analyzer, WAD & Enterprise Portal

ERP Packages: SAP ECC COPA, SD, MM, FI, HR, SRM, BCS, APO, CRM & IS Utilities

Data Visualization: SAP Lumira, Design Studio, Tableau

Methodology: ASAP, Agile

PROFESSIONAL EXPERIENCE

Confidential

SAP Data Analytics Lead

Responsibilities:

• SAP HANA Implementation, first of its kind especially in utilities world with all SAP ISU modules(Meter Reading, Sales Statistics, Service Orders, Installation Facts & ISU-CRM integration) with complex master data structures leveraging ODP/ODQ, SAP SLT, HANA Calculation views.
• Proficient in creating HANA relevant objects like Attribute Views, Analytical Views, Calculation Views, Analytical Privileges, Stored Procedures, Scripting Calculation Views for accommodating complex business scenarios
• Expertise in Data Provisioning to replicate data from ECC, non- SAP systems to HANA system through BODS, DXC, and SLT
• Designed and develop efficient, well-structured and documented technical solutions with an emphasis on SAP BW, HANA, BODS, BOBJ and Tableau.
• Involved in importing of BW Models into HANA for specific report requirements
• Involved in SAP (CRM, ISU, BW, HANA) migration from On-premise to Cloud (VirtuStream)
• Rapid-deployment solution (HANA Live) implementation including functional testing
• Involved in HANA Modeling Activities for specific report requirement to achieve the real-time reporting for high volume data, handled native HANA and BW Transport activities across landscapes
• Provided user training on HANA
• Responds to support calls and provides guidance to user’s questions related to reports
• Optimizes BI applications and performs report and query running to improve performance
• Build effective relationships within the organization with other Business units in over to support change request solution design and testing

Environment: SAP BW 7.5, HANA 2.0, BODS 4.2, Tableau online, SAP CRM, IS Utilities, VirtuStream

Confidential, Milwaukee, WI

SAP BI Application Lead

Responsibilities:

• Converting the Functional requirements into Technical Specifications to formulate an appropriate multi-dimensional design
• Extracting FI-AR, FI-GL, CO-PA data from ECC to BW and data flow designs in SAP BW
• Designing and developing RR (Record and Report) reports like Product Cost Itemization, Lower Cost or Market
• As offshore BI Team lead, making daily status calls with onshore and coordinating with offshore team and get the complete update on project status and daily workload activities. Supporting the offshore team for all Functional Clarifications, Technical Solutions

Environment: SAP BW 7.4, Bex, SAP FI CO (ECC 6.0)