Sindhu Deshineni
Lewisville,TX
Overview
11
11
years of professional experience
5
5
years of post-secondary education
Work History
Senior Software Engineer
Globys
Seattle, Washington
07.2023 - Current
- Designed and developed SSIS packages for ETL processes, focusing on data extraction, transformation, and loading from diverse data sources to target systems.
- Created and optimized complex SQL queries and stored procedures for data manipulation and reporting; enhanced database performance through indexing and query tuning.
- Managed and optimized data workflows using Azure Data Factory; integrated various data sources with Azure services to streamline data processing and storage.
- Developed and maintained detailed reports and dashboards, addressing key business metrics and providing actionable insights to stakeholders.
- Implemented best practices in data modeling and database design, ensuring efficient data retrieval and reporting capabilities.
- Conducted performance tuning of SSIS packages and SQL queries, identifying and resolving bottlenecks to improve overall system efficiency.
- Enhanced software functionality by identifying and resolving complex technical issues.
- Worked closely with cross-functional teams to gather requirements, design solutions, and ensure alignment with business objectives.
Azure Data Engineer
CarCapital
Grapevine, Texas
5 2022 - 06.2023
- Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
- Experience in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service
- Involved in creating the external and internal tables in Azure SQL Data warehouse, SQL Server and created stored procedures to move the data from external to internal tables
- Involved in Architecting and developing the Azure data factory pipelines by creating the datasets and source and destination connections to move the data from Azure SQL database to Azure Data Lake Raw Zone
- Installed SQL server Database engine, SSIS & SSRS features
- Design and developed business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, operations and finance team needs
- Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets, and sessions
- Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
Azure SQL/ETL Developer
Fairway Independent Mortgage
Carrollton, Texas
01.2019 - 05.2022
- Created complex stored procedures to perform various tasks including, but not limited to index maintenance, data profiling, metadata searches, and loading of the data mart
- Designed, developed, and tested the ETL strategy to populate data from multiple source systems
- Created master-child packages to consolidate data from data sources into SQL server with execute package tasks, enabling modular programming
- Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets, and sessions
- Designed SSRS reports for in depth business analyses
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
- Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
- Microsoft Azure and setting up communication with the help of endpoints
- Helped to develop a backup and recovery strategy for databases on a virtualization platform utilizing Microsoft Azure.
MSBI Developer
Cisco
Ann Arbor, Michigan
02.2018 - 01.2019
- Encapsulated frequently executed SQL statements into stored procedures to reduce the query execution times
- Performed data cleansing and scrubbing in the staging database
- Created SSIS packages to implement error/failure handling with event handlers, row redirects, and loggings
- Optimized SSIS packages utilizing parallelisms, fast load options, buffer sizes, and checkpoints
- Managed packages in the SSISDB catalog with environments; automated execution with SQL agent jobs
- Created data models and data flow diagrams for the to-be process
- Strong experience with migrating databases to snowflake
- Hands on experience on SnowSQL, Snowpipe for continuous data load
- Experience in creating data sharing between two snowflake accounts and redesigning views to increase performance
- Experience migrating and creating reports in Looker based on Snowflake connections.
MSBI Developer
Acquisto
MA
01.2017 - 01.2018
- Developed various dashboards, used context filters, sets while dealing with huge volumes of data
- Designed dashboards for actionable, non-actionable complaints from Multidimensional databases
- Generated dashboards to compare the expected weekly registration and physician specific registrations used dual axis for comparison
- Generated Dashboards by joining multiple complex tables
- Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
- Supported business decision-making by creating interactive dashboards for data visualization in Power BI.
SQL/ETL Developer
Teesage Fabrications
NY
07.2016 - 02.2017
- Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources
- Experience creating SSIS Packages to export flat files
- Developed Stored Procedures, Triggers, Functions and T-SQL Queries to capture updated and deleted data
- Used different data Transformations like Lookup, Derived Column, Conditional Split, data conversion while creating the SSIS Packages
- Effectively handled data errors during the modification of existing reports and creation of new reports.
SQL Database Developer
IBM
05.2013 - 12.2014
- Created functional/non-functional requirements via JAD sessions
- Designed data integration process and collaborate with business analyst for various project needs
- Developed complex stored procedures and functions to perform data profiling and business calculations
- Created SSIS packages to perform incremental loads using timestamps
- Devised complex expressions for calculations, groupings, filters, and formatting contents of SSRS reports.
Education
Master of Science - Technology Management
TEXAS A&M UNIVERSITY
01.2014 - 08.2015
Bachelor of Science - Computer Science And Technology
VIT
10.2010 - 05.2014
Skills
Azure SQL Database, Azure Data factory, Azure Data Lake, Synapse Analytics
Data Visualization, Data Migration,, Data Warehousing Data Modeling
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSA)
Informatica, Power BI, Tableau
SQL Server, Snowflake
C#, NET, Python, R
References
References available upon request
Timeline
Senior Software Engineer
Globys
07.2023 - Current
Azure SQL/ETL Developer
Fairway Independent Mortgage
01.2019 - 05.2022
MSBI Developer
Cisco
02.2018 - 01.2019
MSBI Developer
Acquisto
01.2017 - 01.2018
SQL/ETL Developer
Teesage Fabrications
07.2016 - 02.2017
Master of Science - Technology Management
TEXAS A&M UNIVERSITY
01.2014 - 08.2015
SQL Database Developer
IBM
05.2013 - 12.2014
Bachelor of Science - Computer Science And Technology
VIT
10.2010 - 05.2014
Azure Data Engineer
CarCapital
5 2022 - 06.2023
Similar Profiles
Ratih WibowoRatih Wibowo
Senior Technical Support Specialist at GlobysSenior Technical Support Specialist at Globys
Subhash SaladiSubhash Saladi
Volunteer at YMSLVolunteer at YMSL
Deysy JaimesDeysy Jaimes
Specimen Processing Technician at Quest DiagnosticsSpecimen Processing Technician at Quest Diagnostics
Edrick BronsonEdrick Bronson
Forklift Operator at Pacesetters Personnel ServicesForklift Operator at Pacesetters Personnel Services
David TorresDavid Torres
National Product Manager at PRGNational Product Manager at PRG