SUMMARY

• A dynamic individual with 5 years of experience in Software Development in Investment Banking Domain.
• Oracle Certified Associate for Oracle 8i/9i/10g/11g Databases.
• Oracle PL/SQL Developer worked on Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (SOFTWARE DEVELOPMENT LIFE CYCLE) including analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *Plus, TOAD, SQL *Loader and SQL Developer.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Good understanding of database architecture concepts and expertise in data warehousing, data modeling and ETL.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Worked on Test Plans, Test Strategies, Debugging, Object testing and Functional Testing and done manual Code Formatting, Performance Testing, Integration Testing and User Acceptance Testing (UAT).
• Developed, enhanced, and implemented standard UNIX Shell Scripts, Windows batch/FTP scripts for database monitoring, exports, startup/shutdowns, etc.
• Skilled in mapping client’s business requirements and translating these requirements into technical specifications.
• Deft at monitoring project documentation and identifying & fixing bugs.
• Comprehensive experience in managing projects and new systems implementations for streamlining operations within time and cost parameters in compliance with the organization’s quality standards.
• Dexterous in adopting pragmatic approach for improvising solutions and resolving complex business issues.
• A self-motivated, responsible and reliable team player with a set of strong technical skills, analytical, interpersonal and communication skills.

TECHNICAL SKILLS

Operating Systems: MS Windows 2000/XP, Windows Server 2000/2003 and UNIX.

Languages: SQL, PL/SQL, MS SQL, C/C++, HTML.

Scripting Languages: Windows Batch/Ftp Scripts, UNIX Shell Scripts, PERL.

Databases: Oracle 8i/9i/10g/11g, SQL Server, MS-Access, Sybase.

Office Automation Tools: MS Word, MS Excel, MS Power Point, MS Project, MS FrontPage, Editors- Edit Plus, Ultra Edit

Tools: /Utilities SQL*Plus, TOAD 12.2.1, SQL Developer, SQL*Loader, Quality Centre, MySql, Embarcadero Rapid SQL, PUTTY, Database Configuration Assistant, Oracle Enterprise Manager(OEM), SQL Trace, SQL*NET, SQL Enterprise Manager, Query Builder, Oracle Scheduler.

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Lead - PL/SQL Developer

Responsibilities:

• Involved in understanding Business Requirement & Functional Specifications.
• Wide hands on experience on PL/SQL Programming especially in the areas of Views, Cursors, Stored Procedures, Normalization, Multiple table queries, SQL tuning etc.
• Administered reviewing of the Detail Level Design Document, Software requirements specification, Implementation Principle Document.
• Delivered initial training and handled ramping-up of new joiners in the team.
• Handled identification of scenarios and development & execution of test cases.
• Interacted with the Client Teams for obtaining timely deliverables.
• Performed Environment Stabilization for the UAT & SIT Environments.

Environment: Oracle 11g-PL/SQL, SQL *Plus, Toad12.2.1, SQL Developer, SQL Loader, Unix Scripting.

Confidential - Wilmington, DE

PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Used pipelined functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Developed Installation scripts for all the deliverables.
• Performed functional testing for the procedures and packages.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.

Confidential

Lead - Sybase Developer

Responsibilities:

• Got an Opportunity to work with UK counterparts in London.
• Looked after the establishment & maintenance of GSD single handed within India.
• Accountable for reviewing High Level Design Document and understanding the business requirements & functional specifications.
• Performed technical analysis of the existing procedures used by GSD consumers.
• Excellent Sybase ACE v15 development skills (with T-SQL).
• Good hands on with Unix specially Redhat Linux.
• Worked with the GSD BA as well as GSD consumers to ensure that the required data in GSD can be replaced by equivalent data from Confidential strategic sources.
• Worked on Sybase technologies to build procedures to support the existing GSD consumers.
• Liaised with the consumer Development teams to help identify/investigate data quality issues, identify root cause to find an optimal solution.
• Handled R&D Initiatives for the core product.
• Drafted documents for processes and other technical requirements of the team.
• Contributed in Defect Status Meetings & Walkthroughs along with the BAs and the Development team, Project Management & Release Management and Team Members (Testing and Development team).
• Delivered initial training and handled ramping-up of new joiners in the team.
• Examined Software requirements specification and the High Level Design Document.
• Interacted with the Client Teams for obtaining timely deliverables.

Environment: Embarcadero Rapid SQL, Windows XP, C/C++, Visual Studio

Confidential

PL/SQL Developer

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, TestingandImplementation.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign keyconstraints in data conversions.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• UpgradedOracle 9i to 10gsoftware in different environments for latest features and also tested databases.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Creatingindexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Created some Custom reports and Forms for the end users to check the details and errors.

Environment: VB 6, Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL PLUS, HTML, TOAD, UNIX shell scripting.