Ankur Shah

Senior SAP Certified Technical Lead – BI/BW, HANA & CLOUD

adv9us@r.postjobfree.com

732-***-****)

Ankur is Certified SAP BI & SAP HANA Consultant having 15+ years of IT industry and nearly 14+ years of SAP experience in Medical Technology, Finance, Retail, Manufacturing, Beverage, Chemical and Utilities & Energy Industries. He has experienced in the field of Enterprise Resource Planning (SAP), Business Intelligence (BI), BO (Business Objects), IP, BPC, HANA, BW/4HANA, QlikView, Power BI, CLOUD technologies and SAP Predictive Analytics. Over the years, he has performed various roles like Application Developer, Business Process Analyst, Team Leader, Technical Design Specialist, BI Architect, SAP Project Delivery Manager, Transition Manager and Project Manager & managed complex multi-phase deployments of application development for Fortune 500 clients.

CLOUD Expertise:

Consulting with prospective clients to determine needs, conduct on-site technical assessments, designing effective solutions, and resolving business critical issues on Cloud and on-Prem solutions.

Experience developing and implementing cloud migration strategies including SAP.

Lead team and cross-team meetings.

Work closely with partner teams to ensure that infrastructure required to support new applications and capacity expansions are ready well in-advance of need.

Partner with application managers to develop capacity requirements for new projects.

Developed plans, timelines & procedures related to integration test & sanity checklist.

Creating, validating & reviewing solutions and effort estimates for data center migration.

Exposing SC Data Models into SAC using live connection.

Implemented stories using different features of SAC.

Knowledge in configuration of live data and import data connections and data acquisition.

SAP BI/BW Expertise:

BW Extraction(ETL):

Worked extensively on extraction from R/3 system – SD, FI-CO, MM, PM, VMS, DP, SNP, TRP, HR

Worked on extraction from CRM system – CRM Sales, opportunities, Activities, Service management, Hierarchy and Marketing Attributes.

Extensively worked on extraction from SAP IDM – GRC system.

Worked on extraction from Integrated SQL 2005 with BI 7.0 through DB Connect and various Non-SAP systems.

Extensively worked on Flat File extraction.

Expertise in LO Cockpit and Data Sources like Business Content Data Sources, Generic Data Sources, Data Mart Data Sources.

Responsible for Data Source Enhancement through User Exit (ABAP/4).

BW Modeling:

Expertise in BW connection with Source System like R/3, CRM, SAP GRC, Flat File, DB Connect, UD Connect and BW (Data Mart)

Worked on InfoCubes, Info Object, ODS Object, MultiProvider, Infoset, Info Source, Update Rule, Transfer Rule, Transformation, Data Transfer Process, Hierarchy, Business Content Activation, Process Chain, Open Hub Destination, Remodeling etc.

Worked on APD’s to transfer data from BI 7.0 system to CRM 5.0 system.

Responsible for Performance Tuning.

Expertise in Integrated Planning (IP).

BW Reporting(OLAP):

Expertise in Query Designer and RRI (Jump Targets) to BI system and from SAP BI to SAP ECC / SAP CRM system.

Worked on Business Explorer Analyzer, Reporting Agent, Background Printing, Download Scheduler, Workbooks, etc.

Worked extensively on Web Reporting (Web Application Designer), Dashboard development & Information Broadcasting.

Worked on Exception broadcasting using ALM framework.

Business Objects:

Expertise in WEBi, Dashboard, SAP Lumira & Universe development with BO XI4.1, 4.2, BO 4.0 & XI 3.1, Analysis Office for MS Excel 2.0, 2,1, 2.2.

BPC:

Worked on BPC 7.0, BPC 7.5 & BPC 10.

Qlikview:

Expertise in development of dashboard using Qlikview 11.

Designed & developed Qlikview dashboard for SCM & Distribution Analytics.

Developed interactive Map on Dashboard to track information.

Data Services:

Working knowledge of Data services interfaces & integrating it to SAP BI.

HANA:

Migrated SAP BW 7.X system to HANA.

Expertise SAP HANA Modeling.

Expertise in extracting data using ODP connection.

Expertise in optimizing / migrating BW objects to HANA optimized objects.

Expertise in integrating SAP HANA to Business Objects & publishing reports via MS Analysis for office.

Data Provisioning (Flat Files, Confidential, SLT for SAP & Non-SAP), SDI/SDA.

S4/HANA Reporting using CDS:

Expertise in creating VDM models using CDS views.

Worked on creating table functions & AMDP to consume in CDS views.

Expertise in enabling CDS view to consume in Reporting tools.

Analytics:

Working knowledge on SAP Predictive Analytics and various algorithms.

Expertise in integrating SAP Lumira to SAP HANA and creating a story.

Technical Skills:

BW/4HANA : SAP BW/4HANA 2

Cloud Platform : SAP Analytics Cloud, MS Azure

SAP BW : SAP BI 7.5, 7.3, 7.1, SAP BI 7.0, SAP BW 3.5, 3.0B

Business Objects : BO 4.1, BO 4.0, SAP Lumira, Dashboard, Universe, Web Intelligence, BO XI 3.1, AO 2.1

BPC : SAP-BPC 7.0, SAP NW BPC 7.5, SAP BPC 10

Qlikview : Qlikview 11

HANA : BW on HANA & BW4HANA, Native HANA

Data Services : DS 4.0 version 4.0

ERP : SAP R/3 6.0, 4.7, 4.6C

SAP Modules : SD, MM, FI, CO, CRM, CAM, VMS, IDM, GRC, PM

MDM Solution : SAS, Cegedim Dentrite (Nucleus Pharma)

Languages : ABAP/4, C, C++, COBOL

Operating Systems : Windows XP/2000/95/NT, AIX

Databases : Oracle 10g / 9i, MS-ACCESS 7.0, SQL Server 7.0/2005, DB6

Affiliations/Certifications:

Certified SAP NetWeaver 2004’s (BI 7.0) Solution Consultant, SAP America, Philadelphia, PA.

Certified SAP HANA 1.0 Application Associate.

Higher Education:

Mumbai University – Bachelor of Engineering (Computer Science)

Published:

Published an article - Updating marketing attributes from Business Intelligence (BI 7.0) to SAP CRM 5.0 using Analysis Process designer on CRM Expert.

Published an article - Learn how to deliver actionable alerts from SAP BI to your SAP CRM using ALM framework on CRM Expert.

Professional Experience:

Medical Technology Company Nov 2022 – Till Date

Project 1: Dehaze, Franklin Lakes, NJ

Project Details:

Client : BD

Duration : Nov 2022 – Till Date

Title : SAP Analytics Consultant – SAP BW/4HANA & POWER BI

Environment : SAP BW/4HANA, HANA, POWER BI, Non-SAP systems

Responsible for designing the SAP BI, BW/4HANA, HANA & POWER BI application for SCM area.

Created URS, FRS & Technical documents based on requirements.

Analyzed & consolidated various data points from non-sap systems related to shipping information and presented in a POWER BI dashboard to Users.

Developed data models for Shipping, Invoice, Product & Product allocation tables in HANA.

Worked on complex AMDP & ABAP routines to transform data as per business requirement.

Worked on complex calculation views, calculation view with star joins.

Created filters, input parameters & calculated columns.

Created Power BI Data Flows using HANA views as a source.

Created Power BI reports using Power BI Data flows.

Worked on CHARM for creating RFC & CD to move objects.

Worked on HP-ALM.

Worked on providing training & knowledge transfer.

Knowledge in configuration of live data and import data connections and data acquisition.

Collaborate cross functionally with multiple Business and Business Technology teams to develop solution designs and identify process improvement opportunities.

Ability to handle multiple tasks and priorities based on Agile & Waterfall methodologies.

AgriBusiness Company Mar 2020 – Oct 2022

Project 1: Apollo, St. Louis, MO

Project Details:

Client : Bayer

Duration : Mar 2020 – Oct 2022

Title : BI Analytics Consultant

Environment : SAP Analytics Cloud, MS Azure, S4/HANA, Native HANA, SAP BW on HANA 7.5, ECC 6.0, BEx, BOBJ 4.2, SAP Lumira, Analysis for Office, Teradata, BODS, Non-SAP systems

Responsible for designing the SAP BI, BO & HANA application for SCM & Finance area.

Implemented standard operating procedures (SOP’s) for BI applications.

Analyze, consolidate and present monthly financial information in form of BW & BO reports to Users.

Developed data models for the Finance, Sales & Distribution & Purchasing tables in HANA.

Worked on complex ABAP routines to transform data as per business requirement.

Worked on Data Provisioning using SDI, SDA, and BODS Data Services.

Experienced on S/4HANA ABAP CDS view creation, CDS table function & AMDP.

Extensively worked on S/4 HANA CDS views.

Customized the existing CDS views by adding new fields/joining multiple CDS views.

Consume CDS data model used for S/4HANA as source for frontend reporting into SAP BO, Power BI & Bex query.

Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool.

Used WEBi & AO to connect with the SAP HANA Database & Bex reports in designing new Reports.

Experienced on migration from BW 7.x oracle DB to HANA DB.

Supporting current BI applications by making sure all incidents & work orders are resolved within given SLA’s.

Responsible for designing and implementing cloud-based solutions including private & public cloud deployment models for SAP & Non-SAP applications.

Creating, validating & reviewing solutions and effort estimate for data center migration to Azure Cloud environment conducting POC for Digital Transformation Project.

Knowledge in configuration of live data and import data connections and data acquisition.

Collaborate cross functionally with multiple Business and Business Technology teams to develop solution designs and identify process improvement opportunities.

Ability to handle multiple tasks and priorities based on Agile & Waterfall methodologies.

Utilities Company Sep 2018 – Feb 2020

Project 1: Operational Reporting, Minnesota, MN

Project Details:

Client : Xcel Energy

Duration : Sep 2018 – Feb 2020

Title : SAP BW HANA Lead

Environment : SAP BW on HANA 7.5, BW/4HANA, ECC 6.0, BEx, BOBJ 4.2, SAP Lumira, Peoplesoft, Teradata

Responsible for overall project delivery for SAP BI, HANA & BW/4HANA Projects. Review, analyze project plans, project status, and communicate to SAP project teams and senior management.

Responsible for designing the SAP BI, BO & HANA application for SCM & Finance area.

Implemented WO2PAY KPI Dashboard in SAP Lumira environment which enables compliance to Normal Goods & Service Policy and a solution to create visibility to users working outside policy. It Optimizes Inventory and Purchase Order management process with accurate reservations to reduce waste and On-time material delivery.

Creating project plan, system architecture & performed preliminary check for migration to BW/4HANA.

Expertise working on Agile project methodologies.

Design and Build Complex & scalable HANA data models.

Build Currency conversions in HANA models.

Fine tuned HANA Models to improve reporting performance.

Performed Remote migration from SAP BW 7.3 to BW/4HANA.

Provided system architecture for Data Tiering Optimization.

Worked on the SLT & SDI for real-time replication of the business data from SAP to BW/4HANA system.

Extracted data using CDS views.

Used WEBI to connect with the SAP HANA Database, in designing new Reports for bringing summarized view of large volumes of data.

Collaborate cross functionally with Business and Business Technology teams to develop solution designs and identify process improvement opportunities.

Developed and maintained standards regarding methodologies, definitions, processes, and quality.

Ability to handle multiple tasks and priorities. Ensure deadlines are met on time and with 100% accuracy.

Semiconductor Company Apr 2018 – Aug 2018

Project 1: STAR 1, Houston, TX

Project Details:

Client : Lumileds

Duration : Apr 2018 – Aug 2018

Title : SAP BW HANA Lead

Environment : SAP BW on HANA 7.5, ECC 6.0, BEx, BOBJ 4.2, MS Analysis for Excel

Project Contribution:

Worked extensively on Finance, Controlling, Special Ledger & Logistics module with functional users as well as business users to gather requirements and implementing them to report data accurately.

Designed and implemented SAP HANA data modeling using Attribute Views, Analytical Views, and Calculation Views.

Developed data models for the Finance, Sales & Distribution & Purchasing tables in HANA.

Design SAP HANA data model information Views for report consumption with time dimensions.

Created Technical specifications and standard modeling documents for HANA.

Created HANA database users, role, analytical privileges for data and data model security.

Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.2 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.

Migrated HANA content from development, testing environment to Production environment using delivery units.

Involved in developing test scripts and assisted in UAT using Test ID's for super users, and end users.

Track and resolve complex issues as a part of production support.

Ability to handle multiple tasks and priorities.

Conducted Knowledge transfer sessions with users.

Manage a team of 2 onsite & 4 offshore resources and their day to day activities.

Chemical Company Sep 2016 – Mar 2018

Project 1: SCM Analytics, Houston, TX

Project Details:

Client : Orion Engineered Carbons

Duration : Sep 2016 – Mar 2018

Title : SAP BW Lead

Environment : SAP BI 7.5, SAP ECC 6.0, BO 4.2, HANA

Project Contribution:

Implemented Integrated Planning (IP) application for Demand managers & Sales Rep with Analysis Office for Excel as Frontend tool.

Implemented Reports using SAP Lumira connecting to SAP BW Queries.

Created Forecasting Visualization to compare Sales Forecast & Final Demand for management reporting.

Developed different calculated KPI’s in SAP Lumira and presented to Business.

Responsible for leading SAP BW team for testing & validating upgrade from SAP BW 7.3 to HANA database.

Migrated BW Objects to HANA Optimized objects.

Created Data flow using LSA++ architecture.

Extracted data from SAP using ODP connections.

Creating composite providers and queries using BWMT in HANA Studio.

Fine-tuned BW/HANA with ABAP and recommended corrective action.

Perform ad hoc requests and projects in SAP BW integrating to SAP ECC 6.0 as assigned by users.

Involved in gathering user requirements and data modeling for SCM Reporting requirements.

Interacting with Functional Consultants and Business Experts for designing data models.

Track and resolve complex issues as a part of production support.

Developed and maintained standards regarding methodologies, definitions, processes, and quality.

Ability to handle multiple tasks and priorities.

Conducted Knowledge transfer sessions with users on How-to-Use SAP Lumira.

Manage a team of 2 onsite & 2 offshore resources and their day to day activities.

Chemical Company May 2014 – Aug 2016

Project 1: Finance & SCM Analytics, Houston, TX

Project Details:

Client : Orion Engineered Carbons

Duration : July 2015 – June 2016

Title : Senior BI Principal Analyst

Environment : SAP BI 7.3, SAP ECC 6.0, BO 4.1

Project Contribution:

Responsible for leading the effort of designing the SAP BI & BO application for Finance & SCM area.

Implementing Operational KPI & OTIF Dashboard in SAP BOBJ 4.1 environment which covers overall Cash flow of Orion and a solution to monitor the month end closing vs forecast to give management updates on actual Keyline’s and their expected development.

Analyze, consolidate and present monthly financial information in form of BW & BO reports to Users.

Collaborate cross functionally with Business and Business Technology teams to develop solution designs and identify process improvement opportunities.

Perform ad hoc requests and projects as assigned by users.

Track and resolve complex issues as a part of production support.

Ability to handle multiple tasks and priorities. Ensure deadlines are met on time and with 100% accuracy.

Manage change request, new requirements & support issues using remedy tool.

Forest Laboratories Aug 2013 – April 2014

Project 1: SCM, Distribution & Financial Analytic, Jersey City, NJ

Project Details:

Client : Forest Laboratories, Inc.

Duration : Aug 2013 – April 2014

Title : Senior BI System Analyst

Environment : SAP BI 7.1, SAP ECC 6.0, BO XI 3.1, SAP BPC 10, SQL, SAP DP/SNP, SAP HR, Qlikview 11

Project Contribution:

Forest Laboratories is implementing SCM, Distribution analytics & Finance application to track the logistics spend, Logistics performance and customer service performance across the organization on a daily basis using SAP BI, SAP BO & Qlikview.

Managing project expectation including project time line & status, resource planning etc.

Managed a team of 2 resources including a contractor.

Responsible for leading the effort of designing the application & bringing the data from Non-SAP European inventory system and SAP MM & SD application.

Gather the requirements for blue print, build, the consolidation, Planning, Budgeting and Forecasting functionalities.

Prepare process Definition Document (PDD), Report definition Document (RDD) for the finalized consolidation, planning, budgeting and forecast processes.

Prepare the documentation on the input template and data extraction of consolidation and planning requirements.

Configure the currency translation logic, maintain rate application, rate dimension, business rules, Account Dimension, Rounding functions for the report.

Configure data manager extraction from ECC and BI system for the actual, plan data.

BPC process chain development to the financial data to staging DSO and to the cube.

Process chain development to support master data loads from BW to BPC.

Reconciling the data of BPC consolidation, planning extracts with BI, ECC application.

Develop the planning and consolidation reports using the BPC reporting services and EVDRE.

Designed SAP BI data model to in-house both SAP & Non-SAP inventory & Sales data.

Extracted Data from SAP & flat file for generating Qvd files.

Developed SCM BOBJ reports to track inventories.

Created Data model in Qlikview to track the UPS shipments.

Designed & developed interactive Qlikview Dashboard for Distribution Analytics.

Resolved complex BOBJ & Qlikview issues for inventory & FI areas.

Performed testing of Qlikview & SAP BO reports & dashboards on iPad.

Responsible for Level 3 production support on a daily basis.

Capgemini US LLC Nov-2006 – July 2013

Capgemini is a global leader in consulting, technology, outsourcing and local professional services. Headquartered in Paris, Capgemini’s regional operations include North America, Northern Europe & Asia Pacific and Central & Southern Europe.

Project 1: IT Modernization Project, Greensboro, NC

Project Details:

Client : Lorillard

Duration : Nov 2012 – July 2013

Title : SAP BI – BOBJ Manager / Lead

Environment : SAP BI 7.3, SAP ECC 6.0, BO 4.0, BPC 10

Project Contribution:

Lorillard is implementing SAP BI & BO solution for SAP Supply Chain (Demand Planning, SNP & Sales Deliveries sub-areas) & HR project.

Responsible for initiating the project, presenting SAP BI / BO capabilities and project management activities.

Responsible for leading a team size of 3 resources.

Responsible for designing Sales Deliveries, Demand planning application for reporting in SAP BI & BO environment.

Performed gap analysis of HR reports & presented HR standard reports in SAP BW.

Worked on SAP BPC 10 NW Planning/Budgeting/Forecasting implementation from Blueprint to implementation and going live.

Developed Business Process Flows to guide end-users through pre-defined sequential tasks that span across the different departments within the organization.

Integrated SAP BI & SAP BO systems and developed complex WEBi reports & Graphs including forecast information.

Involved in data extraction and conversion between BPC and non-ERP systems with extractors and ETL tools.

Developed custom Process chains to support master data and transaction data loads from BI to BPC.

Created Package links to bundle more than one packages and to run sequentially.

Used Modeling functions such as Spread, Trend and weight to distribute the allocation to base members.

Worked on setting up Security and Audit settings to ensure user entitlements and access rights.

Worked exclusively on Work Status and integrating the Work States with Business Process Flows.

Configured drill-through functionality in Reports to see the underlying data from external databases.

Used Content Library to publish Documents. Developed BPC Live Reports using drag and drop option and included interactive chart. Developed BPF, Audit and Work Status Reports.

Resolved complex issues involving integration between SAP BI & SAP BO and provide timely delivery of reports.

Responsible for preparing cut-over plan.

Creating & uploading test results in HPQC (HP quality Center).

Provided training to users in SAP BO 4.0 WEBi tool.

Project 2: Product Supply system, Atlanta, GA

Project Details:

Client : Coca – Cola Refreshment

Duration : June 2012 – Oct 2012

Title : BI Architect / Delivery Manager

Environment : SAP BI 7.3, SAP BI 7.1, SAP ECC 6.0, BO 4.0, SAP BPC 7.5, DS 4.0, Teradata.

Project Contribution:

Coca-Cola Refreshment is implementing SAP BI & BO solution for PSS (Product supply system) project that includes Compliance Analytics, TRP (Tactical Route Planning) & Demand planning sub-areas.

Responsible for Managing a team of 7 team members.

BI Architect for TRP, SPEND & DP.

Responsible for designing TRP (improve planning the routes for deliveries) & SPEND ($ spend across vendors) solution for CCR in SAP BI & BO environment.

Responsible for integrating Data Services system to SAP BI for transferring data to & from Data Services & Teradata.

Worked on SAP BPC 7.5 NW Planning and consolidation implementation.

Developed Data Model for BPC Account Based model from BI KPI's.

Configured Application Set and Application parameters for Journals and work status settings.

Involved in data extraction and conversion between BPC and BW systems.

Integrated SAP BPC Data Manager Packages with SAP BI process chains.

Worked on month end closing consolidation Reports.

Performed reporting and data collection using Distributor & Collector functionality.

Extract data from SAP and non - SAP systems into BPC/BI/BW with ETL tools.

Responsible for preparing cut-over plan.

Creating & uploading test results in HPQC (HP quality Center).

Project 3: Product Supply system, Atlanta, GA

Project Details:

Client : Coca – Cola Refreshment

Duration : July 2011 – May 2012

Title : BI Architect / Delivery Manager

Environment : SAP BI 7.1, SAP ECC 6.0, BO 4.0, OTM, SQL, SAP DP/SNP

Project Contribution:

Coca-Cola Refreshment is implementing SAP BI & BO solution for PSS (Product supply system) project that includes Fleet management, Oracle transportation management & Demand planning / Supply network planning sub-areas.

Managed a team of 10 team members.

BI Architect for Fleet management, OTM & SNP/DP.

Managing client expectation including project time line & status, resource planning etc.

Responsible for designing the PSS solution for CCR in SAP BI & BO environment.

Responsible for managing the team with day to day activities including project status, resolve any technical issues, providing solutions.

Developed WEBi reports in BO 4.0 environment.

Direct responsible for on time & high quality delivery of Reports & Dashboards.

Developed cutover plan for PSS project and presented to CCR.

Responsible for Post-Cutover data load activities.

Involved in Knowledge Transfer session to the user and to the production support team.

Project 4: Coke one, Atlanta, GA

Project Details:

Client : Coca - Cola

Duration : Jan 2011 – June 2011

Title : Sr. SAP BI Consultant (Technical Design Specialist)

Environment : SAP BI 7.1, SAP ECC 6.0, SAP IDM GRC, SAP CRM 6.0, Non-SAP system.

Project Contribution:

Coca-Cola German Bottlers are implementing new local partner function to link ship-to parties together in ECC. This will represent the grouping of ship-to locations that are the same business entity. Based on this, Sales orders in ECC will now needed to be processed out of Ship-to party instead of Sold-to party. This requires changes to BI data models including extractors. These changes are grouped under sub project call Collective Billing.

Managing a team of 3 SAP BW contractors onsite.

Identifying and understanding the technical data flow for the changes that need to be performed for OTC / RTR stream related to Collective billing project.

Constant interaction for the status of the task and performing system check for the objects developed.

Enhanced ECC extractors for adding partner function.

Implemented Remodeling rules to perform copy of historical data to new field (ship-to) in BI system.

Implemented reports into SAP BI for SAP IDM (Identity management system) – GRC (Governance, Risk & Compliance) system.

Resolved complex connectivity issues with SAP IDM system on visual admin.

Developed process chain to automate the data load for SAP IDM reporting requirements to run every 6 hrs.

Implementing SAP BI reports for CAM (Customer Asset Management) by analyzing Coca-Cola current needs for Singapore / Malaysia bottlers.

Involved in Identifying and understanding business process for CAM.

Perform BI - CAM design development for CCSM (Singapore/Malaysia) bottlers.

Worked on Material classification for implementing new class in BI.

Involved in Knowledge Transfer session to the user and to the production support team.

Project 5: BI Scale Project, Atlanta, GA

Project Details:

Client : Coca - Cola

Duration : March 2010 – Dec 2010

Title : Sr. SAP BI Consultant (Technical Design Specialist)

Environment : SAP BI 7.1, SAP ECC 6.0, SAP CRM 6.0, Non-SAP system.

Project Contribution:

Implementing SAP BI reports by analyzing Coca-Cola current needs for German Bottlers.

Involved in Identifying and understanding business process for Sales Order / Billing / Pallet tracking / Complaints (CRM), Product master, HR master data of ECC & CRM systems.

Design technical data flow and develop technical specification for reports pertaining to SD, CO-PA and CRM application.

Develop Data models & enhanced ECC/CRM extractors.

Resolved technical issues pertaining to performance of CRM data sources and complex data issues in CRM system regarding BDOC by defining / registering Queues & manually processing BDOCs.

Worked on complex Unit conversion routines for different materials.

Develop Bex & WEB reports involving variable customer exits.

Mitigate all the developed objects from DEV to QAS and perform system check.

Actively participated during Cut-Over phase for PROD environment and assisted team members for timely completion of the data load into BI system by minimizing the ECC system downtime.

I was able to resolve complex data issues in BI -CRM - ECC system (system messages) and also any high priority tickets that were opened after the cutover activities as a part of warranty support.

Perform Knowledge transfer session with AMS (support) Team to get familiar with the objects and architecture that was built as a part of BI implementations.

Project 6: BI Upgrade Project / Purchasing Remediation, Houston, TX

Project Details:

Client : National OilWell Varco (NOV)

Duration : Jan 2010 – Feb 2010

Title : Sr. SAP BI Consultant (Technical Design Specialist)

Environment : SAP BI 7.1, SAP ECC 6.0.

National Oilwell Varco is a worldwide leader in providing major mechanical components for land and offshore drilling rigs, complete land drilling and well servicing rigs, tubular inspection and internal tubular coatings, drill string equipment, extensive lifting and handling equipment, and a broad offering of downhole drilling motors, bits and tools. Since 1841, National Oilwell Varco (NOV) has been dedicated to ensuring customers receive the highest quality oilfield products and services.

Project Contribution:

Managing a team of 2 people on BI - purchasing application.

Designed purchasing application in BI based on enterprise data warehouse concept.

Solved / converted FULL Loads in PROD environment to DELTAS using ABAP which helped client to bring down the data load time.

Designed process chains for SD, FI, MM, Purchasing application based on EDW concept that helped to monitor the process chain easily.

Developed Trigger programs, decision tree for process chains to execute dependent data loads.

Executed pre-upgrade & post-upgrade task.

Project 7: Master Data Management, Chicago, IL

Project Details:

Client : Astellas Pharma US.

Duration : Aug 2009 – Nov 2009

Title : Sr. SAP BI Consultant (Technical Design Specialist)

Environment : SAP BI 7.0, Siebel, SAS MDM, SAP ECC 6.0, Cognos, Cegedim Dentrite, Wolters Kluwer, Various third party systems.

Astellas Pharma US, Inc is the U.S. affiliate of Astellas Pharma Inc., Japan’s second largest pharmaceutical company and ranked within the top 20 in the global market.

Project Contribution:

Astellas Pharma is currently implementing MDM suite to manage customer master information at one place from various sources to achieve improved data accuracy, regulatory compliance, personalization and customer service, scalability, flexibility, data traceability, customer insight, with consistent addresses and Spend Compliance Monitoring.

Identifying and understanding different sources of data for customer master and corresponding dependencies by carrying out several workshops with client team.

Developing data flow diagrams involving dependencies of source system and helping client to interface different customer master sources to Cegedim Dentrite (Nucleus Pharma) MDM (SAS) suite.

Defining correct mapping rules between

Contact this candidate