SUMMARY

• Worked as Mainframe QA (10 Years), Hadoop (Big Data)/ETL QA Automation Lead and Test coordinator with 11 Years of Experience.
• Across all projects actively involved in all phases of SDLC/STLC
• Worked with Banking Clients (Citi, JPMC, Sallie Mae and Confidential ), Health Care Clients (BCBS, Hartford Insurance, Confidential )
• Worked on the Domains Credit Card, Managed Care, Retail, PBM, Student Loan, Brokerage and Investment.
• Mainframe Testing
• Experienced on setting up the Test JCL's, Procs, and Sort cards as per the testing standards
• Involved in the Verification of batch jobs, Procs, cards, modules, copy books in development libraries for the correctness. Verification of Tag’s, Change man package, parent and implementation details.
• Responsible to manage UAT (OPC Scheduler activities like Monitoring batch schedules, fixing the abends, escalations, adding new jobs, handling holds as per the user needs)
• Experienced on executing the SQL queries in Spufi for test validation
• Involved in CICS Screen validations and corresponding VSAM files (KSDS, ESDS)
• Experienced with IBM Utilities like Sort, IEBGENER, IDCAMS and ICE tool
• Worked on changed controller tools like Change man and Endevor
• Experienced with Debugging tools like Xpediter and Intertest
• Experienced with Writing COBOL Programs and also able to read and understand the programs based on the need
• Developed a COBOL module for compare process which saved lot of CPU time and provided good amount of CPU time savings
• Used Strobe tool to identify the time consuming statements in JCL/COBOL/DB2 and provided the solutions to save the CPU time
• Developed a Critical jobs statistics tool using Rexx and Clist
• Test Lead and Tester Responsibilities
• Contributed to test strategy, test estimation and test scope artifacts to ensure the delivery of quality software applications on medium to large projects.
• Experienced on working with onsite/offshore model
• Worked with Technical and Business teams to define the scope of testing required.
• Experienced with the identification of high level test scenarios and any specific test environment or test data requirements.
• Created test cases, ensuring appropriate test coverage and evaluating the overall quality of the artifacts delivered.
• Reviewed and provided input for all testing artifacts that can include test plans/case/scripts, requirements traceability matrices, test tracking documents and test schedules.
• Carried out test execution, evaluated the outcome of the testing conducted in each test cycle and provided defect escalation to management, as needed.
• Presented Test Results to the team to get the approvals and conducted/attended defect calls
• Prepared Test Summary/Closure Reports
• Documented the lessons learned, conducted the meeting with team to understand the same and mitigated the same in the upcoming release
• Worked with UAT teams to answer their queries
• Helped Regression teams by providing the scenarios from each release to be part of the Regression
• Provided support during the release and involved in the post production validations
• Mainframe Automation Tools developed using CLIST and REXX
• Critical jobs statistics tool, GDG Tool, DD Name Vs File name and developed back end JCL’s, COBOL programs.
• REXX tool to get the Attributes of the existing GDG base
• REXX tool to create the Test GDG base with new naming conventions
• REXX tool to create the NDM cards
• PDSMAN tool to search multiple libraries with multiple criteria in a specified pattern of members
• PDSMAN tool to SCAN and REPLACE a particular string
• Big Data Testing
• Experienced in Testing of Data pipeline built using Teradata/Hadoop/YARN/HDFS/Hive/Hive QL/SQL environment
• Hands on Experience on validation of the mapping sheets and Hive Tables
• Data stage and Transformation validations - Ensuring that the intended data is loaded into Hadoop system - which involves comparing the source data with HDFS data, comparison of counts, checking data quality, verification of HDFS directory for the correctness of target path, transformations and joins
• Data Masking Validation
• Performed testing on SHA-256 Hash functionality algorithm
• Experienced on development of test cases based on the mapping rules
• Knowledge in Automation Testing
• Used Selenium Web Driver for automation, comfortable with handling multiple browsers, various objects like Text Box, List Box, Links, Images, Tables, and Labels.
• Comfortable with Selenium IDE tool
• Utilized firebug tool for locators identification
• Comfortable with the coding of xpath, screen capture, handling alerts, scrolling logics, multiple windows
• Comfortable with Selenium parameterization to test with multiple sets of data
• Utilized test frame works like JUnit and TestNG
• Comfortable with creating TestNG Framework using annotations
• Automated test validation activities with shell scripts
• As a Test Coordinator
• Responsible for Testing Estimation and Requirements Traceability
• Coordinated the Testing activities with multiple teams on multiple projects
• Organized DEV to QA Handoff meeting to get understanding of QA team with the actual changes planned for a release
• Conducted Test plan walkthrough with the QA and Business team
• Organized Test Results walkthrough with the business team for getting the approvals
• Organized defect calls and weekly status meetings to identify the risks and status of the project
• Escalated the risks to management and Identifying the mitigation plans with the management team
• Connecting the different groups of people based on the dependencies of the project and Following up with testers to resolve the conflicts

TECHNICAL SKILLS

Mainframe: IBM Mainframe, Rumba, AS400, TSO/ISPF, JCL, GDG, IDCAMS, COBOL, DB2, SQL, Spufi, QMF, VSAM, CICS, REXX, Clist, Changeman, Endevor, Xpediter, IBM Utilities, Sort, Zeke, OPC, ISPF, SDSF, Pdsman, SuperC Compare, File - Master, File-Aid, NDM, FTP, SAR, IOF, VDR, Jscan, JCLPREP, OS390, Z/OS

Testing: HP QC (Quality Center)/ALM, Clear Quest, qTest and Jira

SDLC Methodologies: Waterfall and Agile

Hadoop/Big Data: HDFS, Map Reduce, Hive, Hive QL, SQL, Pig, YARN, Sqoop, Horton work/Cloudera Distribution, Tidal, Unix/Linux, Shell Scripting

Testing Automation - Selenium with Java: Selenium IDE/Web Driver, Selenium Grid, Java, TestNG, JUnit, Jenkins, Maven, Testing Framework, Eclipse

Other: HBase, NoSql, Teradata, Spark, Scala, Oozie, Flume, Impala, HTML, QuerySurge, Squirrel, Toad, MS Word, MS Excel, MS Access, PowerPoint and VISIO

PROFESSIONAL EXPERIENCE

Confidential, Raleigh NC

Hadoop QA

Responsibilities:

• Understood the data from various source systems and their business importance
• Interacted with Data architect, ETL, Hadoop Administration and Metadata teams
• Attended daily agile meetings to provide the present status of work and road blocks
• Utilized Jira for creating the user stores, tasks and to track the progress of the same
• Utilize qTest for tracking the testing activities
• Worked in Horton woks Distribution
• Developed medium to complex SQL queries for validation, involving joining multiple tables
• Developed shell scripts to automate the test case preparation and test results validation across multiple zones in the Hadoop data lake
• Involved in the validation of ETL mappings and work flows and their schedules
• Prepared test plan based on the scope and business requirements
• Proficient with below Hive Activities
• Verified and made sure the files are landed into the landing zone from various sources
• Validated Hive Schemas to make sure they are in sync with the given mapping sheet
• Validated Hive tables properties like compression, file type and delimiters
• Validated fields definition as per the given mapping sheet
• Compared the data between different to zones to make sure the data is transformed as expected and no loss in the data
• Developed medium to complex HiveQL queries to complete the validation
• Verified the scheduler for the jobs implementation, pre and post requisites

Environment: Horton works Distribution 2.3,YARN, ETL Informatica BDM tool, Unix/Linux, Shell scripting, HDFS, Map Reduce, HIVE 1.2.1, HIVE QL, SQL, MS Excel, Teradata, Oracle, Ambari UI, Tidal, JIRA and qTest

Confidential, Raleigh, NC

Senior Mainframe QA

Responsibilities:

• Projects worked - IHC (Intermediate Holding Company) - FR Y-15 (Federal Reserve), FATCA (Foreign Account Tax Compliance Act), FR Y-9C, Mantas, FICC (Fixed Income Clearing Corporation) and Book of work items
• Comfortable with Test planning, Test Case Preparation, Execution, Defect Reporting, test closure report and Release Verifications
• Sending daily status report, communicating risks and resolving conflicts
• Worked on major federal projects and Book of work items
• Acted as a Approver for QA tasks
• Comfortable with multiple Trade booking systems to process different types of trades
• Coordinated the QTP Automation testing activities with offshore team

Environment: Mainframe, JCL, COBOL, HPS, DB2, SQL, Squirrel, Power Builder, QTP, HP Quality Center/ALM Tool, MS office Applications MS Excel and word.

Confidential, Richardson, TX

QA Lead

Responsibilities:

• Acted as a QA Lead and coordinated the Activities with other 3 team members
• Validate Claims Data received from different systems for correctness
• Good understanding of the RxClaim system, QL and Recap system
• Comfortable with all basic concepts like Claims Submission, Plan Edits, Pricing, Patient Pay (Copay/Co Insurance), Pharmacy network, Member Eligibility, Adjustments, Prior authorization, Step therapy, Accumulations of deductible, OOP, Refills and Benefit profile settings.
• Hands on experience in generating reports like PDE, CET and 1013 financials for balancing purpose
• Experience on testing of Adjustments application

Environment: AS400, PDM, RxClaim, Mainframe, JCL, COBOL, SQL, MS Excel and HP Quality Center

Confidential, Hartford, CT

QA Lead

Responsibilities:

• The Hartford Group is a leading provider of life insurance, group and employee benefits, automobile and homeowners insurance and business insurance -as well asinvestment products, annuities, mutual funds, and college savings plans.
• SRS is a third party system, which mainly deals with the Claims Administration and Risk Management. Acted as a Mainframe QA lead and coordinating with 3 offshore resources

Environment: Mainframe, Testing, Oracle, SQL, MS Excel

Confidential, Wilkes Barre, PA

QA Tester

Responsibilities:

• Sallie Mae the nation’s leading provider of saving, planning and paying for programs. Worked on testing of IBR, ICR, and Alternate Direct Lending Repayment Plans.
• Understanding the Technical Systems design of various repayment plans using in FFELP and FDLP Loans and testing of the same

Environment: Mainframe, Testing, DB2 SQL, MS Excel

Confidential, Kansas City, MO

QA Tester

Responsibilities:

• JPMorgan Retirement plan services are a division of Asset & Wealth Management. Specifically concentrates on Retirement plans like defined contribution plan (401K and Profit sharing plans) and defined benefit plans (pension and cash balance plans).
• Currently NFS (National Financial services) is the brokerage clearing house used by RPS. Now the objective of this project is to convert the brokerage clearing house from NFS to JPMCC (JPMorgan Clearing Corporation).
• Throughout the conversion all files, reports, tables and data fields must be maintained for both NFS and JPMCC and stand alone for JPMCC after the conversion. Test plan included the testing of dual processing of files, assets and data movement.

Environment: Mainframe, Testing, DB2, SQL, MS Excel

Confidential, Richardson, Texas

Test Coordinator

Responsibilities:

• Provider and Managed Care Technology Group (PMCTG) is the ITG team that supports manage health care delivery (MHCD) and Health care management (HCM) groups.
• The objective of this project is to separate the production environment from testing environment, which involves understanding of the existing system and proposing the changes needed, preparing strategy documents for each proposal and end to end testing of all 3 systems (Provider, IMM and Pricing) and sun setting the New Mexico application.

Environment: Mainframe, Testing, Rexx, DB2, SQL

Confidential, Irving, Texas

Test Coordinator/Tester

Responsibilities:

• Collections system deals with the delinquent customers and objective is to motivate the customers by educating the different kinds of payment methods, arrangements and to retain the customer.
• Other activities included moving the accounts to RMS, Archiving the credit history an account and write-off. Simultaneously handled three systems IBS, FDR and SEARS.
• Involved in all phases of SDLC and Acted as a Tool Developer, Testing Coordinator (UAT, Parallel and Regression), Team lead (Onsite/Offshore Coordination)

Environment: Mainframe, Testing, Rexx, Clist, DB2, SQL, MS Excel