We provide IT Staff Augmentation Services!

Lead Sapbi/hana Consultant Resume

3.00/5 (Submit Your Rating)

SUMMARY:

A Data Science Enthusiast, an Analytics maven having over 16 years of extensive experience in the Data Analytics and Business Intelligence space. Skilled collaborator acted as business intelligence & analytics Liaison with top executives across different businesses to deploy business intelligence and analytical insights to the customers in Insurance, Consumer Goods, High Tech & Telecommunications, Retail, Chemicals, Energy & Resources, Government - Public Sector and Manufacturing industries.

SPECIFIC EXPERTISE IN:

  • Big Data Analytics
  • Enterprise Analytics
  • Data Mining & Machine Learning
  • Financial Analysis
  • Descriptive, Predictive, Prescriptive Analytics & Optimization
  • Supply Chain Analytics
  • R & Python
  • SAP Analytics - SAP HANA, SAP BW, B4H,SAC
  • Hadoop Ecosystem - Pig,Hive,Spark
  • BI Analytics - Tableau, Qlik, MicroStrategy

TECHNICAL SKILLS:

BIG DATA: Hadoop Ecosystem

Statistical Software: R

Programming: Python, SQL

IMCE: SAP HANA

ERP: SAP ECC (6.0, 4.7, 4.6C)

EPM: MS BPC 7.5, SAP BPC 10.0 NW, SAP BPC 10.1 on HANA & EPM Unwired 3.2

SAP BW: SAP BW 3.0, 3.5, 7.0, 7.02, 7.31, 7.4 on HANA

BI Analytics: SAP HANA, Tableau, Qlikview and MS Confidential

ETL: SAP BODS 3.x, 4.0, Ascential Data Stage 6.1

SQL ANALYTICS: SSIS, SSRS, SSAS & SSMS

SAP BI/BO Tools: Business Objects 5.1, 6.5, Business Objects XI 3.1, BOBJ 4.0, 4.1.

Databases: SAP HANA, MS SQL Server, Oracle8i/9i/10g, MS Access.

PROFESSIONAL EXPERIENCE:

Confidential

Lead SAPBI/HANA Consultant

Responsibilities:

  • Intake of reporting requirement from Corporate Finance group - CFO, Controller, VP and Finance Directors.
  • Responsible for the EPM - BPC and BW system integration, managing and administering the data needed for the BPC models.
  • Took ownership and completed Finance VP’s request on the Capital Expenditure project extracting Internal orders data into BW and provided reporting solutions.
  • Worked with AR - Directors on the spend analytics reporting
  • Worked on the rebate agreement project, designed the data flow to extract the sales rebate data into BW from ECC.
  • Worked closely with Finance team in developing dashboards using SAP Lumira.
  • BW/4HANA modeling experience and good knowledge of HANA, BW integrated scenarios
  • Data Provisioning in HANA from SAP and non-SAP sources
  • Demonstrated background working with HANA Modeling Artifacts
  • Responsible for designing BI data models pertinent to FI-CO and FMCO.
  • Responsible for the production and maintenance of the Finance Data models/structures.

Confidential

Data Science - Architect

Responsibilities:

  • Intake projects from multiple business sectors for predictive, descriptive analytics roll out.
  • Worked in the Text analytics research POC for Marketing Division using R and Python.
  • Developed Confidential visualization dashboards for the top CXO levels in multiple business areas.
  • Implemented quantitative analysis, Marketing analysis, consumer survey analysis and customer analytics
  • Familiar with Big Data tools & technologies - HDFS,Pig,NoSQL,Hive and SparkR
  • Utilized AWS to set up databases to pull data from diverse data sources and did predictive analytics using Hadoop platform (Hive & Pig)
  • On hand experience in working with MS Azure cloud platform, setting up the databases for different business group ( Sales, Finance, Marketing) gathering data across diverse source and storing in the data lake to facilitate Analytics(Predictive & Prescriptive) using Confidential Analytics.
  • Extensive experience in handling on premise, cloud platform and combination of the both databases/data warehouse to do analytics using tools like Confidential, Tableau.
  • Building, maintaining the data warehouses for the entire GBS division in the cloud and on premise database.
  • Served as Power Analytics Project Manager and Solution Architect responsible for project intake, project management in delivering Confidential analytics across the division.
  • Good Understanding and knowledge in ADLS and ADF
  • Exposure in loading data into Azure Data Lake
  • Good understanding of Azure Foundation.
  • Proficient in Microsoft Azure Suite, including Azure ML and PowerBI Analytics.
  • Extensive knowledge in classification, clustering, regression algorithms in classifying data and utilized R and Python for plotting the graphs.
  • Current industry knowledge of forward-looking data technology (Big Data, Hadoop, Cloud platforms, in memory databases, streaming data 7 analytics)

Confidential

Divisional Project Manager

Responsibilities:

  • Lead the strategy, direction, and management of BI platform design.
  • Lead technical architecture design, development, and implementation.
  • Oversee the development of the semantic data layer.
  • Approve dashboards that are to be certified and published for the business stakeholders.
  • Own the Confidential operations
  • Manage and update the divisional knowledge-base portal
  • Facilitate governance meetings within division
  • Track and manage development projects including back-end database development, data standardization, and dashboard certification.

Confidential, Chicago

SAP BI Analytics & EPM - Manager /Architect

Responsibilities:

  • As a BI Manager/Architect, manage the intake, prioritization, and execution of BI projects in the Enterprise Analytics space with HANA, BPC, Business Objects, BW, SQL, CRM - Sales force & Wave Analytics cloud as the key technologies.
  • Collaborate directly with IT Vice-president, Directors and Business leadership teams promoting BI solutions, BI tool sets within SAP BW / BOBJ/ HANA technologies to improve and have the best analytical reporting structure within the enterprise.
  • Conducted frequent meetings with IT Vice President, Sr.IT - Director, in promoting their business analytics to the next level by showcasing strengths of advanced analytics BI tool sets like Tableau and Qlik View.
  • Close interaction with Supply Chain Directors, BI Managers, Process owners in requirements gathering, blue printing, designing BI architecture and reporting solutions across Supply chain and Sales business functions.
  • Lead offshore teams working in BI/BW/BOBJ and BPC applications, providing technical solution guidance, ensure best methodologies followed, responsible for the offshore resources performance reviews, feedback and process improvements.
  • Manage the execution of project throughout analysis, design, build, test and release phases; balance scope, schedule, quality, and risks and report overall performance.
  • Acted as the SME, Architect and primary point of contact for the BI shop including SAP BW, BOBJ, and BPC applications.
  • HANA Modeling - Designing Agile data marts by utilizing BW on HANA mixed scenarios (ECC, CRM, SQL)
  • Established roadmap alignment to SAP by prescribing a path towards HANA enablement using Advanced DSO (ADSO) and Composites
  • Redesigning of LSA to LSA++ Architecture. Remodeling solutions using HANA specific components like AMDP, Open ODS views and ADSO.
  • Establish SAP BW on HANA as a central data warehouse to support analytic initiatives across the enterprise and establish a single source of truth.
  • Exposed SAP BW models as HANA views and developed mixed models to develop BOBJ reports and Dashboards using IDT.
  • Responsible to rollout SAP Lumira for a group of top 50 business users including top executive’s VP, CEO, Directors and Managers.

Confidential, Deerfield, Illinois

Architect - SAP BI Analytics

Responsibilities:

  • As a SME and Sr. BI Architect in defining scope of project, identifying business requirements, blue printing and all aspects of project implementation including BI architecture, planning, implementation, upgrade and migration.
  • Architected the solution to extract Budget & Forecast data from BW. Facilitated COGS analytical reporting for the Corporate Finance group - CFO, Controller, FPA Director and Manager.
  • Intensive collaboration with process owners, business stake holders in identifying gaps within the data infrastructure. Implemented standard and best practices in integrating SAP BW and BPC.
  • Designed reconciliation audit reports and systematic validation of data warehouses, to identify compliance and data integrity issues and ensure corrective action taken, when needed.
  • Worked closely with the Financial Business Analysts, Managers and internal consultants in identifying and recommending best approaches to improve BI decision making system.

Architect - SAP BI Analytics

Confidential

Responsibilities:

  • Responsible for FI/CO, Consolidation, Asset Accounting business modules architecture in BW when upgrading to new version 7.31 to ensure the system is consistent with existing reports and BW Metadata and repository.
  • Performed system checks prior/post upgrade and validated objects/reports pertinent to FI modules in the BW landscape.
  • Executed both general and upgrade checklist obtained from the ASU tool Box in the BW system prior to implementation.
  • Coordinated the upgrade and project plan with Basis and DBA team to perform related upgrade tasks.
  • Involved in cut over activities during the project go live.

SAP BI - FICO Architect

Confidential

Responsibilities:

  • BI Analytics Architect & development team lead for enhancement projects, performance improvements, production & support, new implementations, configuration in the BI analytical reporting space for the SAP Modules - Finance/Controlling.
  • Provided technical expertise in identification, design, configuration, testing, and debugging of FI/CO, Inventory and Order to Cash (Sales) SAP applications.
  • Act as an SME in the financial analytics space and responsible for all the relevant analytical reporting built using BOBJ tools.
  • Evaluated current BW architecture and proposed various improvement solutions/techniques per SAP standard.
  • Architected and developed Audit control reports with complex architecture for all Finance modules to reconcile the data between ECC and SAP BW, with alert Management via email using Crystal reports.
  • Responsible for the BW BPC integration, data loads and worked in EPM reports.

We'd love your feedback!