Business Analyst

Tico G. Hilliard ** Four Oaks Drive, Powder Springs, GA 30127, 678-***-****, ************@*****.***

Education

University of New Orleans, New Orleans, LA, Curriculum in Computer Science

Kennesaw State University, Kennesaw, GA, Curriculum in Information Technology

Work History

OpenText, Exclusive Coca-Cola Account • June 2018 – October 2019, Business Analyst II

11720 Amber Park Drive, Alpharetta, GA 30009 • Supervisor: Fredrick Rowell • 404-***-****

Coca-Cola, Customer Business Solutions, E-Business • August 2007 – June 2018, Business Analyst II

One Coca-Cola Plaza, Atlanta, GA 30313 • Supervisor: Joy Gayle Reider • 404-***-****

EDI Specific Responsibilities for all data - Provides 24/7 on-call support • Acts as liaison between EDI clients and Coca-Cola business partners • Track the receipt, translation and transmission of data files • Creates documentation of non-standard processes • Gather technical specifications for analysis before implementation • Ensure data integrity • Implements translation and transmission processes for EDI, XML, and csv data to accommodate changes and new requests • Responsible for training co-workers on all office duties

Project Specific Responsibilities

WebMethods Migration Project - Planned testing procedures for all emailed data being migrated from Enterprise to web Methods • Scheduled and monitored testing by developers on the project team

AI Migration Project - Test all E-Business service center processes to ensure that there are no errors in the system once migration to a newer version of Application Integrator is complete

Continuous Education - Manage the schedule and facilitate training classes to ensure service center analysts are up to date on current changes and processes implemented by E-Business

Programming Challenges

Develop and test technical solutions resulting in the correction of business inefficiencies

Coca-Cola Customer Business Solutions, Sales Support • April 2003 – August 2007, Sales Reporting Volume Analyst

One Coca-Cola Plaza, Atlanta, GA 30313 • Supervisor: Jay Caplan • 404-***-****

Sales Reporting Responsibilities – Reconcile sales variances, including the assurance of accuracy of the data and categorizing data according to provided specifications • Ensure data is reported according to Coca-Cola contract and confidentiality requirements • Summarize sales and geographical data using advanced MS Excel and MS Access features such as pivot tables, vlookups, goal seek, nested if statements, grouping, truncate, concatenate, text to columns, calculated fields, and subtotals • Customer accounts include Sysco, Walmart, Target, Compass, Dollar General and Subway

Customized Multi-user Database Responsibilities – Use Access, Visual Basic for Applications and SQL to develop, maintain and train staff in the use of four customized relational databases (including tables, queries, forms, reports, macros and modules) to use as follows: (1) tracks and calculates total hours spent to generate report by employee and/or category (2) records a user friendly view of report specifications customer, employee and/or time period (3) calculates funding payments by vendor and/or store location

The development of these databases saves 1,000 hours per month of manual data collection, manipulation and verification

Tico G. Hilliard

Training Responsibilities – Train team members in the following areas: (1) building efficient, space saving databases (2) generating reports and manipulating data with queries (3) issues encountered when building large multi-user and single-user databases (4) advanced Excel functions/features including, but not limited to, pivot tables, vlookups, dlookups, goal seek, nested if statements, grouping, truncate, concatenate, text to columns, calculated fields, subtotals and various database functions

Coca-Cola Enterprises, Inc. • March 2001 – April 2003, Sales Analyst/Executive Secretary

One Coca-Cola Plaza, Atlanta, GA 30313 • Supervisor: David W. Houston/Jean Terminiello • 404-***-****

Sales Analyst Responsibilities – supported 1 VP, 1 Director, 1 Product Support Manager and 11 NAEs

Reconciled sales and location discrepancies among Coca-Cola locations • Requested tradename and key account implementation to facilitate sales reporting and marketing payments • Provided pricing analysis used in the negotiations of new and renewed contracts and to ensure contract compliance • Work closely with account managers regarding customer issues such as sales, pricing and service • Served as the link between Coca-Cola corporate and franchisee entities to validate location issues that result in sales discrepancies • Maintained national and regional contract pricing reports and communicate pricing updates to the Executive Steering Committee members and various management departments • Created monthly reports and presentation relating to net sales income and gross profit performance • Created ad hoc sales reports, equipment reports and presentations as required • Review IRR Models submitted by account executives before distribution to determine final approval

Executive Secretary Responsibilities – supported 1 VP, 1 Director, 1 Product Support Manager and 11 NAEs)

Provided monthly operating expense report summaries and track spending vs budget • Coordinated the on-site details (audio visual needs, catering, meeting room set-up) for monthly team meetings • Trained administrative staff • Performed general office duties (phone, filing, correspondence, expense reports, appointments, travel, etc.)

Software Knowledge

Word Processors - Microsoft Word • Spreadsheets - Microsoft Excel (proficient in the use of charts, pivot tables and various advanced formulas), • Databases - MS Access (proficient in data importing, manipulation, queries, reports, mapping and macros), Dbase, Paradox • Programming Languages - SQL, PL/SQL, Visual Basic for Applications, ADA, Java, JavaScript, HTML, PHP • Presentation - Microsoft Powerpoint • Other – Smart ftp, Reflection, UNIX, UltraEdit, TextPad

Summary

Strong analytical and organizational skills • Talent for learning new software with ease • Ability to work well with all levels of an organization • Effectively communicate ideas verbally and in writing • Work well under pressure and various time constraints • Willing to take on new assignments • Flexible in meeting change

References

Available upon request

Contact this candidate