PROFESSIONAL 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.

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, Devart dot 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, 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.
• 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.
• 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.

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

Confidential, Mountain View, California

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

Confidential

IT Analyst

Responsibilities:

• Presenting Workshops to graduates/undergraduates and guiding them on SQL/PGSQL
• Educating graduates and undergraduates in Aptitude (Math), soft skills and in PG/SQL.
• Involved in meetings
• Sending status reports on weekly basis.

Environment: s: SQL, Aptitude, Soft skills