Engineer Developer

HARISUDHAN DURAISAMY

Email: ***************@*****.***

Cell: +91-994******* (India)

CAREER OBJECTIVE:

To utilize my skills, strengths and knowledge for sustained growth of myself, organization and society.

SUMMARY:

6.3 years of experience in ETL/DWH Testing, Database and Manual Testing.

Mostly involved in writing SQL queries in Manual Testing.

Basic experience in development of transformations with Informatica

Good in writing SQL queries according to business rules.

Good knowledge in working with Informatica tool in an ETL workflow.

Involved in writing Test cases according to requirements.

Good knowledge in areas of Integration Testing.

Having complete Defect Life Cycle knowledge.

Good knowledge on tracking the bugs and maintenance.

Has Hands-on Exposure to production support activities related to Informatica TECHNICAL SKILLS:

Database : Oracle 11g, DB2, SYBASE

Operating Systems : Windows XP/NT/2000/7/10, UNIX, Sun OS

ETL Tool : Informatica 9.6.1

Functional tools : T24, Mortgage View, Calc Builder, TBA, ATE,Sql loader

Defect tracking tool : HP-ALM QC 10, JIRA, HRO Maestro, Lotus Notes

Technology : Oracle, Mainframe, CICS.

Programming Languages : Basics of PL/SQL

DB Query tools : SQL Developer 4.1.3, PL/SQL Developer

Reporting Tool : Tableau 9.0

PROFESSIONAL EXPERIENCE:

Currently working as an Associate with Natwest Group, Chennai from November - 2019

From March-2018 to November - 2019 to Senior Test Engineer in Saudi-American Bank(SAMBA), Riyadh, Saudi Arabia under the payroll of Maveric Systems,Chennai

From March-2014 to March-2018(includes 6 Months of Internship) as Senior Specialist

(DATAWAREHOUSE) with Alight Solutions, Chennai.

CERTIFICATIONS:

Certified by Oracle University as Oracle Certified Professional (OCP) in Oracle 10g.

Secured C’ grade in British English Certificate (BEC) exam conducted by the University of Cambridge, London

ACHIEVEMENTS:

Recipient of “LIVE OUR VALUES” for quality, flexibility, outstanding contribution & timeliness on deliverables.

Recipient of “GOLD AWARD FOR EXECUTION “Award for contribution to quality development and maintaining client promise.

Recipient of “PLATINUM AWARD FOR UNMATCHED TEAM” for distinctive client value. EXPERIENCE SUMMARY:

Project 1:

Natwest Group:

Project Debt Management Transformation Programme

Database Oracle 11g

Environment/Tools Informatica Power Center 9.6.1, PL/SQL All Round Automation,Confluence,JIRA

Testing Methodology Agile

Domain BFSI - Banking

Project Description:

Debt Management Transformation Programme (DMTP) project involves migration of the accounts from Legacy mainframe systems to Cloud based DMv11 solution, which aims to reduce the maintenance cost in DB2 database and provide sophisticated user experience to debt related bad accounts

Responsibilities:

Involved in sprint planning meetings.

Analyze the user stories and raised queries to the business analyst.

Collaborated with BA and developer frequently for requirements clarification

Test planning activities

Preparing the test cases based on the business user view

Review the changes made on the user stories and modify the test cases based on the change.

Actively participated in project meetings and discussions.

Tracked and managed defects along with analyzing data and provided reports

Performed both positive and negative testing to ensure upgrades were performing correctly

Validated the old mortgage manager screen with the new solution to ensure all the fields are captured correctly.

Prepared a document with both application screens for end to end testing. Notable Contributions:

Implemented power BI to extract data from XML files which reduced manual work

Implemented SQL * loader for uploading extract from source and target systems for reconciliation . This reduced manual effort of 5000 minutes to 15 minutes per file Project 2:

Saudi-American Bank (Client site – Riyadh, Saudi Arabia): Project SMART SAMBA

Client Saudi-American Bank (SAMBA)

Database Oracle 11g

Environment/Tools Informatica Power Center 9.6.1, T24,Star,Periperal systems, FRAS

,HP-ALM, Putty, WinSCP

Testing Methodology Agile Scrum Waterfall

Domain BFSI - Banking

Project Description:

SMART SAMBA project involves migration of the data from legacy STAR system to T24 application and also posts Live testing of daily/Monthly/Adhoc data movement from T24 system to various peripheral systems that supports the functions of the bank. Responsibilities:

Responsible for data validation processes and documentation of all the process related documents required for the development and production support.

Collaborated with BA and developer and application team frequently for requirements clarification

Test planning activities

Preparing the test cases based on the business user view

Review the changes made on the user stories and modify the test cases based on the change.

Tracked and managed defects along with analyzing data and provided reports

Performed both positive and negative testing to ensure upgrades were performing correctly

Involved in production support activities of Informatica

Prepared a document with both application screens for end to end testing. Project 3:

General Motors of Canada ltd

Project Benefits Administration (Web & Annual Enrolment) Client General Motors of Canada Limited (GMCL)

Database Oracle 11g

Environment/Tools Informatica Power Center 9.6.1, PL/SQL All Round Automation Domain Health and Welfare

General Motors Company, commonly known as GM, is an American multinational corporation headquartered in Detroit that designs, manufactures, markets, and distributes vehicles and vehicle parts, and sells financial services.

Responsibilities:

Handle all the Development and Enhancement tasks (Incidents, Break fixes and CR's) and the Production Support Tasks.

Responsible for the application security by giving access to the application users depending on the requirement and approval from the higher management.

Responsible for data validation processes and documentation of all the process related documents required for the development and production support.

Responsible for server maintenance of all the Informatica and Business Objects production servers.

Co-ordinate with the end users on their business objects reporting issues and data issues, understand their requirements and work with them closely to resolve their issues. Project 4:

Canadian Imperial bank of Commerce – Canada

Project Defined Benefits Reform

Client Canadian Imperial Bank of Commerce (CIBC)

Database Oracle 11g

Tools Used Informatica,TBA,PCS, PPP, SQL Utility, Calc Builder, ATE (Advanced Table Editor)

Domain Defined Benefits(DB)

CIBC serves more than eleven million customers and has over 40,000 employees. The company ranks at number 172 on the Forbes Global 2000 listing. Responsibilities:

Involving analyzing the business requirements.

Participating in daily status calls with client and onsite co-coordinator to getting clarification on requirement.

Filling the process related documents like Effort Tracking sheet, Unit test exit report etc..

Involved to create Unit Test plan and unit testing.

Used different transformations like Source Qualifier, Expression, Aggregator, Joiner, Dynamic Lookup, Union, Router, update Strategy, sequence generator, Normalizer and Filter etc. in creation of mappings.

Creating jobs on SCD type1, SCD Type2 and Loading data into Dimension and Fact tables. EDUCATION:

COURSE INSTITUTION PERCENTAGE DURATION

B Tech -

(IT)

Bannari Amman Institute of Technology,

Sathyamangalam.

8.19 CGPA 2010-2014

Class XII Vijayalakshmi Matriculation Higher Secondary School, Sirumugai.

95 2009-2010

Class X S.I.V Matriculation Higher Secondary School, Sirumugai

88.2 2007-2008

PERSONAL DETAILS:

Father s Name : Mr T.Duraisamy

Mother s Name : Mrs D.Bagyalakshmi

Date of Birth : 12.05.1993

Languages Known : English(R-W-S), Tamil(R-W-S) & Kannada(S) DECLARATION:

I pledge and pronounce that all the above information is true to my knowledge. Place: Chennai

Date:

(D.Harisudhan)

Contact this candidate