Sruthi Annamraju
Prosper,TX
Summary
Senior Data Analyst / Data Science Engineer with ~6 years of experience in end-to-end analytics, data modeling, automation, and business intelligence across cloud and on-prem environments. Strong in SQL development (Teradata, SQL Server, T-SQL) with expertise in complex queries, performance tuning, stored procedures, and large-scale analytical workloads. Skilled in automating data workflows using Alteryx Designer, including cleansing, deduplication, pattern validation, and survey data processing significantly reducing manual effort and improving data accuracy. Proficient in data warehousing and ETL/ELT across Azure (Synapse, ADF, Databricks), AWS (S3, Redshift, Glue), Snowflake, Teradata, and Snap Logic. Expertise in building scalable Star/Snowflake models, fact/dimension structures, mapping data sources, and integrating decentralized data across distributed systems and validating upstream/downstream system behavior. Skilled at understanding business requirements and converting them into technical requirements, data flows, source-to-target mappings, data rules, and technical specifications for data engineering teams. Hands-on experience working with third-party data providers, ensuring accurate, timely data ingestion for campaigns, surveys, and enterprise analytics. Delivered executive-level dashboards using Tableau enriched with automated insights, forecasting indicators, trend visualization, and segmented comparisons and familiar with BI tools such as Power BI, Looker and Snow Sight. Experienced in predictive analytics and trend-based analysis, segmentation, anomaly detection, automated insights to improve targeting, enhance reporting, and support smarter decision-making. Improved enterprise data quality using rule-based and pattern-matching logic to detect missing attributes, incorrect mappings, inconsistencies, and other data reliability issues across large ecosystems working with data engineering teams. Actively leverage AI to streamline daily work, including summarizing datasets, generating SQL suggestions, drafting documentation/emails, creating presentation content, and synthesizing QA findings enhancing productivity and analytical efficiency. Mentored and guided contractors, delegating project tasks effectively and ensuring high-quality, on-time deliverables. Recognized with multiple Spotlight Awards for high-impact contributions, operational excellence, and delivering reliable, scalable data solutions. Currently pursuing an MBA at the University of Illinois Urbana-Champaign, including focus areas such as Business Analytics, Global challenges in Business strengthening the ability to apply BI, automation, and strategic data work.
Overview
8
8
years of professional experience
Work History
Sr Data Science Engr
Verizon
Irving, USA
07.2024 - Current
- Converted to full-time after multiple Spotlight Awards; part of the Analytics & Data Management – Data Science team.
- Own the lifecycle and daily quality of the 50M+ record Contact Universe including SFDC, Marketo and third party data using rule-based checks, pattern matching, Alteryx automation, and Tableau QA dashboards to ensure accurate, complete, and up-to-date customer data.
- Designed automated Alteryx workflows for data cleansing, deduplication, lineage validation, and survey targeting logic, reducing manual effort and improving reliability.
- Led the biannual Relationship Survey, applying predictive analysis on historical responses to identify high-propensity segments and significantly improve response rates.
- Automated survey QA and targeting logic in Alteryx, accelerating cycle turnaround and improving consistency across waves.
- Built executive-facing Tableau dashboards enriched with automated insights such as trends, segmentation, anomaly indicators, and forecast patterns for strategic decision-making.
- Developed scalable data models and optimized SQL scripts, stored procedures, and analytical views; validated upstream/downstream flows with Engineering and supported workloads on Teradata and GCP.
- Delivered ad-hoc analyses, campaigns and C-level reporting, translating business needs into KPIs, insights, and actionable recommendations.
- Integrated Gemini AI to summarize daily anomalies, generate insights, create emails/PowerPoints, proofread documentation, and support SQL troubleshooting, improving operational efficiency.
- Explore next-generation BI solutions including Tableau Next (agentic AI) to evaluate opportunities for automated data prep, insight generation, and modern AI-driven reporting.
Data Analyst
ECOM Consulting Inc/GSK Solutions Inc
Dallas, USA
11.2022 - 07.2024
- Client: Verizon, Irving, TX
- Part of Digital and Revenue Technology - Marketing business team.
- Spearheaded the Relationship Survey project, orchestrating the seamless provision of back-end customer data to third-party survey partners.
- Acted as a pivotal liaison between cross-functional business teams, translating complex technical requirements into actionable strategies.
- Managed and manipulated extensive databases using Teradata SQL Assistant, ensuring data integrity and reliability.
- Crafted and optimized intricate SQL scripts, including stored procedures and views, and techniques such as joins, sub-queries driving performance enhancements and efficiency gains.
- Analyze customer feedback and responses to refine marketing and CX strategies; build Tableau dashboards that clearly visualize trends and insights for business stakeholders.
- Built tableau dashboards for daily quality analysis and checks of the Contact Universe.
- Conducted in-depth data analysis and list development for various campaigns, providing actionable insights to refine marketing strategies and drive business growth.
- Executed ad-hoc analysis initiatives to address specific business needs and enhance the credibility of contact sources.
- Leveraged Advanced Microsoft Excel to organize and analyze customer data, facilitating data-driven decision-making processes.
Data Engineer
Spreetail
Lincoln, USA
05.2022 - 11.2022
- Analyze, design, and build solutions using Azure PaaS service and SSMS to support the forecasting team to get the meaningful insights for Ecommerce platform.
- Understand the status of the application and determine the impact of new implementation on existing business processes.
- Maintenance and Validation of all the internal and external data sources which are used by the Data Scientists by writing SQL scripts, stored procedures and business rules in SSMS.
- Performed end-to-end data modeling, including Star/Snowflake schema design, fact/dimension creation, and documentation of data entities used by analytics and data science teams.
- Created data flow diagrams, lineage documentation, and source-to-target mappings, capturing how data from multiple e-commerce systems moved through Azure Data Lake, staging layers, and into production analytical tables.
- Extract, Transform and Load data from different internal and external source systems to Azure SQL Server using combination of Azure Synapse Analytics, Azure Data Lake, Azure Databricks, Delta Lake, SSMS and T-SQL.
- Created pipelines in Azure Synapse Analytics using linked services/datasets to extract, transform and load data from different sources like Flat files, SFTP locations into Azure Data Lake as staging folder and then into Azure SQL Server.
- Data Ingestion to one or more azure services SQL server, Azure Data Lake and processing the data in SSMS to create further database objects such as fact tables, views and stores procedures.
- Databricks Administrations in terms of creating, configuring and maintaining spark clusters.
- Automated job cluster creation in Azure Databricks for ETL jobs using API calls in PowerShell scripting.
- Responsible for creating, maintaining, and trouble-shooting the ETL pipelines as required. Ensuring 24/7 availability and accessibility of data.
- End-to-end development of CI/CD process for the data engineering process to have automated deployment using GitHub.
Data Engineer
Anblicks Inc
Dallas, USA
06.2021 - 05.2022
- Clients: Main Event, CBRE
- Worked with clients to gather technical and business requirements for large-scale data migrations and real-time data integration projects.
- Designed and implemented Azure-based data warehouse solutions (Synapse, ADLS, ADF, Databricks) supporting real-time and batch workloads.
- Created data flow diagrams, lineage documents, and source-to-target mappings, covering data movement from Sybase, SQL Server, APIs, Snowflake, and other distributed systems into Azure environments.
- Performed data modeling including fact/dimension design, Star & Snowflake schema modeling, logical/physical modeling, and documentation of entity relationships.
- Built automated pipelines replacing SSIS with ADF, improving processing efficiency by ~60%.
- Created a Java-based utility to extract Sybase tables and push near real-time data into ADLS.
- Integrated API, SQL Server, and external datasets into Synapse; built cubes, and developed Power BI dashboards for business users.
- Delivered configuration-driven ELT frameworks, Power BI dataset refresh automation, and PySpark-based transformation logic.
- Developed pipelines to copy data across heterogeneous systems (Snowflake → Postgres, SQL sources → Dedicated Pools).
- Built monitoring dashboards in Snow Sight and embedded Power BI into a web application for client access.
- Implemented internal POCs using AWS S3, Redshift, and Glue to evaluate cloud warehousing options, prototype ingestion pipelines, and compare multi-cloud data migration patterns.
Application Development Analyst
Accenture
India
05.2018 - 07.2019
- Part of customer retention and analytics team. Successfully provided data-driven support and insights for the customer facing application to increase its efficiency by 85%.
- Maintained large database of customers and their ratings for the application provided by the client and performed queries using T- SQL in SSMS.
- Worked on dimensional data modeling using star and snowflake schemas for fact and dimension tables.
- Created database schemas and number of database objects like tables, views, stored procedures using SSMS.
- Proactively created, organized, and manipulated large amounts of customer data in the spreadsheets using the Advanced Microsoft Excel i.e., using Pivot tables, functions etc.
- Utilized SAS for statistical analysis, performance evaluation, and generating customer insights, supporting data-driven improvements for retention and engagement initiatives.
- Key member of a large, dedicated team which inspired me to develop teamwork skills.
- Followed Agile software development methodology and gained understanding of the organizational level project cycle.
Education
MBA - Business Analytics
University of Illinois
Urbana Champaign08-2027
Master of Science - Data Science
University of North Texas
Denton, TX05.2021
Bachelor of Technology - Computer Science and Engineering
JNTUH
India05.2018
Skills
- SQL development and programming
- Java and Python skills
- Data orchestration tools (Azure Data Factory, AWS Glue)
- Cloud-based data solutions (Snowflake, Redshift)
- Data visualization expertise (Tableau, Power BI)
- Advanced Excel proficiency
- Business intelligence methodologies
- Comprehensive data analysis
Extracurricular Activities
Degree in Indian Carnatic Vocal Music, Potti Sriramulu Telugu University, Hyderabad, India
Volunteer Experience
Head Volunteer, Girls in Tech, India, 09/01/16, 11/30/17, Part of inclusive global organization helping women enter into and excel in tech industries and stem related education., Conducted bootcamps, workshops for women in rural area to motivate them to pursue technology., Networked with professionals from all over the world such as Professors from Berkeley university, California.
Timeline
Sr Data Science Engr
Verizon
07.2024 - Current
Data Analyst
ECOM Consulting Inc/GSK Solutions Inc
11.2022 - 07.2024
Data Engineer
Spreetail
05.2022 - 11.2022
Data Engineer
Anblicks Inc
06.2021 - 05.2022
Application Development Analyst
Accenture
05.2018 - 07.2019
MBA - Business Analytics
University of Illinois
Master of Science - Data Science
University of North Texas
Bachelor of Technology - Computer Science and Engineering
JNTUH