RESUME

Fredrick Jesudoss Sahaya

Email: acwmuq@r.postjobfree.com

Mobile: +1-804-***-****

SUMMARY

Having 9 years of IT experience (2 years as IT Quality Analyst) in developing, testing, supporting and maintaining Healthcare, Retail, e-Commerce, Banking and Financial Services on Windows, Mainframe and Unix environments with multiple technologies like Teradata, .Net Framework 2.0 and Search Engine Optimization.

EXPERIENCE

Analyzing bugs, interacting with development teams to fix errors and issues in Quality Control

Update QEI records for each projects in order to reflect the RAG status being updated by portfolio management

Experienced in driving Unit Testing, Functional, Regression, Integration Testing, User Acceptance Testing and Live Environment Simulation testing phases across domains

Extensive and in-depth knowledge of developing complex SQL scripts

Good knowledge in Mainframe COBOL, JCL, CICS, DB2, SQL, UNIX and Web Applications

Good knowledge of Data Warehouse concepts and hands on using ETL tools using Informatica and Teradata

Good team player with excellent Communication and Leadership skills

Good understanding and implementation of Quality process and procedures

Hands on experience in writing and evaluate Test Plan, Test Approach, Test Cases, Requirements Traceability Matrix for Manual and Automated testing

Identifying and recommending improvements to processes, business products and services

Through knowledge of Software Test Life-Cycle (STLC) including Test Requirements, Test Analysis and Design, Test Environments, Integration Testing, System Acceptance Testing and User Acceptance Testing

Working knowledge in both ONSHORE and OFFSHORE model

SKILLS

Operating Systems : IBM Mainframe z/OS TSO ISPF, Microsoft Windows, UNIX

Environment : Client/ Server, Data Warehouse, CICS

Coding Languages : Mainframe COBOL, JCL, VB.Net 2.0, ASP.Net 2.0

Scripting Languages : SQL, UNIX Grep Commands, CSS, HTML, XML

Testing Tools : IBM Rational Quality Manager, HP Quality Center, SOAP UI

IBM Tools : Change man, Control-M, FA, FM, FMIMS, Clear Quest, Rational Team Concert

Database Tools : ADO.Net 2.0, Access DB, DB2, VSAM, Teradata SQL Assistant 14, Toad Oracle

Automation Tools : Informatica DVO (Data Validation Option)

Project Tools : Microsoft Visio and MS Office

WORK EXPERIENCES

Anthem® INC. Richmond, Virginia, USA

IT Quality Analyst - 2 years (November 2014 - till date)

Team: IM Data Solutions

Size: 20

Project # 1: ASO Billing, Revenue and Claims received ORMB (Oracle Revenue Management Billing) data matching the claims subject area being sent to EDWARD. Data warehouse to receive the data from ORMB mapping the fields in all layers of LZ, CSA and Target

Responsibilities:

Attend BSD/ BTRD, Mapping, TSD/ TDD requirement specification meetings to gain knowledge on scope

Raise clarifications being observed via scope walk through by means of ambiguities tracker

Create Test Plan, Approach, Test Cases and Requirement Traceability Matrix for review with stake holders

Execute test cases via DVO for regression test scenarios for count, default, null and threshold validations

Execute functional, business and minus query test cases to make sure the results match the requirements

Log the defects in Clear Quest (CQ#), Rational Team Concert (RTC) matching the RQM test cases

Provide signoff’s once the test case results are fine, reviewed with stake holders and approvals are obtained

Tools: Teradata SQL Assistant, UNIX, Informatica, SQL, ETAT, DVO, Mainframe, Oracle (ORMB), Clear Quest, Rational Quality Manager, QEI, JAZZ Server, Rational Team Concert, TOAD

Project # 2: ASO Revenue and Claims CR65 Revenue and Claims missing CAK (Claim Adjustment Key) received ORMB (Oracle Revenue Management Billing) data matching the claims subject area being sent to EDWARD. Data warehouse to receive the data from ORMB mapping the fields in all layers of LZ, CSA and Target

Responsibilities:

Attend BSD/ BTRD, Mapping, TSD/ TDD requirement specification meetings to gain knowledge on scope

Raise clarifications being observed via scope walk through by means of ambiguities tracker

Create Test Plan, Approach, Test Cases, Requirement Traceability Matrix and Checklist for review with stake holders

Execute test cases in ORMB (Oracle) Toad in order to verify and validate the input records being sent from source to target as part of sample validation

Execute test cases via Informatica DVO for regression test scenarios for count, default, null and threshold validations

Execute functional, business and minus query test cases to make sure the results match the requirements

Log the defects in Clear Quest (CQ#), Rational Team Concert (RTC) matching the RQM test cases

Update QEI records to receive the corresponding RAG status for quality dashboard based on test cases

Provide signoff’s once the test case results are fine, reviewed with stake holders and approvals are obtained

Tools: Teradata SQL Assistant, UNIX, Informatica, SQL, ETAT, DVO, Mainframe, Oracle (ORMB), Clear Quest, Rational Quality Manager, QEI, JAZZ Server, Rational Team Concert, TOAD

Project # 3: Enterprise Vendor Information System (EVIS) data extract (DX) team which acts as a lower end source system to receive feeds from EDWARD. The purpose of this project is to stream line the report required to map the business rules and share the results with end users.

Responsibilities:

Attend BSD/ BTRD, Mapping, TSD/ TDD requirement specification meetings to gain knowledge on scope

Raise clarifications being observed via scope walk through by means of ambiguities tracker

Create Test Plan, Approach, Test Cases, Requirement Traceability Matrix and Checklist for review with stake holders

Execute test cases via Informatica DVO for regression test scenarios for count, default, null and threshold validations

Execute functional, business and minus query test cases to make sure the results match the requirements

Log the defects in Clear Quest (CQ#), Rational Team Concert (RTC) matching the RQM test cases

Provide signoff’s once the test case results are fine, reviewed with stake holders and approvals are obtained

Tools: Teradata SQL Assistant, Informatica, SQL, ETAT, DVO, Clear Quest, Rational Quality Manager, QEI, Rational Team Concert

Project # 4: EPDS to EDWARD (HMO65 Impact) Provider data to reach data warehouse for all participating and non-participating feeds in order to calculate claims for further processing. Claims which were process with these feeds will further reach CSA layer based on applicable Business rules before marking them as complete.

Responsibilities:

Attend BSD/ BTRD, Mapping, TSD/ TDD requirement specification meetings to gain knowledge on scope

Raise clarifications being observed via scope walk through by means of ambiguities tracker

Create Test Plan, Approach, Test Cases, Requirement Traceability Matrix and Checklist for review with stake holders

Execute test cases via Informatica DVO for regression test scenarios for count, default, null and threshold validations

Execute functional, business and minus query test cases to make sure the results match the requirements

Log the defects in Clear Quest (CQ#), Rational Team Concert (RTC) matching the RQM test cases

Provide signoff’s once the test case results are fine, reviewed with stake holders and approvals are obtained

Tools: Teradata SQL Assistant, Informatica, SQL, ETAT, DVO, Clear Quest, Rational Quality Manager, QEI, Rational Team Concert

Project # 5: EDWARD missing COB data (ACES) Government Business Data (GBD) ONSHORE only model. ACES source system was missing co-ordination of benefits data, which has to be corrected as part of history fix and upcoming records has to be altered as part of incremental fix.

Responsibilities:

Attend BSD/ BTRD, Mapping, TSD/ TDD requirement specification meetings to gain knowledge on scope

Raise clarifications being observed via scope walk through by means of ambiguities tracker

Create Test Plan, Approach, Test Cases, Requirement Traceability Matrix and Checklist for review with stake holders

Execute test cases via Informatica DVO for regression test scenarios for count, default, null and threshold validations

Execute functional, business and minus query test cases to make sure the results match the requirements

Log the defects in Clear Quest (CQ#), Rational Team Concert (RTC) matching the RQM test cases

Provide signoff’s once the test case results are fine, reviewed with stake holders and approvals are obtained

Tools: Teradata SQL Assistant, Informatica, SQL, ETAT, DVO, Clear Quest, Rational Quality Manager, QEI, Rational Team Concert

UST Global® Centro Fox, Guanajuato, Mexico

Test Lead - 9 months (March 2014 till November 2014)

Client: Anthem® INC.

Team: Test Centre of Excellence/ Test Data Management

Size: 12

Project # 1: Consumer Portal team from different sources will have changes applied in CHUB and our lower systems for which they require data from testing in various environments like UNIT, SIT and UAT. These test data are supposed to be either copied from Production or we will mockup to recreate the scenario, once a request has been placed. The data which has been shared to a team will be tagged to the project and will not be used by other projects.

Responsibilities:

Test Data creation, validation and quality check before issuing to testing team

Engage/ Participate/ Update status during Client calls for test data

Extract/ Alter data from database by coding report programs to identify business requirement data

Update daily status to Clients, Users and Managers across all working location shores

SOAP UI being used as a middleware to obtain data being transferred from request and response files

Tools: Mainframe COBOL, JCL, IOF, SAR, SPUFI, QMF, DB2, SQL, SOAP UI, Clear Quest, Microsoft Visio

Project # 2: Consumer HUB (CHUB) is an intermediate layer of data warehouse when data flow from multiple source systems for Business reports and processing inclusive of all subject areas. Records are being queried and used across for testing purpose to lower data extract (DX) or business intelligence (BI) teams.

Responsibilities:

Extract/ Alter data from database by coding report programs to identify business requirement data

Test Data creation, validation and quality check before issuing to testing team

Insert/ update/ modify test data being cloned to recreate production issue for fixing them in SIT/ UAT regions

Tools: DB2, MS SQL Server, SQL

UST Global® Chennai, TamilNadu, India

Technical Lead - 11 months (April 2013 till February 2014)

Client: WellPoint INC.

Team: WGS Managed Services LON/ Multi-Channel Support

Size: 18

Project # 1: Multi-Channel Support team has almost 11 regions running multiple subject areas batch cycle like Membership, Claims, Check write, FCS, Inquiry and Group tape. All these batch jobs are supposed to be complete on time, in order the testers to start proceeding with their changes which has been planned live for upcoming releases.

Responsibilities:

Lead team of resources, ensure the batch cycle is completed for all subject areas

Automate the jobs, which need to be run as part of ADHOC process each month to fix records

Hard delete the records after confirmation from the specific testing team groups, if being reported as issue

Roll out information to all region users about the uptime and downtime,

Kill user sessions if they have displays in their job print SYSOUT which makes region clocking

Tools: Mainframe COBOL, JCL, QMF, SPUFI, BMC Control-M, IOF, SAR, Main view, FM, FMIMS, DT, Fault Analyzer, Clear Quest, SQL, Tivoli

UST Global® Trivandrum, Kerala, India

Senior Software Developer - 3 years and 5 months (November 2009 till March 2013)

Client: WellPoint INC.

Team: WGS Managed Services LON / WGS and STAR Claims Service Delivery

Size: 40

Project # 1: WGS and STAR Claims Service Delivery has multiple hourly sweep, intermediate hour batch window and nightly batch to complete fine with process of mapping, edit, load, adjudicate, finalize and history update in claims processing. Records to be identified and dropped if we found them issue while processing the batch completion.

Responsibilities:

Dedicated ONCALL support for Production, UAT and SIT regions

Monitor claims regular, hourly and night batch window cycle jobs using Control-M

Create packages, incidents, and work orders to fix abended jobs in production

Update Client with daily claims batch cycle statistics report

Dedicated resource to fix jobs permanently which is recurring due to data and ACR definitions

Tools: Mainframe COBOL, JCL, QMF, SPUFI, BMC Control-M, IOF, SAR, Main view, FM, FMIMS, DT, SQL, DB2

Project # 2: WGS and STAR Claims Service Delivery will have reported CQ#’s (Clear Quest) issues of various severity seeking immediate break fix by altering the code, testing them in user acceptance testing environment and go live. These defects are being analyzed, debugged and found out the root cause of issue in code using Debug Tool (DT), fix the code, test them and promote the package to region. The package will later then be approved in production for live.

Responsibilities:

Active participant interacting with Clients during off cycle and maintenance code releases to production

Schedule and submit batch cycle window jobs by raising job scheduling request

Train fresh resources and make sure to be compliant on healthcare security and policies

Initiate SWATT 1, 2, 3 and 4 calls if more users report online CICS region issues and unavailability

Create test plans for coding changes moved as break fix in SIT and UAT testing regions

Tools: Mainframe COBOL, JCL, QMF, SPUFI, BMC Control-M, SQL, DB2, Main view, FM, FMIMS, DT, Fault Analyzer

Mobius Knowledge Services® Chennai, TamilNadu, India

Junior SEO Analyst - 1 year and 2 months (September 2008 till October 2009)

Client: GAP INC. (GAP/ Old Navy/ Banana Republic)

Team: Content and SEO Services

Size: 15

Project # 1: Products of clients (apparels) to be listed within top results when being searched in major search engines and bring up their websites. These strong keywords are refined and plugged in multiple articles websites, blogs, wiki, e-how and article submission websites. Same keywords with multiple length are being used in Clients website in order to drive traffic which is being done as part of On-page and other website driving traffic as Off-page optimization.

Responsibilities:

On-page and off-page optimization

FTP/ cPanel web server administration, hosting and maintenance

Google analytics and webmasters

Tools: Windows XP, HTML, CSS, XML, SQL, Filezilla, Robots.txt, Metadata, Google ADWORDS and Algorithm

Project # 2: Generate short and long keywords and add them towards index page of websites in order to drive traffic when the search is being made in major search engines like google. Submit same sets of keywords with an article, white papers, blogs, vlogs in order to drive traffic to websites.

Responsibilities:

Organic keyword research and link building

Social media optimization and insights tracking

Web spider and Web Analytics reporting

Tools: Windows XP, HTML, CSS, XML, SQL, Filezilla, Robots.txt, Metadata, Google ADWORDS and Algorithm

Project # 3: Travel related video blog to be created and posted with all new package information in order to attract tourist. Need to submit the video logs with refined keyword search add them to comments, robots.txt, title, description and keywords in order to drive the weblog come up when the search is being done in google.

Responsibilities:

Weblog and video log creation and webpage administration

Website auditing, HTML, XHTML and CSS validating

Update daily page rank report status to Client and Managers

Tools: Windows XP, HTML, CSS, XML, SQL, Filezilla, Robots.txt, Metadata, Google ADWORDS and Algorithm

NINTEEN Hour IT Private Limited ® Tiruchirappalli, TamilNadu, India

Project Manager - 6 months (December 2007 till May 2008)

Client: Internal

Team: Windows and Website Application

Size: 8

Project # 1: Requirement is to create a software for internally handling student’s database by keying in their information and to pull reports based on the various categories like different course enrolled, gender and district.

Responsibilities:

Create and maintain windows based applications.

Create and maintain database, tables, extract reports based on requirement.

Create VSI as a package as a software installation bind to deploy in client/ server machines to act as host.

Tools: Windows XP, Microsoft .Net Framework 2.0, VB. Net 2.0, ADO. Net 2.0, SQL and MS Office

Project # 2: Requirement is to create and maintain multiple websites for all sister concerns associated with existing parent company. To ensure they all run fine and all inquiries from these websites are being pulled and reported to managers based on categories.

Responsibilities:

Create and maintain web based applications.

Create and maintain database, tables, extract reports based on requirement.

Report escalations to Managers/ update dashboard daily towards closure of incident/ tickets

Tools: Windows XP, Microsoft .Net Framework 2.0, ASP.Net 2.0 behind code VB, SQL, HTML, CSS and XML

ACADEMIC

- Master of Computer Applications from St. Joseph’s College, Tiruchirappalli (2004 - 2007 Regular)

- Bachelor of Science in Mathematics from St. Joseph’s College, Tiruchirappalli (2001 - 2004 Regular)

ACHIEVEMENTS

- Awarded by UST Global® with Rewards and Recognition/ Putting the Client first

- Awarded by UST Global® with Rewards and Recognition/ Execution Mindset

- Awarded by Microsoft® as a Quiz winner for ASP.Net MVC framework

VISA

H1B (valid till 07/31/2018)

Fredrick Jesudoss Sahaya

Contact this candidate