Project Manager Management

Joseph Duffy

Senior DBA / Developer

Technology Manager

Project Manager

*************@*****.***

Summary of Qualifications:

Joseph has 24 years experience as an IT professional and 15 years as a hands-on Sybase

Developer/Administrator/Architect. He has been involved as a hands-on manager in systems analysis and

applications development. Having worked in large companies, Joseph has always managed a Software

Development Lifecycle process and complied with formal methodology.

Joseph has spent most of his efforts in systems technology. With so many years invested, he offers

experience in every area of this rare technology skillset. This includes analysis, conversion, testing,

migration and rollout in addition to many other valuable experiences.

Joseph has performed many duties also associated with technical management, project management,

vendor and user liason. He will be happy to offer these services as well.

He is now seeking a long term position with the opportunity to utilize past experience in a technical

environment.

Supported Business Areas

• Broker Dealer Services

• Regulatory Compliance

• Decision Reporting Systems

• Mortgage Backed Securities

• Government Backed Securities

• Trading Systems and Compliance

• American Depository Receipts

• Financial Systems

• Risk Analysis

• Fixed Income Portfolios Pricing

• Financial Systems Design

• Financial Systems Testing

• Asset Management

SKILLS:

Reviewed and optimized the physical and logical design for the system

Data Architecture

Business Analysis

Sharepoint Development and Support

Installed, configured and supported Sybase and Oracle on AIX

Performance Tuning of Database Objects: Stored Procs, Triggers, Indexes

Production support and weekend support

Developed and supported scalability and disaster recovery strategies

DBM (Data Modeling) both logical and physical design (LDM and PDM)

BPM (Business Process Management Support)

Shell Scripting

SQL scripting

SQL Server Security

Managed database administration team and led performance and tuning effort for existing, large

scale Sybase and MS SQL Server databases

Developed proactive database monitoring and maintenance procedures

Upgraded and migrated Sybase production servers to release 11, 11.5, 11.9, 12.0, 12.5, 12.9, 15

Established Sybase and MS SQL Server databases standards and guidelines

Designed and implemented audit and archiving for the system

Benchmarked performance of Sybase batch processes and selected OLTP features. Evaluated

database and recommended performance improvements.

Monitored performance of databases and customized a script using sp_sysmon to record

performance for future evaluation. Provided support to DBAs and developers in order to address

performance issues.

Developed Maintenance Scripts using features such as sp_sysmon, dbcc checkstorage and reorg

Established strategy for disaster avoidance including thresholds, locking strategies, master device

rebuild (preparation) and error monitoring

Performance and Tuning

SAN Support

Clustering and mirroring

Backup and Recovery

Server Upgrades, EBF Changes

Security and Access, CIS, Remote Access

Data Integrity, DBCC, Referential Integrity

Implemented Business Continuity Plan and Disaster Recovery Plan immediately after September 11,

2001. Contributed to corporate disaster preparation during the following years.

Managed vendor consulting and support contracts. Communicated with management at major

software companies in order to facilitate support services. These communications often became

detailed and technical.

Management of numerous projects requiring accountability of development staff, resolution of

scheduling conflicts, budgeting concerns, user requests and recruitment/retention of staff.

Proficiency in Unix and shell programming. Adept at handling high energy and/or crisis priorities

often found in the financial industry.

Well-versed in SQL

Planning, installation and support of Oracle servers and applications in both unix environments.

Participated in the RFQs to internal customers. Conducted feasibility studies and performed due

diligence analysis. Supervised junior technology staff. Interviewed new candidates. Trained and

mentored new staff.

BPM (Business Process Management) and outsourcing

Data Warehouse design and implementation

Interfaced effectively on all levels. Strong oral and written communication skills. Interfaced daily with

end-users and other technology staffs.

Managed relationship with software vendor. Engaged in both technical and contractual negotiations

with Sybase Inc, Oracle Inc and IBM. Participated in team efforts to manage the cost structure of

these contracts.

Managed Sybase/Oracle/MS SQL Server DBA experience in production support, such as

configuration and installation of SQL servers and databases, capacity planning, server upgrades,

server monitoring, system performance tuning, free-space monitoring, backup and recovery,

handling disaster scenarios, development support such as logical and physical design, indexes,

defaults, rules, triggers and stored procedures.

Sybase Replication Server installation and configuration, materialization, monitoring, admin and

support, troubleshooting, recovery, maintenance

Performed all of the following: End of Life and patch management, schema management, server

installation and upgrade, disaster recovery, troubleshooting, high availability, SRDF, EMC and

performance tuning.

Installed and supported Sybase IQ. Migrated 6 terabytes from ASE to IQ and established new

reporting and other features of data warehouse.

TECHNICAL SKILLS

EXPERIENCE:

Unlimited Technology Services 7/07-present

Pfizer Inc, NY,NY, Project Manager/Developer

Hired as a Database Administrator, Pfizer management quickly realized the potential of this

IT Professional. Within a couple of months, he was assigned the responsibilities of Technical

Project Manager. Managed 7+ IT projects in a hit-the-ground fast-paced effort. Negotiated

project delivery and signoff repeatedly. Considered to be technical with outstanding

professional and management skills. Valuable qualities are often difficult to quantify.

Current management has offered to give an outstanding reference internally.

Customer Fulfillment Center-Pfizer

Assigned as Project Manager to CFC Project. Developed relationships with end users.

Negotiated project deliverables and deadlines. Met objectives and satisfied concerns of

customer management concerns. Attended meetings and delivered status weekly.

NYSiteOperations-Pfizer

Sole support and management for “orphaned” application. Provided support on an as-

needed basis. Reviewed requests and managed customer expectations. Provided training

and customer support as needed. Attended meetings and delivered status weekly.

FOS Project-Pfizer

Provided management support for a lightly documented development project. Poor funding

and undocumented requirements provided little direction. Using initiative and persuasion,

negotiated the complicted and often undefined processes at Pfizer. Constant changes in

management, organization and processes create challenges. Demonstrated persistence and

thoroughness while delivering successive stages of project process.

CFI Drawing Copy-Pfizer

This project had numerous challenges. No resources, training or documentation were

provided. Negotiated a shared resource from other stakeholders, we migrated the

application to its new server. Various enhancements and configuration changes were

required to resolve unexpected design flaws. Delivered the project in fulfillment of

management expectations.

Aperture-Pfizer

Supported the review, migration and retirement of a critical application. Business unit

depended on Aperture as their most significant tool. Hundreds of administrators interfaced

with the application weekly. Met all milestones and delivered project on time.

Blue Mountain Calibration/GO Retirements-Pfizer

Data Manager for various application at Global Operations unit. Mastered the various

processes at Pfizer. Played various roles on each project. Met all objectives.

Vista Plus Upgrade-Pfizer

Managed Vista Plus upgrade through ELC documentation process. Met each deliverable as

required.

Managed resources provided for Pfizer World Wide Safety. These resources worked with

CIOMS, a regulatory systems used to filter and screen AE data for submission to the FDA and

European regulatory agencies. As part of this project managed the client expectations including

the HQ clients PCOs and EDS. Developed the requirements definition and managed the

prototype development. Proposed a cost-effective solution, which would meet the requirements

with minimal expense.

Managed resources assigned to Software Validation and Quality Management.

Managed resources on the department methodology for system development life cycle,

including templates, examples and procedures. As part of this project developed a structured

procedure for the bid process and vendor selection in both project based work as well as staff

supplementation. This method was used in several projects including PfLITE and DocCentral.

Fortune 500 Company, NY,NY, Database Manager

Worked with Market Data. Interfaced directly with business users. Gathered requirements and

implemented Business Process Model. Utlized Power Designer to reverse engineer existing databases and

data models. Implemented changes as requested by user community.

Supported the development of compliance systems. Supported financial systems in the area of foreign

exchange, repurchase agreements, bonds, derivatives, swaps and other structured products.

Developed all database objects. These included stored procedures, triggers, constraints and SQL code.

Provided performance and tuning for database objects.

Benchmarked existing systems. Predicted failure of existing technology. Recommended architecture

changes. Utilized performance tools to gather metrics.

Architected and implemented the design of a data warehouse. Reported, managed and implemented more

than 8 cases with Sybase support

Supported systems serving more than a dozen outside customers. Service fees from these customers

totaled more than 25 $MIL.

Managed ASE databases exceeding 6 Terabytes in size. Upgraded ASE servers from 12.5 to 15.

Worked on Data Warehouse system. This system included quite a bit of market data. Feeds were utilized

along with customer data to construct a data warehouse. Real-time compliance services were provided to

customers in addition to reports.

Evaluated performance using sp_sysmon, monitor server and performance benchmarking.

Implemented configuration improvements that improved batch process from 10 to 1.5 hours.

Instituted a secure environment from the “ground up” while avoiding impacts to existing users and

processes.

Installed IQ and migrated all 6 terabytes of data from ASE to IQ. Moved all reporting and data

maintenance to IQ. Benchmarked existing systems and identified performance bottlenecks. Identified and

resolved datatype and other issues related to IQ and ASE.

Installed and configured Sybase Replication Server. Materialized databases, managed routes,

publications, subscriptions, managed design changes, troubleshooting of issues related to datatypes,

identity columns, Sybase bugs.

Supported IQ Server with 25 TB of data. Supported ASE with 6 TB of data. Supported systems serving

more than a dozen outside customers. Service fees from these customers totaled more than 25 $MIL.

Interfaced with the support organizations at major software vendors.

Managed Projects in accordance with Software Development Life Cycle

UTSI, Engagement Mgr

Supervised team of overseas developers. Performed architectural review for large enterprise. Delivered

recommendations and regulatory review. Supported service delivery and business development at

several large enterprises.

Worked closely with reorganization and reengineering efforts at Global American Company. Implemented

Business Process Management (BPM) efforts in existing database designs. Supported the reengineering

of corporate governance from silo-based IT delivery to a centralized structure with budgeting

accountability.

Supporting the recruiting, interviewing and representing of 100s of candidates both local and globally

during a period of 7 years. Managed both vendor and client relationships. Supervised on-site employees

and contractors. Managed vendor selection process. Supervised proposal process at various client sites.

Bank of New York/Mellon, DBA Manager/Application Manager 11/99 – 7/07

Avenue of the Americas, NY, NY

Senior IT Manager/DA for centralized IT department supporting more than 8,000 users. Responsibilities

include project management, mentoring, capacity planning, negotiation of service level agreements,

vendor supervision and management, Oracle server planning and installation, production support,

licensing, case management and DDL design.

Supported Sybase migrations and upgrades for a period of 8 years. Upgraded to/from ASE 11,

11.5, 11.9, 12.0, 12.5, 12.9, 15

Developed and supported the Broker Dealer Services application. Participated directly with users during

the design of one of the industries largest Securities Lending applications. Application features use

Credit Default Swaps, Repurchase Agreements, Custodial Banks and cash management to improve

profitability of the global funding desk at broker dealers.

Developed and supported the American Depository Receipts applications at the largest issuer of

ADRs in the United States. Participated directly with business users during design,

implementation and design of new application features. Application features include Custodial

Bank responsibilities and innovative offerings to bank customers. This application supported DRs

for 1400 programs with companies from 70 countries. Appointed as depository bank for 65% of all

public sponsored DR programs.

Worked closely with business users. Managed design meetings with software developers in

attendance. Gathered business requirements and specified a database design. Submitted for

approval and implemented with both Erwin.

Administered and supported Microsoft SQL Server installations for a period of 8 years. Utilized both Erwin

and Enterprise Manager to perform all support functions. Provided both development and production

support.

Supervised staff of five DBAs. Liason to business management.

Reviewed, evaluated and selected vendor/products. Specified service contracts from software and

service vendors.

Planned and implemented numerous EBF installations.

Planned and implemented numerous Sybase ASE upgrades. The most recent upgrade path brought our

application from ASE 12.5 to ASE 15.

Hands on UNIX SHELL script development. My scripts are used as scheduled maintenance jobs and in-

house tools. Perl scripting. Developed tools which imposed coding and maintenance standards.

Supported development effort for internally developed applications. This support included all database

architecture with an emphasis on database objects (tables, views, indexes, etc) and query performance.

Prepared databases and data for both devel and qa environments.

Installed and supported MS SQL Server for several applications. Provided all database support for a

period of 7 years. Established maintenance plans including statistics, backups, tuning and DDL

design/change.

Utilized Configuration Management tools such as SCCS and Clearcase in order to prepare test

environment and object changes. Implemented source control for all database objects. Incorporated SQL,

Stored Proc and Trigger changes to database objects. Checked in changes and submitted them to

change control committee.

Supported MQ Series messaging. Utilized hiplink and veritas for errorlog monitoring and reporting.

Implemented both logical and physical design. Supported and data by mandating Referential Integrity and

other features.

Worked with KSQL as a reference during development of the proprietary system Broker Dealer Services

(BDS).

PRODUCTION SUPPORT DBA (24/7). Upgraded Sybase Adaptive Server Enterprise on Sun Solaris and

AIX platforms. Installed new servers, migrated from one version of Sybase to the next. Preserved existing

design and logins/users/privilege. Urgent calls during the night and weekend to correct batch problems.

Troubleshooting was a common occurance for both performance (OLTP) and benchmark completion

(batch). Planned for and implemented Business Continuity and Disaster Recovery Plan during days

following Sept 11, 2001.

Training and support of production operations staff. Monitoring and automated notification by production

monitoring utilities.

Created numerous unix scripts for the monitoring and maintenance of Sybase databases. These

include DBCC Checkstorage, sp_sysmon, update index statistics, dump transaction, reorg rebuild, etc.

Utilized tools such as CAST and IWATCH to monitor servers and identify issues.

Managed databases and objects including thresholds, Component Integrated Services, remote access,

etc.

Installed and supported MS SQL Server for several applications. Provided all database support for a

period of 7 years. Established maintenance plans including statistics, backups, tuning and DDL

design/change.

PERFORMANCE AND TUNING of Sybase instances. Configured parameters for optimum performance

of the Servers. Maintained and performed troubleshooting existing instances of ASE and REPLICATION

SERVER. Performance tuned Sybase ASE of both the server and the database. Tuning of SQL Code,

stored procedures and resolution of Open Client issues. Performed backups and loaded new database

instances. Monitored overnight batch jobs and dumps. Archived data into a data warehouse. Utilized

Unix utilities for Sybase. Wrote Unix shell scripts to automate tasks. Identified Sybase Open Client

problems.

Designed, installed, monitored and supported Oracle Oracle 8i 10g, MS SQL Server and all Sybase

through 15 in development, test and production.

Responsibilities included working completing tasks with Network administration, Enterprise Manager,

DBArtisan, Iwatch, SQL Backtrack, Erwin, SQL Plus, PL/SQL, and all product tools.

Responsibilities included Capacity Planning, Data Security and Auditing. Utilized the AUDIT database

and the DBCC database.

Supported High Availability using SUN Veritas.

Installed and supported SQL Anywhere for use by bank sales department. Provided technical direction to

pc technicians and other stakeholders.

Installed Oracle RAC system for Broker Dealer Systems (BDS) application rewrite.

Supported Charles River compliance (CRD) and trading system. Installed, supported and upgraded both

database servers and application.

Supported in house development and test of American Depository Receipts (ADR) applications.

Supported two UDB databases and the applications which utilized them.

Installation and support of Fundtech application on an Oracle platform. Daily routine Oracle administration

and user support.

Alliance Capital, Senior Sybase/Oracle DBA 8/98 – 10/99

Avenue of the Americas, NY, NY

Lead DBA for RDMS infrastructure department. Design, install, monitor and support all versions of

Sybase products for development, test and production including 11.5. Designed, developed and

supported disaster recovery system using Replication server.

Assigned as project manager to 2 troubled department initiatives supervising existing resources.

Resolved both successfully within 3 months allowing the department to meet year-end objectives.

Installation and support of Charles River application.

Utilized CAST to document the usage of existing systems. Identified performance bottlenecks and

initiated resolution through management channels. Coded perl and shell in-house tools to generate

reports related to each of the existing databases in the entire company. Produced tools and manuals

which automatically produced documentation and maintained it.

Sybase Professional Services, Senior Consultant/DBA 9/97 – 8/98

Avenue of the Americas, NY, NY

Database administrator for the entire Emerging Market Trading System. Identified and reported design

and performance issues related to the newly established trading floor of the bank.

Performed performance tuning for municipal bond trading and allocation system. Initialized and allocated

new disks placing data to gain the highest throughput possible. Used gui tools to perform administrative

and performance monitoring tasks.

Analyzed architecture and monitored performance of server and client to identify bottlenecks. Modified

server configuration in order to produce the optimal server statistics.

Participated in installation of high availability failover solution using Sun technology at foreign bank.

Worked directly on trading floor. Recovered master device and database immediately following crash of

the Sybase server.

Bear Stearns & Company 5/93 – 9/97

245 Park Ave, NY, NY

Developer/Tester supporting fixed income trading system. This included liaison responsibilities for

Mortgaged backed securities and govt backed securities applications. Provided production and

development support with a user community of 2000+. Interacted daily with Mortgage Desk, Finance

Desk and Government Securities Desk.

Development support included maintaining a repository of database objects, phased creation of database

objects on all servers, helping developers with query and performance tuning, data migration, server

upgrades and maintenance of development servers.

Support included being on call 24 hours to resolve problems, such as user blocks, disk crashes and batch

job stoppages, plus tasks such as daily monitoring of the health of all servers, tuning backup and recovery

procedures, tuning batch processing for referential integrity and performance.

Designed, developed and tested applications for Online DSS and report generation using perl and db-lib.

Developed numerous application fixes as part of an upgrade to System 11.

Managed sell-off of newly developed Sybase fixed income trading system including 24 hour support

during 6 months of parallel testing and bug fixes.

AIL, Grumman, Norden, AT&T 1/86 – 4/93

Stewart Ave, Bethpage, NY

Held various positions programming in several languages. These included computer programmer, auditor

and on-site vendor management and approval.

Obtained Top Secret Clearance as a necessity for work on the BSTS (Star Wars) project. Also worked on

the A-6 Radar Systems upgrade project. Secret Clearance required.

EDUCATION:

West Islip High School 1980 – West Islip, NY

New York University/Polytechnic Institute of NY

Bachelor of Science in Computer Science - 1985

CERTIFICATION:

Certified SQL Server Administrator since 1998

TRAINING:

More than 30 weeks of database training.

Additional weeks of training in other technology and project/program management.

SDLC Training and other management training.

Contact this candidate