PROFESSIONAL SUMMARY:

• Around 7+ years of professional experience in Software Testing as Software Quality Assurance Engineer on different platforms and environments
• Solid Back End Testing experience by writing and executing SQL and PL/SQL Queries.
• High understanding on the various instruments like Bonds, Swaps, Asserts, commodities, derivatives.
• Involved in developing various test plans and test cases for different versions and applications using Quality Center.
• Involved in executing test plan test strategy and test scripts for Functional, Integration, UAT, Negative and Backend testing.
• Experienced in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification and identifying data mismatch.
• Worked on data migration strategies and impact analysis for both teradata and oracle database systems
• Excellent hands - on exposure to SDLC lifecycle methodology involving Waterfall, Spiral, RUP, Agile Scrum & Sprint techniques and thorough understanding of Application Life Cycle Management(ALM)
• Exposure to various areas of data migration and database design for Data Warehouse applications.
• Working Experience on Testing Data Warehousing (DWH) concepts, Data Analysis, Data Warehouse Architecture and Designing.
• ETL Tester with INFORMATICA, SSIS Warehouse Environment and OLAP Reporting via SSRS and COGNOS.
• 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.
• Experience in various aspects of testing including Data migration Testing, Regression Testing, System Testing, Integration Testing, User Acceptance testing(UAT).
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Expertise in Testing complex Business rules by creating mapping and various transforExcellent 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.
• Expert in writing SQL queries and has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensive experience in Perl and UNIX shell scripting
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Experience in testing XML files and validating the data loaded to staging tables.
• Experience in testing and writing SQL and PL/SQL statements.

TECHNICAL SKILLS:

Data Warehousing: Informatica 9.1, Ab Initio CO>OP 2.14, GDE 1.14, Data Stage 8.x

Reporting Tools: Business Objects XIR2, Cognos 8.0 Suite, Crystal Reports, SSAS, SSRS, MicroStrategy

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, HP Quality Center, Rational Tools

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2005/2008. UDB DB2, Sybase, Teradata 13, MS Access 2008

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, .NET, Java, J2EE, XML, XSD, XSLT

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Hyperion, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr.QA/BI Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Participated and Performed System Integration testing by developing Sub graphs and Integrated with Extraction and Load Graphs.
• Tested reports using SSRS functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Involved in rebuild testing of the BI Reports from Cognos to Crystal Reports.
• Involved in conversion of WinRunner scripts to QTP (Quick Test Pro).
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
• Conducted user acceptance testing (UAT) to validate that the developed application meets the business requirements and executed/monitored Auto Sys jobs
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• Executed the Test cases for Crystal Reports and Cognos.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
• User Acceptance Testing, Performance Testing and White and Black Box testing manually and also coordinated with automation team for implementing automation testing using WinRunner, Load Runner and QTP.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Written extensive PERL and UNIX Shell scripting for data parsing and text parsing needs including archiving the old data, running backend jobs & setting up of job dependencies.
• Tested the SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc, Dashboards etc.
• Understood the business process that included Sales processes, Rating methodology, different Products, Group Renewals and Enrollment process in Facets.
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh,
• Used HP Quality Center to state requirements, business components, test cases, and test runs
• Extensively involved in testing Facets Member/Subscriber, Billing modules.
• Involved in testing Facets for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition, Premium Rate Tables and all.
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Used PERL scripts for data parsing, text processing, database connectivity and to validate the data.
• Defined the Scope for System Integration Testing and was responsible to understand and train others on the enhancements or new features developed.
• Worked with business team to test the reports developed in Cognos
• Performed Regression Testing and automated the test scripts using WinRunner.
• Developed JIL’s for autosys for job settings and job scheduling.
• Used Facets to provide seamless transactions between the provider, members and the plan.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat file Data into Teradata tables using Unix Shell scripts
• Worked with SSRS XML export on the reports and with ranking values in the XML..
• Expertise in working in Agile (Scrum), Waterfall, Spiral methodologies
• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Involved in the Agile Scrum Process
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Raised defects in HP Quality Center defect tracking system.
• Tested several Cognos Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s and Web Reports.
• Working on Medical Networx Configuration under Networx module in Facets to gather agreement information while processing claims like allowed amount and contract terms and Pricing details to process claims and for successful adjudication.
• Tested whether the reports developed in Cognos are as per company standards.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms..
• Gained working knowledge of Autosys jils at command line for loading/force starting jobs, changing job status and monitoring job progress.
• Testing the source and target databases for conformance to specifications
• Conditional testing of constraints based on the business rules
• Design and execute the test cases on the application as per company standards and tracked the defects using ALM/HP Quality Center
• Defined and ran jobs using the Autosys Graphical User Interface (GUI) and Job Information Language (JIL), monitoring and managing AutoSys jobs and alarms.
• Compared query result sets from different database systems using UNIX diff command.
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Preventing occurrences of multiple runs by flagging processed dates
• Testing of records with logical delete using flags
• Used PERL for automating all the types of modules at a time and Responsible for testing the reports according to client’s requirement using Cognos.
• Automated manually written test cases by using WinRunner.
• Ran jobs using the Autosys to load the data from Source to Target.
• Tested the configuration of Medicaid Claims and Sub-systems in Facets.
• 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
• Tested Netezza database for Data Validation, Data Verification using NZ SQL.

Environment: SSIS,AGILE, XML, XSLT, PERL, WinSQL, FACETS, Windows NT 4.0, SQL Server 2008, Autosys, QTP 9.2, Netezza NPS 8050, NZ SQL, ALM/HP Quality Center 11, DTS, T-SQL, SQL, Teradata 13, SSRS,TOAD, Teradata SQL, Oracle 11g, PL/SQL, MVS, IBM DB2, SAS, Cognos 8.4, MS Access/Excel/Visio, UNIX Shell Scripting

Confidential, Tampa, FL

QA/BI Tester

Responsibilities:

• Analyzed the Functional requirements using Scenarios & DDD(Detailed Design Document)
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Generated the detailed reports of the Bugs, go no go reports and comparison charts.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Tested the reports generated by SQL Server reporting services (SSRS) and checked as they are as per the Organization standards.
• Involved with discussion with Business for supporting functional specifications.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Wrote and executed test scripts to verify most of the Test cases using WinRunner.
• Used Quality Center for defect tracking
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, Data Cleansing, Data Scrubbing and Data Migration.
• Worked on UNIX Shell wrapper scripts Worked on Autosys which involved in creation of Autosys jobs, execution.
• Involved in FACETS Implementation Testing, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Created the list, cross tab, repeater and Drill-through reports and created the reports in different formats like PDF, XML, and HTML. Created public folders, private folders, personalized pages and custom views on the Cognos connection portal.
• Conducted regression testing using WinRunner.
• Performed Unit testing and System Integration testing by developing and documenting test cases in Quality Center.
• Defects tracking, review, analyze and compare results using Quality Center.
• Participating in the MR/CR review meetings to resolve the issues.
• Written various Autosys JIL Scripts to activate the UNIX scripts in production i.e. Jil scripts for the Box and Commands
• Expert in Waterfall Lifecycle, AGILE and Iterative project testing methodologies
• Well versed with various types Software Development methodologies- Water fall, Agile, RUP, Iterative and eXtreme Programming
• Wrote complex SQL syntax using case, having, Group by etc
• Excellent knowledge on Agile Methodology.
• Defined the Scope for System and Integration Testing
• Set claim processing data for different Facets Module.
• Proficient with automated testing tools - WinRunner and QTP for testing Client / Server and Web based applications.
• Experience testing ETL products, tested transaction for ETL using Ab lnitioand SSIS and OLAP REPORTING using SSRS. Performed testing extensively for integration and unit testing of standalone and distributed GUI-based applications and GUI-less SOA Web Services.
• Tested and Distributed the reports to the users via Cognos Connection.
• Involved in developing detailed test plan, and responsible for writing test cases and test scripts using Quality Center for System Integration, User Acceptance, Functional and Regression Testing and various other testing.
• Worked on HP Quality Center and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Director. And also used HP Test Director to manage and track defects.
• Executed Complex SQL queries within UNIX shell scripts in the UNIX environment.
• Tested several data validation graphs developed in Ab Initio environment.
• Reported bugs and tracked defects using HP Quality Center 10.0 (Test Director)
• Complete expertise in system integration, data consolidation and data migration between vendors and clients legacy applications.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Identified & presented effort estimations related to testing efforts to Project Management Team
• Design, analyze and performed Integration and System testing on different leading health care software’s such as FACETS, MedPlus, Onyx etc to test all the different software components under one complete system.
• Manually performed User Acceptance Testing of FACETS implementation
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Work as a Data analyst to set Facets data in Claims Processing, Members/Subscribers, Groups, Billing for different testing efforts.
• Sound experience in Automated Testing and Testing Tools like Mercury Interactive WinRunner, LoadRunner and TestDirector
• Responsible for integrating with Facets .Designing test scripts for testing of Claims in Development, Integration and production environment.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Worked on Cognos Framework Manager to import data from SQL Server Data source to create Models for reports and published packages to Report Net server.
• Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ & TPUMP
• Using Import Wizard deploying the reports from Dev system to QA box.
• Used Sets, Metrics, Productive Analysis and Enterprise Performance Management (Scorecard and Dashboard).
• Tested ad hoc and canned reports for Business objects.
• Tested reports for various portfolios using universe as the main data provider.
• Used T-SQL for Querying the SQL Server2008 database for data validation and data conditioning.
• Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
• Worked with SSIS system variable, passing variables between packages.
• Identified system integration requirements, coordinated the collection and verification of business needs
• Tested Desktop Intelligence and Web Intelligence reports.
• Conducted test case review and revision of surrogate key generation in DataStage to uniquely identify master data elements for newly inserted data.
• Used Quality Center to track and report system defects
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Check the naming standards, data integrity and referential integrity.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: AGILE,Ab Initio CO>OP 2.15, GDE 1.15, Autosys, QTP, SQL Server 2008,FACETS, Quality Center 10.0, PERL, Oracle 10g, Java, Unix AIX 5.2,VB Script, T- SQL, SAS, XML, XSLT, XML Spy, SQL,SSRS, PL/SQL, Stored Procedures, Shell Scripting, XPath, OLAP, MVS, Teradata 12, MLOAD, FLOAD, FEXPORT, TPUMP, BTEQ, COBOL II, VSAM, JCL

Confidential, New York, NY

QA/BI Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Designed the data flow diagrams using MS VISIO.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• Worked with SSIS system variable, passing variables between packages.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
• Written Test Plans and Test Cases on Mercury’s Test Director Tool.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services.
• Scheduling and automating jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Environment: SAS/Base 8.1, SAS/Macros, SAS, PERL, UNIX Shell Scripting, SSRS, workflow manager, workflow monitor), Hyperion, Cognos, Mercury Test Director 6.5, QTP 7.2, SQL *Loader, Cognos 7.0, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, Teradata V2R4

Confidential, Wilmington, DE

BI/QA Analyst/Engineer

Responsibilities:

• Built the Forms for application using various form modules and windows.
• Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
• Written PERL scripts and UNIX Shell Scripts for various data comparison and data parsing needs.
• Conducted Bug Review meetings for update on defects from development team and retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application.
• Prepared daily/weekly bug status reports highlighting bug fix metrics and tracked the progress of test cycles in Quality Center
• Conducted & Knowledge Transfer Sessions on new applications to QA Analysts
• Designed the screens and layout using Visual Basic 5.0.
• Used SQL*Plus for updating the database and for data retrieval.
• Design and develop a custom database (Tables, Views, Functions, Procedures, Packages)
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Developed UNIX Shell scripts to automate repetitive database processes
• Work with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.

Environment: Oracle 7.0, SQL*Plus, SQL, Test Director, Rational Clear Quest, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, XML, XSLT, Java and UNIX, Korn Shell scripting, PERL