Post Job Free

Resume

Sign in

Data Warehouse Financial Services

Location:
Princeton, NJ
Salary:
220
Posted:
April 19, 2024

Contact this candidate

Resume:

Page * of *

Vandana Thakur

ad44tc@r.postjobfree.com 857-***-****

Data and Analytics Product Leader, Strategist & Design Architect experienced in managing large scale digital transformation initiatives in the Fintech, Financial Services and Hedge Fund Industry.

Track record with managing the teams and building the on-premises and cloud data warehouse

& Lake houses, financial models & data processes for Security Master, Reference Master, Asset classes; Equities, Swaps, OTC and Exchange traded Derivatives, Equity/Collateral, Margin loans, Capital market products, Hedge fund strategies, Private Placements & Risk and Performance.

• Problem Solving- Extensive Experience & knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational & operational process problems; ability to apply this knowledge appropriately to diverse situations.

• Requirements Analysis – Expertise with methods and techniques to elicit record & analyze the business requirements to ensure the success of business processes in agile methodology. Ability to facilitate discussions across various levels of stakeholders.

• Re-engineering business processes & data platforms - Working Experience Ability to re-design, create and model the business processes, process diagrams, and identify data requirements for data warehouse, data marts & data lake. Ability to process the technical information and make sound business decisions.

• Data Architecture - Extensive Experience & ability to create models and standards to data governance, storage, management & integration with various data systems.

• Database Structures - Subject Matter Expertise Knowledge of and ability to utilize appropriate database structures to organize and store data in a particular manner.

• Data Modeling - Subject Matter Expertise in creating conceptual, logical and physical models, roles and security management for data warehouse and data marts, data lake, and lake house.

• Data Warehousing - Subject Matter Expertise Knowledge of how to collect data from different information sources and distribute them to users; ability to use the information to make sound business decisions.

• Liaise with DBA - Working Experience Expertise with partitioning, index rebuilding. handling data fragmentation issues, query optimization and liaise with DBAs for planning disaster recovery, backup strategy and performance monitoring.

• Business Processes & Data Governance - Extensive Experience & ability to create models and standards to data governance, management & integration with various data systems.

• Technical Tools - Subject Matter Expertise

SQL Server/Snowflake: Expertise with on-prem and cloud ETL/ELT data processes, building one-data platform Data Warehouse, Data-Marts, Data Lake, Snowflake, Python, AI/ML, Business Analytics, Snow SQL(CLI), DBT, FiveTran, Airflow, AWS Glue Data Brew, Streaming & Batch Data Ingestion for structured, semi-structured and unstructured data, Google Big Query and storage integration with AWS, Azure, GCP. Design Tools: Expertise in Relational and Dimensional data Modeling and tools. Performance Specialist: SME with Query and Processes optimization skills. BI Analytics: Expertise and hands-on with Power BI/DAX, Tableau, QlikView, SSRS, SQL Data Integration/ Governance tools: Integration Services (SSIS), BIDS, Informatica Power Center, IDQ/CDQ, EDC and Axon, MDM

Page 2 of 3

Bank of America, NY

Senior Manager, Data Architecture, Analytics & Strategy 2023 – Current Design the data pipelines and manage the product team responsible for building and delivering the front office solution, and analytics deliverables. Product won the top position for the 2023 Banking Tech Solution awards by the Fintech Futures USA. Product empowers the senior bankers for marketing capabilities and pitching the investment strategy and solution to the clients. Designed the data pipelines and One Data Platform for Analytics, Machine Learning and Quant teams. Responsible for managing multiple projects concurrently and align business stakeholders on priorities. Communicate the product vision and roadmap to C-Suite stakeholders and business teams, and drive user adoption for the product usage and self-service analytics.

PGIM, NJ

Senior Manager, Data Architecture, Analytics & Strategy 2017 – 2022 Responsible for building and executing the overall Business Process & data Architecture Strategy. Design, build and deliver the One Data Platform for Analytics, Client Reporting, Financial Models and processes for Investment teams, Trading Desk, Capital Markets, Investment Risk, Operations, HR, Compliance, Marketing, Finance Forecasting teams, working in agile framework. Responsible for building the reconciliation process for AUM & Cash Management, Defaults & Recovery Model, Financials & PnL Model, IRR (Interest Rate of Return) Model, dynamic Analytics and Reporting Model for ad-hoc & Performance Reporting for the investors and clients. Manage the team responsible for building the Data Quality and Governance framework for the business and liaise with Enterprise Governance team for strategy alignment. Derive the architecture refresh and process re-engineering initiative for the Salesforce to meet the exponential business growth. Work with the team and business steering committees to align the priorities for the data and analytics deliverables to meet the short and long-term strategic goals. Barclays Investment Bank, NY - Management Consultant Lead Design Architect/Product Portfolio Manager 2015 – 2017 Manage the team responsible for business process design, designing and modeling ETL feeds and delivery of data processes. Well versed in delivering solutions in extremely short timeframes. Responsible for modeling the security and counterparty resolutions, reference and market data handling for various trade and position feeds for the DW. Work with the business & technology partners; Head of Risk, Prime Services Equity Finance, EF Analytics and trading desk to analyze the business requirements, designing the business process for equity/equity derivatives and cash financing for PB PnL Model.

LOIM Hedge Fund, NY

Head Of Data, Analytics and Vendor Management 2011–2015 Manage the data and BI team responsible for building the on-premises Data Warehouse, performing all the tasks requirements gathering, designing, modeling, and setting up the analytical platform and BI reports for Portfolio Managers, Risk, Marketing, Compliance, Operations, and Investment teams. Liaise with data vendors, business data groups and technical teams. Responsible for designing and building the Security Master and integrating various feeds from Bloomberg, FactSet and Trading and positions feeds into the warehouse. In-depth knowledge of DW feeds from trading and Investment Risk Systems -Advent Geneva, Sophis, Bloomberg, G2 (Legacy trading System) & Eze Castle and regulatory reporting for EMIR, FSA, 13F. Worked with the Global Investment Risk Officer for designing and building the Risk and Performance dashboard and intraday Risk Limit monitoring Application. Page 3 of 3

Bank of America, NJ

Management Consultant 2010– 2011

Responsible for managing the team for designing and building the counterparty, notional and MTM risk control functions. Risk Aggregation data store is created with data from ~60 internal trading applications (Size ~ 14TB) of data for risk measurement calculations. Role required extensive knowledge of Equities and derivative asset classes and effectively articulating reasoning for data model design enhancements and strategically incorporated team member and management feedback to produce the quality results and handle the performance issues. Fidelity National Financial, NY

Technical Product Manager 2005 – 2010

Responsible for building the product and managing the product team. Product having market share of more than 50% of the world’s top banks syndication business - used by ~60 banks worldwide. System facilitates powerful data sharing among bankers, traders and salespeople within loan syndication and trading firms across the globe. Getronics Worldwide, Oslo, Norway

Management Consultant 1999 – 2005

Management consulting for the Den Norske Bank and Oslo Forsikring system. (Pension Management)

konstruct Systems, Chandigarh

Product Engineer (Product Start-up) 1997 – 1999

The leading sales and planning solution for office space architectural design and planning. An easy-to-use design and specification software for the do-it-all design professionals. Product launch was very successful and gained significant growth and revenue from the Canadian Market.

Harvard Business School Executive Program Online

Business Analytics, Business Strategy & Execution, Specialization in Leadership and Management Institute of Electronics and Telecommunications

Master’s Program in Computer Science and Technology Kurukshetra University

Bachelors in Computer Science and Technology



Contact this candidate