SUMMARY:

• Advanced level skills in Tableau, MS Excel & MS Access
• 9+ years of business analysis, reporting, data analysis, and accounting.
• Proven analytical and critical thinking skills.
• Knowledge of PMI standard project management processes.
• Effective project analysis in multi - phase projects using SDLC.
• Successfully manages many different responsibilities simultaneously.
• Superb ability to retrieve, organize and cleanse data to make reporting and analysis more timely and efficient.
• Skilled at gathering and translating requirements into a technical document.
• Recognized for building relationships with key stakeholders and effectively managing the work of consultants and junior team members.
• Seeking Tableau Certification (Qualification)

TECHNICAL SKILLS:

Software: Tableau (Advanced), MS Access (Advanced), MS Excel (Advanced, Business Objects, PeopleSoft PeopleTools, Microstrategy, Retek Data Warehouse, Cognos Impromptu, MS Word, MS PowerPoint, MS Visio

Languages: T-SQL (Intermediate)

PROFESSIONAL EXPERIENCE:

Confidential,Houston, TX

IT Compliance Reporting and Analytics Specialist

Tools: Tableau, MS Excel, MS Access

• Lead the IT Security, Risk and Compliance metrics transformation project from MS Excel to Tableau with the design, development, and production of 30+ interactive dashboards from various data sources.
• Support the Key Risk Indicator program with metrics gathering.
• Serve as subject matter expert for the consolidated data project.
• Design standardized reports.
• Gather requirements for data consolidation initiatives.
• Develop test scripts and/or perform UAT for various projects and document results.
• Interact with offshore support team in regards to database maintenance and enhancement.
• Provide business analyst support for a consolidated reporting project involving merge of 2 data sources into a SQL Server database.
• Manage day to day projects of SME Tableau consultant and junior level intern

Confidential,Houston, TX

Project Coordinator (Consultant)

Tools: Excel, MS Access, LANdesk

• Responsible for managing the rollout of Windows 7 for an assigned region.
• Built MS Access database to assist with the management of the Windows 7 rollout and increase efficiency within the group.
• Ran queries to assist with computer software audits and analyzed compatibility with tested software packages against Windows 7 compatibility.

Confidential,Houston, TX

Business Analyst

Tools: Tableau, MS Excel, Access, SQL Server

• Required to profile and analyze data provided by other departments and update or conceptualize new reports.
• Supported month end reporting for Sales Department with creating and/or updating reports.
• Extensive use of pivot - tables, v-lookups and IF statements in developing monthly reporting packages in MS Excel.
• Developed SQL Server queries in order to respond to requests for data from various users within the company.
• Various financial/accounting reporting duties as assigned.

Confidential,Houston, TX

Data Analyst (Consultant)

Tools: MS Excel, MS Access, VBA

• Responsible for supporting the data migration from a legacy system to SAP.
• Assisted with defining and fine-tuning requirements for upload into SAP.
• Provided feedback to business and IT units in regards to maintaining data integrity across platforms to ensure functionality for end-users.
• Data analysis, cleansing, normalization of data as it relates to the way engineering documents are classified.

Confidential,Fairless Hills, PA

Sr. Data Analyst

Tools: Excel, Access (Oracle ODBC), MS SQL Server 2005

• Served as an internal resource to assist both our reporting and data infrastructure teams in designing, developing and project managing solutions that optimize client requirements.’
• Responsible for delivery of sophisticated analysis products, accurate and appropriate interpretation of data, and developing useful and insightful information from a variety of data sources.
• Maintained and modified over 70 Access databases by client and internal management request.

Confidential,Austin, TX

Business Analyst

Tools: Excel, Access (Oracle ODBC), Business Objects

• Designed queries in Access to retrieve from Oracle and manipulate data sets that exceed 300k rows.
• Responsible for comparing flat files to an Oracle database for state reporting requirements.
• Used multiple formulas and functions in Excel such as Pivot Tables, IF, COUNTIF, SUMIF, CONCATENATE, VLOOKUP, etc.
• Created and analyzed monthly, quarterly, and annual reports and ensures paid claims data has been recorded accurately.
• Identified trends and developments in various segments of business and presents findings to senior management.
• Developed and maintained data capture methodologies as well as provide data analysis to support the information needs of the local health plan.

Confidential,Plano, TX

Metrics Analyst - Supplier Financial Services

Tools: Excel, Access, PowerPoint, (Oracle ODBC), SAP, Oracle AP, Toad, Business Objects

• Responsible for assisting with the creation of appropriate KPIs (key performance indicators).
• Gathered data from various systems and internal groups in order to calculate metrics.
• Manipulated data sets that exceeded 500k rows in Access and then summarized via Excel.
• Managed reporting in Business Objects of data sets that were up to 100k rows.
• Ad hoc financial projects and analysis as requested by upper-level management.
• Provided extensive reporting package for senior-level management and executives which includes complex charts and graphs created in Excel and 90+ pages PowerPoint presentations.
• Business analysis including workflow design, cost analysis and process re-engineering.

Confidential,Plano, TX

Rebate Analyst - Finance and Accounting

Tools: Excel, Access, IMANY/CARS, SAP, Crystal Reports

• Responsible for analyzing and calculating rebates for major restaurant chains via IMANY/CARS.
• Analyzed and summarized large volumes of data from bottlers for chains such as Subway, Burger King and McDonald’s via SAP Business Warehouse; often exceeding 400k rows.
• Ensured that rebates are processed 100% accurately and timely.
• Provided statistical and financial data analysis to senior management by creating complex Excel spreadsheets.
• Performed monthly general ledger analysis and reconciliations.

Confidential,Plano, TX

Statistical Research Analyst - Finance

Tools: Excel, Access, Cognos Impromptu, Peoplesoft PeopleTools, Microstrategy

• Provided a monthly reporting package, which includes budget-vs.-actual expenses, reconciliations, and complex journal entries in an Excel format.
• Monitored capital and major expense items, with budgets exceeding $100MM.
• Database querying using Access and Cognos Impromptu; retrieving and manipulating up to 300k rows of data.
• Designed Excel reports that included pivot tables.
• Ad hoc reporting as requested by management.