AUDIT DATA ANALYTICS AND MANAGEMENT REPORTING ASSOCIATE / ASSISTANT VICE PRESIDENT Resume NEW YORK, NY - Hire IT People

SUMMARY:

To obtain a junior Business Analyst position with emphasis on business intelligence perspective and utilize my skills in reviewing business operations and recommend automated solutions that expedite goals fulfillment.
A self - driven innovative Business Analyst with 14-years’ experience in data analysis, database management, financial statement development, and operational reporting business process improvements (BPIs).
Analytical professional skilled in managing functional projects according to waterfall methodology through extensive research.
Data Analysis & Dashboard Design Business Analysis Applications/ Workflow Process Improvement (BPI)
A multi-entity or global analyst who developed data gathering, requirements analysis, and presentations across a spectrum of stakeholders, priority and risk lists, modeling, acceptance criteria, business planning, metrics, processes, and indexing data. Self-initiated learning of BABOK® knowledge areas culminating to recent 7-year work.

HIGHLIGHTS OF RELATED SOFT SKILLS:

Problem Solving Systems Thinking Time management Technology Learning Teamwork

TECHNICAL PROFICIENCIES:

Expert: Microsoft Office Professional

Intermediate: SQL, Ribbon XML, MS SharePoint, PowerQuery, PowerPivot, IBM Cognos Reporting & Query Builder

Novice: MS Visio, MS Project, JIRA, SAP Crystal Reports, Tableau, Alteryx, BIQ, R

WORK HISTORY:

Confidential, NEW YORK, NY

AUDIT DATA ANALYTICS AND MANAGEMENT REPORTING ASSOCIATE / ASSISTANT VICE PRESIDENT

Responsibilities:

Oversaw solution design project to correct and validate corrupt data collected from various audit ERP systems, containing 28% incorrect data in Access database.
Proposed an Excel modification template to key stakeholders and automated dashboard with a new arrangement.
Employed Agile methodologies into developing key performance indicators (KPIs).
Facilitated development of DataMart plan by providing advanced SQL Server queries, data models and BRDs.
Increased dashboard efficiency 83% by programming existing prototype with PowerQuery and Excel VBA.
Skillfully employed PowerQuery, Excel, and VBA to reduce duplication 50% by automating four diverse transfer pricing sources in the design of 4 monthly expense reports with 14 data entry checks.
Reduced delays 87% by designing efficient model for audit operations hierarchy change in weekly dashboard.

Confidential, NEW YORK, NY

REPORTS DEVELOPER

Responsibilities:

Made recommendations to increase system effectiveness, including system updates using the vertical information to eliminate excess queries and columns.
Upgraded more than 22 databases to Access 2010, developed new queries, implemented quality control measures, and created new database reports.
Implemented quality control measures and designed SAP Crystal reports with cross-tab objects.

Confidential, STAMFORD, CT

DECISION SUPPORT ANALYST

Responsibilities:

Assisted internal production analysis teams and external IBM Cognos developers during firm-wide single eCW data source implementation.
Effectively directed system onboarding value stream mapping across seven dimensions to add more than 70 network physicians to the group.
Using Excel/SSAS OLAP cube measures, reported downstream revenue for external physicians and analyzed physician referral mobility and profitability.
Delivered more than 22 BPI measures for budgeting, accounts receivable, and productivity to senior management.
Designed Excel and Tableau desktop dashboards to analyze and graph data for critical dashboards for 175 multi-specialty physicians with six KPI source inputs and five external benchmarking and research groups.
Produced Cognos and SQL Server business intelligence reports, business requirement documents, logarithm code samples.

SENIOR FINANCIAL ANALYST

Confidential

Responsibilities:

Increased productivity 81% while maintaining annual budget submission tracker Excel metrics.
Improved data efficiency 35% and reduced over-allocated net costs to revenue negative ratios 45% for P&L statement. Introduced activity-based allocation method to 40% of non-revenue cost centers in revised Access data model.

VOLUNTEER

Confidential

Responsibilities:

Improved quality of financial data flows by designing financial analysis SQL server reports.
Confirmed document accuracy by communicating directly with vendor management and automated vendor data collection for the general ledger annual report in Access VBA.
Analyzed P&L statement to measure profitability ratios and reported analysis to senior management.
Reduced accrued expenses 50%+ in preparation for year-end financial audits of Accounts Payable.
Automated P&L spreadsheet to list amounts according to diagnosis, procedure, payor subcategory, number of patient visits, and accounting categories. Organized patient visit expenses and revenues across five hospital service lines.