Akshat Sharma
Senior Analyst
Summary
Highly analytical and solution-oriented Senior Analyst with 8+ years of experience in data analysis, visualization, and business intelligence. Expertise in Agile methodologies, Scrum practices, and advanced tools like SQL Server, Power BI, and Tableau. Proven ability to lead cross-functional teams, design efficient data pipelines, and drive data-driven decisions. Actively pursuing Certified ScrumMaster (CSM) certification to transition into a Scrum Master role.
Results-oriented Analyst skillful in managing and breaking down large volumes of information. Proactive at heading off issues in operations, workflow and production by uncovering trends affecting business success.
Overview
10
10
years of professional experience
6
6
years of post-secondary education
5
5
Certifications
2
2
Languages
Work History
Senior Analyst
Accenture
01.2023 - Current
- Developed and published Power BI dashboards based on stakeholder requirements, enhancing data accessibility and decision-making
- Integrated data from Azure Data Factory (ADF) pipelines into SQL Server to ensure up-to-date reporting
- Created and optimized SQL views and queries for Power BI visualizations and analyses
- Implemented design modifications in Power BI reports, conducting impact analysis to ensure seamless production
- Scheduled and managed report refreshes, troubleshooting errors to maintain data integrity
- Provided mentorship and technical guidance to team members, fostering a collaborative work environment
- Utilized DAX functions, calculated columns, and Power Query for customized Power BI visualizations
- Led daily scrum meetings, identifying roadblocks and strategizing for project success
- Mentored junior analysts, fostering professional development while enhancing overall team performance.
- Collaborated with cross-functional teams to identify areas of improvement, leading to increased operational effectiveness.
- Enhanced team productivity by streamlining workflow processes and implementing time-saving strategies.
Data Analyst
Wipro Ltd
05.2022 - 01.2023
- Developed SQL queries to extract and analyze data, meeting team and program requirements
- Led daily scrum meetings to address project roadblocks and monitor progress
- Analyzed operational quality and productivity, maintaining dashboards that tracked key metrics
- Created dashboards that provided weekly and monthly trends, facilitating informed decision-making
- Participated in weekly client calls to discuss dashboard updates and evolving business needs
- Executed Root Cause Analysis (RCA) scripts to ensure timely task updates
BI Analyst and Developer
Trantor Software Pvt Ltd
06.2016 - 04.2022
- Developed interactive Tableau dashboards for stakeholders, integrating data from various sources
- Conducted data modeling to support analysis and visualization needs
- Performed quality checks on dashboards, maintaining documentation on test results
- Started working with Alteryx to create workflows for routine processes, enhancing efficiency
- Led daily scrum meetings to track development progress and document meeting outcomes
- Conducted requirement analysis during weekly stakeholder calls to improve visibility on changes
Software Engineer
01.2015 - 01.2016
- Provided AWS support, running 24/7 batch jobs and monitoring infrastructure alerts
- Led a team of 6, assigning tasks and ensuring timely completion to prevent business disruptions
- Conducted smoke and functional testing of websites, maintaining detailed documentation
- Developed Tableau and Excel visualizations to provide business insights on sales data
- Executed RCA on unique alerts and assigned tickets to developers via JIRA
Education
B.Tech - Computer Science Engineering
CHITKARA UNIVERSITY
01.2011 - 01.2015
12th (Non-Medical) - undefined
DAV Senior Public School
01.2010 - 01.2011
10th - undefined
DAV Senior Public School
01.2009 - 01.2010
Skills
Power BI
SQL Server
Python (Basic)
AWS
DAX
Power Query
Excel
Client management
Data analysis
Stakeholder communication
Report preparation
Business intelligence
Tableau software
Scrum
Jira
Agile Methodologies
Leadership
Problem-Solving
Mentorship
Manual Testing
RCA
Certification
Certified ScrumMaster (CSM), Pending Completion, 12/24
Timeline
Senior Analyst
Accenture
01.2023 - Current
Data Analyst
Wipro Ltd
05.2022 - 01.2023
BI Analyst and Developer
Trantor Software Pvt Ltd
06.2016 - 04.2022
Software Engineer
01.2015 - 01.2016
B.Tech - Computer Science Engineering
CHITKARA UNIVERSITY
01.2011 - 01.2015
12th (Non-Medical) - undefined
DAV Senior Public School
01.2010 - 01.2011
10th - undefined
DAV Senior Public School
01.2009 - 01.2010