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

PROFESSIONAL SUMMARY

8+ years of diversified experience in software industry.

Master's degree holder.

Strong experience in Business and Systems Analysis, Quality Assurance.

Excellent experience in Workforce Time & Labor software - Workbrain and workforce management, payroll tracking, labor budgeting and planning, schedule optimization, compliance and pay, and workforce measurement interfacing with all major payroll, HR, ERP and other software vendors.

Strong experience as a Quality Assurance Engineer in QA methodologies, QA testing using Manual and Automated techniques for both web and client/server based applications.

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

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

Strong skills in Unit, SIT and UAT Test plans, scripts creation, co-ordination and execution.

Experienced in Integration and Usability testing.

Automated web application testing using Selenium WebDriver 2.0.

Strong skill in GUI, Regression, Functionality, Positive-negative, Black box-white box and data driven testing using HP UFT 11.52

Experience leading Requirements gathering workshops and JAD sessions. Strong experience in creating 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 database and creating complex SQL queries.

Strong experience in bug tracking tools HP ALM, Maximo.

Data analysis, reporting skills using IBM Cognos.

Business Systems analyst with expertise in requirement gathering, architectural, component and interface design and testing for web-based applications in multiple domains.

Testing tools: HP ALM 11.52, HP UFT 11.52,

HP Quick Test Pro 9/10/11, Selenium

WebDriver 2.0, HP Quality center 9/10,

Maximo, JIRA, Eclipse.

Operating Systems: Windows 2003 server,

windows 2000 server, Windows

95/98/ME/XP/vista /2000

Professional/Win7,Linux

Web Technologies: J2EE, XML, HTML and

Java Script

Data bases: Oracle 9g, SQL Server 2005, MS

Access, SQL Developer, IBM Cognos

Languages: VB Script, C, C++, Java, C#

Workforce Management: Infor Workbrain

Environments: Web Logic, Web Sphere, IIS

Tools: VSS and CVS. MS Visio, Excel,

PowerPoint, Access

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

Excellent Manual and Automated testing

skills. ETL testing experience.

Excellent SQL scripting skills.

Strong problem solving and troubleshooting

skills.

Functional specifications creation.

Excellent communication skills

Excellent QA tools knowledge.

Good domain experience of Time & Labor

workforce management.

Excellent Team collaboration, quick learner,

proactive, and self-starter, good mentor.

Network Technologies: TCP/IP, VPN, VM

ware, HTTP and Virtual PC.

SKILLS

WORK EXPERIENCE

Business Analyst July 2015 - till date

Nisource, Columbus, OH

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:

Attended JAD sessions, application walk-through and reviewing Requirements to understand the scope of the project and Attended project meetings as needed and recommended architectural improvements, design solutions and integration solutions.

Crated RICE (Reports, Interfaces, Conversions, Enhancement) documentation for Business requirements and low level design documents.

Developed work-flow charts and diagrams for business processes.

Prepared Unit, Integration and UAT Test Scripts, System Test plans for System testing, Regression and User Acceptance testing.

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

Create work break down structure in MS project.

Built effective test data covering all possible scenarios.

Created simple to complex SQL queries for testing.

Designed, created and executed Manual and Automated scripts using HP UFT 11.52.

Configured Dashboard reports in HP ALM for metrics purpose.

Prepared Traceability Matrix and validation reports using HP ALM 11.52.

Coordinated with the Developers to resolve the issues/defects.

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

Communicated with Manager, project lead daily for testing efforts and provide Status Reports as needed.

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.

Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.

Consistently meet deadlines and requirements for all change requests.

Contributed to value adds during the lifecycle of the project, which improved performance and reduced completion time greatly.

Supervised and provided direction for two technical direct reports regarding technical issues.

Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.

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, IE, MS Office Suite, People Soft, Mainframes and Perl.

Business Analyst Oct 2013 - July 2015

Nisource, Merrillville, IN

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:

Create, edit and modify business and design documents and data flow designs using Microsoft Office Suite. Assist in the creation of the system design and functional specifications for new development projects, using Microsoft Office Suite.

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.

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.

Data querying 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.

Provides assistance and advice to 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. Sr Quality Assurance Engineer Feb 2012 - Sep 2013

PHT Corp, Boston, MA

Project: NetPRO: Web-based ePRO Collection

NetPRO system can be used in clinical trials and post -marketing studies to collect clinician and patient related data via the internet. Clinical data can be viewed by the Sponsor via Study Works portal which is a proprietary system that provides real-time access to data collected using NetPRO. Responsibilities:

Involved in Sprint planning Meetings as part of Agile. Attend Standups regularly for status updates.

Extensively worked on System, Integration and User Acceptance Testing.

Implemented Page Objects, Data Driven automation frameworks using Selenium WebDriver, JAVA, and Junit test framework.

Preparation and Execution of test scripts using Selenium.

Involved in the design of Test cases for UI, functionality and Regression testing.

Created Test Scripts modularly based on technical specifications and in consultation with the project team as and when necessary.

Over all responsibility of end-to-end product testing via Manual and Automation.

Involved in peer review of the Test scripts as well as executing them as per Specification.

Involved in various tests like Ad-hoc testing of the trainer builds, Functional and Regression testing of integrated builds.

Manually manipulate data directly from Oracle database using SQL.

Tracked and documented defects using JIRA defect management tool.

Identified application problems & involved in discussions with the developers and other team members.

Coordinated effectively with developers and project managers and participated in defect review meetings.

Involved in the preparation of Traceability Matrix and validation reports using Quality Center. Software: Selenium WebDriver, XML, Java Script, Junit, Eclipse, Microsoft IIS, MS SQL Server, Windows XP/7, Firefox, Oracle 8i, JIRA, Quality center 10. Sr Quality Assurance Consultant June 2010 - Jan 2012 Freightliner, Bellevue, WA

Project:

Freightliner LLC is the truck manufacturing division of Daimler Group. The project is designed to accept and process warranty and recovery claims from various dealers, suppliers and other vendors of Freightliner across United States and Canada. It provides the users an easier, effective, quick, and hassle-free means for the submittal and processing of these claims. Using this application, Freightliner’s dealers and suppliers can logon, file claims, manage their accounts and check and manage the status of their claims.

Responsibilities:

• Conducted Manual & Automation Testing using the Standard guidelines and structured methodology in testing the application.

• Gathered the requirements and created Test Data.

• Creating of scripts for Selenium in Java to run test cases.

• Documenting and executing Test plans, Test cases and Test Scripts based on baseline requirements.

• Conducted System Testing, Functional Testing and Integration Testing.

• Debugged the software errors and interacted with developers to resolve technical issues.

• Conducted Data Driven Testing based on Excel tables by parameterized test scripts to check application behavior.

• Performed End-to-End Testing and was associated with User Acceptance Testing (UAT).

• Conducted Regression Testing using QTP and identified software errors in Clear Quest and interacted with developers to resolve technical issues.

• Involved in executing test sets in QTP to verify the interdependency of different modules of the application by running batch tests.

• Enhanced QTP scripts using VB scripts.

• Automated test scripts for Functional, GUI validation, Data Driven testing.

• Performed Compatibility testing of the application on different platforms.

• Executed SQL queries to check the data table updates after test execution.

• Used Test Director as bug-tracking tool to centralize the bugs and also to follow up the bug status.

• Participated in periodic walk through meetings and Defect report meetings. Software: QTP, Test Director, VB Script C, C++, HTML, XML, SQL, Java Script, (Solaris 2.5.1), Clear Quest.

Sr. QA Analyst May 2009 – April 2010

Anthem Insurance Companies, Cincinnati, OH

Project:

The application has both intranet and internet portals. Intranet portal was designed for internal anthem users to generate and publish reports from Teradata (data warehouse) using business Objects and for meeting other internal business requirement. Internet portal was designed for both customers for viewing their reports and internal anthem users to provide customer support. ETL processes were used to load data into Teradata database using ETL tools. Testing is conducted to verify the data count, validate data movement, verify data extraction, transformation as per requirement and expectation.

Responsibilities:

• Involved in Preparation of Test Plan and divided test plan into Modules.

• Test scenarios included are Source to target count testing, source to target data testing, data mapping or transformation testing.

• Reviewed and analyzed requirement document for writing the Test cases.

• Responsible for test data preparation and execution of test cases till exit criteria are met, using Bteq SQL queries.

• Automated functionality and testing of application using Quick Test Professional for internet portal.

• Created Test scripts for Functional and Regression tests using QTP. Created synchronization points, various types of check points in QTP including standard, image and text area check point

Performed data driven testing using several ways of parameterization in QTP.

• Performed negative testing to find how the functions performed when it encountered invalid, unexpected values.

• Documented and reported the defects using Clear Quest.

• Performed regression testing on new builds as and when necessary.

• Worked closely with developers in analyzing test results and defining different test approaches.

• Upon successful completion summary report is prepared and closure process is done. Software: Teradata SQL assistant, Bteq SQL queries, Quick Test Professional, VB Script, J2EE, Java Script, HTML, XML, Oracle 8i and Clear Quest.

QA Analyst Jan 2008 - April 2009

US Bank, Cincinnati, OH

Project:

US Bank is the 5th largest commercial bank in the United States. The new web-based credit card presentment system removed to need for monthly paper statements by providing a legal on line document. The various components of the project include Card information, Balance Summary, billing period, finance charges, balance details, statement information, credit balance refund, lost/stolen cards, and archive statement request.

Responsibilities:

• Analyzed Business Requirements and developed Test plans, Test cases, Test scenarios, expected results and prioritized tests.

• Responsible for reporting the Test progress and Defect trends to the senior management.

• Generated Test scripts using Quick Test Pro.

• Creating new automation scripts to test changes in the application and updating existing scripts to incorporate new changes in QTP.

• Enhanced automation scripts by adding Checkpoints, Synchronization points and by making scripts data driven.

• Parameterized the fixed values in checkpoint statements, created data tables for the parameters and wrote functions for the parameters to read new data from the table upon each iteration – Performed Data-driven testing using Quick Test Pro

• Performed System Testing, Backend Testing and Integration Testing of the application.

• Designed Test cases for Positive/Negative Scenarios and also performed rigorous Functional testing on the Application modules.

• Wrote custom defined functions to handle complicated Test scenarios.

• Performed data driven testing for different data sets.

• Used Test Director as the defect-tracking tool.

• Generated customized status reports for the executives using Test Director. Software: J2EE, HTML, Java Script, Web Logic, Windows NT, XP, Oracle and QTP 8.0, VB Script, MySQL, Test director.

Systems Engineer Aug 2001 - Nov 2006

Slash Networks, India

Responsibilities:

• Analyze clients’ needs, design and develop software. Test software applications and systems.

• Create manuals and detailed sets of instructions, algorithms that instruct computers what to do.

• Monitoring, maintaining, supporting, and optimizing all network hardware, software, and communication links and associated operating systems.

• Deploy new applications and enhancements to existing applications, software, and operating systems.

• Manage servers, including e-mail, internet, fax, database, print, and backup servers and their associated operating systems and software. Managing a swift support ticket queue and resolving incidents promptly

• Creating clear, readable documentation.

Software: Software and technologies used are UNIX, Microsoft Windows Server, Active Directory, Microsoft Exchange, Microsoft SQL Server, LINUX, TCP/IP, VPN, FTP, SSL, and VLANS EDUCATION

Masters of Science: MSc Electronics, 2001

Andhra University

Passed with distinction.

Bachelor of Science: BSc Electronics, 1999

Andhra University

Passed with distinction.

Diploma: Internetwork specialist and Linux administration Centennial College, Canada.

CERTIFICATIONS

Software Quality Assurance and Testing (SQAT)

Microsoft Certified System Engineer (MCSE)

Enterprise Network engineering

CCNA Routing & Switching

Contact this candidate