.

.

BENJAMIN SOLOMON

San Antonio, TX

ad42vl@r.postjobfree.com / 210-***-****

SUMMARY

With over 23 years of expertise in designing and managing relational database systems, I bring a wealth of experience to the realm of information technology. My skill set encompasses 25+ years of general programming proficiency, spanning numerous languages, including specialized shell scripting and conditional job scheduling. Additionally, I boast 20+ years of hands-on experience in Business Intelligence software, adeptly utilizing tools such as Crystal Reports, Excel, SSRS, and T-SQL for comprehensive data analysis. In the dynamic field of web development, I have accumulated over 20 years of experience, demonstrating advanced graphics capabilities. My proficiency extends to 17+ years of web-based programming and database integration, employing technologies like HTML, JavaScript, PHP, and ASP to create seamless and efficient solutions. With a proven track record, I am poised to contribute my extensive technical skills and strategic insights to drive success in any company.

SKILLS

• Databases MSSQL/TSQL, Access, MySQL,

TopSpeed, TCL

• Business Intelligence SAP Crystal Reports, SSRS, Excel, SQL/T-SQL

• Programming VB.NET (console), VB, VB-DOS,

VBScript, QB64, PHP, JavaScript, SQL, T-SQL

(functions/stored procedures), Crystal Formula

Language, ASP/ASP.NET (maintenance only), RIFL,

Pervasive (Actian) IHUB and Data Integrator,

AutoHotkey, batch-programming

• Environments Visual Studio, MSSQL Management

Studio, VB/Access, SSIS, Pervasive Process

Designer, Dreamweaver, Crystal, Flash

• Web Servers IIS, Apache, Xitami, Streaming Media

• Productivity Software MS Office Suite, Adobe

Photoshop/Dreamweaver/Flash/Audition

• Remote access VPN, Terminal Server, MS Remote

Desktop Manager, Citrix, VNC

EXPERIENCE

Business Systems Analyst / WellMed 09/2014 - 08/2023

• Collaborated on the "Rules Engine – Suspects and Screenings" team, managing a conditional rule-based ETL system with approximately 300 rules.

• Produced technical requirement documents, translating plain English into actionable rules and overseeing the creation of new rules for system enhancements.

• Maintained extensive code and codeset tables integral to the mining of measures and diagnoses, ensuring the accuracy and reliability of the system's data.

• Oversaw the Rules Dictionary, serving as the central repository for cataloging all rules, ensuring a comprehensive and accessible reference for the team.

• Created detailed process and data flow charts illustrating the system's operations, from data source to destination, and actively troubleshot user-generated trouble tickets to investigate anomalies in data system versus front-end data at WellMed.

Senior Analyst / CITI 10/2013 - 08/2014

• Spearheaded the creation of temporary and permanent functional IDs within Citi's Global Information Security Administration, utilizing web-based applications to manage access and control for thousands of servers globally.

• Managed the seamless onboarding of new users and roles by receiving, reviewing, and processing requests in accordance with established procedures.

.

.

• Executed the creation and assignment of users and roles, aligning activities with regulated policies and procedures to ensure compliance and secure access at CITI.

• Conducted thorough cross-referencing and reconciliation of login and role ownership data across various management applications, ensuring accuracy and consistency in access management.

• Innovated an automated approach to facilitate mass data changes by scripting the browser within web-based applications, streamlining efficiency and enhancing the overall data management process at CITI. Programmer/Analyst / ROBERT HALF TECHNOLOGIES (AT DAHILL) 08/2013 - 10/2013

• Created and modified new and existing analytical reports for CRM database using classic ASP and TSQL.

• Created new role-based reports for employees in diverse departments.

• Created new functionality for ease of managing and displaying data.

• Created new automated systems based on user-triggered events.

• Created comparison analysis for installing and using reporting system (Crystal Server vs SSRS).

• Created a portal set-up checklist based on database checks for actions that have been completed or need completion.

• Created customer account analysis report showing employee activity on a 30/60/90 day basis

• Environment: Windows 7, Windows Server 2008, MSSQL Server 2008, MSSQL Server 2005, MS Office 2010, Classic ASP, JavaScript at ROBERT HALF TECHNOLOGIES (AT DAHILL). Programmer/Analyst / COMMUNITY FIRST HEALTH PLANS 09/2012 - 07/2013

• Developed utility applications facilitating file manipulation, data transfer, extract/transform/load (ETL), data structure creation, and database retrieval, enhancing efficiency in data analysis processes.

• Successfully repaired multiple damaged Access databases and modified VB programming code, ensuring database integrity and resolving issues in a timely manner.

• Transitioned several reports from Access to web-based SQL Server Reporting Services (SSRS), improving accessibility and streamlining report generation processes.

• Extracted and delivered requested data from diverse sources across the company, adhering to specified requirements and contributing to company-wide data analysis efforts.

• Implemented server-based automated processes for importing and exporting data from external business sources, ensuring seamless data flow and collaboration with external partners. Additionally, developed a sophisticated SQL-code searching application, enhancing code navigation and understanding within a variety of context at COMMUNITY FIRST HEALTH PLANS.

Enterprise Integration Manager / SECURE TECHNOLOGIES, LLC 04/2012 - 08/2012

• For US Army (Fort Sam Houston, USAMITC), maintained and documented processes for MSSQL server and Enterprise Integration server.

• Created and managed automatic log rotation and storage maintenance routines.

• Maintained software patch and security upgrades.

• Maintained monitoring of connectivity and performance of data processing servers.

• Documented installation and maintenance processes.

• Environment: Windows 7, MS Remote Desktop Management, MSSQL Server 2008, Windows Server 2008, Enterprise integration 2009, Remedy at SECURE TECHNOLOGIES, LLC. Software Analyst / GENESIS BUSINESS SYSTEMS 10/2011 - 04/2012

• Developed and maintained compiled and web-based applications for various medical departments at Wilford Hall, Lackland AFB, providing custom solutions and modifications to meet specific needs.

• Successfully converted a critical application from non-compatibility with Windows 7 to a fully functional and compatible version, ensuring seamless operation within the updated operating system environment.

• Utilized a technology stack including Windows 7, ASP.net, VB.net, Visual Studio, SharePoint, and Office 2003/2007/2010 to deliver robust and efficient software solutions for the US Air Force.

• Collaborated with medical professionals to understand their requirements, translating complex needs into user- friendly applications that enhanced operational efficiency and data management.

• Played a key role in the software development life cycle, from design and coding to testing and implementation, contributing to the overall technological advancement and effectiveness of medical systems at Lackland AFB GENESIS BUSINESS SYSTEMS.

.

.

Sr. Database Administrator (Database Designer) / AIM USA, LLC/LAREDO TECHNICAL SERVICES, INC. 01/2007 - 10/2011

• For US Army (MEDCOM, Fort Sam Houston), designed, created and maintained web-based information systems to capture and analyze data from remote facilities world-wide.

• Provided technical support to all remote users of those systems, as well as general support to the immediate local office.

• Updated and maintained department public-facing website.

• Created 5 major web-based data portals that captured medical patient safety data from over 150 remote locations world-wide on a daily basis, housing millions of database records used by both the Army and Air Force.

• Created a web-based replacement application (as an interim) that was used by the US Army and US Air Force for over 2 years so that a proper COTS solution could be procured.

• Environment: Windows XP, MS Office 2003/2007/2010, IIS 6, Adobe Photoshop, Adobe Dreamweaver (CS3), Crystal Reports 10/11/12, PHP, JavaScript, MSSQL Server 2005. Web Developer/PHP Programmer / ItIsRecorded.com 10/2006 - 01/2007

• Developed and managed a dynamic media-streaming website for music, implementing database controls for seamless user experience.

• Crafted site aesthetics, including logo and color schemes, to enhance visual appeal and brand identity.

• Established and maintained robust database systems, along with administration subroutines for efficient data management.

• Engineered PHP code and integrated cutting-edge media-streaming technology for optimal performance.

• Pioneered the creation of a comprehensive data-driven website and associated product line, overseeing graphics, training videos, and advertising materials. Worked with a diverse tech stack, including Windows XP, Linux, Apache, MySQL, MyPHPAdmin, Adobe Photoshop, Macromedia Dreamweaver, Macromedia Flash, PHP, and JavaScript.

Level 2 Technical Support and Training Representative / PRODOC, INC. 03/2003 - 10/2006

• Conducted training daily via telephone and on-site for new customers (professional legal personnel) for a document assembly software application.

• Troubleshot, resolved and documented software application installation and usage issues via telephone and on- site.

• Trained junior technicians to do same.

• Identified sources of over 300 customers' data corruption in financial database, created program suite to scan and repair problems.

• Created and supported a special software roll-back CD for 80 customers experiencing difficulty with a new version of software.

• Created a special technical support web site for software downloads and for customer data transfer.

• Environment: Windows XP, MS Word 2003, TopSpeed, ProDoc. QA Analyst / GLOBALSCAPE 08/2002 - 02/2003

• Developed and executed comprehensive test plans for a web-based content management software application, ensuring alignment with both software functional specifications and business requirements.

• Utilized TestDirector, StarTeam, and Caliber to meticulously track and manage identified bugs throughout the software testing lifecycle, facilitating effective communication and issue resolution.

• Implemented automated scripting to validate the success of software installations, enhancing efficiency and accuracy in the testing process.

• Pioneered a streamlined system for managing and swiftly switching imaged platforms, resulting in significant time savings during testing procedures.

• Operated within a diverse environment encompassing Windows XP, IIS, TestDirector, StarTeam, Caliber, and CMS, demonstrating adaptability and proficiency across various technologies and tools at GLOBALSCAPE. Producer / CONDUIT INTERACTIVE 01/2001 - 02/2002

• Performed the overall design, creation, and maintenance of web sites developed for product ordering.

• Automated the creation and use of HTML documents with the use of proprietary template systems and PHP.

• Administered the design, alteration, and repair of graphics with the use of Photoshop.

.

.

• Generated major operational savings with the automation of existing manual processes at CONDUIT INTERACTIVE.

• Successfully converted a web advertising system encompassing numerous product promotions from a linear system, including sets of files and graphics, to a more modular system that facilitated faster and easier editing.

• Environment: Windows 2000, Linux, Apache, MySQL, Adobe Photoshop, Macromedia Dreamweaver, Macromedia Flash, PHP, JavaScript.

Site Administrator / ZERION.COM 01/1999 - 10/2001

• Developed, administered, and maintained a robust web service hosting over 300 websites, ensuring seamless functionality and optimal performance.

• Customized CGI scripts for remote web-based user administration and site maintenance, enhancing user experience and efficiency in managing web content.

• Generated detailed statistical reports showcasing site traffic and individual user metrics, providing valuable insights for strategic decision-making.

• Achieved an impressive service uptime from January 1999 to October 2001, demonstrating a commitment to reliability and uninterrupted service delivery.

• Implemented automated statistical systems, utilizing tools such as CGI, VB-DOS, and Adobe Photoshop, to analyze traffic and other metrics, delivering daily insights to site users and stakeholders. CERTIFICATIONS

• Security+ Certification

• Microsoft MCITP Certification

Contact this candidate