SUMMARY:

Confidential is a Database technical IT professional with over 30 years of experience in information systems technology. With an extensive background in management, sales and finance, he is a specialist in the use of computer technology, systems integration, conversion, migration, customization and performance tuning. He also has a great deal of experience in the analysis, design, development and implementation of computer systems, particularly in Oracle and Unix environments. And while many people are fixed on rigid technical issues and limited stereotype protocols, his primary concern is in satisfying the needs of management and the end user. This is achieved through complete flexibility and very creative, imaginative and original solutions.

• Business Analysis
• Quality Assurance
• Quality Management
• Data Migration
• Data Conversion
• Data Integration
• Data Optimization
• Data Warehouse
• Change Management
• Systems Analysis
• Systems Design
• Data Analytical Skills
• Innovation
• Imagination
• Business Requirements
• Technical Requirements
• Functional Requirements
• Critical Thinking
• Problem Solving
• Presentation Skills
• Communication Skills
• Migrated proprietary legacy financials system (FoxPro) to Oracle EBS Financials. Customized and added required functionality to maximize automation capabilities, fully utilizing every possible feature of the Oracle Financials Suite. (Financial Management Unit - Confidential )
• Created, tested and optimized systems for Stock Market firms including Corporate Reorg, Corporate Actions, Security Segregation and Exchanges, Washed Tax Lots Accounting, Cashiers Management, Collateral Management, Credit and Risk, etc. (DGT - Davidson Global Technologies)
• Designed, created, optimized and maintained a Data Warehouse for regional sales, marketing, analysis and reporting to various departments for a variety of corporate requirement (Costco)
• Developed completely automated AI expert system to test aircraft and other large machine oil samples and predict oil change, tune-up and/or maintenance requirements and the overall state of the equipment. (PMC - Predictive Maintenance Corp)

TECHNICAL SKILLS:

Operating Systems: Unix, Linux, Solaris, Xenix, AIX, HP-UX, DOS, Unisys and IBM Mainframe, VMS, Windows

Software: ORACLE Ver. 8.1.7, 8i, 9i, 10G, 11i, 11g;

Oracle: RICE (Reports, Interfaces, Conversions, Extensions), eBusiness Suite (EBS), Financials, Discoverer, OLAP, Developer, Designer, Forms, Reports, TOAD, SQL Developer, PL/SQL Developer, AquaData Studio, SQL*Loader, SQR

Peter Martin Associates: (PMA) FACTORS, HTML, rpt, rpt2c, ctar, awk, sed, Access, FoxPro, Sybase, PostgreSQL, Rexx, lynx, Lotus Notes (Domino), etc

PROFESSIONAL EXPERIENCE:

Confidential

Senior Unix / Oracle / Actimize Developer, Support and Troubleshooter

Environment: Develop, Customize and Maintain varied and various Anti-Money Laundering (AML), Market Manipulation, Fraud and other irregular Market activities Software for Deutsche Bank with Actimize AIS, RCM, etc.; Working with Big Data on Database Design, Development, ETL, Data Cleansing, De-Duping, Integration, Aggregation, Reconciliation, Exploration, etc. Develop ETL, WSDL, SOAP, Corvil and Data Management processes. Modify, troubleshoot and optimize Control-M, PL/SQL, awk, java, Python and perl scripts.

Confidential

Oracle Lead Developer, Support and Troubleshooter

Responsibilities:

• Consulting on various stages of migrating from Main Frame Legacy Premium and Billing System to Custom Oracle Application.Create scripts to verify integrity of migration code and data, including Ad-Hoc Reports.
• Resolve any discrepancies between Legacy and Customer Application functionality, performance and batch process results.
• Maintain version control (TFS - Source Control Explorer, Microsoft Visual Studio).
• Modify existing and create new Packages, Procedures, Function, etc. to enhance performance (Performance Tuning) and functionality
• Optimize code thru creation of Indexes, Primary and Foreign Keys.
• Create and maintain backup and restore tables and data, etc

Confidential

Oracle Lead Developer, Support and Troubleshooter

Responsibilities:

• As all aspects of the work here at the Fed are very sensitive and highly confidential, I can only be very general about the work that I am involved with:
• Most of the work centered around Oracle Database: analyze, design, development, documentation, migration (from Unisys Mainframe) and maintenance, data loading (ETL), PL/SQL, create, modify, enhance and debug Packages, Procedures, Triggers, Functions, Database Links.
• Application (forms and reports) troubleshooting, support, maintenance, enhancements and development, deployment.
• Also, support and debugging of IBM (Domino) Lotus Notes 9, WSDL and MS Access 2007 Applications.
• In Development, QA and Production environments.

Confidential, MidTown, Manhattan

Oracle Lead Developer

Responsibilities:

• Conform to the ICD9 to ICD10 revisions (International Classification of Diseases Codes) which included expanding certain columns and adding a conversion date and revision column to necessary objects1) create inventory of all end user schemas and objects for 17 Oracle Databases and Unisys Mainframe; including Tables, Views, Materialized Views, Indexes, Packages, Procedures, Triggers, Functions and SQL*Loader Control files.
• Identify the objects needing remediation and document same create Oracle Tables to store Total and ICD related inventory objects create Procedures to update and keep current all ICD inventory objects create Procedures and Views that automate and keep current Alter Tables scripts to add the new columns to the Tables that are being remediated
• Automate Procedure to identify by Procedure, Package, Function and Trigger specific line numbers of code where remediation is required
• In anticipation of the integration of these Database into one DataWarehouse, map source and target objects

Confidential

Oracle Lead Developer

Environment: Convert, optimize and test SQL Server and Unisys Banking Application to Oracle PL/SQL Procedures on Oracle Exadata Platform.

Confidential

Senior Oracle Developer

Environment: unix, Unisys, java, Windows XP; Oracle 11g, SQL, Sybase, PL/SQL, SQL*Loader, Toad, Forms, Reports, Aqua Data Studio, SQL Reports, Crystal Reports, including Ad-Hoc Reports.

Responsibilities:

• DGT is a Boutique Software Development house with clients like Confidential, Merrill Lynch, Royal Bank of Canada, Jefferies, Nomura, UBS, etc.
• Worked on Development, Testing and Debugging of products including Corporate Reorg, Corporate Actions, Security Segregation and Exchanges, Washed Tax Lots Accounting, Cashiers Management, Collateral Management, Credit and Risk, etc.
• Modify and Troubleshoot existing PL/SQL Procedures and Packages (Performance Tuning), Oracle Forms and SQL Reports and create new ones against multiple Databases.
• Create and enhance PL/SQL stored procedures, functions, trigger, indexes, views, materialized views, etc.
• Create, clone and maintain multiple Development, QA and Production Oracle and Sybase databases. Create load scripts from varying data sources.
• Cleanse and merge incoming data from various trading and securities feeds CCH, DTC, etc. Create 1099 system for clients of various day trading firms. Convert Sybase data, stored procedures, functions, triggers, etc to Oracle.

Confidential, Stamford, CT

Senior Oracle Discoverer / Developer, Data Analyst

Environment: unix, Unisys, Windows XP; Oracle 10g, SQL, PL/SQL, SQL*Loader, Toad, Discoverer Viewer, Plus and Desktop

Responsibilities:

• Modify and Troubleshoot (as Administrator and User) existing Discoverer and DataWarehouse Reports and create new ones against multiple Data Warehouses.
• Enhance functionality of existing reports and create new reports from Sales, Accounting, Manufacturing and Inventory data.
• Create PL/SQL procedures, triggers, tables, views and functions to facilitate these reports, based on the Oracle core Financials, Manufacturing, Inventory, WIP, BOM, OE, etc. and two datawarehouses coming off of them.

Confidential

Senior Oracle Developer, Data Analyst

Environment: Unisys, Windows NT, 2003, XP; Oracle 10g, SQL, PL/SQL, SQL*Loader, Toad, Oracle Developer, Designer, Seapine Surround and Test Track.

Responsibilities:

• Expand functionality for a RIS (Radiology Information System) system.
• Develop a Generic Data Migration (ETL) system for the RIS system from many variable databases and formats.
• Included were a Patient Visit module, Exam Scheduling, Insurance Authorization and Verification, Physician Accessibility, Billing System, Claims System, Collections, Transcription, Report and Document Archiving and Retrieval and Financial Reporting.
• Also, Install and create scripts to Clone Oracle for Development, QA and Production.
• Create PL/SQL procedures, triggers, tables, views and functions to add functionality to existing and new modules.

Confidential

Senior Oracle Technical Lead / Developer / Data Analyst

Environment: Windows 98 / NT / 2000, Solaris 2.8, Unisys, Oracle RAC, Oracle8i, 9i, 11i and 10g, SQL, PL/SQL, SQL*Loader, HTML, Oracle Developer, Forms & Reports, Designer and Discoverer, awk, sed, Unix shell script.

Responsibilities:

• Installation, Set Up and Implementation of Oracle Public Sector Financials. Maintain Logical and Physical Database Design.
• Install patches and updates to the Databases. Create automated procedures to Import / Migrate Legacy Data from FUND-EZ and FMIS Legacy Systems; Interview and Document Auditors, Accountants, Bookkeepers and Social Workers to determine work flow, legal compliance requirements and best practices; both time and monetary, based on Department, City, State and Federal mandates for the accounting processes.
• Create working documents, procedural and technical, and get sign-off at all levels. Monitor and supervise Oracle Financials Team, Functional and Technical, to ensure compliance with documents.
• Create link between Peter Martin Associates FACTORS Client Management System to automatically transfer new Clients from FACTORS to Oracle Financials. Create annual templates for AR, AP, and GL to automate monthly processes.
• Customization and automation of all procedures. A/R, A/P, PO, OE, GL, INV, CM, etc., by way of PL/SQL Packages, Procedures, Functions, Triggers, etc. Create Custom Menus, Forms, Monthly and Annual Reports, etc

Confidential

Senior Oracle DBA / Developer / Systems Analyst

Environment: Windows 98 / NT, Solaris, Oracle WebServer, Oracle 8.051, SQL,PL/SQL, SQL*Loader, HTML, Oracle Developer, Reports and Designer.

Responsibilities:

• Installation, Implementation, development of Bolt-On Screens and Customization of Oracle Financials; design member, course, test, certification, subscriber, etc.
• DataBase; create custom forms, reports, etc.; A/R, A/P, GL, Order Entry, Inventory, Training, etc.

Confidential

Oracle DBA / Developer

Environment: Windows 95 / NT, Oracle WebServer & WebDB, Oracle 8.05 & 8i, SQL,Oracle Security Server, PL/SQL, SQL*Loader, HTML, Oracle Developer and Designer

Responsibilities:

• Various Oracle DBA activities including ETL, Data Migration, DataWarehousing modeling; Create Virtual Database on a frame relay system, for 8 county providers, each with its own server and instance of Oracle, to identify common activities, clients and services.
• Create algorithms and procedures to match up clients in all 8 provider databases in order to seamlessly view data on an individual no matter which or how many of the provider database they appeared

Confidential

Oracle DBA / Developer

Environment: Windows 95 / NT, Solaris 7, Oracle WebServer, Oracle 8.05, SQL, PL/SQL, SQL*Loader, HTML, Oracle Developer, Designer and Discoverer

Responsibilities:

• Various Oracle DBA and Development activities including Data Cleansing (Hygiene) and DataWarehousing modeling, development and implementation for US West, Costco; for marketing and statistical analysis

Confidential

Oracle DBA / Developer

Environment: Windows 95 / NT, Solaris, Oracle WebServer, ORACLE 7.3 & 8.0, SQL, PL/SQL, HTML, Java, Developer 2000

Responsibilities:

• Design and implement an Oracle DataBase Design for this new MLM Nutrition Company;
• Develop a Web presence with Oracle Web Server and eCommerce site with Oracle eCommerce Application Server.
• Develop programs and procedures to calculate sales and commissions, process credit cards, display upline and downline

Confidential

Oracle DBA / Developer

Environment: Windows 95 / NT, Unix, Oracle WebServer, ORACLE 7.3 & 8.0, SQL, PL/SQL, HTML, Java, Developer 2000

Responsibilities:

• Web Site Development for the Freight Industry with Oracle Web Server and ESRI GIS and Mapping Software.
• Oracle DBA responsibilities including Database modeling, architecture and site integration - After consultation with representatives of the Freight Industry designed and created a relational database structure and gave on-line functionality to a static Demo Web Site.
• Converted existing static html to dynamic PL/SQL code integrated with Oracle Web Server and Database.
• Developer 2000 Menu System for Maintenance of tables, Designer 2000 for schematic view and program flow and future enhancements.

Confidential, AutoNation

Oracle Developer / Systems Analyst

Environment: Unix, ORACLE, SQL, PL/SQL, SQR, Windows 95 / NT

Responsibilities:

• Design and implementation of Database Design and Architecture for Predetermining future value of used cars, using data from various sources, including development of the programs and procedures

Confidential

Oracle Developer / DBA / Systems Analyst / Unix Admin Functions

Environment: Unix, ORACLE, SQL, PL/SQL, SQR, Windows 95 / NT

Responsibilities:

• Largest Office Supply Company; develop reports and unix scripting and menuing; audit and production reports and bar coding of product labels; consolidation of inventory and warehouse management system controls, etc.

Confidential

Consultant / Analyst / Programmer

Environment: Unix, ORACLE, SQL, PL/SQL, SQR, Developer 2000, Forms 4.5, Windows 95 / NT

Responsibilities:

• Large Mail Order Catalog Distributor: developed statistical analysis forms and projections for sales by catalog, issue, year, geographic location, product, etc.