Bikramjit Singh, CSM®

Email-id: adgy52@r.postjobfree.com

Contact: +1-973-***-****

Visa: GC EAD (Corp-to-Corp Only)

Career Objective

With solid expertise as Scrum Master, Project Management, Digital/Technical Business Analyst and Business Intelligence Architect, my goal is to reach a level of excellence in my area of operation, and contribute in the growth of industry by sharing my knowledge

Experience Summary

Have 12.5+ years of experience as Business Analyst, Scrum Master in analyzing, designing, development and maintenance of Business Intelligence Solutions, Digital Transformation, Web, windows applications with good exposure to full Software Development Life Cycle (SDLC)

Certified Scrum Master with extensive experience in Refinement, Sprint Planning, Sprint review and various scrum ceremonies

Strong experience in Leadership, Schedule Management, Project Management, Change Management, Client Interaction and understanding Business Application, Business Data Flow and Data Relations from them.

Around 9 years of experience on P&C Insurance domain with AINS 21 certified for Property and Liability Insurance Principles by AICPCU

Extensive experience in project management, creating project plans, project schedule, resource management and handling PMO activities with multiple parallel projects providing team leadership

Worked extensively on the capacity of Technical Business Analyst with Stakeholders for integration and mergers.

Extensive experience in using Microsoft Business Intelligence Development Studio (BIDS) for developing SQL Server Integration Services (SSIS) packages (i.e. ETL jobs) for data-management applications, creating reports using SQL Server Reporting Service (SSRS).

Experience in designing tables and Normalization using SQL Server 2000/2005/2008 R2

Experience in (SQL Server) Database Design and Development, Writing Constraints, Indexes, Views, Stored Procedures, Cursors, Triggers, and User Defined Functions using T-SQL and PL/SQL. Worked on performance tuning of queries and database.

Worked as Data Modeler to design logical and physical models for SQL database and data warehouse.

Basic knowledge of MSBI SSAS and MicroStrategy.

Facilitated requirements gathering sessions and documented business /functional and non-functional requirements.

Extensive experience in writing Business Requirements Document (BRD), Technical Specification Document (TSD) and Functional Specification Document (FSD).

Designed and developed Use Cases, Use Case Diagrams and Activity Diagrams using UML.

Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans using MS Project, MS Visio.

Organized JAD sessions to flush out requirements, performed Use Case and work flow analysis, outlined business rules, and developed domain object models.

Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.

SME's (Subject Matter Experts) and Managers of various business Units

Performed GAP analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.

Experience in developing Web Applications using Visual Studio 2010/2005/2003, .NET Framework 4.0/2.0, C#, VB.NET, ASP.NET along with Telerik Controls

Experience in developing Web services (WCF), Windows Services and Windows Applications using different Microsoft based technologies.

Hands on experience in developing applications using ADO.NET, XML, XSLT, JavaScript, JQuery, CSS, Visual Source Safe, Windows Services and IIS.

Experience in setting up Production environment for applications on Win 2003/2008/2008R2 and in configuring, hosting web applications on IIS 6.0/7.0.

Experience in working as SCM coordinator and attended CMMI audits for projects.

Strong verbal and written communication skills along with good Analytical and problem-solving skills. Strengths include Quick learning, positive attitude, trustworthiness, Self-Motivation and hard work

Technical Skills

Databases

SQL Server 2008 R2, SQL Server 2012 (working knowledge), SQL Server 2005/2000, MS Access, Oracle (Working Knowledge)

BI Tools

MSBI SSIS 2008 R2, MSBI SSRS 2008 R2, MSBI SSRS 2005, MSBI SSIS 2005, MicroStrategy (Working Knowledge)

Technology

.NET 4.0/2.0, MVC3, Web Services, Enterprise Library 5.0/3.5, Telerik

Programming Languages

C#.NET 4.0/3.5/2.0, VB.Net, ASP.NET, TSQL, PL\SQL

Scripting Languages

JavaScript, HTML, CHTML, JQuery, VBScript, ACORD P&C 2.7

Version Control Systems

MS Visual Source Safe (VSS). Team Foundation Server (TFS)

Other Utilities

Visual Studio 2010 with TFS, Visual Studio 2003/2005, VSTS 2005, HP-ALM (Working Knowledge), JIRA, ServiceNow, MS Project Professional

Methodologies

Agile, Waterfall, OOAD using UML and MS Visio

Hardware / Platforms

Windows 10/7/XP/2K/NT/98/95

Work Experience

Chubb Insurance, Malvern, PA

Project: Digital Transformation – Fast Track

Aug 2019 – Present

Role: Project Manager - Digital

Project Objective

Chubb Insurance have multiple P&C Insurance products under Fast Track system. This project initiative was to move identified applications to the digital platform in order to gain more business from various Partners. Project involved building APIs for digital platform, educating partners for the API and testing with Partners. Additionally, fulfilled BA role for Agent Web, another application project for WSG Group consisting of 21 products.

Role and Responsibilities

Fulfilled responsibilities as Project Manager.

Responsible for resource management, project scheduling and managing scope.

Managing day to day deliveries, change management. Reporting progress to stakeholders, delivering status reports.

Lead requirement gathering sessions for the assigned Fast Track products for digital initiative.

Created API Specification Document as work product of business requirement gathering.

Designed ACORD XMLs for request and response XMLs for API

Conducted knowledge transition session for duck creek team for API development and for Partners for product information.

Designed and developed Test Cases for partners in order to cover all possible scenarios for testing.

Conducted all levels of testing including functional, regression, user acceptance and integration to verify Partner.

Helped to create Process Flow, Business Flow Diagrams and Work Flow Diagrams to be presented to senior management. Used MS-Visio for flow-charting and process model.

Facilitated JAD sessions with Partner’s business and technical teams to ensure correct implementation of product at partner’s portal.

Liaise between business and Partner’s team to ensure a mutual understanding of processes and applications.

Created Partner-Product matrix to track various partners and the products used. Also creating tracking document for new Partner onboarding.

Effectively and accurately communicate relevant project information to the client and project team.

Communicate ideas for improving company processes with a positive and constructive attitude.

As Agent Web BA, worked on Agile methodology and participated in daily standup meetings.

Created user stories for each sprint of development using JIRA for Agent Web.

Created business requirements document for Agent Web user stories and helped development team in refinement. Helped in sprint planning and updating the sprint backlog.

Responsible for end-to-end delivery of user stories for Agent Web

Aetna Healthcare, Blue Bell, PA

Project: Aetna Healthcare - Commissions

Feb 2018 – Aug 2019

Role: Project Manager

Project Objective

Under Aetna Healthcare, Commissions domain had multiple applications for agents/broker/producers which interacts with other applications and interfaces with third party application for daily operations. Project involved enhancing existing applications for new features timely to meet business needs. It also involved defining new web applications/interfaces for the companies bought/merged by Aetna in different states

Role and Responsibilities

Working closely with project owner in backlog management and continuous delivery of features and maintained burn down chart and team velocity.

Lead requirement gathering sessions, analyzed and created all types of requirements documents (requirements, functional & technical) for technical solution projects.

Worked on Agile methodology and conducted various scrum ceremonies

Coordinated daily standup meetings.

Created user stories for each sprint of development using IBM RRC and RTC

Conduct all levels of testing including functional, regression, user acceptance, integration, and performance to verify client’s needs are met.

Communicate client’s business requirements by constructing easy to understand data and process models.

Provide input into developing and modifying systems to meet client’s needs and develop business specifications to support these modifications.

Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using Rational Rose and MS Visio.

Created Navigation Flow, Business Flow Diagrams and Work Flow Diagrams for applications using MS Visio.

Facilitated JAD sessions with technology and controlling teams to ensure regulatory compliance.

Designed and developed Use Cases using UML and Business Process Modelling.

Used MS-Visio for flow-charting, process model and architectural design of the application.

Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.

Developed Gap Analysis document, logical and physical design and remediation plan Captured, communicated, managed system requirements and maintained requirement traceability matrix to keep team members up to date with the latest testing results

Developed complex SQL queries and stored procedures to retrieve and analyze data from the Informix and Oracle databases.

Effectively and accurately communicate relevant project information to the client and project team.

Communicate ideas for improving company processes with a positive and constructive attitude.

Effectively handling the change management process to make sure the changes are approved as per the process.

Chubb Insurance, Philadelphia, PA

Project: OGC Chubb Mergers and Integrations

May 2017 – Jan 2018

Role: Assistant Project Manager, Technical Business Analyst

Project Objective

Post-merger of ACE INA Holding Inc. and Chubb Insurance, this project concentrates on all initiatives where Legacy Chubb applications need to remove dependency from Legacy Producer system and start using OGC Producer Administration System which is book of records for producer and their appointments, in order to align P&C insurance rules. As part of this project worked with 83 legacy applications to gather and write requirements. In addition, provide technical and architectural solutions to achieve the target.

Role and Responsibilities

Onshore Assistant Project Manager and Lead Technical Business Analyst

Responsible for Business Knowledge Acquisition and interaction with Legacy Chubb application Owners and Client-side Business Analysts for the same.

Analyzing Chubb’s Business rules and translate them as per ACE’s P&C Insurance Business rules and prepare translation logic.

Recommend architectural solutions for integration.

As SME answered queries of various business stakeholders from different business units who intend to use central book of records.

Build business intelligence i.e. SSIS (ETL) jobs solutions for data retrieval\sharing and processing.

Worked with Database Architects for database designing (SQL and Mainframe). Designed logical and physical models.

Provide data analysis reports to all Business stakeholders for day-to-day operations using complex SQL queries.

Developed SSIS (ETL) jobs for generating feed for the Legacy Chubb systems

Developed SSRS solutions for Legacy Chubb systems

Developed, tested and deploy Services for new business

Managed change management activities through analysis of system requirements effort

Responsible to conduct Unit Testing, SIT, UAT and Code Review.

Responsible for project management via Project Metrics Generation in C2.0 and PMO.

Use to generate Status Report Generation for weekly Client Meetings

Lead requirement gathering sessions, identified and prepared business requirements document, functional specification document, created Trace-ability matrix. Worked on effort estimation with development team.

Developed Use Case diagrams, Business Flow diagrams, Activity/State diagrams and Sequence diagrams so that developers and other stakeholders can understand the business process.

Create process flows, and produce documentation.

Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.

Conducted JAD Sessions with IT Teams, stakeholders and other management teams in the finalization of the User Requirement Documentation.

Created and maintained Excel spreadsheet of all configurations and their descriptions for easy access that was distributed company wide

Coordinate internal resources and other vendors for the flawless execution of projects.

Responsible to manage scope to meet deadlines and desired milestones

Effective management of stakeholder relationship at all levels of the business.

Responsible for conducting As-Is To-Be Gap analysis to find out the current state of the system and required state of the system.

Produced various ad-hoc reports that were used to monitor success of the new requirement by ensuring data is being created as it should.

Chubb Insurance, Philadelphia, PA

Project: OGC PAS Chubb Integration

Oct 2015 – Apr 2017

Role: Assistant Project Manager, Business Analyst, Technical Lead

Project Objective

ACE INA Holding Inc. Acquired another P&C insurance company named Chubb Insurance. As part of the merger, Producer and Appointment information from Chubb environment has to be brought in OGC Producer Administration System database. As Chubb’s way of writing business is different than ACE’s thus all ACE specific Business rules has to be implemented for translating Chubb data to ACE supported format. It majorly involved business intelligence (SSIS job) development. Besides it involved enhancement for existing applications, new web services and reports.

Roles and Responsibilities

Onshore Team Lead and Coordinator cum Developer (.Net and Database).

Interacts with Legacy Chubb downstream application Owners and Business analysts to discuss and device strategies for integration with OGC systems

Lead requirement gathering sessions, identified and prepared business requirements document, functional specification document, created Trace-ability matrix. Worked on effort estimation with development team.

Responsible for Business Knowledge Acquisition and interaction with Legacy Chubb application Owners and Client-side Business Analysts for the same.

Analyzing Chubb’s Business rules and translate them as per ACE’s Business rules and prepare translation logic. Developed, tested SSIS (ETL) jobs for generating feed for the Legacy Chubb systems

Developed SSIS (ETL) jobs to fetch data from various data sources i.e. Excel, SQL Server, Mainframe

Developed, tested SSRS solutions for Legacy Chubb systems

Developed, test and deploy Services for new business

Responsible for Unit Testing, SIT, UAT and Code Review.

Assisted the project manager in change management activities through analysis of requirements effort, and resources.

Responsible for project management via Project Metrics Generation in C2.0 and PMO.

Status Report Generation for weekly Client Meetings

Interact with Chubb IT Team for their technical requirements and support

Chubb Insurance, Philadelphia, PA

Kolkata, West Bengal, India

Project: OGC Webapps

Dec 2012 – Apr 2017

Apr 2010 – Dec 2012

Role: Assistant Project Manager, Business Analyst, Technical Lead

Project Objective

ACE OGC has six applications under its umbrella. The objective of the project is to provide business continuity to the P&C insurance business of ACE by providing required enhancements/developments and support to six applications named Compliance Risk Assessment, Complaint Management System, ACE Forms Database System, Pipeline Tracking System, Producer Administration System and Fines and Penalties System.

Role and Responsibilities

Onshore Assistant Project Manager, Technical Lead and Coordinator cum Developer (.Net and Database).

Lead requirement gathering sessions, identified and prepared business requirements document, functional specification document, created Trace-ability matrix. Worked on effort estimation with development team.

Responsible for Business Knowledge Acquisition and interaction with Client and Client-side Business Analysts for the same.

Analyzing the new requirement, enhancements and bugs, for both UI and database, and designing and developing an optimal solution for them.

All the projects above required planning, estimation, tracking, risk and issues management, change management, stakeholder management, raising invoices.

Based on requirement, worked on database enhancements by creating new tables, stored procedures, views and indexes. Performed performance tuning of queries.

Develop SSIS (ETL) solutions for dependent applications.

Develop reporting features using SSRS for business group

Provide Ad hoc reports to Business group for day-to-day operations using complex SQL queries.

Interaction with all other downstream applications for scope of improvements

Responsible for Unit Testing, SIT, UAT and Code Review.

Responsible for project management via Project Metrics Generation in C2.0 and PMO.

Status Report Generation for weekly Client Meetings.

Chubb Insurance, Philadelphia, PA

Project: Major Claims Applications and PRO Application

May 2014 – Sep 2015

Role: Assistant Project Manager, Onshore Lead & Coordinator

Project Objective

Major Claims include stack of 15 applications which are all related to P&C Insurance Claims Business. The objective of the project is to provide business continuity to the Claims business of ACE by providing required enhancements/developments and support to all 15 applications under Major Claims. It also involves running month end financial process to consolidate claims for various downstream application. In addition, need to provide business continuity to PRO application, a UNIX based system.

Roles and Responsibilities

Onshore Team Lead and Coordinator cum Developer (.Net and Database).

Requirement Gathering and Analysis and Effort Estimation.

Responsible for Business Knowledge Acquisition and interaction with Client and Client-side Business Analysts for the same.

Analyzing the new requirement, enhancements and bugs, for both UI and database, and designing and developing an optimal solution for them.

Interaction with all other downstream applications for scope of improvements

Responsible for Unit Testing, SIT, UAT and Code Reviewing.

Status Report Generation for weekly Client Meetings

Execution of Financial Month end Process for consolidation of claims data, worker’s comp data

Interaction with QDabra for certificate for RFS application

Chubb Insurance, Philadelphia, PA

Project: Fines and Penalties Redesign

Jan 2014 – May 2014

Role: Business Analyst, Onshore Lead & Coordinator

Project Objective

Objective of this project is to accomplish migration of Fines and Penalties system from MS Access based application to MVC3 based application with SQL Server as database. It also involved the automation of import process of vouchers from PeopleSoft database.

Role and Responsibilities

Requirement Gathering and Analysis and Effort Estimation.

Onshore Team Lead and Coordinator cum Developer (.Net and Database).

Responsible for Business Knowledge Acquisition and interaction with Client and Client-side Business Analysts for the same.

Project tracking

Responsible for Unit Testing, SIT, UAT and Code Reviewing.

Responsible for Project Metrics Generation in C2.0 and PMO.

Status Report Generation for weekly Client Meetings

Chubb Insurance, Philadelphia, PA

Project: OGC Webapps Migration

Oct 2012 – Mar 2014

Role: Assistant Project Manager, Business Analyst, Onshore Lead

Project Objective

ACE OGC has five projects/applications under its umbrella. The objective of the project is to migrate\upgrade the applications to latest technical platform of .Net Framework 4.0 and MS SQL Server 2008 R2. Applications for migration are Compliance Risk assessment, Complaint Management System, Pipeline Tracking, ACE Forms Database System and Producer Administration System.

Role and Responsibilities

Effort Estimation.

Onshore Team Lead cum Developer (.Net and Database).

Responsible for Business Coordination.

Analyzing the new requirement, enhancements and bugs, for both UI and database, and designing and developing an optimal solution for them.

Responsible for Code and Test Case Reviewing.

Responsible for Project Metrics Generation in C2.0 and PMO.

Status Report Generation for weekly Client Meetings

BFS Technology Consultancy Group, Kolkata, India

Project: C-SQLR

Apr 2009 – Apr 2010

Role: Analyst & Developer

Domain Coverage

BFS Healthcare (for Oracle), Insurance (for Sybase), BFS (for SQL Server)

Project Objective

The application is focused toward creating a window-based tool that would validate the SQL code against some common set of industry specified best practices related to database programming. The tool covers Oracle, MS SQL Server and Sybase databases.

Role and Responsibilities

Part of Requirement Analysis team for the application

Responsible for designing and implementing the application architecture (2 member team)

Developed the framework for the application

Developed the Parser engine of the application

Responsible for the Unit testing of the Parser

Contributed for the integration testing.

Realogy Franchise Group UK - Travel and Hospitality, India

Project: Awards and Recognition – UI

Sep 2008 – Apr 2009

Role: Developer & Technical Support

Project Objective

The basic objective of this project is to develop the new functionality for the Awards & Recognition application. At the same time to deal with the enhancement as well as bug-fixing related work.

Another important task of this project was to develop a common codebase for the Awards application for both US and Canada as earlier there were two separate applications for both of them

Role and Responsibilities

Primarily responsible for development and technical support to the application.

My responsibilities include:

oAnalyzing the new requirement, enhancements and bugs, for both UI and database, and designing an optimal solution for them

oEffort Analysis and Estimation

oUnit testing as well as documentation.

Realogy Franchise Group UK - Travel and Hospitality, India

Project: Realogy RFG BH&G

Jan 2008 – Aug 2008

Role: Developer

Project Objective

The basic objective of this project is to provide all the existing and some additional functionality to the brand BH&G, which is newly added to the Realogy Franchise Group.

Role and Responsibilities

Primarily involved in database related activities, Stored Procedure creation/modification, Data Import/Export, as well as documentation.

Involved in Business Understanding and Analysis.

Involved in Design.

Actively involved in unit testing and supported testing team for database related parts.

Awards and Recognitions

Received ‘Spot and Shine – Illuminator’ award from ACE Insurance for Q1 2015

Received ‘Certificate of Recognition’ from Lisa Preskenis, VP – ACE North America Systems for OGC Web Application Migration project for 2013-14.

Received ‘Associate of the Quarter’ from ACE Client Partner John Weber for Quarter 1 2013 at onshore location.

Received ‘Certificate of Recognition’ from Lisa Preskenis, VP – ACE North America Systems and Beth Markoe, SVP – ACE North America Systems for contributions in OGC Business for 2011-12.

Received “Certificate of Recognition” from Bill Hurd, Head - ACE North America for contribution to their business for 2010 and WFIC Merger Project at year end.

Received “Diamond In The Rough” award from T&H vertical for the first quarter 2009

Worked with Cognizant Technology Solutions (January 15, 2007 – May 10, 2007) during project semester under Data Architecture Centre of Excellence (DACOE) and awarded “Outstanding Performance”

Certifications

Certified Scrum Master from Scrum Alliance

AINS 21 Certified by AICPCU

Microsoft Certified Technology Specialist (SQL Server Database Implementation and Maintenance)

Contact this candidate