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), Data Marts, 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 business process 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 business problems for complex business and 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 .

IT 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 business owners 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 data manipulation
• Ensured different internal & external systems exchanged data according to the specification to transform data from enterprise data warehouse to SQL Server & load data to 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 all business documents and contents using MS SharePoint.
• Created data mappings in Data Warehouse and designed a site map for approval from executive management.
• Closely interacted with subject matter experts in understanding the business process 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 Business Intelligence 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 data validation and cleansing
• Gather, understand and document detailed business requirements using appropriate tools and techniques
• Liaise with internal and external clients to fully understand data content
• 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 business requirements 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.As a lead Siebel QA assisted and lead the Quality Testing team, to ensure quality of the Bethany CRM Softwares Dot Releases, Deployments and Code fixes.

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. Speridian has implemented customized Confidential Portal application.

Sr. Siebel Quality 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.
• DBU files to verify the data or do changes to the files to test some scenarios also used most of the utilities like PDM, WRKQRY and other complex queries to retrieve the data to verify or do some changes to the data for testing purpose.
• 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

• 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.