Ayush Rawat

Background

About Ayush Rawat

Total 12+ years of working experience as Microsoft SQL Server Database Developer and Microsoft Business Intelligence developer. • Experience in BI Development in implementation of Data warehouse/BI solutions and expertise in SSIS for integrating data from different sources in to a data warehouse. • Business / Partner interactions to streamline the process and document the requirement. • Experience T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions. Writing SQL queries as per business needs. • Hands on experience in Performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes. • Experience in developing SSIS packages for integrating data from different sources (Oracle, SQL, Text Files, Excel & etc.) in to a data warehouse. • Involved in Huge data migrations, transfers using utilities like SSIS, and Bulk Insert. Expert in Extracting, Transforming and Loading (ETL) the data using SSIS Tool. • Creating mappings/workflows to extract data from different OLEDB Source (SQL Server), Flat File sources, Excel File Sources and load data into various Business Entities. • Used Control Flow Tasks like for Loop Container, For Each Loop Container, Sequential Container, Execute Task, Email Task, and Data Flow Task. • Proven proficiency at Data Transformations like Derive Column, Conditional Split, Aggregate, Row Count, Sort, merge, and Execute SQL Task to load data into Data Warehouse. • Created SSIS packages for full refresh and incremental data loads in warehouse as per business needs • Experience in Performance Tuning for SSIS packages by Implementing Design Time Considerations and Configuring the Components Properties. • Experience in installation, upgrade and configuration of Microsoft SQL Server databases. • Hands on expertise in migrations from MS SQL SERVER 2012 to MS SQL SERVER 2016 • Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages. • Broad experience in Query Optimization and performance tuning of stored procedures, functions etc. • Experience in Dimensional Data Modelling Star and Snow Flake Schemas. • Experienced in a fast - paced Agile Development Environment including Test-Driven Development (TDD) and Scrum • Good experience in project support via Service Now tool.