SUMMARY:

• IT professional with over 8 years of working experience for globally leading IT giant - Confidential and 1+ year internship as SDET at Confidential, Bellevue, WA
• Excellent understanding of Software development Lifecycle (SDLC) of application development and Test Methodologies from Project definition to post deployment documentation.
• Expertise in designing and developing strategic Test plans, Test Cases, and Test Reports for manual test
• Experience preparing test cases based on system requirement specifications SRS, Design Document, reviewing with developers and finalizing test cases
• Experience working on automation tool like Selenium with JUnit framework and manual testing like Quality Centre .
• Excellent hands on experience in handling defects throughout the bug life cycle from detection to resolution using JIRA and Bugzilla
• Expertise in White box testing, functional testing, Integration testing, Database testing, Regression testing, User Acceptance testing, Blackbox testing, Ad-Hoc and End-to-End testing
• Experience testing web based applications and mobile applications
• Experience in SDLC using the Waterfall Model and good understanding of Agile Methodology.
• Good understanding of Lean Six Sigma Methodology
• Good knowledge on JAVA . Written multiple scripts in JAVA to generate reports by connecting to database through JDBC
• Strong Foundation on RDBMS and excellent at writing Complex SQLs, PL/SQL Functions and Procedures, and creating SQL Objects - Tables, Views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections and other ORACLE facilities such as Import/Export, SQL Loader and SQL PLUS
• Experience working in UNIX environments and performing tests using shell scripting.
• Familiarity with scripting languages like Java Script, HTML, CSS
• Working experience on Hadoop ecosystems like Pig, Hive, HDFS, Sqoop
• Accomplished experience in developing software solutions for major bellwether Banks of USA and UK
• Have handled Effort estimation & resource planning based on business requirements and delivery timelines
• Managed development teams in onsite-offshore delivery model
• Good team player and can work individually in both development and maintenance phases
• Exceptional ability to adapt to latest technologies, innovative and organized aspects
• Committed team player with good interpersonal skills and ability to handle multiple tasks

TECHNICAL SKILLS:

Languages: PL/SQL, T-SQL, JAVA, C++

Database: Oracle 10g, SQL Server

Tools: & Frameworks: SQL Developer, PL/SQL Developer, TLM and SWIFT applications

Server: Weblogic 9.2,10, Apache Tomcat

Operating System: Windows, Linux

Testing Tool: Selenium, Quality Control

Defect tracking Tool: Quality Center, Bugzilla, BitBucket

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Oozie

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Big Data/Test Engineer

Technology/Environment: Big Data Ecosystem/Linux

Responsibilities:

• Analyzed huge authorized website data collected by external sources to generate single (golden) record of providers and Loaded unstructured data into Hadoop File System (HDFS).
• Developed Pig scripts for data cleaning and processing. Created User Defined Functions (UDFs) in Java to format the output on Hadoop
• Used Sqoop to import data to HDFS/Hive and Created reports for analysis using Hive.
• Installed and configured Hadoop ecosystem components, implemented Cloudera Manager Hadoop cluster
• Configured SQL database to store Hive metadata.

Confidential, Bellevue, WA

SDET

Technology: PHP, JQuery, Java Script, SQL Server

Tools: Bitbucket, Selenium Web driver, Selenium IDE

Responsibilities:

• Worked closely with Business Analysts, Developers & Project Managers to discuss and collect business requirements and participated in design sessions and application walkthrough and reviewed high level scenarios
• Prepared functional / business requirement documents, Use cases and Screen flows of the application.
• Worked in Agile/scrum process and actively participated in developing test plan.
• Developed Test Cases and performed Functional, UI, Compatibility, Exploratory, Ad-hoc, System and Regression testing
• Performed UI testing, Usability, Functional, Regression, Positive, Negative Testing and conducted Performance testing.
• Analyzed the production defects and raised tickets in Bitbucket .
• Developed Automation test scripts using Selenium IDE and Selenium WebDriver for web application
• Coordinated with developers and discussed issues to take timely action.
• Generated reports on daily basis to communicate testing status

Confidential, NEW YORK

Module Leader

Technology: PL/SQL, T-SQL, Unix, SQL Server

Responsibilities:

• Requirement Analysis, design and development of enhancements routed through JIRA
• Built new custom objects using PL/SQL and Perl scripts, by independently handling requirements gathering till development
• Autosys job creation and scheduling reports based on user requirements
• Involved in QA activities including System testing and User Acceptance testing for deployments
• Provided mentorship and Technical guidance on SQL scripting and business understanding to my team
• The data patterns identified from the discrepancies were presented to the user community, along with recommendations for improvements for Agile development

Confidential

Project Leader

Technology & Tools: Oracle PL/SQL, Linux, SWIFT suite of products, JIRA

Responsibilities:

• Worked directly with clients for various production requirements and created Technical Design documents. Requirement analysis & design documentation for on-boarding GORILA (Global Resilient Integration Layer)
• Performed the role of SDET in addition to managing a team and provided continuous support for all the day today activities involved as part of SWIFT maintenance like Message monitoring in SAW, Data Control activities etc. and received critical acclaim from clients for successful delivery
• Generated PL/SQL scripts as part of GORILA (Global Resilience Architecture) Architectural upgrade to check for data integrity for all transaction tables.
• Involved in testing phase of Oracle migration project and provided test evidences for routing configuration available for all BICs set on Nomura SWIFT network.
• Prepared unit test cases/ scripts and performed Unit Testing.
• Performed peer reviews and review of test cases prepared by team members
• Carried out QA activities including system integration testing to make sure the deliverables are in match with business requirement
• Was solely Accountable for all the quality/process related activities including project Audits and Management Reviews for Nomura Project
• Responsible for handling end to end migration of environment from a regionalised SWIFT architecture to globalised resilient layer using a product called Incentage.
• Routing rule configuration on GORILA that uses Oracle database and Java framework for providing interface between back-office systems and SWIFT
• Anchored several process improvement initiatives for brining-in business benefits to clients
• Got appreciation from customer for a large automation done using Java/SQL scripting for comparing architectural changes in GORILA Incentage product. This was a key driver for implementing the SWIFT GORILA project successfully and brought in a significant reduction in manual effort.
• Received accolades from clients for quick adaptability and support for GORILA implementation for Tokyo region within a short span of time. The activities included daily calls with users for requirement gathering, conversion to business requirement document, sign-off on BRD, technical requirement document sign-off, development, testing, UAT and implementation.

Confidential

Project Leader

Technology: SYBASE, UNIX, TLM (Transaction Lifecycle Management)

Tools: JIRA, SQL Developer, TLM Application

Responsibilities:

• Managed a team of 5 in addition to my individual responsibility of being a SDET and provided end to end support for all BAU activities on TLM
• Performed Requirement analysis & provided design documentations for all requirements on reconciliation between various Back-office / Middle-office systems
• Configured business rules on TLM and provided solutions for reconciliation between various systems in Nomura using Sybase database
• Adhoc procedures/scripts created for verifying reconciliation data in Sybase environment based on rule logic configured
• Actively encouraged team & provided many process improvement proposal for customers to benefit on their daily business activities
• Developed test scenarios and test cases based on requirements in BRD
• Single point of contact for all quality/process related activities which includes project Audits and Management Reviews for Nomura project
• Received process improvement award at TCS BFS unit level for successfully implementing Reconciliation solutions using LEAN SIX SIGMA Methodology. The DFSS (or DMADV) approach was taken in order to solve process problems to achieve service effectiveness with about reducing process time for 50 reconciliations from few hours to minutes thereby achieving great customer satisfaction.
• Responsible for setting up TCS Nomura Centre of Excellence (CoE) for mentoring trainees on Reconciliation and the product, TLM
• Took initiative to design a JAVA based reconciliation tool using Eclipse framework to provide a high performance, accurate result for data reconciliation between 2 systems. The effort on this initiative was appreciated by Managers & peers.

Confidential

Database Administrator

Technology: Oracle 10g, PL/SQL, TLM Application

Tools: TLM Applications like TLMControl, Smart schema, Design Studio, Recon Admin, Security Admin, Configuration Import and Configuration Transfer, Solaris 5.10, Windows Web logic 9.2

Responsibilities:

• Installed Oracle 10g software in the Solaris environment
• Administered database for application users, Monitored Database for its proper performance
• Back up the functional Database
• Matching Statistics Report as required by the Client (Based on the sql provided by clients, analyzed and wrote PL/SQL scripts for generating matched stats report based on inputs provided by user)
• Received appreciation from my peers & managers for performing tasks in addition to database administration. Responsible for providing JAVA solution to read all files in a directory and generate report with the count of Accounts, Transactions received from Client. This helped the project to know the count of transactions received without even loading them on database.

Confidential

Module Leader

Technology/Environment: C++, Oracle 10g, Java, Solaris 10, Windows Weblogic 10, MasterCraft V 7.0

Responsibilities:

• Analysed the working Rule Engine System of the Compliance system in C++ version and re-designed the rule engine module in Java retaining the backend table structure and functionality.
• Analysed the C++ version of Rule engine of Compliance system used for cash banking
• Customised the Rule engine that was written on C++ and provided a Java based solution with oracle database interaction for meeting business requirements for Market Surveillance system
• Re-engineered C++ version of Rule-engine, customised and tested within a small time interval (3 weeks)
• Was responsible for setting up test environment and providing demo on Java based surveillance product end to end for client, London Stock Exchange. The presentation on the various aspects of the product was critically acclaimed by my managers