SUMMARY:

• Possesses over 20 years of full project life cycle development experience including detailed business analysis, formulating specifications, data modeling, data and process re - engineering, and development and deployment of enterprise-wide solutions.
• Successfully align technology solutions with business needs and liaise with business stakeholders and IT personnel at all levels.
• Extensive knowledge and experience in the design, business analysis and development of banking and financial solutions including fixed income trading, mid office, back office and custodial processing.
• Vast experience in the architecture of numerous OLTP solutions as well as multi-dimensional solutions including Data Warehouses and Data Marts.
• A highly skilled thought leader in the areas of Data Architecture, MDM, Data Governance, Data Quality and efficient delivery of Enterprise Intelligence Analytics.
• Design and deploy business intelligence solutions that provide valuable metrics used by management in decision making. Great operational economies are, thus, realized.
• Highly experienced in Banking, Brokerage, Corporate Actions, Corporate Trust, Profitability, Corporate Actions, Mutual Funds, Trust and Custody Services, Mortgage Banking, Insurance and other transaction intensive Sectors.
• Highly focused in the realization of operational economies by selecting the right mix of business acumen, technology know-how, leadership instincts and broad experience in order to accomplish the organization’s tactical and strategic goals.

TECHNICAL SKILLS:

Hardware: IBM PC, IBM Mainframe, Sun, and HP

Case Tools: Designer 2000, Coolgen Re-engineering, ERWin, Embacadario Data Architec/ErStudio, Seer HPS

ETL Tools: Ab Initio ETL Tool,

Informatica Power Center Operating Sys: OS/MVS, UNIX, Windows

Databases: Oracle, Teradata, DB2, MS SQL Server, Sybase AS, MS Access

Query Tools: SQL Navigator, PL/SQL Developer, TOAD, SQL Programmer, Enterprise Manager, Oracle Discoverer

BI/Analytics Tools: Tableau, Business Objects, Cognos, MicroStrategy

PROFESSIONAL EXPERIENCE:

Confidential,Herndon, VA 

Enterprise Data Architect

• Assessment of gaps in capabilities of client’s existing architecture and software in comparison to Industry best practices.
• Make recommendations in the areas of Architecture, Data strategy and the Selection of appropriate Enterprise Intelligence/Analytics Tools for capturing and Rendering Enterprise Intelligence and Analytics to Confidential ’s diverse user community.
• Design Data Model, develop and deploy Enterprise Data Warehouse (EDW) to capture Confidential Mortgage Deals transaction traffic - which includes packages of Mortgage obligations and ancillary details relevant to the Pricing, Securitization, and the relevant Processes in the workflows associated with the end-to-end processing of said deals.
• Design, develop and deploy a meta-data driven engine (Data Architecture and accompanying Operational Services/Process layer) for Capturing the metrics associated with inbound data feeds (from OLTP/ODS source application) into Confidential ’s EDW as well as outbound traffic into downstream Data Marts whose design are driven by OLAP requirements.
• Metrics include Data Quality Measurements, Transaction Volumes and transaction-Type Volumes, (New, Updated and Deleted instances), as well as business rules and data transformation rules.) The metrics proved pivotal in the areas of: quality assurance, capacity planning, performance monitoring, daily reconciliation between inbound and outbound traffic and overall process governance.
• Support business analysts in the validation of the documentation, query design, and integrity and accuracy of test results of OLAP requirements and ETL audit statistics.

Confidential, Sparks, MD 

Data Architect

• Design the data architecture to facilitate nascent BI capabilities such as analytics, guided analytics, predictive analytics data discovery, dashboards and user centric strategic data analysis and reporting.
• Maintenance of Enterprise Data Warehouse Data Model in Erwin Data Modeling tool.
• Participated, with Solution Architect, BI Architect and Business Analysts, in the selection of best of breed BI/Analytics Platform which best support PHH's ambitious business requirements, which included: a rich intuitive client experience and has ease of use, is robust enough for the enterprise, has support for bursting, can be integrated with email server and is portable to any platform/device.
• Perform data reengineering exercise to re-platform warehouse data from traditional Sybase ASE to high performing Sybase IQ.
• Analyze, investigate the contents of reference data; provide action plans for the standardization, cleansing of reference files as well as operational data. Design and implement procedures for the systematic correction of "un-clean" data elements.
• Design and deploy data architecture for a solution which determines, on monthly basis, current market value as well as projected future market value of same, based on myriad empirical data; Thus provide the basis for market timing in the sale of assets and the ability compare Actual Sale prices against their earlier projected prices.
• Provide relevant documentation of data artifacts (Data Models, KPIs, Dashboard Specifications, Reporting Templates, ETL tractability mapping, data transformation rules/formulae)

Confidential, New York, NY 

Data Architect//Data Modeler

• Engaged in the following Strategic endeavors:
• Designed Logical and Physical Models of Business areas for both OLTP Applications as well as for OLAP, MDM, Marts and Warehouses.
• Created and implemented standardized object naming standards and designed strategies for new object names to coexist with old ones. Instituted a Data Administration/Data Governance function where none previously existed.
• Liaise with development teams in designing the Data Access Layer and taking a preemptive approach to performance issues: Selectively conducting Transaction analysis, Formulating processes - stored procedures, functions and batch scripts (procedures) to address the needs of applications.
• Developed Advanced reports in Crystal Reports
• Support DBA team in the maintenance of Oracle database and in the tuning/optimization of queries and transactions.

Confidential,Westport, CT

Data Architect/Administrator and Mortgage Planner

• Devised logical data models using ER/Win; presented models to business community and developers via JAD sessions; developed physical database design and implemented same in Oracle RDBMS.
• Designed and implement an advanced query facility for use by mortgage brokers and bankers in locating the most competitive mortgage programs for a given borrower profile.
• Conducted performance testing of OLAP data queries and, where appropriate, make database design changes to facilitate speedier, yet consistent, data delivery.
• Developed and implement data access objects (stored procedures) for application that features real time monitoring of Mortgage Bank’s warehouse line of credit.
• Implemented system for managing customer contact and monitoring/managing the progress of loan processing and integrate same with company-wide loan processing platform.
• Designed advanced universe and web intelligence layers for business objects development and deployment.
• As an entrepreneur in the mortgage banking business
• Recruited, trained and managed a team of loan officers and processors deployed throughout tri-state area; Secured mortgage financing for real Estate Developers and Investors for commercial and residential projects.
• Assisted homeowners in navigating programs designed to enable them to restructure existing mortgages; even cases involving the prospect of foreclosure.
• Counseled homeowners experiencing difficulty meeting increased monthly payments on Adjustable Rate Mortgages.

Confidential,New York, NY

Data Architect, Application DBA

• Designed enterprise model using Erwin design tool and provided support and maintain to Sybase XI and Oracle 8i databases.
• Implement the physical database in Oracle 8i to support a web based order management and customer relationship management applications
• Architect a component-based security management facility, written in Visual Basic and employing ADO 2.5, that manages Application level security
• Design and Develop robust batch PL/SQL programs that exploit stored procedures, functions, packages and triggers
• Developed a messaging framework for pushing data to and pulling data from, other applications
• Designed, developed and tested packages, stored procedures and functions for invocation by Visual Basic and Java Applications components
• Investigated the use of XML as a B2B messaging enabler and SQLJ as a host language for developing/maintaining stored procedures, functions and packages in Oracle 8
• Specified the requirements for the development of a data warehouse and the cleansing and migration of unstructured data into same.

Confidential,New York, NY 

Data Architect, Application DBA

• Design data model using ERWin design tool and Implement the physical database in Oracle 8 to support case management and a forms management applications
• Architect a component-based reusable security framework in Visual Basic, which manages security at the database as well as the application level
• Develop robust batch PL/SQL programs that exploit stored procedures, functions, packages and triggers
• Design and test packages, stored procedures and functions for invocation by Visual Basic Applications
• Design a distributed data warehouse, which employed star schema design techniques and is geared to facilitate data mining as well as decision support
• Develop the corporate reporting infrastructure to facilitate the distributed deployment of management reports as well as OLAP functionality, complete with drill-down, roll-up, and ad-hoc capabilities
• This solution featured Visual Basic, MS Access reporting Engine, Advanced features of Business Objects Reporting Tool and Oracle 8

Confidential, New York, NY

Information Architect

• Designed a distributed Information Warehouse for Chase Manhattan’s Global Investor Services Division Warehouse is deployed on Sybase, Oracle and DB2 relational database management system engines
• Developed specifications for end-user reporting
• Designed and implement the Enterprise Data Model for Corporate Actions and provide leadership for incorporating same into the Chase Manhattan’s Global Custody Data Warehouse
• Developed Client Messaging framework for development of a central message handler and router to support inbound and out bound messages to and from the bank

Confidential,New York, NY

Data Base Administrator, Information Engineer and Client Server Architect

• Maintained vast Global Financial Enterprise Model and associated Physical Databases and application level models using ADW CASE tool
• Developed and deployed a GUI based Change Management/Tracking System that:
• Monitors all change requests to the business; Provides an approval process using business rules defined by a user review committee; Align business requests with technological infrastructure by associating (mapping) requests to physical (technical) constructs such as applications, databases, database tables, programs and subroutines; and, Provided online data analysis, dynamic reporting, version control and a maintenance scheduling facility
• Designed, developed and deployed a Decision Support Customer Information System employing ODBC, Visual Basic, MS Access, DDCS/2 and several DBMS engines
• Designed and developed a corporate Meta-data-mart with interfaces to CASE tools and production RDBMS catalogs for deployment to developers, business users and customers.
• Specified and designed a distributed relational architecture to support the Meta-data- mart
• The system supported ad-hoc queries and online request based reporting facility
• The system performed several impact analyses which are critical to effective change management

Confidential,New York, NY

Data Base Administrator/Integrator

• Designed, tuned, optimized and maintained Corporate Customer Relations database
• Established a departmental Data Administration function and introduced CASE tool at the user and department level
• Provided full mapping of Meta-data elements throughout every incarnation of conceptual data model:
• Logical/business model; Normalized physical model; Production (implementation) model; and, Historical/warehouse model.
• Designed and developed interface utilities to scrub and transform and then feed production data from Relational and legacy data stores into common Corporate Customer Relations Data Warehouse.
• This Solution was deployed nationwide on a distributed basis and employs:
• Data Fragmentation; Data replication; Distributed Transactions support; and, On Line Analytical Processing capabilities

Confidential, New York, NY

Information Engineer

• Served as Leading Information Engineer on an Information Strategy Planning Group
• Designed Entity Relationship Diagrams for the Sales, Medical Operations and Marketing functions
• Constructed high-level Process models for all business processes in the above areas
• Mapped Processes to business Entities via ADW’s Association Matrixes
• Recommended the components of a suitable relational information infrastructure which supports both OLTP and DSS needs of the Client organization
• Developed customized applications in Microsoft Access and Visual Basic for the maintenance of project documentation and the generation of Reports

Confidential, New York, NY 

Data Architect

• As an Application Developer and Designer, I Implemented a Decision Support System written in Microsoft's Visual Basic and Watcom VX*REXX which: provided access to meta data; supported the validation of data names; was vital to conducting impact analysis; and, was equipped with a reporting engine.
• As a Systems Integrator, designed a Client Information System. Implemented the underlying database and co-developed the supporting APIs in Microsoft's Visual Basic
• As a Data Analyst/DBA conducted enterprise-wide information modeling using Bachman and other CASE tools:
• Developed both logical and physical relational models for deployment to DB2 and other RDBMS platforms; Provided support/training to development teams; Evaluated the merits of referential integrity, units of recovery, concurrency and other processing/performance issues including SQL tuning and optimization
• As a Systems Administrator installed a DB2/2 Database Server and implemented a Distributed Client Server Application to support Application Development and Database Administration.
• As a Database Administrator managed:
• Implemented new releases of vendor-supplied data-based software; Issued and revoked access privileges (authorizations) to database users and local administrators; Executed Database Utilities to: insure data integrity and data quality, provide smooth data recoverability, and derive optimum database performance each business and/or processing day