PROFESSIONAL SUMMARY:

• 6+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of
• Business Applications using the Oracle Relational Database Management System(RDBMS). Strong knowledge in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i/ 8i/8.x/7.3,DB2,teradata v2r5

GUI S: Developer/2000(Forms10g/9i/6i/5.0/4.5&Reports10g/9i/6i/3.0/2.),owb

LANGUAGES: SQL, PL/SQL, C, HTML, XML, java script

ADMINISTRATION: SQL*Loader, Export, Import.

Tools: TOAD,SQL*PLUS, SQL*NAVIGATOR, SQL DEVELOPER, Putty, VI Editor, forms Builder, Reports Builder, Procedure Builder, Graphics Builder, Import & Export utility, Erwin, PERL

OPERATING SYSTEM: Windows7/ NT/2000/98/95, DOS 6.0/3.0, UNIX,SUN SOLARIS

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL Developer.

Responsibilities:

• Created several stored procedures to migrate the date into salesforce.com from Siebel CRM.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Involved in developing packages for implementing business logic through procedures and functions.
• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Performed Root cause analysis for test failure and co - ordinate with different teams to resolve the issue while in Production.
• Extensively migrated data from flat to different targets using ETL and Data ware housing tools.
• Also had an opportunity to work in various stages of Software Development Life Cycle (SDLC).
• Customized forms by writing block level triggers and item level triggers using Oracle Forms.
• Worked with Agile/Scrum team to deliver the best output.
• Provided guidance to the external team in performing testing on the components that I own
• Created and monitored the new jobs in Production that were added as a part of the Release.
• Provided Testing and Support for Release by providing support to resolve the severity 1 issues.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like AUTOTRACE and DBMS SQLTUNE.
• Used SQL*Loader to load bulk data from various flat files.
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Developed UNIX shell scripts in VI Editor with embedded SQL*Loader calls and PL/SQL statements to extract data from the application in the form of flat files and load the extracted data into the new application.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Develop Packages, Stored Procedures/Functions to develop Atlas Database mirroring the existing ATG System.
• Write Procedures to classify the incoming orders based on their regions and place them in different SAP system
• Perform root cause analysis for and test failure and co-ordinate with different teams to resolve the issue.
• Created and Maintain Autosys jobs in both production and development Environments.
• Created Views based on multiple tables and perform data changes on tables for cancelled and modified orders.
• Create multiple jobs in Autosys Environment co-coordinating with offshore team and other technical teams to create a QA Environment to perform testing.
• Create UNIX Shell scripts and SQL queries to get order report data from Atlas and process them into reports that are used by other systems like SAP and JCAPS for maintenance.
• Customized forms by writing block level triggers and item level triggers using Oracle Forms.
• Designed and developed Oracle Reports and Forms for both Oracle Applications and Custom Development.
• Extensively migrated data from flat to different targets using ETL and Data warehousing tools.
• Extracted and Transformed the data using Extract Transform Load an PLSQL
• Develop Unix Shell scripts to monitor jobs and run the stored procedures/functions.
• Worked with Agile/Scrum team to deliver the best output.
• Opportunity to work with Power Builder Programming for developing business applications and create, modify and delete databases.
• Structured and optimized code in stored procedures, triggers and Microsoft Access for processing data.
• Also worked with various JAVA developers for creating java functions and use them in front end applications.
• Also had an opportunity to work in various stages of Software Development Life Cycle(SDLC).
• Involved in preparation ofTest planandTest scriptswith the help of requirement and design document.
• Co-ordinate between different teams to highlight the defects and defect resolution.
• Provided Support coverage for the release and performed root cause analysis during the warranty phase.
• Worked with different teams to set up the development and test Autosys environments.
• Created Work Instruction Manual listing the possible failures and Recovery steps for each and every new job added as part of the project.
• Involved in the preparation ofTest planandTest scriptswith the help of requirement and design document.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, UNIX Shell script, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, Windows XP/2000.

Confidential, Chicago, IL

Oracle PL/SQL Developer

Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination
• Created process force and deployed into run time depository using ware house builder
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas. worked with bulk collect to Implement the performance of multi row queries
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Generated various analytical reports using MicrosoftAccess.
• Worked with Agile/Scrum team to deliver software projects and products.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Helped in maintaining the databases and also worked with production support team to solve tickets and debugging issues.
• Migrated XML data to Targeted files using ETL tools in Data warehousing.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created SQL*Loader control files for loading the data from flat files to staging area tables.
• Developed SQL scripts to create database objects liketables, views and sequences.
• Used SQL*Loader to load bulk data from various flat files.
• Developed SQL and PL/ SQL scripts for migration of data between databases.
• Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms 10g.
• Had some hands on Experience with Perl Scripting.
• Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.
• Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.
• Opportunity to work with Power Builder Programming for developing business applications that uses OLE Automation.
• Helped in solving debugging issues for the production team and also helped the production support to solve performance issues
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, DBMS PROFILER, etc.
• Developed UNIX shell scripts in VI Editor 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.
• Created Bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.
• Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g, PERL.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Wrote UNIX scripts to automate loading files into database using error handling and notification.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.
• Developed and modified procedures, functions, triggers, forms, and reports and deployed the changes in the system.
• Developed user interfaces using Oracle Forms.
• Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.
• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Opportunity to work with basic Power Builder Programming for developing business applications.
• Responsible for creation of new users and setting up privileges and policies for protection of data.
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 9i, Reports9i.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader - for different cases)
• Explain Plan, TKPROF was used for checking the performance of queries
• Modified and updated existing custom forms to adapt to new database schema
• Involved in creation and updates of several SQL packages and Procedures
• Created SQL scripts for conversion of legacy data (including validations) and then load it into the tables
• Developed SQL*Loader programs &PL/SQL scripts to load legacy data into Oracle Apps.
• Developed reports using Reports 6i.
• Developed PL/SQL programs for various modules to validate data while importing into oracle system.
• Opportunity to work with basic Power Builder Programming for developing business applications.
• Participated in database development like creating PL/SQL triggers, packages, procedures function.
• Handling errors using Exceptions.

Environment: ORACLE 7.x, Reports 6i, PL/SQL, SQL Loader, SQL.