SHLOK MISTRY
Tempe,AZ
Summary
Detail-oriented Data Analyst with 2 years of experience in data mapping, validation, and database management. Proficient in Excel, including advanced functions like XLOOKUP, VLOOKUP, Pivot Tables and Macros, with a proven ability to automate data processes, ensuring data accuracy and consistency. Skilled in SQL, Excel, and ETL processes, with a strong focus on identifying and addressing data gaps, improving data quality, and supporting business intelligence needs. Adept at collaborating with cross-functional teams to enhance data models and streamline data reporting. Committed to delivering accurate, actionable insights through systematic data management and validation practices.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst
Safe-Way Garage Door
Tempe, AZ
09.2024 - Current
- Designed and automated Excel-based Reports using Macros, VBA scripts, and Power Query for streamlined data analysis.
- Built a Customer-Specific Configurator in Excel, utilizing advanced functionalities like VLOOKUP, XLOOKUP, and macros to streamline workflows, improving efficiency by 75%.
- Developed SQL queries and scripts to extract, transform, and load (ETL) data, increasing data processing accuracy by 45%.
- Created and maintained Power BI dashboards, fixed a financial reporting discrepancy of $250,000, and improved financial report reliability by 100%.
- Developed an Automated Purchasing System using Power Apps, reducing manual input and enhancing order accuracy.
- Worked extensively with ERP systems to manage data integrity and optimize operational workflows, reducing data inconsistencies by 30%.
- Automated the order processing system, integrating tools to enhance customer experience and reduce order turnaround time.
- Built a configurable application in Retool using Python and JavaScript for seamless data visualization and customization.
- Designed Python scripts to automate label printing, reducing manual tasks and improving production efficiency by 80%.
- Streamlined supply chain data tracking, ensuring accurate forecasting of material needs and inventory levels through Power BI reports.
- Integrated supply chain data with ERP and reporting systems, improving visibility into procurement and inventory workflows.
Data Analyst
CleVision Technologies Private Limited
Ahmedabad, India
01.2021 - 07.2022
- Created advanced Excel dashboards with Pivot Tables and conditional formatting, improving reporting speed by 40% and providing real-time insights into data mapping accuracy.
- Developed a systematic approach to manage data mapping tasks, leading to a 25% increase in task completion speed and improved data consistency across all datasets.
- Streamlined data reconciliation using Excel's VLOOKUP and XLOOKUP functions, resulting in a 25% increase in data accuracy and faster resolution of discrepancies.
- Spearheaded the integration of new data sources, resulting in seamless data flow and a 10% improvement in the consistency of product information across multiple systems.
- Utilized Excel’s Power Query to automate data extraction and transformation, cutting data processing time by 50% and ensuring timely data integration..
- Created and maintained documentation for SQL queries, stored procedures, and ETL processes to ensure knowledge sharing and continuity.
- Implemented data security measures and access controls in SQL databases to safeguard sensitive information.
- Optimized data analysis workflows by creating Excel tools that automated trend analysis, resulting in a 30% increase in the speed of identifying data mapping gaps.
- Analyzed large datasets using SQL and Excel to identify trends, patterns, and insights, supporting strategic business initiatives.
Education
Master of Science - Information Technology
Arizona State University
Tempe, AZ05-2024
Bachelor of Science - Computer Engineering
Gujarat Technological University
Ahmedabad, India07-2022
Skills
- SQL & Database Management (SQL Server, MySQL, PostgreSQL)
- Advanced Excel (Pivot Tables, VLOOKUP, XLOOKUP, Macros)
- Python, Java
- Automated Reporting (Power BI, Tableau)
- Data Modeling & Schema Design
- Data Mapping & Validation
- Data Reconciliation & Audit
- Cross-Functional Collaboration
Certification
- GOOGLE ANALYTICS PROFESIONAL CERTIFICATE
- GOOGLE BUSINESS INTELLIGENCE SPECIALIZATION
Timeline
Data Analyst
Safe-Way Garage Door
09.2024 - Current
Data Analyst
CleVision Technologies Private Limited
01.2021 - 07.2022
- GOOGLE ANALYTICS PROFESIONAL CERTIFICATE
- GOOGLE BUSINESS INTELLIGENCE SPECIALIZATION
Master of Science - Information Technology
Arizona State University
Bachelor of Science - Computer Engineering
Gujarat Technological University
Similar Profiles
Murad AbukhattabMurad Abukhattab
Garage Door Technician at Safe Way Garage DoorsGarage Door Technician at Safe Way Garage Doors
Travis Behn JrTravis Behn Jr
Garage Door Tech at Don's Garage Door CoGarage Door Tech at Don's Garage Door Co
Julia WinskyJulia Winsky
Bookkeeper at Freeport Garage DoorBookkeeper at Freeport Garage Door