We provide IT Staff Augmentation Services!

Sap Bw Hana Lead Resume

Minnesota, MN

SUMMARY:

  • Confidential is Certified SAP BI & SAP HANA Consultant having 14+ years of IT industry and nearly 14+ years of SAP experience in 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 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 and Project Manager & managed complex multi - phase deployments of application development for Fortune 500 clients.
  • Expertise driving projects and leading cross-functional teams to meet key program deliverables. Adept at maintaining focus on achieving bottom-line results while formulating and implementing advanced technology and business solutions to meet a diversity of needs.
  • A strategic thinker noted for outstanding leadership, excellent mentoring, analytical problem solving and team building skills that used to handle client in difficult circumstances & multi-culture team environment. Good grasp of dispute resolution, negotiation techniques, and other positive interpersonal skills.
  • 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).
  • Expertise with various data provisioning tools - SLT, SDI, SDA and ODP enabled extractors for extraction.
  • Expertise in BW connection with Source System like R/3, CRM, SAP GRC, Flat File, DB Connect, UD Connect and BW (Data Mart), SLT & SDA.
  • 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).
  • 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.
  • 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.
  • Worked on BPC 7.0, BPC 7.5 & BPC 10.
  • Expertise in development of dashboard using Qlikview 11.
  • Designed & developed Qlikview dashboard for SCM & Distribution Analytics.
  • Developed interactive Map on Dashboard to track information.
  • Working knowledge of Data services interfaces & integrating it to SAP BI.
  • 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.
  • Migration from BW 7.3 to BW on HANA & BW/4HANA
  • Working knowledge on SAP Predictive Analytics and various algorithms.
  • Expertise in integrating SAP Lumira to SAP HANA and creating a story.
  • Expertise in Power BI interactive reporting & dashboard development.

TECHNICAL SKILLS:

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

PROFESSIONAL EXPERIENCE:

Confidential, Minnesota, MN

SAP BW HANA Lead

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

Responsibilities:

  • 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.
  • Manage a team of offshore resources and their day to day activities.

Confidential, Houston, TX

SAP BW HANA Finance Lead

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

Responsibilities:

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

Confidential, Houston, TX

SAP BW Lead

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

Responsibilities:

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

Confidential, Jersey City, NJ

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

Responsibilities:

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

Confidential, Greensboro, NC

SAP BI - BOBJ Manager / Lead

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

Responsibilities:

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

Confidential, Atlanta, GA

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.

Responsibilities:

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

Confidential, Atlanta, GA

BI Architect / Delivery Manager

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

Responsibilities:

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

Confidential, Atlanta, GA

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.

Responsibilities:

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

Confidential, Atlanta, GA

Sr. SAP BI Consultant (Technical Design Specialist)

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

Responsibilities:

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

Confidential, Houston, TX

Sr. SAP BI Consultant (Technical Design Specialist)

Environment: SAP BI 7.1, SAP ECC 6.0.

Responsibilities:

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

Confidential

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.

Responsibilities:

  • 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 source systems and providing data interface files to load into MDM system.
  • Facilitate overall data structures for customer master from MDM suite to Astellas data warehouse.
  • Making sure that the spend compliance monitoring reports are correct with highest data accuracy.

BI - CRM Implementation, Cleveland, OH

Sr. SAP BI Consultant (Technical Design Specialist)

Environment: SAP BI 7.1, SAP CRM 2007, Non-SAP system.

Responsibilities:

  • Identifying and understanding business process, functional and technical pain points, provide solutions by developing functional specifications for Activities & Service Confirmation areas of CRM system.
  • Performed the configuration, design, development and implementation of Reporting and Analysis solution based on SAP BI 7.0 suite interfaced with SAP CRM 2007.
  • Managing a team of 1 onsite & 4 offshore SAP BI developers to deliver BI reports & Dashboards from SAP CRM Activities, Service Confirmation & Non-SAP System.
  • Performed EDW Data Modeling, Data Extraction and Retrieval, including development of Process chains and process management.
  • Extracting hierarchy’s data based on Fiscal years and Territories.
  • Developed KPI’s to calculate the compliance between planned & actual data.
  • Development & Implementation of BI high quality reports using Bex web, WAD, Dashboards and Information Broadcasting.
  • Performed Customization to provide dynamic links to drill through from BI reports to CRM portal.
  • Designed functionality to trigger alerts (Alert Management) from BI to CRM system based on rule based exceptions and publishing alerts to CRM portal. Also developed link to drill through CRM transaction & drill down to BI reports from Alerts.
  • Developed a RRI functionality to drill through from BI reports to CRM portal using BSP application & developing iView on portal.
  • Build dashboard based on web template to represent the year to date compliance KPI’s.
  • Development of configuration documents, OSS notes, technical troubleshooting and problem solving.
  • Build Quality environment (QAS). (Transport)
  • Perform cut-over activities in PROD system. (Manual configuration before transports)
  • Help users during Integration testing and performed knowledge transfer sessions.

Confidential, Morristown, NJ

Sr. SAP BI Consultant

Environment: SAP BI 7.0, SAP BW 3.5, SAP ECC 6.0Honeywell International is a diversified technology and manufacturing leader, serving customers worldwide with aerospace products and services; control technologies for buildings, homes and industry; automotive products; turbochargers; and specialty materials.

Responsibilities:

  • Analysis of existing BW 3.5 system which includes all Process chains scheduling & dependencies, Info Providers, Aggregates if any, Data sources that provides Delta Update etc.
  • Involved in Pre-Upgrade activities.
  • Carry out series of meetings with Key players to discuss work plan and coordinate overlapping issues.
  • Developing test plan and test scripts for testing consistency of BI 7.0 system.
  • Developing of BI objects particularly for data source that provides Delta’s.
  • Performing RSRV checks to make sure that all the Info providers & master data objects are consistent.
  • Migrating and testing queries / workbooks to BI 7.0 environment.
  • Development of front-end GUI roll-out strategy and users training
  • Schedule training for end users to make them understand new BI 7.0 functionality.

Confidential, Chicago, IL

Sr. SAP BW Analyst

Environment: SAP BI 7.0, SAP ECC 6.0, ESSBase

Responsibilities:

  • Extracted data from SAP ECC 6.0 (FI-CO).
  • Created customized Info Cubes based on Client Requirement.
  • Defined solutions to optimize existing process by creating new data flow. It involves developing DSO, DTP’s and transformation (Start & End routines) in BI 7.0 environment.
  • Worked on transporting data from BI application server to third party systems (ESSBase) using programs in BI in conjunction with Open Hub destination.
  • Daily monitoring of process chain to validate the data loads to non-sap systems and updating Customer mapping table in BI 7.0.
  • Manual changes to RATRAN MASTER TMPL. Validating and analyzing various accounts amounts and providing them to Business using an APD interface.
  • Worked on initiating WAS (Web application server) in BI to end users and facilitates error handling emails to process chains (Configuring SMTP connection).
  • Involved in documentation of the process (Integrated Planning document).

Hire Now