Sql Server, Power Bi, Azure, Snowflake

Srujana Gontyala

+* (***) *** - **** **********@*****.*** Dallas, TX

LinkedIn: https://www.linkedin.com/in/srujana-gontyala-a9ba7a53/ Technical Skills

Languages: MS SQL, T-SQL, Azure SQL, Snow SQL, Python, DAX Databases: MS SQL Server, Azure SQL DB, Snowflake, DB2 Tools: Git, Visual Studio for SSIS and SSRS, Power BI, SSMS, Azure Data Factory, Databricks

Cloud Platforms: Azure Data Factory, ADLS Gen2, Azure Blob storage,, Snowflake, Power BI, Azure Databricks cloud platforms

Experience

Accenture, - Hyderabad, India

Application Development Senior Analyst Apr 2021 – July 2022

● Led End-To-End Design, Implementation and Testing, ensuring seamless execution and successful delivery.

● Designed Data Processing, Analyzed Data Ingestion, and Created Database Objects in Azure SQL DB and SQL Server

● Worked on designing and creating database and database objects in Azure SQL DB and data migration from SQL Server to databases in Azure SQL DB and files in Azure data lakes gen2.

● Migrated Data from third-party servers to local on-prem SQL servers, Snowflake and Azure Data Warehouse .

● Developed ETL/ELT pipelines in ADF and Azure Synapse, using triggers for scheduling and error logging functionality to proactively address any issues. Create and use self-hosted integration runtime.

● Worked on creating SSRS and complex Power BI reports and dashboards from Snowflake, SQL Server, Azure DB and other data sources.

● Perform testing of SQL code, Pipelines, jobs and reports in different test regions.

● Testing packages\report\pipeline\SQL code in Development\Stage\Prod regions. Preparing unit test reports (UTR) and test scripts for the same.

● Mentored fellow teammates on their coding and monitoring pipelines in ADF and ADLS during the project.

● Attend scrum meetings to report progress, collaborate with the team on assigned stories and proactive create new tasks to maintain transparency and support a collaborative work environment. Yash Technologies, - Pune, India

Senior Software Engineer Apr 2019 – Apr 2021

● Utilized Microsoft Azure, Snowflake, SQL Server, T-SQL, SSIS, SSRS, and Power BI for development activities.

● Designed database schemas, tuned stored procedures in SQL Server, and created SSIS packages.

● Managed CI/CD pipelines for ETL/ELT tasks in Azure Data Factory, Databricks clusters, and data loading to Azure Blob storage, Snowflake, and SQL Server.

● Automated data flow processes in Snowflake and Azure Data Factory.

● Created custom reports and dynamic dashboards using SSRS and Power BI from various data sources.

● Conducted unit testing and prepared technical design documents and estimates.

● Utilized ServiceNow and Jira for incident management and project tracking. Capgemini, - Hyderabad, India

Consultant Aug 2013 – Apr 2019

● Proficiently utilized Microsoft Azure, Snowflake, SQL Server, Visual studio, SSMS and related tools to drive impactful development projects.

● Expert in database design, stored procedure optimization, and SSIS package and SSRS report development.

● Skilled in managing end-to-end data pipelines, SSIS jobs, creating custom SSRS reports, and dynamic Power BI dashboards for actionable insights.

● Led testing efforts, CI/CD deployments, and provided valuable technical insights for project success.

● Proficient in incident management with ServiceNow and project coordination using Jira.

● Confidently facilitated team training sessions on SSIS proficiency. Education

G.Narayanamma Institute of Technology and Science, Hyderabad, TS, India Bachelors in Electricals and Electronics Engineering GPA: 3.2 2009 - 2013

Contact this candidate