PROFESSIONAL SUMMARY

Experience Summary

**+ years of Strong Design, Development, Project Management Experience in Banking Domain.

2+ Years of Experience in Big Data Eco System - Hadoop, HDFS, Hive, Sqoop programming and Data Modeling.

7+ Years of experience in Oracle – SQL, PL/SQL technology.

6+ Years of rich experience in Pro*C, UNIX.

Experience in Data Center Migration, Data Migration, Technology Migration, File System Migration via First Data File Gateway from legacy system.

Managed Development, Maintenance, Migration projects in Global delivery model.

Experience in gathering of business requirements, interacting with users, identifying functional and technical gaps, Sizing, Scheduling, Designing, programming, reviewing and tracking.

Expertise in Software Development Lifecycle (SDLC), Release Management and change management process, QA & UAT, Production L2 Application Support, Supported CMMI level 5 audit.

Ensure required training is available & utilized by team members.

Monitored, tracked and ensured compliance to project stringent SLA’s and KPI’s.

Analytical problem-solver, able to anticipate issues and improve the efficiency.

Education

Bachelor of Technology (IT) from Arasu Engineering College,

Kumbakonam with 74% [March-2005]

Domain Skills

Account Opening, Debit Card Processing (Citi India),

Pre-Paid Card Systems (VPS),

Reconciliation & Settlements (CITI Bank, VPS), Basics in Switch System

Credit Cards Payment System, Acquiring and Merchant Solutioning

and Funding (FirstData Omnipay System)

AML (Citi LATAM LNT InfoTech)

Technical Skills

Languages : C, Pro*C, JAVA, Python

Big Data Eco System : HDFS, Hive,Pig,Sqoop,Flume,Oozie

Operating System : Windows, MS-DOS, UNIX

Database : Oracle 9i,11g,12 C ( SQL,PL/SQL)

Tool Skills

Technical : SQL Developer, TOAD, Connect Direct – File Transfer, GIS – File Transfer

Defect Tracking : ALM

Change Management : JIRA, Remedy

Version Control : VSS,SVN,GIT-Gerrit

Scheduling : Tivoli, Control M,Oozie

Release Management : Touch Paper

Documentation : Confluence

Certification

ITIL Foundation certificate in IT Service Management.

Honors And Awards

GEM Award (Going Extra Mile)

DU Head – Polaris Software Lab Ltd.,

JAN 2011

Delivery R & R: Live Wire

SDU Head - VISA Engagement HCL Technologies

OND 2013

SPOT Award

SDU Head - VISA Engagement HCL Technologies

JAN 2014

Delivery R & R: Live Wire

SDU Head – LBG Engagement HCL Technologies

JAS 2015

O2 League Award

EXPERIENCE Summary

Organization

Designation

Duration

LNT Infotech

Project Manager

Sep 2019 to Feb 2020

First Data Corporation, India

Senior Application Analyst

Mar 2018 to Apr 2019

HCL Technologies., India

Senior Technical Lead

July 2012 to Feb 2018

Polaris Software Lab Ltd., India

Consultant

Mar 2008 to Jul 2012

Sunbeam Systems, India

Software Programmer

Aug 2005 to Mar 2008

PROJECT Summary

Project:

LATAM Data Mart Migration Project

Role/Period:

SME Cum Project Manager

Technology:

Oracle 11g, PL/SQL, Unix Shell Scripting, Python, Big Data – Hive, Sqoop,Autosys,Jira

Overview:

Migration of AML-CDW system into EAP architecture . Existing CDW system is in Legacy technology ( Pro*C, Unix Shell scripting, PLSQL) now migrating the same into EAP architecture where HIVE ( HQL ) is used as a technology .

Compliance DataWarehouse loads, stores and transform transactional and referential data for anti money laundering purposes.

It main task is to take information from LATAM product processors and transform it to the required format so it can be ingested by Mantas. After that Mantas will run the required scenarios with that information and publish the cases monthly (Usually the 12th of each month) in CitiCMT. CDW receives the information directly from the product processor (Files) or through an intermediate DataWarehouse (RDW)

Responsibility:

Managing Data Model, Development, DQ, SIT team with 26 people in global delivery model (offshore and onshore model).

Interacted with team members, across different streams (Client ., LATAM team, Mapping – Data model team, Development, DQ & Testing, End User, Change Management) for defining overall objectives, strategy and road map for the project.

Directed and coordinated business requirements review, efforts estimation, resource requirements and all planning activities for the project.

Scheduling of activities across all the tracks for two Waves. Wave1 – Three country migration and Wave-2 6 country migration plan.

Migration planned to move the different source system present for each county into single source code in EAP architecture. Involved in Designing of Single source code maintenance.

Understand AML Domain logic implemented in CDW system and convert that to fit into Global ERP Model .

Involved in Data Mapping by analyzing the Legacy PLSQL code and mapping the same into CITI EAP architecture Data Stage Model.

Project:

OMNIPAY – Acquiring & Merchant Technology First Data Corporation

Role/Period:

SME Cum Project Manager

Technology:

Oracle 11g, PL/SQL, Unix Shell Scripting,Control-M, Python, Big Data – Hive, Sqoop,Oozie,Confluence, JIRA, GIT-Gerrit

Overview:

OmniPay is First Data's multi-currency, multi-country acquiring technology of choice for payment processing Omnipay provides support across Clearing, Billing & funding, Settlement and Data Reporting & Management and performs auth support for directly connected merchant and gateways.

Responsibility:

Managed offshore IT Service, App Support team, MI team along with Vendor Development team members.

Interacted with team members, across different streams (BA,

Development, Testing, End User, Change Management) for defining overall objectives, strategy and road map for the project.

Ensure to update all the project related documents and QA/PROD Project deployments are available on Confluence.

Directed and coordinated business requirements review, efforts estimation, resource requirements and all planning activities for the project.

Query Tuning, Code Review, Design and Development.

Job Scheduling using Control-M Scheduler.

Involved in Release Control and Change Control for APAC related Countries project release using JIRA.

Supporting Data Center Move – Migrating Data Center from Dublin to Germany Frankfurt.

Technical Support for Importing and exporting data in HDFS and Hive using Sqoop and experience in implementing ORC File, AVRO file format and UDF as part of DC setup for India Instance Migration.

Technical Support and Involved in Initial Analysis Estimation of India Data Center Set up for ICICI & PayPal Indian Client from Frankfurt server and Data Migration from Frankfurt Server to India Server.

File System migration from legacy file transfer to First Data File Gateway.

Project/Client:

Bank of Montreal – Commission Accounting System

Role/Period:

Senior Technical Lead: Jan 2017 to Feb 2018

Technology:

Hadoop, Hive,Sqoop,.Net,MS SQL Server 2008, Pro*C, ORACLE PLSQL, UNIX, Forms & Reports,JIRA,SVN

Overview:

CAS :

Is a commission accounting system proprietary to NESBITT Burns Financial Accounting Department. It receives information from various sources and also sends output to various sources. ADP,RIS,Wealthware are example of some inbound data while Payroll, Hyperion are examples of some outbound . Night Cycle Process is a part of CAS System. It loads the data into the CAS System. The commission payout calculation process is the single most component of CAS. There are various reports generated with CAS System. Gross Commission, Sales Report, Investment Advisor Reports are some of them.

RIS:

RIS (Retail information system) is a Backend system which is used by IA’s (Investment Advisor) to perform some Business functions like Trades, Marketing, Reports, Calculating & Displaying client Holdings. IA’s will access RIS Application to create and maintain client’s portfolio. RIS is a Bi-lingual (English & French) Application. It Organizes, manages, and stores a wide range of information about each of NB’s clients and their respective holdings.

Oracle Security - 12C Migration:

Corporate Audit has identified the need for enterprise wide Information Systems security improvements at the database level. PCIS must comply with recent Corporate Audit recommendations and corporate security objectives.

Responsibility:

Managing Development team. Conducting regular meeting with development teams.

Assign the task to team members and tracking it as per the project plan.

Finalizing the Design approach for the new change request.

Development, Code Review, QA/UAT/Production Support

Importing and exporting data in HDFS and Hive using Sqoop.

Involved in creating Hive tables, loading with data and writing hive queries which will run internally in map reduce way. Extracted files from SQL Server through Sqoop and placed in HDFS and processed.

Working on ORC File, AVRO file formats in Hive.

Support and involved technically DBA Activity on the Users, Roles & Privileges.

12C Migration Analysis and Design Solution for Data Pump Implementation.

Technical Support on Query Tuning for the Team members.

Project/Client:

LBG- BOE Compliance 2016

Role/Period:

Project Manager: May’ 2015 – Jan 2016

Technology:

UNIX, MAINFRAME, .NET, APTITIDE Tool, SVN

Overview:

Bank of England Statistical Reporting Compliance Programme to enable the LBG entities that have a banking license to be able to meet the changing regulatory demands made on them by the Bank of England (BoE) in respect of statistical reporting. The changes are mandated by the BoE directive under section 17 of the 1998 BoE Banking Act. The BoE has a rolling 5 year programme where it makes significant changes to the data and reporting it collects from banking firms. These changes, in the majority require to be delivered as part of the normal reporting from periods from 1 January 2016, with the final change (relating to embedded financial institutions) being optional until January 2017 – and being met under a separate project.

Responsibility:

Handled a team of 25 members.

Preparing WO for BOE Compliance project.

Defined the scope of the project in collaboration with senior management.

Developed a schedule for project completion that effectively allocates the resources to the activities.

Reviewed of WBS plan for all the tracks.

Managed project staff according to the established policies and practices of the organization.

Executed the project according to the project plan.

Reviewed the quality of the work completed with the project team on a regular basis to ensure that it meets the project standards.

Supported Aptitude Team with ETL processing of loading and evaluating of data’s.

Ensured that the project deliverables are on time, within budget and at the required level of quality.

Evaluated the outcomes of the project as established during the planning phase. Weekly Status Meeting with client and Sharing WSR with Senior Management.

Project/Client:

VISA PROCESSING SERVICE

Role/Period:

Project Lead : July 2012 –May-2015

Technology:

Oracle 11g, PL/SQL, Pro*C,JIRA,SVN

Overview:

VPS is processing service part of Visa Inc., providing services in travel card multi-currency product to different clients across the world. The services are Card management processing (Card generation, embossing file generation and SFTP to bank embossing vendor to process the physical cards), UAM module for bank in order to follow the super admin, branch admin, organization admin & users for card inventory, card issuance, branch stocks, product creation managements, Transaction authorization & settlement processing based on VISA & MASTERCARD interchanges rules.

Responsibility:

Conducting regular meeting with development teams.

Assign the task to team members and tracking it as per the project plan.

Finalizing the Design approach for the new change request.

Code Review.

Analyzing the skill gap and provide the training whenever required for the project engineers..

Implementation of DE-DUP Logic for ICICI, HDFC Legacy & Multi Currency System.

Daily Transaction limits Check implementation on ICICI Legacy & Multi Currency System.

UCIC Implementation for HDFC & ICICI.

Project/Client:

CITIBANK - Cheque book stock issuance and Instrument type automation

Role/Period:

Consultant: Mar 2011 –June 2012

Technology:

UNIX, Pro*C, NAPT, Oracle 9i,VSS, Remedy

Overview:

Instrument type is used to identify the physical stationary of the cheque leaf in which the details needs to be printed. The instrument type will be differentiated based on the type of account. Stock is the leaf range allocated to each instrument type. In the earlier system, cheque book request will not be processed if the earlier allocated stock reached its maximum for an instrument type. OPS User has to do a set of process to issue additional stock or if the stock reached its maximum, it will be switched to the next instrument type. This tedious process where we have the high risk of manual errors got removed in the new system. Whenever the stock is going to lapse, the system will automatically switch to the next instrument type and provides hands off to the set of tables/process where the same will be referred during the cheque clearing process. For the system through which the bulk cheque book issuance is done (like for corporate), different process of automation is done.

Responsibility:

Studying the existing manual set of process which the OPS is doing

Designing & coding the new system by interacting with the corresponding operations unit with no more manual intervention.

Project/Client:

CITIBANK - Corporate to Retail conversion

Role/Period:

Consultant: Jan 2010 –Feb 2011

Technology:

UNIX, Pro*C, NAPT, Oracle 9i, VSS,Remedy

Overview

Corporate salary accounts will be converted to retail accounts if salary hasn’t got credited for continuous three months. Corporate account is a zero balance account and for retail accounts, minimum balance has to be maintained. The duration of conversion will differ based on many parameters. The conversion process was done manually through standalone conversion programs based on the dump provided by the product team in the earlier system. This process is automated for the accounts for which salary credit was not happened and also based on the docs submitted by the customer. There are only few documents which can be considered for having the corporate accounts. The process involves sending appropriate communication to the customer on 60th, 90th & 120th day (day difference from the last salary credit date). The conversion will take place at any point of time in the above mentioned period based on the document submitted by the customer and also based on the Net Relationship Value (NRV) the customer is holding with the bank. Customer will be communicated once his account got converted into retail.

Responsibility:

Analyzing the existing process

Coding the entire enhancement

Project/Client:

CITIBANK - ATM Euronet settlement reconciliation revamp

Role/Period:

Associate Consultant: Mar 2008 –Jan 2010

Technology:

UNIX, Pro*C, NAPT, Oracle 9i,VSS,Remedy

Overview:

Whenever other bank customer transacts in CITIBANK ATM or CITIBANK customer transacts in other bank’s ATM, the settlement will be done through Euronet network. Other bank’s card will be identified by the card BIN number (which is the first 6 digit of the card number). Electronic Journal (EJ) and customer Finance are the proofs for offus customer and onus customer respectively from bank side. Euronet will provide a file for the transactions happened by the onus customer in offus ATM and offus customer in onus ATM. Each entries of the file will be validated against the EJ for the customer finance and if they tally both will be knocked off and settlement will be done to Euronet. The exceptions will be thrown for user intervention to figure out the reason for the exception and those will be sent back to the Euronet for re-verification and re-validation and the process continues until the transaction amount is settled.

Responsibility:

Designing the new approach for Automation.

Interacted with Euronet team to identify the gaps and finalizing the file structures.

Sole responsibility to close all milestones and deliver the project on time.

Taken care of all the reconciliation and settlement and exceptions issues

Provide the resolution entries which were required for other reconciliation.

Contact this candidate