Manager Test Cases

ASHWIN MOTHUKURI

Cell: 281-***-**** Email: ****.*******@*****.***

EXPERIENCE SUMMARY

Having 11+ years of experience in software industry which includes Manual, Automation, Mainframe, Database, ETL/Datawarehouse, SAP CRM & BO, Web technologies and Big Data/Hadoop – Hive testing.

Onshore experience with Kaiser Permanente, State of California, USA and Barclays Bank, Manchester, UK.

Data warehouse testing in Big Data, Spark, Kafka, Scala, Python, AWS (EMR, S3, EC2, Lambda), Hadoop, HDFS, Hive, Pig, Impala, MySQL, UNIX, Teradata, Informatica, ETL.

Data Warehousing - Expertise in developing strategies for ETL using Informatica Power Center and SAP BO reports.

Experience in Selenium, Quick Test Professional (QTP) and IBM – Rational Functional Tester.

Experience in JAVA web-based applications, Oracle databases, and Client/Server applications.

Experience in AWS and Azure Cloud Mirgration.

Knowledge in Robotics Process Automation - Blue Prism & Automation Anywhere.

Excellent Knowledge of Database Systems – Oracle 10g, SQL server, IBM DB2 and Data warehouse concepts.

Extensive experience in developing SQL scripts to validate the databases, tables and reports data for backend database testing.

Proficient in troubleshooting database issues and experienced in using performance monitor/profile to solve dead locks/ long running queries.

Experience in RDBMS, Microsoft SQL Server, Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge, PEGA and UNIX applications.

Extensively worked on testing tools like Application Lifecycle Management, QC, Rational Test Manager, Rational Quality Manager and Test Director.

Certified IBM - Rational Functional Tester for Java certification, Agile Scrum Master & Application Test Designer.

Experience in testing SAP CRM and ECC modules. Strength in SAP CRM 7.0 Sales and Interaction Center on Web UI Platform.

Project Management: Ability to work with and drive cross functional teams to ensure completion of all commitments made relative product development timelines, delivery, quality and business matters.

Manage programs through entire product life cycle, interfacing with onsite teams on technical and business matters.

Exposure in Project and Release Planning, resource estimation and conflict management.

Liaised between onsite – offshore project leaders and performed the role of a facilitator between multiple teams.

Dynamic work allocated to the team members on a priority basis and ramping up the teams’ knowledge base if the team member is new to the product or process by providing appropriate trainings. Swift learner and venerable team player, ability to meet tight deadlines and work under pressure.

Expertise on different types of functional, integration, system & regression testing.

Good understanding on SDLC/STLC the software testing, planning, quality assurance and quality control and worked in different phases of V-model, waterfall and agile methodology.

Experience in test management, traceability to requirements and defect tracking.

TECHNICAL SKILLS

Domains : Healthcare, Banking, finance, Insurance and Retail

Automation Tools : HP – QTP, IBM – Rational Functional Tester

Testing Tools : Rational Quality Manager, RTC, TD, Quality Centre,

ALM, Clear Quest and BugZilla

ETL Tools : Informatica and Datastage

Databases : Oracle 8i/9i/10g/11g, DB2 8.0, SQL Server 2005/2008,

Teradata, MS Access

Methodologies : Waterfall, V-model, Agile scrum

Operation Systems : Windows XP/2000/2007/2010 and UNIX

Mainframe : DB2, CICS, VSAM

Languages : VB script, Java script, JCL, COBOL, SQL, Scala, Python, HQL,

Spark, Unix Korn Shell

Other Utilities : Oracle SQL, WinSCP, Putty, AWS, Hive, BigD, Spark, Hadoop,

HIVE, Sqoop, Kafka, flume, Pig

EDUCATION

Master of Computer Application (MCA) from IGNOU in 2003

Bachelor of Science (B.Sc) in Mathematics, Statistics & Computer Science from Kakatiya University in 2000.

CERTIFICATIONS

IBM Certified – Rational Functional Tester for Java

Certified for Essentials of Test Management with IBM Rational ClearQuest

Certified ScrumMaster (CSM certification from Scrum Alliance

Accenture Technology Academy - Certified Application Test Designer

Awards for the performance delivered in Major Releases in the Projects.

HDSE (Higher Diploma Software Engineer) Certification from APTECH

PROFESSIONAL EXPERIENCE:

Client: Equian, AZ, USA Aug'2016 to till date

Role: Senior Associate - Projects

Organisation: Cognizant

Equian is a leading provider of technology-enabled, data-driven solutions ensuring accurate payment integrity across the healthcare and property and casualty industries. The company focuses on Pre-Payment and Post-Payment healthcare overpayment solutions that drive expanded savings for Medicaid, Medicare, Blues, and other Commercial payers.

Cognizant has been engaged by Equian to implement the BigDecisions platform for Data management and Analytics.

The first phase of implementation will be a Proof of Concept to build a scalable solution to ingest medical claims, eligibility and authorization data from 3 client ( Highmark, Humana & BCBS) sources and enable integration with Equian’s internal systems Audit Point & Troveris.

Responsibilities:

As a working module lead role, handling team members and involves the following:

Test Requirement gathering, analysis, Create Test plan, Create Test scripts.

Work with developers to build code and code migration.

Test execution, Test results validation and test results documentation.

Provide sign-off for production implementation.

ETL testing using Spark, Kafka, Scala, Python, AWS (EMR, S3, EC2, Lambda), Hadoop, HDFS, Hive, Pig, Impala, MySQL.

Test Auto file trigger for AWS and Oozie workflow scheduling for Hadoop HDFS batch processing

Developed HIVE SQL queries to validate the complex business rules

Working as Test Lead and is responsible for ETL testing, helping other team members to ensure delivery of quality deliverables, meeting the timelines, perform end-to-end testing and provide weekly status on projects to management

Interacting with clients, business analysts, end user to get business requirements from them, providing estimates, Translating business requirements into test requirements, coordinating with offshore to ensure the defect free deliverables

identified major Performance Issues in QA testing and work with developers on performance tuning guidelines to meet SLA

Exchanged data between S3 and Hadoop HDFS.

Analyze data Integration & flow from 3 data sources

Preparing and Executing the test cases in the Hive SQL, Beeline, Big Decesion and Oracle SQL Developer.

Testing the reports in Tableau.

Co-ordinate UAT testing, act as a SPOC between Equian and Cognizant

Perform defect management and tracking of defects identified in SIT and handle triage calls and manage defects.

Filled the knowledge gaps by arranging the required KT sessions to team members

Environment: JAVA (JDK), Apache Tomcat, R Studio, Sql Server, Informatica BDM, Tableau, Cloudera, Spark SQL, Spark Streaming, Kafka, Python, AWS (EMR, S3, EC2, Lambda), Hadoop, HDFS, Hive, Pig, Impala, Scala, Spark, Big Decision, WinSCP, SQL Developer, PuTTY, MS Office 2013

Client: Caltex – Australia March'2016 to Aug'2016

Azure Cloud Migration (SAP Re-Platforming)

Role: Team Lead & Management

Orginisation: Accenture

The SAP RePlatforming Project has been established to Migrate the SAP On Premise to Azure Cloud.The main objective of the RePlatforming as follows.

Re-platform the SAP landscape to the cloud. Migrate all SAP systems from current OS and DB (Unix/oracle/max DB) to MS Windows Server 2012 R2 and MS SQL 2014. Adopt a cloud infrastructure opex model for SAP infrastructure. Remove the need for future hardware upgrades, refresh cycles. Achieve improved system performance, Increase platform flexibility, elasticity and responsiveness. Reduce the overall TCO of SAP Infrastructure (across hardware, OS, DB, licencing, infrastructure and application support).

Responsibilities:

As a working Offshore module lead role, handling team members and involves the following:

Coordinate with onshore for Test Preparation, Execution and Status reporting.

Coordinate with client, other vendors and address the issues and share the testing deliverables.

Review the Test Strategy,Test Planning documents.

Test Management Tool setup, maintenance, Resource Management.

Coordinate between BAU support team, Migration Team and Testing Team.

Coordinate the Refresh Plan in Baseline Systems testing.

Coordinate the Azure Cloud Migration in Dry Run testing.

Coach my team to develop them to highly productive, apply testing methodology and produce high quality deliverables while executing test cases for each modules.

Daily interacting with onshore and offshore team.

Daily assign the task to the team members, and sending daily catch up with offshore achievement for the day status, Test execution status for CON,Reference systems & Dry Run Testing status report to onshore/client team.

Filled the knowledge gaps by arranging the required KT sessions to team members.

Environment: SAP - BW, PI, EP, PORTAL, SCM, SRM, HR, BO, ECC, SD, MM and NoN SAP systems, DB- Oracle to SQL 2014,OS Migration - Unix to Windows Server 2012 R2, office 2013, IBM - Rational Quality Manager (RQM), Rational Team Concert (RTC).

Client: State of California – Franchise Tax Board, USA Apr'2015 to March'2016 Enterprise Data to Revenue (EDR)

Role: Team Lead

Orginisation: Accenture

The Enterprise Data to Revenue (EDR) Project addresses modernizing our enterprise operations and systems. This means more efficient operations throughout the department, better customer service, maximized transparency, and more revenue. New Return Processing System – Automates manual processes, enhances data capture and validation ability, and standardizes our processes. Enterprise Data Warehouse – Stores data and makes it accessible to our systems and to Franchise Tax Board users. Secure Online Taxpayer Folder – Provides instant access to tax account information. Modernized Systems – Modernize legacy systems allow efficient communication with the New Return Processing System, Enterprise Data Warehouse, and Taxpayer Folder.

Responsibilities:

As a working module lead role, handling team members and involves the following:

Analyzed the business requirements and functional specifications.

Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.

Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.

Developed complex mappings in Informatica to load the data from various sources.

Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Parameterized the mappings and increased the re-usability.

Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.

Created procedures to truncate data in the target before the session run.

Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.

Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.

Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.

Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.

Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.

Written documentation to describe program development, logic, coding, testing, changes and corrections.

Created Test cases for the mappings developed and then created integration Testing Document.

Filled the knowledge gaps by arranging the required KT sessions to team members.

Environment: Oracle 10g/11g, Informatica Power Center (Power Center Designer, workflow manager, workflow monitor), SAP Business Objects – Crystal Reports and Dashboard, IBM - Rational Quality Manager, SQL developer, TOAD, SQL, PL/SQL, FileZilla, PuTTY, Mainframe, Clear Quest, Rational Quality Manager, Manual and MS Excel.

Client: KAISER PERMANENTE, USA Sep'2014 to Apr'2015 Role: Test Lead

Orginisation: Accenture

Kaiser is a global health insurance service company offering health, life, accident, dental, medical insurance and health related services to individuals. In its most recently reported year, the non-profit Kaiser Foundation Health Plan and Kaiser Foundation Hospitals.

Responsibilities:

As a working module lead role for application, handling 15 team members and involve the following:

Involved in sprint and walk through meetings to go through the Business Requirements and understand the scope of the project.

Mapped requirements to test cases to maintain accurate Traceability.

Automated, Executed and Maintained Test cases through Selenium Web Driver.

Built a detailed, reusable Page object Framework for over 80% Test cases using Selenium Web Driver + JAVA (No Record and Run).

Responsible for review of Test cases and Test Scripts (Manual + Automation) written by Peer.

Worked on Selenium Web driver for automating over 70% of cross browser testing on IE, Firefox, and Chrome.

Involved back end validations using MySQL.

Performed Smoke test on the build to ensure its clean enough for QA testing to proceed on the delivered builds.

Logged and Verified defects accordingly using BugZilla.

Involved in defect triaging with developers and other project stakeholders to get updates on defects.

Involved in updating the Dashboard with daily status update on execution of TC's and defect report and Involved in retrospective meetings.

Responsible for testing and automating hand held devices.

Environment: Web Driver, Java, TestNg, Manual and Automation (Selenium RC, WebDrvier),BugZilla, MS Office, BugZill and SQL.

Client: Express Scripts Inc, USA Apr'2013 to Sep'2014 Role: Test Lead

Orginisation: Accenture

ESI - TMDS (Theater Medical Data Store): TMDS is a service oriented aggregation and distribution point for theater medical data. The purpose of the TMDS is interface is to share outpatient prescription and pharmacy, medical data form from TMDS to ESI on a weekly basis. ESI will load the claims to the patient’s claim history.

Responsibilities:

Coordinate between Clients and Offshore teams.

Preparing estimates for the release work proposed and getting approvals for the same from Clients and Accenture Management.

Understanding end to end Business functionality, Analysis of Requirement documents.

Preparing resource utilization metrics and sharing the same with the Clients and leads.

Addressing application access issues

Preparing Status Reports on testing activities/efforts

Addressing issues raised by the team and clients

Coordinating Automation work from Onshore and helping offshore Automation resources by providing resolutions for the questions raised.

Tracking Release schedules and Resource estimations.

Constant follow-ups with clients to track the change requests and updating the team as and when needed.

Developed and Executed Test Plans, Test Cases and Test Scripts.

Close coordination, seamless communication and daily Touch Point & hand off calls with the Team to update the leads and clients on progress and issues.

Constant monitoring of effort and schedule, escalating the project dependencies much in advance to mitigate the risk of show-stoppers while testing.

Participated in defect management calls with the onshore functional team.

Used RQM and share point for test case management, defect tracking

Performed a wide range of quality tests, functional, user interface, regression, connectivity, smoke tests, performance,user acceptance, failover and recovery.

Continuous review process - peer review with offshore and onshore to avoid any issues with the Test Scenarios and Test Cases.

Filled the knowledge gaps by arranging the required KT sessions to team members.

Environment: Java, J2EE, XML, Share Point, RUMBA Mainframe, Claim Research Tool, Oracle Developer, Windows, Rational Quality Manager, Excel.

Client: Dyson, UK Feb'2012 to Apr'2013 Role: Team Lead

Orginisation: Accenture

Dyson Ltd is a British technology company, founded in 1993 by James Dyson, which designs and manufactures vacuum cleaners, hand dryers, Bladeless fans and heaters.

Dyson has chosen SAP CRM to run their business process more effectively.

The scope for Dyson Projects entails Marketing, Sales and Service Processes.

Responsibilities:

Played Module Lead for applications handling eight member team.

Understanding and designing of the test cases based on the functional requirements

Coordinating the team and assigned daily task and consolidated the reports.

Developing/review/modify test plan, test cases, test data and coordination with the development team.

Review/modify/create test cases and test scenarios for different types of testing like UAT testing, End to End, Product integration testing and regression testing as per the requirements.

Validated SAP CRM and ECC screens for data validation and sales related screens and distributing to warehouses.

Co-ordination with the onshore team for the status meetings and issue clarification.

Raising and tracking defects during test execution in IBM - Rational Quality Management.

Participate in bug review sessions and coordinate with development teams.

Environment: Rational Quality Management, SAP Testing, Share Point, Windows, Excel,

SAP CRM & ECC

Client: Highmark, USA Oct'2010 to Feb'2012 Role: Senior Software Engineer

Orginisation: Accenture

High Mark is one of the 10 largest US HealthCare insurance companies based in Pittsburgh, Pennsylvania, United States and is the largest health insurer in Pennsylvania, and West Virginia. As, it serves 4.9 million health plan members primarily in Pennsylvania, West Virginia and Delaware, employs more than 20,000 people and provide health, dental, vision and supplemental health products and services to 34.4 million customers

Responsibilities:

Responsible for preparing WSR(Weekly Status Reports) and presenting the same in weekly status meetings with offshore, onshore & client teams.

Responsible for addressing the issues raised by the team and clients and follow up until closure.

Constant follow-ups with clients to track the change requests and updating the scripts as and when needed.

Helped team improving their functional and technical skills.

Point of Contact for all automation activities from offshore.

Close coordination, seamless communication and daily handshake meetings to update the onsite leads and clients on progress and issues.

Constant monitoring of effort and schedule, escalating the project dependencies much in advance to mitigate the risk of show-stoppers while testing.

Continuous review process - peer review, onsite review with offshore and onshore to avoid any issues.

Responsible for Preparing Automation Process Documents for the Team.

Responsible for Developing and Executing Automation test scripts using RFT for 12 different web applications.

Responsible for automating different applications like Capes Pega - Workflow, ECS - Membership, OPIS and Bill Core - Ebill etc.

Regression testing of the applications using RFT.

Environment: Java, J2EE, XML, Share Point, MQ Series, Rational Functional Tester,

Rational Quality Manager, DB2, Windows, Excel.

Client: Lloyds Banking Group, UK Dec'2008 to Oct'2010 Role: Senior Software Test Engineer

Orginisation: Accenture

This project is all about offering reliable, Innovative, and Business Acceptance Testing services to the Lloyds banking Group Projects. Previously, Lloyds Bank has merged TSB in its first acquisition and formed LTSB. And now its recent acquisition is with HBOS. HBOS mainly comprises of H- Halifax and BOS- Bank of Scotland forming Halifax Bank of Scotland (HBOS).This total acquisition of Lloyds Bank is referred to as LBG (Lloyds Banking Group). LLOYDS BANKING GROUP is the largest retail bank in the United Kingdom with over 30 million customer base and headquartered in London. It is formed through the acquisition of HBOS by Lloyds TSB in 2009. LBG has the largest branch network in the UK and market-leading telephone and internet services. Accenture is responsible for managing and supporting the implementation of integration through BRT, CBT, UAT and Regression testing. This includes all tasks ranging from requirements review; test scripting, execution planning, test execution, defect reporting and coordination between all project teams involved, status tracking, and reporting progress and status to the onshore team.

Responsibilities:

Using High level design documentation and use cases to derive test scenarios and test

cases.

Taking ownership & responsibility for UAT to facilitate testing for the introduction of new

or revised functionality.

Working as a single point of contact for technical and testing guidance for other capability

groups in the core banking system.

Ensuring that all capability groups test the changes appropriately and reporting the

progress and test results to supervisor.

Preparing test scenarios, test conditions and review of test scenarios and conditions.

Responsible for execution test scripts.

Performing Functional, Regression testing and defect retesting.

Training sessions conducted for new associates and project related tasks.

Involved in meetings for preparing test plans based on Software Requirements Document

Involved in business functionality review meetings

Interacted with Functional and Technical Managers & QA team for understanding

requirements

Prepared MOM for meetings and status calls and regularly updated the SharePoint for

future reference

Escalation and communication bridge for Offshore and Onsite.

Defect tracking and Defect analysis using Quality Center 9.2 and provide an accurate

Defect Management Report like Test Metrics detailed daily status report.

Thoroughly tested application along with bug reporting, bug tracking till bug closure.

Also, I was involved in generating production packs and performed the QA and also

sending the reports to the Client.

Extracts reports from the QC and the update reports in a specific format

Implemented PDF process production checklist for each pack

Daily created a For Final Metrics PDF Consolidation to update Pack for both LTSB and

HBOS Packs.

Reduced the time required for QA the reports (instead of excel reports to make a PDF’s)

mins thereby saving time by 70% approx

Delivered on time and schedule as directed by the client.

Environment: V.B, .net, Share Point, MQ Series, Windows 2007, Oracle Developer, Windows, Quality Center, Excel.

Client: Barclays, Manchester,UK Nov'2006 to Dec'2008 Role: Software Test Engineer

Orginisation: Accenture

The ePayments Automation (ePA) initiative aims to improve the Bank's operating efficiency when dealing with SDDP (Same Day Domestic Payments aka CHAPS) and BIPS (Barclays International Payment Services) Payments. The primary goal of the programme is to reduce and ultimately remove paper-based payment instructions arriving at the Payment Centres. Paper instructions will be substituted by new electronic delivery means resulting in more flexible, consistent, uniform and secure service. ePA will leverage and extend the current strategic IT platform (ADIR) providing additional benefits.

- Cost savings by reducing the number of full time employees (FTEs) involved in processing payments.

- Cost savings by removing the manual processing and handling of paper around the country.

- Meeting of KYC and ID&V compliance requirements by contextual help and data validation at each process step.

-The key functionality covered by ePA Release 1 includes

- Access via the existing ADIR Customer Gateway screens, including use of the existing locates KYC ID&V screens.

- Access to ePA Release 1 screens via a standalone Chordiant front-end for Users without ADIR Customer Gateway access.

- Execution of Payments within AFTS/API.

Responsibilities:

Involved to study the Project Functional Design documents

Prepare Test Conditions, Prepare Test Scripts for responsible module.

Review the test Scripts and update them, performed the functional testing and regression

testing using QTP and Log detail defect report.

Peer review of the test cases.

Provide accurate and the Defect Management Report like Test Matrices detailed daily

status report.

Reported and Tracked defects through Test Director.

Prepare and make the Payments in FAX - ABBYY Correction Station & Export and

Monitoring Station.

Involved API/AFTS Testing and checking Payments in Mainframe, like using CICS and DB2

Navigation (API Diary) environments.

The daily status report is sent to the client team.

Environment: Windows 2003, Java, JSP, Mainframe, Oracle, Test Director, QTP, Windows, Excel.

Contact this candidate