PROFESSIONAL SUMMARY:

• More than 8+ years of programming experience as an Oracle PL/SQL Developer in all phases of Software Development Life Cycle (SDLC) including Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS).
• More than 7 years’ experience in developing two - tier and three-tier applications and distributed architecture applications using Software Development Life Cycle(SDLC)
• Highly competent in gathering user requirements and converting those into software requirement specifications.
• Expertise in creating relational database development, for creating complex database queries, writing Constraints, Indexes, Views, Packages, Stored Procedures, Cursors and Functions using PL/SQL in Oracle databases (8i, 9i, 10g, and 11g).
• Experience in using Oracle supplied packages such as DBMS SQL,DBMS JOB, and UTL FILE to read and write into files.
• Implemented PL/SQL advanced topics like Bulk Collects, Bulk Inserts Ref Cursors, Collections, Dynamic SQL, Autonomous transactions, Table Partitioning and External tables.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export
• Experience on UNIX shell scripting.
• Experience in Oracle reports developer (Oracle developer suite 10g/AS).
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.
• Skillful in working with the tools like SQL * PLUS,TOAD
• Good experience in data modeling using Erwin Data Modeler: Creating entities, relationships, sub-types, schemas and ERD to database schemas.
• Good experience in Software Engineering Processes (Agile and Waterfall Methodologies). Development of software project based on users’ requirements and meeting deadlines to satisfy users' needs.
• Expertise in designing and developing applications using J2EE technologies including JSP, core java, AJAX, Java Script, CSS, Hibernate, JDBC, JQuery, Oracle, MySQL.
• Hands on experience in project management tools like VSS, ASANA, Microsoft project
• Strong Technical & Analytical Skills, willing to share, investigate, learn, work hard, and thinks from a user perspective and to work in cutting edge technology with strong relationships with colleagues, clients and vendors in functional and technical areas, proactive and open-minded.
• Managerial Activities: Project planning and scheduling, Project Management and Task Allocation to Team, Project team meeting & Performance reviews, Effort Estimation, Performing & establishing Quality Management process for Project, Client coordination for the project including status meeting, Manage Knowledge Transfer Process and induction plans, Knowledge Management and best practices, Reviewing deliverables for ensuring quality and trace ability, Team Building
• QA Activities: Preparation of Test plan, Preparation of Test cases, Functional testing, System Testing, Black box testing, White box testing, Integration Testing, Production testing.

TECHNICAL SKILLS:

Operating Systems: WINDOWS98/NT/2000/XP, Solaris 5.8, UNIX, Linux

Languages: C,C++, java, core ABAP, COBOL, VB 6.0, VC++, SQL, PL/SQL. Proc *C, unix shell scripting

Scripting Languages: Shell, Perl, Java Script

Web Technologies: PHP,JavaScripts,HTML5, XML

RDBMS Database: Oracle 11g/10g/9i/8i, SQL Server, MS-Access

Application/Web Servers: Oracle Application Server 10g

BI Tools: Discoverer 10G/11g, Oracle Reports 6i/9i/10g

Other Tools: TOAD, SQL developer, SQL Navigator, Oracle Enterprise Manager, SQL*Plus, SQL* Loader, Clear Case, putty, SVN, Erwin.

Project Management Tools: VSS,Asana, Microsoft project

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken, New Jersey

Sr.Oracle PL/SQL Developer/Tester

Responsibilities:

• Involved in SDLC which included requirements gathering, analysis, design, and development and in application design and designed Use case diagrams, Class diagrams, and Sequence diagrams using UML.
• Responsible for creating Proof of Concepts for the initial proposals and developed prototype for the user interface to kick start the project
• Designed and proposed of underlying architecture with the leads and architect, involved in developing the base code for the application.
• Worked in developing database table design, ERD and creating the DDL scripts for the new oracle database.
• Extensively involved in creating Tables, Views, Indexes, Stored Procedures, User Defined Functions and Triggers, Cursors, SQL/PL-SQL, Code optimization and performance tuning. Responsible for client side validation and server side validation for the modules.
• Worked with DBA team to assign grants and roles on database objects.
• Attended meetings and review to discuss current issues and processes to tackle critical issues.
• Experience with FTP to put and get the files.
• Used Clear case for each release of project.
• Responsible for Tuning of application with the help of Other Team Members & Oracle Support.
• Utilized tools like TOAD during development of the application.
• Developed Stored Procedures, Functions, SQL statements and Packages for the processing of sum of defect points on a track using TOAD.
• Used joins, indexes effectively in where clauses for Query optimization.
• Developed stored procedures to implement loader integration.
• Developed User Interfaces using JSP, HTML, spring, and Ajax
• Developed in a fully scalable Web application using Java, Spring, Hibernate, Junit and Oracle PL/SQL.

Environment: Oracle 11g, Oracle 10g/9i, SQL, PL/SQL, SQL*PLUS, TOAD

Confidential, Milwaukee, WI

Sr. Oracle PL/SQL Developer & Tester

Responsibilities:

• Designed and proposed of underlying architecture with the leads and architect, involved in developing the base code for the application.
• Extensively involved in creating Tables, Views, Indexes, Stored Procedures, User Defined Functions and Triggers, Cursors, SQL/PL-SQL, Code optimization and performance tuning. Responsible for client side validation and server side validation for the modules.
• Created new Tables, Indexes, Synonyms and Sequences needed per data conversions.
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables in Oracle database using UNIX shell scripts.
• Developed procedures, functions and packages to load the data from staging tables to product base tables.
• Developed various reports by using PL/SQL and Reports 10g.
• Debugged existing code for business logic issues.
• Used Version Control tools like SVN
• Coordinated with the development team to compile, run, test and install the developed code onto the testing as well as production environments. Responsible for performing code reviews
• Involved in round the clock production support by interacting with the users and their environment in order to help debug production issues.
• Documentation of all modules for user level and system level maintenance.
• Involved in debugging and tuning the SQL code, queries and optimization for the Oracle database.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored procedures, functions and packages.
• Worked with the project DBA in assigning tablespaces, grants and roles.
• Involved in DDL creation, data profiling and data architecture and data centric development.
• Worked in developing database table design, ERD and creating the DDL scripts for the new oracle database.
• Worked on Oracle database to design Database schema, created Database structure, Tables and Relationship diagrams.
• Responsible for writing SQL Queries, Trigger and function to manipulate database objects.
• Acted as a single point contact for the Database related activities like developing/ creating tables, procedures and functions for the java developers.
• Involved in designing of the application using UML (Unified Modeling Language).
• Maintained the code base using Microsoft VSS and acted as a librarian to integrated and check in all the peers code to the repository.

Environment: Oracle 10g, Oracle SQL Developer, SQL*Loader,Reports 10g,Discoverer 10g, JavaScript, UNIX Shell Scripting, HTML, Putty

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in creation of Low Level Design including sequence diagrams and class diagrams to understand the existing architecture.
• Understanding of the Functional specifications, based on that prepared design documents.
• Developing highly complex applications using Oracle 10g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures. Superior skills in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL
• Using concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables
• Analyzing business requirements, preparation of source-target mapping documents, conduct unit testing and code walkthroughs to ensure there are no missing elements, and perform integration testing
• Handling code defects, enhancements and release management using tools like Rational Clear case and Rational Clear quest
• Performing the performance tuning for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized v$ scripts to monitor the database processes and performance
• Using existing processes and procedures for application deployment and provided 24x7 production support as Primary
• Creating shell scripting for generating reports for clients
• Tuning of Queries, Packages using Oracle utilities Explain Plan, DBMS Prof.
• Developing procedures using native dynamic SQL (EXECUTE IMMEDIATE), dynamic SQL, Ref cursors.
• Developed the different components of application such as JSPs, Servlets and used VSS for version control.

Environment:: Oracle 10g, Clear case, Clear quest, Toad 9.5, PLSQL Developer 7, Java, HTML

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in requirements, design, and development and testing phases of project.
• Developed PL/SQL Stored Procedures, Functions and Packages, Triggers for searching all types of book in advance search model.
• Involved in development of Unix Shell scripts to call procedures and functions maintained logs where executed properly or not, copy the only selected fields into other text files.
• Extensively involved in tuning of Oracle databases, using Oracle utilities Explain Plan, DBMS Profiler.
• Used Views, Materialized Views, Cursors, REF Cursors, Partitioning, Exception handling, Bulking Techniques
• Extensively involved in loading the data from different files using SQL LOADER utility, Creation of different control files and used fillers in those files for selective loading.
• Restructured packages, procedures to improve performance.
• Involved in improving the performance of loading and manipulations using Bulk Binds, Creation of different types of indexes.
• Involved in developing procedures using native dynamic SQL (EXECUTE IMMEDIATE), dynamic SQL, Ref cursors.
• Involved in Logical and physical data modeling.
• Involved in developing JDBC Connections to connect to database and fetch the data.
• Involved in development of KornShell Scripts including file manipulation, calling procedures and functions, using SQL LOADER utilities, awk, sed etc.
• Experienced in batch job scheduling.
• Experience with FTP to put and get the files.
• Used Clearcase for each release of project.
• Involved in another project Using transform data to another DB.
• Extensively worked on Toad during development for connecting to different servers.
• Involved in Unit Testing, System Testing, System Integration Testing.
• Used Test Director to keep track of the Test Cases.
• Involved in Promotion of code to UAT, PRODUTION.
• Analysis of client requirement in the initial development phase and provide the best solution for any requirement.

Environment: Oracle 10g/9i, SQL and PL/SQL, Proc *C, UNIX, PERL, Toad

Confidential

Jr. Oracle Developer

Responsibilities:

• Involved in the design, coding, deployment and maintenance of the project.
• Acted as a single point contact for the Database related activities like developing/ creating tables, procedures and functions for the java developers. Involved in designing of the application using UML (Unified Modeling Language).
• Written PLSQL procedures to extract the daily promoted and demoted Employees from the HR database.
• Developed various reports by using SQL.
• Loading of data (Data Migration) from legacy system to custom tables using SQL LOADER.
• Supporting on-call in out of office hours.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Used advanced Bulk technologies (FOR ALL, BULK COLLECT) to improve performance. Developed installation scripts for all the deliverables. Performed functional testing for different Oracle Forms application functionalities.
• Performed unit testing, system testing and integration testing.
• Worked on Oracle database to design Database schema, created Database structure, Tables and Relationship diagrams.

Environment: Oracle 11g, SQL, PL/SQL, Proc *C, Java Script, UNIX