John Allen Niemiec
Pittsburgh
Summary
High performing IT professional within various industries seeking a position as a lead systems analyst
Overview
28
28
years of professional experience
Work History
Senior Systems Analyst (Health Insurance)
UPMC (University of Pittsburgh Medical Center)
04.2021 - Current
- Responsible for second level support of critical software applications to support customer base
- Participant on one to two agile sprint teams to support both software release and maintenance activities
- Develop SQL Server stored procedures and views to fulfill data requirements and support ETL processes for various applications
- Participate in grooming, user story creation, and tasks for agile sprint teams using Azure DevOps to support software development initiatives
- Interaction with both technical resources and non-technical personnel to meet changing departmental requirements
- Address adhoc-requests for user data and system configuration requirements
- Apply data management standards and procedures to both production and non-production environments
- Business domains supported include Medicare, Medicare, Health Services, NCQA and Provider
Business Analyst (Health Insurance)
UPMC (University of Pittsburgh Medical Center)
06.2019 - 04.2021
- Responsible for business requirements gathering and translation to functional specifications for database engineers to support Medicare and Medicaid consumers
- Participated in grooming, user story creation, and tasks for two agile sprint teams using Azure DevOps
- Develop SQL Server database tables, stored procedures, views, indexes, common table expressions and cursor objects to fulfill application requirements and ETL batch processes
- Provided first level of bug support to before potential triage to applicable database resources
- Addressed adhoc-requests for user data and configuration needs
- Maintained communication channels between technical and non-technical levels
- Conducted manual quality assurance activities for database enhancements and modifications
- Maintained team documentation for both reference and audit purposes
- Business domains supported inclusive of Medicare, Medicare, Health Services, NCQA and Provider
Data Analyst III (Healthcare)
Centene Corporation
03.2018 - 06.2019
- Developed Teradata SQL procedures and views that support the health plan processes and strategic initiatives
- Performed design and creation of data cubes and dashboards to support automation initiatives
- Employed MS Excel for pivot table creation, variable lookups and appropriate data filtering requirements
- Worked with business analysts in requirements gathering and specification documents
- Resolved database and report issues as necessary
Systems Analyst/Product Owner – (Finance and Accounting)
Buchanan Ingersoll & Rooney P.C.
10.2011 - 03.2018
- Conducted overall application support of firm general ledger, data mart, and interfacing applications
- Develop SQL Server database tables, stored procedures, views, indexes, common table expressions and cursor objects to fulfill application requirements and ETL batch processes
- Participated in third-party version upgrades, data conversions, implementation, and support to complete the projects
- Designed, developed and maintained data integrations with Epicor HCM module per payroll, tax, performance evaluations and miscellaneous HR processes (i.e
- Employee demographics)
- Assisted in the implementation, maintenance and first-level support for the Epicor HCM module
- Authored both business and functional requirement documents consumed by technical personnel
- Developed and maintained an inventory of reports based on various data sources using SQL Server Reporting Services (SSRS)
- Maintained adhoc user applications authored in Microsoft Excel and Microsoft Access using Visual Basic for Applications (VBA)
Senior Systems Developer/Analyst (Health Insurance)
United HealthCare Group
08.2007 - 10.2011
- Worked with end users and business analysts to gather requirements, design specifications and user acceptance test plans using departmental standard software development tracking tools
- Developed SQL Server2005 based objects including tables, stored procedures, views, functions, and indexes, and reports to support new development and maintenance projects for batch based processes and queries
- Created ad database driven reports using Crystal Reports10 for various user communities
- Developed an ACH direct payment file to electronically pay health network providers using the T-SQL language
Database Report Developer - Mortgage and Title Applications (Finance)
Service Link
05.2007 - 08.2007
- Utilized SQL Server Reporting Services to create and modify database driven reports using VB.Net as the front-end tool
- Created SQL Server based stored procedures, functions, views, and tables to assist in presenting report and interface information
Database Developer (Mortgage Systems)
Northern Virginia Ryan
07.2006 - 05.2007
- Applied the SQL Server development tools for screen design, called procedures and report creation through SQL Server Reporting Services
- Performed Visual Basic development to support processes within the settlement services division
- Created reports using a vendor-based software package
Lead Financial System Analyst/Developer (Finance)
Fiserv Incorporated
08.2001 - 07.2006
- Worked closely with end-users on system requirements and translating those requirements into technical processes
- Participated in the creation of customized financial applications using COBOL, Visual Basic6.0, VB.Net, SQL Server2000, and Crystal Reports to provide the user community with the information necessary for decision making processes
- Employed data transformation services in importing, modifying, and outputting data to various formats
- Development and support and Essbase6.0 (OLAP) financial data cubes for company revenue, expense, and budgeting analysis tools to assist with financial analysis and performance reporting requirements
- Supported an installation of Microsoft Great Plans (releases, security, data integrations)
- Created Visual Basic forms that included menus, command buttons, option boxes and Active X controls that interacted with the appropriate database objects
- Enhanced an in-house ETL tool using Visual Basic to gain efficiencies in processing times
Software Engineer I – III (Core Banking)
Fiserv Incorporated
05.1997 - 08.2001
- Participated in the analysis, design, and development of mainframe banking applications for financial institutions located within the United States and abroad using COBOL I/II, JCL, VSAM, and Endeavor
- Applications supported included time deposits, retirement, strategic initiatives, and general ledger
- Worked closely with product managers and business analysts on application enhancements, system defects, and suggested areas of improvement necessary to achieve maximum systems performance
- Enrolled in training classes to enhance skills and knowledge to enhance value to the development team
Education
Master of Business Administration - Management
Robert Morris University
Pittsburgh, PA05.2003
Bachelor of Science - Management Information Systems
Robert Morris College
Pittsburgh, PA05.1997
Skills
- Application integration
- Functional specifications
- User requirements gathering
- User acceptance testing
- Software development life cycle
- Database design
- System testing
- Defect Management
Accomplishments
- Made recommendations to decrease of company expenditures by $2M
- Led upgrade projects to improve health care claims processing performance by 40%
- Resolved over 1000 software product issues when performing a system support role
- Designed and developed a custom financial reporting system that resulted in 300 hours of resource labor
- Provided mentorship to less experienced team resources
Languages
English
Full Professional
Timeline
Senior Systems Analyst (Health Insurance)
UPMC (University of Pittsburgh Medical Center)
04.2021 - Current
Business Analyst (Health Insurance)
UPMC (University of Pittsburgh Medical Center)
06.2019 - 04.2021
Data Analyst III (Healthcare)
Centene Corporation
03.2018 - 06.2019
Systems Analyst/Product Owner – (Finance and Accounting)
Buchanan Ingersoll & Rooney P.C.
10.2011 - 03.2018
Senior Systems Developer/Analyst (Health Insurance)
United HealthCare Group
08.2007 - 10.2011
Database Report Developer - Mortgage and Title Applications (Finance)
Service Link
05.2007 - 08.2007
Database Developer (Mortgage Systems)
Northern Virginia Ryan
07.2006 - 05.2007
Lead Financial System Analyst/Developer (Finance)
Fiserv Incorporated
08.2001 - 07.2006
Software Engineer I – III (Core Banking)
Fiserv Incorporated
05.1997 - 08.2001
Bachelor of Science - Management Information Systems
Robert Morris College
Master of Business Administration - Management
Robert Morris University
Similar Profiles
Anna KokosinskiAnna Kokosinski
Housekeeper at UPMC (University of PIttsburgh Medical Center)Housekeeper at UPMC (University of PIttsburgh Medical Center)
Luis Alfredo Velez RenteriaLuis Alfredo Velez Renteria
Health Science Research Fellow at University of Pittsburgh, University of Pittsburgh Medical Center, UPMCHealth Science Research Fellow at University of Pittsburgh, University of Pittsburgh Medical Center, UPMC
AUSTIN SHAFFERAUSTIN SHAFFER
Clinical Operations Admin / Project Manager (Internship) at University of Pittsburgh Medical Center (UPMC)Clinical Operations Admin / Project Manager (Internship) at University of Pittsburgh Medical Center (UPMC)