Nirali P. Email and Phone Number

• Enhance the profitability and quality of the Credit Risk Portfolio by performing Credit Administration tasks, including Financial Spreading and Analysis, Risk Grading (Bloomberg) Reports, and monitoring systems• Deliver Tier-2 technical assistance to users of Credit360 and CreditLens by addressing queries regarding navigation, policies, procedures, and application-related issues• Contribute to development initiatives by investigating a modern .NET-based platform, identifying and rectifying errors, and implementing server updates, with the main objective of enhancing security, stability, and performance• Function as the escalation liaison for the run-the-bank support team, responsible for managing and resolving production issues and incidents, while implementing a rotating on-call schedule among team members• Engage in support for Mission-Critical Server systems and act as Primary Infrastructure Support resource for CreditLens web & SQL servers, coordinating production build deployments and infrastructure support team for BR/ DR strategies

• Coordinated with the Architecture team to set up Azure Active Directory for client roles, permissions, and policies, utilizing features like conditional and role-based access control for secure authentication• Led the successful integration of Salesforce with Camis software, resulting in a 25% improvement in data visibility and a 20% enhancement in data accuracy through an agile methodology.• Integrated advanced SQL into camping reservation software to enhance performance monitoring, forecasting, real-time data access, scalability, improved decision-making, and User Access Management.• Performed a Root Cause Analysis to identify payment gateway failures by implementing features to detect suspicious patterns, ensure AML (Anti-Money Laundering) compliance, and enhance transaction security. This integration led to a 60% reduction in refund processing time and improved operational efficiency• Leveraged expertise in System Analysis, Feature Recommendations, Data Protection Regulations, Testing and Quality Assurance, and Payment Integration to significantly enhance the successful development, implementation, and ongoing maintenance of camping reservation software• Partnered with the Scrum Master and define Acceptance Criteria within the Agile framework using RALLY

• Managed updates and maintenance of the Master Data Sheet (MDS) and Source Information (LOBs) Book of Records in the EDGO platform• Responsible for advanced SQL database development, including stored procedures, database design, and data modeling for aggregation and summarization.• Established and executed procedures and reporting mechanisms for the 1B governance program, covering Operational Risk, Regulatory Compliance Risk, Model Risk, and Change and Delivery Risk• Collaborated with the risk management team to improve data accuracy and regulatory compliance, while analyzing transaction data to identify trends, resulting in a 20% reduction in processing times through optimized workflows• Proficient in dimensional, relational, Data Vault 2.0 modeling, and physical data model implementation.• Developed Financial Models in Excel, participated in regular model evaluations of fluctuations in credit risk models, and supported the FinOps team in transitioning the data feed frequency from monthly to daily• Leveraged Active Directory to enhance security, optimize data workflows, and ensure regulatory compliance

• Utilized a range of Asset-Liability Management (ALM) strategies to effectively address liquidity risk, evaluate monthly discrepancies in revenue/cost forecasts. and fulfill short-term obligations• Engaged in the Agile approach for integration of vendor packages, relational databases, message queues, and legacy systems• Developed XML data transformation guidelines to integrate data from legacy systems and external applications• An ETL workflow was established to integrate Anti-Money Laundering (AML) processes during data migration and improve AML strategies for post-migration activities.• Proficient in managing multi-state, multi-line accounts throughout the entire policy life cycle, including tasks like rating and pricing, quoting, issuing policies, and overseeing related account activities• Conducted data mapping and transformation activities to ensure a smooth migration of data from company’s legacy system to Guidewire's insurance platform by performing a comprehensive evaluation of Policy Management, Claims Processing, and Underwriting Operations

• Designed and developed a RESTful API using Node.js and Express, integrated with a MySQL database, resulting in a 30% increase in data processing speed and a 25% reduction in API response time• Implemented lazy loading and server-side rendering for faster load times, utilized Jenkins for CI/CD, and employed SonarQube, and WebInspect for code quality• Contributed to a Python web application for data aggregation, improving dataset processing and user interaction, while also participating in open-source projects to strengthen professional connections in the Python community• Employed GIT for Source Code Management and proficient in Maven and Gradle for automating the build process

• Contributed to the design and execution of innovative software functionalities utilizing JAVA, J2EE, HTML, and XML• Proficient and up to date in Spring, myBatis, Bootstrap, jQuery, and AODA compliance standards• Possessed practical experience in n-tier web application development with Oracle database serving as the backend