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.

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.

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.

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.

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.

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.

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.

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.

Environment: 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