Ajay Pala C: 313-***-**** adz3ba@r.postjobfree.com

LinkedIn: linkedin.com/in/ajay-pala-8486b593

PROFESSIONAL SUMMARY

10+ years of diversified experience in software industry.

Master's degree holder.

Strong experience in Business and Systems Analysis, Quality Assurance and QA methodologies in various domains.

Strong experience with various test automation tools Selenuim with Java, Microfocus UFT 15.0.2 and creating test run reports.

Strong experience with project management tools Microfocus ALM 16.0.1, JIRA, Microsoft Office Suite including Microsoft Visio and Microsoft project.

Strong experience with CI/CD tools Bitbucket, Github and Gitlab.

Strong experience in testing Rest APIs with Postman.

Strong experience in creating customized PDF and Excel report log using VB Script as needed by the client and send out the logs via customized e-mail using SMTP relay agent.

Contribution to complete project life cycle of Analysis, Design, Configuration, Implementation, Testing, Defect Management, Release, and support.

Strong experience in creating Detail design documents which include RICE (Reports, Interfaces, Conversions, Enhancement) documentation for new development and enhancement projects.

Expert in Business and functional documentation, Project plans, business processes, workflows, and activity diagrams.

Strong experience in Software Development Life Cycle stages SDLC and Development Methodologies like Waterfall, Agile and Scrum.

Strong experience in database and creating complex SQL queries for testing and reporting.

Good knowledge of Object-oriented programming concepts (OOPS).

SKILLS

Testing tools: HP ALM 16.0.1, HP UFT 15.0.2, Selenium WebDriver, Maximo 7.6.0.4, JIRA.

CI/CD: Bitbucket, Github and Gitlab.

Data bases: Oracle 11g, SQL Server 2005, MS Access

Web Services: Rest Assured

Languages: VB Script, JAVA.

Workforce Management: Infor Workbrain, Work force Time and Labor.

Payment portals: Kubra online payment portal.

ERP portals: Cayenta customer portal, Maximo.

Excellent MS Office skills - Word, Excel, Visio, PowerPoint, Access, MS project.

Excellent Manual and Automated testing skills.

Excellent SQL scripting skills.

Strong problem solving and troubleshooting skills.

Excellent Team collaboration, quick learner, proactive, and self-starter, good mentor.

CERTIFICATIONS

Software Quality Assurance and Testing (SQAT)

Microsoft Certified System Engineer (MCSE)

Enterprise Network engineering

CCNA Routing & Switching

WORK EXPERIENCE

Test Automation Engineer /QA Analyst July 2016– Till Date

Client: EMWD, California

Project: Multiple Projects

Experience working on multiple projects as BA and Automation engineer including Maximo 7.6.0.4, Customer billing Portals and Customer payment portals.

Responsibilities:

Analyze the business requirement documents, design documentation, flow diagrams to understand the business process being developed and create appropriate solutions.

Attend JAD sessions, application walk-through and review requirements to understand the scope of the project and determine existing gaps, the requirements for closing those gaps, and a means to measure progress of the transition and transformation.

Created RICE (Reports, Interfaces, Conversions, Enhancement), quality documents viz., Business requirements document (BRD), Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and QA/validation documents, Use-Case Models, Data Flow Diagrams and Activity Diagrams in Word, MS Visio, Excel using data validation, conditional formatting, pivot tables, queries, graphs with strict adherence to formatting standards.

Creating Automation frameworks in Selenium WebDriver using Maven and running test scripts using TestNG.

Tested REST API’s using postman tool.

Documented REST API results and coordinated with client and vendor teams.

Lead the Test Automation effort in creating multiple scripts including e-mail logs for daily operations, Functional testing, and end to end testing.

Created a Hybrid Framework of automation for the applications which includes Maximo,

Cayenta using VBScript coding in HP UFT.

Created custom templates and reports in HP ALM to review the progress and share with external vendors.

Managed test script repository for various projects in HP ALM.

Integrated HP ALM and HP UFT to run the scripts and log results in ALM.

Created hybrid framework to run end to end testing by using complex sql queries and VB Script.

Prepare test data and Performs data analysis to support evaluation of system defects.

Software: HP ALM 16.0.1, HP UFT 15.0.2, Oracle 11g, VB script, Maximo, SQL Server Management Studio, SQL Developer, Progress DBA, Cayenta, Rest Assured.

QA Analyst/Test Automation Engineer July 2014 – June 2016

Client: NiSource, Ohio

Project: Workbrain Upgrade

Workbrain 4.1 time and labor is in place for CMA, NCS and CPG employees. Workbrain 4.1 is about to be unsupported by the vendor and needs to be upgraded. The purpose of this project is to upgrade Workbrain. The Workbrain project has two releases:

i.NiSource – The existing NIPSCO WB6.01 application will be modified to include CMA and NCS.

ii.CPG – Upgrade CPG from WB4.1 to WB6.1.5

Responsibilities:

Create Automation scripts for Functional and regression testing, reducing the run time and eliminated the need to add additional resources.

Analyze the business requirement documents, design documentation, flow diagrams to understand the business process being developed and create appropriate QA documentation.

Have performed test coordinator duties in the planning, management, and execution of the test scripts. Report and discuss progress of the test process weekly.

Coordinated the Onshore and Offshore teams to resolve clarifications & issues and acted as a single point of contact for any escalation and issues.

Prepare Unit, Integration and UAT Test Scripts both Manual and Automated (using HP UFT 11.52), Test plans and conduct System, functional and Regression testing.

Support UAT by authoring test cases, test plans, defects, root cause analysis and lead defect resolution calls.

Prepare test data by writing simple to complex SQL queries by extracting data from Oracle database.

Performs data analysis to support evaluation of system defects.

Conduct defect analysis, tracking and management using HP ALM/Quality Center.

Provided continued maintenance and development of bug fixes and patch sets for existing applications. Analysis and resolution of post-production issues.

Implemented company policies, technical procedures, and standards for preserving the integrity and security of data, reports, and access.

Develops training materials, start-up, shut down and first level troubleshooting of processes and conduct training sessions for team members and other users in the department.

Develop standards and protocols for project deliverables of all departmental team activities to ensure quality and timely delivery of documents.

Software: HP ALM 11.52, HP UFT 11.52, XML, Java, Oracle 11g, VB script, Infor Workbrain 6.01, HP Quick Test Pro 9/10/11, Maximo, JIRA, Windows XP/7, MS project, IE, MS Office Suite, People Soft, Mainframes and Perl.

Senior Test Engineer Oct 2011 - July 2014

Client: NiSource, Indiana

Project: Green Pay Project

The NIPSCO Time & Labor project will replace NIPSCO’s ATR application (28-year-old time system) with leading time and labor solution utilizing Workbrain (Version 6.0.1), an application developed by Infor. The application will integrate with Work Management, Financial, PeopleSoft and other systems, and the project will include providing electronic timesheets for field use. Implementation will include the current labor and HR policies.

Responsibilities:

Conduct, co-ordinate and supervise end to end testing process.

Supervise testing environment for all system compatibility checks and enforce test development standards.

Designed, created, and executed manual and automated scripts using HP UFT 11.52.

Conduct Unit and Integration testing, planning, and co-ordination of UAT testing.

Gather data and produce reports for change control board meetings.

Attend JAD, analyze user requirements, procedures, and problems to automate or improve existing systems.

Research and understand problems, develop, and implement solutions for solving the problems.

Identify opportunities that can improve efficiency of business processes.

Data querying and creating test data using Oracle SQL developer.

Designing and testing standards and solutions.

Troubleshoot technical issues and identify modifications needed in existing applications to meet changing user requirements.

Investigate and resolve application functionality related issues and provide first level support and troubleshooting.

Analyze data contained in the corporate database and identify data integrity issues with existing systems and implement solutions.

Helped and advised business users in the effective use of applications and information technology.

Coordinate application development, work closely with colleagues, developers, testers, and end users to ensure technical compatibility and user satisfaction and participate in weekly meetings with the IT consulting team to discuss progress on a weekly basis to the team and project managers.

Defect tracking using HP ALM and Maximo.

Software: Infor Workbrain 6.01, HP ALM 11.52, HP UFT 11.52, XML, Java, Oracle 11g, VB script, Quick Test Pro, Windows XP/7, IE, MS Office, People Soft, Main frames and Perl.

Apart from the above listed clients, I have worked for various clients over the past years in different roles as Senior QA Consultant, QA Analyst and Systems Engineer.

EDUCATION

Master of Science: MSc Electronics

Bachelor of Science: BSc Electronics

Diploma: Internetwork specialist and Linux administration

Contact this candidate