Sr. Oracle Plsql Developer Resume

OBJECTIVE

I'm seeking a challenging position as a Sr. Oracle PLSQL Developer to effectively utilize innovative, creative and analytical problem solving skills

• Around 8 years of overall professional experience in IT industry
• Experience in working as Oracle PLSQL developer, Oracle Forms developer, Oracle Reports developer and Oracle DBA.
• Experience in complete system development life cycle (SDLC)
• Experience in Requirement gathering, Evaluation, Analysis and proposing solution
• Strong domain knowledge in Aerospace
• Worked on all phases of development lifecycle, from gathering requirements to testing, implementation, and support.
• Design and develop Oracle packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Created system for capturing, reporting, and correcting error data.
• Experience in using Sybase power designer for designing database objects and creating conceptual and physical data models.
• Expertise in developing Reports using Oracle Reports developer.
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Expertise in developing Oracle PL/SQL packages for complex data transformation.
• Experience in designing Partitioned tables for improving performance.
• Experience in Oracle10G Database creation/configuration in Solaris SPARC and Windows.
• Expertise in various basic DBA activities like applying CPU patches, Upgrading Databases, User Management, Monitoring Table space, verifying Log files, Monitoring Archive files space. etc.
• Experience in Performance Tuning of Queries and Packages.
• Experience in migration of Microsoft SQL-Server database to Oracle 10G using Oracle Migration work bench tool.
• Experience in migrating Oracle 6i forms to Oracle 10g.

TECHNICAL SKILLS:

Software Products: Oracle 10g PL/SQL, Oracle 10g Forms\\ Oracle 10g Reports\\ Oracle Application Server 10g, Java\\
Hardware : Dell (Windows 95/98/2000/NT, XP)\\ Sun Solaris SPARC, VM ware\\ HP Unix\\
Tools : Sybase Power Designer, PL/SQL Developer, \\Toad, SQL loader, VSS, Oracle Migration \\ Work bench, XML Spy, Clear case tool\\ Netbeans IDE, Putty, Winscp\\

Professional Experience:

Confidential Mar 2010 - Till Date
Project- PI
Role-Technical Lead, Developer

Description:
The PI is used for Estimating, Financial, and Business Management Purposes. The application supports the Estimating and Business Operations of the company.

Highlights:

• Provided Customer support in code building, deployment and sever setup.

Design and Development Activities :

• Requirement gathering for the requested change from customer.
• Analysis of the requirements and preparing HLD and LLD.
• Design and develop Oracle forms/reports, Oracle packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Provide configurations changes to Oracle application server 10g.
• Build efficient Oracle packages for data transfers between different layers.
• Created system for capturing, reporting, and correcting error data.
• Prepared Estimates as per guidelines
• Performance Tuning of Queries and Packages.
• Migrated Oracle 6i forms to 10g.

Solution Environment-Solaris 10, Oracle 10G SQL/PLSQL, Tools-Oracle developer suite, MS-VSS, Toad, Oracle Reports/Forms

Confidential Jul 2008 - Mar 2010
Project-AD-SP
Role-Developer, DBA

Description-AD-SP is a web application that stores current and historical distribution metadata. AD is an approved authoritative source to identify & maintain distribution requirements and distribute physical and digital product definition data to internal personnel, external partners, and suppliers.

SP is a subsystem to AD and is considered to be the external supplier\'s view of Data Distribution.

Data for AD-SP is received through Data feeds from external system which are loaded, validated, transformed and then published to target tables.

Highlights:

• Provided Production and CAT support
• Provided Customer support in code building, deployment and sever setup.

Professional experience:

Client: Confidential, Richfield, OH Nov’11- Present
Role: Oracle PL/SQL Developer
Description:�Confidential business solutions have individual and institutional customers worldwide. It offers a variety of products and services. It is one of the largest hardware company, based on tools. It is one of the most admired companies in United States of America. The order management dashboard is the tool used by GM project Managers and customer care agents to check the status of multiple customer orders. Using this dashboard, customer care agents were able to track and manage order status of all customer purchases with visibility from order to delivery in a near real-time manner.

Design and Development Activities:

• Requirement gathering for the requested change from customer.
• Analysis of the requirements and preparing HLD and LLD.
• Created conceptual and physical data models using Sybase Power Designer.
• Created design pattern for incoming FEEDS using ETL process.
• Created Partitions for large tables.
• Designed and developed complex PLSQL packages and SQL loader scripts that can load, process and publish more than 5 GB of file in a single process.
• Developed scripts using SQL loader to load data into staging tables.
• Developed user friendly crystal reports.
• Prepared Estimates as per guidelines
• Developed re-usable UNIX shell scripts.
• Created adhoc queries to support reporting requirement.

DBA activities:

• Involved in Setup Development and Test environment.
• Created Oracle database in Solaris systems and configured it for Development and Testing environments
• Applied CPU patches and "upgrade" patches to Oracle Database.
• Imported production database dump into Development and test environment.

Solution Environment- SUN SPARC T1000, Solaris 10, Oracle 10G SQL/PLSQL, Java, Tools-SVN, MS-VSS, Sybase Power Designer, Netbeans, PLSQL developer, Winscp

Confidential Oct 2006 - Jun 2008
Apr 2006 - Oct 2006
Project-BID
Role-Developer

Description-The BID is a reporting system and reports BOM (Bill of material) data to a wide range of internal customers that support the various airplane families. It also has various interfaces to other applications.

BID is a data warehouse containing BOM data which uses ETL concept. The main source of Data is from PDM. PDM data is loaded into staging tables through MQ. The data from staging tables are loaded into transformation tables using PLSQL packages. The final data is published in to de-normalized tables which are used for reporting.

Highlights:

• Requirement gathering for the requested change from client.
• Analyzed the functional/Technical requirement and prepared HLD and LLD.
• Designed database objects for Layer1, Layer 2 and Target schemas.
• Designed Partitions for large tables to improve performance.
• Created Design Patterns for developing ETL process.
• Developed complex Oracle PLSQL packages for data transformation and publishing.
• Developed user interface using Oracle forms.
• Developed user defined models and notations using Oracle D2K.
• Developed Adhoc reports and queries.
• Prepared Test Plan.
• Tested the complete data flow including loading, transformation, Publishing and report generation using scripts.
• Prepared Test results.
• Prepared PLSQL scripts which can generated over 600 JSP, HTML pages with different functionalities, accumulating savings in terms of effort & cost.

Solution Environment-HP UNIX, Java/JSP, Oracle 10G, Tools-IPMS, Oracle Forms/Reports Developer, PLSQL Developer, Toad, XML Spy, Clear tool,and MS-VSS

Customer- Confidential Dec 2005 - Apr 2006
Project-SECL ERP
Role-Developer

Description-SECL ERP is the customized ERP solution for South Eastern Coal Fields Limited. This ERP contains following Business Process Chains [BPC] - Purchase, Inventory, Payables Management, Fixed Asset Management, Enterprise Asset Management, General Accounting, and Management Accounting.

User interface is developed using Ramco virtual works which generates JSP code. The user interface calls an oracle procedure which handles the business functionalities.

Highlights:

• Involved in design and development of the application.
• Prepared Functional Specification and Design Specification
• Migrated Microsoft SQL-Server database to Oracle 10G using Oracle Migration work bench tool.
• Involved in creating tables, keys, stored procedures, constraints and User Defined Functions.
• Designed test cases for various scenarios.
• Performed load testing.
• Developed complex packages as per the requirement.

Solution Environment-HP UNIX, Java/JSP, Oracle 10G, Tools-Ramco virtual works, Oracle Reports Developer, Oracle Migration work bench , PLSQL developer and MS-VSS

Customer- Confidential Jun 2005 - Dec 2005
Project-ITC - IBD
Role-Developer

Description-ITC-IBD is a personalized ERP solution developed for ITC- IBD Limited. This ERP support the wide, varied and growing business and operational needs of the International Business division that is mainly into sourcing and exporters of Agricultural produce and Aqua Products. The division has a network spread through rural India for the purpose of procurement. This network is also used to sell and distribute products to the rural markets.

User interface is developed using Ramco virtual works which generates JSP code. The user interface calls an oracle procedure which handles the business functionalities.

Highlights:

• Involved in design, development and implementation of the application.
• Prepared Functional Specification and Design Specification
• Involved in creating Oracle tables, keys, stored procedures, constraints and User Defined Functions.
• Designed test cases for various scenarios.
• Performed load testing.
• Developed complex Oracle PLSQL packages as per the requirement.
• Developed more than 80 reports using Oracle Reports.
• Provided Production support to customer

Solution Environment-HP UNIX, Java/JSP, Oracle 10G, Tools-Ramco virtual works, Oracle Reports Developer, Oracle Migration work bench , PLSQL developer and MS-VSS

Customer- Confidential Dec 2004 - Jun 2005
Project-CALL-LOG Management
Role-Developer

Description-The system maintains all the vendor details, categories, lease period, advance amount, type of vendor. If a particular system of a vendor has problem the user should log a call and the specific vendor will get the message and he will rectify the problem.

highlights:

• Involved in design, development and implementation of the application.
• Prepared Functional Specification.
• Involved in creating Oracle tables, keys, stored procedures, constraints and User Defined Functions.
• Designed test cases for various scenarios.
• Developed Oracle PLSQL packages as per the requirement.

Solution Environment-HP UNIX, Java/JSP, Oracle 10G, Tools- PLSQL developer and MS-VSS

Customer-Confidential Jun 2004 - Dec 2004
Project-De-Fin
Role-Developer

Description-De-Fin is a Finance Maintenance Project, It maintains all the Financial details of the Assets, Trainers, Developers, Candidates and produces reports with the users criteria. It caters to both training and development division of the company.

highlights:

• Involved in design, development and implementation of the application.
• Prepared Functional Specification.
• Involved in creating Oracle tables, keys, stored procedures, constraints and User Defined Functions.
• Designed test cases for various scenarios.
• Developed Oracle PLSQL packages as per the requirement.

Solution Environment-HP UNIX, Java/JSP, Oracle 10G, Tools- PLSQL developer and MS-VSS

EDUCATION:

• Bachelor of Engineering, Information Technology