Sushma Boyapati

+1-647-***-**** ad15np@r.postjobfree.com

Summary

Data Analyst professional with 4 years’ experience in designing, coding, testing and supporting next-generation database solutions in Database warehousing, Business Intelligence, performance optimization, query, objective environment, and PL/SQL Server environments. I have a passion for learning and implementing new technologies and techniques, which has helped me stay updated with the latest trends in the industry.

Proficient in writing complex SQL queries using joins, subqueries, and correlated subqueries to retrieve data.

Have experience at using Triggers to carry out various tasks from the database.

My focus on performance tuning of T-SQL queries, including index tuning, query optimization, and partitioning, has enabled me to optimize the efficiency of database solutions.

I have extensive experience in designing and developing SSIS Packages for loading data from text files and CSV files to SQL Server databases using SSIS.

Proficient in migrating data between different heterogeneous sources such as Flat file and Excel 2005, and in using different control flow elements like Data Flow Task, Execute SQL Task, Script Task, and Send Mail Task.

Experienced in using different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column, etc.

Work closely with lenders Client Care departments and runs a Delta report to deploy changes to the database on weekly basis.

Configured Backups, Optimization jobs and involved in Restoring database to point in time in case of issues.

Have experienced in enhancing and deploying the SSIS Packages from development server to production server.

Experienced with working on reporting tools like Crystal Report, SSRS and Report Builder 3.0.

Created Database Objects like tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement.

Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.

Designed a Data Warehouse solution, gathering data from multiple databases and making it available for analysis through secure dashboards and reports.

Expert in creating multiple kinds of Power BI Reports, Dashboards and Visualizations

Created a basic table report using MSSQL, SSRS and SSDT.

Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models. Education

• Graduate from St. Francis college for women-Hyderabad, India- year June 2016 to April 2019. Technical Snapshot

Database: MS SQL Server, SQL Server analysis services, SQL Server integration services, SQL Server reporting Service 2016/2014/2012/2008 R2 environments.

Programming Language: SQL, PL/SQL, SSRS, SQL*Plus, Java, HTML, XML, C, C++.Azure, AWS. System administration: Unix, Windows, Virtual Machines Software: Microsoft office, Adobe Creative, Suite

Professional Experience

Wunderman Thomson Jan 2021 - present

Role: Data Analyst

• Collaborated closely with end-users to write functional specifications based on business requirements.

• Analyzed source data and worked with the Data Warehouse team to develop Relational Models.

• Implemented and managed ETL solutions, focusing on automating operational processes and ensuring high data quality.

• Wrote complex SQL queries using joins, subqueries, and correlated subqueries to retrieve data, and created Triggers to perform various tasks within the database.

• Focused on performance tuning of T-SQL queries, including index tuning, query optimization, and partitioning.

• Deployed SSIS packages in Development and Testing environments, creating ETL packages to validate, extract, transform, and load data into the data warehouse and data mart databases.

• Designed and developed SSIS packages for loading data from text files, CSV files, and other sources to SQL Server databases.

• Scheduled SSIS jobs using SQL Server Agent for daily, weekly, and monthly loads.

• Migrated data between different heterogeneous sources, including Flat files and Excel, using SSIS.

• Experience in Error handling, Debugging, error logging for production support in SSIS

• Used various control flow elements, such as Data Flow Task, Execute SQL Task, Script Task, and Send Mail Task, and data flow elements, such as Flat File, OLEDB, Excel Sources and Destinations, and Data Flow Transformations like Data Conversion, Conditional Split, and Derived Column.

• Created Schema Database diagrams, Table structures, and maintained relationships with constraints and indexes as per business logic.

• Created Stored Procedures, User Defined Functions (UDF), Views, Joins, and System Defined Functions, as well as Temp Tables and Table Variables.

• Wrote complex T-SQL queries using joins, subqueries, and correlated subqueries to retrieve data and used Triggers to perform various tasks within the database.

• Created DAX Queries to generate computed column in Power BI.

• Expert knowledge in SDLC (Software Development Life Cycle) and was involved in all phases in projects. Skills: SQL, T-SQL, SSIS, DAX, Debugging, T-SQL

Pronix Inc, Hyderabad, India May 2019 to Nov 2020

Role: Data Analyst

• Installation and configuration of MS SQL Server 2008/12/14 on window 2007/8 OS.

• Created Database and Database objects like Views, Indexes, Trigger and Stored Procedures using T-SQL.

• Hand on experience in analyzing, design, and build modern data solutions using Azure PaaS service support Visualization of data.

• Extract/transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics

• Done Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks.

• Troubleshooted and resolved SQL Server connectivity issues.

• Created SQL statements, extracted and transformed data using SSIS.

• Used SQL Server Profiler to monitor the server Database Tuning, Application Tuning, performance monitoring, debug T-SQL and slow running scripts and maintained documentation.

• Created a basic table report using MSSQL, SSRS and SSDT.

• Simplifying complex queries using minimum joins and sub-queries involving multiple tables.

• Maintain database security with up-to-date patches, created and maintained users and roles, assign privileges.

• Performed and planned database backup, restore and recovery when necessary.

• Experience in troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.

• Created SSRS dashboards using charts, gauges, indicators and data bars.

• Deployed SSRS reports in native and share point mode.

• Based on the requirement for different executive dashboards, analysis and model flows from various sources to integrate into Tableau Dashboard.

• Accumulated 3 business environments into single environment, implemented always on Availability groups for HADR using SQL server 2008R2,2016/2014/2012 Enterprise edition.

• Used Power BI, Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize Report.

• Used Power BI Gateway and Scheduled Automatic Refresh to keep the Reports and Dashboards up to date. Skills: MS SQL Server 2008R2/2012/2014/2016, SSIS, SSRS, Studio, Windows 7, MS Office 2010/2013, Windows Server 2008 and Windows Server 2008 R2, Power BI Desktop, Power BI Service.

Contact this candidate