Now you can Instantly Chat with Muralidhar!
About Me
Ø Having Overall 8+ years of experience in ETL, Functional testing with Banking, Insurance and Risk & Compliance banking.
Ø Having very good experience in ETL Production support with JPMC bank....
Ø Having very good experience in ETL Production support with JPMC bank.
Ø Proficient in ETL and Manual testing on Web based applications, Windows applications and mobile applications.
Ø Proficient in performing ETL data warehouse testing using tools like Informatica and Data stage, Real time and Batch file testing.
Ø Hands on experience in working with SQL Server, Teradata, DB2 and Oracle Databases.
Ø Experience in writing complex SQL queries
Ø Extensively worked on Functional tools such as management tools- HP ALM QC, Test rail and Fog bugz.
Ø Experience in preparing, creating and documenting Test Plans, Test cases, Test execution, test results, DSR report, TOR or TCR (Test Closure report) and RTM.
Ø Hands on experience in converting mapping transformations into SQL scripts, executing to perform the data validation.
Ø Having good experience in Teradata control frame work (Teradata GCFR) & FSLDM.
Ø Good knowledge in Data warehouse concepts and UNIX.
Ø Good experience in Scheduling tool Control-M .
Ø Played role as a Very good team member and capability of handling projects individually towards achieving the milestones.
Technical Skill set:
· Testing : Data warehouse / ETL & SAS EG
· Operating System : Windows, UNIX
· DB Interface tools : Teradata, SQL Server Management Studio, Netezza, Oracle SQL Developer.
· ETL Tool : Informatica (Power center 9.1), Data stage & Teradata
· Application : SAS EG 4.3
· Job Scheduling tool : Control-M
· Management tool : Quality center (12.53), Test Rail, FogBugz and Bugzilla
· Testing tools : DB, SOAPUI , WINSCP 5.11.3
· Packages : Microsoft Office.
Show More
Skills
Portfolio Projects
Contribute
• Understand the testing effort by analyzing the requirements of project. • Estimate and obtain management support for the time, resources required to perform the testing.
Description
A well-designed transaction monitoring (TM) system is an important component of an effective anti-money laundering and counter financing of terrorism (AML/CFT) compliance program. In support for the efforts to combat money laundering and terrorist financing, AmBank group is committed to develop and implement effective measure to identify unusual or suspicious activity and ensure that they are reported to the regulatory authorities.
To effectively monitor potentially suspicious/unusual transactions and guard the bank against money laundering and terrorism financing threats, there is a need to have a robust ongoing detection system, data management, and optimization and reporting to review of customer’s transactional activity, based on pre-defined set of criteria, behaviors and parameters in accordance to the risk based approach of monitoring process
Show More Show LessWorked as EDW Tester in Cognizant Malaysia from Feb 2017 to Dec 2018.
Contribute
Database testing ,ETL testing
Description
- Gathering and Understanding business documents from client requirements.
- Preparing environment setup for data extraction, loading and transformation from upstream to downstream.
- Validating data from Production environment and SIT environment.
- Check issue log and exception when Control M job fails and report them to the developer.
- Prepare and execute test cases in HP ALM after validation /executions of the SQL scripts
- Analyze mapping specifications and report and collect observation logs
· Worked together with stakeholders to prepare test script and test plan with entry, exit and sign off criteria for the project.
- Using ETL Frame work to better collate the data by batch and validate them.
- Performed activities in ETL frame work like: Batch initialization, activity initialization and closure of the same.
- Follow up with mapping team to get mapping specs clarifications.
- Follow up and conduct discussions with developer on the issues.
- Raising SIR(Defects) while data loading and when development code does not meet the FSD requirement.
- Maintaining project documentation for SIT tasks performed, tracking issues logs, for audit, generating compliance report.
Multiple projects in OCBC on data quality,Functional testing & Mobile apps
Contribute
Tested Multiple applications using ETL &database testing,Functional testing & Mobile apps
Description
- Gathering and Understanding business documents from client requirements.
- Preparing environment setup for data extraction, loading and transformation from upstream to downstream.
- Validating data from Production environment and SIT environment.
- Check issue log and exception when Control M job fails and report them to the developer.
- Prepare and execute test cases in HP ALM after validation /executions of the SQL scripts
- Analyze mapping specifications and report and collect observation logs
· Worked together with stakeholders to prepare test script and test plan with entry, exit and sign off criteria for the project.
- Using ETL Frame work to better collate the data by batch and validate them.
- Performed activities in ETL frame work like: Batch initialization, activity initialization and closure of the same.
- Follow up with mapping team to get mapping specs clarifications.
- Follow up and conduct discussions with developer on the issues.
- Raising SIR(Defects) while data loading and when development code does not meet the FSD requirement.
- Maintaining project documentation for SIT tasks performed, tracking issues logs, for audit, generating compliance report.
Contribute
Data quality check,SAS testing, ETL Testing
Description
- Gathering and Understanding the client requirements.
- We prepare SQL using SAS datasets in SAS EG and Teradata.
- Validating Control Reports for different Source system like UKBA & ALS.
- Validating Statistics and file health check report for UKBA & ALS.
- Validating DTU Jobs in Tivoli Manager.
- Preparing, Run and execute test cases in HP ALM after validation /executions of the SQL scripts.
· Validating Business Data, Data mapping and Business transformation data into CRA Reports.
- Attend daily status calls and interact with Leads, designers on shore and offshore, developers on issues and concepts
- Preparing TCR(Test Closure report).