User details
SV
SV
Sravanthi Veepuri
@sravanthi_veepuri_1r5zv0kg6
Data Engineer
South San Francisco, CA, United States
5Followers14Following0Mutual0Post
Member since: Jan 21, 2025Result-driven professional with 15 years of experience in designing and optimizing data solutions. Proficient in creating data pipelines, data warehouses, and BI reporting solutions using modern technologies like Snowflake, AWS, Azure and Airflow. Expertise in streamlining workflows and delivering 40% faster insights for decision making. Proven success in database modeling, ETL development, and real-time analytics, achieving measurable improvements in process efficiency. Performed detailed SQL profiling and optimization, reducing query execution times and improving resource utilization.
In my current role as Principal Data Engineer at Alameda Health Systems, I developed and optimized intricate SQL procedures, enabling the generation of over 30 key performance metrics that secured $50 million in funding. I collaborated with cross-functional teams to refine data warehouse structures, enhancing query performance and ensuring timely delivery of critical insights. My ability to write and optimize complex stored procedures and triggers has been instrumental in streamlining data workflows and reducing execution times by 40%.
Previously, at CodeObjects, Inc., I engineered and tuned large-scale Oracle databases, writing PL/SQL packages and implementing advanced indexing and partitioning strategies that improved query performance by 50%. I also conducted in-depth SQL tuning using tools like EXPLAIN PLAN and SQL Trace to identify and resolve bottlenecks, ensuring peak database performance even under heavy workloads.
I have Certified expertise in database architecture, cloud solutions, and platform optimization like Snowflake, OracleDBA.
• Developed 10 PY6 and 20 PY7 reporting metrics, securing $50M in funding by adhering to DHCS requirements for the QIP value-based payment program
• Collaborated with cross-functional teams and met performance metrics within deadlines, enhancing validation and testing processes
• Refined data warehouse structures, boosting data handling efficiency, contributed to accelerated insights, and improved decision-making across teams
• Created a Power BI reporting solution, improving report generation productivity, minimizing manual tasks, and streamlining the overall report delivery process
• Designed and automated End-to End data Pipeline using AWS RDS(Sql server), snowflake, DBT.
• Developed complex metrics from scratch using Sql and stored procedures.
Data Engineer: CodeObjects, Inc (Insurity) Sep 2008 – Nov 2020
· Engineered end-to-end streaming and batch data pipelines using AWS, S3 storage, Airflow, and Snowflake, processing over 5TB of data daily, boosting pipeline efficiency
· Optimized data pipelines using Snowflake and Snowpipe, automating data loading processes and reducing manual intervention, increasing data processing efficiency by 50%
· Optimized the cost using automated Data Migration Pipeline for Cloud Transition using AWS S3, AWS DMS, AWS Glue, Amazon Redshift, Amazon RDS by 30%
· Deployed Slowly Changing Dimensions (SCD) on Snowflake using stream and task functionalities, improving data consistency and shortening processing time
· Implemented role-based access control (RBAC) in Snowflake, enhancing data security and ensuring compliance with industry standards, leading to a 50% reduction in security breaches
· Migrated on-premise datasets to Amazon RDS, saving 20% in hosting costs annually and boosting operational efficiency with auto-scaling infrastructure
· Designed and maintained physical and logical data models, creating data flow diagrams and solutions, aligning with company objectives, and reducing system errors by 18%
· Enhanced queries through indexing, clustering, and new database design techniques, improving query performance and accelerating report creation for business analysis
· Performed data discovery, profiling, and data quality checks using SQL and tools, improving data quality and reducing discrepancies by 25%
· Led bi-weekly demos for business stakeholders on new product features, architectural roadmaps, and enhancements, earning 90% positive feedback and driving product development
· Directed the database team and executed data migration and integration solutions, transferring 15TB of data across systems, and improving data flow efficiency
· Implemented Snowflake data warehouse, enabling integration with data sources, leading to a 40% decrease in query processing times and improving report generation speed
· Engineered and deployed BI solutions, including ETL jobs, snowflake schema, and complex BI reports and dashboards, enhancing decision-making speed
· Optimized data storage costs with AWS S3 and Glacier, reducing storage expenses by 30% while maintaining high availability and durability for critical business data
· Developed logical and physical data models using ER Studio, Visio, and DBDesigner for enterprise applications, improving data integrity
· Designed Actuate reports tailored to business needs, streamlining decision-making processes and reducing report generation time by 35%, enhancing operational effectiveness
· Directed database porting initiatives, supporting databases for CRM applications, increasing system compatibility and leading to a 20% reduction in integration-related issues
· Executed database security policies, including encryption, access control, and auditing, complying with data protection regulations (GDPR, HIPAA)
· Facilitated QA and user acceptance testing, achieving test coverage and lowering test cycle time, increasing testing efficiency
· Created complex SQL queries in Snowflake, generating insights for senior management, streamlining the reporting process, and reducing the time required for report preparation by 45%
· Led the execution of Y2K compliance projects on Mainframes using COBOL and JCL, ensuring full system functionality and minimizing potential disruptions to legacy systems
· Facilitated the Northwestern Pension System pilot project, contributing to the implementation and integration of critical business functions within tight timelines