SUMMARY

• Senior Data Architect with extensive experience in retail and institutional financial and insurance firms.
• Knowledgeable in real - time systems design and OLAP reporting systems.
• Worked with most data base platforms on the mainframe and distributed platform.
• Progressively managed small to medium sized groups of staff in financial and insurance environments.

TECHNICAL SKILLS

OO CASE: Rational Rose, Softbench, UML

Database: ORACLE, SYBASE, DB2, SQL Server, Teradata

OLAP: OBIEE, DSS (Microstrategy), Red Brick Warehouse, Hyperion Essbase, IMPROMPTU and POWERPLAY, Oracle EXPRESS SERVER

Chng Mgmt: PVCS, MS-VSS

Statistics / Quan: SAS, SPSS, STATISTICA, IBM Intelligent Miner

CRM: Siebel, Clarify

Prgraming: C, C++, VISUAL BASIC, PL/SQL, Perl

Front End: MS-ACCESS, MS-EXCEL, Crystal reports

Prjct Mgmt: MS-Project, Ergo, Remedy

ETL: Informatica 9, Ab Initio, Ascential MS SSIS

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Senior Data Architect

Responsibilities:

• Designed and implemented client master data model
• Designed and implemented product master data model
• Designed and implemented security master data model
• Redesigned the financial instrument ODS database based on FTI and other foundation models.
• Designed a hub-and-spoke data architecture (and relevant data model) to migrated our stove pipe datamart installation into a centralized data warehouse, reducing a tremendous amount out of ETL processing for these datamarts.
• Wrote several data flows (use cases, sequence diagrams, …etc) to outline data extraction and manipulation job flow.
• Managed all data architecture initiatives, from legacy migration, to OLTP and OLAP project support.
• Developed a knowledge repository to enable the IT organization to metadata..
• Maintained several data architecture repository releases in ER/Win and Embarcadero.
• Wrote several RFIs and RFPs to solicit vendor proposals for our strategic applicatios.
• Made several Basel II presentations to the financial controller community and management of the operations division.
• Managed several POCs that involved one or more external vendors in relation with internal strategic projects.
• Managed several projects simultaneously, including PFE (potential future exposure), Basel II implementation, P&L, and other regulatory projects.
• Designed relational and dimensional data models to support SOX and Patriot act initiatives.
• Implemented multi-tiered Risk Metrics Dashboard for the firm’s management.
• Took over existing projects as well as writing proposals for and negotiating the scope for new ones.

Confidential, New York

Senior Data Architect, Analytical Research

Responsibilities:

• Led a group of analysts, architects, project managers, and developers.
• Educated sector business teams (macro, non-dollar, muni, and mortgage) on understanding the data produced above to identify significant trend away from recent historical perspective.
• Redesigned data models for several retail and institutional systems and delivered Rational usecases for them.
• Developed risk management tools for real-time assessment.
• Provided assistance to the structuring & sales team in structuring, pricing and assessing the risk of complex transactions.
• Assisted the back office and other bank support functions in understanding of and dealing with risk facets of complex transactions
• Provided analytics algorithms for trading commodity/currency futures.
• Developed various credit risk hedging reports based on probability / density functions.
• Wrote budgets and project proposals. Staffed my team.
• Chaired JAD sessions, RAD forums, and business rule documentation efforts.
• Kept all business partners involved throughout the project by engaging them in prototype evaluation, scope revisions, and matrixed correlation of deliverables.
• Plotted the architecture and technology foundation for the enterprise analytics portal that offered such features as real-time charting applets as well as cube manipulation servelets.
• Designed the architecture for the alert authoring service in the portal to enable traders and other business users to create and use text alerts, dashboards, traffic lights, heat maps, and others.

Confidential, New York

Senior Engagement Manager, Finance research

Responsibilities:

• Managed a large group of staff, consultants, and business analysts, often in conjunction with other engagement managers.
• Led various teams of pre-sales engineers in preliminary engagements.
• Documented project plans for multi-national financial firms. These projects required data sources on different platforms and continents.
• Produced budgets and personnel plans both internally (the consulting firm) and externally (the client).
• Developed cross-market asset management integration architecture. For example, the NYC head office received up-to-the minute activities reports on their far east subsidiaries.
• Performed logical and physical data modeling, identifying supertypes and subtypes, translated entity-relationship diagrams into foreign keys.
• Create risk management systems for major financial services firms to assess their domestic and foreign clients through a unified interface that translated foreign business metrics into their local compatibles.
• Designed project modules based on OO Booch schemas.
• Integrated heterogeneous database systems offline (Oracle, DB2, Sybase, and flat files) through propriety host tools.
• Imported IMS and other non-relational data into DB2, Sybase, and Oracle.
• Created several ER diagrams as well as their logical and physical data models.
• Configured the administration service for remote administration and scheduling of data cleansing and transformation processes.
• Wrote several DB triggers, stored procedures, and scripts with nested cursors for real-time portfolio management.
• Created and maintained a PVCS version control system.
• Authored a rule base to infer non-linear information (such as covariance and trending) for knowledge discovery and forecasting.
• Wrote several analytical algorithms for risk exposure, foreign fixed income trading, and performance appraisal.
• These scripts were used to populate appropriate tables of the analytical DB as part of the engagement.
• Created mirrored instances for real-time fail-over substitution.
• Developed performance logging scripts that generate alert e-mails on abnormalities.