SUMMARY:

IT Architecture consulted with global financial & insurance companies, led data architecture, data modeling, designing, managing & governance IT initiatives.

SUMMARY:

• IT architecture, data modeling more than 15 year working with Global financial firms, leading teams and initiative in global environment.
• Involved in leading data architecture, IT Strategy, data model design (Conceptual, Logical, and Physical), ETL design; begin to end dimensional data warehouse (OLAP) development, relational database (OLTP) development, Business Intelligence Applications.
• Erwin Model mart administration, Data model domains, naming standards, Creating Model reports.
• Led initiative to develop data architecture principles, data modeling standards, data modeling guidelines partnering with project teams.
• Syndicated standards, guidelines, best practices adoption to domain groups.
• Consumed with Data Warehouse methodologies - in particular Kimball, dimensional data warehouse architecture, modeling, data history, proven abilities to manage data warehouse end-to-end-complete implementation.
• Finance architecture team-led architecture and data modeling projects, supported more than 80 core applications in Financial Reporting, Financial Accounting, Tax & Treasury, Control, Management Information, conducted and contributes project architecture reviews.
• Teradata Financial Services LDM Release 11:00:00
• Involved interacting with Business stake holders, collecting functional requirements, translating functional requirements into technical specifications.
• Data Warehouse Kimball methodology, dimensional modeling, ETL, database concepts, SQL tuning, materialized views, index strategies.
• Report Design utilizing Report Net Cognos studio and Cognos ReportNet Metadata Modeling, Cognos Impromptu, Business Objects.
• Excelled in programming with PL/SQL, SQL, C, and Visual Basic.
• Database tuning, optimization, indexing, partitioning, parallelism.

CORE ARCHITECTURE/PROJECT MANAGEMENT:

• Data Modeling (CDM,LDM,PDM)
• Data Modeling (DB, DW, ODS)
• Data Architecture
• Metadata Architecture
• Data Integration, ICD (Interface Control Document)
• REFERENCE DATA
• Principles, Standards, Domains
• Team Building
• Project Management
• Databases, UML
• Equities/Fixed Income
• Deposit
• Collateral
• Secure Financing
• Loans/Cash
• Derivatives OTC/Exchange Trades
• General Ledger
• Regulatory Reports
• Treasury, Controls
• FO Risk & Control

TECHNICAL SKILLS:

Applications: Erwin 7.3, 9.5, Embarcadero Studio, IBM Cognos Report Net, Cognos Framework Manager, Power Play series 7, Business Objects webi, Oracle Designer, Oracle Developer, Power Play series 7, Informatica 8.x, Oracle Forms 4.5/6i, Designer6i, Oracle Enterprise Manager.

Database: Oracle 7.3, 8i, 10g, 11i, MS SQL Server 2000, 2005, 2008, IBM DB2, Teradata. Sybase 10.0, 11.0, Vertica

Programming Languages: PL/SQL, C, ProC, Visual Basic, Shell Scripting (K, Born, & C).

Methodology: E-R, Kimball, CMMI, SDLC.

Tools: SQL Navigator, Toad, SQL Loader, MS Visio, Rational Clear Case, Clear Quest, Erwin Data modeler 7.5,9.5 UML 2.0, Control-M, DB Visualizer 6.2, Embarcadero DB Artisan, Rapid SQL.9, CISCO COMPOSITE, SPOTFIRE

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Data Architecture Consultant

Responsibilities:

• Build Conceptual/Logical data model part of core business/functional team in coordination with business analyst, application owner, db design team.
• Involved in data modeling delivery, Data model domains, naming standards, Creating Model reports, Change management.
• UT Control Logical Data Model Span through multiple instrument class, retrieved data from trading applications, utilized by numbers of IT Technical teams to design PHYSICAL DATA MODELS
• Architected Data Quality LDM, resulted into high quality data; DQ model implementation recognized through-out the department, span into DQ initiative.
• Participated in interview with trading groups facilitator to gather requirements, acquire system flows, rectify issues come out of clients, supervisory reports.
• Updated design document with revised requirements.
• Participated in routine initiative review meeting with the stake holders, program managements, apprise the stakeholders with architecture.
• Data architecture Investment Bank FRONT OFFICE Risk & Control, Initiative involved building UT (unauthorized trading) Control to mitigate trading compliance risk.

Technical: Modeling tool CA Erwin 7.3, MS SQL Server2008, Oracle 11g, PL/SQL, SQL.

Confidential, New York, NY

Lead Data Architect

Responsibilities:

• Led data architecture initiative heading data architects & data modeler teams.
• Involved in highly complicated logical data model design for the mission critical system.
• Led data model reviews, communicating solutions to data architecture issues, syndication with out-sourced technical teams.
• Erwin data model ownership, Domains, naming standards, Change management, Model administration.
• Delivered source to target maps, Data Model Diagram, Data model reports, source data validation principles, data validation.
• Team leadership in projects, developing relationship with source system provider, data acquisitions, reporting groups.
• Designed Metadata model, developed metadata lineage maps, generated metadata reports.

Technical: Modeling tool CA Erwin 7.3, MS Visio, Oracle 11g, PL/SQL, SQL.

Confidential, New York, NY

Data Architect

Responsibilities:

• Data Architecture, Conceptual, Logical data model for CFO Loans, Cash Securities, Repos, Central FX Leveling, GL Adjustments, derivatives.
• Led team in designing Conceptual, logical data model for Management
• Information System’s (MIS) Data Warehouse. Coordinate with offshore technical teams.
• The Data Warehouse stores firm’s expenses, supply management, projects and sales credits.
• Designed Metadata model, developed metadata lineage maps, generated metadata reports.
• Led initiative to develop data architecture principles, data modeling standards,

Technology: Modeling tool CA Erwin 7.3, MS Visio, Oracle 11g, PL/SQL, SQL, UML 2.0, Embarcadero Rapid SQL, IFMS, Power Designerw2, Teradata Financial Services LDM (FSLDM) Release 11:00:00

Confidential, Jersey City, NJ

Data Architect/Modeler Consultant

Responsibilities:

• Architecture group member, lead conceptual, logical, and physical data models development.
• Design Conceptual, Logical, Physical data models, participated in core Client Reporting
• Application Development, contributed to capacity plans for new systems, analyze existing models, design, guide implementation process flow.
• Interact with source system owners, developers to acquire knowledge, analyze system database, reverse engineering data models.

Technical: Modeling tool CA Erwin 7.3, Oracle 11g, MS SQL Server 2005, DB2, PL/SQL, SQL, UML 2.0, Toad 10.x, DB Visualizer, DB Artisan.

Confidential, New York, NY

Data Architect/Modeler Consultant

Responsibilities:

• Responsible for data model, design, implementing, deploying, and supporting the data architecture in a data warehousing environment.
• Led data architect/data modeling effort covering conceptual, logical, physical data model for relational as well dimensional model, data dictionary, metadata.
• Collaboratively worked with domain architecture, project management in all project stages; contributed in time estimation, tool selection, and technical resource allocation.

Technical: Modeling tool CA Erwin 6.3, Oracle 10/11g, MS SQL Server 2008,PL/SQL, SQL, MS Visio, UML 2.0, SQL Loader, Control-M Scheduler.

Confidential, Jersey City, NJ

Data Architect/Modeler Consultant

Responsibilities:

• Instrumental in complete architecture, re-design and development of data warehouse using Kimball dimensional model.
• Designed, model and implemented new fact grains, SCD, Conform dimensions, degenerate dimensions.

Technical: Kimball Dimensional Data warehouse, Oracle 10/11g, CA Erwin 7.3, PL/SQL, SQL tuning, Informatica 8.11, MS Visio.