Vishant Bhatia Email & Phone Number

Canada

Windsor, Ontario, Canada

• Developed and optimized complex SAP B1 HANA queries using Common Table Expression (CTEs) to enhance data extraction, reduce query run-time and improve report generation efficiency.• Designed and customized layouts in SAP B1 HANA for customer facing documents and automating the process of sending documents via Email from SAP B1, reducing manual efforts by 30%.• Developed and migrated Crystal Reports to SAP B1 HANA, enhancing reporting accuracy and streamlined the process.• Provided training and support to end-users and other IT staff on SAP B1 HANA functionalities and best practices.• Led the implementation of SAP B1 HANA dashboards and cockpits to streamline procurement, packaging, quality and profitability to enhance data-driven decision-making processes.• Designed and automated custom alert systems in SAP B1 HANA for discrepancies between purchase order and GRPO, improving procurement accuracy by reducing errors by 20%.• Automated the process of sending data from SAP B1 HANA via email to Power BI, reducing manual work by 35% and ensuring seamless data updates for reporting and analysis.• Design, develop, and maintain interactive reports and dashboards using Power BI.• Extract, transform, and load (ETL) data from SAP B1 HANA into Power BI.• Use DAX (Data Analysis Expressions) to create advanced calculations and measures.• Train machine learning models using historical data and validate their accuracy and performance.• Developed a machine learning model for thrips forecasting, improving early detection accuracy by 25% and reducing pesticide usage by 15%, resulting in cost savings and sustainable farming.

Windsor, Ontario, Canada

Capable of translating business requirements into technicalsolutions using Power BI and SQL, ensuring alignment withorganization and stakeholder needs.Analyze and address user-queries, troubleshoot issues andpromptly resolve technical challenges.Proficient in developing interactive dashboards and reportsusing Power Bi and do descriptive, predictive, and prescriptiveanalytics.

Windsor, Ontario, Canada

Experience and proven knowledge in manufacturing processes, procedure and high-volume production machinery and systemsExpertise in working with cold and hot pressing with Safety and Health standards and employment law.

Amritsar, Punjab, India

• Monitor, analyze, reporting and dashboards to identify risks, recommending and implementing corrective actions.• Conduct in-depth analysis and transformation of large and complex datasets to generate actionable insights.• Expertise in working with the Tableau Server and Tableau command line utility to maintain and schedule Tableau Data Extract.• Responsible for generating periodic reports to facilitate technical assessment and management overview. Proficient in creating trend reports and various types of charts and enable informed decision-making by providing comprehensive insights into key metrics and trends, ultimately impacting company strategies and initiatives.• Proficient in SQL for administering object creation, including Tables, Views, user-defined functions, indexes, stored procedures, CTEs, cursors, and triggers. Leveraged these skills to optimize database performance, streamline operations, and enhance data-driven decision-making, contributing to the company's overall success.• Successfully utilized MS Excel data analysis tools including sorting, filtering, VLOOKUP, and PIVOT tables to analyze and validate data. These efforts directly contributed to optimizing sales strategies, identifying market trends, and enhancing decision-making processes, resulting in increased company sales and operational efficiency.

Amritsar, Punjab, India

Managed complex business concerns for licensing, taxation, and financial oversight to profitable operations.Worked with clients to comprehend business needs and restructure those prerequisites into reports with Tableau and Power Bi.Used advanced Microsoft Excel to create pivot reporting and increased annual sales by 30%.Creation of Insight reports in a predictive way at different levels using Python, Matplotlib, Pandas, Scikit-learn and Machine learning models.

Pune, Maharashtra, India

Implement monitoring shell scripts to notify teams about database up/down time status and sizing concerns to ensure 24*7 availability.Develop and maintain ETL processes to facilitate seamless data integration across systems.Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.Optimized database performance by monitoring health and implementing tuning recommendations.Streamlined backup and recovery processes, enhancing overall system stability and availability.

Post Graduate, Data Analytics For Business, 2 Year Program

Data analytic for business, data science , machine learning, artificial intelligence, python , R studio

B.Tech, Computer Science & Engg.

Activities and Societies: NSS, Prayas, ACES

B.Tech, Computer Science & Engg.