Sr. Reporting Analyst (Business Intelligence)/QA

SHERRIN ELIZABETH RAJU

*.******@****.***

469-***-**** - Dallas TX

Seeking a challenging position to utilize my 6+ years of IT experience in the field of Reporting and Analytics, Quality Assurance Testing, Business Analysis, and Software Development, for the benefit of the company and the growth of my career.

EXPERTISE:

QA - Testing - Hyperion BI - IBM Cognos - Test Director 5 - Quality Centre 9.2 - QTP 8.2 / 9.X - Win Runner 7.0 - LoadRunner 6 - Bugzilla 2 - Clearcase - ClearQuest - Rational Tester - RequisitePro - JavaScript - Java - C++ - C - Cobol - .NET - VB 6 - Struts - JEdit - JUnit - JCreator - Version Control - CVS - VSS - Weblogic5 - RDBMS - TOAD - Oracle - Access - SQL - UML - ERD - HTML - XML - JSP - Java Script - JUnit - SQL Server - Data Modelling - Crystal Reports - Ad Hoc Reports - Word - Excel - PowerPoint - Visio - Windows - Linux 9 - Unix - Outlook - Gap Analysis - SDLC - Waterfall Model - WBS - Vi Editor - MS Project - General Ledger - Technical Documentation - Acrobat - SharePoint - QuickBooks - Tableau - Salesforce

Problem Solving, Risk Management, Excellent Aptitude, Versatile, Self-Sufficient, Motivated, Positive Work Ethic, Proactive, Self-Organizing Skills, Good Attitude, Professionalism, Approachable, Team Development, Delivered On-time Under-budget, Adaptable, Well-Planned, Follow Procedures, Schedule Meetings, Proposal Presentations, Goal Oriented, Gather Information, Project Management Principles, Strategic Thinking, International Experience

EXPERIENCE:

UnitedHealth Group, Texas May 2010 - Present

Sr. Reporting Analyst (Business Intelligence)

Proficient in JavaScript coding of the user-friendly interfaces in the Business Intelligence Hyperion application. Developed reports using IBM Cognos as part of the migration of a particular customer.

Extensive hands-on experience using SQL to extract data for reporting and analysis, write queries against Enterprise Data Warehouse tables and Java Script to revise programs as needed. Experience working with Reports/Dashboards design within Tableau.

Manipulation and creation of Excel spreadsheets; including but not limited to standardizing reports across multiple sheets, utilizing vLookups and functions/formulas (compare, concatenate, merge, etc), creating, using and interpreting pivot tables, filtering and formatting to generate desired results.

Analysed software requirements and design documents, and created top level Test Plan/Approach documentation and detailed test procedures to include expected system state and expected system output as test criteria. Generate test data inputs to be used in support of test procedures. Developed cross reference matrix and maintained traceability of test procedure steps to the specified requirement.

Involved in various levels of testing: Unit, and system testing, UAT, Functional testing, Performance testing, Usability testing, Regression testing. Demonstrated expertise in testing of web applications, which include code reviews, functionality-to-requirements verification, and GUI usability testing.

Designs, builds and delivers Ad Hoc reports based on the analysis results in addition to publishing customer facing statistical reports which disseminates historical and current data to provide management with analytical trends and analysis.

Involved in troubleshooting, continual maintenance support to close assigned problem reports and legacy applications maintenance.

Conducted requirements and design document reviews and peer reviews for test plan documents and formal test procedures.

Acted as SME by providing QA/testing knowledge transition and key validation of the products to ensure that the client requirements are met. Worked within self-directed and diverse workforce.

Delivered analysis and improvements in on-going performance through testing. Involved in Test suite development to implement the product. Demonstrates understanding of data modelling (relationships, data types, tables, etc.) and analytics concepts (queries, reporting)

Expertise of technical and cross-functional content of core domains - Appeals, Denials and Grievances, Authorizations, Claims. Worked on SLA (regulatory) and CMS/Medicare Part C/Part D reporting requests.

Authored number of business process documents and test plans. Experience in interpreting and analysing data.

Worked with internal customers to define report requirements, and build the report solution thereby automating majority of them.

Extensively involved in quality testing and QA signoff of the customer-facing reports to production. Convert reports based on legacy standalone database to most recent data warehouse tables for accurate reporting.

Improved effectiveness of team members by repeatedly assisting them and drastically reduced work of team member, delays and rework.

Comfortable working within a cross-functional in a collaborative environment with developers to develop innovative automated testing solutions. Able to change direction quickly, and have an eagerness to learn new technologies as the need arises. Took on multiple tasks and delivered it without lots of management.

Strong knowledge of the all following software tools: Microsoft Suite applications and SharePoint functionalities.

Proficient in MS Visio for draw workflow diagrams to make it easy for IT business professionals to visualize, explore, and communicate complex information. Excellent business document writing skills (BRD, prototypes, checklists, production logs, etc.). Established outstanding customer service and people skills.

Provided trainings as part of the knowledge transition to new on-boarding members and peers. Created mock-ups of the new user interface and working closely with the development team to develop user scenarios/test cases as needed.

Accenture, UK Apr 2007 - Sep 2007

Lead Developer/Test Engineer

Developed Java-coded (Struts) modules for claims processing software. Written complex queries and Stored Procedures using Oracle and SQL. Maintained Verification and Validation Plans, written Test Cases and executed Test scripts.

Proficient in using different testing tools - Test Director, QTP, WinRunner, Load Runner and Bugzilla.

Assisted with VBScript software changes based on feedbacks for update or correction.

Prepared Test Data based on user requirements for Test Execution, with the main objective as to capture the maximum number of bugs.

Performed Automation to verify that in each release the supported environment passes authentication without failure.

Development, Testing, Deployment and Technical Documentation for Regression, Integration, System and User Acceptance Testing.

Scheduled execution of script sequences and stored all Testing products (scripts, results) in organized directories.

Prepared Test Estimates, Test Summary Reports, Testing Status Statistics and Comparison Charts using established formats and performed reviews. Build and integrated Swing User Interfaces, performed Blackbox and Whitebox Testing.

Repeatedly assisted team members, which resulted in completing Regression Testing one month before deadline.

Demonstrated expertise in Ad-Hoc and Metric reporting and analysis. Created class diagrams using Microsoft Visio.

Redesigned existing modules to make the codes scalable and easily manageable. Involved in reconfiguration, support and maintenance of the production/test environment, and ensured rigorous and comprehensive product testing for overall product quality.

Strong knowledge of QA best practices and software development life-cycle methodologies to create processes to drive quality in a product.

Hands-on Experience of automated test tools and frameworks, and building maintainable and efficient tests using Java-based tools like Junit.

Defines documents and executes test cases to reveal potential defects, and analyses code to identify and resolve issues found during testing

Coordinated small to medium sized integration and conversion projects, and completed assigned tasks independently, on time and with quality. Provided technical guidance/training to end users, completed data loads/fixes and assisted with customer relations.

Participated in brainstorming sessions with experts in understanding Business Processes, new initiatives, trouble shooting and change requests. Familiarity with version control systems, SharePoint and MS Project.

Accenture, India Aug 2006 - Mar 2007

Developer/Test Analyst

Developed software solutions to serve offshore customers per contractual requirements. Used Test Director for bug reporting, followed up with development team to verify bug fixes.

Performed Manual and Automated Testing off-shore. Ensured all the Defects are raised, recorded and resolved.

Analysed, Developed, Tested, Deployed Assembly Test scripts and kept them updated. Performed month- end data loads, operational stability and system preparation.

Involved in Performance and Stress Testing using LoadRunner. Captured all expected Test evidence accurately and efficiently to provide proof of Testing. Tested application manually prior to automation using WinRunner for Functional Testing.

Created, debugged and executed Test scripts for Regression Testing through WinRunner for Java Applications.

Updated Test and/or Execution Plans, Backup of Data and Environments. Delivered quality in UAT - Creation of Test Plans and Phase containment of defects as per quality standards.

Prioritised reusability of initiatives which demonstrated productive improvements through creation of component library, knowledge database and FAQs. Involved in Technical Design phase of XML processing, creation and modification of Test suites and Test Data.

Understood database structure and managed changes in database in addition to understanding of SQL - ability to create simple and complex SQL statements. Demonstrated ability to take initiative, overcome obstacles and encouraged team to achieve results.

Designs and develops tests and test requirements for new products, systems, software and/or related components.

Provided guidance on testing methodologies, and help keep the entire team accountable for the quality of work released.

Push new efficiencies with the team, from promoting test coverage to creating new tools and evangelizing automation best practices.

Supported the Oracle Projects application, and provided day to day second level support and administrative functions around Project Foundation and Management. Demonstrated ability to interface effectively and collaborated with clients, peers and management to develop solutions.

EDUCATION:

Masters - Computer Applications (3- year Degree)

Bachelor of Science - Computer, Mathematics, Statistics (3- year Degree)

CERTIFICATION:

ISTQB Certified Tester Advanced Level (CTAL) - Test Manager, Test Analyst

Contact this candidate