SUMMARY

• Over 9+ years of experience in the IT industry, involved in analysis, design, development, testing and implementation of applications & maintenance of databases in Client/Server and Internet/Intranet environments
• 4+ years of Level 2 application production support.
• Expert in developing and deploying numerous Oracle objects PL/SQL Database Cursors, Triggers, Exceptions, Packages, Stored Procedures and Functions.
• Expert in RDBMS including Conceptual/logical & physical Database Design and Modeling using Erwin, Oracle 11g/10g/9i/8i, SQL Server, PL/SQL, TSQL
• Worked extensively on UNIX shell programming
• Experience in performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing and hints
• Expertise in Oracle features like SQL Loader, External Tables, Table functions, Analytic functions and Dynamic SQL.
• Worked with Toad, Quest and PL/SQL Developer
• Experience in Data warehousing OLAP tools (Crystal Reports, Business Objects)
• Involved in Unit Testing, UAT, Integration testing, System testing and GUI testing.
• Good functional noledge on financial accounting, Banking, Educational Institution business processes.
• Experienced working with clients on - site, analyzing software requirements and developing solutions and procedures
• Conversant with the complete Software Development Life Cycle (SDLC) of applications and meticulously confirm to quality procedures and standards.
• Possess a good noledge of gathering/ analyzing business requirements.
• Excellent Client interaction skills and proven experience in working independently as well as in a team

TECHNICAL SKILLS

RDBMS: Oracle 7.x/8i/9i/10g/11g, SQL Server 7.0 / 2000, TRANSBASE and MS Access

Operating Systems: UNIX (Solaris, HP-UX, Red Hat Linux), Windows 98/NT/2000/XP

Data base tools: TOAD 9.0, Oracle Enterprise Manager, SQL*Plus, Quest, PL/SQL developer and SQL developer

Data Modeling Tools: Erwin 3.5.2/4.0, Micro Soft Visio 2003

ETL Tools: Oracle Data Integrator (ODI), and SQL*Loader

Business Intelligent Tools: Crystal Reports, Business Objects XI Release 2, Oracle discoverer

Languages: C, C++, .NET, Java, ASP, SQL, PL/SQL, HTML, Visual Basic 6.0

PROFESSIONAL EXPERIENCE

Confidential

SR ORACLE DEVELOPER

Responsibilities:

• Performed intense analysis on existing business systems and provided solutions to enhance systems.
• Maintained and developed new systems to support the electronic parts catalogs application (over 33000 dealerships uses dis application)
• Developed software using Oracle 9i/10g PL/SQL, UNIX shell scripting, and Perl scripting programming languages.
• Tuned Oracle queries and optimized process to enhance application.
• Troubleshoot application flaws and generated accurate fixes in a fast paced environment.
• Used data modeling skills to improve existing de-normalized data model to enhance performance
• Created database objects like tables, views, stored procedures, functions, packages, triggers, and indexes.
• Independently debugged application and resolved production issues.
• Used in-house scheduler and generated operational instructions for publishing latest data per requirements.
• Involved in SBS system development life cycle, which include analysis, design, technical specification writing and testing application.
• Created shell scripts to transfer data from web SFTP server to Oracle directory on UNIX.
• Provided offline production support and responsible of defect fixes to application.
• Worked with ODI (Oracle Data Integrator) tool to publish various raw files formatted data into oracle tables.

Environment: Oracle 10g/11g (SQL, PL/SQL), PL/SQL developer, SQL*Loader, UNIX, Java, AccuRev (version control tool), JIRA (defects recording application), GMCP (in-house scheduler), SFTP, Microsoft Visio and ODI tool.

Confidential

ORACLE DEVELOPER

Responsibilities:

• Involved in complete software development life cycle
• Involved in Database designing using Microsoft Visio 2003
• Involved in understanding the SRA (System Requirements Analysis) document for designing the Database
• Responsible for preparing System Delivery Specifications / Technical System Design (SDS/TSD) document
• Extensively used tools like TOAD 9.0, Microsoft Visio 2003
• Successfully ran the batch cycle in Development and QA using SQL LOADER for loading the target tables.
• Developed mappings and transformations using PL/SQL procedures
• Involved in writing test cases for Unit testing the application
• Involved in scheduling jobs through UNIX Cron job
• Wrote shell scripts to run batch jobs and to invoke pl/sql procedures.
• Responsible for writing Install Scripts for migrating the code through various environments.
• Involved in preparing OpDocs to schedule daily, weekly and monthly cycles using control-M
• Developed various PL/SQL Procedures, Functions, triggers and Packages
• Extensively used Microsoft Visual Source Safe for maintaining the different versions of the code

Environment: Oracle 11g (SQL, PL/SQL), TOAD, SQL*Loader, Microsoft Visio 2003, ASP.NET, FTP, UNIX.

Confidential, NJ

ORACLE DEVELOPER

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation
• Developed logical and physical data models using Erwin, along with corresponding metadata, to support Adjudication Applications.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package

Environment: Oracle 11g (SQL, PL/SQL), Oracle SQL Developer, SQL*Loader, Erwin, ASP.NET, SharePoint Web Server 3.0, UNIX.

Confidential, OH

ORACLE DEVELOPER

Responsibilities:

• Involved in complete system development life cycle.
• Involved in the team for documenting functional and technical specifications, including specifications for others to build.
• Involved in modifying existing PL/SQL Procedures, Functions, Triggers and Packages and developing new ones.
• Developed procedures to run the SQL * LOADER to load data from various sources in the form of either Excel, CSV or flat files into the target database tables
• Developed Error Logging and Data logging to better understand the performance of the ETL procedures and to associate the errors to the procedures.
• Wrote SQL, PL/SQL, triggers, views and cursors for implementing business rules and data transformations.
• Extensively used various data transformation functions of PL/SQL.
• Extensively used tools like TOAD 9.0, Microsoft Visio, Power Designer 12.0
• Involved in preparing Operational Docs to schedule daily, weekly and monthly cycles using control-M.
• Created shell scripts to transfer data from web FTP server to Web Sphere Application server on UNIX system.
• Responsible for writing Install Scripts for migration of the code through various environments and implementing.
• Involved in Unit testing, Integration testing, Regression and UAT testing along with other team members.
• Provided post implementation support and involved in production support team.

Environment: Oracle 10g/11g (SQL, PL/SQL), DB2,MS Access, WebMethods, WAS6.0, SQL*Loader, UNIX, Control-M Enterprise Manager 6.2.01, Power Designer 12.0, Microsoft Visio, Quality Center 9.0.

Confidential, OH

ORACLE DEVELOPER

Responsibilities:

• Involved in complete system development life cycle.
• Prepared the user interface document and technical document based on the Functional specifications.
• Involved in redesigning and implementing the logical and physical database design according to new business rules.
• Created indexes and enforced uniqueness in order to improve the SQL performance.
• Developed stored procedures, triggers and packages in support of various new business applications and data security.
• As a part of performance tuning, rewrote Delphi embedded sql code into pl/sql programs.
• Scheduled jobs using shell scripts as a batch process to run on Maestro Scheduler along with DBA.
• Involved in SQL tuning and optimization, troubleshooting database problems, auditing and space management.
• Created test plans, test cases and was involved in Unit testing, Integration testing and parallel process testing along with other team members.
• Provided post implementation support and involved with production support team.

Environment: Oracle 9i (SQL, PL/SQL), Delphi 7, Microsoft Visio 2003, SQL*Loader, UNIX.

Confidential, OH

ORACLE DEVELOPER

Responsibilities:

• Involved in complete software development life cycle.
• Wrote clear program/module technical specifications, including specifications for others to build.
• Involved in creating triggers, stored functions, procedures, packages for complex business rules with built in function and aggregate functions.
• Designed and developed Oracle objects for high-performing Database Batch Processes.
• Provided automatic recovery and error logging for the main ETL process of loading data from one system to current system.
• Coded, tested and provided Quality Assurance support for very complex Oracle objects.
• Involved with training/testing team members to perform parallel processing testing for all migration systems.
• Provided performance tuning, profiling and monitoring of slow performing SQL.
• Troubleshoot problems and analyze solutions
• Responsible for providing production support after deploying new application

Environment: Oracle 9i (SQL, PL/SQL), TOAD, PL/SQL developer, Microsoft Visio 2003, Delphi 7, SQL*Loader, FTP, UNIX, Business Objects.

Confidential, OH

ORACLE DEVELOPER

Responsibilities:

• Involved in complete system development life cycle.
• Kicked off meetings with the clients (users) and gathered business requirements.
• Assisted in defining and involved in documenting functional specs and halped establish deliverables.
• Analyzed and Mapped conversion data elements from original legacy system to new system database Banner views and fields, and vice versa.
• Created SQL*Loader control programs and PL/SQL validation procedures to map data from different data sources to the Oracle Server.
• Functions and triggers were used at different levels in the all modules to perform various validation operations.
• Built interfaces to and from Banner for third party applications, Luminus/LDAP.
• Widely used the parameters facility in UNIX and PL/SQL to facilitate automation of the processes.
• Developed packages, stored procedures, functions for performing various calculations and converting COBOL based program of some of the departments into Oracle-based SQL scripts.
• Created shell scripts to transfer data from web FTP server to Oracle directory on UNIX.
• Involved in walkthrough code for team members and smoothly migrated code to production environment.
• Coordinated with the Testing team members to perform integration testing.
• Provided SQL tuning, table indexing, data migration, project migration, program debugging.
• Setup PL/SQL batch programs for taking periodic backups from the legacy system and updating them in the new tables.

Environment: Oracle 9i, 10g (SQL, PL/SQL), Forms 10g, TOAD 9.0, Banner 7.3, ASP.net, SQL*Loader, UNIX.