SUMMARY:

• Data Architect / Business Analyst / Data Analyst with 15 years of IT industry with 10 years implementing Data Warehousing Concepts and Business Intelligence Solutions for Banking & financial clients
• Extensive experience in Business Intelligence reporting tools like Tableau, Cognos, Business Objects . Well versed with Microsoft suite of BI tools like SSRS, SSAS and Power Query
• Participated in several strategic systems development and re - engineering initiatives in a variety of critical roles
• Business Requirements Definition and Business Analysis
• Translate information into relevant business documentation
• Data/Information Architecture - Data integration through analysis, profiling, cleansing & mapping of the legacy data systems
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML)
• 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
• 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
• 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/ 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: Underwriting/Reinsurance: Commercial Property, Automobile, and General Liability, Excess & Surplus lines

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, 2005, 2008, 2008R2, 2012) Oracle, Teradata V2R5, Teradata 12, SYBASE and DB2

Reporting Tools/GUIs/CASE Tools: IBM Infosphere Data architect 9.1.1, Erwin 9.1, Power Designer, ER/Studio, TABLEAU, Cognos 7.3.9, BUSINESS OBJECTS, 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: 3NF(OLTP), Star& SNOW-FLAKE schema, 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, Burlington - NC

Data Architect / Business Analyst

Responsibilities:

• Serve as liaison between the business operations and technology teams through the project lifecycle to deliver tools and functionality that allow end users to drive organizational goals & improve productivity
• Worked with Line of Business to gather detailed business requirements (BRD) through meetings and JAD sessions.
• Worked closely with other BAs on the team to ensure timely preparation, updates, and delivery of project artifacts.
• Conducted and facilitated Daily Standup meetings during the requirement gathering sessions with Stakeholders.
• Created user stories, software functional specifications, and requirements for multiple Insurance products, Claims, and Authorizations modules under iterative framework
• Work with the Architecture team to implement data strategies, build data flows and develop conceptual data models

Data Architect

Responsibilities:

• Research and propose technical strategies.
• Study and document architectural frameworks and reference material.
• Identify and solve complex design problems and creates new solutions.
• Design and modify components of new and existing IT systems and vendor offerings to promote integrated corporate business systems.
• Design, support and deploy mechanisms to enhance, refine, and deliver the architecture vision.
• Create the Conceptual Architecture, Vision and Principles and develop Business models to guide development of the architecture.
• Analyze current information technology environments to identify and assess critical capabilities and recommend solutions.
• Provide research and development activities for architecture.
• Develop frameworks, standards and reference material for architecture and associated products.
• Develop and maintain common services, repositories and utility components for the enterprise.
• Develop and maintain enterprise-wide and domain blueprints and models for the architecture portfolio.
• Provide program and project level architecture, including support for data, application and technology architecture.
• Provide data, application and technology deliverables on a program and project level basis including risk and opportunity assessment, modeling and design related products and services.
• Manage the architecture governance activities associated with ensuring compliance with the enterprise architecture.
• Effectively communicate the architecture to all levels of the organization.
• 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.

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, Informatica PowerCenter 9.1, Oracle 9i / 10g, Exadata, DB2, PLSQL & Toad

Data Modeler / Associate

Responsibilities:

• Develop and plan required analytic projects in response to business needs.
• Business analysis for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans. 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.
• Assist the team on Data Integration - Data Profiling & transformation of the legacy systems
• 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.
• Collaborate with Tableau developers & provide for the data mapping requirements including Data acquisition, preparation, governance, and provisioning
• 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 9.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,, Tableau, Cognos, Business Objects.

Data Modeler / Senior 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.

Data Modeler / 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, Business Objects.

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, Cognos.

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

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