SUMMARY

• IT professional with 9+ years of diverse experience in IT, including business analysis, applications management, strong software development skills and a solid technical aptitude for troubleshooting and problem solving.
• Excel in identifying system needs, implementing multi - faceted application solutions, and working with a variety of operational systems, software, development languages and tools.

TECHNICAL SKILLS

Operating Systems: Linux, Unix, IBM AIX 5.3 and Windows 95/98/2000/NT/XP

Languages: Oracle PL/SQL, UNIX Shell Scripting, Pro C, 4GL

Databases: Oracle8i, 9i, 10g & 11g, Informix

Tools: SQL*Plus, SQL* Loader, SQL Developer V 1.5.0.54.40, CTRL M

Supporting Software: Borland StarTeam, Putty, Smartbear Code Collaborator V7, Exceed

Middleware/Distributed: Web services

Others: HTTP/HTTPS, FTP

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

PLSQL Lead Developer

Responsibilities:

• Working on the service request and business enhancements raised by client
• Analyzing the business requirement and possible Impact of the proposed enhancement.
• Propose a reliable solution for the requirement and preparing the technical understanding document.
• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on service requests.
• Created and maintained database objects like tables, views, Indexes, triggers, and synonyms to meet the business requirements.
• Wrote complex SQL queries, Sub queries and nested loops for faster data retrieval.
• Created Cursors and Ref Cursors to process the required data.
• Used Bulk Collect and FOR ALL to DML multi-row from table.
• Understanding the business logic to modify existing SQL Code and Performance Tuning, indexing, table partitioning.
• Extensively worked through SQL Developer and SQL Plus for database development and tuning.
• Used Oracle packages - DBMS STATS, UTL FILE
• Created data load process to load data from OLTP sources into Netezza
• Used exception handling methods along with pragma exception init in order to associate our own created exception names for the ease of debugging and displaying the error messages in the application.
• Created batch jobs to load data into our database using UNIX Shell Script and Control - M scheduling.
• Developed pl/sql program unit to test the business logic in testing environment.
• Analysed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Provided technical design and documentation for new development and existing system enhancement.
• Worked with testing team for test case and test script preparation.
• Coordinated with QA and Testing team and provided the technical support for business implementation.
• Worked as independent contributor for the project

Environment: Oracle 9i,10g, SQL, PL/SQL,SQL*PLUS, MS Office, Microsoft Outlook, IBM AIX, Putty, Windows 7 professional and Unix.

Confidential, San Antonio, TX

Oracle PL /SQL Developer

Responsibilities:

• Writing pl/sql procedure/packages/functions to resolve the daily task related issue to make them atomized.
• Created scripts to load the data into database tables from flat files using SQL* Loader.
• Created stored procedures with cursors to generate the reports.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Involved in loading files to tables using NZLOAD and extensively used NZSQL
• Involved in production support by efficiently debugging the production issues.
• Created indexes, constraints, triggers, synonyms in different schema.
• Worked on Oracle Data dictionaries views to get information related to object
• Worked on Bulk Collection and Pl/sql table for getting optimal performance.
• Wrote Shell Scripts to do manipulation on vendor input files and loaded into database table
• Generating various reports on requirements using PL/SQL, ProC and SQL * plus SPOOL command.
• Involved in job scheduling using CTRL M.
• Peer Review of code before turning over to production.
• Preparation of Unit Test plan.
• Perform System Testing, Release Testing and deploy the code.
• Coordinating with onsite, attending regular hand-off and transition meetings for new projects.
• Providing Knowledge transition on delivered effort to Production Support team.

Environment: Oracle 9i,10g, SQL, PL/SQL,SQL*PLUS, MS Office, Microsoft Outlook, IBM AIX, Putty, Windows 7 professional and Unix.

Confidential, San Antonio, TX

Oracle PL/SQL Developer

Responsibilities:

• To find out bugs in the application and rectify them.
• To prepare document as per the changes in the code.
• Developing Unix shell script to validate the input feed files received from different vendors.
• Used various Shell Scripts and Scheduled jobs in CTRL M to run on regular intervals.
• Involved in SQL Activities.
• Involved in Unit testing, Debugging and Integration testing of the application.
• Peer Review of code before turning over to production.
• Managing Monthly release for all applications development, bug fixes.
• Involved in client meetings.
• Worked as independent contributors.

Environment: Oracle 9i,10g, SQL, SQL*PLUS, MS Office, Microsoft Outlook, Putty, Windows 7 professional, Winscp and Unix .

Confidential, San Antonio, TX

Oracle PL/SQL Developer

Responsibilities:

• Worked on project estimates, resourcing, status updates, project plan updates, and team coordination.
• Preparation of Checklists, identification of Test Cases, preparing Test Plans.
• Developed Pro C scripts with embedded pl/sql and sql.
• Wrote Unix shell scripts to invoke the Pro C executables.
• Scheduled all scripts in CTRL M.
• Extensive Knowledge and working of Bulk Collect and Bulk Binding for data retrieval.
• Wrote complex SQL queries, Sub queries, Cursors and Collections for faster data retrieval.
• Involved in Performance Tuning for the SQL, PL/SQL scripts.
• Coordination with the Release Management team to ensure the version control of the scripts execution in Production environment.
• Provided knowledge transfer to other team members about the new technology and allocation of tasks to the team.
• Involved in writing technical documentation, and writing test plan.
• Coordinated with development team, project management, QA and provided necessary support.

Confidential, San Antonio, TX

Oracle PL/SQL Developer

Responsibilities:

• Working up with Service requests/change requests.
• Impact analysis on existing system and provided appropriate solution.
• Enhancing existing 4gl scripts to implement the business logic.
• Structural changes to Informix database objects according to business logic.
• Wrote Unix shell scripts to validate and manipulate the vendor files.
• Created Unix Shell Scripts for automating the execution process of 4gl reports.
• Used File Transfer Protocol (FTP) tool to transfer files from one server to other.
• Worked on CTRL M for Scheduling Batch Jobs.
• Involved in Unit testing, Integration test and writing the Test plan.
• Preparing the technical documentation on changes done.
• Release notes and Rollout and Backout plan.
• Trained other team members on the functionality and operability of the application.

Environment: Informix, 4GL, Crystal reports, Unix, Linux, IBM Unix servers running AIX 5.3IBM AIX, Borland Starteam, Putty, Smartbear Code Collaborator V7, Exceed