Roger Chern

720-***-****

** ****** *****, *********, ** 80127

adh72f@r.postjobfree.com

Work History

Colorado Department of Labor and Employment

November 2018 – present

Liability Analyst

-Skills: Excel, Microsoft Office, Google, Salesforce, law interpretation, client communication

-Analyze businesses’ application for wage and unemployment premiums to determine their qualification for payment into the state unemployment fund

oDetermine their premium rates as a result of their business history, particularly employment rates and wages paid, as it compares to their use of unemployment payments

oAnalyzing accounts to determine eligibility, verifying historical trends and business operations to create new annual rate structures for companies

oCommunicating issues regarding company accounts, including overdue payments, refund payments, account errors, maintaining updates

Colorado SEO Pros

November 2017 – January 2018

Business Analyst

-Skills: Moderate Excel (Equations), building reports, recommendations, competitive research

-Use of Goggle Analytics and Excel to track website errors and performance

-Pivot tables used for types of errors and source of customers’ search landing sites

-Vlookups to assist in identifying source of errors within Google Analytics

-Analyze clients’ websites to determine loading ability and make recommendations for improvement

-Find competitors’ search engine position and determine methods to increase visibility comparable to these sites

-Assist in keyword research and page “story” improvements that align with these keywords

-Find industry websites and blogs to connect clients’ websites

School

September 2015 – June 2017

Projects:

oBusiness Analysis with Microfinance, First Finance, Phnom Penh, Cambodia (Jan – Mar 2016)

Review and analyze business structure of First Finance to determine the stability of organization, reports sent to its contributor, Deutsche Bank, review financial statements to determine the quality, uses and default rates of microloans, record statements of business operations and relations with its clients, determine if there are any internal problems and potential resolutions

oReal Colorado Soccer Consultant (Sept 2016 – Nov 2016)

Determine the current market share for Real Colorado soccer, analyze growth rates based on territory, population growth, determine strategy for expansion, through promotional growth through schools and neighboring communities

oReal Colorado Soccer Consultant (Jan 2017 – Mar 2017)

Analyze data warehousing techniques, perform data cleaning and sort through current and former players, use data to analyze current population based on age and gender, give analysis of data cleaning and use of data thereafter

Colorado Department of Revenue

February 2008 – February 2015

Driver’s Examiner III

-Skills: Customer interaction, office management, daily accounting, law interpretation and implementation, interoffice communication, data entry and analysis, office organization, security and privacy

oIncreased employee efficiency and customer interaction by approximately 18%, avg 1800-2000 customers per employee/month

-Verify government documents, fraud preventions, audit employee workload

-Assist in testing computer network upgrades to comply with government procedures

oAssist managers with balancing office accounting, filling proper documents to main office

-Creating procedures and policy to comply with laws and maintain clarity for employees

Education

University of Denver, Master’s in Business Administration (September 2015 – June 2017)

Concentration: Business Analytics

Certificate: Corporate Social Responsibility

-Relevant Courses: Business Statistics, Financial Accounting and Reporting, Strategic Cost Management, Managerial Finance, Law and Public Policy, Strategic Human Resources, Strategic Management, Survey of Business Analytics, Business Databases, Predictive Analytics, Data Mining and Visualization

University of Colorado, Boulder, BA Sociology (September 2000 – May 2004)

Skills:

-SPSS (Intermediate), JMP(Intermediate), Microsoft Office (Advanced), Excel (Advanced), Tableau (Intermediate), PowerPoint (Advanced), SQL (Proficient), LISREL (Proficient), Trello (Beginner/Intermediate)

Contact this candidate