Business Analyst, Business Data Analyst, SQL, Excel, MS Project, SOAP

Tapas has **+ years of IT experience as Business Analyst along with Quality Assurance and Project Management in all types of Insurance domain (Property & Casualty, Auto, Health and Home), Pharmaceutical and Capital Markets. He is specialized in ETL/Data Warehousing, BI Reporting Tools and Web/Mobile applications with hands-on System/Regression testing.

HIGHLIGHTS:

Elicits requirements using interviews, document analysis, requirements workshops, competitive product analysis, business process descriptions, storyboards, Wire-frames, surveys, task and workflow analysis.

Proficient in Data Analysis / Data mapping / Data Validation / Data Dictionary / Data Integration / Metadata management / Business Analysis / BI Reporting through various Tools.

Profound cognition in requirements gathering from the Business users and Stakeholders to develop Business Requirement document, Use Case and test case.

Proven ability in data profiling among various external legacy systems and the proposed Enterprise Data Warehousing model for standardizing the data.

Effectively communicates to the business customers and the entire technical team to analyze existing anomalies, if any, and recommends feasible solutions.

Demonstrates leadership in managing large and complex BA/QA engagements in multiple projects at the same time within onsite/offshore team.

SUMMARY:

Accumulates business requirements through interviews, and gets oriented with the current system. Prepares Business case and Business requirement document (BRD) with the interaction of User Interface (UI) and User Experience (UX). Conducts JAD sessions with Developers, SMEs, QA team members and Business stakeholders.

Translates business needs into Technical and functional requirements in a complete, correct manner to understand.

Organizes and facilitates Agile and Scrum meetings that includes Sprint Planning and Review, Daily Stand-ups with a team of business representatives, software developers, and testing team and create snapshots of project velocity.

Supports Business Requirements activities by providing end-to-end analysis of the entire system and takes onus with respect of metadata management, data requirements, data flows, workflow context and user interface design.

Creates and maintains Business Use cases and System Use cases, Use Case diagrams, Flow Diagrams, Business Flow Diagrams, Activity diagrams, Sequence diagrams through VISIO tools.

Expert in preparing of Test Strategy, Test Cases, UAT support and test execution of ETL tools, like, Informatica, DataStage, Ab-Initio and BI Reporting applications, like, Business Objects, Cognos, Spotfire and SalesForce.com.

TECHNICAL SKILLS:

Languages:

PL/SQL, XML, Java, ASP.NET, .Net Framework, C/C++, HTML, K-Shell, AWK, Perl

Databases:

ORACLE 11g, DB2, SYBASE, MS SQL Server, SQL Anywhere, MS Access

Operating System:

HP-UX, SOLARIS, Linux, Windows 2000, Windows XP and Windows Vista/7/10

Applications:

MS Project, Power Point, Excel, Visio, TOAD, EZ-SQL, SQL Developer, Guidewire

Data warehouse ETL Tools:

Informatica, DataStage, Ab-Initio

Business Intelligence Tools:

COGNOS 8.5, Business Objects, QlikView, Spotfire and SalesForce.com

Error Tracking Systems:

JIRA, Mercury HP Quality Center, Team Track, Clarify Clear Quality, PVCS Tracker

Web Services:

SoapUI 5.0.0

Automation Testing Tools:

Quick Test Professional, Load Runner, WinRunner, Test Director and Clear Quest

PROFESSIONAL EXPERIENCE:

Arch Insurance Group June 2016 – January 2017

Role: Business Data Analyst

Arch Insurance is a market-leading insurer in the US who provides a wide range of property, casualty and specialty insurance for corporations, professional firms and financial institutions across the US that comprises with superior underwriters and its claims services.

Accomplishments:

Responsible in formulating Data Dictionary from the existing SQL Script through the process of reverse engineering, managing integration with existing systems, including Data mapping, data feed analysis and data schema changes.

Performed data mapping among various source systems, transformation of data to meet internal system requirements.

Developed complex SQL queries for querying data against different databases for data verification process.

Designed extensive QlikView reports on navigating Policy and Claims System using combination of charts and tables and performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.

Analyzed new and existing data using SQL and BI tool – Qlikview and built dynamic reports, dashboard using Qlikview to leverage various data for company management.

Worked on Qlikview Server and Publisher to manage user access, schedule refreshing of documents, mount completed applications.

Created Dashboards with different style using Qlikview components like List Box, Slider, Buttons, charts and Bookmarks.

Analyzed the data, understood the data, standardized the data and documented the lineage of data across the Enterprise.

Collaboratively exercised with developments team to ensure data specifications are understood and followed, supporting Quality Assurance and User Acceptance Testing (UAT) during design and implementation of major enhancements.

Compiled detailed documentation for technical team (Architect, Developers, QA etc.) and facilitated project/enhancement governance and prioritization.

Involved in defining source to target data mappings, matching of Custom to Standard field elements and data definitions.

Environment: MS SQL Server, Toad, XML, SoapUI, Informatica, HP Quality Center, Unix, .Net and Business Objects.

SUMMARY OF PRIOR ENGAGEMENTS:

Capgemini Financial Services USA Inc. October 2008 – April 2016

Role: Lead Consultant – Business Analyst / QA

Clients: Hartford Insurance, Farmers Insurance, Cigna Insurance, Morgan Stanley, Moody’s Investors Serv.

Project: Morgan Stanley - Mobile Research Application, New York City, NY

The Mobile Research application is an integrated equity system of Authoring, Publishing, Distribution Engine and Research Link to be accessed by the users through iPad, iPhone and Android phones. Research documents are prepared by analysts and are published using Authoring/Publishing application and distributed to mobile devices thru Research workflow Engine.

Accomplishments:

Converted consumer insights into out of box ideas to enhance user experience (UX) and presented it to marketing team.

Coordinated with the Business users, Project Managers and Development team to analyze the requirement and generated comprehensive Use Case, Test Plan and test Case in an Agile environment.

Conducted data validation and data mapping derived from MDM using SQL queries in MS SQL Server 2008 environment.

Project: Moody’s Investors Service - One Ratings Platform (ORP), New York City, NY

ORP program is a multi-year initiative to implement an enterprise ratings platform for efficient, effective and standardized ratings business processes to accelerate delivery of ratings products and services to the market, minimize risk, and offer the flexibility to meet market, business and regulatory demands.

Accomplishments:

Gathered business requirements from the client, translating them into use cases and functional specifications.

Communicated to various business stakeholders and understand their vision and ensuring this achieved during the project. Key tasks were performing ROI analysis, user experience analysis.

Environment: Oracle, Guidewire, Java, XML, SoapUI, Informatica, JIRA, Quality Center, Unix, Cognos 9.5, SalesForce.com

Cegedim Dendrite (formerly Dendrite International, Inc.) December 1997 – June 2008

Role: Group Lead – Business Analyst/QA

Clients: Daiichi Sankyo, BMS, Sanofi Aventis, Schering Plough, Abbott Laboratories, Johnson & Johnson

Accomplishments:

Formulated Use Case, User Stories and professionally maintained Sprint Backlog in an Agile environment.

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Actively involved in requirements traceability information and tracked requirements status throughout project.

Collaborated with business users to test applications and implement workaround to feature issues, works with the business to recommend appropriate training, communication and scheduling as systems are deployed.

Served as a subject matter expert and performs functions for urgent, high visibility, high profile, and strategic projects to ensure accuracy and completeness while meeting challenging deadlines.

Environment: Oracle 9.0, Visual Basic, Eclipse, QlikView, SQL Navigator, XML, .Net, Sun Solaris, Ab Initio, Cognos 8.5.

EDUCATIONS:

Education: Master’s Degree in Economics and Statistics.

College: University of Burdwan, India.

Special Training:

Attended Oracle 7.3 Database Administration training.

ENDORSEMENT:

Available in LinkedIn.com, the link of which is: http://www.linkedin.com/in/tapasbiswas

Contact this candidate