SUMMARY:

• Highly driven and successful analyst and developer with a proven track record and reputation for achieving results in Operations.
• Possess a unique combination of analytical and leaderships skills, with excellent organization and prioritization abilities.

TECHNICAL SKILLS:

• Oracle database
• Informatica
• UNIX and LINUX servers
• Cloudera Hadoop
• Datalake
• Hive
• Spark
• Hive
• Weblogic
• Microstrategy
• Media Maestro
• NoSQL
• Kafka
• Hadoop File System - HDFS
• Sqoop
• MongoDB

PROFESSIONAL EXPERIENCE:

Confidential, El Segundo, CA

Senior Specialist

Responsibilities:

• Lead meeting with business stakeholders to provide weekly status updates on production issues
• Recommend solutions to resolve production issues.
• On call production support for weekly batch processing.
• Lead troubleshooting meetings with database administrators, UNIX system administrators, developers, analysts to resolve critical production issues.
• Write SQL scripts to resolve data issues.
• Analyze PL/SQL procedures to determine root cause of breakages.
• Engage with upstream systems support to resolve issues with data migration.
• Troubleshoot and interact heavily with end users to resolve issues that they have in using the systems.
• Manage and mentor off shore team.
• Resolve over 400 incident tickets per year related to batch processing job failures, user issue requests, and research tickets.
• Perform Oracle database tuning by:
• Tune access to code in the System Global Area (SGA)
• Optimize SQL by analyzing
• Explain Plans
• SQL Trace
• TKPROF
• DBMS SQLTUNE
• Optimize PL/SQL by analyzing
• DBMS PROFILER
• DBMS HPROF
• Perform package-based, table based, function result
• Check for and utilize the best aggressive compiler optimization level
• Write or rewrite applications with best practices analyze and standards using the 11g features:
• BULK COLLECT
• RETURNING
• FORALL
• NOCOPY
• Analyze application execution profiles
• Tune algorithms
• Take advantage of any PL/SQL specific performance features
• Balance performance improvements against memory consumption
• Performing timing tests to determine how much efficiency has been gained
• Test code to check for future possible performance issues once data grows from a few rows to millions of rows
• Perform table partitioning

Confidential, El Segundo, CA

Senior Problem Management Analyst

Responsibilities:

• Financial, Crediting, and Tactical Application Issues Management Senior Problem Management Analyst
• Investigate root cause of incidents and recommend solutions to resolve issues for Enterprise Payment System
• Provide consultation for Development and Business Analyst teams on how to be proactive about preventing incidents from reoccurring
• Subject matter expert in Oracle

Oracle Lead Programmer Analyst

Confidential, Pasadena, CA

Responsibilities:

• Medicare Business Engine Production Support Department Oracle and Java Financials Technical Lead Contractor Lead developer in 24/7 Production Support environment
• Use Tivoli Work Scheduler to run batch jobs
• Create stored procedures.
• Troubleshoot issues occurring between data transmission from Oracle database to Web Server
• Perform project management duties of estimating level of effort, creating execution plans, unit testing code development, work with testing teams to test data in UAT environment, perform data migration duties between environments, create SOX documentation for compliance.
• Create work orders and change requests in BMC Remedy 7.6 to schedule code deployment.
• Use StarTeam and IBM Rational Team Concert for version control and code migration.
• Manage team of onshore and offshore developers and provide technical assistance in creating summary and action plans to properly develop a solution to the code.
• Extensive technical knowledge in Medicare and health care business processes.
• Report production defects with HP Quality Center 10.0

Oracle Technical Lead

Confidential, Sunnyvale, CA

Responsibilities:

• Manage offshore development team supporting Oracle Applications Manufacturing
• Design custom APEX development using Oracle APEX 4.1
• Develop advanced charts to replace Microsoft Access and Microsoft Excel reports
• Develop Interactive Reports
• Develop BI Publisher reports
• Modify existing APEX pages to enhance features
• Write JavaScript functions to enhance APEX performance beyond default parameters

Confidential, Quincy, MA

Senior Programmer Analyst

Responsibilities:

• Built enhancements to Medicare Secondary Payer billing information to account for new Confidential laws recently mandated.
• Created PL/SQL package that matches Medicare members to update legacy Confidential system, write comma and tab delimited data to UNIX server using utl file.
• Developed UNIX shell scripts to FTP flat files to Confidential system.
• Created new APEX 4.0 screen to account for new business rules created due to new Federal laws mandated concerning Medicare.

Confidential, San Diego, CA

Senior Programmer Analyst

Responsibilities:

• Proposal Tracking System Redesign
• Enhanced the existing Oracle Application Express 3.2.0.00.27 , 4.0 system.
• Added functions to support Engineering, Purchasing, Contracts department.
• Created additional reports to support new requirements.
• Created BI Publisher reports using Oracle BI Publisher Template Builder for Word 10.1.3.4.1 Build 130.
• Mentored junior developers
• Advised on SDLC best practices
• Reviewed SQL queries and recommended more efficient ways to write them
• Led in-house discussions about white papers written
• Created and presented the following white papers:
• DBMS SQLTUNE
• Tuning Tips and Programming Tools (collaborative effort)
• Converting Oracle Reports to BI Publisher
• Handled user service requests for Production & Material Control, Shipping & Receiving, and Government Accounting.
• Created and enhanced existing Oracle Forms and Reports 10g.
• Converted Oracle Forms and Reports to APEX applications.
• Have extensive knowledge in building APEX Interactive Reports
• Augment APEX applications with JavaScript.
• Created packages, functions, and procedures to augment existing programs.
• Tuned SQL statements by rewriting queries, running Explain Plans, TKProf.
• Support Manugistics 7.1.3 by maintaining current custom system that is integrated with it and build enhancements by building interfaces as well as new programs.
• Created materialized views and PL/SQL package to support Manugistics accounting month end reports concerning the CTD, IM, ORD, and WOD tables.

Confidential, Woodland Hills, CA

Senior Application Developer

Responsibilities:

• Part of the Production Support team to maintain financials and worker's compensation systems.
• Troubleshoot and solve technical production issues concerning PL/SQL programs, SQR programs, Oracle Forms, Postscript check printing issues, financial G/L sum issues, Appworx scheduled batch programs.
• Create and maintain Design System Documents to document the system and problem fixes.
• Work closely with business systems analysts to gather requirements from the business.
• Create, document, and maintain entity-relationship diagrams to document current system.
• Perform expert performance tuning of SQL by query rewriting, hint usage, using Explain Plan, SQL Trace, and TKPROF, using indexes, and table partitioning.
• Function as DBA to perform application development related functions.
• Expert SQL writing experience to write extremely complex queries efficiently current to Oracle 10g including using advanced analytic functions.
• Expert PL/SQL program writing experience specializing in advanced features current to Oracle 10g.
• Expert Oracle Forms and Oracle Reports developer from all versions from 3.0 to 10g.

Confidential, Los Angeles, CA

Oracle Developer Contractor

Responsibilities:

• Create stored procedures, worked on Oracle Applications.
• Customized and modified Oracle Forms and Reports 6i.
• Developed a proposal to perform table partitioning on the ten largest database tables to increase query performance.
• Function as DBA in creating tables, triggers
• Tuned Oracle 9i SQL statements using query rewrite, inline views, Explain Plan, SQL Trace, and TKPROF
• Wrote complex SQL statements involving aggregate and analytic functions to generate reports.