SUMMARY:

• 7 years of IT experience in Design, Development and Maintenance of various software applications in client - server environment using Oracle Technologies on UNIX & Windows Platforms.
• Expertise in Client-Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Created database objects such as Tables, Views, Synonyms, Indexes, Sequences and Database Links as well as Custom Packages tailored to business requirements.
• Experience in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages to implement business logic.
• Possess strong Documentation skills and knowledge sharing among team
• Highly involved in all phases of Software Development Life Cycle (SDLC) from Analysis, Design, Development, Test, Implementation, Documentation and Support.
• Experience in working with Java developers to coordinate Web-based functionalities with Oracle Database. Knowledge in XML, HTML and JavaScript.
• Well versed in MS Office Suite such as Visio, Word, Excel, Access and PowerPoint.
• Involved in programming, debugging, and unit and system integration testing of modules.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Involved in jobs scheduling, monitoring and Production Support in a 24/7 environment.
• Excellent Analytical and Problem Solving skills with strong communication and interpersonal skills.
• Flexible, highly-adaptable, team-player, pro-active and eager to learn and perform new tasks.
• Experience in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques
• Experience in loading data from flat files to database tables using SQL*Loader.
• Experience in working with UNIX and expertise in UNIX Shell Scripting.
• Analyzing the incidents, those arise in production, and fixing them within the Service Level Agreement.
• Write and modify Database Stored Procedures and Structured Query Language (SQL) queries to improve database performance.
• Understand the Business Requirements from the Client and prepare the high level design document for Project Application Modules.
• Understanding the code and functionality of the module.
• Created detailed design documents (UML diagrams like Use case, Class, Sequence, and Component diagrams) using Visio software.
• Using Clear Quest & Level3 Bugzilla as Defect Tracking Tools to track and resolve the defects.
• Coordinating with the Offshore - Client teams, ensuring clear flow of information and efficient authoring and reviewing.
• Reviewing the module specific deliverables of the team
• Guiding the team in understanding the code and functionality of the Use Case.
• Responsible for executing the scripts and debugging the test scripts.
• Customizing the test scripts to work with various data (Parameterization).
• Involved in creation of different project status sheet and Reports.
• Preparing Knowledge Transition documents for important and complex functionality of the Use Case.
• Execute data tests (positive and negative).
• Maintain and Recondition Data as needed for testing.

TECHNICAL SKILLS:

Languages: C,C++, Java, XML, PL/SQL

Databases: Oracle9i/10gR2/11g,sybase 12.5.3/12.5.0.3/12.0/11.9.2

Tools: SQL* Plus, Toad, SQL* Loader, SQL Developer, Oracle Developer, MS Visio, Text Pad, Eclispe IDE 4.0, IBM Clear Quest Tool, IBM Rational Quality Manager, SSRS, Crystal Reports, and Business Objects

Web Technologies: HTML, CSS, XML, JavaScript

Web Servers: Tomcat, IIS

Operating Systems: UNIX, Solaris, Windows 95/2000/NT/XP,7

PROFESSIONAL EXPERIENCE:

Confidential (Pittsburgh, PA )

PL/SQL Developer

Responsibilities:

• Developed PL/SQL Stored Procedures, Functions and Packages
• Involved in requirement gathering along with the Business Analysts Group.
• Involved in Object Modeling in UML using Rational Rose 2000
• Gathered various requirement matrices from the business analysts
• Participated in Joint Application Development (JAD) sessions
• Conducted Design reviews with the business analysts, content developers and DBAs.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 9i
• Developed screen layouts, report layouts using Forms and Reports and participated in implementation.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Successfully manipulated Stored Procedures, Functions and Packages using TOAD.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Designed and developed various reports using Oracle Reports 9i.
• Created and used Table Partitions to further improve the performance while using tables containing large amount of data.
• Used Designer 2000 for Data Modeling, Design Specifications and to analyze Dependencies.
• Assisted in debugging Visual Basic.NET components
• Developed PL/SQL packages using Oracle Standard/ Custom Exceptions.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Worked with the Implementation team to ensure a smooth transition from design to implementation phase.
• Performed Data Loading and Transformation using SQL* Loader.
• Identify,report and resolve risks related to the project-module.

Environment: Oracle 10g, PL/SQL, SQL*LOADER, SQL PLUS, ASP, HTML, PVCS, TOAD, Java, Developer Suite 6i/9i (Forms, Reports), Rational Rose 2005, Windows NT 4.0/2000, UNIX shell scripting.

Confidential . (St.Louis,MO)

PL/SQL Developer

Responsibilities:

• Worked on multiple projects with different business units including Insurance actuaries
• Gather the various reporting requirement from the business analysts.
• Develop PL/SQL procedures,functions and packages
• Gather all the Sales analysis report prototypes from the business analysts belongingto different Business units; Participated in JAD sessions involving the discussionf various project needs.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Coded database Triggers, Package, Functions, and Procedures using PL/SQL; and maintained the scripts for various data feeds.
• Optimized and tuned PL/SQL to reduce the loading process.
• Created shell scripts to automate the acquisition and archiving of files.
• Wrote KORN Shell Scripts to prepare files to be merged into the database
• Developed UNIXscripts to create FTP Jobs.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Responsible for designing and maintaining fully integrated and multiple levels help system for the modules.
• Involved in preparing functional specifications, release notes, materials and other documentation.
• Performance tuning of SQL queries for data warehouse consisting of many tables with large amount of data.
• Created Packages, Procedures and Functions that extensively used PL/SQL cursors, user defined object types and exception handling.
• Optimized and tuned PL/SQL to reduce the loading process. Used SQL trace facility and Tkprof along with Explain Plan to accurately assess the efficiency of the SQL statements when the application runs.
• Designed star schemas using dimensional modeling and created fact tables and dimensional tables.
• Involved in writing complex scripts for Data Transformation and ETL process.
• Used ERWIN for logical and physical Database Modeling. Analyzed Business documents, Internal & External Source systems and requirements to develop the Logical and Physical model (Facts and Dimensions) and Business Process Model.
• Analyzed and designed UML model using MS Visio to reflect existing business models.
• Ensured the feasibility of the logical and physical design models;
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Identify,report and resolve risks related to the project-module.

Environment: Oracle 10g/9i, SQL, PL/SQL, UNIX, UML, Business Objects, Windows XP, SQL*PLUS, SQL*Loader, Erwin, SSRS.

Confidential (Denver,CO)

PL/SQL Developer

Responsibilities:

• Interacted with the business community and database administrators to identify the business requirements
• Develop PL/SQL procedures, functions and packages
• Used SQL queries and database programming using PL/SQL (writing Packages,
• Stored Procedures/Functions, and Database Triggers).
• Worked on SQL tools like TOAD to run SQL queries and validate the data.
• Worked on database connections, SQL Joins, views in Database level.
• Work with team members using SQL Loader to load data from flat files to database tables in Oracle.
• Written SQL scripts to create database objects like tables, views and sequences.
• Constant monitoring and performance tuning of Oracle10g database, checking the most queries.
• Developed batch programs using UNIX shell scripts to generate reports daily, weekly & monthly for Customers Markets.
• Created Korn Jobs to perform regular updates to database tables to keep in sync with the data coming from other sources.
• Performed review and analysis of deadlocks and database performance tuning.
• Conducted code walkthrough & internal/peer reviews on application code and other deliverables.
• Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Involved in the continuous enhancements and fixing of production problems.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Implemented procedures/functions in PL/SQL for Stored Procedure
• Transformations.
• Identify, report and resolve risks related to the project-module.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, KORN Shell script, Erwin, TOAD, Web Logic, HTML, Java, J2EE, Unix