SUMMARY:

• 11 Years of IT experience in analysis, design, development, testing, implementation & maintenance of application software in Oracle, SQL, PL/SQL, and Unix
• Expert in creating tables, packages, stored procedures, advanced queries, triggers, views, indexes and functions for databases using SQL *PLUS, and PL/SQL.
• Worked extensively on performance tuning like giving the stats and also the Hints.
• Excellent skills in Designing and Development of applications using SQL, PL/SQL, Oracle Database 11g, 10g, 9i.
• Strong knowledge on oracle architecture and database design.
• Experience in Database design using Normalization and E/R diagrams using tools like ERWIN, VISIO.
• Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views.
• Extensively worked with collections to reduce the overhead and improve the performance using bulk collect and bulk bind. Also handled exceptions in collections using Save Exception and %BULK EXCEPTIONS.
• Experienced with DBA activities like granting and revoking privileges on database objects, creating synonyms and database links.
• Worked with Explicit Cursors, Inline cursors and REF Cursors and performed data manipulations.
• Worked on user defined exceptions, WITH clause, pipelined functions, retrieval of bulk data from collections using table() function.
• Experience in programming using Perl scripting
• Worked with data transformations and loading using Export/Import file packages and SQL* Loader and also created external tables to manage data which is stored at the operating system.
• Created Instead of triggers for updating join views with DML operations.
• Created Global temporary tables to maintain session data and improved the performance of data retrieval and created views, indexes on them.
• Resolved mutating table errors using the new functionality in Oracle 11g through Compound triggers.
• Worked with dynamic SQL queries by creating SQL queries at runtime using EXECUTE IMMEDIATE, DBMS SQL.
• Expertise in optimizing and tuning of SQL Queries and PL/SQL applications using utilities like Explain plan, TKPROF & hints, and scheduling the tasks using DBMS JOB/DBMS SCHEDULER.
• Created batch files for Windows environment for running the script files and scheduled them using Windows scheduler.
• Expertise in working with built - in packages like DBMS LOB, DBMS SQL, DBMS SCHEDULER, DBMS JOB, UTL FILE.
• Experience in unit testing and maintenance of the developed code.
• Strong experience of complete software development life cycle (SDLC) and software quality procedures and practices.
• Expert level experience with Oracle 11g, 10g, 9i.
• Expertise in working with development tools like SQL developer and TOAD.
• Excellent analytical skills, logical reasoning, and interpersonal skills.
• Unit testing and debugging the code using error log package.

TECHNICAL SKILLS:

Databases: Oracle 11g, Oracle 10g, Oracle9i, MS ACCESS

Languages: SQL, PL/SQL, Java

DB Dev. Tools: SQL Developer, TOAD, Oracle Enterprise Manager, SQL*Plus, SQL*Loader

Scripting: Unix shell scripting

Operating Systems: UNIX, Windows XP, MS DOS

XML Technologies: XML

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead - SQL/PL-SQL

Responsibilities:

• Creating the packages, Procedures and scheduling the Jobs.
• Analyzing the Business Requirements Document thoroughly and providing the inputs to the business analysts.
• Extensive experience on Working with the Unix Script, Creating the Unix script so as to automate the Jobs.
• Collaborated with Team on increasing the performance.
• Extensively usage of precursors and cursors.
• Expertise on debugging the code and creating exceptions to handle the bad data.
• Worked with Collections and improved the performance of multi-row queries.
• Designed the EOD batch in Autosys.
• Working on the BAU issues which is raised by L2 team, which involves functional and product understanding of Confidential Banking System.
• Working on the migration projects, in which data needs to be moved from the legacy system to the strategic system which is Confidential, this involes using the swisscom framework provided by Confidential, data analysis and data cleansing needs to be done.

Environment: SQL, PL/SQL, Toad 12.5, UNIX

Confidential

Project Lead - SQL/PL-SQL

Responsibilities:

• Created the procedures and maintained them.
• Extensively worked on Cursors.
• Worked with SDLC methodologies.
• Worked with collections and increased the performance of multi-row queries.
• Responsible for work distribution and ensuring deliverables deadlines.
• Responsible for the project management and task deliverables.
• Involved in coding and providing technical help to team members.
• Responsible for Requirement Gathering and Understanding
• Mainly working on Counterparty interface of Confidential European instance in Confidential . This involves writing PL/SQL Procedures, Packages, Triggers etc
• Analyzing client business needs and identifying technical solutions for the technical architecture and implementation approach for the proposed solution.
• Core development, Design changes, fixing issues and enhancements related to intraday and EOD trade loading.
• Involved in User Acceptance Testing.
• Development, maintenance and bug fixing of Confidential - PRISM reconciliations. PRISM is a Confidential GBM Risk System which provides a feed to Confidential on daily basis. The data in the feed is reconciled every day with data in Confidential . This reconciliation is done via Informatica Power center workflows.
• Involved in the migration of Oracle Database from 10g to 11g and also invloved in designing the strategy of how the migration will happen during the SIT and UAT cycle.
• Performance Tuning of the batch running in production and other database components.
• Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
• Prepared and setup of testing environment for QA team in the platform
• Developed the Feeds like Accrual, Value and Outstanding for the SGL (Single General Ledger) which contains the General Ledger data for the Confidential .
• Worked on the BAU issue which was raised by the Support team.
• Worked on the number of migrations involving LIQ, some of the migrations are ACBS to LIQ Migration, LIQ ASIA to LIQ GL migration, CBD to LIQ migration, Ulster to LIQ migration.
• Tunned the SGL batch of LIQ from 3 hours to 40 mins.
• Developed External tables for QA team for doing the feed comparision.

Environment: Oracle 11g, SQL, PL/SQL, Toad 10.8,SQL TRACE, TKPROF, Informatica

Confidential

Project Lead - SQL/PL-SQL

Responsibilities:

• Extensively used SQl loader and import/export toolbar to load the data from excel files into oracle.
• Extensively worked on cursors, sql joins (inner join, outer join, anti join), views, packages, procedures, functions.
• Expertise in debugging the code and creating the exceptions to handle bad data and send them to error log files.
• Worked on export/import commands to move the structure and the data from development to production.
• Conducted ETL performance tuning, troubleshooting.
• Analyzing client business needs and identifying technical solutions for the technical architecture and implementation approach for the proposed solution.
• Responsible for Requirement Gathering and Understanding
• Developed stored procedures and complex packages extensively using PL/SQL.
• Development, maintenance and bug fixes are being done which includes performance tunning, creating the complex stored procedure, writing analytical queries for the different calculations of figures.
• Query optimization has been done after liasing with the business users and DBA’s.
• Have working knowledge of Informatica, checking the session logs, run properties of the session and then fixing any data issues or any mapping issues as part of the EOD batch.
• Tune the EOD batch of Client Mart application from 12 hours to 8 hours which help the users of Client Mart to view the reports on time.
• Developed shell scripts to send notifications after the process of data creation is complete.

Environment: Oracle 11g, SQL, PL/SQL, EXPLAIN PLAN, SQL Developer 3.0.03, Informatica

Confidential

Technology: Oracle 10g/11g

Senior Developer - SQL/PL-SQL

Responsibilities:

• Involved in development and enhancement of various modules.
• Exposure to Java language
• Wrote packages, stored procedures for storing the client information and modifying the views to resolve any possible bugs.
• Created database objects such as tables, views, synonyms, indexes and sequences.
• Created views based on multiple tables and performed data changes using Instead of triggers for the underlying tables.
• Setup run time environment, creating and maintaining shell scripts to run stored procedures, packages to populate the valid data in staging tables and invalid data into error tables which will be sent back to sender notifying the errors.
• Constructed the required data involving complex JOIN statements, including outer-joins, intersect and union all.
• Worked with Collections and improved the performance of multi-row queries by using Bulk Collect and Bulk binds.
• Used DBMS JOB to automate the regular tasks and improve time-constrained performance.
• Tuned SQL statements using Explain plan, TKPROF for maximum efficiency and performance.
• Wrote SQL, PL/SQL programs to retrieve data from data repository using cursors and exceptional handling.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Created PL/SQL Procedures, Functions, Triggers and Packages to meet the business requirement of the project.
• Avoided mutating table errors using the new functionality in Oracle 11g i.e., Compound triggers.
• Used Global Temporary tables to access the repeated data within a session and improved the performance.
• Used SQL loader for importing the flat files which consists of several records of customer’s information into the different tables in the database.
• Unit testing the PL/SQL code.

Environment: Oracle 11g, SQL, PL/SQL, EXPLAIN PLAN, SQL developer, UNIX.

Confidential

Technology: Oracle 9i

SQL/PL-SQL Developer

Responsibilities:

• Developed and modified stored procedures for retrieval of data according to search criteria like readings from a particular location during a period of time.
• Generated SQL queries to fetch complex data from different tables in the database using joins, and formatted the results.
• Involved in implementing data integrity validation checks through constants and triggers.
• Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views for remote instances.
• Used Nested tables, Varrays extensively with bulk collect for accessing complex data resulted from joining of large number of tables to extract data from database.
• Resolved mutating table errors by creating global variables inside a package, then creating a row level trigger including the global variables and then creating a statement level trigger implementing the required functionality.
• Created complex SQL queries using inline views, sub queries, correlated sub queries.
• Worked with package DBMS JOB for scheduling the tasks.
• Created SQL loader control files to load multiple records into the database.

Environment: Oracle 10g, SQL, PL/SQL, Sql trace, TK PROF TOAD 9.5, UNIX

Confidential

SQL/PL-SQL Developer

Responsibilities:

• Involved in design and development phase of the business requirement.
• Created PL/SQL code to implement business rules through triggers, procedures, functions and packages using SQL editor or Toad.
• The data from flat files are to be loaded into the database using SQL Loader.
• Enabling and disabling of roles at runtime, based on user responsibility.
• Worked extensively on complex SQL scripts which were used for reporting purpose.
• Analyzed high volume data to increase the performance of stored procedures using Explain plan and Hints.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Created database triggers to enforce security and worked with shell scripts.
• Monitored log files regularly for data extraction and taking actions based on the problems.

Environment: Oracle 9i, SQL, PL/SQL, SQL Developer, UNIX

Confidential

SQL/PL-SQL Developer

Responsibilities:

• Wrote larger and complex PL/SQL procedures and functions to efficiently perform complex business logic to summarize data
• Created Tables, Views, Constrains, Synonyms, Sequences.
• Created Materialized Views
• Involved in client acceptance testing
• Worked with the database links to get the data from different database.
• Created new tables according to the requirement and used them in the procedure which is created.
• Assited the client for changing the datatypes of the columns.
• Analyzed data to increase the performance of stored procedures using Explain plan and Hints.

Environment: Oracle 9i, SQL, PL/SQL, SQL Developer, UNIX