Sales Analyst

MICHAEL J. PERNA

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

Port St Lucie, FL 34983

722-***-**** home

908-***-**** mobile

*******@*******.***

SUMMARY: Effective strength in interpersonal skills, research and analysis. Interacts with all

levels of management. Possesses excellent verbal and written communication

skills

SOFTWARE: WINDOWS NT/XP, MS WORD, MS OUTLOOK, MS EXCEL/PIVOT

TABLES / VLOOKUP, COGSDALE (Utility Software), SAS

EDUCATION: B.S. Marketing, Rutgers University

EXPERIENCE:

2009-Present Premise Technician, AT&T, Port Saint Lucie, Florida

Install and rearrange inside/outside wires. Verify cable, phone, internet and

Uverse services are working correctly. Job requires travel to various houses daily

in company vehicle. Communicate with customers to ensure completion and 100

percent customer satisfaction. Complete various forms on PC using MS

OFFICE.

2006 – 2009 Office Specialist, Fort Pierce Utilities Authority, Fort Pierce, Florida

Perform statistical, administrative work, radio dispatching, direct customer

assistance, and maintenance of departmental files and records. Create/maintain

Service Orders in Cogsdale for field crews. Participate in job scheduling process

for the Meter Installer/Remover. Ability to understand and follow oral and

written instructions quickly and accurately on various matters.

Meter Reader, Fort Pierce Utilities Authority, Fort Pierce, Florida

Responsible for accuracy in reading electric, gas, and water meters on assigned

routes and record readings on a hand-held device. Reports altered, damaged or

tampered meters to supervisor. Maintain effective working relationships with the

public, employees and other customers in a professional and courteous manner

and a neat appearance. Operates and is responsible for a Utilities Authority

vehicle, general knowledge of First Aid, ability to walk and work outside under

varying working conditions.

2005 Relocation to Florida.

2003 – 2004 Senior Programmer Analyst, AT&T, New Jersey

Responsible for analytical support to the All-Distance marketing team. Develop

procedures, suggest recommendations and provide high quality reports to the

client for business needs. Provide ongoing detail sales reports for new/current

states with over 4 million customers. Work independently, and maintains a

strong focus on efficiency and quality to ensure customer satisfaction.

1998 – 2003 Senior Programmer Analyst, AT&T, New Jersey

Responsible for all analysis for Acquisition Sales - Long Distance-Dial One

Services, This includes market analysis, development of optimization strategies,

and sales tracking for both legacy and trial promotions for over 23 roll up

programs that have a combined acquisition sales of over 9 billion. Perform

financial and statistical modeling analysis in support of all CMD Prospect

Segment Marketing Programs using SAS, MACROS, FTP, MS-

WORD/EXCEL/PIVOT TABLES, RAS, and SYNCSORT. Contribute to the

success of the group by developing and sharing skills and accomplishments with

others. Interface with all levels of management. Work independently,

comfortable working on multiple tasks, and maintains a strong focus on

efficiency and quality to ensure customer satisfaction.

1998 Senior Programmer Analyst, Novartis Pharaceuticals Corporation

Perform analysis on prescription data from over 34,000 pharmacies and matching

them to over 1 million prescribers. Deliver multiple types of data and analyses

critical to Sales and Marketing. Provide information with particular prescriber

information to determine the value of the prescriber and to measure the impact on

writing patterns. Design custom programs/charts to project what prescriptions

will be written by prescriber specialty and accurately and rapidly extract data,

format it, and distribute to the clients.

1995 – 1998 Senior Programmer Analyst, AT&T, New Jersey

Supported Business Operations Analysis (BOA) department. Evaluated trials and

promotions in order to assist marketing groups to make decisions concerning the

economic viability of AT&T services (NBA Promotion, Calling Party Pay6s, and

Mother Day Sweepstakes). Targeted marketing by supporting decisions to

continue/terminate promotions based on analysis of how promotions performed.

Analyzed characteristics of the customer base using profiling, market sizing, and

modeling techniques. Performed internal analysis on retention behavior for

AT&T Wireless and WorldNet programs. Recommended areas that warrant

attention, produce reports/graphs on results.

Supported and maintained the Plan Outpic Retention Tracking System to assist in

evaluation and tracking the performance of optional/loyalty calling plans.

Primary function was to compare monthly outpic rates of customers vs.

comparable group of customers who are not on plans. Utilized JCL, SAS,

SYNCSORT, and MS-EXCEL. Demonstrated ability to handle multiple projects

and works with minimal supervision. Attended to the needs of the clients to

maintain client’s satisfaction and build long-term relationships. Contributed to

the success of the group by developing and sharing skills and accomplishments

with others.

1993 – 1995 Senior Programmer Analyst, A.M. Best Company, Oldwick, New Jersey

Designed and developed programs utilizing JCL, SAS, and SYNCSORT to

extract and analyze data for various types of external request for data or ad-hoc

reports on CD-ROM, mag tapes/diskettes. Utilized programs for ad-hoc analysis

of TOP-10 underwriters by volume, customer count and dollar amount. Worked

independently and maintained a strong focus on quality to ensure customer

satisfaction.

1993 Programming Consultant, BFR Systems, Somerset, New Jersey

Coordinated the integrations of SAS AF/SCL to current version using PC3270

emulation. Created all datasets and files for upgrade and modified programs to

run in new version. Conducted all unit and system testing before sending to UAT

for approval. Completed appropriate documentation for system.

1981 – 1993 Risk Analyst/Programmer, Beneficial Corp., Peapack, New Jersey

Formulated strategies for managing consumer loan portfolios based upon

empirical evaluations and monitored reports to determine the effectiveness of

strategies. Developed a database with merchant/customer information that

provided flexibility for selection reports using JCL, TSO, and SAS. Designed

and maintained material used in Planning/Modeling reports, and fixed asset and

depreciation system for Headquarter offices. Worked with clients and marketing

departments to complete analyses in a timely manner to create and-hoc reports on

credit-card portfolios.

Awards AT&T Consumer Awards for outstanding contributions and taking on additional

responsibility.

• Commitment to Excellence

• True Achievement Award

• True Thanks

Contact this candidate