SUMMARY

• Senior Software Engineer with 7years of total IT experience in the areas of analysis, design, development, implementation and management of full life cycle commercial applications.
• Proven technical skills with 5 years of experience in Oracle SQL, PL/SQL and oracle 9i/10g/11g/12c.
• Experienced in developing Stored Procedures, Functions and Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Experience in Dynamic SQL, Records, Arrays and Exception Handling
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• 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.
• Hands on experience in lowering the query by more than 200% using hints like PARALLEL, PARALLEL INDEX,APPEND
• OLTP environment experience.
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Extensive ability to back trace the bottle necks of a query using LONGOPS.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operational costs.
• Highly motivated & conceptually strong individual with outstanding oral and excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS

Languages and Technologies: PL SQL, C, C++, SQL plus

Operating System: MS Windows 2000/NT/XP/NT & VISTA, MS DOS and UNIX.

Databases: Oracle 8i, 9i, 10g,12cAccess, MS SQL Server

GUI(S): Visual basic 6.0, ASP, HTML, Cold Fusion

CASE TOOLS: VANTIVE, TOAD 8.5,12.1.0.22,Oracle report builder,Oracle form builder

Reports: Crystal Reports 7 / 8, Oracle Report Builder, MS visual studio 2005

Version Control: Visual SourceSafe, CVS, WINSCP

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma city, OK

Pl/Sql developer

Responsibilities:

• Involved in project analysis, design and implementation.
• Involved in developing PL/SQL scripts for different procedures and packages.
• Involved in handling and generating reports using oracle apps for different Instances and agencies in Confidential .
• Worked on Confidential payroll system and developed PL/SQL scripts for procedures and packages and also involved in testing and fine tuning of the code .
• Worked on oracle report builder for generating the “Biweekly-Reports” on payroll in Confidential .
• Worked on payroll related SCR’s (Status Change requests) in development and tested the code using oracle apps.
• Worked with project support team and involved in supporting the R12 upgrade to databases.
• Written UNIX scripts for invoking the oracle reports and oracle forms and also to move files from server to local .
• Involved in leading and working on SOA web services 12c for a project.
• Involved in a complete project as a front end developer, also managed middle tier web services and also involved in testing phase of the whole project for Confidential and Confidential .
• Involved in writing technical documents for the SCR’s and also wrote testing documents for future testing references.
• Involved in working oracle Forms and Reports
• Involved in giving support to the production issues and databases.

Environment: Oracle 11g,12c (SQL, PL/SQL),TOAD 12.1.0.22, Report Builder 10.1.2.0.2 , Forms Version 10.1.2.0.2 , Oracle E-Business suite, WINSCP.

Confidential, Columbus, OH

Developer

Responsibilities:

• Involved in interacting with the end-user (client) to gather business requirements.
• Participated in analyzing and modeling the requirements for the logical and physical design of the database using star schema and normalization techniques.
• Population of the data warehouse tables using SQL*Loader.
• Analyzing and writing Oracle PL/SQL code.
• Developed procedures to run the SQL * Loader to load data from flat files into the target database tables.
• Developed complex mappings to load data from Source System (Oracle) and flat files
• Define and represent Entities, Attributes and Joins between the entities.
• Written UNIX shell scripts to automate loading files into database using crontab.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
• Identified SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), Explain plan, Auto trace, TKPROF and tuned them for better performance.
• Increased performance by creating Indexes and Hints.
• Responsible for troubleshooting various aspects of the client/server architecture in both UNIX and Oracle setting.
• Analyzing and upgrading Oracle Forms 11g.
• Aided developers in writing efficient code and making efficient use of the resources leading to better performance and optimization.
• Developed Front end Designs using .Net Framework using WinForms, WebForms, HTML/DHTML, JavaScript, Crystal Reports 9.0, used Control Objects, Package and Deployment.
• Developed interface program in VB.Net and used ADO.Net Oracle Database as Data Access Layer.
• Coordinated the deployment of applications on a CITRIX server/NetScaler.
• Support for the development, pre-production and the production databases.

Environment: Oracle 10g (SQL, PL/SQL), SQL*Loader, Forms 6i, TOAD 7.4, HTML/DHTML, PRO*C, JavaScript, Windows NT/2000, Crystal Report 8.0/9.0, Erwin 4.0, UNIX, CITRIX.

Confidential, NE

Oracle PL/SQL Developer

Responsibilities:

• Responsible for system study & information gathering.
• Development was done using front end as Oracle Pl/Sql Developer/2000.
• Involved in creation of Tables using storage parameters and clusters.
• Involved in writing Database procedures, Functions, Packages and Database Triggers.
• Coded many generic routines (as functions), which could be called from other procedures.
• Developed user interface screens, Master detail relations and Report screens.
• Analyzing and upgrading Oracle Reports.
• Developed various Reports for the end users as per their requirements and created many reports to suit preprinted format of the company.
• Conducted training sessions to end-users.

Environment: Oracle 9i, PL/SQL, SQL Loader, Shell Scripting

Confidential, Louisville KY

Developer

Responsibilities:

• Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Designed reports that had complex SQL, PL/SQL code and stored the procedures.
• The filter conditions for the Queries were dynamic in nature and included lexical parameters.
• Responsible for coding and modifications to enforce business rules and to improve performance of the system.
• Fined tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans.

Environment: Oracle 10g/9i, PL/SQL, SQL PLUS, TOAD, Windows XP Professional.

Confidential, Tucson, AZ

Responsibilities:

• Wrote stored PL/SQL Procedures for reports.
• Developed Queries using SPL data model for CC&B to Understand the business Flow
• Developed PL/SQL scripts for data processing.
• Created Indexes, Views and Tables
• Knowledge with ETL involving large amount of data, in particular XML and loading into Oracle.
• Optimized the existing UNIX scripts to achieve better performance.
• Wrote triggers and procedures to handle the data processing.
• Created scripts to trigger nightly batch processes.
• Involved in Developing and Generating Reports.
• OLTP environment experience.
• Preparing Unit test scripts, setting up a test environment and unit testing the code.
• Tuning of the SQL statements for application developers

Environment: Oracle 10g, PL/SQL, Report Builder 10.1.2.0.2 , Toad 7.5.2.0, Unix