Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Personal Information
Timeline
Generic
Ashish Gupta

Ashish Gupta

Dhanorie

Summary

Results-driven Data Analytics & Engineering professional with 4+ years of expertise in database administration, workflow automation, and business intelligence. Proven ability to lead data-driven decision-making through advanced analytics, predictive modeling, and Power BI dashboard creation. Adept at optimizing processes, managing cloud-based infrastructures (AWS & Azure), and collaborating with cross-functional stakeholders. Strong communicator with experience in strategic sourcing, healthcare analytics, and financial technology operations. Proficient in a range of technologies including Oracle Database Servers, Amazon AWS CLI, RDS, EC2, MySQL Server, and MS SQL Server, I am committed to contributing to the success of the organization while continuously advancing my skills and knowledge in the ever-evolving IT landscape.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Process Executive

EXL Services Pvt. Ltd.
02.2024 - Current
  • As a Care Management Associate within the U.S. insurance sector at CVS Aetna Insurance, Led data-driven analysis in healthcare insurance operations at CVS Aetna Insurance, optimizing claims processing & policyholder experience.
  • Developed compliance - driven datasets ensuring adherence to Aetna policies & HIPAA standards to enhance regulatory accuracy.
  • Managed clinical data analytics using SQL and Power BI, driving insights for strategic healthcare policy adjustments.

IT Technical Sourcer

General Mills India Pvt. Ltd.
08.2023 - 11.2023
  • As an IT & Finance Technical Sourcer, I specialized in identifying and attracting high-value professionals across technology and financial sectors, ensuring alignment with critical business objectives.
  • My expertise spans full-cycle talent acquisition, leveraging advanced sourcing strategies, data-driven analytics, and stakeholder collaboration to build a robust pipeline of IT engineers, finance analysts, and technical specialists.
  • By combining deep domain knowledge in IT and finance with high-impact sourcing methodologies, I successfully delivered top-tier talent, contributing to workforce excellence and organizational success.

Information Systems Engineer

Lumen Technologies
11.2021 - 05.2022
  • As part of a 24/7 global support team, I specialized in application support and database management within Data Analytics and Business Intelligence environments using the Lumen Platform.
  • My role encompassed monitoring, troubleshooting, and optimizing client applications, ensuring seamless functionality and high-SLA compliance.
  • I proactively managed technical queries, enhanced system efficiency, and maintained data integrity, supporting critical analytics-driven decision-making.
  • By combining expertise in application support and data analytics, I contributed to operational excellence and business intelligence accuracy for global clients.

Database Administrator Cloud

Pentagon System & Services Pvt Ltd
11.2020 - 03.2021
  • Experienced in database refresh methodologies, including backup and restore processes for Oracle Database, MSSQL Server, and MySQL Server.
  • Skilled in database maintenance, performance tuning, and recovery manager(RMAN) for disaster recovery.
  • Proficient in cloud technologies, with hands-on expertise in Microsoft Azure, AWS, RDS, EC2, and S3 for database management and optimization.
  • Executed log shipping, system performance tuning, and data integrity enhancements across Windows and Linux-based database environments, ensuring seamless cloud-based data operations.

Performance Marketing MIS Executive - SQL DBMS

Ziff Davis
08.2018 - 05.2020
  • Managed the design, setup, and testing of database systems, ensuring seamless data handling and extraction of data.
  • Specialized in My-SQL based ETL processes, creating complex query definitions for efficient data retrieval, cleansing, and validation.
  • Oversaw database performance monitoring, optimization, and maintenance, configuring and managing SQL Server environments to support critical business operations.
  • Provided cross-training and technical support, troubleshooting database-related issues and ensuring smooth data flow across teams.

Education

Bachelors of Engineering - Computer Science

Dr. DY Patil School of Engineering & Technology
Pune
06-2018

Skills

  • Data Analysis & Engineering
  • Oracle Database Administration & Database Optimization
  • Cloud Technologies ( Amazon AWS, RDS, EC2 )
  • Cross - Functional Team Leadership
  • Workflow Automation & Data Visualization
  • Business Intelligence & Data Analytics
  • SQL Server - Reporting ( SSIS & SSRS )
  • Workflow Analysis & Utilization management
  • Microsoft Power BI - Integration
  • MS SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS)
  • Oracle Database Recovery Manager(RMAN)
  • Strategic decision-making
  • Data Governance & Regulatory Compliance ( HIPAA Policies )
  • Insurance Analytics
  • Technical Communication & Business Communication
  • Stakeholder interaction and problem-solving
  • Reports & Insights Documentation

Certification

  • Oracle Database11g/12c SQL Certified Expert, Expert in Oracle database querying, proficient in joins and sub-queries, adept at DML, DDL, and DCL operations. Experienced in managing transactions with savepoints and rollbacks. Proficient in table management, including creation, alteration, and renaming. Skilled in granting and revoking table permissions. Competent in set operations, utilizing WITH clauses, and optimizing queries. Experienced in creating and managing views and sequences for unique identifiers. Proficient in accessing data dictionary views and managing user roles. Skilled in working with external tables and performing conditional insertions. Capable of executing version queries to track changes in table columns.
  • Digital Networking Strategies Certified
  • Certified in Generative AI for Business Leaders

Accomplishments

Paper Published on “Smart and Secure System for Automatic Toll Collection and Accident Detection”, In International Journal of Computer Engineering and Applications ( IJCEA ), Conference Publications, ICORIET in 2018

Personal Information

Date of Birth: 12/21/96

Timeline

Process Executive

EXL Services Pvt. Ltd.
02.2024 - Current

IT Technical Sourcer

General Mills India Pvt. Ltd.
08.2023 - 11.2023

Information Systems Engineer

Lumen Technologies
11.2021 - 05.2022

Database Administrator Cloud

Pentagon System & Services Pvt Ltd
11.2020 - 03.2021

Performance Marketing MIS Executive - SQL DBMS

Ziff Davis
08.2018 - 05.2020

Bachelors of Engineering - Computer Science

Dr. DY Patil School of Engineering & Technology
Ashish Gupta