Anna Mathis Email and Phone Number
United States
Anna Mathis's Location
Henderson, Nevada, United States, United States
Anna Mathis's Contact Details
Anna Mathis work email
- Valid
- Valid
Anna Mathis personal email
n/a
Anna Mathis phone numbers
About Anna Mathis
• Over 10 years of progressive experience with strengths in statistical reporting/data mining to improve business processes and performance in diverse industries including gaming, pharmaceuticals, and insurance.• Create intricate financial reports for sales analysis highlighting cost bottlenecks and profit limiters• Develop a wide variety of reports using SSRS/SAP/CRM Dynamics by querying data utilizing SQL Server, Access, XML and other database sources.• Coached and created user guides for colleagues on SSRS, SAP and CRM Dynamics.• Lifelong learner; continuously improves technical and leadership abilities.AREAS OF EXPERTISE:− KPI reports − SQL query developing/optimization/repair− Project management − Insurance and claims reports− Statistical modeling − Data mining/imports/exports− Agile/Waterfall project methodology − Customized graphical data and workflow displayTECHNICAL SKILLS: Software/Cloud Services:• 7+ years: Microsoft SQL Server 2008/2012/2014/2017, Microsoft Visual Studio 2010/2012/2013, Microsoft Office Suite 2007/2010/2013/2016, SAP-Crystal Reports 2008/2013, SSRS reporting, Adobe Products • 3 years: Microsoft Dynamics CRM 2011/2013• 2 years: PostgreSQL, pgAdmin, Navicat, AWS, Azure• 1 year: Microsoft Dynamics CRM 2015, Oracle 12c• > 1 year: MongoDB, Confluence, Jira, BitBucketStatistical software:• 7+ years: Visio Professional 2010/2013/2016• 4+ years: R-GUI, Power BI, LucidChart• 1 year: Minitab, SAS, SPSS, • > 1 year in SlamData and Metabase (used with MongoDB NoSQL)Certifications:• Microsoft Certified Technology Specialist – Azure, 2015 • Microsoft Certified Professional – CRM, 2013 Eye Care Databases:• NextGen• Centricity• Amkai• MDO• ModMedI pride myself on the quality of my work, with quality in this context referring to how I do my work, how quickly my work can be executed, and how close I was able to achieve the goals requested of me.
Anna Mathis Work Experience Details
-
Clark County School DistrictUnited States -
Senior Database DeveloperSilverton Casino Lodge Nov 2023 - PresentLas Vegas, Nevada, UsIn 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 position:• 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 and/or creating new tasks where necessary (.BAT, .dxt, .log, custom, .py, etc.).• 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.• Document processes and procedures that would allow other members of the team to do various jobs – Badge Running, KPI Updates, TTM Report, adding new departments and table games to MicroStrategy reports.• Delve into various databases to troubleshoot the SyncSort ETL and scheduled task jobs, these databases were within the following Servers: AS/400, BravoDB, Teradata, Oasis, PSQL and SQL Server. • Manipulate MicroStrategy Report attributes to allow for specialized departments, locations, and new table games to appear in reports.• Edit Python programs within the task scheduler that were providing the incorrect dates. -
Database ArchitectRobert Half Jun 2023 - Mar 2024Menlo 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. -
Business Intelligence EngineerSummit Interconnect Dec 2022 - Jun 2023Irvine, 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 server. • 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.• Created scheduled jobs that automated data being pushed to new data warehouse tables. • Adjusted security roles in MS SQL servers to allow for deployment of SSRS and Power BI reports. -
Dwh Manager/ Enterprise Database SpecialistComprehensive Eyecare Partners Sep 2019 - Sep 2022Henderson, 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 tables and views, constructing an ERD of the DWH, identifying possible areas of improvements in their ETL process, recognizing obstacles, planning for new projects, and negotiating time frames and costs. • 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.• Met with administration and vendors of the various practice management softwares to learn data requirements and required business logic for proper development of ETLS and reports.• Established a workflow process that would move new logic between the Development, QA and Production data warehouse AWS servers. • Provided a Gap Analysis on what the DWH originally was spec’ed out to be verses what was developed and identified what needed to still be created.• Provided technical guidance and assistance on daily operational activities related to DWH functionality.• Hiring of new staff to help with the testing process. -
Lead Database EngineerPharmagin Aug 2017 - Nov 2019Las Vegas, Nv, UsAt 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.• Created a depository for code used for the development of the data warehouse and reports in BitBucket.• Developed concepts for business development opportunities. -
Lead Database Developer/Project ManagerFaraday Future Apr 2017 - Jul 2017Gardena, Ca, UsWorked 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 KPIs that would enable optimizing the manufacturing process. What I was doing• 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 SIPOCs based on those PFD’s that were constructed using Excel 2016, and developed Swim Lane Information Flow Diagrams (IFD) based on each of the SIPOCs that were created using Visio 2016.• 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. -
T-Sql DeveloperSoleil Management Aug 2016 - Feb 2017• 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.
-
Business Intelligence ConsultantChsi Technologies Jan 2016 - Feb 2017After 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 this monthly for several years after leaving CHSI to assist in improving billable hours by the team.
-
Lead Database DeveloperChsi Technologies Apr 2014 - Jan 2016Over 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 forms.• 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.• Create and troubleshoot SSIS packages for automated data transformation, importing, or exporting.• Write Powershell solutions for Azure manipulation, database configuration, or windows administration.• Write C# solutions for scheduled data imports which properly update or insert as needed to avoid creating duplicates while properly handling cascading child relationships.• Write C# solutions to configure Azure blobs and containers as needed for a dynamic and growing number of customers.Note: I can develop C# solutions as needed, but the majority of my experience is in SQL/data solutions and I prefer positions where the majority of my work is working with data as opposed to C#. However, when necessary I can implement C# or work with developers on C# or other language projects.
-
Mathematician/ConsultantChsi Technologies May 2011 - Apr 2014• Developed an equation to accurately find the true cost of commissions, net premiums and written premiums.• Created Visio Presentation for Kanban Queue Processes
-
TrainerChsi Technologies Jul 2013 - Jan 2014Create instructional materials for mathematic trainingInstruct individuals on mathematics for insurance and programing
-
Microsoft Dynamics Crm DeveloperWebfortis, Llc Nov 2013 - Feb 2014Walnut Creek, Ca, UsI 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.• Support/troubleshoot issues. -
DesignerWebcomics Unlimited, Llc Aug 2008 - Feb 2014Managed Online Advertising.* Corrected Minor Code Issues.* Coordinated with Advertisers.
-
Business Intelligence AnalystGaming Laboratories International Jan 2012 - Nov 2013Lakewood, Nj, Us1. 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.• Programmed website that provided easier access to the SQL Reporting System.• Developed KPI pivot charts using Visio 2010 for upper management dashboards.• Constructed trend, success and fault rate reports by fiscal years and quarters.• Identified, investigated flaws in systems and reported these to IT.3. Project Manager• Managed meetings between engineers, quality assurance, development and IT to help focus on key concerns, find solutions and increase productivity.• Assisted IT, engineering and quality assurance in developing better tools for management reporting. • Participated in the planning of accurate data collection and maintaining data integrity.• Helped analyze and assess major business decisions by providing essential available facts and statistics. • Received and processed inquiries from internal customers including speaking with individuals, coordinating follow-up action, documenting requests and responses. -
Crm AdministratorGaming Laboratories International Jan 2012 - Nov 2013Lakewood, 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. • Customize dashboards, reports and views specific to job functions. • Verified data across Accounts, Contacts, Opportunities, etc. • Identified and communicated errors made by users to users and provide assistance in correction process. • Enforcing system user adoption of policies and procedures by monitoring audit history.
-
InstructorUnlv Aug 2008 - Dec 2011Las Vegas, Nv, UsDeveloped 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. -
Statistical Security Analyst (Consultant)Chsi May 2011 - Jul 2011Las Vegas, Nv, UsIdentified 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 statistical analysis.
Anna Mathis Skills
Databases
Ssrs
Visio
Sql
Microsoft Sql Server
Data Mining
Business Intelligence
Microsoft Excel
Data Analysis
Microsoft Office
Sas
Access
Visual Studio
Logical Thinker
Statistical Data Analysis
Minitab
Software Documentation
Statistics
Training
Project Management
.net
Crystal Reports
Html
Spss
Crm Dynamics 2011
Analysis
Microsoft Dynamics Crm 2013
T Sql
Microsoft Access
Sql Server Reporting Services
R Gui
Microsoft Visual Studio 2005
Sql 2005 And 2008
Minitab 16
Visio Professional 2010
Statistical Modeling
Data Modeling
Mysql
Workers Compensation
Workers' Compensation Claims
Property And Casualty Insurance
Casino Gaming
Mongodb
Sql Server Management Studio
Lucidchart
Slam
Jira
Confluence
Anna Mathis Education Details
-
University Of Nevada-Las VegasApplied Statistics -
Concordia University-WisconsinMathematics
-
Concordia University-WisconsinMathematics
-
Concordia University-WisconsinMathematics And Statistics
-
Concordia University-WisconsinSecondary Education And Mathematics
Frequently Asked Questions about Anna Mathis
What company does Anna Mathis work for?
Anna Mathis works for Clark County School District
What is Anna Mathis's role at the current company?
Anna Mathis's current role is Database Engineer and Business Intelligence Analyst.
What is Anna Mathis's email address?
Anna Mathis's email address is am****@****are.com
What is Anna Mathis's direct phone number?
Anna Mathis's direct phone number is +170296*****
What schools did Anna Mathis attend?
Anna Mathis attended University Of Nevada-Las Vegas, Concordia University-Wisconsin, Concordia University-Wisconsin, Concordia University-Wisconsin, Concordia University-Wisconsin.
What are some of Anna Mathis's interests?
Anna Mathis has interest in Children, Environment, Education, Science And Technology, Animal Welfare, Arts And Culture, Health.
What skills is Anna Mathis known for?
Anna Mathis has skills like Databases, Ssrs, Visio, Sql, Microsoft Sql Server, Data Mining, Business Intelligence, Microsoft Excel, Data Analysis, Microsoft Office, Sas, Access.
Who are Anna Mathis's colleagues?
Anna Mathis's colleagues are Michelle Langham, Jennifer Clay, Jason Bidwell, John J Villarreal, Lion Zion, Anedra T. Bowens, M.a., M.ed., Rachel Sahagun.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial