November 2021 to Present
Hired as a Senior Data Engineer, my primary task was to manage integrations between the various in-house and third party systems. I was also responsible for developing and maintaining all data dictionaries from ground up. Initially the company was using Informatica for their ETL solution. After some time, I was able to convert all ETL processes to PowerShell, saving the company approximately $100K per year. Additional cost savings were gained by rethinking existing data models to reduce redundant data. Thereby saving significate costs in AWS storage. I also automated several existing processes, freeing the work force to focus on other more important tasks.
Hired as a data developer, I was initially task with stream lining the DevOps processes. I worked to reduce total Git repositories from 43 down to 7 manageable repositories. I also converted the team from a random branching methodology to iteration based branching. I implemented semantic versioning and conventional commits to help automate GHANGELOG and CI/CD. I also refactored code to take advantage of Nuget packaging to eliminate Git submodule linking. When not working on the DevOps process, I optimized the SQL database footprint by implementing an indexing strategy. Also worked to migration databases amongst the various instances of SQL Server based on use and required response times.
Working for 180 Medical as a full stack developer, I was tasked with developing stored procedures and application code to support the business’s in-house developed application, MedTrack. This application ran on the Microsoft stack, including SQL Server and IIS. It was developed in C# using MVC.
Working for Matrix as a data analyst, I was tasked with developing integrations between various systems using Informatica and PowerShell. To include UltiPro, Active Directory, various SQL databases, and the main ERP application housed in Oracle. Additionally, I also maintained SSRS reports and provided overall support for Microsoft SQL Server. I assisted the team in growing their understanding of PowerShell and many other technologies, as well as developing skills in features of existing software that they were not yet aware of.
Working for Verinovum, as a database developer and production database administrator, I was tasked with the design and implementation of multiple data models used to store and process incoming patient data from multiple health care providers. I also managed and maintained production SQL Server cluster.
Working for Samson Resources, on a development team, I was tasked with the design and implementation of multiple data models used to store and maintain data concerning all aspects of the company’s data. I was placed in charge of developing, implementing, and enforcing data model and database standards and conventions. I also led four application developers in the use of SSIS to convert the data stored in JD Edwards Accounting (AS/400) to SAP (Oracle). I instructed application developers in the proper use of Microsoft SQL Server and proper data model principals.
Working for Relay Health, a division of McKesson, on a team of three production support DBAs I was tasked with the maintenance of 45+ SQL 2005 instances spread across multiple four node clusters which housed the databases for their SaaS insurance claims billing products.
September 2007 to November 2010
Working in the IT department I was tasked with the management of Microsoft SQL data stores which housed many databases for in-house written application as well as the public facing websites. Upgraded all SQL servers from 2005 to clustered multi-instanced 2008 servers on an iSCSI SAN. Assisted developers with standardizing their database calls, through the use of stored procedures and XML. Performed regular security audits to tighten security and conform to regulation placed on Williams & Williams by their customers in the banking industry. Implemented Microsoft Dynamics CRM 4.0, and supported the associated data stores post implementation. Assisted with upgrade to Microsoft Dynamics Solomon 7.0, and supported the data stores and the application post implementation. Implemented Microsoft SharePoint 2007, and supported the associated data stores post implementation. Led the Business Analytics team and IT resources in the implementation of the Microsoft BI stack, including MOSS, Performance Point and Excel Services. Assisted the Business Analytics team with ad hoc queries and understanding data relevant to customer activity. Led the upgrade of Microsoft SharePoint 2007 to 2010 to support new business intelligence functionality on the improved Microsoft BI stack. Assisted junior level network administrators with network design and layout, as well as improving existing services such as VPN.
June 2001 to August 2007
Working on the systems support team I was tasked with the management of several Microsoft SQL data stores which housed the Adage ERP system, written by Infor. Also, managed many specialty database, including Dun and Bradstreet’s Risk Assessment Manager, OAT Systems (RFID), LabVantage’s LIMS, Shop Floor Automation Systems ( Invensys Systems’ Wonderware and Rockwell Automation), SolarWinds NPM and in-house written data warehousing databases. Databases were distributed across multiple clustered (active/passive) and stand-alone SQL servers, running SQL 2000 and SQL 2005.
May 2001 to May 2001
As temporary database support, reported on enhancements that could be made to improve performance on SQL servers used for Thrifty web site. I also wrote DTS Packages to move and manipulate data for the web development team.
Working on the web development team I was tasked with the management and development of the corporate data store which housed information gathered throughout the company from various FoxPro based ERP/MRP systems. The data was then made available to the Internet, Intranet, and Extranet.