SUMMARY:

• Oracle: 30.2 yrs - development (18.5 yrs), data modeling (6.2yrs), DBA (5.5 yrs)
• Other IT: 7.4 yrs

EXPERIENCE:

Confidential, CA

Architectural Analyst

Responsibilities:

• Created ddl for data warehouse fact and dimension tables, including junk and conformed dimensions, using Kimball methodology for load into universe to create Business Objects reports.
• Wrote plsql to partially build ddl by copying and transforming stage table ddl.
• Created entity relationship and shell diagrams.
• Requested creation of the tables including stage tables and views.
• Found stage tables without primary keys, mismatched record counts, missing tables and etl bugs.
• Aided conversion of plsql to Informatica.
• Created update trigger to find incorrect etl values.
• Trained on cyber security.
• Clarified requirements.
• Wrote monthly report.
• Worked on virtual machine.

Environment: Windows 10, Office 365, Plsql,Excel, Toad, Erwin, Sharepoint, Jira, Confluence, Agile.

Confidential, AL

Oracle DBA

Responsibilities:

• Copied tables from on-premise production environment to Azure cloud virtual machines.
• Analyzed versions of Oracle Database and OEM to decide which to install.
• Created entity relationship diagram of a major subsystem.
• Prepared Oracle 12C database STIGs.
• Wrote PL/SQL program to obfuscate sensitive database data.
• Documented university student management system
• Install of SQL Developer, Oracle Enterprise Manager and Management Agents on Azure virtual hosts.
• Advanced Queueing processing.
• System data flow diagram.

Environment: Multi-tenant Oracle 12C Windows 10, Oracle Enterprise Manager 13.3, Oracle Advanced Queueing, Azure, Data Pump, DBCA Jira, Confluence, Agile

Confidential, AL

Systems Analyst

Responsibilities:

• PL/SQL programming on an infrastructure system.
• Copied files from local network to virtual machine.
• Transferred excel files to Oracle table and created pl/sql to process it.
• Introduced logging procedure and exception handler to procedures.
• Changed loop processing to SQL.
• Changed dynamic SQL where SQL injection attacks were possible.

Environment: Windows 7, PL/SQL packages and procedures, Excel, WINSCP, Jira, Sharepoint, Linux, Agile

Confidential, KY

Systems Analyst

Responsibilities:

• ETL operations and data mapping for human resources system.
• Ran and manually handled exceptions for ETL process.
• Documented ETL flow, mainly regarding de-confliction and type 1 and 2 slowly changing dimensions within stored procedures and packages.
• Mapped flat file data extract back to source tables by reverse engineering stored procedures and packages.
• Added functionality to stored procedures.
• Zipped files in a Unix script

Environment: SQL Server 2008: Windows 7, T-SQL, SQL Server Management Studio, SQL Server Integration Services, Remedy, Jira, Sharepoint, Unix

Confidential, NC

Oracle developer

Responsibilities:

• Developed database which records and measures risk in complying to bank regulations and policies.
• Created and reviewed tables, procedures, etl package and database mappings to support Java user interface.
• Data modeling, Agile development

Environment: Windows 7, PL/SQL, Informatica, Toad, SVN, Jira

Confidential, CA

Software Engineer

Responsibilities:

• Wrote ETL and created fact table for counts of reserves and their sub-populations in each military component, done in collaboration with a J2EE web front end
• Created pl/sql packages using ref-cursor, bulk collect, remote Kimball dimensional data warehouse, Oracle Scheduler, Agile development

Environment: Windows 7, PL/SQL, Toad, SVN, Jira, Oracle Scheduler

Confidential, LA

ETL Developer

Responsibilities:

• Wrote ETL in E-leave and qualifications parts of Kimball military human resources data warehouse.
• Was done in collaboration with web based Business Objects reports
• Created pl/sql packages for type 1 and 2 slowly changing dimensions etl, both incremental and bulk.
• Analyzed Kimball dimensional and relational data warehouses.
• Optimized PL/SQL.

Environment: Oracle11g: Windows 7, PL/SQL, Toad, Dimensions

Confidential, KY

Oracle architect/developer

Responsibilities:

• Ran and wrote ETL to support physician ETG composite scoring based on groupers.
• Revised Inmon star data store and relational model for use in Oracle database and Qlikview.
• Modified scoring code sql with analytic functions.
• Documented confidence and reliability levels and peer cost comparisons.
• Prepared use of external tables and bitmap indexes.
• Created sql to populate geographies and specialties.
• Ran quality tests of provider compliance ratios

Environment: Windows 7, SQL, Erwin Data Modeler, PL/SQL Developer, QlikView, Excel macros.

Confidential, KY

Oracle Developer

Responsibilities:

• Property and Casualty and Medical insurance screens.
• Updated ref-cursor packages for forms queries.
• Added fields to screens.
• Rejected events and cases. Redesigned tables.

Environment: Windows XP, PL/SQL, Forms10g, PL/SQL Developer, Putty, Winscp, QVCS, Data modeling.

Confidential, MN

Oracle Developer

Responsibilities:

• Payment system for rural carriers.
• Transferred leave from clock ring system to leave system.
• Solved production issues.
• Developed forms, database procedures and triggers. Data modeling

Environment: Windows XP, PL/SQL, Forms 10g, Toad, SQL Developer, Putty, Reflection, Reports 10g

Confidential, SC

Owner/Business Analyst, POS Support

Responsibilities:

• Developed daily sales report for each cash register.
• Constructed worksheet to store money counts, overages, underages in each cash register.
• Devised guide showing how to open and close store, including how to reset registers for next day.
• Operated Digimaster DVR to catch store theft. Submitted police and bad check reports.
• Built worksheet to replenish change and set gas price.
• Reported taxes. Interviewed employee candidates and aided in the hire/fire decisions.
• Passed Oracle certification exam Oracle 10g New Features for Administrators