Sql Server Data Analyst

Prabhavathi Pemmasani

+1-314-***-**** ***********************@*****.*** Atlanta, GA Linkedin ID Professional Summary:

Detail-oriented and performance-driven SQL Developer / Data Analyst with over 5 years of professional experience in designing, developing, and maintaining end-to-end data solutions across industries such as insurance, healthcare, and enterprise services. Specialized in SQL Server, T-SQL, PL/SQL, SSIS, SSRS, and Azure Data Factory (ADF), with a strong track record of building high-performance ETL pipelines, implementing scalable data warehouses, and optimizing complex queries. Experienced in dimensional modeling using Star and Snowflake schemas, performance tuning, and automation of data processes across heterogeneous systems to support business-critical reporting and analytics. Well-versed in building intuitive, data-driven dashboards and reports using Power BI, incorporating DAX, data modeling, and visual analytics to support executive decision-making and self-service reporting. Adept at collaborating with cross-functional teams, gathering business requirements, defining KPIs, and delivering timely, high-quality data solutions in Agile/Scrum environments. Known for strong problem-solving skills, production support expertise, and a deep understanding of data governance and integrity. Holds a Master of Science in Computer Science from Southeast Missouri State University and is committed to delivering reliable, efficient, and scalable data solutions that drive business value. Technical Skills:

Database & SQL Technologies : SQL Server (2005/2008/2016/2019), Oracle PL/SQL, T-SQL, SQLLoader, TOAD, SQLPlus, SSMS.

ETL & Data Integration : SQL Server Integration Services (SSIS), Azure Data Factory (ADF), Data Migration, ETL Framework Design, Incremental Loads, Data Cleansing, PowerShell, Unix Shell Scripting. Reporting & BI Tools : SQL Server Reporting Services (SSRS), Power BI (DAX, Data Modeling, Measures, Slicers), Microsoft Access, Excel (VBA, Pivot Tables, Macros, Charts). Data Warehousing & Modeling : Star & Snowflake Schema Design, Data Marts, OLAP Cubes, MDX, SSAS, Dimensional Modeling, ER Modeling, Logical & Physical Data Modeling, Materialized Views, Indexing

& Partitioning.

Cloud & Integration Platforms : Azure Data Factory, Azure Dataverse, SharePoint Integration, Dynamics 365 Integration.

SDLC & Agile Methodologies : Agile (Scrum), Sprint Planning, Story Grooming, Stand-ups, Version Control, Code Review, Documentation.

Other Skills : MS Office Suite, Report Builder, Automation Frameworks, Data Validation & Testing, Production Support, Backup & Restore, Environment Refresh. Educational Details:

Southeast Missouri State University, MO – Jan 23 – May 24

● Master of Science (M.S.): Computer Science

Jawaharlal Nehru Technological University, Kakinada – May 2020

● Bachelor of Technology: Computer Science

Professional Experience:

Travelers Insurance Atlanta, GA

Sr. SQL Developer/Analyst Aug 2023 – Current

Roles & Responsibilities:

● Developed and optimized complex T-SQL stored procedures, views, functions, and triggers to support data transformation, validation, and reporting requirements across transactional and analytical systems.

● Designed and maintained SSIS packages for high-volume ETL operations, performing data extraction, transformation, and loading from flat files, Excel, XML, and relational sources into SQL Server data warehouses.

● Created and managed indexing strategies, analyzed execution plans, and applied performance tuning techniques to enhance query performance and database responsiveness.

● Modeled data structures using Star and Snowflake schemas, built physical and logical data models, and implemented dimensional design strategies for scalable analytics.

● Implemented parameterized ETL pipelines in Azure Data Factory to automate scheduled data loads and enterprise data sources into SQL Server environments.

● Designed, developed, and scheduled SSRS reports using stored procedures and views, supporting operational and executive reporting with automated subscriptions and data snapshots.

● Built and maintained Power BI dashboards and reports, applying DAX expressions, measures, and slicers to provide visual insights into key business metrics and trends.

● Created data models and established relationships in Power BI to enable self-service analytics and reduce ad HOC reporting dependencies.

● Collaborated with business analysts and stakeholders to gather reporting requirements, define KPIs, and ensure accurate data representation in both SQL and Power BI layers.

● Performed root cause analysis and resolution of data anomalies and integrity issues within SQL Server and analytical environments.

● Participated in Agile ceremonies and cross-functional collaboration for sprint planning, backlog grooming, and iterative delivery of data and analytics solutions.

● Supported production SQL Server environments with regular backups, environment refreshes, and monitoring of ETL pipelines and reporting performance.

Quadrant Resources Hyderabad, India

SQL Developer July 2020 – Dec 2022

Roles & Responsibilities:

● Designed and implemented scalable data marts to support business-critical reporting on productivity, usage metrics, and operational KPIs.

● Developed and optimized complex stored procedures, functions, triggers, and views using T-SQL and PL/SQL for high-performance data processing.

● Created robust SSIS packages to handle end-to-end ETL workflows, including incremental loads and scheduled updates across heterogeneous sources.

● Delivered actionable insights through dynamic SSRS reports and interactive Power BI dashboards using drilldowns, slicers, and custom visualizations.

● Improved database and report performance by analyzing execution plans, optimizing indexes, and tuning long- running queries.

● Automated data integration and transformation tasks using advanced PowerShell and Unix Shell scripts to support large-scale backend operations.

● Integrated SQL Server and Oracle environments with external platforms like Azure Dataverse, SharePoint, and Dynamics 365 for seamless data orchestration.

● Provided architectural guidance and mentored development teams on best practices in T-SQL, stored procedure optimization, and modular database design.

● Established and enforced database development standards, coding conventions, and version control practices across multiple project teams.

● Executed large-scale data migrations using SQL*Loader and custom PL/SQL scripts to ensure clean, validated, and structured data movement.

● Played an active role in Agile development ceremonies, including sprint planning, story refinement, and daily stand-ups, ensuring alignment with business goals. Apollo Health and Lifestyle Hyderabad, India

Database (PL/SQL) Developer Aug 2019 – June 2020

Roles & Responsibilities:

● Developed and maintained complex SQL Server and PL/SQL procedures, functions, triggers, and packages to support data warehousing and reporting needs.

● Designed and deployed SSIS packages to extract, transform, and load data from diverse sources including flat files, Excel, vendor feeds, and legacy systems into the data warehouse.

● Created and optimized advanced T-SQL and PL/SQL scripts to automate data operations and ensure efficient data retrieval, transformation, and validation.

● Built SSRS reports for operational, executive, and ad hoc reporting requirements with a focus on performance, usability, and scheduled delivery.

● Utilized Microsoft Access and Excel (including advanced VBA, Macros, Pivot Tables, and Charts) to analyze data trends, build dashboards, and streamline reporting workflows.

● Designed and implemented materialized views, indexes, and partitioning strategies to enhance query performance and minimize data load time.

● Actively participated in data modeling and business requirement sessions to map source data to reporting schemas and support new enhancements.

● Leveraged SQL Server 2005/2008 and Oracle tools like TOAD, PL/SQL Developer, and SQL*Plus for developing and managing schema-level database objects.

● Performed performance tuning and query optimization using execution plans, indexing strategies, and Oracle hints to ensure optimal throughput.

● Conducted ETL testing, data validation, and reconciliation to ensure high data quality and integrity throughout the pipeline.

● Created reusable templates and automation frameworks for ETL processes and reporting structures, significantly reducing development time and increasing consistency.

Contact this candidate