Vikas Jangam
Pune
Summary
. Logical Data Analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with 1.4 years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Analyst
Bajaj Finserv
Pune
08.2023 - Current
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Gathered requirements from stakeholders to design data models and reports.
- Leveraged SQL queries to extract, transform and load data into databases.
- Optimized existing database structures for better performance on analytics tasks.
- Tracked sales data related to products sold in order to generate reports for management review.
- Developed automated reporting processes using SQL queries to streamline data extraction tasks.
- Created automated reports to visualize financial performance metrics.
- Designed and implemented interactive visualizations using Power BI.
- Built various dashboards with interactive visualizations using Power BI.
- Integrated multiple sources of structured and unstructured datasets into a single platform.
- Created stored procedures for automating periodic tasks in SQL Server.
- Configured SSRS reports by creating report models, parameterized reports and linked reports.
- Developed new reports, updated existing reports and created routine reports based on defined requirements.
- Developed the reports using the advanced formulas and functions within Excel, such as VLOOKUP, SUMIFS, COUNTIFS.
Business Analytics Masters (Internship)
Ineuron.ai
Pune
05.2022 - 08.2022
- Developed reports using SQL queries to track progress against key performance indicators.
- Optimized existing queries for better performance using SQL query tuning techniques.
- Designed complex reports using SQL Server Reporting Services.
- Analyzed business requirements and translated them into logical data models.
- Integrated multiple data sources into one unified view using views or joins in SQL queries.
- Developed and maintained data visualization dashboards for senior management.
- Created automated reports to visualize financial performance metrics.
- Designed and implemented interactive visualizations using Tableau, Power BI, and other tools.
Back Office Executive
Concentrix Daksh Private LImited.
Pune
09.2021 - 04.2022
- Compiled reports using Excel spreadsheets.
- Maintained database of customer information using Excel spreadsheets.
- Created weekly, monthly, quarterly reports utilizing Excel spreadsheets.
- Created detailed reports on operational performance metrics using Excel functions.
Education
Bachelor of Science - Statistics
Sadguru Gagde Maharaj College,Karad
Karad03-2020
HSC
Vidyamandir Jr College of Science, Urun Islampur
Urun Islampur03-2017
Skills
- Microsoft SQL
- SQL and Databases
- Azure databricks
- Azure data lake
- Power BI
- Excel
- Database Programming and SQL
- Statistical Analysis
- Reporting Tools
- Structured query language (SQL)
Certification
- Buisiness Analytics Masters
Languages
Marathi
First Language
English
Elementary (A2)
A2
Hindi
Upper Intermediate (B2)
B2
Timeline
Data Analyst
Bajaj Finserv
08.2023 - Current
Business Analytics Masters (Internship)
Ineuron.ai
05.2022 - 08.2022
Back Office Executive
Concentrix Daksh Private LImited.
09.2021 - 04.2022
Bachelor of Science - Statistics
Sadguru Gagde Maharaj College,Karad
HSC
Vidyamandir Jr College of Science, Urun Islampur
Similar Profiles
KARTIK D BHATTKARTIK D BHATT
Cluster Head at Bajaj Finance Limited (Bajaj Finserv)Cluster Head at Bajaj Finance Limited (Bajaj Finserv)
Vijay BansalVijay Bansal
Area Credit Manager at BAJAJ FINSERV LENDING (Bajaj Finance Pvt. Ltd)Area Credit Manager at BAJAJ FINSERV LENDING (Bajaj Finance Pvt. Ltd)
RAJESH RRAJESH R
Senior Area Manager - Collections at Bajaj Finserv, Bajaj Finance LtdSenior Area Manager - Collections at Bajaj Finserv, Bajaj Finance Ltd
Shyam KhamkarShyam Khamkar
Unit Manager - Data Science and Analytics at Bajaj FinservUnit Manager - Data Science and Analytics at Bajaj Finserv
Vaibhav SuryawanshiVaibhav Suryawanshi
UI Developer at Xcaliber Infotech Private LimitedUI Developer at Xcaliber Infotech Private Limited