Data Architect/modeler Resume
New, YorK
SUMMARY:
- Extensive experience in business workflow, project management, process and data analysis of Financial Systems
- Legal and Compliance, Trading and Sales, P/L, Risk Management, Credit Exposure calculations.
- Expertise in mapping the data model elements to their corresponding sources and creating extraction, transformation, and loading (ETL) rules.
- Experience defining Data Warehouse and OLTP data architecture.
- Comprehensive Project Management skills and proficiency in all phases of Software Development Project Life Cycle.
- Strong interpersonal, communication and presentation skills, high level of assertiveness.
TECHNICAL SKILLS:
Skills: Market Data Analysis, Data Modeling, Business Process re - engineering, Project Management
Software / Real-Time Event Streaming: Confluent, Apache Kafka, Avro, XML, UML, SOAP, MQ, Pub/Sub
Technologies: Messaging / Service Design, Microservices, SOA, DigitalML, XMLSpy, Erwin Oracle, Sybase, MS SQL, Microstrategy, UNIX, Java, Shell scripts, Perl
Data Architect/Modeler Expert Competencies: Development of Data Models for Equities, Debt, Options, Futures, Swaps, and FX instruments. Design of execution, trade, and bookkeeping activity message models (via Avro, XML Schemas, XSD Taxonomies) for real-time messaging architecture.
PROFESSIONAL EXPERIENCE:
Confidential, New York
Data Architect/Modeler
Responsibilities:
- Data modeling for Sales Analytics and Market Intelligence system (customer fund inflows/outflows).
- Data modeling for Enterprise Financial Crime Prevention program ( Confidential / Confidential ).
- Created vision, functional requirements, risk assessment, project plan, and software requirements specification. Performed data gathering and gap analysis of multiple systems and vendor feeds, created dimensional and fact tables, created data dictionaries, taxonomies, created attribute transformations.
Confidential, New York
Data Architect/Modeler
Responsibilities:
- Basel III regulatory reporting and credit risk / collateral management system.
- Development of legal document logical and physical database schemas.
Confidential, Whippany, NJ
Data Architect/Modeler
Responsibilities:
- Development of OTC Derivatives reporting system.
- Logical and physical database design of Portfolio Swaps entity capture / update data structures.
- Created logical and physical database design schemas
Confidential, Jersey City, NJ
Data Architect/Modeler
Responsibilities:
- Development of Counterparty Credit Risk legal entity management system.
- Design of entity capture, parent/subsidiary hierarchy management, and credit line limits management.
- Developed daily Repo, Reverse Repo reporting positions, calculations of financing costs, repo rates, P&L.
Confidential, Whippany, NJ
Data Architect/Modeler
Responsibilities:
- Led analysis, strategy, proposals and recommendations for Enterprise Reference Data Architecture
- Financial instrument model, leveraging Confidential Standards
Confidential, New York
Data Architect/Modeler
Responsibilities:
- Development of Datamart reporting Income trading.
- Deployment of Straight-Through Processing (STP) initiative to consolidate Confidential traded and voice-brokered Futures and Cash trades, producing real-time portfolio PL and Risk calculations.
