Project Sap

: www.linkedin.com/pub/amit-ghildyal/**/***/*b/

Skype id: amit.ghildyal; email: ************@*****.***

Tel: +414-***-****

Experience Summary:-

SAP / BW/BI Project Manager & Solution Architect with multiple years’ experience in IT and SAP. Technological Experience includes Open End Technologies, Client-Server, ERP, SAP R/3, SAP NW 2004s, BI7.0/BOE3.1x, and BW7.3/BI4.0 & BW on HANA. Functional Experience ranges from functional/business requirements gathering and analysis, efforts estimation, Blue-Printing/Designing, conceptual/logical & physical design and modelling, cross-team coordination/team management, development, testing, implementation cut-over and support activities.

Team management/Client facing/handling/cross-functional coordination, solution architecting and delivery management experience as a manager.

Synopsis-

Rendered responsibilities as a BW Manager/Lead/BI Solution Architect/Project Lead/Analyst included base expertise in SAP Business Warehousing and BI sphere; have worked in different BW/BI versions of SAP starting from 3.1H to BW7.3 & BOE3.1x to BI4.0. Functional domains are mainly FI and include CRM, PLM, HCM, and SCM. Industry domains include manufacturing, IT, Oil and Gas, Food and Beverages, High Technology firms, Auto-motives and e-Commerce.

Experience included team management, client handling/management, project mgt., covered 8+ long haul truly Global FSDLC SAP implementations and various short project implementations, testing (unit/functional), transports management, cutover, support and maintenance, rolling out of View tools enterprise wide, end user support, active participation in BI security strategy rollout.

International exposure from working with Big5 such as IBM, Capgemini, global clients like Nestle, British Petroleum, Medtronic, Altera Corporation, Cox News Inc., GE, worked in perm rolls of Rockwell Automation and Johnson Controls. Was involved in the future Roadmap for SAP BI/BOE for Rockwell Automation & Reporting Analytics on adopted SAP products including SAP BW, Business Objects Enterprise tools (Dashboard, Web Intelligence, Crystal Reports, and Advance Analysis), BWA and Business Explorer. Organization wide security enablement for BW/BOE reporting. Project/Engagement Lead for SPM and P2P area in Johnson Controls.

Worked as a Manager–Capgemini Inc. for Technology-Services SAP (SAP BI/BW/HANA- ANALYTICS) Service Line.

Worked as an Architect for Big long-haul global SAP implementations and project initiatives for global organizations.

Architect Responsibilities:-

Detailed Business/Functional Requirement Analysis and Technical Feasibility Analysis

Exploring existing application and System Landscape scenario vs-a-vis needed scenario

Proposing technical solutions with high level Architectural Blue-Print Diagrams

Discussing solution (architectural) options with business and analysts teams, proposing newer methods.

Adopting Agile methodology approach in developing solutions

On-site team coordination/mentoring and management

Offshore team coordination/mentoring/guidance

Working closely with technical analysts/developers/functional leads thru’ full life cycle implementation

Owning responsibilities of successful functional testing in D/Q and Pre Prod Support and validation in P

Participating in different organization processes viz. Change Management, Hyper-care & Cutover activities

Working with other technical teams viz. Basis Architecture, Portals, Security and other technical wings

Maintaining/Supporting smooth flow of Production and Testing environments for operation and testing activities.

Coordinating with external teams on matters of new tools rollouts, system/application upgrades etc.

Courses, Training and Certification

SAP BW – SAP Education, Bangalore

SAP BO – RA INTERNAL TNG., U.S.

SAP BW on HANA – Capgemini Internal, U.S.

SAP S4/HANA- SAP INC.

Software Development on SAP HANA SPS9 – SAP INC.

DRIVING BUSINESS RESULTS WITH BIG DATA – SAP INC.

SAP BUSINESS NETWORKS IN A NUTSHELL – SAP INC.

IN-MEMORY DATA MANAGEMENT 2015 – SAP INC.

ITIL V3 – CSME Inc., U.S.

Environments/Versions

SAP BW 7.x/BI4.0: Core SAP BW7.0/BW7.3, BOE3.1x/BI4.0, ECC6.0, ABAP/4, multi-landscape scenarios.

SAP BUSINESS OBJECT TOOLS SUITE: - Web Intelligence, Design Studio, Crystal Reports, and Office Analysis etc.

Additional Technology: BaaN, ORACLE/TERADATA SQL Scripting

Soft Skills: Managerial Skills, Project/Team Management/Engagement Skills, Communication Skills

Professional Experience

Client: Mondelez International Aug2016- Current

Employer: HP Enterprise

Project: World Wide Mondelez implementation

Role: SAP Project Manager

The SAP Project Manager role for Mondelez comes with a responsibility from end-to-end perspective right from handling/Managing the solutioning->Blue Printing->Realization/Design&Build->Testing (UT/SIT/UAT/RT) ->Cutovers-> Go-live->Hyper-care Support-Project closure and sign-off. Mondelez works on a house management model with HP thus giving HP an opportunity to have deep insight into the procedures and policies of the Mondelez while implementing different geos and functionalities.

Helping managing team on a daily basis to get the projects delivered on time on a tight scale of factors like budget and time. Working and managing better in terms of forecasting the time efforts and revenue generation and project timelines and schedules with higher management. Handling multiple projects at the same time.

Working with different geos also gives a broader understanding of Mondelez business better and help them better to be successful in SAP. The env. Is wide open from SAP ECC, SAP DWM, SAP XI/PI, SAP BI/BO etc...

Achieving high results while delivering on time and to the utmost satisfaction of the client adds value to HP brand.

Client: Pay-Pal, USA Oct.2014 – April2016

Role: Business/Technical Solution Architect and BI Reporting Lead

Project: PFit (Pay-pal Finance Transformation):

Role: Business /Technical Solution Architect

Rendering Business/Technical Solution Architect and Reporting/Analytics Strategist role from Pay-Pal’s world-wide financial systems perspective and future Reporting/Analytics strategy perspective, analyzing the current financial-architecture for overall management reports, devising platform for future state in the new technological platform of SAP HANA(NATIVE), Informatica, Bank-Analyzer on HANA, and SAP BW on HANA. Proposing design solution to the future application landscape on SAP HANA, INFORMATICA, SAP BW on HANA and SAP BA on HANA.

Worked on SAP HANA (NATIVE) and SAP BW on HANA Landscapes:-

-Creating Transient Providers/Virtual Providers for for ad-hoc prototyping in SAP

-Building composite Providers for combining HANA data with BW Data for Joins

-Combine Analytic Indexes created in APD or published SAP HANA models

-Creating Attribute/Analytic and Calculation Views for different modelling requirements

-Using different types of data provisioning as per the fitment of the model and requirements.

-Help Building Using client UI rendering on the SAP HANA development workbench SAP UI5 user interface

Devising future reporting methodology/analytics based on requirements/usability and usefulness of tools and business requirements. Developing HANA/EDW Data modelling for reportings and deciding for reporting tools viz. Tableau, SAP BI and others which has a wide base of different database /staging platforms.

SAP HANA COMPETENCY/PRACTICE INITIATIVES:-

-SAP HANA LANDSCAPE BUILDING

-Successfully Completed/RoAs Various Courses/TNGs. From SAP on SAP HANA & allied technologies

-SAP HANA Real time PoCs Building for various Migration Paths and New Implementation paths

-Building HANA Modelling PoCs for various customer scenarios and fitments

-SLT landscape scenarios/ SAP and Non-SAP Data Source Scenarios Landscape building

Data Core Systems Inc. (DCIL] __Jan.2014-Sep.2014

Role (Independent Consultant) -SAP BI/BW HANA – PRACTICE Lead/ Offshore Delivery Lead & Solution Architect,

Env: SAP BI/BW/BEX, BO, HANA

Project: SAP Offshore Deliverables:

Playing the role of Delivery Lead cum Solution Architect for the deliverables from DCS offshore perspective, managing teams from resource and work –assignment perspective. Cross-team coordination, Solution Architecting across domains & projects, delivery management & reporting and issue-resolution were main responsibilities of the role.

Client: Coca-Cola Refreshments, U.S. Feb. 2013 – Aug. 2013

Role: SAP BI – Delivery Manager and Solution Architect

Project BI Integration: Coca-Cola (CCR) was trying to get all the activities related to its North America bottlers under one template. The initiative was started under one single template, Coke1, and was then extended to all other bottlers including the CCR. CCR already had a matured Reporting System and environment in SAP BW/BI, and wanted to keep/retain most of its reporting area as a ‘whole’ while analyzing if there were any GAPs emerging as a result of new implementation (CONA-Coke One North America); the flow of data for certain areas which would be starting from New Source systems once the system goes live.

Responsibilities:

Detailed analysis of the 2 different systems from GAP perspective. Engaged teams together viz. Business/SMEs/BA. Proposed Design Solutions. Managed offshore for their activities. Successful thorough Initial Analysis from GAP perspective. Successful completion of Funcitonal Requirement Specs for FI (AR/GL) areas. Completed Design Architecture Diagrams for FI area. Successful Initial Reviews with Business and SMEs of the proposed Design Architecture. Successful management/guidance of offshore team for their work

Project Compliance Analytics: Compliance Analytics is a very high level crucial BI reporting area for CCR to gauge the Vendors performance based on orders purchased, in terms of Qty and Amount during a given period. Based on this, CCR determined future orders/purchases from Vendors. This gave CCR a tighter control over their expenses and better vendor management.

Responsibilities:

Delivery Lead/Solution Architect. Preparation of Project Plans including activities from other related areas.

Engaged other teams viz. CCR (Delivery), Basis, Support, and Offshore. Planned execution in a phase manner by coordinating among the team and their related activities. Managed offshore for their activities. Supported during the different testing cycles/cutover/Prod Validation. Ensured overall delivery a success

SAP BW/HANA and SAP BI Competency Initiatives:-

Solution Architecting and Delivering Mgt. plus Initiatives to build competency and capability for SAP BI & HANA.

-Organized workshops for prototyping of models and PoCs and reporting analytics

-Trained on SAP BW on HANA & Worked on various PoCs for SAP BW migration to SAP BW on HANA

-Built use-cases and best fitment scenarios out of various migration paths to the customer

-Build competencies around Business Objects reporting tools to be used in hybrid landscape of SAP BW On Hana

Johnson Controls Inc., U.S. Aug. 2012 – Feb. 2013

Role: SAP BW/BW – Project/Engagement Lead for Spend Performance Mgt. and Purchasing/P2P Area

Project Power Solution Enterprise Systems (PSES): PSES was a hallmark initiative of Johnson Controls to bring its Power Solution Functions on the roadmap of SAP. Spend Performance Management (SPM) was an initiative for Procurement Area under that direction. The SPM was meant to implement to gauge the vendors’ performance across the board for PS area and to make future decision based on their performance KPIs.

Responsibilities:

Engagement Initiative for the Project by doing Research and Analysis. Preparation of Project Plans including activities from other related areas. Engaged other teams viz. SAP Max Attn., Landscape Architecture, Business, and Basis, Charting out the proposals for the implementations by sharing thoughts and presentations. Prepared the platform by implementing the P2P business contents in BW 7.3 Env. Interfacing/Coordinating between business-functions and technical teams. Getting the foundation lead out for P2P area by implementing BI Standard Contents

Rockwell Automation Inc., U.S. June 2008 – Aug. 2012

Role: SAP BI Architect/Lead Analyst

Environment: SAP BW/BOE

Global In-house Implementation

Project Global Process Transformation (GPT): GPT is a Global SAP NW 2004s Rollout implementation project for Rockwell Automation for its different functions and processes around the world to get integrated with. The overall reporting requirement is being catered out of SAP BI 7.0 (SAP NW2004s). The ‘getting implemented’ modules of the SAP are CRM, PLM, FI, HCM, SCM to name few. On the go-track is a plan to implement Business Objects enterprise wide, along with the implementation of several other requirements from all other streams/functions viz. CRM, SCM (APO), PLM, COPA, FI, WORKFLOW, and HCM. The project is divided into different sequential release(s) now running for couple of years since, and would be running for next few years.

Responsibilities:

Worked as a BI/BOE Architect and Lead Analyst for Finance/HCM and PLM areas. Participation in Lay-outing of the future plans for the project/technology and tools. Thorough Analysis of the architectural components to be added/removed. Cross-Functional Team coordination. Scope and Efforts Estimation. Resource planning. Process and Strategy development, Entity Relationship ETL Designing of the system. Guiding/managing team. Project Architecture (Architecture Diagrams, Blueprinting/ERD Designing/Modelling), Review of design/modelling. Engagement in Organisational processes viz. change control/management process, cutover process, test cycle’s process, and hyper care process. Cross Functional engagements. Functional/Business Requirement Understanding. Tech specs Writing. Development, design, extraction, loading, support, and maintenance. Guiding the team thru’ the development. Testing, UTP, UAT, and Integration. Cutover Activities, Worked in close coordination with Basis, Security and Portal Teams. Leading the technological roll outs within the enterprise under the Roadmap Projects

Client: MPM (Momentive Performance Materials, NY), U.S. Nov. 2007 – Feb. 2008

Role: Consultant

Project (Jupiter): BW/SEM- Client recently took over this unite from GE and was in the process of implementing a BW-SEM which included BCS and BPS streams. The major reporting area was Finance/Costing, Planning and Consolidation. The BPS and BCS modules were built and tested, and BW-front-end reporting requirements were designed and developed.

Responsibilities:

Worked as a front-end Architect. Involved in Requirements gathering and analysis. Efforts/Complexity Estimation. Proposed design solutions for requirements. Customized the BI-system accordingly. Designing and development of the solution thru BEx. Testing/interacting with business to validate. Offshore team handling. Requirement transfer/knowledge transfer. Guided teams through development. Quality and Timely Delivery of the assignment.

Client: PDL Biopharma, U.S. __ Aug. 2007 – Oct. 2007

Role: SAP BI Front-end Architect

Environment: BW7.0/IP/ECC

Project BW/IP: Worked from a front-end reporting lead perspective and tried to meet their requirement for their global operations.

Responsibilities:

Working as a front-end Architect. Involved in requirements gathering and analysis

Efforts/Complexity Estimation. Proposed design solutions for requirements. Designed and development of the solution thru BEx. Testing/interacting with business to validate. Requirement transfer/knowledge transfer. Guided team through development. Quality and Timely Delivery of the assignment

Client: Cox News Inc., U.S. April 2007 –July. 2007

Role: SAP BI Architect

Package: SAP ECC 5.0 & Net weaver 2004s (BI7.0)

Project Media Solution: Media Solution was a project in which two major operation lines were taken care of viz. Advertising and Circulation. This gave the Client a clear idea of its operations coverage in terms of area, subscription and volume of business while deciding for the advertising Campaigns based on these inputs.

Responsibilities:

Analysed the initial Organisational structure. Analysed the user’s requirements thru different User requirement questionnaires. Prepared initial BI content Analysis Document. Prepared BI questionnaire. GAP Analysis. Proposed Solution from BI perspective. Activating/Incorporating the required BI contents. Prepared the data flow structure staging data in BW architecture. Analysed different data sources from different source systems for Logistics

Selecting/appending the required enhancements. Creation of Info Providers, sequencing the data flows in them

Scheduled Data Packages. Debugging/Rectifying the data errors. Writing Transfer/Update rules. Unit Testing/System testing. Guided and helped team through development. Arranged meetings with team and key users. Creation of required documents, project documents in share point. Arranged/sequenced project activities. Project management activities

Client: Altera Corporation, U.S. _ __ Jan. 2007 – Feb. 2007

Role: SAP BI Architect

Package: SAP ECC 5.0 & Net weaver 2004s (BI7.0)

Project: Altera’s BW implementation was ranging from its Purchasing side of Business to the Sales. Due to the high technological nature of its business, it needed to go down to the end-to-end implementation cycle.

Responsibilities:

Interacted with key business users and Business Analysts to clarify the requirements and business scenarios to test. Analyses the requirements, estimated complexity and effort estimation. Designed, modelled and developed the requirement as per the System’s Design model of the org. Writing Codes for transfer update rules and field routines

Optimising the solution, thus taking minimum data load time and Query Run time. Leading/guiding the team mates to complex solutions. Debugging, System & Integration Testing of the model. Continuous interaction with the client/team/key users. Progress Updating through meetings/discussions, mails. Suggested/defined solutions at times

Client: BP Taxwise, U.K. May 2006 – Nov. 2006

Role: SAP BI Onsite Coordinator and Analyst

Package: SAP R/3 4.6c & BW3.5

Project BP’s IST BW Implementation with BP Taxwise BW: BP Taxwise is BP’s BW system to handle the indirect taxes for its different geographies viz. Oil Americas, EAO and EH regions. This phase was set to test the BP Taxwise system for BP’s IST (integrated supply and trading) operations.

Responsibilities:

Interacted with the management and business to identify business requirements. Involved in the design and development changes to Info -Cubes, ODS, Multiproviders in the implementation of IST implementation of BP Tax wise project. Developing Reports per user requirements. Created Standard multidimensional queries. Made modifications and corrections to existing reports. Assisted in cube changes and modifications. Analysed Cubes/ODS/Multi-providers for BW data issues. Checked Info packages for data load issues. Analysed Info objects Key Figures and Characteristics and Navigational Attributes. Implemented Customer Planning Account Hierarchies in BW reports. Analysed Functional Specifications/Technical Specifications for trouble shooting, Monitored master and transactions data loads, using BW monitor. Developed BEx Queries for IST operations for SD, MM, Purchase and FI areas. Utilized frequently BW Admin Work bench RSA1 for checking into cube designs and analyzing cube structure. Checked Key figures and Master data attributes, texts, hierarchies in cubes for trouble shooting. From RSA1 displaying contents of cube using ListCube transactions for displaying contents fact tables. Analysed SAP tables using SE16 transactions for troubleshooting data issues. Analysed Extract Structure from SE11. Production Support in BW. Reconciling BW reports data with source data

Worked with BW team to trouble shoots Errors and problems in reports. Worked with BW team to resolve load issues Checked Data Staging for receiving source files using AL11 transaction. Using RSA3 to check extractors for data load issues. RSA6 and RSA5 for checking data sources for solving data issues. Using RSRT for query monitoring and trouble shooting. Used RSD1 for analysing/maintenance of info objects settings. Assisted in Scheduling Jobs for data loads, Trouble Shooting issues in Multi providers and ODS. Verifying Transfer Rules/Update Rules. Integration Testing and Validating Reports:

Actively involved in formulating overall testing strategy, setting up test plans and test labs in Mercury Quality Centre Powered by Test Director. Tested different test conditions for different regions technically and functionally, end to end Fault finding Analysis. Raised defects, logged them in Clear Quest and retested plans and execution after receiving clarification from Business Analysts. Regression testing for any change requests or modifications done

Analysis Testing and Documentation of CR15 for Canadian region across the systems viz. Source BW System-Informatica – Taxwise BW. Documentation of overall testing/changes/analysis

Client: British Petroleum, Canada __ Nov. 2005 – April 2006

Role: SAP BI Team Lead

Package: SAP R/3 4.6 & BW 3.5

Project BP BW Implementation for GFO Project: BP Canada GFO project involved implementation of BW for its Canadian Region for FI area. It inherited the reporting structures from its legacy system running for Americas on EPDW/Oracle and I-reporter architecture. The equal interpretence of all its required FI reports and creation of different hierarchies into BW involved other technologies like EPDW/ORACLE as well, for analysis, during implementation.

Responsibilities:

Understanding the BW design and its interfaces with legacy system on EPDW and Oracle and SAPR/3. Carrying out configuration of BW objects like Info Cubes, Queries and Workbooks. Analysed and estimated Requirement, complexity and time consumption wise. Analysed PL/SQL codes from legacy systems and creating equivalent in SAP BW system

Proposed appropriate changes. Customized BW objects including ODS, Cube, Info Source, Transfer Rules/Update Rules

Writing Programs for Start Routine/Update Rules/Transfer Rules. Data loading (Master and Transaction)

Quality-Review of developments. Maintained systems related to projects viz. SDMS, SDC. Understanding SQL codes for mapping purpose. Created mapping documents interpreting SQL documents. Created equivalent codes by writing ABAP transfer routines/ Start Routines or Field Routines. Management of data load thru RSA1/RSPC/RSPCM. Management of data load, data sources, source system replication thru RSA1. Creation of Master Data Hierarchies viz. 0ACCOUNT, 0COSTCENTER by writing ABAP programs and loading it later on the QA system as well. Testing the developments across the systems-end to end. Documentation of the developments / TPRs / CRs

Client: Medtronic Inc., U.S. Jan. 2005 – Oct. 2005

Role: SAP BI Team Member and Lead

Package: SAP R/3 4.6 & BW 3.5

Project SAP BW Implementation: Medtronic Incorporation required BW implementation for it Sales module DataWarehousing and report generation requirements. Being a full life cycle implementation starts with designing and modelling-creating different BW objects and goes up to the customization of the requirements based on InfoSet queries, ODS customization, involving master data, and transaction data from all operational areas.

Responsibilities:

Understanding the requirement. Feasibility study and time and effort estimation. Client and onsite team interaction/discussion. Prepared the detail Technical specification, which included design of Data Sources and ODSs.

Enhancement of Standard extractors and development of Custom Data extractors. Developed Extractors in R/3 and required Info Objects and ODS in BW. Designed/modelled/reported the requirements through different methodologies, Created Queries thru BEx for Sales requirements. Created Cell Referencing Queries. Created Matrix Queries (using Cell Referencing Feature). Writing Start Routine/ Filed Routines thru’ ABAP. Data load Management thru RSA1/RSPC/RSPCM. Sales Master Data Load and Transaction Data Load. Loading data for Sales Order, Delivery and Billing. Worked on Sales Data for creating reports. Adding required fields into the objects like ODS. Creating full flow for the data flow viz. right from creating data sources in source system, replicating them in the target system, creating update rules thru Info Source structure, writing rules/routines for uploading them further to desired data target, testing them for data validation. Creating/Checking Extract Structures/Data Sources for fine working thru RSA3 & RSA6 for fine performance, field addition, testing data thru RSA6 for structure and data validation. Checked data load process/flow thru RSPC/RSPCM. Debugging/Simulating data loads for faulty data loads. Rectifying data loads thru PSAs. Analysed Functional Specs/ Writing Tech Specs. Routine Client and Onsite Team Interaction. Meeting Client Expectation by following best practices. Managed Deliverables thru SDMS and SDCs

Client: Nestle Inc. __ Sept. 2003 – Dec. 2004

Role: SAP ABAP Team Member and Lead

Package: SAP R/3 4.6

Project SAP R/3 Implementation and Hyper-care Support: The project involved the implementation of SAP R/3. All modules of SAP’s viz. Sales and Distribution, Finance and Controlling, Materials Management, Quality Management, Production Planning, Human Resource Management, Plant Maintenance, and Project Systems was being implemented in this project. Analytical reports encompassing all these modules were provided out of customizing Reporting. It involved extracting and transforming data from all SAP modules and history data from other existing legacy systems.

Responsibilities:

Custom Dev Team Member/Support Shift Manager. Programming/coding. Testing and debugging. Code walkthroughs as required. Unit Test Summary as required. Managed Support Shift. Interacted with the Client. Provided Solutions. Coordinated Activities in order to get the solution at the earliest. Worked in CS area for SD module. Writing Report Programs. Created Smart forms for their SD invoices and Debit/Credit Notes. Converted/Designed Smart forms for their SD requirements. Worked for their materials mgt. Requirement. Worked in module pool programming during development. Regular Team Interaction for further development discussion/ issue clarifications/resolutions.

Education

Masters in International Business & Industrial Economics – University of Allahabad, 1995

Post Graduate Diploma in Computer Applications (Equivalent to US Bachelors in CS) – IERT Allahabad, 1996

Diploma in Business Management – IGNOU, New Delhi, 2000

Contact this candidate