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.

TECHNOLOGY SUMMARY:

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

Principal

• 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 Fannie Mae’s diverse user community.
• Design Data Model, develop and deploy Enterprise Data Warehouse (EDW) to capture Fannie Mae 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 Fannie Mae’s EDW as well as outbound traffic into downstream Data Marts whose design are driven by OLAP requirements.

Confidential, Reading, PA 

Enterprise Data Architect

• Development and maintenance of Enterprise Data Model, arranged into Subject Areas, in Erwin Data Modeling Tool.
• Participate in the evaluation and selection of hardware and software to support key OLTP business areas: sales, order processing, production, marketing, CRM and field operations.
• Participated in the selection and deployment of a BI/Analytics Platform which best support GreatGrow’s ambitious OLAP business requirements, which include:: monitoring the growth of crops grown by farmers around the world and tracking the use and rates of use of GreatGrow’s soil amendment products.

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, Baltimore, MD 

Data Architect/Data Modeler

• As a Data Architect/Data Modeler: Participated in the refinement of Enterprise model (of OLTP System physically deployed in DB2) to support the implementation of a federated case processing solution for processing disability claims for the social security administration. This entailed logical and physical modeling, data governance strategies, data quality analysis, and data dictionary management and governance.
• As a Systems Engineer: For the BI component of the solution, I co-authored BI User Manual by leveraging Detailed System Specifications (DSS) Documents and Use Case and User Interface Specifications (UIS) documents. Manual's purpose to present features and facilities of MicroStrategy-based BI Solution
• Conduct Data Analysis of Data in Mainframe VSAM file systems and re-engineer same into Oracle RDBMS.
• As a Database Developer/Architect: Co-Developed the Data Access Layer for the BI component of Solution; developing scripts in Oracle 11g and configuring same for high performance.

Confidential, New York, NY 

Data Architect//Data Modeler

• Using ErWin Data Modeling Tool, I led effort to Design and Develop the Enterprise Data Model to Support the implementation of a Federated Agent Compensation Solution. This entailed Logical and Physical Modeling, Data Governance Strategies, MDM, Data Quality Analysis, ETL process flow definitions and data mappings (from OLTP-based source data stores to EDW target) and Data Dictionary management and Governance..
• Formulation of Strategies and Solutions aimed at achieving Multi-Platform data base integration among systems on disparate Operating Systems (Windows, Unix and IBM/MVS) and corresponding Database Engines (MS SQL Server, UDB and DB2)
• Assessment of appropriate performance and tuning options for complex queries in UAT and Production environments.
• Collaborate/support business analysts in the specifications and development of OLAP queries to satisfy initial BI needs.

Confidential, Baltimore, MD 

Data Architect//Data Modeler

• Augmentation of existing Data Warehouse, which bears Beneficiary Data pertaining to Telephony (IVR) and Internet interaction, including Web Chat, for the US Centers for Medicare and Medicaid Services, CMS.
• Use of Ralph Kimball’ methodology in re-engineering dimensions and implementation of enhancements to Warehouse and ODS/OLTP alike.
• Liaise with operational, development and business intelligence teams in the joint design of solutions from an enterprise standpoint. Use of Star Schema.
• Established/fine-tuned data governance/administration practices for both physical and logical models through ERWin Modeling Tool and other document standards.
• Performed data cleansing procedures to restructure dimensional (reference) data with the aid of Informatica DQ and native SQL procedures.
• Performed high performance optimization and tuning of BI and OLAP queries against massive Data Warehouse deployed in an Oracle 10g platform. Optimization of complex transactions featuring Tables with 3+ billion rows and having the features: partitioned tables with partitioned indexes, parallel processing, appropriate indexing strategies, distributed queries and distributed transactions.

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 

SIA- Data Architect/Integrator

• Design and implement data models and accompanying physical database design to support a solution that monitors all fixed income funding activity (specifically, municipal and corporate bonds), determine the congressional districts where in the instruments are issued and conduct data mining and warehousing activities on the underlying data.
• Responsibilities included logical and physical database design, data administration and development of business intelligence solution.
• Develop decision support User Interface that facilitates management reporting, data inquiry (lookups) capabilities, and other strategic Information Analysis features.
• The solution features online and hard copy reporting, ETL, warehousing, purging and archiving support features.
• Developed advanced reports in Crystal Reports and MS Access.

Confidential, New York, NY 

Information Architect/Integrator

• Design, develop and deploy a Visual Basic Windows based Executive Information System for tracking the progress of Dental Insurance Claims at offices throughout the country
• Design a data mart, complete with Online Line Analytical Processing (OLAP) and Strategic Information Analysis features which provide managers with the power, at their fingertips, to do the following:
• Develop, test and implement stored procedures used in the daily maintenance of the claims data

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

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