SUMMARY

• IT professional with 8+ 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.
• Involved in all phases of the SDLC (Software Development Life Cycle) from Analysis, Design, Development, Testing, Implementation and Maintenance with timely delivery.
• Expertise in writing Packages, Stored Procedures, Functions, Views, Database Triggers using SQL and PL/SQL in Oracle.
• Strong knowledge in Oracle Cursor management, Exception Handling, REF Cursors.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL and Analytical Functions.
• Experienced in Bulk Collections, PL/SQL Collections and Exception handling.
• Extensively used oracle UTL FILE package.
• Creating different kinds of partitions on tables and indexes.
• Experienced in Tuning Queries for better performance with large volume of data.
• Proficient in database and SQL tuning using HINTS, EXPLAIN PLAN.
• Designed and developed the Extraction, Transformation, and Loading (ETL) program to move data from source to target, mapping source data attributes to target data attributes.
• Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Strong in using tools such as SQL developer, SQL*Loader, SQL*Plus and TOAD.
• Troubleshooted, fixed, and implemented bug fixes and enhancements within tight deadlines.
• Experienced in writing UNIX shell script and PRO * C script and scheduled job using CTRL M tool.
• Experienced in writing 4GL scripts, stored procedures using Informix db.
• Worked on SAS scripting and debugging.
• Experienced in Unit testing and Integration Testing with excellent debugging skills.
• Excellent technical and analytical skills with clear understanding of OLTP and OLAP models.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

TECHNICAL SKILLS

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

Languages: Oracle PL/SQL, UNIX Shell Scripting, SAS, 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, Wilmington, DE

PLSQL Lead Developer

Responsibilities:

• Involved in gathering the requirements from client and in the analysis, design & development of the project.
• Interacted with End Users and other project members to collect, analyze and document user requirements.
• Wrote SQL queries using analytic functions.
• Experience in preparing and deploying complex schema updates, data migration and scripts.
• Comprehensive knowledge of waterfall and scrum methodologies.
• Improved performance of long running views and stored procedures.
• Developed oracle tables, views, triggers, synonyms, user defined functions, stored procedures, packages and indexes.
• Designed and developed several Pl/sql Stored Procedures, Views, User defined Functions for all the DML functionality.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Used Hints like append, no index, use index, driver site, etc., to improve the performance.
• Brief knowledge of cleansing and loading of data to different databases. Related Experience in developing/managing large-scale databases.
• Worked on creating Extracts (.csv files) based on end user requirements. Loaded new data into oracle tables.
• Worked on extracting data from different databases like Teradata, Sql Server and Load to Oracle database tables.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every month in Production, UAT, DEV Environments.
• Wrote Unix shell scripts for some static process to run in dynamic way.
• Wrote Unix shell scripts to automate the ETL process.
• Worked with SAS scripts for some minor enhancements.
• Plan production deployment activities, ITSM processes and coordinate with various teams like DBAs, Unix Admins etc.
• Ability to develop comprehensive test plans, scripts and cases and perform unit and comprehensive testing with system developers to ensure overall functionality and technical quality of deliverables.
• Scheduled job in Control M tool for automation.
• Worked on SAS scripts analysis and changes for automation.

Environment: Oracle 9i,10g,11g, SQL Developer, PL/SQL,SQL*PLUS, MS Office, Microsoft Outlook, Linux servers, Putty, Control M, Windows 7 professional and Unix, SVN,EURC,RSAM.

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, UTL FILE
• 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,11g, SQL Developer, PL/SQL,SQL*PLUS, MS Office, Microsoft Outlook, IBM Unix servers running AIX 5.3, Putty, Control M, 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 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,11g, SQL Developer, PL/SQL,SQL*PLUS, MS Office, Microsoft Outlook, IBM Unix servers running AIX 5.3, Putty, Control M, 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.
• Written UNIX shell Scripts for getting data from systems to Data Warehousing system
• Created CTRL M schedules/jobs for automation of ETL load process to run on regular intervals.
• Involved in SQL Activities.
• Actively involved in the production support and also transferred knowledge to the other team members.
• 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 Developer, SQL*PLUS, IBM Unix servers running AIX 5.3, MS Office, Microsoft Outlook, Putty, Windows 7 professional 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.

Environment: Oracle 9i,10g, TOAD, SQL*PLUS, MS Office, Microsoft Outlook, Putty, Windows 7 professional, Borland Starteam, Smartbear Code Collaborator V7, IBM Unix servers running AIX 5.3, Exceed and Unix .

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.
• Designed, developed and tested stored procedures, views and complex queries for Reports distribution.
• Tuned SQL queries using execution plans for better performance.
• 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: Unix, Linux, SQL *PLUS, Informix, 4GL, PL/QL, Crystal reports, IBM Unix servers running AIX 5.3, Borland Starteam, Putty, Smartbear Code Collaborator V7, Exceed.