Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Timeline
BusinessAnalyst
Abhijiit Ray

Abhijiit Ray

Bengaluru,Karnataka

Summary

Seasoned Business Analyst with over 5 years of experience in IT and HR domains, proficient in Advanced Excel, VBA Automation, Power BI, Python, and MS Office tools. Expertise in capturing and translating complex business requirements, user acceptance testing, process optimization, and end-user training. Adept at leveraging technical acumen and business insights to drive strategic decision-making and system enhancements. Seeking to transition into AI Prompt Engineering, Operations, or techno-functional roles to utilize and expand the skill set in a dynamic environment. Strong analytical and problem-solving skills, with a proven track record in IT transformation, business intelligence, and customer engagement. Skilled in data visualization, Excel automation, time management, and multitasking. Excellent communication and collaboration abilities, maintaining high professional standards and creativity in problem-solving.

Overview

5
5
years of professional experience
1
1
Certification
2
2
Languages

Work History

Business Analyst

Allegis Global Solutions (AGS)
07.2022 - Current
  • Partnered with clients to deliver bespoke data-driven HR solutions and insights
  • Extracted actionable insights from HR data, bolstering strategic decision-making
  • Led numerous VBA projects, crafting client-specific solutions and ensuring timely completion
  • Developed modifiable Applicant Tracking System (ATS) in Excel, optimizing client hiring processes
  • Facilitated communication between clients, tech teams, and internal stakeholders
  • Recognized for outstanding performance and contributions by global leadership team
  • Automated Excel reports via VBA, reducing manual efforts by 50%
  • Created interactive dashboards in Power BI for executive insights
  • Conducted user acceptance testing, ensuring system upgrades met business expectations
  • Improved HR processes, enhancing operational efficiency by 30%
  • Provided end-user training on new system functionalities and Office Tools.
  • Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
  • Performed gap analysis between existing systems or processes and desired state, identifying areas for improvement or enhancement.
  • Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.
  • Improved business processes by analyzing current practices and recommending optimization strategies.
  • Optimized workflow processes to enhance overall productivity and achieve operational excellence.
  • Interacted with internal customers to understand business needs and translate into requirements and project scope.
  • Generated business intelligence reports to inform strategic decision-making.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Developed customized reports, summarizing and presenting data in visually appealing format.
  • Created dashboards to monitor and track key performance indicators.
  • Created data models to support decision-making processes.
  • Deployed predictive analytics models to forecast future trends.

Business Operations Analyst

Hewlett-Packard (HP) Inc
12.2020 - 07.2022
  • Led team of 3 analysts focused on US Region, delivering data-driven insights and reports
  • Managed team performance, identified issues, and optimized processes
  • Conducted meetings to address challenges and drive resolutions
  • Reported on trends in distributor, retailer, and reseller networks
  • Generated Big Data reports for L1 and L2 support, ensuring issue resolution
  • Monitored and audited sales across various channels
  • Acted as primary contact for data issues, collaborating with stakeholders for resolution
  • Served as SME for internal tools, overseeing enhancements and new features
  • Managed comprehensive testing cycles, ensuring alignment with business needs
  • Deployed data to data warehouse, ensuring integrity and accuracy
  • Enhanced reports for Microsoft support businesses and delivery partners
  • Updated and maintained KPI-driven channel dashboard
  • Developed and instated channel inventory and business analytics policies
  • Collaborated with IT to introduce new reports for business decision-making.
  • Designed customized data collection models for specific visualization tasks.
  • Participated actively in stakeholder meetings, presenting data-driven insights and recommendations to support business growth initiatives.
  • Mentored junior analysts in advanced statistical techniques to enhance their skillsets in developing meaningful business insights.

Operations Analyst

Collabera Inc
01.2019 - 12.2020
  • Supported comprehensive HR programs and performed related duties
  • Managed talent acquisition, sourcing, and recruitment processes
  • Enhanced data collection procedures for building analytical capabilities
  • Prepared regular reports and maintained existing dashboards
  • Collaborated with HR Service Centers and Divisional HR Business Partners.

Education

Masters in Computer Applications (M.C.A) -

Gandhi Institute For Technology [GIFT]
Bhubaneswar, Odisha
01.2019

Bachelors in Computer Application (B.C.A) -

CMT
Bhubaneswar, Odisha
06.2016

ICSE -

St Xavier's High School
Puri, India
03.2011

Skills

  • PowerBI
  • Python, Sql- Proficient
  • Creative solutions
  • Microsoft Excel, VBA, Power Query
  • Client Relationship Management
  • Time Management
  • Attention to Detail
  • Problem-Solving
  • Multitasking Abilities
  • Excellent Communication
  • Critical Thinking
  • Operational Efficiency

Certification

  • Certified in Master's in Data Analyst from Simplilearn
  • Certified in Microsoft PL-300 PowerBI Associate
  • CBAP - Certified Business Analysis Professional(On going)

Projects

Portfolio Dashboard Development (AGS), Collaborated with a team to extract vital employment data from the Snowflake database for diverse clients spanning a 5-year period. Designed and implemented a dynamic PowerBI dashboard showcasing client employment trends and metrics. Key features included insights into active headcount, new starts, impending contract ends, and a retrospective performance analysis. Empowered clients with real-time data for informed decision-making, trend identification, and effective workforce planning., Snowflake Database, PowerBI

Timeline

Business Analyst

Allegis Global Solutions (AGS)
07.2022 - Current

Business Operations Analyst

Hewlett-Packard (HP) Inc
12.2020 - 07.2022

Operations Analyst

Collabera Inc
01.2019 - 12.2020

Masters in Computer Applications (M.C.A) -

Gandhi Institute For Technology [GIFT]

Bachelors in Computer Application (B.C.A) -

CMT

ICSE -

St Xavier's High School
Abhijiit Ray