Professional Summary

• Experience in Creating Tables, Views, and Sequences.
• 9 years of SQL and PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes and exception handling.
• Experienced in relational databases like Oracle 11g, 10g and 9i.
• 9 years of extensive experience in the IT industry in all phases of SDLC including requirement gathering, analysis, application design, development, testing, implementation and maintenance.
• Strong Knowledge of Loading Data using SQL Loader and PL/SQL.
• Have worked on trouble shooting, Query Optimization and performance tuning.
• Over 3 years of experience in writing UNIX Shell Scripts.
• Experience in creating JIL files and worked on Scheduling Autosys jobs and Control M.
• Experience in preparing unit test cases, conduct unit testing, assembly testing, system integration testing and provided support to business acceptance testing and post implementation support.
• Experience in Configuration Management, Release Management activities and also worked with change management team for the final project sign-off. Experience in project estimation, preparing status reports for the customer and preparing hand shake document for production support team.
• Experience in effectively handling team of 4 members
• Experience in trouble shooting failed mission critical production systems under extreme pressure conditions and time constraints including emergency code fix.
• Experience in production support model including Batch Support, Data Fix, Analyzing issues and generating Ad-hoc reports to customer.
• Beginner level experience in ABInito and Informatica ETL tool.

Technical Skills

Professional Experience

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Designed the control file to load data from flat files obtained from various interfaces using SQL Loader
• Created several UNIX shell scripts according to the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Generated PL/SQL scripts for data manipulation and validation and created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Developed triggers and audit tables for insert, update and delete on Master Tables for Audit purpose.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging to archive tables once it is processed successfully.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN and SQL TRACE.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and SQL plus.
• Used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application and Involved in the implementation and post implementation activities.
• Involved in the continuous enhancements and fixing of production problems.
• Improved the performance of the application by rewriting the SQL queries.

Environment: Oracle SQL, PL/SQL, Linux, Perl, TOAD, Autosys

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Writing Unix Scripts which is configured in CTRL-M Manager Tool which in turn calls Java program Batch Modules designed to call these business procedures based on steps configured
• Handling errors using Exception Handling extensively for the ease of debugging, displaying the error messages in the application and in the implementation and post implementation activities.

Environment: Oracle 9i, Oracle SQL, PL/SQL, Java, XML and XSL

Confidential

Role: L3 Support Engineer / Team Lead

Responsibilities:

• Leading the team for Maintenance, Enhancement and support.
• Interacting with end user to ensure customer satisfaction.
• Providing real-time production support for timely and correct fix to production problems
• RCA of major problems and incidents
• Continuous enhancements and fixing of production problems.

Environment: Oracle SQL, PL/SQL, Java, XML and XSL

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering the requirement with Business users and documenting the requirements
• Prepare system test cases and perform system testing.
• Played a major role during System Integration Testing and User Acceptance testing by interacting with the testers on functional related issues.
• Prepared change requests on new requirements.
• Analysis of Functional specifications communicating the same to team members.
• Creating various Crontab Jobs for automatic processing of reports and other processes.
• Creating database objects like tables, views, materialized views, procedures and packages.
• Handling errors using Exception Handling extensively for the ease of debugging, displaying the error messages in the application and in the implementation and post implementation activities.

Environment: Oracle 9i, Oracle SQL,PL/SQL, Servlets, JSP, EJB2.0 and HTML

Confidential

Role: PL/SQL Developer/ IT Engineer

Responsibilities:

• Requirement gathering/analysis, ensuring work monitoring/guidance, coordination with client/business
• Creating PL/SQL storedprocedures, functions and packages according to the project and client requirements.
• Generating PL/SQL scripts for data manipulation and validation and created scripts to create new tables, views and queries for new enhancement in the application.
• Creating indexes on the tables for faster retrieval of the data to enhance database performance.
• Detailed Design, Coding, Unit and integral testing.

Environment: Oracle 9i, Oracle SQL, PL/SQL, VB.net and XML

Confidential

Role: Programmer

Responsibilities:

• Creating PL/SQL storedprocedures, functions and packages according to the project and client requirements.
• Generating PL/SQL scripts for data manipulation and validation and created scripts to create new tables, views and queries for new enhancement in the application.
• Monitoring the Resource Utilization.
• Detailed Design, Coding, Unit and integral testing.

Environment: VB 6.0, Oracle SQL, PL/SQL

Confidential

Role: Software Engineer

Responsibilities:

• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data
• As a Developer responsible for Regular Modification in coding and business logic for the client.
• To provide support for Sales module, Non-Executive Information System, Production module and Cost Budget module.
• Involved on product testing after completion of development.
• Worked in Post Implementations Support.

Environment: Oracle SQL, PL/SQL