Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic

Guangyu Mao

Downingtown,PA

Summary

My journey in software-related fields around 5 years.In essence, my extensive experience as a software developer, leadership in team projects, adherence to development best practices, and comprehensive technical skill set have collectively contributed to these achievements.

Overview

8
8
years of professional experience

Work History

Software Developer II

Frontage Laboratories, Inc
01.2019 - Current
  • Development of web application using Oracle Apex and Java Script with SDLC methodologies
  • Design front-end and back-end solution for development with AngularJS and Node
  • Utilized SQL Developer for database design,optimization and maintenance
  • System Administration in Oracle NetSuite for P2P Project and deployment
  • System Administration in Salesforce for CPQ Project and deployment
  • Oracle Cloud and OCI administrator role and building integration with different application
  • Primary System Administrator for GitHub managing company source code repository
  • Global Administrator for Microsoft Azure Active Directory for App registration

CIP Compliance

PJM Interconnection LLC
04.2017 - 09.2017
  • Interface with regulatory agencies and auditors to facilitate external compliance audits and ensure alignment with CIP standards.
  • Monitoring company compliance in NERC CIP Standards and reporting status to FERC
  • Maintain comprehensive records and documentation of all CIP compliance activities
  • Provide training and awareness programs to staff and stakeholders

Software Test Engineer

Innovative Solutions
05.2016 - 09.2016
  • Develop and maintain detailed test plans that outline the scope, objectives, and approach of testing activities for each software project
  • Create clear and comprehensive test cases based on software requirements, user stories, and design documentation
  • Inspected coding standard, regression analyzed, generated test procedure and execute
  • Participate in User Acceptance Testing and Computer System Validations
  • Optimize applications and scalability for better performance
  • Maintain comprehensive testing documentation, including test plans, test cases, test data, and test results.

Manager Assistant

MeiHao International Trade
05.2015 - 08.2015
  • Arranged and analyzed data using PL/SQL to extract valuable insights and support decision-making processes.
  • Implemented robust data validation processes to ensure that all user input was validated
  • Collaborated with multiple warehouses to optimize storage arrangements
  • Managed the end-to-end export process, including documentation, customs compliance, and arranging transportation for products to international markets

Education

Bachelor of Science - Computer Engineering

Drexel University
Philadelphia, PA

Bachelor of Science - Civil Engineering

Purdue University
West Lafayette, IN

Associate of Science - Engineering

Delaware County Community College Media

Skills

  • Programming: JavaScript(NodeJS AngularJS), Python, Oracle APEX, HTML, CSS, PL/SQL, C#
  • Software: SoapUI, SQL Developer, Visual Studio Code, JIRA,GitHub,Microsoft Office

Additional Information

  • Month of Employee, Frontage Laboratories, Inc. (July 2019, May 2022)
  • A. J. Drexel Scholarship, Drexel University, 2015-2018 Drexel Grant, Drexel University, 2015-2018

Timeline

Software Developer II

Frontage Laboratories, Inc
01.2019 - Current

CIP Compliance

PJM Interconnection LLC
04.2017 - 09.2017

Software Test Engineer

Innovative Solutions
05.2016 - 09.2016

Manager Assistant

MeiHao International Trade
05.2015 - 08.2015

Bachelor of Science - Computer Engineering

Drexel University

Bachelor of Science - Civil Engineering

Purdue University

Associate of Science - Engineering

Delaware County Community College Media
Guangyu Mao