Karthik Bala Email & Phone Number

Geelong,Victoria

 Develop business measures and requirements as multiple SAS dataset Problem analysis and issue resolution for the developed SAS datasets and SAS programs Improve the performance of SAS programs in BI’s production environment  Develop and run monthly/weekly/daily SAS reports for Recovery Support (Return to work, Legal, Common Law, Dispute etc) Develop SAS programs for new business reports and create reports as per stakeholder requirement using various dataset Design… Show more  Develop business measures and requirements as multiple SAS dataset Problem analysis and issue resolution for the developed SAS datasets and SAS programs Improve the performance of SAS programs in BI’s production environment  Develop and run monthly/weekly/daily SAS reports for Recovery Support (Return to work, Legal, Common Law, Dispute etc) Develop SAS programs for new business reports and create reports as per stakeholder requirement using various dataset Design, develop and maintain operational performance dashboards on a regular basis Show less

Geelong, Victoria, Australia

 Prepare monthly scorecards consisting of various measures which reflect the performance of division for each month. Prepare new dashboards as requested by business units Prepare PowerPoint packs for the management team while highlighting the key factors for the each month for their divisional meeting Enhancing existing excel reports with pivots, slicers, graphs etc to help stakeholders make decisions. Develop Qlikview reports for business on Legal service charter… Show more  Prepare monthly scorecards consisting of various measures which reflect the performance of division for each month. Prepare new dashboards as requested by business units Prepare PowerPoint packs for the management team while highlighting the key factors for the each month for their divisional meeting Enhancing existing excel reports with pivots, slicers, graphs etc to help stakeholders make decisions. Develop Qlikview reports for business on Legal service charter  Used Power BI tool for DAR project Show less

Geelong West, Australia

 Implemented framework for Information management team for the CSP project. Designed workflows process for Information Management, Data Science, and Reporting and Model team in BI. Created dashboards comprises of filters, Charts and various status reports for the IM team in JIRA Implemented Scrum process as part of SDLC for delivery of the work to Business. Prepared Test Plan for IM CSP remediation work. Created test cases for CSP projection with respect to solution… Show more  Implemented framework for Information management team for the CSP project. Designed workflows process for Information Management, Data Science, and Reporting and Model team in BI. Created dashboards comprises of filters, Charts and various status reports for the IM team in JIRA Implemented Scrum process as part of SDLC for delivery of the work to Business. Prepared Test Plan for IM CSP remediation work. Created test cases for CSP projection with respect to solution delivery document Assisted in execution of the test cases for CSP project. Excellent analytical skills with strong knowledge on schema, data design and SQL Technical experience in, relational databases, database development, data mining, data mapping, debugging, data management, reporting and data analysis. Good understanding and experience of inmon methodology. Developed SAS programs according to client request. Unit tested developed code for the clients. Peer reviewed and gave feedback on the developer’s code. Created SQL squires to design the data for testing the datasets and requirements. Worked closely with IM team on delivery of BAU work to business. Verified the SAS programs remediated by CSP is not introducing new defects  Verified the datasets created by CSP for new functionalities delivered as part of CSP Gathered the requirements from BI Ops team for reporting working and prepared the different documents as part of business delivery. Prepared documents and use cases for UAT and agreed on the sign off checklist. Show less

Geelong

 Prepared Test Plan and Test Strategy for different projects Created Project Planning schedule for the various project. Implemented new Test Management tool Zephyr for the company to be collaborated with JIRA Implemented testing process for the company. Created dashboards comprises of Charts and various status reports for the project and Business stakeholders. Worked with Business and Functional BA’s conducting workshop to get desired output and clarity on the product… Show more  Prepared Test Plan and Test Strategy for different projects Created Project Planning schedule for the various project. Implemented new Test Management tool Zephyr for the company to be collaborated with JIRA Implemented testing process for the company. Created dashboards comprises of Charts and various status reports for the project and Business stakeholders. Worked with Business and Functional BA’s conducting workshop to get desired output and clarity on the product to be developed for the functional area. Provided KT and helped the new testing team to know about AVANTI system and guided them in testing of different functionalities as Subject Matter Expert. Extended the automation test Suite scripts (UFT,QTP) for the new projects  Very good knowledge in creating JQL queries in JIRA to extract/create various reports for stakeholders and testing team. Drafted/Created complex SQL queries using DB schema to verify DB validation and data migration testing Prepared Defect report and run the defect triage meeting with project stakeholders. Prepared Test Summary Report at the end of each release Managed and overlooked testing team comprising of 8 team members for the CBM project. Reviewed the and drafted test cases for various project in QC, Zephyr and JIRA Planned the execution phase and executed the test cases for each release along with testing team. Prepared regression test suite and executed them at the end of the every drop Prepared and Performed integration testing for various application such as ROL,COL, DECHIPA, Mainframe, Save to Avanti, Copy & Print and Tempus. Very good experience in Insurance and Payment area which comprises of complex business and functional logic Created Test condition and Test cases for the Requirements to be covered to test against FRS Executed test cases for each drop and raised defects for failure test cases. Send the execution report to the manager to keep the track of progress during Show less

 Assisted in test plan creation Gathered requirements for drafting scenarios and test cases Scheduled meetings with various teams to understand the solution and finalise the solution Prepared test cases from Requirement, Business and Solution documents Prepared test data as a file from PeopleSoft and Mainframe server Scheduled and ran the batch job using the Autosys tool Performed test execution Raised defects in Quality Centre Drafted test cases and… Show more  Assisted in test plan creation Gathered requirements for drafting scenarios and test cases Scheduled meetings with various teams to understand the solution and finalise the solution Prepared test cases from Requirement, Business and Solution documents Prepared test data as a file from PeopleSoft and Mainframe server Scheduled and ran the batch job using the Autosys tool Performed test execution Raised defects in Quality Centre Drafted test cases and linked it to the requirement in QC Created test data for various test cases using Mainframe, OMS and People soft Performed Test Execution and raised defects in QC Participated in defect triage meeting and provided information on the defects raised by me Prepared Summary Log of the testing activity carried out Prepared failure report for AWHC in word document Designed the test cases for two releases(Bundle 900 and ILOG) in QC Show less

Melbourne, Australia

 Reviewed the business requirement and functional solutions specification documents for various projects Maintained the revision of documents in SharePoint Performed system test execution for various web projects which included cross browser testing and raised defects using TFS Generated defect reports and followed up outstanding issues with the development team Retested the defect fixes for Qantas, Canberra Theatre Centre, OfficeMax and Retail Decision… Show more  Reviewed the business requirement and functional solutions specification documents for various projects Maintained the revision of documents in SharePoint Performed system test execution for various web projects which included cross browser testing and raised defects using TFS Generated defect reports and followed up outstanding issues with the development team Retested the defect fixes for Qantas, Canberra Theatre Centre, OfficeMax and Retail Decision projects Performed stress testing for OfficeMax using Visual Studio 2008 and produced a report Drafted and executed test scripts for iPhone/iPOD Applications (iOS 3 and iOS4) Show less

India

 Motivated the team to achieve a target given by the authority Provided training and knowledge transfer sessions to the team Raised innovative ideas for process improvement and for technology which were approved by management Drafted component and integration test cases for run time components from the Functional Specification, System Requirement Specification and Business Specification Executed run time component test cases (component and integration) using a… Show more  Motivated the team to achieve a target given by the authority Provided training and knowledge transfer sessions to the team Raised innovative ideas for process improvement and for technology which were approved by management Drafted component and integration test cases for run time components from the Functional Specification, System Requirement Specification and Business Specification Executed run time component test cases (component and integration) using a simulator Prepared defect reports Performed code coverage using Ncover Explorer tool Created UAT test cases and executed them in the client’s infrastructure Captured performance testing results for various transactions manually Configured Webservice in the local machine and performed CRM testing as part of transaction Performed code coverage for various components using Ncover Explorer tool Prepared CTR (Test Report) and CTS (Test Specification) documents required for release of the components Prepared iteration plans for the next iteration Logged defects using Mercury Quality Centre 9.2/MKS Integrity Created queries for tracking the defect status using the defect management tool Prepared root cause analysis reports for various components Reviewed unit test report which includes fxcop analysis, static analysis and code coverage analysis Show less