Harriett Xing

Skills PHP, Python, Java, Node.js, Coldfusion HTML, Javascript, React GIT, Subversion, JIRA, ansible SQL, PL/SQL, Oracle Application Express (APEX) MySQL, MongoDB, Oracle (version 7 to 12c), NoSQL Experience PHP Developer, Lithicum Heights MD — January 2017 – present Responding to development, enhancements and maintenance of current web application with backend in PHP/Python/MySQL, and front end in HTML/CSS/JavaScript. Designing and developing pages in php/html/javascript. Installing and configuring IIS/PHP7/MySQL5 for production and testing environment. Installing and configuring Linux/Apache/PHP/MySQL (LAMP) for development environment. Migrating MySQLi to PDO. Creating Python scripts to utilize libraries for file uploading, and MySQL DB backup. Performing database administration tasks for production and development in MySQL. Installing and configuring Ansible; Creating playbook for setting up development environment. APEX DEVELOPER, Corepex, Bethesda MD — July 2015 – October 2016 Worked on maintenance and support of backend web application that built reports and created processes for payroll and benefit data. The application was built on Oracle 12c and Application Express (APEX) 5. Responded to JIRA tickets that update PL/SQL packages and Application Express Components in HTML/CSS/JavaScript. Interacted with data analysts to ensure application meets requirements. DATABASE DEVELOPER, SOFT CONCEPT, WASHINGTON DC — JULY 2014 – OCTORBER 2014 Analyzed existing Oracle PL/SQL scripts and UNIX shell scripts. Created technical analysis document. Created PL/SQL procedure. Participated in meetings to clarify requirements. DATABASE DEVELOPER, SYNTEL, HUNT VALLEY MD, MEMPHIS TN — JANUARY 2014 - JULY 2014 Worked as a database developer supporting a team of Java Developers. Worked with Oracle database scripts and build scripts in HP UNIX as part of an agile team. Created design documents and test plans from user stories. Participated in team code reviews and design reviews. PROGRAMMER ANALYST, THE NATURE CONSERVANCY, ARLINGTON, VA — SEPTEMBER, 2012 – OCTOBER 2013 Worked with end users to determine business needs and process. Responded to maintenance requests for Team Approach (a membership and customer relationship management System for nonprofit organizations) in Oracle PL/SQL. Used UNIX as testing and staging servers. DATABASE DEVELOPER, VISTA TSI, HERNDON, VA — APRIL 2012 — SEPTEMBER, 2012 Responded to maintenance fix for application in Oracle Application Express (APEX) Worked with functional data analysts to determine business process. Converted Foxpro reports to Oracle PLSQL stored procedures. Analyzed SQL queries for performance tuning. WEB DEVELOPER, CNI INFORMATION TECHNOLOGY, ROCKVILLE, MD — JULY 2010 – FEBRUARY 2012 • Worked for Indian Health Services Web team. Created, designed, implemented, and maintained internet and intranet web applications using Coldfusion 8 and 9, HTML, CSS, javascript, with backend in MS SQL Server 2005 and 2008 using transact-SQL. The applications are developed using Fusebox MVC framework. Participated in designing and implementing the database backend. Followed IHS software development process and Section 508 standards. Created and maintained front end CFM web pages,T-SQL queries for Indian Health Services Listserv mailing list tool. Designed and implemented a conference room scheduling tool using relational database in SQL Server 2005 (later upgraded to 2008). This was a full life cycle development that involves requirement analysis, design, implementation, testing, and maintenance. As a member of a team, participated in developing an action/documents tracking tool. Developed forms for data entry and file upload, data display screens, PDF reports in Coldfusion 8, and corresponding SQL queries. Performed data modeling for the new database implementation. Wrote system requirements specification documents. Created user acceptance test plans and facilitated user acceptance testing. Developed a user acceptance test plan template for CNI web team. DATABASE DEVELOPER, SSCI, ARLINGTON, VA — NOVEMBER 2009 – JUNE 2010 Maintained web reports in Oracle 11g State Department. The application was originally developed in Oracle web application package to track information on people, and was in the process of being migrated to .NET platform. Troubleshoot new and legacy code in PL/SQL. These were HTML, CSS, and Javascript code dynamically generated by PL/SQL stored procedures at run time through ORACLE HTP. Worked with DBA team to tune SQL statements for performance. Worked with systems analyst and business analysts to decipher business needs and requirements. Performed performance tuning of indexes and SQL queries. • Analyzed SQL queries. WEB DEVELOPER/DATA MANAGER, ICF INTERNATIONAL, WASHINGTON, DC — SEPTEMBER 2006 - NOVEMBER 2009 Designed and developed a personnel salary expense forecasting tool for budget analysts in Federal Aviation Administration. The tool was prototyped in MS Access, developed as a web application in Coldfusion 8, Coldfusion Reports, CFC components, HTML, CSS, javascript, and Oracle 11g backend. Gathered user requirements through meetings and prototyping Performed user software installation and supported software demo meetings. Developed forms, displays, reports in Coldfusion MX, 7, 8, and corresponding SQL queries. Designed and implemented relational database in Oracle 10g and 11g. Performed data modeling for the new database implementation. Installed and maintained Oracle 10g database instances, performing upgrade, backup, import, export tasks. Monitored development database space usage to enhance performance. Performed database administration tasks, database sizing, database migration and performance tuning, backup/recovery, security. APPLICATION DEVELOPER, NORTHROP GRUMMAN,ARLINGTON, VA — MARCH 2005 - SEPTEMBER 2006 Developed PL/SQL stored procedures as part of a development team. Developed screens using Oracle Forms. Performed system and integration testing. APPLICATION DEVELOPER, EVIDENCE BASED RESEARCH, VIENNA, VA — NOVEMBER 2002 - APRIL 2004 Designing and developing a web based survey application using Java with Turbine framework and MySql. Used XML document to specify application database schema. Designed and implemented the database in MySQL. Written all the required database scripts in SQL, PL/SQL. Customized an open source issue tracking and collaboration tool in PHP/MySQL (phpCollab) in LAMP Stack. Implemented a web application in J2EE and Oracle utilizing a rapid application development tool, SPARX. Used XML to specify database schema Designed and implemented a decision tree software in Visual Basic. Designed and modeled databases for confidential clients in intelligence community. Assisted in miscellaneous Oracle database administration tasks. Debugged ASP pages SENIOR WEB DEVELOPER, INNOVATIVE INFORMATION TECHNOLOGY, FAIRFAX, VA — OCTOBER 2000 - AUGUST 2002 Designed and developed the intranet for Innovative Information Technology (www.iitedge.com) using PHP and MySQL. The intranet ran with Tomcat on Linux. It was set up SSL. The application was designed using MVC principles. Created design document for an in-house tool that generates basic Java application templates for a business schema. The tool used XML to specify database schema and basic application display. Maintained and enhanced Java servlet-based choicebuys.com B2B MVC web application for Choice Hotels. Developed front-end Javascript data validation routines to improve quality of user entered data. Designed functional web pages in HTML, CSS, Javascript. Maintained a Task and FAQ server using PHP and MySQL in LAMP Stack. Used VMWare to work with both Windows and Linux. Education Virginia Tech, Blacksburg, VA — B.S. Computer Science Certification Oracle PL/SQL, Brainbench.com, October 2016 PHP 5.6, Brainbench.com, January 2017 CPR/AED/First AID, American Red Cross, December 2016 Continuing Education MongoDB Administration (MongoDB University) (http://university.mongodb.com/course_completion/120f823f-a95c-43b9-8dcc-) MongoDB for Python Developers (MongoDB University) (https://university.mongodb.com/course_completion/3fb7405e-d975-48fe-a59d-77c31706/printable) MongoDB for Node.js Developers (MongoDB University) Google Cloud Onboard (Google) MERN Stack Developer (Lynda.com) MEAN Stack Developer (Lynda.com)