Mary Larner

Business Intelligence Specialist

LiveView Technologies, Orem, Utah

• Built a RBAC Typescript-based client-side application to provide a highly branded analytic UI experience to our customers that supports self-service automated reporting with benefits of having reusable and shareable dashboards.

• Oversaw, administered, and maintained Fivetran, Looker and Snowflake.

• Migrated crystal reports and excel spreadsheets to Looker.

• Created a Cost and Usage Analysis dashboard that provide comprehensive insights around the team's current tech stack deployment and usage. Highlighting several of the most impactful opportunities for cost saving and performance improvements and resource optimization (Billing Metrics, Performance, Usage Monitoring and Change History).

• Create multiple executive dashboards for visually telling stories of the business status, strength & weakness, potentials for the client, and also enable the end-users to dynamically interact with data as necessary.

• Automated data loading with Snowpipe between AWS S3 bucket and Snowflake database. 

• Architected and implemented data warehouses to support a new business intelligence initiative.

• Analyze and organize raw data material.

• Worked with stakeholders, business users, and customers to collect and document requirements for new reporting and analysis.

• Created data models and ETL processes to load data into the data warehouses.

• Utilized Snowflake's Tasks and Streams capabilities to ingest a stream of data and prepare for analytics.

• Provided support for business users.

• Create and modify dashboards and perform analysis using Looker.

• Intergrated data from several source systems using RestFul API, Lamba and Fivetran

• Define caching policies, design robust models and explores, Maintain and debug code. Perform data validation. Implement and maintain version control through Git in addition, created CI/CD pipeline jobs to validate the code quality being submitted through merge requests, Create persistent and native derived tables, set up a data dictionary for end-business users.

• Using advanced methods to identify opportunities and provide solutions, Tracked key-performance indicators, reported to founders and investors.

• Translate the results of an analysis into easily understood presentation materials.

• Provided data reports and analytics to internal and external clients, analytic support for work process improvements and resources optimization and develop ad hoc and standard reporting for management.

• Helped to resolve a large, critical data error to prevent company liability and consumer impact.

• Collected and analyzed data, provided recommendations from a statistical data analysis perspective.

• Analyzed market trends and the competitive landscape to understand opportunities and potential value.

• Advised optimal data architecture and query design.

• Prepared business cases for IT enhancements, ensuring a fresh approach to improving existing systems and reporting processes. Provided problem management support to capture customer and business requirements and transform them into solutions.

• Train new team members, Refreshers with existing team members and updates on any new releases on BI platform tools.

• Designed the project database diagrams with tables implementation. Centralized data processing and storage among region branches that improved company's management accounting and enhanced business performance. Protect confidential and sensitive information or materials.

• Load and transform large sets of structured and semi structured data. Responsible for managing data coming from different sources.

FusionFeed Operator

Infinite Athlete, San Francisco, California

Seasonal - Weekends Only

• Effectively managed video and communication feeds for National Football League (NFL) & PAC-12.

• Set up 8K cameras.

• Verified functionality of various sources and ensured seamless integration with multiple video ingest servers. 

• Monitored real-time data streams to maintain optimum video and audio quality and swiftly address any issues. 

• Conducted detailed performance analyses and generated comprehensive reports. 

Business Intelligence Developer & SQL Data Reporter

Arivo Acceptance LLC, Sandy, Utah

• Define caching policies, design robust models and explores, Maintain and debug code. Perform data validation. Implement and maintain version control through Git in addition, created CI/CD pipeline jobs to validate the code quality being submitted through merge requests, Create persistent and native derived tables, set up a data dictionary for end-business users.

• Using advanced methods to identify opportunities and provide solutions, Tracked key-performance indicators, reported to founders and investors.

• Translate the results of an analysis into easily understood presentation materials.

• Provided data reports and analytics to internal and external clients, analytic support for work process improvements and resources optimization and develop ad hoc and standard reporting for management.

• Helped to resolve a large, critical data error to prevent company liability and consumer impact.

• Collected and analyzed data, provided recommendations from a statistical data analysis perspective.

• Analyzed market trends and the competitive landscape to understand opportunities and potential value.

• Advised optimal data architecture and query design.

• Prepared business cases for IT enhancements, ensuring a fresh approach to improving existing systems and reporting processes. Provided problem management support to capture customer and business requirements and transform them into solutions.

• Train new team members, Refreshers with existing team members and updates on any new releases on BI platform tools.

• Designed the project database diagrams with tables implementation. Centralized data processing and storage among region branches that improved company's management accounting and enhanced business performance. Protect confidential and sensitive information or materials.

• Load and transform large sets of structured and semi structured data. Responsible for managing data coming from different sources.

Collection Representative

Intermountain Healthcare, West Valley City, Utah

• Make and receives inbound/outbound calls to initiate arrangements for patients to pay unpaid balances.

• Negotiate a payment and/or repayment plan to bring accounts currents explaining disciplinary actions which could result if no payment received while adhering to standard compliance procedures and guidelines.

• Respond to billing inquiries including to following up with insurance transactions, provider auditing, verification of insurance billing and medicaid eligibility and re-coding/reprocessing claims.

• Submit insurance claims, financial assistance applications, legal claims, etc.

• Escalate high complexity billing issues for resolution to a senior associate or supervisor in the appropriate department.

• Meet collection goals with providing exceptional customer service exhibiting good oral and written communication skills.

Collection Representative

Yessio LLC, Taylorsville, Utah

• Perform inbound and outbound calls and emails, Process customer payments and request payments, Verify Banking and Employment Information, Build Rapport, Providing excellent service while achieving quality results

• Assist on demand reporting requests, Ad-Hoc Reporting, Trainee Assistant, QA, Data Entry, Compliance Assistant

• Contact customer and advise the status of the delinquent account through inbound, outbound and emails.

• Negotiate a debt repayment plan to bring accounts currents explaining disciplinary actions which could result if no payment received while adhering to standard compliance procedures and guidelines.

• Monitor/Research delinquent accounts and transactions, Use ChangeGear Help Desk to perform any refunds, corrections, settlements and report any system IT issues.

• Submit bankruptcy claims, fraud reports and follow process with third party debt consolidation companies.

• Help with office/assistant task duties when needed: create manuel outbound dialer using excel, collection data verification, help assist with new trainees currently and refresher training with current employees.

• Awarded for maintaining top quality compliance scores on calls, productivity and perfect attendance.

Call Center Specialist

Contactics, Draper, Utah

• Help applicants seeking a job or pursuing a career in the truck driving industry.

• Assist on completing job applications for qualified applicants.

• Inbound and outbound Domestic Call Center.

Information Technology Sales Specialist

Elite IT Home, Orem, Utah

• Take inbound calls and conduct outbound calls on warm leads using company’s sugarCRM salesforce system to customers who are having computer related issues.

• Conduct QA Computer Analyst.

• Inform and Counsel customers on IT support services to resolve their issues and offer products to help maintain a healthy computer a achieve a successful sale.

Data Engineering for Everyone

Datacamp

View Certificate On Datacamp

Introduction to Data Engineering 

Datacamp

View Certificate On Datacamp

SQL Essential Training

LinkedIn Learning

Advanced SQL for Query Tuning and Performance Optimization

LinkedIn Learning

Business Intelligence

Google

View Certificate On Coursera