SUMMARY

• 9+ years of IT experience handling all phases of SDLC like analysis, design, development, implementation and deployment of large software products in both Client/Server and Web Server Environment using Oracle 11gr2/10g/9i/8i database, J2EE and .net on different platforms like Unix and Windows NT/2000/98/xp/windows7 environments, that involves system study, designing process flow diagrams, preparation of user manual, testing and debugging of software, implementation and training for users.
• Expert in Oracle Database Development. Designed and implemented OLTP and Data Warehouse Systems, application schemas, reports, and application interfaces using PL/SQL, Stored Procedures, Packages, Triggers, Functions, SQL Loader, External Tables, Utl File, Objects Types, Collections, Bulk Collect, Cursors, Ref cursors, Table functions, Global temporary tables, Analytical functions and Dynamic Sql on Oracle (8i - 11g), Oracle Flashback table & query.
• Skilled in Unix Shell and Perl script writing. Created load scripts in Korn shell and Perl on UNIX, called by scheduler (Crontab and Autosys), to format and transfer data from various platforms and databases.
• Solid experience of Performance Analysis and SQL query tuning, response time reducing, while designing scalable applications from scratch and maintaining existing ones, using AWR, Profiler, EXPLAIN PLAN, TKPROF and SQL Trace. Good knowledge of key Oracle performance-related features, such as Cost-based optimizer, Execution plans, Optimizer Hints, Indexes, Partitioning, Temporary tables, v$-views.
• Extensively worked on SQL Loader, creation of control files to load the data from flat files.
• Good knowledge on oracle administration fundamentals including import/export, expdp/impdp.
• Involved in Design of Data modeling including logical, physical data modeling and dimensional data modeling using ERWIN.
• Providing suitably tested fixes to defects with in the sanctioned delivery process.
• Carrying out design, construction, review and defect analysis activities.
• Ability to produce clear documented and commenced code.
• Proficiency in oracle11gr2 (11.2.0.1.0 ), sql, pl/sql
• Proficient using TOAD, SQL Navigator, SQL/PLSQL developer, Clear Quest, Clear Case, DOORS and FTP tools (Humming bird, Putty, Fsecure etc).
• Strong experience with DATAPUMP utilities like EXPDP/IMPDP.
• Worked on Database links and materialized views.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Extensive experience in writing Static & Dynamic (REF) Cursors, Dynamic SQL, Records, PL/SQL tables & Exception handlers.
• Expertise in handling errors using Exceptions.
• Design and Implemented ETL (Extract, Transform, Load) using Informatica PowerCenter.
• Hand on experience in creating different kinds of partitions for managing large tables.
• Experience in working with high transacted OLTP systems.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL, Pro*C and UNIX utilities.
• Hands on experience in working different FTP clients like Smart FTP, Cute FTP, SFTP using F-Secure and Winscp.
• Used database objects to create Reports according to requirements using Crystal Reports.
• Familiar with the features enhancements in Oracle 11g.
• Experience in using Developer 10g, Forms and Reports 10g/9i/6i for developing end user screens and reports.
• Knowledge and experience with BI publisher Reporting, SQL Reporting, Crystal Reports, Business Objects and other report writing tools utilizing oracle, SQL Server, Access, Excel, Flat files and other Data sources. Excellent experience with performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
• Ability to understand Functional specifications, Business requirements and technical Design documents.
• Actively ensuring the production implementation of the new enhancements with smooth transition of the project adding value to the team in filling the gap where required as an Analyst, Programmer and Tester.
• Used existing processes and procedures for application deployment and provided 24x7 production support as Primary.
• Worked with relative RDBMS data models and highly involved in normalizing them using 1NF, 2NF and 3NF from denormalized state.

TECHNICAL SKILLS

Databases: Oracle 11gr2 (11.2.0.1.0 )/10g/9i, SQL Server2000/2005,MySQL, Microsoft Access

Tools: TOAD, SQL *PLUS, SQL Navigator, ERWIN, Oracle 6i/9i/10g, Reports & Forms developer suite, TKPROF, EXPLAIN PLAN,SQL*Loader, Export, Import, SQL Developer, Internet Information Services (IIS)

Scripting: HTML, XML, CSS, Perl, Korn & Bourne Shell Scripting

Operating System: Windows 9x/NT/2000/2003/XP/VISTA, Linux, UNIX

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

Version Control Tools: CVS, Clear Quest, PVCS, Clear Case, Subversion (Tortoise SVN), Windows TFS

PROFESSIONAL EXPERIENCE

Confidential, West Des Moines, IA

PL/SQL Developer

Responsibilities:

• Interacted 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.
• Written sql and pl/sql scripts using oracle11gR2 to extract data from database and for testing purpose.
• Performed normalization of the OLTP database to eliminate redundant data. Developed technical infrastructure designs, data mappings, flows and report dissemination mechanisms by architecting Data Warehouses and Marts.
• Developed PL/SQL Procedures, Functions, Cursors, and Packages. Views and Materialized Views with fast and incremental Refresh Rates.
• Worked on PL/SQL Implicit, Explicit and REF Cursors and created Triggers. Enforced integrity constraints using triggers.
• 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.
• 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.
• Highly involved in a huge transition from denormalized database to Normalized database to reduce the redundancy by diving larger database to smaller tables with relative mapping with the help of 1NF, 2NF and 3NF.
• 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.
• Worked with data dictionary views to query the required information about the status of the procedure, looking for any indexes etc.
• Worked with Business Objects (Crystal Reports) developers for enhancement of the reports and faster data loads and improve functionality of the reports generated for business.
• 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 etc., and PRAGMA EXCEPTION INIT.
• Implemented the Usage of System Change Number (SCN) in order for getting the Flashback Database.
• Resolved Priority Production Support Issues and Defect Fixes in PL/SQL code.
• 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.
• Worked as a part of GOLDEN GATE creation and validation process.

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

Confidential, St. Louis, MO

PL/SQL Developer

Responsibilities:

• Analysis and gathering of new business requirements from the business resources.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Worked on Autosys Jobs which will kick off the scripts at the scheduled time automatically.
• Worked thoroughly on coding and debugging of stored procedures, functions, packages and other Oracle objects to implement Business Rules.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Modified the existing procedures according to the new enhancements.
• Worked on repairing and enhancing current base ofPL/SQL packagesto fix production issues and build new functionality and improve processing time throughcode optimizations and indexes.
• WroteSQL Loadercontrol file for flat file data load and scheduled them in UNIX to load every night in Production Environment.
• Worked with DBAs to tune long running queries, used Explain plan and SQL trace to analyze query execution plan

Environment: Oracle 11gR2, SQL, PL/SQL, SQL Developer 3.0.03, UNIX, TOAD, Shell scripting (Bourne and Korn), Subversion (SVN)

Confidential, West Des Moines, IA

PL/SQL Developer

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Analysis and gathering of new business requirements from the business resources.
• Worked thoroughly on coding and debugging of stored procedures, functions, packages and other Oracle objects to implement Business Rules.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Modified the existing procedures according to the new enhancements.
• Responsible for making decisions on coding standards and documentation.
• Involved in developing ETL Process to Load the Data from different sources.
• Involved in Performance tuning of SQL queries by using quest control tools and manual by EXPLAIN PLAN.
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Involved in developing UNIX shell scripts for Loading Database Tables.
• Loading data from flat files into database tables using SQL* Loader
• Developed SQL and PL/ SQL scripts for migration of data between databases.
• Writing scripts for Data Staging, Loading and cleanup process.
• Experience in developing various kinds of triggers and used sequences to generate values for surrogate keys in data warehouse tables using Before Insert triggers.
• Created Materialized Views and partitioning tables for performance reasons.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Extensively used Nested tables, PL/SQL tables to code Procedures and Functions.
• Implemented common/generic routines (utility functions) to standardize backend processing
• Worked with DBAs to tune long running queries, used Explain plan and SQL trace to analyze query execution plan

Environment: Oracle 11g R2, SVN, TOAD 10.1, Clear case, Clear quest, SVN, MS VSS, Share Point, Sun Solaris/Windows XP/Linux

Confidential, West Des Moines, IA

PL/SQL Developer

Responsibilities:

• Interacted 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.
• Written sql and pl/sql scripts using oracle 11gR2 to extract data from database and for testing purpose.
• Performed normalization of the OLTP database to eliminate redundant data. Developed technical infrastructure designs, data mappings, flows and report dissemination mechanisms by architecting Data Warehouses and Marts.
• Developed PL/SQL Procedures, Functions, Cursors, and Packages. Views and Materialized Views with fast and incremental Refresh Rates.
• Worked on PL/SQL Implicit, Explicit and REF Cursors and created Triggers. Enforced integrity constraints using triggers.
• 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.
• 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.
• Highly involved in a huge transition from denormalized database to Normalized database to reduce the redundancy by diving larger database to smaller tables with relative mapping with the help of 1NF,2NF and 3NF.
• 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.
• Worked with data dictionary views to query the required information about the status of the procedure, looking for any indexes etc.
• Worked with Business Objects (Crystal Reports) developers for enhancement of the reports and faster data loads and improve functionality of the reports generated for business.
• 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 etc., and PRAGMA EXCEPTION INIT.
• Implemented the Usage of System Change Number (SCN) in order for getting the Flashback Database.
• Resolved Priority Production Support Issues and Defect Fixes in PL/SQL code.
• 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.
• Worked as a part of GOLDEN GATE creation and validation process.

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

Confidential, Pittsburgh, PA

PL/SQL Developer

Responsibilities:

• Developing highly complex applications using Oracle 11gr2 database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Involved in creating Database Design (Physical and logical) as per the requirement given by business.
• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
• Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.
• Used features like bulk collect to process large amount of data in data base.
• Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the database using SQL* Loader.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Extracted data from Flat files using SQL*LOADER.
• Designed and developed Oracle Forms & Reports using Forms10g and Reports 10g. Including Forms based on stored procedures.
• Executing and maintaining the data warehouse extract transform load (ETL) process.
• Made use of performance tuning utilities like explain plan, Explain Plan, SQL Trace and dbms profiler to reduce the run time of complicated queries on Oracle 10g.
• Understanding of the Functional specifications, based on that prepared design documents using concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables.
• Handling all the application roles both in the application tier (Oracle Forms) and in Database tier (Database Roles and Synonyms).
• Constructing complex SQL queries with sub-queries, inline views as per the functional needs. Create SQL scripts to perform unit and component 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.
• Responsible for redesign and restructuring of existing ETL process to provide better scalability, restart ability and maintainability.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader, highly tuned ETL process (SQL Loader and PL/SQL procedures) was implemented to load client’s feeds into staging schema of data warehouse.
• Creating shell scripting for generating reports for clients.
• Designed and Developed Several Matrix and Master Detail Reports with Oracle Report Designer.
• Quickly learned a wide range of technology skills and business knowledge required for my projects.
• Using existing processes and procedures for application deployment and provided 24x7 production support as Primary

Environment: Oracle 10g/11g, HP-Unix, Oracle Enterprise Manager, SQL*Loader, SQL*Plus, PL/SQL Developer, Oracle forms, UNIX Shell Scripting.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in Client interaction, requirement analysis, system design, development, testing, documentation and implementation.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Developed UNIX shell scripts for batch process.
• Design source to target mapping documentation and designed Data Warehouse Dimensional model using type 2 slowly changing dimensions.
• Provided solutions for partition adjustment tasks, Includes creating new partitions and moving data between different set of partitions.
• Automate Oracle scripts using Unix Shell Scripting and Experience file manipulation using UNX AWK scripting
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Responsible for identifying database performance issues and tuning as necessary using Explain plan and Hints.

Environment: Oracle 10g, PL/SQL, Oracle Forms 10g, TOAD, Oracle Reports 10g, UNIX.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in interacting with the end-user (client) to gather business requirements.
• Resolved application problems to maintain high level of customer satisfaction.
• Involved in performance fine-tuning of the queries/report using PL/SQL and SQL Plus.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Managed tables, indexes, constraints, views sequences, synonyms and stored program units.
• Developed database triggers required for the Integrity constraints.
• Created Logical and Physical Models using ERWIN.
• Performed performance tuning and query optimization.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
• Coded complex SQL queries to retrieve data from the database depending on the need.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Written PL/SQL cursors for transaction processing.
• Written Queries for the management in the form of stored procedures and packages.
• Involved in writing complex queries to generate reports as per client request as a part of production support.
• Developed batch programs in Pro*C and wrote Scripts to run them on Unix Cron Scheduler.
• Created partitions on the tables to improve the performance.
• Extracted data from Flat files, Oracle and SQL server sources.

Environment: Oracle 9i, Solaris 5.9, SQL Developer 1.1, Serena PVCS, Oracle, Enterprise Manager, Windows 2000, Oracle forms 9i