Post Job Free

Resume

Sign in

Engineer Data

Location:
Schaumburg, IL
Posted:
December 08, 2020

Contact this candidate

Resume:

KRISHNAMOHAN MOCHERLA

*** ******** **** **** # ** Schaumburg, IL 60193 Phone: 650-***-****

Email: adihb1@r.postjobfree.com

Perm. Address: 856 Muender Ave, Sunnyvale CA 94086

Profile Summary: Immg. Status: US Citizen

Motivated QA professional with over a decade of experience in Testing ERP (Enterprise Resource Planning) applications with exposure to Agile, Scrum methodologies as well as SDLC Development. Expertise in designing, developing and implementing test plans, test cases and test processes enabling swift corrective actions, significant cost savings and fault free audits in in CI-CD pipelines.

Worked on Cloud based Oracle Fusions Financials and cloud based Salesforce CRM applications testing

Strong Business Analyst and Product Mgr skills besides QA Organizational, analytical, Problem-solving

Strong Functional Knowledge of Oracle Applications modules such as AP, AR, GL, CE, Payments(IBY), SLA, TCA, PN etc. KT planning and Training.

Worked cross-functionally with other teams and collaborate closely with developers and support to validate solutions to resolve important customer bugs.

API Testing: Used POSTMAN, SOAP UI and Salesforce Workbench. Some exposure to API automation.

SDET Experience: Java Selenium WebDriver, Jenkins, Oracle Applications Testing Suite(OATS)

Frameworks: TestNG, Data Driven Framework, Page Object Model, Hybrid Framework.

Other Testing tools: Jenkins, QTP/UFT, WinRunner, QC/ALM, Jira

Design and Creation of: Test Driven development Basic Validation Tests (BVTs), Release Readiness Flows(RRFs), End-to-End Tests(E2E), System/Regression Test Plans, Report specific Test plans, Cross Pillar Integration Tests.

Tested and certified various products of Oracle Financial Applications on various releases of Oracle11i, Oracle E-Business Suite, Java-based Oracle Fusion Financial Applications.

Experience in Onshore-Offshore Model. Involved in Agile ceremonies Design Discussion, Story Time, Data Design and Sprint Retrospective

Professional Experience

QA Engineer/Project Leader (Mobile Project)

Camping World, Chicago August 2019 – April 2020

Working on Cloud based Salesforce Lightning CRM Applications (Sales, Service and Marketing). Worked closely with development team and PM teams on CPQ application features and Integration. Writes documentation and creates process flow charts for new features, improvements of business processes and amendments.

Test Strategy planning, working with teams to understand the project goals and requirements, writing system test plans, Logging bugs and follow up with developers and Business teams as required. Lead the new projects, schedule and attend the QA Planning meetings, updates of the project to the team, discuss the product features, testing methods and test data design for the project. Requirements Traceability Matrix preparation. Suggest and ask for possible work around available for the issues encountering during QA execution. Data Integration Testing for Sales Desk application for Record Type. Creating Confluence wiki documentation pages. Daily standup meetings, Jira updates. Managing and updating Test Manager. Pulling tests and updating testing status as required in the Test Manager. Preparing weekly testing status reports on different projects. Updating project plan.

Oracle Applications: Procure to Pay(P2P) and Order to Cash(O2C) Cycle Testing, AP, AR, GL and CE Integration Testing.

Mobile Applications Testing on iPhone, Android phones and iPads. Chrome browser Developer tools

API Testing using Salesforce Workbench and Postman, REST Assured.

SDET: Selenium Java, Eclipse Maven, TestNG Designing the Page Object Model framework, Apache POI data driven tests, implementing Log4J (for customized message logging for easy analysis of failures). Jenkins used for scheduling batch runs. Creation and stabilization of automated tests for various applications including Salesforce CRM Applications and Web applications. Platform/Application related issues communication with Development and PM or Business teams. Setup, maintain frameworks POM as required.

Ecommerce Business Application Testing: Testing of online sales application for RV & Outdoors; Good Sam Roadside assistance sales.

ETL Testing – Used Salesforce Data Loader, verified bug fixes relating to "Too many Query Rows" Limit Exception on huge data loads. Salesforce Data Integration Testing with Inventory, Pricing systems.

Accessibility Testing: using Jaws, Nvidia tool and browser tool bar. Ad-hoc testing of Oracle Financials applications as required. DOM Analysis.

QA Lead / Engineer – Consultant Mar 2018 – July 2019

Online Business Applications (OBA) Woodridge IL: Medical Information Systems, dot net application business flows testing, Involved in testing of IRMS customized application various releases to various clients from time to time. Agile methodology, scrum runs, daily stand-up meetings, weekly/bi-weekly presentation of existing and new features. Gap analysis for the existing test plan and features. IRMS Web Digital Onboarding training module for the entire application, coordinating with development team and external service provider. Preparation and writing of test cases for each and every test or bug fix and certifying the test cases for client’s submission and audit. Review of Standard Operating Procedures (SOPs) and updating with application improvements. OBA Medical Systems Applications #C, automation, Digital onboarding, regression, BI dashboard testing, gap analysis Requirements Traceability Matrix. Bugs Root Cause Analysis.

Salesforce CRM applications testing (Classical version). API Testing: REST API Testing with POSTMAN and Salesforce Workbench.

Mobile Applications Testing: Mobile applications testing on different devices, iPad, iPhone, Android OS.

SDET: Automation Supervision: Daily coordination with India Team to monitor and review the Progress of Regression Scripts run. Selenium Java, TestNG, Jenkins were used on this project. Page Object Model, Data driven Frameworks. Besides supervision, I was responsible for designing and creating tests for new features and improvements in the products.

ETL Testing – Web Application Data Integration with original MS Access Application data.

Thorough testing of Digital Onboarding for physically challenged personnel, to learn the OBA Applications usage. Worked on SSIS(SQL Server Integration Services) to move data into reports servers.

Facebook (Menlo Park, CA): Oracle Financials application projects (Financials month/quarter closing mock runs), SDET: OATS automation and Manual Testing of Oracle EBS Suite of Applications.

Hilton Grand Vacation (Orlando, FL): Cloud based financials applications upgrade, In-bound and out-bound interfaces, AP, AR, CE, IBY and GL products, Microsoft Visual Studio (VS) and Team Foundation Server (TFS). Conducted Accessibility Testing for physically challenged users.

Salesforce CRM Applications (CPQ) Manual /Automation Testing for different groups of Hilton Grand Vacation new projects. API Testing: REST API Testing with POSTMAN and Salesforce Workbench.

SDET: Worked with India Team on Selenium Tests stabilization and re-write as required. Selenium-Java, TestNG, Maven, Git, GitHub, Data Driven, Page Object model frame works.

Testing of HGV vacation package online application.

Mobile Applications Testing: Mobile applications testing on different devices, iPad, iPhone, Android OS.

ELT Testing - Time to time as required – Used Oracle Data Integrator and Salesforce Data Loader

Analysis of Business needs, requirements with Clients business team, Preparation of Functional Design Documents, User Stories, Use Cases, Test Cases for Salesforce Apps. Daily Scrum meetings, Reporting progress of Projects and QA status.

Collaboration: Collection of data and updates from Offshore team, Assigning QA work to offshore team members, Bug fix verifications and regression testing on different applications. Daily / Weekly progress reporting to management. Updating Project Plan.

Quality Assurance Engineer – Individual Contributor / Project Lead Jul 2007 to Jan 26, 2018

Oracle Corporation, Redwood City, CA 94065, USA -- QA Project Lead

Products: Cloud based Oracle Fusion Financials Cash Management / Payments (IBY), AP, AR, GL, Trading Community Architecture (TCA) & Oracle Customers Online (OCO), Property Manager (PN)

SDET: Java – OATS (Oracle Applications Testing Tool), Selenium, TestNG, Page Object Model, Data Driven framework (data banks, data provider, apache poi).

Designing Test plan with data sets for automation for Smoke tests, BVTs, E2E Flows and Business Scenarios. Scripts (SELENIUM/OATS) Creation, conforming to coding standards, delivery and monitoring runs failures, maintenance, update as per new features and changes. Update POM and other frameworks as required from time to time. Stabilization of OATs scripts / Selenium scripts according to the application changes from time to time per improvements, modification in different modules of application. Coordinating with other SDET Engineers in India and USA for clarifications and functional issues or data issues.

HP UFT/QTP is being used for Release 12 EBS suite RTs and Test improvements. VB Script, Data Driven Testing, AOM being used for batch execution.

API Testing: Web services testing (SOAP UI), Cloud environments testing, browser specific testing, language-based testing, accessibility testing was conducted on several releases. REST Assured testing for External Transactions, Bank and Branch features using Postman.

Accessibility Testing: Got trained by a Blind Personnel for testing Oracle Applications for Accessibility Testing. Voluntary Product Accessibility Template (VPAT) – Testing of Cash Management product to meet the various accessibility standards (Section 508) using various methods including browser tool bar, DOM and Jaws, NVDA tools.

Mobile Applications Testing: Mobile applications testing on different devices, iPad, iPhone, Android OS.

ELT Testing – for specific upgrade projects used Oracle Data Integrator and SQL Loader. For Accounts Payables worked on Invoice Loading from image files, spread sheets, etc. sources

Customer Support: Participation in Customer Bug review meetings as a QA contact along with PM, Support and Developers. Customer issues and Support Tickets Root Cause Analysis. Reproduction of the issue in local environments, working with developers and explain them the issue, suggest them for possible solutions, once the issue got fixed, test the fix and regression in local environments before code merge; after code merge test in the QA Environment for regression.

Product Management: Supported Dev team with Product Management duties. Prepare/Review BRD / FRD / User Stories as required. KT plans, KT Training. Review of TDDs. Prepare/Review of FDDs relating to the cross-pillar integration features, discuss with concerned teams, about the shortfalls, must features, would be good features and improvements with concerned teams on the features. Product training and knowledge transfer sessions of Fusion Cash Management New Features to other teams, Global Sales Engineering Demo Team, QA Engineers in counterpart countries.

Tech Stack Testing: Review and understand the Technology Stack Upgrade effects on the product and conducting thorough testing of Technology Stack Upgrade Environment to make sure there is no regression. Review and understand the Technology Stack Upgrade effects on the product and conducting thorough testing of Technology Stack Upgrade Environment to make sure there is no regression.

Security Testing: Thorough testing of Oracle Identity Management (OIM) and Authorization Policy Manager (APM) with Data Role, Job Role, Duty Role based use cases. Function security policy testing using different privileges assigned to duty roles in APM. Creation of Testing security features for upgrade features from Rel 9 > 10 > 11 > 12 > 13. Creation of users, Roles and Policies, customization works in pre-upgrade and verifying them in Upgraded environments. Data Security Testing on major releases of Fusion Financial Apps.

Integration Testing: P2P and O2C cycle testing along with product integration. Prepare and maintain System Test plan for Financials Pillar products’ integration, with detailed steps and data sets. Prepare test plans for cross-pillar integration for Cash Management with HCM, SCM and CRM products. Prepare/Review of FDDs relating to the cross-pillar integration features, discuss with concerned teams, about the shortfalls, must features, would be good features and improvements with concerned teams on the features. Hyperion Essbase Integration Testing. Revamp testing of Bank Statement Transaction Creation Program. This Revamp of feature was because of the issues I found during my testing. IBY integration testing for all the new features and improvement of features of Cash Management. Testing of Oracle Applications Desk Top Integration feature loading huge data using excel files into Interface tables and loading them into applications.

Testing Cycles: For every testing sprint / release pull the Manual and Automation tests into the QC/ALM folders and design the tests cycle scope for the Cash Management product and assign them to testers as required, make sure the tests are updated on daily basis so that the QA Dashboard is updated properly for the daily divisional meeting.

Attending daily divisional update meeting for updating Integration testing for various products of Financials modules automation testing updates for various modules.

Coordinating between QA Teams located in India and Mexico. Monitoring the test failures, coordinating different development teams for their product test failures, bug fix follows, coordinating with QA automation teams for scripting updated and scheduled runs.

Manual Testing of System Test Plan / Bug fixes in various releases of Cash Management and IBY products as required from time to time.

Participation in Testing Sprints and Fusion Financial Continuous Delivery Life Cycle of various on-going projects. Review and analysis of Business Requirement Documents, Functional Design Documents, Discussing improvement of existing features, and UI improvements.

Design of tests to suite the Business Rules and user stories; design of Test Data for these tests.

Designing various types of Tests and Test details. Designing Test Data to suite the testing scenarios.

Analyze and suggest improvements to Release Readiness and P1 scripts widening the scope of test coverage.

Managing and Updating ALM, Quality Center with statuses to update the Dashboard Reports. Migration of test inventory to new ALM system from QC.

New Feature Testing in Fusion Cash Management V2, Bank Account Transfers, AdHoc Payments, Cash Positioning and Forecasting, Spread sheet load for Bank Statements, External Transactions.

Technical Skills

Languages: Java, SQA Basic, 4Test Language, SQL, PL/SQL, HTML, XML, UNIX Scripts, BASIC, C, and VB Script

Oracle Applications: Cloud based Oracle Fusion Financial Applications E-Business Suite 12, 11i, 10SC, Character mode

Operating Systems: Windows, Linux/Unix, iOS, Mobile iOS, Android.

Testing Tools: SELENIUM, OATS, QTP, Oracle Data Integrator, SQL Loader, Salesforce Data Loader, QC, Test Director, WinRunner, Silk Test 5.x, SQA Test Suite, QA Organizer, SQA Suite: SQA Administrator, SQA Robot, SQA Image Comparator, SQA Text Comparator, SQA Test Log Viewer, SQA Site Check, and QA Run

Word Processors: MS Word, WordPerfect, WordStar, and Professional Writer

Spreadsheet Software: Microsoft Excel, Lotus 123, and Quattro Pro

Education & Certifications

Bachelor’s Degree in Commerce and Accounting (Osmania University, Hyderabad, India)

Issuing Authority

Degree

Subject

Genesis Software Systems, Hyderabad, India

Certificate

Oracle Financials

Oracle Corporation, USA

Certificate

Oracle Payables

Oracle Corporation, USA

Certificate

Oracle Receivables

CRS Info, Hyderabad, India

Certificate

SQL, PLSQL, Forms 4.5, Reports 2.5, Graphics, DBA

Infer Data, Hyderabad, India

Certificate

Lotus Notes 4.5

Mercury Interactive, USA

Certificate

WinRunner



Contact this candidate