senior software engineer,skills unix,oracle,sql,pl/sql

SRIKANTH YALLAGONDLA

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

Mobile : +91-801*******

Career Objective:

To contribute considerably in success of corporate world and acquire technical and managerial knowledge and to become an indispensable resource, enhance the existing knowledge base & competency levels and to perform my responsibilities with sincerity.

Summary:

Around 3 years of experience in Application-Maintenance, Production-support and Script enhancement in a reputed Indian IT company Using Unix and Oracle11g\10g\9i SQL programming.

Good team player with leadership capabilities. Having good team management skills, communication skills, client interaction skills.

Extensive experience as Support and maintenance Engineer by utilizing PL/SQL Procedures, Functions, Packages, Triggers and also involved in Data Extraction from database as per the user requirements.

Knowledge about Investment Banking Concepts as result of supporting a Custodian application belonging to a reputed European Bank.

Thorough interaction with the customer as well as onsite coordinators keeping the business scenario in mind and successfully delivering the deliverables on time with utmost customer satisfaction. Strong attitude and work ethics are few of the strong points besides technical knowledge.

Knowledge of various ITSM and ASM-RTB processes in relation to Production Life-Cycle (Problem and Incident Management)

Professional Summary:

Working as L2.5 level in Application Support and maintenance.

Provide back-end support to applications by checking the front end functionality as per the client/user requirements.

Monitoring production server, troubleshooting.

Monitoring and resolving the P1/P2/P3 tickets on ticketing tool ServiceNow.

Regularly attend & resolve the issues such as application outage, Issue impacting multiple users, Revenue impacting key function issues in the Crisis call.

Enjoy new challenges and willing to take an extra responsibility to get work done.

An excellent communicator coupled with interpersonal skills

Good performer both in team and independent environment.

Accolades & Certifications:

Received several appreciation mails from client and end users.

RTB (HCL Internal Certification)

Received an innovation award from the HCL.

Technical Skills:

● Technical Skills : UNIX BASICS, SQL

● Operating Systems : UNIX, Windows.

● Database : Oracle11g\10g.

● Tools & Platforms : Putty, Control-M, Geneos, SQL Developer, Service Now. Winscp

Academic Credential:

● Completed Masters in Computer application from Vivekananda P.G College, secunderabad in the year 2016.

Project Handled:

Project#1 : Deutsche Bank_RMW

Company : HCL Technologies Limited

Client : Deutsche Bank

Project Name : RMW (Risk Management Workstation)

Environment : AIX Unix, ORACLE 10g,

Tools : Control-M, Service Now, Geneos, SQL Developer

Duration : DEC’17 - till date

Role : Software Engineer

Job Profile : L2.5 Support (S.M.E)

Location : Frankfurt (onsite position for client)

Description:

Risk Management Workstation (RMW) is the main Agency Lending system. It brings together data from several third party systems and provides a common user interface. Amongst other functionality, RMW provides trade capture, settlement functions, cash management, position management and reporting functionality.

Global One Enterprise All is a vendor product to support securities lending in Europe and USA

System function is to cater to Settlements, Corporate Actions Disbursement, Client reporting and Regulatory reporting.

MQ used for SWIFT message transmission and reception.

Scheduled jobs are set up through Control-M (and cron tabs wherever appropriate)

Roles and Responsibilities:

● Incidents and Request Handling

● Script Enhancement

● Application Administration

To ascertain The MQ queues and Channels are running

To supervise Intraday Online Jobs (Cron / Cyclic Jobs in Control-M) and Overnight EOD Batch jobs and take corrective action in case of failures

To Bring down and Bring up the application processes for Unix Admin team to perform Server related tasks

To Publish Control-M Job XMLs

To Make sure all Upstream and Downstream Interfaces are connected and act in case of any feed failures or other Ad Hoc Requests. Sharing Public keys and adding other interface's Public keys to Application's Authorized keys

To perform Annual BCP Testing on each of the 3 Prod-DR Pair on which the application is running

Taking Stock of Disk Space in all 3 Prod-DR Pair and provide briefing to DB Counterparts on criticality for each and requisition for additional space

To enable and support Ad-Hoc Extra ordinary trading days for certain branches usually Saturdays

To Set up New Business Branches

To Cooperate with Unix Admin Teams to jointly achieve assigned objectives for activities like Storage Migration and Tech Refresh tasks

To restore and re enable branch data and processes in case of an accidental data wipeout

● Problem Management and Resolution

● Change Management

Raising Standard and Normal changes for release purpose and database migration

Implementing the change and verify

Project#2 : Client Service System (CSS-Main)Deutsche Bank-GBIT

Client : Deutsche Bank, Frankfurt, Germany

Period : NOV’16 - NOV’17

Technologies : Oracle 11g (PL/SQL), UNIX

Tool : SQL Developer, CSS APP,DAP Portal

Role : Production Support

Job Profile : L2 Support

Team size : 4

Description:

Client Service System(CSS) is a ticketing tool used by Deutsche Bank users to attend the client requests, it contains payment details which is via email, document generations and other client Queries. CSS is a case management app for service, documentation,operations, electronic Banking support departments with main Business Lines in CSS i.e. CMC.GSS.TF. Each business Line contains tickets with mailing functionality and different teams having ‘Common Actions.

Common Actions - Documents upload,follow up,transfer,match and merge,Tickler and complete.

Roles and Responsibilities:

Executing the technical requests of Front End customers

Monitoring & resolving the tickets in our queue according to their priority.

Tracking log files and monitoring the growth of log files.

Monitoring Server health checkups and fixing the errors.

Monitoring the database in production environment.

Extracting data from production databases as per user request.

Status reporting on weekly and monthly basis.

Working on 24*5 supports.

Working in Release activities coordinating with the SA and DBA.

Escalate to L3 if necessary and coordinate with them.

To do technical monitoring, to identify the messages failed for technical cause.

Production incident/problem investigation, root cause analysis and resolution.

Transition to the new members about the projects and Domain Knowledge.

Overall Roles and Responsibility:

Having around 3+ years of IT experience in ORACLE,UNIX on development and production support.

Handling client calls from different zones.

Working in Production support with fixing the issues.

Good knowledge in UNIX and SQL and PLSQL Scripts.

Involved in implementations & Supporting Projects of BANK Applications. Implementing any changes in an application (Oracle Script) required as per requirement.

Personal Traits:

● Quick Learner

● Goal Oriented

● Dynamic and Hardworking

● Good in Team Work

DECLARATION:

I hereby declare that all the details given above are true to the best of my knowledge and belief.

Place: Bangalore Srikanth Yallagondla.

Contact this candidate