CV, US Based Data Architect Seeking Work In London

Available

Serial No: 24665

Job Seeker Location

×

Close

Skills keywords: database administration, pl/sql, TSQL, unix/perl/korn

Short Bio:

Twenty years of experience as a data architect with specialized experience in application development, database administration, database design and database development and systems analysis. Extensive exposure to financial sector work in Risk Management (credit, equity and market risk), securities trading, investment banking and insurance(health care and casualty)

Current location:  Florida, United States - View on map

Nationality: American

Preferred Sector of Employment:  IT and Technology, accounting and finance, Banking Insurance and Financial Services

Spoken languages: english

Location I am interested in working: Anywhere

Profile

Project Management • Application Development • Database Administration

Talented consultant with strong educational background and experience in programming using cutting-edge development tools. Articulate and effective communication with formal presentations and writing technical documentation

TECHNICAL SKILLS and QUALIFICATIONS

Operating System: AIX, HPUX, Windows, LINUX

Languages: ASP, ADO, C/C++, HTML, Javascript, KORN, PERL, WIN32 OLE,

PFC, PL/SQL, Powerscript, PostGres, T-SQL, VBScript, VB, VB COM, XML, XSL/XSLT

Software: Clearquest, DBArtisan , ERWIN, InstallShield, MS Office, Peregrine, Powerbuilder, Powerdesigner, TOAD, Visual Studio, Visio, WISE

Databases: Access, DB2, Oracle, SQL Server 2005, Sybase ASE, Sybase IQ, Greenplum

Configuration Mgt: Clearcase, PVCS, SafeSource

Project management: MS Project, Summit-D

Career Summary

Depository Trust Clearing Corporation(DTCC), Tampa, FL
March 2010 – present

The Depository Trust & Clearing Corporation is the largest financial services post-trade infrastructure in the world, with operating facilities in multiple locations in the U.S. and overseas. Through its subsidiaries, DTCC provides clearance, settlement and information services for virtually all equity, corporate debt, municipal debt, government securities, mortgage-backed securities, and emerging market sovereign debt trades in the U.S., totaling more than $1.7 trillion daily.

Sr, Technical Consultant

Project(s): Risk management and risk monitoring, market and credit risk domain

• Sybase database management and database development.

•Sybase database modeling and design,

•Datawarehouse design and development,

•Design and development of datawarehouse ETL trading interface,

• Full life cycle development CMMI 3 compliant, systems analysis and database development experience

• Database performance tuning, transaction management, code triggers, views, and Stored Procedures

• Programming End-of-Day and Intraday Value At Risk(VAR) model processing for US and European markets.

• Liquidity needs and allocation adjustment reporting as it relates to participant supplemental liquidity deposit requirements

• Analyze and document business and functional requirements

• Coordinate and manage project migration enhancements and development

Skills: Database Administration, Korn/Bash, Perl, Sybase v.15.0 ,Greenplum, PostGresq, T-SQL, AML

ATT, Atlanta, GA
October 2007 – February 2008, October 2008 – February 2010

A technology leader providing telecommunications for communities worldwide specializing in telephony and advanced mobile solutions.

Product Support Manager/Software Developer/Database Administrator

Project(s): Multiple projects

• SQL Server 2005 migration.

• Full life cycle GUI software development, systems analysis and database development experience

• Database performance tuning, transaction management, coding of triggers, views, and stored Procedures

•Create, modify and test SSIS/DTS packages performing data extraction, transformation, and loading of source data.

•Perform database backup and restore operations.

• Extensive Powerbuilder GUI software development in client/server and IBM mainframe environment.

• Full life cycle GUI software development, systems analysis and database development experience

• Develop business process flow diagram, requirements and technical design

• Analyze and document business and functional requirements

• Manage project deliverables and support solution design of new features and enhancements

Skills: Database Administration, Korn, Perl, Oracle, SQL Server 2005, SSIS/DTS, T-SQL, Redgate

Wachovia Corporation, Corporate Investment Banking, Charlotte, NC February 2008 – October 2008

Wachovia offers a full range of products and services to meet the needs of corporate and institutional clients nationwide. These include capital raising, market making, and financial advisory products and services.

Database Architect

Project(s): Multiple projects

• Sybase ASE 12.5 development and design.

• Full life cycle systems analysis and database development experience

• Database performance tuning, transaction management, coding of views, and stored Procedures

• Redesign, modify and improve investment trade system processing

• Support end-users. Resolved critical and non-critical system defects.

Skills: T-SQL, Perl, Korn, Database Performance Tuning and Process Improvement, , Sybase ASE 12.5, UNIX

Kool Smiles, Marietta, GA
March 2007 – October 2007

A leading provider of comprehensive high quality general dental care to underserved children and young adults ages 1-21 who are covered by Medicaid, and State Children’s Health Insurance Programs.

Software Developer/SQL Server Database Analyst

Project(s): Internal Billing System and Call Center System

• Extensive Powerbuilder GUI software development in client/server and IBM mainframe environment.

• Full life cycle GUI software development, systems analysis and database development experience

• Develop business process flow diagram, requirements and technical design

• Analyze and document business and functional requirements

•Create, modify and test SSIS/DTS packages performing data extraction, transformation, and loading of source data.

• Implement conceptual and detail prototyping techniques essential for usability testing.

• Database performance tuning, transaction management, coding of triggers, views, and stored procedures

• Implement conceptual and detail prototyping techniques essential for usability testing.

• Support end-users. Resolved critical and non-critical system defects.

Skills: Powerbuilder v.9.0, T-SQL, SQL Server 2005, SSIS/DTS, Database Administration, Reporting Services

International Business Machines(IBM), Atlanta, GA
October 2006 – March 2007

An innovator in development and manufacture of the industry’s most advanced technologies, including computer systems, software, storage systems and microelectronics. In 2006, the company reported a consolidated revenue of $88 billion.

Sr. Software Engineer

Project(s): Customer Service Workbench, NASCO Claims System

• Extensive Powerbuilder GUI software development in client/server and IBM mainframe environment.

• Full life cycle GUI software development, systems analysis and database development experience

• Develop business process flow diagram, requirements and technical design

• Analyze and document business and functional requirements

• Implement conceptual and detail prototyping techniques essential for usability testing.

Skills: CMMI, DB2, Powerbuilder v.10.0, T-SQL

BLUECROSS BLUESHIELD, Jacksonville, FL
September 2005 – 2006

A major provider of health insurance serving the State of Florida. Bluecross and Blueshield of Florida serves more than 6.6 million customers. In 2005, the company reported a consolidated revenue of $6.49 billion.

Sr. Project Lead/DBA

Projects: Sales Compensation and payroll systems

• Extensive Powerbuilder GUI software development in client/server environment.

• Full life cycle GUI software development, systems analysis and database development experience

• Transact SQL(TSQL) programming and database design

• Database Administration, datawarehousing and datamining via Enterprise Data Warehouse(EDW)

•Create, modify and test SSIS/DTS packages performing data extraction, transformation, and loading of source data.

• Database performance tuning, transaction management, coding of triggers, views, and stored procedures

• Develop business process flow diagram, requirements and technical design

• Analyze and document business and functional requirements

• Implement conceptual and detail prototyping techniques essential for usability testing.

• Perl scripting

• Utilized Perl WIN32 OLE in building program components

• Develop programming interface for extracting data from Enterprise Data Warehouse(EDW)

Skills: Database Admin, Datawarehousing, DTS/SSIS, PERL, Powerbuilder v.9.0, T-SQL, MS SQL Server, Siebel Analytics

GLOBAL CARD SERVICES, Orlando, FL
September 2004 – September 2005

Global Card Services, Inc. (GCS) is the single source solution provider for any merchant accepting credit cards. Application Service product suite offers merchants the latest in fully integrated payment processing gateway systems. Since 1994, GCS has provided its products and services to merchants in the Travel & Entertainment industry.

Sr. Database Architect

Projects: Multiple database administration and system related projects

• Database Administration, datawarehousing and datamining

• Develop programming interface for extracting data from Sybase IQ datawarehouse

• Database design and modeling

• TSQL programming, performance tuning and database design

• Moderate Powerbuilder GUI software development in client/server environment.

• Develop business process flow diagram, requirements and technical design

• Analyze and document business and functional requirements

• Support end-users. Resolved critical and non-critical system defects.

• Perl scripting

• Develop programming interface for extracting data from Sybase IQ datawarehouse

Skills: Database Admin, Datawarehousing, HPUX, PERL, Powerbuilder v. 9.0, T-SQL, SYBASE ASE, SYBASE IQ

WELLPOINT, Cincinnati, OH
June 2004 – Sept 2004

WellPoint is the nation’s leading health benefits company serving the needs of approximately 34 million medical members nationwide. WellPoint is a Blue Cross or Blue Cross Blue Shield licensee in 14 states

Sr. Project Lead

Projects: Sarbanes/Oxly initiative of drug claims process

• TSQL programming, performance tuning and database design

• Develop business process flow diagram, requirements and technical design

• Analyze and document business and functional requirements

• Analyze and write technical design document

• Support end-users. Resolved critical and non-critical system defects.

• UNIX scripting with Korn shell

• Project planning and initiation of QA and production environment

Skills: AIX, ClearCase, ClearQuest, HP-UX, Korn, T-SQL, SYBASE ASE, Visio

CITISTREET/CITIBANK, Jacksonville, FL
June 2002 – June 2004

A division of Citigroup, found in more than 100 countries world-wide, Citistreet and Citibank deliver a wide array of health/welfare, banking, lending and investment services to individual consumers, as well as to small businesses with up to $10 million in annual sales

Sr. Systems Consultant

Projects: Payroll Systems implementation, Data conversion and migration

• Implemented new products and services for Citistreet clients

• Design and development of payroll arrears processing

• SQL programming and database design

• Support end-users. Resolved critical and non-critical system defects.

• Develop extraction program and arrears tracking of payroll system

• Project planning and initiation

• Analyze and document business and functional requirements

• Establish solution design, technical design and technical procedures

Skills: C , DBArtisan, HP-UX, PERL, Powerbuilder v.7.0 & 8.0, PVCS, T-SQL, SYBASE ASE, VB, Visio

EASTERN CASUALTY INSURANCE CO, Marlboro, MA
May 2001 – Nov 2001

Sr, Software Developer

Project: Insurance and Claims Processing Management System

• Supported 1000 end-users.

• Powerbuilder GUI software development, and 3-tier architecture design

• Full life cycle GUI software development, systems analysis and database development experience

• Project planning, requirements analysis, solutions design, build and test, and transition planning

• Support end-users. Resolved critical and non-critical system defects.

• Transact SQL management( writing triggers, views, stored procedures etc.)

• Design logical and physical database model of insurance policy liability/coverage information

• Developed programming interfaces for extracting claim loss data

• Implement conceptual and detail prototyping techniques essential for usability testing.

• Mentored junior developers

Skills: ASP, DBArtisan, EAServer, Erwin, GUI, Installshield, Oracle/PLSQL, PowerDesignor , PFC,

Powerbuilder v.6.5 & v.8.0, Sybase, T-SQL, UNIX, Visio, VB, Windows 2000

FIDELITY INVESTMENTS, Boston, MA
April 1997 – June 1998, Dec 1999 – May 2001

Fidelity Investments is a leader and innovator of managing investment funds for retirement and business venture capitalization. Listed as a fortune 500 company Fidelity has a strong market strategy for international investment diversification

Application Development Manager

Project: Facilities Management System

• Supported 1200 end-users.

• Extensive Powerbuilder GUI software development in a 3-tier client/server work environment.

• Full life cycle GUI software development, systems analysis and database development experience

• Manage each project in accordance with Fidelity Investments (FSDM) software delivery methodology

• Supervise technical and systems design phase, team sessions held between end-users and staff members

• Manage a staff of 15 developers, QA technicians, and systems analyst

• Performed maintenance fixes on work flow management system

• Database performance tuning, transaction management, coding of triggers, views, and stored procedures

• Engineer two successful software releases each one having high visibility with corporate managers

• Implement conceptual and detail prototyping techniques essential for usability testing.

Skills: Active X/COM, ASP, DBArtisan, , EAServer, GUI, MS Project, Oracle, PLSQL, PFC, Powerbuilder v.6.5, T-SQL, Sybase, UNIX, Visio, VB, Windows NT, WISE Installer

GRIFFON GROUP, Wilmington, MA
June 1998 – December 1999

The Griffon Group, formed in 1997, has two integrated areas of focus. First, Griffon is designing and developing a suite of analytical software tools for the investment management industry. These tools will allow clients to more efficiently collect, verify, and disseminate market data information for financial instruments in which they invest or are analyzing.

Software Developer

Project: Security Master System, Financial Pricing System

• Extensive Powerbuilder GUI software development in a 3-tier client/server work environment.

• Full life cycle GUI software development, systems analysis and database development experience

• Manage each project in accordance with Griffon Group software delivery methodology

• Performed maintenance fixes on financial pricing system

• Database performance tuning, transaction management, coding of triggers, views, and stored procedures

• Analyze and document business and functional requirements

• Implement conceptual and detail prototyping techniques essential for usability testing.

Skills: DBArtisan, , GUI, MS Project, PFC, Powerbuilder v.6.5, T-SQL, Sybase, UNIX, Visio, Windows NT

PROFESSIONAL HISTORY

Data Architect, Depository Trust Clearing Corporation, Tampa, Fl August 2010 – present

Product Support Manager, ATT, Atlanta, GA October 2008 – July 2010

Data Architect, Wachovia Corporation, Charlotte, NC October 2007 – October 2008

Database Administrator, ATT, Atlanta, GA October 2007 – February 2008

Software Developer/Database Analyst, Kool Smiles, Marietta, GA March 2007 – October 2007

Sr. Software Engineer, IBM, Atlanta, GA October 2006 – March 2007

Sr. Project Lead/DBA, BlueCross Blueshield, Jacksonville, FL September 2005 – November 2006

Sr. Data Architect, Global Card Services, Orlando, FL Sept 2004 – Sept 2005

Sr. Project Lead, Anthem BCBS, Cincinnati, OH June 2004 – Sept 2004

Sr. Systems Consultant, CitiStreet, Jacksonville, Fl June 2002 – June 2004

Sr. Software Developer, Eastern Casualty Insurance, Marlboro, MA May 2001 – November 2001

Application Development Manager, Fidelity Investments, Boston, MA April 1997 – Jun 1998, Dec 1999-May 2001

Software Developer, Griffon Group, Wilmington, MA June 1998 – December 1999

Software Developer/DBA, Medical Systems Management, Reading, MA August 1996 – April 1997

Client/Server Developer, Quantra Corporation, Burlington, MA August 1995 – August 1996

GIS Developer, New England Power Svc Co, Framingham, MA April 1995 – August 1995

Cartographer, National Ocean Service, Washington DC August 1986 – September 1993

Defense Mapping Agency, Aerospace Center, St. Louis, MO November 1984 – Augist 1986

Qualifications

Computer Science, Harvard University Extension School, Cambridge, MA, 1995;

B.S Geological Sciences, University of Massachusetts, Boston, MA, 1986;

Certificate, Defense Mapping Agency Cartography School, Aerospace Center, St. Louis, MO, 1985;

A.A.S. Environmental Science, Essex Agricultural Technical Institute, Hathorne, MA, 1981;

Certificate, Cartography, Salem State College, Salem, MA 1981;

Certificate, US Army Aviation Helicopter Maintenance School, Ft Rucker, AL 1980

Technical Training

MS SQL Server 2005 • MS Report Services and Analysis Services • ORACLE Database Administration

Windows API Programming • Peregrine Service Center • Powerbuilder

Advanced Powerbuilder Techniques • CMMI • ASP • XML • XSL/XSLT

Certificate, Anti-Money Laundering(AML) Certification, DTCC, 2010-13