Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic
Amit Bhan

Amit Bhan

Oshawa,ON

Summary

  • About 15 years of progressive IT experience as a C#.NET, ASP.NET MVC, Dot Net Core, JAVASCRIPT, jQuery, WEB API, Angular JS, MS Azure, MS SQL, DB2
  • Certified Scrum Master (CSM) - Well-versed with Scrum Framework.
  • Senior Consultant in the Insurance domain with strong functional knowledge of the Mortgage and Retirement plan Business.
  • Rich experience in end-to-end SDLC for niche customers like Manulife/John Hancock.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Senior Consultant

Eviden
Toronto, ON
10.2019 - Current
  • Applications -RPS Business Tools Website
  • RPS Business tool is an Azure website holding a migrated version of core business applications like Core Fund Tool, Rate of Returns, New York Agency, and SignerCheck
  • Domain: Insurance Role - Technical Lead Location - Manulife, 250 Bloor Street East, Toronto Environment - C#, ASP .Net Core MVC, Azure, CSS, Angular, HTML, jQuery, JavaScript, Microsoft SQL, Informatica ETL, ServiceNow, JIRA, Microsoft SharePoint, CAWA Scheduling tool, MS Office, SVN, Role & responsibility:
  • Working in a Managed Service project to handle multiple RPS (Retirement Plan Services) applications - Core Fund Tool, Rate of Returns, New York Agency, and Signer-Check
  • New York Agency - This application is a DB2 database and batch to process all data pertaining to unit values of all JHRPS mutual funds
  • Applications consuming Lawson, NSCC and NYASchedule feeds may depend on NYAgency as these feeds are generated at each payment processing
  • SignerCheck- is a user-friendly intranet repository for specimen signatures that was live in John Hancock's cloud on Monday, April 10th, 2017
  • SignerCheck is used to validate the approval of our signed forms and written requests
  • All users of the Lotus Notes Signator Database who view, add, or edit signature specimens will be required to access the new site
  • ROR is the Fund Performance calculator
  • On a monthly basis, the application takes data from the Unit Value tables and populates an MS Access table for history
  • The monthly unit values are then calculated to determine the Funds' performance
  • The Core Fund Tool Back-End is an application that is to be used by Investment Marketing to generate data files to be used by the Core Fund Tool front-end Internet application
  • This front-end application is used by Brokers on the Broker-Dealer Website as a tool to assist them in selecting which Manulife Funds to offer their clients
  • Owned all the Non-discretionary work requests, enhancements subjected to RPS (Retirement Plan Services applications.

Consultant, Investment Division, Global Wealth and Asset Management

Eviden
Toronto, ON
08.2011 - 09.2019
  • Applications - Enterprise! LMS - Loan Management System, MVAL- Mortgage Fund Valuation, Mortgage Reporting Repository and FileOnQ Domain: Insurance Role - Technical Lead Location - Manulife, 250 Bloor Street East, Toronto Environment - C#, ASP .Net Core MVC, Azure, CSS, Angular, HTML, jQuery, JavaScript, Microsoft SQL, Microsoft SSRS, Informatica ETL, ServiceNow, JIRA, PPM, CAWA Scheduling tool, MS Office, VBA, Git hub, VB.NET Role & responsibility:
  • Worked in a Managed Service project to handle multiple Manulife's Mortgage applications - Enterprise! LMS Application, Mortgage Fund Valuation, Mortgage Reporting Repository, and FileOnQ
  • As a Business Systems analyst, I designed and implemented many key existing and new reports for Enterprise! LMS application in SQL and SSRS technology
  • Owned all the discretionary work requests, enhancements subjected to Mortgage applications
  • Well-versed in business data modeling techniques and data presentation using UML 2.0 diagrams
  • Extensive day-to-day experience in Data analysis, extraction for the backend SQL database for Enterprise! LMS application
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Adept at queries, report writing, and presenting findings
  • Interpret data, analyze results using statistical techniques and provide ongoing reports
  • Technical expertise regarding data models, database design development, and data mining techniques
  • Ability to do data analytics and other strategies that optimize statistical efficiency and quality
  • In conjunction with Business analysis, I'm involved in production support activities wherein I support Mortgage Business users for day to day activities and daily nightly batch cycle playing a key role in sending out notifications on high priority issues to the Manulife business groups, involving relevant IT teams to resolve issues and tracking defects
  • Extensive day-to-day usage of SQL, VB Macros, ServiceNow, SharePoint, CAWA Scheduling tool, Informatica, JIRA, XML, and MS Office
  • Conducted project review sessions, obtain sign-offs, Gap analysis, and coordinated acceptance tests to ensure timely delivery of requirements
  • Automated Daily Valuation Process of Mortgage Fund Valuation (MVAL) system a few years back to send daily Valuation files to RBC and scheduling it thus reducing the scope for manual effort
  • Extensive knowledge in MS Office, VBA having day-to-day artifact building and reporting activities
  • Played a key role in planning, testing, and implementation of application upgrades for Enterprise! LMS application over the years
  • Supported Enterprise! LMS application upgrades with the following deliverables:
  • Created & updated the Business specifications, scope, estimated efforts, Issue log, daily status tracker & other relevant artifacts for the project.
  • Acted as a bridge between vendor & customer by exchanging information, delivery/issue alerts, and response to business/technical queries
  • I played an active role in setting up the environment for user testing and played a key role in functional testing, regression testing, security testing, downstream testing, test results verification, and documentation
  • Played a crucial role in Implementation planning, engaging all teams in implementation support of the upgrade
  • Handled post-implementation issues reported by business by actively liaising with the vendor in resolving major system and vendor discrepancies.

Analyst Programmer - SharePoint Practice, IT

Eviden
India
02.2011 - 07.2011
  • Client: In-house Domain: Capital Markets Role - Software Developer Location - India Environment: MS Office, MS SharePoint, Microsoft SQL Role & responsibility:
  • Enhanced Syntel's in-house site 'Syntelligence' from SharePoint 2007 to SharePoint 2010
  • This was a migration project to enhance site into a full-fledged suite by adding features of SharePoint 2010
  • Played a key role in a site migration and testing
  • Showcased expert level skills in analyzing, defining and prioritizing the requirements
  • Supported SharePoint site upgrade with the following deliverables: Ran a pre-upgrade check on our existing SharePoint 2007 environment
  • Backed up the original SharePoint 2007 database in SQL Server & then restored to a new database
  • Installed SharePoint 2010 Server on a newly built Windows Server 2008 R2 machine
  • Configured the necessary service accounts
  • Created a new Web Application
  • Mounted our SharePoint 2007 database into SharePoint 2010 using PowerShell.

Process Executive

Infosys BPM Ltd
India
01.2010 - 10.2010
  • Client: Verizon US Role: Technical Process Executive Location: India Environment: Microsoft Office, Microsoft Windows Roles and Responsibility
  • As a Technical support executive, I addressed internet access issues of Verizon home users in the United States
  • Configured home internet, diagnosed software faults, and solved technical problems over the phone
  • Logging and keeping records of customer queries in Remedy tool
  • Analyzing call logs so you can spot common trends and underlying problems
  • Updating self-help documents so customers can fix problems themselves
  • Working with field engineers to visit customers if the problem is more serious
  • Testing and fixing faulty equipment.

Education

Bachelor's Degree - Information Technology

University of Pune

Skills

  • C#NET
  • ASPNET MVC
  • Dot Net Core
  • JAVASCRIPT
  • JQuery
  • WEB API
  • Angular JS
  • MS Azure
  • MS SQL
  • DB2
  • Certified Scrum Master (CSM)
  • ServiceNow
  • JIRA
  • Microsoft SharePoint
  • CAWA Scheduling tool
  • VB Macros
  • Business Intelligence

Websites

Certification

Certified Scrum Master (CSM)

Timeline

Senior Consultant

Eviden
10.2019 - Current

Consultant, Investment Division, Global Wealth and Asset Management

Eviden
08.2011 - 09.2019

Analyst Programmer - SharePoint Practice, IT

Eviden
02.2011 - 07.2011

Process Executive

Infosys BPM Ltd
01.2010 - 10.2010

Bachelor's Degree - Information Technology

University of Pune

Similar Profiles

CREATE PROFILE
Amit Bhan