Dan Ratanasit Email & Phone Number

Atlanta, Georgia, United States

Atlanta, Georgia, United States

• Developed.NET solutions in C# and T-SQL utilizing Agile methodologies for government reporting applications in the Regulatory Reporting team
• Optimized performance of Ryan White utility (federal report for HIV patient care) by migrating all SQL code to stored procedures and refactoring the C# code to improve performance and maintainability. Provided support.
• Enhanced the Ryan White utility’s UI to improve usability by displaying user-friendly data alongside report data to offer clients improved insight into their report data
• Regularly collaborated with product and QA teams to create and refine Jira stories to ensure the Ryan White utility complied with the latest federal requirements enabling clients to secure federal grants and funding
• Developed, tested, and deployed stored procedures for NextGen's HQM Portal (Health Quality Measures) to calculate 2022 and 2023 UDS (Uniform Data System) measures critical for clients to secure federal grants and funding

Atlanta, Georgia, United States

• Actively engaged with NextGen clients to analyze specifications to design, code, test and deliver customized solutions using.NET, C#, WPF/MVVM, SQL stored procedures, SSIS packages, SQL jobs, Mirth channels to meet.
• Developed WPF reporting applications using C# and T-SQL for state reporting programs (Ohio Title X, Arizona Title X, Texas DSRIP, and Oregon MOTS), creating complex SQL queries to pull extensive patient health data.
• Developed, maintained, deployed, and supported.NET applications and stored procedures, SQL jobs, and SSIS packages for the federal 340B drug program to automate reports (Walgreens, CVS, CaptureRx, etc.) enabling.
• Maintained, supported, and deployed NextGen’s Interactive Voice Response (IVR) Utility, stored procedures, functions, SSIS packages, and SQL jobs to automate patient notifications allowing clients to meet Meaningful.
• Developed Mirth channels, T-SQL stored procedures, and SQL jobs for Planned Parenthood affiliates to automate importing/staging/transforming incoming data from Allscripts HL7 messages into patient charts
• Developed and deployed WPF applications using C# and/or SQL stored procedures, SQL jobs, and SSIS packages for billing and AR solutions such as balance write-offs, complete AR wipes, and balance exports

Atlanta, Georgia, United States

• ASP.NET developer in UPS’s Global Treasury department responsible for the enterprise-wide global treasury web application (GTIP). Developed REST APIs in C# using ASP.NET MVC to handle CRUD operations. Developed and.
• Led requirements gathering and development of GTIP modules for Signatory Exceptions, Detailed Variance Reports, Share Repurchase Tracking and Credit Card Requests
• Refactored all C# source code, T-SQL tables and stored procedures for UPS cash balance inputs and reports, eliminating thousands of lines of redundant source code resulting in improved maintainability
• Developed, maintained and supported Trading Room, Intra-company Loans, and Bank Guarantee/Letter of Credit modules
• Led the team’s adoption of Subversion, trained all team members, and created all process documentation
• Introduced CSS to the GTIP site to facilitate adherence to UPS web design guidelines

Marietta, Georgia, United States

• Developed a web application using PHP, JavaScript, AJAX and MySQL to replace the company’s manual processes for tracking inventory and online orders
• Led the development of a new PHP and MySQL application to track inventory replacing the company's spreadsheet processes minimizing manual data entry and increasing employee productivity
• Developed a search engine utilizing AJAX enabling customers to quickly search inventory
• Developed user-friendly websites used by customers to place online orders and by employees to update inventory

Atlanta, Georgia, United States

• Programmer/Analyst at GSU Brainlab whose mission is to create and adapt human-computer interaction methods using Brain-Computer Interface technologies to effectively control real-world applications
• Developed the AudioMORPH application in Visual Basic 6.0 to generate customized JAWS screen reader scripts for visually impaired computer users
• Worked closely with visually impaired end users to test and gather requirements for future AudioMORPH releases
• Created a blinking LED circuit utilizing 555 timer IC’s and various capacitors to test human brain reactions for the Steady State Visually Evoked Potential (SSVEP) research project
• Published literature review on various approaches to creating auditory interfaces based on graphical interfaces

Alpharetta, Georgia, United States

• Performed black box and multithreaded stress testing of Veriprise’s core product and wireless solutions
• Developed test strategies and test cases based on analysis of requirements and design specifications
• Implemented test cases in Visual C++ or Java and used Perl scripts and WinRunner to automate testing
• Tested Veriprise’s wireless platform interface with Lotus Notes, Oracle, and Siebel databases
• Tested the server-side security capabilities of Veriprise’s wireless platform by using a simulated client to test the server’s encryption, decryption, handshaking, and user-session functionality

Marietta, Georgia, United States

• Designed, coded, and tested software for various displays and utilities of the F-22 Avionics Pilot Vehicle Interface using C, Ada, and VAPS graphical prototyping tool
• Developed String Display Utilities to use in place of image attribute to convert numeric data types to string for all F-22 cockpit displays
• Implemented and unit tested updates to F-22 Maintenance Fault Display, displaying “black box” info to pilot
• Designed updates to F-22 Mission Data Display, displaying flight plan, radar threats, etc. to pilot

Bangkok, Bangkok City, Thailand

Assisted with Systems Engineering Department intranet web pages while fully immersed in Thai corporate and cultural environment

Masters

Bs