Systems Management Director
2021 - 2023US RxCare- Joined the company when the source control was scattered across each developer's personal Bitbucket account. Created a central team Bitbucket and got all code moved to this new team workspace.
- Implemented Jira and Jira Service Manager to organize the teams better, significantly improving communication. Previously, the development team received all requests via phone, email, text, or direct message.
- Used Confluence as a repository and began documenting the Classic ASP data loads and an updated system to ensure rules between the two were matched before implementation. The company had older software and no documentation.
Technologies: Leadership, Analysis, QA Testing, Code Review, Web Project Management, Jira, Confluence, Documentation, Git, Bitbucket, JenkinsSoftware Engineer III
2013 - 2021Elixir Rx Solutions- Improved the efficiency of the data loading process for calculating deductible and out-of-pocket balances.
- Integrated a new rules tracking system (Decisions.com rules engine) to determine eligibility.
- Refactored the eligibility process to improve visibility into what was being received.
Technologies: Oracle 11g, PL/SQL Tuning, PL/SQL Developer, Ruby, C#.NET, Bash, Windows PowerShell, ETL, ETL Tools, JavaScript, Stored Procedure, Documentation, Python, Source Code Review, Microsoft Word, Microsoft Excel, Visio, Azure DevOps, Data Validation, Quality Assurance (QA), SQL Stored Procedures, Data Management, Data Analysis, Database Architecture, Oracle Database Architecture, Relational Databases, Relational Database DesignDatabase Architect
2008 - 2013CVS Health- Redesigned an inefficient system entirely, which shortened a multi-day running government process so that it would run in just a few hours.
- Mentored junior developers on database best practices and how to review queries for performance improvements.
- Worked within an architect team, documented, and educated staff on the best practices through lunch-and-learn sessions.
- Maintained and created ETL processes for loading a variety of data formats.
Technologies: C#.NET, Data Architecture, Database Design, Data Engineering, Data Warehousing, Documentation, ETL, SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), TFS, Microsoft Team Foundation Server, Visual SourceSafe, Data Validation, Quality Assurance (QA), Star Schema, SQL Stored Procedures, Data Management, Data Analysis, Database Architecture, Oracle Database Architecture, Relational Databases, Relational Database Design, Relational Data MappingData Warehouse Software Engineer
2001 - 2008Oeconnection- Rebuilt an inventory publishing process with a team of three others to go from 6–8 hours to process inventory to less than 15 minutes.
- Built the company's first data warehouse from design to ETL processes.
- Launched a data analysis intelligence system building data marts off the data warehouse for multiple customers.
- Completed various database and website tasks as assigned from external members' sites to internal tools (task tracking and a billing system).
Technologies: Data Warehousing, T-SQL, SQL, Stored Procedure, SQL Server DBA, C#.NET, Data Architecture, Data Engineering, Data Warehouse Design, Database Design, SQL Server Integration Services (SSIS), Documentation, ETL, SQL Server Reporting Services (SSRS), Microsoft Access, Quality Assurance (QA), Data Validation, SQL Stored Procedures, Star Schema, BizTalk, Data Management, Data Analysis, Data Visualization, Relational Databases, Relational Database Design, Database Architecture