SUMMARY:

• 7 years of valuable experience in Information Technology working for diverse domains such as Banking and Financial Services, Insurance, Telecommunication and Pharmaceuticals
• Expertise in Testing of Data Warehousing/Business Intelligence applications and experience in working with EDWs (Teradata, Oracle, DB2, Sybase, SQL Server). Extensive experience in testing Reports like dashboards, drill up and drill down, adhoc as well as scheduled. Good exposure with writing SQL scripts, complex SQL queries, Testing of Source to target mappings, Testing of BI Reports.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in all phases of Software Development life cycle.
• Application Data warehousing experience in Banking, Pharmaceutical and Insurance.
• Design, develop, and execute test plans and test procedures supporting new software development.
• Write problem reports, provide test progress updates, and author test results summary reports and recommendations.
• Collaborate with software engineers to identify and resolve issues.
• Performed Unit, Integration and System Testing.
• Proficient in leading testing projects from inception, requirement specification, planning, designing, configuration management & documentation and post production support.
• Rich onsite exposure of coordinating end to end testing processes, executing projects, interacting with Onsite Testing Lead for removing gap between client expectations & testing capabilities and assisting onsite leads in planning & risk mitigation in critical situations.
• Worked with Microsoft office tools including office 365, Team foundation Server, MS Visio, Outlook and One Drive.
• Wored with Financial Applications like Atlas Office, OLA, Activity Center and ExportSS.
• Working Knowledge on all Phases of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and testing methodologies such as V - Model, Agile and Waterfall Model
• Deft in testing methodologies viz. BI - ETL Testing, Report Testing, Manual Testing and Automation testing (QTP), and Database Testing; and completing highly complex test optimization.
• In-depth knowledge of various tools such as ETL Tools: Informatica and Datastage Director; Reporting Tools: Microstrategy, SAP BO, OBIEE; Automation Tools (QTP), Quality Centre (QC) and Basic UNIX commands.
• Team Player with excellent communication, planning, analytical and organizational skills
• Good analytical and problem solving skills.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS:

ETL Tools: Ab Initio, (GDE 1.15, Co>Op 2.15), EME, Data Profiler, Informatica9.x/ 8.6/8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), SSIS, Data Stage

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 11i/10g/9i/8i, MS SQL Server 2008/2005/2000, DB2, Teradata, Sybase 12.5, MySQL, Netezza

OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XI r3/r2/6.x/5.x, SSRS, SSAS, Crystal Reports, OBIEE

Languages: SQL, PL/SQL, XML

Tools: Toad, SQL* Loader, WinSQL, SQL Developer, Teradata SQL Assistant, SQL Plus*

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: HP Quality Center, Bugzilla, Rational Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential, Newark, Delaware

QA Analyst

Responsibilities:

• Attended requirement analysis and design walkthroughs sessions with the Business System Owners, Developers, Business Users and Management staff.
• Assisted to Prepare a comprehensive set of documents to define the requirements and functional specifications
• Participated in Validation plans per the business requirements document.
• Worked closely with validation team to ensure testing issues were resolved.
• Worked closely with the project Manager in planning, coordination and implementing methodology.
• Interacted continuously with developers and Validation team to maintain schedules for release, bug fixes and other issues related to the system
• Facilitated weekly team meetings between business users, developers and tester where test status and defects were discussed.
• Executed test cases, test scripts, captured test results and reported them
• Executed test cases including manual, automated, and functional, non-functional, usability performance tests.
• Identified bugs and defects, and reported them accurately using Microsoft Team Foundation Server 2013.
• Worked with UAT activities to ensure the applications and products and releases are according to the Quality Assurance standards.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based onrequirements.
• Tested the existing Reports with 100% accuracy
• Validated data in Target database according to business rules
• Executed very complex SQL queries to validate and verify data set per business rules. Working with Data Analyst’s on the Ambiguities raised during Analysis/Testing Phase.

Environment: Oracle 12c, TOAD 8.0, UNIX, MS Office Suite 2013 including MS TFS, MS Visio, Office 365, Atlas Office, OLA2, Activity Center, SQL Server 2008

Confidential, NYC,NY

ETL Tester

Responsibilities:

• Analyzed and review System, Functional, Technical Requirement Documentations
• Tested the existing Reports with 100% accuracy
• Analyzed the data mapping and developed test scenarios to verify the data migration from different sources.
• Tested various reports extracted from Enterprise Data Warehouse with Business Object including Dashboards, Scorecards, KPI’s Master-Detailed, Summarized
• Validated data in Target database according to business rules
• Analyze data using SQL, Excel, UNIX and data testing tools.
• Verify the implemented ETL code against the corresponding mapping document. Confirm the data loads from source files into the target tables.
• Examine sample record sets for consistency, data corruption and over all data quality.
• Prepared SQL queries and executed to validate the ETL processed data in target database.
• Verifying the column mapping between source and target databases
• Worked closely with Development team for various data issues
• Confirmed that data is parsed, transformed and loaded per business logic in the Oracle data warehouse through the Informatica mappings
• Run the Informatica Workflows for ETL Process
• Prepared and ran SQL queries
• Developed SQL and Stored procedures to achieve the data transformations
• Performed back-end testing on the Oracle database by writing SQL queries
• Tested several UNIX Shell Scripts for job scheduling.
• Performed data profiling on the source databases to check for data inconsistencies
• Imported different source data with DB link into the testing environment for testing
• Executed very complex SQL queries to validate and verify data set per business rules
• Working with Data Analyst’s on the Ambiguities raised during Analysis/Testing Phase.
• Wrote and submitted weekly quality assurance status reports
• Attended and participated in periodic product status meetings

Environment: SQL, PL/SQL, HP QC, Rational Clear Quest, XML files, Flat Files, TOAD, XSD, XML Spy 2013, Informatica 9.x, Putty,WinSQL, DB2, SQL Server 2008, Oracle 10g, Autosys, IBM AIX 6.1

Confidential, Chicago, Illinios

Backend/SQL/DWH Tester

Responsibilities:

• Analyzed and review System, Functional, Technical Requirement Documentations
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Data warehouse using complex SQL & PL/SQL queries.
• Tested the existing Reports with 100% accuracy
• Analyzed the data mapping and developed test scenarios to verify the data migration from different sources.
• Tested various reports extracted from Enterprise Data Warehouse with Business Object including Dashboards, Scorecards, KPI’s Master-Detailed, Summarized
• Logged defects using HP Quality Center/ALM, linked defects with requirements and generated Defect Reports in QC.
• Responsible for testing all new and existing ETL data warehouse components. Validated data in Target database according to business rules
• Analyze data using SQL, Excel, UNIX and data testing tools.
• Verify the implemented ETL code against the corresponding mapping document. Confirm the data loads from source files into the target tables.
• Involved in preparing the Data-driven and keyword-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
• Examine sample record sets for consistency, data corruption and over all data quality.
• Prepared SQL queries and executed to validate the ETL processed data in target database.
• Verifying the column mapping between source and target databases
• Worked closely with Development team for various data issues
• Confirmed that data is parsed, transformed and loaded per business logic in the Oracle data warehouse through the Informatica mappings
• Run the Informatica Workflows for ETL Process.
• Performed Regression testing with QTP by executing the automation test scripts
• Prepared and ran SQL queries. Developed SQL and Stored procedures to achieve the data transformations
• Performed back-end testing on the Oracle database by writing SQL & PL/SQL queries
• Tested several UNIX Shell Scripts for job scheduling. Performed data profiling on the source databases to check for data inconsistencies
• Imported different source data with DB link into the testing environment for testing
• Executed very complex SQL queries to validate and verify data set per business rules. Working with Data Analyst’s on the Ambiguities raised during Analysis/Testing Phase.
• Wrote and submitted weekly quality assurance status reports.
• Attended and participated in periodic product status meetings

Environment: ETL Informatica 9.x, BI Business Objects, SQL, PL/SQL, HP QC, QTP, Rational Clear Quest, XML files, Flat Files, TOAD, XSD, XML Spy 2013, Putty,WinSQL, DB2, SQL Server 2008, Oracle 10g, Autosys, IBM AIX 6.1

Confidential, Pittsburgh, PA

DWH/QA Tester

Responsibilities:

• Analyzed and review System, Functional, Technical Requirement Documentations
• Worked with different data sources ranging from VSAM files, flat files, DB2, oracle and SQL Server databases
• Tested the existing Reports with 100% accuracy
• Analyzed the data mapping and developed test scenarios to verify the data migration from different sources
• Tested various reports extracted from Enterprise Data Warehouse with Business Object including Dashboards, Scorecards, KPI’s Master-Detailed, Summarized
• Logged defects using HP Quality Center/ALM, linked defects with requirements and generated Defect Reports in QC
• Extensively executed SQL queries on SQL server tables in order to view successful transactions of data and for validating data
• Working experience in Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS)
• Validated data in Target database according to business rules
• Analyze data using SQL, Excel, UNIX and data testing tools
• Involved in performing extensive Back-End Testing by writing SQL queries to extract the data from SQL Database using SQL Server
• Verified the implemented ETL code against the corresponding mapping document
• Confirmed the data loads from source files into the target tables
• Examined sample record sets for consistency, data corruption and over all data quality
• Prepared SQL queries and executed to validate the ETL processed data in target database
• Verified the column mapping between source and target databases
• Worked closely with Development team for various data issues
• Confirmed that data is parsed, transformed and loaded per business logic in the SQL Server data warehouse through the Informatica mappings
• Validated reports against the SQL Server database directly querying the database using SQL
• Prepared and ran SQL queries
• Developed SQL and Stored procedures to achieve the data transformations
• Performed back-end testing on the Oracle database by writing SQL queries
• Tested several UNIX Shell Scripts for job scheduling
• Performed data profiling on the source databases to check for data inconsistencies
• Imported different source data with DB link into the testing environment for testing
• Executed very complex SQL queries to validate and verify data set per business rules
• Worked with Data Analyst’s on the Ambiguities raised during Analysis/Testing Phase
• Wrote and submitted weekly quality assurance status reports
• Attended and participated in periodic product status meetings

Environment: ETL Informatica 9.x, BI Business Objects, SQL, SQL Server 2012/2008, SQL Server Management Studio, PL/SQL, HP QC, SSIS, SSRS, SSAS, Rational Clear Quest, XML files, Flat Files, TOAD, XSD, XML Spy 2013, Putty, WinSQL, DB2, SQL Server 2008, Oracle 10g, Autosys, IBM AIX 6.1

Confidential, Alpharetta,GA

QA Tester

Responsibilities:

• Analyzed and review System, Functional, Technical Requirement Documentations
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Data warehouse using complex SQL queries.
• Tested the existing Reports with 100% accuracy
• Analyzed the data mapping and developed test scenarios to verify the data migration from different sources.
• Tested various reports extracted from Enterprise Data Warehouse with Cognos reports including Dashboards, Scorecards, KPI’s Master-Detailed, Summarized
• Logged defects using HP Quality Center/ALM, linked defects with requirements and generated Defect Reports in QC.
• Responsible for testing all new and existing ETL data warehouse components. Validated data in Target database according to business rules
• Analyze data using SQL, Excel, UNIX and data testing tools.
• Verify the implemented ETL code against the corresponding mapping document. Confirm the data loads from source files into the target tables.
• Examine sample record sets for consistency, data corruption and over all data quality.
• Prepared SQL queries and executed to validate the ETL processed data in target database.
• Verifying the column mapping between source and target databases
• Worked closely with Development team for various data issues
• Confirmed that data is parsed, transformed and loaded per business logic in the Oracle data warehouse through the Informatica mappings
• Run the Informatica Workflows for ETL Process.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Prepared and ran SQL queries. Developed SQL and Stored procedures to achieve the data transformations
• Performed back-end testing on the Oracle database by writing SQL queries
• Written several complex SQL queries for validating Cognos Reports.
• Tested several UNIX Shell Scripts for job scheduling. Performed data profiling on the source databases to check for data inconsistencies
• Imported different source data with DB link into the testing environment for testing
• Tested Cognos reports to check whether they are generated as per the company standards
• Executed very complex SQL queries to validate and verify data set per business rules. Working with Data Analyst’s on the Ambiguities raised during Analysis/Testing Phase.
• Wrote and submitted weekly quality assurance status reports.
• Attended and participated in periodic product status meetings

Environment: ETL Informatica 9.x, BI Cognos 8.0 Series, SQL, PL/SQL, HP QC, Rational Clear Quest, XML files, Flat Files, TOAD, XSD, XML Spy 2013, Putty, WinSQL, DB2, SQL Server 2008, Oracle 10g, Autosys, IBM AIX 6.1