SUMMARY

• Over 7 years of experience in Testing Rest API automation, ETL testing for banking domain and product (BI validator Testing tool) and 1 year of experience as trainer.
• Experience in Testing windows - based application with .NET framework which connects to different environments - OBIEE (10g, 11g, 12c, 18c, 19c), Tableau (9.x, 10.x), MicroStrategy (9.x,10.x), Cognos (10.2.x,11.0.x), Business Objects.
• Experience in Testing product which was developed using - Rest API / SOAP Services, HTTP, Command line, .NET (SDK), CSS, XML, JavaScript, Telerik Devcraft, Devart dot connect driver for oracle, dotnet framework.
• Experience in testing windows-based application - BI Validator Automation tool which connects to BI environment using web services, HTTP and command line requests.
• Experience in testing application, which was built through web services Angular JS, Java script, XML, Apache tomcat, Spring Hibernate, ASP. Net.
• Experience working on the tools or applications -SQL Server, Oracle SQL Developer, MS - Access, Postgres - Pgadmin (10.3), TOAD, SSIS, command line for validations or executions, ALM, Taiga, Trello.
• Experience in checking end to end functionality of BI application for repositories ORACLE (driver type - Direct, OCI) (11g, 12c), Postgres (10.3) against BI connections tools - Oracle, Tableau, MicroStrategy, Cognos, Business Objects.
• Experience in Testing Prompts, Parameters, drill down reports, Filters, Marks, work book parameters, compare Pdf’s for different formats - PDF, HTML, EXCEL.
• Experience in creating, formatting and generation of workbooks, tableau views, worksheets, dashboards, reports in Tableau and OBIEE.
• Experience in Functional testing, stress testing, performance testing, migration testing, upgrade testing, catalog testing, Adhoc Testing across multiple browsers - chrome, Mozilla Firefox, Internet Explorer.
• Experience in testing windows-based server for scheduled test plans and executing through command line.
• Experience in the ETL / Dataware house testing, Application testing, Regression testing, Manual, static testing, smoke testing Sanity testing, Acceptance Testing, Integration Testing.
• Participating in the requirement analysis, reviews as part of the project deliverables.
• Good knowledge on SQL Queries and creating a SQL for scenarios.
• Experience in requirement analysis, creating test plans, Testcases, Test Scenarios and Test summary reports for on / off shore teams.
• Estimating user deliverables along with the team (DEV - QA).
• Coordinating for the release points, bug fixes and retests.
• Experience on working cloud Environment - AWS and large data sets.
• Worked as a trainer (Aptitude, soft-skills and Oracle (SQL)) for graduates and undergraduates.
• Excellent communications skills, strong problems solving skills and a good team player.

TECHNICAL SKILLS

Testing: Application/Product - BI Validator Automation Testing tool, Data warehouse testing/ ETL Testing

Operating System: Windows

Tools: Oracle SQL developer, SQL Server Integration Services - SSIS, BI Validator Automation tool, IBM - Data Studio (DB2), Ab Initio, Unix, Toad, MS-Access, ALM, Trello, Taiga

Supporting Tools / connections for BI validator tool: OBIEE (10g, 11g, 12c, 18c, 19c), Tableau (9.x, 10.x), MicroStrategy (9.x,10.x), Cognos (10.2.x,11.0.x), Business Objects

Languages: SQL, Core Java

Developer Technologies, frameworks: Rest API / SOAP Services, HTTP, Command line, .NET (SDK), CSS, XML, Java Scripts, Telerik Devcraft, Devartdot connect driver for oracle, dotnet framework, GitHub

Data Bases: Oracle (11g,12c), Postgres - Pgadmin (10.3)

Methodologies: Agile, Waterfall model

Testing Methods: Functional Testing, Performance testing, Stress testing, Upgrade, Data Comparison, Regression Testing, Acceptance Testing, Smoke, sanity testing

Repositories: Oracle, Postgres

PROFESSIONAL EXPERIENCE

Confidential, TX

Lead QA Automation Engineer/API Engineer

Responsibilities:

• Developed and implemented cost - effective strategies for updating existing applications.
• SetupReadAPIfrom scratch as an automation tool and developed automated test scripts using property transfer from manual test case.
• Mostly worked with Cases, Contacts, Accounts, Solutions and Reports entities in Service cloud application
• Verification & validation of Inbound Emails as converting as Cases. Validating the Assignment rules of Cases
• Checking the functionalities of Escalation rules of Cases. Testing the Flow functionality of the Cases by using the Call Guides
• Developed and maintained automation test scripts for server functional testing with Selenium Web driver, Robot Framework and Python
• Implemented Page Object Model framework with Python and Selenium.
• Maintained regression suite in MTM for every release covering all end to end scenarios.
• Designed and Developed UAT Regression automation script and Automation of functional testing framework for all modules
• Worked on Integratingteam Citywith Docker to test cross browser through cloud support.
• Developed and implemented robust pattern base testing with SoapUI which cut down the script development time in half.
• Contributed and maintained mobile automation test scripts withSeeTestand Appium in Python
• Working with security testing and performance team and analyzed the root causes for the issues.
• Responsible for implementation of Hybrid Test Automation Framework build using READYAPItechnologies under OOPs concept utilizing industry leading harness design patterns and approaches.
• Involved in testing services likeREST/Soap Using Groovy Script.
• Automated scripts, assertions, test cases in READYAPIusing groovy script.
• Performed gap analysis procedures and detailed data reviews to optimize implementation.
• Established company automation methodology, frameworks and tools.
• Documented meeting minutes and distributed to staff to facilitate follow-up and permanent record.
• Developed and maintained expense budget while applying CI/CD builds to continually decrease expenses.
• Offered pricing and feature recommendations to management and cross-functional teams.
• Supervised production planning while using appropriate tools and analysis for smooth production output.
• Supervised and led employees to high performance levels in cross-functional matrix management structure.
• Debugged code and located root causes of problems by reviewing configuration files and logs.
• Worked on Mainframes(SHARES)which is the backend Global distributed system used mainly in airline industry
• Developed test scripts utilizing comprehensive business requirements, functional documentation and processes.
• Executed Test Cases recorded inMTMto test the application for its functionality, system integration and verify the Exit Criteria.
• Logged descriptive bug report for failed Test cases in Visual StudioTFSsupported with logs and XML documents.
• Worked on the functional testing usingFIDDLERas the primary tool.
• Used Service now for request Ticket assistance, Test Estimates, Employee Support etc.
• Experience in core AWS services (S3, EC2, ELB, EBS, Route53, VPC, auto scaling etc.) and deployment services (OpsWorksand Cloud Formation) and security practices (IAM, Cloud watch and Cloud trail).

Environment: Cloud,Groovy, FIDDLER, Jira, SQL, Web Services (SOAP & RESTFUL), XML,Robot Framework,SOAPUI, Service now,Saleforce.com platform, Apex Language, Visual Force,TEAMCITY,LoadRunner,Python,TFS & MTM, Windows,Kibana, Postman,SharePoint, Service NowSee Test,AWS, Cloud Watch

Confidential, Virginia

Quality Analyst

Responsibilities:

• Expertise in testing product BI validator tool, end to end functionality/flow based on client requirement single handedly.
• Experience in Testing windows-based application with .NET framework which connects to different environment - OBIEE (10g, 11g, 12c, 18c, 19c), Tableau (9.x, 10.x), MicroStrategy (9.x,10.x), Cognos (10.2.x,11.0.x), Business Objects
• Experience in Testing Developer technologies or frame works which are built in - Rest API / SOAP Services, HTTP, Command line, .NET (SDK), CSS, XML, Java Scripts, Telerik Devcraft, Devart dot connect driver for oracle, dotnet framework.
• Participating in the requirement analysis, Developmental changes as part of project grooming.
• Estimating user deliverables along with the team (DEV - QA).
• Preparing and executing manual Testcases based on the existing and the new client requests.
• Managing Oracle and the tableau servers, adding the users with different passwords and permissions.
• Performing smoke testing in the early stages when the builds are released from the DEV to QA team.
• Performing functional, Regression, Integration, sanity, User acceptance Testing before the builds are released to clients.
• Worked for repositories - Oracle (Driver - Direct, OCI), Postgres - Pgadmin against different connections/tools - Oracle,Tableau,MicroStrategy,Cognos, Business Objects
• Creation, Updating and the generation of new / existing Reports, Users, Passwords for Oracle and the Tableau environment according to the requirements.
• Performing Validations for database connections (Oracle, Postgres, OLEDB, ODBC, SQL server (windows and server authentications) for each of the BI Connection environment.
• Worked on the databases - Oracle(11g,12c), Postgres – Pgadmin (10.3).
• Worked on executing / Validation of BI connection against each repository through command line and Web Server (Apache tomcat), GitHub.
• Experience in working Oracle SQL developer, Pgadmin, Command line, Apache tomcat, ALM, Jenkins,Taiga,Trello.
• Experience in creating, formatting and generation of workbooks, Tableau views, worksheets, dashboards, reports in Tableau and OBIEE.
• Experience in Testing Prompts, Parameters, drill down reports, Filters, Marks, work book parameters, compare PDF’s for different formats – PDF, HTML, EXCEL
• Experience in Functional testing, stress testing, performance testing, migration testing, upgrade testing, catalog testing, Adhoc Testing across multiple browsers – chrome, Mozilla Firefox, Internet Explorer.
• Experience in testing windows-based server for scheduled test plans and executing through command line.
• Performed functional testing to identify various critical points in the application and automated it.
• Being part of sprint team, participating in the sprint ceremonies (project and sprint grooming, daily scrum, sprint planning, review meetings, sprint demo) and the client calls on the product.
• Publishing or reporting bugs along with the test results within the team
• DEV –QA Coordination for the release notes, bug fixes and retests.
• Experience on working Cloud Environment – AWS and testing large data.
• Documenting knowledge on the BI validator tool (editing or updating) to build continuous improvement and learning capabilities and the best practices.

Environment: s: Windows XP, Oracle SQL Developer, Pgadmin, Jenkins, XML, HTML, CSS, OBIEE, Tableau, MicroStrategy, BI Validator tool, Fiddler,ALM, Taiga, Trello, GitHub, Command line Interface - CLI

Confidential, Atlanta, Georgia

Test Engineer

Responsibilities:

• Performing Static Testing as soon as the mapping document is shared, Analyze and report to the Development team accordingly.
• Experience in ETL Test execution, Defect Tracking and reporting.
• Worked on waterfall and Agile environment.
• Experience on working Microsoft Office.
• Hands on Experience on Test Management / ETL Tools - SQL Server Integration Services (SSIS), Oracle SQL Developer, TOAD, Microsoft Access (MS - Access), IBM Data Studio – DB2.
• Experience in Analysis, design, testing, and implementation of solutions using data ware or data mart.
• Experience in writing test cases, test scenarios, test scripts and analyzing test results.
• Experience in Analyze/interpret test results and provide recommendations to improve testing.
• Proficiency in ETL data validation using complex SQL queries.
• Experience in Cloud Environment - AWS
• Experience testing large data
• Develop complex SQL scripts (Primarily SQL) for ETL.
• Understanding the requirements and prepare the test cases.
• Creating of test instances in ALM accordingly the requirements.
• Execution of test cases or performing validation by using SQL Queries in the SQL server, MS-Access and TOAD.
• Check with the data and the count if they are matching in both Dev and QA environments and reporting if there are any differences.
• Involved in the daily onshore and off shore status calls.
• Raising defects in the ALM and bringing them to closure by communicating the Dev team.
• Involved in defect analysis and closing them in time.
• Sending the status reports on daily basis.
• Educating new team member regarding the project.

Environment: s: SQL Server Integration Services (SSIS), Oracle SQL Developer, Microsoft Access MS-Access, TOAD, IBM Data Studio – DB2, ALM, Ab Initio,Java, Angular JS

Confidential, Atlanta, Georgia

Test Engineer

Responsibilities:

• Performing Static Testing as soon as the mapping document is shared, Analyze and report to the Development team accordingly.
• Experience in ETL Test execution, Defect Tracking and reporting.
• Worked on waterfall and Agile environment.
• Experience on working Microsoft Office.
• Hands on Experience on Test Management / ETL Tools - SQL Server Integration Services (SSIS), Oracle SQL Developer, TOAD, Microsoft Access (MS - Access), IBM Data Studio – DB2.
• Experience in Analysis, design, testing, and implementation of solutions using data ware or data mart.
• Experience in writing test cases, test scenarios, test scripts and analyzing test results.
• Experience in Analyze/interpret test results and provide recommendations to improve testing.
• Proficiency in ETL data validation using complex SQL queries.
• Experience in Cloud Environment - AWS
• Experience testing large data
• Develop complex SQL scripts (Primarily SQL) for ETL.
• Understanding the requirements and prepare the test cases.
• Creating of test instances in ALM accordingly the requirements.
• Execution of test cases or performing validation by using SQL Queries in the SQL server, MS-Access and TOAD.
• Check with the data and the count if they are matching in both Dev and QA environments and reporting if there are any differences.
• Involved in the daily onshore and off shore status calls.
• Raising defects in the ALM and bringing them to closure by communicating the Dev team.
• Involved in defect analysis and closing them in time.
• Sending the status reports on daily basis.
• Educating new team member regarding the project.

Environment: s: SQL Server Integration Services (SSIS), Oracle SQL Developer, Microsoft Access MS-Access, TOAD, IBM Data Studio – DB2, ALM, Ab Initio, Java, Angular JS

Confidential

Responsibilities:

• Performing Static Testing as soon as the mapping document is shared, Analyze and report to the Development team accordingly.
• Experience in ETL Test execution, Defect Tracking and reporting.
• Worked on waterfall and Agile environment.
• Experience on working Microsoft Office.
• Hands on Experience on Test Management / ETL Tools - SQL Server Integration Services (SSIS), Oracle SQL Developer, TOAD, Microsoft Access (MS - Access), IBM Data Studio – DB2.
• Experience in Analysis, design, testing, and implementation of solutions using data ware or data mart.
• Experience in writing test cases, test scenarios, test scripts and analyzing test results.
• Experience in Analyze/interpret test results and provide recommendations to improve testing.
• Proficiency in ETL data validation using complex SQL queries.
• Experience in Cloud Environment - AWS
• Experience testing large data
• Develop complex SQL scripts (Primarily SQL) for ETL.
• Understanding the requirements and prepare the test cases.
• Creating of test instances in ALM accordingly the requirements.
• Execution of test cases or performing validation by using SQL Queries in the SQL server, MS-Access and TOAD.
• Check with the data and the count if they are matching in both Dev and QA environments and reporting if there are any differences.
• Involved in the daily onshore and off shore status calls.
• Raising defects in the ALM and bringing them to closure by communicating the Dev team.
• Involved in defect analysis and closing them in time.
• Sending the status reports on daily basis.
• Educating new team member regarding the project.

Environment: s: SQL Server Integration Services (SSIS), Oracle SQL Developer, Microsoft Access MS-Access, TOAD, IBM Data Studio – DB2, ALM, Ab Initio, Java, Angular JS

Confidential

Analyst

Responsibilities:

• Responsibilities are to use GIS technology to integrate biophysical, ecological and socio-economic data that can be analyzed for purposes such as tracking and monitoring water bodies, Sign boards.
• GIS data sources are digital and can be easily be updated, allowing GIS analysts to produce up to date maps using multiple data sets to customize the information for industries and audiences.
• Meeting the timely deadlines.
• Sending daily reports among the team regarding daily tasks, ongoing, completion and defects.
• Involved in daily project meetings.
• Educating new team member’s

Environment: s:Windows, Confidential Maps