TANACIA MENDHEIM

Carrollton, Texas ***** H: 469-***-**** C: 972-***-**** ada4e8@r.postjobfree.com

PROFESSIONAL SUMMARY

Experienced and enthusiastic specialist/Consultant with over 8 years of experience in Analytics, Reporting and Business Intelligence. Excellent reputation for resolving problems, improving customer satisfaction, team training and overall operational improvements. Working hands on with a diverse team. Reporting findings to business including executives to save costs and increase profits. Always learning and implementing new technology and maintaining the company’s strategic business goals.

SKILLS

Business Intelligence: Business Objects,

SSRS, SSAS, SSIS, Yellowfin, SAS, Qlikview, Cognos, Tableau, BMC Remedy, OBIEE, BIDS

Databases: SQL 2008, SQL 2012, MS Access, SQL Management Studio, MS SQL Server,Oracle OraClient 11g

ATS: Taleo/OBIEE, Icims, SAP SuccessFactors, Business Objects, SalesForce, Workday, Yellowfin

Applications: Crystal Reports, Access, Excel, PowerPoint, Macros, Impromptu, Teradata

Languages: Some VB.NET, Visual Basic (VBA), C++, C#

Operating Systems: Windows 2003 - Windows 10

Microsoft Office: PowerPoint, Excel, Access, Visio

Operating Systems: Windows 2003 - Windows 10

Training on: Azure Cosmos DB, Spark, Accenture Cloud Technology, Google Analytics

Team Lead, Team Building, Team Management

PowerPoint, Visio, Agile/Waterfall/DevOps, SDLC

Data Collection, Data Analytics, Quality Assurance

Business Consultant, Intelligence Analysis

TSQL, PLSQL, Query, Tables

SAP SuccessFactors, SAP HCM

Cost Analysis, OBIA

Oracle 11g, OBIEE, Access, SQL

Human Resources, HRIS, RPO, Workforce Management

Automation, Workflow, Research

Excel, Power Query, Power BI, Dashboards

QBR, Graphs, Charts, Presentation

Visual Studio 2005 – 2017, MS Server

SOW, KPI’s SLA’s, Contracts

Crystal Reports, Reporting, Maintenance

Implementations, UAT Testing, Functional Specs, BRDs, SDLC, Technical Documentation

ETL, Data Validation, Data Warehouse

Knowledge of snowflake and kafka

Banking, Financial Analysis, Financial Reporting

Billing, Forecasting, Budgeting, Budget Planning

Problem Solving, Troubleshooting, Fast Paced

Business Intelligence, Big Data, Alteryx

Business Intelligence Tools, Large Data Sets

Reporting Analytics, Business Analytics

Technical Writing, spreadsheets, contracts

EDUCATION

University of North Texas, January 2011 - Current

Senior, Information Technology, 2.25

Tarrant County College, Graduated May 2012

Web and Application Development & Database Programming, 3.345

WORK HISTORY

Alexander Mann Solutions

Principle Business Intelligence Consultant, July 2017 – Current

Serve as SME using different ATS reporting tools and lead analyst

Analyzes procedures, reconciles data and recommends improvements in such areas as data collection, purchasing, budgeting, and monitoring Completing Daily, Weekly and Monthly billing for client’s permanent hires and contractors

Daily use of Oracle developer and OBIEE

Weekly use of SAP SuccessFactors/Using Report Center to build Ad-Hocs and Manipulate already created reports

Running regular weekly and monthly maintenance checks in Excel

Creating formulas, aggregate functions and creating code from scratch in OBIEE/SAP SuccessFactors

Completing Daily, Weekly and Monthly billing for stakeholders’ permanent hires and contractors

Daily use of Taleo, OBIEE and Service Now

Create queries, maintained pre-existing queries/Reports inside OBIEE/SAP SuccessFactors

Gather data for and create client specific Quarterly Business Reviews on a monthly and quarterly basis

Creation of Ad-Hoc/1-Off reports in OBIEE/SAP SuccessFactors

Creation of new reports and charts to publish weekly/monthly based on stakeholders needs

Scheduled and managed daily/weekly/monthly finance/operational reports based on the business requirements.

Knowledge of SOX and GAAP reporting

Cost analysis and financial reviews on monthly and quarterly cost using OBIA

Produce weekly and monthly financial reporting on agency spend and recruitment billing

Present QBR data and Monthly financials to management and executives through PowerPoint and excel reports

Created ad-hoc reports for major stakeholders producing monthly and quarterly financial analysis reports

Build dashboards to track and trend headcount, pipeline and future hires

SLA and KPI Reporting based on client need

Troubleshooting missing data with report

Monitored financial agreements between the business and project teams.

Partnered with project managers to ensure data quality on Issues, Risks, Change Requests and overall health of each project

Provided data metrics to Senior Level Management focusing on key areas of resource management, data quality, and financial earnings.

Cost analysis and financial reviews on monthly and quarterly cost.

Gathering raw QBR data for presentation in PowerPoint deck within formatted excel reports

Creating Excel knowledge, using Taleo and OBIEE exports

Creating reports using excel (Dashboards, Import/Export, Pivot Tables, Vlookups, functions, etc.)

Updated and changed VBA code in saved templates used for daily/weekly reports and trackers

Setting up new report creation for automation in SAP SuccessFactors/OBIEE thru agents and self-service dashboards

Updating technical documentation and reporting steps

Created excel based logs for OBIEE issues and daily task

Assists in prioritization of daily production support / client support work, as well as enhancement and project work with business clients in development of new reporting / data delivery solutions

Performs in-depth analysis needed to support special projects or operational data requests

Ability to schedule report distribution in OBIEE and using macros

Conducts research and analytical studies, preparing reports that include cost analyses, comparative data, and qualitative data to support findings

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built reports and dashboard

Develops and prepares ad hoc reporting and analysis as needed to support projects

Cost analysis and financial reviews on monthly and quarterly cost.

Work with Business Analyst and BI Analyst on a daily basis

Excellent ability to learn new technologies and ability to deepen understanding of existing code

Ability to work on multiple priorities and deadlines simultaneously

Automation of OBIEE and exporting of SuccessFactors, Taleo, Stella and Avature

Updating technical documentation and reporting steps

Vizient (Healthcare, Retail)

Data Reporting Analyst, April 2017 – June 2017

Running regular weekly and monthly maintenance checks in Access and Excel

Troubleshooting and fixing random issues with queries and relationships in Access / SQL

Building Hospital/Product/Cost/Region dashboards for executive team in Tableau

Prioritizing & Time Management

Problem Solving & Analysis

Provides expert level support to delivery of corporate reporting solutions.

Assists in prioritization of daily production support / client support work, as well as enhancement and project work

Works with business clients in development of new reporting / data delivery solutions.

Cleansed and validated data prior to importing into databases

Created and maintained record of company vendors and products

Created and maintained various data tables for project access

Provides data analysis of data as requested by the business for business efficiencies and productivity

Assisting management with auditing and reporting projects

Running daily, weekly and monthly reports for client

Checking and validation of peers’ work product and results

TelVista

CC Reporting Analyst for Statistics, January 2017 – April 2017

Running regular weekly and monthly maintenance checks in Access and Excel

Troubleshooting and fixing random issues with queries and relationships in Access

Completing Daily, Weekly and Monthly billing for clients permanent hires and contractors

Daily use of Oracle developer and SQL Server Management Studio

Create SQL queries, maintained pre-existing queries and daily testing of new queries in both SQL and Oracle developer

Create and maintain reports in oracle, MS SQL, SAP SuccessFactors and crystal reports

Ability to schedule/publish report distribution on SSRS, Yellowfin, SAP SuccessFactors and BO

Acquiring data from primary and secondary data sources & databases/data systems

Creating Excel knowledge, using import and export and SQL ad-hoc reports

Creating reports using excel (Import/Export, Pivot Tables, Vlookups, functions, etc.)

Creating new VBA code for scheduling, formatting and delivering excel reports

Provides expert level support to delivery of corporate reporting solutions.

Assists in prioritization of daily production support / client support work, as well as enhancement and project work.

Works with business clients in development of new reporting / data delivery solutions.

Studies management methods in order to improve the effectiveness and efficiency of workflow and reporting procedures.

Identifies administrative needs and develops appropriate solutions or recommendations.

Conducts research and analytical studies, preparing reports that include cost analyses, comparative data, and qualitative data to support findings.

Building New Reports, Dashboards and Graphs in SAP SuccessFactors and BMS Remedy

Studies methods of improving work measurements or performance standards.

Coordinates collection and preparation of operating reports

Reviews and answers correspondence.

Serve as a subject matter expert and lead analyst.

Analyzes critical historical and real-time operational performance information including contact volume, handle times, team and individual performance, schedule adherence, sales performance, abandon rates, attrition and shrinkage data, and any individual and group KPIs.

Develops and prepares ad hoc reporting and analysis as needed to support projects and initiatives.

Performs in-depth analysis needed to support special projects or operational data requests.

Identifies and implements modifications to Aspect WFM system to allow for effective use of the system.

Organizes and presents ideas in a convincing and compelling manner

Update SOP’s and create technical documents on shared drive

PeopleScout a TrueBlue Company

Virtual Senior Reporting Analyst/ Virtual Reporting Analyst II, February 2014 – November 2016

Running regular weekly and monthly maintenance checks in Access and Excel

Completing Daily, Weekly and Monthly billing for client’s permanent hires and contractors

Daily use of Oracle developer and SQL Server Management Studio

Creating reporting in SAP SuccessFactors (Based on Hires and Requisitions)

Create SQL queries, maintained pre-existing queries and daily testing of new queries in both SQL and Oracle developer

Create and maintain reports in crystal reports, SAP SuccessFactors, oracle and MS SQL

Assisting BI teams with data mapping and ETL processes

Assist with and completed testing to resolve issues in code, reports and transitions to new software

Cleaning/Setting up excel and text files for ETL processes

Building New Reports, Dashboards and Graphs in SAP SuccessFactors and BMS Remedy v9.0

Scheduling reports and maintenance on pre-established reports and schedules in BMS Remedy

Ability to schedule report distribution on SSRS, Yellowfin, SAP SuccessFactors and BO

Implementation, Data Mapping, and Training business to use Yellowfin

1+Years of Yellowfin BI experience, Having good working knowledge in

data extraction and data transfer

Have working knowledge in creating the views and creating the reports

with charts

Have hand on experience on dashboards and have basic idea about in reports

Responsible for creating standard reporting suite using Yellowfin Reporting

Creating stored procedure from pre-established stored procedures and creating new stored procedure in Oracle and SSMS for regularly used reports

Writing T-SQL statements to retrieve data for reports, Ad-Hocs, QBR and executive reporting

Creating queries from pre-existing statements and queries from scratch using WHERE clauses, Joins (inner, outer, right and Cartesian), BETWEEN operators and using conditions to report on specific request from client

Used SSIS package to populate data from excel to database, used lookup, derived column and conditional split to achieve the required data

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS

Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.

Assistance on contracts and SOW for incoming clients.

Partnered with project managers to ensure data quality on Issues, Risks, Change Requests and overall health of each project.

Provided data metrics to Senior Level Management focusing on key areas of resource management, data quality, and financial earnings.

Create and maintain reports in crystal reports, oracle and MS SQL.

Participated in monthly forecasting and budget planning process

Assisted with managing monthly forecasting and budget planning process

Present QBR data and Monthly financials to management and executives through PowerPoint and excel reports

Acquiring data from primary and secondary data sources & databases/data systems

Creating Excel knowledge, using import and export and SQL ad-hoc reports

Creating reports using excel (Import/Export, Pivot Tables, Vlookups, functions, etc.)

Creating new VBA code for scheduling, formatting and delivering excel reports

Write basic to complex queries in SQL and Access to create client specific ad-hoc reports using stored procedures, triggers and joins (inner, outer and Cartesian)

Learn MDX Coding for SSRS

Assist with the conversion of client data from oracle client to yellowfin and/or SSRS

Assist with and complete daily and weekly updates BRD’s

Work with Business Analyst and BI Analyst daily

Create, update and supervision of client specific foundational document for cube creation

Excellent ability to learn new technologies and ability to deepen understanding of existing code

Ability to work on multiple priorities and deadlines simultaneously

Learning, using, and training others on newly installed software

Setting up new report creation for automation in Crystal, BO and Virtually using Schedule task software

Report creation using Crystal reports

Automation of SQL and Crystal reports through BO

Creation and exporting of Taleo, SAP SuccessFactors and Brassring reports

Updating technical documentation and reporting steps

Assisting manager with special time sensitive projects

Running Daily, Weekly and Monthly Reports

Ensuring Data quality and Integrity

Monthly client and account analysis

Learning and tutorials on Tableau

Tutorials using SAS

Capital One

Data Report Analyst, November 2013 - February 2014

Knowledge of SQL code and SQL statements

Running SQL queries using Teradata

Running Daily, Weekly and Monthly Reports by specified time

Working within a fast-paced environment

Creating reports using excel (Import/Export, Pivot Tables, Vlookups, functions, etc.)

Creating Ad-hoc reports with little or no notice

Working closely with business to create and complete report builds based on business need

Prioritizing business and information needs

Ensuring Data quality and integrity

Excellent ability to learn new technologies and ability to deepen understanding of existing code

Ability to work on multiple priorities and deadlines simultaneously

DPSG (Dr Pepper Snapple Group)

Data Research Analyst / Report Analyst, April 2013 - September 2013

Assist with monthly maintenance of ECS data files, research and translations within a custom system.

Recommend, test and implement process improvements to gain efficiencies, eliminate redundancies, reduce expenses and meet business demands.

Process and maintain data that is stored on STARS and NAIS, as well as maintain documentation of all requests/ updates.

Create Ad-Hoc reports using cognos (Version 7 & 8) and impromptu

Created reporting spreadsheets in excel to analyze data received from vendors

Updated macros to run and format reports

Creating excel pivot tables and graphs to showcase data

Using text function, logical functions and statistical functions in excel on a daily basis

Analyzing and updating VBA and macros for report efficiency

Import and Export data from access to excel

Studying about and writing apps for iPhones

Creating Stored Procedures, Triggers and functions in SQL

Proficiency with SQL reporting tool (SSRS)

Update monthly sales/financial reports for regional managers and VP’s.

Ability to work on multiple priorities and deadlines simultaneously.

Identify and streamline more efficient processes/procedures for meeting business goals of the Company.

Create, design, and execute custom databases as needed.

Updating & creating technical procedures and reporting steps

Assist others within a focused team environment.

Assist manager with special projects as needed.

Learning and using SAP and BEx.

ARC Pressure Data, August 2011 – April 2013

Reporting Analyst

Analyzing oil and gas well data for outcome of production.

Creating Excel and ad-hoc reports for major gas companies.

Using some VBA and Macros in Excel to calculate data for placement in graphs and reports.

Building, maintaining and tuning SQL databases for in-house apps and field reps.

Converting Access database to SQL using SQL Server.

Updating and maintaining Access database.

Analyzing and updating VBA and macros for report efficiency

Using text function, logical functions and statistical functions in excel on a daily basis

Import and Export data from access to excel

Studying about and writing apps for iPhones

Creating Stored Procedures, Triggers and functions in SQL

Proficiency with SQL reporting tool (SSRS)

Excellent ability to learn new technologies and ability to deepen understanding of existing code.

Server Support, Laptop Support and Desktop Support

Taking initiative over new projects.

Updating & creating technical procedures and reporting steps.

Burlington Northern Santa Fe (BNSF) May 2011 – August 2011

SAP Business Intelligence Intern

Using SAP GUI.

Assisting with packaging new functional/technical specs.

Assisted with dashboard conversion to Webi and Xcelius.

Testing packages for results and fixing issues with applications during testing.

Assisted with update of BW document in solutions manager.

Running jobs in Redwood, assisting conversion from Redwood to Control M.

Gathering, Maintaining KPI’s for BW team for reporting and updating purposes

Participating in weekly and monthly meeting to report progress

Wells Fargo & Company, October 2004 – August 2009

Operations Specialist

Training and development of 10-15 bankers.

Handled 2nd level customer disputes.

Knowledge of various state and federal banking regulations.

Developed Access reports for banker stats.

Contact this candidate