SUMMARY:

Tableau Desktop, Tableau Server Admin

TECHNICAL SKILLS:

ERP: SAP BI/BW - BEx Analyzer, SAP FI/CO, SAP Budgeting / Plan / Actual

Programming Languages: Macros/VBA, VB 6.0, VB Scripting

Database Languages: SQL / T-SQL

Web Languages: HTML / CSS, VBScript / XML

PROFESSIONAL WORK EXPERIENCE:

Financial Systems Analyst

Confidential, Dearborn, MI

Responsibilities:

• Maintain /enhance of Finance database systems (Oracle, GRIMM & CAPE, Local MS Access & MS Excel ) and evaluating new external computer systems as required. (Tableau Desktop, Tableau Server) as possible replacement for reporting.
• Taking Initiative acting as Lead Tableau Architect for product evaluation and pricing among our operations.

Confidential

Work Program Analyst

Responsibilities:

• My role initial point of contact with stakeholders & end clients.
• We gathered the requirements, specs and used RAD tools (MS Access and MS Excel) to prototype a solution.
• Eventually the solution would go into BI/BW Confidential 4.0.
• Developing new reports and modifying existing reports to meet the needs of various customers within the Operations Line of Business.
• The main focus of these reports is to provide assistance in their business decision.
• Balanced Scorecard (BSC) Operations Dashboard - aggregate monthly performance metrics among various financial and non-financial measures for the Chief Operating Officer
• Performance Reporting Tools - Integrate Excel BI Dashboards / charts from large data sources: SAP & MS Access

Confidential

IT / Data Support

Responsibilities:

• Maintained font-end Access & back-end SQL Server Record Artist Database while Manager on vacation.
• Processed weekly extracts & reports for direct deposit for artist payments and various partners.
• Provided help desk support.

Confidential

Financial Reporting Analyst

Responsibilities:

• Analyzing trends in revenues and expenses.
• Preparing spreadsheets, graphs, and charts to help illustrate financial trends.
• Presenting financial information to managers.
• Performing revenue and expense forecasts in order to make financial decisions.
• Produce monthly variance analysis. Monitor, report, and quantify performance metrics and corresponding financial implications for operations management
• Account Mapping and reconciliation.
• Utilized SQL, macros and modified VBA modules.
• Manage 200 cost center Excel VBA budget packages.
• Manage Revenue and Expenses Financials - Confidential Actuals, Forecasts, compensation, staffing hour allocations and vacation entitlements.
• Consolidate budget submissions into standard analytical reports.
• Gather reporting requirements from Sr. Finance Manager.
• Create mock- up reports for review.
• Extract data from multiple data sources (ODBC).
• Prepare time estimates for all reports developed.
• Develop reports in pre-production environment, promote through test, and then to production.
• Migrate legacy Access reports to Crystal for all Dept. Mgrs across hospital to view on intranet.
• Builds mutually cooperative relationships by treating others with equal dignity and respect.
• Works cooperatively with others to foster a culture of inter-professional collaboration; being a solid team player, delivering on share of the work, and contributing other team members’ goals/work.

Confidential

Business / Financial Analyst

Responsibilities:

• Plan, research, write, and deliver training materials and technical reference information weekly.
• Course material include: Excel VBA Modeling, Data Analysis using Access SQL, Aggregation.

Confidential

VBA Developer

Responsibilities:

• Developed Access client Deficiency DB to track accounts not completed.
• Create customized queuing pages that show status of pending issues and necessary actions required.
• Modified Excel VBA Forms to specifications.

Confidential

Technical Business Analyst

Responsibilities:

• Involved extensively in every aspect of a database application development from requirements gathering/analysis to reporting for the desktop application.
• Responsibilities required interaction with both Business analyst, and stakeholders to ensure regulatory needs were addressed and project timelines and responsibilities were met.
• Using VBA with advanced data manipulation and user control. Can create tables, queries, forms and reports, and connect them together with macros.
• Maintain a collection of each store budgets and reporting on project financials.
• Prepare summary reports for management, based on the analysis
• Creating new medium- to high-complexity reports according to specifications
• In corporate data aggregation, analytics by filtering criteria specified by the end-user.
• Drilling down report, having user selections, on the report affect other reports
• Flags projects and milestones off-track with status indicators.

Confidential

Jr. Business Analyst / Access Developer

Responsibilities:

• Database Design and Implementation
• Modeling (MS Visio) & Design, Implementation, Testing, Maintenance and Documentation manual.
• Tools required included: Access, Excel, and Visio (for drawing E-R diagrams).
• ADO connectivity development to Microsoft Jet/Access databases and fluent with SQL.

Confidential

Access Developer / Reporting Analyst

Responsibilities:

• Develop a fully functional Access database system from scratch for staff use.
• Automating Access to Excel data transfers auto-populating Excel Templates.
• Met all deadlines when Reports needed by various funders and partners.
• Advanced Statistical Data Analysis Reporting
• Analyzing large data sets for reporting.
• Leveraging VBA to enhance Data Analysis i.e. reporting results using Automation
• Running Descriptive Statistics i.e. % breakdown of success rate in a particular trade.