Test Cases Manager
Resume:
RESUME
Fredrick Jesudoss Sahaya
Email: **************@*****.***
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