Akshay Gupta

Experience

• 

  One Window Overseas Education Pvt Ltd.

  May 2016 - Aug 2016

  Data Analyst
• 

  NStarX

  Nov 2018 - Dec 2021

  Cloud Data Engineer

  ● Designed and implemented scalable big data architectures tailored to business needs, balancing performance requirements with considerations for data volume, velocity, and variety. ● Applied in-depth ETL skills to orchestrate the smooth movement of data, optimizing processes for efficiency and maintaining data integrity throughout. Leveraged Apache Oozie for workflow scheduling and orchestration.● Applied expertise in data modeling to design structures that optimize storage, retrieval, and processing, catering to unique challenges posed by varying data volumes and complexities.● Applied encryption and access controls to secure sensitive data in Hadoop clusters, Databricks, and GCP BigQuery. Utilized GCP (IAM) identity and access management, and incorporated Azure Event Hub for real-time data ingestion.● Conducted performance tuning for ETL processes, resulting in a resource utilization optimization of 20%. Utilized GCP BigQuery, Dataflow, and Dataproc for optimized data processing.● Implemented caching strategies and query optimizations in Hive , leading to a 30% improvement in analytical query performance. Utilized GCP Cloud Storage for efficient data storage.● Implemented monitoring solutions, resulting in a 40% reduction in data quality issues through proactive identification and resolution. Show less

• 

  Humana

  May 2023 - now

  Data Engineer

  ● Developed and maintained robust data management systems adhering to HIPAA regulations, focusing on the integrity and security of sensitive patient data. Implemented comprehensive data encryption and access controls, significantly reducing the risk of data breaches using Snowflake's secure data sharing capabilities.● Engineered seamless integrations between clinical healthcare systems and billing platforms using API-driven approaches with Azure Databricks, optimizing existing data pipelines and reducing data processing times by 30%, thereby increasing efficiency in billing operations and patient data management.● Leveraged Azure Databricks for developing advanced data analytics tools that utilize statistical models and machine learning algorithms to facilitate data-driven decision-making, enhancing patient care and operational efficiency by providing insights into treatment outcomes and resource allocation.● Utilized Snowflake's scalable architecture to prepare clean, well-structured datasets for use in machine learning models, focusing on predicting patient outcomes and identifying billing anomalies. Collaborated with data scientists to refine data features and improve model accuracy.● Developed complex SQL queries on Databricks to extract, transform, and load (ETL) data, leading to a 40% improvement in data retrieval speed and accuracy for business intelligence reporting.●Authored detailed technical documentation for all data processes and systems, ensuring clarity and usability across multiple departments. Established guidelines and practices that comply with healthcare regulations, enhancing organizational adherence to legal and ethical standards.●Worked closely with IT specialists and healthcare professionals to develop and customize data solutions that meet specific organizational needs using Azure Databricks and Snowflake. Improved patient service delivery by 25% through tailored data applications that enhance user experience and operational workflows. Show less