Brian Chum Email & Phone Number

Long Beach, Ca, Us

Long Beach, Ca, Us

Santa Monica, Ca, Us

• Led discussions with the global sales and marketing organization to address and answer business questions.• Partnered with the global sales and marketing organization to develop analytics metrics that solve business challenges.• Led the implementation of multiple technical/architectural analytics solutions.• Developed and designed 3 Tableau CRM/Einstein for internal deployment.• Integrated data across 3 Salesforce instances, providing consolidated insights on over $300 million in annual sales revenue.• Built and Deployed intelligent scoring for managing pipelines worth over $200 million.• Designed dataflows for standardizing data and creating calculations around annual recurring revenue, renewal rates, and quota attainment.• Created schedules and managed replications/data syncs/concurrent runs between Salesforce and Tableau CRM to load balance over 28 million rows of data.• Authored SAQL modules to increase deployment efficiency in the team by 700%.• Built visualizations for dashboards that forecasted annual recurring revenue over $100 million from different stages of the sales lifecycle.• Designed a Business Intelligence specific role hierarchy system for securing sales data for over 500 users globally.• Authored SAQL queries for customized dashboard functionality in Tableau CRM • Built databases to facilitate ETL processes with other applications in finance and billing.• Analyzed key performance indicators and wrote business requirements for the deployment of the Domo Analytics/Salesforce Einstein/Tableau CRM platform.• Built data integrations for Salesforce, Google Analytics, and Marketo to provide consolidated insights from the marketing funnel into the sales pipeline.• Created and maintained the data models used by the Lattice's Insights predictive engine.

• Analyzed front end Electronic Medical Records (EMR) processes to increase operational efficiency for consulting partners and clients• Designed new operational workflows with existing application environment to eliminate redundancies• Analyzed of clinical key performance indicators and business requirements for reporting• Deployed new servers with Microsoft Exchange email relay, .net framework, Terminal services, and FTP file servers• Deployed Google App Suite to office and field staff: Mail, Calendar, Drive, Docs, Sheets, Slides• Managed projects to research, design, configure, implement applications to support office/field staff

El Segundo, Ca, Us

• Translated business requirements from 6 different organizations to support a migration into an integrated Salesforce environment. • Analyzed Salesforce system infrastructures to consolidate 6 companies, in different industries that offered different services, increasing efficiency of users in Salesforce by 600% percent. + Companies: Sesame, e-Doctors, Officite, NOLO, Total Attorney, iMatrix• Created reports using CRM data/SQL Server Management Studio (SSMS) to analyze revenue.• Designed visual flows, as a Salesforce Administrator, that automated data entry in the opportunity database using account/contact data to make the sales process more efficient.• Maintained Apex Triggers, as a Salesforce Administrator, that created data across multiple objects within the salesforce infrastructure increasing the efficiency of teams handing off data between objects.• Optimized visualforce pages and designed custom Salesforce applications to address operation inefficiencies. • Managed Salesforce replication using linked servers with PostgreSQL.

Irvine, California, Us

• Analyzed front end processes to understand which mobile applications fit nursing workflows in the field.• Designed operational workflows within applications to streamline nursing workflows• Authored business requirements for designing multiple Salesforce applications• Managed a linked server that brought Salesforce into a SQL environment for reporting in a data warehouse using PostgreSQL• Designed Salesforce applications that allowed users to complete a variety of functions to replace paper driven processes: + Call Center: Designed this application to manage a 24 hour call center using Salesforce as the front end application and patient database. + HCC Coding: Designed this application to manage operational processes for scheduling and completing comprehensive evaluations to be used with multiple clients like LA Care, Blueshield, Healthcare Partners. + Palliative: Designed this application to manage operational processes for patient outreach and scheduling visits + Marketing: Designed this application to manage operational processes for hospice liaisons to manage referrals, complete explanation of benefits, and manage driving routes between facilities + Legal Solutions: Designed this application to manage legal documentation and contracts + IT Resources: Designed this application to manage purchase orders, bills, and technology assets distributed to staff to better asset management.• Managed and was the system administrator for application servers using windows server 2008R2/2012 and running IIS8, Microsoft Exchange email relay, .net framework 4, Terminal services, FTP file servers, VMware virtualization, Railo 4, Adobe Cold Fusion • Deployed Tableau to analyze clinical KPIs , patient census, patient outreach efficacy, and provider utilization• Deployed Druva as an enterprise wide back-up solution to protect patient records.• Deployed Aprima as an electronic medical record for the medical group division.

Associate Of Science (A.S.), Computer Software Engineering

Cinematography And Film/Video Production