We provide IT Staff Augmentation Services!

Data Architect Resume Profile

3.00/5 (Submit Your Rating)

Summary

Technology Delivery Manager Project manager

  • Combines degrees in Computer Engineering Mathematics with 15 years of progressive roles as Development Lead, Systems Data Architect, Business Analyst, Project Manager Development/Delivery Manager in leading Investment Banks.
  • Certified PMP and ITIL V3 Professional
  • 10 Years of experience in managing Global Projects managing Global Teams compromised of Developers, Business Analysts, and Production Support groups in North America, Asia Europe.
  • Thorough knowledge of Financial Institutions, Products and Regulations with focus on Fixed Income, OTC Derivatives, Treasury, Cash Management , IR Derivatives, FX Trading, Market Risk, Credit Risk, Basel , Sarbanes Oxley, Basel Regulatory Compliance.
  • Extensive experience in building effective relations with Senior Management in both the Business Technology sides.
  • Solid Business Analysis experience including Enterprise Analysis, Requirements Elicitations/Analysis Solutions Assessment
  • Extensive theoretical and hands-on knowledge of most Data Management Business Intelligence areas including Data Warehouse architecture, Dimensional Relational Data Modeling, ETL Processes, Data Governance, Master Meta Data.
  • Practical/Theoretical Knowledge of most Software Development Methodologies Quality Management/Control Practices.
  • Leadership and hands-on experience in Change Control, Systems Migration, Capacity Planning Disaster Recovery.

CAREER SUMMARY

Company

Department s

Role Title

Leading Investment Bank.

Market/Credit Risk Data Management, Basel, Collateral

Project Manager/Lead Business Analyst

Natixis Capital Markets

Back Office Systems Supporting Various Departments including Finance, Operations, Middle Office, Risk, Fixed Income, Derivatives, Lending, Cash Management

Systems Data Architect

Lehman Brothers Inc. Currently Barclays Capital

Fixed Income, Treasury, Cash Management, Reconciliations, Reference Data

Vice President, Systems/Data Architect Business Analyst

Goldman, Sachs Co.

Risk Asset Management IT

Technical Lead

Lucent Technologies

Voice Recognition Applications

Senior Consultant

PriceWaterHouseCoopers

Human Capital Mgmt

Technical Lead

New York City, Office Of the Actuary

Pension Plans Group

Actuary/Business Analyst

TECHNICAL PROFICIENCIES

Project Management Tools

Microsoft Project, SharePoint, TWIKI, JIRA, Microsoft Office

Modeling Analysis Tools

UML, SysML, BPMN, ERD, Visio, Erwin, CASE, Power Designer, Visual Paradigm,

RDBMS Data Warehousing

SQL, Sybase, Sybase IQ, Oracle , DB2 UDB , Microsoft SQL Server Informatica ETL

Business Intelligence/Reporting

Business Objects, Microsoft Reporting Suite, Crystal Reports, Microsoft Analysis Services

Frameworks/Middleware

J2EE , TIBCO Active Matrix , Weblogic, Spring Framework, EJB, Hibernate, Struts , EMS JMS

Specialized Third Party Products

Misys Summit, TLM, Documentum, Staffware, Smart Stream TLM , GEAC,AUTOSYS

Languages/Scripting

JAVA, Perl, C/C /, UNIX Shell Scripts , JavaScript, HTML/DHTML, XML/XSL

EMPLOYMENT HISTORY

Confidential

Project Manager, Business Analysts Manager,

  • Managed all Projects related to the Development and Maintenance of the Risk Data Management System.
  • This system reconciles and validates Trade, Book Portfolio level data used by Risk Managers and Data Stewards in the areas of Market Risk, Credit Risk, Collateral, and Basel Implementation The system supports Risk Managers, Risk Operations, Middle Office, Back Office and Data Stewards in various groups.

Accomplishments:

  • Managed and completed 4 high profile development and hardware procurement projects in parallel. The objective of these projects is to improve the capacity, performance, throughput and availability of Risk Data Management System.
  • Devised and implemented a process to incorporate new Trading Systems into the Risk Data Management suite.
  • Put in place processes and procedures for Change Management, Release Management and Problem/Issues Reporting.
  • Built and trained a team of 6 business analysts to manage, improve and oversee the infrastructure of the Risk Data Management system.

Responsibilities as a Project Group Manager Include:

  • Responsible and accountable for the coordinated management of multiple related projects directed towards the incorporation of all Credit Market Risk Data into the Risk Data Validation System.
  • Managing a global team of business analysts and project managers.
  • Working with senior management from the IT and Business side to develop a road map for future systems enhancements.
  • Reporting to Senior Management on the status of ongoing projects and new initiatives.
  • Working with heads of upstream and downstream systems to co-ordinate systems migrations, and other changes in the Risk, Back Office, Middle Office and Front Office areas.
  • Overseeing the creation of Project Plans, Business Requirements Documents, Functional Requirements Documents, Test Scopes Plans and Production Support Run Books
  • Overseeing ITIL V3 implementation in the Risk Management area
  • Creating Change Control Release Management processes and procedures.
  • Overseeing Capacity Planning, Business Continuity Planning and Disaster Recovery procedures.
  • Acting as the group liaison with Internal External Auditing Compliance.
  • Managing Hardware procurement, deployment and configuration.
  • Software and applications evaluation and procurement.

Confidential

  • Project Manager Data Architect Back Office Systems
  • Architect of the General Ledger Unification
  • Project which will consolidate three General Ledgers Systems in One System.
  • Data Architect for the Global Back Office Data Warehouse which will host all Back / Middle Office Data from most Business Units including Finance, Treasury, Cash Management, Equities, Fixed Income, Derivatives and Lending. The system will mainly be used for Operational Risk, Credit Risk and Basel II reporting.
  • Systems and Data Architect for a J2EE application which is used to manage Credit Risk and Collateral Margin Calls.
  • Converted 120 night batches to grid computing using TIBCO DataSynapse Grid Server

Confidential

Systems Architect /Business Analyst

  • Business Analyst Architect of the Derivatives Early Retirement System used to terminate Lehman Derivatives Positions.
  • As Business/Systems Analyst contributed towards the integration of 7 Lehman Systems into Barclay's platforms and the sun setting of redundant systems in the Finance, Operations, Cash Management, Reference Data and Reconciliations areas.
  • Coordinated the fulfillment of 500 Forensic Data requests submitted by the Bankruptcy Administrators and Courts.

Systems/Data Architect

  • Reduced Manual Processing by 40 in the Finance and Operations departments through Strategic Tactical Solutions.
  • Led the design, implementation and configuration of the Global Treasury Workstation in America, Europe and Asia
  • Designed and led the implementation of a Framework to automate regression testing after major changes and upgrades.
  • Re-engineered the Cash Straight through Process to reduce latency from 30 minutes to 15 seconds.
  • Led the Integration of numerous Vendor Products including TIBCO, Informatica, Business Objects and Documentum.
  • Modeled and designed the Lehman Global Debt Accounting Data Warehouse use for annual and quarterly reporting.
  • Architect and Analyst of 8 J2EE Business applications which were deployed on the Lehman Live Portal
  • Member of the Systems Architecture Review committee which reviewed and approved systems architectures and blueprints
  • Led the Sarbanes-Oxley Implementation and Compliance efforts in the Finance Department.
  • Member of the ITIL best practices committee which led several initiatives including Release Change Management, Incident Management, Capacity Planning, Business Continuity Disaster Recovery,
  • Integrated the HJM Pricing Model into Treasury and Fixed Income systems to allow the pricing of Bermudan Swaptions.
  • Conceived, designed and led the development of a Real Time Reconciliation System: An in-house J2EE application, which allowed business users to reconcile real time data from two systems or sources , generate exceptions reports and identify, investigate and resolve breaks online.

System Featured:

  • Dashboard to track, run and revise reconciliations
  • Open Items Investigation Engine.
  • Extendibility: Dynamic addition of new systems, data sources and queries via a J2EE interface.
  • Drill down to Source Systems to analyze mismatches and outstanding breaks.
  • One to One, One to many and many too many matching.
  • Weighted Matching Algorithms
  • Creating and assigning Matching Algorithms using a GUI.

Technical Lead/Senior Developer

Confidential

  • Technical Lead for the design and development of the Lehman Structured Notes Auto-Mirroring System. This system was implemented using TIBCO RV and JMS, which enabled the auto-mirroring of structured notes equity linked swaps which were booked in Lehman Euclid Equities Systems to Securities, Bonds and IR Swaps in Treasury Summit... The System was implemented using TIBCO Adaptive Database Server, TIBCO RV, and TIBCO Business Works. Business Rules were implemented using C , JAVA, Perl and Sybase Stored Procedures.
  • Designed, Modeled and implemented numerous Sybase Databases
  • Managed the conversion and migration of three Visual Basic/C systems to J2EE platform, 10 months ahead of schedule.

Technical Lead/Senior Developer

Confidential

  • Architect/ Lead Developer of a Cash/ Liquidity Management System which automated manual processes including:
  • Control and Manage the Firm's intraday liquidity with banks
  • Ensure all cash flows are facilitated within the Firm's credit availability
  • Enforce controls by integrating regulatory, accounting and legal policies with the Firm's cash disbursement procedures.
  • Forecast, Monitor and evaluate the efficiency and accuracy of funding projections.
  • Provide funding projections for secured Fixed Income funding requirements
  • Project short term cash needs across all entities and bank accounts
  • Provide margin forecasting
  • Ensure funding availability for secured and unsecured financing requirements throughout business units in the Firm
  • Facilitate the Fixed Income funding process via Triparty and Held in Custody secured financing transactions
  • Monitor the flows through real-world bank accounts and optimize end of day balance positions
  • Monitor and Benchmark Cash Management performance to internal targets and industry benchmarks
  • Designed and Developed numerous applications in the Fixed Income , Treasury, Cash Management and Operations areas including:
  • Global Debt Database: This system was the global data repository and analytical tool for Long Term Debt and Hedges. Products included Bonds, IRE/ FX Swaps, Money Markets, Caps/Floors and Swaptions. The system was used for Balance Sheet/Income Statement reporting, Marking to Market, Cash Margin Calls and Hedge Effectiveness Measurements.
  • Pre-settlement System: This application is responsible for the generation and processing of Treasury cash flows based on trades booked in Treasury Summit. It allowed manual release, netting, bulking and splitting of payments. It is capable of processing 600 messages/minutes .The system is built using Summit APIs, SDL, J2EE and TIBCO Suite.
  • Cash Positioning: This J2EE application was used by the Lehman Cash Management Team for Cash Positions generation, Liquidity Reporting , Forecasts and Projections of funding requirements and availably.
  • Cash at Banks: This Lehman Live J2EE application was used for Banks Account Balances Reconciliation, Interest Burn Calculations, Liquidity Reporting, Funding Projections, Forecasting and other Cash Management functions.
  • Day Light Overdraft: A J2EE application which was used to load intraday minute by minute account balances for Lehman Bank Accounts with JP Morgan Bank and CITI Bank and calculate / reconcile overdraft fees.
  • Bank Relations Database: This application provided a centralized and automated workflow environment for business users to request the opening or closing of Firm Bank Accounts and for the Bank Relations team to approve and process these requests. The system also maintained a centralized comprehensive database of Banks, Contacts and Account
  • Signatory Verification System: This Lehman Live J2EE application automated the workflow for the submission and approval of granting, revoking or amendment of signing powers on outgoing payments. The system also stored definitive specimen signatures to be sent to outside parties, and to be used to confirm signatures on checks and documents.
  • Creditor Relations Database: This application provided the Creditor Relations group with a central warehouse of specific creditor and contact information including Credit Lines, Collateral, Haircuts, Ratings, Strategy, Relations and Return Model.
  • Letters of Credit System: this .NET application was used to process and track Letters of Credit, generate associated invoices, fax confirmation letters to the beneficiaries, and counterparties .The system stores all relevant information about counterparties and beneficiaries e.g. Credit Lines, Ratings, Locations and Contacts in addition to Lehman Referential data.

Confidential

Asset Management Division, RISK Management IT

Senior Developer

  • Contributed towards the design and development of PACE , an equities Portfolio, Analysis, and Construction Environment .The system enabled portfolio managers to measure manage risk and attribute performance of multibillion portfolios. Activities Included:
  • Contributed towards the Analysis, design and architecture of the system.
  • Implemented mathematical computation models using MATLAB and C .
  • Designed and implemented a database which stored historical and daily financial data.
  • Wrote applications in C , Java, and Perl to gather and load financial data from Reuters, Bloomberg., Yahoo Finance

We'd love your feedback!