PROFILE:

• Total IT experience of 13 years in SAP Native HANA / S/4 HANA/ SAP BW/ SAP BO consulting assignments. These include all types of projects like implementation, maintenance and production support background in all phases of ASAP methodology in SAP BW/BI.
• Experienced in THREE Full Cycle SAP Implementation involving - SAP Native HANA / S/4 HANA/ SAP BW/ SAP BO.
• SAP Certified in SAP HANA & SAP BW 7.0 and SAP MM (Materials Management), i.e three diffrent expert level certificates in three different SAP Areas.
• Extensive experience in implementingSAP HANA Analytics, S/4 HANA and SAP HANA Data Modeling as end to end Solution Architect.
• Good experience and exposure in implementing Analytics for SAP S/4 Simple Finance.
• Hands on experience in End to End SAP BW to HANA Migration as well as Native HANA modelling, Architecture and Administration.
• Good knowledge of S/4 HANA. Worked on feasibility exercise and presentations on S/4 HANA and Digital Transformation of Enterprise.
• Good exposure to latest HANA technologies like HANA XS Engine, HANA Predictive Analytics Engine (PAL), SAP HANA Cloud Platform Analytics / API Library, SAP Business Objects Cloud and Digital Boardroom.
• Worked on Designing and Architecting the complete BW 7.3 solution on HANA and move from LSA to LSA++ architecture. Created designs with advanced HANA objects like Composite and Transient Providers, Hybrid providers, Open DSO & HANA Optimized Cube and DSOs
• Good Functional Knowledge of Finance (Accounts Payable & Accounts Receivable) and CRM functional areas
• Worked in parallel in Native Hana (Hana Studio) in creating end to end data models for reporting solutions like COPA & Logistics with data replication scenarios both from SLT and BODS
• Analyzed and Implemented HANA Live solutions for SAP COPA and SAP Logistics areas.
• Good working knowledge on SQL Scripting and procedures
• Involved from requirement gathering, analysis, and design and then build of the Backend data flow in SAP 7.3 system and culminating into building of SAP BO 4.1 (Business Objects) reports (Webi) on SAP BEx Analyzer Queries
• Worked in BO 4.1 tool on universe design as well as created reports in Webi and Crystal.
• Worked on HANA advanced dashboarding and reporting tools like Design Studio and Analysis for office
• Good Functional knowledge of SAP ECC modules like Sales & Distribution, Materials Management and SAP Finance, Plant Maintenance etc. This knowledge has helped in gathering customer requirements & building and testing reports
• Good experience in working and leading projects where the backend data model is built in SAP BW and front end reports are delivered using Business Objects tools like Webi, Crystal and Dashboards
• Very good experience in Oil and Gas’’ and Utility Sector companies, handling both Upstream and Downstream line of business
• Have worked for three major Oil and Gas Projects (BP USA, Confidential USA, BP UK); both as a hands on SAP BW developer/Architect earlier and then later as a SAP BW Lead handling both teams Onsite (USA) and offshore (India)
• End to End trained on SAP HANA SPS04 (in all areas like Implementation, Modelling, Security & Authorization, Data Provisioning, SAP HANA Administration, reporting & SAP BW on Hana).
• Good hands on working experience in HANA Modelling in SAP HANA SPS04 environment and SAP BW 7.3
• Hands on experience in developing SAP BO (Business Objects) reports in with BO WEBI & Crystal reports and BEx Analyzer in Harley Davidson project
• Completed 3 successful full lifecycle implementations with experience as Senior BW/BI consultant
• Extensive hands on experience in SAP APO & BW integration in implementation projects.
• Experience in SAP BI and BPC integration and making SAP BW data available for BPC.
• Proven Functional and Solutions designing experience across various SAP Modules like SAP MM,SD, SCM, OTC, CRM etc.,
• Successful implementation of Functional and BI/BW back-end and front-end solutions in cross application modules like Logistics, APO, OTC, FI-CO and core SAP modules
• Worked in every phase of ASAP methodology, from Business Blueprint, Project Preparation, Requirements Gathering and Analysis, Realization/Configuration, system test plans, unit testing, Go-Live, Production Support, Ad-hoc query reporting, end user documentation and training
• Proficient in SAP technical areas like ABAP and Workflow
• Self-motivated problem-solver with exceptional commitment to high quality, strong analytical capability, communication, persuasion and leadership skills.
• Experienced in defining systems strategy, developing systems requirements, designing and prototyping, testing, training, defining support procedures and implementing practical business solutions under multiple deadlines
• Adept at implementing technology-enabled business solutions for clients as part of a high-talent team and as a team lead or Project Manager on at least 1+ full cycle implementation

TECHNICAL SKILLS:

SAP BW - 7.4, 7.3, 7.0, 3.5 (SAP Certified BW 7.0 Consultant)

SAP HANA - 1.0, SP10 (SAP Certified HANA Consultant)

SAP SLT, SQL Script Procedures, SAP Native/ Enterprise HANA Architecture / modelling

HANA XS Engine, HANA Predictive Analytics Engine (PAL)

SAP HANA Cloud Platform Analytics / API Library

SAP Business Objects Cloud and Digital Boardroom.

SAP MM (SAP Certified MM Consultant)

SAP Business Objects - 4.1

SAP BODS, SAP Information Steward.

SQL Script.

SAP BPC - 10.0

SAP ABAP, BWA, NLS, BEx Query Designer, WAD, Webi, Dashboard, AOLAP

BW integration with Logistics, SD, FI, AR, AP, MM, CRM, HR, APO

R3 (SAP ECC 6.0,ECC 5.0, 4.6C, 4.0 & 3.0), Oracle, Access

Ascential data stage, Informatica

Service manager 7, HP Quality center 10.1

Control M

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SAP NATIVE HANA & BW ON HANA ARCHITECT

Responsibilities:

• Creating the Technical design and building the end to end reporting solution based on HANA Views for various areas like Finance, Logistics, HR etc.
• This involves creation of Attribute, Analytic, Calculation views as well as SQL Procedures and functions.
• Making the required tables available using either SLT or SAP BODS.
• Creating the Universe in IDT on top of the Calculation Views and making the BO reports available.
• Working on various BO reporting tools like Webi, Crystal, Design Studio, Analysis Office and Lumira.
• Exporting data from HANA tables to Informatica using UC4 Scheduler Jobs.
• Importing data back into HANA from Informatica after transformations, to provide data set for Snapshot reporting.
• Extensively worked on SQL Script Procedures, SAP Native/ Enterprise HANA Architecture / modelling.
• Designed and Implemented a SAP SDI(Smart Data Integration) scenario where data from an external source was Integrated with HANA data for combined reporting,
• Worked extensively on SAP SLT (SAP Landscape Transformation).
• Was part of SAP ECC Upgrade to EHP 7 and then to S/4 HANA Simple Finance 1605.
• Worked on S/4 HANA Simple Finance Analytics requirement gathering design and build.
• Worked on S/4 HANA CDS views.
• Worked in design architecture and Impmenting a Central Finance Solution by consolidating data from a number of different local S/4 / Regional ECC systems.
• Worked on HANA XS Engine and HANA Predictive Analytics Engine (PAL)
• Worked on SAP HANA Cloud Platform Analytics / API Library and Business Objects Cloud and Digital Boardroom.
• Worked on SAP HCI (Hana Cloud Integration) scenario where a new company implemented S/4 .
• Working on Designing and Architecting the complete BW 7.4 solution on HANA and move from LSA to LSA++ architecture. Created designs with advanced HANA objects like Composite and Transient Providers, Hybrid providers, Open DSO & HANA Optimized Cube and DSOs.
• Working on Hybrid Reporting solutions where data from HANA Views are made available in BW using Transient providers and utilized using Composite Providers. Also data in BW infoproviders are made available in form of HANA Views for reporting
• Involved from requirement gathering, analysis, and design and then build of the Backend data flow in SAP 7.4 system

Confidential, Nashville, TN

Architect SAP Data Services, Information Steward & HANA

Responsibilities:

• Creating Interfaces with complex transformation to transfer data from various source systems like, SAP ECC, SAP BW, HANA Sidecar and SQL Server.
• Automating the Datservices Job execution using Enterprise scheduling tools like Cybermation.
• Execution of jobs and troubleshooting.
• Worked on S/4 HANA Simple Finance Analytics requirement gathering design and build of CDS Views.
• Expereinced in SAP SLT Configurations.
• Using SAP BODS for exporting data to Informatica.
• Creating Rules, Views and Scorecards / Dashboards to monitor Data Quality and take corrective actions.
• End user training and knowledge transfer.

Confidential, Roseland, NJ

Architect Native HANA & BW on HANA & Implementation

Responsibilities:

• Created end to end data modelling solutions in Native Hana for Finance &CRM areas called ‘’Accounts Planning’’ to make the reports available through BO Front End.
• Detailed Functional knowledge of CRM & Finance areas like Account Planning, Accounts Payable and Receivable was required to create the end to end models for reporting.
• Worked on SQL Scripting tasks like creating SQL Procedures, CE Functions, SQL Debugging etc.
• Worked in parallel in Native Hana (Hana Studio SP -09) in creation of Attribute, Analytic and calculation views, to provide end to end Native HANA models, for critical business Functions like Utilization, Time & Expense, Cash Recieved, Indirect Projects, Open AR etc.
• Worked with the BO Team to Integrate these Views with the BO Universes.
• Worked with BO team on creation of Webi, Crystal reports and Design Studio Dashboards,as well as Lumira & Tableau.
• Helped the DELTEK HANA project go live. Was part of Post Go Live, one month Critical care phase.
• Created new reporting solutions using resuse Views of HANA LIVE Virtual Data Models
• Now working on Enhancements, adjustments to the Models and handling day to day user tickets.
• Created Users, Roles and HANA Authorizations to handle HANA Security scenarios.
• Worked on SAP HCI (Hana Cloud Integration) HANA Implementation on Cloud scenarios.
• Extensively worked on SQL Script Procedures, SAP Native/ Enterprise HANA Architecture / modelling.
• Worked on SAP SDI(Smart Data Integration) and created combined reporting solutions in HANA.
• Used SAP Information Steward to create Scorecards, Profiles, Validation rules etc.
• Worked on SAP HANA Cloud Platform Analytics / API Library and Business Objects Cloud and Digital Boardroom.
• Worked extensively on SAP SLT (SAP Landscape Transformation).
• Upgraded the SAP ECC to S/4 Simple Finance 1511 version.
• Worked on S/4 HANA Simple Finance Analytics requirement gathering design and build.
• Worked on designing and consolidating data from number of different systems into a Central Finance S/4 solution.
• Worked on Modelling of S/4 HANA CDS views.
• Worked on HANA XS Engine & HANA Predictive Analytics Engine (PAL).
• Worked on creation of Master Data models in SAP BW 7.4 for use in Native HANA as Attribute Views.
• Created Process Chains and end to end load schedules for these BW Objects like Engagement, Phase, and Employee etc.
• Finally integrated these BW Objects/Views in End to End Flows in Native HANA modelling Studio.
• Worked on upgrading the BW on HANA System from LSA to LSA++ Architecture.
• Created Advanced BW on HANA Objects like Advanced DSOs, Composite Providers & Transient Providers.
• Worked on solutions for BPC(Business Planning & Integration) and MDG(Master Data Governance).
• Gave BW on HANA training to SAP support team as well as end users.

Confidential, Minneapolis, Minnesota

Data Architect BW

Responsibilities:

• Worked as a SAP BW/HANA Data Architect in a project named Flash to migrate a SAP BW 7.0 system to SAP BW 7.4 using full HANA functionalities.
• Worked on Designing and Architecting the complete BW 7.4 solution on HANA and move from LSA to LSA++ architecture. Created designs with advanced HANA objects like Composite and Transient Providers, Hybrid providers, Open DSO & HANA Optimized Cube and DSOs.
• Involved from requirement gathering, analysis, and design and then build of the Backend data flow in SAP 7.4 system and culminating into building of SAP BO 4.1 (Business Objects) reports (Webi) on SAP BEx Analyzer Queries.
• Worked in BO 4.1 tool on universe design as well as created reports in Webi and Crystal.
• Worked extensively on Finance Areas ( Accounts Payable and Accounts Receivable).
• Worked on CRM data flows and Reports.
• Worked on integration of specialized modules like MDG and EHSM(Environmental Health & Safety Management).
• Trained End Users and Power uers on BW on HANA and BO reports.
• Worked in parallel in Native Hana (Hana Studio) in creating end to end data models for reporting solutions like COPA & Logistics with data replication scenarios both from SLT and BODS for different HANA Sidecar scenarios.
• Worked on Modelling and Data provisioning, Security & Administration in Native Hana (HANA STUDIO) in SAP HANA for a POC project involving SAP COPA data.
• Was involved in advanced modelling in Native Hana where I created Attribute, Analytic and calculation views in HANA Studio and ultimately
• Worked with SAP BODS (BO Data Services) & SAP SLT (SAP Landscape Transformation) tools for extracting data from SAP and Non SAP systems to HANA for Real Time and Batch Data Provisioning.
• Created Validation Rules, Scorecards, Profiles etc in SAP Information Steward.
• Worked on HANA Security. Created Users Roles and assigned HANA Privledges.
• Worked with BO team on creation of Webi, Crystal reports.
• Worked on Design Studio Dashboards as well as on Lumira & Tableau.
• Worked on integration of SAP BW and HANA Studio by creating reporting Infoproviders in SAP BW based on HANA Views(Transient providers).
• Worked on different HANA Live Solutions from Virtual Data Model, with the goal of activating and utilizing it for different real time reporting needs of the project.
• Worked with SQL Scripting for Complex Currency conversion modelling scenarios and creation of SQL Procedures.
• Worked on Implementing a COPA HANA Live end to end business flow.
• Worked on specialized Finance reporting like Treasury Management.
• Worked on HANA advanced dash boarding and reporting tools like Design Studio and Analysis for office.
• Worked on HANA on cloud scenarios.
• Did Presentations, Customer Workshops on S/4 HANA and digital transformation.

Confidential, Houston, TX

Architect SAP BW on HANA & Native HANA

Responsibilities:

• After technical Migration to BW on HANA, Worked on Designing and Architecting the complete BW 7.4 solution on HANA and move from LSA to LSA++ architecture. Created designs with advanced HANA objects like Composite and Transient Providers, Hybrid providers, Open DSO & HANA Optimized Cube and DSOs
• Created end to end reporting solutions for Finance reports for COPA and Treasury Management areas.
• Engaged in design and build of Backend flow in SAP BW 7.4 system followed by creation of Reports in SAP BO 4.0(Business Objects), for a Critical list of management reports called ‘’President’s List’’.
• Responsible from requirement gathering, analysis, design and then build of the Backend data flow in SAP 7.3 system and culminating into building of SAP BO 4.1 (Business Objects) reports(Webi) on top of SAP BW BEx Analyzer Queries.
• Responsible for creating and maintaining data flows in SAP BW 7.3 system (on HANA Database).
• Delivered End to End reports (Both Webi & Crystal) which had both complex Publication and Adhoc requirements.
• Involved in all phases of project like conducting user requirement gathering workshops, doing the development, arranging security, and helping users perform UAT (User Acceptance Testing).
• Did extensive back end development in SAP BW 7.3 system on HANA Database and also handled Symantec Partitioning Object.
• Trained a batch of Super users on BW on HANA and Native HANA .
• Worked on Modelling, Data provisioning, and Security & Administration in Native Hana (HANA STUDIO) for different Logistics and Finance reporting solutions in Hana Sidecar Scenario.
• Worked actively on an End to End ‘’ Sales and Profitability’’ solution creation in Native HANA (HANA Studio) using the Graphical modelling interface.
• Created number of ‘’ Attribute Views and Analytic Views’’ on different Material and Customer tables from ECC as well as combined everything with the COPA tables using Calculation views. BO reports (Webi and Crystal) were created on top of these.
• Worked with the Basis and Security teams in creating the HANA studio security setup as well as worked on Hana transports.
• Created Users, Roles and HANA Authorizations to handle HANA Security scenarios.
• This ‘’End to End’’ Sales Project included hands on working on all HANA areas like Data Modelling, Data provisioning/replication using SLT(SAP Landscape Transformation)&SAP BODS(BO Data Services), Security & Authorization, Transport Management as well as some HANA System Monitoring and System administration.
• Used SAP BODS(BO Data Services) & SAP SLT( SAP Landscape Transformation) tools for extracting data from SAP and Non SAP systems to HANA with objective of both Real Time and Batch Data Provisioning.
• Used SAP Information Steward to create Scorecards, Profiles, Validation rules etc.
• Worked on analyzing and using HANA Live content from Virtual Data Models to make complete Finance and Logistics reports available to users.
• Worked on complex calculation views using SQL Scripting.
• HANA advanced dash boarding and reporting tools like Design Studio and Analysis for office as well as Lumira and Tableau.
• Worked on integration of SAP BW and HANA Studio by creating reporting Infoproviders in SAP BW based on HANA Views (Transient providers). Also worked on utilizing BW Infoproviders in HANA Studio.

Confidential

Architect & Project Manager (SAP HANA / BW)

Responsibilities:

• Worked as Architect & Lead Consultant for PTS (Procure to Supply) module. Primarily responsible for entire Design and Build and Integration of SAP APO and BW systems.
• Doing entire design and build of back end and reports of APO DP (DEMAND PLANNING) module.
• Doing entire design and build of back end and reports of APO SNP (SUPPLY NETWORK PLANNING) module.
• Currently responsible for successful Go-Live of PTS module for CEU (Central Europe) in November 2013. Also helping McCain go live for SAM & SAF (South America & South Africa) later in 2014.
• Helping McCain import their entire Sales history, from Legacy systems to SAP BW and SAP APO systems.
• Worked on designing reports related to Plant Maintenance and Project systems module involving KPIs like downtime calculations, Preventive and Predictive maintenance planning as well as worked with other EAM (Enterprise Asset Management) module data modelling and designing.
• Conducted requirement gathering workshops with Plant Maintenance users to understand their reporting requirements, did GAP analysis with the present design and prepared the technical specifications and high level design for Plant Maintenance reporting.
• Worked on data extraction and reporting for SAP SEM and SAP BPC modules.
• Worked on design and development of group of SAP Finance EPM reports. This included specification gathering, discussions with cross functional teams and finally design and development.
• Involved from requirement gathering, analysis, design and then build of the Backend data flow in SAP 7.3 system and culminating into building of SAP BO 4.1 (Business Objects) reports(Webi) on SAP BEx Analyzer Queries.
• Worked in BO 4.1 tool on universe design as well as created reports in Webi and Crystal.
• Worked on HANA advanced dashboarding and reporting tools like Design Studio and Analysis for office.
• Worked on a HANA Pilot project which involved creation of Logistics data model in SAP HANA SPS04 & SAP BW 7.3 on HANA DATABASE landscape. This included working on all HANA areas like, Data modelling in HANA Studio, Data provisioning, HANA user security and Authorization, Hana Transport management, and HANA system Monitoring and Administration.
• Did advanced modelling in Native Hana (HANA STUDIO) as well as worked in areas of data provisioning, security and Administration.
• Was part of CORE HANA team which had frequent workshops with SAP on various HANA engagement as well as part of HANA sales and Promotion team.
• Worked as SAP HANA/ BW Subject Matter Expert advising various projects and Sales/ Solutioning teams on end to end HANA engagements.
• Worked on few different Finance and Logistics Native HANA reporting solutions in HANA Sidecar scenario.
• Worked with SAP BODS (BO Data Services) & SAP SLT( SAP Landscape Transformation) tools for extracting data from both SAP and Non SAP Systems.
• Worked with various Materials Management and Sales and Distribution HANA Live solutions.

Confidential, Houston, TXD

Sr. SAP BW /BO Consultant & Onsite Lead

Responsibilities:

• Worked extensively on creating and supporting Finance and Controlling reports.
• Worked on end to end development of a critical Finance Reports called ‘’NAGP Accruals’’ and few others. This includes the designing the entire flow from extraction of data from ECC to making the report available as well as distribution of report using Info spokes and other tools.
• Involved in upgrading the BP WR5 BW system from version 3.5 to 7.0.
• Worked extensively on SAP SEM and consolidation data loads and maintaining the SEM reporting solutions.
• Worked on SAP BI and BPC integration and making SAP BW data available for BPC. Also worked on SAP BI-BPC data reconciliation issues
• Worked as an Architect with the BP and IBM Teams to Migrate the SAP BW system to SAP BW 7.3 on HANA.
• Supported the BPS Application in their day to day activities.
• Worked on redesign and rebuild of the SAP BW system as per SAP HANA 7.3 principles and on data loads from SLT (SAP Landscape Transformation).
• As a Native HANA developer worked on two POC projects (Finance & SD) which involved creation of data models in SAP HANA SPS06 & SAP BW 7.3 on HANA DATABASE landscape.
• This included working on all HANA areas like, Data modelling in HANA Studio, Data provisioning, HANA user security and Authorization, Hana Transport management, and HANA system Monitoring and Administration.
• Exporting data from SAP BW to external systems like Informatica using Open Hub Destinations.
• Supported SAP IP (Integrated Planning) solution.
• Worked with SAP BODS (BO Data Services) & SAP SLT ( SAP Landscape Transformation) tools for extracting data from SAP and Non SAP systems to HANA for Real Time and Batch Data Provisioning.

Confidential, Milwaukee, WI

BI /BW Senior Developer/ BI lead for IBM/ Project Manager

Responsibilities:

• Worked as senior developer in a Global SAP Implementation project named GME (Global Manufacturing Engine).
• Worked extensively on gathering requirements from users and converting them to
• Functional and Technical specifications, by organizing Workshops with Power users.
• Worked on end to end report developments for all SAP modules like MM, SD, PP, FICO etc.
• Worked extensively with the SAP Security team and created the authorizations and security guidelines for all consultants / users in both BW, APO &ECC environments.
• Majority of development were done to make APO/SCM (Advanced Planner & Optimizer & Supply chain management) available from Enterprise BW system. Worked extensively on APO /BW integration and development.
• Designed and created reports for Plant Maintenance module. This involved integrating & scheduling of Preventive and Predictive Maintenance schedules and calculating downtimes as well as worked on creating design and data models for EAM (Enterprise Asset Management) module.
• Worked end to end (From Specification gathering to data model to report creation), for many Finance and Controlling reports.
• To create the Plant Maintenance reporting solution, conducted series of requirement gathering workshops with the end users and prepared the Technical Specification documents.
• Created the reports in using BEx query designer.
• Developed WEBI & Crystal reports on top of BEx Analyzer reports for all reporting requirements
• Enhanced LIS data sources to create end to end reporting solution for many logistics areas.
• Worked on multiple end routines, transformation routines to model data into the Info providers.
• Hosted requirement gathering workshops and did design and development for SAP SEM and consolidation global reporting solutions.
• Worked on creating ‘’End to End’’ reporting solutions in CRM and Billing areas.
• Designed and developed an EPM reporting solution which included, Planning, Budgeting and Finance reports.
• Integral part of the BI APO implementation (DP).
• Defined the BI-architecture for DP waterfall and forecast accuracy report based on adjusted sales history from APO server.
• Organized multiple workshop sessions to train users with reports (BEx Analyzer, Info view, Webi, Crystal Reports).

Confidential, Houston, TX

SME (Subject Matter Expert) in BI/BW & Logistics / Project Manager

Responsibilities:

• As BW SME my primary mandate was to review all load processes and Process chains and redesign them to bring in performance improvement
• Was involved in reviewing the design and architecture of their Inventory management system. Suggested solutions and alternatives.
• Was involved in redesign of many Process chains and extraction processes which brought about significant time savings.
• Organized requirements gathering to identify reporting demands in core SAP modules.
• Extensively involved in creating functional specifications for global requirements and technical specifications for reporting needs in core SAP modules.
• Created end to end data flow for many reports in the Logistics area.

Confidential, Denver, Colorado

BI Techno-Functional Architect / Project Manager

Responsibilities:

• As Team lead and BI Architect was responsible for entire Design, Development and Delivery of SAP BI module.
• Was involved with Basis in installation of BI Module, Source system configuration and setting up of all the system connectivity.
• Was involved in installation of SAP Business content and Demo content for many Functional area and giving report presentations to the Core/Super user group
• Organized requirements gathering to identify reporting demands in core SAP modules.
• Extensively involved in creating functional specifications for global requirements and technical specifications for reporting needs in core SAP modules.
• Created end to end data flow for many reports in the Logistics area.
• Created setup tables and did the initial data loads for all Logistic cockpit areas.
• Designed the complete data flow and reporting solution for CRM and Billing areas.
• Was involved in leading the End user training workshops and creation of all end user training materials.