Aditya Guuin
Pune
Summary
Passionate BI Developer with a proven track record in designing and implementing innovative solutions for complex business challenges, while embracing opportunities for growth. Skilled in diverse programming languages, optimizing system performance, and collaborating with teams to deliver high-quality results on time.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Senior BI Engineer
MagicOrange Pvt Ltd
Pune
03.2024 - Current
- Expertise in managing Azure DevOps branches, pipelines, and repositories, ensuring smooth code integration and continuous delivery through effective branch mergers, and version control strategies.
- Proficient in designing user stories based on model specifications, driving seamless layout changes, and delivering high-quality, scalable solutions in collaboration with cross-functional teams.
Application Development Team Lead
Accenture Pvt Ltd
Pune
07.2021 - 03.2024
- Proficiently configured SSAS and SSIS, enabling seamless integration with Power BI, and optimizing data visualization through 15+ dynamic, stakeholder-focused dashboards.
- Expert in crafting and redesigning Power BI dashboards, leveraging SSAS Cube connections to enhance usability, deliver valuable insights, and align with business objectives.
- Demonstrated mastery in SQL and DAX, driving efficient data retrieval and analysis, while successfully managing high-impact Power BI projects within tight deadlines.
Data Specialist – Business Intelligence
LTI - Larsen & Toubro Infotech
Mumbai
08.2019 - 07.2021
- Expert in analyzing process requirements and delivering impactful solutions through SQL, Power BI, Tableau, and advanced Excel dashboards, seamlessly aligning with business objectives.
- Proficient in query optimization, data modeling, and coding for advanced analytics, reporting, and visualization using SQL, DAX, Tableau, and VB.NET/VBA.
- Skilled in creating dynamic Excel dashboards with advanced formulas, integrating SQL connections to Oracle, Microsoft Access, and other databases, and driving data-driven insights.
- Corrected data errors and entered missing information into new data parcels being processed for clients, maintaining compliance with guidelines.
Senior Process Analyst – Business Intelligence
A.P. Moller -Maersk Global Service Centre
Pune
12.2017 - 03.2019
- Built a strong Power BI dashboard using DAX queries, SQL, MS Excel, and MS Access data for precise and compelling visualization.
- Analyzed business needs, crafted reports with macros, advanced Excel formulas, and stakeholder-specified methodologies. Led the creation of a detailed data module for Maersk logistics stakeholders.
- Performed root cause analysis on production issues related to process failures.
- Provided guidance on best practices for developing, documenting, and executing business processes.
Business Process Lead – Development Process
Tata Consultancy Services Limited
Mumbai
08.2016 - 12.2017
- Crafted queries in Power BI, Tableau, Excel Reporting, and Power Pivot to drive impactful business intelligence insights and reporting excellence.
- Achieved success in projects by utilizing Microsoft BI tools (SSAS, SSIS, SSRS), driving advanced data analysis and empowering strategic decision-making.
- Utilized advanced Excel techniques, including SQL-based OLAP data cubes and VBA macros, to streamline data extraction, manipulation, and comprehensive reporting.
Analyst – BPMI Development Process
Capita India Private Ltd
Pune
07.2014 - 05.2016
- Developed elegant user forms and advanced automation solutions using VBA Macro, Excel, and MS Access, streamlining workflows and enhancing client deliverables.
- Designed and maintained MS Access databases, delivering impactful data analysis, automation reports, and polished presentations to onshore teams.
- Led six teams with 1200+ advisors in the UK, implementing VBA Macro-based automations to enhance efficiency.
Operation Executive – MIS Reporting Team
BNY Mellon - Bank Of New York
Pune
01.2011 - 07.2014
- Designed user-friendly forms in Excel and Access, integrating with SQL, Access, and Excel databases to optimize workflows and data management.
- Delivered end-to-end VBA Macro automation solutions for UK and US clients, streamlining reporting processes and ensuring timely delivery of MIS reports and ad hoc tasks.
Customer Care Executive – Outbound Process
Mphasis Limited - Information Technology
Pune
10.2008 - 01.2011
- Managed outbound calls for home mortgage and security lending, ensuring exceptional customer satisfaction through direct onshore and U.S. third-party interactions.
- Delivered actionable insights through comprehensive MIS reports, enhancing decision-making processes.
Education
MBA - Information Technology
We School - Welingkar Education - Information Technology
Mumbai06-2021
BBA -
Bachelor of Commerce (Nagpur, India)
Nagpur, Maharashtra06-2008
Skills
- Microsoft Fabric, Microsoft Power BI, Tableau, and Business Intelligence
- SQL, Google Big Data, AWS, and Azure
- Advanced Excel and MIS Reporting
- MS Access, MS Word, and MS PowerPoint
- Software development
Certification
- Analyzing and Visualizing Data with Microsoft Power BI
- Scrum Foundation Professional Certificate
- Lean Six Sigma Yellow Belt Certification
- Project Management Essentials Certified
- Exam 461: Querying Microsoft SQL Server 2012/2014
Languages
- English
- Hindi
Hobbies and Interests
A passionate food enthusiast with a keen interest in exploring diverse culinary experiences, both locally and internationally. Skilled in the art of cooking, I am always eager to discover new flavors and culinary techniques from various cultures.
Timeline
Senior BI Engineer
MagicOrange Pvt Ltd
03.2024 - Current
Application Development Team Lead
Accenture Pvt Ltd
07.2021 - 03.2024
Data Specialist – Business Intelligence
LTI - Larsen & Toubro Infotech
08.2019 - 07.2021
Senior Process Analyst – Business Intelligence
A.P. Moller -Maersk Global Service Centre
12.2017 - 03.2019
Business Process Lead – Development Process
Tata Consultancy Services Limited
08.2016 - 12.2017
Analyst – BPMI Development Process
Capita India Private Ltd
07.2014 - 05.2016
Operation Executive – MIS Reporting Team
BNY Mellon - Bank Of New York
01.2011 - 07.2014
Customer Care Executive – Outbound Process
Mphasis Limited - Information Technology
10.2008 - 01.2011
MBA - Information Technology
We School - Welingkar Education - Information Technology
BBA -
Bachelor of Commerce (Nagpur, India)
Similar Profiles
GAYATHRI DEVIGAYATHRI DEVI
Assistant of Regulatory Affair at VKL SEASONING PVT. LTD. / KEYA FOODS INTERNATIONAL PVT. LTDAssistant of Regulatory Affair at VKL SEASONING PVT. LTD. / KEYA FOODS INTERNATIONAL PVT. LTD
Anum HasanAnum Hasan
Head of Department -Software Project Management & Business Development at Appedology (Pvt.) Limited - New Name of Protégé Global (Pvt.) LimitedHead of Department -Software Project Management & Business Development at Appedology (Pvt.) Limited - New Name of Protégé Global (Pvt.) Limited
Thiyaga Lakshmi VellaiSamyThiyaga Lakshmi VellaiSamy
Senior Software Implementation Specialist at DigiSME Pvt Ltd (a) Majulah Info-Tech Pvt LtdSenior Software Implementation Specialist at DigiSME Pvt Ltd (a) Majulah Info-Tech Pvt Ltd