VAMSHOTHAM REDDY C
Data Science & Analytics Professional
Bengaluru, IN.Work
Ai Variant
|MIS Intern
Bengaluru, Karnataka, India
→
Summary
Managed comprehensive MIS reporting and data analytics across key projects, including Industrial Combustion Energy Use and Salesforce CRM, to drive operational efficiency and data-driven decision-making.
Highlights
Automated daily, weekly, and monthly MIS reports using Excel, SQL, and Power BI, reducing manual efforts by 40%.
Developed and maintained comprehensive daily, weekly, and quarterly MIS reports and dashboards for sales and non-sales teams, enhancing data accessibility and strategic decision support.
Designed and implemented advanced Power BI dashboards with complex visualizations (Bar-in-Bar, Bullet Graphs, Box Plots) to enhance data interpretation and stakeholder insights.
Wrote, optimized, and executed complex SQL queries, including Joins and schema alterations, to facilitate efficient data import/export and backend operations.
Streamlined data integrity by cleaning and transforming raw data, addressing missing values, standardizing formats, and eliminating inconsistencies using advanced Excel, SQL, and Power Query.
Delivered actionable insights and ad-hoc reports to operations, sales, and claims teams, driving informed decision-making and contributing to cost-saving initiatives and system enhancements.
Education
Jawaharlal Nehru Technological University Anantapur (JNTUA) - Anantapur
→
MBA
Finances, Big Data Analysis
Sri Venkateshwara University - Tirupati, AP
→
B.COM
Computers Application
AP State Board
→
Intermediate
C.E.C
AP state board
→
SSC
General Studies
Languages
English
Telugu
Certificates
Data Science and Analytics
Issued By
Various Institutions
Data Analyst
Issued By
ExcelR Solutions
Data Visualization
Issued By
IBM
Skills
Data Science & Machine Learning
Data Science, Machine Learning, AI, Deep Learning, Python (pandas, numpy).
Data Analysis & Business Intelligence
Data Analysis, Analytical Skills, Data Visualization, Data Dashboard, MIS, MIS Reports, Statistics, Tableau.
Database Management & SQL
MySQL, SQL, MySQL Database Management, SQL Queries, Joins, Union, Schema Alterations.
Microsoft Excel & Office Suite
Advanced Excel, Microsoft Office Applications, Pivot Tables, VLOOKUP, HLOOKUP, Charts, Data Validation, Conditional Formatting, Google Sheets, VBA Macros, Power Query.
Reporting & Automation
Automated Reporting, Report Generation, Data Transformation, Process Improvement.
Interests
Entertainment
Watching Films and Anime, Listening to Music.
Sports
Playing Sports.