SUMMARY

• An accomplished database and data warehouse designer / developer with extensive experience in all aspects of the software development life cycle (SDLC), for both normalized databases and data warehouses. Extensive experience in HMO / Healthcare / Health Insurance, Mortgage and Telecommunications industries. Held roles as: database architect, data warehouse architect, data modeler, database developer, data warehouse developer, data analyst.
• Solid experience in architecting, designing, analyzing, modeling, developing, testing and maintaining normalized databases and dimensional data warehouses, including documentation and user training.
• More than 7 years of designing, developing and testing ETL software (Extract, Transform, Load) for data warehouses.
• Extensive experience with Oracle starting in 1987 with Oracle 2 thru Oracle 10g RAC.
• Requirements gathering experience in both one - on-one and JAD (Joint Application Development) settings.
• Work extremely well with people in all aspects of the development process, at all organizational levels - Executives, Managers, Technical staff, Non-IT staff, and Vendors.
• Project lead and technical lead on several projects - managed teams of up to 10 people.
• In-depth understanding of both legacy and current IT technology and methodologies, including experience with RUP, Use Cases, OOA and Java.

TECHNICAL SKILLS

Software: SQL, PL/SQL, MySQL, Oracle SQL Loader, ERwin, SQLNavigator, TOAD, Oracle 8i, 9i, 10g RAC, Java, Unix Shell Scripts, Pentaho, Ruby, DEC VAX, MS Project, MS Excel, MS SQL Server, Mercury Interactive Testing Tools.

Systems: Unix, Linux, Windows (2000, XP, Vista), VAX VMS

Industries: HealthCare/HMO/Health Insurance

PROFESSIONAL EXPERIENCE

Confidential, Burbank, CA

Data Warehouse Developer / Designer

Responsibilities:

• Added a drug/pharmacy claims datamart to the DW. Started from the outside vendor’s (Medco) input files and documents, determined the target datamart table design from discussions with management; designed and programmed Unix c-shell and Oracle SQL*Loader scripts; designed and programmed the Oracle 10g Procs to perform the ETL actions to map the source data to the target tables; programmed, tested and documented the scripts and procedures.
• Added a mental health claims datamart to the corporate data warehouse. Performed the same actions as for Medco above, but for a different vendor (Value Options), with a different set of source datafiles.
• Created a datamart to track the status of the main medical claims pipeline (vendor was ViTech) and added this to the corporate data warehouse. (A claim goes through several stages in its lifetime, from opening to paid or denied. This datamart tracked numbers of claims at different stages of the pipeline and the rate of flow of claims through the pipeline.) This datamart had eight dimensions, one detailed fact table and one aggregated fact table to allow for simpler and faster reporting. Very complex ETL processing consisting of about 10 staging tables, 3 Unix shell scripts and 16 Oracle procedures, from simple to complex. This datamart replaced a time-consuming Excel + SQLServer application that required substantial manual work every week. The result was incorporated into the first corporate “dashboard” for use by top-level executives.

Confidential, Anaheim, CA

Data Architect / Data Modeler

Responsibilities:

• Maintained several schemas in the project data model using Erwin, TOAD and Oracle 8i.
• Was attached to a team of business analysts creating the new schema for “outside vendor processing “ (Credit, Flood, and Title) to insure that the data model was workable and efficient and adhered to 3NF principles.
• Created and maintained various parts of the data mapping from the legacy loan origination system to the new version.
• Worked with both off-shore and on-site teams

Confidential, Irvine, CA

Data Warehouse Architect / Developer / Designer / Data Analyst

Responsibilities:

• Did extensive requirements gathering via one-on-one discussions with management and department specialists in all areas of loan origination, secondary marketing and accounting.
• Determined the initial set of datamarts, along with a full set of conforming dimensions, and determined the initial business process to start with (Loan Pipeline from Opening to Funding).
• Switched roles to data analyst to help assess the cleanliness and completeness of the source data.
• Wrote ETL procedures in TransactSQL and Excel to transform source data into the new fact and dimension tables.

Confidential, FL

Database Architect / Data Modeler / Data Analyst / Developer

Responsibilities:

• Project lead on project to migrate a legacy Payroll system (COBOL-based, single-tier) into a multi-tiered client-server system using Java and Oracle 8i. Created a 3NF normalized data model using ERwin. Did development/programming in Java using a Java integrated programming environment called Versata.
• Worked on project to create an integrated, web-based system for the State of Georgia Pre-Kindergarten program. Turned Use Cases and system requirements into 3NF data models using ERwin on a Java/DB2 platform.

Confidential, CA

Senior Systems Analyst / Senior Developer / Project Lead

Responsibilities:

• Technical Lead on project to create an independent testing platform for Confidential ’s entire IT Department. Prior to this, the Confidential IT Department did not have a separate QA step before putting new code into Production.
• Gathered requirements from managers, analysts and developers in both one-on-one interviews and JAD (Joint Application Development) sessions, from all IT departments..
• Led the technical team in designing the testing environment to support standard QA testing functions, including system test, regression test, stress/performance test, and end-to-end test.
• Used MercuryInteractive testing tools: TestDirector, WinRunner, LoadRunner.
• Data Modeler on project to create company’s first star schema data warehouse. Worked with business analysts to define structure of the dimension and fact tables. Evaluated OLAP tools, including BusinessObjects and Brio and provided recommendations to management.
• Senior programmer/analyst on project to develop a “post-merger” ETL system, to merge data from the newly acquired company (QualMed, Inc) into the existing Oracle/RDB data warehouse. Created ETL programs to carry out complex transformations, using COBOL and embedded SQL on a VAX/Oracle RDB platform.
• Project lead on a Testing/QA project to test a major new actuarial application prior to it being put into production. Created the test plan and test scripts and managed the testing environment, the testing schedule, and a team of four testers. Organized the defect management, including regression testing, and also managed the user acceptance test.
• Designed and developed Confidential ’s first set of HEDIS reporting programs. (HEDIS = Health-plan Employer Data and Information Set), to satisfy a corporate requirement for these reports. Did detailed data analysis to match existing source data to published HEDIS reporting requirements and standards. Designed and programmed a set of extract and reporting programs to satisfy the HEDIS requirements. Platform was VAX/VMS COBOL with embedded SQL on an Oracle/RDB database.

Confidential, Irvine, CA

Database Architect / Database Designer/ Data Warehouse Designer/Developer / Project Lead

Responsibilities:

• Designed and developed the cellular bill-printing system for two foreign AirTouch subsidiaries - Telecel in Lisbon, Portugal, and Belgacom Mobile in Brussels, Belgium. Designed the data structures and process flows for the complete set of bill-printing programs. Project lead for the programming and testing efforts. Project lead for the cut-over to successful implementation at both sites. The platform was VAX COBOL/DBMS/DCL feeding billing data into large-scale XEROX 8000 and 9000 series printers.
• Designed a major upgrade to the corporate ETL system that linked PacTel’s operational system (which consisted of three main application areas - Message Processing, Billing and Order Processing) to the corporate Data Warehouse, at that time called the “Decision Support System” or DSS. The existing ETL system was out of control and corporate users did not trust the data in the Data Warehouse. Added a “control layer” to the existing ETL system of more than 150 VAX COBOL programs. Did intensive requirements gathering and data analysis and then designed the new control structures and designed the program modifications and new programs. Led the programming project with a team of five programmers. Led the testing effort. Led the implementation team (as project lead) to a successful cut-over to the new system. Platform was VAX COBOL, DEC DBMS, DEC DCL on the source side and Oracle 6 on the Data Warehouse side.