Sunil Kumar

Project : Anthology (formerly Blackboard, U.S.)

Project Description:

Blackboard is a leading EdTech company serving higher education, further education, business and government clients around the world.Its connects a deep understanding of education with the power of technology to continuously push the boundaries of learning.The scope of this project is to build DW solutions and create dashboards/Reports to show the student management system progress to the management/Users.

Responsibility:

Primarily involved in extensive work with Power BI, including report design, DAX expressions, and custom visualizations. Managed data integration from SQL Server, Snowflake, and various other sources. Developed and maintained SSIS packages for data extraction, transformation, and loading processes, ensuring efficient job optimization and monitoring performance. Designed dashboards for ETL trend tracking and created comprehensive reports in Pyramid and other reporting frameworks using PostgreSQL. Collaborated with cross-functional teams to gather requirements and deliver insights utilizing Tableau and Azure Data Factory for cloud-based data integration. Demonstrated strong skills in data analytics and business intelligence through comprehensive reporting and data visualization.

Project: Alta Hospitals

Project Description:

Alta Hospitals System LLC provides healthcare services. The Company specializes in pediatric, obstetrics, gynecology, general surgery, orthopedic, outpatient, as well as skilled nursing and urgent care services. The scope of this project is to create dashboards/Reports to show the hospital/finance progress to the management. On the other hand we maintain the Patient/Physician info in DW.

Responsibility:

My responsibilities are to create Power Bi reports using SQL server as the source. I have been assisting in development, monitoring and deployment of SSIS packages. Involved in Performance Tuning in SQL and to make the Power Bi reports more efficient. Effectively utilizing visualizations like table, matrix, bar, card, gauge and slicers. Focusing on custom visualization such as multi slicers and hierarchies as well as DAX expressions. Contributing in creating several Power Apps.

Project:COMMUNITY FIRST MEDICAL CENTER (U.S)

Project Description:

Community First Medical Center’s mission is to provide compassionate medical and nursing care as well as advanced diagnostic and treatment services that promote our patients’ well being. Recognizing the need to provide quality healthcare in the local community, our dedicated doctors and medical staff stood united in the face of a looming hospital closure.Ultimately pushing the previous ownership to put the hospital up for bid, our doctors, together with Community First Healthcare of Illinois, saved the hospital in December of 2014 and continue to put the health of our community first. The scope of this project is to create dashboards/Reports to show the hospital/finance progress to the management.And other hand we maintain the Patient/Physician info in DW.

Responsibility:

Worked on developing Power BI reports, Data modeling, Complex requirement implementation. Worked on SSIS and SSAS tools. Worked on RDBMS with experience in SQL server. Worked on Complex queries and performance tuning. Worked on Custom Visualizations like multi slicer and Hierarchy slicer. Worked on power apps to get acknowledgment and to provide input to the user. I used to gather requirements for POWER BI reports from business users and executives.

Project: British Telecom Project

Responsibility:

• Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Created jobs in SQL server agent
• Created index and have performance tuning in SQL Server