Rohit Kulkarni

• Company Overview: State of Illinois has initiated SAP project for the family and child care support and Deloitte is the implementation partner for this project
• Reviewed the functional specification documents and built technical specification documents
• Worked on the enhancing the BW data models including Bex as per Illinois state requirements
• Set up folder structures and security for the BOBJ WEBI reports
• Worked on the SCAARs and VAP reports
• State of Illinois has initiated SAP project for the family and child care support and Deloitte is the implementation partner for this project

• Company Overview: ADP has several clients who use payroll services for their employees, and as part of data analytics, they have various process flows for different products.
• Worked with business users and functional configurators on requirement gathering, preparing functional specifications and technical specifications.
• Worked on new product enhancements in the BW system
• Worked in the Masters team on the new report requirement and enhancing existing reports
• Worked on the N8 Tax Deferral Report, gathering requirements, steaming tables to BW, building dataflows in BW including Bex queries and reports
• Create dataflows by developing various objects like Info Objects, data sources, Info providers like ADSO's, Info cubes, Multiproviders, Composite Providers, Open Hub's, APD's
• Open Hub's and APD's were developed for generating flat files for Audit teams, and Avenue project
• Enhanced various flows as per the report requirement changes by business users that were previously implemented
• Worked on Agile-Jira based model
• Documented activities and knowledge base documents in confluence
• ADP has several clients who use payroll services for their employees and as part of data analytics they have various process flows for different products

• Company Overview: Home Depot has implemented S4 HANA for their central finance reporting and also implemented BW 7.5 and HANA 2.0 for Comparable Sales and One Finance project initiative
• Worked on comp sales refactoring, redesigned the dataflows for performance improvement
• Worked on consolidation of Hana calc views for Analysis for office reports
• Worked with business users and functional configurators on requirement gathering, preparing functional specifications and technical specifications
• Worked on design, development, testing and supported post go live of implementation
• Designed solutions using the new Hana mixed / hybrid modelling features
• Worked on developing data flows, created objects such as CDS views, Calculation views, Table functions, parameters, ODP extractors, ADSOs, AMDPs, Transformations, DTP’s
• Worked on the HANA SQL database store procedure and consumed it via ABAP at the application level
• Worked on the requirement to generate a flat file based on database table using calculation view, external view and ABAP program and automated it via process chain
• Worked on Proof of Concept on Data Warehousing Cloud
• Created Entity relationship models after joining tables/nodes, maintaining associations, deployed / created models after data preparation in Data Warehousing Cloud
• Worked with different source/repositories
• Built semantic layer on top of data model using data builder in SAP DWC
• Worked on Hana Store Procedures and consumed it in ABAP
• Created test scripts in HP ALM for Unit Testing, Integration Testing and UAT
• Experience working with pivotal stories
• Home Depot has implemented S4 HANA for their central finance reporting and also implemented BW 7.5 and HANA 2.0 for Comparable Sales and One Finance project initiative

• Company Overview: TECO has initiated SAP ISU-CRM project in 2014, to convert its old legacy system into SAP, and it was implemented in two phases
• Work with business users and functional configurators on requirement gathering, preparing functional specifications and technical specifications
• Created Graphical calculation views, Scripted calculation views and Dimension calculation views for various reporting requirements
• Create dataflows by developing various objects like Info Objects, data sources, Info providers like ADSO's, Info cubes, Multiproviders, Composite Providers, Open Hub's, APD's
• Open Hub's and APD's were developed for generating flat files for Audit teams, and Avenue project
• Enhanced various flows as per the report requirement changes by business users that were previously implemented
• Worked extensively on the Billing and FICA reports, in depth knowledge on the ISU tables, understanding how the data is linked in ISU
• Worked on the Paid Taxes report which provides all different tax information like State tax, City tax, Florida gross receipt fee, Franchise charges
• Worked on Peak Demand by customer report for electricity and gas
• Enhanced BOBJ folder structures and report connections
• Created multiple reports using Analysis for Office and Webi tools
• Worked on automation of the jobs using Redwood Automation tool, created process definitions, Job chains, Job status alerts, email alerts
• Supported the production system which includes, monitoring, fixing job failures, performance tuning on the slow performing jobs and housekeeping activities
• Worked on Labor and Employment expense details report
• TECO has initiated SAP ISU-CRM project in 2014, to convert its old legacy system into SAP, and it was implemented in two phases

• Company Overview: Project: Financial System Roadmap FSR project has various releases since 2012 which are R3, R4, R5, and R5.6
• Each release was the major release in the FSR project and also had implemented AP/FA and Profit areas
• This is one of biggest projects in SAP in terms of volumes
• R5 & 5.1 releases included design & implementation on SAP BPC 10 version
• Global Template in BW7.3 systems with LSA Architectural features (Implementation of BW model and reports, based on FI-GL, AP, AA)
• Involved in developing objects for GL for the FSR DUAL POST project
• Developed objects for Profit Analyzer
• Quality testing for the FSR DUAL POST
• Involved in determining the data flow for the business requirements extraction and reporting and translated these requirements into Dimensional Data Models in BW for Warehouse Implementation
• Performed Data Extraction for master data (attributes, texts and hierarchies) and transactional data
• Scheduled and automated data loads from R/3 to BW, 3rd party systems to BW and also from flat files to BW and optimized the load performance by data selections and number of Info Packages
• Created various queries and extensively worked on Query Builder objects viz
• Filters, Structures, Exceptions, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Offsets and Query Variants
• Strong experience in support in troubleshooting Transformation, debugging start routines, end routines and expert routines, DTP, Cubes, DSO, Open Hub, BI Statistics, Performance tuning
• Performance Tuning with Aggregates, compression, Rollup, Partition, Reconstruction, OLAP Cache, Query Mode, Indices, Multi-Provider, Line-Item Dimension, Query Monitor (RSRT), Indexes and Archiving
• Experience in using BWA (BW Accelerator) Filling of BIA Indices, Roll up etc
• Extensively worked on support tickets, data issues, reconciliation issues, production log-utilization issues, Process chain failures
• Experience using the ticketing tools like Solution Manager and Remedy
• Experience in Automation using iXP (R11) tools, designed, developed, tested the BW jobs and process chains
• Full Implementation of BW which includes Extraction, DSO/Cubes, Bex Queries
• Worked with Report-to-Report Interface (RRI) to drill down from Info Cube to DSO item and schedule line level information
• Worked on design and development of Data Model, which includes General Ledger (GL), Accounts Receivable (AR) and Accounts Payable (AP)
• Development of Process Chains for Automated Scheduling of all Data Loading Jobs
• Participating in requirements gathering, design, configuration and testing activities for SAP BI and SAP Net weaver environments
• Responsible creating the transport requests and moving the same to Quality Environment
• Project: Financial System Roadmap FSR project has various releases since 2012 which are R3, R4, R5, and R5.6

• Company Overview: Project: Utilities - SAP BW-HANA model (Implementation of BW model and reports in SAP BW 7.4(BW on HANA) and FI- GL areas
• Created attribute, analytic and calculation views as part of the current project
• Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services
• Replication of the selected tables of FI from ECC to SAP HANA
• Performed transformations during the replication process
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity
• Experience in Importing meta data, Table definitions, performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE (In memory calculation Engine) studio
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio
• Migrating standard Info cubes to in memory optimized Info cubes using migration Tool
• Migrating standard DSO's to In-memory optimized DSO's using migration Tool
• Importing the BW Models into HANA using HANA Studio
• Consuming the HANA Models in BW by creating the Transient Providers
• Project: Utilities - SAP BW-HANA model (Implementation of BW model and reports in SAP BW 7.4(BW on HANA) and FI- GL areas

Project - Compliance Management & Reporting (CMR) is targeted to evaluate employee compliance with various agencies regulations and company policies and provides reporting on compliance evaluation and results

• Interacted with business users for requirements gathering
• Understanding report requirements
• Played a key role in design and development of Optimized Universe
• Played a key role in development of Reports
• Maintained the proper universe to report binding
• Tested Universe and Reports as per the reporting requirements required for end user
• Maintained universes or operational break/fix issues and enhancements
• Documentation of Universe and supporting guidance for end users
• Project - Compliance Management & Reporting (CMR) is targeted to evaluate employee compliance with various agencies regulations and company policies and provides reporting on compliance evaluation and results