Ayan Gupta
Data Analyst
Summary
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
3
3
years of professional experience
3
3
Certifications
Work History
Data Analyst/ Business Analyst
Database Administrator
Wipro Technologies
11.2021 - Current
- Trained junior team members on best practices for database administration, promoting a culture of continuous learning within the organization.
- Built databases and table structures for web applications.
- Modified databases to meet needs and goals determined during planning process.
- Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability.
Education
Bachelor of Computer Applications - Information Technology
Bishop Westcott School
Kanpur, India08.2021
Skills
SQL (SQL Server, MySQL)
Microsoft Power BI
Excel (VLookup, Conditional Formatting, Pivot Tables)
Microsoft Azure (DataBricks, Azure Data Lake, Azure Data Warehouse)
Python (Pandas, NumPy, SciPy, MatPlotLib)
Data Analysis
Data Visualization and Presentations
Projects
Power BI Project: Chocolate Sales Dashboard
Overview:Built an interactive Power BI dashboard using MySQL data.
Key Features:
- DAX Measures: For sales, boxes sold, and shipments.
- Dynamic Visuals: Slicers, filters, and custom titles.
Impact:Enhanced sales strategy through data-driven insights and an intuitive dashboard.
Certification
Microsoft Power BI
Timeline
Database Administrator
Wipro Technologies
11.2021 - Current
Data Analyst/ Business Analyst
Bachelor of Computer Applications - Information Technology
Bishop Westcott School