SUMMARY

• Over 7 years of experience in the field of Information Technology Industry as Quality Analyst and worked extensively in Health care, Banking, Insurance, Finance environments.
• In depth technical knowledge and understanding of Data warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, Oracle, and ETL.
• Worked as a QA Tester in Manual and Automation Testing with extensive experience in Shell scripting using Perl and ksh.
• Proficiency in BPM & BRE using PEGA (PRPC).
• Experience in understanding the Business Process Flows, Case Tools, and Business Analysis.
• Experienced in full SDLC Methodology including Waterfall, RUP and Agile Software Development.
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL Processes where in the organizations were using Datastage, Informatica, Abinitio and Autosys tools.
• Extensive use of debugging tools like Clipboard, Tracer, Rules Inspector for unit testing & debugging of the Pega PRPC application.
• Expertise in Automation Test cases with QTP using VB scripts.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end - to-end testing.
• Well versed with using Quick Test Professional (QTP) to support test automation using potential features like Data Driven Tests, Check Points, Regular Expressions and Functions
• Experience in working with open source tools Selenium (Selenium IDE, Selenium RC, Selenium Web Driver), JUnit, Eclipse and preparation of Automation Test framework.
• Experience in working with many external applications like Notepad, Excel, IE, MS word etc through QTP by creating instances.
• Extensive experience in functional testing, unit testing, integration testing, regression testing,GUI testing, back-end testing, browser compatibility testing, and component testing onWindows.
• Expertise in running Test Scripts from Quality Center/ Test Director on different hosts.
• Experience in writing Test Plans, defining Test Cases, developing and maintaining Test scripts, analyzing the results of scripts, interaction with developers in fixing the errors.
• Experience in Bug Tracking and Reporting using Test Director/ HP Quality Center.
• Strong skill in Backend Testing using SQL queries on Oracle and SQL Server.
• Good at multi-tasking and working well under tight deadlines with high efficiency.
• Excellent analytic-al and communication Skills, documentation skills, team problem solving ability and analytic-al skill.
• Ability to work independently with minimal supervision and also a great team player.
• Expertise in analyzing User Requirements, Functional and Technical Specifications.
• Excellent troubleshooting, project management and problem solving skills.

TECHNICAL SKILLS

Testing Tools: QTP 11.0, LoadRunner 8.0, Win Runner 7.5, Selenium 2.4

ETL /BI Tools: Informatica, Datastage, Abinitio,Toad, Autosys

Management Methodology: Release Planning, Prioritization, Change Management, Agile Methodology.

Reporting Tools: Quality Center 11.0, Test Director 7.5

Programming Languages: C, C++, C#,JAVA,SQL,VBScript, UML

Web Technologies and Tools: HTML, XML, CSS, ASP, ASP.NET, JSP, JavaScript, Dreamweaver

Database and Tools: MS SQL Server 2008/2012, TOAD for Oracle, MS Access

Operating Systems: Windows 95/98/200/XP/Vista/7/8, Unix(Linux,Aix,Solaris) MacOS

Business Modeling Tools: MS Visio, Rational Rose

Web Servers: MS IIS 6.0, I Planet Sun One, Apache Web Server

Document Processing: MS PowerPoint, MS Project, MS Visio, MS Web, MS,Excel, MS SharePoint

PROFESSIONAL EXPERIENCE

Confidential, Cypress, CA

DWH/SQL/ETL Tester

Responsibilities:

• Documented QA testing processes and activities form project inception to production deployment and maintenance.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Created manual Test Cases in HP QC/HP ALM for various User Stories based on Release and Sprint Plan.
• Defined data requirements and elements used in XML transactions.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the reporting objects in the reporter against the design specification document.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata
• Executing and monitoring jobs through Control - M.
• 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.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Deleting the target data before processing based on logical or physical primary key
• Preventing occurrences of multiple runs by flagging processed dates
• Reviewed Informatica mappings and test cases before delivering to Client
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Monitor security batch processing jobs in multi-platform shop via Control-M & Tidal Schedulers.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Ensured that the mappings are correct and conducted data validation testing
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Coded UNIX awk and sed shell scripts for data migration for the Department of Credit Risk Warehouse and Capital Funding (CAPFUN) Database.
• Control-M agent accounts, and trouble-shooting Control-M production errors and coordinating with vendor when necessary.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined BUSINESS RULES.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, Functions, Alerts, Cascading Prompts and User Defined Objects.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
• Validated the OLAP cubes generated in SQL Server Environment.
• Worked with all kinds of Teradata load utilities
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 10g.
• Prepared test plans/test schedules with inputs from Project manager and development team
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Confidential, Vienna, VA

Quality Analyst

Responsibilities:

• Developed Test Plans, Test Cases, and Test Scripts for SIT and support for UAT tests.
• Used DATASTAGE as an ETL Tool for Developing the Data Warehousing.
• Executed test cases and test scripts for manual and automation testing.
• Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing and Functional testing.
• Extensively used the AutoSys jobs for the entire project.
• Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse database.
• Worked on SQL scripts to load data in the tables.
• Extensively worked with DS (Designer, Director and Manager).
• Used the DATA STAGE Director and its run-time engine to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions.
• Tracked the defects using Clear Quest tool and generated defect summary reports.
• Worked on Mainframe files .
• Used Mainframes for the daily data from the production to SIT environments.
• Experience testing on XML documents.
• Experience working with Rational ClearCase for Version controlling and ClearQuest for Defect Tracking Tool.
• Validated the data movement and transformations are done correctly for MISMO.
• Worked with Data Warehousing developers who extensively used DATASTAGE, to design mapping to move data from source to target database using Stages to do the functionality.
• Prepared status summary reports with details of executed, passed and failed test cases
• Interacted with developers, Business & Management Teams and End Users.
• Participated in regular project status meetings related to testing.

Confidential, Richmond, VA

Quality Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Programmed custom scripts using ksh to copy and archive files.
• Used vi editor to create, edit and update shell scripts.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Performed complex defect reports in various environments like UAT, SIT, and QA etc to ensure the proper delivery of the application into the production environment.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Designed and kept track of Requirement Traceability Matrix
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
• Created SQL server Analysis Projects using MS SQL Server 2008.
• Implemented and maintained tools required to support data warehouse testing.
• Performed the tests in both the FIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).

Confidential

QA Engineer

Responsibilities:

• Analyzed system requirement and business requirement documents and developed test cases and test scripts.
• Used SQL commands to validate the database and test its integration with the front end.
• Performed GUI Testing, Functional Testing, Integration Testing and Regression Testing.
• Execution of manual test cases and responsible to track and log the defects using Quality Center.
• Interacted with developers to sort out the issues and the defects.
• Performed data driven testing and GUI Check Points using QTP and enhanced the overall functionality of the application.
• Written reusable VBScript functions and accessed them from the library files which are stored in the Quality Center
• Developed automated regression scripts using Quick Test Professional utilizing VBScript scripting for both positive and negative boundary conditions.
• Created and executed scenarios in Load Runner controller to analyze system performance in Load Runner Analyzer under load.
• Used rendezvous concept of Load Runner to generate peak load onto the server thereby stressing it, and measuring its performance.
• Attended the Review meetings and walk through and interacted to Business Analysts and Developers for defects solving.
• Used Selenium IDE for Open source web testing
• Used Mercury Quality Center for Defect Reporting, Analyzing, Tracking and Report Generation.
• Performed Regression testing by executing QTP scripts on the new build.
• Performed Integration, System, UAT and Usability Testing.