Application support analyst
Resume:
D.CHANDRA SHEKHER
E-mail:
***********@*****.***
Summary
. Excellent experience in Investment banking as Application Support
Analyst.
. Technical expertise in supporting Mission Critical trading applications
in major Investment banks (Credit Suisse, UBS) in Singapore.
. Certified ITILv3 Foundation Course.
. Good domain knowledge of Investment banking.
. Good working knowledge on Trade Life Cycle, Equity, Fixed Income, FX,
Derivative instruments.
. Good working knowledge on FIX Protocol.
. Good working knowledge on messaging middleware technologies IBM MQ.
. Excellent knowledge and working experience in UNIX, Shell scripting and
Perl scripting.
. Excellent knowledge and working experience in Oracle, Sybase databases.
. Excellent working experience in Oracle PL/SQL Programming, Stored
procedures, functions, packages and triggers.
. Good working experience in supporting multitier (Java) applications.
. Excellent working experience in ETL tool Informatica Power Centre, SQL
Loader and Data warehouse.
. Technical expertise in customized scripts to automate the monitoring
which helps to identify and mitigate the risks with capacity and
eliminates manual intervention.
. Excellent working experience in gathering requirements, design (High
level and Low level), coding, unit testing and system integration.
. Good working experience in Incident Management, Problem Management,
Release Management, Configuration Management.
. Good working experience on SDLC processes.
. Excellent Client Interaction, written and verbal communication skills.
Experience (9 years 4months)
. Currently working as Software Technical Consultant in Origem Solutions
Pvt. Ltd, Singapore since July 2011.
. Worked as Software Development Advisor in DELL Perot Systems, India
from Nov 2005 - June 2011.
. Worked as Software Engineer in Global Energy Consulting Engineers Ltd,
India from June 2004 - Nov 2005.
Technical Profile
Programming Languages : C, C++, Java, Pro *C, SQL, PL/SQL, T-SQL
Scripting Languages : UNIX Shell scripting, Perl,
AWK, SED
Database : Oracle 11g, Sybase 12.5,
SQL Server 2008
Operating Systems : UNIX (Solaris 10), Linux,
Windows 7
Tools : Toad 9.2, SQL
Developer, PL/SQL Developer, ITSM Remedy Management
tool, HP Quality Centre, Business Objects, MQ Series
Application servers : Web logic
ETL Tools : Informatica Power
Centre 8.6.1
Scheduler Tools : Autosys, Control-M
Source Control : CVS, SVN
Web Technologies : HTML, XML
Education
Level Name of the Institution % of marks
obtained
M.Tech, Power NATIONAL INSTITUTE OF TECHNOLOGY 80.34
Systems (Deemed University), Warangal,
Engineering (INDIA)
(Formerly known as REC)
B.Tech, Electrical JAWAHARLAL NEHRU TECHNOLOGICAL 80.88
and Electronics UNIVERSITY College of Engineering
Engineering (Autonomous), Kakinada, (INDIA)
Intermediate Govt. Jr. College of Boys, Kakinada 79.10
(10+2) (INDIA)
S.S.C (10th Std.) M.S.N. English Medium High School, 81.91
Kakinada (INDIA)
Achievements and Awards
. Awarded Associate excellence performance award for outstanding
contribution in the USA client project in Dell Perot systems
organization for the year 2009.
. Stood as Topper of the batch in Bachelors of Technology (Electrical
and Electronics Engineering).
. Awarded "Best Outgoing Student" in Bachelors of Technology.
. Obtained 96.1 percentile in GATE-2002 conducted by Indian Institute of
Science, Bangalore, INDIA.
. Ranked 643 (among 1, 00,000 students appearing) in EAMCET -1998
conducted by Govt. of Andhra Pradesh, INDIA.
Projects
CS PC IT - Product control Applications
Organization
-
Origem Solutions Pte. Ltd, Singapore
Client
-
Credit Suisse (Investment Bank),Singapore
Tenure
-
July 2011 - till date
Team Size
-
7
Role
-
Application Support Analyst
Technology
-
UNIX (Solaris), Shell Scripting, Perl Scripting, Oracle 11g, PL/SQL,
SQL Server 2008, Java, Web logic
Tools
-
Dataware House, ETL tool using Informatica Power Centre 8.6.1,
BOXI,PL/SQL Developer, Control-M, ITSM Remedy Management tool, HP
Quality Centre, Subversion
Abstract
This project consists of product control applications which generates
daily, Monthly and annual profit & loss (P&L) statements for a trading
desk. These applications receives trades, positions, cash flows from
upstream sources (Front Office & Back Office Systems) and receives
static data like book, product, counterparty data and market data like
Price, FX Rates and create cash balance/trial balances and generate
P&L reports for equity & derivative securities, validates and
reconciles front office and back office trades, positions, cash flows,
Balance sheet and P&L reporting and provides data to downstream
systems for general ledger posting and regulatory reporting
applications like Basel2 capital calculation.
Responsibility
Working closely with trading desks on position, P&L or other issues.
Working with USERS in analyzing missing/incorrect trade and Positions
data and coordinating with Trading Systems for the fixes.
Analyzing discrepancies in P&L & breaks for different type of products
like equities, fixed income (bonds), derivative instruments (futures,
options, swaps etc
Performing root cause analysis of missing/incorrect PV/Price/CASH data
in the application reported by USERS and participating in change
management.
Performing root cause analysis of incorrect accounting entries posted
to General Ledger.
Coordinating with Business Analysts for fixing missing accounting
rules and configuration of book/product data in the applications.
Identifying the opportunities for improvements in applications,
application bugs and coordinating with Application development team
for fixing permanently following change management process.
Identifying performance bottlenecks in the applications and
co-coordinating with respective teams to fix the issue permanently.
Performing root cause analysis of incidents, data quality issues and
resolving the issues in a timely manner with minimal Business impact.
Effectively communicating with various stake holders in negotiating
SLA/OLA for new deliverables and publishing service impact
notification to Users if there are any delays/issues in trading
systems.
Efficiently tracking issues in production environment and coordinating
with concerned teams for permanent fixes.
Developing the customized scripts to automate the monitoring which
helps to identify and mitigate the risks with capacity and eliminates
manual intervention.
Complete Automation of weekend maintenance of the applications which
saves 12 hrs. of weekly human effort.
Automation of critical milestone deliverables which helps support team
to track effectively and notifying users in case of Upstream delays
/application issues.
Involving in F2B batch critical path analysis and working with
development teams to rectify few incorrect dependencies which benefit
downstream feed deliverables.
Involved in transformation program effectively training vendor
resources to handle daily batches.
Performing deployments and supporting weekend releases.
UBS Equity IT - TAS DSS - Back Office Settlement System
Organization
-
Dell Perot Systems, Singapore
Client
-
UBS (Investment Bank),Singapore
Tenure
-
Mar 2006 - Oct 2007, Mar 2010 - June 2011
Team Size
-
9
Role
-
Application Support Analyst
Technology
-
UNIX (SunOS 5.8), Linux, Shell scripting, Perl Scripting, PL/SQL
programming, Oracle 10g, Sybase 12.5,Java
Tools
-
FIX Protocol, MQ Series, Business Objects, Autosys, ITSM Remedy
Management tool, Toad 9.2, Subversion
Abstract
This project includes applications which performs back office
operations like trade processing, trade confirmation, corporate action
processing and dividends notification system which captures, processes
corporate events data and notifies clients and few interface
applications to security settlement system. These applications
receives trade data from clearing systems like Clear net, EUROCLEAR
through SWIFT Messages, validates and posts the data to Settlement
System. It also consists of applications which generate unmatched and
failed trade reports and notifies Clients.
Responsibility
Performing root cause analysis of unmatched trades and failed trades.
Addressing user queries and handling application issues. Prioritizing
the user queries and providing timely updates.
Prioritizing feed and message processing to the security settlement
system as per SLA.
Performing root cause analysis of incidents and resolving the issues
in a timely manner.
Effectively Communicating with UP stream and DOWN stream systems.
Following Incident Management, Problem Management and Release
Management processes.
Providing the reports to the users on adhoc basis.
Handling batch job failures and resolving in a timely manner.
Setup of system configurations like secure license keys (SSH keys) in
Unix Servers for secure data communication.
Migrating jobs from Unix's Cron to Autosys (scheduling tool) which
reduces manual effort and improves handling of job failures.
Automation of day to day activities like SOD checks, weekend
activities like bring down the application processes.
Performing deployments and supporting application releases.
Conducting business continuity plan tests.
VRS - Vehicle Reservation System
Organization
-
Dell Perot Systems, India
Client
-
Enterprise Rent-a-Car(One of the major Car rental company), USA
Tenure
-
Nov 2007 - Feb 2010
Team Size
-
13
Role
-
Senior Software Programmer, Configuration Controller
Technology
Tools
-
UNIX (Solaris), Shell scripting, C, Pro*C, Oracle 10g, PL/SQL
programming, JAVA
CVS, SQL Developer,make, dbx
Abstract
Vehicle Reservation System (VRS) is a product that provides complete car
rental solution. It is used by car rental companies for handling
reservation, billing & invoicing. VRS produces financial postings which can
be fed into an ERP system for accounting/financial analysis.
Responsibility
. Gather requirements from the client and performing requirement
analysis.
. Develop functional and technical design specification documents as per
the requirement specifications.
. Performing requirement gap analysis and producing traceability matrix.
. Develop the source code as per design documents following all the
coding standards.
. Mentor junior team members and conducting code reviews and suggesting
improvements.
. Prepare Unit Test Cases and perform Unit testing.
. Fixing of bugs identified in testing.
. Build and deploy the application in UAT environment.
. Configuration Management of source code and documents in repository
using version control tool (CVS).
. Identification of configurable items and creating branches, tags for
respective releases. Merging of source code from branches to trunks and
resolving conflicts for the complete project.
. Automation of source code check-in, check-out scripts, build and
deployment scripts.
. Following SDLC processes throughout the project.
. Performing the root cause analysis of the issues reported by Client.
POWER NET
Organization
-
Global Energy Consulting Engineers Ltd, Hyderabad,
INDIA
Client
-
Chennai Electricity Board, Bangalore Electricity
Board, India
Tenure
-
Jun 2004 - Oct 2005
Team Size
-
5
Role
-
Software Programmer
Technology
-
C, C++, Pro*C, PL/SQL, Oracle 9i, Unix,Windows-2000
Abstract
Power Net, A Power Workstation for performing analysis like load flows and
optimization, planning of Distribution Networks. The project identifies
technical losses and factors responsible for such losses. It also reduces
peak power, energy losses by using suitable optimization methods and
develops least cost solution for long term expansion.
Responsibility
. Design and enhancement of new functionality into the existing code as
per the client requirements.
. Calculation of rate of return, investment costs etc.
. Performing Bug Fixing.
. Converting static arrays into pointers.
. Incorporation of range of HTML reports like voltage drop, power flows.
POWER CUSTOMER
Organization
-
Global Energy Consulting Engineers Ltd, Hyderabad,
INDIA
Client
-
Chennai Electricity Board, Bangalore Electricity
Board, India
Tenure
-
Jun 2004 - Oct 2005
Team Size
-
3
Role
-
Software Programmer
Technology
-
C, C++, Pro*C, Oracle 9i, Unix,Windows-2000,HTML
Abstract
Power Customer, A Power Workstation for processing the application of a
prospective Power Customer. It evaluates the application by placing the
customer hypothetically on the nearest pole location and analyzes the
feasibility of providing connection to the customer from an already
existing Transformer. It also includes facilities like identification of
customer on the network map, preparing estimate report and finally release
of power supply.
Responsibility
. Design and Implementation of identification of new customer in an
electric network and to perform a technical feasibility test.
. Introduction of new features like calculation of voltage drop, power
losses.
. Incorporation of range of HTML reports like calculation of number of
existing customers present in an area, consumption of electrical energy, amount of money collected on electricity bills, arrears present etc
which enables power utility to check the financial health of existing
Power distribution system.
Personal Information
Sex & Marital status : Male & Married
Pass Category : Employment Pass (P2)
FIN : G5861057M
Passport No. : F6106880
Nationality : Indian
Present Address : #12-153, Blk 723, Yishun St 71, Singapore
760723
Contact this candidate