Data Analyst Groton Ct
Skills
Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.
Skill
Years Used
Last Used
Tracking and prioritizing issues from discovery through resolution
Assignment and tracking of action items, issues, and risks
Status reporting to stakeholders
Conduct stakeholder meetings, including meeting agenda, minutes, and action items
Meeting facilitation and proactive follow up with individual providers
Excellent organization and communication skills
Direct provider outreach
Newsletter/website communication with provider community
Creating, updating, and coordinating communication plans; all aspects of functional testing, schedules, and success criteria
Creating, updating and coordinating communication plans; including acceptance procedures, validation trend analysis, error resolution, etc
Creating RACI charts, process flow charts, swim lane diagrams, memorandums, etc.
Knowledge and experience with HL7 messaging
Government experience in the healthcare arena
Statistical analysis of issues to identify hotspots, weaknesses, issues, and risks
Employment HistoryConfidential,
Groton, CT May 2012 - Present
Data Analyst
Pfizer Incorporated is a global pharmaceutical company committed in applying science and utilizing its global resources to improve health and well-being at every stage of life. The project was RDM: The Clinical Study Reference Data Module (RDM) provides a consistent foundation for key reference data domains (e.g. Drug Program, Clinical Studies, Countries, Investigator, etc.). This component allows aggregate querying and reporting across data providers in a consistent manner. This component is based on Informatica Master Data Management Solution. The RDM will continually acquire, maintain, and disseminate reference data, which when used within the Clinical Aggregation Layer (CAL) and throughout the broader business, will enable more consistent operations, analysis and reporting. Project goal was to gather business requirements for successful release.
Responsibilities:
- Understood and articulated business requirements from user interviews and then converted requirements into system requirements.
- Designed and developed business flow diagrams, wireframes, mock ups, user interface design, activity diagrams, sequence diagrams, Object Oriented models using MS Visio.
- Conducted JAD sessions with end user community ensuring that the software addressed all business needs, analysis of the potential users of the system either through discussion.
- Clarified client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all stakeholders.
- Collaborated with Sales and Marketing teams, external ad agencies, third-party technology distributors to facilitate communication for successful project launches.
- Developed process procedures in compliance with FDA regulations using standard documentation like Standard Operating Procedures (SOP’s)
- Strategized project scoping and specifications documents, logical data model, to clearly communicate the project roadmap.
- Developed Requirement Traceability Matrix (RTM) to track requirements against standard procedures
- Met with all developers, offshore team and project stakeholders to lead a kickoff meeting. Defined and introduced the project, team members' roles, and key deliverables. Mapped out timelines, milestones, communication processes, question and answer session.
- Generated excitement and buy-in to secure commitment to project objectives, and shared a group vision to start the team on a motivated track.
Environment: MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio, BIE), MS-Project, Windows 2000, OBIEE, Business Objects, SharePoint, Epic, LIMS, cGxP (cGMP, cGDP, cGAMP, cGLP), GAMP, Microsoft EDW, MS SharePoint, Six Sigma, .Net 4.0, RUP, Agile, SDLC, TFS, Microsoft Test Manager, People Soft.
Confidential,
CA June 2010 – March 2012 Senior Business Analyst
Visa is a global payments technology company that connects consumers, businesses, banks and governments in more than 200 countries and territories, enabling them to use digital currency instead of cash and checks. As a Business Analyst for the visa specializing in credit cards, also ensure that deliverables are being produced within time, quality and budget. Led upgrade projects, conducted weekly status meetings for management, analyzed budget variances, and developed status reports and test plans. The project is a Graphical User Interface application developed for end customer use to carry on online transactions which provides all the details of the expenses of the customer and also the various reports of the various expenses along with the tax of the expenses.
Responsibilities:
- Identify the client/organizational needs and provide suitable agile system based solutions.
- Requirements gathering, user interface design and deployments of reports using Crystal Reports.
- For undefined requirements and use cases, conduct ad hoc interviews with Digital Tech and business SMEs to define like-for-like and to-be requirements.
- Create UAT Test Strategy, UAT Test Plans and UAT defect reporting.
- Involved in designing and Writing System test Scripts.
- Fully involved in UAT testing phase to support client
- Handle the tasks of explaining UAT scope, criteria and entry/exit strategy to less trained professionals
- Document Use Cases, Requirements, Stories and Exit Criteria in JIRA
- Organizing and managing JIRA stories into their respective sprints. Handling the movement of stories as they migrate across sprints.
- Update JIRA stories with decisions, progress, changes and/or completion.
- Created a Standard Procedures Manual in collaboration with the three departments within Affinity to capture their AS-IS processes and procedures. This manual is used to on-board all new Affinity members and serves as a point of reference for activities pertaining to the acquisition and servicing of new military Affinity groups. MS Visio was the primary tool used to create process diagrams and illustrate work flows.
- Responsible for oversight of multiple Affinity related projects dealing with compliance, credit card releases and credit card enhancements; serve as the SME and primary point of contact for the Affinity Group.
- Provided guidance for existing processes by documenting issues and suggesting improvements.
- Designed TO-BE processes to add value to existing systems with JAD sessions between various departments such as IT, Compliance, Product Management and Legal.
- Responsible for review and approval of Web Content pages in collaboration with the QA team, edited web content pages and web layout, design cube using SSAS. Created architecture, server side software, client side software, and database.
- Data modeling, Data Mappings, Source to target mappings, Traceability matrix.
- Grasp of data modeling essentials and ability to map source data into a target model.
- Provide weekly updates to senior management in the form of impact analyses, progress reports and feedback from customers.
- Lead/participate in meetings to ensure that Affinity is in compliance with new governmental regulations for credit cards.
- Assisted the Operations Lead in business process change management by co-coordinating with Pricing, Print Production Services and Product Management, forecasting and trending modeling.
Environment: MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio, BIE), MS-Project, Windows 2000, Business Objects ,Epic, Adobe CS3,Microsoft EDW, MS SharePoint ,MS-Project, Six Sigma, SSAS,.Net 4.0, JIRA, RUP, Agile, SDLC, TFS, Microsoft Test Manager, People Soft.
Confidential,
Business Analyst
United Health Group have led the marketplace by introducing key innovations that make health care services more accessible and affordable for customers, improve the quality and coordination of health care services, and help individuals and their physicians make more informed health care decisions. The project was to manage the content on the Web so teams across the globe could collaborate and contribute to the process in a more meaningful way.
Responsibilities:
- Make certain the user stories are good, comply with acceptance criteria, have sufficient business value and selling points.
- Prepared interview questionnaires for the users and gathered requirements to write specifications and to shape software development process.
- Project to build and operate data centers for data warehouses for Medicaid data.
- Design and Implementation of SharePoint server farm for collaboration and document management.
- Platform ahead of schedule, substantially improving accountant productivity.
- Worked on implementing HIPAA standards, HL7 in facets,ICD-9,ICD-10 TANF, Medicaid requirements, Medicare Part D claims, Medicaid Management Information System
- Sourced and analyzed multiple data sources for inclusion into an enterprise data model or data warehouse
- Experience in source system analysis, source target mappings and some light data model work on multiple sources in health care.
- Understand the software requirements of the healthcare unit and make note of the features expected in the EPIC module
- Design the epic modules based on the requirements and ensure it matches the end user's expectations.
- Developed SAS programs to listings/graphs to create study specific datasets, which were used as source datasets for report generation.
- Documented business workflows textually as well as in UML diagrams, according to RUP for a better understanding of the user community.
- Documented timely reports using MS Project 2000.
- Involved in executing test cases, evaluating test results and preparing test summary reports, GAP Analysis.
- Organized meetings with the development teams to elicit use cases and document them.
- Worked as a liaison between developers and users.
- Checked business readiness and determined activities of flow.
- Created and managed project template, use case project templates, requirement types and traceability relationships in Requisite Pro.
- Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams using MS Visio.
- Appointed to modernize and enhance its technology infrastructure that would result in a centralized and paper less system.
Environment: RUP, Rational Requisite Pro, Rational XDE, Rational Rose, Optimal Trace Software, Rational Clear Quest, Agile, Java, COTS, facets , Epic, crystal reports 6.0, Oracle, Adobe CS3, MS Project, People Soft, MS Office Suite, EMR/EHR, QNXT, Business Objects.
Confidential,
Business Analyst
The Department of Health is the government organization for protecting the health of all Americans and providing essential human services. DOH covers Wadsworth Center-Division of Laboratory Operations, running on Clinical Laboratory Information Management System (CLIMS) where the aim of the project was to manage multiple projects in epidemiology department, newborn screening department and claim processing.
Responsibilities:
- Served as a liaison between the internal and external business community of CLIMS Remote Order Entry (ROE) project and ECLRS outbreak management system involving HL-7 messaging.
- Completed the documentation of claim scenarios for source system. Facilitate meetings with internal and external groups and communicate project status to upper management.
- Identified, researched, investigated, analyzed, defined and documented business processes and use case scenarios.
- Conducted user interviews, gap analysis, attended Joint Application Development (JAD) sessions, created agendas and documented analysis in requirement gathering for both CLIMS ROE and ECLRS project.
- Worked on EDI transactions like 834, 835 and 837 to identify key data set elements for designated record set.
- Documented the user requirements into Functional Requirements Document (FRD) and Non-Functional Requirements Document (NFRD) for the development team to better understand the application requirements.
- Created Data Flow Diagrams (DFDs), ER diagrams for database modeling and Web-page mock-ups using MS Visio for acceptance from analysts, surveyors and stakeholders.
- Used Rational Clear Quest for defect tracking and managing the assignment reminders of defects to team.
- Conducted User Acceptance Testing (UAT), end to end testing and user training pertaining to old and new CLIMS ROE & test catalog.
Environment: Java, J2EE, Windows XP, UNIX, SQL Server, MS Office, Visio, Clear Quest, MS Office suite, MS Project, Java, Erwin, SQL, Windows NT, Oracle, UML, Rational Clear Quest
Confidential,
February 2005 – September 2007
Sr. Business System Analyst
The project was designed and executed by BLCPro Ltd., the scope of the project was archival of current I*Net production applications, production database, selected protocol production reports; all current production source code and LiveLink documentation into an OpenLAB repository environment. Complete shutdown of I*Net application system and its environments, decommission and retirement of all associated servers and infrastructure related items. Retiring INET will allow the use of a single EDC system and will simplify the current business process. Migration of all active study data to Oracle Clinical. The retirement of INET will simplify this process as OC/RDC will become the sole solution for supporting all EDC studies.
Responsibilities:
- Understood and articulated business requirements from user interviews and then convert requirements into user interface design technical specifications.
- Use agile systems and strategies to provide quick and feasible solutions, based on agile system, to the organization.
- Worked with Business Users in articulating the Clinical Trail life cycle process in Oracle Clinical.
- Identified the Clinical Trial documents in the existing system like CRF notebooks, design documents, QA audit trials and other documentations in order to retire the INET clinical Trial system.
- Strong understanding of metadata and database structure for migration of data structure to Oracle Clinical.
- Worked with technical team to verify and validate the metadata and database against the SAS datasets.
- Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS and Excel.
- Held team meeting with the SMEs to understand the Verifications and Validation process before the close out of a protocol or study.
- Proposed BPR in the few clinical trial process areas to address both system and business needs
- Interacted with EDC business heads to finalize the Business Requirements for the application. Conducted joint requirements planning sessions as a facilitator to gather requirements.
- Interacted with SME’s of different departments (Business, Information Technology, Quality and Operations).
- Efficiently responded to client inquiries and resolved discrepancies. Identified, prioritized, tested and proved essential business functions to assure compliance with FDA and internal auditing.
- Developed SOPs for archival and retrieval procedures from INET(CTMS) to OpenLAB (Archival Library).
- Assisted project manager in preparing and developing the Project scope definition, Project Management Plan, Project Traceability Matrix and Resource Allocation Plan.
- Established a business Analysis methodology around the ELC (Enterprise Life Cycle). Helped develop use cases, project plans and manage scope.
- Developed Use Cases, Use Cases diagrams, Class diagrams, Activity diagrams, Sequence diagrams using tools. Experience in conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions.
- Worked closely with the Third party application team to model the screens, which met user, defined requirements and also company standards to retrieve data once the application is retired.
- Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
- Performed System and Integration Testing along with testers. Conducted UAT with the business users and tracked/managed maintenance request (MR) and change request (CR).
- Migrated SharePoint sites from test server to production.
- Developed user manuals, presentations and training manuals as per project specifications and timelines.
Environment: Informatica, IDBS Biobook ,Agile, Business Objects, LIMS, Oracle 9i, 10i/g, ASP, HTML, SQL/PLSQL, MS Visio, and Windows XP/2000, XML, XSLT, MS Project, MS Office Suite (Word, Excel, Access, PowerPoint, and Outlook).
Confidential,
January 2004 – January 2005
Business Analyst (Financial and credit services)
ICICI Bank offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries in the areas of investment banking, life and non-life insurance, venture capital and asset management.
Prepared layout plans for a paperless facility for the insurance sector. This project was the first step in the implementation of a document management system and enterprise solution system that could be used across any location or branch.
Responsibilities:
- DevelopedBusinessrequirements by exploratory methods from existing system, existing statement of work, client change requests and other documents like screen specifications etc.
- Developed use cases, security and functional requirements using MS Excel, Word and PowerPoint
- Migrated Word requirements into Rational Requisite Pro.
- Managed QA resources and QA management plan and Project risk management plans
- Updated Project scope documents according to the approved change requests and fixed defects
- Determined system testing needs and generated test outline and specifications.
- Identified and gathered test data needed to support the testing effort.
- Held daily scrum meeting with the Project team and change management team to discuss the requirement updates, change requests, tasks and assign/re-assign man hours on a daily basis.
- Led the UAT testing schedules depending on the system testing deadlines and product support.
- Managed and updated Project plan documents including project schedule and cost management.
- Automated web front end and web services testing using Mercury Win runner.
- Monitored offshore development team in implementing the WEB front end user interface requirements.
Environment: Java, DB2, XML, Quick Test Professional, Test Director, Requisite Pro, ASP .net, Load Runner, Caliber RM, PC Client, Bus tester, Test harness, UNIX, Camilion.