Vicky Guan Email & Phone Number

New York, Us

San Francisco, Ca, Us

Designing and developing decentralized data systems

Mountain View, California, Us

• Contributing to the Schedule Payments system for QuickBooks Online and QuickBooks Desktop by building the ability to query, manipulate, and manage over 590,000 transactions per month with GraphQL and batch requests in Java and Spring Boot framework• Maintaining Schedule Payments system robustness and scalability through continuous testing using Karate, Mockito, and JUnit such that about $90 million of transactions are successfully processed every month• Building from ground up Intuit’s first ReasonReact web-app in OCaml that consumes the Schedule Payments API and allows for users to graphically manage schedules within the Schedule Payments system• Designing and implementing Secure Sign On and cookie management system in backend and frontend systems using serializable encryption, Memcached, YAML configurations, and REST protocols to prevent schedule corruption and to ensure authorized usage• Updating Schedule Payments API documentation on internal wiki while resolving any tickets from our clients

Mountain View, California, Us

• Designing and implementing Intuit’s first integrated test application on Android to facilitate non-UI components testing for Turbo Tax and Mint• Implementing a cross platform test app-runner for Android, iOS, and Web by using WebdriverIO, Appium, JavaScript, and Mocha testing framework to ultimately accelerate QA test development time by 66%• Engaging in agile rapid development, refactoring the code base to enhance customer experience, and working with other software engineers to produce features, fix bugs, and establish legacy code

Bentonville, Arkansas, Us

• Monitored all production server health and statuses across each data center by developing automated Python and bash scripts on Pycharm by performing full stack responsibilities• Automated data collection and script enforcement through storing monitoring results into a MySQL database for internal access• Collaborated with team members in working on an internal dashboard using HTML/CSS, MySQL, Angular, Node.js, JavaScript API for team infrastructure status visibility and synchronization

Bentonville, Arkansas, Us

• Extracting data from Walmart database sources like RESTful web apps, ServiceNow, and intra-network servers to create output reports regarding company resource usage (e.g. app efficiency, server assignments) for site maintenance• Testing and building automated Windows Share, REST Query, mySQL, Excel, Microsoft Azure, and ServiceNow DataLink connectors using Apptio software to transfer Walmart Big Data onto one accessible data platform • Operating Apptio data platforms with extracted data transforms for optimal and more transparent ITFM cost modeling• Collaborating with @WalmartLabs teams and Apptio IT Crew to resolve connector building issues through tracking DataLink engine log errors, dissecting file properties, and reassembling DataLink header and query arguments

La Jolla, Ca, Us

• Cooperating with Sixth College Provost, academic advisors, student affairs staff, and university counselors and psychologists to facilitate vital information through overlooking scheduled and walk-in appointments and acting as the intermediary between clients and Sixth College staff • Instructing and answering parent and student questions pertaining to university policies, events, and forms along with Sixth College academic requirements• Supervising office space to ensure orderly and pleasant building atmosphere for staff and students

La Jolla, Ca, Us

• Collaborated with 41 other Orientation Leaders in overseeing the current largest class Sixth College has had of over 900 incoming freshmen and transfer orientees through a three-day orientation focusing on academic preparation, drug and alcohol awareness, and community building• Individually guided and mentored 23 students in providing on-campus resources and opportunities for an excelling university career while preserving a positive, safe environment

San Francisco, California, Us

• Representing MKThink and San Francisco Student Nutritional Services in assessing and traveling to over 100 schools across the city through arranging scheduled visits and collecting dimensional analysis• Examining tools and conditions within San Francisco Unified School District kitchens, cafeterias, and serveries to advance decisions in unit technology and other appliance upgrades

Columbus, Oh, Us

• Managed the inventory for easy product location and efficient product promotion• Assisted customers in locating certain products and using fitting room facilities• Assembled and arranged store structure layout according to Abercrombie and Fitch corporation standards

Us

• Assessed non-profit organizations and their goals through series of agenda program structure evaluations while discussing review matters with program directors • Collaborated with other youth reviewers in adequately allocating $22 million of government funding• Represented youth voice through passing programs that foster healthy growth within communities

San Francisco, Ca, Us

• Guided and organized field trips and park days throughout the Bay Area• Facilitated weekly cultural teaching days about Japanese ethnic and heritage and crafting activities• Managed camper contact papers to easily contact parents in times of emergencies• Maintained and followed safety standards through routine environment examinations

Bachelor Of Science (Bs), Computer Engineering

High School Diploma, Ged