SUMMARY

• Over 7 Years of Experience as an Oracle Developer with Proficiency in Oracle 11g/10g/9i/8i, SQL, Oracle PL/SQL, Oracle Form Builder 11g/10g/9i/6i, Report Builder 11g/10g/9i/6i, C, C ++,UNIX Shell Scripting.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 (Forms, Reports) Oracle Developer Suite 10g/11g and other front - end tools.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Extensive working experience in developing Database Triggers, Stored Procedures, Functions for developing Forms and Reports.
• Experience in Migration of Forms 6i, Reports 6i to Forms 10g and Reports10g.
• Good understanding of oracle Data Dictionary and Normalization Techniques.
• Expertise in performing Data export, Import and various operations using TOAD,SQL Developer.
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Partitioning, Indexes, Explain plan, Trace utility & TKProf.
• Extensive experience in using Cursors and Ref-cursors for processing of data.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records and Types.
• Strong programming skills on Oracle SQL, PL/SQL indexes, bulk collects and Collections.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
• Experience in UNIX Shell Scripting.
• Extensively worked on IBM’s Automation tool- Tivoli Workload Scheduler.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using Informatica Power Center to populate the tables in OLTP and OLAP Data warehouse Environment.
• Worked with query tools like Toad, SQL*Plus, PL/SQL Developer.
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Enforcing experience in data integrity using integrity constraints and database triggers.
• Good knowledge and Understanding on BO Reports.
• Experience in creating Materialized Views and DB links,Synonyms.
• Experience in using Erwin Software tool,Crystal Reports etc.
• Extensive experience in Production Support and troubleshooting data quality and integrity issues .
• Extensive experience in working with large Databases.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work as a team lead also.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i

Oracle Tools: SQL * Loader, TOAD,PL/SQL Developer, SQL Developer, SQL Tool, SQL Navigator, Developer 2000 (REPORTS 6i/10g/11g, FORMS 6i/10g/11g), SQL*Plus, Discoverer, Crystal reports, BO reports .

Data Modeling Tools: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

Programming Languages: Unix Shell Scripting, Perl Programming, XML, C, C++,Java, HTML,XML

Environment: Sun Solaris 2.6/2.7/2.8/8.0 , Red Hat Linux, Windows NT/ 95/ 98/ 2000/ XP,MS DOS 6.22

ETL Tools: Informatica Power Center 9.0

Operating Systems: Windows XP/ 2000/2003/2007/ NT, UNIX, Red Hat Linux

PROFESSIONAL EXPERIENCE

Confidential, Richfield,MN

Oracle PL/SQL Developer

Responsibilities:

• Develop queries/stored procedures to analyze and correct issues in the Oracle OIM/OIA provisioning system.
• Data analysis to determine discrepancies between the two systems and generation of SQL to correct issues as they are found as well as reporting trends in those discrepancies.
• Cleanup of data initiative for the mainframe. This involves data ETL of both data from mainframe reports and OIM/OIA data.
• Analysis and generation of mainframe commands to add users to missing mainframe groups as well as analysis of RACF permission sets and reporting of access that users may lose based on the cleanup process.
• Develop other ad hoc queries based on need for OIA/OIM clean up.
• Importing and Exporting the Data from large text files/excel files into the database using SQL Developer.
• Created and maintained Tables, procedures, and Indexes .
• Tuned PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
• Tuned PL/SQL Packages and PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, table partitions, Explain plan and analyzing the tables.
• Performed SQL performance tuning using Explain plan, Trace utility & TKProf.
• Created mappings using various transformations like Expression, Update strategy, Lookups, Filters, Routers, and Joiner transformations.
• Providing Production support and solving Day-Day problems.
• Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
• Exporting and Importing the data into the database as and when user provided the data and do analysis.

Confidential, Kansas,MO

Application Developer

Responsibilities:

• Developing Script work flows, Forms using the DCLink tool according to the Client requirements.
• Analyzing, creating new and modify existing forms.
• Designing, developing the enhanced custom Forms and Script workflows according to the Design specification.
• Helping Team members in tuning queries and programs and trained them to write well-tuned code.
• Created and maintained Procedures, functions, Packages, and DB triggers.
• Implemented Exception handling, Autonomous Transactions, Pragma Exception Init, Locks, used save points, commits & rollbacks to maintain Transactional consistency & database integrity.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in analysis, system design documentation.
• Created and maintained Tables, views, procedures, functions, packages, DB triggers, and Indexes.
• Successfully manipulated Stored Procedures, Functions, Triggers and Packages using TOAD and SQL Navigator.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors etc.
• Tuned PL/SQL Packages and PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.
• Extensively involved in data migration.
• Used UTL FILE built-in package to generate files as per the requirement.
• Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
• Implemented Exception handling, Autonomous Transactions, Pragma Exception Init, Locks, used save points, commits & rollbacks to maintain Transactional consistency & database integrity.
• Wrote complex in-line Views which summarized the business needs to the fullest.
• Involved in Migrating the entire database setup from test environment to production.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL and UNIX utilities.
• Designed Reports that had complex SQL, PL/SQL code and stored procedures using Reports 11g.
• Designed Forms that had complex stored procedures and PL/SQL code using Forms 11g and did some personalizations.
• Involved in the continuous enhancements and fixing of problems.
• Involved in creating Detail Design Documents for the requirements.
• Involved in formulating general methodologies, Naming conventions and Coding standards for various procedures and packages

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzed, created new and modified existing forms, reports, scheduled reports, Oracle 6i,PL/SQL, Stored Procedures, Functions, Packages, Triggers etc.
• Designed, developed and enhanced custom Forms and Reports according to the functional specification.
• Did code reviews of other developers and provided suggestions to improve performance
• Wrote high performance queries/programs using Bulk Binds, REF Cursors etc.
• Helped other developers in tuning queries or programs and trained them to write well-tuned code.
• Provided expertise to development managers in design or preparing proof-of-concept testing.
• Converted Forms & Reports from 6i to 10g.
• Wrote complicated stored Procedures, Functions, Database Triggers and Packages, Shell Scripts.
• Involved in handling Exceptions through PL/SQL Blocks.
• Created various feeds/downloads, nightly batch jobs and other daily/monthly reports/downloads.
• Developed SQL *Loader scripts to load data from flat file to Oracle 10g database tables.
• Tuned batch jobs and other daily/monthly reports/downloads.
• Used Toad for creating and modifying procedures, functions and triggers.
• Developed complex Oracle Forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc).
• Created Test Plan for QA and implementation plan for Production implementation once the unit test is done.
• Performed SQL performance tuning using Explain plan, Trace utility & TKProf.
• Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.
• Maintaining different version of software (version control) using CVS.
• Used Erwin Software tool for data modeling.
• Providing production support solving Tickets created using the software ElemenTool.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Developed thin client reports using Crystal reports.
• Preparing test plan for QA for testing before moving from PreProd to Production environment.
• Trouble shooting the day to day problems in the areas of Costing, Process Raw materials and Raw material accounting, Security system, Stores, Private vouchers, OptiVISION (OTIF).
• Doing month end activities.
• Providing data to corporate auditors and to the users as per their requirement.
• Modifying forms, reports and stored procedures & packages, triggers, functions etc to meet the business requirements.