SUMMARY

• Utilizes strong knowledge and experience with Oracle Database concepts blended with Oracle Financials System Administration and PL/SQL programming.
• Qualified PL/SQL Developer.
• Working on NYU SCP Certificate in Java Programming

TECHNICAL SKILLS

Operating System: Unix (HPUX 10.20, HPUX 11), Windows 2000, NT 4.0/3.xx, Windows 98/95, MS Access 2000, Front Page 2000, Apache 1.3.9

Languages: SQL, SQL*Plus, PL/SQL, Unix Shell Scripting, JAVA SE,VB Script, JavaScript, EMACS, VI, HTML,PHP

Databases/Tools: Oracle7.xx, 8.0.5, 8i, 9i, Oracle Financials 10.7, Oracle 11i Application Suite utilizing modules Adadmin, Adpatch, Adrelink, Flexfields, MultiOrg, AP, GL, PO, AR, BOM, FA, INV, ENG, CST, MRP,ERP Module configuration and patching, Sysadmin, Concurrent Managers, Workshifts, Concurrent Request Administration, Oracle Enterprise Manager, Oracle Server Manager, SQL*Loader, System Architect, Oracle Discoverer 4i, 9i AS, Developer/2000, Developer 6i,Views, Materialized Views, Partitioning, Procedures, Triggers, 9iR2 RAC, TOAD, Application Designer v8.49, DataMover, Control - M,Data Modeling, WebLogic

Networking: Microsoft NT Enterprise, Sqlnet, TCP/IP, NET8

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer/Data Analyst

Responsibilities:

• Working with the Data Stewards to analyze and document five applications in terms of data architecture.
• Understanding of securities ratings business processes and S&P content delivery systems.
• Worked with documentum and Pega with primary focus of PL/SQL.
• Wrote data definitions for data dictionary effort.
• Established business rules through analyzing packages,procedures,functions, collections and documentation.
• Used Oracle Standard views to establish inventories of objects to be analyzed.

Environment: Windows 7, Oracle 11.2

Confidential

Oracle Developer

Responsibilities:

• Modifying business logic to include validation rules by writing functions. Data Architect for small application.
• Working with Control - M scheduler to develop jobs using DOS and Powershell scripting.
• Data warehouse development and tuning of long running queries for performance.
• Develop data loading database application for displaying financial data with Bulk Collect, Dynamic SQL and external tables.
• Utilized PL/SQL to create procedures, functions and packages.
• Writing Technical Design documents and specifications for Direct Debit report.
• Designed tables for data capture based on Bank Credit Card Documentation.
• Wrote production deployment scripts for applications.

Environment: Windows 2008 Server, Oracle 11.1

Confidential

Oracle Developer

Responsibilities:

• Working with Cash Team on Data Warehousing Projects
• Building complex views for Treasury and Brown Brothers internal and external client reports.
• Utilizing Bulk Collect for Insert and Update operations.
• Implemented UNIX shell scripts through cron to load data with external tables.
• ETL processing for new Risk Management application with staging and fact tables.
• MQ experience with FX applications.
• Utilized PL/SQL to create procedures, functions and packages.
• Design and implement FX application for tracking and recording currency rates.

Environment: AIX 5.3 Oracle 10.2, Oracle 11.1

Confidential

Peoplesoft DBA/Developer

Responsibilities:

• Mask sensitive data by writing PL/SQL functions and procedures which utilize hashing, collections and UTL FILE
• Explored utilizing Row Level Security and Virtual Private Database.
• Wrote Excel Macros to create DataMover scripts which load bulk configuration changes for Application Security modules.
• Wrote and executed DataMover scripts to Export and Import Tables, Insert data into PeopleSoft tables.
• Use Application Designer 8.49 to re-engineer Peoplesoft Module configuration queries to improve refreshes and documentation.
• Ran PeopleSoft conversion programs to input Customer data from flat files into the PeopleSoft database.
• Troubleshoot configuration issues by convening with Functional and Technical Specialists between State Government and outside consulting agencies.
• Work with the State Team to explore and recommend sensitive data classification.
• Write Documentation and make presentations describing my work progress.
• Utilize Bank documentation to mask Credit Card numbers for test data and Data Architect masking application.
• Masked Reference Data of Financial Transactions to protect confidentiality of State Clients.

Environment: AIX 5.3 Oracle 11.1

Confidential

Oracle Developer

Responsibilities:

• Query tuning with Explain Plan.
• Writing P/L SQL code using packages like dbms lob and other standard packages
• Participated in Agile Planning and Scrums.

Environment: Windows 2003 Oracle 10.2

Confidential

Oracle Database Administrator

Responsibilities:

• Writing P/L SQL procedures, functions for Text Messaging Application.
• Partitioning, Very Large Database volume
• Working with collections, following Specifications, Unit Testing, and Integration Testing.
• Adapting database package for Java Messaging Application.
• Resolving production support issues related to Wireless Carriers.

Environment: HPUX 11.1, Oracle 9.2.4, 10.2

Confidential

Senior IT Consultant/Oracle DBA

Responsibilities:

• Worked at HBO on contract as an Oracle DBA supporting inventory management, marketing and data warehousing applications
• Oracle 10g OCP. AIX shell scripting, PL/SQL programming with packages, procedures
• Working with clients to gather requirements and create ERD with Embarcadero. Excel 2003 Macro programming.
• Created VBA macros for Audience Research application.
• Xytech tape management system upgrades. This system handled scheduling and shipping invoices for video tapes.
• FileMaker 5.5 administration and exports. Ran database software for preparing files to be refreshed on Beta Server and ran export utility.
• Contributed to retiring proprietary FileMaker Pro application for shipping inventory to Oracle 10g.
• Artesia database upgrades: Interfaced with Project leaders to solve upgrade issues related to data problems.
• Working with users to refresh schema data from transactional to query instances
• Data modeled ATP application, wrote and tested a small PL/SQL application to drop data partitions for self service java application with the Sales and Marketing
• Created, wrote and tested a small PL/SQL application to transfer data from flat files to Oracle tables and generate email to verify transfer. Also created Bourne Shell script to activate data transfer and scheduled it with Autosys.
• Data Architected Audience Research application to improve data load efficiency with ETL processing.

Environment: AIX 5.3 Oracle 9.2.4, 10.2

Confidential

Senior IT Consultant/Oracle DBA

Responsibilities:

• Worked with 8i, 9i, 10g environments and Retek and Lawson Applications.
• Exports, Imports, HP-UX shell scripting, on call support.
• Table space monitoring and adding data files
• Development support including writing storage parameters, constraint modification and correcting syntax errors during testing.
• Change management and application upgrades. Index rebuilds and partition rebuilds. Web Server and database monitoring.
• Metalink TAR requests Auditing support and capacity planning monitoring.
• CA Harvest administrator. Performance tuning
• Compiling ProC. Working with Perl scripts

Environment: Windows 2003 HPUX 11.1 Oracle 8.1.7, 9.2.4

Confidential

Application Developer Consultant

Responsibilities:

• Contract with Confidential to do data cleanup and maintenance.
• Creating PL/SQL packages, procedures and functions. Resolved validation problems involving duplicate participants and missing participants on digital product tracks.
• Also corrected metadata of product descriptions by using XML tools for schema validation.
• Interfaced with Marketing department to expedite new release registration for the Confidential digital catalo
• Assigned small projects in the form of bugs to be fixed on a day to day basis.
• Interfaced with recording engineers to establish appropriate standards for validation of metadata
• Interfaced with European and Asian affiliates to resolve validation issues related to product metadata.
• Gave technical assistance to Java group about queries and other database issues.
• Reconciled data between different databases and product types.

Environment: HPUX 10.5 Oracle 8.1.7, 9.2.4

Confidential

Owner/IT Consultant

Responsibilities:

• Worked with a business analyst formerly with KPMG to create ERD and data flow diagrams for medical records application startup using Access.
• Designed and implemented small data warehouse with star schema configuration and ETL with SQL*Loader for educational client utilizing Oracle Enterprise Manager.
• Created driver inspection database, including forms and reports using MS Access for messenger service
• Teach Clickon@ the Library classes in MS Office at NYPL in the Bronx. Effectively trained computer illiterate clients to make them employable using Excel, Microsoft Word and PowerPoint.
• Created curriculum, presentation slides and exercises for in-class practicing.
• Also individual tutoring and mentoring utilizing special projects in PowerPoint and Excel which included integrating video, animation and images.
• Trained individuals in how to utilize the internet and how it works.
• Created handouts and curriculum to explain concepts. Also train in Photoshop and ImageReady utilizing hands on practice and guidance.
• Training doctors and nurses in a hospital setting to use HIPPA compliant medical records software.
• On call for one-on-one consultation and mentoring.
• Modified OS Commerce package written in PHP to have Guest Log In for Web Site.
• Troubleshoot hardware and software as well as network issues for small businesses.

Confidential

Database Administrator- Oracle Financials System Administrator

Responsibilities:

• Lead team of two other DBA’s to maintain reorganization, daily monitoring and troubleshooting of problems over 3 instances with a total of 131 Gigabytes of data.
• Worked with upper management in the establishment of a new instances and created capacity plan and presentation explaining the case for establishment of the new instance. A new development box was purchased and configured for a Financials 11i instance.
• ANSI SQL development, SQL Server Administration
• Recovered tables by creating individual table space from synchronized data files
• Supported developers in testing data warehouse application to certify production database upgrade of data warehouse instance.
• Established benchmarks for this process.
• Data Warehouse profitability application utilizing Explain Plan to tune queries. Created procedures and functions with PL/SQL.
• Created tables with storage parameters and indexing which improved performance of 3 million-row data set from 24 hours to 3 hours.
• Worked with Oracle Support on Financials Issues related to HPUX platform and applied patches to both production and Training Instances.
• Successfully troubleshooting of these issues resulted in significant uptime in Production Instances.
• Monitored logs to maintain backups were done correctly as well as Alert logs to determine proper operation. Also worked with SA to tune the instance.
• Recreated 5 Gig + tables using Temporary Tablespaces and SELECT statements.
• Sized and built Oracle 8.16 database for Oracle Financials 11i instance on its own hardware.
• Did Manufacturing application data purges and other system admin functions like solving printer configuration issue.
• Periodic refresh training instances with production data without the use of exports.
• Coordinated with developers for Financials data purging and index rebuilding, as well as tablespace reorganization.
• Consolidated shell scripts, which could move developer scripts from multiple training boxes across the network to a production instance and have auditing functionality.
• Stabilized data media utilization to postpone the purchase of new storage media.

Environment: HPUX 9.4 Oracle 7.3.4, 8.0.6, 8.1.7

Confidential

Developer

Responsibilities:

• Designed process utilizing SQL*LOADER for table data in batch processing improving efficiency.
• Configured ODBC drivers to allow client access of server databases.
• Assisted DBA’s in troubleshooting application problems associated with Y2K compliance.

Environment: Windows ME, Oracle 7.1

Confidential

Developer

Responsibilities:

• Designed testing procedures for reports and forms that improved quality of service to users.
• Added flexfields to Version 9.4 Order Entry Modules which improved product ordering.
• Utilized Pro*C to create customized data sets for batch processing ETL thereby improving order processing time.