SUMMARY

• Over8years of extensive experience in all phases of software development life cycle (SDLC) that includes Requirement Analysis, Design, Development, Integration, Documentation, Testing, Deployment, Code Management, Maintenance, Enhancements in Enterprise Application Integrations.
• Proficient in PL/SQL programming - Stored Procedures, Functions and Packages, SQL performance tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers,Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections.
• Extensive knowledge and work experience in System Analysis, design and development of database applications in Client/Server applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL, SQL*Loader.
• Expertise in leading a team of 5 resources. Proficient in developing concurrent programs using SQL, PL/SQL and UNIX Shell Scripting.
• Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, User Acceptance Testing (UAT), Quality Assurance,Code Review.
• Designed database schemas using Entity relationship modeling with ER diagrams& database normalization principles.
• Good understanding of oracle Data Dictionary, RDBMS and Normalization Techniques.
• Functional knowledge in individual and group General Ledger, Account Receivables, Banking andTelecom domain.
• Experience working with Production and Development environment.
• Experienced in Query Optimization, Debugging, and PerformanceTuning of the applications.
• Experience in working with Sequence and Indexes.
• Proficient in working with Hints and Table Partitioning.
• Solid experience in writing and debugging stable and robust PL/SQL code, handling various kinds of Exceptions, SQL, Dynamic SQL, C, and UNIX shell scripts.
• Supported Advance PL/SQL using Cursors, REF Cursors, and Native Dynamic SQL.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Implemented Autonomous transaction and Distributed transaction processing in PL/SQL; Non-Distributed transactions, Distributed transactions, Remote transactions.
• Moved columns of data into and out of database tables using PL/SQL program units by passing collections as parameters to program units.
• Used Cursor Variables (Ref Cursors) to pass query results sets between PL/SQL programs and client application.
• Hands-on experience with Oracle Reports, Open Interfaces, and APIs.
• Hands-on experience on APEX tool.
• Good Understanding of GUI using JavaScript, HTML.
• Thorough knowledge in software processes and involved in all phases of development life cycle.
• Involved in developing Forms and Reports using Oracle9i, 10g (ORACLE 10g AS).
• Involved in preparing Integration test, Database Test for TOAD.
• Experience in Unit and Integration Testing.
• Experience in UNIX, and Shell Scripting.
• Knowledge of DB2 Database
• Ability, willingness, and passion to learn new technologies and acclimatize to diverse work cultures.
• Solid managerial and administrative skills with good business understanding and excellent versatility and adaptability to manage multiple tasks.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills and a Very Good Team Player.

TECHNICAL SKILLS

Operating System: Windows XP/ NT/95/98/2000, UNIX, Windows7.

Languages: SQL, PL/SQL, UNIX Shell Script, JavaScript, HTML,C,C++, Java, XML Schema, XML

RDBMS: Oracle 11g, 10g, 9i, 8i, SQL server 2000/2005/2008.

GUI: Oracle Pl/SQL Developer Suite, Reports 9/10

Data base toolsDevelopment tools: TOAD, SQL*Plus, SQL*Loader, Work-flow, SQL Navigator, SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements, creating detailed Documentation HLD and TDD which includes all Business requirements and technical specifications.
• Developed stored procedures, functions and packages to facilitate consistent data entry into the database.
• Participated in system analysis and data modeling, which included creating Tables, Views, Materialized Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
• Expertise in working with Records, Collections and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS.
• Involved in SQL query Performance tuning.
• Experience in using various oracle PL/SQL collections VARRAYS, NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2
• Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, USER etc.
• Create various user defined EXCEPTIONS to control the process based on the business requirement.
• Involved in generating numbers for PRIMARY KEY VALUES using Oracle SEQUENCE objects.
• Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATMENT.
• Extensive experience in design, development, and enhancement and managing applications oracle PLSQL.
• Designed and developed scripts for Packages, Procedures, Functions and other objects to deploy to different database schemas and environments.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Expertise in working with APEX tool to provide business functionalities.
• Involved in integration of the data with SOA, OFS and JAVA team according to the business specifications.
• Testing the system integration closely with SOA, OFS and JAVA team and resolve the issues as per the business rules.
• Expertise in import and export MS Excel data to Pl/Sql Objects.
• Expertise in MS Excel functionalities.
• Expertise in writing Check SQL’s and transactional quires to run in production to monitor data integrity
• Created ER diagrams for the database objects for different projects and maintained them.
• Worked on CVSto monitor the PLSQL code changes,CVS versions also used for deployment process.
• Worked in all deployment processes to SIT, QA and Production Environments. Handled various errors thrown throughout the integration process and coordinated with the team.
• Worked in agile environmentwith more than 10 people as a team (Which includes SOA, OFS team members).
• Strong Knowledge on ETL process.
• Involved in scrum meetings, Business requirements meetings.
• Updated status of the development on daily basis.

Environment:Oracle 11g, SQL, PL/SQL, Toad, Oracle RDBMS, SQL Developer, CVS, QC.

Confidential, Frederick, MD

Oracle Pl/SQL Developer

Responsibilities:

• Involved in creating detailed Documentation HLD and LLD which includes all Business requirements and technical specifications.
• Leading team of 5 resources.
• Created data mapping files for the data coming from different web services.
• Knowledge and experience in structured systems analysis and design techniques.
• Developed database objects including Tables, Clusters, Indexes, Views, Sequences, Packages, Triggers and Procedures to troubleshoot any database problems.
• Extensively used stored procedures to apply validation logic for the data in staging area to load into catalog Database.
• Used Explain Plan, HINTS for performance tuning of SQL, PL/SQL queries.
• Worked with ETL team and architect to build data model for staging area.
• Worked with business experts to understand the source data in web service systems.
• Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.
• Importing and exporting the data into multiple environments.
• Supported for code integration and system integration testing for this application.
• Worked with Java and J2ee development team and worked for Hibernate mapping and Provided SQL Queries.
• Developed different UNIX scripts for the output of the commands.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.

Environment: Oracle 10g, Oracle Reports 10g, SQL, PL/SQL, Toad, Oracle RDBMS, Erwin, SQLDeveloper.

Confidential, Bloomington IL

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
• Created data mapping files for the data coming from different web services.
• Worked for designing Logical and Physical data models for Master Data and Transactional Data.
• knowledge and experience in structured systems analysis and design techniques
• Developed database objects including Tables, Clusters, Indexes, Views, Sequences, Packages, Triggers and Procedures to troubleshoot any database problems.
• Worked with ETL team and architect to build data model for staging area.
• Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.
• Importing and exporting the data into multiple environments.
• Supported for code integration and system integration testing for this application.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support
• Performed SQL Performance tuning using Explain Plan, Hints and indexes
• Involved in handling the batch jobs using UNIX shell scripting.
• Responsible for performing code reviews.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Utilized SQL*Loader to load flat files into database tables.

Environment: Oracle 11g/10g,SQL Server Reports 2008, SQL, PL/SQL, Toad, Oracle RDBMS,SQL.

Confidential, MI

Oracle Pl/SQL Developer

Responsibilities:

• Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Worked on various backend Procedures and Functions using PL/SQL.
• Developed the forms and Reports as per the requirements.
• Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.
• Involved in Shell scripts to automate the loading, balancing and extraction process
• Check the functionality of data in the front-end whether it is displaying properly or not.
• Managing Version Control Tool like Clear Case and Start Team.

Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, TOAD, Java, HTML, MS Office