SUMMARY:

• Over 8 years of IT experience as Oracle Developer in various verticals such asFinance, Insurance and Health Care.
• 7 years of experience in Data Warehousing, designing Star Schema and Snowflake Schema.
• Over 3 years of experienceasJava develop er using JDBC, XML and Hibernate framework.
• Excellent experience and understanding of System Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database.
• Strong Data modeling experience, using ER diagram, Dimensional and Hierarchical data modelingusing tools like Erwin.
• Comprehensive in writing Unix Shell Scripts (bash shell and korn shell) and unit testing integrity.
• Solid knowledge in handling Oracle Exceptions.
• Extensive experience in Extraction, Transformation and Loading (ETL) of data from different heterogeneous source systems using tools such as Informatica.
• Outstanding in using SQL Loader to load flat files of various formats into Oracle database.
• Expertin Oracle tools like Export/Import and data pump utilities like Expdp/ Impdp.
• Proficient insome common - used Packages like DBMS STATS, UTL FILE,DBMS SCHEDULER and UTL MAIL
• Proficient in Performance Tuning, using various Oracle utilities, such as Explainplan, Hints, SQL Trace, TK prof and DBMS Profilerto identify bottlenecks and provide solutions.
• Highly experienced in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Expertise in developingStored Procedures, Packages and using advanced features like Function Overloading, Query Optimizer and Nested Loops.
• Creative, independent, good team player with and ability to accept responsibilities and meet tough deadlines.

TECHNICAL SKILLS:

Operating Systems: UNIX, RedHat Linux, Win 98/NT/2000/XP/Vista/7

Database: Oracle 9g/10g/11g

Languages: Shell Script, SQL, PL/SQL, Java

Tools: SQL developer, SQL Plus, TOAD 8.5/9.0, Informatica, Eclipse

Case Tools: Erwin

Utilities: Vi Editor, FTP, SQL*Loader, SQL Developer, PL/SQL Developer, Explain Plan, TKProf, Import/Export, Impdp/Expdp, SQL trace,DBMS Profiler

PROFESSIONAL EXPERIENCE:

Confidential,New York,NY

Senior Oracle Developer/Java Developer

Responsibilities:

• Participated in design discussions with the application architects and suggest design changes for improved database performance.
• Designed and developed data loading processes and the night batch processesusing UNIX Shell scripts.
• Participated in the analysis of Physical Data Modelfor ETL mapping and process flow diagrams to develop Data Mart design.
• Involved in the optimization of Oracle queries/scripts using Oracle Hints, Explain Plan Dbms Profiler and Auto Trace.
• Ran batch jobs for loading database tables from flat files using SQL* Loader.
• Coded Stored Procedures, Triggers, Functions and Packages to support various business processes.
• Scheduled reports using Utl MailandDbms Scheduler.
• Wrote complex SQL queries usingJoins, In-line View and Correlated Sub Queries for various reports
• Developed P ipelined F unctions using R ef C ursors and PL/SQL Named Blocks as per client requirement.
• Worked with Informatica to create ETL mappings and schedule workflow
• UsedPL/SQL Collections and Records,Partition methods for oracle tables and indexes.
• Created aggregate Materialized ViewsinData Warehousingto improve data retrieval performance.
• Used Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Extensively worked on PL/SQLException handling.
• Implemented the middle tier with Hibernate framework and integrated that with the ORM framework and JDBC.
• Developed Data Access Object (DAO) persistence layer using Hibernate.

Environment: Oracle 10g/11g, TOAD, PL/SQL Developer, Unix, Informatica, Eclipse

Confidential, NJ

Senior PL/SQL Developer

• Interact with Business to understand business requirements and define project scope.
• Prepare project plan, estimate efforts
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Developed programs using Oracle PL/SQLprocedures, packages and SQL queries.
• Loading of data using SQL* Loader and import/export utilities.
• Preparation of unit test cases and test script documents for end to end testing.
• Documenting program specifications and communicating requirements to offshore team, analyzing design documents, design and code reviews.
• Involved in code walkthrough, system testing and regression testing.
• Tuning of SQL queries.
• Participated in Functional Testing and Unit Testing.
• Weekly statusreporting to different levels of management on project status.
• Conducting audits and reviews to ensure compliance with specific quality guidelines.
• Integrate all components, test and deploy in production.
• Provide post production support.

Environment: Windows XP, Oracle10g, Oracle PL/SQL, Visual Basic

Confidential,Rochester,NY

Senior Oracle PL/SQL Consultant

• Gathering development requirement from client’s functional team and from functional design specification documents.
• Authoring the technical design documents for the given functional design.
• Performed logical database design.
• Created logical and physical database objects - table spaces, tables, indexes, referential integrity constraints, and triggers to development needs.
• Responsible for the development of pipelined functions using ref cursors and PL/SQL stored procedures as per client requirement.
• Responsible for developing technical components for the following Oracle Applications modules: Custom Char Resolve, Conversion Resolve, Upc Resolve, Scope Resolve, View/SubTotal Resolve, Hierarch Resolve.
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Fine-tuning of PL/SQL Stored Procedures using HINTS in Explain Plan.
• Worked on enhancement of existing pipelined functions and packages.
• Testing codes developed by self and team.
• Bug Fixing while in Production with top priority.

Environment: Oracle 10g , PL/SQL, SQL*Loader, TOAD, WinSCP, Putty

Confidential,Jersey City,NJ

Oracle Developer

• Created and managed many objects in large Oracle Databases containing millions of records.
• Coded and debugged Stored Procedures, Packages and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Extensive querying using SQL * plus / TOAD to monitor quality & integrity of data.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints.
• Created Batch Jobs and UNIX Scripts to automate the process.
• Wrote PL/SQL programs to read from files, upload data, and mass updates/inserts of data based on certain business policies.
• Developed oracle Reports, PL/SQL packages to perform Certain Specialized functions.
• Involved in SQL Tuning by creation of Indexes, Rebuilding Indexes, and Clusters etc.
• Involved in unit level testing, Module level testing and Integration testing at the primary level before the modules are delivered to the Quality department.
• Written korn shell scripts that were used for checking Network stats, Disk space, Monitor Queues, Virtual Memory, Shared Memory and Control processes.
• Developed shell scripts with embedded SQL statements for batch processing and data content changes.

Environment: Oracle 9i, Shell Scripts. Toad, SQL *Loader, Import/Export

Confidential

PL/SQL Developer

• Developed tables, views, stored procedures, functions, and user-defined data types
• Created table structures along with the triggers, indexes like bitmap and function based indexes
• Monitored indexes and analyzed their status for performance tuning and query optimization
• Maintained the data integrity and security using constraints and database triggers
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures
• Troubleshoot performance issues within packages and stored procedures using explain plan and DBMS OUTPUT
• Responsible for tuning the application with the help of team members & Oracle support
• Improved the query performance using better joins and hints appropriately
• Developed packages, procedures and functions for complex reports
• Used SQL*Loader for loading the data into the tables from files
• Developed batch programs using UNIX shell scripts
• Participated in the design and code reviews and verified compliance with the project’s plan
• Documented the whole process flow, PL/SQL packages, locations and descriptions, and possible error messages

Environment: Oracle 9i, SQL, PL/SQL, SQL Plus, Sun Solaris 2.6, SQL loader, UNIX