Sanjay B Email & Phone Number

IT experience as a Microsoft SQL Server 2019 & 2022. Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS. • Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server Experience with all phases of software development life cycle (SDLC) and project methodologies. • Excellent skills in implementing ETL Packages using Data Transformation Services (DTS) and Migrated DTS packages to SSIS and modified using DTS editor wizard. • Developed a dashboard solution for analysing STD statistics by building SSIS 2012 cubes and Tableau using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer. • Worked with the Version control Systems like Team Foundation Server (TFS), Visual Source Safe (VSS). • Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot). • Trained and experience in working on Splunk and developing dashboards on Splunk server. • Extensively worked on Erwin Data Model Tool and good knowledge of Relational Database Modelling/Loading and Dimensional database modelling concepts. • Proficient in creating Standard Subscriptions and Data driven subscriptions for delivering reports to people internally within the project. Expert in deploying the SSRS reports using Report manager. • Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS. • Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and various delivery mechanisms. • Strong experience with Crystal Reports. Strong Data Mapping Experience.

• 

  University Of Delaware

  Computer Science