Sunil Pratap Singh
Technology Leader | Data Engineering, And Application Modernization
Ghaziabad
Summary
Spearheaded data architecture initiatives, designing and implementing robust solutions that enhanced business intelligence and reporting needs for R1 RCM.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Sr. Program Manager
RI-RCM
01.2022 - Current
- Client: In house Product of RI-RCM (PAS & Enterprise Datawarehouse)
- Tools Used: Databricks/Snowflake, DBT (data built tool), SSRS, SSIS, SSAS, Dimension Modelling, Tableau, Power-BI, and Ms-Excel
- RAG (Retrieval Augmented Generation), Vector Dbs, Azure Foundry, .Net, APIM, Azure Services, react/.net/Application insights
- Designed enterprise data warehouse on Snowflake integrating 50+ source files/systems, data transformation and enabling real-time dashboards for 500+ business users
- Managing a team of software developers (13+12) to support the Business Intelligence and data services needs of the enterprise.
- Work directly with US clients & actively engaged in design discussion for all BI solutions.
- Identifying client needs and propose solutions using MSBI.
- Advanced extensible reporting skills using SQL Server Reporting Services (SSRS)
- Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
- Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
- Skilled in SQL 2022 Business Intelligence tools, Data Warehousing and ETL processes.
- In-depth understanding of OLAP and ad-hoc query tools.
Program Manager
RI-RCM
01.2020 - 01.2022
- Tools Used: Angular, react, .Net, Agile, Azure, Devops, CI-CD, Restful APIs, O-Auth, JWT
- Client/Products(s): R1 Decisions/ CloudMed work-driver/Physician Advisory Services
- Lead planning, execution, and delivery of large cross-functional initiatives aimed at meeting key business priorities.
- Shape and influence the technical direction of projects, ensuring we meet stakeholder needs while maintaining high-quality standards.
- Maintain transparent and effective communication channels to keep stakeholders informed of progress, developments, and challenges.
- Build atmosphere of trust within the team and inspire team to do their best work and address impediments to this quickly and effectively
- Regularly assess opportunities, drive for process improvements, and find new ways of operating, with a focus on simplification and productivity.
Deputy Manager
RI-RCM
01.2018 - 01.2020
- Client/Products(s): R1 Analytics Mede Analytics (R1RCM)
- Supervised design and development of data warehouse supporting BI initiatives.
- Migrated data from legacy systems to new solutions, designing conceptual and logical data models and flowcharts.
- Created and deployed ETL solution using MSBI/Power-BI to streamline data processing.
Education
Executive leadership program -
IIM-Indore
IndoreBachelors - Computer Application
MSc - IT
Sikkim Manipal University
Higher Diploma - Software Engineering
APTECH
Skills
- Data Modelling, Data Warehousing, Data Vault 20, ETL Development, Data Integration, Tableau/Power-BI, Databricks/Apache Airflow/Azure Services/Claude Code
- Business Strategy Development
- Analysed and optimized ETL processes to ensure efficient data flow and integrity
- Collaborated with stakeholders to define data requirements and design solutions that meet business needs
- Provided technical guidance and support for data-related projects and initiatives
- Monitored and improved data quality through regular audits and validation processes
- Created and maintained documentation for data architecture, data flows, and data governance policies
- Data-Driven Decision Making
- Project management skills
- Agile Methodologies
- Excellent written and verbal communication skills with ability to communicate effectively
Problem-solving skills
Accomplishments
- Spearheaded the end-to-end modernization of the enterprise data ecosystem, migrating legacy on-premise systems to Mede Analytics, Project-Bison & R1BI architecture.
- Mentored senior engineers and established a data architecture center of excellence, standardizing data modelling best practices.
- Implemented end-to-end Generative AI in PAS for physicians to summarize EMR document.
Certification
AZ-101
Interests
Listening to soft Music, Reading technical articles, gardening, pet parent
Timeline
Sr. Program Manager
RI-RCM
01.2022 - Current
Program Manager
RI-RCM
01.2020 - 01.2022
Deputy Manager
RI-RCM
01.2018 - 01.2020
Bachelors - Computer Application
MSc - IT
Sikkim Manipal University
Higher Diploma - Software Engineering
APTECH
Executive leadership program -
IIM-Indore