Experience

• 

  L&t infotech

  Apr 2010 - Nov 2021

  Senior software engineer

  Projects:• Sharepoint 2010 1. Central Admin – Creating Web Applcations, Site Collections, Search configuration, Web Analytics2. Creating custom web part, workflow, event receivers3. SharePoint Designer – creating custom workflow, Data View Webpart4. Configuring Security5. Using javascript for custom forms – New form, Edit form, Display form6. Lotus Notes to SharePoint Migration7. Running Powershell scripts• MS Access/MS Excel – VBA 1. Creating and designing forms, tables, queries2. Backend Coding using VBA (MS Access) Show less

• 

  Marsh mclennan

  Apr 2014 - Oct 2021

  Project: Elite and Metastorm (April 2014 – October 2021) Technical Support Tier 3 and Production Support Risk Consulting group in Marsh US, that sells services to assist clients in evaluating and mitigating risks, uses these two tools. In Metastorm, Projects are created for a client with the details like client details, consulting hours, exceptions etc. Billers review these projects and once they approve a project, data goes to Elite. Elite has two parts - Webview and Enterprise. Webview is time entry site where consultants (technically called timekeepers) enter time. Enterprise is used for maintaining timekeepers, budget, exchange rates etc. and generating different kinds of reports. Responsibilities: Providing technical support to global user base, working with vendor (Elite - Thomson Reuters Corp., Metastorm - Hyperion) to resolve any issue if needed Coordinate & work closely with Business/Operations, Enterprise architect team & Support Team for executing new enhancements & implementing new solutions Responsible for all production defects/monitoring & support, incident management, problem management for existing Web/Windows/Window Service/Schedule/Batch applications Enhancement of Metastorm functionalities like changing workflows and forms Gathering requirements from business Creating Requirement document and getting sign off from business Designing using Metastorm Designer Creating tables, columns in SQL database Coding with JavaScript Unit testing UAT defect fix Deploying in Production with help of different teams (Database team, Application Engineering team) Backend support – maintaining tables, views (MS SQL Server 2014) Successfully upgraded backend servers from Win 2008 to Win 2010 servers Environment: JavaScript, Elite Enterprise, Metastorm Designer, SQL Server 2014 Show less Project: Invoice Request and Central Intake Tool (April 2015 – October 2021) Technical team lead This tool has two parts - Invoice Request Tool (IRT) and Central Intake Tool (CIT). IRT is used by insurance brokers to enter Client details, policies, coverages, insurers, risk allocations, amounts, revenue sharing and other details in one consolidated item which is called a worksheet. After entering the details, brokers submit the worksheet to Client Support Team (CSS). The CSS team uses CIT. CSS admins assign the submitted worksheets to the CSS team members. CSS team members then enter the worksheet details to the invoicing system, called Cansys, to generate the actual invoice. This tool is on MS Access frontend (uses Visual Basic for Applications code) and MS SQL backend. Users access this tool via Citrix. Responsibilities: Involved in development of the application user interface and designing data structure Involved in Requirements analysis, Low Level Design, Coding and Integration Involved in Coding, Review of Programs, Unit test plan preparation, Testing & Test Review Analyze business application usability to suggest improvements for effective utilization and involved in implementation to automate through RPA Providing technical support to the large user base (700+) Working with BA to understand enhancements Working with offshore developers and QA to deliver enhancements and upgrades in a timely manner Working with different teams like Database team, Citrix team for deployments Successfully upgraded backend from MS Access to MS SQL to enhance performance and support large user base Got multiple client appreciation for improving Ops performance by Optimization and Automation. Environment: MS Access VBA, SQL Server 2016, Oracle Database 12c Enterprise Edition Show less

  • Production Support and Lead Technical Specialist

    Apr 2014 - Oct 2021

  • Technical Team Lead

    Apr 2014 - Oct 2021
• 

  Scotiabank

  Nov 2021 - now

  Technical team lead

  Customer Information Systems Support Lead:Customer Information Systems in BNS handles the bank's customer profile, demographic data, customer to account relationships and other customer data for bank customers. It has a front end that allows customer onboarding and customer maintenance. The back end consists of two systems – mainframe DB and relational DB (DB2). Mid-tier between both systems is an iway application that syncs the data between two backend systems. - Analyzing the issues raised through Service Now tickets and assigning to proper team members - Making sure OLA and SLA are met for each ticket - Working with different teams in case further information or investigation is required - Updating Application profiles (EPM) for the CIS applications - Working on Major incidents to find the root cause using Dynatrace, AQA logs - Server patching support for lower environments and productionTechnical Navigator:- Analyzing requirements and working with the BA to create JIRA stories - Creating and maintaining releases, features and changes in Service Now as needed for the standard/expedited/emergency releases - Working with Dev team to deploy codes in Dev, QAT, NFT and PROD environment using ACCP pipeline - Actively working with QA team to make sure all defects are closed in a timely manner - Working with release management to release in Production in proper maintenance window - Arrange for the health checks after the prod release Show less