software developer

DOMINGO ANTHONY DURAN - “Tony”

Contact 401-***-**** (401-DEV-HELP), Warwick, RI

*******************@*****.***

Objective Senior IT position requiring a wide range of technical and analytical skills. Enjoy working on projects using new methodologies as well as maintaining and upgrading legacy systems. Prefer a focus on database analysis and queries but I am comfortable in almost any full-stack developer capacity. Languages Fluent in English and Spanish.

PROFESSIONAL EXPERIENCE

TISTA Science & Technology - Database Architect - September 2023 to September 2024

My contract with the Department of Veterans Affairs (VA) was extended into a new role.

Reviewed database documentation for multiple systems and reported improvements.

Devised methods to assemble new System Design Documents in an meticulous and thorough manner.

To support the consolidation of various databases, wrote complex PL/SQL queries and Excel formulas.

Created a Master Data Dictionary combining tables and columns from dozens of schemas.

Used Toad for SQL Server to do both schema and stored procedure code comparisons.

For the accuracy of data security, reviewed the settings for thousands of user and group permissions.

Compiled detailed reports comparing the tables and space utilization for dozens of databases.

Presented at Leadership meetings and detailed my observations and suggested improvements.

Among the technologies used: T-SQL, C#, Excel, SQL Server Management Studio, TOAD, VISIO, PowerPoint. TISTA Science & Technology - Senior .NET Developer - August 2021 to September 2023

This was a contractor role for the United States Department of Veterans Affairs (VA).

Successfully passed extensive background checks and obtained required Tier 2 Public Trust security clearance.

Accurately enhanced and supported VB.NET code for the Workers Compensation (WC) application.

Helped maintain the legacy WC so successfully that the VA extended our contract multiple times.

Accurately performed regular data imports into Oracle databases using a custom-made Importer application as well as Toad for Oracle, Excel, Amazon AWS, and WinSCP SFTP client.

To improve data security I successfully conceived, proposed, developed, and implemented a custom Data Masking application for Oracle DB test environments.

Completed the upgrade of an aging legacy VB6 application to VB.NET 4.8 and Oracle 19c.

Among the many technologies used: Visual Studio, C#, VB .NET, Oracle, Fortify Audit Workbench, GitHub. Narragansett Bay Commission - Senior Programmer Analyst - June 2015 to January 2021

Successfully supported and enhanced many systems which included the Pretreatment system, Permits, Board of Commissioners website, Online Reservations, Purchasing, various web services, and many subsystems.

Rewrote the old Pretreatment system from classic ASP to ASP.NET. Set aggressive goals, held meetings with the end users, and finished the extensive project to their complete satisfaction. Wrote dozens of dynamic reports and customize official letters using data from both the new and old PT systems.

For our forward facing Narrabay.com website, evaluated multiple Content Management Systems and worked with a team of developers to replace a legacy Sitecore CMS with the Umbraco CMS.

Updated Snapshot website data exporting feature by replacing aging Silverlight technology with Telerik Kendo.

To display daily water buoy data transmissions, created a webpage incorporating custom visual elements featuring an interactive dashboard and animated gauges.

Narragansett Bay Commission - System Design Analyst - March 2010 to June 2015

Maintained and enhanced many .NET C# systems including Customer Service, Billing, Data Entry, Permits app, Chain of Custody app, handheld lab scanners, and web services. Delivered SSIS data extracts, resolved many support tickets, and assisted company staff with prompt solutions and personal training.

Created a new Purchasing section to the Narrabay.com Sitecore website which collected SharePoint documents.

After our senior developer left, became the sole programmer for the IT department. Was given the coding responsibilities for the entire company for a year. Successfully maintained all internal and external systems.

Handled enhancements, data research requests, and closed all support tickets in a timely manner.

Accurately delivered crucial reports and data extracts for both departmental personnel and upper management.

Interviewed, hired, and trained new developers. Assigned them duties and managed a new and efficient IT team. Freelance Consultant - Web Developer - January 2009 to March 2010

For a local business client, constructed a JavaScript form to gather customer demographic information. The form included data validation and enabled and disabled entry fields as needed.

Built custom-made animated graphics and background images for various web pages using Photoshop.

For the client of an IT consulting company in Boston, I designed a multipage online reporting system. For the front-end, I designed the web pages using HTML and CSS to seamlessly integrate with the client's existing website. For the backend, I wrote scripts to interface with a MySQL database I created using phpMyAdmin. At the client's request I also removed all existing JavaScript code and replaced it with Perl server-side scripting. Putnam Investments - Programmer Analyst - June 1997 to January 2009

Successfully developed and deployed a complex prime money market portal using Java and MyEclipse IDE.

For a CMS project, ported intricate Perl modules by accurately rewriting them into XSL languages.

Compiled comprehensive database specs and coded DDL/DML SQL scripts for a product conversion project.

Created MS Access input forms and user documentation to update Oracle DBs from Excel spreadsheet data.

For a net tracking application, analyzed data extracts and wrote efficient and dynamic Perl SQL scripts.

Implemented critical modifications to a diverse variety of projects such as: sort clearing and executing dealers for an Individual (k) project, de-convolute plug-in file and reformat input tables to prevent data truncation for web stats, added 529 new funds to system, updated internal database with new pricing funds and added edits to Exchanges, added IRA contributions to summary table of daily statements, installed Business Objects in order to convert old client reports using stored procedures, fixed rejected networking activity records from financial institution data transmissions, and many others.

Supported the legacy mainframe system conversion process by performing data research, verification tests, FTP file transfers, administering procedures training, copybook requests, File Manager template creations, offshore personnel support, key contributions during issues meetings, and extensive JCL for test job requests. TECHNICAL SKILLS

Windows C# (10+ yrs. experience), Visual Studio (10+ yrs.), MS Office - Word, Excel, PowerPoint (10+ yrs.),

.NET (8 yrs.), TFS (7 yrs.), ASP (5 yrs.), VB6 & VBA (3 yrs.), VB.NET (2 yrs.), BASIC variants (10+ yrs.), batch files, C, REST, MS-DOS, JSON, WinForms, NuGet, Notepad++, Visio Database Oracle DB & PL/SQL (10+ yrs.), TOAD (10+ yrs.), SQL (10+ yrs.), SQL Server & T-SQL (10 yrs.), SQL Server Management Studio (5 yrs.), SSIS, MS Access, SQL Developer, SQL*Plus, SQL*Loader, MySQL, phpMyAdmin, Relational DBs, Tables, Stored Procedures, Views Client-Server HTML (10+ yrs.), JavaScript (10+ yrs.), CSS (10+ yrs.), AJAX (5 yrs.), Java, JSF, JSP, J2EE, MyEclipse, XML, XSLT, Subversion, Git/GitHub, PHP, Dreamweaver, WordPress, Adobe Acrobat, Google AdWords, SEO, webpage design, content development, image editing, graphic design, affiliate marketing, domaining

Mainframe (Most over 10 yrs.) COBOL II, DB2, VSAM, JCL, Easytrieve Plus, TELON, CLIST, IBM System/370/390, File-AID, ISPF Dialog Manager, Librarian, MVS TSO, PLATINUM, SPUFI, SDSF, IBM utility programs, INTERTEST, VSAM, CICS, Informatica PowerCenter 8, Smartest, Fortan, RPG II Mac OS X Xcode, Objective-C, Nvu, Preview, iPhoto, iWeb, iMovie, iWork, Open Office, NeoOffice, Smultron, Toast 9, GIMP, VirtualBox, CrossOver, Handbrake, Coda Unix Perl (5 yrs.), Regex, shell scripts, vi, AutoSys EDUCATION & TRAINING

University of Rhode Island

Completed 3 years of Computer Science BCS courses.

Offered a programming position and accepted it for financial reasons before completing my degree.

Gained extensive hands-on experience beyond the bachelor's degree level.

Earned credits equivalent to an associate degree. Professional Training Courses:

SAFe Scrum Master 6, SAFe for Teams 5.1, Kendo UI, MVC, ASP.NET 3/4/5/6/XML/Reporting/Core, HTML 5, Visual Studio, Umbraco, Bootstrap, Razor Pages, Angular JS, Photoshop, Orchard, Angular 2, WebMatrix, J2EE, OOP, Informatica PowerCenter ETL, Junit Testing, UML Design, Maven, Eclipse, UNIX, JSP, Servlets, SDM, Java 2 SDK 1.4, CICS, VB6, Telon Batch/Online, MVS, OS/JCL.

Contact this candidate