SUMMARY OF QUALIFICATIONS

• Over EIGHT 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.
• Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.

TECHNICAL SKILLS

Front-End 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.

Confidential

Oracle Developer/Eagle Developer NJ

The project Business Application Development (BAD) involved development and maintenance of the internal application. The application used Eagle Star and Pace tool for manipulating Fund accounting related information. The clients used Star Web panels to enter the accounting related information, the application used the Pace uploaders to load external data into the application. Exporters were used to report the data back to clients.

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

The project ePACE Development involved loading the business data into the client side data warehouse called ePACE. Loaders were used to load the external data from flat files into the data warehouse. The business logic was then applied to the raw data using PL/SQL procedures, functions, packages to transform the data as per business standards. The exporters were used to export data to the internal reporting system called CRS.

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

Best Pricing was the internal client application for calculating the best price for the security. The application used to receive the security price data from various external vendors. This data used to get loaded in the client side data warehouse. Some business hierarchical rules used to get applied on all the possible prices in order to come up with the best price for a particular security for that day.

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

Confidential was the internal client application for developing and maintaining the data warehouse at client side. Loaders were used to load the external data from flat files into the data warehouse. The business logic was then applied to the raw data using PL/SQL procedures, functions, packages to transform the data as per business standards. The exporters were used to export data to the internal reporting system called CRS.

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.