Summary:

• Over 10 years of IT experience as an Oracle PL/SQL developer and Oracle Forms and Reports Developer on variety of UNIX and Window platforms with Oracle 10g/9i/8i.
• Oracle certified Associate OCA in IZ-007 Ref: OC853373.
• Worked with clients in different domains like Banking-Finance, FMCG, Mortgage and Insurance.
• Experienced on complete Software Development Life Cycle SDLC using various methodologies like Rational Unified Process RUP , Waterfall Model, Agile, V-Model and SCRUM.
• Developed stored procedures and packages with PL/SQL in Oracle 8i/9i/10g as back-end and involved in Analysis, Design, Development, Migration, Testing and Implementation of ERP in multi-tier architecture.
• Very Good Knowledge about the oracle tools like SQL, PL/SQL, SQL PLUS, Oracle Enterprise Manager, SQL LOADER.
• Expertise in Oracle Database Architecture and making structural changes to the database.
• Ample of experience working in various stages of a database design, including Data Modeling, Schema Design, User creation, Designing Physical and Logical structure.
• Hands on experience in preparing User Specification Requirement, Software Requirement, Technical Documentation, and Test Plan.
• Proficient with Database Cloning, Migration, Standby Database, Data Guard of Oracle Databases and Oracle Applications.
• Experienced in file loading using SQL Loader, file manipulation and emailing capabilities of Oracle using in-built packages.
• Excellent experience in Oracle 10g/9.x/8.x/7.x development using PL/SQL, Stored Procedures, Triggers, Functions, Packages, Views, Oracle Objects.
• Expertise in using EXPDP/IMPDP Data pump to take the hot backup using DUPLICATE or full export and also to accomplish table level and full database de-fragmentation.
• Experienced in ETL techniques and Analysis and Reporting including hand on experience with the Reporting tools such as Business objects, Crystal Reports, Discoverer and SQL Server Reporting Services SSRS .
• Expert in optimizing database performance, resource use, and physical implementations of databases, addressed variety of database integration issues including migration between disparate databases, integration, maintenance / conversion, capacity planning issues, and new applications.
• Experienced in working on Oracle supplied packages like UTL FILE, DBMS JOBS, DBMS PROFILER, DBMS SCHEDULER, DBMS ALERT and DBMS PIPE packages.
• Analyzed tables and indexes for Cost Based Optimization CBO for improving performance and work efficiently.
• Configuration of Oracle Enterprise Manager OEM to monitor database and report on events as defined by the DBA group.
• Documented all the processes involved in designing, development of projects and database for future reference.
• Provided 24 x 7 dedicated supports to production, development test application environment.
• Goal Oriented individual with ability to direct complex projects from concept to fully operational status.
• Organized, Excellent interpersonal, communication, documentation and leadership skills

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Oracle PL/SQL Developer.

Description:

Confidential is a leading global manufacturer and marketer of power tools and accessories, hardware and home improvement products, and technology-based fastening systems. This project is mainly dedicated towards providing Oracle PL/SQL Developer support and maintaining performance of multiple databases in development, production, and test environments for various types of databases.

Environment: Oracle 11g/10g, Windows 2008/XP, PL/SQL, SQL PLUS, TOAD 9.6, SQL Developer, SQL Loader, UNIX, LINUX,MS SQL SERVER 2005/2008,Erwin, MS Outlook 2000/2003, MS Communicator, Oracle Forms10g , Oracle Reports 10g,Report Studio.

Responsibilities:

• Participated in all phases of development like System Analysis, Design, Coding, Development and Implementation and provide support to existing client databases.
• Extensively used feature of oracle 10g in data pump utilities EXPDP/IMPDP for Copying of data from development server to test and production server.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds as per the business needs.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Extensively used the advanced features of PL/SQL like collections, nested table, varray and dynamic SQL.
• Used SQL Loader, C to extract, transform, import, export data from Oracle tables to flat files, developed reports using C programming.
• Coordinated and created all database change modifications and new object creations required by other programmers.
• Analyzing and extracting data from heterogeneous source systems like Flat files, Excel files, XML, from relational sources like SQL Server.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
• Expertise in writing Ad-hoc Queries using bind variables and error handling to improve query performance.
• Used Oracle 11g redesign LOBs format to store the Multimedia data which will not only provide superior performance but also take less storage to store the data.
• Provided Performance tuning and performance analysis for large oracle data warehouse using Oracle 11g database and application tiers for best practices for partitioning, scalability and monitoring.
• Extensively used QUEST Tools TOAD, SQL PLUS, SQL Loader utilities such as UTL FILE and UTL MAIL in packages to interact with system files, generate HTML, and send mail.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.
• Used Explain plan and auto-trace for tuning the SQL and Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Migrated multiple Clients from Solaris, Windows, and Linux to different platforms with Oracle 10g, 9i, 11g.
• Upgraded several 10g RAC clustered databases to 11g
• Worked with Administrative and Desktop Edition of Oracle Discoverer. Building workbooks, editing existing workbooks, adding/editing worksheets and scheduling workbooks for user.
• Developed Reports using Reports10g Creating EUL, Business Areas, Privileges, Administration functionalities, Reports through User Edition .
• Generated Dashboard report, List Reports, Cross Tab Reports and Drill Through reports using Report Studio
• Personalized standard reports and forms according to business requirements, using Oracle Forms and Reports.
• Documented all the processes involved in project for future reference.

Confidential

Role: Oracle PL/SQL Developer.

Description:

Confidential is an insurance company which helps people manages the risks of everyday life, recover from the unexpected, and realize their dreams. The project is to maintain the Production, Test, and Development and cluster Server Environment and support for developers in developing queries. Worked as a team member with other Oracle Developers to ensure 24 hour x 7 day a week support of all corporate databases

Environment: Oracle10g/9iAS, Oracle OEM, Oracle Developer 9i, SQL PLUS, PL/SQL, Toad 9.6, Rational Rose RUP UML ,PL/SQL, HTML , XML , Developer , ERWIN ,Unix Shell Scripts, SQL Loader

Responsibilities:

• Understanding the end user requirements and make possible changes in order documents and the specified requirement documents.
• Designing, Coding enhancements and customizations to the application in accordance with the change orders.
• Creating primary database storage structures table spaces , altering according to the company's requirement, modifying the database structure as necessary from information given by the application developers
• Analyze table spaces and removing row-chaining and row migration in table spaces and Managed table spaces and redo logs.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Implemented PL/SQL, packages, triggers, functions and views, writing test scripts using TOAD 8.6.
• Performed user administration, space administration on development and QA databases.
• Wrote both implicit and explicit cursors to capture many rows with in a pl/sql block, and applied business rules on them.
• Created the Staging tables for better performance in the Process of migrating data.
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Worked on tuning the SQL queries and stored procedures and also performed application tuning and performance monitoring using STATSPACK, TKPROF.
• Responsible for capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lock activity.
• Creating users and profiles as per request and maintaining the Security Management using roles and grants.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation.
• Day to day troubleshooting like adding space in data files, rebuilding indexes, check alert log file and monitoring of system.
• Upgraded 6i clients server Oracle Forms and Reports application to web based 10g and ran the application through Oracle Portal and Single Sign-on.
• Created Web based reports using Crystal Reports and Scheduling timely to refresh of documents through Broadcast agent.

Confidential

Role: Oracle PL/SQL Developer.

Description:

This project deals with building an Oracle platform that supports data integration service for loading data. This platform is used to load data from the ENCORE source tables for the Platform and Teller reports. Development of platform includes building procedures to map and load the data from the source OLTP table to target table columns for reporting.

Environment: Oracle9i,SQL,PL/SQL,OracleDesigner2000,Toad5.0,UNIX,MSOutlook98/2000,MSWord,Micrsoft SQL Server 2005, Windows XP, Erwin, Mind Map, Oracle Forms 9i, Reports 9i,Teradata.

Responsibilities:

• Interacting with the clients to understand the requirements and Designing module wise Oracle 9i database structure and its implementation on the client server.
• Developed Function Definitions, Entity Access Matrix and Entity Life History Diagrams using SSADM, Mind Map and Excel 2000.
• Wrote new pl/sql packages, procedures of the application in accordance with the prevailing standards of the application using Oracle Designer.
• Enhanced the existing packages of the application by adding new procedures and new business logic accordance with the prevailing standards of the application.
• Performed Data Analyst role, to analyze the data and to clean the DB schema.
• Developed Database objects like Views, Materialized Views, Indexes, Sequences, and Synonyms.
• Wrote shell scripts to process PL/SQL procedures and wrote PL/SQL program units for data extracting, transforming and loading
• Fine-tuned, the SQL queries in order to improve the overall system performance
• Taking logical backups using export at object and schema level to save space and reduce fragmentation in your database.
• Wrote UNIX shell scripts to encrypt flat files that are created by Oracle Job's and to upload FTP the flat files to the designated server.
• Tuning application using tools like Explain plan, SQL Trace and TKPROF for high efficiency.
• Wrote new procedures, which are triggered by UNIX shell script to process the staging data and do the required process.
• Performed exception handling for data that did not conform to the required format.
• Aided developers in writing efficient code and making efficient use of the resources leading to better performance and optimization.
• Testing and Implementing enhancements and solutions.
• Assisted in setting up the Forms and Reports Services on standard 6i server.
• Support for the development, pre-production and the production databases.

Confidential

Role: Oracle PL/SQL Developer

Description:

• The project involved developing online tools and Web Applications for the financial advisors of the
• company. The online tools consist of mainly Generating Online Reports to give better understanding of the
• financial position of the investors to the Advisors.

Environment: Oracle 9i,PL/SQL,PERL,HTML,Discoverer,SQL Plus Reports, Sql Loader, WindowsXP,UNIX, TKPROF, MS Outlook 2000, TOAD, Mind Map, MS Office, Oracle Reports9i/6i ,Oracle Forms9i/6i .

Responsibilities:

• Participated meetings to gather functional and non-functional requirements with tax experts, tax officers and end-users.
• Involved in system analysis and developed requirement catalog.
• Created index on all key fields and analyzing tables is done to reduce query return times. Materialized views are created in many cases for frequent refreshes of data and also to improve performance.
• Created Tables Views and referential integrity constraints using SQL and wrote Database Triggers, Procedure Functions using PL/SQL.
• Extraction of data from source systems through Excel and Flat files, loading in to the data mart tables for report needs.
• Participated in developing Entity-Entity Matrix, Logical Data Model and Data Flow Diagrams.
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS Native Dynamic SQL .
• Developed Menu Model Diagrams and Input/output structures for the data entry screens.
• Involved in developing the Process Model Diagrams to represent the Income Tax business processes
• Used DBMS PROFILER package to understand where the code is spending the most time, detect it and then optimize it.
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. For best results, used these tools with EXPLAIN PLAN.
• Developed program specifications and test plans based on the logical program specifications.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Orecle8i as back-end.
• Intensively involved providing end-user trainings to tax officers and data-entry operators.
• Designed and developed Web-enabled Oracle Forms Reports including Forms based on stored procedures.
• Used the Crontab in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.
• Assisted in setting up the Forms and Reports Services on 9i and 6i AS.
• Involved in the implementation and support of the system in many Inland Revenue Offices throughout the country.

Confidential

Role: Oracle PL/SQL Developer.

Description:

Confidential has advanced the practice of less-invasive medicine by providing a broad and deep portfolio of innovative products, technologies and services across a wide range of medical specialties. Today, with more than 25,000 employees and 26 manufacturing, distribution and technology centers, Boston Scientific remains true to its original mission

Environment: Oracle 9i, HTML, PL/SQL, SQL Plus, SQL Loader, Toad, Unix, Windows 98/2000/2003, MS Outlook , Microsoft SQL Server 2000/2003, Erwin.

Responsibilities:

• Understanding the existing application and its related back end business logic and wrote technical documentation for the proposed changes in the application.
• Involved in the development of the Function Hierarchical Diagrams, Entity Relationship Diagrams for batch as well as core modules.
• Designed the database from scratch using Oracle SQL Plus and additional Oracle Objects including Tables, Views, Sequences, Triggers, etc. were also developed during this process.
• Supported direct mail campaign strategies. Provided segmented data to end-users
• Interact with business analysts to develop modeling techniques and re-structuring strategies
• Involved in Unit Testing of each module.
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also Extensive Usage of Indexes
• Monitoring existing SQL code and performance tuning if necessary.
• Loaded data from flat files and load data to warehouse using External Tables and PL/SQL Scripts using SQL Loader and ETL with PL/SQL.
• Developed interfaces using PL/SQL procedures and created packages to load data into targeted Oracle database.
• Verified the loads and involved in debugging process team.
• Provided database support to testing team in writing complex SQL queries.
• Prepared the detailed design document, test cases and use cases for business requirements
• Measuring and reporting response rates using Excel, PL/SQL script.
• Developed Unix Shell scripts to automate repetitive database processes.