Software Engineer, tech lead

Quan Zhang

ac1fd6@r.postjobfree.com 281-***-****

**** **** *****, *** ***, San Jose, CA 95125

EXPERIENCE

General Motors – Software Engineer, Tech Lead/Lead Developer; Austin, TX Sep 2013 – Present

Led four-person team and managed tech side of GM adoption of Siemens Teamcenter Product Cost Management (TcPCM), an off-the-shelf cost management software; resulting Annualized Direct Business Benefit of over $15 million

Implemented custom SQL and Excel reports, crafted queries joining up to 79 different tables in a SQL Server database with over 800 tables for reporting purposes, as well as custom PL/SQL functions to facilitate quality control tasks and deliver functionality in reports; created custom Excel reports that extracts and exports raw data from app and database into various proprietary reports used by GM to estimate tool and part costs; improving efficiency by 75%

Developed new features for Materials Purchasing Reporting, using Java connected to Oracle database with JavaScript/KendoUI front-end and utilizing Spring Web Services and Struts2 Framework; resulting Annualized Direct Business Benefit of $5 million

Delivered 23 user stories, implemented large scale functionality to identify threats/opportunities from changing costs in raw materials; enabling business users to identify threats/opportunities from year-over-year difference in old and new price of parts

Initiated standardization and simplification of application deployment for WebLogic-based applications using Jenkins, improving turnaround time by 110%

Investigated back-end database based on front-end descriptions to support QA and business users, reducing delivery time by 17%

Led daily stand-up meetings to track tasks and delivery, scheduled working sessions and meetings as needed with business and Siemens resources

Developed deployment process for IIS-based COTS product using Web Farm framework, standardizing new release process and reducing deployment time by 65%

Investigated Mockito to facilitate unit testing and Spring Web Services to upgrade from Struts2 framework, both currently used

Subject Matter Expert for IIS and WebLogic application deployment framework, provided on-call troubleshooting

PricewaterhouseCoopers – Forensic Technology, Experienced Associate; Houston, TX Aug 2011 – Sep 2013

Developed various SQL scripts to assist PwC and client teams in various tasks, including rectifying IRS tax adjustments totaling up to $1 billion, creating a custom stored procedure to check large number lists for valid South Korean ID numbers, and other custom queries using string matching and regular expressions for data search

Subject Matter Expert for data extraction from various ERP systems, including Hyperion, John D. Edwards, and Corptax

Reverse-engineered a set of complicated Excel models to calculate royalty fees and costs between client’s worldwide branches after their creator had already left the company. Created documentation for these models to facilitate transition to client employees. Improved said models by adding automation, resulting in 38% faster runtime

Built various Excel VBA macros for PwC Tax team, removing need for manual data transformations, and provided quick turnaround when additional macro requirements were identified, reducing tax team delivery time by 67%

Performed forensic analysis of laptops, servers, and Blackberry hard drives, restored deleted files and folders from images taken using EnCase. Extracted existing and deleted emails using iConect, improving core forensics team efficiency by 43%

EDUCATION

University of Texas at Austin, BBA, Fall 2007 – Spring 2011

Major: Management Information Systems, Minor: International Business, semester abroad at Shanghai Jiao Tong University

SKILLS AND CAPABILITIES

Databases - MS SQL Server, Oracle, MS Access; SQL scripting for both Microsoft and Oracle

Programming/web design – Java, JavaScript, VBA, Kendo, JQuery, JSON, AJAX, C#, .NET, CSS, Android Mobile

Design/planning methodologies – Spring MVC, Struts2, JUnit, Mockito, Agile, Waterfall

Configurations Management – Oracle WebLogic framework, Microsoft IIS and Web Farm framework, Jenkins, Ant, SVN

Data visualization/reporting – Google Analytics, Excel (base and VBA/Macros)

Forensic / E-Discovery Tools - EnCase Forensic, iConect E-Review tools, Trident Email Recovery

ERP/PLM/Reporting systems: Siemens Teamcenter Product Cost Management, Hyperion, JD Edwards

Operating Systems - Microsoft DOS and Windows/NT based platforms, Linux

ADDITIONAL

TeamGM Contribution – recognized in 2013, 2015, and 2017 for outstanding contribution to GM’s mission

Foreign Languages: Chinese (fluent), Spanish (conversational)

Work eligibility: Eligible to work in the US with no restrictions

Contact this candidate