STANLEY PIKE
Albany
Summary
ETL development engineer and quality analyst with extensive programming expertise across diverse environments. Proficient in the full system development lifecycle, including requirements gathering, design analysis, application development, testing, and database management. Demonstrated ability to enhance system performance and resolve complex issues, delivering high-quality software solutions that align with business objectives.
Overview
28
28
years of professional experience
Work History
Software Development Engineer/QA
Solventum/3M Health Information Systems
Albany
01.2017 - Current
- Quality Analyst working with the Clinical & Economic Research team testing coding and compliance updates to components for the Solventum Medical Records Coding Grouping Software.
- ETL Developer working in an Agile Development Environment.
- Responsible for designing and maintaining the processes and structures used to transform large scale Healthcare data sets into a data warehouse and various data marts which support a suite of production applications.
- Assists in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities.
- Creates automated processes to validate and translate data into our in-house data warehouses.
- Review requirements and data models and translate into ETL design processes that effectively populate data warehouse and data mart tables.
- Worked with team developing extracts with Python in AWS cloud for 3M’s Performance Matrix Healthcare Product.
Database Analytics Programmer
COMMUNITY CARE PHYSICIANS, P.C
Latham
08.2010 - 01.2017
- Responsible for maintenance of Community Care Physician’s SQL server databases.
- Troubleshoot performance issues for Practice Management and Electronic Medical Records databases.
- Develop and maintain Microsoft SQL Server Integrations Services (SSIS) packages, Reporting services applications, SQL stored procedures and functions for MS SQL 2008r2, 2008, 2005 and 2000 servers to support end-user requests and database analytics applications.
- Create SSIS solutions used for importing and exporting data to and from various sources.
- Created PowerShell scripts used in the monitoring and maintenance of SQL Databases on Windows 2008 Servers, both physical and VMware Virtual Servers.
- Created and maintain the database of web content analytics by extracting, downloading and importing content page statistics for Community Care Physicians web pages from Google Analytics.
- Designed, developed and implemented Information Technology Department Inventory Application used for tracking and maintaining Community Care's PCs, Laptops, Networking and Data Center Equipment using Microsoft Access 2010 Access Database Project User Interface and SQL Server 2008 database.
Consultant
CGI Information Systems & Management Consulting Services, Inc.
Albany
01.2001 - 06.2010
- Programmer/Analyst for the New York State Department of Environmental Conservation’s Bureau of Applications Development responsible for production support of their Air Facility Permitting System developed with PowerBuilder 11.
- Member of team that converted the Bureau’s applications from Sybase 12 to an Oracle 10g database.
- Rewrote Sybase stored procedures, functions and embedded SQL in Oracle PL/SQL.
- Programmer for AFS Compliance Application, developing user requested enhancements to system while also being responsible for system maintenance, repairs and upgrades.
- Trained staff on application changes that were result of enhancements and modifications.
- Conducted meetings with AFS Compliance staff to define new specifications and required process changes for the AIRS extract that uploads NYS DEC inspection results to the US Environmental Protection Agency’s AIRS database.
- Also reviewed and updated process documentation.
- Worked with Compliance staff to develop, test and implement modified Extract into Production.
- Created Technical documentation detailing Extract process.
- BUSINESS Analyst for team that developed a Web based case management application for the Unemployment Insurance Appeal Board based on the Curam framework.
- Responsible for designing test scenarios, executing testing, verifying results and automating tests.
- Developed test data, created and reviewed Use Cases for accuracy and test planning.
- Used Rational Suite Development Studio 2003 tools for testing.
- Rational ClearQuest 2003 used for tracking test results and defects.
- Automated tests created using Rational TestManager 2003 in conjunction with Rational Robot 2003.
- Created Oracle 9i stored procedures and functions in PL/SQL for producing test data and verifying test results.
Senior Associate Computer Programmer
PRICEWATERHOUSECOOPERS
Albany
10.1997 - 01.2001
- Aided in development, maintenance, testing and support of SMART system software developed with Visual FoxPro 6.0 and 3.0.
- Developed 3-tier client/server Intranet web site with Visual Basic 6.0 and MS SQL Server 6.5 used by market analysis and for on-site demonstrations.
- Created reports for web site using Crystal Reports 7.0 and SQL Stored Procedures.
- Installed and configured NT 4.0 Server, MS SQL 6.5 server, Internet Information Server II.
- Worked with Hospital Information Systems groups to create interface between Medical Records systems and SMART software by creating C++ preprocessor.
- Responsible for software maintenance and upgrades to NT 4.0 server and web site.
- Served as Database Administrator for Healthcare MedPAR database.
Education
M.S. - Geology
WICHITA STATE UNIVERSITY
Wichita, KSB.A. - Computer Science and Geology
SUNY
Potsdam, NYSkills
- Windows operating systems
- Windows Server administration
- Linux Ubuntu management
- MS SQL Server
- MySQL database management
- Oracle database administration
- Sybase management
- Transact-SQL programming
- PowerShell scripting
- Python programming
- C# development
- Oracle PL/SQL
- Git version control
- AWS cloud services
- Microsoft Visual Studio 2019 and 2017
- SQL Server Data Tools for BI
- SQL Server Integration Services
- Toad for Oracle management
- VMware vSphere client and Workstation
- PowerGUI scripting tools
- Program development and technical writing
Skills
Win 11, Win 10, Win 8, Windows Server 2012, Windows Server 2008, Windows Server 2003, Linux Ubuntu 14.04, MS SQLServer 2022, MS SQLServer 2018, MS SQLServer 2008r2, MS SQLServer 2008, MySQL 8.0, Oracle 10g, Oracle 9i, Oracle 8i, Sybase 12, Trans-Act SQL, PowerShell 3.0, Python, C#, Oracle PL/SQL, MS SQL, GitHub, GitHub CoPilot, AWS, MS Visual Studio 2019, MS Visual Studio 2017, SQL Server Data Tools – Business Intelligence, MS Business Intelligence Development Studio 2008, SQL Server Integration Services, TOAD 9.1, VMware vSphere Client 4.1, VMware Workstation 11.1.3, PowerGUI 3.6, Skilled in creating programs to meet specific project and user requirements including troubleshooting and implementation., Proven technical ability supported by published papers and development of various user computer manuals.
Affiliations
Capital Cup for Kids, Captain of team fund raising- (2005-2024)
Timeline
Software Development Engineer/QA
Solventum/3M Health Information Systems
01.2017 - Current
Database Analytics Programmer
COMMUNITY CARE PHYSICIANS, P.C
08.2010 - 01.2017
Consultant
CGI Information Systems & Management Consulting Services, Inc.
01.2001 - 06.2010
Senior Associate Computer Programmer
PRICEWATERHOUSECOOPERS
10.1997 - 01.2001
M.S. - Geology
WICHITA STATE UNIVERSITY
B.A. - Computer Science and Geology
SUNY