Home

Ratna - ETL Tester Or QA Manual tester or Guidewire QA Lead

[email protected]

Location: Columbus, Ohio, USA

Relocation: Remote or HYbrid Local

Visa: H1B

Professional Summary: Having 16+Years of Extensive Experience in BIG DATA/HADOOP Testing, Guidewire Data Migration and Guidewire Funcational Testing. Expertise in Guidewire Policy Center, Billing Center, Claim Center, Contacts Manager Applications Functional testing. Having experience on Hadoop Components including Hadoop, Spark Scala, Sprark SQL , HDFS, HIVE, HBASE, HUE, SQOOP, AWS S3 Buckets. Expert in understanding of the policy administration life-cycle from Quote to Bind, other transactions like Policy Change, different types of Cancellations, Renewals, etc. Experience with Guidewire Policy Center functions and processes/workflows, Claims Center and also on exposure to Billing Center. Expertise in ETL Testing, BI Testing, DB Testing ,HADOOP ,Big Data and Reports Testing. Experience in BI tools testing like AWS Athena, AWS S3 Buckets, Redshift, HIVE, OZIEE, HUE ,Qlick Sense, OBIEE, BO, BODS, SSRS, SSIS, Cognos, Tableau, QlikVeiw, Abintio, Datastage and Informatica, Informatica DVO, IDQ& IDD. Validation of different file formats in Enterprise Data Lake like PARQUET, ORC, AVRO, CSV, JSON ,XML file formats. Experience in YAML, HUE SQL, Athena Validation SQL, SQOOP functions and HIVE SQL for BIG DATA applications. Experience in Apache Oozie Job Scheduler & AutoSys Job Scheduler. Having experience in Informatica TDM, Oracle MDM, Informatica IDD, Informatica MDM, IBM InfoSphere and IBM Curam Software. Expertise in Software Testing Life Cycle (STLC)& Bug Life cycle and SDLC. Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents. Profound experience in Personal Lines, Commercial Lines, Farm & Ranch, General Liability, Property, etc. Having Experience in Insurance, Heath Care, Financial, Banking domains. Experience in Design, Execution and reviewing of Test cases/Test Scripts/SQL Scripts. Experience in different types of testing Retesting, Regression, Risk Based, BAT,GUI, System, SIT, UAT, E2E, Sanity, Ad-hoc, Security, Boundary, Browser Compatibility, Smoke Testing. Having Good knowledge on SOAP UI testing, Selenium Web driver, PYCHARM IDC, Selenium RC, BDD Cucumber, PY Validator Automation tools. Participate in the Scrum process and Daily Scrum, Sprint Planning, Sprint Reviews, Retrospectives, Backlog and Show & Tell. GroomingExpertise in working on Defect Tracking Tools (HP ALM, HP QC, JIRA and Bugzilla, Clear Quest). Experience in managing Onshore and Offshore QA teams. Educational Qualifications: MCA (Master of Computer Applications) from Andhra University. Certifications: Oracle Certified Associate (Oracle Database 11g: SQL Fundamentals). AIS (Accelerated Integration Specialist) from HP. ISTQB from International Software testing Qualification Board. Technical Skills: BI Tools AWS Athena, AWS S3 Buckets, BO XIR2,BODS,SSRS,SSIS,Informatica,AutoSys, QlikVeiw, OBIEE, Oracle MDM,HADOOP Guidewire Guidewire (Policy Center v8,v9, v10, Claims Center v8,v10, Billing Center) and Contacts Manager. Automation Tools / Framework PYCHARM 2022.3, QTP 9.2,BDD Cucumber, Selenium Web Driver Tools/ Languages JAVA, XML, JSON, SVN, TFS, Python Project Management MS-Office Suite (Word, Excel, Outlook) Test/Defect Reporting Tools JIRA, HP ALM, TD, Project Place, IBM Rational DOORS Databases SQL, Athena, Redshift, AMP Aginity, MYSQL, Dynamo DB Web services Fiddler, Splunk, SoapUI, Build Tools Maven, Jenkins, CI/CD Version control tools GIT, TFS, GitHub Cloud Amazon Web Services (AWS) S3 Methodologies Agile, Waterfall Professional Experience: Client: State Auto Insurnace, Columbus, OH, USA June 2018 to Till date Role: Enterprise Data Lake QA Lead Project Name: Enterprise State Auto Insurnace Data Lake and EDW Decommission Description: State Auto Insurance is upgrading existing EDW to Enterprise Data Lake environment (HADOOP/AWS EMR). Data residing on SQL server, Informatica to Hadoop Distributed File System. The Ingested data from multiple source systems will transformed and curated and consumed by the downstream systems.Converting and Migrating all multiple source systems GWPC, GWBC, GWCC, Legacy, SABIR, RTW, Telematics, V6, V7, HOInsepct, RAVechile, etc. From existing target EDW to new Target Hadoop Enterprise Data Lake. State Auto Insurance is Columbus based Insurance Company global leader in many LOB s like Personal Auto, Commercial Auto, BOP, CUP and Farm & Ranch, CPP and Workers Compensation. Responsibilities: Working with Data Designers, Data Modlers and Business Analysts to get the final copy of functional requirement document and start getting on to requirement analysis. Understanding Business requirements , mapping document and Transformation logics. Resposible for all State Auto Insurnace Enterprise Data Lake QA Deliverbles. Respoisible for Ingestion Validation & Curation Validation. Responsible for developing HUE/HIVE HQL, SQL, YAML, My SQL Validation scripts to validate Source, Target data. Validation of different file formats in Enterprise Data Lake like XML, AVRO and JSON file formats. Validated SQOOP ingested data from different external sources to HDFS system. Hands on Experience in working with different file formats. Validating different Source mainframes, GWPC, GWBC, GWCC, GWPL,GWCL,Legacy records counts in Target HIVE tables. Validating Data Completeness and Corrects of Loaded data in HIVE tables. Chair the DRB meetings and track all open defects to closure. Analysis of the mismatched records, raising defects in JIRA, retesting resolved defects. Environment: HIVE, SCALA, SPARK, HIVE, AWS Athena, AWS S3 ,Buckets, Informatica 9.1,Mainframes, PL/SQL, UNIX, XML Files,MobaXterm, GWBC,GWCC,GWPC and Legacy Test Management tool: JIRA Client: Fifth Third Bank - Cincinnati, OH, USA April 2017 to June 2018 Role: EDO/EDW QA Lead Project Name: ECIF ODS, YETR Tax file, Data Spine Vantiv/LE HADOOP Data Lake, Atacamma Data Injection, Argus Reports. Description: Fifth Third Bank is one of the premium banks in USA. The online system provides services to its customer for accessing their accounts and doing banking operations online. EDO one of The biggest Data warehouse Implementation developedfor bank to serve better to Fifth Third Customers. Responsibilities: Working with BusinessAnalysts to get the final copy of functional requirement document and start getting on to requirement analysis. Understanding Business requirements and Transformation logic. Understanding the mapping document and Design Document & BRD document. Validating 53 Bank EDO applications as per new CR s. Validating Source mainframes records count in Target HIVE tables. Validated FLUME ingested data from different external sources to HDFS system. Reconlidating the REXX Mainframes data into Data Lake HIVE tables by using BRAVO tool. Prepare and review the test plan and test scenarios with Tech Leads and Business Analysts. Validatig the Atacamma & IBM IA DQ rules in Collibra DQ DashBoard. Chair the DRB meetings and track all open defects to closure. Support UAT team with the UAT test plan, Test Scenarios Reviews, Test Data Preparation and track results/defects. ETL Jobs status monitoring on production server. Validating Data Completeness and Corrects of Loaded data in Target System. Managed the execution in Test Management Tool HP ALM. Environment: Informatica9.1, Tableau, Oracle11g, SQL, Mainframes, PL/SQL, UNIX, AQT, XML Files, Putty, Flat Files, HIVE, REXX, SQOOP, Informatica DVO, Informatica MDM, DVO Test Management tool: HP ALM Client: TDIC (The Dentist Insurance Company) - Sacramento, USA May 2015 to March 2017 Role: Data Migration Test Lead Project Name: TDIC Data Migration to Guidewire. Description: The TDIC Data Migration Program focuses on the replacement of the legacy policy administration systems (CHSI) with more modern off-the-shelf policy administration capabilities (Guidewire Insurance Suite) with minimal business disruption. The entire program is divided into two releases. For Release A, Workers Compensation. As part of Release A, Migrate only Workers Compensation (WC) policies and related data from the source systems to the target systems Mid-term with historical data . Responsibilities: Understanding Busiess requirments and Trasformation logics. Understadning the mapping document and Desingn Document. Prepared Test Strategy and Test Paln for this Data Migration. Validating Data Completeness and Corrects of Loaded data in Target System. Involved in the Congos Reports Data validation with Source tables/Views. As per end user requests prepared and sent Cognos Adhoc reports. Involved in end users taining on Cognos reports preparation. Validated the Cognos report format and layout with Business requiments. Validated Congos Report Filters and Prompts as per BRD document. preparation & Execution of SQL Validation scriptcs to validate the Target Data. Developed and executed Re-usable SQL Scripts for Finanacial Balancing Reconsolidation. Invloved in Integration testing of Policy,Billing and Claim Centers. Managed the execution in Test Management Tool HP ALM. Environment: Guidewire Policy Center, Billing Center, Claim Center, Contacts Manager, SSIS, XML,SOAP UI, SQL Server, UNIX, SQL Server Agent,TFS and IBM AIX and Cognos. Test Management tool: HP ALM Project Name: Common Claims Platform Client: CNA Insurnce - Chicago, USA Dec 2013 to April 2015. Role: Guidewire QA Lead Description: CNA is a leading global insurance organization serving businesses and individuals with a broad range of insurance products and insurance-related services. CNA is the 2nd largest commercial lines insurer and has 1 million business and professional policy holders. The Specialty and Marine to Common Claim Platform initiative is one of the 17 initiatives identified for the CNA Claim Strategy program and will address the Specialty and Marine lines in Guidewire ClaimCenter 5.0 Common Claim Platform. Responsibilities: l Analyzing requirements from the business And create High Level Scenarios that are mapped to requirements and writing test cases and mapping them to requirement using Quality center. l Identifying the scope of testing for every service pack release. l Prepared, Reviewed and Tracked Test Plan, Test Strategy and Project Plan documents. l Lead the team size of 12. l Logging defects in Team Track and retesting defects. l Daily work allocation to the team and status reporting to Onsite Coordinator. l Interact with BA Analysts and Developers to ensure that all aspects of the system have proper testing coverage and overall system reliability, performance and quality. l Performed Adhoc, Functional, Integration, Database, System, Regression Testing. l Maintain and report status of project on a weekly basis. Participated in Project Kick-off meeting and weekly Status calls with client. Compute Test execution efforts in terms of requirements gathering, Design reviews, test case authoring, Test execution estimation and status reporting and test execution Metrics computing for every Release and tracking of same for any deviations. Authored Functional & Integration test cases with test case techniques for complex modules and prioritized the Test Cases as High, Medium and Low. Executed Test Cases and Prepared Test Cases Execution Report. Environment: Policy Ceter, Billing Center and Claim Center Test Management tool: HP AML Client: State Farm Insurnace - Bloomington, Illinois, USA August 2012 to Nov 2013 Role: Guidewire QA Lead Project Name: State Farm Policy center Description: State Farm Insurance is one of the largest church insurance providers in the US. It empowers property and casualty insurers to meet the needs of a rapidly changing industry with more effective underwriting, agile policy and product management. Responsibilities: Conducting daily standup meetings and discussing daily status, issues/risks/delivery challenges encountered during test execution and track test progress and defect triage calls to track defect closure. Maintaining a checklist for all tasks and miscellaneous activities. As a team member, involved in working on Guidewire Policy Center and Portal application. Involved in creating Policies from PC or Portal with Direct/Agency Bill, also worked on other transactions and Renewals for Personal Lines and Commercial Lines. Translating requirements into optimized designs, and identifying design alternatives and implications on functionality, effort, performance and operations along with focusing on requirement changes. Development of test plans, test scenarios, test cases based on FSD/FRD, authoring and execution of test cases, and documentation of test results. Also maintaining test coverage. Keeping track of any requirement changes, updating team s/test cases and working on them accordingly. Environment: Policy Ceter Test Management tool: JIRA Client: Zurich Insurnace - Z rich, Switzerland Nov 2011 to August 2012 Role: Sr.Software Quality Control Engineer Project Name: Policy Center Upgrade Description: Zurich is a leading global insurance organization serving businesses and individuals with a broad range of insurance products and insurance-related services. Zurich is the one of the largest personal lines insurer and has 1 million business and professional policy holders. Responsibilities: Involved in Testing for Personal Lines (Auto, Homeowners and Umbrella) and Commercial Lines (Auto and Homeowners) in Guidewire PC. Involved in Testing for ETE Regression with good knowledge in different applications like Guidewire Policy Center. Experience working on LexisNexis,Versik, MVR integrations. Defining scope of testing by doing functional analysis of the requirements and requirement changes. Underline the requirements to begin Test execution and sharing them with respective stakeholders, such as test environments, Test data, Quality center domains etc. Took a leading role in manual testing the Guidewire application, actively involved in creation of detailed test plans, test scenarios and test cases for different application modules according to functional requirements and business specifications. Environment: Policy Center Test Management tool: HP Quality Centre 9.2 Client: UTC Power Ltd. - USA May 2010 to Nov 2011. Role: Sr.Software Quality Control Engineer Project Name: UTC Power Dashboard Description: UTC Power application is intended to serve the management population of UTC Power. It is intended to be a repository for customer requested and approved reports in dashboards/metrics format. This tool captures customer specified metrics and displays in a dashboard format with drilldown capability. Various Menus like Aftermarket, Finance and Supply Chain Management menus will be developed in the application. All these menus having sub menus with drilldown functionality. These reports can be exported to excel and PDF. Responsibilities: Understanding the requirements & Functionality of the application. Involved in the preparation & Execution of Test cases. Involved in the Data validation of SSRS Dashboard with Source. Logging and tracking defects through JIRA Preparation of Defect Summary Report Reporting to the onsite Coordinator about the Status on daily con-call Environment: SSRS Dashboard, SQL Server 2005 Test Management tool: JIRA, TFS Client: OTIS WHQ Ltd. USA March 2009 to May 2010. Role: Sr.Software Quality Control Engineer Project Name: NSAA Marketing Reports Description: NSAA Marketing department needs eleven new BI reports. The NSAA users are currently taking several extracts, loading the data to MS Excel and/or Access and then preparing Excel files that are e-mailed to field managers. The new BI reports should eliminate the manual process and provide a self-service option where field users can run prompted reports to get the data they need. Responsibilities: Understanding the requirements & Functionality of the BO Reports. Involved in the preparation & Execution of Test cases. the Functionality of the Business Objects Reports. Involved in the Business Objects Reports Data validation with Source tables. Validated the Business Objects report format and layout with Business requirements. Validated Business Objects Report Filters and Default Filters as per BRD document. Logging and tracking defects through JIRA Environment: BO, BODS, SQL Server 2005 Test Management tool: JIRA Client: OTIS WHQ Ltd. USA Dec 2008 to March 2009 Role: Sr.Software Quality Control Engineer. Project Name: OtisPlan+ Description: Otis Plan+ is a web browser based application for sales personal. The purpose is assisting the sales personal in dealing with client to allow the client to have a simulated view of the elevator being proposed for the building. By using this application sales person can demonstrate to PPT report the Building owners which describes about No of elevators required for that particular building and also cost of the elevators. OtisPlan+ used throughout the world and having more than 25000 End Users. Responsibilities: Understanding the requirements & Functionality of the Reports. Supporting End Users of OtisPlan+ across the world. Involved in the preparation & Execution of Test cases. Involved in the Presentation Reports Data validation with Source tables. Logging and tracking defects through HP QC 9.2 Environment: .Net, C++ and SQL Server 2005 Test Management tool: HP Quality Centre 9.2 Keywords: cplusplus continuous integration continuous deployment quality analyst business analyst user interface business intelligence sthree database active directory information technology hewlett packard logistics execution microsoft procedural language Iowa Ohio