Technical support Analyst

Karthikeyan Mohan

IT Analyst

PERSONAL DATA

Address : ***/*, ******** ********** **,

Namakkal – 637001

Mobile : +91-830*******

Email Id : *******.********@*****.***

TECHNICAL SKILLS

Windows 98/7/10, Unix

Oracle 10g, PL/SQL

Unix shell scripting, Python

HTML, Core Java, JSP & Servlet, J2EE,

Spring

AWS Cloud Computing (Amazon)

Tools

Autosys, SmartStream TLM,

Recon Trade/Frontier, Aqua data

Studio, Service now, JIRA, Eclipse

Webserver

Apache Tomcat

KEY SKILLS

Proactive and Responsible

Flexibly adaptive to work

environment

Quick in learning new technologies

Punctual and meeting deadlines

Multi-tasking and excellent

coordination

LANGUAGES

English, Tamil

Experienced application and technical batch support professional over 6 years experience seeking for opportunity in a renowned company for a job position with a challenging role where I can utilize my skills in understanding the process to support the growth of the organization and myself personally and professionally

EXPERIENCE SUMMARY

Has over 7 years of experience in IT industry with strong knowledge in the software development life cycle concepts and expertise working skill in design, implementation, code fixing, application maintenance and batch support

Having strong knowledge in support process and concept

Experienced in developing stored procedures, Triggers, Cursors, Joins, Views on databases oracle 10g/11g

Having extensive working skills in support and maintenance of UNIX shell scripting and ORACLE

Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures

Has strong analytical and communication skill both oral and verbal

Experience in preparing monthly metrics

Proficient in analyzing and translating business requirements to technical requirements

Having quick ability to acquire additional skills required to complete the task before deadline

Having excellent skill in problem solving and wide interest in exploring and learning new technologies

CAREER SUMMARY

Employer : Tata Consultancy Services

Designation : IT Analyst

Service Period : 2008 – 2016

Competencies : Amazon Web Service ( AWS ) Course,

(Break) Python, JSP & Servlet, Spring Java

Duration : 2016 – 2017

PROJECTS WORKED

CITI-GRU Smartstream TLM Reconciliation

CITI-GRU Recon trade/frontier Reconciliation

ITRS-Geneos monitoring and implementation

CITI-DoS US visa collection maintenance

PROJECT SUMMARY

1. CITI-GRU Smartstream TLM Reconciliation

Duration : 2013 – 2016

Client : CITI BANK – GRU ( Global Reconciliation Utility) Operating System : Windows XP, Unix

Tools Used : Autosys, DMW ( Data Mapping Wizard), Quickrec Product Used : Smart Stream TLM ( Transaction Lifecycle Management) Programming Languages : Unix Shell Scripting

Database : Oracle

Role : L2/L3 Maintenance and Support

Project Description

Reconciliation is growing process with wide scope adopted by many top banks in their trading system. SmartStream TLM is a reconciliation tool used by Citi bank for performing their daily reconciliation of trading happening within their own banks and to other bank all over globally. TLM has capacity to reconcile billions of transactions in span of few minutes providing end user with outstanding transactions and make their work easier. This project involves the analysis, design, enhancement and production support to middle and back office users of CITIBANK’s reconciliation team using the Smart Stream’s TLM reconciliation tool. Roles and Responsibilities

Coordinate with development team in release activity assisting in deploying jobs in production, migrating scripts, loading fresh data and perform the task listed in the release document

Developed the UNIX scripts for converting one file format to another format

Tune existing database procedures / reports for improved application performance

Enhance / Modify Database procedures as per business requirements

Developed Unix scripts to process feed from upstream systems that needs to be loaded in database

Handling the new requirement of the reports required by the Business

Involved in PL/SQL code review and modification for the development of new requirements

Wrote fine-tuned query and stored procedure to resolve database performance issue

Development of script to move the files between different servers according to business requirements

Automation of manual support tasks using UNIX shell & Database scripts to improve system availability & avoid recurring issues

Coordinate with user for new enhancement in the application and track the same to Development team

Involves actively in user creation in the application, handling issues and Interact with the users to resolve problems, ensure availability of dedicated support group for any issues at any time, Track production problems and follow up with the development team effectively

Monitoring the flow of incoming feeds and escalate to concern upstream system on any delay

Involve in new user id creation, adding/modifying of roles pertain to users, unlocking locked users and importing and refreshing of dashboard to user profile

Assist in new account set up, restoring of old files from backup and provide report on validating the rejected transaction entries to user

Production Support and application performance monitoring and daily/weekly server reboot and service line for all the application under GRU

Perform regular update on overall status for each system in client communication channel, attend status call and update in the daily wellness share point

Initiating weekly support call, status call and production release call

Preparing weekly/monthly volume metric for each system and monitoring the processes for Incident/Problem Management, Change Management and Quality Management

Performed quarterly CDS roll out activity and yearly COB activity coordinating with users

Identifying priorities in consultation with the client and changing the schedule 2. CITI-GRU Recon Trade/Frontier Reconciliation

Duration : 2012 – 2013

Client : CITI BANK – GRU ( Global Reconciliation Utility) Operating System : Windows XP, Unix

Tools Used : Recon Trade/Frontier and Windows Scheduler Programming Languages : Unix Shell Scripting

Database : MySQL, Oracle

Role : L2/L3 Maintenance and Support

Project Description

This project involves in the analysis, design, enhancement and production support to middle and back office users of CITIBANK’s reconciliation team using the Recon Trade/Frontier application. CITIBANK incorporates this tool globally for handling reconciliations of all transactions with in and with other banks. Mostly it focused on the customers in EMEA, APAC and NAM regions

Roles and Responsibilities

Daily job monitoring in scheduler, new job creation, rescheduling, pausing and releasing jobs and terminating long running jobs

Perform daily status of each system and update user on its availability

Coordinate with user for new enhancement in the application and track the same to Development team.

Performed quarterly CDS roll out activity and yearly COB activity coordinating with users

Assist users in providing access, adding new roles, modifying existing profiles and unlocking user id through clearing bindery entries

Identifying priorities in consultation with the client and changing the schedule

Perform weekly server reboots and service line bouncing and monitor the system stability and disk space usage 3. ITRS-Geneos monitoring and implementation

Duration : 2011 – 2012

Client : CITI BANK – GRU ( Global Reconciliation Utility) Operating System : Windows XP, Unix

Tools Used : ITRS Geneos

Role : L2/L3 Maintenance and Support

Project Description

ITRS is a tool CITIBANK incorporates in many of their application focusing mainly on tracking system stability and functionality. It enhances system monitoring to higher level and its very feasible to user in handling by delivering accurately the system stability and capturing any system alert. In reconciliation process this tool assist the support assistance in delivering end to end monitoring functionalities towards the whole system such as job execution flow, disk space usage alert, long running process and queries and CPU memory utilisation alert Roles and Responsibilities

Assist in collecting all data required that is essential to be setup for monitoring

Performing validation and refining on the monitoring output for accurate delivering

Composing sql queries used regularly for daily monitoring task for implementing in ITRS for automatic monitoring

Handling alert and fix it and involve the concern team to clear it

Perform daily status of each system and update user on its availability 4. CITI-DoS US visa collection maintenance

Duration : 2011 – 2012

Client : CITI BANK – GRU ( Global Reconciliation Utility) Operating System : Windows XP, Windows Server

Tools Used : Recon Trade/Frontier, Windows Scheduler Role : L2/L3 Maintenance and Support

Project Description

DoS US visa fee collection system is CITIBANK highly senstive project providing service to client like CSC and CGI for countries throughout the world for over 65 partner banks. CITI bank collects all the visa payments of applicants applied from different partner banks throughout the world through feeds flowing intraday and in end of day and send the clients the valid credit payment entries for their validation Roles and Responsibilities

Perform regular check in the flow of intraday and EOD payment file, contact partner bank in case of missing file and monitor the flow of generated handoff to clients

Prepare hourly hand off count report and share internally to team

Response to user query on the missing payments and duplicate payments

Generate monthly billing volume count for country wise and the monthly hand off file and share it to clients EDUCATION QUALIFICATION

B.Tech

Course : Bio-informatics

Institution : Vellore Institute of Technology

Year : 2004 – 2008

Percentage : 8.64 (CGPA)

Higher Secondary ( XII )

Institution : NKMHS School

Year : 2003 – 2004

Percentage : 91.3 %

Higher Secondary ( X )

Institution : NKMHS School

Year : 2001 – 2002

Percentage : 86.4 %

AWS ( AMAZON WEB SERVICE ) KNOWLEDGE

Simple Storage Service (S3)

Creation, managing and deletion of buckets and storing of objects

Modifying bucket and object properties

Creation of bucket policies and controlling of its access

Enabling versioning and life cycle for object

Static website hosting

Elastic Compute Cloud (EC2)

Launching, stop and terminating EC2 instance

Attaching Elastic Block Store and scale up or down the volume of running instance

Attach and detach Elastic IP address to and from EC2 instance

Snap shot creation of EC2 volume

Control traffic via managing ports in security groups

Load Balancer and Auto scaling

Creation of Launch configuration with AMI

Creation of Auto scaling group

Testing auto scaling group with online load testing tool

Virtual Private Cloud ( VPC )

Creation of Public and Private subnet and assigning ip address

Creation of Routing table

Creation of Internet gateway

Creation of NAT gateway

Identity and Access Management ( IAM )

Creating Users and Groups

Creating Custom policies

Managing the access to users to various AWS services using custom policies

Creating Roles and assign to Users

Increase the security through enabling MFA ( Multi Factor Authentication )

Database services

Launching RDS ( Relational Database Service ) instance

Creating Dynamo DB instance

Other Services

Cloud Watch - Configuring alarm to notify on volume spike, traffic load

Route 53 - Configure Domain name to Static website hosted in S3 bucket

Cloud Formation - Creating template and stack to take care of provisioning different aws resources

Content Delivery Network ( CDN ) - Creating the distribution across globally on all edge location to minimize the latency in accessing the data

Elastic Bean Stalk, Simple notification service ( SNS ), Simple Queue Service ( SQS ), Simple Email Service ( SES )

DECLARATION

I hereby confirm that the above furnished information are true to my knowledge

Contact this candidate