Dilip Kumar V Email & Phone Number

Bengaluru, Karnataka, India

Proficiently extract data from SAP, data hub, and Anaplan platforms, ensuring accurate and efficient data retrieval processes.Conduct comprehensive data flow analysis between SAP, SQL, and Anaplan systems, identifying key points of integration and potential data discrepancies.Implement rigorous data validation procedures for SAP, SQL, and Anaplan platforms, meticulously verifying data accuracy, consistency, and reliability.Collaborate with cross-functional teams to address and… Show more Proficiently extract data from SAP, data hub, and Anaplan platforms, ensuring accurate and efficient data retrieval processes.Conduct comprehensive data flow analysis between SAP, SQL, and Anaplan systems, identifying key points of integration and potential data discrepancies.Implement rigorous data validation procedures for SAP, SQL, and Anaplan platforms, meticulously verifying data accuracy, consistency, and reliability.Collaborate with cross-functional teams to address and resolve any data issues or discrepancies found during validation, ensuring smooth data operations and reliable reporting.Communicate findings and concerns to relevant teams and stakeholders, presenting clear and concise reports on data discrepancies and recommended solutions.Spearhead automation efforts using Alteryx, streamlining data extraction, comparison, and validation processes, resulting in significant time and resource savings.Continuously optimize and improve data extraction and validation processes to maintain high data integrity and reliability across platforms.Develop and maintain documentation for data extraction, flow analysis, validation, and automation procedures, ensuring knowledge sharing and smooth onboarding for new team members.Stay updated with industry best practices, advancements in data integration, and automation technologies to enhance data management and reporting capabilities.Proactively identify opportunities for process improvement and efficiency gains, driving innovation and excellence in data management practices. Show less

Bengaluru, Karnataka, India

Creating reports and dashboards using Power BI and data visualizations using Power Query Concepts. Working on schedule refreshing by means of data gateway and also publishing the report in power BI service. Updating the buying master and consolidate by different division.Daily, weekly and monthly report generation and multiplier report generation. Sales analysis and report to the concerned managers.Weekly review meeting conducted and present business trends and making sales… Show more Creating reports and dashboards using Power BI and data visualizations using Power Query Concepts. Working on schedule refreshing by means of data gateway and also publishing the report in power BI service. Updating the buying master and consolidate by different division.Daily, weekly and monthly report generation and multiplier report generation. Sales analysis and report to the concerned managers.Weekly review meeting conducted and present business trends and making sales dashboards.By using power BI application, display the business trends on daily basis.Creating the finished goods codes in voyager(oracle database).Measured and developed service level targets against best in class benchmarks. Show less

Bengaluru, Karnataka, India

Prepare the data and Doing Descriptive, Prescriptive, and predictive analysis and Share the findings to the management.Prepare and Publish the B&M(Buying and merchandising) report to the categoryplanners.Prepare the sales AOP(Target) vs sales Achievement report on daily basis.Providing tableau support to all the planners and buyers in the organisation.Connect with multiple data sources in power BI and develop the interactive dashboards.Provides various analyses and data… Show more Prepare the data and Doing Descriptive, Prescriptive, and predictive analysis and Share the findings to the management.Prepare and Publish the B&M(Buying and merchandising) report to the categoryplanners.Prepare the sales AOP(Target) vs sales Achievement report on daily basis.Providing tableau support to all the planners and buyers in the organisation.Connect with multiple data sources in power BI and develop the interactive dashboards.Provides various analyses and data support concerning all facets of management reports.Constantly improving the reporting processes and process automation.Make a review meeting with all the sales managers on weekly basis and discuss theGap.Prepare SPSF(sales per square feet) report on daily, weekly, monthly basis.Published the sales Trend Analysis for PAN India by using Power BI Desktop Tool.Support for JDA software files such as to change the given format to prescribed format to upload the Data.Provide support to the Business Manager with ad hoc tasks when necessary and Work withvendors to incorporate new systems in existing reports. Show less

Bengaluru, Karnataka, India

Creating reports and dashboards using Power BI and data visualizations using Power Query concepts.Working on schedule refreshing by means of data gateway and also publishing the report in power BI service.Updating the buying master and consolidate by different division.Daily,weekly and monthly report generation and multiplier report generation.Sales analysis and report to the concerned managers.Weekly review meeting conducted and presentbusiness trends and making sales… Show more Creating reports and dashboards using Power BI and data visualizations using Power Query concepts.Working on schedule refreshing by means of data gateway and also publishing the report in power BI service.Updating the buying master and consolidate by different division.Daily,weekly and monthly report generation and multiplier report generation.Sales analysis and report to the concerned managers.Weekly review meeting conducted and presentbusiness trends and making sales dashboards.By using power BI application,display the business trends on daily basis.Creating the finished goods codes in voyager(oracle database).Measured and developed service level targets against best in class benchmarks. Show less

Erode, Tamil Nadu, India

Handling multiple reports, working with formulas, pivot tables & pivot charts, and various other excel sheet components for accurate data.Interacting with clientdirectly through scheduled daily / weekly Business Conversation Ensure deliverables (Daily, Weekly & Monthly MISReports) are prepared to satisfy the project requirements cost and schedule.Responsible for all inward and outward documents verification and updated it to project manager.Daily reports of Complaints/ Request / Enquires… Show more Handling multiple reports, working with formulas, pivot tables & pivot charts, and various other excel sheet components for accurate data.Interacting with clientdirectly through scheduled daily / weekly Business Conversation Ensure deliverables (Daily, Weekly & Monthly MISReports) are prepared to satisfy the project requirements cost and schedule.Responsible for all inward and outward documents verification and updated it to project manager.Daily reports of Complaints/ Request / Enquires and Making dash boards of sales in all areas.Preparing the Monthly and yearly wise sales reports and also reports for costing and varience analysis.Preparing incentive MIS for all sale’s person & Channel Partner. Show less

Coimbatore, Tamil Nadu, India

Implement and analysis data to create daily, weekly, monthly basis.Measured and developed service level targets against best in class benchmarks.Generate timely and accurate reports for analysis.Generating and maintaining day to day MIS data and updating the management.Creating MIS report and presenting to the concern department.MIS reporting using MS Excel and macros at operational and client level.Responsible for preparing and review production schedule documentation for the… Show more Implement and analysis data to create daily, weekly, monthly basis.Measured and developed service level targets against best in class benchmarks.Generate timely and accurate reports for analysis.Generating and maintaining day to day MIS data and updating the management.Creating MIS report and presenting to the concern department.MIS reporting using MS Excel and macros at operational and client level.Responsible for preparing and review production schedule documentation for the products.Predicted troubles and delays for productionschedules.Managed raw material inventory by coordinating with vendors.Prepared monthly Performance Status Reports.Collated, analyzed and documented company’s quarterly and half yearly performance details.Generated, maintained and analyzed Sales, Quality and Client Service reports.Reviewed history of current reporting.Monitored implementation of MIS processes and evaluated their effectiveness.Performed Trend Analysis of Data and Automation of reports. Show less