Career Objective
oA software engineer with background in data analytics, data science, and backend software development within finance, retail, and social media
oSpecializes in data query, manipulation, validation, calculation, and visualization on top of process design and optimization.
Education
oUniversity of California, Berkeley: College of Chemistry and College of Letter and Sciences [Aug. 2011 to Aug. 2016]
Job Experience
B.A in Applied Mathematics (Numerical Analysis) and B.S in Chemistry (Polymer Science)
GPA: 3.128 (3.3 Mathematics, 3.00 Chemistry)
oAssociate Strategy Execution & QC Data Engineer at Lending Club [Aug 2018 to Now]
Developed applications and systems for audit tools, databases, reports, and dashboards stretching across multiple platforms
Owned the planning, development, testing, implementation, documentation, and on-going maintenance of complex Python programs on AWS servers
Added additional technology and applications (HIVE/PRESTO/SPARK) to shorten the deployment process for every deployment.
Supported the technology infrastructure design, promotion, and implementation of quality control workflow changes and strategic initiatives.
Fixed and maintained a complex TABLEAU dashboard that displayed the categorically organized investment returns for the investors.
Led the day-to-day work streams of multiple technical resources and SQL schemas and databases
Assisted in implementing and providing quality control of multiple A/B tests done over strategy and pricing of products.
Singlehandedly developed and deployed an entire company product in a week, replacing the 3-month work of an entire offshore team.
Provided technical support for business partnerships with mutual funds and trusts in million-dollar revenue contracts.
Provided in-depth detail correction for company’s pricing and strategy policies represented by network of SAS and JAVA scripts
Ran in-depth root cause analysis on the discrepancies of thousands of inconsistencies amongst multiple production teams
oData Scientist/Optimization Specialist/Process Manager at Gap Inc [June 2017 to Aug 2018]
Optimized the processing of big retail data from five continents
Mined, complied, and managed data from multiple sources into one flexible mega-source for the entire corporation
Performed and created complex SQL Macros to be automated daily in SAS codes for greater efficiency
Created powerful python scripts combined with SAS and batch files for machine learning, data compiling, script automation, etc at many levels of data for financial reports and data model updates.
Singlehandedly designed a data mining/organization system that compiles data from rival companies and other sources and employed machine learning to develop a app from ground up
Completely overhauled and updated an internalized data validation flagging system to validate data at many different fields and levels with complex logic systems and email notification systems.
Designed and constructed a complete ETL-report creation process connecting Teradata tables, Python and SAS scripts with bash shell scripts and cron jobs.
Ran the entire pre-season analytics for the corporation and all of its subsidiaries at a seasonal pace.
Started an app development which included the use of Google API and Google Cloud
oDigital Marketing Analyst at Adobe Systems [May 2017 to June 2017]
Analyzed smart, programmatic advertisement data across thousands of channels to create a digital landscape of audience interests and their hidden overlaps
Provided valuable insight of audience’s changing behavior and activity trends based on seasonality, fashion, popular topics, etc
Created and automated processes for performing optimization of topics and trends and creation of reports for Adobe and its clients
oDatabase Analyst III at Well Fargo [Nov.2016 to April 14. 2017]
Supported ATM Advertising in ensuring ATM campaigns are set-up and staged.
Created Tableau dashboard with highly complex and manipulated data sets.
Singlehandedly designed and created high-quality, universally adaptable databases and data functions for company use
Responsible for developing business requirements and translating business needs into moderately complex analyses and projects for a department or functional area.
Performed complex SQL queries analysis of findings using statistical and/or financial analysis, modeling, process documentation, etc.
Compiled and mined data from multiple, cross business sources
Developed specific, customized reports and ad hoc analyses to make recommendations for alternative solutions.
Provided guidance to less experienced specialists and consultants on data processes and integration
Created powerful python scripts and VBA Macros to greatly expedite data manipulation, organization, validation, and project processes
Created large databases on servers such as Microsoft Access and Tableau
Automated and streamlined business and ATM execution processes
o4+ years experience in data analytics and high volume-calculations in a laboratory, business, and corporate environment
oStrong background in applied mathematics and computer science (4+ years)
Especially strong in statistics, multivariable calculus, numerical analysis, interpolation, approximation
Performed research in various disciplines (social media, banking, business, credit info)
o5+ years experience in multiple computer languages and skills
Python/Scheme/Matlab/SQL/JAVASCRIPT/R/SAS
MS VBA/Macros
UNIX/LINUX
HTML/CSS
o5+ years experience in Microsoft Word, Excel, Power Point, Keynote, Google Docs, InfoPath, Sharepoint, Macgyver, Jenkins, Github POST
o3+ years experience in Tableau Desktop. 2+ Year experience in SQL associated with Oracle and Teradata