Intensive 2nd year summer course, Japanese @
University of Michigan
Relational database expert, specializing in Oracle and data warehousing, and skilled Perl and Unix shell programmer. Self-starter with strong work-ethic and committment to delivering the end product on time and with the highest degree of detail. Work extremely well independently or as a key player in a team. Proven track record of quickly and competently developing new
Relational database expert, specializing in Oracle and data warehousing, and skilled Perl and Unix shell programmer. Self-starter with strong work-ethic and committment to delivering the end product on time and with the highest degree of detail. Work extremely well independently or as a key player in a team. Proven track record of quickly and competently developing new skills, learning computer languages, and understanding conceptual frameworks. Strong organizational, communication, and teaching skills. Excellent ability to analyze a problem, break it into components, understand the implications of various solutions, and implement the best solution.
Complex SQL & DDL design for RDBMS in a Unix based Oracle environment (8i, 9i, 10g)
PL/SQL, ETL, performance tuning, sqlldr, sqlplus, Perl DBI, TOAD
Familiarity with sed, awk, C, C++, Java, PHP
Non-SQL file-based data aggregation
zsh and bash on Linux/Solaris
Fluent in spoken Japanese w/ strong reading and writing skills
Sr. Software Development Engineer (Sales Tools) @ Responsible for upgrading and maintaining framework for aggregating advertiser and sales data from Hadoop data store and delivering it to downstream databases and systems, using Pig, Oozie, Hadoop, UNIX shell scripting, Perl, mod_perl, and XML technologies, among others. Design and maintain structure of MySQL databases where the data is ultimately stored and consumed to internal sales tools which automate tasks for and support Yahoo!'s sales force for the combined Yahoo! and Bing search marketplace. From July 2011 to Present (4 years 4 months) Burbank, CaliforniaSr. Software Development Engineer - Business Information Group @ From October 2007 to June 2011 (3 years 9 months) Burbank, CaliforniaSenior Data Warehouse Engineer @ From April 2006 to October 2007 (1 year 7 months) Senior Data Warehouse Developer @ (duplicate of Snap position) From April 2006 to October 2007 (1 year 7 months) Senior Database Developer @ Led the migration of over 900 reports and jobs from legacy data warehouse to new data marts along with a major change in business logic.
Took the lead for the reporting team on development of non-SQL based aggregations using Perl and shell script based frameworks. Built numerous very large (yet scalable) aggregated tables using these methods.
Provided consistent, timely, and accurate adhoc support for a variety of business groups, most notably Content Solutions, Customer Services, Product Management, Business Planning, and various departments in the Tokyo office.
Primary point of contact for all legal related reporting requests, delivering data both for internal litigation needs and 3rd party subpoenas under strict deadlines.
Mentored new hires to the reporting group. From June 2004 to April 2006 (1 year 11 months) Senior Database Developer @ (renamed to Yahoo! Search Marketing) From September 2003 to June 2004 (10 months) Senior Database Developer @ (acquired by Yahoo!)
Developed various near real-time tools to monitor hourly revenue by affiliate partner implementation, hourly revenue for various matching technologies, and potential negative advertiser affects of new matching technologies.
Took the lead on understanding and internalizing various new product initiatives throughout the company, most of which ultimately affect reporting and the numbers our internal and external customers need to see. Distributed that information to the rest of the group.
Successfully managed transition to the Tokyo office where I was the single first point of contact for all data related requests. Handled this primarily in the Japanese language. From October 2001 to September 2003 (2 years) Database Developer @ (renamed to Overture Services)
Rescued an ailing implementation of Gotos LWES (light-weight event system) based data capture system for Goto Shopping, producing reliable data feeds, relevant aggregations, and end user reports.
Took the development lead on both adhoc and published reports for Overtures proprietary advertiser editorial and customer relationship systems. In the absence of documentation, this often involved reverse engineering the data present in the database in order to meet customer requirements. As a result turned a damaged relationship between the end reporting users for these systems into happy customers of the reporting group. From October 2000 to October 2001 (1 year 1 month) Engineer @ Led design and implemented API and XML interface for three-tier architecture, using mod_perl, XML, and Java.
Played integral role in coding team for database migration to Oracle, migrating many complex queries and modules dealing with the database from Perl DBI to a software database layer.
Wrote technical specifications and implemented new features for web site application.
Determined specifications, coded, and tested reporting, fraud detection, and database maintenance scripts.
Developed and maintained major features of customer support tool web interface.
Maintained MySQL database integrity, performed emergency data restoration, and executed manual updates to meet customer support requests.
Trained engineers in Dublin, Ireland office on use of Knowledge Adventure software engines and integration of products.
Products localized include 3D-Body Adventure, My First Encyclopedia, Aviation Adventure, Spider-Man Cartoon Maker, Steven Spielbergs Directors Chair, and JumpStart Pre-K and Kindergarten. From July 1994 to December 1997 (3 years 6 months)