Prakhar Gupta Email & Phone Number

Boston, Ma, Us

Boston, Massachusetts, United States

• Applied Python to analyze client interaction data to highlight the most critical technical issues, increasing system efficiency by 4%.• Created a ticket management database system by using the MySQL workbench to streamline the Quality Assurance team's workflow.• Utilized Microsoft Power Automate to find patterns, leading to gaps, in the inventory tracking system and cut the inaccuracy by 11%.• Managing a 94% customer satisfaction score while providing technical help to clients via phone conversations and walk-ins.

Framingham, Massachusetts, United States

• Utilized advanced data analytics and optimized Snowflake SQL procedures to improve the fill rate, achieving a 12% increase in order fulfillment accuracy. This enhancement not only boosted customer satisfaction but also led to an 8% reduction in order processing errors, significantly improving overall supply chain operational efficiency.• Played a key role in transitioning over 50 procedures from the old Manhattan Warehouse Management System (PKMS) to the new Manhattan Active WMS (MAWM), demonstrating expertise in end-to-end supply chain operations. This transition resulted in a 15% reduction in order processing time and a 10% improvement in inventory accuracy.

India

Development of Snowflake Data Extraction Scheduler:• Implemented a secure and interactive user interface on Microsoft Power Apps. The interface enabled users to trigger the extraction of data from databases such as MS SQL Server, and dynamically build Azure Logic Apps.• Developed an Azure function app to extract data from multiple relational databases and perform data migration to the user-defined cloud platform like AWS S3 and Azure Blob Storage.• Ensured data security and privacy by integrating the tool with Azure Active Directory, providing role-based access control and data governance capabilities, resulting in a 40% decrease in data breaches.• Followed Agile Methodology to meet client requirements and improve the tool's performance and scalability, resulting in a 25% increase in tool performance and a 30% reduction in development time.

Bengaluru, Karnataka, India

Development of Data Quality Tool:• Designed, coded, and built a software tool for Data Quality checks on incoming data through the creation of data pipelines and ETL processes with the help of a team - The tool was able to successfully clean and analyze data from over 10,000 records in just 10 minutes, improving the accuracy of the data by 95%. • Developed and designed ADF pipelines to automate trigger for Azure Databricks notebook, which incorporated data warehousing techniques and big data technologies like Hadoop and Spark - The ADF pipelines successfully processed over 100 GB of big data in just 30 minutes, reducing the manual processing time by over 70%.• Eliminated human errors by automating the pipeline, resulting in a 100% accuracy rate in processing the data.• Conducted sessions with clients to understand business requirements and used data modeling and data visualization techniques to provide business intelligence using Google Charts & Microsoft Power BI.• Maintained a CI/CD platform for the tool using Git version control system and deployed it to the Azure cloud computing platform, ensuring scalability and performance optimization.

Mumbai Area, India

• Worked on various Embedded Projects on PIC18F26K40 microcontroller and Microchip’s Explorer 8 Development Board• Worked with MPLAB X IDE software and coded in Embedded C language• Debugged the code and created test suites for Unit testing

Master'S Degree, Data Analytics Engineering, 3.77

Coursework : 1. Foundation of Data Analytics 2. Data Management & Analytics 3. Data Mining 4. Computation and Visualization 5. Financial.

Bachelor Of Technology - Btech, Electrical, Electronics And Communications Engineering, 8.6

Hsc, Mathematics

Activities and Societies: Badminton

Ssc