SUMMARY

• Around 7+ years of total experience as an Oracle PL/SQL developer with design, development, and testing of business applications such as OLTP, OLAP, Enterprise, web based, Client/Server architectures.
• Worked extensively on various technologies like Oracle 8i/9i, 10g/11g, PL/SQL, C/C++.
• Expert in writing SQL, PL/SQL modules like functions, stored procedures, cursors (Implicit, Explicit, REF), packages, triggers, indexes, collections(Nested tables and Varrays) and materialized views.
• Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL Developer.
• Expert in Oracle Import/Export utilities, Oracle SQL* Loader, SQL Navigator, SQL Developer, SQL*Plus, TOAD, PL/SQL Developer, ETL Process and Data Migration.
• Worked on export/import commands to move the structure and the data from development to production.
• Implemented the Usage of System Change Number (SCN) in order for getting the Flashback Database
• Having Good experience working with large kind of databases up to 10 terabytes of data.
• Extensive experience in performance monitoring and tuning in Oracle/MS SQL Server. Expertise in creating stored procedures, functions packages, collections and bulk collections using PL/SQL. Worked on Oracle 10g Enterprise manager and Configured Listener and Network configuration.
• Experience in optimization of SQL statements using SQL Trace, TKPROF and Explain Plan.
• Experience in performance Tuning using various types of Hints, Partitioning and Indexes.
• Good knowledge of the RDBMS concepts advanced Oracle queuing and Oracle Workflow.
• Deep understanding of Software Development Cycle (SDLC) and implemented various models like Spiral, Agile (XP, SCRUM) and Iterative models.
• Interacted with Clients, Project Managers to gather the Business Requirements and developed the technical specification document.
• Having Good knowledge of UNIX, and Shell Scripting.
• Strong understanding of Data Warehousing (Including Star Schema, Snowflake Schema) and Extraction Transformation Loading (ETL).
• Assisted DBA in performing various DDL works like Creation of Schemas, tables, Indexes, Materialized Views, and Partitioning tables.
• Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions.
• Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents.
• Knowledge in Oracle Golden Gate 12c about real time data feeds and transactional integrity.

TECHNICAL SKILLS

Databases: Oracle 8,8i, 9i, 10g, 11g, SQL Server 2000/2005, MySQL, T - SQL, Microsoft Access

Oracle Software: TOAD, SQL *PLUS, SQL Navigator, Teradata SQL Assistant Reports & Forms developer suite, TKPROF, EXPLAIN PLANSQL*Loader, SQL Developer

Software’s: MS Visio, MS Project, MS Office, Infomatica, DataStage

Scripting: HTML, XML, XSLT, DOS, Korn & Bourne Shell ScriptingOperating System Windows NT/2000/2003/XP/VISTA, Linux, UNIX.

Programming Languages: C, C++, VB, PL/SQL and SQL.

Version Control Tools: CVS, Clear Quest, Clear Case, Subversion (SVN)

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in development of ETL Jobs using SQL Developer for data migration between different maintenance systems.
• Extensively involved in ETL code using SQLin order to meet requirements for Extract, transformation, cleansing, and loading of data from source to target data structures.
• Enhance the old Logical Query Design to fit new business requirement, and implemented new design into SQL Server 2008 and Oracle SQL Developer.
• As an XSLT web developer designed and developed the websites with the java and XSLT.
• Provided support and help on management of the data and XSLT programming.
• Troubleshoot the problems and fixed the bugs in XSLT and java related programs.
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Creation of database objects like tables, views and procedures using oracle tools like SQL Developer.
• Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Created Batch files using DOS scripting language for automation process.
• Involved in the continuous enhancements and fixing of production problems.
• Tuned SQLstatements using Explain Plan, SQL Trace to improve the performance by using Oracle 11g.
• Extensively used Global Temporary Tables to load the required data set to increase the performance.
• Preparing UTP (Unit Test Plans) as per the RS (Requirement Specification), FS (Functional Specification) provided by the Business Analysts.
• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
• Tuning T-SQL queries to improve performance.
• Extensively worked with BA team to fix the defects that are logged.
• Involved in the continuous enhancements and fixing of problems.
• Performed ETL tasks like Extract Transform and Load Process when loading data into tables using Datastage.
• Involved in developing Microsoft Access applications for front end applications.

Environment: Oracle 11g, SQL Developer, XSLT, informatica, MS SQL Server 2008, T-SQL, Microsoft Access, DOS scripting, CVS.

Confidential, Dallas, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Drilled deep into the existing data model, understood the business requirements, data relationship and data flows to gain insight of the business model and suggest better ways to implement newer functionality.
• Involved with architects and business analysts to understand business requirement to reflect them into data model and involved with project development teams to convert the model into technical specifications and also provide knowledge to quality assurance analysts regarding the model.
• Interacting with QA teams to review and develop data standards, data exchange, XML data standard, and data sharing model.
• Developed data standards, data exchange, XML data standard or data sharing model.
• Provided technical XML consulting services to the management and support staff.
• Handled the queries regarding XML and troubleshoot problems.
• Writing scripts using XML language.
• Performed normalization of the OLTP database to eliminate redundant data.
• Developed PL/SQL Procedures, Functions, Cursors, and Packages using SQL Developer, TOAD and Oracle 11g.
• Developed PL/SQL Views and Materialized Views with fast and incremental Refresh Rates using Oracle TOAD.
• Worked on PL/SQL Implicit, Explicit, REF Cursors and created Triggers for tables using SQL Developer.
• Performed DBA activities such as creation of roles, granting privileges to the role, creating database link to connect to users under different instance.
• Created dynamic sql queries using Execute Immediate statements.
• Extensively used SQL Loader and import/export toolbar to load the data from excel files into oracle.
• Extensively used REF cursors to pass out the required data set to the front end team working on JAVA
• Extensively worked on cursors, SQL joins (inner join, outer join, anti-join), views, packages, procedures, functions.
• Worked with Collections to reduce overhead involved with cursor looping. Bulk fetched the data from sql engine into collection. Handled exceptions using SAVE EXCEPTIONS and %bulk exception.
• Extensively used Global Temporary Tables to load the required data set to increase the performance.
• Extensively used materialized views, pragma autonomous transactions, object types, table functions, and pipelined functions to implement business logic effectively.
• Involved in several discussions with the client team to discuss the modification and deliver updates of the project.
• Expertise in debugging the code and creating the exceptions to handle bad data and send them to error log files.
• Error handling using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Resolved Priority Production Support Issues and Defect Fixes in PL/SQL code.
• Implemented the Usage of System Change Number (SCN) in order for getting the Flashback Database.
• Unit testing the PL/SQL code. Made necessary database structure changes for OLTP as per business requirements.
• Created batch files for automation of SQL script files and scheduled those using windows scheduler.
• Automated executing script files through UNIX using Autosys. Worked on basic UNIX commands for FTP data from one location to another.

Environment: Oracle 11g, XML, Oracle Forms 10g, SQL, PL/SQL, SQL Developer 3.0.03, UNIX, TOAD, Shell scripting (Bourne and Korn), Perl. SubVersion(SVN).

Confidential, Irving, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Executed tasks on XML registry, XSLT/XQuery and transformation capabilities.
• Analyze and evaluate constraints in mapping data, XML, and object models.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Created domain XML schema for use of integration, services and messaging.
• Use XQuery/XPath and/or other tools to manipulate data into required form
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Wrote numerous Backend Database Triggers for Complex Business integrity.
• Wrote backend Packages, Procedures Functions and Triggers and bulk collections.
• Extensive use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Configured the mappings to handle the updates to preserve the existing records using Router and Update Strategy Transformation, per business logic.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE, and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures. Created some oracle objects for OLAP.
• Developed Perl scripts for extracting and transferring data from external systems.

ENVIRONMENT: Oracle 10g, Oracle Forms 10g, PL/SQL, TOAD, SQL Developer, Shell scripting (Bourne and Korn), Perl, SQL*loader, Stored Procedures/Triggers, XML, XSLT/XQuery, Windows NT.

Confidential, Houston, TX

Oracle PL/SQL Developer

Responsibilities:

• Participated in analysis, design, development, and testing of the application.
• Developed PL/SQL batch processing jobs using UNIX Shell scripting.
• Participated in writing PL/SQL, stored procedures/packages, triggers, bulk collections, constraints, cursors (Implicit, Explicit, REF), views and indexes using SQL Developer and TOAD.
• Created Informatica mappings for loading the data from flat files and 3rd party Data providers into Staging
• Worked extensively on tuning of mappings/sessions using session partitioning and lookup strategies to address bottlenecks.
• Performed multi-source Extraction Transformation and loading (ETL) into the Repository using Informatica.
• Worked on Data Backup and Data Recovery using RMAN.
• Hands on experience in using database designing tools like ERwin and PowerBuilder.
• Strong knowledge in using views, Materialized views, Export and Import Utilities provided in Oracle TOAD.
• Experience in Dynamic SQL, Records, Arrays and Exception Handling.
• Experienced in using Oracle Utility programs like SQL*Loader, SQL Developer and External Tables.
• Extensively participated in performance tuning for various oracle based application using various methods like SQL Trace, EXPLAIN PLAN, TKPROF etc.

Environment: Oracle 9i/10g, Oracle Reports & Forms 6i/9i/10g, PL/SQL, ERWIN, MS Access, MS Excel, C++, Informatica, SQL*Loader, CVS, TOAD, Dynamic SQL, Eclipse, EXPLAIN PLAN, TKPROF, MS Visio, UNIX.

Confidential

Oracle Developer Intern

Responsibilities:

• Created various PL/SQL Scripts involving Insert, Sequences, Constraint and Index scripts.
• Created and Modified PL/SQL Triggers, Procedures, Functions, packages and bulk collections using PL/SQL.
• Performed data loading/ unloading from both CSV and flat files with the help of Utilities provided in and TOAD.
• Participated in importing and migrating Source/Target Tables from the Oracle databases and created reusable components to optimize the process.
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus.
• Participated in migration of the databases from Oracle 8i to Oracle 9i. Exported reports into formats such as PDF, Excel, and CSV.
• PL/SQL Programming participated in designing and developing various complex Stored procedures, Functions, materialized views, cursors (Implicit, Explicit, REF), Packages using TOAD and Oracle developer suite.
• Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Worked efficiently with Informatica client tools and several transformations including Source Qualifier, Lookup, Aggregator, Expression, Filter, and Update Strategy.
• Developed SQL*Loader scripts to load data in the custom tables. Extensive use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• Implemented the Referential Integrity constraints through different Check Constraints and Triggers.
• Implemented security by creating different Users and assigning Roles to Users.
• Performed ETL tasks like Extract Transform and Load Process when loading data into tables using Datastage.
• Performed Integration, Functional and Unit Testing on code.
• Participated in improving the performance of the Queries using TKPROF and EXPLAIN PLAN.

Environment: Oracle 9i/10g, Oracle Reports & Forms 9i/10g, PL/SQL, MS Access, MS Excel, Perl, SQL *Loader, MS Visual Studio 2005, Oracle APEX (Application Express), JavaScript, HTML, XML, DataStage, Pro*C, TOAD.