PL/SQL Developer Resume

SUMMARY:

6 + yrs of Experience in design, analysis, development, debugging, performance tuning & implementation of application on oracle platform at client locations.
Proficient in PL/SQL programming (stored procedures, functions, cursors, exceptions, Triggers).
Designing and Developing Reports using development tools like SSRS 2008 R2 and Jasper Reports.
Onsite Development and providing Support for Customization of products to suit according to the client requirements.
Programmer wif hands - on experience in Business Development.
4 + yrs of experience in Murex 3.1 Murex Datamart Reporting, Mxml Exchange, Trade workflow, Real time Interfaces,End of day activities.
Basic knowledge in UNIX.
Having good experience in “Insurance” & financial services Domain.

TECHNICAL SKILLS:

Languages: SQL, PL-SQL, UNIX, C,XML,MxML

Report Design Tool: Jasper Reports (iReport), SSRS 2008 R2

Development Tools: SQL Developer, TOAD, PLSQL Developer

Databases: Oracle 10g/9i/11g

Platform: Windows 2000 Server, Windows XP

Functional areas: Insurance and Banking

PROFESSIONAL EXPERIENCE:

Confidential, Singapore

PL/SQL Developer

Key responsibilities,

Reports to be created in Murex 3.1.
Development includes: P&L, Cash flow, Simulation view, Market data viewers, and Liquidation module for security position.
Participating in UAT and working directly wif the business users to understand the issues and address them.
Optimizing the Datamart setup and reports.
Involving wif users and halping resolve functional FO issues.
Interacting wif Murex to get the Mx setup related issues.
Preparation of Control - M setup & R2w setup for EOD activity.
Development & modifications of MxML Paper confirmation.
Having knowledge of MxML Exchange, End of the day activity.

Confidential

PL/SQL Developer

Responsibilities:

Migration of reports from Murex 2.11 to Murex 3.1
We analyze the requirements and identify the class type of report if it cannot be delivered from existing set of rep tables or it is costlier to derive from existing reports rather TEMPthan creating new report.
Based on above observation we create dynamic tables, which may access different transaction class wif required filters needed to filter the selection of data.
We create .REP table to be populated wif the data by mapping above created dynamic table.
We create feeder to populate .REP table.
We create Oracle procedure or SQL to develop the business logic.
We design actuate files (.ROD) files to provide a front view to end user.
We create batch of feeders, batch of reports and processing script in Murex to automate the report generation.
We provide L1 and L2 supports for Murex Datamart report module.

Confidential

Jasper Reports, SSRS

Responsibilities:

Analysis of the specifications provided by the clients for Reports.
Developed complex Jasper reports & SSRS reports using for calculating the Summary sheet for the each channel wise.
Developed PL/SQL stored procedures, functions, packages and triggers.
Contest definition in the front end and development of the logic for calculating rated premium business of Agents and providing the Qualifier list.
Designed the Commission rate control statement Jasper report for calculating the commission rate for different channels when a particular product is sold.
Service Tax changes have been handled successfully in the CMS modules.
Performance tuning of existing reports and SQL queries by using creating the Indexes and hints. committee member in“NACOAT-NIRMITI-09” for academic session 2009