· Import data using Sqoop into Hive and Hbase from existing SQL Server.

· Support code/design analysis, strategy development and project planning.

· Involve in Requirement Analysis, Design, and Development.

· Export and Import data into HDFS, HBase and Hive using Sqoop.

· Involve in create Hive tables, loading with data and writing Hive queries which will run internally in MapReduce way.

· Work closely with the business and analytics team in gathering the system requirements.

· Writing Hive QL, shell script, Oozie workflow.

· Importing data from Oracle to HDFS through Sqoop.

· Generating ad hoc reports based on the client’s demand using Hive, Sqoop, HBase etc.

· Formulating & implementing the test cases.

· Review of SRS, FRD document and Preparing Test data as per Requirements.

· Preparing Test cases against System Requirement Specification or change requests.

· Involve in Functional, System and Integration Test execution as per the test plan.

· Delivering production and test platform Level 3 Support.

· Documenting reports on various activities followed in the project.

Environment: Classic ASP, VB, C#, Oracle Client: Maybank (Kuala Lumpur)

Role : Senior Software Engineer Organisation: D+H

Responsibilities:

· All component deployments, Release Policy and planning.

· Organizing Release Management Team

· Release design, build and configuration

· Coordinator for Functional document sign-off and achieve the business goals.

· Train the bank’s IT (Information Technology) team to eventually manage 1st level support for CMS system on their own.

· Explain RCA report to MBB Weekly basis (if required).

· Act as coordinator with offshore team for other activities and support every day defects .

Project: GCP Loan Process. Duration: Feb 2017 – December 2017

Environment: Hadoop, Hive , Sqoop, HBase, Flume, Scala, Spark, Java Client: CITI Bank

Role : Senior Software Engineer Organisation: Finstra (D+H)

Responsibility:

· Coordinate with the Product Owner on current programming tasks.

· Collaborate with other programmers to design and implement features.

· Quickly produce well-organized, optimized, and documented source code.

· Implemented Apache PIG scripts to load data from and to store data into Hive.

· Involved in converting Hive/SQL queries into Spark transformations using Spark RDDs and Scala.

· Involved in converting MapReduce programs into Spark transformations using Spark RDD in Scala.

· Implemented Spark using Scala and utilizing Data frames and Spark SQL API for faster processing of data.

· Used Avro, Parquet and ORC data formats to store in to HDFS.

· Used Oozie workflow to co-ordinate pig and hive scripts.

Project: Global Cash Plus Duration: Aug 2015 – Dec 2016

Environment:Java 1.7, Spring, Hibernate-4.0, JMS, Oracle, MS SQL Client: Bank of Brazil

Role : Senior Software Engineer Organization: Finstra (D+H)

Responsibilities:

· Implemented soap web service for transaction module of web portal.

· Mapped different association for persistent classes by using hibernate.

· Wrote JUnit for newly developed backend modules.

· Used parsers for parsing xml documents and used XML transformations using transformation server.

· Implemented new web services to improve functionality.

· Refactored code and test suites to promote code-reusable infrastructure.

· Modified cache strategy for 3 types of messages support for SEPA.