SUMMARY

• Around 8 years of diversified experience in analysis, design, development, Requirement Gathering, testing and implementation of applications in the Client Server environment.
• Expert level skills as an Oracle developer includes PL/SQL, SQL, Forms and reports; stored procedures, packages, functions, cursors, triggers, constraints
• Having Extensive Experience in creation of table partitioning by range, list, hash, composite methods and indexes for managing large tables.
• Excellent conceptual knowledge ofOracle 9i/10g/11g
• Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Experience in using TOAD, SQL Developer and PL/SQL Developer.
• Having Extensive Experience in Database SQL, PL/SQL tuning and used query optimization like Hints, Explain Plan, and Partitioning.
• Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
• Experience in data migration and Data loading.
• Experience indeveloping formsbased onviews, tables and proceduresin tabular and form layouts.
• Expert in handling various version control software.
• Basic knowledge on Supply Chain and Financial Modules in order to life cycle and advanced pricing.
• Good Experience on Large database.
• Good coordination with Offshore and Onshore team.
• Good knowledge on Data Modeling and Creating ER Diagrams using ERWIN.
• Technical documentation of different lifecycle deliverables and user manuals.
• Knowledge on Agile Methodology (Scrum) and AIM Methodology.
• Extensive knowledge on Performance Tuning procedures and Handling Errors in stored procedures.
• Analyze data quality and report the anomalies to business users using SQL Developer.
• Client handling skills and proven experience.
• In addition to excellent technical abilities possesses strong oral and written communication skills, analytical and interpersonal skills.

TECHNICAL SKILLS

Databases: Oracle 11g, Oracle 10g, Oracle 9i, Forms 10g, Forms 9i, Reports 10g, Reports 9i

Utilities: SQL*Loader, Export / Import, Oracle

Languages: SQL, PL/SQL, C, Java, Unix Shell

Tools: TOAD, SQL Developer, PL/SQL Developer, Putty, SQL*Loader, iSQL*Plus, ERWIN, MS Excel

Operating Systems: Windows XP, Windows NT, Windows 9X,UNIX, Red Hat Enterprise Linux 6, Sun Solaris 10, Windows Server 2008

Methodologies: Agile (Scrum), AIM

Version control Tools: PVCS, SVN, MKS

PROFESSIONAL EXPERIENCE

Confidential, NJ

PL/SQL Developer

Responsibilities:

• Involved in the new business requirement Gathering and major developments.
• Impact analysis for the proposed changes were made and documented.
• Preparation of System Test Plan, Functional Specifications, User Manual, Data Model using the normalization process.
• Created Records, Tables, Object, Collections (Nested Tables and VArrays), Table Partitioning and Error Handling code for stored procedures.
• Client interaction through meetings & presentations.
• Involved in developing various Forms, Reports, Procedure, Functions and the PL/SQL Libraries to support the application.
• Designed and developed various custom packages triggers and forms.
• Developeddata entry forms, complex and template forms.Creation of Pop - up Menus and maintaining Master Detail relation-ship.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, UNION ALL, Inner and Outer Joins
• Involved in Extraction, Cleaning, Testing and loading of data in between the schemas using oracle Export and Import utilities.
• Trouble-shoot performance issues and bugs within PL/SQL packages, forms and reports.
• Documented all the PL/SQL Procedures, changes and modifications, configurations.
• Worked on creating stored procedures, functions, triggers and packages.
• Worked on performance tuning using the execution plan, explain plan, Partitioning tables, materialized views and oracle hints.
• Coordination with offshore team in resolving the issues. Taking of the offshore issues.
• Developed UNIX Shell Scripts to execute procedures and ran sql scripts on Linux.
• Used SQL * Loader to load large flat files in the database.
• Production Support & User Acceptance Testing Support.
• Domain Knowledge sharing within & across projects.
• Trouble shooting within & across projects.
• Monitored the production Oracle alert logs for database errors.
• Production support and version releases. Was available 24*7 to resolve production issue.

Environment: PL/SQL, Forms 9i/10g, Reports 9i/10g, SQL* Loader, SQL PLUS, Agile, Oracle 11g, UNIX

Confidential, IL

PL/SQL Developer

Responsibilities:

• Using the Toad and SQL Developer tool to Design, Develop and tune the SQL code.
• Designing and developing SQL procedures, Triggers, tables, views, query performance tuning and packages
• Creating, modifying and reviewing Stored Procedures, Packages, functions and cursors to suit business requirements and handled the errors for stored procedures
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Creating indexes and partitions on various tables in order to enhance performance
• Providing support and played a major role in debugging errors during implementation and deployment
• Creating database objects like synonyms and sequences
• Optimizing the SQL statements and PL/SQL blocks by analyzing the execute plans and statistics of SQL statements and created and modifying some Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways
• Using EXPORT/IMPORT to do table level and full database d-fragmentation. Used UC4 with the UNIX coding for the automation process.
• Involved in Creation of tables, partitioning tables, Join conditions and correlated sub queries as per the business requirements.
• Extensively worked on the mappings, analysis and documentation of OLAP reports requirements.
• Used partitioning and sub-partitioning like range, list, and hash.
• Coordinating with team and holding daily scrum (Agile) and track process.
• Using composite data types like %ROWTYPE and %TYPE
• Expert knowledge in cursor, ref cursor, system ref cursor, collection and dynamic SQL.
• Made use of for all and bulk Collect feature to process the data from cursor/ Ref Cursors and placed the processed data into a collection.
• Using the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.

Environment: Oracle 11g, SQL Developer, SQL Plus, Toad, Reports 10g, Form 10g, UC4, UNIX, MS Office 2010, Windows XP, Agile

Confidential, MI

PL/SQL Developer

Responsibilities:

• Designing module wise Oracle database structure and its implementation on the client server
• Used PL/SQL table to avoid mutating problem in database trigger
• Develop tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types
• Extensive use of Partition methods for oracle tables and indexes.
• Extensively worked on PL/SQL Error/Exception handling for Stored Procedures.
• Involved in Data Extraction, Data Cleaning, and Data Loading in large data server.
• Created database objects like tables, views, indexes, partitions.
• Worked on Performance tuning of application programs using Oracle Indexes, Partitioning tables, EXPLAIN PLAN, TKPROF and SQL TRACE.
• Query performance using better joins and used Hints appropriately
• Developed packages, procedure and functions for complex Reports
• DevelopedMaster Detail, Detail reports usingtabular and Group above reports.
• Wrote many simple and complex ad-hoc reports usingSQL PlusandTOADfor the business users. Transformed complex business rules to Oracle PL/SQL.
• Modified Stored Procedures and Stored Packaged Procedures.
• Utilized partitions to fine-tune SQL data retrieval and load.
• Used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL
• Provided support for production issues In Discoverer/Forms/Workflows
• Scheduling different activity using Perl scripting
• Created documentation for the application.
• Used shell scripting to change and modify the data
• Using the corn tab in UNIX for automatic tasks.

Environment: Oracle 11g, Forms 10g, Reports 10g, SQL*PLUS, Toad, Sun Solaris 2.6, Toad8.0, Windows 2000/NT, SQL plus, PL/SQL, UNIX

Confidential, IL

PL/SQL Developer

Responsibilities:

• Designed and developed SQL procedures, Triggers, tables, views, query performance tuning and IOP packages
• Created table partitioning by range, list, hash and indexes for managing large tables, normalization and de-normalization.
• Designed the Unit testing plan for the issues worked on for the testing purpose, Worked on the System design document.
• Designed JACL scripts, XML Files, bat files for the link to the MS Access (front end).
• Develop underlying data models and databases
• DesignedReportoutput formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Developedcomplex triggersinreportsbefore/after for validation of user input.
• Ensure compliance of standards and conventions in developing programs
• Design, develop and implement life cycle of IOP
• Translate business requirements into software applications and models
• Resolving, supporting and troubleshooting existing Client Reporting Applications
• Maintain and manage all versions of data models for production, testing and developing databases
• Strengthen client relationships and be knowledgeable about their marketing objectives
• Positive client feedback on Service Level Agreements
• Worked as an ETL tester
• Given a support to the front end developer (Excel/VBA Developer)
• Creation of client specific modules that stage/parse raw client data from a variety of formats and render documents into postscript and/or PDF formats
• Debugging, troubleshooting and maintenance of existing PERL scripts and modules
• Worked on Functional Requirement Documents.
• Developed the POC (Proof of concept) to Demonstrate options.
• Performed code reviews

Environment: Oracle 10g, Reports 10g, IOP, PL/SQL Developer, SQL developer, Excel 2003/2010

Confidential, VA

APEX-PL/SQL Developer

Responsibilities:

• Analysis of new business requirements and major developments.
• Coded and debugged the stored Procedures, Packages, Exception/Error Handling and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Worked on Partitioning tables and created indexes for better performance of application.
• Created Users, Admin accounts for teammates.
• Created Oracle Apex Application from Scratch.
• Created, modified and reviewed Procedures, Packages and functions and cursors to suit business requirements
• Created Apex triggers for different functions of the application including database and report triggers.
• Created and defined Row Sets, Columns Sets and Content Sets.
• Developed and verified forms and Reports on 10g using Oracle Application Express (APEX3.2).
• Created maintained and compared objects in multiple schemas for developers
• Performed import and export of schemas, objects using data pump utility in 10g
• Written shell scripts for rebuilding existing databases to keep up with the latest developments
• Performed tuning for PL/SQL procedures and packages and modified code accordingly to improve performance
• Created indexes and partitions on various tables in order to enhance performance
• Written shell scripts to load data into various subsystems using SQL loader
• Provided production support and played a major role in debugging errors during implementation and deployment
• Modified code to maintain user jobs running on regular intervals performing data transfer from staging area to log tables
• Designed and developed customized Reports, Forms, PL/SQL packages, Workflow.
• Performed code reviews on PL/SQL and SQL
• Created database objects like tables, views, synonyms, indexes, and sequences.
• Used shell scripting to change and modify data.
• Extracted data from theXMLfile and loaded it into thedatabase.
• Developed UNIX Shell Scripts to execute procedures and run the SQL scripts through Job scheduler.
• Integrated, tested, debugged and implemented application systems.
• Optimized SQL statements and PL/SQL blocks by analyzing the execute plans and statistics of SQL statements and created and modified some Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways.

Environment: Oracle 10g, PL/SQL Developer, SQL Developer, REDHAT LINUX, Forms 10g, Clear Case, Clear Quest, HTML, APEX 4.1, Agile, UNIX

Confidential

APEX-PL/SQL Developer

Responsibilities:

• Developed PL/SQL procedures and functions to assign sensitivity levels to specific data based on a set of rules.
• Developed PL/SQL stored procedures and functions to implement customer specific rules
• Performance tuning and optimization using explain plans, partitioning tables and indexes.
• Worked with systems and business analysts to establish data warehouse design.
• Evaluated the data quality using developed PL/SQL stored procedures and UNIX shell scripts.
• Used process automation to keep the systems up to date and reduced manual errors by developing shell scripts and using CRONTAB on various UNIX platforms.
• Used ETL to convert code from other DBMS versions to Oracle

Environment: Oracle 9i, Oracle PL/SQL, SQL, TOAD, HTML, UNIX, APEX3.2

Confidential

APEX-PL/SQL Developer

Responsibilities:

• Done analysis of the project by interacting with the user at different levels
• Involved in application design, development, testing, Integration and implementation
• Creation of tables, indexes, views
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner.
• Used Power exchange for mainframe sources.
• Creation of PL/SQL procedures, functions, cursors, packages
• Created Materialized Views and partitioning tables for performance reasons.
• Unix Shell Scripting was coded for job automation.
• Performed code reviews on PL/SQL and Linux development

Environment: ASP, ORACLE 9i, PL/SQL, Red hat Linux, UNIX, APEX 3.0