SUMMARY:

• Over 11 years of extensive experience in Software industry in various areas including Data warehouse, Development, Design, Modeling, Programming, Performance tuning in roles of Senior developer and Technical lead.
• Developed, executed and managed Oracle PL/SQL program with bulk read and write implementation.
• Designed and enhanced database objects such as tables, Partitions, Partition Exchanges, External Tables, Materialized views, indexes, constraints, hints, Ref Cursors, Collections, DBMS packages, DB Links and triggers.
• Performance tuned and optimized large databases, DB objects like Packages, stored procedures, long running batches and complex queries.
• Expertise in Oracle 11g new features and handling of very large databases of few Tera bytes.
• Expertise in migrating database data from Sybase to Oracle and MS SQL Server to Oracle and Oracle Real Application Cluster (RAC) architecture.
• Performed Performance tuning, code reviewing, debugging, analyzing query plans optimizing the complex queries in PL/SQL.
• Very good knowledge in Star and Snow flake schema. Knowledge on Data Pump, AWR reports and import/export data.
• Implemented PL/SQL batch processing using Oracle job scheduler and Autosys.
• Experience in all phases of software development life cycle from requirement gathering, Development, Testing (QAT, System Integration and User Acceptance) to production deployment.
• Extensively worked in Agile methodologies. Experience in project effort estimation and leading a project.
• Functional expertise in Capital Markets, Investment banking, Retail Banking, consumer banking and re - insurance.
• Adaptive to new technological advancements, Team player, excellent problem solver, strong technical, analytical, communication and interpersonal skills.

TECHNICAL SKILLS:

RDBMS: Oracle 11g R2/11g R1 RAC, Oracle 10g RAC, Oracle 9i, SQL Server 2005, My SQL

Languages: SQL, PL/SQL, UNIX, JavaScript

Operating Systems: Windows 2000/NT/XP, UNIX, LINUX

Data Modellings: Erwin 4.x, Visio, ER Studio, SQL Developer

DB Tools: Toad 10.x, SQL Developer, SQL Tools

Job Scheduler: Autosys, Oracle Job Scheduler

Version Management Tools: Visual Source Safe(VSS), Concurrent Versions System(CVS), Subversion Control (SVN), Bit Bucket

Documentations: Microsoft Office, MS Visio 2000, MS PowerPoint, MS Word, SharePoint, MS-Project

Reporting Tools: Jasper Reports

Other Tools: JIRA, Service Now

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Senior Database Developer

Environment: Oracle 10g/11g, Oracle SQL Developer, SQL Tools, Java 1.5, WebLogic, Toad 10.x, Win XP, MS Visual source safe, JIRA

Responsibilities:

• Involved in functional requirement gathering, design, and development and testing phases of project.
• Extensively worked on Partitions in tables and partition exchange between tables, External Tables, Materialized views, indexes, constraints, hints, Ref Cursors, Collections, DBMS packages and triggers.
• Written complex packages, procedure and queries to implement major modules.
• Export/Import utility
• Performance tuning of complex queries
• Using DB link
• Using SQL Loader
• ETL (Extraction, Transformation and Loading) Process
• DB Modelling & Microsoft Visio
• Oracle Database administration issues
• Spearheaded Database migration from Sybase to Oracle database.
• Scheduling jobs in tools like Autosys 11
• Spearheaded Database migration from Multiple SQL server databases to Oracle database.
• Responsible for resolving performances issues in database and for integrating DB objects with Java/HTML.
• Developed use case diagrams, class diagrams, database tables, and mapping between relational database tables.
• Assisted DBAs in migration of Oracle 10g and 11g R1 and R2 to different servers.

Confidential

Senior Database developer

Environment: Java 1.5, Jboss Seam 2.0, EJB 3.0, JSF 1.2, Jboss RichFaces, Ajax4JSF Tags, Facelets, Jboss 4.2, Web Services, Axis 2.0, Hibernate 3.0, Spring 2.0, Flex, Flex Builder, Log4j 1.4, Ant, Eclipse 3.1, Oracle 10g, Microsoft VSS, Xml, Xpath, Xslt, PL/SQL and Linux.

Responsibilities:

• Designed, modified and implemented changes in the existing Database structure to factor in the new requirement
• Developed new Database objects such as stored procedures, packages, functions etc.,
• Performance tuning of the complex queries generated across multiple tables.
• Worked on debugging, bug fixing, troubleshooting.
• Worked in developing stored procedures which helped to retrieve messages for Interactive Voice Response calls
• Enhanced database objects and created scheduled jobs to send SMSs to credit card customers

Confidential

Database Developer

Environment: Microsoft SQL 2005 Server, Java/J2EE, EJB, Struts Framework, Windows 2000/XP, Erwin 4x, Jasper Reports.

Responsibilities:

• Involved in debugging, Bug Fixing, troubleshooting during System testing
• Responsible for Database Maintenance such as Database Backup, Restoration, creation of new Database Objects and access control to users.
• Developed procedures, functions, and triggers and wrote complex queries in SQL.
• Extensively worked in the design and development of reports using iReports (Jasper Reports).
• Created Erwin models through reverse engineering process.
• Worked on database synchronization, generation of Scripts and OSQL Batch files.
• Debugging and troubleshooting Modules in JAVA/J2EE
• Worked in the Post production bug fixing activities in JAVA/J2EE
• Prepared Unit Test Cases and Unit Test Results.
• Performed System Integration Testing and EQA.
• Effort estimation for the Change Requests (CR).

Confidential

PL/ SQL Developer

Environment: Java/J2EE, Oracle 9i, Win XP, MS Visual Safe Source.

Responsibilities:

• Designed and Implemented Hibernate data persistent framework to persist any kind of Java object, manipulate a hierarchy of objects, handle collections, caching and work with transactions.
• Involved in Implementation of Middleware framework using Hibernate and Spring Framework.
• Developed procedures, functions and written complex queries in SQL
• Worked with different source systems like Net Asset Values (NAV), flat files and relational sources.
• Involved in development of the standalone modules using Java/J2EE
• Prepared Unit Test Cases and Unit Test Results.

Confidential

PL/ SQL Developer

Environment: Microsoft SQL Server 2005, Oracle 9i, Win 2000, Lotus Domino.

Responsibilities:

• Creation and maintenance of Database objects required for the application
• Developed procedures, functions and written complex queries in SQL
• Performed administrative tasks on databases, managing users and privileges, backup, retrieval, code delivery to onsite.
• Prepared Unit Test Cases and Unit Test Results.
• Performed Unit Testing and IQA