New Britain, CT 860-***-****

ad22a0@r.postjobfree.com

http://www.linkedin.com/in/earlott/

Work Experience

Business Systems Data Analyst, Product Owner, Scrum Master and Coach

Summary

Results oriented IT Professional with extensive experience understanding requirements and delivering quality solutions. Known for depth and breadth of technical skill coupled with a unique ability to participate in and lead teams. Over 20 years of experience in Relational Database Design, Systems Development, ETL, Querying and Reporting. Focus on Business Systems Data Analyst, Product Owner, Scrum Master, Scrum Coach and Project Management roles for the past 14 years.

Core competencies:

Azure Dev Ops

Business Analysis

Systems Analysis

Data Analysis

Scrum Master Certified

Project Management

Data mapping

Lead JAD sessions

Negotiating

Strong communicator

Relational Database Design

Microsoft Office

Microsoft Visio

MS SQL Server 2012

SQL

SDLC

Professional Scrum Master I

Agile Methodology

Waterfall Methodology

Project Details

2020 December – 2023 August Aetna Hartford, CT (Infosys Consultant) - Insurance Company

IT Project Manager for AIS End to End Delivery Team

oClinical & Care management Domain with extensive customer interfacing / client facing

oAs a member of this team, I successfully coordinated all development teams through Story creation and implementation of the requirements for implementing the Virtual Care and Virtual Primary Care for new expansion. This expansion allowed access to these systems to additional funding methods, segments, plan types and functionality.

oThis required meetings with the Business Management team to ensure that all requirements are met by the development teams and all Stories are created and completed. This also required insuring that all the development teams involved across platforms were aware of what was happening on other teams and that there would be no impacts.

oAzure Dev Ops

Business Analyst/Agile Coach for Creating new Underwriting workflow and Underwriting System requirements for the Medicare team

oUnderwriting Automation Domain with extensive customer interfacing / client facing

oIn this role I worked closely with stakeholders, SMEs and development teams, interface designer and Architect to create requirements to replace existing Excel and Access systems with .Net and SQL Server. I documented all current processes written in MS Excel and MS Access so the Architect could put together a plan for the new .Net and MS SQL Server application design and system Flow. I worked with the User Interface designer to map out the new system flow and then turned this documentation into User Stories that were used to implement the project. My role on the team was to complete this initial phase.

oI was the Agile Coach for the team who instructed them all on the Agile Methodology including Epic, Feature and Story creation and how all the ceremonies worked to complete the work.

oAzure Dev Ops

oData governance

Product Owner/Business Analyst/Scrum Master/Agile Coach for SI Tech Reports

oReporting Domain with extensive customer interfacing / client facing.

oSI Tech Reporting is a workstream system written in C#

oThis project initially had failed to meet the business need, so I was brought in to work closely with stakeholders to identify what issues had been identified and any enhancements that had not yet been implemented. I pulled together a new development team to address these issues and enhancements. Initially a user interface designer was brought on to address the system flow issues and a new design was approved by the business team. I used the list of issues and enhancements along with the new interface design improvements to create Epics, Features and Stories to complete the development work. I played the role of Scrum Master to instruct the new development team on Agile methodology processes and ceremonies and oversaw the ceremonies were carried out. I oversaw the Sprint iterations and moved all changes into production before handing the completed production system over to the business team and the lone developer who would handle and updates to the system going forward.

oData governance

oEpic, Feature and Story creation

oRun daily stand ups and ceremonies as needed

oAzure Dev Ops

Product Owner/Business Analyst for ODI and Power Tool Systems

oEnrollment & Benefit Administration Domain with extensive customer interfacing / client facing.

oWorked closely with stakeholders, SMEs and development teams.

oThis position required working with external international teams in distributed model including QA and Development. I oversaw all day-to-day requirements including any system enhancements the business team required and any production issues that were identified. I met weekly with the business team to discuss the status of existing items and to identify any new items or changes in priorities that needed to be addressed. I met monthly with the executive team to give a high level status of what had bee accomplished for the month and any possible issues that were in deed of attention.

oODI is a workstream system written in C#.

oPower Tools is a C# screen scraping system to populate Benefit data on DB2 database.

2019 May – 2020 March (Net2Source Consultant) – Aetna Insurance Company

Product Owner/Business Analyst/Scrum Master/Agile Coach

Worked closely with stakeholders, SMEs and development teams

Oversee the projects worked on in four different workstreams on the Pay Flex Data team that had 27 members working in the SAFe Agile Methodology

Overview

oI was brought in as the sole Business Analyst on a team of 25 people that were mostly all new to Agile Methodology. The Scrum Master only had experience working with experienced Agile teams and no experience with teams new to Agile. I have worked with new Agile teams in the past so I helped bring the team up to speed on how to implement Agile on a new team. Since the team was so large I created multiple smaller teams. They were meeting with all 25 members on their daily stand ups in one meeting. I converted this into multiple stand up meetings focusing on each development team. I created a flow or the ceremonies for each team so they could understand how all the requirements are gathered in various grooming meetings as outlined in the Agile Methodology and implemented ceremonies for each team. This was all done over about a 6 month process so while the was happening I also kept the flow of work into each teamd so no projects fell behind. My management team and Product owners were on board with the changes I was making and it helped it to all go very smoothly.

oThis position required working with external International teams in distributed model including QA and Development

oDatawarehouse project included centralizing all the data reported on within the PayFlex company and used for data feeds, Tableau Reports, Talend, Globalscape and SSRS

oData Feeds team was responsible for all incoming and outgoing data feeds. Working with external vendors to feed data into our internal systems. Creating files to send to external vendors from internal systems.

oAd hoc reporting team would create small data requests for internal business users

oProduction support team would deal with all new production implementations and correct any issues arising from nightly production runs.

MarkLogic Big Data – Worked with architect for initial set up of server, design of data lake and loading of data from source systems and content management

oSource to target data mapping and analysis on Data Warehouse

oIncludes creating data mapping and Business Requirements Definition documents as well as other documentation defining business process flows and data flow diagrams.

oThis project required knowledge of MS SQL Server and creating SQL commands, XML, JSON, Azure Dev Ops

oData governance

Cigna Bloomfield, CT (Apex Consultant) - Insurance Company

2018 May – May 2019

Product Owner/Business Analyst/Scrum Master/Agile Coach

Worked closely with stakeholders, SMEs and development teams

Enrollment & Benefit Administration and Claims processing Domain with extensive customer interfacing / client facing

Internal facing Member & Provider Portals/Service

This position required taking on the role of Product Owner as well as Analyst working in the SAFe Agile Methodology

This position required working with external International teams in distributed model including QA and Development

Responsible for the Web based application used by member representatives to answer member questions regarding benefits and claims

This project required knowledge of MS SQL Server and creating SQL commands and XML, JSON

XML, Mainframe services, Java website

This position required taking on the role of Product Owner as well as Analyst working in the SAFe Agile Methodology

This position required working with external International teams in distributed model including QA and Development

Responsible for the Web based application used by member representatives to answer member questions regarding benefits and claims

This project required knowledge of MS SQL Server and creating SQL commands and XML, JSON

XML, Mainframe services, Java website

Connecticare Farmington, CT (Talus Partners LLC Consultant) – Insurance Company

2017 May – 2018 March

Product Owner/Business Data Analyst

Worked closely with stakeholders, SMEs and development teams

Enrollment & Benefit Administration, Claims processing & Reimbursements, Member & Provider Portals/Service, Clinical & Care management, Funding & Billing and Reporting with extensive customer interfacing / client facing

This position required taking on the role of Product Owner as well as Business Data Analyst with extensive customer interfacing / client facing

Responsible for working with external vendors providing data feeds

oJAD sessions with vendors to verify all data feeds match internal and external systems.

oIdentifying gaps so that default values could be created for required fields not existing in one of the databases and XML

oOverseeing the work from the external vendors to ensure all work met expectations

oOverseeing all requirement gathering JAD sessions and responsible for the project plans and deliverables

oData governance

Cigna Bloomfield, CT (Judge Group Consultant) - Insurance Company

2016 July – 2017 May

Product Owner/Business Analyst

Worked closely with stakeholders, SMEs and development teams

Claims, Membership, Eligibility and Benefits with extensive customer interfacing / client facing

This position required taking on the role of Product Owner as well as Analyst working in the SAFe Agile Methodology

This position required working with external International teams in distributed model including QA and Development working in the SAFe Agile Methodology

Responsibilities include identifying source data for Oracle RDS and defining load procedure from source system for EDI transfer. Also document all processes. This data is comprised mostly of Insurance Claim Authorization information. The data is retrieved Informatica jobs from the TruCare SQL Server Database and loaded into an Oracle database.

oThis position required working with International teams in distributed model including QA and Development

oThis project required knowledge of MS SQL Server and creating SQL commands and XML, JSON

Responsibilities include identifying source data for Oracle RDS and defining load procedure from source system for EDI transfer. Also document all processes. This data is comprised mostly of Insurance Claim Authorization information. The data is retrieved Informatica jobs from the TruCare SQL Server Database and loaded into an Oracle database.

XML, Mainframe services, Java website

Fidelity Smithfield, RI (Eliassen Group Consultant) - Investment Company

2015 June – 2016 April

Product Owner/Business Analyst

Worked closely with stakeholders, SMEs and development teams

Customer Investment and customer care

Extensive customer interfacing / client facing

This position required taking on the role of Product Owner as well as Analyst working in the SAFe Agile Methodology

This position required working with external International teams in distributed model including QA and Development working in the Agile Methodology

This position oversees the management of Fidelity information to answer customer questions on the company’s customer Help Desk.

oThis position required working with International teams in distributed model including QA and Development

oThis project required knowledge of MS SQL Server and creating SQL commands and XML, JSON

Connecticare Farmington, CT (Consultant) –

Insurance Company

2015 February – May/2015

Worked closely with stakeholders, SMEs and development teams

Claims, Membership, Eligibility and Benefits with extensive customer interfacing / client facing

Responsible for the Web based application used by member representatives to answer member questions regarding benefits and claims working in the Agile Methodology

oWorked with external vendor to bring in-house requirements to completion

oXML

Law office of Neal E. Guttenberg, Branford, CT (Consultant) 2014 October – 2015 February

Lead Developer/Analyst

Cigna, Windsor, CT (employee) –March 2012 – September 2014

Business Systems Data Analyst/Product Owner

External facing Member & Provider Portals/Service

Working in the Agile Methodology

XML, Mainframe services, Java website

HIPPA EDI transactions such as 834,835, 837, 276,277,278, 278

ESPN, Bristol, CT (Experis-contract) April 2011 – March 2012

Data Analyst/Data architect

As Sales with Extensive customer interfacing / client facing

Working in the Agile Methodology

XML

Data governance

Prior Positions

UTC, Farmington, CT (ITWorx -employee) April 2010 – April 2011

Data Analyst/Data architect

SQL Server, Stored Procedures, ETL

University of Connecticut, Storrs, CT (employee) February 2009 - January 2010

Data Analyst/Data architect

SQL Server, Stored Procedures, ETL

Working in the Agile Methodology

eRichards Consulting, Shelton, CT (consultant) October 2008 - January 2009

SQL Server, Stored Procedures, .Net, Object-Oriented development

Travelers, Hartford, CT (NEOS-consultant) July 2008 - August 2008

Systems Analyst, Teradata

ING Investments, Hartford, CT (employee) July 2006 - July 2008

SQL Server, Stored Procedures, ETL, XML, XSLT

.Net, Object-Oriented development

EBD, Avon, CT (Tallan-consultant) April 2006 - July 2006

SQL Server, Stored Procedures, ETL

.Net, Object-Oriented development

Cigna, Bloomfield, CT (The Cimino Group- consultant) November 2005 - April 2006

Oracle, Stored Procedures, ETL, .Net

.Net, Object-Oriented development

Financial Partners, Agawam, MA (The Systems Group- consultant) February 2005 - November 2005

SQL Server, Stored Procedures, ETL

Prime Resources Corporation, Bridgeport, CT (consultant) January 2005 - February 2005

SQL Server, Stored Procedures, ETL

Conning, Hartford, CT (TekSystems- consultant) April 2004 - December 2004

SQL Server, Stored Procedures, ETL

.Net, Object-Oriented development

Prime Resources Corporation, Bridgeport, CT November 2003 - April 2004

SQL Server, Stored Procedures, ETL

Anthem Behavioral Health, West Hartford, CT May 2001 - September 2003

Claims, Funding and Billing, Senior Database/Application Developer/Technical Architect/ Data architect/Project Lead/Business Analyst

Powerbuilder, Object-Oriented development

Healthcare payer domain experience:

Enrollment & Benefit Administration

Claims processing & Reimbursements

Member & Provider Portals/Service

Clinical & Care management

Funding & Billing

Reporting

Methodologies

Agile

Waterfall

Certification

Professional Scrum Master I - Scrum.org – 04/23/2020

Education

Teikyo Post University, Waterbury, CT.

BS Marketing

Visa Status

U. S. Citizen

Contact this candidate