Frank Mejia
Email. mejia****@gmail - 925-***-****
Summary:
Experience in Customer Service, Marketing, Finance, Cash Management, Account Management and Product Management. Developed and maintained strong partnerships with cross-functional departments and business units.
Work Experience June 2015- Aug 2022.
IVCi
601 Old Willets Path
Hauppauge, NY 11788
Warehouse: 3401 Investment Blvd, Hayward, CA 94545
Logistics Coordinator.
Receive/Post incoming inventory for various job project.
Prepare/Ship/Deliver- project materials to various jobsites.
Maintain/Record project inventory as being used until completion.
Coordinate with various project manager for delivering/or staging project materials for pick-up.
OfficeTeam - Robert Half International
Pleasanton, CA July 2014 to June 2015
Contract assignment: Way to Be Design- Hayward (July 2014 to June 2015)
Process internet & phone customer orders. Review content and make necessary corrections prior to submitting to warehouse for fulfillment.
Expedite orders as requested.
Provide customer support and resolve ordering and shipping issues.
Contract assignment: Housing Authority of Livermore (June 2014 to July 2014)
Front Office Coordinator-
Manage front office appointments, scheduling and provide customer service to all clients.
Service Response Partners Nov 2013 to March 2014
Contract assignment: Gifts.OpenTable.com
Program Administrator-
Provide customer support to consumers and merchants via email inquiries and incoming telephone calls.
Log inquires resolutions & escalations in Salesforce and Zendesk systems.
Build restaurant website for gift certificate program.
Maintained overall customer satisfaction of 90-100% rating.
YP.com (formerly A.T&T Advertising & Publishing)
Milipitas, CA Oct 2011 to June 2012
Performance Manager
Build Targeted Lead Programs for Advertisers & monitor performance.
Report to sales reps and advertisers’ performance of their targeted programs
Collaborate with reps in determining additional advertisement to add to underperforming programs and implement
Peek…Aren’t You Curious, Inc.
Tracy, CA Jan 2010 to Oct 2011
Manager-Warehouse Operations
Manage and supervise the daily warehouse operations
Maintain inventory controls of incoming and outgoing product shipments using Retail Anywhere (RAE) database network system.
Resolve technical issues in shipments and RAE database management
Verified accuracy of incoming and outgoing product shipments
Prepare shipping orders for Peek’s retail stores and Nordstrom distribution centers to ensure delivery on a timely basis. Expedite rush orders as required
Project staffing needs to meet the shipping and receiving activity
AT&T Advertising and Publishing
San Francisco, CA April 1996 to Dec 2008
Program Manager, IT
Researched and resolved data integrity issues within 24 hours. Established a high level of customer service/satisfaction
Worked with cross-functional teams in evaluating and testing new product data integrity in CSS test environment and release in CSS live system environment
Maintained data accuracy of 61 database tables for Finance, Marketing, Publishing, Billing, and Customer Service business units
Specialty Product Manager
Served as subject matter expert on Specialty Products Limited Inventory websites
Provided monthly analysis of sales revenue, effective discount rate, and unsold products by region
Maintained inventory control of product availability
Aided/training to Field Marketing, Sales, and National Sales teams
Yellow Pages Product Manger
Developed and introduced new or enhanced products to increase revenue and identify cost savings
Analyzed sales revenue, effective discount rate, and cost factors of the 8 stand-alone Yellow Pages Spanish products to identify additional revenue opportunity
Coordinated with cross-functional groups in resolving any issues in implementing cost saving initiatives. Revenue objective was exceeded by 25%, $2 million
Served as Bilingual single-point-of-contact between all business units and client- Seccion Amarilla (Tel-Mex) in analyzing, identifying, and introducing Cross-the-Border Guide in mutually beneficial markets
White Pages Product Manager
Develop and launched two White Page Products, WP Bulls Eye & WP Billboard Ads, to increase revenue
Prepared business case identifying cost factors, sales revenue, and customer penetration
Partnered with cross-functional teams in resolving issues and coordinated implementation strategy. Presented product presentation to the Sales offices
Core Marketing Account Manager
Prepared data extract (via Brio-Query) and performed trend analysis on book revenue, revenue by product, penetration, local incentive dollars, revenue by channel, old business lost and increase by advertiser total spending by market
Liaison between cross-functional departments in monitoring Marketing Merger Initiatives to ensure compliance with merger commitments
Researched and resolved budget variances and tracked merger expense savings initiatives
Manager- Cash Operations
Determined daily cash flow needs for Pacific Telesis Group and its subsidiaries. Invested or borrowed in the short-term markets to meet cash needs. Reconciled bank accounts.
Served as single-point-of-contact between subsidiaries and banks in resolving banking operational issues
Prepared financial analysis of significant cash fluctuation from budget forecast vs. actual. Supervised, trained, developed, and coached cash management staff of 8
Education:
California State University-Fresno
Bachelor of Science Degree-Business Administration Degree,
June 1972
Technical Skills
Salesforce, Zendesk, Word, Excel, PowerPoint, Brio-Query (SQL database), CSS (Amdocs-Common
Suite of Systems). RAE (Retail Anywhere Systems) database management
Foreign Language - Fluent in Spanish