Post Job Free

Resume

Sign in

Software Engineer

Location:
Bengaluru, KA, India
Posted:
November 24, 2015

Contact this candidate

Resume:

Suma B S

Oracle PL/SQL Developer

acskom@r.postjobfree.com

+91-810*******

Current Employer : Fidelity Investments

Designation : Software Engineer

Overall IT Experience : 5 Years 9 months

Basic Skill Set : SQL, PL/SQL, Oracle Forms & Reports (6i&10g), UNIX, SQL SERVER 2000, UNIX Shell Scripting, Actimize (Products / Packages)

Domain Knowledge : BFSI (Banking and Financial Services), Compliance and surveillance

Objective

To obtain a challenging position in a people-oriented organization where I can utilize & maximize my knowledge on program development, quality assurance and experience as an Oracle Developer thereby achieving the corporate goals.

A motivated professional with 5+ year’s experience in IT services for Banking & Finance. Driven by excellent analytical & communication skills.

Experience Summary

1.Currently working as a Software Engineer with Fidelity Investments from June 2013.

2.Worked as a Project Engineer with Wipro Technologies for ANZ Client from Jan 2010 to June 2013.

Summary

5+ Years of experience specialist in Software Analysis, Design and Development and production support.

2+ years of experience working in ACTIMIZE customized Model development.

Having hands on experience in Oracle Forms and Reports (6i and 10G).

Skilled in developing Unix shell scripts, PL/SQL oriented Oracle objects. Performing Oracle DBA environment related activities like refreshes of Test environments.

Providing database and Unix environments access and performing releases into test environments.

Experience in modifying SQL Server DTS Packages.

Having good knowledge on tools like Toad, SSH Tectia Client, Quality Center and SQL Server 2000.

Good understanding in Investment Banking Domain and having knowledge of SDLC Processes.

Have done Oracle Client and Actimize AIS Installations.

Excellent communication and interpersonal skills.

Strongly Capable in performing individually complex trouble shooting, root cause analysis and Solution development.

Having good interaction with the Customers.

Team player, Motivated, able to grasp things quickly with analytic and problem solving skills.

Result oriented & committed to meet the goal.

Projects

1. Currently working in development projects for Fidelity Investments from June 2013 to present.

Client Description

Fidelity Investments is one of the largest mutual fund and financial services groups in the world.

It manages a large family of mutual funds, provides fund distribution and investment advice services, as well as providing discount brokerage services, retirement services, wealth management, securities execution and clearance, life insurance and a number of other services.

Project Description

This project undertakes the development and enhancements of the products/solutions offered by the bank to customers.

Role

Analyst & Developer

Location

Offshore (Bangalore)

Skills

Oracle Database 10g, PL/SQL, AIS 4.X and 3.X, RCM,TOAD, Unix Shell script

Contribution

Interacting extensively with the clients to understand the new products and assisting them in designing and developing the required solution.

Responsibilities:

•Developed many Custom models using AIS 3.X and AIS 4.X.

•I have been working on banking related project, under the Risk and Compliance category.

•Our project works on delivering alerts for any suspicious trading activity of clients and also financial crimes for Fidelity employees and customers.

•We achieve the deliverables using the Actimize 4.10 tool and also PL/SQL.

•I have worked on the broker/ dealer side of the business requirement and have developed on the Suitability, Options etc., in addition to creating re-usable components.

•Alerts are generated using Actimize 4.10, Risk Case Manager Designer and the RCM front end alert screen by applying the flow of the business requirements in the Actimize tool / PLSQL.

•RCM web services implementation on AIS

•Operations Dashboard Implementation

Trade Monitoring & Surveillance

Monitoring and Surveillance application provides coverage on non-compliance trade activities done as part of client trading, Proprietary trading or trade executed by an employee by generating alerts on data loaded in data warehouse.

• Develop procedures using TOAD to perform load from Data - Warehouse to accomplish the requirement of creating non-compliance alerts.

• Get Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures, ETL mappings, ACTIMIZE models for code enhancements.

• Prepare detailed technical design for on boarding new feeds to data warehouse in order to capture noncompliance alerts on that source specific data.

• Responsible for peer review and ensuring zero defect on go live.

2.Projects worked as Oracle Developer with Wipro Technologies for ANZ Client from Jan 2010 to June 2013.

Client Description

The Australia and New Zealand Banking Group Limited commonly called ANZ is one of the largest banks in Australia and New Zealand.

Investment Lending (Margin Lending)

ANZ bank provides their customers with margin loans, a lending facility to gear up their investments by lending money flexibly. Customers can borrow funds to invest into share markets by using this facility. The product is identified to be one of the fastest growing financial products in Australia.

The investment portfolio of the customer is used as security for the loan just like any property is used as security for investment into property.

By combining the funds borrowed from the margin lending facility with the customer’s own portfolio, the amount that can be invested is increased.

Direct Investing (Online Investment Account)

The ANZ online investment account is a convenient and simple product that enables everyone to access share market returns by which customers can open and access the account 24/7 via ANZ Internet Banking.

Project Description

This project undertakes the development and enhancements of the products/solutions offered by the bank to customers.

Role

Analyst & Developer

Location

Offshore (Bangalore) & Onsite (Melbourne, Australia)

Skills

Oracle Database 10g, Oracle Forms & Reports, PL/SQL, SQL*Plus, TOAD, Unix Shell script, Banking & Finance

Contribution

Worked on many enhancement projects for the existing system. The major ones among them are:-

Working on many work orders and Incidents.

MyPortfolioExtractDecommission

MyPortfolio is a Web Customer Interface to EBBOS that enables customers to view the position of their ANZ Margin Loan online. In this project I was involved in modifying the existing MyPortfolio Extract for ANZ Investment Lending by changing the SQL Server DTS packages and PL/SQL codes as per the requirement.

There were 14 files generated that were loaded nightly into MyPortfolio but later it was modified to extract only 5 files which were generated by modifying the existing SQL Server DTS Packages and thus preventing the database maximum utilisation and led to performance improvement.

Oracle 9i to 10g Database upgrade

EBBOS is an Internal ANZ System designed to facilitate Portfolio Management and trading functions. EBBOS has a number of interfaces to external systems, such as CHESS and E*Trade. Currently EBBOS is running on Database version oracle 9i and is upgraded to version 10g, as part of this project for the following benefits:

Potential for performance increases during market volatility.

Better performance tuning tools available for development of future projects.

Increased stability

Overall system risk reduction – supported system lower development & support costs.

As part of this project, I had tested all the forms, reports, applications which were currently running in 9i on the 10g platform and this included in changing all the forms, reports and corresponding dependent applications. I was involved in both the form and report changes.

Trainings

Course Name

Conducted By

RDBMS,SQL, PLSQL, Oracle Database, Basics of JAVA

Wipro Technologies

UNIX Basics & SHELL Scripting, ORACLE Forms & Reports 6i

Basic training on SQL Server DTS packages

Software Configuration Management, Veloci-Q, Software Reviews and Testing

Advanced Actimize AIS

Fidelity Investments

Database Administration

Actimize RCM

Accomplishments

1.Received Clients appreciation for many projects from my project manager for being enthusiastic in understanding the project requirements, developing and resolving the issues proactively and identifying and handling possible expectations or discrepancies in the project.

2.During the Oracle 9i to 10g Database upgrade project, I was the Single Point of Contact to help our team members during the system testing phase of the project to debug the errors and fix them for which I have got many appreciations from the Project Manager for being very quick in fixing the issues.

Education

Course

College

Year of Passing

Percentage/Grade

PGDBA (HR)

Symbiosis, Pune

2011

‘A’

B.E

(Electronics and Communication)

R.V College of Engineering, Bangalore

2009

80

PUC

Sheshadripuram Composite Pre-university College, Bangalore

2005

90.66

SSLC

Seshadripuram Girls High School, Bangalore

2003

90.24

Personal Profile

Date of Birth : 08-12-1986

Nationality : Indian

Gender : Female

Marital Status : Married

Husband’s Name : Deekshith Anoor

Pan Card : CIYPS0970H

Passport details : Passport no H7536625

Issue Date 11-Sep-2009

Expiry Date 10-Sep-2019

Address : #72/2, 10th B Main, 2nd C Cross, Annaiah Reddy Layout,

Doddabanaswadi, Bangalore 560 043

Language Proficiency : English, Kannada, Hindi and Tamil

Declaration

I do hereby confirm that the information given above is true to the best of my knowledge. I also understand that any false declaration or willful suppression of information shall amount to misconduct and may result in appropriate disciplinary action.

Date :

Place : [Suma BS]



Contact this candidate