EXECUTIVE SUMMARY:

A strong leader, mentor and a Subject Matter Expert in Database Development writing simple to complex PL/SQL blocks and SQL within Oracle procedures, function and packages.

TECHNOLOGY SKILLS:

• Oracle RDMBS v 4 - 11G
• Oracle Applications v 11i
• SQL Server RDMBS v 6 - 8
• Oracle PL/SQL
• SQL Tuning
• SQL Server TSQL
• Database Design
• Supply Chain
• CRM
• UNIX (Sun,IBM & HP)
• Windows NT
• Windows Server 2000
• ORACLE Administration\Tuning
• SQL Server Administration
• Perl scripting
• UNIX shell scripting
• Gravic Shadowbase DB Replication
• ProactiveNet Software
• Oracle 9i & 10G RAC
• Oracle Streams
• Oracle 11
• Oracle XML
• Netezza
• XML
• Confidential DMX Symmetrix Disk Array
• First logic Data Quality Management software
• DataStage 8.1
• Informatica Power Mart/PowerCenter 5.1/6.2
• Business Objects
• Crystal Reports
• ADP/SIS
• Confidential ControlCenter (ECC) storage management software
• ORACLE Warehouse Builder (OWB)
• Erwin
• Oracle Data Safe/Standby Database
• Oracle, RDBMS mentoring & Teaching
• Oracle Parallel Server
• PHP
• Confidential Storage Technology (SAN, NAS, DAS, CAS, IP-SAN)

PROFESSIONAL EXPERIENCE:

Confidential, Wakefield, MA

Senior Database Developer

Responsibilities:

• Solid understanding of inheriting PL/SQL object types, casting PL/SQL object types into descendant types, converting PL/SQL object collections into a result set, bulk operations and pipelined functions
• Created a data refresh process using PL/SQL blocks and SQL within Oracle procedures that refreshed data from the ODS database to the RTR database
• Developed complex PL/SQL blocks and SQL within Oracle procedures using ORACLE XML and types used by web service calls to insert, update and retrieve data from the RTR database
• Responsible for development, implementation and testing of data extraction, transformation, and load programs for large marketing database projects
• Worked together with the client team to design solutions and implement programs according to the requirements and timelines specified in the statement of work
• Worked with Data Warehousing and Marketing Databases using Oracle and Netezza
• Worked with First logic Data Quality Management software for data hygiene and merge/purge logic
• Implemented a process that will send out real - time emails using Harmony based on rules that were stored in the database.
• Created an Oracle XML process that created XML files based on changes made to the RTR database, then these files were loaded into the ODS database
• Worked with DataStage 8.1 for extract, transformation and load (ETL) applications
• Developed 200+ scripts using UNIX ksh93 and Perl
• Programmed using Toad for Oracle creating simple to very complex PL/SQL blocks and SQL within Oracle procedures and functions within packages
• Responsible for database design, tuning and management
• Implemented a reusable process that creates data extracts, by just updating Meta data tables.
• Implementation of business intelligence and marketing automation solutions
• Refined standards to improve quality and productivity
• Documented all work and facilitated support of ongoing operational responsibilities
• Provided requirements to the technology delivery group to improve product integration, internally developed infrastructure components, and application
• Participated in code reviews and acceptance process to improve methodology and delivery

Confidential, Tewksbury, MA

Senior Database DBA/Programmer

Responsibilities:

• Designed, Configured and Maintained Oracle Database partitioning (18 Hash; 9 TS) on a 2TB - 5TB Oracle 8i and 10g databases
• Provided 24 by 7 on-call Database/Application/Oracle Replication support for 12 Oracle 8i, 6 Oracle 10g production databases worldwide
• Provided Oracle technical leadership and direction for the company
• Designed, Configured and Maintained Oracle replication master to master across 10 database nodes replicating data from MA to CA
• Researched and installed Oracle database patches/upgrades for Oracle 8i and 10g production databases worldwide
• Upgraded and Migrated 8i database running on SunOS 5.9/ Confidential CX300 SAN to Oracle 10G on RHEL5.2 Linux running on HP DL380,/HP MSA2012 SAN
• Conducted Application, Database, SAN, Server Performance reviews and then providing findings and recommendations to the senior leadership team
• Created and Supported Unix Shell scripts executed by Unix CRON Jobs and Oracle stored procedures executed by DBS Jobs for database monitoring, backup, maintenance and data transformations
• Designed, Configured and maintained Oracle BLOBs
• Programmed using Toad for Oracle creating simple to very complex PL/SQL blocks and SQL within Oracle procedures and functions within packages
• Dealt with complex performance, usability and productivity issues with Database, SAN, Server and Application
• Responsible for database code release process to QA and production databases
• Responsible for daily Database Administration tasks
• Used Oracle STATSPACK and home grown tools to monitor databases to assist with performance problems with database/application
• Mentored developers with PL/SQL and SQL(development and tuning)
• Developed disaster and recovery procedures for all databases
• Operating Systems: SunOS 5.9, RHEL5.2, Windows,VM Hardware: SUN-FIRE V490, Confidential CX300 SAN; HP DL380, HP MSA2012 SAN Database: Oracle 8i 64 bit, Oracle 10G 64 bit, Oracle 11g Database Sizes: 10 OLTP 2- 5TB OLTP; 8 DW 1 - 2 TB Logging and Reporting; 2 Customer service 900GB

Confidential, Beverly, MA

Senior Database DBA/Programmer Consultant

Responsibilities:

• Migrated a Microsoft SQL Server database (schema, data, views, triggers and stored procedures) to an Oracle 10G database using Oracle Migration Workbench
• Converted SQL Server stored procedures to Oracle Stored Procedures
• Designed and Developed a Database Data Retention policy for an Oracle 10G R2 database data using Meta data tables and procedures/functions
• Designed and Developed a Backup and Restore methodology for an Oracle 10G R2 database using Oracle Data Pump
• Designed and developed some Oracle Java stored procedures and classes that were used by various stored procedures
• Programmed using Oracle SQL-Developer creating simple to very complex procedures and functions within packages
• Developed Microsoft Windows bat and VB scripting to create scripts that installed Oracle 10G R2 binaries, created ORACLE 10G database, configured listener/tnsnames and install/configured EM
• Developed application schema creation, release and data loading scripts using to Windows bat scripting
• Designed and Developed Oracle External Tables for data loading
• Designed and Development Oracle Loader Script to load application lookup data into the database
• Conducted Application and Database Performance Tuning
• Created a fully populated sample database for performance and application testing
• Software: 7-zip, Microsoft .NET, VBScript, Oracle SQL-Developer, CVS
• Operating Systems: Windows XP Professional
• Hardware: Dell Servers/PC’s, Raid 5
• Database: Oracle 10G R2, SQL Server Version 2000

Confidential, Hopkinton, MA

Senior Solutions Architect

Responsibilities:

• Designed, Implemented, Configured and Maintained 3 Large Data Warehouse Oracle 10G databases
• Translating the business requirements into a logical data model and then into a physical model using Erwin
• Designed and Implemented Data loads, Meta data, Rollup and Reporting Oracle Database schema’s
• Designed, Implemented and Maintained Oracle Table Partition for very 100 large Oracle tables for performance and Maintains concerns
• Delivered Technical Architectural Design, Strategies and Plans to clients through the engagement on Oracle Database Technologies
• Designed and Implemented very complex Billing/Chargeback PL/SQL engines (Oracle Stored Procedures within Packages); These engines were used to properly bill the client for hardware (SAN, NAS, CAS) and Labor Usage
• Designed and Implemented Oracle Stored Procedures within Packages, which were used to produce delimited files; These delimited files were then used to feed various clients systems
• Designed and Implemented Oracle Stored Procedures within Packages which allowed the client and internal group to retrieve and maintain data in the DS/DW database through a portal application
• Designed, Implemented and Maintained a Data Loading framework using Oracle SQL loader, DB Meta data tables and PHP; The Data Loading Framework was used to load data from client site into are Data Warehouse database for reporting, billing usage and portal view; It was build to retrieve XML files that were generated offsite from Confidential Control Center (ECC)
• Created and Implemented various of database processes
• Researched, designed and implemented a prototype project using Oracle Warehouse Builder (OWB) on Oracle 10G database

Confidential, Boston, MA

Senior Database DBA/Programmer

Responsibilities:

• Assisted in Technical Design of an Enterprise Information Strategy (Data Warehouse, ODS), that will enable company to increase the effectiveness and efficiency of its customer data (Oracle, ADP/SIS, SQL Server, MS Access, MS Excel) analytic and reporting capabilities and enhance the firm’s ability to accurately determine customer, account and product profitability
• Worked closely with a consultant company in creating a Enterprise Information Strategy using Oracle 9i & 10G, Informatica (ETL) and Business Objects (reporting)
• Installed, Configured and Supported Informatica Power Mart/PowerCenter 5.1/6.2 Repository on a UNIX/Oracle platform
• Designed and Developed a ETL methodology for supporting data transformations and processing, in an enterprise wide ETL Solution using Informatica Power Mart/PowerCenter 5.1/6.2
• Installed, configured and supported Business Objects Web Intelligence, Designer and Universes
• Installed and Configured ProactiveNet Software to monitor, identify, diagnose and resolve performance problems for are mission critical Oracle 8i, 9i, 10G databases (1-2TB, 500GB, 100GB) across all environments on an Confidential SAN (DMX)
• Assisted with on-call Database and Replication performance, usability and productivity issues
• Designed and Configured Oracle Database partitioning for a 1TB database
• Assisted in supporting Oracle Databases and Database Replication for are yearly disaster and recovery tests
• Designed a temporary reporting management system using Crystal Reports 6 and Oracle PL/SQL on a windows platform
• Assisted in technical design for a Replication Strategy for are Enterprise Information Strategy (Gravic Shadowbase, Oracle Streams, Golden Gate)
• Designed, Installed, Configured and Developed the Replication Strategy using Gravic Shadowbase, replicating real-time data from an ADP/SIS system on a NSK Platform to an Oracle 9i Database on Unix; The database was then used by the 24 by 7 Web application to access customer data and Enterprise Information Strategy for analytic and reporting capabilities
• Designed, Developed and Tuned Oracle Stored Procedures, Functions, Packages, Views, External Tables, Triggers for an existing and new Web Application
• Translating the business requirements into a logical data model and then into a physical model using Erwin or Oracle Designer
• Created and Supported Unix shell and Perl scripts for database monitoring, backup, release and data loads on Unix SUN servers platform
• Designed, Installed and Configured 2 Node RAC Oracle 10G R1 on a Unix platform
• Designed various Oracle 10G & 9i security features to protect sensitive data using roles, group policies, views, resource groups, transparent data encryption, column level encryption and database auditing
• Installed, configured & supported (OFX) on Oracle9i to exchange financial information on a common data-stream format to different financial software
• Created database strategies for high availability and recovery using VERITAS and Confidential SAN (DMX) for Oracle 8, 9i 10G databases in both archive/no-archive modes
• Installed and supported Oracle upgrades from Oracle 8 to 9i and Oracle 9i to 10G

Confidential, Cambridge, MA

Senior Technical Specialist

Responsibilities:

• Subject matter expert for Oracle database technologies (Oracle 7, 8 and 9i)
• Defining and communicating product/solution recommendations to clients/teams
• Creating database strategies for high availability, performance, recovery and security
• Driving the team in designing the implementation plan for the database
• Hiring, managing and mentoring database professional’s company-wide
• Identifying all interfaces between various databases and systems
• Translating the business requirements into a logical data model
• Sizing databases, identifying and sizing database servers, peripherals (disk sub-system, RAID, backup servers) and software; clustering, replication, and parallel server solutions)
• Conducting SQL, database administration and tuning classes company-wide
• Conducting weekly Database, SQL and Data Model reviews with the team and DBA, to ensure the quality of the database implementation and integration
• Working collaboratively with clients to ensure business objectives were being met
• Working on many database implementation using Oracle, SQL Server, Informix, DB2 and Sybase
• Working on large (800G) to small (1G) mission-critical database (OLTP, DDS, DWH) projects as the Senior Database Specialist (Over 200+ Projects)
• Writing detailed architectural and infrastructure documentation
• Ensuring that the application's data architecture is complete and meets the business needs
• Dealing with performance, usability and productivity issues
• Assisted in designing an Oracle Replication solution of over 20 nodes
• Designed, Installed and Configured 2 Node Oracle Parallel Server environment on a Unix platform using Oracle 8 for high availability and performance
• Designed, Installed and Configured many Oracle Standby databases for recovery, reporting and testing usage
• Installed and supported various Oracle upgrades from major to minor patches between the following Oracle versions: 7 to 8, 8.1.4 to 8.1.5 and 8 to 9

Confidential, Wakefield, MA

Senior Engineer

Responsibilities:

• Installed, managed and configured and sized development databases
• Tuned, configured and sized databases to insure that they performed efficiently in production
• Created and maintained source control for database code
• Performed reorganization and maintenance on the database
• Generated the physical database design for the data model
• Kept the logical and physical data models synchronized
• Created data loading procedures using the Oracle loader
• Coded simple to complex business problems in SQL and PL/SQL (Engines & Feeds)