Swetha Sree

Swetha Sree Email and Phone Number

Sr Azure Data Engineer
Swetha Sree's Location
Miamisburg, Ohio, United States, United States
About Swetha Sree

• Over 8+ years of IT experience in Data Design and Development on Microsoft SQL Server2016/2014/2012/2008, T-SQL, Performance Tuning, SSIS/DTS Package Configuration, SSRS, Analysis and Data- Warehousing. • Hands on experience in Azure Cloud serveries, storage, Logic Apps, Data Factory, Azure Monitoring, Key Vault,Event Hub and SQL Azure • Experience in Azure App Service for hosting the web application on Azure. • Experience in Azure Function to compute intensive operations available on-demand that can automatically scale using the cloud infrastructure. • Experience in Creating generic azure pipelines in ADF. • Experience in Azure Databricks • Experience in Azure SQL DB using a scalable, hybrid database platform that has everything built in, from in-memory performance and advanced security to in-database analytics. • Experience in Azure Stream Analytics Cluster and to analyze and process high volumes of fast streaming data from multiple sources simultaneously. • Specialist in T-SQL Programming, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). • Worked Extensively on ETL process using SSIS package. • Experience in Database Development, modeling, Data Warehousing, Design and Technical Management. • Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization and back-up/recovery. • Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member. • Expert in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SSIS services. • Expert in enhancing and deploying the SSIS Packages from development server to production server. • Extensive work experience in development of SSRS, Power Pivot Reports. • Expert in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional , Table, Matrix, Chart, Adhoc and Sub Reports. • Expert in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files. • Created Reports with complex formulas and to query the database for business Intelligence. • Extensive experience with T-SQL in constructing Triggers, Tables, Implementing Stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.

Swetha Sree's Current Company Details

Sr Azure Data Engineer
Swetha Sree Work Experience Details
  • Iqvia
    Sr Data Engineer
    Iqvia Jan 2022 - Aug 2024
    Durham, North Carolina, Us
     Experience in dealing with ambiguities to create rational and functional solution from requirements. Worked with various tasks and transformation in control flow and data flow items Develop conceptual solutions & create proof-of-concepts to demonstrate viability of solutions. Experience in Azure Databricks Delta Lake Medallion Architecture using bronze, silver and gold layer. Worked on Spark with converted into Pyspark code for Geotracker. Worked on data ingestion pipeline using azure databricks notebook, Azure Data factory, External,Internal table,merge, file processing and cluster management in databricks. Design Setup maintain Administrator the Azure SQL Database, Azure Analysis Service, Azure SQL Datawarehouse, Azure Data Factory, Azure SQL Data warehouse. Implementing data ingestion pipelines from multiple sources using Azure Data Factory, Azure DevOps CI/CD,Azure Data Lake, Azure Synapse, Azure Databricks, PySpark, GitHub. Implemented Azure polices to keep control over the types of resources Implemented Copy Activity, Custom Azure Data Factory Pipeline activities Primarily involved in Data migration using SQL, SQL Azure, Azure storage and Azure Data Factory, SSIS Experience in loading data into Azure Synapse analytics Developed and maintained complex ETL pipeline using Apache Spark on Azure databricks to process andtransform multi-terabyte datasets. Setup SQL Server Linked Server to connect multiple servers/databases. Scheduled Triggers and mapping dataflows using adf and used key vaults to store credentials. Implemented Azure Application insights to store user actives and error logging. Migration from Azure SQL data into CRM Dynamics 365 Export and Import process using Azure ADF
    View
  • Bettcher Industries
    Azure Data Engineer
    Bettcher Industries Mar 2021 - Dec 2021
    Birmingham, Ohio, Us
     Develop and implement automation solutions to support operations, provisioning, and cost control ofassets/environments/products. Experience with Azure EventHub, Azure KeyVault, Azure DevOps, Rest API, Event Hub and Key Vault. Using Microsoft platform technologies and Azure resources, design, build and modify existing business tiercomponents, database objects and web applications. Consume information using Azure snowflakes/Azure Synpse Analytics, Azure Machine Learning Services andother azure Data Services. Design and develop database objects, stored procedures, views, functions, tables, triggers and SSIS packages;ensure their stability, reliability, and performance. Design, develop, and maintain SSRS reports based on user requirements. Write and optimize SQL statements for data access and retention. Perform regular database management duties including backups and audits to ensure that SQL databasesremain accessible, secure, and stable. Test databases for performance, fine-tune when necessary. Collaborate with developers on database design, query tuning, and schema refinement. Independently analyze, solve and correct database related issues in real time while providing efficientresolutions. Respond to feedback from users regarding performance and work with developers to improve the performanceof queries and indexes. Tune stored procedures and T-SQL queries to improve performance and sustainability. Provide support for the deployment of database scripts in development, test, QAT and productionenvironments. Monitor database performance parameters to provide fast query responses to front-end users. Study the technical requirements provided by product team and design databases to fulfill the requirements. Participate in all team activities like sprints and project planning. Designed and developed Power BI graphical and visualization solutions with business requirement documentsand plans for creating interactive dashboards.
    View
  • Nih
    Azure Data Engineer
    Nih Mar 2018 - Feb 2021
     Work with business teams to understand current business processes for onboarding acquired bulk claims data/ Assess the viability of a solution for onboarding acquired claims data into legacy applications. Evaluate legacy solution and technology to understand viability of leveraging these to match requirements fornew application. Evaluate database structures to further understand processing of claims data Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS,PowerShell Designs, develops, tests, and implements applications. Microsoft Azure (Function Apps, Cosmos Db, DurableFunction Apps, Event Grid, Azure Data Factory, Logic Apps, Service Bus, Storage Accounts, etc.) Implemented Copy activity, Custom Azure Data Factory Pipeline Activities Help develop evaluation findings results and assist development of recommended solution architecture Used advanced features of T-SQL in order to design and tune T-SQL to interface in Azure cloud and otherapplications in most efficient manner Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data intotarget data sources by performing Deployed and Generated SSRS reports using the Reporting Services and Report Manager Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascadingparameterized reports using SSRS. Analyze and create complex SQL Queries, database scripts, stored procedures, triggers etc. as well astroubleshooting and optimizing Created pipelines, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recoveryprocedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios in Production Implemented SSRS solutions, used dashboards and gauges to enhance for the business users.
  • Lids
    Business Intelligence Developer
    Lids Jun 2017 - Feb 2018
    Indianapolis, Indiana, Us
     Interacted with technical team and Business users to perform analysis of business requirement Assist clients by helping to develop end to end solutions for clients Understand the business issues and data challenges of clients and translates them to specific data requirements. Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages Monitoring performance and managing parameters to provide fast query responses to front-end users Experience in troubleshooting and resolving database integrity issues, performance issues, blocking anddeadlocking issues  Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and otherrelated monitoring and troubleshooting tools Partner with leadership and internal stakeholders to understand business and end-user needs, gain subjectmatter expertise and assess key opportunities, then design and implement high quality data and reportingsolutions. Communicate with report consumers and other stakeholders to elicit and document reporting requirements andpropose appropriate solutions. Design, document and develop functional and technical specifications, report mock-ups, prototypes, and finaldelivery of reporting solutions. Proactively work to improve and automate reporting processes. Created packages in SSIS with error handling as well as created complex SSIS packages using varioustransformations and tasks like Sequence Containers, For loop and For Each Loop Container, Execute-SQL, ExecutePackage, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join,Row Count, Union All, flat file source and destination, OLE DB source and destination, excel source anddestination Design and conversion of reports from other reporting platforms to Microsoft SSRS. Administration and configuration of SSRS servers. Develop ad-hoc queries and stored procedures for data mining and data validation.
    View
  • Factset Systems India Private Ltd
    Sql Server Developer
    Factset Systems India Private Ltd Apr 2013 - Sep 2014
     Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS). Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using ofSQL Server2008 r2 Integration Services (SSIS) Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring,and archived data files for different DBMS Involved in creating highly interactive score cards and Dashboards using Performance Point Server. Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 r2 from differentenvironments for the SSAS cubes Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries. Involved in designing, developing, debugging and testing of reports in SQL Server 2008 r2 Reporting Services(SSRS) Generated several drill down and drill through reports using SSRS Expert in creating Star schema cubes using SSAS Designed and created the table schema and stored procedures that will be used in Data QC Designed and developed the Data QC Maintenance website that will be used to maintain the application tables,execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file Daily support of system wide replication tasks including monitoring, alerting, and problem resolution. Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL andSQL Analyzer Migrated data from various sources into SQL Server using SQL Server Integration Services Created complex reports which includes cascade parameters, multivalve parameters and conditional formattingto generate user friendly reports Created reports using Reporting Services 2008 to retrieve data using database code objects such as storedprocedures, views and multiple T-SQL queries Provides technical documentation of the system
    View

Frequently Asked Questions about Swetha Sree

What is Swetha Sree's role at the current company?

Swetha Sree's current role is Sr Azure Data Engineer.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.