Santosh T Email & Phone Number

SKILLS: • SSIS• SSAS• SSRS• Azure Data Factory• Python Pandas• T-SQL• Power BI• DAX• 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 • 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.• Created 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).• 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).