Financial Analysis and Forecasting Manager Resume

SUMMARY:

Strategic, creative, and analytical data science expert with extensive experience in big data management and visualization, database management, and analysis.
Strengths include project management, application of technology innovations, interpersonal communication, business intelligence analysis, and process improvement.

TECHNICAL SKILLS:

Data Science Tools: NoSQL Data Stores (Cassandra, MongoDB) Hadoop My SQL Big Table Map Reduce SAS & R

Databases: Oracle MS SQL Server MS Access Dimensional Data Modeling Star Schema Snowflake Modeling FACT and Dimensions Tables ERWIN Oracle Designer Power Designer

ETL Tools: Cognos Decision Stream Informatica Oracle Warehouse Builder

Programming Skills: Java SQL & PL/SQL C/C++ HTML/XML

Operating Systems: Windows 10/8/7/XP UNIX Linux

BI Tools: IBM Cognos Suite Power Play Transformer Upfront Report Net SQL*Plus

PROFESSIONAL EXPERIENCE:

Confidential

Financial Analysis and Forecasting Manager

Responsibilities:

Oversaw management and improvement of the revenue forecasting model by adding ability to adjust standard RVU and units independently.
Designed Predictive model for Revenue Planning using Logistic Regression, decision tree model and other machine learning techniques.
Collaborated with the financial planning and administration department leaders to produce annual and quarterly forecasting reports.
Led the production of monthly reports for reconciliation along with the accounting department.
Designed and implemented a new accounts payable module to manage the vendor payments, which improved cash flow management, reconciliation, and overall P&L.
Improved the Physician and Employee compensation models.
Designed Statistical Models to change the Payor Mix and Modality trends of past 3, 6 or 12 month trends based on Treatment Plan forecasting and clustering them by Specialty.

Confidential, San Diego

Project Lead

Responsibilities:

Led the improvement of reports for cost accounting, including progress payments, past payments, and project costs.
Analyzed requirements and specifications to develop specifications and initiate project planning.
Conducted cost/benefit analysis using K - means clustering.
Tracked student behavior to identify trends and scope unmet needs.
Recommended changes and improvements to the ETL process.
Performed data mining and data preparation with help of business users to replicate legacy reports for financial analysis and External Reporting.

Confidential

BI Project Manager

Responsibilities:

Managed reporting for customer relationship management including forecasting, pipeline, sales, and demand.
Developed statistical models to forecast inventory and procurement cycles.
Designed active and static reports to better inform pipeline reports to increase accuracy of long-term demand forecasting.
Created an Inquiry Aging Report that improved business lane management and added $2M additional revenue over five years.
Conducted Hypothesis Testing to implement models for Lead generation.
Utilized metadata from databases to develop real-time monitoring reports.
Applied metrics to develop global dashboards to visually track sales.
Designed Time Series Forecasting model to improve customer delivery time by reducing bottlenecks in manufacturing and delivery process.
Created complex statistical and financial reports to improve financial insights.

Confidential

Supply Chain Metrics Analyst

Responsibilities:

Oversaw metrics for the supply chain board including quality metrics, outbound velocity, line level reports, and daily demand forecast reports.
Planned and executed installation and configuration of Cognos 10.
Migrated and verified reports from Cognos 8.4 to Cognos 10.1.
Created several crosstab reports, accounting reports, and multi-query supports to better serve the needs of business decision-makers.

Confidential

Data Management Analyst

Responsibilities:

Managed the development and maintenance of logical and physical ERWin data models and corresponding metadata.
Improved standard reporting and ad-hoc reporting using a multi-layer approach and other modeling best practices.
Implemented internal Cognos security measures to secure sensitive data.

Confidential

Telemedicine Project Lead

Responsibilities:

Led engagement of business users to gather business requirements and design functional and technical requirements.
Resolved ambiguous relationships to ensure clear query paths.
Utilized Cognos software to create the DRM model.
Designed and implemented chart reports, list reports, crosstab reports, master detail reports, drill through reports, and drill down reports.
Led of end users to build and customize their own ad-hoc reports.

Confidential

BI Reporting Project Lead

Responsibilities:

Improved ad-hoc reporting and multi-dimensional reporting through the development of hierarchies and measures.
Utilized Cognos software to develop DMR modeling, enhance and test new models, and create transformer models for packages.
Collaborated to install and configure ReportNet and create content store.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship