SUMMARY

• Having 10 Years of experience in the field of Software Design, Development and Implementation with Proficiency in Oracle, SQL, PL/SQL as well as Java /J2EE that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Experienced in creating the OOP modeling using Rational Rose and transform the model to RDMS using SQL scripts and implement the business logic in PL/SQL.
• Knowledge and Exposure to Oracle 10g and 11g.
• Experienced in PL/SQL Batch Processing and extensively used SQL*Loader for the data loading from text files.
• Expert in SQL Query Tuning, Database Triggers, Materialized Views, Stored Procedures, Packages and Dynamic SQL.
• Strong in writing Stored Procedures using PL/SQL, Strong in writing SQL queries.
• Created SQL scripts to perform Data Repair Tasks.
• Experienced using Oracle Collections, bulking techniques.
• Involved in Profiling and Tracing the PL/SQL Code using PL/SQL supplied packages and Dictionary views.
• Extensively used HTP, HTF and OWA packages used to dynamically build webpage from PL/SQL.
• Developed stored packages with Oracle's Web Toolkit
• Hands on experience in Object Oriented Programming and Relational Database Management Systems.
• Extensively worked on data conversions from legacy to oracle.
• Involved in Designing, writing Algorithms and Specifications.
• Proficient in Application Development with Client - Server Architecture environment.
• Excellent Programming and trouble shooting skills and an ability to deliver under pressure.
• Interacted with business technical groups and analyzed business needs.
• Used Agile Methodology for the application development.
• Have a professional attitude and good communication skills, self-motivated and multi-task oriented, with strong work ethic and ability to work effectively.

TECHNICAL SKILLS

Database Systems: Oracle 9i/10g/11g

Operating Systems: Windows, Linux

Languages: SQL, PL/SQL, Java, J2EE, HTML, XML, AJAX and Java Script

Development Tools and Utilities: Visual SlickEdit, PLSQL Developer, SQL Developer, SQL*Plus, Toad, Netbeans IDE, Eclipse IDE, Crystal Reports, DynaTrace, Introscope, Splunk

Version Control Tools: Harvest management System. CVS, PVCS, SVN

PROFESSIONAL EXPERIENCE

Confidential, NC

Senior PL/SQL Developer

Responsibilities:

• Coordinated the release process of this application with different development teams.
• Reviewed the code and defined the coding standards for the quality of the deliverables
• Identified the performance bottlenecks and provide the solutions for the fix
• Monitoring of the DB, App and web servers
• Provide the Application Support in lower environments
• Implemented the Interfaces for downstream/upstream data transfer
• Data load between the environments
• Scheduled DB scripts To gather Schema Statistics, Index rebuild
• Identify and resolve the issues with the ORACLE table fragmentation issues
• Analyzed the Application logs to identify the issues with the application
• Analyzed the Oracle AWR/ADDM reports identify the DB issues.

Technologies: Oracle 11g, JavaScript, CSS, java UNIX shell script, Toad, SQL Developer, Tectia SSH Terminal, BladeLogic, TortoiseSVN, Introscope, DynaTrace, Eclipse Memory Analyzer, Splunk, MetricStream

Confidential, NJ

Senior PL/SQL Developer

Responsibilities:

• Create, modify and execute the rollover scripts for the tax portal applications.
• Enhance and create new functionalities for the Tax portal applications.
• Create and modify the views for the Business Objects Reports.
• Used the SQL*Loader to load the data from flat files
• Analyzed and tuned the existing views and program constructs for the better performance.
• Creating architecture and design documents and providing assistance to the development team on programming.
• Removed unnecessary Dynamic SQL program constructs.
• Analyzed and redesigned the INDEXES
• Analyzed and safe guarded the PL/SQL programing code from the SQL INJECTION
• Involved in the Data modelling for the new application.
• Created TRIGGERS for event logging and impose advance security to the data.
• Used BULK COLLECT and FORALL for bulk fetch operations.
• Using the “Agile” methodology in the development life cycle of the project.

Technologies: Oracle 10g, 11g (SQL&PL/SQL), SQL*Loader, SQL*Plus, Oracle Portal, Toad, SVN.

Confidential, NY

Senior PL/SQL Developer

Responsibilities:

• Involved in full SDLC cycle of PAR.
• Involved in analysis and Design phase of PAR. Participated in signoff of Functional Specification, System Design Documents of PAR.
• Implemented the batch jobs to run daily to transform the data from different databases to the reporting system.
• Created PL/SQL procedures and packages to perform the complex calculations using the Global Temporary tables.
• Created triggers for auditing purpose.
• Created materialized view on remote database and automated scheduler of refreshing of materialized view.
• Extensively work with the collection types VARRAYS, NESTED TABLES and ASSOCIATIVE ARRAYS
• Import of data from SQL Loader to Oracle tables and creation of external tables.
• Created the SHELL scripts to automate the CRON jobs.
• Published the reports in the oracle portal.

Technologies: Oracle 10g, 11g (SQL&PL/SQL), SQL*Loader, SQL*Plus, Oracle Portal, Toad, PVCS (Version Control)

Confidential

Responsibilities:

• Used SQL*Loader to transform the flat file to the Oracle Database Staging Tables
• Implemented the transformation logic in PL/SQL packages.
• Created the User Interface using HTP, HTF and OWA packages
• Send the approvals emails to the selected users using UTL SMTP
• Generated the output files according to the SAP standard.
• Created STORED PROCEDURES and FUNCTIONS for the data transformation process.

Technologies: Oracle 10g, 11g (SQL&PL/SQL), SQL*Loader, SQL*Plus, Oracle Portal, Toad, PVCS (Version Control)

Confidential, Atlanta, GA

Software Engineer

Responsibilities:

• Enabled the system to receive the flat files and transformed the data to the data base.
• Automated the process to run the business flow automatically.
• Done performance tuning for the complex SQL queries and the PL/SQL program constructs using EXPLAIN PLAN and TKPROF utilities.
• Analyzed and redesigned the INDEXES
• Used CACHE mechanism to improve the performance
• Worked with BULK COLLECT program constructs.
• Extensively used HTP, HTF and OWA packages used to dynamically build webpage from PL/SQL.
• Developed stored packages with Oracle's Web Toolkit
• Involved in fixing the bugs runtime.
• Analyzed the PL/SQL code for SQL Injection
• Maintenance of existing crystal web reporting system.
• This included the setup of Stock Report, Return Material Authorization Report and various sales reports.
• Furthermore, the creation and development of miscellaneous crystal reports on demand.
• Worked in Oracle 10g environment.

Technologies: Oracle 10g, 11g (SQL&PL/SQL), Toad, JBOSS, XML, XSL, Centura, Java, J2EE, Rational Rose modeler, Crystal Reports and Harvest management System

Confidential, Atlanta, GA

Software Engineer

Responsibilities:

• Involved in getting the User Requirements, Data Modeling & Development of the system.
• Involved in the creation of class diagrams and state transition diagrams
• Involved in designing the Primary & Foreign Key for the objects in the schema.
• Involved in writing the client side scripts using JavaScript.
• Done the performance tuning tasks using PL/SQL Developer
• Implemented the business logic using PL/SQL collection types.
• Generated dynamic web-reports using java, JavaScript, HTML, DHTML using PL/SQL Web Cartridge with HTP and HTF.
• Worked in Oracle 10g environment.
• Used Agile Methodology for the implementation.
• Has actively participated in unit testing and system integrated testing.
• Involved in creating Documentation for the system
• Created the SHELL scripts to automate the CRON jobs.

Technologies: Oracle 10g, PL/SQL Developer, Centura Builder, Rational Rose modeler, and Harvest management System, Linux, Agile Methodology

Confidential

Software Engineer

Responsibilities:

• Provided the support to the customers.
• Fixed the BUGS in runtime by using the PL/SQL profiling and Tracing.
• Used PL/SQL supplied packages and Dictionary Views to analyze the PL/SQL code.
• Worked with Performance Tuning tasks for SQL and PL/SQL program constructs.
• Done performance tuning for the complex SQL queries and the PL/SQL program constructs using EXPLAIN PLAN and TKPROF utilities.
• Analyzed and redesigned the INDEXES
• Used CACHE mechanism to improve the performance
• Worked with BULK COLLECT program constructs.
• Created the data repair scripts.
• Safeguarded the PL/SQL Code against SQL Injection
• Analyzed the PL/SQL code for the SQL injection.
• Determine the functions and procedures to work with the Invokers privileges.
• Removed unnecessary Dynamic SQL program constructs
• Performed SQL Query tuning using PL/SQL Developer.
• Created TRIGGERS for event logging and impose advance security to the data.
• Worked in Oracle 9i, 10g environment.

Technologies: Oracle 9i, 10g,PL/SQL, JAVA, XML, Toad, SQL Developer, Crystal reports, PL/SQL Developer and Centura Builder.

Confidential

Software Engineer

Responsibilities:

• Done the feasibility study and documented the Customer Requirements
• Modeled the system using Rational Rose and created the Database tables.
• Created Database Triggers, Materialized Views, Stored Procedures, Packages and Dynamic SQL.
• Extensively used HTP, HTF and OWA packages used to dynamically build webpage from PL/SQL.
• Developed stored packages with Oracle's Web Toolkit
• Designed complex CURSOR and CURSOR variables
• Created strong and weak REF CURSORS
• Created subtypes based on existing PL/SQL data types
• Extensively work with the collection types VARRAYS, NESTED TABLES and ASSOCIATIVE ARRAYS
• Involved in the testing.
• Transformed the data to flat files using UTL FILE.
• Scheduled a batch job to automate the database process using DBMS SCHEDULER.
• Worked in Oracle 9i and 10g environment.

Technologies: Oracle (SQL&PL/SQL), XML, XSL, Centura, Java, J2EE, Rational Rose modeler, Report Builder, Report Designer, Crystal Reports and Harvest management System, Oracle 9i, PL/SQL, PVCS, AIX Version 5, TOAD, Ascential DataStage 7.5, SQL* LOADER

Confidential

Trainee Software Developer

Responsibilities:

• PL/SQL parser for providing syntax highlighting
• Indentation engine for formatting support
• Code snippet tool palette
• Code completion

Technologies: Java, XML, Oracle 9i, PL/SQL Developer, Tortoise SVN and NetBeans IDE.