Name : SaravanaKumar Sivanandan (Kumar)

Mob : 469-***-****

Email : acuxh8@r.postjobfree.com

Location : Dallas, Texas, USA

PROFESSIONAL SUMMARY

*) 12+ years of overall IT experience. Extensive experience in complete Software Development Life Cycle.

*) Hands on experience in Installation, configuration and Maintenance of Hadoop ecosystems like HDFS, YARN/MRV2, Hive, Pig, Zookeeper, HBase, Oozie, Sqoop, Hue, Flume and Spark.

*) Experience in administering Hadoop clusters using Cloudera Manager including activities like deploy Hadoop cluster, add/remove services, add/remove nodes, keep track of jobs, monitor critical parts of the cluster, configure name-node high availability and schedule.

*) In depth knowledge and good understanding of Hadoop daemons: NameNode, DataNode, Secondary NameNode, Resource Manager, Node Manager and High Availability

*) Hands on experience in Linux (RedHat), Unix, Amazon web service (AWS), Teradata, Oracle PLSQL and MySQL.

*) Provided support to development team to trouble shoot issues and performance tuning

*) Good Knowledge on shell scripting

*) Experience in administration & development activities of RDBMS data bases, such as Teradata, Oracle and MySQL

*) Extensive experience in the following domains: Banking (JPMorgan Chase and Keybank), Telecom (Frontier Communication and British Telecom), Market Analysis (AC Nielsen), Bio-pharmaceutical (Amgen)

EDUCATION DETAILS

*) Holds a Master degree in Computer Science (MCA - Master of Computer Application). Year of passing 2002

*) Holds a Bachelor degree in Computer Science (Bsc Computer science). Year of passing 1999

CERTIFICATIONS

*) Cloudera Certified Administrator for Apache Hadoop (CCAH). Year of passing Apr-2016

*) Teradata 12 Certified Professional. Year of passing Nov-2013

*) Oracle Certified Associate (OCA) – Oracle PL/SQL Developer Certified Associate. Year of passing 2007

TECHNICAL EXPERTISE

*) Hadoop Eco systems: HDFS, YARN/MRV2, Hive, Pig, Zookeeper, HBase, Oozie, Sqoop, Flume, Spark

*) Hadoop Management tool: Cloudera Manager (CM)

*) Hadoop Web Interface: Hue

*) RDBMS Tool: Teradata, Oracle PLSQL, SQL, MySQL

*) Operating System: Linux (RedHat), Unix, Ubuntu

*) Web Server: Amazon Web Server (AWS)

EMPLOYMENT HISTORY

SNW Infotech Inc (Frontier Communication, Dallas, TX) : From Nov-2015 - till date

Cognizant Technology Solution (Chase Bank, Dallas, TX): From Sep-2011 to Oct-2015

Cognizant Technology Solution (For various clients from India): From Jul-2008 to Sep-2011

CMC Limited (ACNielsen): From Aug-2005 to Jul-2008

A&S Software Technology (Amgen): From Apr-2005 to Jul-2005

Nivetha Software Services (Ramco Systems): From Jul-2004 to Mar-2005

KGM Softwares private limited: From May-2003 to Feb-2004

1.PROJECT PROFILE: Verizon Wireline to Frontier Conversion (VZ3 Conversion)

Client

Frontier Communication, TX, USA

Duration

Nov-2015 to till date

Role

Hadoop Admin

Technology

Cloudera Manager, HDFS, YARN/MRV2, Hive, Pig, Zookeeper, Oozie, Sqoop, Flume, Spark, Hue, Teradata and MySQL

Operating System

Linux (RedHat)

Employer

SNW Infotech Inc

Work Location

TX, USA

PROJECT DESCRIPTION:

Frontier acquires Verizon's wireline operations that provide services to residential, commercial and wholesale customers in California, Florida and Texas. These Verizon properties include 3.7 million voice connections, 2.2 million broadband connections, and 1.2 million FiOS video connections. The network being acquired is the product of substantial capital investments by Verizon and is 54 percent FiOS enabled.

ROLES AND RESPONSIBILITIES:

Installation, configuration and Maintenance of Hadoop Cluster, Cluster Monitoring, Troubleshooting and Transform data from RDBMS to HDFS.

Add/remove services, add/remove nodes, keep track of jobs, monitor critical parts of the cluster, configure name-node high availability using Cloudera Manager

Managing and reviewing Hadoop log files.

HDFS support and maintenance, disk space management

Monitor Hadoop cluster connectivity and security

File system management and monitoring

2.PROJECT PROFILE: MB-Default Management

Client

JPMorgan Chase, TX, USA

Business Area

Mortgage Banking - Default Data Management, Sub-serving, Mortgage Express

Duration

Feb-2013 to Oct-2015

Role

Hadoop Admin

Technology

HDFS, MapReduce, YARN, Hive, Pig, Zookeeper, HBase, Oozie, Sqoop, Teradata, Oracle, AWS and Cloudera Manager

Operating System

Linux (RedHat)

Employer

Cognizant Technology Solution (CTS)

Work Location

Lewisville, TX

PROJECT DESCRIPTION:

JP Morgan Chase has initiated Default Management Information Services data repository facilitating Default & Credit Risk related reports. Currently it supports external reporting to Treasury and other government agencies, Management Information Services, Default, Executive and Loan Modification related reporting using ICDW. ICDW is a Customer-Centric Business Analytics Platform that offers a customer-focused approach to analytic reporting by creating a centralized repository of consumer data (Consumer, Card and Commercial) that arrives from a documented, corporate-wide data model that is transparent and meets regulatory requirements. Also ICDW leveraging a leading technology platform (Teradata) and architecture that are recognized by the industry for stability and reliability

ROLES AND RESPONSIBILITIES:

Administering Hadoop clusters using Cloudera Manager including activities like deploy Hadoop cluster, add/remove services, add/remove nodes, keep track of jobs, monitor critical parts of the cluster, configure name-node high availability and schedule.

Maintenance, Production support, incident/change management, service request management, Troubleshooting and Transform data between RDBMS and HDFS.

Performed data completeness, correctness, data transformation and data quality testing using SQL

Managing, reviewing Hadoop log files. Performance support to Developers

3.PROJECT PROFILE: MB-Default Management

Client

JPMorgan Chase, TX, USA

Business Area

Mortgage Banking - Default Data Management, Sub-serving, Mortgage Express

Duration

Sept-2011 to Jan-2013

Role

Senior Database Administrator

Operating system

Linux, Windows

Database

Teradata, Oracle 11g

Employer

Cognizant Technology Solution (CTS)

Work Location

Lewisville, TX, USA 75063

PROJECT DESCRIPTION:

JP Morgan Chase has initiated Default Management Information Services data repository facilitating Default & Credit Risk related reports. Currently it supports external reporting to Treasury and other government agencies, Management Information Services, Default, Executive and Loan Modification related reporting using ICDW. ICDW is a Customer-Centric Business Analytics Platform that offers a customer-focused approach to analytic reporting by creating a centralized repository of consumer data (Consumer, Card and Commercial) that arrives from a documented, corporate-wide data model that is transparent and meets regulatory requirements. Also ICDW leveraging a leading technology platform (Teradata) and architecture that are recognized by the industry for stability and reliability

ROLES AND RESPONSIBILITIES:

Design and implementation of Teradata Data Marts Creation and monitoring of ETL workload to ensure data consistency and availability

Data base migration from Oracle to Teradata ICDW.

Create users, structures, databases, granting access. Creation, management, and alteration of database objects in both production and development environments

Monitoring and turning of Database Objects to deliver optimal performance

Implementation of database backup, recovery, and disaster recovery procedures. Daily review of database change reports

Supported development team for better performance

4.PROJECT PROFILE: IB-Data Manipulation Application (DMA)

Client

JPMorgan Chase, NY, USA

Business Area

Investment Banking, DMA - Requirements Analysis

Duration

Jul-2010 to Sept-2011

Role

Oracle PLSQL developer, Data analyst/Technical Business Analyst

Technology

Oracle, Flex, J2EE- Spring, hibernate, SVN Version Manager, Tableau

Operating System

Unix, Windows

Employer

Cognizant Technology Solution (CTS)

Work Location

CTS, Chennai, India

PROJECT DESCRIPTION:

Data Manipulation Application (DMA) is a web based software application for JPMC’s Investment Banking back office division for performing adjustments on Trades that are executed by JPMC’s Investment banking and brokerage division. These trades flows downstream to DMA from middle office risk management (upstream) systems. By performing adjustments, Trades can be enriched and made ready for the IB Front office client profitability systems for preparing business critical reports. Prior to DMA, trade adjustments were performed using two standalone applications for Equity trades and Credit and Rates trades separately, which had many redundancies and operational inefficiencies. The new DMA will replace the two applications into one single application which provides many advanced features and it’s more efficient that the predecessors. Though DMA’s main purpose is to adjust the existing trades in the warehouse, this can also be used for creating trades, dashboard reports and many more value added services.

ROLES AND RESPONSIBILITIES:

Gather the input from Onsite coordinator

Analysis, Design, Development the PLSQL packages, stored procedures and functions.

Co-ordinate with J2EE resources to connect PLSQL code with Flex

Preparation of test cases and Unit test the code in order to meet the actual requirement. Defect fix

5.PROJECT PROFILE: Keybank-Anti Money Laundering (Mantas AML)

Client

Keybank, Ohio, USA

Business Area

Banking – (Mantas) Anti Money Laundering (AML), Know your customer

Duration

Jul-2008 to Jul-2010

Role

Maintenance and Enhancement of the project using PLSQL and Unix. Team lead

Technology

Oracle, PLSQL, Mainframe - TWS, Serina Version Manager

Operating System

Unix

Employer

Cognizant Technology Solution (CTS)

Work Location

CTS, Chennai, India

PROJECT DESCRIPTION:

Key companies provide investment management, retail and commercial banking, consumer finance, and investment banking products and services to individuals and companies throughout the United States and, for certain businesses, internationally. Know your Customer is the international benchmark for framing Anti Money Laundering and combating financing of terrorism policies.

ROLES AND RESPONSIBILITIES:

Maintenance and Enhancement of (Mantas) Anti Money Laundering project using PLSQL and Unix Sheel scripts

Understand the requirement for the enhancement. Involved in PLSQL, Unix shell development to meet the requirement.

Developed automation tools as part of customization.

Involved in Disaster recovery exercise

Support for weekly, bi-weekly and monthly jobs

.

6.PROJECT PROFILE: AC Nielsen – Phoenix Custom application

Client

AC Nielsen, USA

Business Area

Market research

Duration

Oct-2006 to Jul-2008 (21 months)

Role

Maintenance and Enhancement of the project using SQL Server (DTS) packages, PLSQL packages. Team lead

Technology

Oracle 9i - PLSQL, SQL Server 2000, Data Transformation Services (DTS), Winbatch

Operating System

Unix, Windows

Employer

Computer Maintenance Corporation Limited (CMC Limited), Consulting to Tata Consultancy Services (TCS)

Work Location

TCS, Chennai, India

PROJECT DESCRIPTION:

The AC Nielsen - Core application allows all levels of Trade Dimensions users to query and dynamically provide new/updated information to the clients in support of standard Business Operations. This can be visualized as a sub-set of the Data Collection & Verification System. Also it provides custom outputs to meet the requirements of a specific group of the clients of Trade Dimensions.

ROLES AND RESPONSIBILITIES:

Develop the SQL Server DTS packages, Enhance the existing packages for any requirement change

Customize and Automate all the manual work

Code walk through and performance tuning.

Preparation of Test cases and unit testing the code in order to meet the actual requirement.

Support for integration and Implementation

Support for Weekly, bi-weekly and monthly jobs.

7.PROJECT PROFILE: BT – Line Share Automation (LiSA)

Client

British Telecom, UK

Business Area

Telecom, BT – Line Share Automation (LiSA)

Duration

Aug-2005 to Oct-2006 (14 months)

Role

Oracle PLSQL, UNIX developer

Technology

Oracle 9i, PL/SQL, UNIX

Employer

Computer Maintenance Corporation Limited (CMC Limited), Consulting to Tata Consultancy Services (TCS)

Work Location

TCS, Chennai, India

PROJECT DESCRIPTION:

BT-LiSA (Line Share Automation) is primarily being developed to automate the manual process that are currently in practice for provisioning various types of SMPF(Shared Metallic Path Facility) orders on CSS(Customer Support System) which is an order management system for BT.

ROLES AND RESPONSIBILITIES:

Gathering the requirement from business analyst.

Develop Package, Stored Procedure, Function based on the requirement

Code review and performance tuning

Test cases preparation. Unit testing the code in order to meet the actual requirement and deployment.

Partially involved in deployment support using Unix

8. PROJECT PROFILE: Amgen POQIS

Client

Amgen POQIS, USA

Business Area

Bio-pharmaceutical

Duration

Apr-2005 to Jul-2005 (4 months)

Role

Oracle PLSQL developer, Support for Dot net coding and UI Design

Technology

Oracle 9i, PL/SQL, Dot net and Dream weaver 4.0

Employer

Consulting to Cognizant Technology Solution (CTS)

Work Location

CTS, Chennai, India

PROJECT DESCRIPTION:

The Software Project is related to maintain data related to various Projects handled by Amgen. This project used to handle Project Details, Project Schedule, Resource Allocation, Project Cost & Benefit, Monthly update and Report. The Software was developed using ASP.Net, C# as Front end and Oracle as back end.

ROLES AND RESPONSIBILITIES:

Writing back end Procedures, Packages in Oracle 9i, PL/SQL

Partially involved in Dot net coding and UI Design.

Code walk through and Performance tuning.

Unit testing the code in order to meet the actual requirement.

9. PROJECT PROFILE: Aviation - OraTrace

Client

Petroleum Helicopters Inc., USA

Business Area

Aviation

Duration

Jul-2004 to Mar-2005 (9 months)

Role

SQL Server, PLSQL Developer

Technology

SQL Server, Oracle 8i PLSQL Developer and RVM tool

Employer

Nivetha Software services & Consultants (Consultant for Ramco Systems)

Work Location

Ramco Systems, Chennai, India

PROJECT DESCRIPTION:

Ramco Aviation offers Enterprise Asset Management functionality specifically to support the critical needs of airlines. Ramco Aviation helps to reduce overhead costs, manage inventory, increase airplane availability and improve your overall business processes.

ROLES AND RESPONSIBILITIES:

Front end designing using RVW tool.

SQL Server, Oracle 8i PLSQL Development

Implementing, integrating and unit testing the code in order to meet the actual requirement.

Providing support to the testing team to understand the requirement for testing.

Deployment support

10. PROJECT PROFILE: Petrol bunk kit

Client

KGM Softwares, Domestic product, India

Duration

May-2003 to Feb-2004 (10 months)

Role

Visual Basic, MS-Access SQL Developer

Technology

Visual basic, MS-Access SQL

Employer

KGM Softwares

Work Location

KGM Softwares, Erode, Coimbatore, India

PROJECT DESCRIPTION:

The main objective of the Product is to computerize the petrol bunk activities such as Purchase, Sales, Item Maintenance, Pump, Tank, Dip chart, Daily & Monthly stock Report, Ledger Maintenance, Vehicle, Outstanding Details, Daily, Weekly, Monthly Statements Details, Reports, Basic Accounts entry, Export & Import Options, Updating to accounts software and so on.

ROLES AND RESPONSIBILITIES:

Requirement gathering from the clients.

Writing VB codes and SQL queries to meet the actual requirement and unit testing

Providing support to the testing team to understand the requirement for testing.

Contact this candidate