Jag S.

Responsible for verifying migration of data. Maintain test scripts to align with change requests. Web Applications regression testing.

The Insurance Corporation of British Columbia is a provincial Crown corporation which provides universal auto insurance to B.C. motorists. Projects: - CDMP (Claims Data Migration Project) is a data migration project to migrate legacy data into an EDW (Enterprise Data Warehouse) model. - INFOR2 is a data warehouse project that migrates legacy policy data to EDW and infuses with the Guidewire PolicyCenter to facilitate the business objects reporting. - FAST is a Fraud analytics software tool that utilizes policy and claims data to identify auto insurance fraud patterns and report. • Responsible for verifying migration of (files) data from legacy systems to GWCC (Guidewire ClaimCenter) staging and GWPC (Guidewire PolicyCenter). • Verified data transformation from source systems o the Warehouse (EDW). • Infusing of Historical Claims Warehouse (CDW) data into Warehouse (EDW). • Validated Data Integrity, Data completeness, Validity, Data Transformation, Data Quality, Uniqueness and Referential Integrity of data and table definition while transforming data. • Validated all tests during initial and incremental loads for the Anchor, Fundamental and Relationship tables. • Assisted in verifying fact and dimension table implementation in Star Schema model based on requirements. • Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation. • Validated the reporting objects in the reporter against the design specification document. • Expertise in querying and testing RDBMS such as Oracle, DB2 using SQL • Written several complex SQL queries for validating and verifying the data across different databases. • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data. • Performed Unit testing and System Integration testing by developing and documenting test cases in Quality Center. • Reported any bugs using Jira

Alberta Blue Cross provides supplementary health and dental benefits to meet the needs of over 1.6 million Albertans. They offer benefit plans for individuals and families, seniors, and large and small employers. Project ASR (Administration Systems Replacement) is a web based online application which is used by the financial service representatives to sell Insurance products and by the customer service representatives to service customers. • Worked as a QA Analyst in testing the ASR project • Responsible for gathering Business, Functional requirements and Use cases • Review the Business and Functional requirements and identify the gaps and raise questions to Business Analyst • Work closely with Development team to provide feedback • Test code and implementation in the Development Environment • Responsible to document the change requests • Create detailed Test Plan, Test Scenarios and Test cases according to the Business/Functional requirements using HP ALM 11.0 • Identify the required test data • Create test data using XML • Used SOA requirements to set-up testing data, testing environment and test scripts on a periodic basis • Organize test coverage review sessions with the Business and Development teams and update the Test cases accordingly • Perform Sanity, Functional, Navigational, Cross Browser, Integration and End-to-End testing on ASR application • Report all the defects with proper priorities and severities and steps to reproduce using HP ALM 11.0 • Regression test the new builds after defect fixes using Quick Test Professional 11.0 • Provided regular status reports to the Project Manager and Management • Responsible for providing feedback to transition team members for better performance and output • Responsible for testing and implementing service oriented architecture (SOA) components • Provide guidance and support to junior staff members