PROFESSIONAL SUMMARY:

• 6 years of experience in RDBMS concepts and Application Development, Testing and Implementation using Oracle 11g/10g/9i/8i, MS Access, SQL, PL/SQL, Query Optimization, Performance Tuning and Troubleshooting
• Extensive experience in writing SQL queries and PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Exception Handlers, Database Objects and Collections.
• Also experienced in experience in analysis, design, development and implementation of ASP . NET, PHP,C++, C, XML, HTML, VB.NET, Unix, Oracle11g, Networking Classes and IP address Sybase technologies solutions utilizing Object Oriented Analysis and Design techniques (OOAD ).
• Monitoring and optimizing the Database Performance through Database Tuning, and Application Tuning.
• Proven ability to plan, coordinate and implement Software Development Life Cycle processes.
• Experience in developing web applications using technologies like HTML, Java Script, CSS, JSP
• Excellent exposure to Object Modeling Techniques like use cases.
• Good understanding of OOAD principles and experience in architecting ASP.NET, VB.NET, HTML, XML, and PHP based solutions
• Developed Shell scripts in Korn /Bash and used Cron Jobs for Automation.
• Possess the ability to work in self - managed and team environments.
• Multi-talented with excellent communication skills, strong decision making, organizational, coordination, planning, and execution skills.
• Ability to handle multiple tasks and to work independently as well as in a team, experienced in interacting with Business/Technology groups.
• Exceptional ability to quickly master new concepts, Team facilitator and Leadership qualities.

TECHNICAL SKILLS:

Operating System: Novell NetWare 3.x, UNIX, Sun Solaris2.5, Linux, MS-DOS, Mac, Windows. (Vista, XP, 2003, 2000, NT, 9x), Windows Server 2003/2008

Database: Oracle 11g/9i/8i/8.0, SQL Server 6.x/7.0, Blend SQL Server, Oracle Apps(11g), Access

Languages: ASP.NET, XML, PHP, C, C++, java script, Ajax, Action script, Flash, HTML, DHTML, VB, Dream-Weaver

Oracle Tools: TOAD, SQL Developer 2000, SQL*Plus, SQL*Loader, SQL Navigator, Oracle Designer, Oracle Enterprise Manager, DBM

Reporting Tools: Oracle Reports 9i / 6i / 2.5, Crystal Reports

Networking: Networking TCP/IP

Other Tools: FrontPage, MS Office Suite, Adobe, Contribute and Photoshop

WORK EXPERIENCE:

Confidential

Oracle Pl/SQL Developer

Responsibilities:

• Embedded HTML and Java Script in PL/SQL Program units using HTP package.
• Maintained standardization and also uniformity using SDLC for business requirement
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 10/11g.
• Created partitions on the tables to improve the performance.
• Involved in the pre-production tasks in the data conversion process
• Responsible for maintaining communications with clients through the various phases of a project.
• Worked on the Email notification programs to notify the users of recent load information.
• Designing report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports and report data export to XML format.
• Used SQL* Loader to upload bulk data by writing scripts for the Control file.
• Created partitions for parallel processing of data
• Developed User interface using Oracle Forms and Reports.
• Created LOVs, Menus, Program Libraries and Canvases for front-end interface.

Environment: Oracle 11g/10g, Oracle 11g Forms, Oracle 11g Reports, HTML,UNIX, Win-2000, Power Builder, SQL Navigator, SQL * PLUS, TOAD..

Confidential, Mansfield TX

Oracle Developer

Responsibilities:

• Coordinated with DBA in creating and managing tables, indexes, database links and privileges
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object types and Triggers
• Developed SQL Queries to fetch complex data from different tables using joins, database links and formatted the results into reports and kept logs.
• Developed screens and reports using Oracle Forms/Reports 9i and PL/SQL
• Used bulk loading, multi table inserts, Composite objects (Varrays, Nested Tables, Index By Tables) extensively in PLSQL
• Performance Tuned long running report queries by creating indexes on tables, using parallel hints in report queries, creating Global temporary tables
• Utilized SQL*Loader to load flat files database tables
• Utilized PL/SQL developer tool in developing all back end database interfaces
• Responsible for performing code reviews
• Developed user documentation for all the application modules
• Involved in performing User Acceptance Testing (UAT) with business users.

Environment: Oracle 10g, SQL*LOADER, Windows XP, PL/SQL, SQL*PLUS, TOAD

Confidential, Madison, WI

Oracle Developer

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements.
• Used ERWIN for logical and physical Database Modeling. Analyzed Business documents, Internal & External Source systems and requirements to develop the Logical and Physical model (Facts and Dimensions) and Business Process Model.
• Wrote complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Optimized and tuned PL/SQL to reduce the loading process. Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Created Packages, Procedures and Functions that extensively used PL/SQL cursors, user defined object types and exception handling.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Used SQL trace facility and TKPROF along with Explain Plan to accurately assess the efficiency of the SQL statements when the application runs.
• Generated various timely based Reports and also modified the discrete job data Reports to add custom fields, and altered layouts as per client requirements
• Developed necessary Forms based on the business requirements using Forms 9i.

Environment: Oracle 9i/10g, SQL, SQL*PLUS, SQL*Loader, TOAD, PL/SQL, UNIX (Korn, Bash) Shell Scripts, Business Objects.

Confidential

Oracle Programmer/Analyst

Responsibilities:

• Generated designs using Oracle designer and power designer.
• Implemented the scripts on test, system and production environments.
• Involved in designing user interfaces and programming using SQL, PL/SQL.
• Retrieved the data from the database, manipulated and modified the data using various DML, DCL and DDL commands.
• Created views and triggers based upon the required functionality.
• Created extra table spaces and fine tuned the codes.
• Worked on DCL to grant privileges and revoke them from the listed users.
• Handled requests sent by other departments and created appropriate views for them to access database.
• Worked as UNIX programmer for implementing data in production environment through batch cycles.
• Automated the cycles of production environment and tracked daily event log reports.
• Managed project development starting from design aspects, testing and providing programming skills related to oracle application modification and implementation of code.

Environment: Oracle 8i, SQL*PLUS 8i, Oracle Developer 2000, Oracle PL/SQL, TOAD 7.2, HP UX 11i.

Confidential

Oracle Developer

Responsibilities:

• Involved in requirement analysis and design.
• Coded Stored Procedures, functions and triggers at High level.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Prepared proper backup and recovery plans.
• DBA activities like creating users, roles and granting and revoking privileges.
• Technical assessment of modules.
• Preparing Functional and Program Specification Documents.
• Implemented project at client place.
• User and technical support.

Environment: Oracle 8i, Forms 6i, Reports 6i, SQL Loader, Toad, Windows 2000 Professional