Summary
Overview
Work History
Education
Skills
Certification
Honors & Awards
Languages
Affiliations
Timeline
Generic

Piotr Stroczan

Ringwood

Summary

Results-driven IT Senior Manager and Scrum Master with extensive experience in healthcare IT. Successfully led multiple Agile teams, enhancing database performance and client satisfaction through optimized SQL solutions. Proven track record in architecting scalable web applications and improving operational efficiency.

Overview

1
1
Certification
27
27
years of professional experience

Work History

Manager Software Engineer/Sr. Manager Software Engineer/Scrum Master

Cognizant Technology Solutions Pvt. Ltd.
Teaneck
10.2006 - 07.2026
  • Architected Warehouse Database and Moved necessary components to support Reporting from Operational Database using SQL Change Tracking (Full data/Partial Data move Jobs).
  • Created Warehouse Reporting Platform and built costumed reports (SSRS)– 100+ reports
  • Managed Development Team to create Triggered based Audits (compliances) SSIS Jobs to transfer data to Warehouse.
  • Improved the performance by optimizing the SQL I/O and CPU cycle expensive queries – by introducing cache in the application, modifying the indexes on the tables, optimizing the joins, introducing Isolation Levels, DMVs, Customed reports, SQL Profiler, Query analyzer with Statistics, Activity Monitor, changing the deployment structure – database and Application server
  • Managed development team to create scheduled archiving jobs for efficient data movement to warehouse.
  • Resolved critical UI/ETL performance issues to support 10M memberships and handle 100 million transactions.
  • Converted Big Stored Procedures (Legacy Jobs) into Single responsibility and Reusable Sub Stored Procedures – improved performance by major.
  • Created SQL System Versioning Stored Procedures driven Jobs to create JSON Results for an external Usage (Integration with another Cognizant’s product - Web API).
  • Maintained Dev-Ops Nightly, CI, Release Builds and Unit Tests jobs.
  • Play main role for development, development Lead, database code reviewers group facilitated for 20+ developers.
  • Play major role to convert SSRS to Power BI POC.
  • Managed Development Team to Create SSIS package components to call webApi & external process integration.
  • Fix many SQL Server and .Net warnings – using ReSharper, FxCop, Fortify, and implemented Unit test cases etc.
  • During Transformation of Trizetto to Cognizant was playing main role as SEs Manager to formalize and adopt 4-5 Agile teams in India as well as Scrum Master and SE Manager for over 4 years.
  • Created and Maintained SQL Database for ease of development/deployment automation for Data-tier Application Package (DACPAC)
  • Developed TriZetto Elements product for Medicare and Commercial markets
  • Project Description:
  • Cognizant (formally known as TriZetto Elements) is a whole product suite for Healthcare Payer’s across Medicare and Commercial Market. It is a highly critical suite of applications from client’s revenue perspective and government healthcare CMS compliant systems; it comprises of 9 different applications made using different technologies.
  • The main components/applications of this project are Enrollment Application Manager, Risk Score/Risk Adjustment Manager, Financial/Rx Reconciliation, and data flows from other applications to this one as it contains the centralized database for Medicare users.
  • Recently we have been expanding the product suite for Commercial Healthcare market.

Developer, Senior Developer, Team Lead SE

Plan Data Management
New York City
11.1999 - 10.2006
  • Contributed to various phases of SDLC, such as requirement gathering, estimation, development, testing, deployment, and defect fixing.
  • Developed 4 applications in SQL, VB6, VB.Net, ASP.Net, Crystal Reports.
  • Converted C# code to enhance performance through SQL stored procedures and indexed views.
  • Optimized SQL I/O and CPU cycles of expensive queries by introducing caching, modifying indexes, optimizing joins, and implementing NOLOCK on SQL read operations.
  • Performance Tuning with the help of perfmon counter, SQL- Profiler, IO/PU cycle reads, Query Analyzer, Query Execution Estimation.
  • Used Team Foundation Server/ VSS for integration, maintenance and security of code.
  • Developed database diagrams and maintained automated jobs, recovery plans, and maintenance schedules.
  • Adopted and Converted Access Databases into SQL 7.0.
  • Created Cubes (SSAS) for Fraud and Abuse Application.
  • Oversaw the development and maintenance of products such as EAM, SSM, RAM, FRM, and RSM.
  • Outlined the project's goals, deliverables, and overall impact.
  • Plan Data Management (PDM) provided software and services that streamlined the enrollment, reduce administration, and compliance of Medicare and Medicaid plans whose primary products assist Medicare Advantage and Medicare Part D plans to maximize revenue, and improve compliance. Today, these legacy capabilities are integrated into Cognizant’s broader TriZetto Healthcare Products suite to help health plans manage complex government and commercial data.

Education

Associate Degree - Computer Information Systems

BMCC College
New York

Computer Science

Baruch College
New York

Skills

  • Database : SQL Server, Oracle, MySQL
  • BI Tools : SSIS, SSRS, SSAS, Power BI
  • Build/Versioning Tools : Team Foundation Server(TFS), Azure DevOps (AZDO), TeamCity
  • Design Tools : SSMS, Microsoft Visual Studio, Visual Code, Microsoft Visio
  • Testing Framework : tSQLt, SSDT, xUnit, nUnit, log4Net, Angular, Swagger
  • Code Quality/Security : TFS – Auto Shelve, Azure-Visual Studio, AZDO, FxCop, Style Cop, ReSharper, Fortify, Blackduck, VS – Spell checker, ReSharper, GitHub Copilot
  • Development : Agile (SCRUM – Sprint, Kanban), Waterfall Methodologies
  • Provide technical mentoring to developers and senior developers within a domain or project, or as assigned
  • Provide guidance to stakeholders in the development of solutions that create innovation Provide design solutions for complex business and technical problems
  • Conduct reviews of functional specifications, business use-cases and code reviews to ensure that the team is following coding standards and processes set for the project Perform occasional demonstrations to the project stakeholders of the developed application/modules and will collect their feedback
  • Resolved many Clients Performance issues/time-outs and other bugs

Certification

  • Client – Server Certificate (SQL, C#, ASP.Net, VB.Net) – Year 2001-2002
  • Microsoft Certified Azure Fundamentals (AZ-900) Year - 2025
  • Microsoft Certified Technology Specialist in Business Intelligence – Year 2008
  • Scrum Master (SAFe) – Year 2014.

Honors & Awards

Employee of the Month in 2015/2016, Star Award as Scrum Master/SE Team Lead 2018

Languages

Polish
Full Professional
Russian
Professional
English
Full Professional
Spanish
Limited

Affiliations

  • Tennis, Swimming, Biking, Soccer, Hiking

Timeline

Manager Software Engineer/Sr. Manager Software Engineer/Scrum Master

Cognizant Technology Solutions Pvt. Ltd.
10.2006 - 07.2026

Developer, Senior Developer, Team Lead SE

Plan Data Management
11.1999 - 10.2006

Associate Degree - Computer Information Systems

BMCC College

Computer Science

Baruch College
Piotr Stroczan