SUMMARY:

• 20+ years of software development experience with excellent understanding of both business and technology, as well as an effective communicator with both technical and non - technical people
• Excellent in SQL, PL/SQL, Unix shell scripting and Windows batch programming
• Possess superior knowledge of enterprise IT systems and software development practices
• Expert knowledge of Oracle, IBM Optim and the workings of relational databases
• Converted a few groups of roadblocks into strong supporters of the projects
• Resolved in 15 minutes contentious design sessions that had been going on for weeks
• Ability to ramp up within days using standard documentations and manuals
• Designed and developed applications exactly as desired by end users on first attempt
• Using IBM Optim:
• In 4 months and with a co-worker, archived 22+ TB of database data and 4,000+ flat files, for a total of 46+ billion database records and 4+billion flat file records (7+TB), in addition to performing other work unrelated to archiving
• With regard to database data, about 10 times more than what was archived by an existing consulting team which has been there for 3+ years with about 5 people
• With regard to flat files, nobody I know has archived even 10% of it in the same amount of time
• In 6 weeks, masked 469 columns across 53 tables, about 4+ times more than typical
• In 8 hours, created a total of 84 new IBM Optim artifacts (Extract, Convert and Insert) to overcome an IBM Optim bug discovered 3 days before project ended, allowing the project to complete on time

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, Unix shell script, Windows batch, AWK, C, VBA

Databases: Oracle, DB2, MS SQL Server, MS Access, Sybase, Netezza, Teradata

Tools: SQL*Plus, SQL*Loader, IBM Optim, Optim Connect/Attunity, Visio, Toad

Operating Systems: Unix (Solaris, AIX, HP-UX, etc.), Linux, various versions of Windows

Hardware: Sun, AIX, DEC minicomputer, DEC Alpha, HP-9000, IBM RS/6000, Sequent

WORK EXPERIENCE:

Confidential

Consultant

Platform and tools: Oracle, DB2, MS SQL Server, Windows, Linux, IBM Optim

Responsibilities:

• Perform in-depth analysis of databases to be archived
• Heavily utilize Oracle External Tables to archive data in 4,000+ flat-files
• Create Unix shell scripts and DOS batch to automate setting up as well as archiving

Confidential

Consultant

Platform and tools: Oracle, Windows

Responsibilities:

• Create various complex Oracle views for built-in reporting tool

Confidential

Consultant

Platform and tools: Oracle, Windows, IBM Optim

Responsibilities:

• Populate and maintain 60+ Oracle tables used by IBM Optim

Confidential

Consultant

Platform and tools: Oracle, Windows, IBM Optim

Responsibilities:

• Plan deployment of IBM Optim with Oracle back-end

Confidential

Consultant

Platform and tools: Oracle, DB2, MS SQL Server, Windows, IBM Optim

Responsibilities:

• Mask sensitive data in Oracle databases

Confidential

Consultant

Platform and tools: Oracle, DB2, MS SQL Server, Windows, IBM Optim

Responsibilities:

• Mask sensitive data in Oracle databases

Confidential

Consultant

Platform and tools: Oracle, DB2, MS SQL Server, Sybase, Windows, Linux, IBM Optim

Responsibilities:

• Investigate permissions needed by various IBM Optim activities in Oracle and MS SQL Server

Confidential

Consultant

Platform and tools: Oracle, MS SQL Server, Unix shell script, SQL, PL/SQL, SQL*Loader, Windows, Unix, IBM Optim, Optim Connect/ODM/Attunity

Responsibilities:

• Archive data in Oracle databases

Confidential

Consultant

Platform and tools: Oracle, MS SQL Server, SQL, PL/SQL, Unix shell script, DOS batch, Windows, Unix, IBM Optim, Optim Connect/ODM/Attunity, Vormetric Data Security, Toad

Responsibilities:

• Design, create and maintain Oracle triggers to automatically format, copy, update and delete input data into/from various back-end tables
• Help design a new Oracle based application with web front-end
• Analyze and archive data in Oracle, MS SQL Server and Sybase using IBM Optim
• Create Unix shell scripts with embedded SQL and PL/SQL to automate the analysis of Oracle database prior to archiving using IBM Optim
• Create Unix shell scripts to automate IBM Optim archiving process

Confidential

Consultant

Platform and tools: Oracle, MS-Access, SQL, PL/SQL, Windows, Toad

Responsibilities:

• Create reports with MS-Access front-end and Oracle back-end
• Work with a very upset manager due to incorrect report spec. created by business analyst

Confidential

Consultant

Platform and tools: Oracle, Netezza, SQL, PL/SQL, Windows, Linux, Toad, WinSQL

Responsibilities:

• Maintain and enhance existing systems that loads data into an Oracle database for processing before moving the final result to Netezza

Confidential

Marketing Database Manager (started as consultant)

Platform and tools: Oracle, MS Access, SQL, PL/SQL, Windows/DOS batch, Windows, SQL Navigator, Visio, ERwin

Responsibilities:

• Design, code, implement, document and maintain applications for corporate marketing group with Oracle back-end and DOS batch (with embedded SQL) as well as MS-Access font-end
• Improve existing processes which resulted in simpler and easier maintenance
• Create a new sales site reporting application reducing the time needed to create a report from days of labor-intensive work to less than 1 hour of automated processing. This allows daily monitoring of sales sites, instead of weekly, resulting in their more efficient use and increase sales

Confidential

Consultant

Platform and tools: Oracle, SQL, PL/SQL, Unix shell script, AWK, Windows, Unix, Linux, Toad

Responsibilities:

• Debug and fix in 1 week an existing ETL application which had failed for more than 6 months
• Work with a very upset manager due to incorrect report created by another programmer who was on vacation Confidential the time the report was first run

Confidential

Platform and tools: Oracle, SQL, PL/SQL, SQL*Loader, Unix, Linux, Unix shell script, Windows/DOS batch, Visio, ERwin, Developer 2000, SQL*Forms 3.0, SQL*Menu 5.0, Pro*C, AWK, JavaScript, HTML, Visual Basic, Crystal Report, Smalltalk, Ingress, SAP ABAP/4, Profile Generator (SAP), SAPGUI 4.0, SAPGUI 4.5, Quick Test for SAP, Infomodeler

Responsibilities:

• Design and develop various applications as well as Oracle databases
• In multiple occasions, convert groups of roadblocks to strong supporters of the project

Confidential

Consultant

Platform and tools: IBM Optim, Oracle, DB2, MS SQL Server, Windows, Linux

Responsibilities:

• One of the 2 IBM Optim specialists working with a project manager and a data architect
• In 4 months, archived 22+ TB of database data and 4,000+ flat files, for a total of 46+ billion database records and 4+billion flat file records (7+TB). The largest: an 18+ TB Oracle DB (30+ billion rows). Resulting in reduction of overall project costs as well as adhering to a very aggressive schedule, enabling project completion months ahead of the original schedule
• Maintain, administer and handle any IBM Optim and Optim Connect (ODM/Attunity) issues and activities, in addition to archiving the above-mentioned databases and flat files

Confidential

Consultant

Platform and tools: IBMOptim, Windows

Responsibilities:

• Install and configure IBM Optim on Windows Server
• Mask 460+ columns in 6 weeks (first phase of project), about 4+ times more than typical
• Mask 300+ columns in another 6 weeks (2nd phase of project) allowing the client to complete the project in only 2 phases. The 2nd phase was actually completed in 4 weeks but stayed for an additional 2 weeks Confidential the client’s request

Confidential

Consultant

Platform and tools: IBM Optim, Oracle, Windows

Responsibilities:

• Mask tables containing sensitive information per agreed upon rules
• Create a total of 84 new IBM Optim artifacts in 8 hours (Extract, Convert and Insert) to work around an IBM Optim bug discovered 3 days before project ended, resulting in on time completion of the project despite the setback

Confidential

Consultant

Platform and tools: IBM Optim, Oracle, Windows

Responsibilities:

• Plan deployment of IBM Optim with the infrastructure team with regard to hardware, storage, network bandwidth, etc. Unfortunately the client put the project on hold due to merger

Confidential

Consultant

Platform and tools: IBM Optim, Oracle, DB2, MS SQL Server, Windows

Responsibilities:

• Mentor client on flat files masking using IBM Optim, Optim Connect, Federated database and LUA script

Confidential

Consultant

Platform and tools: IBM Optim, Oracle, DB2, MS SQL Server, Windows

Responsibilities:

• Verify and maintain IBM Optim masking for PeopleSoft tables

Confidential

Consultant

Platform and tools: IBM Optim, Oracle, DB2, MS SQL Server, Sybase, Windows, Linux

Responsibilities:

• Participate in enterprise level planning for IBM Optim deployment: investigate and recommend storage solutions, server hardware and data centers for IBM Optim
• Investigate permissions needed by various IBM Optim activities in Oracle and MS SQL Server

Confidential

Consultant

Platform and tools: IBM Optim, Optim Connect/ODM/Attunity, DB2, MS SQL Server, Windows

Responsibilities:

• Participate in planning for data masking using IBM Optim
• Install and configure IBM Optim and Optim Connect/ODM/Attunity
• Archive PeopleSoft Financials (43,000+ tables) and Lawson databases on DB2 LUW

Confidential

Consultant

Platform and tools: IBM Optim, Windows

Responsibilities:

• Participate in enterprise-wide storage optimization project to reduce long-term storage costs by adding cheaper storage tiers to existing storage infrastructure
• Investigate and recommend enterprise-wide usage and deployment of IBM Optim as well as applications that can benefit from it

Confidential

Consultant

Platform and tools: IBM Optim, Oracle, DB2, MS SQL Server, Windows, Linux

Responsibilities:

• Create templates to gather data on existing systems to determine their suitability and priority for archiving using IBM Optim
• Train, mentor and help new and existing IBM Optim users
• Archive databases slated for decommissioning using IBM Optim

Confidential

Consultant

Platform and tools: IBM Optim, Optim Connect/ODM/Attunity, Oracle, MS SQL Server, SQL, PL/SQL, Unix shell script, Windows/DOS batch, Windows, Unix, Vormetric Data Security, Toad

Responsibilities:

• Participate in the design of enterprise-wide archiving infrastructure as well as in investigation and determination of storage solutions and encryption solution for IBM Optim archive files
• Create disaster recovery plans and procedures for archives using IBM Optim
• Create procedures and templates to perform retirement archiving, reducing archiving time from 4+ weeks (or longer) to 2 - 3 weeks
• Install, setup, upgrade and maintain IBM Optim and Optim Connect/ODM/Attunity
• Train, mentor and help new and existing team members