Anoop Singh Bisht

Operations Associate

Noida, Uttar Pradesh, India20 yrs 2 mos experience

Key Highlights

Over 10 years of experience in data analysis.
Expert in automating reporting processes with VBA.
Proven track record of delivering business-critical reports.

Stackforce AI infers this person is a Data Analyst with expertise in automation and business reporting in consulting and healthcare sectors.

Contact

Skills

Core Skills

Data AnalysisData VisualizationAutomationBusiness Reporting

Other Skills

Ad Hoc AnalysisAnalytical SkillsAutoCADCommunicationData AnalyticsData CollectionData ValidationExcelExcel PivotExtract, Transform, Load (ETL)KPI ReportingMicrosoft OfficePerformance ManagementPerformance ReportingPower BI

About

Seasoned, compassionate and creative Data Analyst with 10+ years of industrial experience and 7+ years of relevant experience, well-versed in problem-solving, creating and managing various business complex reports and collaboration across teams. Successful at on-time delivery of reports business critical requirements, managing teams, progressing toward project milestones, quality assurance. PowerBI, Advance Excel, VBA & SQL are the key skills.

Experience

Ey

Assistant Manager | Financial reporting | Data Analytic and Visualization |

Nov 2024 – Present · 1 yr 4 mos · Gurugram, Haryana, India · Hybrid

● Supporting Lead Partner directly with daily sales and revenue reporting, ensuring timely and accurate insights to inform strategic decisions.
● Designed and maintained interactive dashboards using tools such as Power BI / Excel, improving visibility into sales performance and trends.
● Improved cross-partner communication and data consolidation, enhancing transparency and coordination in revenue forecast reporting.
● Collaborated with cross-functional teams to align reporting metrics and drive consistency in sales data across regions and service lines.
● Conducted ad-hoc analyses and created custom reports as requested by leadership to support key business initiatives and client pursuits.
● Developed and implemented VBA-based automation solutions to streamline reporting processes, significantly reducing manual effort and improving operational efficiency.
Key Achievements:
1) Got Emerging Extraordinary award in first 6 months tenure on creating an automation in Sales/Pipeline & Revenue visibility dashboard.

Power BIExcelVBASQLData VisualizationData Analysis

Accenture

Business Reporting and Governance Analyst

Mar 2022 – Oct 2024 · 2 yrs 7 mos · Noida, Uttar Pradesh, India · Hybrid

Business Reporting Analyst:
● SLA/ KPI reporting for the business. Ensuring all backend agreements for SLA’s are established, including Operational Level Agreements and Underpinning Contracts.
● Responsible for developing and maintaining the Service Catalogue, working with Service Transition, Service Management and individual product teams to ensure the service catalogue is kept up to date and current
● Creating the Monthly performance dashboard and decks on the business performance to share with leadership and client.
● Conducting the Monthly Business review meeting with client and internal leadership. Capturing and circulating the MOM accordingly to all attendees.
● Collecting the data from different sections of operation team and various other sources like, client tools, SQL servers etc.
● Creating mini bots (Macros) to automate existing process and reduce FTEs. Standardized the report format by extensive collaboration with different teams. Streamlined the process of data collections, scrapping and validation.
○ Automated the entire workflow of data collection and scraping using VBA/Excel. It validates the data format and catches data anomalies and saves a couple of days of effort of manually determining the issue.
○ Automated Graphical Reports generation with different facets and dimensions by uploading the data to generic datastore.
○ Generated trends Production, Quality, Attendance, Incentive, Inflow-Outflow on a Daily, Weekly & Monthly basis to help stakeholder to take business decisions.
○ Introduced UserForms to make the report generation framework user-friendly.
○ Creating new Reports in Power BI. Also converting old excel reports into PowerBI Platform.
● Ad Hoc Report Generation per management team requirements.
● Maintain and update existing VBA programs as per new changes.
● Build long-term relationships with internal colleagues for smooth participation in all deliverables.

SLA ReportingKPI ReportingService CataloguePower BIVBAExcel+2

Pacific bpo pvt. ltd. – an access healthcare company

Sr. MIS Executive

Jul 2019 – Feb 2022 · 2 yrs 7 mos · Noida, Uttar Pradesh, India

Gather business requirements from management and collaborating with multiple teams
Standardized the report format by extensive collaboration with different teams. Streamlined the process of data collections, scrapping and validation.
Automated the entire workflow of data collection and scraping using VBA/Excel. It validates the data format and catches data anomalies and saves a couple of days of effort of manually determining the issue.
Automated Graphical Reports generation with different facets and dimensions by uploading the data to generic datastore.
Generated trends Production, Quality, Attendance, Incentive, Inflow-Outflow on a Daily, Weekly & Monthly basis to help stakeholder to take business decisions.
Introduced userforms to make the report generation framework user-friendly.
On specific projects, managed and mentored the team of 2-3 MIS executives.
Ensure the timely delivery of all key performance metrics per the client SLA.
Ad Hoc Report Generation per management team requirements.
Maintain and update existing VBA programs per new changes.
Demonstrated/Learned Skills: VBA, Requirement Gathering and Analysis, Microsoft Excel, Mentoring, Automation.