Ashish Kalanauria

I'm Ashish Kalanauria, a versatile professional adept in project management, business analytics, trade derivatives and settlement. With a drive for operational excellence, I've delivered successful projects and process enhancements.

As an Operations Analyst Manager at OSTTRA, I led 35+ projects, ensuring timely delivery and risk management. Bridging business and tech as a Business Analyst, I utilized Python, SQL, Excel, Tableau, and Power BI for solutions, while CRM expertise streamlined processes.

At Markit, I created BI dashboards with Power BI and Excel Reporting, improving efficiency. Committed to community impact, I served as an Academic Rep and contributed to environmental sustainability projects.

Certified in Scrum, ITIL, and Google Analytics, I bring analytical expertise. If you're seeking a adaptable professional to drive success, let's connect.

Operations Analyst Manager • OSTTRA (S&P Global & CME Group JV)

July 2014 – August 2022 

• Developed project plan, including scope, timelines, budgets, and resource allocation, ensuring alignment with organizational goals and client requirements.
• Monitored project progress, identified risks and issues, and implemented proactive measures to mitigate them.
• Managed and closed 35+ projects as a Project Manager, developing project plans and reporting project status.
• Onboarded 20+ clients, serving as a trusted partner and resolving implementation issues.
• Collaborated with cross-functional teams, including stakeholders, clients, and vendors, to ensure effective communication and timely project delivery.
• Conducted regular status meetings, prepared project reports, and delivered presentations to senior management, providing transparency, and fostering alignment.
• Working closely with Prime Brokers, Custodians and Administrators to reconcile cash, positions, static data across a broad product range to ensure the funds have accurate positions and cash for their NAV production. Also, Confirmation and settlement of various securities.
• Bridged the gap between the development team and business users as a Business Analyst, analyzing business needs and translating them into technical requirements.
• Took on management responsibilities, including leading a small team and overseeing their performance, setting goals and recommended development plans.
• Improved process efficiency through gap analysis, documentation updates, and automation using Excel macros, resulting in significant time savings. I have saved around 1 FTE time by enhancing over 8 processes. 
• Worked towards the future vision for the IT environment, recommending improvements and advancements.
• Demonstrated technical expertise in SQL, Python, Excel.
• Coordinating, and executing large industry events on OTC traded Derivatives in Markit Wire & MTM platform for clients (like IBOR, SOFR) and financial regulations updates on trades (MIFID, Dodd Frank, SFTR, etc.;)
• Work with clients to perform post trade events like:
  • Compression events
  • Novation’s, Portfolio transfer, LE-Amendments
  • Corporate Actions
  • Transaction Processing
  • Confirmation
  • Settlement and Clearing

MIS Senior Associate • Markit (now S&P Global)

September 2009 – July 2014

• Developed daily, weekly, periodic, and annual BI dashboards and MIS reports for senior management, incorporating data from Salesforce and SAP Finance.
• Created KRI and KPI reports by collaborating with various teams.
• Developed and maintained Macros to increase efficiency and reduce manual effort and errors.
• Demonstrated technical expertise in Power Bi, Excel Reporting and Presentation creation.
• Providing decisive leadership, directing the team, and implementing performance enhancement strategies to elevate their effectiveness and deliver exceptional results.
• Ensuring thorough documentation and constant review of reporting processes and procedures to align with changing business and customer requirements.

Reference Data Associate • Seagal Financial Securities (now S&P Global) 

May 2006 – September 2009

• Researched and documented new bond issuances.
• Coordinated with investor relations to document debt movements under corporate actions.
• Tracked, documented, and reported on Structured Finance transactions (ABS/RMBS).
• Captured and reported monthly cash flows of Asset-Backed Securities and Residential Mortgage-Backed Securities.

MSc. Business Analytics 2022-2023 

University of Exeter, United Kingdom

Modules:

Topics in Business Analytics, Programming for Business Analytics (python and R), Statistics and Mathematics for Business Analytics, Database Technologies for Business Analytics, Analytics and Visualization for Managers and Consultants, Marketing Analytics, Design Intelligence, Strategic and HR Analytics, Operations Analytics

Post-Graduate Diploma in Business Management (PGDBM) 2003-2005

EMPI Business School, New Delhi, India

Bachelor of Computer Application (BCA) 2000-2003

Nagarjuna University, Andhra Loyola College, Vijayawada, India