Sr. Business Data Analyst and Lead Quality Analyst (Manual & Automation) Resume Riverside-CA - Hire IT People (2024)

SUMMARY

• Experienced as Business Data Analyst,Post Production Support Analyst and Quality Analyst with 9+ years of experience in the field of Information technology.
• Extensive experience on manual and automation testing tools such as HP ALM /Quality Center, Rational Team Concert, Rational Quality Manager, QTP/UFT, Selenium, Spring too, Eclipse, CI, Cucumber, Soap UI.
• Having in - depth knowledge of the Software Development Life Cycle (SDLC) methodologies that include Waterfall, and Agile (Scrum)
• Experienced in analyzing and creating SQL and PL/SQL scripts to generate customized monthly, quarterly, annually user reports.
• Strong understanding in Data Modeling, Logical and Physical Database design & development, Normalization
• Knowledge of Database concepts including Data Warehousing, Dimensional modeling, Relational Database Management System (RDBMS), DataMarts, OLAP operations such as Drill-Down, Roll-Up, Slicing, Dicing and Pivoting
• Leading experience in cleansing data, data validation checks during landing and staging area on migration to DW.
• Expertise on Reporting Life Cycle from requirements gathering to presenting to end users on Tableau and SSRS
• Diverse work experience on Unit Testing, Functionality, Integration, GUI, System, Regression, Smoke, Brower compatibility and UAT Testing.
• Developed Use Case diagrams by analyzing the businessprocess followed by Class diagrams, Activity diagrams, Sequence diagrams, Data flow diagrams and flow charts using MS Visio
• Experience in working with Business Intelligence (BI)
• Excellent experience working with MS office suite including MS Project and MS Word for technical writing and requirement management.
• Passion for identifying & determining solutions to businessproblems for complex businessand software projects
• Strong background with Jira and Confluence, demonstrated ability to apply critical thinking skills and a logic based approach to problem solving
• Extremely motivated, diligent, conceptually strong team player with ability to take new roles and adapt quickly to new technology.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks
• Possess knowledge sharing attitude with strong passion for mentoring and educating team members about new technologies.

TECHNICAL SKILLS

Packaged Applications: Oracle Siebel CRM, ASP.NET

Domains: Public Sector, Banking, Financial & Home Mortgage

Tools: QTP, UFT, Selenium (Java).

Build Tools: Maven, Jenkins

Test Management Tools: Quality Center (ALM), JIRA.

IDEs: Eclipse

Methodologies: V Model, Waterfall Model, Agile Model

Databases: DB2, Oracle, SQL Server 2008

Version Control: TFS, Microsoft Visual Source Safe, GIT HUB and SVN Tortoise

Environment: Windows 7, UNIX, LINUX and Windows XP

Desktop Technologies: MS Office, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Riverside-CA

Technology - Asp.NET, Ajax, SQL Server 2002, Selenium, JIRA

Sr. Business Data Analyst and Lead Quality Analyst (Manual & Automation)

Responsibilities:

• Worked with businessowners and product managers to determine and document the requirements for technical solutions that meet the strategic needs of the business.
• Maintained the physical database by monitoring performance, integrity and optimize the queries for maximum efficiency by using SQL Profiler Index Tuning Wizard
• Monitored scheduled jobs and alerts created for SSIS packages and SSRS reports in Visual Studio
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the frontend application
• Performed analysis, detailed specifications, SQL database analysis and disaster recovery, technical and end-user documentation, host communications interface design and performed on-line and batch testing of production support.
• Used MS Access database, Excel for MBS reporting and in testing for datamanipulation
• Ensured different internal & external systems exchanged dataaccording to the specification to transform datafrom enterprisedatawarehouse to SQL Server & load datato fact tables
• Control and manage daily test activities through daily Agile Scrum 'stand-up' meetings.
• Responsible for facilitating sprint review at the end of each sprint. Collaborated and managed allbusinessdocuments and contents using MS SharePoint.
• Createddatamappings in DataWarehouse and designed a site map for approval from executive management.
• Closely interacted with subject matter experts in understanding thebusinessprocess methodology
• Contributed in Defect Tracking and Logging for quality assurance and future maintenance purposes
• Formulated the Requirements Traceability Matrix for tracking and reviewing requirements
• Performs other reasonable duties as required
• Responsible for introduction of BusinessIntelligence to analyze data and provide interactive dashboards.
• Use BI tool - Tableau to turn SQL into interactive dashboards to share report, analytics, pivot tables, scheduled reporting, charts, graphs and custom filters
• Experience in all phases of Software Development Life Cycle (SDLC) like requirements, design, development, testing, implementation and support.
• Performed automated testing on Windows based application.
• Participate in daily stand up meeting and provide test automation status.
• Review manual test cases and identify gaps.
• Worked on Automation Scripts Using Selenium WebDriver.
• Developed automation test suites for Regression testing
• Hands on experience using AWS Amazon web services.
• Created automation tests classes for end to end scenarios.
• Feasibility analysis of test automation for the existing test cases.
• Used Extent reports to generate the HTML reports, for maintaining logs and to include the screen shots of failed test cases.
• Analyze existing test scripts and provide estimations for refactoring.
• Reviewed manual test cases and provided automation estimations.
• Append Data into production Data bases according to users need.
• Identify, evaluate and implement external services and tools to support datavalidation and cleansing
• Gather, understand and document detailed businessrequirements using appropriate tools and techniques
• Liaise with internal and external clients to fully understand datacontent
• Communicate with internal colleagues to understand the needs of departments and the organization as a whole.
• Work with external stakeholders to understand and investigate feedback into the service/function/product provided.
• Worked closely with management and end-users to create and evaluate businessrequirements to support delivery of effective business intelligence solution.
• Used Visio and UML Diagrams to visualize the system process and to present, elaborate and explain the details of the requirements to all stakeholders.
• Prepared reports using SSRS to highlight discrepancies between customer expectations and customer service efforts which involved in scheduling the subscription reports via the subscription report wizard
• Generate complex stored procedures, triggers, functions, indexes, tables, views, joins and various T-SQL codes for application
• Responsible of designing and managing schema objects, such as tables, views, indexes, triggers, procedures and maintained referential integrity between tables by using SQL Server

Confidential - Westlake Village, CA

Technology - Siebel 8.1.1.11, Workflows, OpenUI, OBIEE, BIP, Windows 7, .Net, VB, SQL, Quick Test Professional 11.0, Quality Center 10.0, SQL Server 2008 R2Move.com/Realtor.com, implemented CRM Bethany project.

Sr. Siebel Quality Analyst (Manual & Automation)

Responsibilities:

• Involved in the Requirement sessions for Pricing and Products implementation.
• Developed QA Test Plan which included objectives, testing strategies, test environment for covering functional, integration and end-end testing.
• Hands on experience in Oracle RDBMS, SQL Server and backend testing using SQL queries and Toad.
• Used Quality Center for Defect Management and used Visual Source for Configuration Management..
• Resolve the test environment setup issues and propose solutions.
• Develop SQL queries to Generate custom test reports from quality center database.
• Suggest process improvements on automation test approach.
• Develop new and existing regression suite using UFT.
• Develop and execute automation scripts for each sprint.
• In corporate SQL in functions to query test data from excel and to feed automation tests
• Execute regression suite across multiple test environments.
• Fix issues with existing framework and achieve unattended testing.
• Work with functional test teams to get automation script sign offs.
• Develop reusable functions for .Net application and common QTP libraries.
• Validated pricing using the PSP (Product Selection and Pricing) engine for the Agents/Office Products for eMedia.
• Validated integrations for Credit Card Authorizations, Tax Calculations, and Inventory Search and Lock Extension Business Rules
• Validated for PeopleSoft and Siebel Integration for Agreements, Invoice Generation and Charge Calculations.
• Validated Data Validation Rules at Auto Order, Approval generations and order Submit to compile with large amounts of data.
• Tested Email Templates for Order confirmations, Renewal Notification email and Proposal Templates for Invoice Generation.
• Designed and developed automated test scripts to ensure system integrity and functionality using QTP.
• Monitor and debug the Realtor.COM to Siebel Workflows at the time of Integration testing.
• Conducted three cycles of Regression Testing to make sure all high risk defects have been fixed and there are no new errors in the application with the defect.
• Review process of the design and test case documents with UAT users
• Closely interacted with the developers for Assisted Production Bug Fixes and Data migrations issues.
• Participate in product review, functional review and design review meetings and provide feedback.

Confidential, Hoover, AL

Technology - Siebel 8.1.1.12, OpenUI, SOA, BIP, SQL, Quick Test Professional 11.0, Quality Center 10.0The application is being used to process customer service request and send reminders for their payments.

Sr. Siebel Quality / Business Analyst (Manual & Automation)

Responsibilities:

• Developed Test plans and Test cases based on business requirements and functional specification documents of the applications.
• Created Test Cases in Quality Center, executed Test Cases and reported defects for all the modules in the project.
• Developed positive and negative scenarios for GUI testing/validation.
• Conducted manual testing to test the overall functionality of the application Involved in Integration, Regression, Functional and End to End testing on Store and Merchandising application interfacing with POS.
• Worked extensively in testing of new Vendor Setup, Store Replenishment, Purchase Orders, Cost & Price setup.
• Continuous interaction with developers, BA’s and business managers to discuss the gap projects and updated requirements.
• Performed end-to-end testing of the application and detected GUI bug.
• Involved in gathering business requirement, studying the application and collecting the information from developers and writing the test plans.
• Involved in User Acceptance testing.
• Prepared the Test cases based on the Functional specifications.
• Involved in Data Setup for System testing.
• Used QTP for Regression testing.
• Used Quality Center for writing Test cases and defect tracking..
• Querying data from different database tables as per the requirement and executing the source queries from workflows.
• Extensively used SQL queries to perform database testing to check the Data Integrity
• Closely interacted with the developers in fixing the bugs.
• Expertise in advanced Descriptive Programming in QTP using VB Script.
• Developed the Test automation scripts using the Dynamic Descriptive Programming.
• Used the Object Spy for identifying the properties of an Object.
• Used Recovery Scenario wizard and On Error Resume Next to recover from an unexpected error.
• Developed and Created the VB Script for test automation.
• Inserted the Checkpoints, Synchronization points; Parameterized dynamic values; and grouped test steps into user-defined functions.
• Ran automated scripts using QTP Extensively for End to End Testing.
• Developed User defined functions and called the same.

Confidential, Rochester,NY

Technology - Siebel 8.1.1.12, OpenUI, SOA, BIP

Sr. Siebel Quality Analyst (Manual & Automation)

Responsibilities:

• Performed System and Integration testing.
• Created complete user Documentation and Test Plans.
• Performed manual testing for all the projects.
• Used to run jobs for EDW team to get the data from RxClaim to EDW system.
• Wrote SQL statements to pull and update the data from the production and Test box.
• Good understanding on Project estimations and resource allocations.
• Programs are tested with direct interaction with developers, functional users and the business owners.
• Developed and managed test plans including the identification of detail test cases and the definition of data pools to ensure the developed functionality performs as specified in requirements.
• Lead offshore and onsite teams.
• Worked on GAP’s for migrating from Aetna and Rx America clients to CVS Caremark System
• Extracting claims on daily extract and creating CET’s for different clients.
• All the projects are involved in testing of adjudication of claims, setting up plans, calculations of accumulations and deductibles for individual and family.
• Tested loading the members into the system and verifying the data, also involved in testing various enhancements and production fixes of the application.
• I was responsible for uploading the artifacts into SharePoint.
• Conducted Backend test using SQL queries to verify the Integrity of the Database.
• Responsible for creating and uploading the project artifacts in Share point and providing release support.
• Reported bugs using bug-tracking tool HP Quality Center.
• Involved in both back-end and front-end testing.

Confidential

Technology - DB2, Sharepoint, HP Quality Center

UAT Analyst

Responsibilities:

• Performed System and Integration testing.
• Created complete user Documentation and Test Plans.
• Performed manual testing for all the projects.
• Responsible for uploading the artifacts into SharePoint.
• Conducted Backend test using SQL queries to verify the Integrity of the Database.
• Responsible for creating and uploading the project artifacts in Share point and providing release support.
• Reported bugs using bug-tracking tool HP Quality Center.
• Involved in both back-end and front-end testing.