SUMMARY

• Nine plus years of IT experience as an PL/SQL developer, System Analysis, Design, Development & Support of Oracle Database 8i, 9i, 10g and 11g in Production, Staging, Development environments.
• Proficient working experience with SQL, PL/SQL, Stored Procedures, Functions, Triggers, Packages and using the latest features to optimize performance.
• Extensive Experience with Oracle tools like SQL, PL/SQL, SQL*PLUS, SQL Developer, PL/SQL Developer, TOAD.
• Experience in Designing the Database using tools Erwin, MS Visio and good knowledge of Relational Database Management System (RDBMS).
• Excellent experience with performance tuning, normalization and denormalization, partitioning of tables.
• Strong experience with Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Proficient in advance features of Oracle 11g /10g for PL/SQL programming like Using cursor variables, Ref. cursors, Varrays, nested tables, Dynamic SQL, Bulk Binds, Inline views, Global Temporary Tables, Flashback.
• Experience in application and database fine - tuning using explain Plan, SQL Trace and TKPROF.
• Extensive knowledge of using DBMS Oracle supplied package like UTL FILE, DBMS JOBS, DBMS SCHEDULER, DBMS ALERT, etc.
• Hands on experience working with DB Links and also creating materialized views like Read Only, Updatable, Writeable.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Good knowledge on Amazoan Redshift.
• Good Working experience on Pro*C.
• Expert in UNIX Shell scripting (Bourne, Korn), Perl scripting.
• Hands on experience with Crontab in UNIX environment for scheduling routine tasks.
• Good experience working with various FTP protocols like FTP using SSH protocol.
• Good Knowledge of data warehouse Concepts and ETL tools like Informatica.
• Clear communication and documentation of technical specifications.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with customers and expert Skills in time management, prioritizing tasks.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, C, Shell Programming (Bourne, Korn), Perl Scripting, Visual Studio.NET 2003/2005, Pro*C.

Databases: Oracle 8i/9i/10g/11g, MS SQL Server 2005/2008, MySql, MS Access.

Reporting Tools: Oracle Forms & Reports 6i/9i/10g, Crystal Reports 8.0, SQL Server Reporting Services (SSRS), SSIS

Tools: TOAD 8.x/9.x, SQL Developer, PL/SQL Developer, Humming Bird 10, F-Secure 5.3, SFTP, Rational Rose, Microsoft Visio, ER-Studio, Erwin, MS Visio, BI, DWB.

DB Utilities: SQL Loader, Export / Import, Data pump, Explain Plan, TKPROF.

Operating Systems: UNIX, LINUX, Sun Solaris 5.X, Windows NT/XP/Vista/7, Windows 95/98/2000, Windows Server 2003/2008.

Web Technologies: HTML, DHTML, XML, JavaScript, IIS, ASP.NET, AJAX, SOAP and Web Services,ADO.NET, ADO and Active X.

PROFISSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr.Oracle Developer

Responsibilities:

• Responsible for requirements analysis, database design, development and unit testing of the application.
• Modified the existing DB design using Erwin tool according to the new requirements.
• Involved in writing SQL queries and PL/SQL programming. created new packages and procedures and modified and tuned existing procedure and queries.
• Involved in Creation of DB objects like Tables, partitioning tables, Indexes, sequences, views.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Worked on SQL Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Extensively used the features of PL/SQL like collections, ref cursors, and dynamic SQL, ref cursors and dynamic SQL.
• Used Explain plan for tuning the queries. Collected the DB statistics from AWR reports and worked closely with the DBA in the performance and space issues.
• Good knowledge of the Mortgage banking and worked on multiple applications on Development and Production Support.

Environment: Oracle 10g /11g, PL/SQL, SQL, TOAD, SQL Developer, PL/SQL Developer, SQL*PLUS, Solaris 5.10, UNIX, Windows 8, Erwin.

Confidential, New York, NY

Sr.Oracle Developer

Responsibilities:

• Worked on Extracting data from different data sources and loading it in to the database.
• Responsible for requirements analysis, database design, development and unit testing of the application.
• Created the DB design using Erwin, MS Visio tools or modifying the existing design according to the new requirements.
• Extensively involved in writing SQL queries and PL/SQL programming.
• Performing hands-on analysis, manipulation and loading of customer-provided data and providing reporting on loading using SQL*Loader.
• Involved in Creation of DB objects like Tables, partitioning tables, Indexes, sequences, views.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Worked on SQL Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Extensively used the advanced features of PL/SQL like collections, ref cursors, and dynamic SQL, nested table, varrays, ref cursors, materialized views and dynamic SQL.
• Used data pump utilities (EXPDP/IMPDP) for Copying of data from development server to test and production server using.
• Used Explain plan and auto-trace for tuning the SQL and Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Developed flat files using UTL FILE Oracle supplied package.
• Wrote Perl Scripts according to the requirement.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.
• Used the Crontab in UNIX for Automatic Tasks.

Environment: Oracle 10g /11g, PL/SQL, SQL, TOAD, SQL Developer, PL/SQL Developer, SQL*PLUS, Solaris 5.10, UNIX, Perl, Windows XP/7, MS Visio, Erwin, ER-Studio, ETL.

Confidential, New York, NY

Oracle Developer

Responsibilities:

• Involved in Creation of tables, partitioning tables, Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Extensively used the advanced features of PL/SQL like collections, nested table, varrays, ref cursors, materialized views and dynamic SQL.
• Worked on Application level Performance tuning.
• Used Explain plan and auto-trace for tuning the SQL and Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Used Oracle 10g new feature data pump utilities (EXPDP/IMPDP) for Copying of data from development server to test and production server using.
• Extensively used FORALL and BULK COLLECT to fetch large volumes of data from table.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Used DBMS FGA to provide fine grained security.
• Worked on Extracting data from different data sources and loading it in to the database.
• Wrote Perl Scripts according to the requirement.
• Developed flat files using UTL FILE Oracle supplied package.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.
• Used the Crontab in UNIX for Automatic Tasks.
• Used Validation Controls and Custom validation control to validate Web forms

Environment: Oracle 10g /11g, PL/SQL, SQL, TOAD 9.6, SQL*PLUS, Solaris 5.10, UNIX, Perl, Windows XP, C#.Net, IIS 6.0, Informatica, ETL.

Confidential, Virginia

Oracle PL/SQL Developer

Responsibilities:

• Analysis of business requirements and converting business rules into design software to meet the requirements.
• Participated as a team member and involved development of application.
• Developed tables, indexes, constraints, views and sequences.
• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Used PL-SQL features like cursors, ref cursors, Exception handling.
• Worked on User-defined and System defined exceptions to handle different types of Errors.
• Involve in Tuning, Performance and Optimization of queries and standardization of the code.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Extensively used FORALL and BULK COLLECT to fetch large volumes of data from table.
• Planned the index rebuilding, index analyze and table analyze on periodical basis.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Developed complex Oracle forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc).
• Developed LOV’s and Triggers for different data blocks.
• Developed forms Using Tab-canvas, Stacked, Content and Horizontal toolbar canvas.
• Developed reports using complex queries as per client request as a part of production support.
• Generated Reports on the daily basis according to client requirements using Crystal Reports.
• Worked withPro*Cscripts for interface modules.
• Worked withPro*Cto migrate the data into warehouse tables.

Environment: Oracle 10g, SQL, PL/SQL,, SQL*PLUS, TOAD 8.6, Oracle Forms 10g/9i, Crystal Reports, Solaris 5.8, UNIX, Perl, Windows XP, Informatica, Pro*C.

Confidential, IL

Oracle /.NET Developer

Responsibilities:

• Participated as a team member in the development and maintenance of applications.
• The systems were developed on Windows 2000 platform using Microsoft Visual studio .Net, C#.NET, ASP.NET, XML, and HTML.
• Have been involved in developing General Business E-Ordering Front-End Applications, and Continued Maintenance and update releases for this application.
• The data was stored in Oracle 9i database and was accessed using ADO.NET.
• Java Script was used to validate user inputs/data and manipulate aspects of the client browser while a user viewed the page.
• Tasks Include developing HTML and ASP.NET Pages to interface with an end user.
• Have been involved in developing Front End for General Business Registration Application. This Application basically enables the user i.e. General business Customer to register on this website.
• My tasks mainly includes developing web pages using ASP.NET that runs on IIS which ask required credentials from Users and eventually after authentication register the user and provides the User id and Password.
• Used Validation controls (Compare validator, Range validator etc) for UI validations.
• Created a Web service to verify the credentials by connecting to the database and returns back the result on the ASP.NET page. The unauthenticated users were forced to enter into registration form .This registration form was included as a user control in ASP.NET page.
• Used Data Grid to provide UI reporting which was populated using Dataset Object of ADO.NET. This data grid was dropped in user control .ADO.NET was used to connect to the database and data was accessed by using the dataset object and bound to data grid control.
• Involved in creation of Tables, Views.
• Created Indexes and sequences for the faster retrieval of data.
• Creating SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Worked on Extracting data from different data sources and loading it in to the database.
• Maintenance and updating releases for this Application and even extended support to the requests of Users enabling them to reregister on the site.

Environment: Oracle 10g/9i, ASP.Net 1.1/2.0, IIS 5.0, Erwin, C#.NET, ADO.NET, JavaScript, HTML, IIS, Visual Studio.NET, Crystal Reports, Informatica, ETL.

Confidential, Dallas, TX

Oracle Developer

Responsibilities:

• Performed database and query tuning and performance monitoring.
• Enforced database integrity using primary keys and foreign keys.
• Monitored growth of data and managed space allocation accordingly.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity.
• Extensively written PL/SQL code for stored Procedures, Functions, Packages, Libraries and other database triggers etc. Written interfaces to transfer/interact data with various external systems.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Used package like DBMS JOB to determine if there are any jobs that are to be performed, or any changes are made to the program or procedure.
• Backup strategies, scheduling the backups. Backing up and restoring the databases whenever necessary.
• Actively involved in coding SQL statements in PL/SQL.
• Developed various Complex Queries, Views for Generating Reports.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Used Quest TOAD to tune query performance.
• Performed off site on call 24x7 production support for Oracle 9i database administration activities.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Used Cursors both implicit and explicit to capture many rows within a PL/SQL block, and applied business rules on them.
• Created public synonyms on the database links for easy reuse.
• Created database links to retrieve data from multiple servers.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation.
• Managing Tablespaces, Rollback segment, Indexes for various applications like Financials Accounts, Inventory Control System and Payroll & Personnel Administration System.
• Created parameterized reports and customized existing reports for presentations using Cross-Tab reports and Sub-reports and Running Totals/Formulas in crystal report.
• Made Forms customization on various existing forms.
• Use built-in functions in oracle forms.
• Created layout wizard and data block wizard in oracle forms.
• Created LOVs, record group in oracle forms.
• Created flat files as reports and migrated into remote server usingPro*Cscripts
• Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.

Environment: Oracle 9i, PL/SQL, Windows 2000, SunOS 5.8, Crystal reports 9, SQL*Loader, TOAD 8.5, SQL Navigator, Oracle Forms 6i/Oracle Report 6i, Pro*C.

Confidential

Oracle Forms Developer

Responsibilities:

• Study the scope of the systems.
• Analyzed and designed the various PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Participated as a team member in the analysis of the system.
• Creation of many Database Packages, Functions, and Procedures.
• Developed database triggers and stored procedures using PL/SQL cursors and tables.
• Used PL/SQL Dynamic procedures during Package creation.
• Extensively used the advanced features of PL/SQL like collections, nested table, varray & Dynamic SQL.
• Created the indexes and analyzed the table for better performance.
• Used case statements and expressions while writing PL/SQL block.
• Used DBMS REDEFINATION package to rename columns and constraints.
• Extensively used Explain Plan, TKPROF for SQL query optimization.
• Used PL/SQL tables, PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database trigger.
• Worked extensively on exception handling, to trouble-shoot PL/SQL code.
• Customized data by adding calculations, summaries and functions.
• Developed Front end with Forms 6i.
• Wrote DDL statements and triggers in oracle forms.
• Wrote PL/SQL Library and triggers in oracle forms.
• Design and development of screen interface using Oracle Forms, Reports.
• Developed LOV’s and Triggers for different data blocks.
• Developed complex Oracle forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications.
• Involved in coding and implementation of PO’s, other bills, LC’s, Service tax and other advances, LC Payments.
• Managed and resolved design issues during development stage. Worked closely with other developers.
• Bridged the connection between Oracle Database and Java Application using JDBC Driver and data transfer.
• Used the methods provided in the JDBC API to create, read, update and delete the data from the database.
• Prototype demo to the management and users.

Environment: Oracle 9i, PL/SQL, Forms 6i, Reports 6i, Windows XP, JDBC 4.0, Java1.6.