Experience

• 

  Intelligroup asia private limited

  Aug 2006 - Oct 2009

  Sap bw developer

  Responsible for: Worked extensively on Data warehouse workbench (RSA1). Designed and developed Info Objects, Info Cubes, DSOs, Info sets and Multi providers. We developed flexible business User interfaces for calling BAPI’s from SAP ABAP HR Module Payroll Data . Designed Standard Data sources from R/3 and flat file, Created Transformations and assigned Rule groups.  Worked on different types of Data Store Objects (DSO) like: Standard DSO, Write optimized DSO & Direct update DSO. Worked Reports Payroll data is provided on a monthly basis by the BW extractor used. Using update rules, the InfoCube also calculates calendar quarters and annual information (on a calendar basis in each case). An example is used to illustrate the assignment of a month. The example assumes that payroll is performed on a weekly basis. Monthly payroll runs are usually easy to assign. Validated data consistency in reporting with Data Target against PSA after loading them to data targets. Created Process Chains to automate the process of loading data into Data Targets. Involved in Transporting the BW objects from development server to Quality server.  Involved in unit testing of EDW layer.  Worked with the RSMO in solving the data load errors Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets. Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains. Extensively worked with all types of tickets raised by end-users. Expert in analyzing the Short-dump occurred across the systems and resolution of issues/tickets raised for the same Involved in Requirement Analysis. Show less

• 

  Intelligroup

  Aug 2006 - Oct 2009

  Sap bw developer

  SAP BW , HR, , SAP Payroll , FI, SD Logistics , BEX Reports

• 

  Igate

  Nov 2009 - Sept 2014

  Sap bw team lead

  PerkinElmer (NY), P&G Procter & Gamble (Cincinnati), Owens Corning (Toledo),

• 

  Ge

  Sept 2014 - Dec 2014

  Sap crm /bw consultant

  • Major Responsibilities include BW Data loading Monitoring /Issue resolution.• Handling any new CR’s & Attending client meetings and taking care of these requirements fixing issues for Complaints , Return process and status management.• Involved SAP CRM,SD,AP,AR with BW Roll Out &Go-Live support activates (Global Orders , Global revenue, Global Cost, Open Service order)• Involved with BI data load scheduling by using process chains, monitoring and troubleshooting data extraction/load problems.• Handling the Business critical tickets using remedy tool• Reconciliation of data with interfaces, BWA Indices, Secondary Indices, Rollup and Compression PSA deletion and maintaining aggregates as a part of performance tuning• Month end and Year End activities. Show less

• 

  The clorox company

  Jan 2015 - Jun 2015

  Sap bw/hana consultant

  • Involved in full cycle of implementation of SAP BW on HANA, SAP HANA on BO which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support• Translate the Business KPIs into HANA & Define the Reporting Layouts Using SAP BO WEBI reports • Experience with HANA Live and Virtual Data Mart (VDM). Building custom applications using VDMs • Involved in creating custom schema, non-ECC tables and SQL queries in SAP HANA • Involved in Data Provisioning from SAP ECC, SAP BW and non-SAP sources via SLT, BODS and DXC, HANA security including User Management, Roles and Analytic Privileges• Experienced with different Relational databases like Teradata Hadoop with HANA, Oracle and SQL Server, Created HANA optimized data providers Info cubes and DSO created in SAP BW• Enhance DPA reports by the agreed improvements• Create the Business Blue-Print document Show less

• 

  Cintas

  Jun 2015 - Jun 2016

  Senior sap bw / hana consultant

  • SAP HANA Modeling – Attribute, Analytic and Calculation Views , SAP HANA options/functions, SQLScript Procedures for SAP HANA, SAP HANA Project Explorer Approach - Performance Analysis via PlanViz, Indexes, Sequencing, Views, Tables.• SAP HANA Modeling – Attribute, Analytic and Calculation Views , SAP HANA FUZZY SEARCH options/functions, SQLScript Procedures for SAP HANA, SAP HANA Project Explorer Approach - Performance Analysis via PlanViz, Indexes, Sequencing, Views, Tables.• Development of SAP BI Objects, Extraction, Transformation, Data Acquisition, Data Loading and Monitoring• SAP BW Query Designing and Web Application Designing (WAD), Analysis Process Designing (APD), Process Chains (PC)• Broadcast data via SAP BW OpenHub APD Destinations like Data Warehouse ,MDG,CRM, SD IP : Vistex Sales teams .• Expertisein BW on HANA, LSA++ Architecture. Show less

• 

  Pfizer

  Jul 2016 - May 2017

  Hana technical architect
• 

  Briggs & stratton

  May 2017 - Oct 2018

  Hana developer
• 

  Ernst & young

  Oct 2018 - Nov 2019

  Ernst & young

  • Extensively worked on SAP HANA Modeling – HANA Calculation views, HANA CDS Views, analytical Privileges, Column store views and performed SQL, Creating Function using PL/SQL the Function Editor coding to push data into data base intensively.• Created custom CDS composite, basic and consumption views for real time reporting in s/4• Utilized standard basic SAP S/4HANA CDS views consisting of master data for various consumption CDS query views ,Maintained standard runtime hierarchies for profit center, cost center and financial statement versions,Created table functions in case of complex database functions where CDS has limitations in ansi sql Show less

• 

  Autodesk

  Apr 2020 - Dec 2020

  Sap hana applications programmer -analyst

  SAP BI Analyst

• 

  Charter communications

  Dec 2020 - now

  Sap business intelligence consultant /sap hana technical architect