SUMMARY

• Proficient working experience with SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers and using the latest features to optimize performance (Bulk Binds, Inline views, Global Temporary Tables, Flashback).
• Extensive Experience with Oracle tools like SQL, PL/SQL, SQL*PLUS, Oracle Enterprise Manager, SQL Developer, TOAD, Oracle 10g Developers suite.
• Proficient in advance features of Oracle 10g for PL/SQL programming like Using cursor variables, Ref. cursors, Varrays, nested tables, Dynamic SQL.
• Excellent experience with performance tuning, normalization and denormalization, partitioning of tables.
• Experience in application fine - tuning and database fine-tuning using explain Plan, SQL Trace and TKPROF.
• Strong experience with Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• 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.
• Knowledge of Relational Database Management System (RDBMS).
• Expert in UNIX Shell scripting (Bourne, Korn).
• Hands on experience with Crontab in UNIX environment for scheduling routine tasks.
• Good Knowledge of data warehouse Concepts.
• Good Knowledge of ETL tools like Informatica.
• Good experience working with various FTP protocols like FTP using SSH protocol.
• 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.
• Expert Skills in time management, prioritizing tasks.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, C, Shell Programming (Bourne, Korn), Perl Scripting, Visual Studio.NET …

Databases: Oracle … MS SQL Server … 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, Humming Bird 10, F-Secure 5.3, SFTP, Rational Rose, Microsoft Visio, ER-Studio, Erwin, BI, DWB.

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

Operating Systems: UNIX, LINUX, Sun Solaris … Windows NT/XP/Vista, Windows … Windows Server …

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

PROFESSIONAL EXPERIENCE

Confidential, Newark, NJ

Oracle Developer

Responsibilities:

• Responsible for requirements analysis, design, development and unit testing of the application.
• Performing hands-on analysis, manipulation and loading of customer-provided data and providing reporting on loading.
• 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 and PL/SQL programming.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Extensively used the advanced features of PL/SQL like collections, ref cursors, and dynamic SQL.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Extensively used the advanced features of PL/SQL like collections, nested table, varrays, ref cursors, materialized views and dynamic SQL.
• 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 data pump utilities (EXPDP/IMPDP) for Copying of data from development server to test and production server using.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• 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.

Environment: Solaris 5.10, UNIX, Perl, Oracle 10g /11g, Windows XP, PL/SQL, TOAD 9.6, SQL*PLUS.

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.
• 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: Solaris 5.10, UNIX, Perl, Oracle 10g /11g, Windows XP, PL/SQL, TOAD 9.6, SQL*PLUS, C#.Net, IIS 6.0.

Confidential, Virginia

Oracle 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.

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

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 datablock wizard in oracle forms.
• Created LOVs, record group in oracle forms.
• 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