SUMMARY

• Over 9 years of experience as an Oracle PL SQL Developer, and worked in all phases of Software Development Life Cycle from designing to implementation.
• Experience with Data flow diagrams, Database normalization, and ER Modeling and database design techniques
• Expertise in database development and maintenance using database and tools, like Oracle 9i/ 10g/ 11g, SQL - PL SQL, and TOAD/ SQL Developer / SQL*Plus
• TEMPEffectively made use of Oracle Collections(Nested Tables and PL SQL Tables) and Records
• TEMPEffectively made use of Table partitions, Materialized Views, and Indexes (B-Tree, Bitmap, and Function based)
• Extensive work experience in writing and modifying complex Oracle Database objects like Packages, Procedures, Functions, and Triggers
• Experience in using Dynamic SQL, and Dynamic Ref Cursors
• Very strong command in using TOAD and SQL Developer tools
• Very good knowledge and experience in using Oracle in-built packages like UTL FILE and DBMS SQL
• Very good knowledge of Oracle performance related features such as Query Optimizer and Execution plans
• Good knowledge of SQL tuning using HINTS and EXPLAIN PLAN
• Work experience in Oracle Front-end designing / programming using Oracle Forms 6i/9i, and Oracle Reports 6i/9i
• Very good knowledge on ETL and Data warehousing concepts
• Good knowledge in Database Installation, Importing tables, and Users
• Good knowledge in connecting Oracle databases to Excel using ADO.NET drivers, and good knowledge in writing Excel macros using VBA
• Good knowledge in writing reports in SAP BO 4.0, using web based tool Webi
• Good understanding of Risk Management, Asset Management, and Fund Accounting concepts
• Good understanding of Time / Money weighted return methodologies and Financial Performance Standards

TECHNICAL SKILLS

GUI Tools: Forms & Reports 6i / 9i, TOAD, SQL Developer, Webi

Databases: Oracle 12c/11g/10g/9i and SQL Server

Languages: SQL, PL/SQL, and VBA

Operating Systems: Unix (Sun Solaris, Linux), and Windows

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Oracle Database Developer

Environment: Oracle 11g, Toad, and UNIX

Responsibilities:

• Worked with front end development teams and facilitated required packages, procedure, and provided necessary insight into teh data
• Involved in teh creation and modification of Packages, Stored Procedures and Triggers
• Developed PL/SQL triggers and Master tables for automatic creation of primary keys
• Involved in teh continuous enhancements and fixing of production problems
• Created new tables and views required for new enhancements in teh application using TOAD
• Used TOAD, SQL Developer, and SQL*Plus to create tables, views, and materialized views
• Partitioned fact tables and materialized views to enhance teh performance
• Created indexes on materialized views to improve data retrieval performance
• Used Bulk Collection concepts in procedures to improve performance by reducing context switching
• Used dynamic queries and dynamic ref cursors in teh procedures and packages
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day
• Used analytical functions to reduce teh code complexity in procedures and functions
• Used agile development methodology for teh development of teh database and application
• Created PL/SQL Scripts to extract teh data from operational database into simple flat text files using UTL FILE package
• Performed SQL and PL SQL tuning using tools like Explain Plan, SQL Trace, and TKPROF
• Worked with internal and external auditors to facilitate required data to perform their tasks
• Worked in production support environment and test environments and performed releases and implementation related tasks

Confidential, Omaha, NE

Oracle PL/SQL Developer

Environment: Oracle 11g, Toad, and HP-UNIX PA-RISC 64 Bit

Responsibilities:

• Worked as Sr. Oracle Database Developer
• Created complex database objects like Packages, Procedures, and functions
• Altered and created different database objects like tables and triggers
• Involved in writing complex SQL queries, as per user and business requirements
• Used SQL Developer and TOAD to create database objects and to write PL SQL Programs
• Used Bulk Collection concepts in procedures to improve performance by reducing context switching
• Used dynamic queries and dynamic ref cursors in teh procedures and packages
• Used Associate arrays and records in teh procedures and packages
• Involved in creating views and temporary tables
• Involved in financial analysis and rate of return calculations
• Created procedures to get teh invalid combinations of table data
• Provided required data to finance auditors, and inventory auditors
• Worked with various users to understand teh presentation needs of different teams in teh organization
• Prepared technical design document, and prepared unit test plan documents
• Involved in creating UNIX shell Scripts for automating file management related tasks
• Involved in functional requirements meetings
• Involved in application enhancement meetings

Confidential

IT Manager - Software

Environment: Oracle 10g, Toad, SQL Server 2010/2012, and SAP BO 4.0 - Webi

Responsibilities:

• Involved in requirements meeting sessions with software vendors
• Involved in clarifying vendor’s queries on requirements
• Involved in installation of SQL Server Enterprise edition
• Involved in installation of SAP BO 4.0 software
• Involved and coordinated in developing 180 reports with vendors team, using Agile development methodology
• Involved in testing of each report’s accuracy, format, and speed
• Completely involved in Reports Development project
• Responsible for getting sign-offs from teh respective users
• Responsible for taking project to live/ production

Confidential

Oracle PL/SQL Developer

Environment: Oracle 9i/10g, Toad, Forms & Reports 6i / 9i, and Windows

Responsibilities:

• Altered system architecture to support Multi custodians
• Developed and implemented Mutual Fund module in teh system
• Developed and implemented Partly Paid up shares module in teh system
• Customized system to support corporate actions like Merger and Demerger
• Altered system from weighted average calculations to FIFO (First-In-First-Out) calculation, to calculate long term and short term gain/loss accurately
• Developed and implemented Auto calculation of fixed fee and generation of its invoices
• Developed different levels of return calculations in teh system
• Developed and implemented needed tools to generate reports using Excel macros, directly from users machines and Oracle database
• Developed GIPS (Global Investment Performance Standards) report in True, TWRR method
• Reduced manual work, by introducing auto mailers and upload utilities
• Involved in Oracle database 9i to oracle 10g migration (Nov’08)
• Coordinated with vendor in migrating Forms & Reports 6i to 9i
• Coordinated with vendor in implementation and testing phase of migrated forms and reports