Developer Sql

ANNAMALAI VIJAYAN

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

Weymouth, Massachusetts - 02189 Phone: 937-***-****

SUMMARY:

7.5 years of experience in Oracle PL/SQL development

* **ars of experience in Financial and Banking domain

5 years of ETL experience with Informatica

4 years of Unix scripting experience

4 years of Autosys experience

Experienced with both Agile and Water Fall methodology relative to the Software Development Lifecycle (SDLC)

Experienced in all phases of SDLC including requirements gathering, design, and development, unit testing, on-going support and maintenance

Good knowledge on logical and physical Data Modeling using normalizing techniques

Strong knowledge in SQL, PL/SQL Stored Procedures, Functions, Packages, Exception Handling, Triggers, Views

Knowledge in performance enhancing tools in Oracle like Explain Plan, Different types of optimizer hints, Indexes, table partitions and sub-partitions, materialized views, global temporary tables, autonomous transactions, PL-SQL collections and bulk binds

Expertise in using Rational Team Concert (RTC) and Jira for tracking work status

Experienced in using Crucible and FishEye tool for doing peer code review within the team

Experienced in Design, Development, Testing and Deployment of applications build on top of oracle database

Possessing good knowledge in Java technology

Excellent written and verbal communication & interpersonal skills

An analytical, hardworking individual with excellent communication skills and natural ability to work in a team and as an individual

TECHNICAL SKILLS:

Languages : Oracle SQL, PL/SQL, Unix shell scripting

Databases : Oracle, SQL Server

ETL Tools : Informatica

Database Tools : Toad, PL/SQL Developer

O/S : Windows, Unix

Team Collaboration Tool : IBM Rational Team Concert(RTC)

File Sharing Tools : FileZilla, Humming Bird

Domain Expertise : Financial and Technology Management

Scheduling Tools : Autosys

Central Repository : VSS, Clear case, GitHub, Stash

Defect Tracking Tool : Quality Center

TECHNICAL ENVIRONMENT:

Oracle 9i/10g/11g,12c, TOAD, Oracle SQL Developer 3.0, Informatica Power Center 9.1.0/8.1.1, IBM Rational Team Concert, IBM Rational Clear Case, Autosys Console, Putty, Unix, MS Excel, MS Word Quality Center 10.0

EDUCATION:

MBA in Technology Management, Anna University, India, March 2013

Bachelor of Engineering, Anna University, India, June 2008

PROFESSIONAL EXPERIENCE:

Employer : Infosys Limited

Role : Senior Oracle PL/SQL & ETL Developer

Client : Fidelity Investments

Duration : Jan 2015 till date

Project Name : Performance Center

Creation of a UI interface for Fidelity Investment Managers based on the performance attribution and exposure data repository, such that the performance numbers stored in the repository are readily available for decision making.

Accomplishments:

Working on database development to support UI interface created for the Fidelity Investment/Portfolio Managers to help them make investment decisions based on the current performance of the portfolio/product

Requirements gathering from the end users

Involved in Logical & Physical database layout design

ETL development and performance tuning

Providing support and maintenance

Adopting Agile Methodology, which includes grooming sessions, retrospective, sizing sessions

Scrum master for the entire team based out of Ireland, USA and India

Managing offshore development, operations and support team of 20

Role : Senior Oracle PL/SQL &ETL Developer

Client : Fidelity Investments

Duration : Oct’2013 till Dec 2014

Project Name : Performance Attribution and Exposure (PAE)

Fidelity’s PAE application is developed by FIMT-AAT (Fidelity Investment Management Technology – Asset allocation Technology) group. PA&E initiative involves creation of a repository which should store the various performance parameters of the portfolios, products, business lines, departments owned and invested into by Fidelity’s

Global Asset Allocation (GAA) Division.

Accomplishments:

Calculated and stored the performance of all Fidelity funds, portfolios, business lines, departments and division in a centralized data repository.

Sourced the portfolio performance data from various sources like morning star using ETL tool Informatica.

Calculated the performance of higher level composites at product, business line, and department and division level.

Client appreciation for successful implementation within timelines and with additional enhancements

Involved in integration and user acceptance testing

Lead daily team stand-ups with development team, QA team and BA to check work status

Used Fisheye and crucible tool for peer code reviews within the team

Participated and conducted Knowledge Transfer Sessions

Role : Oracle PL/SQL Developer

Client : Fidelity Investments, Boston, MA

Duration : Oct’2011 till Dec 2013

Project Name : Fund Ownership and Exposure Center

Created an application for Fidelity investment managers, which calculates and describes the ownership of Fidelity and external funds contained in various investment levels such as products, business lines, departments, division and various fund characteristics.

Accomplishments:

Helped the investment managers to make a decision by comparing the fund performance with the standard threshold to find out whether to buy that fund or sell the fund.

Used by the portfolio managers to find the percentage of fidelity and external funds owned by fidelity's various products.

Co-coordinated the database production deployments

Mentored the application development team for creating these applications

Prepared readiness report to delivery manager and release management team after every production release

Role : SQL Developer/Data Analyst

Client : Fidelity Investments, Boston, MA

Duration : March 2009 – Oct 2011

Project Name : GAA Risk Platform

Fidelity GAA Risk Platform sources portfolios and benchmarks from upstream databases and transforms risk portfolios for 3rd party risk analytics modeling (like MSCI’s BarraOne platform). As part of transformation, process also sources and uploads security reference data for various instrument likes equities, bonds, derivatives and mortgage securities. risk analytics are also published to the risk subject area in the database warehouse where it can be consumed by other Fidelity enterprise applications

Accomplishments:

Involved in data analysis in various non-prod database environments

Developed SQL queries which were used for building various reports

Created database High level design and detailed design documents

Involved in the waterfall model methodology

AWARDS :

Four times SPOT award winner at the account level, Infosys Ltd for my exceptional performance

STRENGTHS:

Enthusiastic, resourceful, committed, reliable and dependable

Ability to work independently and as a co-operative team member

Aim to achieve near perfection in my entire task and desire to learn during the same process

Ability to take up a problem, issue and resolve the same, even if it does not fall within the scope of my duties

Contact this candidate