Bryan Sam Email and Phone Number

Oversee new and existing 10+ ELT data pipelines from ingesting various data source systems to Snowflake to building, maintaining, and scaling data pipelines and its data models in dbt to report gameplay usage of Level Ex's games• Design, build, and maintain all parts of data warehouse infrastructure (ELT, data modeling, metric design, reporting products) to meet the needs of business use cases• Streaming and ingesting new raw data in real-time to Snowflake instead of an hourly Playfab event export by switching to Snowpipe (auto ingestion) and AWS S3 (file storage) with the help from a Software Engineer• Serve as a data subject matter expert and spokesperson to address questions quickly and accurately for stakeholders including Product Managers, Sales, etc.• Advocate for data quality and governance by implementing dbt unit and singular testings to ensure accuracy and identify and fix the root causes• Establish best data modeling practices and Kimball's methodologies to deliver DRY, optimal, and scalable database designs and queries in Snowflake via dbt • Monitor scheduled Prefect flow data pipelines and identify and resolve any failed Prefect flows in a timely manner• Minimize liability on the Analytics team by providing code reviews on Github and documenting data pipelines details, Tableau dashboards, changes to metadata, and data models

Designed and implemented Level Ex’s analytics framework and platform, developed and maintained ELT data pipelines, and delivered concise and effective data reporting products to demonstrate that Level Ex's games can hone and improve healthcare professionals' skills• Built, maintained, scaled, and supported 10+ existing ELT data pipelines and its data models in dbt to meet the needs of business use cases• Reduced the runtime around 75% for Level Ex’s 5 core apps data pipelines after switching the ingested data models from table to incremental in dbt• Co-led with a data engineer on designing, building, and integrating Level Ex Data Warehouse API Endpoints, which is another data reporting product option, to Level Ex existing ELT framework • Established and maintained trusting relationships with various teams (Sales, Marketing, Platform, etc.) to develop and improve Level Ex’s internal analytics products and services• Monitored scheduled Prefect flows and identify and resolve any failed Prefect flows in a timely manner• Minimized liability on the Analytics team by providing code reviews on Github and documenting data pipelines details, Tableau dashboards, changes to metadata, and data models

Supported ELT data pipelines, deployed impactful and compelling Tableau dashboards, and led statistical analytic projects to demonstrate that Level Ex's games can hone and improve healthcare professionals' skills• Supported 10+ existing ELT data pipelines and its data models in dbt to meet the needs of business use cases• Helped Level Ex to receive prestigious grant from NASA Polaris Dawn by listing the best sample sizes through power analysis in R for upcoming learning outcome study• Built a customized CRM dashboard on Tableau to improve the understanding of Level Ex's email marketing campaigns and its player acquisition for the marketing team• Delivered internal Rx Lift Studies that demonstrate Level Ex games positively increase Rx prescriptions by doctors for marketing and sales teams to acquire and retain pharmaceutical clients• Collaborated on and led data analytics projects to meet the needs for stakeholders from Sales, Marketing, and Product

Developed and recommended analytics solutions for retail banking institutions to optimize their customer engagement and workforce resources for its bank branches with project manager(s) and banking institutions' Workforce Management Team• Reduced the time of running daily and weekly field studies reports in half by developing organized and concise SQL script templates with written instructions• Applied stratified random sampling to present a list of selected branches as a sample that best represents the entire financial banking intuition’s network of branches for the field study • Transformed the field study’s data into captivating and storytelling visualizations in Tableau under the guidance of the Project Manager and Subject Matter Expert• Trained co-workers on how to connect Microsoft SQL Server and create visualizations in Tableau

• Improved the Location Matching algorithm’s accuracy from 44% to 92% by implementing regex, datamapping rule to standardize addresses, and restricted string-matching criteria in Python• Co-authored standardized SQL scripts to normalize the data to minimize the redundancy of data preprocessing in preparation for statistical analysis and reports• Applied clustering algorithm to find different demographic market groups to assist clients on Open Hours Optimization for their bank branches' hours of operations• Wrote SQL queries for data clean-up, data discrepancies and validation, and data aggregation and summarization• Created reports and presentations of statistical analysis and results from field studies for executive teams of a retail banking institution

Partnered with Edwards Lifesciences Product Quality Team on a 6-month capstone project to provide business recommendations by employing advanced data analysis techniques• Drafted a proactive solution on providing in-depth insights utilizing unsupervised machine learning techniques and natural language processing methodologies in a team of 10• Won the Best Analysis Awards for captivating solution for Edwards Lifesciences Tools: Python (Pandas, NumPy, Matplotlib, Scikit-learn, vaderSentiment, & NLTK) and Tableau

Managed and validated the transmission of accurate global product data with Product Data Integrity Manager to cross-functional teams’ daily ad-hoc analysis and reports • Co-led a 2-year Product Data Migration Project from Apparel Business Systems to Microsoft Dynamics AX with IT, Inventory Management, and Product Development• Eliminated the manual process of creating bi-weekly Closeout & Runout reports by automating on PowerBI with BI Developer and Product Data Integrity Manager• Constructed an Assortment Planning Microsoft Excel template for the VP of GMM in Professional Division to forecast orders to match the market demand for 5.11 products• Organized mass seasons catalogs which include initial costings and pricings for Category Managers and Sr. Merchandisers before importing to Microsoft Dynamics AX

Completed 3-month assignment under Auto Alert’s 2017 budget by supporting the Sr. Financial Analyst and Director of Finance on year-end budget and forecasting Auto Alert’s 2018 budget• Managed and improved the efficiency and accuracy of Auto Alert’s commissions models for regional sales, marketing, and consulting teams• Cleaned and manipulated data from SalesForce in preparation for financial analysis and ad-hoc reports • Presented financial discrepancies and anomalies to the Director of Finance in a timely manner

Completed a 3-month summer part-time job with Suntek Systems on handling high volume of IT assistance tickets• Remotely installed and set up Suntek Systems' enterprise software applications and Microsoft SQL Server on clients' computers• Identified and troubleshot technical issues for Suntek Systems' customers• Reported all performed services and supports to the Director of North American Operations for review

Assisted VP of Marketing with long-term marketing projects and campaigns• Created several Microsoft Excel spreadsheets of prospective clients for the Sales Team • Researched peer-to-peer lending industry for VP of Marketing • Prepared and ignited Google AdWords online marketing campaign with the VP of Marketing to attract prospective clients

Forecasted monthly revenue and audited WIP projects under the supervision of the Senior Director of Agency Services• Updated the status of projects on FileMaker to keep track of progress• Revised and audited WIP movement for accuracy and correction • Calculated the monthly revenue forecast for Senior Director of Agency Services to ensure the forecast met its goal

Fulfilled 3-month internship with Practice Builders Social Media Team• Populated and launched clients’ social media accounts• Scheduled clients’ posts on Facebook, Twitter, LinkedIn, Yelp, and Google+ via Hootsuite• E-mailed pending social media posts to clients for approval

• Prepared and made drinks in a quick and accurate fashion for customers• Reported to store manager to ensure the inventory is in stock every week • Occasionally cleaned and organized the shop to adhere the safety and health standards