Drawing, Painting, Cooking and Playing football
Amar Shanbhag
Senior Business Analyst
Hyderabad
Summary
Dynamic Senior Business Analyst with expertise in SQL and dashboard optimization. Proven track record in enhancing data-driven decision-making through innovative reporting solutions. Adept at collaborating with cross-functional teams, ensuring data integrity, and delivering actionable insights that drive effectiveness and improve performance metrics. Strong analytical and leadership skills.
Overview
10
10
years of professional experience
7
7
years of post-secondary education
Work History
Senior Business Analyst
Tech Mahindra
08.2024 - Current
- Lead the end-to-end design, development, and implementation of interactive and user-friendly dashboards and reports using PLX and Looker platforms. This includes defining key metrics, selecting appropriate visualizations, and ensuring intuitive navigation.
- Optimize dashboard performance and responsiveness, ensuring efficient data loading and calculation.
- Design, develop, and implement new databases or data models to support specific analytical needs, ensuring data integrity and optimal performance.
- Proactively identify, clean, and transform raw data from various sources to ensure accuracy, consistency, and usability for reporting and analysis.
- Maintaining comprehensive documentation of data sources, definitions, transformations, and data models to ensure data literacy across the organization.
- Providing in-depth weekly, monthly, and quarterly analysis of various vendor-wise trends, including performance and quality scores.
Business Consultant
Quation Solutions Pvt. Ltd.
04.2023 - 08.2024
- Analyzing and providing Marketing campaign effectiveness.
- Accessing customer purchase behavior on demographic, geographic and product bases.
- Worked on strategic market planning and data analysis to help customer segmentation for campaigns.
- Reviewing campaign effectiveness and highlighting trends, performance and recommendations to be used in future campaigns.
Business Consultant
Convergytics Solutions Pvt. Ltd.
07.2022 - 04.2023
- Creating customer base for campaigns for Brands to target depending on requirements.
- Collaborating with brand managers, marketing heads, and stakeholders to coordinate campaign activities by managing data.
- Responsible for identifying target groups through data analysis through SQL.
Microsoft Functional Consultant
Sonata Software Ltd
12.2021 - 07.2022
- Assisting Microsoft Dynamics 365 users with user sign in issues, Storage, migration of environments.
- Troubleshooting and creating requests for escalation to technical team for Power Platform Admin center.
Active Directory Administrator
Wipro
02.2021 - 06.2021
- Handling active directory and domain related responsibility for ICICI Bank process.
- Providing access to employees and assisting employees with access related issues.
Team Leader – B2C/B2B Customer Support
Rail Europe India Pvt. Ltd.
11.2015 - 02.2021
- Trained 50+ members on required process, websites and booking system.
- Reporting and updating management with team performance, issues and changes and handling escalations and solving issues on customer end.
- Conducting monthly performance reviews, feedbacks and coaching.
Education
Post Graduate Diploma - Management - Marketing (Hybrid Learning)
Welingkar Institute of Management
01.2017 - 12.2018
International MBA - Travel and Tourism
Kuoni Academy
06.2014 - 05.2016
Bachelor of Commerce - undefined
St. Andrews College of Arts, Science and Commerce
06.2011 - 05.2014
Skills
- SQL
- Excel/Google sheets
- PLX Scripts & Dashboards
- Looker Studio
Courses
- Exploring Data with Looker (Google Cloud Skills Boost).
- Analyzing and Visualizing Data with Looker (Google Cloud Skills Boost).
- Google Sheets (Google Cloud Skills Boost).
- Advanced Google Sheets (Google Cloud Skills Boost).
- Complete SQL Bootcamp 2022 (Udemy)
Interests
Timeline
Senior Business Analyst
Tech Mahindra
08.2024 - Current
Business Consultant
Quation Solutions Pvt. Ltd.
04.2023 - 08.2024
Business Consultant
Convergytics Solutions Pvt. Ltd.
07.2022 - 04.2023
Microsoft Functional Consultant
Sonata Software Ltd
12.2021 - 07.2022
Active Directory Administrator
Wipro
02.2021 - 06.2021
Post Graduate Diploma - Management - Marketing (Hybrid Learning)
Welingkar Institute of Management
01.2017 - 12.2018
Team Leader – B2C/B2B Customer Support
Rail Europe India Pvt. Ltd.
11.2015 - 02.2021
International MBA - Travel and Tourism
Kuoni Academy
06.2014 - 05.2016
Bachelor of Commerce - undefined
St. Andrews College of Arts, Science and Commerce
06.2011 - 05.2014
Similar Profiles
Sandeep GinkaSandeep Ginka
Product Cost Engineer at Tech Mahindra Ltd., India & Tech Mahindra (America) Inc. USAProduct Cost Engineer at Tech Mahindra Ltd., India & Tech Mahindra (America) Inc. USA
Hemanth Kumar BangaruHemanth Kumar Bangaru
Team Lead at Tech Mahindra, Tech Mahindra Pvt LtdTeam Lead at Tech Mahindra, Tech Mahindra Pvt Ltd
Vinita HasabeVinita Hasabe
VAS Manager at Tech Mahindra Tech MahindraVAS Manager at Tech Mahindra Tech Mahindra
VISHNU RAMKISAN INGOLEVISHNU RAMKISAN INGOLE
Senior Network Engineer at Tech Mahindra, Payroll by RLAB (Client- Mahindra & Mahindra)Senior Network Engineer at Tech Mahindra, Payroll by RLAB (Client- Mahindra & Mahindra)
Bharath Kumar KondetiBharath Kumar Kondeti
Senior Drupal Developer at SpecbeeSenior Drupal Developer at Specbee