Abhishek Nirwani
Summary
Accomplished IT Support and Application Specialist with 12+ years of experience across capital markets, pension funds, finance, and healthcare sectors. Skilled in delivering seamless application functionality, resolving complex issues, and maintaining system integrity. Expertise in Power BI, SQL, Snowflake, ETL processes, Agile methodologies, and cloud-based SaaS applications. Strong background in bridging technical and business teams, improving processes, and enhancing user satisfaction through reliable support and innovative solutions.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Ontario Teachers’ Pension Plan (OTPP)
Senior Application Support Analyst – Compliance Module
01.2024 - Current
- Provided end-to-end support for in-house and cloud-based Compliance applications, including FundApps, Consensys, and MyComplianceOffice, along with their integrations with upstream data providers.
- Supported cloud migration of in-house Compliance applications, ensuring seamless transitions with minimal disruption to business operations.
- Managed and monitored UC4 automated jobs for data loading and report generation, ensuring accurate functioning of compliance applications and reports.
- Troubleshot and resolved issues in applications, reports, and underlying data, maintaining data integrity and supporting regulatory audits.
- Monitored trading reports and collaborated directly with business users to ensure adherence to regulatory requirements and company compliance policies, efficiently resolving queries and issues.
- Utilized ServiceNow for ITSM, incident tracking, and change management; Confluence for documentation and knowledge management; and Kibana for log investigation and advanced troubleshooting.
Ontario Teachers’ Pension Plan (OTPP)
Lead Application Support – Finance and Supply Management
01.2022 - 01.2024
- Provided end-to-end support for Infor FSM (Finance & Supply Management) and other corporate applications, including Cloudgate, Anaplan, iManage, Workday, and Condeco, ensuring seamless operations and user support.
- Managed data integration using Snowflake for upstream and downstream systems, ensuring accurate reporting and data consistency.
- Supported and monitored workflows and automated jobs using Globalscape and UC4, ensuring smooth data transfers and report generation.
- Troubleshot and resolved application, report, and data issues, maintaining data integrity and system reliability. Utilized ServiceNow for ITSM.
- Maintained dashboards, automated reports, and analytics to support finance, compliance, and operational decision-making.
Ontario Teachers’ Pension Plan (OTPP)
Onsite Lead – EDW, Performance Systems
05.2019 - 12.2021
- Provided technical support for all ETL systems within the Enterprise Data Warehouse (EDW) module, ensuring seamless operations and reliable data availability.
- Worked with data providers such as Bloomberg, S&P, J.P. Morgan, and Thomson Reuters, loading and integrating data into the EDW using Markit EDM.
- Utilized SQL Server, Oracle, and Markit EDM to manage data integration, transformation, and delivery for downstream subscribers.
- Coordinated with offshore teams to resolve incidents within SLAs and implement application enhancements on schedule.
- Collaborated with vendors, business users, and stakeholders to troubleshoot issues, optimize workflows, and maintain system integrity across all platforms.
Ontario Teachers’ Pension Plan (OTPP)
Data Integration Specialist – EDW Module
01.2017 - 01.2019
- Provided technical support for all ETL systems within the Enterprise Data Warehouse (EDW) module, ensuring seamless operations and reliable data availability.
- Managed data integration, transformation, and delivery for downstream subscribers using SQL Server, Oracle, and Markit EDM.
- Coordinated with the onsite lead to resolve incidents within SLAs and implement application enhancements on schedule.
- Performed data validation and reconciliation to ensure accurate and consistent data across systems.
- Monitored ETL and reporting performance, proactively identifying and addressing bottlenecks or failures to maintain system reliability.
AmerisourceBergen
Application Support Analyst – Lash Group Project
01.2015 - 01.2016
- Provided application support for insurance processing systems, covering primary, secondary, and tertiary claims.
- Collaborated with business analysts for requirement gathering, participated in Scrum calls for project status, and conducted retrospectives to discuss and address issues from previous sprints.
- Worked on enhancement requests for VB.NET and C# applications, implementing updates to improve system functionality and user experience.
AmerisourceBergen Corporation
Application Support Analyst – Patient Assistance Program
01.2013 - 01.2015
- Provided support for prescription and order-related communications for physicians, patients, and healthcare providers.
- Utilized OpenText StreamServe and Visual Basic (VB.NET) to generate and deliver time-sensitive correspondence.
- Ensured compliance with HIPAA and internal healthcare regulations, maintaining data privacy and security.
- Collaborated with cross-functional teams to quickly resolve escalated service requests and maintain operational efficiency.
Education
Bachelor of Engineering -
Institute of Engineering And Science, IPS Academy
India09-2012
Skills
Application & Cloud Platforms: Expert in supporting a wide range of cloud-based platforms, including Infor FSM, Consensys, FundApps, MyComplianceOffice, Anaplan, iManage, Workday, Condeco, and other in-house applications
Database & Reporting Tools: Proficient with SQL Server, Oracle, Power BI, and SSRS for comprehensive data analysis and reporting
ETL Tools: Skilled in troubleshooting issues using ETL tools such as SSIS, Markit EDM, and Snowflake for data transformation and migration
IT Service Management (ITSM) Tools: Experienced in utilizing ServiceNow for incident, problem, and change management
DevOps & Automation Tools: Hands-on experience with GitHub, Jenkins, UrbanCode, UC4, Red Hat, and Jira for DevOps and process automation
Monitoring & Troubleshooting Tools: Proficient in using Kibana for log monitoring and advanced troubleshooting
SLA-driven Support: Skilled in Incident and Problem Management with a strong focus on achieving and exceeding Service Level Agreements
Troubleshooting & Root Cause Analysis: Highly capable in advanced troubleshooting, root cause analysis (RCA), and software debugging
Client Management: Adept at stakeholder management and providing direct client support
Collaboration & Documentation: Experienced in leveraging Confluence and SharePoint for project documentation and knowledge management
Certification
- Microsoft AI-102: Designing and Implementing a Microsoft Azure AI Solution (67894)
- ITIL 2011 Foundation: Certificate in IT Service Management
- Microsoft Azure Fundamentals (AZ-900)
- ITIL Foundation Certification (Process)
- Generative AI Foundation Curriculum (Technology)
- Environment Health & Safety Foundation (BPS)
- Foundation Certificate in Capital Markets (BDA)
- PM Integrated Quality Management System (iQMS)
Timeline
Ontario Teachers’ Pension Plan (OTPP)
Senior Application Support Analyst – Compliance Module
01.2024 - Current
Ontario Teachers’ Pension Plan (OTPP)
Lead Application Support – Finance and Supply Management
01.2022 - 01.2024
Ontario Teachers’ Pension Plan (OTPP)
Onsite Lead – EDW, Performance Systems
05.2019 - 12.2021
Ontario Teachers’ Pension Plan (OTPP)
Data Integration Specialist – EDW Module
01.2017 - 01.2019
AmerisourceBergen
Application Support Analyst – Lash Group Project
01.2015 - 01.2016
AmerisourceBergen Corporation
Application Support Analyst – Patient Assistance Program
01.2013 - 01.2015
Bachelor of Engineering -
Institute of Engineering And Science, IPS Academy
Personal Details
Name: Abhishek Nirwani
Location: Address: Brampton, ON, Canada
Phone Number: +1 437-994-4479
Email: abhishek.nirwani210@gmail.com
Work Status: Permanent Resident of Canada
LinkedIn: www.linkedin.com/in/abhishek-nirwani
Similar Profiles
RIYA GERARIYA GERA
Accenture Solutions Private Limited at Application Development Senior AnalystAccenture Solutions Private Limited at Application Development Senior Analyst
Kousic MKousic M
Mainframe Developer and Prompt Engineer at Application Development Senior AnalystMainframe Developer and Prompt Engineer at Application Development Senior Analyst
Nikhil Bhagwan BorgeNikhil Bhagwan Borge
(Acting Team Coach) at NIUM - Senior Analyst Compliance Operations(Acting Team Coach) at NIUM - Senior Analyst Compliance Operations
Desmond Mukavi KiokoDesmond Mukavi Kioko
Engineer - Operations Systems Support at SafaricomPLCEngineer - Operations Systems Support at SafaricomPLC
Michael LowensteinMichael Lowenstein
Senior Software Engineer at FullStack LabsSenior Software Engineer at FullStack Labs