Dhivya Subramanian Email & Phone Number

United States

Bengaluru, Karnataka, India

•Involved in the development of a TCS internal product called “SurveyMax”, the product was beneficial in creating and conducting several types of surveys for TCS Clients and Internal Employees.• Performed development using Java, Python and maintained the products to serve specified business needs.• Enhanced data quality through the implementation of various tests, including generic and singular tests, using DBT.•Created and managed dynamic tables in Snowflake for temporary storage, intermediate results, and data staging, enhancing data transformation and ETL efficiency.• Experience with ETL, Data warehousing, Data Store concepts and OLAP technologies.• Configured DBT to enable data freshness and accuracy monitoring.•Worked in Amazon Web Services cloud computing environment.• Automated and managed critical data processing tasks in Snowflake, ensuring timely execution, enhancing data reliability and efficiency.•Executed scheduled builds using CICD pipelines through Jenkins and acted on issues.• Developed, tested, debugged, and documented Oracle PL/SQL packages and types in accordance with company policies, company standards, and industry best practices, ensuring 97% satisfaction in performance.• Analyzed the response of the clients and helped to take the necessary measures to provide better service to the clients and created dashboards using Tableau for survey reports.• Created a survey database to handle all the surveys Queries using SQL.• Worked on numerous ad-hoc data pulls using SQL for business analysis and monitoring.• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.• Managed Snowflake database infrastructure, including the creation of clones, pipes, and external stages for efficient data ingestion and extraction.

Bangalore Urban, Karnataka, India

•Worked on a Hospital Management System product called AXPERT which streamlines every aspect of health care delivery from patient registration to customized report generation.•Tested the PL/SQL procedures, functions, packages according to the requirements.•Designed, developed, tested, implemented Data Warehousing ETL using Snowflake.• Created customized utilities and APIs for my product using Java and C# using Visual studio.• Worked on product development for various hospitals like Leixir (Dental labs in the USA), Kauvery Hospital, A.J Hospital, etc.•Automated the manual data reconciliation process between the different sources, increasing the data accuracy and efficiency by 90%.• Have written complex SQL queries to perform the data validation in the backend testing.•Construct and run SQL queries to extract curated data for analyzing data and creating Tableau dashboards.• Utilized advanced SQL techniques, including the implementation of window functions in Snowflake, to optimize query performance and reduce costs in data processing.•Creating a GitHub repository, pull, push and commit the code from the repository.•Involved in testing the Pharmacy claims, Medical, Dental and Hospital Claims.•Construct and run SQL queries to extract curated data for analyzing data and creating Power bi dashboards.•Drove 97% stability, reliability, and performance by optimizing in-application SQL statements and designing user-focused databases.

Bengaluru, Karnataka, India

• Conducted scrum meetings among the core team developers and analysts to understand the state of the product.• Production Support for the monthly loads of data.• Erected Tableau and Power BI dashboards to visualize analyzed data, compiling and reporting findings to management and clients. Recommended product feature augmentations, leading to enhanced product quality and customer satisfaction.• Documenting and executing detailed test cases and summarizing the results.• Collaborated with the clinical project manager to determine the study timelines and milestones.• Trained in database design, development, and Testing using SQL through close collaboration with clinical programs.• Construct and run SQL queries to extract curated data for analyzing data and creating Tableau dashboards.• Building Tableau dashboards to track performance and analyze trends of various KPIs overtime.

Masters Of Science-Ms, Data Science

Activities and Societies: -Activities and societies: Summa Cum Laude- Scholarship Award Recipient -Activities and societies: Summa Cum.

Bachelor Of Engineering, Computer Science

-"I received a cash award in recognition of my outstanding academic achievement and securing a university ranking during my undergraduate.