SUMMARY:

• IT services to Confidential 50 companies, offering focused technical expertise to address rapidly changing needs of companies in Financial Services and Manufacturing industries.
• System Architect / System Modeler: Modeled new Access Management process flow including proxy token, group, role and use based entitlements. (Pitney - Bowes)
• Information Architect: Developed multi-workstream universal Business Glossary ( Confidential )
• Analysis of Trade Execution Flow. Modified FIX Messaging to correct erroneous Regulatory Reporting of SWAP trades. Averted additional multi-million dollar SEC fines. ( Confidential )
• Provided critical analysis and technical solutions, resulting in major process renovation to Private Banking Group’s nightly batch cycle. Achieved 50% reduction in processing window guaranteeing availability of on-line system for regular business hours.
• Crafted Business Requirements Document (BRD) for capital expenditure for an industry changing IT check processing ( Confidential / CPCS) modification (Chase Bank).
• Developed technical design to implement modifications to IT check processing ( Confidential / CPCS) environment, resulting in 80% reduction labor costs ($25M) per annum (Chase Bank).
• Designed Data Model utilizing Erwin 7.x, RapidSQL, and Unix Scripting in an SAP/DB2 environment to streamline manufacturing process at Confidential . Resulted in consolidation of 38 disparate processes into 1 common process across all Western Hemisphere manufacturing centers, resulting in dramatic cost saving efficiencies Estimated value in excess of $17M per annum ( Confidential ).
• Provided technical knowledge base mentoring to Sr. Management of IT - Middle-ware software and n-tier web design development ensuring knowledgeable management advocacy presentation to Board of Directors (Fidelity Investments)

CORE TECHNICAL PROFICIENCIES:

• DB2-DBA ( Confidential Cert. 9.5 LUW)
• SYBASE 12.5
• ORACLE
• Confidential Rational System Architect
• MS ACCESS
• SQLSERVER 2000/2005
• ERwin 7.x
• ER Studio 9.x
• RapidSQL/TOAD
• UNIX Script
• Visio / PowerPoint
• Java Script, VB Script
• UML
• JSP, ASP
• JAVA2 / SWING, J2EE
• HTML, DHTML
• XML/CSS/XSD
• Legacy Software

BUSINESS APPLICATIONS ACUMEN:

• Equity Trading
• Options Trading
• Check Processing
• Enterprise Reference Data
• Cash Sweeps
• Statement Rendition
• Cash Management
• Payroll
• Proxy Notification

TECHNICAL SKILLS:

• DB2 DBA - LUW 9.1
• ORACLE/Rapid-SQL/TOAD
• MS SQLSERVER-2005/2008
• SYBASE
• Confidential System Architect 11.3
• Java / Java2 with Swing
• ASP / JSP
• MS PowerPoint
• COBOL
• Mainframe JCL and Utilities

PROFESSIONAL EXPERIENCE:

Business and System Analyst - Enterprise Data Warehouse - Data Architect

Confidential

Responsibilities:

• Modeled new Access Management process flow including proxy token, group, role and use based entitlements. created Business Glossary based on Confidential SA Encyclopedia Meta Data

Confidential

Information Architect

Responsibilities:

• Information Architect participated in the development of a Universal Business Glossary.

Confidential

Business Analyst, EDWH Manager, Data Architect

Environment: ORACLE DWH, FIX Trade and Order Messaging

Responsibilities:

• Detailed flow analysis: Trade and Order Execution FIX Messages
• Modification to the SWAP FIX Messages to correct Regulatory Reporting errors
• Ad-hoc report creation and modification resulting in improved client relationship

Confidential

Data Architect

Environment: DB2/DWH - Utilizing ER Studio 9.x, Infomatica, and PowerPoint with VISIO.

Responsibilities:

• Forensic data analysis based on the EDW Enhancement Project BRD requirments.
• Developed Logical Data Model (LDM) based on the Confidential BDW.
• Documented and implemented EDW Architecture using PowerPoint/VISIO
• Provided EXCEL based Source to Target Mapping (STM) using Infomatica ETL tool
• Created Physical Data Model (PDM) using ER-Studio

Confidential

Data Modeler - Business Integration Services

Responsibilities:

• Developed Conceptual Data Model (CDM) based on the DRD.
• Defined, Documented and implemented DW Architecture
• Built Data Dictionary and Metadata using ERwin Modeling tool
• Developed Normalized Logical Data Model (LDM)
• Created de-normalized Physical Data Model (PDM)
• Provided Source to Target Mapping (STM) Excel spreadsheets database loading.
• Data Modeling for vendor packages (Oracle) and in-house (Sybase) applications
• Developed Ad Hoc Reports using EXCEL Pivot Tables and Templates

Confidential

Data Modeler

Responsibilities:

• Developed new universal data model for all Western Hemisphere data processing.
• 95% reduction in data center processing capacity requirements
• Created full documentation of all processes using ER Studio 9.x, Visio, and PowerPoint
• Developed EXCEL Pivot Tables for analytic review processes
• Developed Conceptual Data Model (CDM) based on the DRD.
• Developed Normalized Logical Data Model (LDM)
• Created de-normalized Physical Data Model (PDM)
• Data Governance - including naming standards and data definition guidelines
• Design review presentations to colleges

Confidential

Data Architect / Data Analyst

Responsibilities:

• Build and populated a new relational database (data cubes)
• Created Value Added Mission critical EXCEL Pivot Tables reports using EXCEL Templates

Confidential

DBA - Team Lead

Responsibilities:

• Reduced development and testing cycle by 80%.
• Created Value Added Multi-Dimensional Cluster (MDC) based Database Warehouse applications.
• Reduced table restoration time by 60%.
• Established forward-looking use of “best practices” SQL coding standards.
• Developed Ad Hoc EXCEL reports using VLOOKUP function and EXCEL Templates
• Developed specialized automation Unix scripts, resulting in 50% reduction in update cycle processing time for external data feeds

Confidential

DBA, DB Developer - Software Renovation/Replacement

Responsibilities:

• Developed EXCEL Pivot Tables for analytic review processes
• Developed Conceptual Data Model (CDM) based on the DRD.
• Developed Normalized Logical Data Model (LDM) using ER-Studio
• Created de-normalized Physical Data Model (PDM) using ER-Studio
• Data Governance - including naming standards and data definition guidelines
• Immediate cost savings accrual of 20% due to reduced IT staffing requirements
• Realized 90% reduction in development time for future upgrades
• Recognized 75% reduction in processing costs
• Developed “smart SQL” coding strategies for future renovations and upgrades.

Confidential

Team Lead

Responsibilities:

• Developed new COBOL/CICS component for the E-Mail, E-Fail Investor Communications / Confirmations applications
• Crafted new flexibility for the Proxy Notice Application - 50%+ reduction in printing and mailing costs
• Developed COBOL/CICS on-Line Balloting. 50% reduction in printing and mailing costs
• Provided COBOL/VSAM/DB2 based Statement Rendition and Re-Issuance request capabilities

Confidential

Project Management / Business Analyst / DBA / Web Development

Responsibilities:

• Built ASP/ VB Script based 50 page state-of-the-art Website..
• DB2 Reporting and Marketing, Database.
• Presented new suite of reporting tools for Account Executive research
• Automated Customer E-Mail market reports

Confidential

Business Analyst - Quality Assurance

Responsibilities:

• Developed migration and testing strategies.
• Developed and executed QA scripts to verify check process workflow: Front-end data Capture, Transfer, Image capture, Storage, and Statement rendition.
• Provided End State reports for accounts based on comparative process flows

Confidential

Middleware Mentor, Web Developer

Responsibilities:

• Middleware Comparative analysis WEBLOGIC vs. WEBSPHERE
• Led development team through full project life-cycle creation of ASP based Account Executive / Client Account Intranet website. Developed Business Analysis and Architectural Design.
• Delivered a web based Client Dashboard
• Provided a 50% reduction in Account Executive response time to client.
• Increased Account Executive overall productivity by 50%
• Presented new suite of reporting tools for Account Executive research

Confidential

Project Manager/System Architect/Business Analyst

Responsibilities:

• Eliminated 90% of the encoding work force ($MM annual savings)
• Provided full documentation necessary to re-create lost check batches.
• Guaranteed 100% protection against lack of funds availability due to loss of physical checks
• Delivered new relational database with workflow analysis and reporting capabilities.
• Developed Ad-Hoc queries for corporate Managing Directors, using the Global Exposure database and Cognos report writer for deliverables.
• Created a DB2/MDC Data Cube (Data Warehouse) to provide critical process review
• Provided full documentation: business analysis, functional analysis and de-normalization data mapping.
• Mentored developers on the “best practices” for developing efficient queries. Faster development time and more throughput was realized, resulting in lower budgetary requirements for the business unit.
• De-normalized tables as needed, resulting in more efficient code and faster response times for queries.
• Developed new indexes to facilitate faster response times and more efficient access to data for queries
• Provided QA analysis, testing and documentation on all Ad-Hoc Queries.