We provide IT Staff Augmentation Services!

Qa Analyst-2 (java & .net Applications, Database Testing) Resume

Alexandria, VA

SUMMARY:

  • Over 9 years of total IT experience as Quality Analyst and as developer (Siebel Actuate Reports).
  • Over 6 years of experience as QA Analyst on Java Applications, .NET Applications, database, Siebel CRM, OBIEE data warehouse reports, BI Publisher and Actuate adhoc/OLTP Reports.
  • 3 years of experience on Siebel Actuate Report development and as Actuate Server Administrator.
  • Has good Experience and expertise on Software Development Life Cycle (SDLC) and on Agile Methodology.
  • Experience in designing Test Cases/Test Scripts/Test Conditions for the Unit Testing, verifying and validating Web based e - commerce applications, Integration Testing, System Testing, and Worked in Enterprise Data Warehousing environment with ETL Tools like Informatica.
  • Met time frame for deliverables, added value for applications and to deliverables by following rigorous testing standards and compliances.
  • Proficient at writing Test Plans and Strategies by following different QA Methodologies.
  • Experience in System Test Plans, defining Test Cases, developing and maintaining Test Scripts and documentation both in Manual and Automated Testing.
  • Proficient in Black Box testing, QA and QC Methodologies and Integration Testing, System Testing, User Acceptance Testing (UAT), Backend Testing, load/performance, security, browser compatibility, and Rational Performance Testing.
  • Expertise in Problem solving and Tracking Bug Reports using Bug tracking Tools.
  • Good Understanding of Web Services, SOAP UI, XML, WSDL, HTML, CSS, Style Sheets, .NET, Siebel, JavaScript, VB Script and on HIPPA transactions.
  • Has good knowledge and experience using SQL, Triggers, Stored Procedures, database connectivity, Unix Shell Scripting, TOAD for Back-end testing.
  • Has good knowledge of Database Servers, and Application Servers.
  • Extensive knowledge in using the Mercury Automated Tools like Win Runner, Quick Test Pro, HP Quality Center and IBM Rational Tools like Clearquest, RequisitePro.
  • Expertise in Functional, Integration, User-Interface, Database, Installation, Performance, and Regression Testing.
  • Has extensive experience in Manual and Automated Testing, including QuickTestPro.
  • Proficient in working on various OS environments (Windows, Solaris, HPUX, AIX and Linux).
  • Good understanding on HP ALM.
  • Experienced in testing Web-based, Client-Server(java, VB & .Net), CRM/ ERP applications, OLTP reports(Actuate) and Reports on OLAP database(OBIEE)
  • Thorough knowledge in various databases like Oracle (10g & 11g ), DB2 and SQL Server.
  • Experience in cross-platform testing. Experienced in using various Bug-tracking tools.
  • Good understanding of a product life cycle (thorough knowledge of Release-cycle and enhancements/bug fixing )
  • Worked as developer on Actuate Report development(Reports in Siebel CRM application) projects
  • Developed excellent professional skills by working independently and as a team member to prepare test plans, Scripts and Test Cases for manual testing as well as Automation.
  • Excellent written and Verbal communication skills.

TECHNICAL SKILLS:

Areas of Expertise: Quality Assurance Testing, Siebel Actuate Report development

QA Tools: RTC, RQM, Quality Center, HP ALM, JBOSS, Test Director, QuickTestPro, Win-runner and PVCS Tracker, Rally, SOUP UI

Languages: VB, Actuate Script/VB Script, JSON and XML

Database: SQL Server, Oracle, DB2, MS-Access, Cassandra

Reporting Tools: Actuate Reporting tool (iServer, Designer Professional, Active Portal, Management Console, eSpread Sheet, BIRT and iServer), BI Publisher and OBIEE 10g & 11g.

Web Technologies: HTML, DHTML, SOAP, Java, .Net, VBScript, XML, and DTD

Modeling Language: UML

Development Tools: TOAD, Informatica ETL tool, Quest, Microsoft Visio, Actuate Workbench 7.0/5.00

Operating Systems: NT 4.0/2000/2003/2008/ XP/Windows7, UNIX, Sun Solaris

Siebel Version: Siebel 8.0 / 7.8/7/7.5.3, 7.0 & Siebel 2000 / 6 (Siebel Application Configuration, Actuate Report Development, EAI, EIM, Workflow Manager, Assignment Manager, Business Services, eScript, Siebel Analytics and Siebel proposal Generation)

Siebel Modules: Siebel Call Center, Sales, Services, Financials, Field Services, eAutomotive and eDealer

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

QA Analyst-2 (JAVA & .net applications, Database testing)

Responsibilities:

  • Worked as QA analyst on java & .Net applications and as backend tester( Database) for data quality.
  • Designed & developed the Master & detailed Test plan using the Business requirements.
  • Conducted the Functional, System, Integration, Regression, UAT and Smoke Tests of the Web application
  • Developed detailed level of test cases for new functionality of application.
  • Involved in database testing to ensure the data accuracy at application and at report level.
  • Involved in UAT testing and in SOAP UI testing.
  • Ensuring test case creation and mapping, test case execution, defect tracking, coordinating with development team, support UAT and status reporting.
  • Performed manual and automation testing of a applications, database and reports
  • Escalation of critical problem/issues during testing phase and reporting them in Rally.
  • Worked in agile methodology and involved in daily scrum calls/standups.
  • Met time frame for deliverables, added value for applications and to deliverables by following rigorous testing standards and compliances.
  • Environment: Java, Oracle 10g/11g, Cassandra, Toad, SQL Developer, SOAP UI, Rally, Putty, WinSCP, FileZilla and Window 7 & 10.

Confidential, Reston, VA

QA Analyst (JAVA application, Database testing and Reports testing)

Responsibilities:

  • Worked as QA analyst for java application, Database and for its reports testing.
  • Designed & developed the Master & detailed Test plan using the Business specifications
  • Conducted Functional, System, Integration, Regression, Unit testing, UAT and Smoke Tests of the Web applications
  • Developed detailed level of test cases for new functionality of application.
  • Involved in database testing to ensure the data accuracy at application level.
  • Involved in unit testing and in SOAP UI testing.
  • Ensuring test case creation and linking, test execution, aligning development support and all status and reporting
  • Performed manual testing of the Applications and database.
  • Escalation of critical problem/issues during testing and reporting them in Rally.
  • Environment: Java, .Net, Oracle 11g,Rally, Toad, SOAP-UI and XML.

Confidential, Reston, VA

QA Analyst (CRM application, OBIEE Reports, Actuate Reports, BIP Reports, Database and Integration process testing)

Responsibilities:

  • Worked as QA analyst for applications, Database and for integration processes
  • Designed & developed the Master & detailed Test plan using the Business specifications
  • Conducted the Functional, System, Integration, Regression, performance, UAT and Smoke Tests of the Web application
  • Ensuring test case creation and linking, test execution, aligning development support, defect management, and all status and reporting
  • Creating and maintaining all testing and defect management documentation, reporting expectations, process continuation, adherence to CMMI requirements, and other testing related activities
  • Performed manual testing of the Applications, database and for reports
  • Involved in various Technical and Functional testing for different applications
  • Escalation of critical problem/issues during testing and reporting them in Quality Center
  • Performed Functionality and Security testing of the User authentication and resetting the passwords using the admin forms
  • Used OBIEE physical SQLs to test/validate OBIEE reports.
  • Created Dashboards, Analysis/reports and prompts as part of OBIEE reports testing and user training.
  • Involved in data validation of OBIEE reports by comparing OBIEE reports data with SQL runs data output.
  • Involved in Testing of OBIEE reports extensively and also involved in user training for OBIEE reports and involved in UAT.
  • Tested OBIEE 11g reports and did data validation after OBIEE 10g had upgraded to 11g.
  • Tested BI Publisher reports by comparing with Actuate Reports data after Actuate Reports had migrated to BIP.
  • Performed data validation and testing extensively by using SQL queries including multi-table joins, aggregate functions and sub-queries
  • Tested applications accordance to 508 compliances
  • Tested data loads from flat file to Siebel applications
  • Tested integration processes between ARCIS and HMS applications through web services
  • ARCIS has machine critical OLTP reports which are the part of daily business activities. These reports has barcodes where users scan these barcodes into application and proceeds to further steps of business flow
  • Tested OBIEE reports in answers, tested iBots, dashboards and scheduled reports
  • Tested Siebel actuate reports which used multiple flows in single page, composite data streams and parameterized reports
  • Actively interacted with user in understanding their functional requirements
  • Worked on different browsers to test ARCIS application behavior on different browsers
  • Worked on Siebel application system testing for patch releases (7.8.2.5 / 7.8.2.8 /7.8.2.12 / 7.8.2.14 / 7.8.2.16 )
  • Worked on end to end ARCIS(Siebel)application testing for IE 8 browser rollout
  • Worked on end to end ARCIS(Siebel)application testing for windows 7 OS and IE 9 rollout
  • Involved in requirements gathering for registry application(new role out) and worked as end to end tester throughout all phases of registry application life cycles

Environment: Quality Center ALM,SQL,Siebel 7.8.4.16 (Center), Siebel Tools, Actuate 7.0, OBIEE 10g & 11g,, BI Publisher 10, Oracle, Toad, WinSCP, Putty, Windows XP, Windows 7, Sun Solaris

Confidential, Durham, NC

QA Tester (Application tester, Database Tester and integration process tester)

Responsibilities:

  • Designed & developed the Master & detailed Test plan using the Business specifications.
  • Got complete knowledge of functionality, process and flow of BOL, PSOR, CRM and OMS applications and used this knowledge to Create Test plan and Test Cases to cover overall functionality of the application
  • Extensively worked on testing of Actuate Reports and Siebel Analytics(OBIEE) reports with respect to BOL, PSOR, CRM and OMS applications.
  • Conducted the Database testing of the application, by executing the SQL scripts in Toad. Used SQLs & PL/SQL (on DB2) to test integration processes between Siebel & Mainframes, AS/400.
  • Worked as database tester to evaluate reports (Actuate & OBIEE) data with data in database.
  • Tested applications accordance to 504 compliances
  • Tested Siebel Accounts, Contacts, Service Requests, Quotes, Orders, Products, Activities and workflow related activities.
  • Tested MVG, pick applets, form applets.
  • Validated individual accounts and member enrollments in power MHS.
  • Validated Account Receivable, Payables, Refunds in Power MHS for individual credit card, Bank drafts or direct bills.
  • Tested routing the work activities and Assignment Manager. Tested Work Flow processes, Work Flow Policies and Work Flow Actions.
  • Implemented the SDLC for the testing life cycles and followed the Standards process in the application.
  • Running the Batch jobs in the Unix to get the Outbound and inbound data of the application.
  • Mentoring UAT team and trained them in Siebel Applications.
  • Created functions in VBScritp and called those in QTP script for execution of the script according to the requirements.
  • Created Universal repositories for Test environment to access the objects in QTP.
  • Assigned Test Cases, used cases for functional testing among UAT team members.
  • Escalation of critical problem/issues during testing and reporting them in Test Director.
  • Involved in Requirement gathering for reports, design, development and testing of few actuate reports
  • Modified XML files to manipulate the data to fake the web services
  • Regression Test Plan and Production Acceptance test plan for the test releases
  • Testing knowledge in HIPAA transactions like 837 Instructional, 837 Professional, 837 Dental claims and 835 claims processing.
  • Prepare and execute Test Cases for end-to-end functionality testing.
  • Created Virtual Objects in Winrunner for unrecognizable Siebel objects.
  • Entire Regression test is done by using Winrunner.
  • Linked Winrunner script with the Test Director for Batch Execution.
  • Implemented the SDLC for the testing life cycles and followed the Standards process in the application.
  • Worked on actuate reports user administration, synchronizing the users, Access control, adding the Privileges to the Users and Scheduling the Reports on Report Server

Environment: Test Director, Siebel 7.5.3(eFinance, Call Center), Siebel Tools, Actuate 6.0, DB2 8.1, IBM AIX 5.1, Windows XP, Toad

Confidential, NY

Actuate Report Developer

Responsibilities:

  • Developed complex reports like Parameter Applet Reports (Multiple Parameter inputs) and composite data stream reports.
  • Developed a report which has 11 pages and pulls data from 14 business components. For this complex report, I used sequential section, Composite sections and parallel sections to show data from non-related BCs in single report.
  • Created Links, joins and Cloned BCs to as part of report object creations.
  • Installed Actuate software for development, Created Roles, Synchronized Users, attached users to roles and designed for access to reports server access and My Reports Access.
  • Added Contact names to Letter Report from child BC, where as there is multiple contacts for each Account and criteria is based on Contact Type and account type.
  • Worked with BAs, PM, Siebel Admin and users for gathering requirements, data validation, and Actuate Server Parameters setup in Siebel and for sign off.
  • Preparation of technical Specs for Reports, user training on reports and involved in Actuate Server cache, log files cleanup and knowledge transfer.

Environment: Actuate 8(Designer Professional, Console Manager, Active Portal), Oracle10i, UNIX, Windows XP, Siebel 8 (Public Sectors)

Confidential

QA Tester Actuate Report Developer

Responsibilities:

  • Involved in IPM application functionality testing
  • Designed & developed the Master & detailed Test plan using the Business specifications
  • Create Test plan and Test Cases to cover overall functionality of the application
  • Done database testing on Oracle database using SQL queries
  • Worked with Siebel team to develop Siebel - Actuate Reports and to test Siebel Application functionality end to end
  • Developed complex reports for its key area of Service Requests.
  • For Service Requests, I developed most useful and important reports for analytical process. Reports displays information like Service Request By Status, Service Request By Sub-Status, Service Request By Type, Service Request By Sub-Type, Service Request By Tier, Service Request By Source, Service Request By Priority and Knowledge Base Used By Tier levels. Also, these sections provide comparisons between the sections and its percentages.
  • Reports developed to show the productivity of help desk staff and their skill level capacity.
  • Involved in Reports Testing, IPM CRM application testing (manual testing)
  • Written Unit test cases for CRM application testing and reports testing.
  • Preparation of technical design document for Reports.

Environment: Jira, Siebel 7.8.3, Actuate Reports7, Ms-Excel, MS-Word, Windows 2000, XP, Java, XML and Main Frames

Confidential, PA

Actuate Reports developer & Support

Responsibilities:

  • Joined with Siebel team to develop Siebel - Actuate Reports before rollout of couple of weeks.
  • Developed complex reports like Parameter Applet Reports (Multiple Parameter inputs) and composite data stream reports. 11 Out of 18 are parameter applets and some are composite Data Stream.
  • Developed Letter Reports as parameterized Reports, these reports data and layout will be changed based on GNPPN Account status and on one more field value.
  • Created Links, MVLs, MVFs and Cloned BCs to display different addresses like Mailing address, Pay Address, Corporate Address and Primary Address for each GNPPN Account in List Report.
  • Installed Actuate software for development, Created Roles, Synchronized Users, attached users to roles and designed for access to reports server access and My Reports Access.
  • Added Contact names to Letter Report from child BC, where as there are multiple contacts for each Account and criteria is based on Contact Type and account type.
  • Worked with BAs, PM, Siebel Admin and users for gathering requirements, data validation, and Actuate Server Parameters setup in Siebel and for sign off.
  • Preparation of technical Specs for Reports, user training on reports and involved in Actuate Server cache, log files cleanup and knowledge transfer.

Environment: Actuate 8(Designer Professional, Console Manager, Active Portal), Oracle10i, UNIX, Windows XP, Siebel 8 (sales)

Confidential, MN

Actuate Report Developer

Responsibilities:

  • Developing custom complex reports like Company Summary Report (fetching data from 8 BCs), Opportunity Summary Report, Notes Report and Opportunity, Activity Contacts Report which are all complex in report design (summary, count, Different Message Display based on different values, Frames dynamic size, searching, sorting, report layout and others) and which required few Siebel config changes.
  • Production support for existing system and User Administration.
  • Modifications in existing reports and modified them as per the requirements. (Added Nested IF conditions, Composite data streams)
  • Configured Siebel BO layer by adding joins, links, added BCs to BO for data population in Siebel.
  • Configures parameterized applets and Report objects.
  • Performance Tuning by removing unnecessary search criteria and Sort, enhancements in existing reports.
  • Preparation of technical Specs for Reports, user training on reports and Actuate Server cache, log files cleanup.
  • Suggested three levels of Performance tuning process for Actuate Reports to avoid load on Siebel and for better performance of Reports i.e. 1) Shifting Search and Sort from Siebel Report Object to Actuate Design 2)Actuate code review 3)Siebel Object Manager level
  • Given spooled SQLs for report generation to DBA to add indexes in database for better report performance.
  • Prepared local set up for report development includes Siebel Client, Tools and Actuate Designer Prof software installation, Local DB initialization.
  • Given inputs on Actuate 8 upgrade for proposed Siebel 8 upgrade.

Environment: Actuate 7(Designer Professional, Console Manager, Active Portal), Oracle9i, UNIX, Windows XP, Siebel 7.8 and Siebel 8 (call center & Financials)

Hire Now