Customer Service Sales
Resume:
Trang Le
Trang Le
***********@*****.***
Pricing /Data Analyst
Over 15 years of dedicated service as a data analyst for customer service, logistics, and marketing organizations,
with extensive experience in manufacturing forecast and business trend analysis for high-technology companies.
Skills and Strengths
- Well-versed in all aspects of data mining, analysis and reporting
- Experienced in Microsoft Excel advanced features and functions, including PivotTable and VLookup
- Ability to manage project scope, schedule and cost while producing quality deliverables that often exceed
management and customers’ expectations
- Self-motivated problem solver
- Ability to adjust to changing requirements and shifting priorities
-Ability to build relationships based on cooperation and trust
Results
- Implemented and enforced parts catalog strategy for $100M service organization.
- Responsible for global parts pricing in Fortune 500 semiconductor manufacturing company.
- Provided real-time trend analysis of crucial service data for senior management decision making.
- Detected and corrected pre-existing errors in parts catalog, thereby eliminating $10K in yearly losses.
- Corrected parts pricing errors found in Service CAP contract, resulting in $5K average savings per year.
- Provided weekly and monthly bookings and revenue forecasts and trends to Marketing Director.
- Provided Quarterly spare parts inventory to Customer Service Logistics Director.
Functional/Technical Tools
Applications: Microsoft Access, Word, Excel, PowerPoint, Visio Professional, Lotus Notes
Training: SAP, Agile, Clarify, MAPICS, HP-MAP3000, ISO9000
Professional Experience
Transaction Coordinator (Jan 2010-Present)
Elite Real Estate and Insurance Services, San Jose, CA
Responsible for tracking and reporting of all customer transactions.
- Review and ensure that all home sales and insurance transactions are conducted according to company
policies and procedures.
- Create and maintain Microsoft Access database of real estate and insurance customer accounts.
- Track ongoing transactions and upload transaction records and supporting documents to the Company’s
database.
- Create listing and purchase order files for sales transactions.
- Responsible for final filing of all sales transaction records.
Page 1 of 3
Trang Le
- Create marketing and sales fliers, budget forms, and other spreadsheet documents.
Data Analyst (2006-2009)
Credence/LTX, San Jose, CA
Responsible for parts, inventory, and service pricing and real-time trend analysis of customer bookings in $100M
global organization. Interface with multiple departments and management executives, providing revenue forecasts
and business analysis reports used in strategic planning.
- Analyze monthly contract booking and revenue figures and report variances between actual and forecast
amounts to Division Director.
- Conduct monthly inventory of spare parts used in Manufacturing and Service departments.
- Maintain parts inventories and track on-hand versus lead-time items.
- Provide shipment and RMA reports to Division Director and to customers.
- Set up new parts pricing based on BOM to Customer Service division.
- Recommend spare parts pricing adjustments based on analysis of current costs and vendor agreements.
- Design, build, and maintain databases for customer contracts, spare parts catalogs, and field service
surveys using Microsoft Access and Excel.
- Analyze spare parts historical data and provide price quotes upon request, both internal and external.
- Generate monthly parts revenue reports and related trend analysis reports.
- Develop and implement revenue reporting processes by product, region, and customer.
Pricing Analyst (1999-2006)
NPTest (formerly Schlumberger Semiconductor Solutions), San Jose, CA
Set up and maintain contract and spare parts databases. Create pricing and revenue reports for division directors
and submit proposals for parts and services pricing structures.
- Research pricing data and current company policies relevant to individual customers prior to submitting
pricing recommendations for new products.
- Implement and enforce parts catalog strategy.
- Set up and maintain Replacement Parts Pricing List (RPPL) referenced by all departments.
- Analyze and generate CAP contract monthly reports for Customer Service division.
- Respond to customer inquiries and resolve pricing issues logged by Call Center staff.
- Create monthly and quarterly presentations and spreadsheets for Customer Service division.
- Provide product reliability information, parts usage, price quotes, and other reports to customers.
- Prepare monthly and quarterly trends reports for Service Engineering group.
Business Control Analyst II (1989-1999)
RICOH Corporation, San Jose, CA
Establish standard cost structures and global parts pricing based on manufacturing BOM and sales data. Set up
and document processes required for ISO 9002 compliance in multiple departments: Purchasing, Document
Control, and Manufacturing.
- Deliver presentations on manufacturing cost analysis and recommend parts pricing to management.
- Establish product standard cost and pricing for Manufacturing division.
- Gather, verify, and organize data for product pricing, work orders, and inventory reports.
- Build and maintain production, sales, and product standard cost databases.
- Create sales and inventory reports used by production planners in materials purchasing forecasts.
- Verify manufacturing and sales reported figures for inconsistencies or unusual variances that may suggest
inaccurate source data.
Page 2 of 3
Trang Le
- Serve as internal auditor to ensure that established procedures are followed according to ISO 9002
requirements.
Administrative Assistant (1985-1989)
RICOH Corporation, San Jose, CA
Manage administrative and support tasks for all departments within Manufacturing Division.
- Compile and analyze data and create production report spreadsheets for Manufacturing, Operations, and
Sales departments.
- Update databases and generate reports for Manufacturing, Operations, and Sales departments, with zero
tolerance for error.
- Analyze, process and respond to customer sales orders and inquiries in a timely manner.
- Prepare purchase requisitions and maintain purchase order filing system.
- Prepare presentations and charts.
- Handle customer inquiries.
- Make travel arrangements for staff and division executives.
- Schedule and coordinate meetings.
Education
Sam Houston State University, Houston, TX
Bachelor of Science, Industrial Technology (Design and Development major)
Page 3 of 3
Contact this candidate