Database Architect Resume Pasadena CA - Hire IT People

OBJECTIVE:

Seeking a position in a growing, dynamic, forward - looking company or enterprise, where I can use my experience, expertise and drive to make a significant contribution.

QUALIFICATIONS

Long-term, varied work experience in IT for more than 30 years, in several different business settings: Health Care, Entertainment, Accounting, Mortgage Banking, Telecommunications
Specialization in database and data warehouse architecture, design and development, primarily with Oracle.
Excellent Business Systems Analyst
Familiar with all aspects of SDLC
Understand the value of architectural design, development standards and best practices
Expert in data analysis, data modeling, data warehousing, integration, BI reporting
Self-starter, proactive, team player, quick study
Good at communicating with individuals at all levels of an organization, as well as outside partners, vendors, agencies, regulators, etc.

TECHNICAL SKILLS:

Oracle, through v.12c

SQL and PL/SQL

Data Modeling: 3NF and DW

MS Tools: Excel, PowerPoint, Visio, Word

BI Tools: BusinessObjects, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Pasadena CA

Database Architect

Projects and Activities:

Debug and correct Oracle Golden Gate application being used to keep two independent web-portal databases in synch 24/7.
Review and validate or correct, new and modified Oracle database schemas originated by multiple IT application groups involved with Kaiser’s web presence.
Database design specialist on application development team creating a new customer service application for web-portal users.

Confidential, Burbank CA

Data Warehouse Architect/Analyst/Developer

Projects and Activities:

Designed and developed a data collection application to create the required submission documents for the Federal government’s ERRP (Early Retiree Reimbursement Program) program. This system resulted in the largest reimbursement of all Entertainment health care companies and survived all government audits.
Created two new data marts in the Data Warehouse for two new health care vendors that began submitting regular data, along with ETL processes.
Developed “Claims Pipeline” claims tracking application, providing feeds to SAGPH’s first Executive Dashboard application.
Redesigned and rewrote the monthly Premium Reporting system, converting it from a multi-step Excel, COBOL system to a single-step Oracle SQL and PL/SQL application. Produced the data that was then fed into the Business Objects/Crystal Reports reporting application.

Confidential, Woodland Hills, CA

Database Migration Specialist/Programmer-Analyst

Projects and Activities:

Principal programmer-analyst on a large data integration project to merge data from a newly acquired health care company into the existing HealthNet Data Warehouse.
Wrote numerous reporting programs, including HEDIS reporting, that extracted data from the Data Warehouse using embedded SQL within COBOL programs.
Ran a team of testers doing QA of a newly written Statement of Loss application.
Project manager for an application team that created a QA testing platform for all new and modified systems throughout all of IT.

Confidential, Irvine, CA

Data Warehouse Architect/Developer

Projects and Activities:

Data architect for Encore’s first Star Schema Data Warehouse.
Extensive Requirements Gathering from most company departments, in one-on-one interviews and JAD (Joint Application Development) sessions.
Led the development of the ETL processes to extract data from the stand-alone Loan Origination system into the first DW data mart.

Confidential

Database Developer/BSA/DW Architect and Developer

Projects and Activities:

Architected and developed a system to control the data flowing into the Data Warehouse via the ETL processes.
Led team of programmers in developing the enhanced ETL system.
Designed and programmed a reporting system to monitor the efficiency and accuracy of the new Data Warehouse ETL controls.
Several other analysis, design and programming projects.
Two European projects to write the bill-printing application for the newly formed Portuguese and Belgian cellular companies.

Confidential

Application Designer, Developer, Programmer

Projects and Activities:

Designed and programmed generic Accounting systems for medium-sized businesses ($50M - $100M), including the following applications: General Ledger, Accounts Receivable, Accounts Payable, Payroll, Fixed Assets, Inventory Control, Sales Order Entry, Project Job Costing.

We provide IT Staff Augmentation Services!

Database Architect Resume

Pasadena, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship