Marketing Manager

Edgar L. Arredondo

**** *. ****** ***., ***. *

Chicago, Illinois 60657

Cell Phone: 773-***-**** E-mail Address: acz9p7@r.postjobfree.com

PROFESSIONAL EXPERIENCE:

J.P. MORGAN CHASE, 10 S. Dearborn St, Floor 7, Chicago, IL – April 2015 to December 2016

Global Commercial Card / PMO Dept. -- Business Analyst / UAT Analyst / Consultant (KForce)

Responsibilities:

Participate in planning of projects as part of PMO Dept. that guided the merger of legacy systems (HP and TSYS) and utilized self-initiative / independent entrepreneurial decision making processes in a fast-paced environment to successfully complete projects and pinpoint / highlight deviations from the overall plan or strategy.

Test applications (internally designed) via ALM (HP Application Lifestyle Management) Tool.

Create strategy and test plans that cover the overall project trajectory and lifecycle (beginning to end).

Create / review test cases for scenarios that cover the testing and implementation of applications.

Identify issues with coding and programming processes and procedures impacting internal applications.

Prioritize projects and resolved timeline issues / glitches concerning the testing of applications.

Utilize Agile and Waterfall methodologies for project management and determining deliverable timelines.

Utilize BluePrint, Jira, MS Project and other project management software / systems to manage projects.

Experience with SQL and MS Access querying and programming / analytic functionality.

ALAN SANCHEZ, CPA, PC, 3418 N. Sheffield Ave., Chicago, IL – November 2012 to April 2015

Database Consultant / Specialist / Coordinator (Lacerte / Intuit Software)

Responsibilities:

Process tax accounting data via tax preparation software program before submission to the IRS.

Highlight and correct discrepancies in data, specifically data veracity and programming errors.

Oversee the smooth and timely input of client tax data to Lacerte / Intuit tax accounting software.

Process marketing mailings / pieces to clients concerning annual tax submissions / new regulations / deadlines.

MERCER HUMAN RESOURCE CONSULTING, 155 N. Wacker Dr. 15th FL, Chicago, IL – Aug. 2004 to Oct. 2012

Global Marketing Administrator / Business Analyst – Europe, Middle East Asia Mercer Markets (2 years)

Assistant Project Coordinator – Market Analyst for Americas M-Drive Team/U.S. Sales Resource Group

(6 years with Stivers Staffing – open-ended contract and subsequently hired by Mercer/MMC permanently).

Responsibilities:

Siebel Oracle CRM - specific module database experience (hands-on execution of specific database tools):

-Marketing and Event Management Modules – creates periodic marketing performance reports, extracts specialized marketing campaign datasets and measures efficacy of marketing efforts.

-Analytics Module – creates finance and marketing strategic planning reports.

-Email Campaign / Vendor Interface Module – creates datasets for uploading to third-party email message houses such as ExactTarget, Marketo and Salesforce .com.

-Data Veracity / Quality Module – provides management tools to ensure data accuracy, and

-Human Resources Interface Module – produces commission compensation reports for internal employees.

Process and supervise changes to in-house data (Siebel Oracle [Mercer M-Drive], Access-based software, internally designed and maintained) and data management systems, and other proprietary databases.

Upload datasets to Siebel Oracle to Marketo and ExactTarget database environments for mailings/campaigns.

Discover and research discrepancies in databases, specifically input, data veracity and programming errors.

Create communications notifying internal users of changes to their accessibility and data in the database.

Alert project managers of problems (“glitches”) with data in the sales/marketing database (via TestDirector).

Perform queries on databases and interface with database programmers to design new queries and filters for data to be performed on in-house databases (total of 62,000 customer accounts/nationwide basis),

Produce strategic planning reports via database reporting tools/functions for management analysis (marketing, sales, finance and human resources departments).

Assist in the QA and UAT of new releases of our in-house CRM and submit corrections/edits to the CRM team.

Monitor/maintain departmental Outlook mailbox and direct in-bound departmental messages/requests.

Edgar L. Arredondo – Resume Page 2:

LA SALLE BANK/ABN AMRO/BANK OF AMERICA, 135 S. LaSalle St., Chicago, IL – Aug. 2003 to Aug. 2004

Assistant Project Manager / Coordinator / Loan Closer–Financial Services and Brokerage / Collateralized Debt Departments (Stivers Staffing Services – 1 year contract).

Responsibilities:

Process changes to brokerage accounts (and closed on active loans) via specifically in-house designed software packages. Also alert software vendors or project manager of problems or “glitches” in database software – front line maintenance. Also, create procedures/guidelines manual for the processing of updates for this position.

Research incidents where account information varied from archived database information via various database software packages: Access, EAI, and other financial accounting software packages and hardcopy archives.

Maintain the flow of information for 400 brokerage offices (via email, Lotus Notes) over a two state area (Illinois and Michigan) concerning all financial consultants, broker reassignments and staffing changes. Also maintain the database with these updates: change in assignment, termination, new hire, salary range, region, etc.

Process “special projects” that related to the maintenance of the financial services main database (with a total of 500,000 customer accounts). Also update accounts at National Financial Services (Fidelity Brokerage Srvs.).

STV INCORPORATED, 200 W. Monroe St., Suite 1650, Chicago, IL – April 2002 to April 2003

Marketing Department Proposal Administrator / Coordinator

Responsibilities:

Research, edit and design production process for marketing proposals in response to Request for Proposals (RFP’s) for architectural, civil, mechanical, electrical engineering projects.

Research information on upcoming RFP project proposals for state/federal government and private sector construction projects such as United States Dept. Transportation, Illinois Dept. of Transportation, Chicago Dept. of Transportation, Chicago Dept. of Aviation, Illinois State Toll Highway Authority, Illinois Capital Development Board, Wisconsin Dept. of Transportation, etc.

Manage the purchase of marketing supplies for the publishing of these RFP proposals.

Maintain and follow-up on contacts with subconsultants in order to fulfill requirements for professional services for the completion of proposed projects.

Assist in creating, maintaining and designing sophisticated spreadsheets and reporting links for managing an 100 employee branch office (to be reported/submitted to main office based in New York City), and

Assist in creating briefing papers and operating reports for the President of STV Incorporated for site visits.

CHICAGO TRIBUNE HOLIDAY FUND and 9/11 DISASTER RELIEF FUND – 435 N. Michigan, Chicago, IL

Aug. 2000 to Nov. 2001, Sept. 1999 to May 2000, Sept. 1998 to Apr. 1999 and Nov. 1997 to April 1998 (Seasonal Contract / Project and Campaign Program Specific / Documentation and Manual Editing Project)

Assistant Gifts Coordinator / Gift Processing Manager (Contractor through ST and LS Staffing Services)

Responsibilities:

Supervise the processing of gifts to the annual Christmas Holiday Fund (over $5,000,000 in donations) and 9/11 Disaster Relief Fund database (over $27,000,000 in donations) with a staff of 24 employees,

Design a procedures manual for the Microsoft Access database and other in-house gift tracking database software programs, address day-to-day problems with the donor (gift) database via immediate troubleshooting and consultation with in-house computer system analysts.

Provide insights and consulting on modifications / corrections to the design of the Holiday Fund and research 24 points necessary to update and improve the processing of gifts to the next annual Holiday Fund campaign, and also utilize Excel, Lotus Notes, Microsoft Word and internet skills to manage / process gifts to this Fund.

Develop and design communications / mailing pieces for specific marketing donor campaigns.

Analyze marketing trends via specialized in-house metrics that are generated via database management tools, and

Translate marketing campaign successes into reports for interpretation by upper management / analysis and suggest new paths to increased marketing responses / increased success rate.

Edgar L. Arredondo – Resume Page 3:

ACCENTURE CONSULTING – 161 N. Clark St., Chicago, IL (previously Andersen Consulting)

World Headquarters Meeting and Event Production Department

Global Markets Meeting and Event Management Area, Chicago, IL – April 1998 to June 1999

Meeting Coordinator/Planner (Contractor through ST Staffing Services)

Events: Process Competency Group Annual Meeting (May 1, 1998),

Gala of the Century (June 20, 1998) and Great America Outing (October 3, 1998)

Responsibilities:

Manage the in-house Access database for the Gala of the Century (1998) and Great America Outing (1998) Events including Octel/Lucent Technologies interfacing issues, scripting of messages and software "glitches",

Assist in the development of timelines and mechanisms to insure adherence to the deadlines delineated in these timelines (Gala of the Century, Great America Outing and Process Competency Meeting),

Create memos, correspondence, and specification sheets for outside vendors and contractors for planned events,

Trouble-shoot issues/problems with registration systems for these events for Accenture employees on all levels (from partner to executive assistant and contractors) in a courteous, professional and stress-free manner,

Assist in the development of marketing pieces and budget spreadsheets for Andersen events, and

Provide on-site support (Navy Pier - 800 attendees, McCormick Place - 5,000 attendees, and Great America - 18,500 attendees) on the day of event's occurrence ranging from physical set-up to production logistics.

FRANCHISING and LICENSING WORLD CENTER (a.k.a., the F.L.W.C.)

Merchandise Mart – Chicago, IL – June 1996 to October 1997

Showroom Operations Manager (Contractor through ST Services)

Responsibilities:

Office and Operations Management:

Supervise maintenance – physical status of showroom (40,000 sq. ft. – largest in Chicago’s Merchandise Mart),

Create appropriate work-orders, supervise maintenance of computer software and hardware, and supervise the installation of new exhibits in the showroom,

Promote new showroom events through the coordination of periodic newspaper articles and press releases,

Screen and route informational telephone inquiries, and

Control visitor flow/security in showroom and assuring compliance with visitor procedures.

Client and Customer Relations:

Maintain professional, diplomatic and cordial relations with clients and

Update status of showroom members daily via ACT software package, fax, e-mail and special mailings.

Marketing / Decision Making:

Rewrite, edit and determine intended target of marketing campaign materials/brochures,

Answer client inquiries regarding franchising and licensing (in English, Spanish and French languages),

Consult with appropriate franchisor, consultant or other franchise information resources (e.g., International Franchise Association, Franchise Times, Inc., Successful Franchising Magazine, Francorp, Franchise Architects, Entrepreneur and Success magazines, etc.), and

Direct prospective franchisee prospective client lead information to franchisor and determine which leads are qualified/verifiable leads.

Business Management:

Update of accounts payable, accounts receivable and issue and track company checking accounts,

Answer concerns from suppliers and service vendors, showroom designers, signage companies, outside consultants, etc. in regards to bill payment and payment procedures, and

Prepare and request check disbursement and payment of miscellaneous outstanding day-to-day items and monitor adherence to or deviance from annual business plan.

Edgar L. Arredondo – Resume Page 4:

FRANCHISING and LICENSING WORLD: Showroom Operations Manager (CONTINUED):

Database Management:

Design input and output specifications for in-house computerized database system tracking every prospective marketing lead (franchisee and franchisor),

Interpret data gathered at the client-facing level at showroom reception area or at initial contact (via telephone, fax or internet),

Generate bi-monthly reports (highlighting the impact of special marketing campaigns, such as Wall Street Journal and Chicago Sun-Times Ads, Ultimate Franchise Show Advertising, radio and television) instrumental in tracking achievement of marketing and business plan, and

Supervise the maintenance of mailing lists (i.e., prospective showroom members, prospective franchisees, franchising industry media contacts, franchising information resources, etc.).

ARCHITECTURAL DRAWINGS and CONSULTING

Chicago, Illinois – June 1993 to May 1996

Business Consultant/Operations Manager

Develop a start-up business strategy and guided its implementation,

Create a marketing campaign targeting potential clients,

Research legal and financial parameters for setting-up a new business,

Follow-up new business/new client leads via telephone, fax and mailed promotional materials, and

Determine the outsourcing of overflow job orders and determine the appropriate turn-around time necessary to complete a project.

RUSH HEALTH PLANS, INC. (a.k.a.: RUSH HMO, now UniCare / Wellpoint Healthcare, Inc. / Anthem BCBS Inc.)

Rush University Medical Center, Chicago, Illinois – March 1991 to June 1993

Assistant Analyst / Medical Administrator – Utilization Management and Professional Affairs Departments

Develop spreadsheet designs/reports, perform statistical analysis on, and maintain / manage collection of patient data vital for tracking trends in performance of patient medical diagnoses and the utilization of HMO programs and services,

Assist in client/patient enrollment and re-enrollment issues,

Create and coordinate medical staff departmental communications via 19 branch offices via newsletter, memorandum, emails and telephone,

Assist in updating and revising Nursing and Physician Manuals for the Professional Affairs Department,

Collect, maintain and prepare daily, monthly and yearly reports highlighting the cost of services rendered by in-house staff,

Monitor, via the use of a state-of-the-art spreadsheet software (Quattro Pro), the utilization of outside vendors versus in-house sources of professional services,

Resolve customer service issues involving claims and professional services effectively and efficiently,

Research special medical topics and projects as requested by the Chief Medical Officer, utilizing the Rush University Medical Library and other university libraries in the Chicago metropolitan area, and

Provide hardware and software in-house computer training for departmental employees.

EDUCATION:

University of Chicago: B.A. Economics, 1988

Grade Point Average: 3.0 out of 4.0 in Economics and Concentration Courses also satisfying Minor Concentration in Spanish and French Languages and Literatures

Academic Awards: Philo A. Otis Award and University Academic Scholarship (3 years)

Blazek Foundation and Illinois State Scholarship (4 years)

Goal: Pursuit of graduate computer/business degree at the Illinois Institute of Technology and/or Exec MBA at University of Chicago or Northwestern Univ.

References: Available Upon Request.

Contact this candidate