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, logical and physical data modeling as well as business methodologies for transactional and decision - support (DW/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.
• 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:

BI Report Developer/Analyst

Confidential, Redmond, WA

Responsibilities:

• Sole developer (for 91 programs) to the Carlisle Project - Developing in Oracle RDBMS v.11 to develop SQL (DML) programs to data mine Terex performance metrics in an Oracle Applications v.11 environment.
• Emphasis on modules - Order Management, Purchasing, Inventory, Accounts Payables (AP), Accounts Receivables (AR)
• Gathered requirements, actively assessed technical problems using root cause analysis and applied rigorous testing
• All activities managed within a Scrum developmental environment with Team Foundation Server as the code repository.

Oracle Software Engineer

Confidential, Richland, WA

Responsibilities:

• Leveraged skills in the establishment, improvement, scalability and performance-tuning of ETL programs using SQL (DDL, DML) 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, triggers and stored procedures. Updated or recommended changes to 300 plus custom objects.
• Used SQL and table constraints to enforce business rules and data quality.
• Responsible for using SQL for successful data mining and timely ad hoc business reporting for metadata and BI.

Programmer Analyst IV

Confidential, Bellevue, WA

Responsibilities:

• Applied expertise in Oracle Applications 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 (DDL, DML) scripts, PL/SQL functions, triggers, 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, data visualization 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.
• Adept at physical modeling (data platforms, schemas), logical modeling using UML (de-normalization, normalization), conceptual modeling and data flow diagrams.
• 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 Quantum Migration Project - Migrating to a new version of Oracle RDBMS
• Responsible for PL/SQL programs, UNIX shell scripts, functional and UAT testing;
• Customer Project - Creating a new Oracle UI with Oracle back-end
• Responsible for the development, analysis, data modeling, design, testing and documentation of all forms, tables, views, data platforms 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

Confidential, Redmond, WA

Responsibilities:

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

Senior Programmer Analyst

Confidential, Seattle, WA

Responsibilities:

• Carried out 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, while presiding over the weekly trouble-ticket meeting

Senior Analyst

Confidential

Responsibilities:

• Dealt with Data Conversion, Data Quality, ETL, Oracle RDBMS, SQL, PL/SQL(procedures, functions), UNIX scripts, DW/BI, all-stages of SDLC, Logical and Physical Data Modeling, development of Data Platforms, On-Call Support, and served as stand-in team lead