Jan 2023 – Present · 3 yrs 5 mos

Jan 2022 – Jan 2023 · 1 yr · Mountain View, California, United States

Jan 2016 – Jan 2021 · 5 yrs · San Francisco Bay Area

• Setup continuous testing and validated majority of new hardware entering FB data centers
• Increased hardware testing, issue detection and coverage over 10x by building processes and dashboards to identify and fix gaps between test plans and runs
• Created issue management system and dashboards to detect, categorize and prioritize issues
• Improved efficiency of debugging 1000x with automated filtering, duplicate failure detection, tracking and reporting
• Integrated and improved tools for device reservations, test management, scheduling, debugging and reporting on 20,000 devices
• Designed HW Testing Production Databases and Datawarehouse
• Optimized queries and schema designs providing up to 1000x performance
• Reduced time to run pipelines from 5 hours to 20 minutes, improving dashboard reliability
• Partnered with multiple teams, organizations and vendor companies
• Lead and trained small team of Data Engineers and SWEs
• Gave presentations on Error Debugging at scale with Presto and Regexes
• Added test management, reporting and simplified setup of Test Automation Framework
• Discovered temperature, power and optics degradation relationship used in patent 10425156

Jan 2015 – Jan 2016 · 1 yr · Shenzhen, Guangdong, China

• Created language quizzes with over 10000 questions that determine ability from a small subset of questions using python, sqlite3, Django and Computerized Adaptive Testing
• Created website using AWS with load balancing, auto scaling and github auto code-deploy
• Loaded translations into postgres with python, Beautiful Soup, ETL, argparse, psycopg2
• Created unique prime factorization math game and Evolution demo for iOS in swift

Jan 2013 – Aug 2014 · 1 yr 7 mos · San Jose, CA

• Developed Test Automation framework in Moose / perl
• Created tools to automate reservations of systems, build creation, install, system management, and running tests and test suites
• Designed data model and managed postgres database for test framework and systems
• Created Object Relational Mapping for querying postgres data and returning perl objects
• Wrote XML/XSL based reporting of automation results
• Integrated tools with Accurev, Jenkins, JIRA, LDAP
• Optimized sql queries improving speed by 10-100x for web pages and reports

Jun 2012 – Dec 2012 · 6 mos · Foster City, CA

• Lead Perl developer on Enterprise CM team
• Created Dashboard for analyzing release status and issues
• Created bash, perl scripts, and mysql db for tracking status of hundreds of existing scripts in a centralized location
• Created automated method for promoting code and deploying releases

Dec 2011 – Jun 2012 · 6 mos · San Ramon, CA

• Wrote test automation scripts and tools for Uverse
• Created OO Perl Modules for combing data from multiple sources, including Oracle, SQL Server, MySQL, LDAP, and ssh using Moose, DBI, Net::Ssh, XML, Javascript, and SOAP
• Setup and configured Linux VM, mySQL db, Apache web server, and Perl

Jan 2003 – Sep 2011 · 8 yrs 8 mos · RTP, NC

• Chief Software Architect in Advanced Networking Services for Net Vision Suite, including: Net Audits, Net dB, Net Collector, and Net Alert
• Primary Designer for Net Audit Oracle 8i database (10+ gigs, 5000+ objects including tables, views, triggers, PL/SQL functions and procedures)
• Managed projects involving 20+ developers and testers in RTP, San Jose, and India
• Programmed in Perl, Perl DBI, Oracle, Java/J2EE, JDBC, Swing, Servlets, XML, VB, Access, Sybase, Apache, IIS, TCP/IP Sockets
• Developed Net Collector (Java based SNMP and telnet data collection tool for Net Audits) from idea stage to a successful product deployed to over 1000 customers
• Drove continued Operational Excellence by achieving 99.99% availability for over 100 Oracle 11g and SQL Server databases
• Ported public and custom applications to secure, regulated environments; collaborated between orginizations to make perl modifications under a single code base
• Reduced complexity, cost, and improved quality of ipv6 assessments by reducing the number of rules from 500,000 to 300.
• Researched, planned, communicated, and implemented upgrades, security patches; automated common tasks, and backed up all SQL and Oracle databases
• Used Transparent Data Encryption, Oracle wallets, Oracle Identity Management, Enterprise Manager, Data Guard, and Database Vault to manage highly sensitive data
• Developed director level reports for monitoring usage of products using Crystal Reports and Business Objects
• Created regular expression based OO Perl parser for extracting data from 100s of complex IOS CLI commands into a database, while reducing time to process from 24+ hours to 1 hour, time to code from 2 days to 2 hours with automatic detection of new patterns
• Migrated database from flat files to MS Access, and Oracle 8 through Oracle 11g
• Introduced and migrated developers to Oracle, XML, Toad, VSS, and Windows/MS Office
• Designed flexible XML specification for data collection