Summary

• Over 8 Years of experience in Information Technology with extensive knowledge and work experience in System Analysis, design and development of database applications in Client/Server environment using Oracle 10g/9i/8i/8.x/7.3, SQL, PL/SQL, Oracle Forms, Reports, Apex, Designer, Graphics and SQL*Loader
• Involved in project planning and scheduling, System design, Functional Specification, Design specification, preparation of impact analysis, Coding, system test plan, Testing, code review, coordinating user testing and user training, Project demonstration, Implementation, On-line support and Maintenance
• Well versed with Order to Cash and Procure to Pay Cycle
• Strong coding experience in writing PL/SQL(Oracle) , Java, JDBC,JSP, Stored Procedures, Functions, Stored packages, Database triggers, Exception handling and object oriented concepts
• Expertise in developing programs using SQL, PL/SQL and Unix Shell Scripting to query and retrieve data from the existing Oracle databases.
• Expertise in troubleshooting problems with the Oracle client/server system using the Oracle Development tools Oracle Reports Developer version 6i ,Oracle Forms Developer version 6i and Oracle Designer version 6i
• Proficient in developing applications using Oracle Forms10g/9i/6i/5.0 and Oracle Reports10g/9i/6i/3.0
• Oracle expertise includes good understanding of in-depth database architecture, evaluation of application products, database design, development, SQL Performance analysis using Explain Plan
• Expert in Export, Import and SQL*Loader Utilities. Knowledge of reports and forms server
• Proficient in developing PL/SQL packages, stored procedures, triggers and developed various applications, using Oracle built-in packages such as UTL_FILE
• Proficient in Application Performance Tuning using TKPROF and Query Optimization
• Good understanding of DBA responsibilities using TOAD
• Trained in OBIEE, Oracle Application Express and XML Publisher
• Have good work experience in UNIX, Sun Solaris, and Windows 95/98/NT/XP/2000
• Involve with team members to evaluate the fundamental principles, theories, techniques and methodologies of data processing to gather and analyze facts, define problems and solutions.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels, Excellent Communication and Interpersonal skills
• Experience in Team Management, Quality Assurance, Software Testing, and Reverse Engineering etc.
• Result oriented & committed to meet the goal

Education:BS in Computer Science

Certifications: Oracle Certified Associate for PL/SQL Developer (OCA)

Technical Skills:

Oracle10g/9i/ 8i/8/7.3, SQL Server, MS-Access, MS Visio, MS Excel, MS Project

GUI’s/ERP

Oracle Application Server, Developer/2000(Forms 10g/9i/6i/5.0/4.5& Reports 10g/9i/6i/3.0), Oracle Designer 6i/10g, Graphics6i, Visual Basic, Visual Studio, Oracle APEX 3.0, Oracle E-Business Suite 11.5.10(OM, INV, BOM, WIP, AR)

LANGUAGES

SQL, PL/SQL, Shell Scripting (KORN, BOURN), PERL, C, JAVA, XML, HTML.

TOOLS

Oracle Enterprise Manager, TOAD, SQL*Navigator, UTL, Forms Builder, Reports Builder, Schema Builder, Procedure Builder, Graphics Builder, SQL Server 2000, Erwin, Crystal Reports.

OPERATING SYSTEMS

Windows XP/NT/2000/98/95, DOS 6.0/3.0, SCO UNIX, Sun Solaris.

Work Experience:

Confidential,IN Jun 09 – Till Date
Senior Oracle Developer/Analyst
Responsibilities:

• Involved in Requirement Analysis, Design, Data Mapping and Client Interaction.
• Responsible for requirement analysis, client interaction and preparation of Technical document.
• Used Oracle Designer to Design tabbed forms like IT-40, IT-PNR, IT-EZ forms for the DOR
• Designed and developed User Interface for forms and reports
• Developed Technical Design Documents and new setup Forms
• Developed and maintained custom Forms, Reports for existing application for department of revenue’s internal system called RPS
• Developed numerous forms and reports using forms 6i/10g and reports 6i/10g
• Developed reports for sending mails to tax payers about payments/overdrafts/claims
• Developed matrix reports, tabular, master detail dealing with millions of rows
• Involved in migration of Forms/Reports from 6i/10g and dealing with post migration issues
• Developed LOV\'s, Canvases, Layout, Record groups, libraries using Forms Builder to be used in various form modules using Oracle Forms 6i/10g
• Developed interfaces for flow from ifile module, used for online filing of taxes
• Developed PL/SQL procedures, functions, packages and triggers for building customized code in SQL Navigator
• Loaded the data from the source flat files and RDBMS tables to target tables meeting the user business requirements and business rules using the SQL*Loader.
• Used the Data load unload functionality in Apex to upload first time data into the database tables.
• Created page level and item level validations using in Oracle Forms 10g
• Sent emails/reports through the application to appropriate recipients
• Developed various triggers, functions, procedures and packages.
• Developed various complex PL/SQL packages.
• Developed Shell scripts to automate batch jobs and loading process in Oracle.
• Development of custom forms and enhancement of existing forms according to the new state policies
• Developed various processes to set up batch jobs and data loads using Oracle PL/SQL.
• Involved in unit testing and reviewing of interfaces and reports.
• Involved in debugging and providing solutions for efficient writing of PL/SQL code
• Tuning of Database objects using Explain Plan, TKProf, Hints etc. Oracle query tuning and optimization
• Fixed several bugs during development and enhanced for fast phase of the project.
• Handled various production issues for the RPS(Revenue Processing) system

Environment: Oracle 10g/11g, Forms 6i/10g, Reports 6i/10g, HTML, Java Script, SQL *Loader, Solaris, Windows 2000/XP

Client: Confidential,IN Dec 07 To May 09
Role: Senior Oracle Developer/Analyst
Responsibilities:

• Performed data seeding by developing custom procedures and numerous sql loader procedures to load data into Inventory
• Designed, Developed, debugged, and modified stored procedures, triggers, tables, views, user-defined functions etc
• Involved in migration of all the object libraries in batch, then all the PL/SQL libraries, then the menu’s, and then the forms in sequence.
• Involved in writing packages to facilitate Extract, Transform and Load (ETL) using PL/SQL procedures
• Developed various custom forms using Oracle Forms 10g for the jewelry division, designed Order entry forms, Order booking etc
• Developed various custom forms from the scratch for the Tool department like Tool repair/duplicate form, Tooling mass change form, Tool Creation to be put in manufacturing suite
• Ref Cursor Query for developing the reports and prepared complex Data Model and Data Layout in Oracle Reports 10g
• Optimized and enhanced the existing procedures and SQL statements for the better performance and wasInvolved in tuning of existing reports
• Developed reports for the Client for accurate amount validations like the deposits received from the salesrep/customers
• Developed – “Sales order by sales rep “report which was very useful to the Client in retrieving Customer Order data for a designated Sales Rep/Manager.
• Developed various reports like store margin, corporate override, royalty report, pickset status report etc for college personalized announcements using Oracle Reports 10g
• Developed custom forms which involved functionality to create a sales order and on floor work jobs for the jewelry project
• Developed CPA (college personalized announcements) Orders Picked Not Shipped Report to show all of the CPA Orders in house that have picked and that are currently not shipped.
• Developed custom forms which involved functionality to create a sales order and wip job for the jewelry project
• Developed alerts for sending email to Production Control when a Pickset Fails to Pick
• Developed EDIB (Early Data Incentive Bonus Summary) report, to determine the amount of bonus earned by a Sales Representativebased on the profitability of an order. The report is used by Corporate Commission Manager to pay commissions for Sales Representative
• Developed several custom forms and reports for the tooling project
• Defining and reviewing the coding standards, besides reviewing the code.
• Wrote UNIX shell scripts for setting up jobs
• Tuning of Database objects using Explain Plan, TKProf, Sql Trace, Analyze, Hints etc. Oracle query tuning and optimization
• Extensively Involved in Preparing Detailed technical documents from the functional specifications
• Involved in gathering requirements from the users and closely worked with the users in testing the objects in various environments before the Code was deployed in prod.
• Trouble shooting and provide 24x7 supports for Production environment

Environment: Oracle Forms 6i/10g, Reports 6i/10g, BI Publisher, SQL *Loader, TOAD, UNIX, MS Visio

Client: Confidential, IN Jun 07 To Nov 07

Responsibilities:

• Worked on various back end Packages and Procedures using PL/SQL
• Created and customized various Database triggers , Views and materialized views using PL/SQL
• Involved in writing the interfaces for loading data from different sources for Data Warehouse system
• Wrote Oracle PL/SQL procedures for migrating data from interchange to current system
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Loading of data using EXPORT/IMPORT, SQL*Loader
• Designed XML format outputs
• Tuned complex Stored Procedures for faster execution and developed database structures, according to the requirements in Oracle data warehouse.
• Involved in writing packages to facilitate Extract, Transform and Load (ETL)
• Wrote complex Pl/Sql code using Bulk collections, Bulk Bind, SQL Loader, Arrays, Nested Tables
• Building of views and materialized views
• Development of Interfaces to Integrate modules
• Developed different kinds of reports using reports 6i, matrix reports, mailing label, custom reports etc
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also Extensive Usage of Indexes
• Data modeling, database design and creation of database using data modeling tools (Creation of Data Flow diagrams and Entity Relation Diagrams using MS Visio).
• Interaction with the Data warehouse team and helping them in building SQL queries and fine tune for better Performance. Wrote Unix scripts for batch processing
• Involved in writing Unit Test Scripts and Integration Testing
• Involved in setting up data for testing, verifying test results, capturing the results using SnagIT and signing off

Environment: Oracle 10g, SQL, SQL*PLUS, SQL*Loader, Forms/Reports 9i/10g, Designer 9i/10g, TOAD, SnagIT, MS Visio, Solaris

Client:Confidential, WI Oct 06 To May 07
Role: Oracle Developer
Responsibilities:

• Analyzed and participated the database design for better understanding the relations, associations and dependencies within the database.
• Analyzed business functionality with the client and developers for the data warehouse system
• Developed several forms and reports as per business requirements
• Oracle PL/SQL procedures used for migrating data from interchange to present DSS (Design Sub system).
• Used UNIX Korn shell scripts and developed Oracle PL/SQL stored procedures for migrating data for initial load and daily load.
• Used Sql *Loader for data loading and migration
• Ensure conformance to code standards and documentation requirements.
• Depending on the requirements created database objects like tables, indexes, views, procedures, functions, packages, Triggers, synonyms, analytical functions, bulk binds
• Reviewed user application requirements.
• Wrote Java stored procedures as per requirements
• Generated claims reports using business objects
• Developed various reports for internal usage and claims departments.
• Performance Tuning done by using explain plan and query optimization techniques.
• Involved in the development of the entity relationship diagrams for the source and target tables.
• Prepared Test cases and testing procedures for the DSS system.
• Involved in unit testing and Integration testing of the Modules.
• Tested the applications with production data

Environment: Oracle 10g, Forms 6i/9i, Reports 6i/9i, Designer 6i, SQL*PLUS, SQL*Loader, TOAD, SQL Developer, Pro C, PL/SQL, Java, UNUX

Client: Confidential, OH Nov 05 To Sep 06
Role: Oracle Developer
Responsibilities:

• Developed several custom Forms to interact with data tables and schema
• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader – for different cases)
• Explain Plan, Tkprof was used for checking the performance of queries
• Modified and updated existing custom forms to adapt to new database schema
• Modified Reports to suit client requirements
• Involved in creation and updates of several SQL packages and Procedures
• Created SQL scripts for conversion of legacy data (including validations) and then load it into the tables
• Used UNIX shell scripts to automate and systemize the load process at nightly cycles
• Developed several reports that help track down an order
• Modified the discrete job data reports to add custom fields, and altered layouts as per client requirements, and also updated the report to work with discrete jobs involving configured items

Environment: Oracle 9i, Forms 6i, Reports 6i, SQL, SQL*PLUS, SQL*Loader, UTL Scripts, PL/SQL, WinNT and UNIX (Korn Shell)

Client: Confidential,Houston, TX Nov 04 To Oct 05
Role: Oracle Developer

• Involved in System study, Analysis, Design, Data Model, Development, Implementation
• Written PL/SQL Packages, Load Report using Oracle Designer, Oracle Forms, PL/SQL and Oracle Reports
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL Loader
• Written Database Triggers, Stored Procedures using PL/SQL
• Involved in developing Extraction-Transformation-Loading process, using SQL*Loader, PL/SQL package UTL_FILE
• Developed Forms and Reports Using Forms 6i and Reports 6i
• Designing Data conversion/Interface with the use of SQL*Loader
• Created oracle Forms and deployed on the web using oracle Forms server
• Used Oracle Designer to produce web based Reports that analyze data by Creating the End User Layer, Business Areas and aggregates
• Used Oracle reports to set-up ad-hoc queries and reports

Environment: Oracle8i, Developer/2000 (Forms 6i, Reports 6i), PL/SQL, SQL*Plus Reports, XML, TOAD, SQL*Loader, UNIX, Win NT.