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.