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
Process Specialist at Cargill Business Services India Pvt Ltd, Cargill India Pvt. Ltd, CargillProcess Specialist at Cargill Business Services India Pvt Ltd, Cargill India Pvt. Ltd, Cargill