SUMMARY

• Total of 7 years of experience in SAP Business Warehouse (BW) and Business Intelligence (BI), including BW on HANA, BW4Hana and Business Objects with 2 full cycle implementations.
• Also proficient in BW security, Alteryx and Tableau. Good functional noledge, strong in both implementation and production support processes, and experienced in managing offshore teams.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Experience in BW4Hana Modelling
• Experience in loading data in Utility industry for the areas of Finance, Sales Stats, Collection Items and Open Items
• Created Calculation Views and created several verticals in the area of Finance and Work Management
• Worked extensively on Open hub, APD tools to download data to the Third - Party Tools from BW
• Experience in using SLT replication using LTRC, LTRS. Reloaded entire master data which uses SLT
• Experience in using Near Line Storage within Sales Stats and Billing area
• Experience in using AMDP scripting in transformation logic
• Supported in decommissioning BW 7.3 and replicated the objects in BW4Hana
• Worked on changing the schema of Calculation Views from BW4Hana to S4Hana
• Experience in UC4 tool for scheduling the process chains in BW4Hana
• Played a key role in migrating BW 7.3 data into Snowflake using Tableau Prep
• Heavily involved in testing Snowflake to understand best possible way to use the cloud resources
• Designated as back-up Tableau administrator and involved in providing user access, monitoring services, folder migration and maintaining groups

TECHNICAL SKILLS

• SAP BW
• SAP BW4HANA
• SAP BW On Hana
• SAP BI
• WebI
• Analysis for OLAP
• Analysis for Excel
• CMC
• SAP ABAP
• SAP Security
• Tableau
• Alteryx
• Snowflake
• BEx/BW Query Designer
• Business Analysis
• Project Management
• Service Now
• BW development experience in the following SAP areas:
• Sales
• Inventory Management (IM/WM)
• Production Planning
• Material Management
• Warranty
• Quality
• Procurement

Confidential

SAP BW

Responsibilities:

• Implemented SAP BW for two AO Smith locations over two release cycles
• Developed end-to-end data models using HANA Studio as well as traditional BW modelling
• Developed data flows consisting of Composite Providers, Advanced Data Store Objects (ADSOs), DSOs (classic), Infocubes, Multiproviders, Transformations, Infoobject master data, Process Chains
• Created HANA views as a source for composite providers or for direct consumption for Tableau dashboard
• Developed and enhanced BW security roles, created authorization objects for row-level security and Infoprovider access, and managed security role provisioning for BW/HANA users
• Conducted complete data loads for different SAP BW process areas and created data load plans for the team
• Performed Set up/initialization and data loading for various BW Datasources including inventory, sales and distribution and production
• Also experienced with non-LBWE Datasources such as finance and master data
• Developed custom extractors using table views and function modules
• Supported migration of the BW system to BW on HANA
• Well-versed in the functionalities and uses of Analysis for OLAP and Excel
• Extensively involved in creating of Transformation and Data Transfer Process (DTP) for the Data Loads
• Created queries using BEx/BW Query Designer, developed WebI reports for ad-hoc analysis and automated distribution
• Designated as back-up CMC administrator and involved in providing user access, creating events, monitoring services, and maintaining groups
• I was the only engineer on dis project, so dis allowed me to work on the complete SDLC of the project. Worked on architecture, design and built Warranty Dataflow using SAP HANA modeling where data is coming from multiple data sources like SAP, SQL, and Flat files
• Built Optimal Hana Data models which include handling of Advanced DSO’s, Composite providers, Analytic Views and Calculation Views by analyzing existing business logics and performance bottlenecks in BW 7.3 system
• Extensively used BEx Query Designer and created queries using BEx User Exit Variables, Restricted Key figures, Calculated Key figures, conditions for YTD, PYTD, Current month, previous Year Current and YoY calculations to be able use on WebI reports
• Created Authorization Objects for security Roles in SAP to access data using excel and Tableau. Testing and Validation of security roles using Rsecadmin and pfcg tcodes
• Extensively used SQL queries and Stored Procedures for troubleshooting and for On-demand reporting purposes
• Scheduled WebI reports to business on-demand basis using SAP Business Objects. Hands on noledge in SAP Business Objects Administration
• Developed Executive Level Dashboards in Tableau in particularly for Warranty
• Productivity and Efficiency Self Service query determines plants efficiency by earned hours and actual labor hours from Kronos
• Collaborated with process teams to gain an in-depth understanding of business requirements and then designed, developed, documented, and tested complex HANA data models that assimilate data from multiple sources system (SAP and Kronos) to develop dis project
• Designed and Implemented dis project using ADSO’s in data extraction layer and using Hana Views & Composite Providers in Consolidation Layers
• Gave the Business a Tableau Cost Center Dashboard for Labor hours with underlying optimized SAP Hana
• Designed and Built Vendor Scorecard dashboard in Design Studio 1.6 using JavaScript and JSON’s which is being used by Global Procurement, Quality Managers across A O Smith
• Responsible for overseeing Tableau self-service analytics throughout the organization. Provide Tableau training, mentoring and outreach services. Collaborate with business areas forming partnerships developing cross-functional analytic solutions.Work closely with functional areas to ensure data is accurate and discoverable
• Rolled out Tableau Order fulfilment dashboards to 8 plant locations using Tableau Server. Dashboard shows Past Due’s, Open Orders, to be built heaters, Lead Times for Plant Operations
• Managed offshore consultants in charge of production support tickets and other maintenance activities
• Customer facing, regularly met with business users to gather requirements for new projects, coordinate activities for on-going projects, conduct demos for new reports, and conduct training for analytics tools

Confidential

Responsibilities:

• Improved performance of the client's SAP BW system by applying database indexes on BW objects, partitioning infocube fact tables, implementing SAP notes, enhancing user exit code, cube compression, infoobject buffer settings, DSO activation settings, BW Accelerator (BWA) monitoring, and BWA index creation/maintenance
• Performed root cause analysis on incidents, data reconciliation, selective data reloading, bug fixes for BW objects
• Configured Business Process Monitoring in Solution manager to proactively monitor the Key Performance Indicators (KPI)
• Created transports for entire BW data flows moving to production
• Enhanced existing BEx queries (formulas, Boolean, selections, cell definitions, etc.)
• Provided additional support for development activities such as data reloads and test extractions
• Monitored existing BW process chains and data loads
• Played a vital role with the SAP BW/BI production support team, took responsibility for monitoring data loads, resolving data load issues & any other inconsistencies. Also maintained detail log file with the status of all the issues
• Expertise in handling the Eclipse-based SAP Design Studio 1.6. Designed Sales Dashboard using scorecards, Navigation Filters, Panels, Charts and tabs
• Performed data validation, functional, UI and performance testing of Design Studio dashboards and WebI reports
• Monitoring of daily process Chains and correct the DTP load failures with basic troubleshooting
• Performed root cause analysis to identify and resolve data reconciliation issues, which halped to optimize data loads
• Worked on modifications related to the Info-object, Info-cube, DSO, multi-provider and Bex Report to fulfill business requirements and perform Impact analysis