Swapnil Yashwant Shinde

Project: OneFin Application – LOS/LMS/Collections

Domain: Retail Asset Banking
Technologies: PostgreSQL, AWS

Key Responsibilities:

• Worked on OneFin, a comprehensive digital lending platform, focusing on integration with new partners for digital loan origination and servicing.
• Currently involved in the Marketplace Personal Loan (PL) integration project with OneFin, enabling seamless onboarding of third-party loan partners.
• Leading a team of 2 members, assigning daily integration tasks, maintaining project checklists, and providing daily status updates to the business team.
• Supporting internal audit processes by ensuring compliance and documentation for all application changes and integrations.
• Managing Production and UAT support (TSE III level), collaborating with development teams to resolve issues, perform root cause analysis, and ensure timely bug fixes.
• Tracking and resolving UAT defects, handling Jira tickets, and addressing production incidents while adhering to SLA/TAT.
• Maintaining close coordination with cross-functional stakeholders for new feature rollouts, partner onboarding, and integration testing.

Current Projects:

• LDAP Integration with OneFin for centralized authentication and user management.
• Dynatrace Integration for advanced monitoring and application performance management.
• Partner Integrations: Ongoing integrations with Marketplace PL and Mobikwik BL to expand digital lending reach.

Project: OneFin Application – LOS/LMS/Collections & AUTOVERT (Lead Generation Tool)

Domain: Retail Asset Banking | Technologies: PostgreSQL, AWS

Key Responsibilities:

• Worked on OneFin, a comprehensive Loan Origination System (LOS), Loan Management System (LMS), and Collections platform, along with AUTOVERT, a lead generation module tailored for loan products like EV2W, EV3W, and RTS.
• Led a team of 4 members, assigning daily tasks, monitoring progress, and ensuring timely delivery of responsibilities.
• Collaborated with cross-functional teams throughout the Software Development Life Cycle (SDLC), including requirement analysis, development support, testing, debugging, and deployment.
• Engaged with the internal audit team to support application audits and ensure regulatory compliance.
• Managed production support activities (TSE III level), coordinating with development teams to resolve application-level issues.
• Monitored and tracked UAT activities, new requirements, Jira tickets, and production issues to ensure smooth operations and timely resolution.
• Maintained and optimized PostgreSQL databases, performing CRUD operations, writing complex and efficient SQL queries, creating stored procedures, indexing, and maintaining data integrity.
• Assessed moderately complex issues and identified opportunities for process improvements in operational workflows, tools, and procedures.

Project: Novopay Solution (LOS/LMS/Collections)

Domain: Retail Asset Banking
Technologies: Unix, Linux, Oracle 10g, SQL Server, WebLogic, PL/SQL

Key Responsibilities:

• Worked on Novopay Solution—a comprehensive LOS, LMS, and Collections platform—supporting customized loan products such as JLGBC, IBL, etc.
• Ensured high availability of digital applications for both end-user customers and internal bank users.
• Spearheaded the setup of a new Disaster Recovery (DR) environment for the lending application (Micro-ATM) to comply with regulatory mandates.
• Led Business-as-Usual (BAU) activities and mentored a team of 10 professionals.
• Collaborated with internal audit teams to support application audits and ensure compliance.
• Managed UAT and production support (TSE III level); coordinated with developers to resolve technical issues.
• Tracked and managed new requirements, UAT activities, Jira tickets, and production issues.
• Provided support in resolving UAT testing workflow challenges and external interface-related issues.
• Addressed escalations by delivering timely and effective resolutions.
• Ensured timely closure of production issues via BMC ticketing system, adhering to bank-defined TAT.
• Handled daily production activities including data patches, server health checks, monitoring, and end-of-day (EOD) processes.
• Acted as liaison between Development, Product, and Delivery teams for bug fixes and production deployments.
• Assisted end users and customer agents by troubleshooting and resolving application-related technical issues.
• Performed root cause analysis (RCA) for reported issues and created JIRA bugs when required.
• Authored documentation for complex procedures and system/network troubleshooting guides.
• Operated in a cross-functional environment, conducting technical analysis and requirement evaluations.
• Ensured regular KPI reporting and effective trending of non-compliances and deviations.
• Managed application maintenance including operational support, problem resolution, and enhancement implementation.
• Recommended system modifications to reduce recurring user/system/database issues.
• Participated in the review and development of business and system requirements to align technical solutions with business needs.
• Evaluated and contributed to improvements in processes, procedures, and tools for efficiency and reliability.

Project Highlight:

• Successfully completed the first-attempt DR Drill activity for the application under senior guidance, ensuring full compliance with regulatory expectations.

Major Projects Project: Loan Management System (LMS) – Finnone / Loan Assist (Mobile App)

Domain: Retail Asset Banking
Technologies: Unix, Linux, Oracle 10g, SQL Server, WebLogic, PL/SQL

Responsibilities:

• Interacted with the Business Technology Group (BTG) to gather and analyze enhancement requirements, identifying necessary infrastructure changes (e.g., port openings, new setup creation, directory/space creation, database restoration, and load test parameter validation).
• Deployed releases in the UAT environment and performed initial sanity testing; collaborated with the QA team for performance/load testing when applicable.
• Documented SIT results, including process steps and screenshots, in the Change ID system.
• Managed the release lifecycle from SIT sign-off to UAT handover; provided ongoing support to BTG during UAT and moved the release to production after final approval.
• Monitored post-production performance and stability for a minimum of 7 days to ensure successful deployment.
• Developed and optimized SQL queries in SQL Server to extract monthly performance metrics from the LOANAPP system; shared insights with business stakeholders.

Key Enhancements:

• LMS Enhancements:
  Implemented Ex-Gratia Payment feature as mandated by the Government of India.
  Integrated RBI Loan Restructuring scheme in LMS workflow.
• Mobile App Enhancements:
  Introduced Video KYC, Digital Application Form, and 10-Second Loan Journey to enhance the digital onboarding experience.

Project Domain Technologies

Key Responsibilities:

• Coordinated with vendors to address open issues, discussed timelines for releases, and escalated concerns to Application Owners and IT teams.
• Managed and acknowledged issue tickets raised in BMC (IDFC’s bug tracking tool).
• Analyzed user-reported issues and gathered system enhancement requirements; assigned tasks to internal team members accordingly.
• Provided complete documentation, screenshots, and replication steps of issues to vendors for resolution, using UAT environments for validation.
• Responded to production and UAT server alerts related to storage and backup.
• Monitored and cleared export logs, .dmp, and .gz files upon reaching file system thresholds.
• Archived and cleaned up old logs/files older than one month to maintain system efficiency.
• Performed regular database and transaction log backups to ensure data integrity and disaster recovery readiness.
• Raised and tracked tickets and change requests using Mantis (bug tracking and change management tool).
• Tested vendor releases in UAT, coordinated business approval, and deployed to production upon successful validation.
• Added, modified, and maintained Cron jobs based on scheduling and operational needs.
• Customized the Mantis application based on project-specific requirements to improve issue tracking workflows.
• Developed and executed SQL queries to extract reports, delivering accurate MIS data to the operations team.

Project

Technologies: WebLogic, PL/SQL, Linux, SQL, UNIX, WinCP 3.7, Putty
Client: IDFC Bank

Key Responsibilities:

• Monitored the smooth functioning of INDUS applications and related interfaces such as MDM, BEURO (CIBIL), CBS, and ESB; coordinated with respective teams to troubleshoot and resolve interface-related issues.
• Conducted root cause analysis for recurring issues and collaborated with vendors to implement permanent solutions.
• Processed settlement files received from CBS (Core Banking System by TCS) for loan collections.
• Raised change requests and issue tickets in BMC Tracker for system enhancements and permanent fixes.
• Handled patch management: received patches from vendors, deployed them in UAT and pre-production environments, and moved them to production post-testing and business approval.
• Generated NACH (National Automated Clearing House) files through the frontend application for automated collections.
• Performed reconciliation of loan data in the LMS (Loan Management System) to ensure accuracy and completeness.
• Maintained continuous connectivity and data flow between INDUS applications and external interfaces.
• Conducted end-to-end application testing in UAT for various loan products including Home Loans, Personal Loans, and Loans Against Property (LAP).
• Drafted monthly operational and performance reports using custom SQL queries.

Project

Client: AXIS Bank
Technologies: Oracle Database 10g, Linux, SQL, UNIX, Visual Basic, WinASP 3.7, PuTTY, HTML, CSS

Key Responsibilities:

• Monitored transactions and system logs to ensure system performance and stability, analyzing technical issues affecting live transactions.
• Processed settlement files from the Reconciliation Department for various agents including AXIS, VISA, VIGL VISA, NFUT, and EURO.
• Handled patch deployments in both production and testing environments.
• Administered the CMS (Card Management System) application; managed card generation, ATM/WEB/IVR PIN processing, and emboss file generation.
• Ensured uninterrupted connectivity between the (Narada) Switch and client systems.
• Conducted post-implementation testing on the test server (UAT) prior to production deployment.
• Trained new team members on system processes, provided guidance, and helped resolve technical issues.
• Performed transaction testing in UAT across various technologies.
• Maintained high-quality standards in operational activities, consistently exceeding client expectations.
• Wrote SQL queries based on branch-specific requirements.
• Coordinated with internal departments including Development, Help Desk, and Reconciliation teams.
• Proposed system enhancements to improve usability and efficiency.
• Addressed branch queries, including top-up requests and End-of-Day (EOD) processes.
• Communicated with clients via email regarding escalations, and provided necessary system data and support.