We provide IT Staff Augmentation Services!

Business Analyst/ Database Developer Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • Experienced Dallas based Business Analyst specializing in complex financial modeling using Excel
  • Data Analytics, Adobe Analytics, Salesforce, SAP, Hadoop, SQL Server, SSIS, APS, Power BI and OLAP Cubes.

PROFESSIONAL EXPERIENCE

Confidential, Seattle, Washington

Business Analyst/ Database Developer

Responsibilities:

  • Set up centralized data repository layer with robust Data Governance for data quality & enablement to address all decision supports needs within DTC.
  • Determine models, measures, and dimensions to rationalize data and support EIT on data modeling with rapid prototyping on APS for immediate business needs.
  • Enable a successful platform for NextGen Business reporting and analytics through data sourcing and mapping to enable an Omniture - Channel flow of data across systems.
  • Develop data integrations and reports using the Microsoft Business Intelligence (BI) toolset (primarily T-SQL and Reporting Services) and vlookup and pivot tables in Excel.
  • Working knowledge of SQL/ODBC connections vs. local tables and how SQL tables are utilized in multiple databases
  • Used access as the Front-end of Microsoft SQL Server to create forms and reports while storing tables and queries on the database server.

Confidential, Dallas, Texas

Finance Analyst

Responsibilities:

  • Worked directly under the CEO and 1st Vice President of 1500 Employee Company completing special projects.
  • Budget Analysis and Budget Forecast Project of 14 for-profit companies and two nonprofit companies.
  • Forecasting/Planning - income statements, balance sheets, and cash flow. Financial reporting/dashboards, to help better understand the business practices.
  • Preparation and analysis of monthly schedules for actual results, budget, and quarterly forecasts as well as providing management with an analysis of P&L and BS variances.
  • Provided senior leadership variance explanations of monthly P&L results versus previous forecast and prior year.
  • Provided analytic support to budget owners by identifying financial opportunities as well as potential budgetary pitfalls.
  • Extract data from a marketing campaign to provide information for better business decisions using SQL.

Confidential, New York

Business Analyst

Responsibilities:

  • Worked directly under the CEO of a Startup Mobile App coordinating and analyzing operational data of active sales agents to develop forecasts, identify trends, and identify potential issues which may arise throughout the day.
  • Reviewed the client's’ goals and objectives against various metrics and trends to make proactive recommendations to the client and generate incremental revenue.
  • Served as a bridge between development staff and clients, taking requirements from clients and converting them into well-defined tasks for our developers.
  • Developed and implemented strategies between uVore and partnering restaurants.
  • Delivering completed tasks to clients and obtaining client approval and acceptance of completed work.

Confidential, Plano, Texas

Deduction Analyst

Responsibilities:

  • Identify, determine cause and resolve all types of deductions in a timely and efficient manner with a clear understanding of the impact to Supply Chain, the balance sheet and the P&L using SAP.
  • Ensure accurate and efficient reconciliation and reporting of all open and resolved deductions.
  • Thorough preparation of deduction packages to support the issuance of a credit memo, collection process or claim processing.
  • Seek opportunities for continued improvements, efficiencies, and best practices. Assist in implementing identified solutions.
  • Generate reports to measure daily performance and align with team metrics.
  • Responsible for meeting month end and quarter end deadlines impacting working capital.
  • Maintain direct contact with the Customer, Sales, Customer Service, Warehousing, and Transportation to achieve validation, address noncompliance, and provide cause analysis of deductions.

We'd love your feedback!