Michael Wayne Arnold
Gmail.com, username Marmanold
610 S 13th Street
Nashville, Tennessee 37206
Education
Bachelor of Science in Business Administration
The University of Alabama (December 2006)
Majors: Management Information Systems & German
Minor: Computer Science
Experience
- EDI/ETL Team Lead, PlayMaker CRM, Franklin, TN, USA
December 2011 - Present
- Managed a team of EDI specialists to ensure that all integrations were done past expectations and within the alloted timeframe
- Built integration requirements and EDI standards with external IT departments
- Met weekly with clients to give status updates on the progress of the integration
- Worked with the project manager and the client to extract business requirements and logic for integrating external data with internal systems
- Managed tasks for several ongoing and potential implementations at a time
- Electronic Data Interchange Specialist, PlayMaker CRM, Franklin, TN, USA
February 2011 - November 2011
- Extracted data from client sources including various RDBMS, texted-based extracts, and MS Excel reports
- Built custom Java classes to be called via JavaScript in Mirth Connect to assist in data manipulation and extraction
- Using the JExcel API built the first Mirth Connect setup able to use an Excel file as a data source
- Built custom Java classes, Perl scripts, and SQL stored procedures to standardize and improve ETL functions
- Developed a standarized project plan and workflow for integration clients
- Worked closely with development to spec out an XML-based data processing engine, tested the engine, and then implemented the engine into the existing ETL workflow
- Built SQL to facilitate custom reports and analysis for clients
- EDI Data Analyst, Franklin American Mortgage Company, Franklin, TN, USA
July 2009 - February 2011
- Maintained legacy Perl scripts while refactoring the code and migrating it to a new environment
- Developed programming standards and custom Perl modules to increase script resilience and maintainability
- Multitasked between several projects while answering ad hoc queries from business users and external parties
- Monitored and maintained numerous critical B2B and B2G EDI processes
- Gathered specifications for and developed new EDI processes using MS SQL and Perl 5
- Instituted new documentation procedures and began documenting important tasks to meet SAS 70 requirements
- Reduced the number of costly errors on the backend by implementing early error check notification systems
- Learned new technologies and skills on-the-job: e.g., Perl & FNMA DU EarlyCheck
- Assisted business users in solving problems, improving processes, and preventing common issues through ad hoc reporting, monitoring scripts, and historical analysis
- Worked with various internal units; understanding their unique vocabulary and needs
- Automated various manual processes to ensure standardized, controlled, and repeatable processes
- BI Consultant, Market Street Solutions, Chattanooga, TN, USA
September 2008 - July 2009
- Assisted numerous clients across the south eastern United States with building and maintaining business intelligence systems that gave better business insight, increased efficiency, and lowered costs
- Gathered reporting and data modelling requirements via client meetings
- Developed custom business intelligence solutions IBM Cognos 8.x, TM1, and QlikView
- A self-starter and manager on many solo engagements
- MS Access Software Developer, Deloitte Accountants B.V., Rijkswaterstaat, Utrecht, the Netherlands
March 2008 - July 2008
- Continued development on an MS Access development project from a departing colleague a year into the project
- Maintained the application used by ~200 users to manage all active motorway/waterway projects within the Netherlands
- Working closely with various business units to gather specifications and test code, before pushing to production
- Data Analyst/IT Auditor, Enterprise Risk Services, Deloitte Accountants B.V., Amstelveen, the Netherlands
March 2007 - March 2008
- Assured the audit team that data and system migrations were executed in an appropriate and controlled manner and that the affected financial system could be relied upon
- Migrated data and controls from legacy systems to modern ERP systems allowing enterprises greater insight and control over business processes and trends
- Cleansed, validated, and analyzed ERP system master data to provide clients increased confidence in and useful information, trends, and relationships from their data
- Provided clients with custom data analysis, eliciting trends that could point towards fraud, inefficiencies in business processes, miscalculated or unrealized profits, etc.
- Extensively used custom ACL scripts, SQL queries, and Excel & Access macros
- Business Analyst/Systems Developer, Bridge Asset Management System, Alabama Department of Transportation, Tuscaloosa, AL, USA
January 2006 - December 2006
- Joined the project team mid-cycle and quickly educated myself on the project's expectation, requirements, and the specific vocabulary needed to effectively communicate with the client
- Defined requirements over a two month period with weekly verification meetings with the client
- Designed, developed, and tested a web-based application used to forecast a $50 Mil./year budget in ASP .Net with a VB .Net backend connected to an external Oracle database
- Data Analyst, DQI, Audit Enterprise Risk Services, Deloitte & Touche LLP, Atlanta, GA, USA
June 2006 - August 2006
- Worked closely with the audit team to gather specifications for custom general ledger analysis
- Extensively used custom SAS scripts, complex SQL queries, ACL, and business analysis skills to provide the audit team with the information needed during financial and IT audits
Computer Proficiency
- Languages: C++, VB .Net, XHTML, SQL, CSS, PHP 5, ASP .Net, Excel & Access VBA, SAS, ACL, Perl 5, JavaScript, Java
- Operating Environments: DOS, Windows 2k - 7, Mac OS X, Unix/Linux
- Business Tools: Microsoft Office (incl. Access & Visio), Visual Studio .Net, SharePoint, SPSS 13.0, Monarch Pro, ACL, SAS, IBM Cognos 8.x, TM1 9.x, QlikView, Mirth Connect 2.x
- Database Environments: MS SQL Server 2000 - 2008; Oracle 9i, 10g, and 11i; MySQL 5.0, PostgreSQL 9
Linguistic Proficiency
- Spoken Languages: English, German, Dutch, and French
- Intensive Language Experiences:
- Summer 2003, the Universität Klagenfurt, Austria;
- Fall 2004 - Fall 2006, The University of Alabama's German House Program;
- March - August 2005, the Fachhochschule Augsburg, Germany;
- March 2007 - August 2008, Deloitte Accountants B.V., Amsterdam, the Netherlands
- September 2011 - Present, Alliance Française French Lessons, Nashville, Tn.