Aishwarya Agnihotri
Summary
Bringing top-notch abilities in competitor analysis and business intelligence development through various tools to promote company advancements and boost performance. Proactive and industrious in achieving targets by leveraging BI data and producing well-planned recommendations. Experienced leader in leading teams of analysts across projects and domains.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Business Intelligence Consultant
Team Computers
07.2018 - 01.2020
- Created an integrated lead management system focusing on analysis of lead source/campaign performance and lead conversion ratio
- Analyzed sales team performance and created a better lead-generating and follow-up system by providing a working model with automation of data processes
- Developed data models for various departments, created data stages, warehouse, and marts for financial analysis, resulting in cost-cutting and better investment
- Developed an Employee Attrition Prediction Dashboard using Alteryx integration with R Predictive Tool, analyzing factors affecting attrition rate
- Created a Performance and Market Share Analysis for print media, providing insights on brand value, market share trend, and revenue and volume trends.
Senior Product Analyst
Boston Consulting Group
09.2021 - Current
- Led reporting use cases for financial tools and integration with Business Intelligence warehouse and digital products
- Worked with key finance stakeholders and application owners to gather and document business requirements
- Defined the form, content, and capabilities provided in our BI solution and identified key changes and impacts to existing reporting capabilities and products
- Developed comprehensive implementation plans and delivered outputs as defined in project goals and objectives
- Analyzed gaps between prioritized analytical capabilities and our financial application's data models, generating possible solution options
- Worked on multiple data sources, creating practical data models to support analytical analysis, including data mapping and translation from source to target state
- Provided support to a diverse worldwide user base while partnering with the technical team to troubleshoot data issues and redesign processes.
Senior Lead Analyst
American Express
01.2020 - 09.2021
- Designed and implemented Sales Incentive Automation using Alteryx Designer, reducing manual effort by creating data warehouse and dynamic workflows
- Created Business Performance tracker dashboard for leadership, automated on Tableau Server integrated with Alteryx for real-time data source
- Led a team of four analysts for Alteryx implementation, reducing process time drastically for Global Commercial Services
- Created Business Charge Volume generation performance dashboard for three global markets with YOY comparison and drill-down capabilities
- Predicted travel bookings for 2020 using ARIMA & ETS in Alteryx Predictive models, utilized by Global Business Travel Services team.
Graduate Engineer Trainee
Gannon Dunkerley & Co Ltd
09.2016 - 06.2018
- Analyzed Tax Impact on procurement (Pre & Post GST scenario) and created Tableau Dashboards
- Automated the Procurement Process through the development of an eProcurement Portal integrated with Oracle ERP
- Coordinated with development to ensure timely delivery, supported documentation after implementation, and deployed an Intranet Portal across divisions.
Education
HSC -
Air Force Golden Jubilee
B.Tech Plus M.Tech Dual Degree - Electrical Engineering
Gautam Buddha University
01.2016
Skills
- Business Analysis
- Data Warehousing
- Data dashboard design
- Business Intelligence Roadmap Design
- Business Intelligence Analysis
- Project Management
- KPI Tracking
- Specifications Documentation
- Gap analysis
- Data Acquisition
- Variance Analysis
- Requirements Analysis
- Analytical Skills
- Forecasting and planning
- Business Requirements
Certification
- Tableau Desktop Certified
- Alteryx Advanced and Core certified
Accomplishments
- Author of “Efficient Face Recognition System Based on PCA and Extended Biogeography Based Optimization Technique”, Indian Journal of Industrial & Applied Mathematics (IJIAM) [issue 7(2)] – DOI: 10.5958/1945-919X.2016.00024.4
- “Face Recognition System Comparison between PCA and Extended Biogeography Based Optimization Technique”, IICIP held in Delhi Technical University
- Top All India Rank 10 in National Creativity Aptitude Test (NCAT-2014) organized by IIT Delhi
- Best Performer of Quad 1, 2023
- IStepUp Recognition, Client-sponsored recognition for deliverables, Jun 2020
- High Business Impact Award, Business Management Group Meet, Feb 2019
Timeline
Senior Product Analyst
Boston Consulting Group
09.2021 - Current
Senior Lead Analyst
American Express
01.2020 - 09.2021
Business Intelligence Consultant
Team Computers
07.2018 - 01.2020
Graduate Engineer Trainee
Gannon Dunkerley & Co Ltd
09.2016 - 06.2018
HSC -
Air Force Golden Jubilee
B.Tech Plus M.Tech Dual Degree - Electrical Engineering
Gautam Buddha University
Similar Profiles
Nikita MestryNikita Mestry
IT Service Coordination at Team ComputersIT Service Coordination at Team Computers
PANKAJ GOSAIPANKAJ GOSAI
Account Manager at Team ComputersAccount Manager at Team Computers
Rashika MishraRashika Mishra
Business Analyst and Product Owner at Team ComputersBusiness Analyst and Product Owner at Team Computers