Primary Technical Lead and subject matter expert for a multi-system Dev team, coordinating development and technical support for a multi-terabyte data warehouse.• Developed and implemented a multi-phased Oracle DB performance enhancement strategy, transforming batch job run time from 12+ hours down to 3.5 hours• Leveraged the following tools to achieve performance goals:◦ monitoring queries and reading explain plans◦ query tuning/rewriting using advanced techniques (i.e. inline views, WITH clauses)◦ PL/SQL tuning (context switching, bulk collect, etc.)◦ table and index partitioning and compression◦ tuning parallelism (multiple modes)◦ index tuning - adding/modifying/deleting◦ OLAP bitmap indexing◦ result cache implementation◦ table shrink to regain allocated empty blocks and reduce inefficient FTS◦ SQL Profiles◦ PGA/SGA allocation tuning◦ hardware upgrade/optimization◦ dbms_redefinition – removing legacy data types, encrypting 500GB+ tables◦ converting legacy analyze to dbms_stats◦ reduced dynamic SQL blocks in UNIX ksh scripts◦ reading AWR and other reports to identify bottlenecks◦ made new parameters table-driven to reduce deployment time for changes• Wrote a batch of queries for all team developers to use for diagnosing database issues such as blocking locks, px queuing, FTS of extremely large tables• Created a custom alarming module to look for problematic conditions and promptly email alerts

Led the development and all production support, responding to all customer inquiries for a company-wide configuration management system. Sought by and matrixed to additional teams for Oracle expertise.• Reverse-engineered the hierarchy of a 100+ table OLTP schema and developed a conversion script to migrate data from multiple duplicate schemas to a central, schema, including conversion of deprecated data types (LONG RAW to CLOB)• Retooled a GUI connection protocol to reduce user login times from 2+ min down to less than 10 seconds• Leveraged dbms_redefinition for a large scale encryption and conversion of legacy data types• Developed a new view-based custom reporting module to tighten database security and access to cross-project data• Performed multiple Application STIG security reviews, producing artifacts and creating new System Change requests to track development to address findings

Performed intricate software design and development for several mission critical systems. Held multiple development roles including lead responsibilities for a critical auditing application.• Performed a key role as design lead, technical subject matter expert and developer for a brand new application leveraging superior problem solving skills in order to deliver the new system under high pressure with an extremely aggressive schedule• Specialized in writing complex queries and customizing their explain plans for maximum performance including use of parallelism and tuning hints• Worked in a team environment assisting with debugging, critical design reviews, unit testing, system testing, assessing compliance with information assurance audits and helping improve processes in accordance with industry standards• Received multiple nominations and awards for work including 5 nominations for employee of the quarter, winning runner-up twice and also winning 5 specialized awards• Leveraged advanced Oracle 10g and 11i PL/SQL programming concepts including Packages (Procedures and Functions), Views, Materialized Views (Snapshots), Inline Views, Triggers, Functions, Tuning Hints, Capacity Analysis, Execution Plans, Performance Tuning• Volunteered to take on the code base for an Access/VBA system for Annual Records Review, having no prior experience with the language; completely overhauled the code, providing a 500% reduction in processing time for key components• Leveraged exceptional oral communication skills to work with primary Accounting Requirements customers to refine system performance, documenting new technical requirements and identifying all programming instructions, inputs and outputs to assist with the transition of the system from a Microsoft Access/VBA platform to an existing Air Force system

Coordinated high profile software upgrades for the Asset Management division. Collaborated with Technical leads to promote flexible design strategies. Cultivated solid relationships with business clients and mentored onshore and offshore development staff.• Designed and wrote intricate solutions for Extract, Transform and Load (ETL) database processes, handling extracts from multiple platforms including OLAP data warehouse environments• Analyzed and planned for anticipated changes in data capacity and performance requirements - assisted with multiple table designs• Led successful deployment of a customer-facing website, www.jpmorganfunds.com, a public facing website using policies, principles and practices associated with information security/information assurance• Recognized as the subject matter expert for the content management system (CMS) platform, giving business clients the ability to make real-time site content changes

Recruited to join the Business Intelligence team as an expert with customer data for the Northeast, Midwest and Southern regions. The warehouse data was fed to a front-end dashboard used directly by company top executives.- Developed complex SQL for data research and extraction- Worked with senior technical staff to design extractions for future implementations

Led a diverse team responsible for development of four critical order entry and CRM systems. Implemented cost saving solutions using multiple SDLC methodologies, including waterfall and agile (eXtreme Programming). Served as point liaison and developer for key data migrations and legal requests.- Guided staff through replacement of 2 legacy user interfaces leveraging current state of the art technologies- Led implementation of new processes which yielded 70% reduction in processing time for a crucial order processing system- Conducted application testing for the company's first undertaking of Sarbanes-Oxley verification, passing all external audits- Developed and implemented data migration scripts for 2 consolidation projects, allowing retirement of multiple billing systems- Served as the legal department's “go-to” person for customer data inquiries, giving depositions and testimony to support data results

Served as the primary conduit between IT development staff and business clients. Gave 24x7 support to the company’s customer service applications with a base of 2,000+ users. Recognized as a company-wide authority for residential customer data.- Increased system stability by performing data scrubs on identified anomalies- Designed and implemented custom screens and applications to accommodate internal clients needs for ad hoc data requests