SUMMARY:

• 7+ years of IT experience in Enterprise Application Development using Oracle Technology.
• Extensive business knowledge in the domains of Financial, Banking, Health Care, Medical and Manufacturing System.
• Experience in different phases of Software Development Life Cycle SDLC such as Requirements Analysis, Process Engineering, Design, Development, Deployment, Testing, and Support.
• Extensive knowledge in Client/Server Technology, GUI Design, Relational Database Management Systems (RDBMS), and Rapid Application Development Methodology.
• Extensive experience in Database capacity planning and Data Warehousing with ETL Tools.
• Experience in Oracle 11g/10g/9i in installation, configuration, maintenance, upgrading and Development.
• Experience with Oracle Application using SQL, PL/SQL, Stored Procedure, Trigger, Packages, Shell Scripting and Java Packages.
• Extensive experience with Application Development tools SQL*PLUS, iSQL PLUS, TOAD, SQL Developer, Oracle Forms Builder (10g/9i/6i), Oracle Report Builder (10g/9i/6i), JDeveloper and SQL Navigator.
• Extensive experience in developing all database objects such as Stored Procedures, Functions, Packages, Triggers, Cursor, Ref Cursors, Constraints, Indexes like B - tree Index and Bitmap Index, Views, Materialized Views, Database Links and user-defined datatype.
• Experience on Logical / Physical data models, Conceptual Design & Data Architecture using ERWIN.
• Extensive experience with performance tuning, optimizing SQL queries, and stored procedures using Analyze, EXPLAIN PLAN, DBMS TRACE and tuning oracle database initialization parameters.
• Extensive experience with SQL Loader, External Tables, Oracle HT Services, Export/Import for Logical Backups.
• Good knowledge of ETL Process for Extraction, Transformation and Loading of data from multiple source Database Systems to Data Warehouses using Oracle Warehouse Builder (OWB), Informatica and SQL Loader. Experience in Coding ETL Logic.
• Good understanding and experience with Oracle Internals such as tuning init.ora parameters, SGA and Oracle Data Dictionary.
• Experience with Bulk Collect and PL/SQL tables.
• Strong experience with Unix/Linux shells scripting such as sh, bash, csh and ksh.
• Strong experience in Database Migration & Up gradation from 8i to 9i and from 9i to 10g.
• Basic DBA activity- Creating and Managing Oracle Database server, Proactive Monitoring and Performance Tuning, Storage Management and Maintenance (Tablespace, Datafiles, Tables, Indexes etc.), Database security (User & Resources, User Privileges & Roles).
• Extensive experience in Stats pack, AWR, ADDM, DBMS SYSTEM, SQL ADVISOR, DBMS STATS, Explain Plan, SQL Trace and TKPROF.
• Experience in Oracle 10g Flashback utilities and Archive Log mode.
• Knowledge on Installation and Configuration of Clusterware, CRS, OCFS, RAC and ASM for high availability databases. Experience in Installation, configuration and maintenance of Oracle 10g RAC, 10g Clusterware.
• Good experience with Oracle Application servers Oracle9iAS/Oracle10gAS installation, configuration and administration.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008 R2/2005/2000, MS Access.

Design /Modelling: ERWIN, Microsoft Visio, Microsoft Team Foundation Server(TFS)

Scripting /Languages: PL/SQL, Unix, Shell Script, C/C++, JavaScript, HTML

GUI Tools: Oracle Forms Builder 10g/9i/6i, Oracle Reports Builder 10g/9i/6i,VB 6.0, Power Builder

Database Tools/Utilities: SQL*PLUS, TOAD 8.0/9.1, SQL Developer, iSQL*PLUS, Oracle Enterprise Manager (OEM), DBCA, DBUA, Oracle Net Manager, LSNRCTL, RMAN, SQL Loader.

ETL Tools: Oracle Warehouse Builder (OWB), Informatica

Operating System: Windows XP/ NT/ Professional, Windows Server 2000/2003, Windows Vista, Red Hat Linux 4.0/4.7, AIX, Sun Solaris 8/9, MSDOS.

OS Tool: PuTTy, FTP

Application Software: MS Excel, MS Power Point, MS Word, MS Out Look

PROFESSIONAL EXPERIENCE:

Confidential, Eatontown, NJ

Oracle Pl/Sql and Apex Developer

Responsibilities:

• Developed and customized various database programs in the Oracle Applications.
• Analysis of data flow and performance comparison between Development, QA and Production database.
• Developed and tuned database programs such as PL/SQL stored packages, procedures, functions, triggers, Cursor, Collections, Object Types in Oracle Apps.
• Responsible for GL query optimization and performance improvement in Oracle Apps.
• Worked on Partitioning of Oracle General Ledger Tables for overall performance improvement.
• Worked on FDW latency improvement for Data Ware House Database.
• Utilized PL/SQL developer tools and TOAD in developing all back end database programs.
• Utilized SQL*Loader to load data from flat files to the database tables for QA and test environment.
• Developed web-based applications using Oracle Apex.
• Responsible for SQL tuning and optimization using Analyze, Explain Plan, TKPROF utility and optimizer hints.
• Created the DML scripts for test case to compare performance in Development and QA & Testing and Production Database.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Used and suggested SQL hints and indexes to improve SQL performance in back end database programs.
• Used EXPORT and IMPORT utilities to copy data between different schemas in Oracle Apps Databases.
• Developed user interface using Oracle Forms Builder and reports using Oracle Reports Builder according to the requirements.
• Customized user interface using Oracle Forms and analytical reports using Oracle Reports.
• Coordinated with technical development managers, development team, and production support team and with DBA to ensure database performance and reliability.
• Coordinated with DBA in administering database security, creating users, granting/revoking roles, privileges, extending databases storage capacity, monitoring and reducing database fragmentation, re-indexing and for concurrent manager process improvement.
• Experience in Microsoft Team Foundation Server (TFS) for source control, project tracking and reporting.

Environment: Oracle11g, Forms10g, Reports10g, SQL*PLUS, PL/SQL, SQL*LOADER, Oracle Apex, Oracle Toad 9.1.0, iSQL*PLUS, SQL*Net, Export/ Import, ERWIN, Microsoft Team Foundation Server(TFS), Windows 2003, Windows XP, Linux RHE 4.0.

Confidential, New York City, NY.

Oracle PL/SQL and Apex developer

Responsibilities:

• Actively involved in requirements gathering and analysis of all business functionalities related to back end database interfaces. Map new business requirements to enhance existing database models and applications.
• Developed back end interfaces using PL/SQL stored Packages, Procedures, Functions, Triggers, Cursor, Collections, Object Types.
• Utilized PL/SQL Developer Tools and TOAD in developing all back end database interfaces.
• Utilized SQL*Loader to load data from flat files to database tables.
• Responsible for SQL tuning and optimization using Analyze, Explain Plan, TKPROF utility and Optimizer hints.
• Developed front end interfaces using Oracle Forms10g, different historical and analytical reports using Oracle Reports10g.
• Created the DML scripts to populate sample data in development and test environment to support the development and testing team needs.
• Performed testing the database applications and implemented indexes on tables for better performances on data retrieval from oracle databases.
• Suggested and converted several existing User Interface tasks to PL/SQL database procedures using reference cursors to improve performance.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Used DBMS JOB Oracle standard package to automate / schedule jobs on daily, weekly and monthly basis.
• Performed trouble shooting of database related production problems.
• Developed business logic using PL/SQL for Oracle Apex applications.
• Also involved in the development and testing of oracle apex applications.
• Developed Unix shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Used EXPORT and IMPORT utilities to copy data between schemas on different databases (TEST and DEV).
• Migrating Data between Oracle database 10g and SQL Server 2005.
• Collected user requirement, analyzed and defined business information needs for Data Warehouse. Completed the logical data modeling, ETL process design to extract, transform and load data using Oracle Ware House Builder 11g.
• Coordinate with technical project managers, PL/SQL developers, and DBA Team to ensure database performance and reliability.
• Worked with Senior DBA in Creating, checking, extending tablespaces. Administering database security, creating users, granting/revoking roles, privileges, extending databases storage capacity, monitoring and reducing database fragmentation, managing data files, rollback segments, extents, segments, re-indexing, monitoring storage, backup & restore/recover database, export/import database objects.

Environment: Oracle Database10g, SQL Server 2005, Forms, Reports, Oracle Apex, SQL, PL/SQL, SQL LOADER, Oracle Toad, ERWIN, Oracle Warehouse Builder, iSQL*PLUS, SQL*Net, Export/ Import Windows 2003, Windows XP, Linux RHE 4.0.

Confidential, Jacksonville, FL.

Oracle developer

Responsibilities:

• Participated in the full software life cycle.
• Participated in weekly design reviews and walkthroughs with project manager and development team.
• Worked on database design with the team.
• Wrote PL/SQL code using the technical and functional specifications
• Generated SQL and PL/SQL scripts to install create database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Involved in writing PL/SQL Packages, Functions and Stored Procedures and Data Base Triggers.
• Developed complex queries to retrieve the data.
• Worked on Pro C to embed SQL statements
• Design and developed various Reports using Oracle reports6i, PL/SQL, SQL.
• Developed interfaces/screens using Forms 6i for the users and Used Triggers to validate the data.
• Documented business rules, functional and technical designs, test cases, and user guides.
• Involved in the debugging and error handling.
• Monitored the database growth on daily basis. Established backup and recovery strategies.
• Performed Tuning using Explain Plan, Tkprof, Hints and Indexes. Used TOAD, PL/SQL developer tools for faster application development.
• Measured the performance of the shell scripts by getting the expected results.
• Wrote UNIX SHELL scripts.
• Prepared test cases for testing procedures. Involved in unit testing and Integration testing of the Modules.
• Involved in Production support and Maintenance.

Environment: Oracle 10g/9i, Oracle Enterprise Manager, UNIX Shell Programming, Crontab, SQL, PL-SQL, SQL*Plus, Toad, Windows, MS Access, PRO C, Oracle Apex

Confidential

Oracle Developer

Responsibilities:

• Incorporated all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Mapped Operational Repository to Business Repository elements and incorporating the build rules.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers and to extract data from different tables with 20 Million records in some of the tables
• Based on the user selection and finally storing the output as a flat file for further processing for the next module
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used
• Incorporated validation rules for promotion history table and updating tables
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Also my role includes testing the data in addition to re-designing the database. Front end using Forms 4.5 and Reports 2.5.

Environment: Oracle 8i, Forms 4.5, Reports 2.5, PL/SQL, SQL*Plus, Exp, Imp and Windows NT.

Confidential

Oracle Developer

Responsibilities:

• Designed, developed integrated all the modules in the application.
• Built MIS reports using tools such as Crystal Reports.
• Created SQL*Loader control files to load data from external data sources into Oracle database.
• Involved in the physical and logical backups.
• Resolved problems while keeping face of multiples issues.
• Created system models, specification, diagram and chart to provide direction to application & system developers.
• Implemented Enterprise Resources Planning.
• Involved in database design using MS Visio 2000.
• Created test set & scripts for manual testing.

Environment: Windows NT, Oracle 8i, Power Builder 6.5, Oracle Enterprise Manager, Visual Foxprox, Crystal Report, Toad, Visio 2000.