Lead Sapbi/hana Consultant Resume
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.
