Sam Huang

Experience

• 

  Arizona State University - W. P. Carey School of Business

  Mar 2014 - Dec 2014

  Student Support Specialist

  -Managed and maintained the program’s database system to ensure data quality -Coordinated with several departments to produce the program’s monthly expense reports -Prepared Ad-hoc analysis and data visualization for supervisors -Consolidated datasets from multiple sources generated student academic performance reports utilizing advanced skills in Excel

• 

  NYC Department of Design and Construction

  Apr 2016 - Dec 2016

  Data Analyst (Project Intern)

  -Performed exploratory analysis on expenditure data to investigate the root cause of over budget-Utilized Python packages to clean and transform over 60,000 records-Built Logistic Regression, Random Forest to evaluate most important features-Identified main factors and present conclusion to management-Developed departmental dashboard in Tableau to track project expenditure KPI

• 

  Fordham Gabelli School of Business

  Sept 2016 - Dec 2016

  Graduate Assistant - Programing with Python

  -Prepared installation guide and homework assignment materials-Facilitated lecture delivery and introduced several python data processing packages-Hosted weekly office hours to answer Python programming questions

• 

  EnfoTech & Consulting Inc.

  May 2017 - now

  -Utilize Agile SCRUM methodologies to Lead and manage new product development under tight time constraints-Conduct requirement gathering meetings with internal/external clients to identify improvement opportunities -Create system dashboards and BI reports to monitor performance metrics and generate insights-Deliver new product demo, introduce new features and explain technical concepts to target audiences on an as-needed basis-Develop data migration pipeline for system database from various data sources-Design database structures and objects for new system interface/features-Provide customized software solution for business process improvement, system integration, and an end to end implementation-Design integration and data transfer mapping with external systems-Supervise a team of Business Analysts to support 15+ new project initiatives and system maintenance-Coordinate with cross-functional teams to set up project goals and prioritize tasks Show less -Created 50+ performance dashboards, surcharge, and permit reports using SSRS, Crystal, and Power BI. -Constructed PL/SQL scripts to fulfill client’s reporting requirements and automate business process-Collected and integrated spatial data to analyze distribution across geographical areas -Conducted requirement gathering interviews with clients to review existing workflow and propose automated/streamlined solutions-Supported system maintenance, troubleshot more than 300+ issues -Performed system testing and QA, ensured deliverables meet project deadlines -Hosted weekly meetings with project stakeholders to provide progression updates and facilitated product delivery Show less

  • Project Manager

    May 2018 - now

  • Business Analyst

    May 2017 - Apr 2018