Post Job Free

Resume

Sign in

Business intelligence analytics data architect DBA software engineer

Location:
Las Vegas, NV
Posted:
June 13, 2017

Contact this candidate

Resume:

Resume of Ron Mathewson- Henderson, NV

acy6ic@r.postjobfree.com - 702-***-****

(preferred method of contact SMS)

Summary

“Jack of All Trades, Master of Some”

Pursuing a career with an organization that I can grow with so that it will further my technical knowledge and passion under the umbrella of Software Engineering, Business Intelligence, Reverse Engineering, Mathematics, System Administration, Development, data analytics, data surfacing, data mining, reporting software dashboards integration or building, API building and integration, ad-hoc reporting and analysis. I am a quick learner with excellent problem solving skills, results oriented and dedicated IT Professional with a comprehensive background working in and leading cross-organizational IT analysis, support, application design initiatives, roll-outs dealing with and directing a broad range of corporate technical initiatives and solutions in direct support of business objectives. Such as:

Software Engineering: Languages PHP, MYSQL ( Programming Typically on a Lamp/Wamp Stack) DBA(Database Administration) Mathematics Predictive Analytics Data mining Business performance management Text mining Bench-marking Database development MYSQL(most SQL syntax-es) Reverse engineering (both code and electronics) Process Mining Web Analytics Online analytic processing System Administration System Administration VIOP Technology

Technical Highlights

Extremely adept at reverse engineering existing code-bases without documentation for the purpose of enhancement and modernization.

Extremely proficient writing advanced MYSQl queries, DBA and reporting. Advanced experience in Data Science and Mathematics. Impeccable ability to analyze problems, make quick/effective decisions, and motivate others towards implementation of a solution.

ETL-Extract Transform Loading.

Extremely proficient in a LAMP Development environment. Process Improvements, I am constantly on the lookout for ways to improve internal and external processes, discover issues and deliver better value to the customers (internal and external). Highly advanced experience in dynamic integration with several non-conventional APIs. Open source integration into several already existing platforms Generated reports that met management's individual information requirements and allowing management to dynamically modify and drill through report data for powerful information analysis. Familiar with Software development process or program methodologies (scrum, waterfall) Worked in a statistical programming environment.-Using SAAS, Angoss knowledge studio, Orange, Weka, Pentheho. Managing the process improvement projects through to completion. Looking for every opportunity to simplify all processes through automation or manual changes in work-flow.Providing cross functional project support by partnering with Network Strategy, DC Operations, and Training. Provided Engineering, planning and Maintenance support and direction upper management, Prepared, maintained and updated new engineering documentation relating to new and existing processes implemented. Intermediate knowledge of base SAS, SAS macro language, SQL as well as other programming languages. Proven track record of increasing responsibility in leadership, business process design, new business development, and full life cycle project management.

Demonstrated capacity to implement innovative practices and programs that drive awareness, decrease exposure, and strengthen profitability.

Outstanding ability to integrate various open source platforms into existing code-base. Hands-on experience leading all stages of new business segment deployment efforts, including requirements definition, design, architecture, programming, documentation, training, and support.

Highly advanced SEO (Search Engine Optimization); including SEM (Search Engine Marketing), SERP (Search Engine Results Page), and Google® Analytics.

Ron Mathewson

Henderson, NV 89011

acy6ic@r.postjobfree.com

702-***-**** (preferred method of contact SMS)

CORE COMPETENCY FIELD SUMMARY

AD-HOC REPORTING: WROTE REPORT REQUIREMENTS AND GENERATED REPORTS USING SQL TO PULL THE DATA, AND WROTE TO IN DISPLAY A CUSTOM BUILT DASHBOARD OR IN EXCEL .COMPLETE MICROSOFT OFFICE SUITE (WORD, EXCEL, OUTLOOK, POWERPOINT, & ACCESS AND MICROSOFT VISIO.), EXCEL EXPERT

BUSINESS INTELLIGENCE ANALYSIS: COLLECTED REQUIREMENTS FOR NEW FEATURES AND FUNCTIONALITY OF THE EXISTING SYSTEMS Wrote product requirements for developers, including wireframes Wrote product documentation and maintained system processes to make the roll-out of the software as easy as possible for the users

Data Architecture: Data Mining- in-composing raw analysis, database and data management aspects, data processing, model and inference considerations, interesting metrics, complexity considerations, post-processing of discovered structures, visualization Data Warehousing, Data Analytics, Data dictionaries, Data modeling, Neural Nets, Enterprise application integration, Metadata registry, Master Data, Management (MDM), Relational Databases, Semantics. Data retention, Structured Query Language (SQL). Procedural SQL, Unified Modeling Language (UML), Development of a data strategy and associated policies, capabilities and systems to meet business information needs. Software used: Orange software, RapidMiner software, WEKA, Angoss Knowledge Studio Lead marketing analytics efforts(actioncoach.com), Worked with large data sets to create, measure and provide key insights for online campaigns as well as risk assessment

Provided tracking, tagging and measurement requirements for data warehousing and reporting Analyzed website behavior and customer experience to feedback into the design or architecture of the website. Performed Quality Assurance on projects and features not created by myself and developed QA plans Software Engineering: Extreme experience with LAMP Stack {PHP – MYSQL – Linux, Apache} (Averqge understanding of MVC model (PDO, ZEND, Code Igniter only used in personal project/practice.), HTML, CSS, XML, VXML, SEO, SERP, PPC Linux: several kernels (Gentoo, Debian, Arch) [distros:Ubuntu, Saybon, Bohodi, Arch, Zorin] Microsoft Operating systems: Windows XP, Windows Vista, Windows 7, 10 and some Windows Managemen t: Managed call center of 50 Agents and developed it to over 150 Agents in an outsourced technical support call center with several multi-million dollar corporate clients. Integration Specialist: Heavy Experience with APIs and open source and new technology integration into already existing code- bases

Cloud Computing: Amazon EC2 services, Google Compute, Microsoft Azure CALL CENTER: LUCENT CMS, VICIDIAL,OPENBPX FIVE9 VOIP SOFTWARE SUITE OPEN SOURCE AND COMMERCIAL CMS (CONTENT MANAGEMENT SYSTEMS): INCLUDING ECOMMERCE: WORDPRESS, JOOMLA, E107, OPENCART, ZENCART, MAUTIC, LIME SURVEY, SUITE

CRM:, SALESFORCEEXTREME EXPERIENCE WITH LAMP STACK {PHP – MYSQL – LINUX, APACHE} (AVERQGE UNDERSTANDING OF MVC MODEL

(PDO, ZEND, CODE IGNITER ONLY USED IN PERSONAL PROJECT/PRACTICE.), HTML, CSS, XML, VXML, SEO, SERP, PPC LINUX: SEVERAL KERNELS (GENTOO, DEBIAN, ARCH) [DISTROS:UBUNTU, SAYBON, BOHODI, ARCH, ZORIN] MICROSOFT OPERATING SYSTEMS: WINDOWS XP, WINDOWS VISTA, WINDOWS 7, 10 AND SOME WINDOWS COMPLETE MICROSOFT OFFICE SUITE: (WORD, EXCEL, OUTLOOK, POWERPOINT, & ACCESS AND MICROSOFT VISIO.), EXCEL EXPERT PROFESSIONAL EXPERIENCE ON NEXT PAGE

Page 2 of 7

Ron Mathewson

Henderson, NV 89011

acy6ic@r.postjobfree.com

702-***-**** (preferred method of contact SMS)

PROFESSIONAL EXPERIENCE

GWGLIFE LLC [WWW.GWGLIFE.COM] Henderson, Nevada 1/2016- present Senior Software Engineer / Business Intelligence / Data Architect / DBA / System Administrator Currently working month to month 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 ● MYSQLPERFORMANCE TUNING ● VICIDIAL SUPPORT AND CUSTOMIZATION ● SALESFORCE API CALLS (SOAP)

A.K.M .Las Vegas, Nevada (3 month contract) 9/2015 to 12/2015 Senior Software Engineer / DBA / Data Architect

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 Paragon Metrics – Las Vegas, NV 11/2014 – 09/2015

Software Engineer, Project Management, DBA

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). Bodhi Automation (Consultant) Las Vegas,NV (contract) 5/2014 - 10/2014 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 DMA Financial LLC – Henderson, NV (3 years) 4/2011 – 4/2014 Software Engineer / DBA / Project Manager / Business Analyst

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. Page 3 of 7

Ron Mathewson

Henderson, NV 89011

acy6ic@r.postjobfree.com

702-***-**** (preferred method of contact SMS)

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. Key Contributions of DMA Financial LLC

Built modules to allow management to build their own reports and modify existing ones. Generated reports that met management's individual information requirements and allowing management to dynamically modify and drill through report data for powerful information analysis. Created, from ground floor, a SMS system that would pull data from the current database, to send out mass SMS's or phone texts based off criteria such as payment days, birthdays, over under payments to generate call volume. Created API to check credit card numbers against luhn algorithm as well as a database of financial institutions to verify valid credit cards without checking account, Created several internal APIs to interface with call center side of business to import and export leads.

Optimized several MYSQL queries to decrease load to database server by over 70%. Optimized code base to decrease server load by 80%.

Re indexed the current database using keys and foreign keys. Experimented with success different dbase engines, maria, MyISAM. InnoDB, to speed up database transactions. Utilized Angoss Knowledge studio to develop risk assessment profiles and scorecard system. Presented working models to upper management to decrease risk management by 10% to 25%. Created several tools for exceptions team to speed up processing and decrease workforce. Created several custom reports that used MYSQL fuzzy logic due to lack of preexisting relational database structure. ActionCOACH – Las Vegas, NV 02/2008 – 04/2011

Project manager / DBA / SEO Specialist/ Web Developer/ Business Analyst

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.

Page 4 of 7

Ron Mathewson

Henderson, NV 89011

acy6ic@r.postjobfree.com

702-***-**** (preferred method of contact SMS)

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.

Key Contributions-ActionCOACH

Increased rankings of corporate site using keyword density analysis and custom written PHP scripts.

Prepared several ad-hoc reports for senior management.

Increased traffic by over 200% using these tactics for certain sections of corporate site.

Successfully reversed SEO’d negative sites off page one of Google.

Optimized Maintained several (100+) Web sites and specific pages to make them more search-engine-friendly, thus getting elevated positions in search results.

Handled 2000+ accounts and all servers both in house and off-site.

Responsible for all aspects of domain multinational registrar (2000+ names).

Created several modifications add-ons to all public facing an extra-nets.

Interfaced several platforms on public sites with social media platforms; Facebook, Twitter, LinkedIn.

Wrote Facebook apps using iFrame method and FB PHP frame work.

Used FBSQL to capture data for lead system.

Created several applets for lead capture and matching. Wynn Casino – Las Vegas, NV 2/2007–2/2008

Business System Analyst/Application Specialist (contract)

Maintained and updated Micros 9700 POS system, Cetec and time and attendance system, Cognos reporting tool, and Kronos Time and Attendance and other technical applications.

Gathered and documented user system requirements and developed training information.

Worked with vendor on application design and implementation, and ensured requirements were met for any custom add- ons needed.

Analyzed problems and performed lab tests and simulations to identify problems edified teams committed to meeting company goals. Demonstrated capacity to implement innovative practices and programs that drive awareness, decrease exposure and strengthen profitability.

Generated useful information for inclusion in Knowledge base.

Owned Vendor relationship and drove results with them in a timely manner.

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 logistics and structure.

Provided detailed documentation and regular reports to Vice Presidents.

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.

Forecast potential changes in the Purchase Pro application.

Worked with the programming groups/resources to determine over/under allocation (SQL/PHP/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 Forecasted potential changes in the Purchase Pro application. Page 5 of 7

Ron Mathewson

Henderson, NV 89011

acy6ic@r.postjobfree.com

702-***-**** (preferred method of contact SMS)

Shearson Financial Network, Inc. – Las Vegas, NV 2003 – 2007 (4 Years) Marketing Director/Web Development/Graphic Designer Marketing Director/Web Development/Graphic Designer

Launched and maintained a fully integrated VOIP outbound and inbound predictive dialer for 50+ agents.(FIVE9)

Worked with the programming groups/resources to determine over/under allocation (SQL/PHP/HTML/VXML/XML/HTMl).

Provided detailed documentation and regular reports to Vice President.

Maintained website (PHP, HTML, FLASH) and SQL lead database for call center.

Produced graphic art and visual materials for promotions, advertisements such as websites and email newsletters. PURCHASEPRO.COM – Las Vegas, NV 2000 – 2003 (3 Years) Operations Manager/Logistics Specialist/Project Manager

Worked with the programming groups/resources to determine over/under allocation (SQL/PHP/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, data cubes and OLAP cubes (Cognos Impromptu and web-trends) to pull and extrapolate data for reports and analysis.

ClientLogic (now Sitel) – Las Vegas, NV 1995-2000 (5 Years) Call Center Operations Manager/Project Manager

Managed call center of 50 Agents and developed it to over 150 Agents 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.

Responsible for the daily running and management of the center through the effective use of resources.

Responsible for meeting, forecasting and possibly setting, customer service targets as well as planning areas of improvement of development.

Ensured that calls and emails are answered by staff within agreed time scales and in an appropriate manner. Coordinate and motivate call center staff and may managed staff recruitment. Skill list Matrix on following page

Page 6 of 7

Ron Mathewson

Henderson, NV 89011

acy6ic@r.postjobfree.com

702-***-**** (preferred method of contact SMS)

Ron Mathewson-Skill Set outline Years Used Last Used Data Architecture 8 2017

Data Modeling 8 2017

Vicidial 4 2017

API 10 2017

MYSQL / DBA 8 2017

PHP 8 2017

Ad-Hoc Reporting 8 2017

Business Analyst 8 2017

Reverse Engineering >10 2017

Networking 7 2017

LAMP WAMP ZAMP 8 2017

Bit coin / Litecoin Cryptocurrency Algorithms SHA256d, Scrypt, Scrypt-n 2 2017 Cognos 3 2003

Knowledge STUDIO – Orange -RapidMier 3 2016

Linux-several kernels (Gentoo,Debian,Arch)[Ubuntu, Saybon, Bohodi, Arch, Zorin, Android, BEOS]

6 2017

VoIP 10 2017

CRM (SalesForce,SugarForce,ZoHo) 10 2017

CMS (Wordpress, jooma 10 2017

Active Directory 1 2017

Electronics (associates degree) >20 2017

Data Analysis >10 2017

Call Center >10 2010

Web Development >10 2017

Network Management 3 2017

Management >10 2010

SEO/SEM/SERP 3 2010

Big Data 3 2016

Heterogeneous computing: Hadoop, cuda, open cl 1 2016 Crypto currency Algorithms and mining 3 2016

MSSQL 3 months 2016

Microsoft Reporting Server 3 months 2016

EDUCATION

Erie Community College – Orchard Park, NY

AS - Electronic Equipment Technology (specialization In RF transmission) Micros Property Programming Training – Kronos Works 2007 Personal Hobbies and Areas of Study

Computer languages and architecture • Electronics • Chemistry • Physics • Nootropics • Quantum Mechanics • Philosophy • Psychology • All aspects of technology • 3D Printing • CytptoCurrency [currently running(at home)5 terrahash of ASIC SHA2d miners] • Robotics • Amazon EC3 Services • Much DOGE Page 7 of 7



Contact this candidate