SUMMARY:

• Around 13 years of experience as a Software engineer, involving Analysis, Design, development, Testing, Implementation, and Trouble Shooting of J2EE, .NET, Datawarehousing and BigData Technologies
• 6 years of ETL / BI Experience
• 2+ years of experience in Big Data Hadoop and AWS
• Experience in FINANCIALS, INSURANCE and BANKING industries.
• Extensive experience in Manual and Automated Testing of Bigdata, Datawarehouse /ETL and BI
• Good experience in AGILE/SCRUM.
• In depth understanding and knowledge of Hadoop Architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and MapReduce concepts.
• Experience in analyzing data using Hadoop Ecosystem including Hive, PIG and Map Reduce.
• Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Excellent skills in Teradata, DB2, SQL Server and Oracle 9i/8i RDBMS.
• Involved in writing complex test plans and test cases and possess expertise in GUI testing, Performance Testing, Regression Testing, functional Testing, Integration Testing and Regression Testing, User Acceptance a nd Automated Testing.
• Solid Experience in writing SQL queries, stored procedures, functions, packages, database triggers, exception handlers, cursors, PL/SQL records & tables and objects types.
• Experience in writing and Monitoring Batch Jobs using UNIX and Shell Script
• Extensive experience in data condition using C3 /TSYS(Mainframe)
• Responsibilities include application design/analysis, developing Project Plans, coding (documenting all code), and maintaining/upgrading existing applications.
• Involved in the Entire SDLC from requirements gathering through implementation.
• Excellent analytical, inter - personal and communication skills.

TECHNICAL SKILLS:

QA Tools: HP Quality Center (ALM), QTP(UFT)

ETL/BI: Informatica, Cognos; Abinitio

Hadoop: HDFS, Map Reduce, HIVE, PIG, HBase, Sqoop, Oozie

NoSQL: MongoDB, HBase

Technologies: .NET, J2EE, Mainframe, HTML, DHTML & XML

Databases: Oracle 7.x/8i/9i/10g/11g, SQL server 2008/2012, Teradata

OS: Windows, UNIX, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Bigdata Hadoop / ETL Datawarehousing / BI

Responsibilities:

• Worked in Agile Methodology consisting of daily stand up sessions, four week Sprints, Poker planning sessions and task cards.
• Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
• Wrote Hive queries for data analysis to meet the business requirements.
• Tested Hive queries for the analysts.
• Verified Importing and exporting data into HDFS and Hive .
• Worked with Linux shell scripting for moving the files to the Hadoop Cluster.
• Attended daily status call with Offshore to review assigned tasks and solve any impediments.
• Used Oracle SQL developer/SQL server tools for Querying source Database.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during the Testing process.
• Performed Data validity testing for Cognos reports and feeds based on client's requirement.
• Validated format of the reports and feeds.
• Written SQL queries to access the data in SQL Server and Oracle database to execute back-end testing.
• Transformed and loaded the data into target database(ODW/Terdata) using Informatica Power Center; AbInitio
• Worked on SQL tools like TOAD, Oracle SQL Plus, Tera data SQL Assistant to run SQL queries to validate the data.
• Extensively used Informatica Designer, WorkFlow Manager, Workflow Monitor for testing the mapping logic during functional Testing. Performed integrated testing, end- end testing and validated results with Business Analyst and/or customer.
• Used Cognos Query Studio, Cognos Report Studio, Cognos Analysis Studio and to test e various complex Cube reports.
• Writing and executing test scenarios using Gherkin/Cucumber
• Updated weekly status on the testing progress and other concerned issues.
• Involved in Formal Reviews and walkthrough for preparing test plans and test cases.
• Test Case Management using Quality Center.
• Written Test Cases for ETL to compare Source and Target database systems.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Conducted regression testing on the application under test.

Environment: Cloudera CDH4, HDFS, Map Reduce, Hive 0.10, Pig 0.11, Java API, J2EE, AWS, Informatica, AbInitio, Teradata, Cognos 8.0,, cucumber, Oracle 11g, SQL, PL/SQL, UNIX, Shell Scripting, Microsoft SQL Server 2008, Control Version System, Data Center Manager, TOAD, Quality Center 11 (ALM), Agile, Scrum, Github, Udeploy, Jenkins

Confidential, Wilmington, DE

Sr QA Analyst / Lead

Environment: Java 1.5, Visual C++, Test Director, QTP 9.2, Quality Center 9.2, Windows 2000/NT, UNIX, Mainframes, Toad, TIVOLI, F-Secure, MS Office, C3(Mainframes)

Role and Responsibilities:

• Actively leading the QA effort in defining the overall test plan.
• Effective communication with client, cross functional teams to achieve project priorities/timelines
• Expertise with Requirement, Analysis, Design of the system and developing test cases using Quality Center by gathering information from various resources.
• Leading critical modules in the project for various releases.
• Test Data preparation using C3 (Mainframes).
• Extensive knowledge in Database conditioning and validation
• Test Execution of new merger changes and Regression testing
• Batch Test execution using UNIX platform, Scheduling TIVOLI Jobs, Running jobs in F-Secure
• Efficiently performed in various types of testing such as Functionality tests, System tests, Performance tests, Integration tests, White Box tests, Black Box tests, User Acceptance tests, Regression tests.
• Handled IST and FAILOVER testing.
• Worked closely with Development and Business teams to scope requirements, review business requirements, review functional requirement, fix defects, understand functionality
• Create/update traceability matrix & Resource Management
• Cross Block interaction
• Offshore co-ordination
• Automation Execution and Validation using QTP
• Defect tracking and verification till closure

Confidential, Wilmington, DE

Sr QA Analyst

• Involved in gathering the business requirements, Functional & Technical Specifications
• Participated in code review meetings to get the technical documentation.
• Developed Test Plans, Test Scripts and Test Cases
• Developed the test cases using Test Director, Qulaity Center
• Ran the UNIX shell Scripts for batch processing.
• Ran batch jobs using TIWOLI
• Understanding the shell scripts and executing them on UNIX.
• Extensively used PL/SQL Queries to validate the testcases in back end.
• Involved in writing complicated Oracle PL/SQL queries.
• Used SQL Loader for loading tables.
• Loading of the data from Flat files to oracle database using SQL Loader.
• Worked on files using ULtra Editor
• Worked on SQL Navigator
• Hands on Experience in TSYS Green Screens.
• Used MS Excel spreadsheets for Data Conditioning.
• Used Test director, Qulaity Center for bug tracking.
• Used FTP to transfer dump files from production server to testing server.
• Involved in regression testing and integration testing and system testing.

Environment: UNIX, Oracle, SQL, PL/SQL, MS Office Tools, Test Director 8.0, Quality Center 8.2, QTP, SQL Navigator, TSYS iPay / Pay by Touch, Newcastle, DE

Sr QA Analyst

Confidential

• Analyzed business requirements, use cases and dataflow diagrams to achieve better understanding of the application.
• Performed interactive walkthroughs of Test Specifications with Developers, Business Analysts.
• Involved in Payment Server Testing.
• Developed Test Plans in Test Director based on the functional requirements and technical design documents for GUI testing.
• Analyzed Business specifications documents and attended Change Request meetings to document changes and implemented procedures to test changes.
• Grouped the Test Procedures in the Test lab Execution grid for test execution.
• Tested the Web application manually by executing Test cases and updated the status in the Execution Grid of the Test Lab.
• Wrote SQL queries for backend testing, to validate the data stored in the database and performed database integrity checks using SQL.
• Involved in End to End testing of the application by making changes through web, verifying the database, going through settlement processes and verifying the calculations.
• Reported and tracked defects using Test Director.
• Performed Regression testing on the application once the defects are fixed.
• Involved in User Acceptance Testing to ensure that the system under test meets the users needs and provides confidence in its use.

Environment: Test Director 8.0, Win Runner 8.0, Oracle 9i, XML, HTML, DHTML, PL SQL, .NET, VBScript, IIS, UNIX, Windows NT, MS Office Tools

Confidential, Philadelphia, PA

Sr QA Analyst

• Interacted with business People, developers, and other members of the testing team to fully understand the requirements of system changes from both design and end-user perspective.
• Developed and documented comprehensive test scenarios for requirements that cover positive and negative testing.
• Conducted meetings with business owner(s) to baseline the test plan & defined test scenarios.
• Collected Test Data and executed tests as defined in the Test Plan.
• Analyzed results of executed tests to validate that expected results conform to the test plan.
• Created Requirements using Test Director and generated traceability Matrices to ensure that all the requirements are covered by the test cases
• Developed and executed automated test case scripts using Win Runner for the Front-end applications.
• Generated TSL scripts with winrunner
• Modified TSL scripts according to the business requirements
• Extensively used PL/SQL Queries to validate the testcases at the back end.
• Involved in writing complicated Oracle PL/SQL queries.

Environment: TestDirector 8.0, Win Runner 8.0, QTP 8.0, Oracle 9i, XML, HTML, DHTML, PL SQL, J2EE, VBScript, Java Weblogic Server, UNIX, Windows NT, MS Office Tools

Confidential, Wilmington, DE

QA Analyst

• Involved in gathering the business requirements
• Converted the business requirements into functional specifications.
• Participated in code review meetings to get the technical documentation.
• Developed Test Plans, Test Scripts and Test Cases.
• Developed the test cases using Test Director
• Ran the UNIX shell Scripts for batch processing.
• Ran batch jobs using CRON / PROGMAN
• Understanding the shell scripts and executing them as cron jobs on UNIX.
• Extensively used PL/SQL Queries to validate the testcases in back end.
• Involved in writing complicated Oracle PL/SQL queries.
• Used SQL Loader for loading tables.
• Loading of the data from Flat files to oracle database using SQL Loader.
• Hands on Experience in TSYS Green Screens.
• Used MS Excel spreadsheets for Data Conditioning.
• Used Test director for bug tracking.
• Used FTP to transfer dump files from production server to testing server.
• Involved in regression testing and integration testing and system testing.

Environment: UNIX, Oracle 9i, SQL, PL/SQL, MS Excel, Test Director 8.0, SQL Loader, TSYS, C++.