SUMMARY:

Twenty years in Data processing including sixteen years of extensive experience in design, development, and implementation of ORACLE based DSS and OLTP business systems. Extensive experience high - performance PL/SQL code development and SQL performance tuning. Strong skills in ETL development and Data Warehousing. Strong experience with Oracle Report Builder. Strong experience with Java, JDBC, C/C++, Pro*C, Unix shell scripts. Self starter with ability to work either independently or as part of a team. Proven problem solving abilities.

SOFTWARE:

Operating Systems: UNIX (SunOS, Sparc Solaris, IBM AIX, HP-UX, DG/UX), LINUX, VMS, Windows NT/XP, and RSX11M.

RDBMS: ORACLE 11g (SQL, PL/SQL, SQL*Plus, Pro*C/C++, Java, JDBC, SQLJ, Oracle Reports Builder 10.1.2, Oracle WebDB), ORACLE Utilities (SQL*Loader, Export, Import).

Database Tools: TOAD, SQL Navigator, MS Visual SourceSafe, SourceGear Vault, Clearcase.

ORACLE Performance Diagnostic Tools: Explain Plan, Trace facility, Hints, V$ Views.

ETL: SQL*Loader, External tables, Pipelined functions, UNIX Korn Shell.

OLAP: Cognos 10.2.1, Business Objects.

Languages: PL/SQL, JAVA2, C/C++, Oracle Pro*C, C/UNIX, UNIX Shell, SQL, HTML, XML, UML, Design Patterns, COBOL, Macro Assembler.

EXPERIENCE:

Confidential, Harrison, NY

Senior Database Developer

Responsibilities:

• Designed, developed, documented, performance tuned, and tested various Oracle PL/SQL programs for supporting al services.
• Created various UNIX shell scripts for automate process of loading data files from customers to Oracle database using SQL*Loader.
• Created various reports using Cognos 10.2.1.
• Pre-Summarized data for purpose of multidimensional analysis along a combination of “dimensions” and “hierarchies” from detail levels and populated it into data warehouse tables.
• Sql performance tuning. Created tables, indexes, constraints, views, types, sequences, materialized views.
• Created various PLSQL packages implemented front end API.

Confidential, NY

Senior Oracle Database Developer

Responsibilities:

• Designed, develop, and tested (using Agile methodology) complex set of Oracle programs to report differences between new generated Ratings/Outlooks/CreditWatch and existing for Primary and Secondary Markets for various business scenarios.
• Designed, develop, and tested complex set of Oracle programs for Non-Rating Score Master database. Non-Rating Score Master database is designed to store the various types and values of scores and their supporting components (components, factors, sub-factors) that are assessed for various types of analytical entities.
• Created various UNIX shell scripts for automate process of loading data files from customers to Oracle database using SQL*Loader.
• Designed, develop, and tested complex set of Oracle programs to populate primary Participant Evaluation Group tables from staging tables.
• Designed, develop, and tested complex set of Oracle programs for Dependent Rating Notification services.
• Developed various Oracle PL/SQL programs for rating services to help investors perform efficient credit risk-driven investment analysis.
• Performance tuning complex views and PLSQL programs.

Confidential, Port Washington, NY

Oracle Developer

Responsibilities:

• Designed, developed, documented, performance tuned, and tested various Oracle PL/SQL and Java programs for supporting visits maintenance system.
• Pre-Summarized data for purpose of multidimensional analysis along a combination of “dimensions” and “hierarchies” from detail levels and populated it into data warehouse tables.
• Implement various API for Account Manager front-end application.
• Created various visit maintenance reports using Oracle Reports Builder 10.1.2.
• Created various UNIX shell scripts for automate process of loading data files from customers to Oracle database using SQL*Loader.
• Sql performance tuning. Created tables, indexes, constraints, views, types, sequences.
• Designed, develop, tested PL/SQL programs to implement API for front-end application to allow Home Health Agencies’ non-programmer workers create, update, delete export templates for custom visit maintenance export file in various formats (txt, csv, xml), and generated export files using templates. This functionality included tracking history changes, statistics, handling concurrency, and security.

Confidential, Woodbury, NY

Oracle Developer

Responsibilities:

• Designed, developed, documented, performance tuned, and tested various Oracle PL/SQL programs for supporting Confidential ’s Payroll system.
• Created various packages implemented front end API.
• Sql performance tuning. Created tables, indexes, constraints, views, types, sequences, reports.

Confidential, Jersey City, NJ

Oracle Developer

Responsibilities:

• Pre-Summarized data for purpose of multidimensional analysis along a combination of “dimensions” and “hierarchies” from detail levels and populated it into data warehouse tables.
• Created UNIX shell scripts for automate process of loading financial Excel’s reports into Oracle staging tables using SQL*Loader, and then process and loading into data warehousing tables using Plsql programs.
• Created various reports and views.
• Created programs for pivoting some tables.
• Created programs for splitting some tables.
• Created various Materialized Views.
• Sql performance tuning.
• Created various programs implemented front end API.

Confidential, Westport, CT

Senior Oracle Developer

Responsibilities:

• Designed, developed, performance tuned, and tested various Oracle PL/SQL and Java programs for supporting LifeCare services.
• Created programs for refreshing services providers from various information suppliers.
• Identified and removed duplicate providers from master table and related records from detail tables.
• Created various synchronization programs (triggers and packages) for replicated transaction actions against one database to another.
• Created package for geocoding (standardizing addresses to meet USPS CASS requirements and assign longitude/latitude) tables with customers addresses using Java-based MapInfo Geocoding Cartridge.
• Created various Java programs for correct, split, and combine data files according to business requirements.
• Created various programs for checking and reporting critical business data inconsistency or incorrection.
• Created programs for analyzing database objects according to business rules.
• Created programs for encrypting/decrypting sensitive data according to business requirements.
• Created various programs implemented front end API.
• Created Oracle space utilization statistics reports.
• Created reverse engineering DDL schema objects scripts for given schema.
• Created various UNIX shell scripts for automate process of transfer, loading data files from customers to Oracle database using SQL*Loader.
• Created various programs for correct, split, and combine data files according to business requirements using C and UNIX shell script.

Confidential, Stamford, CT

Oracle Developer

Responsibilities:

• Designed, developed, performance tuned, and tested various Oracle PL/SQL packages for supporting web based software systems in Classifieds industries (these products designed to help bring buyers and sellers together online).
• Created various Java GUI database applications using Swing, JDBC.
• Designed, developed, and tested various Classifieds Ad Stream Processing Event Monitors using PL/SQL, shell scripts, CRON (these Monitors send email notification to customers and operators when processing failure in some reasons).
• Generated various HTML reports with contents based on Oracle database using PL/SQL, shell scripts or Pro*C.
• Created Pro*C/C++ programs for implement API to Oracle stored programs for front-end C/C++ programs.
• Created various UNIX shell scripts for automate process of loading data files from customers to Oracle database using SQL*Loader.
• Created and administrated database objects like tables, views, indexes, synonyms, sequences, users.