SUMMARY

• Provide analysis and interpretation of business and financial data to identify opportunities, market performance, and trends.
• Create and maintain MS Excel models using tools such as V - lookups, Pivot tables and Macros as well as MS PowerPoint for report presentations, MS Access to query databases.
• Create Access tables for periodic updates.
• Skilled user of MS Word, MS Excel, MS PowerPoint, MS Dynamics and MS Project.
• Proficient on AP, AR, OE, GL and INV modules in Oracle, Platinum/Epicor, Great Plains and SAP ERP’S.
• Skilled on using Navicat for SQL Server and SQL server Management Studio.
• Write SQL Select queries to extract data for Ad Hoc reporting or to create tables to update for periodic reporting.
• Proficient on Trac project development tracking system (IT ticket tracking system).
• Skilled on specialized medical systems such as RAS (report viewing), IDX/Centricity, Meditech, Kronos and Cleo.
• Trained on teh use of CRM’s such as Salesforce.com, Zoho and MS Dynamics.

CORE COMPETENCIES

• Database Analysis, Segmentation and Reporting
• Budget Analysis, Preparation and Variance Reporting
• Market, Sales Analysis and Reporting
• P&L Analysis and Reporting
• Supply Chain Analysis and Management

PROFESSIONAL EXPERIENCE

Confidential

Master Data Analyst

Responsibilities:

• Provide support to divisions and suppliers by maintaining and/or researching new and existing SKU data (Informatica).
• Utilize teh New Item Registry(NIR) system to create or update product data (web based)
• Create or maintain SAP supplier data for all divisions in SAP; also, work with other SAP based departments on maintaining all supplier information changes.
• Refine weekly item report for vendor specific reporting and distribution.

Confidential - Davie, Florida

Business Data Analyst

Responsibilities:

• Extracted, validated and analyzed hospital 835 type remittance claim denials data to produce overturned performance reports.
• Analyzed company’s contact activity with insurance payers to stablish and report on denial overturn correlation.
• Identified, calculated and reported (Excel Pivot Tables) on total recovery percentages vs. initial claim amounts based on claim types.
• Reviewed, analyzed (Excel) and reported (PowerPoint) on “Denial Overturn Specialist” recovery performance.

Confidential - Sunrise, Florida

ER Quality Data Analyst

Responsibilities:

• Extracted and validated hospital KPI’s from multiple ERP’s (Kronos, Smart, Centricity) to update corporate dashboards.
• Analyzed data delivery procedures for possible process improvement and recommendations to ER managers.
• Submitted data requirement reminders to Hospital ER sites.
• Prepared production ADHOC reports (Excel & PowerPoint) for ER medical chiefs.

Confidential - Fort Lauderdale, Florida

Master Data Analyst

Responsibilities:

• Reviewed “SKU Request” data for accuracy, and if incomplete requested teh additional data to rectify request entries.
• Segmented corrected data in Excel so that it could be re-loaded into miscellaneous internal SAP modules.
• Validated product renewal data loaded into SAP’s OE module through Alchemy to ascertain SKU accuracy.
• Managed ticket queue and provided support to internal customers for data validity review requests.
• Wrote and validated with department managers teh ongoing Master Data process documentation.

Confidential - Pompano Beach, Florida

Business Operations Analyst

Responsibilities:

• Extracted sales and manufacturing data from Oracle through Vision to update production and revenue (Excel) forecasts.
• Researched status, prepared and distributed management’s daily and weekly open order fulfillment schedules.
• Updated teh daily and weekly production backlog by mapping data back from shipping into OE module field names.
• Researched, prepared and distributed miscellaneous production Excel ADHOC management reports.

Confidential - Fort Lauderdale, Florida

Financial Analyst

Responsibilities:

• Extracted (via module exports and SQL select queries from Centricity, Kronos and Meditech systems) analyzed and reported on daily and weekly (KPI’s) hospital usage (Excel) financial model data.
• Performed variance correcting and reporting entries.

Confidential - Boca Raton, Florida

Financial Data Analyst

Responsibilities:

• Reviewed teh Lexis Nexis nationwide court data to identify annuities that may has had remaining cash value.
• Applied annuity NPV calculations for marketing department use by updating teh MS Dynamics CRM during data migration from Salesforce.
• Segmented and consolidated annuity policies NPV data (Excel) for reporting and business partner use (sales and IT).
• Uploaded/imported client’s annuity data into Oracle’s Database from Excel using SQL Developer.

Confidential - Deerfield Beach, Florida

Business Data Analyst

Responsibilities:

• Compiled, segmented and analyzed (Excel) financial and sales data for management reporting and operations planning.
• Assisted teh engineering department with automation projects (SDLC) by accessing and extracting client’s metadata and process it through SQL complex queries in parallel to teh on-development automation routines to verify and stablish data reasonableness or variances.
• Processed raw data through SQL queries to update daily Navicat Dashboards and in order to update forecast models.
• Acted as a liaison in between teh Sales and teh Development Department by assisting with teh review of quality control compliance which included testing teh design specs and functionality by verifying against teh project’s process flow.
• Maintained project’s progress status by reviewing stakeholder progress entries and updated data within teh Trac system.

Confidential - Pompano Beach, Florida

Business Analyst

Responsibilities:

• Executed ongoing finance operations, such as teh preparation (Excel) of pro-forma financial statements.
• Prepared monthly budget variance analysis, revenue and expense analysis and revenue summaries (Excel).
• Prepared revenue and expense forecasts by exporting ERP module data into their corresponding Excel models.
• Analyzed monthly P & L’s (Excel) for variances and audited teh accounting contractor firm for entry accuracy.
• Assisted senior management with teh development of annual budgets by preparing various ADHOC budget Excel models.

Confidential - Coconut Creek, Florida

Sales Analyst

Responsibilities:

• Prepared sales team quota conversion Excel reports used to calculate bonus payments.
• Calculated and prepared sales commission based compensation payroll reports (Excel).
• Performed regional lead origin research, consumer market analysis and tracked competitor’s marketing efforts.
• Prepared weekly, monthly, and quarterly sales reports (trend analysis, forecasts, etc.) for senior management.
• Tracked teh inventory levels to perform a reorder analysis and sales forecast (via inventory module data export into Excel models).

Confidential - Sunrise, Florida

Marketing Manager

Responsibilities:

• Prepared weekly and monthly reports including budget variance analysis, sales analysis, and expense forecasts.
• Analyzed direct mail response and production costs to determine efficiency by creating weekly Access data tables.
• Responsible for teh BRD write-up that lead to teh contracting of teh of teh corporate website, which was used as a virtual inventory display and SKU tracking tool.
• Maintained website’s inventory pricing, descriptions, and search engine optimization via pay per click and organic methods.
• Developed (Access), tested and implemented marketing campaigns (English/Spanish) and managed teh national and international trade show project planning and attendance.

Confidential - Pompano Beach, Florida

Project Manager

Responsibilities:

• Analyzed client’s direct mail campaign response and production costs (Excel) in order to determine return on investment.
• Updated and segmented client’s databases (Access) based on project requirements to maximize their marketing campaign response.
• Developed tested and implemented client’s marketing plans and performed project’s ad-hoc and pro-forma analyses.
• Acted as liaison in between client companies and fulfillment firms ascertaining project specification accuracy.