ETL Senior Tester
Resume:
Kumar Sundararaman
Contact Number : +61-404******/+61-470******
Email : ********@*****.***
Postal : U 8, 55-57 Underwood Road, Homebush, Sydney, NSW Visa: Temporary Business Entry (Class UC) Business (Long Stay) (Subclass 457) Career Objective
Seeking a robust career in the field of Information Technology where I can implement and leverage my knowledge and skills. It is my utmost desire to join an organization of repute that can provide me with challenging career opportunities. I want to be known as one of the best talents available for the changing scenario.
Professional Summary
5 years of work experience in Data warehouse Testing / ETL Testing in banking domain and development of Data warehousing Projects.
More than 3 years of experience at Client Location(Commonwealth Bank of Australia)
Working closely with Project Manager in definition and execution of project deliverables and day-to-day management of the entire project.
Assist in providing resolution for issues and correct project variances when necessary.
Understanding Business requirements along with Business Analyst’s in walkthroughs.
Coordinating with Onshore/Offshore testing team for the test progress and resolving issues
Expertise in documenting test strategies, plans, processes and standards
Review the architecture and designs of systems and features, and actively engage with Business Analysts and Developers to ensure the soundness of proposed solutions
Review and revise acceptance criteria to guarantee they are fit for purpose once fulfilled
Having Good Knowledge and experience of DWH concepts.
Well versed and mentor knowledge in HP Quality Center 11.0 and ALM
Knowledge and work experience in Agile methodologies
Clear understanding of STLC & Defect Life cycle and thoroughly exposed in ETL-Process.
Expertise in design and development of test scenarios and Test cases to validate all the requirements and reviewing Business Requirement Documents.
Responsible for creating Test Plans,Estimation and Test status/Recommendation reports
Thorough knowledge of software testing methodologies Functional, Integration, System Testing, Regression and User Acceptance Testing.
Extensive experience in writing complex T-SQL statements.
Sound experience in Knowledge Transfer and Mentoring new team members in the Project and assigning them the tasks to handle.
Communicates with clients effectively.
Good sense of teamwork, leadership quality, integrity, atitude to learn and ability to put in sustained quality effort consistently.
Worked as Technical Business Analyst and Developer for few months. Employment History
HCL Australia Services Pty Ltd,Australia Senior Test Analyst Aug 2012 - Till date
HCL Technologies Limited, India Test Analyst Nov 2010 - July 2012 Project Summary
HCL Australia Services Pty Ltd Senior Test Analyst –Onshore Jan 2015 - Till date Client : Commonwealth Bank (CBA), Sydney, Australia Technologies : Teradata SQL Assistant 14.0, HP ALM 11.52, Putty, Hyperion Interactive Reporting 9.0
Description: A&I ILT-ST: Analytics & Information is the Backend phase of Core Banking. ILT team involves in handling the Data from the various front end applications like CommSee, CommBiz, Net Bank, BTS and delivering the data to the Reporting Systems and other externals systems which is dependent on the other streams of CBM
Responsibilities
Understanding the requirements including testability and verify whether the reporting requirements can be catered using the data available
• Analysing the requirements for high probability risks areas.
• Prepare Test Conditions and obtain Sign Off from Business Analysts.
• Test case preparation & Execution for the scenarios & Regression
• Analyse and define the Test Data requirements and Communicate External Dependencies.
• Responsible for creating complete test cases, test plans, test data, and status reports ensuring accurate coverage of requirements and business processes.
• Testing the Fund Transfer Pricing/Core treasury system.
• Knowledge transfer of the Data warehouse concepts to the new team member.
• Coordinating with the offshore team to get the deliverables at right time.
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis
• Defect logging and tracking to closure in ALM
• Preparing the Daily Test Status Report and the Test Recommendation Report. HCL Australia Services Pty Ltd Test Lead - Onshore Apr 2014 – Dec 2014 Client : Commonwealth Bank (CBA), Sydney, Australia Technologies : Teradata SQL Assistant 14.0, HP ALM 11.52, Putty Description: GIS MCC-ST: The Multi Currency Core Platform enables the migration of Foreign Currency Accounts to the SAP core platform as well as the creation of 3 new multi-currency Sales Products. As a result, existing data feeds from SAP to the GDW Integrated Model will include accounts denominated in currencies other than AUD.
Responsibilities
• Review and analyse the project requirements.
• Plan and organize the knowledge transfer to the team.
• Collect the queries related to the requirements and get them resolved by the business person.
• Plan, organize and lead the testing kick-off meeting.
• Create the test plan, get it reviewed and approved/ signed-off by the relevant stakeholders.
• Estimate the test effort and team (size, skills, and schedule).
• Create the test schedule (tasks, dependencies and assigned team members).
• Communicate with the client or on site/ offshore team members, as required.
• Review the test cases and test data generated by the Testers and get them to address the review comments.
• Track the new/ updated requirements in the project and modify testing artifacts accordingly.
• Assign tasks to the testers based on the test plan.
• Check the status of each assigned task daily and resolve any issues faced by the team members with their tasks.
• Ensure that each team member is optimally occupied with work.
• Review defect reports and assign valid defects to the relevant developer/ development manager
• Ensure the resolved defects are re-tested and track to closure
Consolidate and report test results, get it reviewed and approved/ signed-off by the relevant stakeholders.
Report the daily status of the project to the stakeholders.
Improve the test process based on the suggestions by others and own judgment.
Preparing the Test Recommendation Report and PIR. HCL Australia Services Pty Ltd Senior Test Analyst – Onshore Aug 2013 – Mar 2014 Client : Commonwealth Bank (CBA), Sydney, Australia Technologies : Teradata SQL Assistant 12.0, Quality Centre 11, Putty, Toad, Hyperion Interactive Reporting 9.0, Essbase
Description: CUSTOMER NEXUS - I&R: BIM’s scope in CBM LCN will be to deliver enriched product and customer data from SAP to the GDW, to make GDW as a single source of truth for data and to maintain current reporting capability.
Extend capabilities delivered in prior launches to accommodate launch offers
Extend GDW load for new SAP data
SAP BP becomes the master for customer
Support informational requirements for ‘new bank’ processes
Update downstream data marts in line with SAP BP
Update analytical and reporting applications
Deliver enriched data
Deliver regulatory reports
Responsibilities
Analysing and Understanding the requirements including testability and verify whether the reporting requirements can be catered using the data available.
Creating traceability relationship between requirements
Developing and Reviewing Test Conditions and cases to verify data transformations as per the business rules and extraction criteria.
Work on Test environment set up
Performing Test Execution
Checking the availability of data in ODS tables.
Creating SQLs - Create SQL queries to fetch and verify the data from Source tables and views.
Source Validation - Validation of the Source data after isolating the driving source tables/views and checking the data integrity between the various source tables and relationships.
Validating the business & transformation rules
Tested Common layer for storing of all views for reporting and analytics purpose
Tested Financial Performance Reporting views and reports
Logging defects in Quality Centre and defect tracking till closure HCL Australia Services Pty Ltd Senior Test Analyst – Onshore May 2013 – Jul 2013 Client : Commonwealth Bank (CBA), Sydney, Australia Technologies : Teradata SQL Assistant 14.0, Quality Centre 11, Putty, Toad Description: DDS Decommission: The DDS Decommissioning project is to migrate all the remaining DDS accounts into SAP. The accounts that are still remaining in the DDS systems are mainly Retail lending products of Viridian Line of Credit, CPL & CALIA as well as Internal Accounts. The scope of Information Reporting capability has been to ensure that the downstream reporting solutions continue to get the information they used to get and also facilitate new operational reports either from the ODS or GDW. The scope of Information and Reporting capability is to continue to provide the same information from SAP as DDS. As part of DDS decommissioning there is some new attributes being introduced that are specific to Retail Line of credit. These being;
The LOW_DOC indicator,
Information relating to Loan Mortgage Insurance,
Various staff and broker identifiers for various activities done in the application process of the retail line of credit
Responsibilities
Analysing and Understanding the requirements including testability and verify whether the reporting requirements can be catered using the data available.
Developing and Reviewing Test scripts/cases to verify data transformations as per the business rules and extraction criteria.
Walkthrough with the business to get sign-off for the Test Objective Matrix
Verifying the flow of customer information from Commsee, SAP,GDW till reports
Performing System Testing i.e. testing of the views, reports and reconciliation process.
Performing Test Execution
Checking the availability of data in ODS tables.
Creating SQLs - Create SQL queries to fetch and verify the data from Source tables and views.
Performing End to End testing i.e. testing of the views, reports and reconciliation process.
Logging defects in Quality Centre and defect tracking till closure.
Prepare the Daily Test Status Report and defect summary report.
Positions in as a Defect coordinator in the absence of Test Manager/Test Lead. HCL Australia Services Pty Ltd Senior Test Analyst – Onshore Aug 2012 – Apr 2013 Client : Commonwealth Bank (CBA), Sydney, Australia Technologies : Teradata SQL Assistant 14.0, Quality Centre 11, Putty, Toad Description: B&D-I&B: Interfaces & Batches involves two different kind of data flow from Source to Target. Extracting the data from ODS tables (which is getting loaded with the DSO files extracted from SAP BI) and sending in SAP PI formatted files to SAP. Obtaining the source file from business and validating those data with the available data in ODS Responsibilities
Analysing and Understanding the requirements including testability and verify whether the reporting requirements can be catered using the data available.
Attending business walkthrough
Developing and Reviewing Test scripts/cases to verify data transformations as per the business rules and extraction criteria.
Tested analytics layer for accounts, account balance, customer and events according to S2T mapping document
Running the jobs
Performing Test Execution
Creating SQLs - Create SQL queries to fetch and verify the data.
Logging defects in Quality Center and defect tracking till closure.
Performing System Testing i.e. testing of the views, tables, files and reconciliation processes of all transactions
HCL Technologies Ltd Test Analyst– Offshore Jan 2011 - Jul 2012 Client : Commonwealth Bank (CBA), Sydney, Australia Technologies : Teradata SQL Assistant 12.0, Quality Centre 11. Description: Launch 3B: The Core Banking Modernisation Programme aims to modernise the Bank’s core systems by replacing three primary product systems (DDS, TDS and HLS) and two customer information systems (CIF and CRIS) with a single system, SAP banking services. In L3a Business Partner became the master for the CIF view of customers and in L3b, Commercial Lending products are delivered. Information and Reporting Involves the business users to analyse and makes decision based on the information retrieved. Responsibilities
Designing the Test conditions using Functional Specifications.
Developing and Reviewing Test cases to verify data transformations as per the business rules and extraction criteria.
Test Environment Setup and Performed the Functional and Regression Testing
Detecting bugs, classifying them based on the severity and Open Defect's with help of Quality Centre wherever discrepancies found in the code and assigning them to development Team.
Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation.
Attended periodic meetings and discussions on problem resolution.
Coordinated with Developers for Defect analysis and performed Regression Testing. HCL Technologies Limited Test Analyst – Offshore Nov 2010 – Dec 2010 Description: In-house Software Testing Training: HCL has arranged the basics of Testing for the fresher’s in Chennai.
As a Fresher trainee, my roles& responsibilities includes:-
Understanding the software life cycle.
Understanding the basic concepts of testing and its practical implementation in assignments
Obtaining the knowledge on identifying the Test scenarios from scope and deriving the Test scripts from the scenarios
Preparing sample Test scenarios and Test cases for the scope provided. Education
Bachelor of Engineering (Electronics & Communication Engineering), Anna University, Chennai, India - 2005 – 2009 – 70%
XII (Higher Secondary) - Tamil Nadu Board of Secondary Education, Chennai, India – 2004 – 2005 – 88.85%
X (SSLC) - Tamil Nadu Board of Secondary Education, Chennai, India - 2002 – 2003 - 73.33% Relevant Skills
Domain : Data warehousing (Banking)
Programming Languages : Teradata SQL
Tools : Teradata SQL Assistant 12.0, Datastage, Essbase Hyperion Report, Putty, Quality Centre 11, TOAD, WINSCP, Microsoft SQL server, JIRA
DB : Teradata SQL
Certifications
• ISTQB - ISEB certified Professional
Personal Vitae
Date of Birth : 14th March, 1988
Gender : Male
Marital Status : Married
Linguistic Abilities : Tamil, Telugu and English.
I hereby declare that all the above information is true to the best of my knowledge and belief. Yours Truly,
Kumar Sundararaman
Contact this candidate