SUMMARY

• 9+ years of IT experience in the analysis, design, development, testing and implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Solid Back End Testing experience by writing and executing SQL and PL/SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification and identifying data mismatch.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Worked on Waterfall and Agile methodologies.
• Extensive testing ETL experience using Informatica PowerCenter 9.x/8.x/7.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplets Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server).
• Experienced working with all kinds of test designing techniques including Decision Table, Pair wise Testing, State Transition Tables, Equivalence partitioning & Boundary value analysis
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within timeframe.
• Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron - jobs for ETL Loads
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate-wide-ETL solution using ETL tools like Informatica.
• Expertise in Testing complex Business rules by creating mapping and various transformations.
• Strong working experience on DSS (Decision Support Systems) applications and Extraction, Transformation and Load (ETL) of data from Legacy systems.
• Experience on Mainframe application testing
• Experience on Facets front-end and Data model in areas of Claims Processing and Member group applications and in workflow configuration
• Extensive experience in working with databases including Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000/7.0.
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows XP,NT/95/2000, OS/2,Linux 6.X/7.X/8.X

LANGUAGES KNOWN: C,C++, PL/SQL 8.x/2.x, SQL*Plus

RDBMS: Oracle 7.X/9i/10g/11g,MS SQL Server 2000,2005,2008, MS Access 7.0/’97/2000, SQL Server 11.x/12.0

SCRIPTING LANGUAGES: VB Script, Java Script

TECHNOLOGIES: Java EE, Hadoop Eco-Systems

WEB SERVERS: Java WebServer2.0, Netscape Enterprise Server, Web Logic 6.0.

DATAMODELLING TOOLS: Erwin 3.5.1/4.x, Designer 2000

DATAWAREHOUSING: Informatica PowerCenter 9.x/8.x/7.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplets Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server).

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr.ETL QA

Responsibilities:

• Involved in understanding Logical and Physical Data model using Erwin Tool.
• Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center 10.0 and ALM 11.0
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Worked with Decision Table Test Design Technique for various test actions.
• Work closely with EDI to ensure accuracy in data transmissions and shared processes.
• Coordinated the end to end testing efforts of EDI transactions.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Collected requirements and tested several business reports.
• Did Test coverage by adding new test actions from iteration to iteration according to the test strategy.
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Worked on Execution Tracker, Test Design Tracker & Defect Metrics.
• Did complex data validation using SQL queries.
• Vigorously worked on Manual Testing by writing the Test Cases and executing the Test Scripts for various scenarios.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Independently designed and developed project document templates based on SDLC methodology
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• 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
• Tracked and reported the bugs with Quality center.
• Extensively worked on Mercury Test Center and ran various scenarios and scheduled them. .
• Created Test input requirements and prepared the test data for Data Driven testing.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 9.5, Quality Center, EDI, Windows NT, ALM 11.0, T-SQL,SQL, PL/SQL, Oracle 11g,SQL Server 2008, WinSQL, TSO, Java Scripts, XML, MS Access, XML/VSAM/Flat Files.

Confidential, NJ

Sr. Quality Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing, Sanity, Regression and end-end testing .
• Maintained and tracked project information in Quality Centre.
• Developed and involved in Manual Testing based on Use cases developed.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Involved in investigating the errors by tracking the root cause for the error.
• Analyzed EDI translation errors that failed in the inbound and re-processed the EDI's without losing the information.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.
• An extensively used Complex SQL statement for retrieving data using TOAD.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Worked with Equivalence Partitioning and divided the input data into various partition of data based on test case condition.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Analyzing Source Files to determine data quality Standards.
• Also responsible for Issue Tracking, resolution and Corrective Actions throughout the project.
• Validating the data passed to downstream systems.
• Worked with Testing Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications
• Tested various Drill through reports from report to report.
• Reported operations sum and average, intersection, etc.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: ETL, Java, SQL, Oracle 10g, XML, UNIX, SQL Server 2005/2008,EDI,Shell Scripting, Ultra edit, Quality Center 9.2.

Confidential

Quality Analyst

Responsibilities:

• Responsible for testing facets core application and UAT modules by following standard testing procedures
• Handle the tasks of testing and entering data in FACETS4.7 application
• Perform responsibilities of building testing environment and testing scripts by referring the technical specifications
• Assigned the tasks of performing regression testing of facets application
• Perform Claims validation of facets application as required
• Handle the tasks of preparing test cases and test scripts of various modules
• Responsible for running test scripts for facets applications and modules
• Written SQL statements manually to validate data from Database using Toad Environment
• Written shell scripts to invoke the SQL Loader to load the data into oracle DB from flat files using control files.
• Created SQLs for QA testing and assisted in testing the data
• Created Tech design document and had walk through with QA team and Production team
• Modified the test cases and re-ran them for the purpose of Regression Testing.
• Generated Reports and Documented and Communicated test results on daily basis.
• Coordinated UAT and sign off for application before rolling out to production.

Environment: Facets4.81, Facets interfaces (IFOX), Facets extensions,,SQL Share point, MS office, MS word, MS excel, Quality Center, Oracle 11g,TOAD, Ultra Edit

Confidential

Quality Analyst

Responsibilities:

• Analyze business and technical requirements to create detailed test cases/scripts.
• Test the batch/on-line application module(s) to verify whether the changes meet the new business requirements.
• Designed and tested screens, tables and reports.
• Prepared detailed Test Plan & Test Cases by understanding the business logic & user requirements.
• Testing CICS mappings manually and checking the validation of the Mapplets.
• Testing with Batch programs are compiled and executed using JCL.
• Prepare and document test data.
• Planned and Managed Test schedules using Release Dates.
• Involved in documenting and maintaining quality process.
• Wrote Test scripts for Regression testing.
• System testing of all online screens and batch programs.
• Analyzed the data using QMF.
• Compared the Test files with the Production files.
• Involved in test case walkthrough with users and getting signoff from users.
• Involved in production check out.
• Responsible for making modifications and enhancements to the existing JCL.
• SQLs are written using QMF to query the DB2 database on mainframe.
• Worked closely with development team in resolving bugs and verified and closed bug reports once they are resolved.
• Involved in Preparation of Test Summary Report.
• Used Test Director for managing the business requirements, test plans, test labs and test Defects.
• Reviewed and approved team members' test scripts.
• Generated detailed reports of the bugs, the pass-fail reports and the Test results.

Environment: Mainframes, COMET, QicLink, DB2, SQL, Test Director, Windows XP, UTR, Quality Center

Confidential

Quality Analyst

Responsibilities:

• Involved in all the Development phase activity like Designing Test cases, Test data, Execution.
• Designed the Test Plan and Effort Estimation
• Prepared Test Scenarios and Test cases
• Performed system testing and regression testing
• Presented walkthroughs on Test cases and Test results to business
• Defect Reporting and Tracking Using Quality Center
• Attended onsite status calls and Defect triage calls.
• Bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status using QC.
• Solved team issues effectively, shared the updates from on shore to off shore team members
• Reported daily status through Daily Status Reports.
• Involved in Functional testing, Data base testing on Mainframe application.
• Analyzed business and/or technical requirements to formulate a testing plan according to clients structured methodology.

Environment: Java, Servlets, JSP, J2EE, Xml, XSLT, HTML, MS-Sql Server,, Windows XP, Quality Center