Became a Subject Matter Expert in Product/Systems Integrations and Functionality• Developed various ETL scripts to pull from multiple diverse data platforms• Wrote various reports that were used to direct efforts of multiple departments• Wrote monitoring scripts for various processes• Performed statistical analysis of Television and Software behavior• Discovered multiple hidden and unexpected behaviors for both internal and 3rd party dataproviders• Directed/Advised our ETL and Reporting Teams on what they needed to build• Worked with Data Science teams to direct areas that needed additional investigation• Mentored colleagues in Data/Database methodologies• Administered 87+ 3-10 Node Cassandra Clusters• Administered 87+ 3 Node Redis Clusters• Administered 9+ Mongo Databases• Sharded Production Mongo Cluster• Administered 8+ Node Elasticsearch Cluster• Administered 3+ MySQL Databases (RDS)• Administered 5+ PostgreSQL Databases (RDS)• Administered Graphite Database

Investigate, install and develop proof of concept against various Database Platforms including Cassandra, Mongo, and Redis.Design and implement Data models from conceptual to physical modeling for extensibility and scalability. Design and code continuous "real time" ETL streams to integrate various OLTP systems.Architect restful micro-services including endpoints and sequencing of events.Develop and update Tech plans, and technical requirements for development teams.Work with project managers and team leads to refine iteration scope.Provide data driven input to help prioritize development effort.Assist Development teams in meeting aggressive timelines.Use various programming and scripting languages to support various projects including Java, Python, PL/SQL and various flavors of shell scripting.Work with partnering businesses and with vendors to determine opportunities for growth and cost savings.

My team maintains 99.999% uptime on our production database supporting one of the largest online retail websitesI lead all efforts in tightening database security --Researching Oracle and 3rd party security software --Planning Database security initiatives and roadmaps --Acting as a liaison to the IT security team --Suggesting improvements to database related internal controlsI troubleshoot and maintain Oracle GoldengateI helped implement our datamasking initiative in non-prod environmentsI help maintain OIDI Support multiple dev teams by reviewing and approving PL/SQL and DDL changesI use Oracle Dataguard to maintain several physical and logical standby databasesI assist in maintaining Weblogic and Oracle JMS queues

•Administered 50+ Databases most of which were 1+ TB in size. Oracle versions included 10g and 11g•Lead a small team of Senior Database engineers supporting two global banking systems 24/7.•Implemented GIT as a documentation and script version control for database team.•Trained 35+ ICS engineers in SQL Tuning and Explain Plans.•Presented in an organization wide database security conference.•Upgraded multiple 10g RAC databases to 11g.•Migrated Databases to Exadata and administered 2 database machines.•Participated in proof of concept for Exadata and provided a cost/benefit analysis.•Used RMAN to clone databases reducing errors and hours spent on this task dramatically.•Provided database support for third party software upgrades including Business Objects and HP Application Lifecycle Module.•Consulted with QA and Dev Teams to improve testing ability.•Approved scripts to be run against project’s production databases.•Lead project opinions regarding data and integration decisions.•Approves all changes to the data model of project’s application.•Correct data integrity problems caused by any application bugs.•Performance Tunes queries providing dramatic difference in the speed of reporting.•Advised developers on SQL and Database related questions.•Lead the Database deployments to production.•Resolved issues resulting from poor management of incorrect/conflicting scripts by creating a process for script approvals that raised visibility of the scripts to the QA manager, and eliminated the problem completely. •Gathered requirements, Designed process, and wrote scripts for validating data conversion ETL jobs transformed and loaded the data.•Found and implemented a performance solution to validate constraints three times faster than scheduled. This compensated for an unexpected 11 hour delay in data conversion.•Worked with Hotsos consultant in tuning queries.•Re-partitioned large tables to improve performance dramatically.

•Facilitated more than $150,000 custom-orders revenue monthly by finding requested parts, estimating landed cost, ordering materials, and communicating delivery information.•Helped make possible $320,000 annual sales to referred customers by resolving problems with customer’s orders & deliveries to maintain high referral rate and customer retention.•Added value to customer experience and saved $6,000-$15,000 monthly opportunity cost per salesman by adding weight field to inventory module and by appending invoice-template to calculate line item and total order weight. Previous to this improvement weight calculation was done by salesmen as needed per invoice.•Saved $2,000 monthly purchasing time by creating purchasing focus queries & reports and by creating/updating po# macros in Excel. Reports include: Cut-Stock, Stock-Check, Warehouse Receiving, Under-Stock, and Min/Max reports.•Saved accounting department more than $750 per month by creating custom reports, by advising in Cougar Mountain (ERP) upgrade, and by creating a system of backup up tables to allow data retention when module history was scheduled to be purged. Custom reports included a query to find all Cash/COD customers to turn off charge on account capability. •Reduced sales errors and GP loss by implementing Bar-Coding process & equipment.•Maintained over 4,000 inventory SKU’s