SUMMARY

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

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

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

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

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.