Information Technology Sales

Gerardo Maciel

Dacula, GA Cell: 323-***-**** ******.******@*****.***

PROFESSIONAL PROFILE

Accomplished business analyst and business intelligence professional who leverages extensive global network with solid technical acumen to efficiently and expeditiously provide analytics. Highly successful in instituting best practices that improve workflow and reduce the reporting cycle time. A hands-on leader adept in partnering with internal stakeholders to implement best accounting practices and development strategies that save the company money, heighten organizational effectiveness and adhere to compliance.

AREAS OF EXPERTISE

Financial Analyst

Business Intelligence

Forecasting

Change Management

International/Domestic Reporting

Mergers & Acquisitions

Retail/Wholesale

Healthcare

Budgeting

Ad Hoc Reporting

Monthly Closing

Accounting

EDUCATION

Computerized Accounting Los Angeles ORT Technical Institute School of Business, Sherman Oaks, CA

Associate of Science in information Technology ITT Technical Institute School of Business, West Covina, CA

Bachelor of Science in information Technology ITT Technical Institute School of Business, West Covina, CA

PROFESSIONAL EXPERIENCE

Catamaran RXAtlanta, GA (04/08 - 12/16)

Catamaran Corporation is a Schaumburg, Illinois based pharmacy benefit Management Company that sells services related to pharmacy benefit management and medical record keeping to businesses in the United States. Working independently of the government and insurance companies allows it to operate as a third party verifier; the RxCLAIM online claim processing system allows for prescription drug claims to be processed online if the customer lives in and fills his/her prescription in the United States. SXC has three separate but interrelated business segments which deal with prescription drug programs.

Business Analyst

Recruited by the Director of FP&A, I led several initiatives to enhance operating efficiencies. Served as the sole Analyst for process client pharmaceutical reimbursements and provide internal and client reporting for over 250 clients valued at approximately $100 million per quarter. I was also responsible, but not limited to:

Assisting in the preparation of quarter-end close, payable closing schedule, and forecasting

Develop various financial functions

Review Budgets, P & L Balance Sheets

General Management Reports Actual vs. Budget vs. Historical vs. Contract

Special projects and ad hoc reporting

Ensure payables aging accurately reflects balances due to clients and write off balances as needed

Prepare estimates of earned rebates for client contract renewals and annual reviews

Interact closely with other departments to ensure all contract terms are correctly reflected in all models

Validate of source data and interpretation of report results

Constantly update myself and colleagues on auditing processes and apply changes to ensure we adhere to regulatory, compliance and company policy standards

SOX Audit

Mansfield Oil Company, Gainesville GA (10/05 – 03/08)

For 60 years Mansfield has been creatively solving commercial, industrial, and municipal customers’ most demanding energy procurement, supply, and logistics challenges. Today, the company provides energy commodities and related services to 6,000 customers in 18,000 locations across the U.S. and Canada. The company’s expertise covers a broad range of transportation and facilities energy from traditional petroleum products, CNG, renewable fuels, and specialty chemicals to power and natural gas. The company is headquartered in Gainesville, GA with regional operations centers located in Chicago, Dallas, Denver, Houston, Los Angeles, Minneapolis, Bloomington, MN, and Calgary, Alberta Canada.

Retail Analyst

Recruited by the Manager of FP&A, I Responsible for improving processes and profits through internal efficiencies and analysis will also evaluate and manage retail site (RMA) street pricing daily to maximize margin and volume. I was also responsible, but not limited to:

Develop various financial functions. Review Budgets, P & L and Balance Sheets

Identify anomalies and research with Sales/Operation

Work with Sales on Potential Prospect and their needs vs. Ops Capability

Prepare financial analysis for proposed sales

Freight Management - Freight Margin Report

Actual vs. Budget vs. Historical vs. Contract

Assist Acquisition Team Provide financial operational analysis of potential business

CoreStaff, West Covina, CA (10/03 – 10/05)

Corestaff Services is a staffing and recruiting company focused on quality, service and connecting our candidates with the needs of our clients.

Accounting Manager (10/03 – 10/05)

Reconcile Account, posting of cash and credits & Debit memos.

Accounts Receivable, Accounts Payable, General Ledger, General Entries, Closing Entries, Research, Banking Procedures, and Payroll.

Assist in installing software programs such as Microsoft Office 2003 and programming various Macro programs

ADDITIONAL SKILS

Technical Skills:

Operating System

Microsoft Dynamics

Database Microsoft Access,SQL, Data Warehouse, ORACLE

SAP System

Microsoft Excel Advance Skill

Power Point Advance Skill

OLR - RAS - Microstrategy

ADP / Payroll

PaperSave Workflow

Personal Skills:

Management Capability

Positive Attitude toward Employees

Enthusiastic team member

Able to work independently or in a group with minimal supervision

Good follow through skills

Self-motivated individual

Strong work ethic

Capable of teaching all windows program and ability to train any employees at all level

Summary of Skills:

Bilingual (Spanish)

Strong accounting and analytical skills with the ability to analyze financial statements, reconcile balance sheets and interpret legal documents

Excellent verbal, written and interpersonal communications skills and proficiency with Word and Excel

Ability to work independently and as part of a team and artistic in developing innovative ideas

Ability to exceed customer's expectations and strive for excellence in all areas of service

Contact this candidate