Dinesh Kumar
Hyderbad
Summary
Data Analyst with 6+ years of experience in SQL development using PostgreSQL, SQL Server, and Snowflake SQL. Strong background in data warehousing, statistical analysis, trend reporting, and ETL design. Skilled in Control-M implementation, Tableau reporting, data mining, database optimization, and performance tuning. Focused on delivering high-quality insights, ensuring customer satisfaction, and meeting SLAs within budget and timelines
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Analyst
Optum
08.2022 - Current
- Spearheaded migration from SQL Server to Snowflake, architecting an optimised data model that decreased storage from 15.95 TB (-532K-$48K/year) to 1 TB (-$600/year), achieving annual savings of approximately $26k-$30K.
- Optimized data processes to minimize storage usage, remove redundant tables, and substantially shorten processing duration.
- Engineered a Snowflake model empowering stakeholders to obtain required data through single SELECT queries with minimal joins, expediting report availability and enhancing access.
- Established robust query logging system to monitor execution time and performance metrics, enhancing issue tracing and operational visibility.
- Engineered text extraction process to identify claim numbers from unstructured user comments, facilitating recovery of over £1,000 in lost claims.
- Transformed 35+ SSRS reports into Power BI with user-friendly visuals, enhancing decision-making and data accessibility.
Database Developer, Analyst
Globallogic
11.2020 - 08.2022
- Implemented functionality to identify ineligible and inactive users within casino application.
- Designed an admin notification process that streamlined user management.
- Restructured database architecture to accommodate enhancements and optimise performance.
- Contributed to over 15 SSRS and Tableau reports aligned with updated data model.
- Directed migration from SQL Server to Azure SQL Cloud Platform, designing a resilient microservices-based solution, managing a team of four members, and ensuring delivery within six months.
- Developed dynamic reports in Excel, Word, Docs, and PDF in collaboration with Google Ads team.
- Utilised PARC reporting tool along with PLX and CLL to enhance reporting efficiency.
Decision Analytics
EXL Services
06.2019 - 11.2020
- Restructured Revenue Cycle Management data model, reducing processing time from two hours to fifty minutes.
- Optimised provider data handling through improved data model architecture.
- Developed automated Tableau dashboard enabling automatic refresh of dashboards with data population, enhancing real-time data visualisation and reducing manual effort.
- Acted as SME for X12 claims files and HL7 standards, utilising Python to extract data from these files into SQL Server database.
Database Developer, Analyst, Database Architect
Spice Digital
01.2018 - 03.2019
- Company Overview: India
- Engineered and optimised departmental services such as Aadhaar and EPFO within UMANG portal, decreasing processing time from 1 hour to 25 minutes via automation.
- Developed and implemented role-based Admin portal within 8 months, facilitating efficient access control and management.
- Streamlined PostgreSQL functions, elevating database performance and query efficiency.
- Established error logging and testing procedures for production scenarios, facilitating seamless deployment and restricted access to designated users prior to global rollout.
- India
Education
Graduation - Computer Science Engineering
Niit University
Neemrana, Rajasthan01.2018
Intermediate - Mathematics, Physics, Chemistry
Sri Chaitanya College
01.2014
Skills
- Data analytics
- Data processing
- Knowledge of BI tools
- Data Visualisation
- Data cleansing
- PostgreSQL
- MySQL
- Python-Basics
- Snowsql
- T-Sql - Sql server
- PG Admin III
- SSIS
- Control-M Job Scheduler
Primary Skills:
Programming Language:
Tools:
- SSRS
- Tableau
- GIT
- VS Code
- Snowflake SQL
- Microsoft SQL Server
- SQL Server Agent
- AWS Redshift
- Azure SQL Cloud Platform
- Snowflake
- Collaboration
- Problem-solving
- Communication skills
- Mentorship
Cloud Technologies:
Soft Skills:
Certification
Microsoft Power BI Certification, Microsoft Certified: Power BI Data Analyst Associate, 1804-1620
Timeline
Data Analyst
Optum
08.2022 - Current
Database Developer, Analyst
Globallogic
11.2020 - 08.2022
Decision Analytics
EXL Services
06.2019 - 11.2020
Database Developer, Analyst, Database Architect
Spice Digital
01.2018 - 03.2019
Intermediate - Mathematics, Physics, Chemistry
Sri Chaitanya College
Graduation - Computer Science Engineering
Niit University
Similar Profiles
Samantha MyersSamantha Myers
Insurance Agent at OptumInsurance Agent at Optum
Summer PalmerSummer Palmer
Manager of Clinical Operations at OptumManager of Clinical Operations at Optum
Mo’neke WaltonMo’neke Walton
Sr. Install Admin at OptumSr. Install Admin at Optum
Ashly MillerAshly Miller
Medical Assistant/Phlebotomist at OptumMedical Assistant/Phlebotomist at Optum
Chekuri Durga Venkata SubbarajuChekuri Durga Venkata Subbaraju
Software Engineer at FastPixSoftware Engineer at FastPix