Mark A. Stacklin

**** ********* **

Willard, Ohio 44890

614-***-**** Mobile

adgwvi@r.postjobfree.com

Information technology professional with 20+ years of experience. SQL database administration; software engineering; development of new and extending existing applications. I am organized and detail oriented.

Qualification Highlights

Effective communicator

Software engineering

Client/Server technology

Project management

Database administration

Quality assurance

Remote admin tools

System, data and gap analysis

Monthly reporting

Technology skills and tools utilized

Operating systems

MS Server 2008, 2003; Windows 10, Windows 7, Citrix, Microsoft Virtual PC

Database

MS SQL server 14-08-05-00; Interbase; MS-Access 10-07-03;

Development tools

Alteryx 6.2; MS Visual Studio VB.NET 2005; Visual Basic; Delphi 1, 4; Power Basic;

Micro Focus Cobol; IBM MVS JCL; Cobol-85, Batch Insurance programming

Office & Reporting tools

MS-Excel 10-07-03; MS-Word 10-07-03; MS-Outlook 10-07; Crystal Reports XI;

Systems supported

Microsoft Dynamics GP 10.0, 9.0, 8.0; LibertyNET 8.5;

Solid programming skills VBA, BASIC, Pascal and COBOL languages, some VB.NET, can work with and use object models to provide a solid base to reuse code and adapt to other purposes quickly.

Professional Experience:

Mid Ohio Employment services dba Spherion, Willard,OH February 2017 to May 2018

Mtd MIDWEST Industries – light assembly lines 3 & 4, press room, hangline, wheels

Paint room pre and post auto spray booth powder coating parts.

Pepperidge farms laborer – packaging cookies, crackers. Working on integrated line.

Adecco Engineering & Technical assigned Owens Illinois February 2016 to Sept 2016

Joined HRIS project, providing Data extracts from staging environment to test.

SQL scripting data transformations, creation of lookup and picklist tables.

Addition of active directory data to staging environment, county web service addition.

Created validation scripts for staging master tables to foundation data.

Gap analysis, source population counts and validations.

Created several Ms Access to import data from flat files into staging data base.

Created Active directory capture profile info, web service using MS Access for county of residence..

Mid Ohio Employment services, Willard,OH November 2015 to February 2016

Pepperidge farms laborer – packaging cookies, crackers. Working on integrated line.

Beacon Hill Staffing Group LLC, Boston, MA, : Amtrust Services Cleveland, OH March 2015 to July 2015

Production corrections group, creating scripts for prod corrections, use of root cause analysis with T-sql scripting

of solutions for add, update, delete to tables bulk row updates and single row adjustments.

Personal auto commission by coverage and premium backfills and Agent master commission maintenance.

Collabera, NJ assigned to JPMC Dublin, OH SQL analyst Programmer February 2014 to September 2014.

Work to take over support and maintenance for POC Le2e application (MS Access 2007) front end to MS SQL server database. Perform analysis and support for migration of data to Oracle. Work with team in New York.

Coded VBA fixes to application interface and startup code. Code release and testing.

Created Office 2010 test plan and scripts for LOB testing and sign-off, capture and report results, attend meetings

Provide schema info for Development team, support POC through cutover/decommission time frame. Alter/update VBA modules/code as needed. Excel extracts/change reports.

Developed automated EUT exceptions report for LOB managers, focused on departmental cost containment. Coding of Macro’s, SQL, SQL-helper functions-VBA, DDL statements, Tables,filters,export to excel file and pivots.

When idle moved legal documents from DMS (decommissioning) to Share-point document library.

Thomas Employment Mentor, OH assigned to Client Marketing Company September 2013 to October 2013.

Creating marketing lists. Applying list building processes, using software interfaces and Query work arounds

to produce campaign targets, shave back excess, document packets, keep up with channels of returns requests,

Opt-Ins, maintain data consistency providing feedback on shorts overages, averages met/missed.

MS Access 2010; SQL 2008; Word;Excel;Import/Export matching.

Contractor(W2) VBeyond Corporation Hillsborough, NJ assigned Genpact as MS Access Developer

Final client AssuraMed (a cardinal health member company) April 22,2013 to August 16, 2013

Familiarize self with Current Spreadsheet solution Excel 2010 pulling from Access 2010

Developed New application for sales information business intelligence and data entry interface for sales force to use as replacement for excel solution. Capture/migrate current sales data entry info. Organize data(Ro/Rw) for MS Access 2010 interface, create beta, finalize and finesse after review by sales management.

Optimized SQL process for Monthly reporting Increased speed to 90x faster than legacy method.

Custom Production Specialist, AccuData Integrated Marketing, Fort Myers, FL (June 2011 – October 2012)

Alteryx 6.2 development and maint - recurring, ad-hoc, list rental, suppression, data processing, Match runs use of proprietary data for appends, geo selects, demographic or firmographic selects. Spatial processing (queries, nearest, distance and trade area joins). Vendor append tools processing, CASS, DSF, NCOA, External services

MS Excel pivot tables, tables, import and export to csv files.

Desktop Tech, Infinity Tech Solutions – Consultant, US Sugar Corp, Clewiston, FL (Dec 2010 – May 2011)

Lease return monitor swap, Lease return Laptop upgrade Win7 and PC upgrade Win7. Install & personalize.

Image laptop and PC’s; personalize add printers and any unique software for user.

Microsoft office support, Windows support, printers and switches level one support.

Systems Application Analyst, Bonita Springs Utilities Inc., Bonita Springs, Florida - (May 2006 - June 2010)

Administration and upgrade MS Dynamics GP, Customizing forms, reports, adding functionality through VBA.

Upgrade and support for Cogsdale CSM 10 billing system. Communicate enhancement request to vendor. Problem reporting and follow up on system gaps and errors. Developed SQL to compare test to production.

Developer skills MS access creating interfaces, table design extending functionality, reporting from MS SQL

MS SQL server administrator – use of DDL, DML, security, backups, Log backups, restore to TEST Env.

Programming T-SQL, stored procedures, UDF scalar and table returning functions.

SQL scripting for gap analysis, created lists for review by customer service, Import Inventory reconciliation.

Problem analysis, reporting software problems to vendors communicating on topic both written and verbally.

Consultant, R.R. Donnelley Inc., Willard, Ohio

(July 2002 - February 2003 & August 2004)

Consultant, Quick Solutions, Inc., Columbus Ohio

(April 1992 - August 2001)

Technical Lead CRM app customization CompManagement Health Systems

(August 2000 to June 2001)

Technical Analyst, Health Insurance proposal system, North Star Marketing

(January 1998 - August 2000)

Programmer/Tester, First USA FCS

(October 1997 to December 1997)

Technical Analyst, Health Insurance proposal system, North Star Marketing

(May 1994 to September 1997)

Bank-pro developer Branch Automation Banc One Westerville Ohio

(April 1992 to May 1994)

The Shelby Insurance group

(April 1989 to April 1992)

Education

Heidelberg College May 1987

Bachelor of Science in Business Administration/Computer Science

Contact this candidate