Requests
9
Looking to expand my network
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Financial ServicesData Engineer
Jan. 2024 Implement data pipelines using shell scripting, Snow Pipe, Microsoft Fabric, model SQL & python-based transformation using dbt onto snowflake and Power BI for reporting.
Design and implement a fund level approval process for managing performance attribution, characteristic and exposure
Transition the performance data to a new vendor and integrate it with existing business entities and BAU processes. Create business objects and API contracts to publish data through data marts for the various down-stream systems.
Create a Power BI report suite to model performance share class analytics, performance attribution and portfolio characteristics.
Implement a chatbot using Snowflake Cortex – access a full range of LLMs and allows users to efficiently interact with enterprise data using natural language.
Aztec Financial ServicesPython/Data Engineer
Sep. 2022 - Dec. 2023 Build a robust, scalable data platform using Python, Spark (Databricks) & Azure, to generate actionable insights and explore hidden correlations.
Optimize performance of data factory pipelines and spark processes.
Assist in the creation of a row-level security model to control access across jurisdiction and products across funds and entities.
Implement ETL process to generate dashboards & reports using DAX and Power Query for reporting revenues, commitments and NAV data.
Fidelity InternationalPython Developer
Aug. 2022 - Jul. 2023 Implement pricing models for options, HTPAs, counterparty and liquidity risk and performance metric calculation using Python with unit-testing using pytest.
Migrate liquidity risk data from MS Access to MS SQL and implement ETL pipelines using Python.
Normalize all standing and reporting data (from excel files to MS SQL) and implement a reference data management workflow for operations.
Local Pensions Partnership InvestmentsSenior Python Data Engineer
Sep. 2020 - Mar. 2022London Designed and implemented an Azure solution with an end-to-end real-time self-serve data management solution using Azure Data Factory and Syanpse.
Developed a DevOps process with Azure using GIT for version control of SQL objects, data pipelines and power BI reports,
Automated all monthly manual excel based reporting to near real-time reporting using PowerBI dashboards.
Process data from multiple sources to generate performance metrics.
Modelled and created a SQL engine to calculate expected fees using terms and conditions specified in the IMAs.
Power BI fee wallet displaying the current fees being charged versus what’s expected.
Implemented Python scripts to flatten multi-level nested JSON hierarchies.
Invesco Ltd.Developer\BI Consultant
Apr. 2016 - Aug. 2020Henley-on-Thames, England, United Kingdom Designed and implemented an end-to-end data workflow to generate golden copy OTC positions used for counterparty risk reporting.
Process daily data from multiple sources to generate liquidity metrics and produce daily batch reports to aid regulatory reporting.
Designed an exception handling and reporting process and integrate it in the existing Counterparty Risk framework processing data from multiple sources.
Developed daily emails using Python for Counterparty and Liquidity processes to report data exceptions and metric outliers using Traffic Light convention.
Extended the DevOps process for Counterparty risk using TFS for deploying web applications
Use Python to load performance data, generate analytics and email watchlists.
Model and implement processing of CMLN, Reverse Repos, TBAs, Synthetic ETFs using Excel, SQL and Python to enhance risk reporting.
Collaborative development of a web application for data management of counterparty risk using C# and Xamarin
Mitsubishi UFJ Securities International plcDeveloper
Sep. 2015 - Mar. 2016 Implement data marts for exporting daily data to Murex
Analyze deadlocks and optimize performance of SQL queries and stored procedures by tuning indexes through SQL Server Management Studio.
Created reports using T-SQL to alert about database growth and failed jobs.
Implemented data-quality MS-Excel reports using T-SQL and Control-M for historical data to fulfill audit and regulatory requirements.
Designed wireframes and developed user interfaces (powered by SQL and HTML5) for requesting new securities from Bloomberg Server API.
Implemented a real-time data management workflow for the Data Management Office for monitoring data and managing reference data.
Refine the exception management workflow to ensure the team has a manageable set of exceptions to work against on a day-to-day basis.
Built UIs to provide transparency on the incoming and outgoing datasets with Markit EDM
Legal & General Investment ManagementBI Consultant
Jul. 2015 - Sep. 2015London, United Kingdom Implement data marts for exporting daily data to Murex
Analyze deadlocks and optimize performance of SQL queries and stored procedures by tuning indexes through SQL Server Management Studio.
Created reports using T-SQL to alert about database growth and failed jobs.
Implemented data-quality MS-Excel reports using T-SQL and Control-M for historical data to fulfill audit and regulatory requirements.
Designed wireframes and developed user interfaces for requesting new securities from Bloomberg Server API. The solution also extends to support requests made programmatically. The underlying solution is powered by SQL and HTML5.
Implemented an end to end data management workflow for the Data Management Office for monitoring data and managing reference data.
Refine the exception management workflow to ensure the team has a manageable set of exceptions to work against on a day to day basis.
Built UIs to provide transparency on the incoming and outgoing datasets with Markit EDM
APG Asset ManagementSenior Enterprise Data Management Developer
Jan. 2015 - Jul. 2015Heerlen, Provincie Limburg, Netherlands Extended the logical and physical data model; and implemented the SQL database schema for managing market data.
Design and implement ETL processes for modelling market data: Load Positions from accounting platform, Request Response Mechanism for multiple vendors, data acquisitions from multiple market vendors and custodians, data validation and mastering using T-SQL.
Workflow design for distributing market-data and pricing data to accounting systems through TIBCO, a data distribution layer.
Developed a workbench in EDM using SQL to manage static and market data returns. This involved displaying summarized views of data requested and received, along with a view on data-quality.
Independent / Freelance ConsultantSenior Python Azure/AWS Snowflake Power BI Data Engineer
Nov. 2013 - Dec. 2024LondonCollege Intranet
Develop an intranet for the college with a service-oriented architecture to migrate data from existing CRM and process data from inquiries to student onboarding – extract data from SAP BW (CDC) into Azure, ADF to staging, model data transformations using dbt, SQL model on snowflake, python-based transformations using data bricks, Power BI for reporting.
Assist in the implementation of a full DevOps process to build, test and deploy code using CI\CD and integrate package sharing using Azure Artifacts. Travel Portal (Startup)
Creation of logical and physical models to build a highly scalable database to support users, vendor and transaction data in the enterprise application.
Collaborate with cross-functional teams to architect a portal for spiritual travel (gaining a multi-million-$ investment) by sharing expertise and building a continuous learning culture.
Implement optimized data ingestion pipelines to load data using REST API and from files, Kafka and other internal databases, AWS - Kinesis for data ingestion, S3 cold storage, Lambda and Glue for data processing, DMS and Glue for data migration, Snowflake to manage all user/vendor transactions, Athena and Quick Sight for querying and visualizations.
HSBCEDM (SQL) Database Developer
Nov. 2013 - Jan. 2015London, United Kingdom Kimball’s dimensional modelling using MS SQL: designed and implemented dimension & fact tables for managing history using star schema.
Developed a SQL driven ETL solution for OTC and non-OTC intra-day assets - implementing an event watcher for file monitoring, components for loading and validating data, performing data translations and applying custom construction of new and existing fields, de-duplicating assets to represent a market view, constructing OTC structures to have a generic representation and generating a source master.
Designed and implemented a programmatic xml interface for requesting & receiving asset data and acknowledgement messages. This included loading & validation of data and xml messages, and data-transformation to generate the asset source master using T-SQL.
Developed an Operational Data Service in MS SQL to deliver positions and transactions data in the form of xml files and messages to internal and external consumers. This service works around a subscription model designed to extract record & deliver data.
Implemented a reference data model in SQL for managing business static data and data for managing the publishing layer.
Built an Asset of Interest model to help with delivering of asset and associated data to consumers.
Write Fitnesse tests to ensure all SQL objects are developed in line with naming standards and integrate these tests in overnight TeamCity builds.
SunGardProduct Manager
Jun. 2011 - Nov. 2013> Put together the voice of the market by running global product road-shows in the form of on-site visits for clients and prospects supplemented with information collected by the team in webinars and user group meetings.
> Work with the product management board to translate the voice of the market and independent market research to define a long term product strategy and elicit these in the form of a prioritised product roadmap.
> Manage the entire product life cycle from strategic planning to tactical activities by working closely with cross functional teams such as business analysts, development, quality assurance and client support.
> Work closely with marketing to publish monthly newsletters, product brochures and other marketing communications to define the go-to-market strategy, helping them understand the product positioning, key benefits, and target customer. > Work closely with sales and pre-sales to fill up RFI’s and RFP’s, and serve as the evangelist for the product offering. > Maintain and manage technical partnerships, requirement analysis, prioritization, evaluation and negotiations of terms with development.
SunGardRisk Model Project Manager (Cadis Team Lead)
Jul. 2010 - May. 2011Implemented an enterprise data-management solution to process equity, fixed income and funds data from multiple sources. This involved:
> Setting up a daily end to end to process of picking up files from the FTP, processing data through Cadis, creating reference data, setting up rules for matching securities across vendors and defining construction rules for creating the security and price master. > Setting up processes using Cadis porters and SQL Server Integration Services for feeding data into all legacy databases (SQL and other proprietary databases). > Setting up monitors to audit all data feeding in and flowing out of Cadis.
> Defining validation rules for testing vendor and master data. Following sufficient user acceptance testing, all relevant downstream data validation tests are gradually being replaced within Cadis. These improvements are aimed towards facilitating a controlled and well audited data-management framework.
> Setting up an exception management workflow for the operations team, such that, exceptions can be managed and data fixes get promoted to all downstream systems in an automated fashion, i.e., without support of the Cadis team for promoting daily fixes. > Setting up Cadis User Inboxes on various vendor, master and reference data to enable transparency.
> Providing technical leadership within the team - this involved supporting the team on technical issues, to managing database and IT issues.
SunGardR&D Analyst
Oct. 2009 - Jun. 2010> Analysed the yield production system to identify gaps in terms of robustness, responsiveness and flexibility.
> Worked with Research and Development to help improve the yield generation system to a more responsive and stable one.
> Worked in the end to end implementation of the new system and it's release into production.
> Analysed client portfolios to help clients make a smooth transition to the improved methodology.
SungardFixed Income Production Lead
Apr. 2009 - Sep. 2009> Responsible for ensuring timely and accurate delivery of risk models
> Management of all fixed Income Projects including analysis, project management and testing
SunGardRisk Model Tester
Jan. 2007 - Mar. 2009United Kingdom> Responsible for testing multi-asset class models with special focus on Fixed Income and Hedge Funds. > Use data terminals (Reuters, DataStream and Factset) for generating quality assurance reports.
> Performing an impact analysis on client portfolios under stressed market conditions and modeling improvements.
> Worked on a range of key projects . For example:
- Creating a bespoke industrial classification of fixed income assets which involved merging data from multiple vendors.
- End -to-End Integration of strategy re-classification within the Hedge Funds Model.
M.H.Saboo Siddik College of EngineeringLecturer of Mathematics
Aug. 2002 - Jan. 2006Mumbai Area, IndiaOne of the best rated engineering colleges affiliated to the University of Mumbai, offering degrees in various disciplines. Teaching Mathematics in a full-time capacity within all degree programs. Modules taught: Complex Differentiation & Integration, Vector Calculus, Differential & Integral calculus, Matrices, Partial Differentiation and its Applications, Fourier series, Numerical Techniques, Discrete structures, Probability and Operation Research.
Intch is a Professional Networking App for the Future of WorkSee more people like Zainab D on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
489368 people
16
Senior software engineer
19
Project manager @ Zois Energy limited
20
Project and business Manager
75970 people
19
Project manager @ Zois Energy limited
18
Financial Consultant @ Standard capital corporation
121
Investor Relations Manager @ ExxonMobil