Summary:

A Certified Oracle programmer with over 10 years of experience in designing and building custom applications using Oracle databases and tools in UNIX and Window environments. As part of the assignment, I have been in application maintenance, debugging, development and client interaction.

ACHIEVEMENTS:

• Actively participated in CMMI Level 5 standard processes.
• Actively participated in Science Colloquium activities in College.
• Was awarded the best employee award in SAIC.
• Scored heavily in laboratory subjects related to microcontroller, Control Engineering and Testing and C programming.
• Have exposure to data integration and IT security measures like SSO which play a crucial role with respect to asset management and virtualization concept.

TECHNICAL SKILLS:

Software Hardware

PL/SQL, SQL, VBA, JAVA, C, C , HTML Windows 98/XP/2000, UNIX, LINUX.

Tools Management Experience

TOAD, SQL PLUS, SQL LOADER Handled a team of 10 in SAIC

ESSBASE SQL Developer

Domain Experience

Power distribution and Services, Single Sign

On, Financial Services Telecommunication Services

Professional Experience:

Confidential

Role: PL/SQL Consultant

Responsibilities:

• Interacting with business owners related to Business As Usual Change Requests.
• Developing Oracle packages, procedures and functions that interact with different modules related to Java, Oracle SOA and Oracle Financial Services.
• Working on defects related to Business As Usual Change Requests.
• Debugging business scenarios and analyzing corresponding transactions.
• Working with team on emergency situations based on business requirement.
• Coordinating with team on Data Integrity issues.
• Providing solutions based on Object Relational Programming and Collections.
• Providing design solutions on technical issues like deadlocks.
• Module design related to configurations for various business entities related to handsets.
• Discussing process implementation related to Change Requests.
• Coordinating with team on performance tuning of various functionalities.
• Working on Shell scripts to schedule jobs and different transactions.
• Importing and exporting data using SQL Loader and SQL Developer Import/Export.
• Checking in scripts using CVS.
• Coordinating with various teams on Code deployment and Release.
• Discussing with team on improving quality of code to ensure that future change requests do not affect the stability of the code and production environment.

Technical Skills:

Oracle 11g PLSQL/SQL ,Java, Unix shell scripting .

Confidential

Role: Developer

Responsibilities:

• Interacted with customers traders /end users to gather business/report requirements.
• Responsible for all the risk management tools for derivatives,Funds,Bonds, Fixed Income of the bank.
• Developing End of reports for traders checking their Risk, Profit and loss for their respective portfolio's.
• Reconcillation between upstream and downstream systems for all the trades wr.t day , month , quarter and year.
• Designed the Database Architecture - Table structures, Triggers, Complex stored procedures, Cursors, Primary Key/ Foreign Key Relationships, Table valued and Scalar Value Functions.
• Analysis, design, development, testing, integration and implementation of new functionalities and functionality changes according to business requirements.
• Performance improvement of several time taking procedures which was causing a delay in the subsequent processes as well. This could some time create inconvenience to the users due to information which was not timely updated.
• Participate in definition, design, and review of software architecture, design, frameworks and interfaces.
• Implemented many Batch Scripting Tasks, Schedules packages and jobs.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and
• Collections to implement business logic using TOAD.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.
• Suggested changes based on DBMS SCHEDULER and automation of Hyperion Essbase Maxl scripts.

Technical Skills:

Oracle 10g/11g plsql, sql , AIX Unix/linux , Java

Confidential

Responsibilities:

Team Strength: 10

• Disclosure is a website used for SEC Reporting. It is based on C and Oracle.
• Developed Oracle packages related to Workflow and Reporting.
• The basic functionalities involved were Approval process, Rejection Process, Aggregation and

Role / Responsibility assignment.

• Had an opportunity to convert a table of records in PL/SQL using cast operator and an Object type Into .Net table.
• Used Bulk insert and Bulk Update to update and insert the records in the base table.
• Performed all the above steps as in Greensheets and the methodology used was Agile in Sprints. Attended Scrum meetings with respect to the same.
• Sprints were for a period of 2 weeks.

Confidential

Responsibilities:

Team Strength: 10

• Develop plsql queries and packages for ecf meta and corpfin schema.
• Participate in meetings for cube build.
• Work on autosys jobs to schedule Essbase processes.
• Created views based on the fact tables and dimension tables.
• Assisted team in building Essbase outline.
• Created Rule files for loading data into the database.

Confidential

Team Strength: 6

• Developers will check in the scripts into clearcase.
• We have to validate the scripts and then raise nexus requests for DBAs to implement the scripts.

Environment:

TOAD, Microsoft Visual Studio,Hyperion Essbase,AIX,IBM Clearcase.

Database/Servers: Oracle 10g/11g.

Confidential

Role: Enhancement and Support

Responsibilities:-

Team Strength: 10

• Enhancement of PL/SQL packages, procedures and subprograms that were involved with
• Oracle Single Sign On.
• Design and Development of a scalable utility to identify customers for deactivation/reactivation of the accounts. PL/SQL packages
• Involved in deployment and build of Application with Java as front-end.
• Requirements gathering, impact analysis and devising the best possible solutions.
• Exhaustive unit testing of all the modules built.
• Guiding and helping the team in completing tasks. Meeting with users for requirements collection.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopment LifeCycle .
• Performed Database Administration of all database objects including tables, indexes, views, sequences packages and procedures.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Technical Skills:

Oracle Workflow, Oracle 9i, Toad, UNIX

Environment: TOAD, SQLPlus.

Database/Servers: Oracle 9i

Confidential

Role: Programmer Analyst

Responsibilities:

• Involved in the coding of PL/SQL programs based on the Requirements Document and Mapping Document for Complex Mapping rules to automate the test design for Energy Applications like BSMART, SPA MRM.
• Coded using UTL FILE for files in Unix and Oracle 8i.
• Coordinating with development teams to test the data in the database.
• Created Tables, Views, Constraints, Index B Tree, Bitmap and Function Based .
• Involved in testing of application by Unit Testing, Integration Testing, User Acceptance Testing UAT and End User Support.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Wrote SQL, PL/SQL, SQL Plus programs required to retrieve data using cursors and exception handling.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• The processes included SPA, MRM, BSMART, Gasgate and Electricity Applications. As part of the knowledge transfer process went onsite for better understanding of the system.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Technical Skills:

Oracle 7/8/9, UNIX

Environment: TOAD, SQLPlus, SQL Loader

Confidential

Role: Software trainee

Technical Skills:

JCL, CICS, DB2, MVS, COBOL