Marcus Ko Email & Phone Number

Salt Lake City, Ut, Us

Plano, Texas, Us

Sandy, Utah, Us

• Developed reporting for newly created healthcare provider recruiting and onboarding platformo Developed data pipelines from SQL Server to Snowflakeo Created data sources in Snowflake using SQLo Developed dashboards used to identify trends in provider recruiting and onboardingo Maintained data integrity and dashboard consistency while utilizing data from a new product that is still seeing major revisions and enhancements• Updated and maintained sales Tableau dashboards to allow for more in-depth analysis and better demo experience• Cleaned and transformed state claims data using Alteryx. Then developed Tableau dashboards to identify provider location and demographic trends

West Jordan, Utah, Us

• Used DOMO to design and maintain ETL processes and dashboards for the logistics team• Created dashboard that identified capacity planning inefficiencies that needed to be addressed• Developed a dashboard used to track the carbon emissions and additional cost of suboptimal shipping routes. This received attention from top executives and prompted a push for more environmentally friendly shipping and decision making

Sandy, Utah, Us

- Created and enhanced ETL processes in Alteryx for encounter, claims, and provider demographic data- Developed and updated Tableau dashboards to support standard reporting used by hospital administration and physician liaisons to identify provider referral behavior inefficiency- Designed and built data migration from SQL Server (Master DB) to Snowflake (Reporting DB)- Built new and corrected old inconsistent/erroneous data transfer/loads across hundreds of client databases using Alteryx and SnowSQL- Wrote process documentation to identify and detail tables and associated ETL processes between SQL Server and Snowflake- Designed configurable Alteryx workflows (apps) to enable user-driven data transactions (loads, updates, extracts) and reducing ad-hoc developer requests

Irving, Texas, Us

-Use root-cause-analysis methodology to resolve application and ETL problems- Application and data pipeline analysis and optimization- Identify changes, augmentations, problems, and artifacts in data ingestion feed from third parties. Solve for data issues by adding dynamic code to automate and account for current and future permutations- Update and maintain SQL Jobs and Stored Procedures- Work with third party vendors to set up software integrations and document processes for other analysts- Create and debug scripts used for ETL automations

Provo, Utah, Us

Mountain Project - CloneReact | Redux | JavaScript (ES6) | CSS | Node | Express | PostgreSQL | Chartjs | Sass | Auth0A clone of a website that allows you to search climbing routes around the country. Users can add new routes as well as contribute to existing routes.Thousands of routes and areas in the database led to complex SQL queries to access the areas and the routes within themUsers can add todos and ticks(climbing routes completed) to their account with the statistics for their ticks being displayed using ChartjsUtilized Google Maps API to display area and route locationsLive Site: http://pountainmoject.com/Github: https://github.com/group-project-mp/mountain-project

Provo, Utah, Us

A Clone of the camera section of GoPro. e-commerce clone demonstrating fundamental full-stack concepts.• Incorporated Stripe for secure credit card transactions with Auth0 for authentication• Utilized sass to more efficiently style and compile CSS files• Customers can add and delete items from their cartWon runner-up at DevMountain for best CSSTo see the website please go to: https://gopro.devmtn-projects.comTECH USED: React/Redux | HTML | Sass | Node | Express | PostgreSQL GITHUB REPO:https://github.com/marcusko77/gopro-clone

San Francisco, California, Us

- Assumed full responsibility in overseeing newly developed areas for the region.- Conducted extensive analyses in business procedures to determine low-performing restaurants and employees as well as to identify and modify menus that received a high number of complaints.- Leveraged knowledge of SQL in devising dashboards for efficient data collection and reporting.- Expertly developed a playbook which covered strategies for newly developed areas, which subsequently was utilized by other regions in the company.

San Francisco, California, Us

- Facilitated training for hundreds of newly-hired personnel, while handling and resolving employee-related issues.- Dealt with solving company partner’s issues and provided instruction regarding ordering procedure.- Expertly reviewed and set optimal schedule for a number of staff across four areas within the city.- Considered historical data in carrying out analyses to enhance operational procedures.- Drove efforts in adding hundreds of new restaurants to the business platform, thereby increasing business revenue.

Makati, Metro Manila, Ph

- Utilized keen eye for detail in reviewing financial and economic variables on corporate bonds from four major companies.- Earned distinction for designing the buy/sell/hold recommendations through standard industry research and analytic tools including Bloomberg, Microsoft Excel, and company filings.

-Leading and assisting guests through the fully suspended zip line course-Provided ground support while guests and other guides were on course

Bachelor’S Degree, Economics

Education record