SUMMARY

• Over 10 years of hands on experience working with Oracle 10g/9i, Unix Shell Scripting, Reports 6i, PL/SQL, tuning, Data modeling, and expert in writing UNIX Shell Programming on Oracle Database running on UNIX environment.
• Extensive experience in analysis, design, development, testing and implementation as Oracle PL/SQL and Forms/Reports Developer.
• Worked on client-server application development using Oracle 11g, 10g, 9i, 8i, PL/SQL.
• Expertise in Writing SQL Queries and Optimizing SQL Queries.
• Excellent understanding of the Oracle Architecture
• Relational database schema, Functional dependencies, Normalization of tables 2NF, 3NF .
• Extensive experience in building Client Server Applications using Oracle, PL/SQL, Stored Procedures, Packages and Database Triggers working with partitions, creating, modifying and sizing database objects.
• Involved in Installation of Informatica PowerCenter 6.2.
• Proficient in legacy data conversions and interface development using SQL, PL/SQL, UNIX, TOAD, SQL Developer, Pl/Sql Developer and SQL Loader.
• Experienced working on data modeling, requirement collection and business process mapping.
• Experience in UNIX administration, Shell scripts, Crontab.
• Good hands on experience in writing various UNIX shell scripts.
• Used various levels of triggers and procedures to validate the data at each level.
• Created logical and physical relational data models using PowerDesigner 8 for all new and modified processes, from start to finish.
• Experienced in developing batch programs by using PL/SQL and shell scripts.
• Conversion of data into XML using SQL Prompt as per client's requirement.
• Designed ETL process using Informatica Tool to load from Sources to Targets through data transformation.
• Experience in SQL query, PL/SQL package, function, stored procedure, triggers to implement business logics of oracle database
• Widely used Oracle Enterprise Manager OEM for administering databases.
• Performance tuning by resolving users issues and problems, monitoring production database by using SQL Plus and performed refinement of the database design leading to significant improvement in system response time and efficiency using EXPLAIN PLAN and TKPROF.
• Deep rooted concepts in Data Extraction, Transformation and Loading from databases, flat files and XML files.
• Resolved stored procedure conflicts between PowerBuilder 9.0 and Oracle 9i client software. Documented the solutions, and communicated them to DBA and development groups to reduce impact on development schedules.
• Experienced in DBA concepts like Creating Indexes, Tables and database physical extensively used Erwin for data modeling and Dimensional Data Modeling by ERWIN.
• Developed and customized reports in applications using Oracle reports 6i.
• Extensively worked on Oracle partitioning to improve the performance.
• Created and managed database object like tables, views, sequences, synonym, index, trigger, user, roles, DB link and Materialize view M-view .
• Experience in full Software Development Life Cycle SDLC i.e. requirements analysis, detailed design, development, unit testing and integration.
• Highly motivated conceptually strong individual with outstanding oral and excellent communication, analytical and interpersonal skills.

TECHNICAL SUMMARY

PROFFESIONAL EXPERIENCE

Oracle Developer

Confidential

Roles and Responsibilities:

• Developed procedure for the conversion of data into XML using SQL Prompt, Oracle utilities as per client's requirement.
• Created and managed database object like tables, views, sequences, synonym, index, trigger, user, roles, DB link and Materialize view M-view .
• Working on troubleshooting defects, Query optimization in timely manner.
• Create Cron job for schedule the tasks
• Developed triggers, Indexes, PL/SQL packages, procedures, functions, using SQL Developer, Pl/Sql Developer Tools. Generated server side PL/SQL scripts for data manipulation and validation of data for remote instances.
• Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table to make Database Faster and easier to maintain.
• Experience in database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Create DB Link
• Participated in change and code reviews to understand the testing needs of the change components.
• Extracted data from the XML file and loaded it into the database.
• Good team player
• Have strong analytical skills including troubleshooting.

Environment: SQL Developer, Pl/Sql Developer, Toad, JAVA, Oracle 10g/11g, PL/SQL, SQL LOADER, SQL PLUS, HTML, XML, UNIX shell scripting,

Oracle Developer

Confidential

Roles and Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic, using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting sing Parallel Queries, Java stored procedure, HTP Package and WEB.SHOW DOCUMENT. Participated in change and code reviews to understand the testing needs of the change components. Working on troubleshooting defects in timely manner.
• Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Used SQL Server tools to build high performance data integration solutions, including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Designed and developed Oracle forms reports
• Have strong analytical skills including troubleshooting.

Environment: JAVA, Oracle 10g/11g, PL/SQL, SQL LOADER, SQL PLUS, HTML, XML, HP-UNIX shell scripting, SQL Developer, Pl/Sql Developer, Toad

Oracle Developer

Confidential

Roles and Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic, using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Participated in change and code reviews to understand the testing needs of the change components. Working on troubleshooting defects in timely manner.
• Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Used SQL Server tools to build high performance data integration solutions, including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Designed and developed Oracle forms reports generated up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.
• Used Crystal Reports to tracked logins, mouse over, click-through, session durations and demographical comparisons with SQL database of customer information.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL LOADER, Oracle Streams 10g Replication , SQL PLUS, HTML, SQL Server 2008, TOAD, XML, HP-UNIX shell scripting.

Oracle Developer

Confidential

Roles and Responsibilities:

• Participated in gathering the user requirements and involved in writing technical design documents.
• Proactively monitor, diagnose and rectify database-related issues.
• Responsible for definition and management of schemas and objects and monitoring, tuning and troubleshooting of Oracle databases.
• Responsible for coding stored procedures, functions and triggers and other scripts based on functionality of the domain and as per business requirements using PL/SQL.
• Designed and developed various types of Reports as per the requirements.
• Developed and customized reports in applications using Oracle reports 6i.
• Designed, developed and tested Applications using Apex 3.2 and 4.0
• Run batch jobs for loading database tables from flat files using SQL Loader.
• Create database links between production databases.
• Resolved stored procedure conflicts between Power Builder 9.0 and Oracle 9i client software. Documented the solutions, and communicated them to DBA and development groups to reduce impact on development schedules.
• Create extensions using Oracle recommended frameworks. Report against Applications data model.
• Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations.
• Used SQL Server for data integration solutions, including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the oracle database.
• Involved in Migration of tables and indexes to different table spaces.
• Extensively involved in Fine-tuning the Informatica Code mapping and sessions , Stored Procedures, SQL to obtain optimal performance and throughput.
• Experience in writing UNIX shell scripts Wrapper scripts to automate batch jobs and Oracle Backups to store in the appropriate tables using PL/SQL and Shell Scripts.
• Wrote Test scripts for Unit, involved in System, and Integration testing.
• Created logical and physical relational data models using PowerDesigner 8 for all new and modified processes, from start to finish.
• Refresh development and test database with data from the production databases.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, TOAD, Power Builder, SQL Loader, Reports 6i, Informatica Power Center, SQL Server 2008, MS Visio, Erwin, UNIX Shell Scripts, Windows NT, UNIX.

Oracle PL/SQL Developer

Confidential

Roles and Responsibilities:

• Analyses and discuss the business requirements with the clients.
• Responsible for the development, implementation and support of the database of the server.
• Managed a team of 2 personnel for the development of the database, procedures, functions, etc
• Optimized and modified the triggers, complex store functions, procedures, user base data type etc.
• Responsible for the dealing with the problems, bug fixing and troubleshooting
• Designed and created an interface between custom application and accounting application, Summit.
• Mentored junior programmers in Oracle database design and development
• Upgraded 6i client server Oracle Forms and Reports application to web based 10g and ran the application through Oracle Portal and Single Sign-on.
• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.
• Wrote Advanced Queuing database package to send messages to clients based on events.
• Lead the upgrade process of Oracle Forms and Reports 6i to 10g including the setup of the 10g Oracle Development environment
• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.
• Member of the team that setup the project standards for development.
• Used Designer for design and database object generation.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Designed and developed Web-enabled Oracle Forms Reports. Including Forms based on stored procedures
• Generated Oracle Forms and database objects through Designer.
• Wrote PL/SQL packages to calculate Missing Information and Determining Eligibility in the processing of a Medical/Health Families Application.
• Created Oracle Reports with Java Barcodes.
• Assisted in setting up the Forms and Reports Services on 9iAS.
• Documented business rules, functional and technical designs, test cases, and user guides

Environment: Oracle 9i/10g SQL, PL/SQL, Forms 9i, Reports 9i, SQL Loader, SQL Navigator, Crystal Reports, TOAD.

Oracle PL/SQL Developer

Confidential

Roles and Responsibilities:

• Developed Server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting sing Parallel Queries, Java stored procedure, HTP Package and WEB.SHOW DOCUMENT. Participated in change and code reviews to understand the testing needs of the change components. Working on troubleshooting defects in timely manner.
• Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Used SQL Server SSIS tool to build high performance data integration solutions, including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Used SQL Server SSIS tool to build high performance data integration solutions, including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Designed and developed Oracle forms reports generated up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.
• Used Crystal Reports to tracked logins, mouseovers, click-through, session durations and demographical comparisons with SQL database of customer information.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.

Environment: Oracle 10g, PL/SQL, ER-WIN, Toad.

Oracle PL/SQL Developer

Confidential

Roles and Responsibilities:

• Written PL/SQL Stored Procedures, Packages to implement Business Rules.
• Designed and created application using Apex 3.0
• Built complex queries using SQL.
• Extensively used dynamic SQL
• Created indexes for faster access the tables which was helpful for performance tuning
• Created various views for better performance of the database.
• Debugged the Procedures, Views Enabling/Disabling altering them as required as per site requirements.
• Used explain plan to increase the performance of SQL statements.
• Was responsible for tuning the procedures for better performance.
• Modified SQL statements to increase the overall performance as a part of performance tuning.
• Upgrade branch system and Accounts Receivable software application.
• Participated in the detailed requirement analysis for the design of data marts and schemas.
• Designed, Developed and implement the Inventory Control Software for Container Production Department.
• Developed UNIX kern shell scripts.
• Worked on UNIX for permissions and wrote server startup scripts to production and development servers.
• Used SQL Loader to load bulk utilities subscriptions used for moving data from external files into the Oracle database
• Used PL/SQL developer tool as a front end to the database.
• Integrate Account Receivable System with Financial Accounting System.
• Integrate Cash Management System.
• Developed Reports for Management reviews.
• Forecast System Module for Production System by comparing the sales volume of each quarter.
• Responsible for user maintenance and security parameters.
• Developed various crystal reports.
• Implement the ETL process to load the Products Data Mart, which helped generate Business Intelligence and Performance Management reports
• Extracted Source Data using Informatica tools and Stored procedures from Source Systems.
• Load data into Oracle tables using Database Links, and Oracle Heterogeneous services.
• Participate in data sourcing, extract data investigation process, and work with team to develop PL/SQL code to extract, clean and sort data.
• Created Scripts to Load data from External systems to oracle Database.
• Experience in writing UNIX shell scripts Wrapper scripts to automate batch jobs and Oracle Backups to store in the appropriate tables using PL/SQL and Shell Scripts.
• Involved in Migration of tables and indexes to different table spaces.

Environment: Oracle 10g, Unix, Forms, Report Writer, PL/Sql, SQL,, SQL Plus, MS Excel, MS Access, Informatica Power Center, Crystal Reports 7.0, SCO Open Server.