SUMMARY

• Over 9+ years of experience in developing and maintaining applications within systems in financial domain.
• Strong knowledge on Oracle architecture and data base design.
• Excellent skills in designing and development of applications using Oracle 11g/10g/9i SQL, PL/SQL Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD in many development projects.
• Experienced in all phases of Software Development Life Cycle (SDLC).
• Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms.
• Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.
• Experience in Bulk Data loading using Oracle utilities namely SQL Loader.
• Working knowledge in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle database issues.
• Working Knowledge on UNIX, Windows and Shell Scripting.
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.
• In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, T - SQL using database tools like TOAD, SQL Navigator.
• Expertise in Eagle Star and Pace application, with hands on knowledge in Web Panels, STAR Scheduler, STAR Message center, PACE uploaders and exporters.
• Working knowledge of Control-M scheduler for scheduling the jobs.
• Familiar with programming languages C, C++, VB Script, Visual Basic, HTML.
• Excellent planning, analytical, written communication and Interpersonal skills.

TECHNICAL SKILLS

FrontEnd Tools: TOAD, SQL Navigator.

Databases: Oracle 11g/10g/9i/8i, Microsoft SQL Server, Microsoft Access.

ETL & BI Tools: Eagle STAR and PACE.

Programming: SQL, PL/SQL, T-SQL, UNIX Shell Scripting.

Operating Systems: Windows XP/2003/2000/NT/98/95, UNIX.

Other: SQL Loader, Control M scheduler.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr Oracle Developer

Responsibilities:

• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader. Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Design and develop Eagle Web panels for front end users as per business requirements.
• Used application platforms Eagle Star, Pace, Scheduler, and Message Center etc.

Environment: Oracle 10g, 11g PL/SQL, SQL Navigator, UNIX, Windows XP, T-SQL, Putty, Eagle STAR and PACE.

Confidential

Oracle PL/SQL Developer/Offshore Team Lead

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Responsible for Analysing requirements, designing, maintaining and updating data models.
• Analyse the current data management procedures in practice and suggest ways for automating the process or improving the existing system.
• Developed stored procedures to apply business logic on raw data.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
• Maintaining daily batch cycle and providing 24/7 support.
• Used Control M scheduler in order to schedule the loader, uploader, and exporter jobs.
• Involved in unit testing and integrated testing.
• Involved in preparing the User Test plans.
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration and batch processing.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Developed and implemented dozens of automated batch processing jobs, running in numerous development, test and production environments.
• Involved in importing the production data to work environment through TOAD.
• Involved in handling the changes in compiling scripts according to the database changes.
• Co-ordinate and manage offshore team to ensure timely and quality delivery to the client and reviewing offshore deliverables.

Environment: Oracle 9i/10g, UNIX Shell Scripts, PL/SQL, Control M Scheduler, TOAD, PL/SQL Developer, SQL Optimizer, Putty, PVCS, JIRA.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Worked as part of the development team, along with the Systems Analysts/Business Analysts.
• Analyzed and fixed the data discrepancies between various systems and identified bad data caused due the data migration from various legacy systems.
• Created PL/SQL Stored Procedures, Functions, Packages, and Triggers; extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming.
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
• Used Control M scheduler in order to schedule the jobs.
• Developed UNIX Shell scripts for calling the stored procedures.
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance.
• Improved performance by creating Unique and Range Indexes based on the cost returned by EXPLAIN PLAN.
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.
• Effectively used Triggers to track the user profile updates and to send the messages to downstream systems.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.

Environment: Oracle 10g/9i, PL/SQL, SQL Server, UNIX Shell Scripting, TOAD, Control M Scheduler.

Confidential

Oracle PL/SQL Developer/Jr. Oracle Developer

Responsibilities:

• Analyzed business requirements and coordinated with the business analyst to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems.
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards. Developed Unit Test Plans.
• Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc. based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and Oracle Objects including Collections, Types and creating objects.
• Used Control M scheduler in order to schedule the jobs.
• Prepared the procedures to update the internal structures to reflect the newly loaded data.
• Used batch scripts to loop from database to database, to perform system-wide functions.
• Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.

Environment: Oracle 9i, TOAD, SQL Navigator, UNIX Shell Scripting, Control M scheduler.