Piyush Bhandari Email and Phone Number

Current Responsibilities-• Performance Management: Set performance goals, conducted reviews, provided feedback, identified training needs, and facilitated professional development.• Project Management: Delivered projects on time and within budget, optimizing resource use to enhance efficiency.• Cross-functional Collaboration: Aligned goals and strategies, and built and maintained key stakeholder relationships.• Conflict Resolution: Effectively resolved both internal and external conflicts.• Process Improvement: Reduced time to market for new issuances in fixed income.• Data Analysis and Quality Assurance: Ensured adherence to high-quality standards and best practices.• Innovation and Change Management: Fostered a culture of innovation and led change initiatives for continuous improvement.• KPIs and Metrics: Achieved measurable results and received client awards.

Responsibilities handled-• Team management including people from India and Dallas(US) responsible for managing daily NI issuances in the fixed-income market.• Managing Global issuances in real-time and reducing reference data time to market gap.• Conducting successful client trials and their onboardings.

Responsibilities handled-• Quality control and data accuracy checks for the whole team using queries on various platforms like SQL and Jupyter notebook using Python.• New Joiners Trainings and onboarding starting from day zero.• Onboarding new clients typically for New Issuances and delivering the timely reference data to new/old clients as per their SOIs or AOIs.

Responsibilities handled-• Advised and worked closely with our Bond Valuation, Pricing, and Portfolio Valuations teams to provide the highest level of data quality to clients.• Tools used: Semantic Extract, Kofax Kapow, Golden6 (SQL), PAPP, VBA Script, and PyCharm (Python) to provide the highest level of effectiveness and efficiency.

Responsibilities handled-• Vendor Feed mapping participation for different sources from EDM to Amazon Web Services (AWS) using a series of logical mappings, QA testing, and Athena.• Quality Checks on Newly added securities using quality tools and SQL queries.• Managing dashboards and various data analyses for team and clients using spreadsheets and other analytics tools like Power BI.• Maintenance and improvements on previously developed automation tools.• Feed analysis and mapping of the unmapped universe.

Responsibilities handled-• Operational maintenance of Data product. Ranging from setting up new securities issued in the market, enhancing the quality of content using a prospectus or credit agreement, and managing corporate actions. • Corporate administration by Capturing corporate action events at instrument level (includes Call event, put event, Exchange offer, Mergers, and Acquisitions, Bankruptcy, etc) and using different sources like Euroclear, WM Gruppe, FACTSET, Perfect Information and Exchange Data International for capturing financial data• Working on automation of process which includes preparing documents that contain mappings and requirements, testing the results on QA, providing clearance, and deploying the same on production.• Promptly updating upcoming auctions for treasury securities with the help of an auction calendar.• Working with different teams on product development, defining new procedures, systems and proactively participated in automating the same. • Maintaining and providing static and dynamic Fixed Income Securities reference data to Index operations & Pricing team that is used for creating Fixed Income benchmark & custom indices, re-balancing of Fixed Income Index and independent pricing of Fixed Income instruments respectively.• Indulging in different process enhancement projects, resulting in better output in terms of time consumption, quality, and accuracy.

Responsibilities handled-• Suggesting User Interface enhancements to management based on client requirements and taking care of data dictionary at regular intervals.• Proficient handling of client queries and client escalations by using CRM tools like DCS.• Client onboarding via FTP and API.• Data maintenance and sample file coverage.

Responsibilities handled-• Financial Reporting of US Municipal Bond Market Financials into Client’s Terminal.• Providing world-class facilities to the end-users in terms of Transparency, Accuracy, and Quality.• Publish financial data on client terminal for further analysis.• Preparing & processing the financial information consisting of Cash Flow Statement, Income Statement & Balance Sheet using US GAAPs from the given accounting records of US Municipal Bonds issued by the States, Cities, Counties and Local Authorities of USA.• Doing desirable Ratio Analysis & Variance Analysis based on vital financial information.• Interacting with clients on process updates, bottlenecks, and providing solutions.• Analyzing key statistical, demographic, and economic information of Municipal bonds issuers namely city, county and states to ascertain their soundness.• Analysis of various pension plans being administered by the issuer & other pension authorities.• Quality checking of production and correct the errors if any.• Responsible for Training and mentoring new joiners along with Quality checks.

• Understanding the real estate accounting process and organizational structure.• Making projects and reports on the ongoing projects and discussion on their future projects.• Reconciliation of real estate accounts and reporting any mismatch found.