Santosh Thumala-
Summary:
Microsoft certified Power BI Data Analyst(PL-300) with over 10 years of Experience in Business Intelligence Applications - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Azure Data Factory (ADF).
Developed Data Pipelines, integrating from different sources into a unified data systems
Maintained the Data quality and optimized data retrieval
Experienced in Business Intelligence, Data Warehouse reporting and dashboard.
Designed, Prepared, fine-tuned, and implemented inbound/outbound SSIS automation to extract, transform and load data from various sources to target DB.
Develop and Document the standard data processes.
Perform periodic Data Quality reviews for internal and external data.
Strong knowledge and experience of MS Integration Services (SSIS) and SQL Server Reporting Services (SSRS). Involved in all phases of SDLC.
Strong experience in advanced T-SQL. Window Functions, Common Table Expression, Stored Procedures, Functions, Triggers, and Queries tuning.
Experienced in Power BI and created various Dashboards
Very good knowledge of Azure Data Factory(ADF), Team Foundation Server (TFS), MYSQL, Python, Tableau, GitHub, C#.Net and Visual Studio
Skills:
Power BI
DAX
SSIS
SSAS
SSRS
Azure Data Factory
Python Pandas
T-SQL
C#.Net
MySQL
Power Automate
MS Office
Python Programming
ETL development
SQL Proficiency
Data Quality Assurance
Data Migration
Data Mapping
Data Governance
Data Security
Data Modeling
Performance Tuning
Data Warehousing
Master Data Management
TFS
GITHUB
NoSQL Databases
Data Cleansing
Data profiling
Data Analysis
Professional Experience:
McKesson Canada, Toronto May 2019 to Present
Data Management Analyst
Created and managed data Pipelines to move data from more than 15 sources into our data warehouse using ADF.
Connected more than 10 various connectors using Power Query like Snowflake, Salesforce objects and inline Databases and cloud databases to create data marts.
Provided continued maintenance and development for more than 25 existing and new Pipelines.
Designed Snowflake and Star schema for report development.
Saved documentation of the SSIS packages for understanding the process and used in Knowledge Transfer.
Created many power automate reports and helped the company save more than 20 work hours per week
Implemented complex SQL queries using store procedures, common table expressions, temporary tables to support Power BI and SSRS queries
Revamped Indexes and made the queries perform 25% faster.
Revised more than 100 Reports in SSRS including the dashboards for the different clients.
Generated Data Driven Reports to send the faxes to 1000+ users at once.
Created 50+ SSIS packages and updated as per the requirement.
Developed and maintained over 100 robust SSIS jobs to facilitate seamless data migration from legacy servers to staging databases, reducing manual intervention by 80 hours per month in the data loading process.
Generated complex calculated measures using Data Analysis expression language (DAX).
Flextrack, Toronto October 2014 to May 2019
BI Developer
Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
Created Efficient Stored Procedures, Triggers, and Functions, Indexes, Tables, Views and other T-SQL scripts.
Involved in Creating Data warehouse based on Star schema and worked with SSIS packages to load the data into the database.
Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining more than 25 SSIS packages.
Established 50+ Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
Generated Reports using Global Variables, Expressions and Functions for the reports.
Modified existing reports according to requirements of the end users and improved Report Performance by 20%.
Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
Created the structure of the model and cube in MS Analysis Services (SSAS 2014).
Designed and implemented Dashboards and Scorecards with business
Implemented the calculations to aggregate physical measures.
Supported .NET applications coded using MVC, C#.NET and VB.NET
Home Trust, Toronto August 2011 to September 2014
Software Developer
Responsible for creating Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers in MYSQL.
Introduced indexed views, and appropriate indexes to cut the query run time 40%.
Developed SQL scripts to Insert/Update and Delete data in MYSQL database tables.
Maintained Change Control and Release Management process for all database objects like Tables, Views, Procedures and Triggers.
Enhanced database efficiency by implementing advanced indexing techniques and updating statistical data, reducing data retrieval times by 25% and facilitating faster decision-making for data-driven initiatives.Created queries with Inner Join, Outer Join, left join, right join and Co-Related sub-query with Mathematical function, Aggregate function.
Extensively used Joins, sub-queries for complex queries involving multiple tables from different databases.
Team member in the development of the new front-end Heritage Portal web application and the mid-tier web services (Object Oriented Design, .Net, Visual Studio, C#, SQL Server).
Academic Qualification:
PG diploma in software engineering and technology – Centennial College, Toronto.
Bachelor of technology in Computer Science Engineering - JNTU, India.
Certification: Microsoft Certified: Power BI Data Analyst Associate
https://learn.microsoft.com/api/credentials/share/en-us/SANTOSHTHUMALA-5520/14859ACC527C46EC?sharingId=14FE0016B0B6961C
