SUMMARY:

• Health Care, High Tech, Finance, Manufacturing and Entertainment industries
• Databases Analysis / Design and Modeling / Development / Administration
• Healthcare and Financial Applications, SQL, PL/SQL, T - SQL (Scripts/Stored units)
• OLTP/OLAP, Business Intelligence (BI), Reporting, ETL, Data Warehouse
• Customer support, analysis, troubleshooting and resolving end user issues

TECHNICAL SKILLS:

OS: Windows, UNIX (HP, Solaris), Linux (Red Hat-Fedora, Ubuntu)

RDBMS: Oracle 7, 8i, 9i, 10G, 11G, 12c, MS SQL Server 7.0/2000/2005/2008 , MS Access 97/2000/2005 , MySQL, Netezza, Focus, DB2

Data Warehouse/ETL: Oracle: SQL*Loader, ODI 11g, Utilities (Export/Import); Data Junction (DJ) MAP Designer 7.5.5, SQL Server 7.0/2005/2008 , DTS, SSIS, Confidential MTC - Mapping Tool.

BI/Reporting: Oracle: BI Publisher 11g, Hyperion Financial Reporting, Enterprise Performance Management System Workspace, Fusion Edition 11; Business Objects 5.1.7/6/XI, Crystal Reports XI, Oracle-Reports, WebFOCUS-ReportPainter, ReportCaster

Oracle Programming: SQL, SQL*Plus, PL/SQL - packages, triggers, stored units, SQL Developer, APEX, Oracle Reports and Forms, Oracle Financial Applications - Releases 10SC and 11i (AP, AR, PO, GL modules), MySQL, ODI 11g

MS SQL Server: Business Intelligence Development Studio 2005, T-SQL- stored units, scripts, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS

Quest: Toad for Oracle Xpert 11.5, Toad Data Modeler 4.1, Toad for Data Analysts 3.1, SQL Navigator

Vitech System: V3-Integrated Benefit Administration Application, Client 3.1/V3 Platform 5.08

CA: ALLFusion ERwin Data Modeler

170Systems: SQL*Flow Designer - Flow Builder, Object Modeler, MarkView - Image Viewer/Modifier, Markview Admin, SQL*Flow Monitor, MarkView Scan

Exposures: Apache Tomcat/Maven, PL/SQL Web Toolkit, HTML, XML, UNIX scripting, cURL, BIG Data NoSQL - CouchDB, Futon, MongoDB, Git/GitHub/SourceTree, Confluence, Atlassian-JIRA, STS (-Spring) Eclipse-based tool

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Consultant/Software Engineering Sr. Analyst

Responsibilities:

• Design, build/enhance and test Oracle’s BI Publisher and Hyperion FR reports used throughout the State of California for the budgetary process
• Created Data Models and SQL statements against budgetary data warehouse
• Design XML/RTF templates to format the final reports
• Build reports that published to the public both in print and on the web
• Created Functional and Technical Design, Unit and User Acceptance Test documents

Data Architect/DBA

Confidential, Orlando, FL

Responsibilities:

• Transition and integrate legacy systems to Saleforce.com cloud-based CRM
• Transform Saleforce.com related DVC business requirements into data models
• Create logical and physical Entity Relationship Diagrams with key and indexes in the third normal form using

SQL Developer Data Modeler

Confidential

Responsibilities:

• Create executable batch files and DDL scripts to generate database objects in Oracle XE (-for local tests only)
• 3rd level of customers support and 11G/12C for multiple schemas using PL/SQL, SQL and SQL Developer
• Generate and administer multiple schema’s objects across multiple Oracle environments to store Saleforce.com inbound/outbound data
• Administer user access to schema objects
• Storage, data manipulation and retrieval JSON-containing CLOB objects in Oracle 11G/12C

Oracle Agile PLM Developer

Confidential, El Segundo, CA

Responsibilities:

• Oracle 11G, SQL, PL/SQL, SQL Developer, Oracle Data Integrator (ODI 11g)
• Data mapping, design and development - data conversion interfaces

Confidential, Los Angeles, CA

IS Department - Database Developer

Responsibilities:

• Design/development of data exchange interfaces between client and subcontractors
• Health Risk Assessment (HRA) project - design and development

Confidential, Alhambra, CA

IT Department - Database ETL Developer

Responsibilities:

• Design ETL conversion maps from the multiple vendors eligibility legacy systems (Mainframe,DB2) to Vitech V3 Integrated Benefit Administration Application (Oracle)
• Design/develop/test ETL data loads and data validation processes
• Develop/implement data export/import batch processes for V3 Integrated Benefit Administration Application
• Create Ad-Hoc reports/queries per user request
• Administrate and monitor end users access to applications and databases
• Analyze, troubleshot and resolve user’s issues at database and application levels

Confidential, Alhambra, CA

Database DW Developer

Responsibilities:

• Gather client requirements, data analysis, mapping, and functional design
• Assist in design/modeling of star schema for new California Health Plan data warehouse
• Develop ETL scripts to load clients transactions into data warehouse
• Develop and enhanced reports and ad-hoc queries

Confidential, West Hollywood, CA

BI/Report Developer

Responsibilities:

• Design, develop and enhance corporate financial reporting system
• Design/Modeled Data Warehouse, programmed ETL scripts for Dashboard WEB Application
• Daily/Weekly/Monthly ETL processes from OLTP into OLAP systems for 3rd Party advertisers

Confidential, Burbank, CA

Sr. Programmer-Analyst

Responsibilities:

• Develop ETL process to migrate music’s download transactions into Confidential eTrans Data Mart
• Produce weekly/monthly reports against eTrans Data
• Develop/support multi-org workflow for payable (AP) of Warner Music Shared Services for the labels such as Atlantic, Elektra, WB Records, Rhino, Maverick, WEA and others
• Automate invoice-scanning process by switching barcodes to labels logos
• Produce variety of Ad-Hoc AP reports and queries
• Develop Electronic Invoice Approval (EIA) and Tax Forms Tracker (W-9) Workflows. Both integrated with Oracle Financial AP and MarkView imaging system to process invoices/W-9 forms
• 3rd level of customers support

Confidential, Glendora, CA

Application Programmer

Responsibilities:

• Write/ enhance stored database units for Payable/Purchasing modules of financial application
• Create GUI screens to manage reports using Oracle Forms and Reports

Confidential, El Segundo, CA

Staff Consultant

Responsibilities:

• Write Financial Reports for Gazprom project, Moscow, Russia
• Migrate data from old legacy systems to Oracle RDBMS in Houston TX, Oracle Energy