Programmer Analyst Portfolio

Experience

Professional Sabbatical / Various Roles

Dec. 2023 – Current

Company: R Software Consulting 123

Earned an Associate of Science in Computer Science while maintaining technical proficiency through independent software projects.
Co-founded a small business, managing IT systems, accounting, and data workflows utilizing NoSQL cloud storage services such as AWS (S3, DynamoDB).
Delivered administrative and client-service support in healthcare and funeral-service environments.
Completed professional training in accounting, finance, and data analysis to broaden business acumen.

Technical Lead

Apr. 2020 – Aug. 2020

Company: Infosys Limited, Palo Alto, CA

Designed and implemented 15+ T-SQL stored procedures, improving SSIS data transfer efficiency by 25%.
Maintained enterprise ASP.NET applications and optimized backend databases, reducing latency across distributed systems by 30%.
Collaborated with users to gather requirements and develop SQL analysis reports supporting business decisions.
Utilized MS SQL Server, SSIS, Visual Studio, Azure DevOps, and SolarWinds for development and performance monitoring.

Programmer / Senior Software Engineer

Mar. 2016 – Dec. 2019

Company: Card Integrators Corporation, Los Alamitos, CA

Led modernization of the company’s flagship application to the .NET Framework, extending its lifecycle and improving performance by 40%.
Implemented RFID functionality that expanded product capabilities and increased client adoption by 20%.
Developed and optimized data upload and conversion tools using T-SQL and SSIS to streamline client onboarding.
Authored system documentation and trained end users on data utilities, reducing support requests by 15%.

Manager of Applications Development / Applications Developer

Oct. 2012 – Jan. 2016

Company: Alignment Healthcare, Orange, CA

Oversaw design and maintenance of data-processing applications for healthcare claims (ANSI X12 837).
Created and optimized 100+ SQL Server stored procedures, improving reporting speed by 35%.
Directed EDI and backend data integration projects between SQL Server and Salesforce.
Maintained CMS-compliant websites using ASP.NET, HTML, and JavaScript.

Senior Software Developer

May 2012 – Aug. 2012

Company: LabCorp of America, Inc., Irvine, CA

Developed cancer-detection prototype using C#, .NET 4.0, and WCF services.
Collaborated with clinical experts to improve medical data visualization and reporting accuracy.
Applied CAB (Composite Application Block) for modular design, improving maintainability.

Senior Software Developer

Feb. 2010 – May 2012

Company: SASCO, Inc., Fullerton, CA

Designed middleware and WinForms applications for construction, telecom, and healthcare clients.
Automated EDI and data conversions using T-SQL and VB.NET, cutting processing time by up to 50%.
Built REST and SOAP integrations for Oracle databases using PL/SQL and XML/XPath.
Enhanced performance monitoring and troubleshooting procedures, reducing production errors by 25%.

Senior Software Engineer

Aug. 2011 – Feb. 2012

Company: MegaPath, Inc., Costa Mesa, CA

Built scalable WCF middleware services enabling communication between multiple WCF APIs using .NET/C#.
Engineered scheduled VB.NET console application to process XML data retrieved via REST APIs.
Implemented intelligent Oracle database update mechanism using PL/SQL and XPath.
Worked with project partners on system analysis and design aligned with client specifications.

Applications Developer / Software Engineer

Jan. 1995 – Jan. 2010

Company: Earlier Career, United States

CareMore Medical Enterprises: Developed CRM used by 60+ users managing 26,000+ patient accounts; improved database performance and reduced data errors by 40%.
MedPlus, Inc.: Maintained hospital data applications using Oracle PL/SQL and VB6; implemented data-exchange automation.
Selective Software Plus / USDA / J.D. Power: Built SAS and SQL reporting tools; designed automation scripts improving report accuracy.
Atwood & Co., Consulting Actuaries: Developed actuarial data models and automated spreadsheet processes, improving data entry efficiency by 30%.

Contact

Email: ThomasDownes57@gmail.com

Alternate Email: TomDownes1@gmail.com

GitHub LinkedIn Duty Scoopin (my business partnership)

Thomas C. Downes

About Me

Technical Skills

Projects

ID Printing System

REST API using AWS and Python

Linked-List Operations Management (for Spreadsheets)

Adding Numbers of Any Length

Experience

Professional Sabbatical / Various Roles

Technical Lead

Programmer / Senior Software Engineer

Manager of Applications Development / Applications Developer

Senior Software Developer

Senior Software Developer

Senior Software Engineer

Applications Developer / Software Engineer

Contact