Ken Liao

Business Intelligence Analyst at SpyCloud
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Pflugerville, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Computer and Network Security
    • 100 - 200 Employee
    • Business Intelligence Analyst
      • Dec 2021 - Present

      Austin, Texas, United States

    • United States
    • Real Estate
    • 400 - 500 Employee
    • Business Intelligence Analyst II
      • Sep 2018 - Dec 2021

      Austin, Texas, United States •Designed, developed, maintained and updated Tableau dashboards for management oversight, revenue tracking, productivity, scorecards and KPI tracking •Developed new reports and updated existing reports using SQL, Visual Studio and SSRS for Operations, Accounting, Executive teams and Clients •Created and maintained data tables in our database with SSIS packages and Stored Procedures •Point person for server migration between Assurant and Xome and worked closely with the Data… Show more •Designed, developed, maintained and updated Tableau dashboards for management oversight, revenue tracking, productivity, scorecards and KPI tracking •Developed new reports and updated existing reports using SQL, Visual Studio and SSRS for Operations, Accounting, Executive teams and Clients •Created and maintained data tables in our database with SSIS packages and Stored Procedures •Point person for server migration between Assurant and Xome and worked closely with the Data Engineering team for system migration to OrangeGrid •Devised Excel macros with VBA to automate reports to be sent via email and automated other manual processes to increase productivity and reduce operational costs •Collaborated with Product Owners, Stake Holders, Data Engineering and End Users •Trained new hires on the team •Recognized as top employee Show less

    • United States
    • Insurance
    • 700 & Above Employee
    • Operations Analyst II - Business Intelligence
      • Jan 2018 - Sep 2018

      Austin, Texas

    • Operations Analyst
      • Jul 2016 - Jan 2018

      Austin, TX

    • United States
    • Banking
    • 500 - 600 Employee
    • Analyst
      • Mar 2015 - Jul 2016

      Austin, Texas Over thinking, over analyzing Withering my intuition Drawing way outside the lines Reaching out to embrace the random Reaching out to embrace whatever may come

    • Specialist IV
      • Nov 2012 - Mar 2015

      Austin, Texas Analyze foreclosure data and assist in foreclosure research. Audit team assignments and track productivity. Utilize Microsoft Access and SQL to streamline tasks. Implemented strategies for improved proficiencies in audits and KPIs. Increased productivity in daily team duties with use of VBA. Train new team members on pre foreclosure/foreclosure tasks. Key member in ensuring breach letters are sent out to borrowers, foreclosure documents are submitted timely and foreclosure… Show more Analyze foreclosure data and assist in foreclosure research. Audit team assignments and track productivity. Utilize Microsoft Access and SQL to streamline tasks. Implemented strategies for improved proficiencies in audits and KPIs. Increased productivity in daily team duties with use of VBA. Train new team members on pre foreclosure/foreclosure tasks. Key member in ensuring breach letters are sent out to borrowers, foreclosure documents are submitted timely and foreclosure sales take place or are postponed appropriately. Received individual achievement award after only 2 months with the company and second award by the 5th month. Streamlined processes in multiple depts and reduced time in motion by 80%.

    • Real Estate Agent
      • Aug 2007 - Nov 2012

      Austin, Texas Area Generates clients and negotiates contracts on their behalf. Serves as liaison for clients in working with other realtors, banks, and lenders. Produces in depth market analysis for different property values.

    • United States
    • Insurance
    • 700 & Above Employee
    • Team Lead, Data/Reports Analyst, Senior Client Service Rep
      • Mar 2008 - Oct 2012

      Austin, Texas Area • Repeatedly recognized for top performance through fast tracked promotions and selected for high-priority initiatives. • Initiated changes to internal operating system which increased productivity for the company. • Streamlined processes to increase team productivity. • Served as the go-to source for clients and external users with internal operating system problems. • Managed vendor and client relations and resolved all escalated issues. • Coached and motivated team of 10 to… Show more • Repeatedly recognized for top performance through fast tracked promotions and selected for high-priority initiatives. • Initiated changes to internal operating system which increased productivity for the company. • Streamlined processes to increase team productivity. • Served as the go-to source for clients and external users with internal operating system problems. • Managed vendor and client relations and resolved all escalated issues. • Coached and motivated team of 10 to increase productivity and morale. Provided written and verbal feedback and completed performance reviews. • Interviewed and hired new employees. Managed staffing/scheduling to meet needs of clients/team. • Developed reports and worked outside of the box to satisfy client needs. Reconciled company data to match client data. • Utilized macros and formulas to manipulate spreadsheets for tracking and increasing productivity. • Mitigated loss by consolidating company processes for automation. • Selected for and lead committee to improve company procedures and provide potential business models. • Recognized as “MVP” by upper management. Show less

    • United States
    • Retail
    • 700 & Above Employee
    • Store Manager
      • Sep 2002 - May 2007

      Austin, Texas Area • Consistently met sales and customer service goals for store. • Interviewed, hired, maintained and motivated a staff of up to 21 associates. • Paid attention to details and multi tasked to run operations smoothly; followed marketing plans to specification. • Utilized in many locations to renovate store, reenergize staff, and boost sales, taking multiple low ranking stores to top 10. • Continually recognized for individual sales performance and overall store sales rankings. #1… Show more • Consistently met sales and customer service goals for store. • Interviewed, hired, maintained and motivated a staff of up to 21 associates. • Paid attention to details and multi tasked to run operations smoothly; followed marketing plans to specification. • Utilized in many locations to renovate store, reenergize staff, and boost sales, taking multiple low ranking stores to top 10. • Continually recognized for individual sales performance and overall store sales rankings. #1 rankings acquired in all categories throughout career. • Developed many associates for promotion into management positions. • Invited into District Manager program. Show less

Education

  • The University of Texas at Austin
    1997 - 2000

Community

You need to have a working account to view this content. Click here to join now