Jan 2014 – Feb 2016 · 2 yrs 1 mo · San Jose, CA

• Technical lead - helping and mentoring local and offshore team members with all things SQL, PL/SQL and Oracle performance related in VLDB (multi-terabyte) databases.
• Database performance – Diagnosing and fixing poorly performing SQL. Monitoring processing in OEM and reviewing AWR reports to find performance bottlenecks. Finding and correcting poorly structured indexes and creating new indexes as needed to improve query speed.
• Identify tables which are causing performance problems. This includes partitioning, compression, inefficient parameters, and improperly gathered statistics. Create scripts for development team to fix the issues.
• PL/SQL development and performance tuning – Writing new code and identifying and analyzing poorly performing code. Rewrite or give recommendations to development team.
• Automated database statistics gathering, index monitoring, performance alerts.
• Identify and recommend new features in 12C which would be beneficial to our processes.
• Created standards and best practices for SQL and pl/sql.
• Presented PL/SQL performance training classes for team.
• Agile – utilize Agile development methodologies.
• Working closely with offshore team for software releases using Jenkins and custom release code, and 24-7 production support as needed.
• Cassandra POC - installed, configured clusters, NoSql schema design, migrated data from Oracle DB using sqoop, sstableloader, Spark.
• Technologies –
• Oracle 12C, 11g RAC, SQL, PL/SQL (triggers, packages, stored procedures), AWR reports, OEM,
• trace, SQL optimizer, PL/SQL hierarchical profiler, partitioning, compression, materialized views, IOT, SQL*Loader, Data Pump, TOAD.
• Cassandra - DataStax Enterprise 4.7, sqoop, Spark, data modeling.

Jan 2011 – Nov 2013 · 2 yrs 10 mos · Sunnyvale, CA

• External Reporting – development of facts, dimensions, ETL for existing advertiser, network and publisher data marts.
• Advertiser Insights – development of new reporting solution for advertisers, networks, and publishers.
• Data quality – automated process to compare data across multiple reporting systems to proactively find issues and validate data.
• Agile – adopted Agile development methodologies.
• Working closely with internal customers and support engineers to quickly resolve production reporting issues. Tracing data discrepancies from reports to source grid data feeds to determine root cause.
• Wrote Pig scripts to compare counts in Hadoop against Oracle Data Warehouse.
• Technologies
• Oracle 11g RAC, VLDB (multi-terabyte) database, SQL, PL/SQL (triggers, stored procedures), partitioning, external tables, IOT, SQL*Loader, Python, Pig, Hive, TOAD.

Sep 2008 – Dec 2010 · 2 yrs 3 mos · San Jose, CA

• Data Modeling - designed and created data structures for enterprise pricing solution for implementation of Vistaar pricing analytics software used to analyze base to net and list to net waterfall for uplift, contractual, promotional, trade in, non standard, and net based discounts.
• ETL – created and maintained all Oracle ETL code using SQL, PL/SQL and shell scripts. Extracted data from Deals Management, Rebates, POS, Claims, Trade-In, and Bookings. Source of data was Oracle 9i, 10g databases and CSV files.
• Performance tuning – responsible for tuning of all team member’s SQL and PL/SQL, and any partitioning and indexing changes needed.
• Technologies
• Oracle 9i, 10g, 10g RAC, SQL, PL/SQL (triggers, stored procedures), partitioning, IOT, SQL*Loader
• Teradata 12, Informatica 8.6, UNIX, Excel (Pivot tables, macros), shell scripting, TOAD.

Feb 2007 – Jun 2008 · 1 yr 4 mos · Sunnyvale, CA

• Designed and created Global Data Warehouse for Support, Manufacturing, Sales, Marketing, and Finance using data from Siebel Service, Oracle OM, and Salesforce.com.
• Support metrics – created process and reports for monitoring service requests, customer surveys, and support performance.
• Created Opportunity reporting system for Marketing and Sales to identify which customers to target for refresh and/or up selling.
• Manufacturing metrics – worked with manufacturing team to setup the DOA, ELF and other metrics they needed to monitor our hardware quality and the performance of third party service providers,
• Implemented new version of database level security for warehouse to control access using sales territories and sales rep hierarchy.
• Technologies
• Oracle 9i, 10g, materialized views, IOT, SQL*Loader, change data capture, Oracle Applications 11i (11.5.10),
• Siebel 7.8, SQL, PL/SQL (triggers, stored procedures), Oracle Discoverer (4,4i,10g), UNIX,
• Excel (Pivot tables, macros), shell scripting, TOAD, MySQL 5.1

Apr 2002 – Nov 2006 · 4 yrs 7 mos · Los Gatos, CA

• Designed and created new Revenue Sharing system on Oracle 8i/9i which tracks and calculates amounts due to studios based on rental activity and each studio’s contract terms. Used stored procedures, triggers, materialized views, partitioning, and shell scripts to extract data from shipping system into the data warehouse.
• Data Modeling – designed, created and maintained star schema for Revenue Sharing system’s facts and dimensions using Kimball’s dimensional modeling methodology.
• Designed and created process to estimate monthly write-off of prepaid expense for controller and auditors. Projection based on individual movie performance to date and historical demand curve. Reports showed over/under performance by title and JE's to adjust prepaid GL balance each month.
• Extensive performance tuning using hints and explain plan in a multi-terabyte data warehouse with tables having over 600 million rows.
• Rapid implementation of enhancements side to satisfy constantly evolving business requirements.
• Moved existing Revenue Sharing process off of front-end systems allowing much faster processing of shipments and greater complexity of contracts with studios.
• Created custom monthly reports for each studio using in house Perl report generator.
• Worked with server group to create automated reporting system allowing studios to download their monthly reports via extranet.
• Implementation of SOX compliance for existing system.
• Supported controller, finance team, content group, external auditors with ad-hoc requests and analysis.
• ETL – created and maintained all ETL code using SQL, PL/SQL and shell scripts.
• Technologies
• Oracle 8i, 9i, materialized views, change data capture, partitioning, IOT, SQL*Loader, Oracle Applications 11i (11.5.1),
• Oracle Designer 6, SQL, PL/SQL (triggers, stored procedures) UNIX, Linux,
• Excel (Pivot tables, macros), shell scripting, Perl, TOAD.

Jan 2000 – Mar 2002 · 2 yrs 2 mos · Redwood Shores, CA

• Migrated BIS Discoverer content from Release 3i to 4i. Enhanced and tuned the views and Discoverer content for AP, AR, CE, FA, GL, PA and XTR.
• Support Oracle IT team and customers with OLTP and Discoverer reporting.
• Handled all performance issues and enhancement requests for BIS reporting.
• Upgraded most of the BIS Oracle Reports to new Performance Management reporting technology. Many of the reports had to be completely rewritten due to performance issues.
• Assist in design and enhancements for Enterprise Data Warehouse for Financial Intelligence.
• Prepared a gap analysis for Oracle IT to determine if the new warehouse would satisfy the reporting done in the America's Data Mart.
• Technologies
• Oracle 8 &,8i, materialized views, change data capture, Oracle Designer 6,
• Oracle Discoverer 3i & 4i Admin and EUL, Oracle Applications 11 & 11i (11.5),
• Warehouse Builder, SQL, PL/SQL.
• PL/SQL (triggers, stored procedures), SQL Loader, UNIX, shell scripting, TOAD.

Jul 1997 – Jan 2000 · 2 yrs 6 mos · Redwood Shores, CA

• Created dynamic web reports using PL/SQL and Javascript allowing users to easily get the data they needed. Reports could be viewed or exported to Excel.
• Created star schema data models for data mart tables using Kimball dimensional modeling techniques.
• Rewrote and tuned the existing extract programs. Reduced the load time by hours while increasing the reporting capability with increased data integrity. Automated the extract processes and created email status reports.
• Migrated the data mart from Release 11 to 11i of Oracle Applications.
• Technologies
• Oracle 7, 8, 8i, materialized views, change data capture, Oracle Designer 2,
• Oracle Discoverer 3, SQL, PL/SQL (triggers, stored procedures), SQL*Loader, UNIX,
• Excel (Pivot tables, macros), shell scripting, Perl, TOAD.

Jan 1995 – May 1997 · 2 yrs 4 mos · Campbell, CA

Jul 1980 – Jul 1987 · 7 yrs · Ypsilanti, Michigan

• State Licensed Automotive Master Mechanic.
• Diagnosis and repairs of Datsun, Nissan, Buick, GMC vehicles.
• Experienced A/C, tune up, brakes, engine repair. Specializing in electrical and drivability issues.