SUMMARY

• Over 7 years of Experience in oracle and PL/SQL Programming, Analysis, Design, Development, Testing, Implementation of business applications using the oracle RDBMS
• Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery with aggressive deadlines.
• Experience with data flow diagrams, data dictionary, database normalization techniques, entity relationship and design techniques
• Expertise in client server application development using Oracle 9i/10g/11g, SQL*Plus, Toad, and SQL*Loader
• Effectively made use of Exception handling, Indexes, Table partitioning, collections, analytical functions, and Materialized views
• Developed packages, functions, procedures, triggers, views, and dynamic SQL using SQL and PL/SQL.
• Created Tables, views, constraints, index (B Tree, Bitmap and Function based)
• Partitioned large table using range partition technique
• Experience in Business Analysis, gathering of business requirements, functional and technical specification writing.
• Experience in using UTL FILE and UTL MAIL packages.
• Experience writing optimized SQL queries, reducing response time, and designing scalable applications from scratch and maintaining existing ones.
• Good knowledge of key Oracle performance - related features, such as Query Optimizer, Execution Plans, Hints, Indexes, and Partitioning.
• Experience in performance tuning of SQL queries
• Expertise in Oracle cursor management, REF cursor and exception handling.
• Experience in creating SQL loader scripts to load data from flat files into the database and also importing data from an excel spreadsheet to the oracle tables.
• Worked in design and deployment of Unix Shell Scripts.
• Performed various types of testing, such as Unit, functional, system, regression and user acceptance testing.
• Proficient experience in creating process flow diagrams using MS Visio and working physical and logical data models using Data Modeling tools like Erwin and Designer 2000.
• Excellent analytical and interpersonal skills, oral and written Communication Skills

TECHNICAL SKILLS

• Oracle 11g/10g/9i
• TOAD
• SQL Developer
• Erwin
• SQL
• PL/SQL
• Oracle forms 6.0
• Oracle Reports 6.0
• Oracle Developer Suite
• C
• C++ c#
• ASP
• Java
• Shell Scripting
• Visual Basic 6.0
• MS Office Suite
• MS Visio
• MS visual studio
• CVS
• SVN
• Quality center 9.2
• QTP 9.2
• Windows 9x/NT/2000/XP
• UNIX
• Putty
• WinSCP

PROFESSIONAL EXPERIENCE

Confidential, NY

PL/SQL developer

Responsibilities:

• Developed stored procedure to insert parsed records into oracle database and validating structure of the input file
• Developed and integrated functions to perform various types of validation checks
• Used UTL file package to read the file from the server and load into oracle tables as well as generate csv files from excel for various label types and write it on the server
• Used Unix shell script to parse the EDI file placed it on server and execute procedure and made some necessary enhancement
• Generated server side PL/SQL scripts for data manipulation and materialized views for remote instances
• Involved in the continuous enhancements and fixing of production problems
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Created FTP package to transfer file to the given IP address of the stores
• Created procedure to insert into error log table and sending notification email using UTL MAIL package
• Extensively used bulk collection in Pl/SQL to improve performance
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Used PL/SQL records and various cursor attributes
• Developed PL/SQL procedures, functions, packages and exception handling blocks
• Created various packages for reporting of the stores promotions and deals.
• Performed mapping between oracle database and SQL server database, and successfully inserted, executed and queried SQL server objects using DBLink.
• Created process flow diagram for various processes using MS Visio.
• Performed Unit testing, end to end testing and debugging of the PLSQL procedures.
• Provided production support and resolved issues and fix defects assigned by the testers in the programs.
• Handled errors using exception handling extensively for the ease of debugging and displaying the error messages in the application
• Made necessary enhancement to the existing process and developed design for the new process.

Environment: Oracle 11g, Windows XP, SQL, PL/SQL, SQL*PLUS, SQL developer, WinSCP, UNIX

Confidential, NJ

PL/SQL developer

Responsibilities:

• Analyze enhancement requests and develop detailed specifications
• Developed Stored Procedures for creating financial reports like size and style report, asset class report, account valuation reports, etc.
• Used SQL*Loader utility to load data files into tables, Export and Import Oracle Utilities to move tables between Schemas for logical backup.
• Developed UNIX shell scripts and generate scripts using SQL*Plus.
• Performance optimization, procedure definition, queries tuning, database design
• Wrote packages, procedures & triggers using PL/SQL to enforce business functionality
• Extensively Used PL/SQL to write cursors and ref cursors for acquiring information to be used in calculations written in stored procedures
• Used PL/SQL bulk collection, cursor for loop, bulk insert using for all and DML (insert/update/delete) methods.
• Created many error logging tables to log errors during exceptions
• Created many PL/SQL exception blocks in procedures to handle runtime exception
• Improved performance of the application by rewriting the SQL queries.
• Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation
• Involved with testers in execution of test cases, logging defects and retesting defects once fixed by the developers
• Created and modified QTP scripts using checkpoints, object repositories, parameterization and recovery scenarios
• Worked closely with testers in performing GUI, Functional, System, Regression and cross browser compatibility testing
• Executed many SQL queries to perform database testing
• Understood and articulated business requirements from user interviews and then convert requirements into technical specifications
• Identified new processes, found out gaps in existing process, and arranged training for new process development and implementation

Environment: Oracle 10g, SQL, PL/SQL, SQL developer, Microsoft Visio, Windows XP, Microsoft Visio 4.0, UNIX, quality center 9.2, QTP 9.2, Erwin 4.1.4

Confidential, NY

PL/SQL developer

Responsibilities:

• Created stored procedures, functions, packages for scholarship search based on different inputs
• Used advanced features of PL/SQL like collections, Bulk Collect, triggers, object types to implement complex business functionality.
• Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Use of PL/SQL bulk collection and DML (insert/update/delete) methods.
• Encapsulated error handling and use of autonomous transaction for logging.
• Used UTL FILE for exporting data and UTL MAIL to generate E-mails.
• Extensively used PL/SQL features like collections and Bulk collect for high performance of stored procedures
• Assisted with testing existing code and making necessary enhancements to the existing process
• Created database objects such as tables, indexes, views, materialized views, triggers, sequences, synonyms, etc.
• Extensively worked on writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries).
• Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.
• Suggested and implemented improvements to legacy systems.
• Developed multiple reports for IT needs to identify and improve performance.
• Involved in RDBMS design and developed ER-diagrams using Erwin.
• Participated in code walkthroughs and review sessions with the development team.
• Effectively documented and archived historical data for future auditing purposes.

Environment: Oracle 11g, Windows XP, SQL, PL/SQL, SQL*PLUS, SQL developer, TK prof, SQL*Loader, XML, Erwin, Quality center

Confidential, NY

Jr. Oracle developer

Responsibilities:

• Understanding the Business process/requirement by interacting with business users for successful deployment
• Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes
• Developed SQL Queries to fetch data from different tables using complex joins
• Created PL/SQL Packages, Procedures and Functions for implementing the business processes
• Designed and developed oracle forms and reports and performed modifications on existing form as per change request and maintained it
• Worked with DBA in creating index for faster retrieval of data and Analyzed Tables for Performance tuning
• Developed Static & Dynamic (REF) Cursors, Records & Exception handlers
• Worked with large tables and created partitions for managing the large tables
• Created audit table to record the Updates and Inserts on the tables by creating database triggers
• Involved in design and development of end user screens and reports
• Involved in loading data using Oracle SQL*Loader into the staging tables
• Participation in weekly design reviews and walkthroughs with project manager and development team
• Interacted with the Front End Team to in corporate the required functionality for their screens and processes

Environment: Windows XP, UNIX, Oracle 10g, SQL*plus, SQL developer, Forms 9i, Reports 9i, SQL, PL/SQL

Confidential

Jr. Software engineer

Responsibilities:

• Developed oracle stored procedures, and complex SQL queries for oracle forms.
• Used SQL* Loader as an ETL tool to load data into the staging tables
• Used JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in various API’s like Java, .Net and hierarchical databases like oracle and Access.
• Worked in production support environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes etc
• Worked in defining Testing methodologies, Designing Test plans and Test cases, verifying and validating applications and documentation based on standards for software development and effective QA implementation in all phases of software development life Cycle(SDLC)
• Created and executed manual test cases using HP Quality Center
• Involved in performing GUI, Functional, System and Regression Testing
• Participated in system walkthrough and inspection meetings to understand the business rules and system operation flows
• Identified and documented defects using HP quality center to ensure applications functionality
• Assisted client implement User Acceptance Test(UAT) including creating test plan, generating test data, designing test cases, preparing test environment and executing test
• Wrote SQL queries to test the application for data integrity and verified the contents of the database tables
• Performed the back end integration testing to ensure data consistency on front end by writing and executing SQL queries on the oracle database using Toad

Environment: Windows XP, Oracle 10g, Toad for analyst, SQL, HP Quality center