We provide IT Staff Augmentation Services!

It Compliance Reporting And Analytics Specialist Resume

Houston, TX

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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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.

Hire Now