SUMMARY

• I am a Software Engineer with over 10+ years of experience working within the Financial, Banking, and Payroll Industries.
• I have worked on Complex Development and QA assignments. Possess extensive experience in JAVA, Oracle, SQL Server, VB Script, and R - Script. Completed Complex ETL (Extracting, Transforming, and Loading) /Datawarehouse involving Oracle, SQL server, and legacy system.
• Worked as a core member on multi-tier QA assignments, Automated core banking application using Java/Selenium Automation tool and working on Web Services Testing using RESTFUL API. SOAP UI and in Database testing by writing SQL Queries using SQL developer, JavaScript, JSON, REST, and SOAP to be accessed on multiple platforms.
• Created R Script automation script for data validation.

TECHNICAL SKILLS

Languages: JAVA, T-SQL, XML, HTML, C#.Net, ASP .Net.

Data Application Software: SQL Server, Oracle, MS Access, and UML.

Database Modeling: ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas.

Analysis tool: R-Studio, R-Script

Test Automation: Selenium and UFT

Webservice Tool: Ready API

BI Tools: SSIS/SSRS/SSAS, Crystal Reports.

Test Management Tool: Azure DevOps, IBM Rational, HP ALM

Version control tools: Visual Source Safe (VSS), Subversion (SVN), Team Foundation Server (TFS)

Certification: MSP, ISTQB, ITIL, SOAP UI

Others: ER-Win, MS Office.MS Visio

PROFESSIONAL EXPERIENCE

Confidential

Sr. Test Engineer

Responsibilities:

• Evaluate Technical and Business needs, analyze them and provide technical solutions.
• Develop comparative statements, reports to examine the existing functionalities, and present to the stakeholders. I also created Business Process Workflow Diagrams.
• Conducted Testing artifacts presentations to stakeholders and Business users Started implementing Agile/Scrum practices in the upcoming deposit release of core banking.
• I have upgraded and using JAVA, VB Script, R Script, and Oracle across all Automation test implementation.
• I have designed and executed Automation scripts in JAVA utilizing the Selenium Automation tool for building a regression suite, which is compatible with all test environments and completed regression suite on every new build.
• Designed reporting tool using JAVA to report all phases of automation test results.
• Implemented and suggested a new automation framework for the reusability of code.
• I worked on all stages of development processes from extraction, transformation, and loading (ETL). Using SSIS, ORACLE, and legacy applications we performed Data mining from various sources into Data Warehouses and Data Marts
• Writing complex SQL/PLSQL queries for database testing (consumer, commercial, consumer construction lending & Deposits)
• Backend (RDBMS) testing, writing SQL queries, generating reports to ensure data integrity, and validating business rules.
• Verified Test Data generated during the volume test phase for a customer-specific end to end test scenarios.
• I am working on Web Services Testing using RESTFUL API. SOAP UI and in Database testing by writing SQL Queries using SQL developer, JavaScript, JSON, REST, and SOAP to be accessed on multiple platforms.
• An implemented new framework for Webservice tool Soap UI (Ready API), which ultimately reduced manual intervention.
• Created R Script automation script for data validation of Bank interface extracts.
• Used version control tools- SVN, to maintain JAVA and R Scripts
• Working on Azure Dev ops, we are about to achieve complete CD/CI (Continuous Development/Continuous Integration)
• Working and supporting Team on running real-time Mainframe (CICS) and batch job (JCL) process on mainframes environment and perform data validations.
• I am working closely with the architecture team, network team, database team, server support team, and web support teams for performing performance and stress tests effectively.
• I am working closely with Business Analysts in identifying Use cases and Process flow.
• Conducting knowledge sharing sessions among team members, explanations, Q&As. Discussions with Business Analysts, Developers, and Subject Matter Experts.
• Actively involved in Requirements review meetings, analyzed requirements, developing test plan and test cases, Requirement Traceability Matrix, Defect Management, Reporting, and Tracking.
• Collaborated with Senior Leadership Team and Process Owners in the development of appropriate Action Plan to mitigate overall risk, monitor benchmarks of the Action plan, and re-test when remediation is complete.
• Possess strong Documentation skill, and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• I have created and supported Team in the Test design process, reviewing Software Requirement Specifications, creating test scenarios, preparing test cases, reviewing test cases.

Confidential

SQL Developer

Responsibilities:

• Performing End-to-End Scenario Testing.
• Develop Test Scripts for Regression Test Business functionality, Integration and Validation and enhancing the existing Test Scripts.
• Working with the business analyst to regression test customization and extensions.
• Designing Test Plans, Test Scenarios and Test Scripts for Automation and Manual.
• Identifying bugs to report to the developers and tracking the status using JIRA and IBM Rational (Collaborative Life Cycle Management Tool) Creating and executing the detailed test plan and verify fixed bugs.
• Writing test scripts from manual test cases for automating them using selenium tool.
• Giving Product Design Reviews in order to provide the functional requirements and support the application production.
• Performing different Types of testing like Unit, Regression, Integration and Smoke testing.
• Creating Framework environment to develop the test scripts.
• Working experience with Requirement analysis, Test Planning, Test Scripting, test Execution, Defect Management.
• Performing tasks using SOUP UI, WINSCP, R-Script, Ready API, R Studio, SQL PL/SQL, and Oracle 12c.
• Performing tasks using Mainframe CICS, File AID, SPUFI, TSO and UNIX shell commands.
• Create documents for test production to ensure Standards.
• Developing and maintaining the testing Programs.

Environment: MS SQL Server 2005, MS Excel, and MS Office.

Confidential

Data Research analyst

Responsibilities:

• Worked as a web-based research analyst was engaged in researching the details of key decision-makers on the web.
• I was Providing these details to our company to approach on-line sales for client companies in the United States & United Kingdom.
• My job was to find Company details like name, address, telephone numbers-mail id.

Environment: Windows, MS Excel, and MS Office.