Anna Mathis Email & Phone Number

United States

Las Vegas, Nevada, US

• In this position, I was to take over ETL Development from a previous third party, document processes that were both hidden and known, and troubleshoot when ETLs failed. Below are my daily responsibilities for this.
• Run ADP reports for Analytics team.
• Update several tables with the newest gaming data from other sources (Teradata, SSMS).
• Analyze, troubleshoot, update, or create new ETLs using the DMExpress (Precisely/Syncsort) ETL Tool or programs within API Server task scheduler. This included opening the jobs, looking at each task, editing the tasks.
• Develop a plan to migrate ETLs from Syncsort to Precisely Server.
• Create a script that would insert missing data from a MicroStrategy report which would allow stakeholders to understand actual amounts sold in specific casinos.

Menlo Park, CA, US

• Evaluated various files of data identifying key components necessary for database design.
• Collaborated with stakeholders to gather understanding of how the data related to itself.
• Created a streamlined database design utilizing LucidChart that will be easily queried by PowerBI or SSRS.
• Designed a data flow that would take key data form Microsoft Dynamics Server/DB to customized database utilizing views that would allow for as-of-date data.
• Involved in vendor meetings and decision process to identify offshore resources for next steps in project and provided knowledge transfer during onboarding.
• Designed a PowerBI report that allowed users to pass certain parameters in order to see Estimated Month to Date Fuel Margins.

Irvine, California, US

• Designed tables, views, functions, spocs and scheduled jobs in various MS SQL databases for the usage of SSRS and Power BI reports and dashboards.
• Developed several SSRS reports and dashboards that involved the quoting, booking and actual totals of materials manufactured for various companies and facilities.
• These reports were designed within the visual studio platform; which meant I was responsible for the deployment of these reports to various servers; as well as, committing and pushing all report changes to the master.
• In some cases, I needed to create new folders in SSRS for the various projects/reports. In this situation, I would, also, need to add security roles to limit access to these reports.
• Worked closely with stakeholders to gain an understanding of their goals for data collection, which provided insight on the design and improvement of reports and dashboards.
• Analyzed and diagramed unknown database to help in the querying of total price and unit price, as there was a discrepancy in these totals.

Henderson, Nevada, US

• Managed a Third Party Administrative (TPA) group who was hired to develop a data warehouse (DWH). This included standups and weekly work session meetings to decide on structure of database, development of specific.
• Coordinated efforts between onsite and offshore teams.
• Proposed and implemented solutions to various data issues discovered during multiple testing sessions.
• Developed and executed project plans; which also included revising these plans due to the changing business needs and requirements from stakeholders.
• Designed various views employing T-SQL that would be utilized by Power BI and Prophix to develop dashboards and reports for various stakeholders.
• Consulted and helped resolve various data issues that developed due to third party software that was implemented into the practice management software.

Las Vegas, NV, US

• At this company I have done the following:
• Wrote customized speaker utilization, budget, programs and billing reports for each product utilizing advanced Microsoft SQL sprocs, PostgreSQL functions and Crystal reporting services.
• Developed a KPI that showcased information on users, programs and speakers.
• Architected an ERD using LucidChart and wrote dynamic sql for ETL using PostgreSQL for a data warehouse that will be used for business intelligence software.
• Utilized Navicat, pgAdmin and PSQL command prompts to copy specified data to a data warehouse from several transactional databases.
• Inserted tickets for bugs and created charts in Jira and Confluence.

Gardena, CA, US

• Worked at the fledgling project for the now-canceled project to put a car manufacturing plant in North Las Vegas. My purpose was to work with the engineers to capture the necessary data points to generate the kind of.
• Designed data flow diagrams that showcased the way data flowed from each system during the automotive manufacturing processes which required the generation of Process Flow Diagrams (PFD) using Visio 2016, creating.
• Led meetings with stakeholders to provide project scope, objectives, gain insight and information to develop necessary deliverables.
• Provided data using MSOffice on average time to turn over a PFD, SIPOC and IFD; which was a prototype meant to be migrated to MSSQL.
• Performed risk management using RAID logs which minimized project risks.
• Successfully added Breadcrumbs to SharePoint 2013 despite no prior knowledge of this process.

• Optimized stored procedures using functions, indexes and views.
• Created SSRS reports for hospitality sector of Soleil Management.
• Identified missing data in data warehouse tables.
• Built email correspondence using merge fields and HTML within SSMS.
• Developed alerts to let specific individuals know about errors in room statuses.

After CHSI downsized they still needed one weekend a month for several years to help provide the KPIs for their business analyst team.Work with billable hour reports combined with customer contracts to generate KPI reports that consisted of charts, graphs, and detailed spreadsheets suitable for giving rolling comparisons of employee performance.Provided.

• Over the course of two years in a small startup I had to wear a lot of hats. It was exciting and I worked with a lot of technologies, below are some of what I did/accomplished while I was there.
• Utilizing Power BI tools to provide consultant billable & developer time spent KPIs to executives.
• Writing Complex SQL queries to generate a variety of insurance-related reports; including, but not limited to, loss runs, broker commission reports, active policy data sheets, and all sorts of schedules & government.
• Develop mostly in Crystal reports, but also a few custom c# and SSRS reports.
• Database configuration per customer for an enterprise-level policy management web application.
• Database cleansing/importing/exporting for a variety of data exchanges with TPAs, customer policies, and data migrations between production and testing environments.

• Developed an equation to accurately find the true cost of commissions, net premiums and written premiums.
• Created Visio Presentation for Kanban Queue Processes

Create instructional materials for mathematic trainingInstruct individuals on mathematics for insurance and programing

Walnut Creek, CA, US

• I work with Microsoft Dynamic CRM 2011 and 2013 for external clients and internal clients.I was trusted to:
• Create customized fields on forms.
• Develop training materials.
• Design and activate workflows.
• Customize and compose dashboards, views and graphs.
• Tailor-make graphs using XML.

Managed Online Advertising.* Corrected Minor Code Issues.* Coordinated with Advertisers.

Lakewood, NJ, US

• 1. SQL Writer and SSRS Designer
• Wrote SQL code to gather specific data from database.
• Designed functions for SQL Database
• Architected data models, databases and tables.
• Sustained, implemented and built reports using SSRS for executive, engineering, and development usage.2. Business Intelligence Designer
• Designed and prepared KPI reports for suppliers, senior directors and executives including analysis and result write ups.

Lakewood, NJ, US

• Certification: Microsoft Certified Professional
• Maintaining control of access rights, security settings and user privileges.
• Instructed and created training materials for CRM system users.
• Developed policy and procedure documents for CRM users.
• Planned workflows from Leads to Opportunities to Procurement to Finished Product.
• Used best practices when creating new fields and/or auto workflow processes using solutions.

Las Vegas, NV, US

Developed a model to predict the odds of having a fatality in a vehicle collision in Las Vegas, NV. Designed a statistical model to predict the odds of where a Las Vegas citizens will go during their day. Coordinator of Math 120 homework for math department. Instructor for Math 120, 95 and 96.

Las Vegas, NV, US

Identified a financial error that saved CHSI a substantial amount.* Conducted a Cost Benefit Analysis on Nurse-Triage Services.* Developed a trend line for the first aid calls to Nurse-TriageServices.* Wrote up several financial documents for CHSI.* Used SQL to collect necessary data for several actuarial projects.* Used Excel to discover trends and other.

Master'S Of Science, Applied Statistics

Bachelor Of Education - Bed And Bachelor Of Science, Mathematics

Bachelor'S Degree, Mathematics

Bachelor Of Applied Science - Basc, Mathematics And Statistics

Bachelor Of Arts (B.A.), Secondary Education And Mathematics