YASHASVI SHARMA
Summary
Analytical and results driven data analyst with hands-on experience in SQL, MS Access, Power BI, and Excel for data consolidation, transformation, and visualization. Skilled at designing data driven solutions that improve decision making, optimize processes, and drive operational efficiency. Proven success in streamlining estimation and reporting workflows, automating repetitive tasks, and building dashboards for project and resource management. Known for technical accuracy, stakeholder collaboration, and delivering insights aligned with business goals.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Data Analyst Intern
UGL Resources
05.2025 - Current
- ERP Integration and Software Implementation: Collaborated on enhancing internal estimation and project control modules integrated with enterprise ERP systems, ensuring seamless data flow between engineering, finance, and resource planning platforms.
- Data Engineering & Automation: Designed and optimized SQL ETL pipelines consolidating multi-disciplinary datasets (Process, E&I, C&S), improving data accuracy by 35%, and reducing reporting turnaround time from 3 days to 4 hours.
- Dashboard Development: Built executive-level Power BI dashboards visualizing project cost, resource utilization, and phase deliverables, enabling leadership to identify trends and improve forecasting accuracy by 25%.
- Process Optimization: Developed automated Excel workflows using Power Query and VBA macros, eliminating manual reconciliation steps and saving 10+ hours weekly across estimation teams.
- Database Governance: Standardized MS Access data models and documentation, enforcing relational integrity, and improving traceability of estimation data across terminals.
- Cross-Functional Collaboration: Partnered with engineering, finance, and project control teams to define KPI metrics and reporting structures aligned with corporate standards.
- Data Quality & Validation: Implemented validation scripts and anomaly-detection queries, ensuring compliance with audit requirements, and maintaining over 98% data reliability.
- Additionally worked on building a Microsoft Power App to bring all project data together, enabling smooth consolidation of completed and upcoming projects. Designed the app to ensure precise, accurate, and polished data presentation, making it easier for teams to input, track, and review project information efficiently.
- The Data Analytics team supports the engineering and project divisions by delivering automated estimation, reporting and ERP integrated systems through SQL, MS Access, and Power BI solutions.
Business Analyst
Department of Transport and Major Infrastructure
11.2024 - 04.2025
- Requirements Analysis: Facilitated requirement gathering workshops with managers and IT teams, translating strategic objectives into actionable, functional specifications.
- Process Mapping & Improvement: Produced detailed AS-IS and TO-BE process maps in Visio, identifying automation opportunities that reduced process delays by 20%.
- Data-Driven Reporting: Designed prototype Power BI dashboards for incident tracking and compliance KPIs, enhancing executive visibility into risk metrics.
- Governance Documentation: Developed standard operating procedures, audit checklists, and control frameworks aligned with departmental policies.
- Stakeholder Engagement: Coordinated communication between business units and developers to ensure alignment of deliverables, and smooth UAT execution.
- Strategic Insights: Conducted root-cause and gap analyses to recommend data integration improvements, supporting future-state digital systems.
- Supported the Risk and Business Continuity division in process improvement and digital transformation initiatives focused on operational resilience and compliance.
Education
Masters - Business Analytics
Edith Cowan University
Perth07.2025
Bachelor of Biotechnology - BSc
Amity University
Jaipur06.2022
Core Competencies
- Expert in developing dynamic and interactive dashboards using Power BI and Tableau. Skilled in applying DAX measures, drill-through filters, and KPI cards to convert raw datasets into actionable insights.
- Hands on experience working with enterprise resource planning (ERP) environments to integrate estimation, reporting, and project management systems. Skilled in system implementation, data migration, requirement analysis, UAT coordination, and end user documentation.
- Advanced proficiency in SQL Server and Microsoft Access for data extraction, transformation, and relational database design. Experienced in writing complex SQL queries, stored procedures, and joins to support large-scale analytical models.
- Strong capability in translating business requirements into structured data models. Skilled in data validation, cleansing, normalization, and consolidation across multiple sources to ensure integrity and governance.
- Advanced user of Excel (Power Query, Pivot Tables, Lookup Formulas, Conditional Formatting) for automation and analytics; experienced in preparing executive reports and presentations using PowerPoint and Word., Proficient in Visio for process mapping and Confluence for requirement documentation and knowledge sharing.
- Strong ability to break down complex business problems, interpret data driven insights, and recommend actionable solutions that support strategic decision making.
- Skilled in engaging with cross-functional teams, gathering requirements, and conveying technical information in a clear, concise manner to both technical and non-technical stakeholders.
Certification
- Microsoft Power BI, Coursera
- Python, Hackerrank
References
- Vivek Gaur( Engineering and Project Manager)- vivek.gaur@ugllimited.com
- Sean Davies( Manager Risk and Business Continuity)- Sean.Davies@transport.wa.gov.au
Timeline
Data Analyst Intern
UGL Resources
05.2025 - Current
Business Analyst
Department of Transport and Major Infrastructure
11.2024 - 04.2025
Masters - Business Analytics
Edith Cowan University
Bachelor of Biotechnology - BSc
Amity University