PROFESSIONAL SUMMARY:

• Strong knowledge of Java.
• Excellent knowledge of manual testing and various methodology of software development lifecycle.
• Extensive experience in Selenium software testing
• Proficient in Linux
• Experience using Hadoop Administrative
• Strong understanding of Business process management, Business Process Automation (BPA), Business process Improvement (BPI) and Business Process Reengineering (BPR).
• Extensive experience in gathering and documenting business requirements. Proficient in writing Business requirement Document (BRD), Functional Requirement Document (FRD) and detailing into system requirement specification (SRS).
• Excellent in performing Gap analysis to check the compatibility of existing system infrastructure with the new business requirements and proficient in documenting As - Is and To-Be business processes.
• Proficient in giving walkthrough and creating Unified-Modeling language (UML) diagrams for business process modeling like Use Case, Sequence Diagram, State Chart Diagram, Activity Diagram etc.
• Proficient in creating screen mock-ups, wire frames and user interface documents using tools like Just in Mind, SnagIt, andAxure etc.
• Extensive experience in developing and reviewing test plans, test scripts, test requirements, test case, test reports and in using Defect-Tracking Tool to address bugs/issues as required.
• Expert in tracking and managing requirements through Requirement Traceability Matrix (RTM).
• Strong Experience in writing Test Plans and Test Cases for User Acceptance Testing (UAT), managing test script execution for System/Integration Testing, Regression Testing, Progression Testing, and conducting Smoke Test.
• Strong technical skills in SQL to extract data for data analysis and user interface (UI) testing.
• Proficient in Pig
• Strong knowledge of Hives

TECHNICAL SKILLS:

Requirement Management Tools: Sybase Power Designer

Requirement Modeling Tools: Power Designer, MS Visio

User Interface Design Tools: SnagIt, Smart Draw, Just In Mind, Axure

Database Tools: Oracle, SQL Server, MS Access

Operating Systems: Windows 8/7/NT/XP/Vista/2003, Mac OS

Defect Tracking Tools: Silk Central, JIRA, Quality Central

PROFESSIONAL EXPERIENCE:

Confidential

Hadoop Admin

Responsibilities:

• Assist in designing and ensuring overall quality of testing process.
• Assisted in designing, developing, and implementing test plans, scripts, and tools using the detailed business requirements document provided by business analyst.
• Worked with business and technology leads to identify the appropriate data for testing and prepare data for test cases.
• Assist application developers and technical support team in identifying and resolving problems
• Assess and revise test sequences and scope based upon test results and changes in product design.
• Coordinate component, systems and documentation, testing with appropriate technical group and release management.
• Document test procedures and findings
• Reconcile test results from different tests and different groups.
• Hadoop Cluster capacity planning, performance tuning, cluster Monitoring, Troubleshooting
• Design Big Data solutions for traditional enterprise businesses.
• Backup configuration and Recovery from a NameNode failure.
• Experience in HDFS data storage and support for running map-reduce jobs.

Environment: Windows 8, PL/SQL Server, Oracle Database, Java, MS Excel, MS SharePoint, Selenium, Manual testing, Test NG, J Unit, Maven, Hadoop, Pig, Hive, Map Reduce, Linux, WebDriver.

Sr. Data QA Analyst / Tester

Responsibilities:

• Created, developed and executed test cases and test scripts manually and using automation tools.
• Analyzed business requirements, functional specification & required documents for Manual Testing.
• Reviewed project specs and worked closely with BA and Development for creating Test Cases.
• Responsible for writing SQL queries, PL/SQL and executing SQL queries to perform backend testing.
• Coordinated with Fixed Income, Equity and Foreign Exchange Operations staff to support User Acceptance Testing. Executed use cases and test cases manually.
• Extensively done Data Centric Testing (data testing requiring data to be moved, copied from source to target systems correctly and completely, Checksum comparison, checking quality of data).
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Executed scripts from Test Lab and Test Cases in Quality Center (QC), verified testing results against expected results and tracked defects.
• Reviewed Business Requirements, Functional Requirements and Technical Specifications to create a comprehensive set of Test Cases and Test Scripts in QuickTest Professional (QTP).
• Created test data for all ETL mapping rules to test the functionality according to requirements.
• Supporting presales activity for Data centric warehouse testing projects.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Performed backend testing using SQL queries to ensure data integrity and actively communicate with DB team to ensure proper test coverage.
• Worked as a consultant in delivering quality data centric solutions for various business domains.
• Worked on 3rd party Vendor tools like LivePerson, Five9, Adobe Insight, Adobe Site Catalyst which were integrated with 24hr and Mortgage banking applications of Salesforce.
• Performed Data Accuracy, Data Validation, and Data Integrity testing by querying the database using SQL Queries to check the data table on the Server.
• Responsible for testing all new and existing ETL data warehouse components.
• Designed and developed UNIX commands as part of the ETL process, automate the process of loading, pulling the data.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Experienced at testing ETL's and flat file data transfers without relying on a GUI layer.
• Involved in Data centric testing using various approaches such as checksum approach to discover errors, identifying records with MD5.
• Tested the APL Trading System for Committing, Executing and allocating the Equities, FX, fixedIncome, Bonds and funds. Ran the Control jobs for performance testing.
• Responsible for ETL batch jobs execution using UNIX shell scripting to load data from core database to Staging and Data mart tables.
• Designed testing approach for ETL process in the Credit Data Provisioning Enterprise Data Warehouse (CDP).Ensure consistent and effective communication among all parties.
• Perform backend SQL data verification concurrent to regression testing in SQL Management Studio.
• Performed UI, Functional, Integration, Back-end, Regression, and Browser Compatibility Testing.
• Perform extensive Data, UI and Regression testing, create repository, source and target databases and develop test strategies for Extraction, Transformation and Loading (ETL) testing.
• Created and executed several stored procedures and complex SQL queries for ETL testing. Manage the entire Database testing and data validation of the project.
• Worked deeply into ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Established a business-centric data check like comparing/contrasting daily transaction and dollar volumes between the loaded DW data, and Cognos reports
• Daily operations also includes working with MS Word, Excel, PowerPoint, Lotus Notes, and MS Project, Kronos Timekeeper.
• Work in Agile environment and provide black box testing for Salesforce CRM features.
• Used the project deliverables to determine testing requirements that define the testing to be developed and executed for the project.
• Ran Manual Test Cases & Scenarios, and defined user behavior, monitored performance, analyzed results.
• Wrote SQL queries for database backend testing, research and validation.
• Engaged in various meetings with the Compuware customer service representatives to perform diagnostic testing of the automation tool in case of object recognition failure or any other critical testing issue. Installed patch accordingly
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Executed SQL Queries to retrieve data from tables and to create views and perform backend testing
• Defined and performed the test strategies and associated scripts for the verification and validation of the application and ensured that it meets all defined business requirements and associated functionality.

Environment: Windows XP, Mac OS, ETL Testing,Waterfall,Agile Salesforce CRM, Lotus Notes Mail, XML,Quick Test Professional (QTP), TFS Bug Testing, Windows, MS Project, VISIO, MS Office, JIRA, Pervasive PSQL, XML Spy.

QA Analyst

Responsibilities

• Involved in gathering Business Level Requirements and reviewed manual testing methods
• Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
• Responsible for writing Test cases to cover overall quality assurance using Test Director
• Created Test Plan, Test Strategy, Test Procedure, Test estimation and Test Scenarios for different phases of testing.
• Gathered and analyzed the Software Requirement Specification and User requirements.
• Involved in the error and duplicates checking post successful completion of ETL script.
• Created comprehensive test cases for the different product suites and components in the test Management tool Quality Center.
• Efficiently communicated the testing issues with Project Management and the Development Team.
• Participated in Joint Application Development (JAD) sessions involving the user community to identify, analyze and formalize requirements
• Developed Test Strategy from the Use Cases and the Business Requirements, Functional Requirements development Methodology.
• Performed functional and regression testing of test scripts.
• Involved in end-to-end manual testing.
• Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
• The tests also included GUI testing: Testing for validation and display of screens
• Created dummy accounts on our system and verified the account generation process and date integrity

Environment: Windows, Mainframe, DB2, Oracle Apps Finance,Waterfall, Agile, Quick Test Professional (QTP), TestDirector, MS Office, Quality Center.

QA Analyst

Responsibilities:

• Developed Requirements Traceability Matrix to map test cases with Requirements using Quality Center.
• Estimated QA and Development department tasks, timings, and resources.
• Provided level of effort estimates at individual test case level to facilitate iteration test planning.
• Wrote test scripts to perform sanity testing and conducted smoke-testing during major software deployments to ensure minimum expected system behavior.
• Coordinated with developers and customer support team in the area of product release scheduling, prioritization of product features, and quality control.
• Parameterized steps, checkpoints and variables in the script to run the test on multiple sets of data.

Environment: Quality Center, Teradata, MS Word, MS Excel, MS Visio.