SUMMARY:

• IT services to Fortune 50 companies, offering focused technical expertise to address rapidly changing needs of companies in Financial Services and Manufacturing industries.
• Team Lead / Oracle Data Architect / Oracle OLAP Cube Modeler within the Oracle EBS Database Tier Modeled and built new ORACLE OLAP DATA CUBES with Cube Materialized Views and Query Re - Write. Developed related ETL processes using INFOMATICA (Sikorsky)
• Team Lead / System Architect / System Modeler: Modeled new Access Management process flow including proxy token, group, role and use based entitlements using IBM’s Rational Software (UML)
• Information Architect / Business Analyst: Developed multi-workstream universal Business Glossary
• Team Lead / Business Analysis of Trade Execution Flow. Modified FIX Messaging to correct erroneous Regulatory Reporting of SWAP trades.
• Quality Assurance Testing using LoadRunner
• 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.
• Designed overall System Architecture using IBM’s Rational Software (UML), Designed detailed Data Layerl Model utilizing Erwin 7.x, RapidSQL, and Unix Scripting in an SAP/DB2 environment to streamline manufacturing process at Confidential .

CORE TECHNICAL PROFICIENCIES:

• DB2-DBA (IBM Cert. 9.5 LUW)
• SYBASE 12.5
• ORACLE EBS / OLAP / CUBE
• IBM Rational System Architect
• MS ACCESS
• SQLSERVER 2000/2005
• ERwin 7.x
• ER Studio 9.x
• RapidSQL/TOAD
• UNIX Script
• Visio / PowerPoint
• EDWH Design
• UML
• JSP, ASP
• JAVA2 / SWING, J2EE
• HTML, DHTML
• XML/CSS/XSD
• LoadRunner 12.50
• Equity Trading
• Options Trading
• Check Processing
• Enterprise Reference Data
• Cash Sweeps
• Statement Rendition
• Cash Management
• Payroll
• Proxy Notification

INDUSTRY KNOWLEDGE:

• Asset Management
• Portfolio Accounting
• Hedge Funds
• Cash Management
• Broker/Dealer
• Foreign Exchange
• Finance
• Equities
• Accounting
• Fixed Income
• Manufacturing
• Options & Futures
• Distribution
• Swaps
• Software Development
• Insurance Commissions

TECHNICAL SKILLS:

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

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect / Oracle OLAP / Cube Architect

Responsibilities:

• Designed and developed Oracle Star Schema Data Warehouse for aircraft tracking and maintenance.
• Oracle OLAP Cube with Cube Materialized Views and Query Re-Write capabilities for the analysis of and reporting on aircraft tracking and maintenance utilizing Oracle OLAP 11g.
• Developed ETL processes to support the on-going maintenance of the Star Schema DWH and OLAP cubes

Confidential

System Architect / System Modeler, Information Architect

Responsibilities:

• Utilizing IBM’s Rational System Architecure (UML) Modeled new Access Management process flow including proxy token, group, role and use based entitlements.
• Information Architect created Business Glossary based on IBM SA Encyclopedia Meta Data
• Quality Assurance Testing using LoadRunner 12.50

Confidential

Information Architect

Responsibilities:

• Information Architect / Business Analyst: participated in the development of a Universal Business Glossary.
• Quality Assurance Testing using LoadRunner 12.50

Confidential

Business Analyst, EDWH Manager, Data Architect

Environment: Oracle EBS Database Tier: ORACLE DWH, FIX Trade and Order Messaging

Responsibilities:

• Provide Business Analysis of Trade and Order execution .using INFOMATICA mapping tool to reverse engineer and validate current design. Made EDWH Design changes using ER Studio 9.x
• Detailed flow analysis: Trade and Order Execution FIX Messages (INFOMATICA)
• 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 - SOA Management & Compliance

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

Responsibilities:

• Responsible for the IBM Banking Data Warehouse (BDW) based Architectural re-design of the Confidential (EDW), extensive use of Excel Pivot Tables, Templates for Ad Hoc Reporting
• Forensic data analysis based on the EDW Enhancement Project BRD requirments.
• Developed Logical Data Model (LDM) based on the IBM BDW.
• Reverse engineered existing data flow using INFOMATICA mapping tool

Confidential

Data Modeler - Business Integration Services

Responsibilities:

• DB2/SAP, Oracle/SAP, Sybase, and DB2/DWH environment.
• Utilizing CA/Erwin AllFusion, ER Studio 9.x and Rapid SQL, design tools.
• Extensive Unix Scripting for Sybase and DB2 development, Rapid SQL for Oracle development.
• Relational Database Warehouse / Data Mart Design, Excel Pivot Tables, Templates for Ad Hoc Reporting
• Ongoing DW table design for Business Objects Report development.
• New Sybase source system table design and development.
• New Oracle/SAP processing table design and development.
• 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) using ERwin
• Created de-normalized Physical Data Model (PDM) using ERwin
• Provided Source to Target Mapping (STM) Excel spreadsheets database loading.
• Developed ETL processes using INFOMATICA

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 & 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:

• Brought on board to support a critical, short event horizon core business requirement.
• Provided data analysis, and correction to key reports being developed for presentation to the Confidential to meet new regulatory requirements and secure funding under the new guidelines for nursing home operator re-imbursement.
• Build and populated a new relational database (data cubes)
• Created Value Added Mission critical EXCEL Pivot Tables reports using EXCEL Templates

Confidential

DBA

Responsibilities:

• Developed Star-Schema physical models (DB2, SQLSERVER), providing faster load and recovery cycles. Interfaced with global teams to produce Multi-Dimensional Cluster (MDC) keys for new corporate-wide Client Data Repository Data Warehouse, resulting in dramatic decrease in query response times
• Created new Automated Backup and Recovery Process procedures
• 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

Responsibilities:

• Provided full life-cycle support to sunset existing homegrown medical records, patient and doctor billing, payroll and pension benefits core business applications for the State of Georgia Department of Health.
• Delivered new, streamlined and maintainable CICS / DB2 core business application.
• ETL of new DB2 database using Infomatica tool to speed up development cycle.
• 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:

• Provided Business Analysis, Architectural Design, Graphic Design, Data Feeds, and Relational Database development.
• Re-statement of business need and review of full workflow process.
• Project Management including allocation of resources and monitored critical path mileposts for two projects using MS Project to track critical path. .
• 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:

• Led team of QA technicians in the preparation of critical comparative analysis strategies.
• 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