Mudit Sirohi

Background

About Mudit Sirohi

14+ years of IT experience with more than 12 years in database development, spanning across Payroll/Benefits, Property Insurance & Finance domains. Strong experience in T-SQL, DTS, SSIS, SSRS, SQL Server 2005, SQL Server 2008R2, SQL Server 2012, SQL Server 2017, and Power BI. Competent in Extraction, Transforming, and Loading (ETL) data flows using SSIS and DTS, creating mappings/workflows to extract data from Oracle, SQL Server, and Flat File sources. Proficient in Creating Indexes, Views, Triggers, Functions, and stored procedures to facilitate efficient data manipulation and data consistency. Experience in Query tuning and performance optimization of queries by using Execution Plan and SQL Profiler. Experience in creating Script Tasks and Script Component in SSIS using C#. Experience in SSIS package development, deployment, and scheduling. Experience in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall and agile methodology. Extensively used Report Wizard, Report Builder, and Report Manager for developing and deploying reports using SSRS. Developed and maintained Cascading, Drill-down, Drill-through, Dashboards, and Parameterized Reports using SSRS. Designed SSRS reports with sub-reports, dynamic sorting, and grouping, defining data sources and subtotals for the report. Experienced in creating custom columns and measures using DAX, developing Paginated Reports, Dashboards, and dynamic Navigation bars in Power BI. Experienced in creating different types of workflows like desktop flows, automated flows, instant flows, and scheduled flows using Power Automate. Used Power Apps to trigger Microsoft flows in Power BI reports. Experience in requirement gathering, customer interaction, and collaborating closely with stakeholders to ensure alignment between business needs and technical solutions. Efficient in work allocation management, utilizing a blend of complexity assessment and colleague performance evaluation to ensure optimal resource utilization and project success. Experience in managing team efficiency and business SLAs for the deliverables. Conducting performance review meetings with team members and providing constructive feedback.