Sales Customer Service

John M. Rodriguez Jr.

**** ******** **** ( Mesquite, TX 75149 ( Ph. 214-***-**** ( Email:

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

Seeking professional position that allows me to utilize and enhance my

current skills, and one that

pushes me to learn new concepts for continuous professional development.

SUMMARY OF QUALIFICATIONS

. Highly proficient in MS Excel and PowerPoint - use to create executive

level templates and reports

o Including: pivot tables, v(h)lookup, charts and graphs, formulas,

database, and linking

. Scorecarding from scratch which measured top-to-bottom metrics within the

organization

. Provide intricate analysis into financials (actuals vs budget vs

forecast) including variance explanation

. Flexible with communication and presentation skills to effectively reach

any and all audiences

. Eager to use, and learn if needed, various systems to retrieve data as

well as for cross-training reasons

. Possess the zest needed to articulate findings, successes, and

recommendations for areas of improvement

. Deadline driven and strong desire to improve and streamline the current

processes

. Create ad hoc templates/tools that assist in improved performance

accuracy and report timeliness

. Ability to serve as a project lead and maintain cohesion among all

internal and external stakeholders

WORK EXPERIENCE

IT Performance Analyst / Budget Analyst

06/06 - 10/09 Dr. Pepper Snapple Group, Inc/Cadbury Schweppes

Plano, TX

. Analyzed various IT operational related data and generated metrics to

assess IT's processes and areas for improvement in performance

o Heavy use of Excel to create and maintain cascading database system

for all department metrics

o Collaborated and directed internal IT departments to ensure the

highest data integrity and accuracy across the board for CIO level

reporting

. Generated and moderated PowerPoint presentations to the ITLT covering

high level performance metrics and recommendations for improvement

o Presented high level reporting to CIO and IT VPs on a frequent

basis

o Maintained reporting presentations on Sharepoint site for org-wide

audience

o Revamped and noticeably improved the CIO reporting process for DPSG

IT (post CS)

o Includes generating new catalog of metrics for operational

reporting

o Drove monthly report timeliness (+50% improvement in '09 from '08)

. Contributed to Annual Operating Plan and Strategic Planning annual

processes

o Budgeting and forecasting for upcoming year(s) - IT Projects and

BAU

o Utilized SAP system to reconcile actuals versus forecast each month

o Use of project management skills to collaborate with all internal

IT departments and ensure overall IT reporting success daily

. Spearheaded IT Leadership ad hoc projects for operational improvements

o In 2009, created and implemented a new process for the IT

department to track support ticket data with more accuracy and

efficiency i.e. monitoring service SLAs

o Single handedly initiated this change and followed through its

completion and received recognition from CIO and IT VPs

. Liaised between IT leadership, IT departments, and external sourcing

partners

o In 2007, took initiative to assist one of Cadbury's outsourcing

partners collect over $1MM in missing invoices - Vlookup function

used here for efficiency an timeliness of payment

. Assisted with database separation activities from CS IT to DPSG IT in '07-

'08

. Analyzed sourcing data to help make decisions on global partner

utilization

o Created original auto-reports for labor forecasting and other

sourcing decisions (rec'd 1 of only 4 recognition awards for

superior work in 2007)

. Organized monthly financial deliverables such as accruals from IT cost

centers

. Created process to efficiently prepare and report routine cost center

budget variance reports

John M. Rodriguez Jr.

1621 Woodlawn Pkwy ( Mesquite, TX 75149 ( Ph. 214-***-**** ( Email:

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

Examination Supervisor

12/04 - 6/06 Gary W. Lambert & Company

Addison, TX

. Provided multi-jurisdictional sales and use tax auditing services for LA

clients

. Managed a team of 2-4 junior examiners by assessing priorities and

delegating work in the most efficient method based on my team's audit

skill set

o Requested status reports from each JE on a weekly basis to track

performance against client objectives and timelines on audits

o Routinely discussed JE performance against his/her objectives to

ensure diligence and reliability as well as successes and areas for

improvement

o Shared high level status updates to the team on a regular basis and

requested input to initiate team improvement and success

o Researched routinely to maintain knowledge and understanding of

applicable laws, policies and procedures, and shared companywide

. Evaluated budgets, expenses, and fixed assets for Fortune 500 and other

nationwide companies

o Used SAP to perform reconciliations in sales and use tax data

o Includes audits of federal, state, and local tax forms

o Worked 1 on 1 with taxpayer's rep to negotiate on all audit

findings

o Required strong listening, communication, and follow-up skills

. Drafted Excel reports and templates to present findings and updates to

client and GWL management

o Directed team to maintain similar reporting at a lower level

o Includes cost/revenue analysis maintained at high and low levels

. Traveled nationwide up to 50% to taxpayer's corporate locations

Fitness Consultant / Sales

1/03 - 11/04 HEST Fitness Products Frisco,

TX

. Provided the best customer service to help exceed personal sales goals

o Achieved top individual and store monthly sales numbers multiple

times

o Developed effective negotiation skills in selling high-end products

. Brainstormed ideas to management to obtain buy-in and project funds

o Generated new marketing programs to initiate more store revenue

Personal Trainer

08/99 - 11/04 4-0 Studio / Independent Dallas,

TX

. ACE and Nautilus certified, plus CPR/First Aid

. Provided personal training services to upscale clientele in N Dallas,

including:

o Fitness evaluations, personal training sessions, goal setting and

tracking, nutrition advice

. Became independent trainer in 2002 and offered in-home personal training

sessions

o Cross marketed PT sessions with HEST clients (free sessions with

purchase of home gym, etc)

EDUCATION

University of North Texas

B.B.A in Marketing, 2002

Contact this candidate