Candidates About

Venkata Nagaraju

Summary:

·         Worked as a Hadoop (Big Data)/ETL QA, Mainframe QA, Automation Lead and Test coordinator with 11 Years of Experience.

·         Across all projects actively involved in all phases of SDLC/STLC right from understanding of requirements, preparing Test Plan, Test Scenarios and cases, Test execution, Defects Tracking, UAT Support and up to providing post Implementation Support.

·         Experienced testing the logical data base design including data flow, relations, metadata and constraints.

·         Big Data Testing

• • Experienced in Testing of Hadoop/HDFS/Hive/SQL environment

o   Hands on Experience on validation of the mapping sheets and Hive Tables

o   Data stage validation - 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

• • 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, Selenium RC, and SOUP UI 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

·         Mainframe Testing

• • Experienced on setting up the Test JCL's, Procs, and Sort cards
  • 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
  • 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

Knowledgent, Warren NJ                                                                                Aug 2016 – Aug 2017

Hadoop Big Data Test Engineer

Big Data project is new initiative to implement a next generation enterprise data warehouse with a fully integrated Hadoop Data Hub to offload data provisioning activities from mission critical hardware, supplemented by a business centric access layer for improved data access. This will be the central storage hub for the data management needs of the organization.

o   Understood the data from various source systems and their business importance

o   Interacted with Data architect, ETL, Hadoop Administration and Metadata teams

o   Attended daily agile meetings to provide the present status of work and road blocks

o   Utilized Jira for creating the user stores, tasks and to track the progress of the same

o   Utilize qTest for tracking the testing activities

o   Worked in Horton woks Distribution

o   Developed medium to complex SQL queries for validation, involving joining multiple tables

o   Developed shell scripts to automate the test case preparation and test results validation across multiple zones in the Hadoop data lake

o   Involved in the validation of ETL mappings and work flows and their schedules

o   Prepared test plan based on the scope and business requirements

o   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

o   Verified the scheduler for the jobs implementation, pre and post requisites

o   Environment: Horton works Distribution 2.3, 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

Credit Suisse, Raleigh, NC                                                                                          Sep 2015 – July 2016

Senior QA (ENO)

Project: NTPA

Credit Suisse operates as an investment bank in the United States. Its businesses include securities underwriting, sales and trading, investment banking, private equity, alternative assets, financial advisory services, investment research, and asset management. The company offers services in investment banking, capital markets, and financial services segments for institutional, corporate, government, & high net worth clients.

• • 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
  • Comfortable with Data validation
  • Acted as a Approver for QA tasks
  • Comfortable with Trade booking system
  • Coordinated the Selenium Automation testing activities with offshore team
  • Environment: Mainframe, JCL, COBOL, HPS, DB2, SQL, Squirrel, Power Builder, Selenium and HP Quality Center/ALM Tool, MS office Applications MS Excel, word, Access

CVS Caremark, Richardson, TX                                                                                  Sep 2011 – Jan 2014

Senior QA Lead

Project:  Client Certification (Client Connect)

CVS Caremark is one of the largest pharmacy health care providers (pharmacy benefits managers (PBM’s)) in the United States. At present CVS owns three adjudication engines like RxClaim, RECAP and QL. Main objective of the Client certification team is to migrate all clients from RECAP and QL to RxClaim system and sunset those two applications. Apart from above CVS owns few more clients from the external system RxAmerica, those clients too merger into RxClaim. The Migration is planned over multiple waves, where as in each wave certain number of clients will be processed then finally 4 types of compare reports will be generated, they highlights the miscompares between Recap and RxClaim System. All the miscompares will be analyzed and the issues will be fixed before implementing them into production.

• Acted as a QA Lead and coordinated the Certification 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

The Hartford Insurance, Hartford, CT                                                                       Jan 2011 – Sep 2011

QA Lead

Project:  Specialty Risk Services

The Hartford Group is a leading provider of life insurance, group and employee benefits, automobile and homeowners insurance and business insurance - as well as investment 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

Sallie Mae Inc., Wilkes Barre, PA                                                                                Feb 2010 – Dec 2010

QA Lead

Project:  Federal Student Loan Repayment Processing (FFELP and FDLP)

Sallie Mae®, the nation’s leading provider of saving, planning and paying for education 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

JPMorgan and Chase, Kansas City, MO                                                                      Nov 2009 – Feb 2010

QA Tester

Project:  RPS Brokerage Platform

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

Blue Cross and Blue Shield, Richardson, Texas                                                          Mar 2008 – Sep 2009

Test Coordinator

Project:  PMCTG – Separate Test from Production

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

CITI GROUP, Irving, Texas                                                                                       Dec 2004 – Feb 2008

Test Coordinator, Tester

Project:  Citi Cards – Automated collections system (ACS)

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

Master of Technology from National Institute of Technology, 2002, Calicut, India.

Bachelor of Technology from S.V. University, 2000, Tirupati, India.