Ayush Singh
Senior Analytics Consultant
Mumbai,MH
Summary
Detail-focused Data Analyst with knowledge in collecting, organizing, and maintaining the data. Proven to understand customer requirements and translate them into actionable project plans with a passion for SQL code generation, analytics, reporting, and business intelligence.
Overview
5
5
years of professional experience
3
3
years of post-secondary education
1
1
Certificate
Work History
Senior Analytics Consultant
Saama Technologies
Pune, Maharashtra
01.2022 - Current
- Led projects and analyzed data in SQL to identify opportunities for improvement.
- Analyzed transactions to build logical business intelligence model in Power BI and SQL for real-time reporting needs.
Data Analyst
M&G Global Services Private Limited
Mumbai, MAHARASHTRA
02.2020 - 01.2022
- Translated business requirements into meaningful KPIs and standardized reports/applications for business monitoring using Microsoft Power BI, SQL, Excel & SSIS.
- Design and develop various business intelligence and data solutions in Power BI and SQL.
- Source control and release management using Dev Ops of Power BI dashboard, SQL script and SSIS.
- Worked and supported projects using Agile methodology in JIRA confluence.
- Researched new or old ad hoc analytics reports and resolved issues regarding data flow into databases.
- Utilized Power BI data visualization tools to effectively communicate business insights.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Automated old reports and achieved 90% reduction in manual efforts using Power BI, Microsoft Excel, and SQL.
Ms SQL Developer
Xangars Solutions Private Limited
Mumbai, MAHARASHTRA
05.2019 - 01.2020
- Work with business analyst groups to ascertain their database reporting needs.
- Take database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports in Power BI and Excel.
Junior Associate - Software Developer
LogStar ERP India Private Limited
Mumbai, MAHARASHTRA
05.2017 - 04.2019
- Created complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision.
- Investigated and resolved data-level system issues to improve usability and functionality.
Education
Master of Computer Applications - Information Technology
TIMSCDR
Mumbai, MH 06.2014 - 06.2017
Skills
SQL Server development
Data Analytics
Microsoft Power BI
Data Visualization
SQL Server Integration Services (SSIS)
T-SQL coding
Defect tracking
Data formatting
Source control using DevOps
ETL
Data Modelling
Certification
Business Analyst using Power BI
Accomplishments
Awarded with the Q3 Customer Technology for excellence delivering multiple campaigns in a short period of time.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Senior Analytics Consultant
Saama Technologies
01.2022 - Current
Business Analyst using Power BI
09-2020
Data Analyst
M&G Global Services Private Limited
02.2020 - 01.2022
Ms SQL Developer
Xangars Solutions Private Limited
05.2019 - 01.2020
Junior Associate - Software Developer
LogStar ERP India Private Limited
05.2017 - 04.2019
Master of Computer Applications - Information Technology
TIMSCDR
06.2014 - 06.2017