Summary
Overview
Work History
Education
Skills
Career Path
Certification
Timeline
Generic

Sateesh Kumar

Exton,PA

Summary

Experienced business intelligence professional well-versed in Process mining and Data Mining data, developing databases, and generating reports. Detail-oriented and systematic with excellent follow-through and a superior work ethic. Excellent communication, project management, and problem-solving abilities.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior System Analyst

Cargill Pvt Ltd
03.2019 - 12.2023
  • Improved system efficiency by streamlining processes and implementing automation tools.
  • Reduced downtime for critical business applications by proactively identifying and resolving system issues.
  • Collaborated with cross-functional teams to develop and implement effective IT solutions for business needs.
  • Enhanced security measures by conducting regular audits and implementing necessary updates.
  • Mentored junior analysts, sharing industry knowledge and best practices to improve team performance.
  • Optimized data storage and retrieval processes, ensuring timely access to vital information for decision-making.
  • Developed custom software solutions to address unique business challenges, resulting in improved operations.
  • Evaluated emerging technologies and recommended strategic upgrades for increased productivity.
  • Architected and implemented scalable and high-performance data models, data flows, and reporting solutions in both Celonis, UIPath and SAP BW
  • Recommended and implement process improvements based on Celonis insights to enhance efficiency, reduce costs, and minimize errors
  • Utilized process mining tools to analyze event logs and extract valuable insights into business processes
  • Implemented quality control measures to validate the integrity of data and the effectiveness of process improvements
  • Good understanding of the Process Mining and Data Mining solutions offered by Celonis, UIPath, and its existing capabilities
  • Hands-on experience in different components of Celonis like - Views, Action Flows, Skills, Knowledge Models, simulation, and data explorer
  • Written complex SQL & PQL queries to fulfill the business requirements
  • Implemented Multi Event Log in the custom project and have good knowledge about OCPM
  • Played a key role in data governance, data quality, and master data management initiatives
  • Defined data models, transformations, and calculations to prepare the data for reporting and analytics


Staff Systems Engineer

Cadence Design Systems
10.2017 - 03.2019
  • Manage a delivery team to ensure timely and accurate customer deliveries
  • Perform resource/workload assignments according to delivery requirements
  • Analyze and troubleshoot delivery issues in a timely fashion
  • Responsible for collaborating with stakeholders throughout the project lifecycle
  • Coordinating activities that affect operational decisions and business requirements
  • Communicating with all relevant employees to ensure delivery times are met
  • Coordinating with projects to ensure issues/gaps/overlap are defined and resolved
  • Report delivery status to customers and develop required delivery documentations
  • Supporting local project managers to achieve/maintain/improve the project goals
  • Planned the kick-off and gap-analysis
  • Organized weekly project meetings along with key stakeholders
  • Created stored procedures for custom data manager packages
  • Designed/modeled a data flow from ECC into BW then into summarized BW info cubes designed
  • Defining and developing dimensions, applications, calculations, script logic, business rules, Input schedules and reports extraction of data from SAP BW as a source system into BPC applications via data manger packages.

SAP BI BW BPC Architect

Exalogic Consulting
01.2015 - 10.2017
  • Carry out meetings with the concerned managers and business users to understand their requirement and their perspectives on viewing the data and the usage of the data projections
  • Gathering requirements and defining the scope of solutions based on time-lines and technical architecture
  • Proactive in identifying problems/conflicts and looking for changes for the better
  • Manage BW projects utilizing Offshore/Onshore team ensuring quality/timely delivery
  • Leading functional/technical meetings to ensure solutions meet the needs of business
  • Coordinating with projects to ensure that issues/gaps/overlaps are defined/resolved
  • Coordinate with the program manager to ensure standards
  • Manage BW, and BPC projects utilizing offshore/onshore teams ensuring quality/timely delivery
  • Leading techno-functional meetings for the entire LC to ensure the needs of the business
  • Setup new master data (Accounts, Company codes, etc) and modify business rules, logic, and reports accordingly
  • Make sure all 3 systems (SAP FI, BW, and BPC) transaction data matches during the month-end
  • Experience in SAP HANA data modeling using Attribute View, Analytical view, and Calculation view
  • Involved in the reporting requirement analysis and designing the solution plan in Hana (Information modeling), SAP BW, SAP BPC, Qlik Sense, and BO
  • Prepared Test plans, and test cases for Hana results validation and also carried out test case execution
  • Good knowledge of SAP HANA and SQL Scripting
  • Fixed defects during various stages in testing such as System Testing, User Acceptance Testing.

SAP Consultant

DELOITTE Consulting India Pvt Ltd
09.2024 - 01.2024
  • Discuss the requirements with client and functional team to understand the business flow and the process to convert them into technical specification, which help developer carryout the development process
  • Implemented SAP BW, BPC for MM, FI and HR modules
  • Developed custom function module extractors, used ABAP routines in transformations
  • Participated in design reviews, spec reviews, code reviews, test plan reviews
  • Worked with various standard as well as custom BI/BW objects for FI, HR, and MM of ECC
  • Worked on customization and enhanced the extract structure to support business needs
  • Developed various transformations to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements
  • Client wants to do reporting on additional dimension - Business Area in SAP BPC and to achieve this requirement performed analysis and modified BPC models, transformation files, conversion files, security, and script logic
  • Providing project work load and timelines to the business users
  • Responsible for defining technical strategy and tactical plan for implementing data and information delivery solutions
  • Developed custom function module extractors, used ABAP routines in transformations
  • Participated in design reviews, spec reviews, code reviews, test plan reviews
  • Worked with various standard as well as custom BI/BW objects for FI, HR, and MM of ECC
  • Create Physical Inventory document with respect to storage locations
  • Configure and update master Data's as per the requirement
  • Worked on customization and enhanced the extract structure to support business needs
  • Carry out TUT process from creating the test cases, test scripts and test case execution to ensure desired functionality.

SAP BI Developer

DELTA Technology and Management Services
05.2024 - 09.2024
  • Involved in designing data flows to extract APO, Sales, Vistex, and Finance data from SAP ECC 6.0 system
  • Design & Development of Technical Specifications documents for the requirements
  • Collaboration with the client to finalize the requirements
  • Architectural & POC kind of activities to do the feasibility study
  • Loaded the requirements to Demand Management based on user input
  • Executed the forecast explosion macro and exploded the system demand to generate the requirements for the components and transferred the same from time series live cache to order live cache
  • Loaded the data from flat file to info cube and from the info cube to planning area
  • Involved in proposing high level design for various data targets like InfoCubes and DSO to meet the business requirement
  • Worked on Remote InfoCubes to support real time data
  • Configured the data sources in BW to retrieve Sales/ Forecast data from APO
  • Created multiple events and related jobs to automate the loads from R/3 and APO
  • Worked on Query Designer
  • Used free characteristics, Filters, Variables, Calculated and Restricted Key figures and Created Variables with user exits and replacement path
  • Created Characteristic Value Combinations (CVC), Planning Areas
  • Extensively involved in handling Initialization, Delta and Repair full request for the Logistics Applications and Created Aggregates on InfoCubes to improve Query performance
  • Involved in solving performance-related issues by applying Partitioning and Compression
  • Scheduled data loads to BW from SAP R/3, Monitored data loads which are running hourly, daily, weekly & monthly basis and solving errors when errors occurred
  • Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages
  • Maintaining Reconciliation's to verify the data in SAP R/3 and SAP BW are same or not after the data loads
  • Enhanced data source for appending fields in to the structure and filling them using User Exit
  • Create Dashboards with Xcelcius for Profit and Loss Analysis, Customer Aging, Account payables and Receivables.

SAP BI Consultant

INFOWIN TECH SOLUTIONS PVT.LTD.
10.2024 - 05.2024
  • Carry out meeting with the concerned managers and business users to understand their requirement and their perspective of viewing the data and the usage of the data projections
  • Good understanding of PS master and operational data like WBS, network, activities, milestones
  • Good experience and knowledge in project structure and project scheduling
  • Extensively worked in the cost planning, budgeting, work progress and closure
  • Worked on customization and enhanced the extract structure to support business needs
  • Reconciliation of BI reports with the ECC & legacy data as wells as the reports
  • Created and Maintained Transformation Files and Conversion files in BPC 10.0 version
  • Reconciling the data of SAP BPC Consolidation and Planning Extracts with SAP BI and ECC applications
  • Created BADI to extract data from ECC system
  • Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc
  • Performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems
  • Created various interfaces from BW to various non-SAP systems using APD and OPEN HUB
  • Assist and conduct UAT sessions with users on the in PROD
  • Record any issues, fix the bugs if any, and collect the signoff.

Education

Master’s Degree in Computer Applications -

Kakatiya University

Bachelor of Science - Computers And Electronics

Acharya Nagarjuna University
06.2003

Skills

  • Process Mining and Data Mining
  • Data Modeling
  • ETL Development
  • Data Warehousing
  • Machine Learning
  • Data Analysis
  • Data Visualization
  • Data Integration
  • Predictive Analytics
  • Business Analysis
  • Python Programming
  • Data Governance

Career Path

  • 03/19/19, 12/23/23, Senior System Analyst, Cargill Pvt Ltd
  • 10/17/17, 03/19/19, Staff Systems Engineer, Cadence Design Systems
  • 01/15/15, 10/17/17, SAP BI BW BPC Architect Consultant, Exalogic Consulting, Dubai
  • 09/13/13, 01/15/15, SAP Consultant, DELOITTE Consulting India Pvt Ltd, Hyderabad
  • 05/10/10, 09/13/13, SAP BI Developer, DELTA Technology and Management Services, Hyderabad
  • 10/06/06, 05/10/10, SAP BI Consultant, INFOWIN TECH SOLUTIONS PVT.LTD., Bangalore

Certification

PMP, SAP FICO and Celonis

Timeline

SAP BI Consultant

INFOWIN TECH SOLUTIONS PVT.LTD.
10.2024 - 05.2024

SAP Consultant

DELOITTE Consulting India Pvt Ltd
09.2024 - 01.2024

SAP BI Developer

DELTA Technology and Management Services
05.2024 - 09.2024

Senior System Analyst

Cargill Pvt Ltd
03.2019 - 12.2023

Staff Systems Engineer

Cadence Design Systems
10.2017 - 03.2019

SAP BI BW BPC Architect

Exalogic Consulting
01.2015 - 10.2017

Master’s Degree in Computer Applications -

Kakatiya University

Bachelor of Science - Computers And Electronics

Acharya Nagarjuna University
Sateesh Kumar