SUMMARY:

• Oracle PL/SQL versions 10g and 11G programming (packages, procedures functions and triggers).
• Complex SQL and SQL analytic functions
• Data Warehouse development.
• Extraction, transformation and loading (ETL) and data conversion strategies.
• Oracle tools, SQL Loader, Oracle Loader, Import and Export.
• Oracle Development tools (Toad, PL/SQL Developer, Oracle SQL Developer).
• SQL, PL/SQL Performance Tuning.
• Quality Assurance (QA) testing.
• Data mapping source to target.
• Data modeling, relational and dimensional design.
• Business analysis, development of technical and functional specifications.
• Excellent communication and interpersonal skills.
• Business Intelligence and reporting tools.

PROFESSIONAL EXPERIENCE:

Confidential

Help desk Analyst

Responsibilities:

• Contracted to help Confidential patients set up and use Confidential ’s new Patient Portal.
• Took approximately 30 calls per day in call center helping patients set up and navigate the portal.

Confidential

Oracle Data Warehouse Developer/ETL Developer

Responsibilities:

• Contracted to assist in revising existing ETL procedures and documenting changes.
• Made changes to UNIX Crontab to reschedule jobs and eliminate unused legacy programs.
• Wrote PL/SQL procedures and packages to create new ETL loads and business intelligence reports.
• Tuned PL/SQL procedures for performance issues.

Confidential, NA

Oracle Data Warehouse Developer and BI Developer

Responsibilities:

• Contracted as consultant to assist in the creation and implementation of Confidential ’s Revenue Management/ Business Intelligence data warehouse project in a Linux environment.
• Analyzed data needs and created dimension tables and fact tables for the data warehouse.
• Developed complex SQL to load data and generate business intelligence reports.
• Wrote SQL and PL/SQL programs to automate data loads into the data warehouse.
• Tuned PL/SQL procedures for performance issues.
• Attended daily Scum/Agile stand - up meetings as a member of the development team. Responsible for making sure development Sprints were met.
• Created documents outlining BI report needs and technical documentation relating to the reports.

Confidential

Oracle Developer Consultant

Responsibilities:

• Contracted to help with company data migration project.
• Wrote PL/SQL procedures and packages to convert a company’s move to Oracle from legacy systems.
• Used SQL Loader to migrate/integrate data.
• Documented Changes to system.

Confidential

Data Conversion Consultant

Responsibilities:

• Oracle data consultant for Confidential broker integration project.
• Created source to target maps.

Confidential

Oracle Development Consultant

Responsibilities:

• Extracted, transformed and loaded new data from multiple data sources using PL/SQL. A nalyzed data quality and reported issues. Updated project plan and data mapping.
• Wrote PL/SQL procedures and loaded data using Oracle Loader and external tables.
• Created source to target data maps.
• Tuned PL/SQL procedures for performance issues.
• Consultant developing changes to bank’s Financial Data Warehouse ( Confidential ) in a Unix environment. Developed on an Oracle 11g UNIX platform. Extracted, transformed and loaded new data using PL/SQL and SQL Loader.
• Developed new business intelligence reports using SQL and PL/SQL.
• Responsible for documenting all technical changes including back out plans.
• Tuned PL/SQL procedures for performance issues.

Confidential

Oracle Database Developer/ Data Warehouse Development Consultant

Responsibilities:

• Contracted to assist in changes to insurance companies Oracle Claims data warehouse.
• Analyzed business analysis documents and created functional specs for changes to the company’s data warehouse.
• Wrote SQL and PL/SQL programs to transform data and load into data warehouse in a UNIX environment. Tuned PL/SQL procedures for performance issues.
• Created source to target data maps.
• Created SQL Loader programs to transform and load data from a new data source.
• Wrote PL/SQL programs to transform data and load into data warehouse in a UNIX environment. Tuned PL/SQL procedures for performance issues.
• Wrote technical documentation of changes.
• Created new reports with materialized views and Crystal Reports for user reports.

Confidential

Senior Database Developer/Analyst

Responsibilities:

• As Database Developer, responsible for ETL and data modeling. Wrote SQL Loader programs and used DataStage to load data to staging tables for data transformation. Wrote PL/SQL programs (stored procedures, functions, packages, triggers) to transform and load data into database in a Windows environment. Tested to ensure all changes conformed to company’s data architecture.
• Created source to target data maps
• Accomplished full data SDLC cycle for clients including business, functional and technical specs, system integration and quality assurance. Met with clients to verify all business specifications and milestones were met.

Confidential

Senior Oracle Database Developer

Responsibilities:

• Oracle PL/SQL Developer involved in data analysis, data modeling and Oracle programming for medical centers clinical, web services and data warehouse divisions.
• Lead database developer for hospital’s website.
• Accomplishments included data models using Confidential development tools.
• Programming the database using PL/SQL packages, stored procedures, functions and triggers on Oracle 9i database on a UNIX platform.
• Data Analyst involved in designing and supporting Enterprise Data Warehouse and Enterprise Data Repository. Used DataStage tools to design warehouse and data marts and for ETL loads.
• Created a daily business report system for hospital management using Excel spread sheets and pivot tables and excel macros.
• Created a daily patient checkout system using Crystal Reports.

Confidential

Programmer/Analyst

Responsibilities:

• PL/SQL Developer for major retail company.
• . Created stored procedures, triggers and packages using Oracle PL/SQL to support application and reports.
• Created customer relation management system and inventory management applications and reports using Oracle database on both Windows and UNIX platforms