Experienced
database expert seeks Oracle Management /Database Architect /Development role.
Summary:
· Twelve years
database development, design and programming experience using Oracle, MS SQL
Server and Sybase.
· Oracle database
developer, Oracle PL/SQL developer, Oracle ETL developer, and PL/SQL performance
optimizer. SQL Server database
developer, ETL developer and database administrator. Data Transformation Services (DTS) developer.
Highly skilled with MS Access, Visual Basic and VB Script.
· Excellent people
skills and very effective team player. Experience working with owners,
presidents, vice presidents, directors, managers, colleagues, users, customers,
clients and vendors.
·
Continually motivated to learn and
apply new professional skills.
· Experience Includes:
American Express, Fidelity Investments, Microsoft, Thomson Financial Services, Goodwin
Procter LLP. Previously licensed Series
7 Investment Manager.
Technical Skills:
· Oracle PL/SQL, PL/SQL Optimization, Stored Procedures, Packages,
Triggers, Indexing, SQL, SQL Tuning, Oracle Regular Expressions, ETL
· Database Programming, Database Administration, Database
Architect/Systems Designer
· Microsoft Certified Professional (MCP) Since 1999 - MS SQL Server,
Visual Basic
· Database Tuning and Optimization MS SQL Server 2005, 2000, 7.0,
6.5, ETL, Data Transformation Services DTS, Maintenance Plans, Jobs, Alerts, VB
Script, Query Analyzer
· RDBMS – ORACLE 10g, 7.0; MS SQL Server 2005, 2000, 7.0, 6.5;
Sybase System 11, 10
· Programming – PL/SQL, SQL, Transact-SQL T-SQL; VB Script, Visual
Basic 6.0, 5.0, 4.0; MS Access XP, 2000, 97, 95, 2.0; Visual Basic for
Applications, VBA, Active Server Pages ASP, Cascading Style Sheets CSS
· CASE Tools - Erwin, PL/SQL Developer, QDesigner, Sybase Data
Architect, Power Designer
· OS - Linux, Windows 2k3/2k Server, XP, NT 4.0, 98, 95, 3.x, Dos
EXPERIENCE:
www.OracleExpert.net
6/2007-Present
Lead Database
Architect / Lead Developer / Founder
LeapFrogRx 12/2006-6/2007
ETL Data Architect
ETL Engineer ETL Developer / System Administrator
Responsibilities:
·
Design, Develop and implement Database
schema, SQL Scripts and Procedures, Processes and Performance improvements to
the data extraction, data validation, data manipulation and data loading (ETL)
for the firm’s billion dollar pharmaceutical clients.
· Write Stored
Procedures, Triggers and SQL Queries and scripts.
·
Design, Develop, Document and
implement client driven ETL change requests, and internally driven process
improvement strategies.
·
Monitor, Maintain, Troubleshoot, Optimize and Backup and mission critical
Database systems.
· Communicate directly with billion dollar client to gather
requirements, discuss change requests, and foster strong client relationships.
Accomplishments:
· Designed and Developed
ETL Process Logging methodology; designed uniform logging procedure and schema that
supports simple, global, detailed process logging. The logging procedure provides uniform
detailed process statistics for data extraction, loading and manipulation
processes.
· Using scripts and
command line instructions, designed, developed and implemented the automated
Development Environment / Production synchronization process. The automated synchronization processes backs
up current development and production environment state, preserving a snapshot
of the environments at the time; then exactly recreates the production
environment over the development environment.
· Developed SQL
automated database system Business Intelligence documentation scripts with
meta-data obtained from system tables and dynamically generated queries. The
scripts dynamically generate all table and column names, and all unique values
within ever table in the database.
· Made significant re-design improvements
to weekly ETL Data Loading Processes.
· Led team meetings and established consistent
department-wide data validation framework.
· Developed
schematic ER-Diagrams for two database systems; re-engineered weekly ETL
processes; and led database team in development of the data validation
framework.
UpToDate / LeapFrog Systems
3/2006-11/2006
Oracle PL/SQL
Programmer, Principle Database Architect, Developer, Data Miner
Responsibilities:
· Design and
develop Oracle 10g content management database system. Principle architect of the Oracle Editorial
Database System.
· Design and develop data migration (ETL) process from hierarchical
Legacy system to Oracle RDBMS.
· Write Stored Procedures, Functions, Packages, Triggers, Sequences,
PL/SQL code, SQL. Optimize PL/SQL, SQL
and ETL performance.
· Work directly with President and Director level senior management
to meet complex and shifting business demands.
· Administer
Oracle 10g users, roles, permissions for the Editorial System development team.
Accomplishments:
· Wrote 10,673
lines of Stored Procedure code.
· Designed, Developed, Deployed and Optimized 34 Oracle 10g
Procedures, Packages, and Custom Functions; 78 tables, 23 Triggers and over 50
PL/SQL script files.
· Increased
performance on a single user query by 7,000% percent. Query duration improved
from 10 minutes to 8.5 seconds.
· Responsible for drastic improvement in performance of Oracle ETL
process. Duration cut from 24 to 2.5
hrs.
· Further Optimized data
transformation through development of Custom Functions. Custom functions perform multi-record data
transformation and significantly reduce overhead associated with single row
cursor based transformations.
· Developed graphics BLOB and XML CLOB data file load process using
Putty, Linux, Oracle directories and BFiles, and a dynamically generated PL/SQL
Script.
· Created custom Oracle ETL procedures that execute a specific
process, group of processes, or all processes to expedite data loading and
testing.
· Designed, developed and deployed custom Oracle Exception Handling,
Process Logging, and Batch Processing procedures. The combination of benefits from these
processes yields exceptional efficiency for issue identification and
resolution. The benefits remain equally
substantial for testing modifications and enhancements.
· Secured database and
partitioned development environment by creating users and roles, assigning
users to roles, granting permissions and creating synonyms.
Accomplishments (cont.):
· Reverse
engineered hierarchical Hypercard Legacy System,
Mapped data elements from Non-Relational system to relational object
model. Designed, developed and deployed
data extraction process. Wrote data
extraction code and transformation logic and managed resources on the ETL
effort.
Goodwin Procter LLP
1/2001-2/2006
Database Administrator / Architect / Developer
Responsibilities:
· Develop, Monitor,
Maintain, Troubleshoot, Optimize, Backup and Secure mission critical Microsoft
SQL Server 2000/2005 Databases and Servers.
· Write Stored
Procedures, Triggers and Transact-SQL Queries.
· Perform SQL installations and upgrades and consolidate SQL
Servers.
· Create jobs, maintenance routines, Data Transformation Services
Packages, Perform Capacity Planning, Disaster Recovery Planning, and Database
Backup Scheduling.
· Administer 26 GB Financial Data Warehouse, 31GB CMS Financial
Database, Ceridian HR/Payroll system, Employee Data Warehouse, 16GB Interaction
client management database, 29GB LegalKEY Web based
records management and workflow system, Copitrak
client fee disbursement systems, Metastorm process
management systems, and Vi Eval Web based employee
review system.
Accomplishments:
· Designed and
developed Employee Data Warehouse using ERWin,
Microsoft SQL Server 2000 and Microsoft Data Transformation Services (DTS). Created VB Script Active X Data Transformations and Transact-SQL
scripts to manipulate data from the Ceridian HR/Payroll system into the Data
Warehouse.
· Used Erwin to
create logical and physical designs and detail reports. Data Warehouse reduces time and costs associated with creating
new downstream data feeds for the firms intranet,
Interaction client management system, Copitrak, phone
directory and many other systems.
· Developed custom scripted
Log Shipping with automated database recovery, cutting Disaster Recovery time
from 2-3 days to 2 hours for CMS SQL 2000 Financial System.
· Significantly increased
Financial Data Warehouse development efficiency by re-engineering test
environment and data warehouse load procedures.
· Administered,
maintained and further developed 26 Gigabyte Financial Data Warehouse and 23
Stored Procedures with over 6000 lines of code. The Stored Procedures enforce
business logic used to load and manipulate financial data for reports given to
firm executives.
· Developed automated ETL process that saves 1 to 2 weeks
implementation time after every firm re-organization and practice area re-alignment
over manual mailing list creation and membership placement. Developed Transact SQL scripts that pull
information directly from the HR system, deploy hundreds of business rules and
generate all mailing list groups, group nesting and membership for the firms
2000+ mailing lists.
Application Developer (Goodwin Procter LLP)
· Saved 2 years on
manual document import project by developing Visual Basic Script that automated
profiling for over 9000 documents. Imported docs into the iManage Document
Management System.
· Upgraded and resolved application issues in MS Access XP/2000/97
financial reporting application and MS Access XP needs.
· Developed, upgraded and maintained MS Access XP/2000 Financial
reporting database; previously developed/maintained four MS Access 97 employee
review applications.
Network Analyst (Goodwin Procter LLP)
· Built and
deployed physical servers, Configured RAID Array, installed Windows 2003/2000
Server Operating Systems, Configured server security.
· Managed, maintained and monitored server conditions using HP
Insight Manager, NET IQ, SQL Server Alerting, Performance Monitor.
· Maintained CommVault Galaxy Tape Backup system responsible for backing
up roughly 80 Terabytes of data monthly.
Systems Analyst (Goodwin Procter
LLP)
· Implemented firm-wide software solutions to meet critical firm
application needs.
· Installed server software, schedule firm-wide application downtime
and performed system upgrades, worked with company owners, directors, software
vendors, network analysts, and user groups to ensure successful
implementations.
Team Leader (Goodwin
Procter LLP)
· Tutored IT members on Database Programming and Administration,
Systems Implementation.
· Assisted with Transact-SQL query writing and optimization, and
provided assisted hands-on tutoring.
AMERICAN EXPRESS
7/1999-12/2000
Database Developer and Programmer
Responsibilities:
·
Design and develop Sybase System 11.5
and MS Access 97 database solutions for monthly reporting and compensation
reporting needs.
Accomplishments:
· Reduced month-end
processing time by 400%, cutting the duration from 16 to 4 hours. Converted MS Access 97 queries to Sybase
transact-SQL Stored Procedures, optimized SQL code and
ensured proper index utilization.
· Re-designed Sybase System 11.5 reporting database using Erwin.
Used Erwin to forward and reverse engineer the database, design logical and
physical data model.
· Designed, developed, and maintained over 50 stored procedures for
monthly data transformation process and report creation using Transact-SQL.
· The stored procedures employed
300-400 business rules that were applied to a monthly raw data feed. The procedure execution populated roughly 35
final result tables accessed by about 40 Cognos reports. The Chief Operating
Officer, 250 senior executives, directors, managers, field execs and their
employees use the reports.
· Developed error checking
and process logging to facilitate problem resolution and shorten development
time when amending business logic.
· Performed ETL migration from MS Access 97 data into Sybase tables.
Team Leader (AMERICAN EXPRESS)
Accomplishments:
· Trained all new
team members, and new manager four employees total over the last ten months
tenure. Interviewed potential candidates.
· Assisted team members with Sybase and MS Access development.
· Lead resource for Vice President and several directors on implementation
of business logic into main reporting process and individual reports.
Project Leader /
Interim Manager
(AMERICAN EXPRESS)
Responsibilities:
· Manage three full
time resources, determine project estimates, manage and meet deliverable
deadlines during the period while our manager position was vacant.
Report Developer
and Administrator
(AMERICAN EXPRESS)
Responsibilities:
· Developed Cognos and MS Access 97 Reports.
· Ensured timely distribution of monthly reporting and quarterly
compensation reporting.
· Interacted with senior management to ensure precise business logic
was incorporated into projections of business volume calculations for
compensation and budgeting.
· Managed monthly intranet reporting system using Cognos web based reporting tool.
· Ensured timely delivery of reports, published reports to intranet,
administered the entire reporting environment.
Application
Developer (AMERICAN EXPRESS)
Responsibilities:
· Develop MS Access
97 Reporting Console that queried system tables to obtain a full list of
existing reports and queries.
· Enabled push one button to run all reports, and gave status during
execution.
IKON Office Solutions / VALINOR
10/1998-6/1999
Consultant / Software Engineer
Responsibilities:
(MICROSOFT and Barnesandnoble.com Data
Migration project)
· Performed ETL
data migration and analysis using SQL Server 7.0 database, SQL queries, SQL
Server 7.0 Data Transformation Services (DTS), MS Access 97.
· Coded business rules using ADO VBA within Data Transformation
Services (DTS) to create music titles for missing title data. Data is used for
online music store at barnesandnoble.com for direct competition against
Amazon.com.
(Berkery Noyes & Co. Investment
Bank Client Management project)
· Coded Visual
Basic 6.0/5.0 and MS Access 97 Object Oriented Client Management system. The
new system completely automates matching prospective buyers and sellers based
on dynamic user input. $35,000 is saved annually by eliminating the manual
search, and productivity increases are expected to generate $200,000 + annually
in increased revenue.
· Performed ETL migration and tested mission critical data using SQL
queries and VBA code.
(MICROSOFT Office 2000 project and
Web Site)
· Created SQL
Server 7.0 database, FrontPage 2000 web site, Access 2000 application and web
site. The web sites provided dynamic SQL database updates through the Internet.
Project results burned to CDs and used by Microsoft’s national sales/marketing
staff for nationwide rollout of Microsoft’s Office 2000 technologies.
THOMSON FINANCIAL SERVICES 7/1997-9/1998
Consultant / Custom Application Programmer Analyst
Responsibilities:
· Develop custom
client/server applications using Visual Basic 5.0, MS Access 97/95, VBA, Sybase
System 10/11, Sybase Power Designer, and PowerBuilder 5.0.
(Schroders
Capital Management Client Billing Project)
· Developed custom
billing system in Visual Basic 5.0, Sybase System 11, and MS Access 97.
· Wrote Stored Procedures to extract and manipulate critical
financial data. Schroders clients had frequently
refused to pay the full amount of their invoice because of unclear billing
procedures. The new billing system details fee calculations directly on the
client invoices. This leaves no question about fee generation, and saves over $75,000
per year globally in lost fees, and frees up multiple resources.
(Le Caisse
General Ledger Interface Project)
· Designed,
programmed, and delivered data mapping system using Sybase's Power Designer,
PowerBuilder 5.0, and Transact-SQL.
· Designed system to accommodate over 750 data mapping rules with
ongoing updates. The system dynamically generates Sybase stored procedures from
user input, encapsulating all business logic. Because users change business
logic from the GUI there are no code maintenance costs, saving $25,000-35,000
annually.
(Compass Group LLC Data Conversion
Project)
· Designed,
programmed and delivered data conversion system in MS Access 97 that imports a
text file, maps data, and creates a text output file. The tool saves Compass
Group 520 labor-hours and $15,600 annually because the previous data conversion
tool lacked sophisticated cancellation and correction mapping that had to be
done manually.
FIDELITY INVESTMENTS 11/1993-7/1997
Systems Implementations Analyst
Responsibilities:
· Develop new
database systems to administer benefit information for employees of Fidelity's
corporate Health and Welfare clients.
(Data Conversion Scrubber Project)
· Designed data
conversion and verification system in MS Access 97; coded functions in VBA to
dynamically create and execute SQL. The
system imports raw data files of 5 to 100 MB, validates data integrity against
dynamically entered standards, and verifies cross-field data consistency. The
application enabled Fidelity to convert and validate new corporate client data
50% faster than previously possible.
Business Analyst/
Database Developer
(FIDELITY INVESTMENTS)
Responsibilities:
· Built database
tools to analyze Fidelity's data correction business operations.
· Developed and managed departmental projects.
· Developed secure multi-user databases in MS Access 2.0 saving
$25,000 annually. Wrote database training manual and user's guide.
Financial
Representative/ Stockbroker (FIDELITY INVESTMENTS)
Responsibilities:
· Licensed Series 7
NASD Securities Broker. Suggested portfolio strategies to Fidelity's wealthiest
private customers and traded $250 million annually.
· Designed
"Value-Link" issue tracking database in MS Access 2.0.
· Co-edited monthly client issues newsletter.
FISCO Equity
4/1993-11/1993
Account Executive
(Insurance Sales and Stockbroker)
Compulife Investor Services
4/1992-4/1993
Investment
Manager (Insurance Sales and Stockbroker)
AMERICAN EXPRESS Financial
Services
6/1991-4/1992
Financial Planner (Insurance Sales and Stockbroker)
Professional Development: 2/98 – present
16 Courses totaling
approximately 500 classroom hours
·
Updating your Database Administration
Skills to Microsoft SQL Server 2005
·
Designing and Implementing OLAP
Solutions with Microsoft SQL Server 2000
·
Managing and Maintaining a Microsoft
Windows Server 2003 Environment
·
Microsoft Visual Basic Script &
Windows Script Host
·
Microsoft SQL Server 2000 Database
Administration
·
Microsoft Windows 2000 Optimization
and Troubleshooting
·
Advanced Transact SQL Training
·
Microsoft TCP/IP Certified Training
·
Microsoft IIS 4.0 Certified Training
·
·
Microsoft Widows NT 4.0 Certified
Training
·
SYBASE Database Administration
Training
·
·
·
SYBASE Writing Effective Stored
Procedures
·
SYBASE Fast Track to SQL Server
EDUCATION:
Client/Server Application Development Certificate. 10 month, 354 classroom hour
intensive evening and weekend program in RDBMS, Visual Basic 4.0, Oracle 7.0,
SQL, transact-SQL, database design, triggers, stored procedures, Transaction
handling, PowerBuilder 5.0.
Bachelor of Arts Major Government, Concentration
Economics