Mark J. Gillotti

**** ************ **. ********, ** 43221 614-***-**** Cell: 614-***-****

acdg3f@r.postjobfree.com http://www.linkedin.com/in/markgillotti

Project Analyst and Systems Solution Provider

Motivated, personable business professional and experienced analyst with over 20 years specializing in

providing effective business solutions resulting in more efficient business systems. Processes strong analytical and

problem-solving skills with focus on conversion and consolidation of systems to streamline and implement

efficient business processes. Excelling in trouble-shooting issues within the development, implementation and

production environments and collaboratively working with team members to provide solutions. Experience with

various technologies including SQL Server, Oracle, Unix, Pick/Multivalue and PC based applications.

Flexible and versatile – able to maintain a sense of humor under pressure. Poised and competent with

demonstrated ability to easily transcend cultural differences. Thrive in deadline -driven environments. Excellent

team-building skills.

Skills Summary

Project Management Communication Skills Programming Life Cycle

Strategic Planning Customer Service ERP – Order to Cash

Team Building & Leadership EAI Tool Sets SOX – Change

Training Call Center/Helpdesk Management

Reporting

Technical Skills

Languages: PL/SQL, SQL, VB, C#, PERL, C, VB Script, JAVA, Basic, PL/I

Applications: Oracle 11i ERP, Oracle (OM), (INV), (API), (OIT), MS Office, ERA dealership, Prefix Life System

Operating Sys: Windows (NT, 2000, XP, Vista, 8.1), UNIX, MS-DOS

Databases: SQL Server, Access, Universe, Unidata, PICK/Multi-value

Development: SQL Navigator, SQL*Plus, SQL Loader, Optio, Toad, Visio, AppWorx, Visual Studio 6.0

Change Control: Kintana, Test Director, ChangeMan, PVCS, Clarity, Harvest

Hightlight of Achievements

Analyed and resolved an issue with custom order entry module, which impacted the completion processing of

$6 million in sales orders.

Automated account balance summary process for Fortune 500 client which created a more efficient overall

process.

Developed online business forms to create near paperless tracking system for customer and order service

representatives. This reduced their time to complete and update these forms as part of their daily fu nctions.

Developed automated shipping barcode labeling system for warehouse single order processing. Labels were

created and met the requirements for FedEx, UPS, DHL and USPS carriers. Increased the processing

efficiency of these orders for the warehouse staff.

Created user training guide and held training session for analyzing error corrections in the order import

function within Oracle application. Provided user quicker analysis of critical dollar orders for their divisions.

Collaborated with team members for the NY Retail integration project as part of segment consolidation of

systems which provided cost savings to the company.

Worked on team to provide multiple warehouse shipping for McGraw -Hill product which resulted in more

efficient and cost saving deliveries to our customers.

Consolidated AR functions to Lawson Financial system from Retail and Book Club system as part of corporate

decision. Accounts receivable functions migrated to new system to provide savings across all divisions.

Initiated standards protocol within the application team resulting in common practices for code development,

testing and migration which streamlined the development cycle .

Identified issue with batch process runni ng long which impacted daily processing. Collaborated with other

team members to update the program to improve the performance of this job by 70%. Resulted in no longer

negatively impacting the daily process.

Mark J. Gillotti

Résumé, Page 2

Professional Experience

2013 – Present Lambdanets

Project Manager/Soft Skills Coordinator

Engaged in business development for CESS (Commuunicative English Soft Skills) program as a new line of

business for the company.

Developed marketing plan to promote the CESS program

2010 – 2012 Career Pursuits Consolidated, LLC

Founder

Developed online resource, CorrectTurn.com, to aid any one in a job transition match a service to their specific

need while in that transition.

Created business plan for the company.

Built and maintained the web portal using Joomla template and associated d atabase.

Marketed the web site to service providers and customers via job fairs, seminars, meetup events and face to

face meetings.

2009 – 2010 Forty Plus of Central Ohio – Local 501©3 organization

Vice Chairman January 2010 – Liaison to Marketing and Computer Committees

Board Trustee January 2008 – December 2010 – Liaison to Marketing and Committee

Implemented use of Constant Contact service for email marketing efforts and developed training program for

membership along with conducting training sessions in use of this product.

Lead team to develop and deliver direct mail campaigns for Business Firs t Fast Fifty, Grandview Chamber of

Commerce members, Short Nort Business Owners.

Mentored other members seeking leadership roles within the organization in terms of organizational processes,

Created Company research workshop program along with the company information archive storage system for

members who want to review existing research on potential target companies in their job search.

Updates and incorporated social media links from LinkedIn, Facebook and Twitter into company website

along with Better Business Bureau accredited charity logo and link.

Lead team to research the use of PayPal account within a nonprofit which resulted in placement of a donor

button on our web site. This was recently expanded to allow members to pay dues on line using the Pay Pal

functionality.

Resolved outstanding issue with United Way of Central Ohio regarding our qualifications as resulting in

contributions to our organization via United Way actually being passed onto the organization .

Coordinating effort with membership to research potential Grant Funding and collaborated on successful grant

submission to Dublin Foundation.

Expanded the promotion of 40 Plus’s weekly networking event through the use of several on line calendar

(LinkedIn, Craigslist, Upcoming.Yahoo.com, FranklinCountyEvents.com, In-and-around-Columbus.com).

Document the various sites uses and the process to add the event details so other members could perform this

task as needed.

Collaborated with the computer committee to research available resources to acqui re computer equipment to

replace older equipment. Documented the results for future use. Also documented available vendors that

recycle old equipment.

2007 – 2008 Nationwide Insurance

Sr. DEVELOPER/ANALYST

Coordinated full documentation of the PREFIX life system with IBM consulting team.

5070 Shannonbrook Dr. Columbus, OH 43221 614-***-**** Cell: 614-***-****

acdg3f@r.postjobfree.com http://www.linkedin.com/in/markgillotti

Mark J. Gillotti

Résumé, Page 3

Lead team that resolved critical defect with COLI Web processing for online transactions and reporting. Team

members where included from RADS, iMedia and Prefix. Resulted in the process working again after one year

of stagnation. A new process flow was also created for all teams to use as documentation.

Served as SME for the training of new consultants to the team .

Enhanced on-line system reference portal to effectively consolidate PREFIX system documentation,

guidelines, processes and procedures for all team members.

2006 Pick Programmer’s Shop, Hilliard, Ohio

PROGRAMMING CONSULTANT

Streamlined Fortune 500 client's data file transfers and processes to add account balance checks, which prevented

process execution duplication.

Produced company workload reporting for tracking project hours as means to determine profitability or loss for each

project.

Upgraded wholesale client's order entry system to audit entry balances and designed new auditing report fo r

order entry function.

1995 to 2005 McGraw-Hill Companies, Columbus, Ohio

ANALYST-DEVELOPER ADVANCED 2002 – 2005

PROGRAMMER ANALYST II 1997 – 2002

PROGRAMMER ANALYST 1995 – 1997

Developed, tested and implemented conversion API for budgets and tasks data during Phase 1 installation of

Oracle ERP solution.

Corrected the invoice and order status document reports address format to achieve 95% success rate

processing at a 3rd party mail sorting vendor, which prior to the change had only a 25% success rate in

processing.

Automated manual backorder cancellation process to more efficiently process back order notifications,

reducing processing errors by 50% in the system.

Enhanced order entry system with ability to process order taken from web site. Eliminated need to have order

service reps key the order manually from a daily report of web site orders .

Worked on team to provide multiple warehouse shipping for McGraw-Hill product which resulted in more efficient

and cost saving deliveries to our customers.

Education

THE OHIO STATE UNIVERSITY – Columbus, OH

Bachelor of Science Computer & Information Sciences, 1986

THE OHIO STATE UNIVERSITY CONTINUING EDUCATION – Columbus, OH

Supervision and Management, 2008

Marketing for a Small Business, 2008

Nonprofit Leadership Certification, 2010

5070 Shannonbrook Dr. Columbus, OH 43221 614-***-**** Cell: 614-***-****

acdg3f@r.postjobfree.com http://www.linkedin.com/in/markgillotti

Contact this candidate