FAITUS JELINE JOSEPH Ph#: 781-***-****

addgjy@r.postjobfree.com

https://www.linkedin.com/in/faitus-jeline-joseph-6155401a9/

Summary:

Having 14+ years’ experience in IT industry primarily working in the Healthcare domain in various Data-warehousing and Business Intelligence projects, I have extensive experience in Informatica, Netezza, Tableau, Business Objects, OBIEE 11G, Teradata, Oracle, MicroStrategy & Cognos with key emphasis on ETL and BI space.

PROFESSIONAL EXPERIENCE:

oWorking in Cognizant Technology Solutions US Corp from March 2006 to till date

Name of the Company

Client Name

Projects

Duration (Years. Months)

Cognizant Technology Solutions US Corp.

Blue Shield of California

BCBSA Provider Directory File Action Plan

Taxonomy Code Project

Legacy Provider Data Replacement (LPDR)

Provider Information Management System (PIMS)

7+ Years

Cognizant Technology Solutions US Corp.

MassMutual Financial Group

Strategic Information Delivery (SID)

1 Year

Cognizant Technology Solutions US Corp.

Aetna Inc.

Aetna – Informatics

1 Year

Cognizant Technology Solutions US Corp.

Blue Cross Blue Shield of Massachusetts

EDI 5010 IDS+ Data Migration

2 Years

Cognizant Technology Solutions India Pvt. Ltd.

American Express

BIS Reporting Services

GABM Marketing Resource Management (MRM) Reporting

‘By Invitation Only’ (BIO) Reporting

2 Years

Cognizant Technology Solutions India Pvt. Ltd.

Key Bank

Migration of Business Objects reports to Cognos 8

1 Year

TECHNICAL SKILLS:

Operating Systems

Windows / Unix

Programming Languages

C, C++, JAVA, Python 3, IBM Mainframe, Visual Basic V 6.0

Databases

Netezza, Teradata, Oracle 11G, SQL Server,

IBM DB2, PL/SQL

Data Warehousing Tools

Business Objects, OBIEE 11G, MicroStrategy 8, Informatica Power Center V 9.6, Cognos 8

Test Management Tools

Application Lifecycle Management V12, JIRA v 6.4

EDUCATION:

oBachelor of Engineering in Computer Science and Engineering, from Anna University, 2005

TECHNICAL CERTIFICATIONS:

oOracle Database 11g: Program with PL/SQL (August 2019)

oCognizant Certified Professional (CCP) in UNIX Shell scripting (October 2017)

oISTQB External Certification – Certified Tester Foundation Level (April 2016)

oOracle 9i: SQL External Certification

oCognizant Certified Professional (CCP) in Data warehousing basics

oCognizant Certified Professional (CCP) in Data warehousing testing

oCognizant Certified Professional (CCP) in Banking and Financial Services L1

ACHIEVEMENTS:

oGot the ABOVE AND BEYOND award for the Quarter 1 2011 from Cognizant recognizing my performance in the project.

oDeveloped a Value Creator tool called Cognos Companion. It is being used in various Cognos projects inside Cognizant for validating the formatting features of the Cognos reports.

oGot Certificate of Appreciation from BCBSMA and Key Corp Clients for the excellent and smart work that really helped reducing the Test execution time.

PROJECT EXPERIENCE:

Project Title

Best in Class Employer Reporting

Client

Blue Shield of California

Duration

JAN 2020 – TILL DATE

Location

Oakland, CA, USA

Role

Informatica developer

Technology

Oracle 11 G, Informatica 9.6, Netezza, ALM, JIRA

PROJECT DESCRIPTION:

The scope of Best-in-class employer reporting project is to enhance the current HDMS vendor extracts based on the new BHI vendor’s tool. The new best-in-class reporting solution will integrate all of the data that the Blue Shield of California Core and Premier accounts need to manage their business into one easy-to-use interface. Blue Shield of California will transmit a series of different data extracts to the vendor who will integrate it into an associative database that can be accessed via a friendly web interface. Security roles will be implemented to verify that each user can only access the data that they should be able to review.

ROLES AND RESPONSIBILITIES:

Coordinate with application team and develop all ETL processes.

Administer all requests and analyze issues and provide efficient resolution

Understanding the data model, data mart, DWH and the end to end follow of data from the source to all the intermediate layers unit the data get populated in Find a Doctor portal and the PDF file.

Prepare codes for all modules according to require specification and client requirements and prepare all required test plans.

Develop all Informatica transformations and system implementation for all Informatica transformations.

Monitor all production issues and inquiries and provide efficient resolution for same.

Evaluate all functional requirements and map documents and perform troubleshoot on all development processes.

Writing SQL queries to validate unit test cases of simple, medium and complex transformation logic to validate the business needs.

Documents all technical specifications and associate project deliverables.

Attending defect triage meeting and daily team meeting and fixing the defects in JIRA.

Project Title

BCBSA Provider Directory File Action Plan

Client

Blue Shield of California

Duration

JAN 2019 – DEC 2019

Location

Oakland, CA, USA

Role

Informatica developer

Technology

Oracle 11 G, Informatica 9.6, Netezza, ALM, JIRA

PROJECT DESCRIPTION:

The scope of this project is to execute BCBSA required action plan to improve provider data quality/matching in the current Provider Directory Format (PDF) submission process. BCBSA requires that 100% of rendering provider IDs (in network) on claims submitted by host plans be included in the PDF which feeds their provider directory repository.

ROLES AND RESPONSIBILITIES:

Coordinate with application team and develop all ETL processes.

Administer all requests and analyze issues and provide efficient resolution

Understanding the data model, data mart, DWH and the end to end follow of data from the source to all the intermediate layers unit the data get populated in Find a Doctor portal and the PDF file.

Prepare codes for all modules according to require specification and client requirements and prepare all required test plans.

Develop all Informatica transformations and system implementation for all Informatica transformations.

Monitor all production issues and inquiries and provide efficient resolution for same.

Evaluate all functional requirements and map documents and perform troubleshoot on all development processes.

Writing SQL queries to validate unit test cases of simple, medium and complex transformation logic to validate the business needs.

Documents all technical specifications and associate project deliverables.

Attending defect triage meeting and daily team meeting and fixing the defects in JIRA.

Project Title

Taxonomy Code Project

Client

Blue Shield of California

Duration

JAN 2018 – DEC 2018

Location

San Francisco, CA, USA

Role

Tableau Developer

Technology

Oracle 11 G, Informatica 9.6, Netezza, ALM, JIRA

PROJECT DESCRIPTION:

The scope of this project is to implement Taxonomy Code on the Submission Format (SF) and Provider Data Format (PDF) files. This will significantly enhance the quality of provider data by accurately identifying the provider specialty on claims and provider records using a standard code set. It will also improve the quality of data for various downstream areas supporting National Programs including, consumer engagement, claim adjudication/benefits determination, data analytics and quality measurement.

ROLES AND RESPONSIBILITIES:

Developing, maintaining, and managing advanced reporting, analytics, dashboards and other BI solutions.

Performing and documenting data analysis, data validation, and data mapping/design.

Reviewing and improving existing systems and collaborating with teams to integrate new systems.

Conducting unit tests and developing database queries to analyze the effects and troubleshoot any issues.

Understanding the data and KPI’s or views which will be shown on final dashboard.

Creating a wireframe/ paper design / design document to finalize the number of dashboards or graphs, graph type & color code.

Conducting and participating in meetings with the Business owners, Product Owners and Product sponsors in order to understand the business requirements.

Documents all technical specifications and associate project deliverables.

Attending defect triage meeting and daily team meeting and fixing the defects in JIRA.

Project Title

Legacy Provider Data Replacement (LPDR)

Client

Blue Shield of California

Duration

JUN 2015 – DEC 2017

Location

San Francisco, CA, USA

Role

UAT lead

Technology

Oracle 11 G, Informatica 9.6, Netezza, ALM, JIRA

PROJECT DESCRIPTION:

BlueShield’s FAD (Find-a-Doctor) process, runs each business day, uses input data from the Legacy provider systems, along with few vendor files, to generate a set of extract files, which are combined with other files by BSC when running its own ETL process that populates BSC’s “Find a Doctor” section of its public website.

ROLES AND RESPONSIBILITIES:

Coordinating all the UAT technical deliverables and supporting the SMEs in validating the business test cases in UAT and in Production environment.

Responsible for preparing the UAT test plan, test strategy & business test cases by eliciting requirements from all the stakeholders.

In-depth knowledge in the data model, data mart, and the end to end follow of data from the source to all the intermediate layers unit the data get populated in Find a Doctor portal and the PDF file.

Responsible for preparing the UAT success criteria and documenting it in JIRA Stories and get it reviewed and approved by the SMEs.

Responsible for requirement analysis, defining the UAT test strategy, planning, execution and maintenance of test logs along with the Business owners, have the responsibility of providing the UAT sign-off.

Writing SQL queries to validate simple, medium and complex transformation logic to validate the business needs

Responsible for preparing the User Acceptance Criteria / Success Criteria and documenting the details in Jira.

Review of test cases designed by the team and guiding the team technically to complete the testing of complex transformations.

Validate the adhoc change requests changes on existing data warehouse and executing the adhoc test cases.

Understand the data flow from source to the extract to validate the data on extracts that are generated from end user perspective.

Conducting defect triage meeting and daily team meeting and maintaining the defects and artifacts in JIRA.

Project Title

Provider Information Management System (PIMS)

Client

Blue Shield of California

Duration

NOV 2013 – MAY 2015

Location

San Francisco, CA, USA

Role

QA Analyst

Technology

Oracle 11 G, Informatica 9.6, Netezza, Business Objects, ALM

PROJECT DESCRIPTION:

Provider Information Management System (PIMS) is a multi-year program developed by McKesson for Blue Shield CA along with Provider Operations System (PROPS). This will serve as a single source of truth provider data solution to manage all relevant provider information.

ROLES AND RESPONSIBILITIES:

Coordinating all the QA technical deliverables and supporting the SMEs in validating the business test cases.

Responsible for preparing the business cases by eliciting requirements from all the stakeholders.

Responsible for requirement analysis, defining strategy, planning, execution and maintenance of test logs. Along with the Business owners, had the responsibility of providing the sign-off on the data and the reports for production migration.

Writing of SQL queries to validate the transformation logic between source and target system/database.

Experienced in slicing the requirement to write SQL queries to validate simple, medium and complex transformation logic to meet the business needs.

Experience in data load validation using Informatica.

Extract the business requirements from requirement documents and technical documents to design test scenarios/cases and supporting SQL queries to validate the data consistency between source and target result sets.

Review of test cases designed by the team and guiding the team technically to complete the testing of complex reports and transformation

To validate the adhoc requests and changes on existing database and validate those requirements with complete artifact.

Supporting multiple projects in parallel for the data team to push all their changes, improvements and bug fixes.

Understand the data flow from database to Business Objects tool to validate the data on reports that are generated by end users.

Project Title

Strategic Information Delivery (SID)

Client

MassMutual Financial Group

Duration

NOV 2012 – NOV 2013

Location

Enfield, CT, USA

Role

QA Lead

Technology

Teradata 13.11, Informatica 9.1.0, OBIEE 11G, Quality Center

PROJECT DESCRIPTION:

Strategic Information Delivery (SID) program is part of Retirement Services (RS) Tech Strategy which is set out to deliver new capabilities for RS in order to meet future business needs. SID will develop centralized data repository, Business Information Factory (BIF), which will serve as a single point of access (book of record) for information maintained and/or analyzed by RS.

ROLES AND RESPONSIBILITIES:

Responsible for requirement analysis, defining strategy, planning, execution and maintenance of test logs. Along with the Business owners, had the responsibility of providing the sign-off on the data and the reports for production migration.

Daily writing of SQL queries to validate the transformation logic between source and target system/database.

Experienced in slicing the requirement to write SQL queries to validate simple, medium and complex transformation logic to meet the business needs.

Experience in data load validation using ETL Informatica.

Extract the business requirements from requirement documents and technical documents to design test scenarios/cases and supporting SQL queries to validate the data consistency between source and target result sets.

Review of test cases designed by the team and guiding the team technically to complete the testing of complex reports and transformation

To validate the adhoc requests and changes on existing database and validate those requirements with complete artifact.

Supporting multiple projects in parallel for the data team to push all their changes, improvements and bug fixes.

Understand the data flow from database to OBIEE BI tool to validate the data on reports that are generated by end users.

Frequently interact with BI developers, Business Analyst and Data Analyst.

Publish the project status report from Quality Center.

Conducting defect triage meeting and maintenance of the defects in Quality Center.

Managing the Offshore and Onsite Team.

Project Title

Aetna – Informatics

Client

Aetna Inc.

Duration

MAY 2012 – OCT 2012

Location

Hartford, CT, USA

Technology

IBM Mainframe, IBM DB2, Quality Center, Clear Quest

PROJECT DESCRIPTION:

Aetna's Enterprise Data Warehouse is loaded with data from different Mainframe source systems like ACAS, CBOR, HMO, HNO and UHSC. It has different subject areas like Providers, Membership, Claims. Aetna Informatics project facilitates the flow of data from different source systems to the Enterprise Data Warehouse after applying the ETL transformation logics. Enterprise Data Warehouse enhancements like adding additional features to the existing Data Warehouse and handle the change requests provided by the Business Users are also in the scope. Data Cleansing, identifying the data inconsistencies and gap analysis are performed and has to be presented to the Subject Matter Experts.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Preparing the Test Strategy and reviewing test cases for all the ETL transformations logics and Business rules mentioned in the Business requirement document.

Preparing test data for all the testing scenarios for the project and coordinating with the Data Management team to load into the tables.

Managing offshore for deployment of all the project modules in CLAIMs subject area.

Understanding the requirements, estimating the project requirements, Test Strategy preparation, Execution of test cases and providing Sign off during production release.

Coordinate with the offshore and bridge the gap between onsite and offshore.

Follow up with the business for getting the test approval before the test case execution for each source systems.

Validating the target database after the first time History load and Daily Incremental load.

Preparing a weekly status report on every Fridays for tracking the effort spent in ETL testing and forwarding it to the business.

Assigning the defects if any to the ETL development team and data architect team after the History and Incremental load.

Attending the weekly defect tracking meeting with the business, ETL development team and data architect team and getting the ETA for the open defects.

Updating the results of the test cases executed in HP Quality Center and validating the requirements traceability.

Project Title

EDI 5010 IDS+ Data Migration

Client

Blue Cross Blue Shield of Massachusetts

Duration

FEB 2010 – APR 2012

Location

Boston, MA, USA

Technology

Informatica Power Center V6, Oracle 11G

PROJECT DESCRIPTION:

The goal of EDI 5010 project is to replaces the existing HIPAA (Health Insurance Portability and Accountability Act) 4010 transaction set to HIPAA 5010 transaction in order to promote greater use of electronic data transactions. The scope of IDS+ ETL testing is to ensure that the data from different mainframe source systems such as TPS, RTMS, HURON, NASCO are properly transformed to the new data store called Information Data Source Plus (IDS +) which will eventually replace the existing 4010 IDS data store.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Writing test cases for all the Informatica transformations logics and Business rules mentioned in the Business requirement document and Data Dictionary.

Weekly Test case walkthrough with the business and incorporating the suggestions/modifications given by the business.

Follow up with the business for getting the test approval before the test case execution for each source systems.

Validating the target database after the first time History load and Daily Incremental load.

Ensuring all the Subscribers cancelled before 3 years are purged in the target database after the weekly purge process.

Preparing a weekly status report on every Fridays for tracking the effort spent in ETL testing and forwarding it to the business.

Assigning the defects if any to the ETL development team and data architect team after the History and Incremental load.

Attending the weekly defect tracking meeting with the business, ETL development team and data architect team and getting the ETA for the open defects.

Creating the System Integration Testing and Regression Testing scripts for all the scenarios and uploading it in Mercury Quality Center.

Updating the results of the test cases executed in HP Quality Center and validating the requirements traceability.

Suggesting various solutions with respect to implementation approach and performance issues.

Project Title

EDI 5010 Cognos Reporting

Client

Blue Cross Blue Shield of Massachusetts

Duration

SEP 2010 – Till date

Location

Boston, MA, USA

Technology

Cognos 8.4.1, Oracle 11G, Transaction Management

PROJECT DESCRIPTION: This project involves the upgradation of the Electronic Data Interchange (EDI) Infrastructure from the existing legacy 4010 systems to HIPAA 5010 Infrastructure. This solution will ensure regulatory compliance and will also improve the flexibility and scalability of EDI Processing. The Project also involves upgrading the existing Mainframe, HLM, Cognos 8.3 and Manual reports to Cognos 8.4.1 Platform.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Preparation of system and regression test cases for the Cognos reports.

Validating the Cognos generated report against the Transaction Manager (TM) to make sure the Claims processed in the TM got populated in the report.

Preparation of complex SQL queries to validate the report data against user requirements.

Uploading test cases in Quality Center.

Execution of test cases and tracking test case results.

Performed regression testing and front end navigation testing for the reports.

Updating the results of the test cases executed in Mercury Quality Center and validating the requirements traceability.

Tracking the defect which rises in each phase in HP Quality Center and fixing the defect within the stipulated timing.

Ensuring Quality standards for the reports.

Reporting and updating the status of the project to the Business / IT SME on daily basis.

Project Title

BIS Reporting Services

Client

American Express, Sydney, Australia

Duration

MAY 2009 – JAN 2010

Location

Chennai, India

Technology

MicroStrategy 8, Microsoft SQL Server 2005

PROJECT DESCRIPTION: Bureau Interface Server (BIS) is the application that interfaces between American Express A/R platforms and various internal and outsourced Bureaus for International plastic card production.

A key requirement that needs to be addressed during the migration is application-level compliance. This involves enhancement/establishment of a reporting service for BIS (replacing dynamic SQL query facilities).

BI&DW is engaged to provide an initial MicroStrategy project to expose this reporting service and provide for end-user ad hoc reporting as well as facilitate canned report development by BIS supplied resources.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Creating the System Integration Testing and Regression Testing scripts for all the scenarios and uploading it in Mercury Quality Center.

The responsibilities include analysis, cleansing data and define a process.

Experienced at testing Informatica ETLs and flat file data transfers without relying on a GUI layer.

Updating the results of the test cases executed in Mercury Quality Center and validating the requirements traceability.

Tracking the defect which rises in each phase in Mercury Quality Center

Ensuring Quality standards for the reports.

Reviewing the MicroStrategy Reports.

Reporting and updating the status of the project to the Onsite Leaders on daily basis.

Have undertaken responsibilities such as identifying areas of improvement and making necessary changes to alleviate the problem, suggesting various solutions with respect to implementation approach and performance issues.

Project Title

GABM Marketing Resource Management (MRM) Reporting

Client

American Express, Phoenix, AZ

Duration

JUL 2008 – APR 2009

Location

Chennai, India

Programming Languages & Tools

MicroStrategy 8, IBM DB2

PROJECT DESCRIPTION: GABM Marketing Resource Management (MRM) Reporting is for the Global Advertising and Brand Management Team for allocating sufficient fund for various activities in Amex for a specific period. The MRM Reporting solution will deliver a robust, flexible and interactive reporting solution and data analysis that satisfies all reporting requirements defined by Business (GABM, GABM Finance, ACRU, Controllership, Advertising Control and Reporting Unit, Global Real Estate & Procurement Services and Tax) during the Analyze sessions on 21-May-08 and 22-May-08 in NYC. Reporting is necessary to enable the business to utilize the functionality of MRM and enables transition to revised accounting policy in Q1 2009.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Preparation of system and regression test cases for the reports.

The responsibilities include analysis, cleansing data and define a process.

Experienced at testing Informatica ETLs and flat file data transfers without relying on a GUI layer.

Preparation of complex SQL queries to validate the report data against user requirements.

Uploading test cases in Quality Center.

Execution of test cases and tracking test case results.

Performed regression testing and front end navigation testing for the reports.

Updating the results of the test cases executed in Mercury Quality Center and validating the requirements traceability.

Tracking the defect which rises in each phase in Mercury Quality Center and fixing the defect within the stipulated timing.

Ensuring Quality standards for the reports.

Reporting and updating the status of the project to the Onsite Leaders on daily basis.

Project Title

‘By Invitation Only’ (BIO) Reporting

Client

American Express, Phoenix, AZ

Duration

Feb 2008 – JUN 2008

Location

Chennai, India

Programming Languages & Tools

MicroStrategy 8, Oracle 10g

PROJECT DESCRIPTION:

The primary function of the ‘By Invitation Only’ (BIO) ticketing system is to book tickets and track sales for BIO functions and Gold Card events (GCE). The premium marketing of exclusive events creates a unique customer experience for Centurion and Platinum card members.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Analysis on business requirements for testing purpose.

Test case preparation for testing data sources and Microstrategy reports.

Preparation of Oracle SQL queries to validate the report data against user requirements.

Uploading test cases in Quality Center.

Execution of test cases and tracking test case results.

Updating the results of the test cases executed in Mercury Quality Center and validating the requirements traceability.

Tracking the defect which rises in each phase in Mercury Quality Center.

Ensuring Quality standards for the reports.

Reporting and updating the status of the project to the Onsite Leaders on daily basis.

Project Title

Migration of Business Objects V 5 reports to Cognos 8

Client

Key Bank, Cleveland, Ohio

Duration

Mar 2007 – JAN 2008

Location

Chennai, India

Operating Systems

Windows 2000

Programming Languages & Tools

Cognos 8, Business Objects

PROJECT DESCRIPTION:

As part of consolidating the existing Reporting infrastructure running on various products from different BI vendors, Key intends to convert its Business Objects Applications to Cognos Report Net. The objective of this project is to migrate all the reports in the identified applications - SLE, CLA, HRS and HRS - from Business Objects V 5 to Cognos V 8.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Analyzed the requirements, understood the functionality and documented the same for reference and future follow-through.

Involved in preparing the unit test cases, system test cases and procedures, and testing all the components.

Wrote SQL queries to validate the report data with respect to the user requirements.

Involved in testing of reports developed in Cognos.

Ensuring Quality standards for the reports which include Review Checklists.

A key member in identifying the bottle necks involved in running the reports with respect to performance and data accuracy.

Followed defect management procedures using quality center.

Other Key Projects:

Project Title

Client

Role

Batch Processing

Key Bank, Cleveland, Ohio

Offshore Test Analyst.

Cognos Companion V1

Key Bank, Cleveland, Ohio

Offshore Test Analyst.

Contact this candidate