Peter Ivey
*** *** ***** **** ? New Milford, CT *6776 ? 203-***-**** ?
*****.****@*******.***
BUSINESS DATA ANALYST
Database Analysis & Mapping Procedural Logic Customer Segmentation
Big-picture focused, hands-on Data Analyst with four years of experience in
data manipulation and report generation, balancing the tradeoffs of risk,
quality, and cost to support Customer Knowledge Management strategies.
Adept in deploying analytical research to steer the marketing of products
and services, client acquisition, and revenue retention. Experienced in
the analysis and design of business and operational reporting data while
managing the aggregation of data into central repositories for easy
archiving, retrieval, and tracking.
( Penetration Analysis & Customer ( Risk Assessment/Mitigation
Segmentation Strategies
( Ad-Hoc Reporting, Database Analysis ( Statistics/Data Mining/Data
Cleansing
( Qualitative & Quantitative Evaluation ( Client
Acquisition/Satisfaction/Retention
( Data Manipulation & Fact-Based Analysis ( Presentations/Communication
Vermont Information Processing (Dec 2009-Present)
Brookfield, CT
Data Cleansing Specialist
. Analyze business data; design, develop and execute quality data movement
processes to drive consistent, repeatable and scalable solutions for
managing vendor database.
. Write SQL queries, creating all necessary migration programs/scripts,
and prepare step-by-step instructions for performing the migration and
verifying its accuracy.
. Map controls from project-to-project, understand trends in the data and
data anomalies to ensure integrity and quality of information, prepare
reporting and communication summaries for project lifecycle phases.
. Assimilate time-based reporting to document and track issues and change
requests, schedule, milestones, and strategic shifts in project to
remediate variances from pre-determined thresholds.
. Decipher highly complex data; create custom data sets and charts,
documented processes and tools for systematically manipulating and
validating the data.
Panolam Industries (May 2009-Nov
2009) Shelton, CT
Business Analyst
. Led pricing, volume, and rebate analysis to provide "operational
insight" into capital projects, including e-commerce implementation,
structural improvement and software implementation and testing.
. Conducted financial modeling and justification exercises, developed past
financial and operational performance reports, business plan analysis
and feasibility studies.
. Prepared ad-hoc reports and cost benefit analysis; identified business
development and add-on sales opportunities to support executive level
decision making.
. Synthesized data, formulated SWOT analysis detailing competitive
intelligence; performed complete due diligence to ascertain trends,
discrepancies, and areas of exposure.
Peter Ivey
Page
2
AEROTEK(Contracted to General Motors) (Jan 2006-May 2009)
Somers, NY
Regional Brand Analyst (Aug 2008-May 2009)
. Evaluated business processes; gathered requirements from internal
stakeholders to compile and present data for evaluation of sales for
retail, fleet, employee and brand and market share penetration.
. Prepared competitive review deck and market analysis. Broke down data
into actionable driver components through simplified evaluations and
balanced scorecard reporting.
District Sales Manager (Jan 2006-Aug 2008)
. Directed vertical growth strategies, oversaw all phases of sales cycle,
operations/business planning, inventory control, and personnel
management.
. Maximized bottom-line by developing tactical sales goals; evaluated,
negotiated and closed structured transactions. Established clear goals,
metrics and sales forecasts to achieve business targets.
. Ironed back-end operational inefficiencies to drive staggering increases
in productivity, customer service, sales reach and frequency targets.
Bachelor of Science, Justice and Law Administration
Western Connecticut State University, Danbury CT 2005
Southern Connecticut State University, New Haven CT
Bachelors Degree, Undeclared, Fall 1998-Spring 1999
Highly Proficient in Microsoft Excel, Microsoft Windows, Microsoft Word,
Microsoft Power Point,
Microsoft Access, Profit Key, Facts 2.0, Lotus Notes, PeopleSoft,
nVision, GoldMine Administrator
PROFESSIONAL EXPERIENCE
EDUCATION
TECHNICAL EXPERTISE