SUMMARY

• Detail oriented quality assurance professional with 8 years of experience.
• Extensive software testing exposure of stand - alone, client-server, mobile and web based applications.
• Extensive experience in Functional testing, Regression Testing, System Testing, Performance testing, White Box Testing, Black Box Testing, Load testing, Database testing, Validation testing(V), Independent Validation Testing(IV) interfaced with customers during User Acceptance Testing.
• Experienced QA Analyst/ETL Analyst/Tester with good understanding of ETL processes, OLAP Systems, data warehousing, and database testing.
• Software development experience pertaining to Client Server, Web based and ETL applications, utilizing technologies including Java/J2EE, Java Script, Oracle PL/SQL, HTML, XML, UNIX Shell Scripts.
• Specialize in planning and executing End-to-End Manual testing process based on functional requirements and technical design documents.
• Expertise in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases based on the User Requirement Document
• Experience in testing with SQL scripts. Great experience at utilizing advanced SQL OLAP functions for data analysis, slicing and dicing of data, and finding patterns in the data for helping business gain useful insight.
• Documented test results and software features being tested to ensure the highest quality results.
• Working knowledge of SAP R/3 - Sales and Distribution, BI 7.
• Understands integration points of specific module with other business processes and SAP modules.
• Extensive experience in the testing of conversions and data loads between SAP and legacy systems as well as functional testing of custom development objects.
• Expert knowledge of quality assurance methodologies.
• Experienced in training other professionals and provided team leadership.
• Reporting the test results and various matrixes.
• Responsible for running complex SQL queries and performing data validation.
• Good experience of test management tools like HP QC, and FIT
• Great experience with multiple RDBMS including oracle, Teradata, SQL Server and Access.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Familiar with writing UNIX and DOS Shell scripts for automation and other tasks.
• Working on a variety of different projects, performing manual, functional, system, regression and database testing.
• Developed courses and trained user and trainer on reporting and analysis functions such as standard report at document level.
• Excellent interpersonal skills, ability to learn and adopt new technology concepts.
• Diligent worker, self-starter and consistent performer.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows 95/97/98/2000/ Me/XP/Vista/7/8, Linux Ubuntu 7.04, Mac OSX

Languages: SQL, Java, C, C++, XML, HTML, JSPs, Java Script, Shell Scripting

Testing tools: HP Quality Center

Databases/Tools: Oracle 10g/11g, MySQ, SQL Developer, Toad, MS Visio, Erwin, Oracle Data Modeler, MS Access, MS Excel, Eclipse

ETL: Pentaho 4.2, Informatica 8.6.0

Other: Entity Relationship Modeling, Use Cases, Object Oriented Analysis & Design

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, MI

Data QA Analyst (ETL)

Responsibilities:

• Responsible for writing SQL scripts to validate Data records from OLTP to DWH.
• Ensured that ETL application correctly rejects, substitute values, corrects or ignores and reports invalid data.
• Verified the extract generated in both UAT and Production environment by running scripts against Oracle RDBSM in Toad.
• Adapt at dealing with different file extracts of different formats including delimited (comma, tab), flat file and XML file.
• Performed regression testing.
• Analyzed issues aroused during testing and notified to the concerned developer.
• Running batch job in Pentaho and validated that job ran successfully.
• Validated DCPS scripts developed by ETL Developer.
• Ran DCPS scripts in all test environment after creating test user to have participant ids.
• Presented all DCPS request to CCB (change control board) for approval.
• Validated DM records in DWH to make sure that dataflow from DWH to Cognos is accurate
• Validated records generated in Congnos with the requirement specification document.
• Validated data consistency on daily basis in UAT and Production.
• Updated FIT tool if any issue need to be addressed.

Confidential, Marietta, GA

Tester/QA Analyst

Responsibilities:

• Responsible for testing EMRMS web application to validate data records from front end which is build on .net frame work and back end which is deployed on SQL Server 2008.
• Verified “Meaningful use” compliance according to ONC.
• Verified that the application successfully follows the guidelines of HIPAA Compliances when it comes to security and privacy of the patient.
• Tested multiple interfaces for the EMR to external vendors including SureScripts, Lab.
• These interfaces used Java/J2ee, AJAX, JavaScript, SQL Server procedures for these development efforts.
• Tested run time behavior on various operating system/browsers or different hardware configurations.
• Performed usability testing to test the performance and the navigation through the web application.
• Performed unit testing to rectify any issues with data set.
• Identified and analyzed issue .net framework based forms.
• Performed user acceptance test by creating test cases.
• Executed the test cases using sample source documents as inputs and ensured that the outcomes of the tests are documented.
• Validated that all test case input sources and test case output results.
• Performed .net SIT which validated integration of networks and sites.
• Document any problems, and work with the project team to resolve problems identified during the tests.
• Resolve issues in java scripting at the front end when it comes to data validations.
• Responsible for testing and resolving system integration issues with java and database systems at the back end.
• Performed stress testing to check the capacity limitation of the application for maximum number of concurrent users, etc.
• Verified behavior in response to problems in the programming environment (system crash, unavailable network, full hard-disk, printer not ready)
• Verified protection against unauthorized access to data and programs.

Confidential, Morrisville, NC

QA Analyst

Responsibilities:

• Prepared Test Cases based on the Use Cases and Business Requirement document.
• Prepared test cases based on Interface mapping document.
• Prepared testing documents before and after validating the source to target data.
• Prepared Test Data and use the same to execute and pass test cases.
• Created and executed automated and manual test cases.
• Served as integration and functional tester on SAP consolidation OTC project.
• Worked with OTC functional analysts to identify functional, integration, and regression testing requirements.
• Responsible for verifying, writing, and executing the test scripts and coordinating the integration testing activities for the project.
• Built and tested required configuration for sales order processing and related functionality.
• Successfully identified the defects and worked with development and business teams to test and finalize the functionality.
• Developed solutions for business requirements in Sales and Distribution area.
• Developed testing programs that address areas such as database impacts, software scenarios, regression testing, negative testing, error or bug retests, or usability.
• Raised defect in QC and assign the same to the QA Lead who will assign it to specific developer and also revalidate the defect once the fixes moved into QA.
• Gathered and documented the business requirements to identify in scope as well as out of scope functionality.
• Worked in an Agile environment and responsible for interacting with different teams.
• Closely worked with on-site and offshore developers to ensure accurate and efficient implementation of required functionality.
• Successfully identified the defects and worked with development and business teams to test and finalize the functionality.
• Supported multiple testing cycles, including Integration, Regression and System testing.