Stephen Green
Colorado Springs,Colorado
Summary
Strategic Database Architect with expertise in designing and implementing complex database solutions. Skilled in data modeling, system scalability, and maintaining data integrity across platforms. Experienced in enhancing database performance and aligning technology with business objectives. Proven success in data architecture, performance engineering, and AI/ML data enablement, driving impactful data initiatives.
Overview
24
24
years of professional experience
Work History
Senior Data Architect
Leprino Foods
08.2025 - 02.2026
- Spearheaded data architecture for Phase II Machine Learning initiative, facilitating real-time production adjustments and proactive quality measures.
- Engineered SQL systems to capture multi-stage production data, boosting predictive quality model effectiveness.
- Optimized data pipelines for attribute measurement, elevating product quality and ensuring output consistency.
- Standards: Enforced engineering best practices using AGILE, GIT and JIRA for version control and task management.
- Streamlined ETL processes, increasing data processing efficiency across departments.
Senior Data Architect
Sompo International
03.2024 - 06.2025
- Led reconciliation of financial data across multiple source systems, identifying and resolving discrepancies totaling millions of dollars, ensuring accuracy of the Financial Data Warehouse.
- Built reconciliation frameworks to validate data integrity between source systems and the Financial Data Warehouse, ensuring compliance with internal financial controls and audit requirements.
- Cloud Integration: Managed data architecture within Azure environments, enhancing secure and scalable access for users.
- Warehouse Ownership: Led redevelopment of Financial Data Warehouse, automating manual processes with scalable pipelines to improve data accessibility.
- Performance Tuning: Applied deep SQL expertise to optimize performance and decrease data load times in complex financial systems.
- Automated Windows application tasks using DAX and macro code, streamlining workflows and reducing manual effort.
- Streamlined ETL processes, improving data processing efficiency across departments.
- Led workshops to educate teams on new data tools and technologies in use.
- Developed strategies to integrate legacy systems with newer technologies, facilitating transition to cloud computing platforms and microservices architectures.
Senior Application Developer
Charter Communications
07.2021 - 01.2024
- Performed data reconciliation across the Accounting Datastore System (ADS), validating consistency and accuracy for daily record sets exceeding one billion rows.
- Developed T-SQL reconciliation scripts to compare billions of records across SQL Server and SAP Hana, identifying data drift and ensuring referential integrity.
- Led migration of Accounting Datastore System (ADS), enhancing data accessibility for billions of daily record sets.
- Automated ETL processes for data transfer from SQL Server to SAP Hana, streamlining maintenance and scalability.
- Developed and maintained enterprise-level applications, ensuring alignment with business needs at Charter Communications.
- Implemented software enhancements that elevated application performance and usability.
- Collaborated with cross-functional teams to gather and refine requirements for new features, enhancing application functionality.
- SAP Hana administration including user security, schema maintenance, and ETL pipeline support for billion-row data transfers.
Sr. Data Engineer
Dentalplans.com
Miami, Florida
06.2019 - 06.2021
- Designed data pipelines integrating dental plan information (SSIS, Azure, SQL Server, Domo) with automated reconciliation controls, validating data accuracy across systems.
- Collaborated with cross-functional teams to define data requirements and specifications, ensuring audit-ready definitions and traceable transformation logic.
- ETL Development & Validation: Created ETL scripts to move and transform data into a centralized repository (SSIS, Azure Data Factory, Domo), including data quality checks and discrepancy reporting.
- Performance & Data Integrity: Optimized ETL processes, enhancing data processing efficiency and reliability while maintaining referential integrity and data lineage for compliance readiness.
- Developed data pipelines that supported business intelligence initiatives for Dentalplans.com, enhancing reporting and analytics capabilities.
- Implemented ETL processes to ensure data integrity across multiple platforms.
- Created ETL scripts to move and transform data from various sources into a centralized repository.
Senior Database Developer
McDivitt Law Firm
10.2017 - 03.2019
- Migrated end product from Oracle Captorra and Needles to Salesforce Litify.
- Re-engineered reporting system in Power BI to enhance data accessibility.
- Developed and maintained complex database systems for legal case management.
- Performed SQL administration and development to optimize database performance.
- Implemented machine learning solutions for enhanced case management efficiency.
- Utilized Excel, SSRS, Power BI, and DAX for advanced reporting capabilities.
- Optimized SQL queries to improve data retrieval efficiency for legal teams.
- Constructed database and warehouse, consolidating disparate data sources and unverified queries into a unified system.
Senior Database Developer
Compassion International
05.2016 - 12.2016
- Designed and optimized database structures for case management systems, ensuring audit-ready data quality and traceability for legal proceedings.
- Legacy Migration & Data Governance: Developed and implemented data migration strategies for legacy systems integration, maintaining referential integrity and data lineage across platforms.
- Overhauled Monthly Statement process, managing millions of rows across SQL Server, Netezza, and Salesforce, implementing automated validation checks to ensure data consistency.
- ETL & Compliance: Designed custom containers in Salesforce with ETL migration from SQL Server (SSIS and T-SQL), ensuring complete and accurate data handoff.
- Legal & Regulatory Alignment: Collaborated with attorneys to understand data requirements for legal proceedings, translating complex rules into well-structured, compliant database solutions.Designed and optimized complex database structures for case management systems.
- Developed and implemented data migration strategies for legacy systems integration.
- High-Volume Extraction: Overhauled the Monthly Statement process, managing millions of rows across SQL Server, Netezza, and Salesforce.
- Designed custom containers in Salesforce with ETL migration from SQL Server (SSIS and T-SQL)
- Designed and implemented complex database solutions for client case management systems.
- Optimized SQL queries to improve data retrieval efficiency for legal teams.
Senior Database Developer
Accusystems Inc.
08.2014 - 11.2015
- Developed data visualizations using SSRS, SQL Server, DAX, and VB.Net, enabling data-driven decision-making across departments.
- Executed seamless data migration from core banking systems to Accusystems services, ensuring data integrity and improving accessibility.
- Managed SQL Server administration tasks, including installation and configuration, to maintain optimal database performance.
- Developed and maintained stored procedures, functions, triggers, views and indexes for MS SQL Server databases.
Senior Database Developer
Redflex Traffic Solutions
10.2012 - 04.2013
- Designed code enhancements for 350+ schemas in U.S. and Canada, improving overall schema management.
- Created Oracle packages, procedures, and functions that streamlined operations and reduced execution time.
- Refined Oracle PL/SQL code, achieving significant performance improvements.
- Optimized SQL queries, increasing data retrieval efficiency for legal teams.
- Designed and implemented complex database solutions for client case management systems.
Senior SQL Developer
CIGNA Healthcare
03.2012 - 10.2012
- Acted as SQL Server Administrator for CIGNA Onsite Health Product, maintaining database performance and reliability.
- Managed CoH database repository, overseeing version control and optimizing SSIS/ETL processes for seamless healthcare integration.
- Administered SQL Server gateway, enabling efficient developer workflows and upholding coding standards.
- Developed complex SQL queries for data extraction and reporting.
- Optimized existing SQL scripts for improved performance and efficiency.
Senior Programmer/Analyst
American Express
02.2011 - 02.2012
- Developed software solutions that improved payment processing efficiency.
- Updated Amex Point of Sale System using VB.Net, enhancing transaction processing speed.
- Migrated data from Access to SQL Server 2008 via XML, ensuring secure processing of merchant transactions.
- Collaborated with cross-functional teams to clarify and document project requirements.
- Analyzed system performance and recommended enhancements for improved efficiency.
- Managed version control systems to streamline collaboration among developers.
Programmer/Analyst III
Mercer Global Advisors
02.2008 - 01.2011
- Owned full-stack development as dual DBA/Developer, integrating front-end (PowerBuilder) and back-end (SQL Server) systems for improved performance.
- Developed applications using PowerBuilder versions 8 to 12, improving user experience and system functionality.
- Managed SQL Server databases for versions 2005 and 2008 R2, ensuring data integrity and performance.
- Coded, tested, and debugged programs to meet established standards, ensuring reliability and robustness.
- Modified existing database structures to improve system performance.
Application Developer
Arizona Power Systems
Phoenix, Arizona
04.2005 - 12.2007
- Developed and maintained software applications for energy management systems in PowerBuilder, SQL Server, and Sybase, enhancing system performance and reliability.
- Collaborated with cross-functional teams to gather user requirements and design solutions.
- Conducted code reviews to ensure adherence to best practices and standards.
- Utilized debugging tools to identify and resolve software defects efficiently.
- Delivered technical support and training for end users on application features and updates, improving user satisfaction and adoption.
- Debugged existing code base to identify and resolve potential issues, increasing application stability and performance.
Database Developer
Louisville Gas & Electric
Louisville, Kentucky
03.2002 - 01.2005
- Engineered and deployed database solutions using Oracle PL/SQL to streamline operations.
- Developed stored procedures, triggers, tables, views, and functions utilizing PL/SQL.
- Optimized existing databases, significantly boosting performance and reliability.
- Monitored database performance, addressing issues and errors promptly.
- Conducted database testing to validate data integrity and accuracy, ensuring reliability.
- Provided technical support for database inquiries and troubleshooting, resolving issues efficiently.
Education
2-Year Business College - C Programming & Systems Analysis (Honors)
Toronto School of Business
Bachelors - English Literature
University of Strathclyde
Skills
- Enterprise data modeling
- Data architecture
- AI/ML data enablement
- Data governance
- Performance engineering
- Performance tuning
- ETL processes
- Data migration
- DBT data transformation
- SSIS development
- SSIS & reporting
- SQL development
- T-SQL and PL/SQL
- SQL Server & Oracle
- Netezza and Snowflake
- SAP HANA and Sybase
- Data visualization
- Business intelligence
- Domo analytics platform
- DAX Software Proficiency
- C# and VB6 programming
- VBA and PowerBuilder development
- Apex and Git version control
- Modern DevOps practices
- Cloud integration
- Agile methodologies
- Jira project management
- Technical leadership
- Refactoring techniques
- CI practices
- Cloud integration
- Modern DevOps practices
- Data migration
Certification
- MCSE (Solutions Engineer) + Security Specialization
- MCDBA (Database Administrator)
- MCSA (Systems Administrator)
- MCP (Professional)
- Brainbench Certification: ASP.NET
Timeline
Senior Data Architect
Leprino Foods
08.2025 - 02.2026
Senior Data Architect
Sompo International
03.2024 - 06.2025
Senior Application Developer
Charter Communications
07.2021 - 01.2024
Sr. Data Engineer
Dentalplans.com
06.2019 - 06.2021
Senior Database Developer
McDivitt Law Firm
10.2017 - 03.2019
Senior Database Developer
Compassion International
05.2016 - 12.2016
Senior Database Developer
Accusystems Inc.
08.2014 - 11.2015
Senior Database Developer
Redflex Traffic Solutions
10.2012 - 04.2013
Senior SQL Developer
CIGNA Healthcare
03.2012 - 10.2012
Senior Programmer/Analyst
American Express
02.2011 - 02.2012
Programmer/Analyst III
Mercer Global Advisors
02.2008 - 01.2011
Application Developer
Arizona Power Systems
04.2005 - 12.2007
Database Developer
Louisville Gas & Electric
03.2002 - 01.2005
2-Year Business College - C Programming & Systems Analysis (Honors)
Toronto School of Business
Bachelors - English Literature
University of Strathclyde
Technical Toolkit
SQL Server (Expert), SAP HANA, Oracle (9i-11i), Sybase, Netezza, Azure, Snowflake (Concepts), T-SQL (Advanced), PL/SQL, C#, CLR, VBA, PowerBuilder, VB6, DAX, Apex, GIT, JIRA, dbt (Concepts), SSIS, SSRS, Power BI, Tableau, Salesforce, DOMO, AGILE