Kaushiky Banerjee

Phone – 848-***-****

Email : adci3o@r.postjobfree.com

Location : Trumbull, CT

https://www.linkedin.com/in/kaushiky-banerjee-9796a3bb/

Experience Objective:

Business System Analyst, Project Coordinator and Data Analyst with around 8 years experience in banking, insurance, manufacturing and healthcare.

Worked in many testing projects where I was responsible for creation of Test Scripts, Execution of Testing Projects & Completion while doing the UAT and user training.

Experience managed project as a Scrum Master and a lean agile change agent in leading teams and organizations in implementing projects using different agile frameworks to meet robust market changes.

I have a good understanding of Database Concepts along with SQL commands.

Certification :

SAFe® 4 Certified Agilist, Scaled Agile, Inc April 2018- April 2019

Technical Skill Sets:

Databases

Oracle, MS Access and SQL Server 2008

Programming Languages and Scripting Languages

XSL, SQL,C

Operating Systems

Windows, Linux

Tools

SFDC, CRM, Tableau, Microsoft Dynamics(2016)

Project Tools

MS Word, Excel, Visio, PowerPoint, Access, SharePoint,Service Now, Microsoft Visual, Remedy, JIRA,Forgerock identity management,Microsoft TFS,ALM, Version One, Tableau

Methodologies

Agile, Waterfall,(SDLC) Total Quality management (TQM),

Professional Experience :-

Project: Wells Fargo, Charlotte, NC

Project Role: Business System Analyst September 2018 – Feb,2019

Project Description :

The project was for Internal and external Payment system API’s for Gateway LOBs who were responsible for providing access to various payment system ( ex : Wire, ACH) to external and internal cients .

Role Description:

Aligning internal business requirements to MS Dynamics CRM capabilities and best practices.

365 (CRM) technical/business solutions to our diverse client base according to their unique needs.

Responsible for providing 365 (CRM) technical/business solutions to our diverse client base on business need.

Work closely with business and developers to build Account, case and dashboards for effective analysis of sales and marketing efforts in Dynamics.

Responsible for producing technical systems documentation including: business requirements, functional specifications, user requirements, traceability matrix, risks and implementation plans.

Evaluate KPI trend performance vs thresholds and conduct in-depth analysis to understand reasons for observed performance

Identification of data specific issues and work with key technology partners in resolving them

Improved team velocity by incorporating capacity planning into sprint planning sessions.

Participating in preparing Test Plans.

Logging defects in Defect Manager, monitoring their status and tracking them to closure using Jira.

Customized Page layouts for Standard/Custom objects and assigned Record Types.

Application to IAM integration as well as User Migration in a phased methodology

Document the security for all phases of the project as well as identify and document the deliverables

Managing all releases and resources for MS Dynamics CRM deployment

Understanding the severity of the bug and give information to developers in order to fix it.

Using Excel pivot tables to manipulate large amounts of data in order to perform data analysis, position involved extensive routine operational reporting, hoc reporting, and data manipulation to produce routine metrics and dashboards for management.

Planning and estimating tasks for each item on the selected product backlog from a BA stand point.

Used SQL for accessing and manipulating database systems and prepare visulazation report on Tableau.

Manages and coordinates all activities necessary to control, track and audit Changes in the environment.

Leads the Change Management function and is responsible for the adequate skill levels and performance of the assigned staff members.

Ensures Change status, progress and issues are communicated to the appropriate groups.

Audits and manages the process lifecycle and reports to upper management

Alert manager to potential risks and issues of importance.

Author, review, analyze, and document business systems and user requirements producing deliverables such as use cases, user stories, UI mockups, test cases, functional specifications, workflow process diagrams, data flow / data model diagrams.

Project: Duke Energy, Charlotte, NC

Project Role: Business Web Analyst March 2018 – July 2018

Role Description:

Gather requirements from Product Owner, Quality managers at various plants.

Created Product Backlog, Sprint Backlog and managed User stories.

Coordinated and participated in weekly estimation meetings to provide high-level estimates Story Points for backlog items.

Developed and followed agile project management plan Agile Ceremonies. Facilitated build requirements log product backlog with cost estimates and priority.

Conducted Grooming meetings, Scrum Daily standup, Product backlog, Sprint Planning, Sprint Review & Sprint Retrospective meetings.

Coordinated with UX design team to guide them on business expectation for Web and mobile design.

scalated impediments and risks that cannot be resolved at the team level

Determined the team capacity velocity from historical data. Created Work Break down structure user stories and corresponding activities tasks.

Design website content that satisfies the webmaster, website content writers in the organizations and website users external to the organization.

Use graphics programs or work with graphic artists to create unique graphics for the site that do not make site access speeds unacceptably slow.

Ensure that the site operates as planned by performing site and usage analyses and modifying the site as needed.

Upgrade site content on an ongoing basis to improve and keep the site visually interesting.

Coordinating requests for content changes from Communications Manager and other members of the team

Liaising with dWebsupport regarding technical issues.

Responsible for ensuring the smooth operation of our mission-critical and customer-facing IVR and inbound call distribution.

Monitor call levels in our IVR and modify our call trees to ensure proper flow-through and routing to our call center queues using Amazon Connect

Conduct Root Cause Analysis and recommend appropriate solutions and continuous process improvement

Work closely with our call center management vendor, software development team, and other internal business teams to deploy builds to our test and production environments

Created Requirements Specifications, Use Case Diagrams, High Level and Detailed Process Flows, as well as standardized a process that decreased requirements gathering and analysis.

Create and perform SQL query for test SQL environments to understand the billing system.

Manipulated various SQL queries adhering to the business process.

Prioritized Production issues and assigned them to the Business Analysts. The effort enhanced the application and decreased time for the business depending on the issue.

Conducted UAT with the cross-functional business teams to ensure the system was aligned with the vision of the business teams.

Developed crucial functional requirement specifications, creating detailed use cases and process flow diagrams to support functional specifications

Project: Wells Fargo, Charlotte, NC

Project Role: Business System Analyst June 2017 – Feb,2018

Role Description:

Aligning internal business requirements to Dynamics CRM capabilities and best practices.

Understand the business process for Credit risk team to implement in the system.

Facilitate monthly agile development sprint planning meetings

Responsible for producing technical systems documentation including: business requirements, functional specifications, user requirements, traceability matrix, risks and implementation plans.

Customized Page layouts for Standard/Custom objects and assigned Record Types.

Improving productivity of the technical teams through facilitating creativity and empowerment;

Participating in preparing Test Plans.

Responsible for logging defects in Defect Manager, monitoring their status and tracking them to closure using Jira.

Customized Page layouts for Standard/Custom objects and assigned Record Types.

Managing all releases and resources for MS Dynamics CRM deployment

Giving mandatory information of a defect to developers in order to fix it.

Analyze the risk related to credit system implementation .

Understad the loan and pricing related business process for system implementation .

Organizing sprint planning, sprint review and retrospective meetings; and

Ensuring requirements are addressed through use of user stories, processes or mechanisms to validate the successful delivery of the requirements.

Planning and estimating tasks for each item on the selected product backlog from a BA stand point.

Complete change management assessments

Manages and coordinates all activities necessary to control, track and audit Changes in the environment.

Leads the Change Management function and is responsible for the adequate skill levels and performance of the assigned staff members.

Audits and manages the process lifecycle and reports to upper management

Schedule Urgent CAB meeting when necessary

Author, review, analyze, and document business systems and user requirements producing deliverables such as use cases, user stories, UI mockups, test cases, functional specifications, workflow process diagrams, data flow / data model diagrams

Preparing and Analyze reports to ensure accuracy of data, identify patterns, and report them in SQL.

Leading project on providing solutions for database migration in response to regulation changes

Preparing data mapping documents.

Identifying the data table from SQL server .

Project: AmerisourceBergen(Lash Group), Charlotte, NC

Project Role: Business Analyst and Project Coordinator June 2016 – May 2017

Role Description:

Planned and conducted requirements elicitation meetings with the business to collect functional and non-functional requirements relating to client's Salesforce technology enhancement and initiatives.

Maintains a solid knowledge base of the functional capabilities and has hands-on experience configuring Salesforce clouds - Sales/Service/Marketing/Chatter.

Possesses good understanding and experience with the Force.com platform: VisualForce

Designed, setup and maintained Salesforce standard objects, custom objects and junction objects, while also structuring user roles, security profiles and workflow rules

Created new custom objects, assigned fields, designed page layouts, custom tabs and components.

Outlined the organization hierarchy and created profiles, roles accordingly in Salesforce; worked on visibility and security settings around them as required by the business.

Works with various technical staff members to determine possible solutions and communicate business and system impacts.

Ability to drive Salesforce application best practices within the company to maximize the use of Salesforce and obtain key business metrics that identify operational trends within the business and assess measurement against our Key Performance Indicators.

Ability to make software configuration changes to support business processes of healthcase cusomers.

Extensively Knowledge in the Member Enrollment and Billing information.

Knowledge and Experience on Membership, Billing, Claims Payment Processing in relation to HIPAA.

Able to understand and implement Processing ICD-9 ICD-10

Understand the Medicare and Medicaid process to implement in the CRM application .

Created Requirements Traceability Matrix to keep the stakeholders informed of the progress of the project.

Assist CRM Project Manager in status reporting and project milestone tracking.

Manage the relationship with system integrator and software vendor to coordinate system upgrades, patch releases and service requests.

Preparing report on Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions

Responsible for planning projects and preparing documents with project manager

Responsible to prepare progress reports and communicate information about these to relevant staff

Identified specifications for billing and accounts receivable requirements, performed gap analysis and presented information to technical team to identify system requirements.

Facilitated strategic meetings between Perot technical team and hospital administrators resulting in identifying key differences in clinical systems.

Coordinates and facilitates work sessions with Medicare Operations users and IT development to define projects' scope and requirements and manage project expectations.

Performs business support responsibilities, including production monitoring, file maintenance, and ad-hoc reporting.

Developed User Stories, Acceptance Criteria for the Sprint’s

Guided projects to completion on time, within scope, and on budget.

Understand the launch process, marketing objectives, sales methodologies, SDLC

Manipulating, cleansing & processing data using Excel, Access and SQL.

Used SharePoint to store document and maintain version control.

Wireframes and documentation were created using agreed upon best practices, templates and systems.

Manage change impact and urgency to ensure impact to production services is minimal and the reasons and justification for changes are business beneficial

Conducted process flow & workflow analysis with the project team to bring out the identified gaps and documented as-is and to-be work flows.

Used SQL to retrieve and analyze the data.

Responsible for drawing data flow diagrams and process flow diagrams using MS Visio.

Mitra Sk Pvt Ltd, India

Project Role: Business Analyst & Project Coordinator Jan 2012 – June 2013

Role Description:

Collaborate with key stakeholders by employing a proactive and consultative approach to gain mutual consensus on project scope and timeline

Organize Plan and Facilitate JAD sessions to allow different SME’s and stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.

Lead enterprise requirements analysis and verification, ensuring that requirement statements are complete, consistent, concise, comprehensible, traceable, feasible, unambiguous, and verifiable.

Build effective relationships between IT and Sales, Marketing and Customer Service to develop a “joint” vision in support of the systems.

Experience in public and private market research industry

Was appreciated when the product was live and presented a mockups to end users.

Provide guidance to other Business Analysts on corporate standards for completing BRD when required in an oversight role.

Work closely with the relevant business partners to Discover, Describe, and Document detailed Business & Functional Requirements for new enhancements, additions or modifications to existing systems.

Create, Maintain and Approve the Requirements Tractability Matrix (RTM) to align with the Business Requirements.

Created user manuals for non technical users.

Visited china twice for several client meetings and to understand business needs.

Conduct Gap Analysis to identify risks, missing or not SMART requirements, non-standard or missing or technical instead of Business focused requirements in projects in Oversight projects

Created Software Requirements Documents which included Activity diagrams, and work flow diagrams of the new enhancements.

Sovereign System Analysis Solution, India

Project Details :Peerless hospital is one of the major reputed hospitals in Kolkata, India. They mainly caters to regional patients and offer in and out patients department. This software was introduced to maintain patient and doctor information and other clinical data.

Project Role: Business Analyst Jan 2010 – Dec 2011

Role Description:

Working as a Business Analyst for the project and Data Analyst .Used MS Excel vLookups and Pivot Tables for reporting and Data Analysis

E-Sanchar Pvt. Limited, India

Project Description: Medicaid is a health insurance program financed and run jointly by the state government for low-income people of all ages who do not have the money or insurance to pay for health care. The goal of the program is to provide medical and other health care services to eligible individuals so that they are able to remain as self-sufficient as possible.

Project Role: Business Analyst Oct 2007 – Dec 2009

Role Description:

Working as a Business Analyst for the project.

Education

Degree / Specialization

University

Year

Masters in Information Technology

Amity University, India

(2014-2016)

Bachelors

Calcutta university, India

(2004-2007)

Contact this candidate