Prashant Singh Email & Phone Number

Mumbai, Mh, In

Hyderabad, Telangana, India

Managing Crucial projects of the Front Office LOB for different desks (XVA, Credit, FX, Commodities) for Regulatory and policy review approvals of Job profiles, Access and identity management and Certifications of all business applications and users.Working on SDR real-time late reporting analysis, Automated the process using VBA & Power query which saves time and increases the accuracy of deliverables.Performing ad-hoc business transformation and automation requests for publishing Business intelligence reporting dashboards. Worked on Enterprise data management, validating data quality and accuracy as per business needs. Performing Sharp testing for Regulatory CFTC, TRACE, and SEC to audit Trade attributes. Publishing Audit dashboard to respective LOB heads, Stakeholders and Risk & Compliance to perform escalation protocols.Performing review of Volcker profiles, Market risk mandates and trade Inventory review. Performing RCSA for all projects and processes.

India

Data Quality Analysis & Enterprise Data Management - Corporate action specialized in Fixed Income Securities(e.g. Muni & Corp Bonds, MBS, ABS, TIPS, T-bills )Data vendor management Swift Message feed ISO 15022 & 20022. (Bloomberg, DTC, IDC, Euroclear, TKS, EMC, Custody feeds). Maintain different schemas for different vendors as per client's business needs.Performing Client End-to-end reporting and test Data quality checks to maintain completeness. Data Scrubbing, wrangling and cleaning securities pricing data.Data Error handling to ensure consistency. Run different SQL queries to pull data from different fact and dimension tables to ensure data availability and export in tabular data for analysis in PowerBI or power query.Handle Data Repository creates a golden record that helps Asset servicing & AMC and CITI LOB make decisions and ease data delivery at a low cost.Integrate EMC repository with Data distribution platform for high-speed delivery and maintain production support to end-users. Cost optimization analysis for Data vendors.

Hyderabad, Telangana, India

Data quality assurance of feeds and dealing with brokers and counterparties for payments and settlements of cash and positions. Working on products like Fixed Income securities, Equity, Derivatives, and Collateral. Managing Transactional Databases (Handling reporting requirements) Transforming and Automating business processes to reduce operational risk and help business managers and stakeholders to find root cause analysis of problems.Portfolio analysis – comparison b/w benchmark returns, and portfolio return and provide reporting to Fund Manager. Publishing the NAV of the fund to respective fund Managers & and clients.Automated Fund overdraft process which helps FO to make investment decisions on time.Automated reports per the requirement of different tasks like Pricing updates, Dividend Declaration, Trade position history, past Due income, and Cash projection Management reports to enhance consistency and accuracy of data.The system used – Aladdin, TLM, Eagle STAR, SS&C – FMC ledger, Bloomberg, SAP BI Reporting Tool.

Hyderabad, Telangana, India

Managed new funds deployment and testing, Securities data management, client mapping and Client onboarding. preparing all SOPs and gathering all business requirements to onboard new clients and Multiple Funds.Providing NAV impact analysis on Fund level as per client tolerance due to income adjustments. Validating & Setting up client’s income accruals, amortization, accretions, Tax Accruals and maturities. Perform Mark to Market of Securities & Provide Daily signs off to Fund Managers.Managed inflation adjustments for TIPS using Bloomberg data, automating tasks to save time and reduce the risk of human error.

Pune, Maharashtra, India

Managing reconciliation of cash and positions between multiple custodians and AXA IM (Investment Manager) ledgers and implementing reporting solutions to reduce breaks related to trade settlements, income, and expenses. Enhancing processes by automating tasks and creating procedure documents and SOPs for publication to process owners. Utilizing the Error Handling Tool to manage data discrepancies related to security attributes. Providing weekly and monthly sign-off financial reports to clients by resolving all pending inquiries and issues, including pending income settlements, failed and open trades, and pending counterparty instructions.

Pune, Maharashtra, India

Managed Custodian financial services for State Street and their clients, overseeing on boarding and fund migration.Provided comprehensive services including cash reconciliation, Trade settlement support, Security master maintenance, custody reconciliation (Cash & Position).Managed Inquiry Management Tool database, ensuring 100% accuracy and timeliness in clearing transactions. Performing Through research using custodian reports & BBG.Delivered monthly sign-offs by resolving all issues related to Trade settlement (Open & Failed execution), Fixed income, corporate actions, Offset wires, .Maintained error log reports and implemented Automation control measures to minimize errors & Reduce time to perform repetitive activities using EXCEL VBA.

Master Of Business Administration - Mba, International Finance (Acca Uk)

International finance with ACCA, UK

Executive Post Graduate In Data Science, 3.85 / 4 Cgpa

Data Analytics and Business Intelligence Machine Learning

Master Of Business Administration - Mba, Computer Science, Finance, 7.49 Cgpa

Activities and Societies: ▪ Youth Money Olympiad (Assess financial literacy). 2016, ▪ Workshop on Customer and Business Analytics. 2015, ▪.

Bachelor Of Technology - Btech, Computer Science, 7.49 Cgpa

Activities and Societies: Working as a member of Technical & Analyst Team, At Association of Computer Engineering (ACE), Lovely.