SUMMARY:

• Six Plus years of IT experience in Oracle PL/SQL Programming, SQL Tuning, analysis and design of business application, technical support on various versions of Oracle (9i,10g,11g) on mid - range and higher end platforms Unix systems and MS SQL Server 2000 on Windows 2000.
• Experienced in software development using Oracle SQL, PL/SQL (including Procedures, Functions, Triggers, and Packages), database tools like TOAD & PL/SQL Developer
• Expertise in variety of applications including Banking, Telecom, Insurance, Knowledge management, Facility/Customer Management System, Work and Pension domain for Government projects.
• Exposed to various stages of Software Development Life Cycle on Client/Server, Multi-tired and Web-based Applications, Designing and Development of applications using SQL,PL/SQL, Oracle Database 9i, Developer 2000, Designer 2000,SqlLoader,Import and Export
• Extensive experience in Development, Business Analysis, Application Design, Data Modeling,, Implementation and Testing Data warehouse and Database applications.
• Very strong skills in Oracle 9i/10g/11g, SQL, PL/SQL, Performance Tuning, SQL* Loader, UNIX Shell Scripting.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization Using Oracle Hints, Explain plans and Table partitioning.
• Extensive programming experience in SQL & PL/SQL procedures, functions, triggers and packages.
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Have extensive experience in developing, implementing and maintaining application systems under Windows/Unix operating systems using SQL, PL/SQL, Oracle Database and many other facilities, such as Import/Export, SQL*Loader and SQL*Plus.
• Extensively involved in writing Views, Materialized Views, PL SQL anonymous blocks and Collections (Bulk Collect programs).
• Sound knowledge/experience in writing all kinds of SQL scripts and Shell Scripts (Ksh, C, Bash Shells) for complete data load, transformations using SQL Loader, PL SQL scripts.
• Involved in Data Modeling to design the Database. Star schema Snow Flake schema etc.
• Extensive experience in installation, performance tuning, implementing backup and recovery strategy for application and database. Extensively involved in SQL tuning and Application tuning
• Maintaining Replication Server using Materialized views. Experience to TOAD & ODBC interfaces to Oracle.
• Code, test, and debug application solution according to design spec, Provide development, maintenance, and operation documents of batch processing.
• Strong analytical and problem solving skills, excellent communication and presentation skills, and a good team player.

TECHNICAL SKILLS

Operating Systems: Windows - 95/98, Windows - NT/2000, 2003

Windows XP, Vista and 7:

RDBMS: Oracle 7.x / 8.0 / 8i / 9i, 10g, 11g, SQL Server 7.0/2000

Languages: C, C++,UNIX, PERL, HTML, DHTML, XML

Utilities: SQL*Loader, exp, SQL, PL/SQL, TCP/IP, SQL Plus, SSH, Telnet, External Tables

Tools: Oracle Enterprise Manager, TOAD, SQL Navigator Oracle utilities export, import, MS Office, MS Visio

GUI: Visual Studio 2008/2010

PROFESSIONAL EXPERIENCE

Confidential, IL

PL/SQL Developer.

Responsibilities:

• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle tools like PLSQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Extensive Experience in customization of modules using Forms 6i, Reports 6i.
• Involved in the customization of Oracle seeded reports using Reports 6i.
• Prepared program specifications for PLSQL Procedures and Functions to do the data migration and conversion
• Developed ad-hoc reports using discoverer 10g.
• Involved in database development by creating Oracle PLSQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Develop and test UNIX Shell Scripts. New scripts were also required to automate and drive the procedural execution of applications for efficiency and troubleshooting purposes
• Fine Tuned procedures for the maximum efficiency in various schemas across databases
• Optimized critical queries to eliminate Full Table scans reduce Disk I/O and Sorts.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Participated in Performance Tuning using Explain Plan.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: Oracle 9i, SQL Navigator, SQL * Plus, Oracle Designer, Crystal Report, Windows NT.

Confidential, CA

PL/SQL Developer

Responsibilities:

• Wrote Oracle PL/SQL scripts for reporting and troubleshooting
• Used to Convert Data into uniform feed as specified from requirements
• Wrote many PL/SQL Procedures/Packages for data handling.
• Created many UNIX shell scripts and enhanced the existing scripts.
• Tuned Stored procedures for optimizing the performance of the application
• Created Autosys jobs for scheduling the loads.
• Created many Oracle Tables, Stored Procedures and Triggers
• Participated in Stored Procedure tuning
• Created many PL/SQL to apply the business logic
• Was part of scripting team for shell script to automate and migrate data from ODS to Data warehouse.
• Created ad-hoc reports using UNIX Shell Scripts.
• Used to use data conversion methods for data from different feeds
• Clear Case is used for version control.
• Provided data for Unit, System Integration and User Acceptance testing.
• Coordinate with offshore team.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Involved in the analysis, design and development of all the interface’s using Informatica Powermart tools in interface team and interfaced with all the other tracks for business related issues.
• Used Debugger to test the mappings and fix the bugs.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Created, updated and maintained ETL technical documentation.
• Loaded aggregated fact tables.
• Managed software releases after each stage of the testing and defect removal.

Environment: Oracle 9i, PL/SQL, SQL, HTML, Power Builder, SQL Plus, Oracle Designer and Toad.

Confidential, CO

PL/SQL Developer.

Responsibilities:

• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle tools like PL/SQL Developer.
• Worked on Logical and Physical Data Modeling.
• Writing SQL Queries for data validation, extraction and loading.
• Engaged in gathering user requirement for the development of 'Healthcare' portfolio for PDS.
• Occupied in the Low-level design of the data tables for the 'Healthcare' portfolio.
• Engaged in the Low Level Design documentation according to the documentation standards.
• Implementing the Informatica interfaces for monthly load of production tables.
• Engaged in design and development of PL/SQL procedure for populating data into Aggregate loss tables.
• Preparing Unit test plans for the components developed and Unit testing.
• Developed PL/SQL Procedures and UNIX Scripts for Automation of UNIX jobs.
• Developed Unix Shell Script as required.
• Converted previous data from other Language Applications into Oracle database.

Environment: SQL and PL/SQL, TOAD, SQL*Loader, Unix Shell scripts, Crystal UNIX.

Confidential, St Louis, MO

PL/SQL Developer

Responsibilities:

• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Creating SQL, Object Views, PL/SQL database objects.
• Used PL/SQL TABLE, RECORDS and OBJECT TYPES.
• Analyzed and prepared Statement of Work and Requirement Definition Document.
• Designed the business logic to eliminate problems and to ensure efficient system functioning.
• Creating the Oracle schema i.e. table spaces, tables, indexes, constraints, triggers, synonyms, database links, roles etc.
• Implementing basic replication using snapshots.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment.
• Tested the entire application in testing environment and exported to Production.
• Developed intricate PL/SQL Procedures, Functions, and Packages to handle the business requirements and manage the inflow and outflow of data.
• Testing stored procedures, programs (functional modules) before deploying into the production database.
• Developing back end logic for business reports using PL/SQL
• Reducing the large number of outstanding faults

Environment: Oracle10g, Toad, SQL * Plus, Oracle Designer, Windows NT, Rational Clear Case (Version control tool) and Rational Clear Quest.