SUMMARY

• Over 7 years of experience in analysis, design, ApplicationDevelopment and production support using Oracle SQL, PL/SQL, and Developer Forms and Reports.
• Strong working and conceptual knowledge of Oracle SQL, PL/SQL, Forms and Reports, Java, and HTML.
• Proficient in writing Packages, Stored Procedures, Cursors,Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Extensive experience in analysis and design of database including ER Diagrams and Normalization techniques.
• Data modeling and Design using Erwin and MS Visio.
• Experience in Performance Tuning and Optimization of SQL statements
• Experience in Tuning SQL statements using EXPLAIN PLAN and TKPROF to improve the performance.
• Used Oracle FormsandReports 6i/9i/10g to develop user interfaces and customized Forms and Reports based on user requirements for Oracle Applications.
• Comfortable working with Testing, Debugging, and Deployment of Applications.
• Good working experience with MS SQL Server as a developer.
• Working knowledge of Unix Shell Scripting.
• Data Conversion from Flat files to Oracle using Oracle SQL* Loader.
• Experience in migration and conversion from MS Access/SQL-Server to Oracle.
• Knowledge of Extraction, Transformation and Loading (ETL) process to load the database.
• Knowledge of Star Schema modeling and Snowflake Dimensional modeling.
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation
• Involved in development of web pages using PHP.
• Strong interpersonal & communication skills.
• Competitive analytical, logical, and problem solving skills.
• Strong management, administrative and leadership skills to work in team.

TECHNICAL SKILLS

Languages

SQL, PL/SQL, C, Java, ASP, JavaScript, JSP, XML, HTML.

Databases

Oracle 9i/10g, MySQL, DB2, MS SQL Server 20005/2000.

Operating Systems

Windows 98/2000/XP, Unix

Packages

MS Office (Word, Excel, Access, PowerPoint, Visio), Erwin

Reporting Tools

Business Objects, Crystal Reports, Oracle Reports 6i/9i

GUI

Developer 2000, Forms 6i/9i

Other Tools

SQL*Loader, SQL*PLUS

Confidential, GA Duration: Jan 09 - Till Date
Role: Oracle 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
• 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.
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Involved in the Modifications and development of databases and tables to support new inventory changes.
• Attended Sales meetings to brain storm report ideas to help push sales.
• Created indexes on tables and Optimizing Stored Procedure queries.
• Designed reports that had complex SQL, PL/SQL code and stored the procedures. Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 10g.
• Worked on Oracle Portal to develop reports as per the requirement.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse
• Worked on UNIX shell scripts to handle the files.
• Created XML pages that allowed for selections of dynamically created checkboxes separately, as a group, or within subgroups, displayed and hid different page components based on user selections and subscription rights, displayed and manipulated multiple selection word wheels.
• Played a key role in loading the data from the staging tables to target tables.

Environment: UNIX, Oracle 10g, Developer Suite (Forms 10g, Reports 10g), PL/SQL, Shell.

Confidential, Chicago, Il Duration: Mar 08 - Dec 08
Role: Oracle developer

Responsibilities

• Expanded the complexity of Packages and StoredProcedures; sometimes having to be writing these Packages.
• Skilled in understanding the Business Rules and effectively implementing them into Business Process flow.
• Analyzed Oracle data using SQL scripts.
• Support the Business team to resolve the data issues and business clarifications.
• Converting business requirements into technical specifications, and detailed mapping documents.
• Created PL/SQL procedures as of the requirements.
• Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
• Programmed Shell Scripts to retrieve third party data into stage tables for insertion into our databases.
• Involved in the Design and Development stages of data entry Forms using Forms9i which were also used for weekly and monthly inventory counts for different store locations.
• Involved in the Design and Development of Sales Reports using Reports9i
• Developed Reports that would produce ratios for sold items in different categories for each store location and individual employee.
• Developed and scheduled Perl scripts.
• Worked on UNIX shell scripts to handle the files.
• Trouble shooting Problems by using SQL server profiler.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse
• Produced Scripts to cleanse source data, ETL process (Extract, Transform & Load) data with business rules, and built re-usable Mappings.
• Created Staging table scripts, SQL Loader control files.
• Developed Korn Shell Scripts for various pre and post session operations, database administration and daily system monitoring activities such as checking source database status

Environment: ORACLE 10g, SQL*Plus, PL/SQL, SQL*Loader, Oracle 10g Forms & Reports, DB2, Export/Import, TOAD, SQL Navigator, ERWIN, Oracle Web Application Server, UNIX Shell Scripting, ASP.Net, Toad.

Role: Oracle developer

Confidential, Tampa, Duration: June 07 - Feb 08
Responsibilities

• Define project plans and involved in analyzing, designing, reviewing, testing and integration.
• Worked in coordination with business team for creating Business Use Cases.
• Tuned performance of SQLQueries, Sources, Targets and Sessions using TOAD.
• Involved in performance fine-tuning of the queries/reports in various schemas across the database using, Oracle Hints, Explain Plan and Trace sessions.
• Involved in the Design and Development of Sales Reports using Reports9i.
• Created Reports9i that displayed sales margins for daily, weekly, monthly, and
• Worked on Cron-jobs to schedule UNIX jobs..
• Loaded data into tables using SQL*Loader
• Other responsibilities included: Creating Queries for Business Objects to produce reports, Generating XML flat files from select queries, developing SQL*Loader scripts to load data into tables, and working with the Production Support team to fix many high priority bugs.
• Designed model for daily transaction for the application in Erwin
• Created UNIX Shell Scripts for automating the execution process.
• Implemented new constraintsin existing Triggers and programmed new triggers that were required for new data
• Created Triggers to apply business rules to the inventory count forms.
• Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures Fine tuned SQL Statements to improve the performance of batch modules using Explain Plan, Tkprof.
• Design front end for a web based application using Java, JSP.

Environment: ORACLE 10g, Oracle Ias, SQL*Plus, PL/SQL, SQL*Loader, Oracle 10g Forms & Reports, DB2, Export/Import, AIX ,TOAD, JDBC, SQL Navigator, ERWIN, Oracle Web Application Server, UNIX Shell Scripting PRO*C, ASP.Net, Toad.

Confidential, Pittsburgh, PA Duration: Jan 06 - May 07

Role: Oracle developer

Responsibilities:

• Involved in the Modifications and development of databases and tables to support the new inventory changes.
• Involved in the Design and Development stages of data entry Forms using Forms 4.5 which were also used for weekly and monthly inventory counts for different store locations.
• Involved in the Design and Development of Sales Reports using Reports 4.5.
• Attended Sales meetings to brain storm report ideas to help push sales.
• Scripted end-of-night batches that would accept sales totals and the end of each night for each store location.
• Created Functions to compute sales calculations and sales predictions based on past sales totals.
• Designed and developed Forms for the HR department.
• Developer different user interface screens (HTML/JSP) and validations using Java script.
• Programmed Procedures to give new employees commission status after certain specified time and changing employee salaries after receiving certifications.
• Developed, modified, and optimized complex queries for data retrieval and modification
• Involved in monitoring of datawarehouse

Environment: Oracle 8i,PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, UNIX, PRO*C, Windows NT 4.0/2000/XP Windows2000, Linux.

Confidential, MN Duration: Aug 04 - Dec 05

Role: Oracle developer
Responsibilities

• Prepared program Specification for the development of PL/SQL procedures and functions.
• Created Custom Staging Tables to handle import data.
• Developed SQL* loader scripts to load data in the custom tables.
• Run Batch files for loading database tables from flat files using SQL*loader.
• Created UNIX Shell Scripts for automating the execution process.
• Developed PL /SQL code for updating payment terms.
• Created indexes on tables and Optimizing Stored Procedure queries.
• Design, Development and testing of Reports using SQL*plus.
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Designing Cognos Impromptu objects including catalogs, folders, user profiles, levels of summarization
• Used power play.
• Involved in preparing documentation and user support documents.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Modified existing forms & reports as per client requirements and also developed custom forms and reports for additional functionality in different modules.

Environment: Oracle 9i/10g,PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, UNIX, Windows NT 4.0/2000/XP Windows2000, Forms 6i, Visual Studio.

Confidential, Oak brook, IL Duration: Jan 02-June 04

Role: Oracle developer
Responsibilities:

• Identified and analyzed business processes & data flow by conducting interviews with end users.
• Created a streamlined process flow to improve employee efficiency.
• Developed a functional flowchart to describe activity rules between business units using Visio
• Designed and Created E-R diagrams for the entire process along with flowcharts using MS-Visio.
• Designed and implemented a centralized relational database schema for sales, marketing, and eligibility operations applying referential integrity constraints.
• Used SQL Stored Procedures to obtain and transfer data to the database using SQL Server.
• Developed and executed data conversion plan from MS Excel to SQL Server 2000 using DTS.
• Interacted with user to gather requirements for report generation using crystal reports.
• Tested and deployed the application at client site
• Provided training to the users to effectively use the new system
• Performing FTP of client and medical CBT for reporting and analysis purpose.
• Provided maintenance an troubleshooting services when required

Environment:SQL Server 2000, Visual Studio 2003, Crystal Reports.