Akash Soni

IT Executive | Data & Business Intelligence Specialist

Gurugram, IN.

About

Highly analytical and results-driven IT Executive with a Bachelor of Technology in Computer Science and Data Science, currently leveraging expertise in SSRS and SQL Server to optimize reporting and enhance cross-departmental performance. Proven ability to streamline data operations, resolve critical system issues, and develop interactive dashboards, significantly improving data accessibility and decision-making efficiency. Seeking to apply advanced data analysis, business intelligence, and automation skills to drive strategic insights and operational excellence in a forward-thinking organization.

Work

Shine & Standard (Client: Max Healthcare)

|

IT Executive

Gurugram, Haryana, India

→

Summary

Led the development and optimization of SSRS and SQL Server reports, enhancing data accessibility and cross-departmental performance for Max Healthcare.

Highlights

Developed and optimized over 100+ SSRS reports, significantly enhancing cross-departmental reporting efficiency and data accessibility.

Engineered 100+ custom and refined 250+ existing reports using SSRS and SQL Server, boosting reporting efficiency across multiple departments.

Programmed and optimized complex SQL queries, views, and stored procedures, streamlining data extraction and reporting processes.

Managed and resolved over 1000+ Sapphire tickets, ensuring critical system stability and enhancing user satisfaction.

Collaborated cross-functionally with physicians, finance, and operations teams to gather requirements, delivering accurate and actionable reports for strategic decision-making.

Binarama Pvt. Ltd.

|

Tech Mind Intern

Noida, Uttar Pradesh, India

→

Summary

Executed ETL operations, automated data collection, and developed interactive dashboards to improve data accessibility and efficiency for various projects.

Highlights

Executed ETL operations, consolidating data from diverse sources into a centralized warehouse and improving data accessibility by 20%.

Standardized and cleaned data, achieving 95% accuracy and consistency across multiple projects.

Automated data collection using BeautifulSoup and Scrapy in Python, boosting data acquisition efficiency by 30%.

Designed and developed interactive Power BI dashboards for the NEET Examination, supporting the Radical Education project.

Education

Dr. A.P.J. Abdul Kalam Technical University

Greater Noida, Uttar Pradesh, India
→
Bachelor of Technology Computer Science and Data Science Grade: 7.4 CGPA

Skills

Programming Languages

SQL, Python, C++.

Data Analysis & BI Tools

NumPy, Pandas, SSRS (SQL Server Reporting Services), Power BI, Excel, Google Sheets.

Databases

SQL Server.

Automation & Web Scraping

BeautifulSoup, Scrapy.

AI/ML & Vision

Gemini Pro 1.5, OpenCV.

Frameworks & Libraries

Streamlit, OpenGL.

Projects

Healthcare Reporting Automation (SSRS+SQL)

→

Summary

Designed and automated critical healthcare reports like Upcountry, Exception Pricing, Finance, and Clinical Reports using SSRS and SQL Server to enhance data delivery and accuracy.

Healthcare Chatbot for Report Insights (Streamlit + Gemini Pro 1.5)

→

Summary

Built an AI-powered chatbot using Streamlit and Gemini Pro 1.5, enabling hospital management to access clinical and financial data through natural language queries.

Dashboard Projects (Power BI + SQL)

→

Summary

Built interactive Power BI dashboards for various analyses, including Call Center, IPL Stats, and E-commerce, integrating ETL and SQL for data-driven insights.

Rubik's Cube Solver (C++, OpenCV, OpenGL)

→

Summary

Automated a Rubik's Cube solver using image processing and logic-based algorithms, enhanced with a 3D visualizer.