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
