SUMMARY

• Total over 15 years of Industry Experience on Oracle 11g/10g/9i/8i,
• Extremely effective in using Tools like PL/SQL Developer, SQL*Plus, SQL Navigator, and TOAD.
• Good experience in stored procedures, functions, triggers and packages.
• Good experience in writing SQL statements and Tuning & Optimization of the Queries.
• Experience in writing SQL statements using Oracle 11g features like Merge, Multiple Inserts, and Partitions.
• Extensively worked in the performance tuning Oracle Queries, SQL, PL/SQL, Packages, Procedures and External Tables.
• Made performance improvements to the database by building Partitioned Tables, Index Organized Tables and Bitmap Indexes.
• Extensively used PL/SQL programming in backend and front - end functions, procedures, packages to implement business rules.
• Extensive experience in posting and retrieving files on Unix Server
• Involved in Database Designing, Normalization and Demoralizations in Oracle and SQL Server.
• Created tables, indexes, sequences, constraints and snapshots
• Responsible for all activities related to the development, implementation, administration and support of Oracle and SQL Server databases.
• Performance testing and tuning while loading data into Data Warehouses, Data Marts, and ODS tables.
• Good communication skills, technical and analytical abilities.

TECHNICAL SKILLS

Database: Oracle 8i/9i/10g/11g/12c Ms-Access 2007/2010, SQL Server 2010.

Platforms: UNIX, Windows.

DB Tools: SQL* plus, PL/SQL Developer* Loader, and SQL Navigator

Scripting Languages: Unix Shell scripting, HTML, JQuery, PHP, AJAX, JSON

Languages: SQL, PL/SQL, C++, T-SQL, and VBA.

Office products: Excel, MS-Word, Power Point, Microsoft Project, and Visio

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Oracle Database Developer

Responsibilities:

• Data Modeling, Creating ERD, creating Flow Charts
• Design and implement ETL Extract, Transaction, Load
• FTP and SFTP Import/Export file Transfer
• Design and implement Data Marts for clients
• Create and Maintain Data Dictionary
• Created PL/SQL Packages and Procedures to process data through ETL
• Data Modeling using MS Visio to create custom tables, views and data marts
• Created External Tables based on client requirements to import data into tables
• Import/Export files from Unix into tables in clients Data Warehouse.
• Worked extensively with Reporting team to create tables/views for consumption
• Collaborated with Project Mangers in client meetings to custom design their ETL
• Created schedules for clients ETL to execute daily, weekly, monthly, etc.
• Writing technical specification documents outlining the ETL process for Account Leads.
• Extensive experience in creating Cursors, Bulk Collect, Insert, Update, Delete processes to process data.
• Helped design archiving plans for clients and strategies to export their data when requested.
• Migrating Access Databases, Reports, Forms, and Procedures to an Oracle application.
• Creating Access tables, reports, forms, and analysis using VBA to be converted into Oracle Developer 2000 applications

Confidential, Chicago, IL

Programmer/Analyst

Responsibilities:

• Oracle (9i, 10g), Access 2003, SQL Server, SQL, PL/SQL, HTML, XHTML, XML
• Created Oracle Queries (SQL, PL/SQL, Packages, Procedures, Functions, SQL Loader, regular expressions) to process and query incoming hospital P.O. data and load into the data warehouse and Operational Data Store (ODS). Created DML and DDL queries.
• Data Modeling: created physical and logical data models for Oracle & Access data bases using Visio. Also created data model for hospital client including a Data Mart & Data Warehouse. Created ETL workflows for Data Mart and Data Warehouse using Visio and Oracle Designer.
• Data Warehouse: Created a data warehouse to house hospital P.O. data. Created and maintained ODS (Operational Data Store) and Data Mart. Used Oracle Designer, Oracle Reports, Oracle Forms, Oracle Discoverer.

Confidential, Oakbrook, IL

Programmer/Analyst

Responsibilities:

• Oracle (9i,10g), Access 2003, SQL, PL/SQL, VBA, HTML, XHTML, XML
• Migrated Access Databases and Procedures to Oracle
• Created Access and Oracle Queries (SQL, PL/SQL, Packages, Procedures, Functions, SQL Loader, Regular Expressions) to process and query incoming hospital PO data and load into the master product table. Created DML and DDL queries.
• Data Modeling: created physical and logical data models for Oracle & Access data bases using Visio. Also created data model for a healthcare Data Mart & Data Warehouse. Created ETL workflows for Data Mart and Data Warehouse using Visio and Oracle Designer.
• Data Warehouse: Created a healthcare data warehouse to include all healthcare products utilized by hospitals. Created and maintained ODS (Operational Data Store) and Data Mart. Software: 5 yrs experience
• Siebel (CRM): used for demographics of hospitals and healthcare manufacturers
• Oracle Designer: used to create data models for data warehouse, and data mart
• Oracle Forms: used to create applications for Internet and Intranet
• Oracle Reports: used to create sales, membership, and forecasting for hospital members and internal use.
• Oracle Warehouse Builder: used to create data warehouse and data marts for healthcare industry. Created Materialized views and processed data using ETL tool.
• Analyze incoming hospital PO data. This data must pass certain criteria before it is entered into our master database. Once cleaned, we prepare spend management reports, so they can see their trend in purchasing of certain products.
• I work closely with our member hospitals to prepare their PO data for submission. This involves categorizing their data {ie. Med/Surg, pharmacy, foodservice, capital equipment}
• I also prepared purchasing analytical reports for our member hospitals