SUMMARY

• Over 9+ years of experience as a Quality Analyst for Client/Server, Desktop, Web, Mobile based applications for various clients.
• 6+ years of experience in ETL Testing.
• Onsite work Experience (having been to Germany).
• Extensive testing ETL experience using Informatica 8.1/7.1/6.2 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Excellent Knowledge of Database Systems - Oracle 10g, SQL server, DB2 and Data ware house concepts.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables.
• Programming experience with SQL, PL/SQL programming and relational databases, including Oracle, DB2, Teradata, Netezza, MS-SQL, iBatis.
• Expertise in testing various Client-Server/Distributed Applications based on Java/J2ee,Dotnet and Mainframe Technologies
• Hands on development of Frame work.
• Well experienced in Team Leading and Customer interaction.
• Experience in Agile+ methodology, played role of Scrum Master leading team of 8 persons.
• Excellent Knowledge of Full project life cycle (SDLC) that includes Requirement Analysis, Estimation, Low-level design, Team management, work allocation, integration testing, implementation, support and maintenance.
• Expertise in Functional, Regression and System Testing
• Experience in review of the Functional requirements.
• Well acquainted with the Software Testing Life Cycle (STLC) of applications.
• Execution of appropriate functional test scenarios based on Functional requirements
• Capable to quickly learn new technologies and adaptability to new environment.
• Experience in preparation of Requirement Traceability Matrix
• Having experience in developing servlets, JSP, Struts and Hibernate.
• Have good working knowledge in webservices testing using SOAPUI.
• Have good working experience in Quality Centre(HP ALM), Clear Quest
• Significant depth of experience in delivery of technical content and evaluating new technologies.
• Domain experience in Insurance, Health Care, Telecom and Banking.
• Preparing Test Data for the test cases based on the SRS or BRS and Analyzing the Test Cases prepared by other team members.
• Excellent verbal and written communication skills
• 2+ years of experience in NO SQL DB’s in Hadoop such as HBase,Cassandra and MongoDB

TECHNICAL SKILLS

Languages: C,Java

Markup Languages: Html, xml, JavaScript

J2EE Technologies: JDBC,Servlets,JSP,Struts,Spring,WebServices

DBMS: Netezza,Teradata,Oracle,SQL

WebServer: Tomcat5.0

Tools: Toad for SQL,Toad for Data Point,Netezza, Informatica,Squids

Application server: Weblogic,Websphere, Tomcat

IDEs: Teradata Sql plus, QC (HP ALM),BUGZILLA, Aginity Work Bench

Version Controls: SVN, Version One, CVS

Operating systems: Windows 9x/xp,UNIX

Hadoop: HBase,Cassandra,Mongo DB etc

PROFESSIONAL EXPERIENCE

Confidential, FL

Quality Analyst\ ETL\Data warehouse Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Involved in writing the test cases and Test plans based on Source to Target Mapping documents and Data model diagrams.
• Wrote the Test cases for Enterprise Data Warehousing (EDW) Tables and Data mart Staging Tables.
• Involved in all stages of the Software Development Life Cycle (SDLC) to develop necessary test strategy
• Compared Report Generated in Excel sheet to data in Database.
• Wrote the SQL queries on EDW tables and Data Mart Staging Tables to validate the data results.
• Wrote the SQL queries for each test case and Executed in SQL Plus to validate the data between EDW and Data Mart Staging Tables
• Analyzed the result and generated defect report using QCfor detected defects and tracked it to development team, and worked closely with developers to track and fix defects.
• Updated the test cases on based on the requirement changes and executed the test cases.
• Involved in executing the test cases for EDW and Data Mart Staging Tables.
• Involved in Daily Scrum or Client Meetings as per Agile process.
• Involved in Knowledge Transfer sessions and s to Colleagues
• Involved in Sprint Tracker and Estimating the efforts for the various Tasks.
• Validating the Target Data such that every transformation executes successfully.
• Conducting Peer Reviews and Involving in System, Integration, UAT Phases of Testing
• Involved in Sanity Testing and Defect report generation
• Involved in testing of every functionality of the application and acted as SME

Environment: Agile, Data base Testing, ETL Testing, Functional Testing, Mongo DB, Cassandra, Netezza,Toad for Data Point, Aginity Work Bench

Confidential

IT Analyst

Responsibilities:

• Involved in testing ACE, Vitality, Clinical Reusable Framework, Shared Contact Repository and Campaign Management functionalities GUI and Business Logic by interacting with various databases.
• Managing knowledge gained for utilizing it for other module testing.
• Participated in regular project status meetings and QA status meetings.
• Communication to stakeholders - Business partners and IT Management
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)
• Improving the quality of application by using Performance Tuning concepts.
• Updating the status of open/closed issues to the on-site team
• Involved in Client Meetings and Daily Scrum Calls as per Agile Process
• Acted as a Scrum Master for couple of Modules or Functionalities
• Acted as a SME(Domain and Technical) for Several Modules and for various Functionalities
• Functional testing performed for services with several scenarios to achieve the Client/business requirements.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Defects identified in testing environment are communicated to the developers usingQuality Center - Defects module
• Extensively interacted with developers, business& management teams to understand theOPM project business requirements and ETL design document specifications.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents andSource to Target mappings.

Environment: Agile, Data base Testing, ETL Testing, Functional Testing, Mongo DB, Casssandra, Netezza,Toad for Data Point/Analyst

Confidential, Irving, Texas

Quality Analyst.

Responsibilities:

• Tested a number of complex ETL mappings, mapplets and reusable transformations fordaily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Designing and Execution of test cases
• Worked with ETL groups and Acquisition team and business analyst for understatingmappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and DB2 server.
• Effectively communicate testing activities and findings in oral and written formats
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test theflat files data in the databases.
• Performing Smoke, Functional, System and Regression testing GPS(Global Platform Services) and EFD(Enterprise Fraud detection) Modules.
• Identifying issues and logging the same
• Defect tracking and generation of reports
• Involved in Prioritization and Optimization of test cases
• Involved in peer reviews
• Prioritized testing in an attempt to find the critical defects as early as possible.
• Involved in developing servlets, JSP and Hibernate.
• Extensively Validated several Business Scenarios

Environment: Oracle 10g/11g, Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor), HP QC 9.0/11.0, SQL developer, TOAD, SQL and PL/SQL, Aginity WorkBench.

Confidential

Quality Analyst

Responsibilities:

• Developed high level test matrix based on business requirements, functional and technicalspecifications, and development standards for assigned projects/applications
• Involved in Understanding the existing cPOS Prepaid Application Flow.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality
• Validation in Data Migration.
• Performed data quality analysis using advanced SQL skills.
• Extensive SQL querying on Staging,Datawarehouse and DataMarts.
• Developed test cases based on test matrix including test data preparation for Data
• Completeness, Data Transformations, Data quality, Performance and scalability.
• Involved in understanding the requirements and prepare UTP’s.
• Developed SQL queries /scripts to validate the data such as checking duplicates, nullvalues, truncated values and ensuring correct data aggregations.
• Technical and Domain specific s given to the internal team members.
• Prepared flow documents for Admin Transactions functionality.
• Performed testing for the Bulk upload functionality raised a issues or bugs to Dev team.
• Differentiated the Pre paid and Post paid Business functionalities deployed the wars individually and Verified or Tested them .
• Scheduling and automating jobs to be run in a batch process
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Functional testing performed for services with several scenarios to achieve the Client/business requirements.

Environment: Manual Testing and Functional Testing, ETL Testing, Oracle 10g/11g, Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor), HP QC 9.0/11.0, SQL developer, TOAD, SQL and PL/SQL, Aginity WorkBench.

Confidential

Quality Analyst

Responsibilities:

• Tracking and reporting the issues to project team and management during test cycles.
• Worked with IT Development team to ensure feasibility of design and clarify user requirements.
• Performed Testing for Early Loan Payment, Onboard Service and Social welfare Loan services as per the Client requirement and delevered to the clients.
• Performed Testing for the Course Design Service, Vacation Service and Ticket Compensation services.
• Performed Testing for Car Loan, Car Allocation, Housing Loan services.
• Preparing the TDDs based on the BRSDs and Solution design documents
• Designing and Execution of test cases as per the TDDs
• Developed Test Cases and SQL Queries to perform various Validations.
• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysisand Data Quality Validation in Data Migration.
• Modifying the TDDs as per the Client requirements and Executing of test cases
• Performed Data Analysis and developed Data Mapping documents for ETL projects.
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness,
• Integrity and Accuracy of Data within an ETL process testing cycle.

Environment: Functional Testing, ETL Testing, Manual Testing and Functional Testing, ETL Testing, Oracle 10g/11g, Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor), HP QC 9.0/11.0, SQL developer, TOAD, SQL and PL/SQL, Aginity WorkBench.

Confidential

Quality Analyst.

Responsibilities:

• Involved in Troubleshooting, resolving and escalating data related issues and validatingdata to improve data quality.
• Involved in developing Validation Frame work with Struts and Hibernate.
• Prepared Test Design Documents and Test Cases for the Validation Frame work.
• Collected the Test Data for the Validation Frame work.
• Executed Test Cases with respect to Source and Target database tables.
• Written SQL queries tovalidate reports against the database.
• Used Mercury Quality Center for Bug Tracking, Reporting and Analysis.
• Designing and Execution of test cases
• Extensive SQL querying on Staging,Datawarehouse andDataMarts.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQLServer Integration Services 2005, Flat Files, DB2, TOAD 9.5, MS Office, XML, Windows Server2003, Mercury Quality Center 9.2, Lotus Notes 7.0.3, Agile Scrum, HTML and JavaScript.

Confidential

Application Developer

Responsibilities:

• Develop test plans based on test strategy. Created and executed test cases based on teststrategy and test plans based on ETL mapping document
• Written complex SQL queries for querying data against different data bases for dataverification process
• Involved in developing servlets, JSP and Hibernate.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convertexcel to flat files
• Tested a number of complex ETL mappings, mapplets and reusable transformations fordaily data loads
• Designed the data flow diagrams using VISIO
• Preparation of technical specifications and Source to Target mappings
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Extensively used SQL programming in backend and front-end functions, procedures,packages to implement business rules and security
• Designing and Execution of test cases
• Performing Smoke, Functional, System and Regression testing

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQLServer Integration Services 2005, Flat Files, DB2, TOAD 9.5, MS Office, XML, Windows Server2003, Mercury Quality Center 9.2, Lotus Notes 7.0.3, Agile Scrum, HTML and JavaScript.

Confidential

Software Engineer

Responsibilities:

• Understanding the Requirements and Participating in the Test Design
• Black Box Testing & execution of these test cases.
• Involved extensively in the GUI Testing, Sanity Testing for the Build, Functional
• Testing, Regression Testing.
• Track the bugs using Bugzilla, which is a bug Tracking tool.
• Created SQL queries to retrieve data from database to validate the input data.
• Executing the Test cases on various flavors of IE, Mozilla Firefox and Safari for different builds. worked on the Analysis phase and helped the team by putting my maximum efforts in Resolving the Issues of the Analysis phase.
• Involved in Analysis phase, prepared the flowcharts in Microsoft Visio by studying the Business Rules & Use Cases of the project.
• For some Prepared Microsoft Excel sheets by studying Business Rules & Use Cases to analyze and design the test cases,test reports in an easier way.
• Acted as a POC for the several domain related Issues.

Environment: Manual Testing, EclipseIDE, Jdk1.4, Servlets,JSP, Struts,Hibernate, Spring,IBM Websphere,Xml, Citrix web client, Windows2000

Confidential

Software Engineer

Responsibilities:

• Understanding the Requirements and Participating in the Test Design
• Black Box Testing & execution of these test cases.
• Involved extensively in the GUI Testing, Sanity Testing for the Build
• Track the bugs using Bugzilla, which is a bug Tracking tool.
• Created SQL queries to retrieve data from database to validate the input data.
• Executing the Test cases on various flavors of IE, Mozilla Firefox and Safari for different builds.

Environment: Manual Testing, RAD,Jdk1.4, Servlets,JSP, Struts, Spring,Hibernate, IBM Websphere, Xml, Windows2000s