Apurva Aggarwal

Apurva Aggarwal Email:-| Phone: (- | LinkedIn: Apurva Aggarwal | LinkedIn Professional Summary An experienced Data Analyst with a strong background in the financial industry and IT consultancy, adept at leveraging data to drive strategic decision-making and optimize business processes. Proficient in data analysis, visualization, and reporting tools such as SQL, Python, AWS Quicksight and Power BI. Adept at bridging the gap between business stakeholders and technical teams to ensure effective communication and seamless project execution. Experienced in eliciting and documenting requirements, managing stakeholder expectations, and delivering actionable insights. Committed to providing data-driven solutions that enhance efficiency and support organizational goals. Core Competencies: • • • • • • • • Data Analysis & Data Visualisation in tools (Power BI, Excel & AWS Quicksight) SQL & Database Management Knowledge of programming in Python, R Statistical & Quantitative Analysis ETL (Extract, Transform, Load) Processes. Familiarity with Cloud Platforms like Azure &AWS Data Storytelling and Business Intelligence Stakeholder Communication & Collaboration. Technical Skills • Data Visualization & Storytelling – Power BI, Tableau, • ETL & Data Wrangling – Cleaning, transforming, and structuring data for analysis • Data Analysis & Insights – Statistical modeling, data • Programming & Databases – Python (Pandas, NumPy, Scikit-learn), SQL (PostgreSQL, MySQL) • Project Management: Agile, Waterfall, Jira, Cross- • Version Control – Git for code versioning and collaboration • Cloud & Big Data Technologies – Azure, Databricks, • Stakeholder Engagement – Presenting data-driven insights to senior leaders • Business Strategy & Decision Making – Leveraging • Coaching & Mentorship – Supporting teams in developing analytical skills AWS Quicksight, Excel(pivot tables, logical and lookup functions, etc.) mining, predictive analytics functional Team Leadership AWS insights to drive business value Professional Experience Data Analyst | Delta Capita, UK • • Apr 2022 – Aug 2024 Engineered and deployed custom Azure data factory jobs using PySpark, achieving a monumental 50% gain in data efficiency and precision. Developed and maintained interactive dashboards and reports using Power BI to provide real-time insights into key business metrics, resulting in a 30% increase in data-driven decision-making. 1 • • • • • • • • Designed and tailored visualizations using QuickSight's advanced features such as calculated fields, parameters, and custom visual types to enhance data storytelling and user engagement. Collaborated with cross-functional teams to determine reporting requirements and deliver comprehensive data solutions. Apply techniques such as data normalization, deduplication, and formatting to enhance data usability. Partnered with business stakeholders to identify requirements and deliver tailored dashboards and reports using Power BI and SQL. Assisted testing teams in validating and verifying data accuracy and integrity. Utilised Pandas functions to automate the conversion of PDF documents to Excel format, streamlining data processing. Configured APIs to expose report data, facilitating seamless data access and integration. Developed a security awareness program that led to 100% developer participation in secure coding training. Data Analyst | Girnarsoft Autombiles Pvt Ltd, India • • • • • • Transformed and filtered financial data by using aggregating and filtering functions of SQL to improve the reporting process. React Native was used to create apps for iOS and Android, guaranteeing smooth cross-platform operation. Took part in regression and feature integration testing to ensure dependable and strong application performance. Created a dashboard with Power BI to help clients compare different stages in the application. Conducted quantitative and qualitative analyses to uncover opportunities for process improvements. Documented reliable data models, enhancing usability for data analysts and BI professionals. Junior Data Analyst | OYO, India • • • • • Feb 2020 – Sept 2021 Apr 2019 – Feb 2020 Designed and implemented dashboards and reports for non-technical stakeholders. Utilize tools like Power BI, SQL, Python, and Azure Databricks to analyze and model large datasets. Develop and present data-driven insights through compelling storytelling to support strategic initiatives and deliver tangible business value. Analyzed maintenance requirements, and designed, developed, deployed, and documented software components to meet project specifications and user needs. Managed software configurations using version control tools to maintain code integrity and track changes effectively. Software Engineer | Mobilyte Solutions Pvt Ltd, India May 2018 – Nov 2018 React Native Developer | Innow8 Apps, India Jun 2017 – Feb 2018 Software Developer | Kaushal Shala Foundation, India Aug 2015 – Jun 2017 Education MSc in Data Science | Leeds Beckett University Graduated: 2022 B.Tech. | Punjab Technical University Graduated: 2015 Key Projects & Achievements • • • Developed a predictive model that improved business forecasting accuracy by 40% Led a data-driven initiative that resulted in revenue growth Designed an automated reporting dashboard reducing manual effort by 25 hours per week Professional Development & Continuous Learning • Actively participated in cloud (AWS, Azure) conferences to stay updated with industry trends and best practices of their data analysis tools. • Continuous learning in emerging technologies and tools related to generating reports and dashboards. 2