Project Manager Data

Sandy Sarkar

abmztm@r.postjobfree.com / 276-***-****

PROFESSIONAL SUMMARY

. A result oriented Business/Quality Analyst having more than 7 years of

experience in the Healthcare Industry with extensive requirement

gathering for custom solution in the cross functional areas like pre-

clinical, clinical, drug development, pharmaceutical and bioinformatics.

. Used IVR to help customers receive anonymous calls about their test

results or content update.

. Working experience in the Analytical CRM for health care customers and

their custom data management.

. In-depth knowledge of Claims Processing with FACETS, SunGard Formworks &

EDS Metavance.

. Worked heavily on Clinical Trials using IVR to conduct global clinical

trials and manage the large volumes of data generated.

. Assisted in Clinical Data Management and Clinical Trials Management.

. Gathered business requirements through JAD sessions and one-on-one

interviews with the Business Stakeholders and tracked the requirements

using CALIBER.

. Performed collection, coding, and assessment and reporting of adverse

event data using ARISg.

. Worked in the ARISg Implementation of the EHR-Pharmacy Module.

. Thorough experience of providing in-depth analysis to business processes

& Data Warehouses using Business Intelligence tools such as Cognos,

Business Objects etc.

. Excellent understanding in analysis of EDI-X12 transactions such as

270,276,278,835,837

. Experience in working on ETL applications/Data Marts & Data Warehouses

. Developed business and functional requirements for new Data Warehouses &

Business Intelligence Implementations and subsequent releases and assist

in the creation of related estimates.

. Exposure to HIPAA Compliance requirements and HL 7 standards.

. Ability to define timelines for prioritizing work requests using tools

such as MS Project.

. Ability to model business processes (BPM) in enterprise level projects

using industry standard case tools.

. Sound knowledge of concepts like Gap Analysis, Risk Analysis, Impact

Analysis.

. Excellent Business writing skills in writing Business requirements

document, USE Case Specifications, Functional Specifications, Systems

Design Specification (SDS), Systems Requirements Specification (SRS)

. Thorough exposure of conducting JAD sessions and interviews with Subject

Matter Experts (SME) and data stewards to understand the business

process, business rules, and data requirements.

. Expertise in Agile, RAD, RUP, SCRUM, Waterfall SDLC (Software Development

Methodologies).

. Worked on Web based Knowledge management system Live Link.

. Experience in Live Link Notifications and Workflow management.

. Worked with the business team to collect the business requirements,

security and service level requirements (SLA) and documented them using

Requisite-Pro.

. Co-authored Data design, Architecture design and Staging requirements for

the Data warehouse environment.

. Used Safety Mart for Clinical Safety Data Management.

. Working Experience in Electronic Submissions in standard format E2B.

. Proficient in using UML for Business Process Modeling, Use Cases,

Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration

Diagrams, Class Diagrams and document them using Microsoft Visio.

. Excellent Knowledge of Object Oriented Programming & Concepts, Relational

Databases & Client/Server applications.

. Excellent understanding of Business process reengineering in an

Enterprise level Architecture environment.

. Experience in UI designing using simulation tools such as Microsoft

Visio, iRise, Axure RP Pro 4 & other industry tools.

. Ability to prepare RTM (Requirements Traceability Matrix) & perform

requirements analysis & design.

. Expertise in Test driven development by writing test cases extensively

for performing UAT System Integration testing (SIT), BAT (Business

Acceptance Testing).

. Experience in reviewing documentation of developed solutions and

authoring of basic user guides or instructions and help files to assist

in end user training & support.

. Excellent interpersonal, verbal & communication skills.

SKILLSET

Technologies: Microsoft .Net, Web Services (SOAP, WSDL, UDDI), J2EE

Languages: Visual C#, Visual Basic

Scripting: JavaScript, HTML, DHTML, CSS, XML, XSL, XSLT

App Server: Microsoft IIS 7.0/IIS 6.0/IIS 5.0, Microsoft Server 2003,

Windows NT

Databases: MS SQL Server 2008/2005/2000, MS Access, Oracle 11i/10g/9i,

MySql, DB2

Tools: SunGard Formworks 5.0, Metavance, Sybase Power Designer 15, Visual

Studio 2008/2005, MS SharePoint 2007, iRise, Telelogic DOORS, Rational

Suite (RequisitePro, ClearQuest, Clearcase), Rational Rose, Axure Pro,

Blueprint, CaliberRM, Enterprise Architect, Team Foundation Server,

Trizzetto FACETS, Cognos 8 BI Studio, Business Objects XI,Formdocs,

Edifeces Specsbuilder,

Applications: MS Office 2007 Suite, MS Project, MS Visio, VMware, FileNet

P8, Documentum 6.x, Ftp95 Pro

OS: Windows Vista x64/x86 Enterprise, Windows XP Professional x64/x86,

Linux, Unix

EDUCATION

Masters of Information Systems, George Mason University, VA

PROFESSIONAL EXPERIENCE

Sr Business/Quality Analyst, Delta Dental,

San Francisco, CA, Aug, 09-Present

C2R Project (Claims to Resolution)

Delta Dental is one of the biggest dental insurance carrier in USA. They

process a huge volume of health insurance claims on a daily basis. For pre-

processing claims & adjudicating them they use industry popular tools such

as Sungard Formworks, Metavance & Macess. I work in a dual role as a Sr.

Business & Quality Analyst in the C2R Formworks Projects. Briefly

summarizing my responsibilities:

. Gathering & validating Business Requirements by conducting meetings & JAD

sessions with the stake holders & translating them to Functional

Specifications for the development team.

. Resolving production defects by providing interim solutions and floating

new change managements to provide long term solutions to counter attack

those defects.

. Analyzing, reproducing production defects in different environments &

tracking them using ClearQuest.

. Conducting Segment, Smoke & Regression tests and tracking issues on HP

Quality Center.

. Creating & managing requirements through requirement management tool

CaliberRM

. Validate defect fixes by recreating the defects in different environment

using test scenarios

. Create Project Dashboards in consultation with the project manager to set

milestones for different deliverables based on the priorities set by the

business.

. Monitoring & troubleshooting the claims pre- adjudication system

comprising of different COTS products such as Sungard Formworks & Maccess

& EDS Metavance by using proprietary Analytical tools provided with the

them.

. Develop test plans in Quality Center for testing Required Change

Managements, Change Controls.

. Conduct defect tracking & review meetings on a regular basis with

different teams across the Enterprise.

. Proposing new functionalities to the business to make the processes more

efficient through means of white papers & presentations.

. Generating periodic deliverable test execution reports and restructuring

Quality center depending upon the priorities.

Environment: CaliberRM, IBM ClearQuest, Sungard Formworks,EDS

Metavance,Macess,Sql Server 2008, Formdocs, MS Visio,HP Quality

Center,Edifeces Specs Builder 6.5,UltrEdit,MS office 2007

Sr Business Analyst, Dept. of Health & Human Services

Lincoln, NE, Jan, 09 - July, 09

The new Claims Processing MMIS (Medicaid Management Information System), NE

was initiated by the State of Nebraska to replace their 27 yrs old legacy

system with a new SOA based system that will be based on the Microsoft .NET

Platform. The new system will automate all the business areas with minimum

human intervention. I was the Business Analyst/Data Analyst for the all the

Claims Processing data which needed to be migrated from the Mainframe to

the Sql Server environment. I had to constantly interface with the legacy

team & the new MMIS design team for data & design related issues.

Summarizing my responsibilities:

. Communicate the Gap process Analysis w/ the state and feed that into the

requirements traceability matrix.

. Work on designing processes & sub-processes & confirming it against the

functional requirements.

. Designing Functional Specifications for the target physical database.

. Created processes for capturing mapping between the source data, cleansed

database and target structures.

. Facilitated JAD sessions for Requirement Validation with DHHS to gather

requirements for the new MMIS.

. Decompose policies into business rules for the edits & audits performed

by the new system.

. Analyze different data cross-walks, complicated logic & look ups required

by different fields for the source to target transformations.

. Prepare Risk Assessment artifacts for the different deliverables of the

project WBS.

. Perform in-depth analysis of the ERD (Entity Relationship Diagram) and

validate it against the system design.

. Mapped EDI-X12 data elements against Logical Data Model.

. Designed and implemented HIPAA 835 Payment Advice Transaction, 837 Health

Care Claim Transaction.

. Participated with the project team in the elicitation, analysis,

communication, and validation of requirements for large scale Data

Warehouse.

. Interpreting new and changing business requirements to determine the

impact on Data Warehouse design and proposing creative enhancements and

changes to meet these new requirements.

. Utilized Business Objects to investigate complex historical data to look

for trends, outliers, and patterns.

. Accessed multiple different OLAP sources to generate report to get a

comprehensive view of the business and the cross-impact that one trend

may have on another.

. Performed Compliance-checks on all inbound/outbound HIPAA-regulated EDI

transactions using FACETS.

. Used FACETS Medicaid functionality to efficiently handle claims

processing as well as enrollment, medical-management and workflow

processes.

. Analyze EDI -X12 data elements such as 270,278,837 captured by the

existing system to validate it against the data elements required for new

system.

. Convert the logical request and response documents into the physical XML

schema, compile a Data Dictionary and convert the logical data model into

a physical data model that will be implemented within SQL Server RDBMS.

. Prepare the road map for the physical implementation of the Data

Conversion Strategy.

. Create monthly/weekly status reports to update the project schedules &

deliverable plan.

. Examine the system design deliverables & validating it against the Rfp.

. Map the data and business processes to the MITA (Medicaid Information

Technology Architecture) -aligned architecture and revise the target as

necessary to eliminate any Nebraska MMIS gaps.

. Break down the services from the Nebraska MMIS Logical Design into

multiple layers of normalized functionality that correspond to utility

services, general business services and Medicaid specific services

. Propose strategies to implement HIPAA 4010 in the new mmis system &

eventually move to HIPAA 5010.

Environment: Sybase Power Designer 15, MS Visio 2007, MS SQL Server 2008,

Team Foundation Server, REACT, C#, Visual Studio 2008, Biz talk Server 2006

R2,MS Office Suite 2007,MS Project Professional, MS SharePoint Services,

Visual C#, Web Services, XML, EDI X12,SSIS 2008, Trizzetto FACETS,Business

Objects,Mainframe, DB2, Performance Point Server, Team Test Agent, Windows

Server 2003

Business Analyst,

Baltimore, MD, Jan, 08 - Dec, 08

Franklin Square Hospital Center Inc.

The HI-Exchange Project dealt with development of an online health

information exchange (HIE) and a secure web portal to enable authorized

Franklin Square Hospital providers to have fast and easy access to

patient's electronic health record. The HI-Exchange web portal features EMR

functions and Integrated Clinical decision Support tools for better care

management. The project dealt with development of a Health Care Cost

Containment System and implementation of an automated inter-operable web

application that tracks patient medical history and health care plans via

Viewer application and Electronic health records. The Viewer/EHR system

provided online access to mobile patient records and improved communication

in public health.

Summarizing my responsibilities:

. Conducted user interviews, gathered requirements, and analyzed the

requirements using Visio, Requisite-Pro.

. Worked with the business team to collect the business requirements,

security and service level requirements and documented them using

Requisite-Pro.

. Analyzed set behavior and contribution to business performance, critical

business metrics & tracking underlying business trends using Business

Objects.

. Working with different IT & Business groups to understand and determine

the Impacts to the Data Warehouse and/or Data Marts for different

projects

. Working experience in the Analytical CRM for health care customers and

their custom data management.

. Worked heavily on Clinical Trials using IVR to conduct global clinical

trials and manage the large volumes of data generated.

. Participated in the logical and physical design sessions and developed

design documents.

. Designed new process flows for the existing system as well as for the

enhanced system.

. Conducted and lead status report meetings with the business and the IT

team on a weekly basis.

. Assisted in Clinical Data Management and Clinical Trials Management.

. Performed collection, coding, assessment and reporting of adverse event

data using ARISg.

. Worked in the ARISg Implementation of the EHR-Pharmacy Module.

. Used Clinical Connect to provide connectivity and transfer of information

from the legacy Clinical Data management system to ARISg.

. Used Safety Mart for Clinical Safety Data Management.

. Captured all HIPAA-related EDI data in the repository using FACETS.

. Accepted inbound transactions from multiple sources using FACETS.

. Supported integrated EDI batch processing and real-time EDI using FACETS.

. Recommend tactic to implement HIPAA 4010 ( EDI X12 837,834,278,270) in

the new System

. Worked on Electronic health record system as a CRM web based application.

. Working Experience in Electronic Submissions in standard format E2B.

. Worked on Data design, Architecture design and Staging requirements for

the Data warehouse environment.

. Exposure to HIPAA Compliance requirements and HL 7 standards.

. Assisted project managers with the development of project schedules.

Developed requirements and preliminary design for client applications.

. Performed analysis and design projects using a systems development

methodology. Worked with all levels of client staff in solution

definition.

. Performed Content Management using Documentum.

. Documented test cases during requirements gathering, analysis and design

phases.

. Manage Scope and change throughout the life cycle of the product.

. Translated customer/client needs into new features and new services.

Environment : MS Project, Microsoft Visio,C#,MS SQL Server 2005, iRise,

RUP, Rational Suite (RequisitePro, ClearQuest, Clearcase), Rational Rose,

Oracle 11i/10g, Clearcase, Blueprint, Business Objects, Trizzetto

FACETS,XML,VB.C#,EDI-X12, Windows NT

Business Analyst, Amylin San

Diego, CA, Feb, 07-Jan, 08

Amylin lead drug candidate Symlin (Pramlintide Acetate) is targeted as a

treatment for people with diabetes who use Insulin. In order to keep track

of the huge amounts of data generated in clinical trials, a data warehouse

was developed. Based on the warehouse, the management was able to take

sound decisions regarding budgets and forecasting the company business

decisions. Summarizing Responsibilities:

. Conducted user interviews, gathered requirements, and analyzed the

requirements using Rational Rose & Requisite Pro - RUP in Clinical Phases

I, II, III

. Formulated documents as per business requirements for existing and future

business systems in the Pharmaceutical Environment

. Identified, researched, realized, investigated, analyzed, defined and

documented business processes and Use Case Scenarios under good GxP

Quality Standards

. Participated in full project life cycle, including gathering user

requirements, screen and report design, in addition to implementation and

roll out

. Acted as a liaison between business staff and technical staff to

articulate needs, issues and concerns as per GxP and IRB department

requirements

. Analyzed and prioritized key reports for day to day servicing needs for

products monitoring processing and Inspection, according to the HL7-

industry experience.

. Generated numerous reports, dashboards utilizing Cognos.

. Creating a RFP that clearly defines the services and deliverables

required of a single vendor to design and implement the enterprise DATA

WAREHOUSE

. Providing input to the Data Architect to help create/update

Logical/Physical Data Models for the Data Warehouse and/or Data Marts.

. Was responsible for developing and managing project plans: system

requirements, change management policy standard and procedures by

utilizing Rational Unified Process (RUP).

. A strong emphasis on developing and producing daily, weekly, monthly

reports for different departments, especially the Regulatory Department

was practiced and documented in (EDMS) Electronic Document Management

System.

. Ensured better compatibility and easier maintenance of application within

the IT structure.

. Documented, reviewed, and verified testing procedures for compliance to

Interface Quality Assurance and Development standards and policies and

other required standards

. Integrated static data with other systems to maintain a central

repository of common data

. Maintained a proactive stance with business relationship(s) to ensure the

business needs are always met within GxP Quality guidelines

. Assisted with user testing of systems (UAT), developing and maintaining

quality procedures, and ensuring that appropriate documentation is in

place

. Assisted the IS and Technical team in understanding and developing the

functionality

. Conducted JAD sessions with business unit owners and portfolio team to

capture business requirements and system behavior

. Created client documentation, acceptance tests plan and user procedures.

Served as a tester for systems and user acceptance as per 21 CFR Part 11

. Maintained a good working relationship with departments such as,

Research, Clinical Trial, and Regulatory departments and often

communicated with them and provided technical support throughout the

product development

. Documented application features and operations in detail, including

screen layouts, business rules, process diagrams, pseudo code and other

documentation

Environment: Rational Unified Process (RUP), Rational Suite (RequisitePro,

ClearQuest), MS Office Suite, MS Visio, MS Project,, Windows XP, Oracle

9i, Mercury Test Director, XML,MS SQL Server 2005, Rational Rose,

Clearcase, MS Access, iRise, Cognos

Business Analyst, InterMune Pharmaceutical

Brisbane, CA, Mar, 06- Feb, 07

InterMune Pharmaceutical's core business segments include an active

pharmaceutical ingredients business, Inc., develop and commercialize

innovative products for the treatment of serious pulmonary and infectious

diseases and congenital disorders.

Responsibilities:

. Involved in Business Process Re-engineering initiatives and collection of

data by using Oracle PL/SQL.

. Maintaining the Requirements Traceability Matrix across the deliverables

of a project.

. Validated all operating model considerations and process documentation

. Performed Gap Analysis for new functionality requirements, as well as

prioritized them based on actual business needs so as to align them with

the product release roadmap.

. Worked closely with pharma data like IMS & MHS looking for market trends,

doing market research, generate reports.

. Conduct analysis and to gather & document requirements to provide &

support ETL data movement and Data Warehouse services.

. Created holistic dashboards/analysis by pulling data from different data

sources using Business Intelligence tools such as Business Objects &

Cognos for presentations to senior management team.

. Used Rational Unified Process (RUP)/UML to make an Object Oriented model

for the application and used UML/Rational Rose for creating the Use

Cases, Class diagrams, Sequence diagrams etc.

. Performed system analyses on the architecture and its functionality.

. Involved in analysis of Test Plans and Test cases, detecting bugs in the

system, preparing the Defect reports using Test Director and interacted

with developers for Debugging.

. Participate in weekly meetings with management to inform stakeholders of

overall project progress.

. Developed and wrote test cases for the testing efforts in compliance with

the rules and regulations of CMM.

. Used tools such as MS-Visio, Excel to define business use cases, activity

diagrams, and sequence and state diagrams.

. Develop PowerPoint presentations for District Manager for monthly

meetings with upper management.

. Wrote Gap analysis for Projects and to assist in problem resolution, as

well as providing updates of Project progress in MS 2000 Project

documents

Environment : Rational Unified Process (RUP), Rational Suite (RequistePro,

ClearQuest, Clearcase), MS Office Suite, MS Visio, MS Project, Oracle 9i,

Mercury Test Manager, MS SQL Server 2005,IBM Rational Team Suite, MS

Access, MS Share-point

Business Analyst, Medimmune

Gaithersburg, MD, April, 05 - Mar, 06

Medimmune is a recognized leader in the biotechnology industry, they use

the latest advances in science, technology and medicine to develop

innovative products that improve the quality of human health.

Project: Worked in IT addressing the technology needed within the area of

Medical and Regulatory affairs. The project involved implementation of a

set of capabilities to improve, its Data Analysis and Reporting business

within the Clinical Research and Development Process as per FDA, GxP, & 21

CRF Part 11 requirements. Responsibilities:

. Involved in Inception phase of SDLC process to gather requirements and

document them.

. Documented the user requirements, prioritized them and converted them as

system requirements that must be included while developing the software.

. Supported query generation and integrated analysis, as well as basic

report authoring and information-sharing over intranets and extranets

using Business Objects.

. Collected and documented policies, calculation methods, business

processes as well as business rules. Responsible for identifying and

documenting business rules for EDMS implementations.

. JAD sessions between the business users, Vender Team, & Subject Matter

Experts.

. Managed the changes to such specifications; track the life of a

requirement both forwards and backwards; Projects like IRMS and

Publication Management part of Electronic Document Management System

(EDMS) and documented the validation plan.

. Ensured that project/requirement(s) are properly tracked and documented

as per six sigma and Project Manager's needs.

. Created client documentation, acceptance tests plan and user procedures.

Served as a tester for systems and user acceptance as per 21 CFR Part 11.

. Managed Argus and Electronic Document Management System (EDMS) for

automating R&D and Regulatory document repositories for submissions to

the FDA.

. Documented application features and operations in detail, including

screen layouts, business rules, process diagrams, pseudo code and other

documentation.

. Applied Business Rules and met with the different pharmaceutical

departments in order to understand and obtain necessary regulatory

information to construct quality requirement documentation

Environment : Rational Unified Process (RUP), Rational Suite (RequisitePro,

Clearcase, ClearQuest, Clearcase ), MS Office Suite, MS Visio, MS Project,, Windows XP, Oracle 9i, Mercury Test Director MS SQL Server 2005,

Rational Rose, MS Access, iRise, Business Objects

Business Analyst, Aureus Medical Group HR

Omaha, Ne, Apr, 03-April, 05

The project dealt with development of a Health Care Access EHR project and

implementation of an automated inter-operable web application that tracks

patient medical history and health care plans via electronic health

records. The EHR system implementation helped in retaining patient data for

future reference thereby reducing the amount of medical errors, oversights,

poor quality preventive care and poor communication. It also provided

online access to mobile patient records and improving communication in

public health. All the reporting of adverse event data was collected in

Drug Safety database using ARISg.

. Gathered business requirements through JAD sessions and one-on-one

interviews with the Business Stakeholders and tracked the requirements

using DOORS.

. Worked on Web based Knowledge management system Live Link.

. Worked with the business team to collect the business requirements,

security and service level requirements and documented them using

Requisite-Pro.

. Conducted and lead status report meetings with the business and the IT

team on a weekly basis.

. Co-authored Data design, Architecture design and Staging requirements for

the Data warehouse environment.

. Generated reports using BI tools such as Cognos & Business Objects

. Exposure to HIPAA Compliance requirements and HL 7 standards.

. Used IVR to help customers receive anonymous calls about their test

results or content update.

. Performed Document Management and version control using Share Point.

. Responsible for addressing, diagnosing and resolving issues that arise on

a day to day basis for the team. Also responsible for documenting the

causes, analysis and final resolution to the issues/errors.

. Identified areas of risk exposure and loss techniques adopted.

Environment : Rational Rose, Requisite-Pro, Rational Unified Process (RUP),

Documentum, ARISg, MS Project, Test Director, MYSQL, ORACLE 10g, Windows

NT/2000, Enterprise Architect,SQL Server 2005,MS Access, MS SharePoint,CaliberRM, Requisite Pro, Clearcase, ClearQuest, Test Manager, Telelogic,

Cognos, Business Objects

.

Contact this candidate