Database and application developer and support person

Sr. Applications Engineer @ From April 2014 to Present (1 year 9 months) Production Applications Engineer @ Provided application support for SaaS email marketing application • Reviewed Oracle database queries and improved performance via index creation and statistics gathering. • Eliminated out of memory errors by configuring jvm heap size and garbage collection parameters • Configured Apache web servers for http redirection and load balancing utilizing mod_jk and mod_proxy technologies • Worked with Engineering team to identify bugs and identify solutions • Documented and improved production infrastructure processes such as system maintenance, application upgrades and sever deployment • Trained and mentored new team members • Setup and configured application monitoring tools via third party tools such as zabbix and also through bash shell scripts and linux crontab • Setup DNS entries for UI and web services endpoints Participated in Application Infrastructure projects • Performed routine application upgrade • Worked closely with Systems Operations and Build Out teams in hardware upgrades • Validated and deployed new tomcat application servers • Worked across functional teams in consolidating application environments From July 2011 to March 2014 (2 years 9 months) Programmer Analyst @ Served as main analyst, developer and administrator for ServiceTrak (proprietary shop floor application and database system) • Added features to ServiceTrak using MS Access and VBA for easier inventory tracking, cycle counting and process control • Conducted performance tuning by implementing indexes on frequently used columns on tables • Maintained Business Objects Universes for users to build custom reports to obtain shop floor data more efficiently • Built specialized reports for internal users as well as customers by creating T-SQL views and stored procedures • Created automatic ETL jobs using SQL Server Agent, DTS and SSIS to submit data to customers as well as update incoming data originating from customers • Participated in SQL Server upgrade (from SQL Server 7 to SQL Server 2005) and data migration – Converted DTS jobs to SSIS Served as developer for new version of FlexFlow (proprietary shop floor application and database system) • Participated in development of database schema for Global Services business segment • Built features to application for the Global Services segment with C#.NET, WPF, XAML From March 2007 to June 2011 (4 years 4 months) Process Engineer @ • Designed and built processes for sub assembly and assembly repair by creating shop floor controls and implementation • Created and maintained repair processes to ensure product quality and accurate data reporting • Reduced paper waste of repair process by eliminating repair travelers • Built custom internal and external data reports with Business Objects for quality and inventory purposes • Generated internal ECOs to source material for repair process • Served as main engineering contact for two OEM customer accounts • Worked across functional teams to resolve issues relating to product quality, handling time and customer satisfaction • Worked closely with other Process and Test Engineers within customer accounts to close various engineering issues • Served as back up for Program Manager when needed From December 2005 to March 2007 (1 year 4 months)

BS, Computer Engineering @ University of California, Irvine From 1998 to 2002 Jeffrey Lee is skilled in: Oracle, Tomcat, MySQL, Microsoft SQL Server, CentOS, Linux, Apache, Databases, SQL Tuning, Data Warehousing, Database Performance Tuning, SaaS appliction support, jvm tuning, Shell Scripting, DNS