Ron Mathewson Email and Phone Number

{contract ended 1/2017, Now as needed/part time REVERSE ENGINEERING OF EXISTING CODE BASES ● LAMP(LINUX, APACHE, MYSQL, PHP) ● SOFTWARE ENGINEERING ● DATABASE DEVELOPMENT / DATA ARCHITECTURE DATA MINING ● SOFTWARE ENGINEERING ● BUSINESS INTELLIGENCE ● AD HOC REPORTING ● REVERSE ENGINEERING ● CUSTOMIZED SPREADSHEETS OR REPORTING PORTALS ● HIGHLY SPECIALIZED MYSQL QUERIES FOR REPORTING ● INSTALLED AND MAINTAINED MULTIPLE WORDPRESS SITES ● SET UP MULTIPLE SERVERS USING L.A.M.P STACKS AND OTHER METHODS ● CONFIGURED LINUX SERVERS USING CLI ● USED AMAZON COMPUTE SERVICES EC2 TO SETUP SERVERS ● WROTE CUSTOM MODULES FOR COMMERCE WORDPRESS ● GENERAL COMPUTER WORK AND MAINTENANCE ● WEBSITE DEVELOPMENT AND SEO ● MYSQL PERFORMANCE TUNING ● VICIDIAL SUPPORT AND CUSTOMIZATION ● SALESFORCE API CALLS (SOAP)

 Wrote Connectors for their Statistical reporting software) called DOMO from MYSQL/MSSQL via ODB drivers  Setup multiple stacks on AWS and local .. to test code on local before pushing live  Wrote Highly specialized A Queries or reporting  Wrote API to interface from their new POS solution (NOVA) to push data into an a MYSQL dbase for reporting into DOMO  Used MSSQL and Microsoft Reporting Server to reverse engineer their current reporting system to migration to MYSQL

 Hired to write a business to business advertising/marketing/accounting/reporting CRM system from scratch. Employee #1  ad Hoc Reporting  Acted as a liaison serving as primary point of contact between Upper management for rules, application business connectors and the database..  Organized and Maintained the allocation on a EC2,RDS Database MYSQL AWS Server(s)  Wrote several; APIs to gather information from different external data sources and including but not limited call tracking services (call button, CAKE, Bomberdoo) and store them in a MYSQL database.  Interfaced several big data APIs in verify accuracy of data.  Developed and created the matching logic, dynamic queries, arithmetical and cost data to display the to the end user Client a vendor, In a readable form in both aggregated and drill down modes.  Evaluated (and in some case used) several open source packages to accelerate project time such as, orange, vicidial, limeSurvey, Suite CRM.  Responsible for complete database structure/architecture as well as server maintenance (used Amazon Web platform).

[6 month contract]Contacted to write proprietary code.Senior Software Engineer / DBA Contacted to write proprietary code for a notification platform, primarily mobile.  Used Amazon web services platform  Used/Learned ruby on rails to a beginner level  Used Amazon Web services push technology  Due to the nature of the project I a bound not to discuss any specific details

Reverse Engineered existing code base php, designed, modified, developed, wrote and implemented software programming applications in PHP.  Ad-hoc Reporting.  Functionally operated as Business analyst part time.  Designed and build relational databases for data storage and processing.  Developed strategies for warehouse implementation, data acquisition, and archived recovery.  Cleaned, optimized, indexed and maintained the database.  Evaluated new data sources and software packages for adherence to the organization's quality standards and ease of integration.  Risk Assessment through the use of data analytic tools such as the ones listed above.  Worked with fundamental concepts, practices and procedures relating to systems analysis, design and implementation.  Relied on experience and judgment to plan and accomplish goals.  Designed, modified, developed, wrote and implemented software programming applications.  Supported and installed software applications/operating systems.  Participated in the testing process through test review and analysis, test witnessing and certification of software. Provided technical support to project team members.  Became familiar with a variety of the field's concepts, practices, and procedures.  Relied on experience and judgment to plan and accomplish goals.  Performed a variety of tasks. Led and directed the work of others.  Set up a metadata registry and allowed domain-specific stakeholders to maintain their own data elements.  Experimented with great degree of success, database clustering and memory hole engines.  A wide degree of creativity and latitude was expected and delivered.Please see resume for Key Contributions to DMA Financial LLC

 As the IT manager managed a team of 5 for various projects written and used primarily in MYSQL, Linux, Apache and Javascript.  Managed the content writers to develop proper keyword density for SEO targeted Key phrases.  Created automated PHP scripts to enhance SEO.  Used new SEO tactics as they become known as the Google search engine evolves.  Kept 30+ SEO, personally written applets up to date with code and current content while taking shifts on the support helpdesk.  Oversaw team of 4 programmers and design, develop, and implement software packages for websites and troubleshoot, debug and implement software code.  Designed and constructed web pages/sites including incorporating graphic user interface (GUI) features and other techniques while maintaining and providing ongoing design of the websites.  Used Zend in dummy MVC mode only due to company's existing code base, rapid open source integration and aggressive ramp times.  Promoted to manage daily operations of the global Information Technology department with responsibilities for leading and managing all positions in the department while and performing all duties and responsibilities of previous two positions.  Designed, documented, implemented, and improved business processes, procedures, policies and best practices to best support the organization’s IT needs. Directly manage resource allocation and employee assessment functions and track, trend, analyze, and report on all necessary key performance indicators.  Determined and implemented solutions to provide the highest possible quality while maintaining profitability and cost efficiency.  Build, mentored and lead diverse, but cohesive, qualified teams committed to meeting company goals. Demonstrated capacity to implement innovative practices and programs that drive awareness, decrease exposure and strengthen profitability.Please see resume for Key Contributions to ActionCOACH

Maintained and updated Micros attendance system, Cognos repo Attendance and other technical Gathered and documented user developed training information. Worked with vendor on applicat and ensured requirements were needed. Analyzed problems and perform identify problems Generated useful information for Owned Vendor relationship and timely manner

Provided detailed documentation and regular reports to Vice President Produced graphic art and visual materials for promotions, advertisements such as websites and email newsletters. Maintained website (PHP, HTML, FLASH) and SQL lead database for call center Launched fully integrated VOIP outbound and inbound predictive dialer for 50+ agents

Fore-casted potential changes in the Purchase Pro application Worked with the programming groups/resources to determine over/under allocation. (SQL/PHP/JAVA/HTML/VXML/XML/HTMl) Worked with management to set realistic time-lines and goals for changes to the code Utilized Cognos impromptu for reporting and MS Project for forecasting Worked with Customer Support to forecast call volume and staffing needs Conducted comprehensive labor cost analysis Used OLAP devices (Cognos Impromptu and web-trends) to pull and extrapolate data for reports and analysis

Call Center ManagerInternet business association, ring any bells?

Managed call center of 50 Agents and developed it to over 150 Agents and 7 supervisors in an outsourced technical support call center with several multi-million dollar corporate clients Provided daily support to client and maintained mutually profitable relationship Oversaw reporting analysis and implemented campaign metrics. Worked to ensure assure adequate staffing to meet service level and high quality demand, within budgetary goals. Performed knowledge-base as well as policy development creation and implementation