Email : ************@*****.*** Contact : 551-***-****
RANJITH S NAIR
Assistant Consultant, Tata Consultancy Services Ltd, Email : ************@*****.***, Contact : 551-***-****
Efficient, customer-focused, and solutions-driven Production/Application Services Technical Lead with
8 years’ senior level experience.
KEY QUALIFICATIONS
• Successfully managing project team (15+ members) and known for high-quality production
services that meets client requirements/targets for over 4 years
• Strong (5+) Shell Scripting skills using sh, ksh and bash in Sun OS UNIX and GNU Linux
platforms
• Strong (5+) skills in debugging, analytical and development of PL/SQL procedures, triggers and
functions
• Good understanding of Capital Markets (Fixed Income, Equities, Futures and Derivatives) and
Life-Cycle of a Trade.
• ITIL Certified and strong (5+) Incident, Change and Problem Management experience
CAREER EXPERIENCE
Tata Consultancy Services Ltd Jersey City, NJ Sep 2006 – Present
Clients worked with :
Deutsche Bank (Banking & Finance) Jersey City, NJ Oct 2010 – Present
Key Responsibilities :
• Project Management and Production Support Lead (L2/L3) for middle office Trade Life Cycle
(TLC) applications for Fixed Income trades in US and Equity trades in Europe.
• Pro-actively analyze manual activities within the application framework and provided automation
solutions using SH, KSH and BASH scripts (Sun OS Unix and GNU Linux platforms).
• Analysis and support maintenance of PL/SQL stored procedures, functions and triggers.
• Analyze data processing problems, high severity production issues using Fault Tree Analytic (FTA)
approach
• Planning, Management and Co-Ordination of BCP/DR exercise within the organization.
• Lead Operational Acceptance Testing (OAT) phase and review test cases for every application code
release into production.
• Management and Administration of Oracle Golden-Gate replication technology and Composite
Software (CIS) Web Manager on Exadata V2 machines.
• Administration of IBM Websphere MQ instance installed across all application servers.
• Management of Incidents, Change Requests and Problem Tickets using ITIL best practices and BMC
Remedy tool.
Motorola Inc (Telecommunication) Schaumberg IL, Sep 2006 – Aug 2010
1
For internal use only
Chennai, India
Key Responsibilities :
• 9i,10g, 11g standalone and RAC database administration functionalities.
• Database Installation, Backup Strategy Management (Hot and Cold backups), User and Space
Management of 10g and 11g stand-alone databases on unix / windows servers.
• DR setup for 11g production database on unix / windows server and DataGuard switchover/switchback
between 11g physical and standby.
• Database cloning (10g and 11g) using RMAN in windows platform.
• Scheduling RMAN database backups(daily/weekly) through Enterprise manager in windows servers
and maintaining database security by means of roles &privileges.
• Monitoring the performance (using dynamic performance views at peak load) of databases.
• Investigate performance issues with the database using Hang Analyze and OEM-AWR reports.
Key Projects :
• Centralized Trade Manager - CTM (Oct 2010 - Present) : Trade confirmation and allocation application
for Fixed Income and Equity Block Trades (US and Europe).
• MOTCORP OASES - Database solutions ( Sep 2006 – Aug 2010) : support solutions for production,
development and testing databases (9i,10g,11g) in Motorola Inc.
Training and Certifications :
• Oracle Training Completed : EM11 Real Application Testing (1 day)
• Oracle Training : Exadata V2 workshop (1 day)
• May 2011: Awarded ‘TCS Star of the Quarter’ for initiatives in Project CTM
• Jun 2012 : Completed TCS Flagship leadership program ‘PathFinders’ (3 days)
• Apr 2009 : Awarded ‘TCS Star of the Month’ for best performing DBA in Telecom Domain
• Jan 2008 : Awarded ‘Bravo Motorola Best Performer’ programmer analyst
• ITIL v3 certified
TECHNOLOGY
Programming Languages : Shell Scripts, PL-SQL, Oracle Golden Gate, Java, Erlang
Tools Used : Toad v10, SQL developer, JAVA Eclipse, ITRS-Geneos, BMC Remedy,
Control-M, UNIX-Cron
Operating Systems : Sun-Solaris Unix, GNU Linux, Windows (XP, Win7)
EDUCATION
Jul 2002 – Aug 2006
University of Calicut, Kerala, India
• Bachelor of Technology – Electrical and Electronics Engineering
For internal use only