Sandhya C Email & Phone Number

United States

United States

Columbus, Ohio, United States

I bring extensive experience in data modeling concepts, particularly Star and Snowflake schemas, which I have applied to optimize data flows for Tableau dashboards at Encova Insurance. My work involves creating, updating, and deleting data using Spark SQL, HiveQL, and Teradata SQL, alongside validating data integrity in Hadoop and Teradata through advanced SQL queries and root cause analysis.I excel in performing real-time analytics by extracting ORC data from HDFS and analyzing it with Spark SQL for enhanced performance. I have automated pipeline management using Azure Logic Apps and focused on optimizing data models to align with business logic, including developing dynamic stored procedures for data validation.Utilizing Azure's PaaS, I facilitate data visualization through Azure Data Factory and Spark SQL, ensuring efficient data extraction, transformation, and loading into Azure services like Azure Databricks. I build automated dashboards to track KPIs related to pharmacy utilization and implement proactive monitoring in Tableau. My strong analytical skills have been recognized through effective root cause analyses of high-priority issues, contributing to improved data integrity and reporting processes.

Cleveland, Ohio, United States

At University Hospitals, I served as a Senior BI Developer/Data Analyst, collaborating closely with physicians and program directors to gather business requirements and design technical documents. I extracted and analyzed data from various sources, including the MSOW and GME databases, and developed comprehensive dashboards in Power BI and Spotfire.I utilized DRG, ICD10, and CPT codes to support clinical pathways and conducted data analysis for the Pfizer grant project. My responsibilities included creating standardized reports, developing prototype reports for end-user demos, and performing QA and User Acceptance Testing.I designed and optimized complex Cognos reports and dashboards, leveraging advanced SQL for data manipulation and visualization. Additionally, I worked with AWS, Azure, and Teradata, performing data analysis using Python, Spark, and Databricks, while optimizing high-volume Teradata tables.I developed and maintained Power BI environments, using DAX for calculations and creating various visualizations to enhance data clarity. My contributions significantly supported data-driven decision-making, helping track program performance and compliance with regulatory standards.

Concord, New Hampshire, United States

At Granite State Manufacturing, I played a key role in developing and optimizing T-SQL code, including stored procedures, functions, and triggers, to manage large data sets efficiently. I was instrumental in migrating on-premises architecture to highly scalable data lakes in AWS, utilizing services like Redshift and Athena for data wrangling and ETL processes with AWS Glue.I contributed to the logical design of databases by building entity-relationship diagrams and implemented reporting solutions using Tableau for the Talent Management group, enhancing insights into job profiles. Additionally, I improved performance for Cognos Analytics reports and successfully migrated reports from Cognos to Power BI, leveraging features like direct query and custom tables.My responsibilities also included troubleshooting Python applications, writing scripts to parse JSON data, and managing SSIS packages with logging and error handling. I utilized SSRS for report generation and scheduling, developed various report types, and participated in business requirement gathering and technical design documentation.My work in data visualization and reporting has supported informed decision-making and improved operational efficiency within the organization.

Hyderabad, Telangana, India

I developed a wide range of reports using SQL Server Reporting Services (SSRS), including Tablix, Drill-down, and Chart reports, and managed report deployment to staging and production environments with user-level security and complex subscriptions. Additionally, I was involved in migrating existing IBM Cognos reports to SSRS.My SQL expertise included writing complex queries, stored procedures, and triggers, while optimizing database performance through normalization and de-normalization techniques. I successfully improved query performance by over 25% through monitoring, tuning, and index optimization.I also contributed to quality assurance by performing unit tests, regression tests, and providing UAT support. My work included creating deployment documentation and integration diagrams using MS Visio, ensuring thorough communication and project alignment.