Professional Summary

• 7 years of extensive experience in the IT industry in all phases of SDLC including requirement gathering, analysis, application design, development, testing, implementation and maintenance.
• Experienced in relational databases like Oracle 11g, 10g and 9i.
• SQL and PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes and exception handling.
• Expertise creating Tables, Views, and Sequences.
• Strong working knowledge of Loading Data using SQL Loader and PL/SQL.
• Extensive experience in trouble shooting, Query Optimization and performance tuning.
• 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 providing 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 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

Technical Skills

Professional Experience:

Confidential

Oracle Developer

Responsibilities:

• Designing the control file to load data from flat files obtained from various interfaces using SQL Loader.
• Creating several UNIX shell scripts according to the project and client requirements.
• Writing 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.
• Generating 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.
• Developing triggers and audit tables to 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.
• Creating indexes on the tables for faster retrieval of the data to enhance database performance.
• Using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files for data loading.
• Performing SQL and PL/SQL tuning and application tuning using various tools like EXPLAIN PLAN and SQL TRACE.
• Creating PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creating of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and SQL plus.
• Using the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handling 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.
• Participating in the continuous enhancements and fixing of production problems.
• Improving the performance of the application by rewriting the SQL queries.

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

Confidential

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.
• Used exception handling extensively for the ease of debugging, displaying the error messages in the application and in the implementation and post implementation activities.
• Lead the team for Maintenance, Enhancement and support.
• Interacted with end user to ensure customer satisfaction.
• Provided real-time production support for timely and correct fix to production problems.
• RCA of major problems and incidents.
• Performed continued enhancements and fixing of production problems.

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

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Gathered the requirement with Business users and documented the requirements.
• Prepared 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.
• Analyzed of Functional specifications communicating the same to team members.
• Created various Crontab Jobs for automatic processing of reports and other processes.
• Created database objects like tables, views, materialized views, procedures and packages.
• Handled 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, HTML

Confidential

PL/SQL Developer

Responsibilities:

• Gathered requirements/analyzed, monitored work, coordinated with client/business
• Created PL/SQL storedprocedures, functions and packages according to the project and client requirements.
• Generated PL/SQL scripts for data manipulation and validation and created scripts to create new tables, views and queries for new enhancement in the application.
• Responsible for regular modification in coding and business logic for the client.
• Provided 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.
• Monitored the Resource Utilization.
• Created 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/SQLand XML