Power Bi Scrum Master

Synopsis: over **+ years of IT Experience in different capacities, primarily in the areas of Database Development, ETL tools, data warehousing, Reporting, Analytics, Maintenance & Support. Have exposure to domains like Insurance, Healthcare, Finance and Banking.

EXPERIENCE SUMMARY

Has over 16+ years of experience in Database Development, ETL tools, data warehousing, Reporting, Analytics, Maintenance & Support.

●12 years of experience in SSIS, SSAS and SSRS. In-depth knowledge of SQL Database engine and Dynamic management views. Knowledge of SQL Cardinality algorithms. Index algorithms.

●Knowledge of designing and implementing relational database models as per business needs.

●In-depth knowledge of Transact-SQL and Query Performance tuning, dynamic queries, resource manager tuning.

●Knowledge in creating complex Stored Procedures, derived tables, common table expressions (CTEs) to facilitate efficient data manipulation and data consistency.

●Knowledge of using variables and expressions in packages.

●Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.

●Experience in creating Jobs, Alerts, and schedule DTS/SSIS Packages.

●Handling the Project Delivery and Scrum master role, ticket assignments for team members and performance appraisals.

●Managing Technical Team and doing performance appraisals for technical resources for last 6 years.

●I am managing 12 team members and take care of their end-to-end performance cycle throughout the year.

●Leading the development team in the design, development, coding, testing and debugging of applications

●Managing all the activities of the software development team and setting goals for each team member to ensure timely project delivery.

●Keep up to date with the latest development software.

●Hire and train new developers.

●Provide guidance to the team and ensure they adhere to development standards.

●Ensure proper documentation.

PROJECT EXPERIENCE

Hexaware, Mumbai Nov 2023 – 17th Oct-2025

Technical Lead

Project name: - SDW Tuning and Decommissionings

Project Description: Worked in SDW decommissioning project remotely for Carlyle Client in a Finance domain project. Technologies used in the project were MSBI stack (SQL, SSIS, SSAS), Snowflake and Power BI.

HCI Active, Mumbai July 2022 – Oct 2023

Technical Lead

Project name: - Health care System

Project Description: We are receiving files of employee, dependent and plan details. We are loading Those files in Our system and provide information as per there requirement.

●Team Manager, handling 11 members.

●JSON file Load in SQL server for 1 TB using SSIS.

●Document loading in Azure blob using SSIS.

●Convert JSON data in Row and import in Prod database.

●Data Migration form SQL 2012 to SQL 2019

●Requirement gathering, Analysis, Understand the business requirements and specifications from the business and technical perspective.

●SQL performance fine tuning,

●Creating new SSIS, SSRS, SSAS

●Creating New MS Power BI Report

●Creating New Pipeline Using Azure ADF.

●Modifying existing SSIS, SQL Script, ADF and POWER BI

●Deployment of SSIS, POWER BI in higher environment.

●Handling release management on QA, UAT and Prod environment.

●Doing Job Monitoring work and supporting to Business Users on reports

●Provide access to the system.

CAPGEMINI, Mumbai June 2021 –June 2022

Technical Project Manager

Project name: - TransAmerica

Project Description: TranAmerica project taking data from multiple sources and generating report in Power BI & excel using SQL Agent jobs. Creating new pipeline using Azure ADF.

●Team Manager, handling 10 members.

●Requirement gathering, Analysis, Understand the business requirements and

●SQL performance fine tuning,

●Creating new SSIS, SSRS, SSAS

●Creating New MS Power BI Report

●Creating New Pipeline Using Azure ADF.

●Modifying existing SSIS, SQL Script, ADF and POWER BI

●Deployment of SSIS, POWER BI in higher environment.

●Handling release management on QA, UAT and Prod environment.

●Doing Job Monitoring work and supporting to Business Users on reports

●Provide access on the system.

NESS, Mumbai June 2020 –May 2021

MSBI Specialist

Project name:- Rovi Video

Project Description: Rovi Video project involves regionals wise collecting data from multiple sources and creating CSV files, converting in zip and stored in FTP location. Each zip file size is minimum 5 GB and maximum 400 GB.

Another process where same zip file copied from FTP to servers and unzip all files in respective folder and stored data in SQL server database. System is keeping last 10 days data.

Created multidimension cubes for business to analyze data in excel and tabular cubes used in Power BI reports.

Creating multiple Power BI reports helps you build different charts and graphs to visualize the data.

●Team Manager, handling 7 members.

●Requirement gathering, Analysis, Understand the business requirements and

specifications from the business and technical perspective.

●SQL performance fine tuning,

●Creating new SSIS, SSRS, SSAS

●CO-ordination with Onsite for requirement gathering.

●Creating new SSIS, SSAS, POWER BI

●Modifying existing SSIS, and flow. SSAS, POWER BI

●Deployment of SSIS, SSAS, POWER BI in higher environment.

CAPGEMINI, Mumbai Nov 2010 – June-2020

Technical Project Manager

Managed offshore development team of 10 for MSBI (SSIS, SSRS, SSAS) and SQL server (T-SQL, Store procedure, trigger, function), MDM, VBA

Project name: - Party Reference Data

Project Description: Party Projects involves phase wise mastering all the Organization & Individual data into newly modeled Party domain. As part of this project information is being retrieved from all the different legacy source systems into one common data store which then serves as source to Master. All the records from this data store is then send to for validation/Cleansing to third party vendor

Except from Party domain, Data from Reference Files (for various domains) placed on File Share Server are loaded at a scheduled time (Insert/Update) into staging tables using the defined business logic and eventually loaded in MDS as Master/Reference data. Data from MDS, incrementally extracted and loaded into Willis Reference (SCD logic) and made available to different APIs.

Created Multidimensional Model Cubes and Tabular Cubes for business to analyze data in excel and tabular cubes used in Power BI reports.

Business user can see data in one place and they analysis and below advantage are given: -

Data warehouse allows business users to quickly access critical data from some sources all in one place.

Data warehouse provides consistent information on various cross-functional activities. It also supports ad-hoc reporting and query.

Data Warehouse helps to integrate many sources of data to reduce stress on the production system.

Data warehouse helps to reduce total turnaround time for analysis and reporting.

Creating multiple Power BI reports helps you build different charts and graphs to visualize the data.

Team Manager, handling 12 members.

Requirement gathering, Analysis, Understand the business requirements and specifications from the business and technical perspective.

Creating Data Modeling

SQL performance fine tuning,

Creating new SSIS, SSRS, SSAS

CO-ordination with Onsite for requirement gathering and offshore team.

Creating & Modifying Python Script

Creating new SSIS, SSRS, SSAS, Power BI

Creation of New Entity, Attribute and Business rules in MDS

Deployment of MDS, SSIS and SSRS elements in higher environment

Project name: - GBClaims

Project Description: ERL Application is used by CL&R, MetLife Sales Force and MetLife Sales Offices for Data Entry and enquiry purposes.

●Team Manager, handling 4 members.

●Requirement gathering, Analysis, Understand the business requirements.

●SQL performance fine tuning,

●Creating new SSIS, SSRS

●CO-ordination with Onsite and offshore team.

●Creating Data Modeling

●Successfully designed process and created templates to be followed by each team member.

●Designed & modified SSIS packages and SSRS reports as per business requirements.

●Re-designed existing SSIS package & SSRS report to optimize the process.

●Writing procedures, functions, cursors, triggers.

●Creation of Technical Documentation related to the tasks.

●Gathering requirements from business.

●Successfully analyzed business requirements and created effort estimation based on the function

points.

●Work distribution to team members and ensured that work completed as per requirement.

● Leading the development team in the design, development, coding, testing and debugging of

applications

● Managing all the activities of the software development team and set goals for each team

member to ensure timely project delivery.

● Keep up to date with the latest development software.

● Hire and train new developers.

● Provide guidance to the team and ensure they adhere to development standards.

● Ensure proper documentation.

● Ensure Time sheet and Invoice.

Project name: - INSPRO

Project Description: It was a conversion project. We have converted mainframe to SQL server.

Successfully designed process and created templates to be followed by each team member.

Designed reporting database to be used to generate reports.

Successfully analyzed business requirements and created effort estimation based on the function points.

Allocated tasks to team members.

Designed SSIS packages which act as interfaces between mainframe system and INSPRO system.

Created technical design document, unit test cases and deployment checklist.

Performed peer and peer to peer review of the packages created.

CO-ordination with Mainframe team.

Technically helping to team.

MILES SOFTWARE, Mumbai Nov 2007 – Oct 2010

Senior Software Engineer

Managed 4 members technical team through all project cycle, including requirement gathering/ analysis, solution designs, development and implementation. Managed communication with business users.

Project name: - SRGELT/PAS (Moneyware Integra)

Project Description: - It's a Back office system which consist trading in modules like Equity, Derivatives (Options, Futures), Bond and SLB

Handling entire development task single handedly, where the entire development is done in VB 6.0 using SQL server 2000 as database.

Designing Reports using Crystal reports.

Taking support calls from User and IT Head and providing solutions.

Coordinating with Users, IT Head and Project manager for development of new requirements and issues encountered by users.

PERSONAL DETAILS

Name: Sandeep Ramadhar Mishra

Email Address: ***********.******@*****.***

Mobile Number: 996-***-****

Marital Status: Married

Nationality: Indian

Sex: Male

QUALIFICATION

Degree

Institute

Year

MBA

SMU, Mumbai, India

2013

Diploma in Computer Programming

NIIT, Mumbai, India

2002

Bachelor of Commerce

SSGHS, Mumbai University, India

2001

Areas of Experience

Industries

Insurance

Healthcare

Finance

Banking

Languages

SQL, Power Shell Scripting, VB6.0, VBA Macros

RDBMS

MS SQL Server

MS Access, Snowflake

Cloud

ADF

BI Tools

SSIS, SSRS, SSAS, SSMS

PowerBI Crystal Report

Operating Systems

Windows 98/NT/XP

Testing Management Tool/Defect Tracking Tools

JIRA

Source Safe Tools

SVN

GIT

TFS

Contact this candidate