Peter Zajkowski Email & Phone Number

Rochester, New York, United States

Optimize query execution and ETL/data flows. Develop solutions using SQL Server tools (TSQL, SSMS, SSRS, SSIS).

Rochester, New York Area

Developed a BI analytics solution for CMS bundled payment programs (BPCI, CJR). Leverage available tool sets (Tableau, Microsoft SQL Server + T-SQL, SSMS, SSIS) to process and report on federal and commercial sources of claims data.

Rochester, New York Area

Led the development of dimensional data models as long term solutions. Collaborated with key stakeholders to define business requirements and leveraged enterprise-level BI tools (Microsoft SQL Server + T-SQL, SSMS, SSIS, SSRS) to achieve desired outcomes. Ensure accurate reporting from multiple data sources including health insurance claims, practice management systems, care management systems, lab results, and hospital ADT. Developed and maintained online reports for physicians and care… Show more Led the development of dimensional data models as long term solutions. Collaborated with key stakeholders to define business requirements and leveraged enterprise-level BI tools (Microsoft SQL Server + T-SQL, SSMS, SSIS, SSRS) to achieve desired outcomes. Ensure accurate reporting from multiple data sources including health insurance claims, practice management systems, care management systems, lab results, and hospital ADT. Developed and maintained online reports for physicians and care managers that identify patient-care opportunities, high-cost drug savings options, and data gap recovery. Show less

Rochester, New York Area

Served as the primary report developer for internal and external customers. Performed data analysis to identify trends and patterns. Maintained reporting systems in SSRS and Business Objects/Crystal Reports, as well as Excel as an OLAP client (Analysis Services) for standard and ad-hoc reporting and analysis. Developed and employed an internal solution for a master patient index. Assisted in the implementation of GRIPA’s clinical integration platform. Collaborated on the quarterly production of… Show more Served as the primary report developer for internal and external customers. Performed data analysis to identify trends and patterns. Maintained reporting systems in SSRS and Business Objects/Crystal Reports, as well as Excel as an OLAP client (Analysis Services) for standard and ad-hoc reporting and analysis. Developed and employed an internal solution for a master patient index. Assisted in the implementation of GRIPA’s clinical integration platform. Collaborated on the quarterly production of physician report cards. Show less

Rochester, New York Area

Served as a T-SQL developer and analyst. Provided support to various Microsoft Access application solutions. Developed physician report cards using Crystal Reports. Provided monthly statistics on health care utilization across the physician/hospital network.

Greater Los Angeles Area

Directed the admissions office for the Ph.D. programs in Psychology, ranked in the top 10 nationally. Administered a budget of $360,000 for new graduate student fellowships. Conducted outreach and recruitment seminars to targeted undergraduate students. Originated a departmental web-based admissions application. Redesigned the graduate admissions Access database from static to relational design, improved the user interface to provide greater ease of data entry and reporting.

Greater Los Angeles Area

Performed as a contractor developing a database to track Year 2000 (Y2K) compliance of all building systems (e.g., fire, security, elevators, lighting, water, and HVAC) in 260 properties containing over 1,000 leased units. Developed two additional MS Access databases to provide occupancy projections and anticipated revenue.

Greater New York City Area

Served as a member of the Department of Applied Psychology’s management team. Coordinated admissions, recruitment, and marketing for the department’s graduate programs. Increased applications to the master’s programs by 20%; increased enrollment yield by 25%. Developed an MS Access database to track 90 graduate courses, including scheduling, teaching assignments, and four-year projections regarding future offerings.

Rochester, New York Area

Provided academic advising to undergraduate students. Managed all aspects of the University Tutoring Program including the hiring and training of 100 paid student tutors. Assisted the Director of Orientation Programs in the design and implementation of the summer College orientation session and mid-year orientation for freshman, transfer students and parents.

Ma, Higher Education

Bachelor’S Degree, Human Service Studies

Associate’S Degree, Liberal Arts