Mark D. Fetterman

*** ***** ***** ( Clinton, PA *5026 1-412-***-****(

acgom6@r.postjobfree.com

Mark has been a

great asset to

Trident Systems

Inc. by working to

retain customers

through

professionalism and

honesty and selling

new opportunities

by walking clients

through the process

of what touch

screens would best

fit their needs

Performance

Review Excerpt,

Trident Systems

Inc.

"As a Procurement

Specialist for

Fisher Scientific,

Mark has

consistently

demonstrated

leadership, a

strong work ethic,

and a dedication to

serving our

customers. As for

his work ethic,

Mark takes on extra

responsibilities to

better himself and

to add value to the

company" Jen Kovach

- Buyer

ThermoFisher

Scientific

Mark is a great

asset to the

department and

myself. With the

demands that are

placed upon me I

would never

accomplish all my

duties without his

help. Jacqueline

Williams - Account

Executive for Bank

of America at

Servicelink

Computer Skills:

Qlikview, MS Word,

Excel, PowerPoint,

Access, Outlook,

Office; PageMaker;

Photoshop; Cognos;

Windows and

Mainframe.

Additional

Training:

Qlikview - Design

and Development

The Dale Carnegie

Course for

Effective

Communication and

Human Relations.

ThermoFisher U

Business Etiquette,

Discovering

Personality Styles,

Techniques for

Better Time

Management, Basics

of Excel.

Senior Business Intelligence Analyst with over 10 years experience

in report development & analysis. Demonstrated leadership abilities

and the ability to perform under pressure with limited direction

and supervision. Keen perception, strong analytic skills and my

attention to detail enable me to solve complex requirements ahead

of schedule.

Summary of Qualifications

Over 8 years of IT experience as Business Systems Analyst/Data

Analyst including project planning and management, software

analysis and design.

Extensive experience with object oriented analysis and design and

developing use-case models.

Ability to meet deadlines and handle pressure while coordinating

multiple tasks.

Demonstrated strong interpersonal skills with the ability to work

effectively alongside upper management and excellent leadership

skills in motivating others.

Technical Skills

Tools: MS Visio, MS Excel, MS Power Point, MS Project.

Databases: MS Access, SQL Server 2008R2

Operating Systems: Windows 98/2000/ME/NT/XP

Languages: SQL, Oracle, SAS, HTML, VB Script,

Reporting tools: Micro strategy, SSRS, Crystal Reports, Qlikview

11, Cognos

Experience

Servicelink. - Hopewell, PA - Mortgage Title Insurance Company

Senior Business Intelligence Analyst 2013 to Present

Wrote complex SQL Queries, Designed Dashboards and provided in

depth data analysis to senior executives

Results:

I produced a series versatile SQL and Qlikview templates. These

templates were designed to minimize production time so I could

quickly adapt and provide quick responses to new requests.

Designed and deployed Visual Studio reports that were dependent on

the complex ad-hoc SQL queries I wrote. These reports were then set

to auto generate on a set schedule and deploy to shared folders or

email directly to end users.

Taught myself advanced SQL joins and practices so I could obtain

data from multiple data platforms. These techniques enabled me to

expand my reporting duties to include additional offices,

departments and organizational hierarchy.

Designed forecasting reports which showed past present and future

trends in business and production.

Met with clients and executives to examine reporting requirements

and design reports based upon desired criteria.

Provided reporting on QA related activities

Business Intelligence Data Analyst / Developer 2012 to 2013

I created, analyzed and managed daily, weekly, monthly and ad-hoc

reports, designed Qlikview Dashboards and increased efficiency

throughout the company.

Results:

Developed a line of reports and macros that save Servicelink over

1600 days of production and over $500,000 in revenue annually

Was assigned the additional responsibility to assume ownership for

all reporting in both the Pennsylvania and California offices.

Designed scorecards based upon client performance metrics to

accurately determine if goals were met, missed or in danger of

meeting compliance.

Designed additional scorecards in Excel which predicted trends,

goals and tracked performance standards.

Implemented Business Intelligence dashboards within Qlikview to

track and evaluate revenue and production.

Report Manager, 2011 to 2012

I analyzed, streamlined and improved the established reporting

process.

Results:

Implemented the strategy of shifting reporting responsibilities

away from senior members of management and funneling all reporting

through myself.

Reviewed all existing data reports for errors and inconsistencies

and fixed, optimized or replaced any reports I found that were

inaccurate.

Wrote training guides for Microsoft Excel and Qlikview. Upon

completion I held a series classes for senior ranking members of

management to better improve efficiency and expand the knowledge of

both programs.

Improved established Qlikview dashboards by adding additional SQL

fields to the Qlikview Database and created new reports based upon

the newly established fields.

ThermoFisher Scientific. - Pittsburgh, PA - Scientific Research

Company

Procurement Specialist, 2009 to 2011

I provided data analysis and research with regard to inventory and

a purchasing cycle.

Results:

Improved invoice processing times by spearheading an invoice delay

project.

Researched products and services and provided sourcing solutions

for clientele.

Worked as a liaison between clients, suppliers and members of our

management team.

Negotiated pricing with vendors based upon availability and

projected needs.

Worked extensively on backorder projects which helped reclaim over

5 million dollars in missing invoices and orders.

Tracked all data, performance and trends through a series of

detailed excel spreadsheets.

Trident Systems Inc. - Mt. Braddock, PA - Computer Software

Development Company

Account Manager/Project Manager, 2005 to 2009

I executed all obligations related to sales orders. These

obligations included data analysis, research and development,

purchasing, negotiation, tracking and sales support.

Results:

Worked directly with global clients Boeing, Lockheed Martin,

Motorola, McKesson. In this role I was pivotal in meeting with the

clients directly, obtaining information, requirements and specs on

projects. I would then relay the requirements to our software

development team and follow the projects through from development,

testing, shipping and post delivery phases.

Increased total revenue from 1.1 million to 2.7 million annually by

expanding clientele base by 87.5%

Lowered repair and returned products rate from 28% to 5.3% by

implementing a more stringent QA process and a thorough tracking

system.

Created a series of databases and spreadsheets that improved

inventory management and tracked quotes issued.

Successfully negotiated a deal with the Transportation of Italy in

2008 for 1,200 touch screen monitors, software and support worth

1.1 million USD.

Was an integral part of having Trident Systems obtain ISO9001

Certification.

J.T. Becker and Company - Carnegie, PA - Insurance Fraud

Investigation Company

Account Manager/Field Supervisor, 2001 to 2005

I supervised and trained a team of field investigators to detect,

monitor, and report fraudulent insurance claims.

Results:

Created and implemented a complete and uniformed training program

designed to teach, mentor and create successful investigators.

Wrote and reviewed reports for the clientele of Becker and Company.

Evaluated the performance and conduct of personnel and made

training recommendations based upon my observations.

Allied Security - Pittsburgh, PA - Insurance Fraud Investigation

Company

Account Manager 2000 to 2001

I managed 15 accounts and 75 guards in a designated area of

Pittsburgh while providing customer service support to client base.

Results:

Scheduled security coverage for the 2001 Mellon Bank Mario Lemieux

Celebrity Invitational Golf Tournament at Nevillewood Country Club.

Wrote and implemented an Operations Procedure Manual for Carlow

College which was used for initial and continual training

processes. This manual covered ethical procedures, performance

standards, emergency situations and reference guides.

Lowered overtime rates by 85% by streamlining the scheduling

practices and improving overall efficiency.

Met with clients to discuss the needs, schedule security coverage,

provide updates and receive any additional information or special

assignments.

Additional Skills

Account Management, Accounts Receivable, Accounts Payable, Customer

Service, Database Management, Project Management, Procurement,

Purchasing, Research, Sales Forecasting, Inventory Management,

Negotiations, Communication, Marketing, Leadership, Training Supply

Chain and Product Lifecycle and Replacement Strategies.

Education

Columbus College of Art and Design - Columbus, OH; Course of Study

Fine Arts

Punxsutawney Area High School - Punxsutawney, PA; Course of Study

Academic

Contact this candidate