SUMMARY

• Over 7 years of extensive experience in all phases of software development life cycle (SDLC) that includes Requirement Analysis, Design, Development, Integration, Documentation, Testing, Deployment, Maintenance.
• Extensive knowledge and work experience in System Analysis, design and development of database applications in Client/Server environment using Oracle 11g/10g/9i/8i, SQL, PL/SQL,SQL*Loader.
• Proficient in developing concurrent programs using SQL, PL/SQL and UNIX Shell Scripting.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views Triggers, Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections.
• Good understanding of oracle Data Dictionary, RDBMS and Normalization Techniques.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN, DBMS PROFILER and hints.
• Expertise in performing Data export, Import and various operations using TOAD.
• Experience in advanced PL/SQL concepts likeBulk collect, For All, REF Cursors, Varrays and Native Dynamic SQL.
• Experience in Query Optimization, Debugging, and Tuning and Improvising performance of the applications.
• Experience in working with Sequence and Indexes.
• Extensive experience in data migration techniques using Oracle External Tables, Import/Export, bulk and batch processing.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data Warehouse Environment.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Implemented Autonomous transaction and Distributed transaction processing in PL/SQL.
• Moved columns of data into and out of database tables using PL/SQL program units by passing collections as parameters to program units.
• Knowledge of packages like DBMS SCHEDULER, DBMS JOB, DBMS STATS, and UTL FILE packages.
• Hands-on experience with Oracle Reports, Open Interfaces, and APIs.
• Involved in developing Forms and Reports using Oracle9i, 10g.
• Good Understanding of GUI using JavaScript, HTML, XML.
• Involved in preparing Integration test, Database Test for TOAD.
• Experience using scheduling tools like Control M, Crontab.
• Experience in Unit and Integration Testing.
• Knowledge of DB2 Database.
• Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, User Acceptance Test (UAT), Quality Assurance.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.
• 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.

TECHNICAL SKILLS

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

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

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

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

Utilities: TOAD, SQL*Loader

Development tools: SQL*Plus, Work-flow, SQL Navigator, SQL Developer, Forms & Reports Builder 6i, 9i/10g.

Methodologies: Agile, Waterfall, SDLC

PROFESSIONAL EXPERIENCE

Confidential, 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.
• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
• Participated in system analysis and data modeling, which included creating Tables, Views, Materialized Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc. in Staging and Destination schemas.
• Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATMENT.
• Used direct path loading via SQL*Loader to load flat files into database tables.
• Worked extensively with advanced features of PL/SQL like records and table types.
• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS.
• Developed Database Triggers for audit and validation purpose. Writing validation packages using PL/SQL package.
• Developed dynamic SQL used in procedures and function for the data extraction and loading process.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Imported the data from flat file and written SQL Loader scripts to load the flat file data into External table for data profiling.
• Worked on Unix shell scripts involving Control M, Crontab jobs.
• Create various user defined exceptions to control the process based on the business requirement.
• Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, USER etc.
• Used Toad for creating PL/SQL program units like trigger, sequence, stored procedure.
• Used UTI FILE Packages for writing DBMS OUTPUT messages to file.
• Collected all impacted modules from all developers and prepare the deployment script for production release.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid and invalid data into error tables.
• Developed PL/SQL API’s to provide the linking information in the form of XML’s.
• 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.
• Involved in scrum meetings, Business requirements meetings.
• Updated status of the development on daily basis

Environment: Oracle 11g/10g, SQL, PL/SQL, Pro*C, SQL*Loader, MS Access, Windows UNIX Shell script, TOAD, Control M, XML.

Confidential, AZ

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
• Worked with the data conversions by application screens.
• Worked for designing Logical and Physical data models for Master Data and Transactional Data.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Extensively used Oracle Collections Nested Tables, Associative Arrays and Objects to improve the performance of Procedures and Packages.
• Worked with ETL team and architect to build data model for staging area.
• 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.
• Worked in PL/SQL tuning and query optimization tools like Explain Plan, and DBMS PROFILER.
• Developed reports using complex queries as per client request as a part of production support.
• Created standalone procedures using Dynamic SQL and cursors to migrate data within the same database.
• Perform technical activities and command line on UNIX, Windows and SQL.
• Performed SQL tuning using Explain Plan, Hints and indexes.
• 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.
• Used reports to display formatted data. Reports can be viewed in the database where they were created or printed. Saved reports as snapshot files so they can be viewed outside an Access application.

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

Confidential, Atlanta, GA

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Created data mapping files for the data coming from different web services.
• Knowledge and experience in structured systems analysis and design techniques.
• Extensively used stored procedures to apply validation logic for the data in staging area to load into catalog Database.
• Improved the performance of the SQL queries by utilizing best optimization techniques.
• Used Explain Plan, HINTS for performance tuning of SQL, PL/SQL queries.
• Used DBMS SCHEDULER to automate the regular tasks and improve time-constrained performance.
• 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.
• Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.
• 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, SQL Developer.

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.

Confidential

Software Engineer

Responsibilities:

• 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.
• Writing logics for different types of reports, Batches, Import and Export functionalities.
• Development for enhancements using technologies like PL/SQL, UNIX. Configuration Management of all the files and Process Documentation.
• 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.

Environment: Oracle 9i, SQL, PL/SQL and Windows 2000 server