Muralidhar N.

Muralidhar N.

experience in ETL, Functional testing with Banking, Insurance and Risk & Compliance banking.

Patna , India

Experience: 8 Years

Muralidhar

Patna , India

experience in ETL, Functional testing with Banking, Insurance and Risk & Compliance banking.

24188.5 USD / Year

  • Immediate: Available

8 Years

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

Portfolio Projects

AML / CFT Transaction Monitoring System

https://www.ambank.com.my/eng

Acting Test Lead in AmBank Group from Jan 2019 to till date.

Company

AML / CFT Transaction Monitoring System

Role

Data Scientist

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 Less

Tools

Windows

BV Mobile & OneCP secured loan

https://www.ocbc.com.my/group/group-home.html

Multiple projects in OCBC on data quality,Functional testing & Mobile apps

Company

BV Mobile & OneCP secured loan

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.

Show More Show Less

Tools

Windows

IRAS_eAgency(OCBC Bank)

https://www.ocbc.com.my/group/group-home.html

Worked as EDW Tester in Cognizant Malaysia from Feb 2017 to Dec 2018.

Company

IRAS_eAgency(OCBC Bank)

Role

Data Scientist

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.

Show More Show Less

Tools

Windows

Barclays CRA HMT(Credit Risk Analysis Her Majesty Treasury)

https://www.barclays.co.uk

ETL/SAS Tester

Company

Barclays CRA HMT(Credit Risk Analysis Her Majesty Treasury)

Role

Data Scientist

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).

Show More Show Less

Tools

Windows