SUMMARY

• 8 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Proven skills in all phases within the software development lifecycle and very strong in the implementation and maintenance of Quality Engineering Processes.
• Experience in the development of Test Plans, Test Cases, Test Procedures and Executing Manual and Automation test cases.
• Extensive experience as Manual testing and Automation using tools like Selenium
• Written Test Plans, Test cases, test scripts and Requirement traceability matrix.
• Experienced in testing both ETL and BI applications.
• Experience in all aspects of Software Development Life Cycle (SDLC) with specific focus on testing.
• Experience in bug reporting and bug tracking using management tools such as Quality Center and communicated recorded problems to the responsible QA or development personnel.
• Adept in using testing tools like Test Director, HP Quality Center, ALM to write and maintain Test scripts
• Experienced in Automating Web applications using Selenium Webdriver and using Java
• Extensive experience with Agile Methodology and used tools like Rally to write stories and track the tasks.
• Worked on Webservices SOAP UI and SOATest and validated Request and Response.
• Extensive knowledge in regression testing and design documentation.
• Strong Skills in using Integration, Functional, Regression, End to End, Ad Hoc and UAT Testing.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Was involved in setting up the test environment, created test data as per the requirement.
• Experience in testing and writing SQL statements.
• Experience in all phases of Software Development life cycle.
• Expert in documenting and creating test data, test scenarios, test plan & test strategy document.

TECHNICAL SKILLS

Java & J2EE Technologies: Core Java, Servlets, JSP, JDBC, JNDI, Java Beans

IDE’s: Eclipse, Net beans

Development Frameworks: MVC, Struts, Hibernate, Spring

Programming languages: Apex, C++, Java, Java Script, Node.JS, JSON, R, Python, Ant scripts, Perl, Linux shell scripts, Scala

Build Management Tools: Apache Maven, Apache Ant

Version control: SVN, ClearCase, Perforce

Databases: Oracle 11g/10g/9i, MySQL, DB2, MS-SQL Server

Web Servers: Web Logic, Web Sphere, Apache Tomcat

Web Technologies: HTML, XML, JavaScript, AJAX, SOAP, WSDL

Network Protocols: TCP/IP, UDP, HTTP, DNS, DHCP

ETL Tools: Informatica, Pentaho, Ab initio

Testing: Selenium WebDriver, QTP

Reporting Tools: Tableau,D3

Architecture: Unified modeling Language Design Patters and Object Oriented Analysis and Designing

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Automation Engineer/ Force.com Developer

Responsibilities:

• Extensively worked on all phases of SDLC i.e. requirement gathering, gap analysis, worked with developers, building test strategies which involves test scenarios, test cases, test execution, and post production validations.
• Worked on projects in validating websites, webpages, online orders, online transactions, and online to store related business scenarios, Shared Services and Legal-IT.
• Worked on development of Shared Services VAT API Metadata.
• Extensively worked on developing functional automation using the Apex Unit tests and Kumonium.
• Extensively written test plans, test cases and test scenarios in QA FORCE
• Automated the web applications using Selenium Web driver using Java
• Identified web elements using xpath checker and firebug
• Worked with different browsers and cross platforms.
• Worked with several cross functional teams with in enterprise landscape in identifying the requirements, understanding the data flow within each system, and executing end to end test scenarios.
• Worked on Agile and Waterfall methodologies.
• Worked with business users in assisting for UATs and documentation.
• Performed Functional Integration, System, Regression, End to End, Ad Hoc and UAT Testing.
• Created and joined tables in MS Access and generated desired output as a part of data validation.
• Tested several mapping rules as per the business requirements.
• Extensively wrote several simple to complex SoQL (Salesforce Object Query Language) Queries using various joins and Sub Queries.
• Developed selenium scripts to automate WORKDAY UI.
• Uploaded and executed test cases in QA Force. Also logged defects and assigned to concerned developer.
• Extensively used MS Excel and MS Access to validate data between source and target.
• Performed Audit Testing based on various scenarios.
• Validated Unicode data from source to target.
• Validated Transactional data on a weekly basis.
• Extracted and validated flat files using UNIX environment.
• Worked on PUTTY TEL to run the integration server jobs
• Worked on Apache ANT for Code deployment to developer and testing environments (Sandboxes).
• Used Apache Maven for dependency and build management of projects.
• Used Perforce (Version Control Tool) for maintaining the different revisions of the projects.

Environment: Apex, Selenium (WD), Kumonium, Apache ANT, Apache Maven, QA Force, Perforce, SoQL, MS Access, Jenkins, Excel, Unix, Putty, GUS (Agile Tool).

Confidential, Fair Haven, MA

Automation Engineer

Responsibilities:

• Plan and Execute the Test Plan for Confidential Fulfillment Feedback project.
• Reviewed Functional requirement and Use Cases documented in Requisite Pro.
• Created test scenarios and test cases based on functional documents and User stories.
• Setting Test plan and Test Lab in the Quality center for the projects to create and access requirements, defects, test cases and reports for the status.
• Created and executed detailed test cases with step by step procedure and expected results and maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Used Quick Test Professional (QTP) for regression testing and running the automation suite.
• Responsible for software QA and analysis, with emphasis on performance testing and functional decomposition of web - based (SOA) and legacy systems architecture.
• Created automation test scripts to test all end-to-end components -- legacy mainframe, Web and upgrade.
• Conducted test case reviews and presented the test cases/test scenarios to the team members for all iterations.
• Participated in daily SCRUM meetings and gave the daily status of testing.
• Optimized Quick Test Professional (QTP) scripts for Regression testing of the application with various data sources and data types.
• Inserted checkpoints where needed, to compare the current behavior of the application being tested to its behavior in the earlier version using Quick Test Professional (QTP)
• Customized the QTP test as per the test Case by using the VB-Script
• Executed SQL queries to verify the database for the relevant test cases.
• Documented the defects in Quality Center and assigned them to relevant developer.

Environment: HP Quality Center 10, QTP 11.0, VB Script, Java, HTML, DHTML, CSS, Web farm, IIS web Servers, IBM Web Sphere, RAD, DB2, ETL (Informatica 8.6.1), UNIX, Micro Strategy, IBM Rational Clear QuestV7.0, IBM Functional tester, Windows XP, SQL Server 2008, Oracle 10g, MS Excel, HP Quality Center, TOAD, Win SQL, Teradata SQL Assistant, XML Spy 2010, XM L Files, MVS, JCL, COBOL II, Copy Books, VSAM Files, CSV Files

Confidential, Providence, RI

Automation Engineer

Responsibilities:

• Extensively tested the web applications and performed integration testing between ERP and CRM applicatio
• Extensively written both Manual and Automation test cases.
• Involved in verification, validation, functional, GUI, system integration, sanity, and regression testing
• Validated data from source to stage and stage to target database.
• Worked on Informatica workflow monitor to create and execute workflows
• Performed record count from source to target database
• Created and implemented Micro Strategy reports by creating projects, schema objects and public objects, Attributes, hierarchies, metrics, filters, and templates.
• Extensively worked with flat files and Excel sheet data sources. Wrote scripts to convert Excel to flat files.
• Tested Services using Soap UI and SOA Test for request and response
• Prepared test/Seed data for various positive and negative testing scenarios.
• Performed tests to check whether there is any loss of data during data loads
• Tested reports daily, weekly, monthly based reports
• Tested Micro Strategy reports and written test cases using HP Quality Center.
• Automated Web applications using Selenium RC using java.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Extensively worked on Quality center to execute a bunch of test scripts.
• Logged the defects found in quality center while execution of test scripts
• Tracked the bad records present in the table.
• Validated the data present from flat files to database
• Tested Daily, Weekly, Biweekly and Monthly data loads.
• Tested the layout of the table from the database to the data model.

Environment: Teradata SQL assistant 13.0, Micro Strategy, Toad for Oracle10g, Informatica Power Center 8.6.1, MS Excel, Erwin Data Modeler, SQL loader, Quality Center, Cobol Files, SAM Files, UNIX, Business Rules Repository GUI(BRR), Business Process Application GUI(BPA), Data Quality Monitor GUI (DQM)

Confidential, Charlotte, NC

Automation Engineer

Responsibilities:

• Responsible for writing Test Cases, Test Plans, Test scripts and other test documents based on business requirement.
• Responsible for data validation testing using SQL and executing testing on data Warehousing projects.
• Responsible for developing detailed UAT test plans, conditions, scenarios, cases and related data and participate in UAT planning and execution activities for business and operations participants.
• Developed Test Plans and developed Test Cases/Test Strategy with input from the assigned business analysts and data architect.
• Performed Manual Testing and Automation of Web applications.
• Have attended Scope Analysis, Requirements workshops to understand the business requirements and written test plans based on it.
• Developed and Tested UNIX shell scripts to move source files to archive directory.
• Involved in extensive data validation using SQL queries and back-end testing
• Used HP Quality Center for test scripts creation, execution, test coverage and defect tracking
• Used TOAD, DB Artisan tools to connect to Oracle database to validate the data that was populated by ETL applications.
• Used standard testing techniques to test the data validity before deploying the Micro Strategy Reports to Users.
• Worked with integration services for transferring and reviewing data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Worked on Clear Quest to log defects and track resolution till the closing of defect after retesting.
• Used Informatica ETL tool for Extraction, Transformation and Loading the data into target database.
• Tested ETL Packages, Scripts from development to QA environment.
• Plan tests with Quality Center (Design Steps and Run Tests) and also prepared detailed documentation with Screen Shots
• Tested the reports using Micro Strategy functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Tested whether the reports developed in Micro Strategy are as per company standards.
• Developed test reports and participated in testing prioritization and archived test results and user signoff.
• Involved in extensive data validation using SQL queries and back-end testing
• Used SQL Server Management Studio for Querying SQL Server 2008 databases.
• Strong Informatica and data loading experience.
• Written complex SQL queries to validate the data against the target based on ETL mapping specifications.
• Used Tidal scheduler for composing and executing the jobs to simulate the production environment in QA.

Environment: ETL (Informatica 8.6.1), UNIX, Micro Strategy, IBM Rational Clear QuestV7.0, IBM Functional tester, Windows XP, SQL Server 2008, Oracle 10g, MS Excel, HP Quality Center, TOAD, Win SQL, Teradata SQL Assistant, XML Spy 2010, XM L Files, MVS, JCL, COBOL II, Copy Books, VSAM Files

Confidential, San Jose, CA

QA Analyst

Responsibilities:

• Responsible for writing Test Cases, Test Plans, Test scripts and other test documents based on business requirement.
• Responsible for data validation testing using SQL and executing testing on data Warehousing projects.
• Responsible for developing detailed UAT test plans, conditions, scenarios, cases and related data and participate in UAT planning and execution activities for business and operations participants.
• Developed Test Plans and developed Test Cases/Test Strategy with input from the assigned business analysts and data architect.
• Performed Manual Testing and Automation of Web applications.
• Have attended Scope Analysis, Requirements workshops to understand the business requirements and written test plans based on it.
• Involved in extensive data validation using SQL queries and back-end testing
• Used HP Quality Center for test scripts creation, execution, test coverage and defect tracking
• Used TOAD, DB Artisan tools to connect to Oracle database to validate the data that was populated by ETL applications.
• Used standard testing techniques to test the data validity before deploying the Micro Strategy Reports to Users.
• Worked with integration services for transferring and reviewing data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Worked on Clear Quest to log defects and track resolution till the closing of defect after retesting.
• Used Informatica ETL tool for Extraction, Transformation and Loading the data into target database.
• Tested ETL Packages, Scripts from development to QA environment.
• Plan tests with Quality Center (Design Steps and Run Tests) and also prepared detailed documentation
• Involved in extensive data validation using SQL queries and back-end testing
• Used SQL Server Management Studio for Querying SQL Server 2008 databases.
• Strong Informatica and data loading experience.
• Written complex SQL queries to validate the data against the target based on ETL mapping specifications.
• Used Tidal scheduler for composing and executing the jobs to simulate the production environment in QA.

Environment: ETL (Informatica 8.6.1), UNIX, Micro Strategy, IBM Rational Clear QuestV7.0, IBM Functional tester, Windows XP, SQL Server 2008, Oracle 10g, MS Excel, HP Quality Center, TOAD, Win SQL, Teradata SQL Assistant, XML Spy 2010, XM L Files, MVS, JCL, COBOL II, Copy Books, VSAM Files

Confidential

QA Analyst

Responsibilities:

• Involved in business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed SOX Program Management in support of the Single Family Technology Group, including SOX test evidence gathering, standard compliance and weekly reporting to upper management.
• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on the ETL Mapping document.
• Prepared technical specifications and source to target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, and packages to implement business rules and security.
• Gained solid testing experience in working with SQL stored procedures, triggers, and views and worked with performance tuning of complex SQL queries.
• Used QuickTestPro; generated various scripts for performing functional testing.
• Wrote test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• Developed automated test scripts from manual test cases for regression testing based on the requirement documents using Quick Test Professional.
• Wrote Test Plans and Test Cases on Mercury’s Test Director Tool.
• Defects identified in the testing environment were communicated to developers using the defect-tracking tool, Mercury Test Director.
• Provided overall support to the Reverse Mortgage Systems, Consumer Home Equity Enhancement & Reporting System and the Shared Accounting and Reporting System.
• Monitored production runs and resolved both technical and financial accounting problems. Implemented software upgrades. Coordinated hardware and software upgrades.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Effectively communicated testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5.
• Extensively used Ab Initio for extraction, transformation and loading process.
• Worked with the ETL group for understating Ab Initio graphs for dimensions and facts.
• Extracted data from various sources like Oracle, XML, Excel and COBOL Flat Files.
• Designed and created complex mappings using SCD Type II, involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimized/Tuned several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process; automated the process of loading, pulling the data.