SUMMARY:

• Data Modeler / Analyst / Business Analyst with 12 years of IT industry with 8 years implementing Data Warehousing Concepts and Business Intelligence Solutions for Banking & financial clients
• Participated in several strategic systems development and re - engineering initiatives in a variety of critical roles. Proven successes in:
• Business Requirements Definition and Business Analysis;
• Data/Information Architecture;
• Conceptual, Logical, Physical Data Modeling;
• Data Extraction, Transformation, and Loading (ETL) Specification & Design;
• Data Warehouse Analysis and Design; Dimensional Data Modeling.
• Master/Reference/Event/Metadata Architecture
• Business Analysis & Systems Design using a variety of methodologies Model & Event based Quality Assurance (QA)
• Industry-standard data models: FTI’s Global Financial Data Model (GFDM)
• IBM’s Financial Services Data Model (FSDM); Universal Data Models for a variety of subject area applications
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
• Developed Source to target mapping to load data in slowly changing dimensions
• Extensively worked source systems like Oracle, Teradata, Access, Flat files, XML and Mainframe.
• Worked expansively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
• Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.
• Broad industry exposure includes:
• Banking/Brokerage - Custody, Fund Services - Accounting & Investment Operations, Agency Lending, Collateral Management, Performance measurement, Corporate Liquidity Risk; Credit Risk, Investment Banking- Market, Clients Accounts, Instruments, Trades, Settlements, Positions, Margin Agreements. Fixed Income, Equities, Commodities, Cash Placements, Borrowings, Commitments, Loans, Deposits, Secured Financing: REPOs, Bond Borrows, Stock Loans, Collateralized Debt Obligations (CDO), Credit Default Swaps (CDS), Interest Rate Swaps (IRS), Total Return Swaps (TRS), Auction Rate Securities (ARS), Futures & Options (F&O), Equity Swaps.
• Insurance: Underwriting/Reinsurance: Commercial Property, Automobile, and General Liability

TECHNICAL SKILLS:

Architectures: Data warehousing, Business Intelligence, Decision Support System/knowledge management, information management, ETL Architectures, Relational Data Modeling and Database Design.

Databases: Microsoft SQL Server 2000 and 2005, Oracle, Teradata V2R5, Teradata 12, Sybase and DB2

Reporting Tools/GUIs/CASE Tools: Erwin, Power Designer, ER/ Studio, Cognos 7.3.9, Embarcadero, Serena Team Track 6.5, Ultra Edit, Quick Test Pro.

Hardware: NCR World Mark servers, Sun E 10000server

Languages: C, C++, SQL, Perl, HTML

Methodologies: Star schema database design, structured systems analysis and design.

Operating Systems: Windows NT, UNIX, NCR-UX, SOLARIS 9, AIX 5.1, MS-DOS.

Warehousing Tools: Informatica PowerCenter 7.1/6.1/5.1.2 , Power Mart 5.1/4.7, Power Connect 1.5, Teradata Utilities like BTEQ, FAST EXPORT, FAST LOAD, MULTILOAD, TPUMP, TERADATA QUERY MANAGER, PRIORITY SCHEDULER, VISUAL EXPLAIN, SQL ASSISTANT.

PROFESSIONAL EXPERIENCE:

Confidential, Washington D.C

Data Architect

Responsibilities:

• Understand and translate business needs into data models supporting long-term solutions.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimize and update logical and physical data models to support new and existing projects.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies.
• Validate business data objects for accuracy and completeness.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Develop data models according to WBG standards.
• Familiar with data warehouse life cycle and dimensional modelling.
• Guide System Analysts, Programmers and others on project limitations and capabilities, performance requirements and interfaces

Environment: ERwin Data Modeler 9.0, Power Designer, ER/ Studio, Informatica PowerCenter 9.1, Oracle 9i / 10g, Exadata, DB2, SQL Plus/ PLSQL & Toad

Confidential, Newark, DE

Data Modeler / Project Manager

Responsibilities:

• Develop and plan required analytic projects in response to business needs.
• Work with business domain experts and application developers to identify data relevant for analysis.
• Create data definitions for new database file/table development and/or changes to existing ones as needed for analysis.
• In conjunction with data owners and department managers, contribute to the development of data models for analytics.
• Contribute to analytical modeling architectures, modeling standards, reporting, and data analysis methodologies.
• Contribute to recommendations on analytical modeling products, services, protocols, and standards in support of procurement and development efforts.
• Collaborate with unit managers, end users, development staff, and other stakeholders to integrate data mining results with existing systems.
• Apply quality assurance best practices for modeling/analytics services. Specify the Data Quality standards.
• Adhere to change control and testing processes for modifications to analytical models.
• Identify, Diagnose and Resolve model performance issues. Monitor analytical system performance and implement efficiency improvements.
• Manage and/or provide guidance to junior members of the team.

Environment: AllFusion Erwin 4.1, Power Designer, ER/ Studio, Informatica PowerCenter 7.1.1, 7.1.4, Oracle 9i / 10g, DB2, SQL Plus/ PLSQL, Perl, Teradata 12, Quick Test Pro 6.0,, UNIX, AS/400.

Confidential

Data Modeler / Project Manager

Responsibilities:

• Assessed the reverse-engineered models for structural deficiencies and anomalies, scope for normalization & data standardization, opportunities for externalizing business rules, etc. Provided detailed analysis results and suggested recommendations for re-engineering.
• Developed a strategic data architecture that included: Party, Party Types, Party Roles, Party Relationships / Structures / Classifications, and their relationship to Accounts, etc. This was accomplished using Universal Data Models as the baseline models and customizing them for specific use.
• Outlined an extraction, transformation, and loading (ETL) specification to transition from the current state to the future state model.
• Identify/analyze business requirements from documents and end-user discussions which involved review of Service Oriented Architecture (SOA) and design of data models which include staging in data warehouse.
• Identified Objects and relationships between objects to develop Conceptual, Logical and Physical model in Erwin tool and later translated model into physical model using Forward Engineering technique in Erwin tool.
• Ensured accuracy and level of information supporting business requirements, as well as subsequent development activities comparing data loads between new EDW (Enterprise Data Warehouse) production systems and retiring system.
• Reduce bandwidth and execution time and also applying conditional logic, stored procedures are introduced in respected DBMS.
• Identified Objects and relationships between objects to develop a logical model in Erwin tool and later translated model into physical model using Forward Engineering technique in Erwin tool.
• Create/Tune Indexes, Tables, Views, Joins, Functions and Triggers for better optimal performance.
• Create stored procedures/macros to handle performance of database and to separate server side functions from the client side.
• Generated reports like subject area reports, entity relationship diagrams, attribute reports, table reports, column reports, indexing reports, relationship reports using Erwin Tool.
• Perform application testing eg.: of loading, reporting interfaces to BDW to verify all systems are in place and operational and the data restored is correct.
• Conducted JAD sessions, design discussions and SOS meetings to impart appropriate data mart.
• Defined enterprise data location architectures for ODS, DataMart, and Data Warehouse data.
• Created Target to Source Mapping documents, Test cases for carrying out unit testing and part of functional testing.
• Documented business logic in Access associated with development.

Environment: AllFusion Erwin 4.1, Power Designer, ER/ Studio, Informatica PowerCenter 7.1.1, 7.1.4, Oracle 9i / 10g, DB2, SQL Plus/ PLSQL, Perl, Teradata 6.1, Quick Test Pro 6.0, TOAD 6.3.11.1.g, UNIX, AS/400.

Confidential

Data Modeler / Project Manager

Responsibilities:

• Developed Dimensional Data Models (Star Schema) to support the Risk Warehouse and MIS Reporting of Risk Analytics, in addition to logical and physical models to support end-to-end development.
• Development of the Operation Data Store (ODS) for housing trade and position data, sourced from a variety of legacy systems, involving both Cash and Derivative asset classes: Bonds, Loans, Treasuries, ABS, MBS, CDO, etc. and Credit Default Swaps, Credit Linked Notes, Total Rate of Return (TROR) Swaps, Interest Rate Swaps, Swaptions, etc.
• Provided ETL expertise in developing transformation specifications for legacy data.
• Developed meta-model structures that define the notion of Portfolio Management with functions: Define Portfolio, Assemble Portfolio, Evaluate results against Risk Limits, Compute & Store Risk Analytics, etc.
• Subsequently, for Short-term Trading Technology (a business systems area within Global Credit), provided Data Architecture and Modeling support for an Auction Rate Security (ARS) Trading System re-engineering initiative. Activities included reverse-engineering the current system and then re-engineering it to meet enhanced requirements and capabilities. The deliverables included an information model and a physical model of the new ARS trading system.
• Translate business and data requirements into Logical data models in support of OLTP, Operational Data Structures and Analytical systems;Ensure data design follows the prescribed reference architecture and framework
• Ensure design reflects appropriate business rules, and facilitates data integration, data conformity and data integrity
• Ensure data structures are designed for flexibility to support future business needs and enhancements
• Develop Hierarchical modeling and dimensional modeling constructs; Develop and maintain the Data Warehouse Bus Matrix Architecture
• Design and govern data services messaging constructs in XSD format.
• Understand the relationships across business information and units of data; collaborate with Business Analysts, Data Stewards and Business Customers to identify data usage patterns and to formulate Business names, definitions and data quality rules for data elements

Environment: Erwin 3.x, Embarcadero, Power Designer, Informatica Power Center 6.2, Oracle 8.0, ER/ Studio, SQL Server, Perl, SAP BW, UNIX Shells, PL/SQL, Sybase, Windows NT, DB2, Sun Solaris.

Confidential

Data Analyst / Modeler

Responsibilities:

• Credit Infrastructure Transformation (CIT) Project in the Global Credit Risk Management (GCRM) business area of Investment Banking
• Developed the Strategic Data Model for the Credit Facility Definition & Repository (FDR), the Approval Recording & Control (ARC), and the Rules-based Risk Management (RBRM) platforms
• Developed meta-model structures that define the terms and conditions governing credit facilities and Credit Policy approval grids based on credit facility types. Corporate and Institutional clients are able to define credit facility templates and instantiate credit facilities based on these externalized business rules
• Developed information, logical, and physical models to support end-to-end development activities
• Provided ETL expertise in developing transformation specifications for legacy credit facility data
• Development tools: Rational Rose; ERwin.

Environment: Erwin 3.x, Embarcadero, Power Designer, Informatica Power Center 6.2, Oracle 8.0, ER/ Studio, SQL Server, Perl, SAP BW, UNIX Shells, PL/SQL, Sybase, Windows NT, DB2, Sun Solaris.

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Worked with the business users to identify business requirements and analyze the possible technical solutions
• Was responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans.
• Designed the business requirement collection approach based on the project scope and SDLC Methodology
• Understood Fixed Income Modeling, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing
• Conducted SMEs meetings, one on one interviews at both in-house and client locations, gathering requirements, providing analysis/functional specifications as well as Liaising closely both Front / Middle Office, and analyzing requirements using Requisite Pro - RUP
• Performed analysis and design projects using a systems development methodology. Worked with all levels of client staff in solution definition
• Designed and developed Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, and Collaboration Diagram
• Involved in Data Modeling design, ODS generation and Data Warehouse maintenance
• Involved in Business Process Flow development, Business Process Modeling, and Analysis.
• Assisted with user testing of systems User Acceptance Testing (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Analyze business needs to drive the delivery of solutions tailored to the business requirements
• Gathered user/business requirements by interviewing the various business units involved.
• Clearly document all requirements to define scope of delivery, and translate the requirements to functional specifications and prepare comprehensive test conditions/cases.
• Writing functional specifications & Preparing test plans and cases
• Collaborated with the Project Manager to organize training material and write user manuals
• Coordinate training with business operations and support activities with other disciplines to include training layout and plans
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML
• Analyzed existing systems logic difficulties and revised them as needed