SUMMARY:

• Over fifteen years of experience developing business solutions with a diverse background in requirements gathering/documentation, systems analysis/design, development, and implementation.
• Extensive knowledge of Oracle PL/SQL, Packages, Stored Procedures/Functions, Triggers, Constraints, Indexing, Partitioning, LOBs, SQL Tuning, Transaction Processing (DCL/TCL), ETL, Data Modeling/Normalization, Collections/Arrays, Star Schema/Dimensions/Cubes, Unit Testing.
• Tools: Toad, SQL Developer, Erwin, SVN, SQL Loader, SQL Plus, Data Pump, External Tables, Unix/PERL, APEX, Oracle Warehouse Builder (OWB), DBMS JOB/SCHEDULER/SMTP, UTL FILE, REGEXP.
• Web Development: MS.NET, T - SQL, C#, HTML, JavaScript, PHP, MySQL, CSS, and XML.
• Excellent communication and problem solving skills with a strong attention to detail.

PROFESSIONAL EXPERIENCE:

Confidential, San Mateo, CA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Responsible for developing new functionality for Postal One core systems. This includes requirements gathering, documenting specification, data modeling, database object creation, PL/SQL programming, test plan development, unit testing, integration testing, user acceptance testing, code deployment and final data/functionality verification.
• Utilizes full System Development Life Cycle (SDLC) to complete quarterly application deployments.
• Assists the front end team with Cold Fusion integration of the database tier. Utilizes Reference Cursors, custom PL/SQL packages, Stored Procedures/Function as necessary for application support.
• Develops database triggers to enforce business rules and ensures a robust/reliable auditing system.
• Maintains legacy systems, including complex queries, data repairs, patches and code refactoring.
• Responsible for tuning complex SQL statements. Assists front end team with best coding practices.
• Provides technical support to customer service team and end users.

Confidential, San Francisco, CA

Oracle PL/SQL Developer

Responsibilities:

• Develops custom solutions with an emphasis on PL/SQL, Data Warehousing, ETL Processing and SQL Tuning with Oracle 11g. Works remotely on assignment for this small consulting company.
• Responsible for implementing a complete ETL solution with Oracle Warehouse Builder (OWB), custom scripting and PL/SQL for a large medical billing client. Project consisted of aggregating hundreds of data sources in various formats requiring complex transformations and business logic.
• Designing a new system utilizing Microsoft .Net, C#, and T-SQL technologies that allows users to directly submit medical billing records for future collection and reporting.
• Developed a low cost ETL solution that is used as a template for new clients. This custom solution was designed to automate the processes for preparing data for loading. This includes file verification, archiving, data cleaning, extraction/staging, error reporting, and basic transformation. Extensive automation moves data through each step of the process while maintaining the highest level of data integrity.

Confidential, Santa Monica, CA

Oracle PL/SQL Developer - ETL Specialist

Responsibilities:

• Provided database development support for Confidential ’s InformaCare Managed Care application.
• Gathered requirements and developed custom health care solutions for over one million patients.
• Designed and implemented a new Data Warehouse and ETL solution with Oracle Warehouse Builder (OWB) in Oracle 10g. Designed data dimensions and cubes for analytical reporting.
• Developed a custom system in Oracle 10g/9i for scheduling, automating, and monitoring ETL processes. Created custom PL/SQL packages to verify file contents, extract data to External Tables, clean, stage and perform data transformation, load data into the production database, log/handle exceptions, verify results and report status/results.
• Utilized Oracle APEX for rapid application development (RAD), reporting, and front end interface. Created an APEX application for accessing ETL processing and related information.
• Performed SQL tuning/optimization to enhance database and application performance.
• Documented code functionality and processes. Designed and performed unit testing.
• Supported InformaCare development (J2EE/ JDBC) team with data related issues. Assisted in writing result sets queries, developed stored procedure and created triggers as needed.
• Generated blinded patient encounter data by removing/masking personal identifying information.
• Provided support for legacy Oracle Forms and Reports maintaining complicated SQL queries.
• Created Unix/PERL scripts as necessary to transfer, parse, and clean source data files.
• Generated ad hoc reports in Microsoft XML as requested.
• Worked directly with government agencies, customers, providers and healthcare partners including: AHCA, Providence, McKesson, PHP, Medicare, and the states of Florida and Arkansas.
• Adhered to all HIPAA regulations and data privacy requirements.

Confidential, Van Nuys, CA

Microsoft .Net/SQL Server Developer

Responsibilities:

• Established an internet presence for startup company iDemandDigital.com. Utilized Microsoft Visual Studio, C#, VSS, SQL Server, and .Net technology to develop an innovative new website.
• Designed database and ER models using ERWIN. Created database objects and maintained schema.
• Responsible for all database related code development including the creation/maintenance of Stored Procedures, Triggers, connection strings, and result sets.
• Performed systems analysis to establish business logic and overall user experience.
• Assisted the development team with user interface design/integration.

Confidential, Thousand Oaks, CA

Technical Team Lead

Responsibilities:

• Provided technical leadership to team members. Tracked and scheduled all department resources.
• Responsible for system enhancements and maintenance.
• Successfully launched global ecommerce website for mobile networking division.
• Developed front end UI for new Technical Support site. Streamlined user experience.
• Launched new Vignette Content Management System (CMS).
• Utilized Agile Development (Scrum) and the full System Development Life Cycle (SDLC) to insure that projects were delivered to specification within scope and budget.

Confidential, Thousand Oaks, CA

Document Control Manager / QA Specialist

Responsibilities:

• Documented all quality related processes and procedures. Insured that all processes were in compliance with ISO standards and practices.
• Worked directly with QA Manager to secure ISO9001 Certification.
• Created/revised all Technical Specifications (Spec Sheets) for semiconductor products.
• Responsible for all areas of document control including revision control, signature authority, document registration/tracking, and controlled copies.
• Developed a custom Document Control System in Microsoft Access which allowed users to query to the location of all existing documentation and specifications.

Confidential, Hollywood, CA

Web Designer

Responsibilities:

• Developed custom websites for clients in various industries.
• Responsible for graphic design and web programming.

Confidential, Foxboro, MA

Systems Analyst - Quality Improvement Program

Responsibilities:

• Performed root cause analysis to determine areas of potential quality improvement.
• Documented current processes and assisted department leaders in system improvements.
• Responsible for developing/maintaining all corporate quality metrics and indicators.