SUMMARY

• Seasoned, multifaceted, and highly organized professional, offering extensive experience in the information technology field; complemented with proven expertise using Oracle in supply chain, data conversion and data migration (ETL).
• Adept at developing and maintaining various programs utilizing frameworks, programming languages, operating systems, quality systems, as well as business methodologies for transactional and decision - support (BI) systems.
• Skilled at providing rapid resolutions on technical issues and working with evolving technologies. Equipped with solid communication and interpersonal aptitudes essential in establishing rapport with individuals of diverse backgrounds.

AREAS OF EXPERTISE

• Program and System Analysis
• Program Development
• Integration and Release Engineering
• Configuration Management
• Requirements Engineering
• Process Management

TECHNICAL SKILLS

Operating Systems: UNIX | Linux | Windows

Quality Systems and Methodologies: Agile/Scrum | SDLC | UML | Fujitsu Productivity Plus

Programming Languages: SQL | Unix and Linux Shell Scripting | Python

Tools: Oracle RDBMS | Oracle Applications | PL/SQL | SQL*Plus | SQL*Loader | Oracle APEX | Forms Personalization | Oracle Reports | Oracle Discoverer | Oracle Forms | Toad | SQL Developer | Visio | Excel | MySQL | Tableau | OpenText | Team Foundation Server | Track IT | SpiraTest

PROFESSIONAL EXPERIENCE

Oracle Software Engineer

Confidential, Richland, WA

• Leveraged skills in the establishment, improvement, scalability and performance-tuning of ETL programs using SQL and PL/SQL in Oracle v.11 for the OpenText v.12 Big Data environment.
• Objects improved were - materialized views, tables, views, indexes, tablespaces, functions and procedures.
• Responsible for using SQL for successful data mining and timely ad hoc business reporting for metadata and BI.

Programmer Analyst IV

Confidential, Bellevue, WA

• Applied expertise in Oracle Application v. R12 with major focus on modules - Order Management, Purchasing, Install Base, Service Contracts, Inventory, Accounts Payables (AP), Accounts Receivables (AR) and Human Resources.
• Utilized Oracle RDBMS 11.2 to improve the SQL scripts, PL/SQL functions, packages, and stored procedures. All programs created with attention to scalability and performance-tuning.
• Took full charge as SME of the development and enhancement of the following:
• Oracle Reports 10g using XML Publisher 10.1 (BI Publisher);
• Oracle Discoverer 11g for system administration utilizing Noetix Views 6.1, thus creating an efficient reporting and dashboard environment for users within the operational data store (ODS);
• Oracle Alerts 12.0 to produce timely and effective reports and notifications for users;
• Customizing Oracle Forms with Forms Personalization to successfully extend the capability of forms;
• Oracle APEX for efficient customer-driven user-interfaces (UI);
• SQL for in-depth data mining;
• Proficient in the analysis, design and development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader and Oracle packaged API’s .
• Technically strong in RICE components (Reports, Interfaces, Conversions and Extensions).
• Created Linux shell scripts using the Red Hat Enterprise Linux 6.6, successfully launching business-to-business and end-user applications.
• Keenly assessed technical problems using root cause analysis to guarantee minimal business interruptions. Applied business case analysis techniques for day-to-day decision making. Provided on-call support.
• Produced documents and programs for all phases of the SDLC. Documented all database and application objects to modify catalogs and to ensure compliance with SOX requirements.
• Made major contributions in generating the following on-time projects:
• Confidential to Confidential Migration Project - Migrating to a new version of Oracle RDBMS
• Responsible for PL/SQL programs, UNIX shell scripts, functional and UAT testing;
• Reference Customer Project - Creating a new Oracle UI with Oracle back-end
• Responsible for the development, analysis, modeling, design, testing and documentation of all forms, tables, views and programs;
• Migration to Oracle RDBMS 11 and Applications R12 Project:
• Responsible for PL/SQL programs, Oracle Alerts, Oracle Discoverer, Views, custom value-sets, functional, UAT and Production testing;

Programmer Analyst | Oracle Developer

Advanced Digital Information, Redmond, WA

• Oracle Applications, Oracle RDBMS, SQL, PL/SQL(functions, procedures, triggers, packages), Oracle Forms, DW/BI, UNIX Scripts, On-Call Support

Senior Programmer Analyst

Confidential, Seattle, WA

• Oracle Applications and Applications Administration, Oracle RDBMS, SQL, PL/SQL(functions, triggers, procedures, packages), Oracle Forms, UNIX Scripts, On-Call Support, Oracle Applications upgrade projects, facilitated weekly trouble-ticket meeting

Senior Analyst | Data Warehouse Developer

Confidential, Renton, WA

• Data Conversion, ETL, Oracle RDBMS, SQL, PL/SQL(procedures, functions), UNIX scripts, DW/BI, all-stages of SDLC, On-Call Support, stand-in team lead