Hi, I’m
Aditya Guuin
Senior BI Engineer
Pune
Summary
Dynamic and goal-focused professional with a proven track record in exceeding revenue objectives and driving business growth. Skilled in strategic planning, networking, and lead development to foster sustainable success. Expertise in customer relationship management, team leadership, and innovative business planning. Recognized for high productivity, exceptional communication, negotiation, and problem-solving abilities to achieve sales targets and accelerate business growth.
Overview
16
years of professional experience
4031
years of post-secondary education
6
Certifications
Work History
MagicOrange Pvt Ltd
Senior BI Engineer
03.2024 - Current
Job overview
- 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.
Accenture Pvt Ltd
Application Development Team Lead
07.2021 - 03.2024
Job overview
- 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.
LTI - Larsen & Toubro Infotech
Data Specialist – Business Intelligence
08.2019 - 07.2021
Job overview
- 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.
A.P. Moller -Maersk Global Service Centre
Senior Process Analyst – Business Intelligence
12.2017 - 03.2019
Job overview
- 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.
Tata Consultancy Services Limited
Business Process Lead – Development Process
08.2016 - 12.2017
Job overview
- 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.
Capita India Private Ltd
Analyst – BPMI Development Process
07.2014 - 05.2016
Job overview
- 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.
BNY Mellon - Bank Of New York
Operation Executive – MIS Reporting Team
01.2011 - 07.2014
Job overview
- 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.
Mphasis Limited - Information Technology
Customer Care Executive – Outbound Process
10.2008 - 01.2011
Job overview
- 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
We School - Welingkar Education - Information TechnologyMumbai, India
MBA from Information Technology
10-2021
Bachelor of Commerce (Nagpur, India)Nagpur, India
BBA from Accounting And Finance
06-2008
Skills
Microsoft Fabric, Microsoft Power BI, Tableau, and Business Intelligence
Certification
Generative AI Overview for Project Managers
Languages
- English
- Hindi
- Marathi
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
We School - Welingkar Education - Information Technology
MBA from Information Technology
06.2021
Bachelor of Commerce (Nagpur, India)
BBA from Accounting And Finance
06.2008
Similar Profiles
Aditya GuuinAditya Guuin
Senior BI Engineer at MagicOrange Pvt LtdSenior BI Engineer at MagicOrange Pvt Ltd
Karan ShahKaran Shah
Senior Engineer at MagicOrangeSenior Engineer at MagicOrange
Randhir Kumar PrasadRandhir Kumar Prasad
Stacker at Engineering and Allied Services Pvt. Ltd, Lift & Shift India Pvt. Ltd, Roadwings International Pvt. Ltd, Western Carriers India Pvt. Ltd, Tractor India Pvt. Ltd, Transworld Terminal Pvt. LtdStacker at Engineering and Allied Services Pvt. Ltd, Lift & Shift India Pvt. Ltd, Roadwings International Pvt. Ltd, Western Carriers India Pvt. Ltd, Tractor India Pvt. Ltd, Transworld Terminal Pvt. Ltd
Anurag PandeyAnurag Pandey
Circle Head at Square YardsCircle Head at Square Yards
KHUSHBOO RELANKHUSHBOO RELAN
Data Analyst Intern at LabmentixData Analyst Intern at Labmentix