TECHNICAL SKILLS

Databases: MySQL/MariaDB, PostgreSQL, SQLite, SQL Server

Frameworks and Libraries: AngularJS 1.X, Angular UI Tree, Bootstrap, CodeIgniter, D3js, DataTables, dhtmlxGantt, Font Awesome, HighCharts, JPGraph, jQuery, Kendo UI, ngGrid, PHPExcel, YUI

Interchange Formats: CSV, Excel, JSON, XML

Languages: CSS, HTML5, JavaScript, PHP, Python, SQL

Operating Systems: Linux, Mac, Windows

Programs and Services: AWS EC2, Bugzilla, Cron, Git, Github, Grunt, JIRA, MS Office, Subversion, Vagrant, VMWare

Protocols: FTP, HTTP, LDAP, ODBC, SCP, SSH, WebSockets

Servers: Apache2, Bind DNS, LDAP Directories and Domain Controllers, Memcached, MongoDB, MySQL/MariaDB, Postfix, Samba

System Administration: Linux Server Administration, MySQL Database Administration, Network Administration, Windows Server Administration

PROFESSIONAL EXPERIENCE

Full - stack Web Developer

Confidential, Cupertino, CA

Responsibilities:

• Developed a complex single page web application to manage the scheduling and logistics of hundreds of millions of dollars of store construction and design materials, maintaining pixel-perfect user interface design and blazing fast application performance.
• Designed and developed a sophisticated reporting tool that allows senior management to easily view the status of store construction projects and future store openings. The tool includes an intuitive web-based UI, point-in-time snapshots, PDF generation, and Excel exports.
• Developed an approval workflow tool to manage the process of approving millions of dollars worth of store construction and design materials. The tool collects approvals and routes requests to various teams within Confidential, as well as sends automated email notifications and reminders to shorten approval times and improve operational efficiency.
• Developed an interactive dashboard and data management tool with drag-and-drop gantt charts for viewing and managing the current workloads of the organization's staff. Data from the tool is used to calculate workload-based compensation incentives.
• Designed and developed the team's automated email notification system. The system includes a web-based management console that allows developers on the team to easily design, schedule, preview, and test automated emails.
• Collaborated with Confidential designers to produce visually stunning email templates.
• Developed dozens of source-of-truth space and asset reports for Confidential 's fleet of retail stores. Common requests include square footage by space or by floor, area dimensions, the number of display counters / tables / stools / etc. within a store, or whether a store houses a particular design feature. Other reports include store lease information, landlord information, metro rankings, as well as other metrics relevant to strategic planning.
• Developed internal REST API endpoints that are consumed by other teams and used to configure the status and resolution of in-store display monitors and video walls.
• Currently designing and developing a complex hierarchical data management tool to store the space and asset information for Confidential 's entire fleet of retail stores. The system implements business logic based on the intersection of multiple recursive data hierarchies, and provides an administration interface for managing hierarchies with infinite depth.
• Provide ongoing support and patches for legacy software modules and reports, often improving performance and data integrity in the process.

Software Engineer

Confidential, Sunnyvale, CA

Responsibilities:

• Designed and developed an interactive web-based executive dashboard that allowed senior management to easily monitor the status of a strategic multi-year global infrastructure consolidation project. The project's scope was to decommission or consolidate approx. four hundred thousand servers and over a dozen data centers resulting in a roughly two hundred million dollar reduction in operating expenses per annum.
• Designed and developed an interactive web-based dependency graph to help project managers visualize the technical dependencies and outage risks associated with their server decommissioning plans. The tool was designed as a single page web application with an interactive HTML5 SVG user interface. Costly unplanned service outages resulting in the loss of tens of millions of dollars of advertising revenue were commonplace prior to the release of the tool. There were zero unplanned service outages after the release of the visual dependency graph.
• Developed an automated ETL application to gather, analyze, and summarize the status of hundreds of thousands of servers every four hours.
• Collaborated with the Performance Engineering Group to develop internal tools to promote the improvement of server hardware utilization by Confidential 's various web properties, resulting in millions of dollars of saved capital and operating expenses.
• Contributed to the development of a complex SOX-compliant data entry and approval workflow tool used to audit and report on capitalized labor expenses.
• Acted as the team's DBA, managing all changes to the team’s MySQL database, and handled a majority of the team's schema design and performance optimization tasks.
• Defined and documented the team's development workflow.
• Defined and documented the team's unit testing guidelines.
• Developed several interactive full-stack reports using libraries such as HighCharts, PHPExcel, D3, RGraph, and YUI on the frontend, and PHP, MySQL, and Memcached on the backend.
• Developed an ETL automation framework with PHP, MySQL, and cron.
• Developed numerous integration scripts to consume and process data from various internal REST API's.

Database Developer & Systems Analyst

Confidential, Cupertino, CA

Responsibilities:

• Developed automated ETL solutions to transfer, import, and summarize ~20GB of CSV, XML, and SQL data per day.
• Developed a custom web crawler to scrape customer reviews of Confidential Kindle products.
• Designed and developed numerous web-based dashboard reports for Confidential Kindle products.
• Administered an internal business intelligence reporting tool with LDAP authentication and group-based access control.
• Acted as the team's database and systems administrator.
• Provided the team's SQL report writers with normalized and summarized data in a timely manner.
• Assisted the SQL report writers with SQL query optimization.
• Created and maintained the team's Git source code repositories.

Senior Programmer

Confidential, Camarillo, CA

Responsibilities:

• Designed and developed an automated ETL application with email notifications, high-performance caching, web-based search and reporting, and a web-based management console.
• Retrieved, cataloged, and archived over two million semiconductor manufacturing equipment log files from Confidential 's contract manufacturers in Asia, Europe, and the US, and transferred them to a multi-million dollar yield analysis tool located in Confidential 's corporate office.
• Used machine learning to develop an intelligent email notification system that used statistical analysis of current data flow trends to determine notification thresholds. The system was used to accurately identify contract manufacturers failing to provide manufacturing data in a timely manner, and could be configured on a per-user basis via a web-based management console.
• Collaborated with Confidential 's electrical engineers to develop a visual wafer map tool to display the results of wafer die quality tests via a modern web-based report dashboard.
• Worked with Operations Managers to design and develop an extranet website to facilitate change-management requests between Confidential and its contract manufacturers.
• Launched internal Wordpress blogs for Confidential 's business units.
• Developed a custom Wordpress LDAP authentication plug-in to authenticate users against Confidential 's multi-domain directory servers.
• Managed one junior off-shore developer located in India.
• Implemented Subversion revision control for Confidential 's internal web application codebases, and network/server configuration files.
• Handled all system and database administration tasks pertaining to Confidential 's web applications.

Senior PHP Programmer

Confidential, Westlake Village, CA

Responsibilities:

• Maintained the company's PHP-powered subscription-based marketing solutions.
• Developed new features and bug fixes for existing customer-facing products.
• Decreased the number of WebInspect-detected security vulnerabilities by 95% by implementing proper data sanitation and validation procedures.
• Developed several features for the company's latest subscription-based product offering
• Collaborated with the QA team to improve the overall quality of our products.
• Configured the servers and services running in the company's Development and QA server environments.
• Provided ongoing support and patches for legacy products, often improving performance and data integrity in the process.

Systems Administrator

Confidential, Baltimore, MD

Responsibilities:

• Managed a heterogeneous Linux/Windows network.
• Provided Linux and Windows technical support.
• Improved hardware utilization by consolidating physical servers with VMWare ESX.
• Deployed Windows Domain Controllers to simplify the management of Windows network clients.
• Deployed Windows Terminal Servers.
• Deployed Redhat Enterprise Linux (RHEL) 4.X virtual machines.
• Deployed Nagios to closely monitor servers, network printers, VoIP systems, routers, and switches.
• Wrote several Perl, bash, and batch scripts to simplify routine server administration tasks.