Vyshunavi Thalupula

• InvolveinBusinessanalysisandrequirementsgathering.
•  DevelopValidationplanandQualitysummaryreportfortheproject
•  Draft test plans based on test strategy. Reviewed, created andexecuted test cases and test scripts based on test strategy and testplans based on Product Requirement Document.
•  Extensively used SQL programming in backend and front-endfunctions, procedures, packages to implement business rules andsecurity.
•  ReviewingtheprojectandcoordinatingwithonsiteClients,onsiteProject Leads and local reporting Managers.
•  CreatedtheRegressionTestcasesandautomatedthemforthepurpose of regression testing using QTP.
•  ExtensivelytestedseveralCognosreportsfordataquality,fonts,headers & cosmetic
•  PromotedUnix/Informaticaapplicationreleasesfromdevelopmentto QA and to UAT environments
•  ResponsiblefortestingpackagesusingSSIStoverifydata completeness, data transformation, data quality, integration testing, UAT & regression testing
•  Worked in an Agile technology with Scrum. Conduct QA scrum call to gather status of the o!shore team. Communicate or KT the project details as and when needed. Provide QA testing timelines understanding the project requirement and scope of testing.
•  Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
•  E!ectivelycommunicatetestingactivitiesandfindingsinoraland written formats.
•  ExtracteddatafromvarioussourceslikeOracle,flatfilesandSQL Server.
•  InvolvedinPerformancetestingtoensuretheloadandstress capability of the application. Validated documented user requirements.
•  Written several complex SQL queries for validating Cognos Reports.
•  Preparingdailystatusreportsanddefectreports.
•  WroteSQLscriptstoperformdatabasetestingandtoverifydataintegrity.
•  FocusedonDataQualityissues,problemsthatincludecompleteness, conformity, consistency, accuracy, duplicates, andintegrity.
•  Extensivelyworkedondesigningvariousoutputandmanagementreports Using SQL Server
•  QuerieddatabasesusingSQLqueriesinTOADandSQLServerManagement Studio to validate the data loaded into target tables.
•  ExtractedDatausingSSISfromDB2,XML,Oracleandflatfiles,Excelperform transformations and populate the data warehouse
•  Testedtheoutgoinglinksfromallthewebpagesfromspecificdomain.
•  CreatedShort-cutjoins,aliasesandcontextstomaketheuniverseloops free.
•  ReportedbugsandtrackeddefectsusingQualityCenter(Test

Director)

•  A test reporting environment was established to combineDistribution Work Management and
•  PeopleSoftinformationintoaconsolidatedplacetoallowcombinedreports to be generated.
•  Testedandworkedoncreatingopendocumentreportsforbusiness.
•  ExperiencedusingquerytoolsforOracletovalidatereportsandtroubleshoot data quality issues.
•  PerformeddataanalysisanddataprofilingusingSQLandInformatica Data Explorer on various sources systems includingOracle and Teradata
•  InvolvedintestingtheCognosreportsbywritingcomplexSQLqueries
•  Optimizing/Tuning several complex SQL queries for betterperformance and e"ciency.
•  CreatedvariousPL/SQLstoredproceduresfordroppingandrecreating indexes on target tables. Worked on issues with migrationfrom development to testing.
•  DesignedanddevelopedUNIXshellscriptsaspartoftheETLprocess, automate the process of loading, pulling the data.
•  Analyzedtestcasesforautomationandcreatedscriptsforregression testing using QTP Automated Test cases for the purposeof regression testing. .
•  Tested data warehouse ETL process using SSIS (Integration Service)
•  Managedandexecutedthetestprocess,usingAgileMethodology
•  Reviewthetestcasesandbugreports.

• DevelopedandDesignedTestCasesbasedontheBusiness requirements.
•  Written several complex SQL queries for validating Cognos Reports.
•  ExtensivelytestedthereportsgeneratedinCognosbywritingSQLqueries to validate the data on the report and compare with the TPWdata.
•  UsedAgileTestMethodstoproviderapidfeedbacktothedevelopers significantly helping them uncover important risks.
•  Written several complex SQL queries & PL/SQL stored proceduresfor validating Cognos Reports
•  Used SQL for Querying the database in Linux environment fortesting the business rules imposed on data movement withInformatica ETL tool.
•  UsedtheETLprocessesofInformaticatooltoloaddatafromMSSQLServer and Oracle, into the target Oracle database.
•  AttendedwalkthroughmeetingswiththeBusinessAnalystsanddevelopment to get a clear understanding of the business and theapplications being used in house.
•  PreparedTraceabilityMatricestotracktherequirementswiththetest cases and make sure none of them have been missed.
•  Developedautomationtestscriptstotestthedatabasebyretrievingthe data from the tables using HP QTP 10 and VB Scripting.
•  Validatedthatdesignmeetsrequirementsandfunctionaccordingtotechnical and functional specifications.
•  UsedHPQualityCenter9.2tostaterequirements,businesscomponents, test cases, and test runs for every iterations, defects.Also link defects with requirements.
•  InvolvedinrecordingchangerequestsontheChangeRequestForm(Remedy) Participated in meetings.
•  Performed all aspects of verification and validation
•  WorkedwithothermembersoftheQAandDevelopmentteamsando!shore team in improving the processes, methods, e!ectivenessand e"ciency
•  Coordinatingwithsourcesystemowners,day-to-dayETLprogressmonitoring, Data warehouse target schema Design (Star Schema)and maintenance.
•  Generatedatarequirementsandsystemspecificationsinan

organized fashion for business solutions and for the developers to

follow on.

•  Worked with business team to test the reports developed in Cognos
•  UsedTOAD&SQLNavigatorGUItoolsforQueryingDatabase.
•  Participated in walkthrough and defect report meetings periodically.
•  DocumentedandreportedvariousbugsduringtheTestingprocess.
•  WrittenSQLQueriestodefine,Identifyandvalidatethecodewrittenfor the data movement into the database tables.
•  TestedtheFront-EndWebApplicationsdevelopedinJ2EEfordataportal for matching
•  DevelopedPL/SQLprocedures&triggers.
•  Retestingtheresolveddefects/issuesafterthedevelopersfixthedefects
•  InvolvedinpreparingtestdataforUATandparticipatedinUATsigno!
•  PreparedstrategiesforanalyzingthedataforETLTeam
•  Worked in an agile technology.
•  InvolvedintestingtheCognosreportsbywritingcomplexSQLqueries
•  CreatedandexecutedSQLqueriesinORACLEandMSSQLserver
•  UpdatedthestatusofthetestingtotheQAmanager,andaccomplished tasked for the assigned work to the Project Management team regularly.Environment: Cognos 8.x, Informatica 8.1/ 7.1.4 (Power Center Designer, workflow manager, workflow monitor), MS SQL Server 2008,Oracle 10g, PL/SQL, TOAD 8.0, QTP,SQL, Linux, Netezza, Maestro 8.0 (Tivoli Work Scheduler), Charm, Agile, Remedy, Test Director/Quality Center, Power Connect, PowerAnalyzer4.1

• InvolvedinBusinessanalysisandrequirementsgathering.
•  Assisted in creating fact and dimension table implementation in StarSchema model based on requirements.
•  Involvedincompleteprojectsoftwaredevelopmentlifecycle(SDLC)and Quality Assurance Life Cycle (QALC)
•  ReportedperiodicprojectstatusandupdatestotheQALeadandQAManager
•  Performed Integration Testing of di!erent modules.
•  Heavily involved in interacting with UNIX Shell scripts.
•  AnalyzedBusinessRequirementsandDevelopedtheTestPlan,TestScripts and Test Cases
•  IdentifiedtheTestCasestobeautomatedandleadthee!ortforautomating the product.
•  UsedTestDirectortoorganizetheWinRunnerScriptsandscheduletest execution.
•  UsedTestDirectorforBugReportsandDefectTracking.
•  TestedUserInterfaceinconsistencyandapplicationfunctionality.
•  DevelopedtestscenariosfortestingEnterpriseDatawarehouseandCredit Data Mart data in DB2 environment.
•  DevelopedSQLscriptstovalidatethedataloadedintowarehouseand Data Mart tables using Informatica.
•  DevelopedReportsandGraphstopresenttheresultstothemanagement.
•  Preparationoftestdataforvariouslevelsoftesting
•  Performedsegmentationtoextractdataandcreateliststosupportdirect marketing mailings and marketing mailing campaigns.
•  Loadnewormodifieddataintoback-endOracledatabase.
•  Optimizing/Tuning several complex SQL queries for better

performance and e"ciency.

•  CreatedvariousPL/SQLstoredproceduresfordroppingandrecreating indexes on target tables.
•  Developed Test Strategy, Test plan, Test cases, and Test scripts andvarious other project documentation in HP Quality Center
•  Worked on issues with migration from development to testing.
•  DesignedanddevelopedUNIXshellscriptsaspartoftheETLprocess, automate the process of loading, pulling the data.
•  Validatedcubeandquerydatafromthereportingsystembacktothe source system.
•  TestedanalyticalreportsusingAnalysisStudioEnvironment: Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), OBIEE, Oracle 9i, Agile, HP Quality Center, TOAD 7, SQL *Loader, SQL Server 2000, QC, Test Director, Erwin 3.5, Windows 2000Confidential, Columbus, OH QA Analyst Responsibilities:
•  ParticipatedinRequirementAnalysis,BusinessAnalysis,Use-Case Analysis and Gap Analysis.
•  Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
•  ConductedFunctional,GUI,RegressionandUser-Acceptance(UAT) testing.
•  DevelopedXMLtestfilesbasedonXMLschema.
•  GeneratedXMLdatafilesusingXMLSpy.
•  ValidatedtheWebServices(SOAP),bothRequestandResponsemessages.
•  TestedtheSourceandTargetdatabasesandETLprocess.
•  DevelopedTestCasesandTestDesignusingQualityCenter.
•  AutomatedthescriptsusingQTPbydevelopingVBscripts.Developed functions in QTP.
•  Worked with SQL, PL/SQL and functions to test the databaseintegrity (Oracle).
•  CreatedTraceabilitybetweenRequirementsandTestCases.
•  ConductedDataDriventestingtotestvarioussetsofdata.Workedwith UNIX Shell Scripts.
•  TrackedthedefectsusingTestDirectorandgenerateddefectsummary reports.
•  MaintainedTestLogs,TestSummaryreportsandparticipatedindefect review / Status / GO-NOGO Meetings.
•  Configuration management / Version control was done using VisualSource Safe.
  Environment: Mercury Tools, QTP 8.0, VB.NET, ASP.NET, IIS, XML, SOAP,Windows XP, SQL Server, Mainframes (DB2, JCL, CICS), MS-O"ce.

•  Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
•  Providedsupporttosalesteammanagementandsalesoperations support groups in the receipt, warehousing and reporting account level sales information.
•  ExtremelyinvolvedinusingTestDirectorforidentifyingthebugs with the help of SQL queries.
•  InvolvedinunderstandingtheRequirementsoftheend Users/Business Analysts and Developed Strategies for ETL processes.
•  ResponsibleforMinispecificationsdocumentthatdescribethe functionality of each subject area.
•  UsedT-SQLforQueryingtheSQLServerdatabasefordatavalidation and data conditioning
•  Reportedsoftwaremismatches(fromthetestplanning),tothe development team using Quality Center
•  ImplementedDatabaseCheckpointsforBack-endTesting
•  PerformedtheBack-endIntegrationTestingtoensuredataconsistency on front-end by writing and executing SQL statements
•  Managedandexecutedthetestprocess,usingAgileMethodology
•  AnalyzedtheDataDictionarydevelopedbytheSystemsAnalystfordeveloping test scripts to test the Policy and Claims systems.
•  Implementing logical and physical data modeling with STAR schemausing Erwin in Data Marts.
•  ExtensivelyusedInformaticaPowerCenter8.1.1toloaddatasourcing from Source to Target databases.
•  ExecutingETL-InformaticaWorkflowsforupdatingtestDatabasesfrom the Production servers.
•  Workedrigorouslywithdeveloperstocreatetestscriptsinregardstothe Informatica ETL.
•  Used Quality Center to track and report system defects
•  FollowedRUPandAGILEdevelopmentmethodologyandadheredtostrict quality standards in requirement gathering.
•  TestedalltheinternallinksandtestedlinksjumpingonthesameWeb page
•  TestedseveralreportsdevelopedinMSReportingServiceswhichwere migrated from Business Objects XI R2.

Environment: Informatica 8.1.1, Business Objects Xi R2, Windows XP, Oracle10G, Sybase, IBM DB2,TOAD for Oracle, UNIX, MS SQL Server 2008,Reflections, Agile, Mercury Quality Center.