We provide IT Staff Augmentation Services!

Lead Qa Business Intelligence Analytics Resume Profile

4.00/5 (Submit Your Rating)

TX

TECHNICAL

SUMMARY:

  • Over 13 years of IT Industry experience in Systems Development and Testing from project definition to post-deployment documentation on Unix/Windows environment.

Strong Background:

  • Over 10 years of experience in Quality assurance of both Manual and Automated Testing of diverse applications on Windows and Unix Environment.
  • Excellent experience of Software Development Life Cycle and Test Methodologies Waterfall, Agile, Scrum Model from project definition to post-deployment documentation
  • Expertise in designing and developing strategic Test plans, Test Cases, Test Scripts, Test Scenarios, Test Reports for both manual and automated tests
  • Extensive experience in Functional, Regression, Integration, Exploratory testing, Sanity testing, User Acceptance, and System Testing.
  • Proficient in using testing tools such as Quality Center, WinRunner, Quick Test pro, Selenium for web and client server applications
  • Manually performed Back-End testing by writing SQL queries.
  • Used Message Broker Middleware Microsoft Biztalk Server, IBM WebSpere , Financial Fusion Sybase for Routing, transforming messages and storing messages in the repository.
  • Familiarity with Waterfall, Agile, Scrum Iterative development practices.
  • Extensive experience in tracking bugs using Bug tracking tools such as Test Director, Quality Center, Star Team, TFS, Rally and Clear Quest.
  • Experience in SOX related projects with an understanding of controls related to SOX.
  • Strong experience in Enterprise Control Station ECS , WS FTP Pro 6.5 and DBArtisan 6.0.
  • Excellent experience with MS SQL Server 2008, Oracle 9i, T-SQL, Unix Shell Script Programming using KSH, SED AWK.

TECHNICAL

SKILLS:

  • Desktop and Laptop Computers: Extensive knowledge of PC hardware and software.
  • Hardware: Sun Solaris 5.6, HP-D210 HP-9000 Series , DEC-Alpha 2100.
  • RDBMS: SYBASE 12/11.x/10.x, SQL Server 2008/2005, Oracle 10g/9i, Fusion, Crystal Report.
  • O.S: Sun Solaris 7, HP-UNIX, DIGITAL-UNIX 3C, WIN NT, Windows .
  • Languages: TSQL, HTML, XML ,XSL, CSS, JavaScript, ASP.NET ,C
  • Testing Tools: QTP, J-Meter. Selenium IDE, Quality Centre 10, Browser Stack, VS Test Professional 2010
  • Protocols: TCP/IP, LDAP, DNS Microsoft networks.
  • E-mail packages: MS Exchange, MS Outlook
  • Other Tools: PowerBuilder 6.5/7, APT 5.x, TSQL, PLSQL, SQLPlus, DB-LIB, DBARTISAN 5.x, WS FTP., Vtrain,
  • Packages: MS Office 2010/2007. MS Project 2010

EXPERIENCE:

Confidential

Lead QA Business Intelligence Analytics

  • Developed and executed Test Plan, Test cases. Metrix, Defect tracking in Rally, Trello, Excel
  • Performed Functional, Regression, UAT testing on QA, Staging, Legacy, Production environments.
  • Track defects and review with development team and product manager on daily frequency.
  • Created test scenarios by analyzing the requirements, design document, mockups.
  • Extensive Data analysis, data validation and validation of Webfocus reports
  • Log, manage, and retest defects in bug tracking system.
  • Validate submitted bugs, assign bugs to development resources.
  • Accurately record and clearly document all actual results compared to expected results.
  • Communicate with developers on critical issues.
  • Provide Demo to business for validated stories
  • Compare Webfocus reports with reports that have been developed in legacy tool InfoEdge
  • Extensive use of SQL query for validating application functionality and ETL testing..
  • Verifying report elements graph, grid, side by side comparison of report, metric for questions, auto populated fields, Report title, Date filters, filtering options, grouping options, report formatting, scores, trend indicators, percentile ranking, calculations, mode calibrations Scheduling reports weekly, mthly etc to be delivered by email, internal external user logins for admin, super user roles, PDF reports, email notification with PDF reports, comments report, performance report, Creating surveys template base and manual , taking a survey ,Submitting a survey, Alerts, Alert notifications, PHI validation.
  • Data validation with other CRC reporting tools
  • Verifying application functionality on different Browsers, devices like tablet, iphone , OS android,windows,iOS etc using BrowserStack cloud environment
  • Verifying C3 application on Ipad iOS device. Integrating BI analytics tools in mobile devices.

Environment: .Net,MS SQL Server 2012, cfusion, Fusion, Webfocus, Trello, Rally, Sharepoint, Vtrain, BrowserStack, MSOffice, MSProject, TestFlight, Hockeyapp, SQLite, iOS, Jenkins

Confidential

Sr. QA Analyst Business eBanking, Mobile Banking, Business Service Tool

  • Developed and executed Test Plan, Test cases. Metrix, Defect tracking in TFS through completion , CMS. Translate Functional spec into detail test cases. Creating test data.
  • Developed test data for new development and regression test scenarios.
  • Document test results, troubleshoot and escalate issues as appropriate.
  • Involved in web based realtime, batch process application feature/functionality testing , data integration, application integration with FIS core technologies Systematics IM/ST system.
  • Executing batch process to upload/download file format validate ebanking functionality. Dashboard, Account Balances, Recent Transactions, Transfer and Payments, Deposit account reporting, Company administration, Self Administration , View mail and alerts, Download documents, Approvals administration, ACH reporting, , Express transfer, Book transfer, Wire transfer, Premium Alerts, Out of Band authentication etc
  • Performed functional, regression, end to end, system, backout testing, offline server testing, production defect validation, exploratory, smoke testing for various projects Bill Pay, Mobile banking, ACH, Security, Wire transfer, Branding Changes, Integration with customer information for different core banks etc
  • Ensuring setup is complete in Admin tool to connect to middleware and third party tools.
  • Accurately record and clearly document all actual results compared to expected results. Document test cases, test results in TFS repository for each releases.
  • Identify and logs valid system bugs and work with developers to drive defect resolution.
  • SQL query using PLSQL for validating application functionality.
  • Interacting with all the members of the project team including architect, business analysts, system analysts, project managers, support team..
  • Considered a subject matter expert for programs/systems.
  • Support release process and perform production site verification testing.
  • Provide estimates for testing activities
  • Provide accurate status reports of current work progress
  • Provide weekly status report to Project Manager.

Environment: .NET, Visual Studio 2012, TFS, Oracle 11g, Sharepoint 2012, Soap UI, Oracle, CMS, Word, Excel, IE 10, Fire Fox, Google Chrome..

Confidential

QA Analyst GENS Customer Care/ Billing Project

  • Developed and executed Test Plan, Test cases. Defect logging in QC.
  • Log detailed defects that will allow developers to easily diagnose the issue.
  • Creating test case scenarios by analyzing the requirements in Calibre that clearly convey the business rules.
  • Verify defects once they are fixed.
  • Identifies and logs valid system bugs and work with developers to drive defect resolution.
  • Involved in Continuous Integration environment that kicks off a suite of integration tests every new build.
  • Created test data load sheet for batch job load to db.
  • Actively participate in the Agile process.
  • Performed exploratory testing for new and existing functionality
  • Extensive SQL query using Toad for validating application functionality.
  • Updated the table test data for validating the application functionality for assembly testing.
  • Responsible for creating AT Test Summary Report, Test Closure Report before handoff to Product team.
  • Provide status of Test execution progress report to Project Manager .
  • Ensures that all Functional requirements are tested before handing off to product testing team.
  • Deliver daily status reports that identify testing status.

Project Details: E2E functional, assembly, regression testing of batch jobs, web based java application , Cognos reporting , informatica upload to SONAR db upload to documentum assembly testing . Support Product testing team for PT and Staging environment.

Confidential

Test Engineer

  • Develop and execute Test Plan Test Cases for various scenarios for Dynamics AX CFMD 2012 and 2009 Payroll Module.
  • Developed Test Cases for US Localization enhancements to AX 2009
  • Validate submitted bugs, assign bugs to development resources.
  • Log, manage, and retest defects in bug tracking system.
  • Functional and Regression, User Acceptance testing of US localization enhancement project. Local taxes calculations, State , Municipal, County, 401K, Benefit/Deductions, Payment process to generate deductions for local taxes, Processing a pay period, Manual payment, Stop payment, Terminate a worker, Rehire a worker. Assign a position. Time Earnings adjustment, Cancel payments etc
  • Accurately record and clearly document all actual results compared to expected results.
  • Communicate with developers on critical issues.
  • Update Time tracking to keep track of time spend on projects

Environment: MS Dynamics AX 2009/2012, Team Foundation Server, SharePoint 2010, Visual Studio 10, MS Test Professional 10, MS SQL Server 2008, XML, MS Office 2010, MS Visio 2010, IE, Chrome, Firefox.

Confidential

Role: Application Support Specialist

Responsibilities:

  • Respond to incidents of various severity levels, generated via customers and/or automated alerts, within established time frames according to documented Standard Operating Procedures and Service Level Agreements.
  • Provide front line support with monitoring the application support e-mail box and address each issue as per the set protocol. Ensure all emails and calls are answered in a timely manner and follow up each issue to closure.
  • Perform data analysis tasks with PL SQL in order to trouble shoot errors and user questions. Work with the development team to analyze the data when necessary and promptly follow up with the user.
  • Deliver a high level of customer service to all users and continuous communication.
  • Work with business users and members of the IT organization to troubleshoot and resolve problems to resolution.
  • Software installations, troubleshooting and escalating client issues in a timely fashion Adding and maintaining documentation for client FAQ and Wiki areas. Support services provided over email, telephone and web conferencing.
  • Provide support for day-to-day production issues.
  • Monitoring and maintaining internal and managed client environments.
  • Providing data dumps to the client. Validating Master database is in sync with the production database.
  • Supporting client application requests e.g. custom reports regarding accounts, licensing and data stores
  • Providing support to end users on a variety of issues, primarily software related, including password resets, adding users, conducting modifications and changes.
  • Identify, research, and resolve technical problems.
  • Respond to telephone calls, email and personnel requests for technical support.
  • Document, track and monitor the problem to ensure a timely resolution.
  • Participation of testing / UAT, release sign-off, and deployment.
  • Incident resolution, problem identification and root cause analysis
  • Ensure that applications are maintained in a manner that supports quality delivery of services to end users
  • Updating time tracking to keep track of time spend on client issues.

Environment: Tomcat, Webspere SOAP UI, Java, Oracle 11, MS Sql Server 2008, XML, Linux, FileZilla, Jira, MS office, IE, Chrome, Firefox.

Confidential

Role: QA Lead

Responsibilities:

  • Develop and oversee development of objectives, test plans, test cases, test reports, log, manage, and retest defects in bug tracking system for Billing Application.
  • Validated different forms in Billing module Invoices , Entering bill data invoice form, Billing batch processes, Invoice adjustment form, billing configuration.
  • Validation of data load from customers in the billing module.
  • Report testing status, milestones and issues to management and other stakeholders related to assigned projects.
  • Schedule and drive bug review meetings, validate submitted bugs, take ownership, assign bugs to development resources, set up QA priority, notify relevant business units, research and log root cause analysis for the reported bugs and follow through with a resolution and final testing.
  • Coordinate support work with developers to provide additional research and debugging of issues when more information is needed to resolve problems reported from the field.
  • Analyze and design QA system environment and requirements.
  • Provide direction and leadership to dedicated onshore and off-shore team members.
  • Coordinate with Project and Development Leads to develop project schedules and resource allocation for QA related projects.
  • Performed and supported levels of Testing i.e., Development Integration Testing DIT , System Integration Testing SIT , Automation Testing, Performance Testing and User Acceptance Testing UAT to verify that applications perform according to business requirements, architecture and design
  • Understand feature specifications and create test suites for all product components focusing on business support systems.
  • Implement ongoing QA improvement processes with interdepartmental teams.

Environment: PHP, Selenium, Java, JUnit, MS SQL 2008, SQL Query Analyser, Visual Studio 2008, .NET Framework SDK V 2.0, XML, DHTML, Javascript, CSS, Windows 7, Unix AIX, MS Project 2010, IE 7.0, Mozilla, Chrome, Word/Excel 2010.

Confidential

Confidential is a premier provider of financial, practice and knowledge management systems to the legal industry and other professional services markets, including accounting, engineering, marketing services, management and IT consulting.

QA Engineer

Elite 3E Framework WebUI Application.

Responsibilities :

  • Perform manual testing of Web Financial application and related backend applications and systems
  • Develops test scenarios and test cases that map to business requirements, Non Functional Requirements and design
  • Create, execute, track and report on functional and integration test cases generation and execution of assigned modules
  • Finding, tracing, and thoroughly identifying defects generating defect reports working with engineers to resolve defects and verifying corrective actions
  • Execute regression tests maintain scripts for the new enhancements and software updates.
  • Verifying validating of email message attachments and language conversion for selected forms.
  • Performed Positive, and Negative Testing to test for possible breaks in software code.
  • Get involved with earliest planning to understand how new features are intended to work
  • Conducted the Regression tests for already reported Bugs to test whether fix has been applied or not and also to test whether the fix causes another problem or not.
  • Created reports that included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.
  • Design, manage, and document Functional, Regression, UAT Testing and stress tests to ensure our service works smoothly for all members.
  • Develop and execute test plans.
  • Query SQL databases for data validation
  • Consult with development engineers and product development team to resolve problems.
  • Executes complex test cases/scripts and interprets/analyzes results to report, communicate, and work through issues with software engineer
  • Accurately record and clearly document all actual results compared to expected results.
  • Communicate with developers, product managers, and technical support specialists on critical issues.
  • Ensure complete documentation is available for all enhancements, bug fixes, and new products
  • Support release process and perform production site verification testing
  • Ensures that all Change Requests, Test Problem Reports are tested and approved before software release.
  • Provide estimates for testing activities
  • Provide accurate status reports of current work progress
  • Deliver daily reports that identify testing status.
  • Weekly status reporting to Manager.

Projects Tested:

A 3E Framework WebUI Application Modules :

Billing, Calendar, Records, AP, Metrics, Conflicts, Collections, GL, Profitability, Fixed Asset.

B Dashboards : Functionality testing of following dashboards

Account Payable Dashboard, Administration Db, Bank Db, Billing Db, Billing GL Reconciliation Metric , Billing Utilities, billing Report, collection, Conflict, Eite services Integration, Entity, General Ledger, TaxesDb,Expenses Db, Inter Company Billing db, Purchasing Db.

Environment : Quality Center tools 9.0, Microsoft SQL Server 2005, SQL Query, Analyzer, Windows Server 2003 R2, Visual Studio 2005, .NET Framework SDK V 2.0, BizTalk Server Message Broker, XML, DHTML, Javascript, Star Team 2005 Realease 2.0, Silk, Windows XP, Converter 2.3, IDE 2.4.113.0, MS Project 2003, Acrobat 7.0, IE 7.0, Word/Excel 2003 SP3,

Confidential

Sr. Business Analyst

Responsibilities:

  • Manually tested Web and Client Server Financial and Mortgage Loan application interface and backend databases in a UNIX/Windows environment.
  • Developed, executed and maintained test plans and test cases, Test Scripts for various languages/environments. UNIX, Sybase, Oracle, JAVA, VB, Mainframe .
  • Performed Functional, End to End Regression tests for Unix shell scripts, Sybase database objects, VB and mainframe applications.
  • Run test plans for release of new application version.
  • Verifying back-end data One-to-one mapping of the data in the Database Modification Request form to the data in the Read Only files provided by developers in Oracle/Sybase/Mainframe environment.
  • Validating Test Results, Highlighting the field and the changed value.
  • Work in conjunction with the Development Team to ensure that all product functionality has associated tests and that the tests are executed on appropriate configurations at appropriate times.
  • Developed use cases, test scripts, test cases, test procedures and test data with Clearly defined testing inputs and expected test results.
  • Executing new and existing test cases and logging results.
  • Data handling across different data sources Sybase, Oracle, MS Access, MS Excel, etc
  • Validate functionality and business rules in calculation, financial planning and reporting engines, based on requirements and use cases
  • SOX compliance projects - Maintained a single repository automated tool for all control documentation and testing results.
  • Run tests, collect and analyze data, and document results.
  • Identify and document bugs.
  • Retesting fixed bugs to verify that they are fixed.
  • Submit test results to the Business Unit Submitter for review and approval.
  • Managed multiple deliverables against aggressive deadlines.
  • Signoff's as a confirmation that testing process has successfully completed.
  • Deliver daily reports that identify testing status.
  • Weekly status reporting to Manager.

We'd love your feedback!