SUMMARY

• Over Five years of experience in the field of Software Design, Development, Implementation and production support with proficiency in Oracle 8i/9i/10g/11g, SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Over Three years of Experience in Java, J2EE, Perl Scripting & UNIX Shell scripting Perl/awk, VB6.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 (Forms, Reports), Forms and Reports 9i, Oracle Developer Suite 10g and other front - end tools.
• Development focusing on Website/Email tracking, database Queries.
• Experienced with the latest Technologies, Architectures and Frameworks such as Enterprise Java Beans, Servlets, Java Server Pages, Hibernate, Spring, JDBC, JUnit, JUnitPerf, STRUTS, XML,Web Services, WSDL, SOAP, REST, UML, SQL, C++.
• Worked with query tools like TOAD, SQL*Plus, SQL Developer. Proficient knowledge in HTML and JavaScript. Created ER Diagrams on Erwin using Normalization Techniques. Exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting.
• Has knowledge and understanding of underlying Database Architecture and Concepts.
• Experience in data migration from legacy system to Oracle RDBMS.
• Proficiency in relational databases (RDBMS), data modeling and in building Data Warehouse Data Marts using Star Schema and Snowflake Schema.
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD. Experience in Performance Tuning & Optimization of SQL statements. Extensively worked in Oracle database environments of up to 10 terabytes in size including very large data sets and partitioned data.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications. Created materialized views like primary key, rowid and sub query materialized views.
• Strong in writing Stored Procedures and SQL queries. Designed and developed the Extraction, Transformation and Loading (ETL). Strong Domain knowledge of Insurance, Automobiles, Banking Systems,Health Care and e-Learning.
• Involved in Migrating Database for text files to Oracle databases Using SQL * Loaders.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

TECHNICAL SKILLS

Operating Systems: Windows 98 / NT / 2000 / XP, UNIX

Languages: Java, C, C++, VB6.0, SQL, PL/SQL, FOXPRO

Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD, iSQL*Plus, SQL*Loader

Development Tools: Developer 10g/9i/6i/2000 Release 1 & 2

Scripting Languages: Java Script, UNIX Scripting

Web Technologies: HTML

Reporting Tools: Crystal Reports, Oracle Reports.

PROFESSIONAL EXPERIENCE

Confidential, Merrimack, NH

Sr. Oracle Developer

Responsibilities:

• Created database objects like tables, views, synonyms, procedures, functions and data base triggers to meet the business requirements. Created constraints on the tables and the relations between the tables to meet the requirements.
• Involved in the Performance tuning of the queries using Explain Plan. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Analyzed the execution plan and the statistics of the optimizer and passed the hints and placed indexes wherever necessary.
• Successfully manipulated Stored Procedures, Functions, Triggers and Packages using TOAD. Created numerous views and materialized views based on the business requirement. Using SQL * Loader script created a job to load everyday file in to status table.
• Provided technical decision support for the system and business analysts. Developed batch processes for financial reporting applications and modules using Perl and Korn shell scripts on Oracle database with partitions and sub-partitions.
• Involved in migrating database from Oracle Created and used Table Partitions to further improve the performance while using tables containing large amount of data. Created a secure FTP script which runs every day to send the daily Agent training file. These jobs scheduled to run everyday using Control-M.
• Did unit testing with the test daily file and sent the everyday test Agent training file by running the jobs manually. Crated, handled and maintained the .SQL scripts, .CMD files and RDFs according to the changes in the business requirements.
• Explored to work and Mappings and Mapplets for ETL process using Transformations like Source Qualifier, Lookup, Joiner, sorter, Stored procedure, Sequence generator, Aggregate, Filter, Update Strategy, Expression, Router, Rank, and etc
• Coded number of Oracle Forms as per the business requirement based on technical document.
• Processing and system capabilities, uses and requirements. Defining Key flex fields and values sets. Ensured timely completion of development projects within estimated costs and standards. Reviewed and modified existing customized reports using Crystal Reports 8.5.
• Design and create new customized reports using Crystal Reports 8.5. Interacted with the client IT team and the business team to resolve issues and dependencies.
• Successfully moved these objects to the Production server. Worked on production support and resolved the issues occurred with the jobs. Using Perl script, parsed the XML file which is then used by Java.
• Developed persistence layer for the Web Services and integrated applications and participated in data modeling. Integrated existing Web Services and applications components with the newly built ones using the Enterprise Service Bus.
• Led and technically mentored a group of 7 intermediate and senior developers. 9i to Oracle 10g for horizon application.

Environment: VB 6, JAVA, Oracle 10g/11g, SQL, PL/SQL, SQL*LOADER, SQL *Plus, TOAD, XML, UNIX, Perl, VSS.

Confidential, Goodlettsville, TN

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic, using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting sing Parallel Queries, Java stored procedure, HTP Package and WEB.SHOW DOCUMENT. Participated in change and code reviews to understand the testing needs of the change components. Working on troubleshooting defects in timely manner.
• Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Used SQL Server SSIS tool to build high performance data integration solutions, including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Designed and developed Oracle forms & reports generated up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.
• Used Crystal Reports to tracked logins, mouseovers, click-throughs, session durations and demographical comparisons with SQL database of customer information.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.

Environment: VB 6, Oracle 9i/10g/11g SQL, PL/SQL,SQL*Loader, SQL Navigator, TOAD.

Confidential, Louisville, KY

Oracle Developer/Analyst

Responsibilities:

• Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information. Involved in GUI designing using Oracle Developer 10g (Forms 10g and Report 10g).
• Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package. Used PL/SQL to validate data and to populate billing tables. Using UNIX Shell scripting Perl/sh/awk.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables. Performed functional testing for different Oracle Forms application functionalities.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD. Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in migrating database from Oracle 9i to 10g database. Involved in developing screens and generating reports. Developed Forms and Reports.

Environment: VB 6, JAVA, Oracle 9i/10g, PL/SQL, SQL*LOADER,SQL PLUS, HTML,TOAD, XML, HP-UNIX shell scripting.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Monitored Usage Processing of TTL-OSS-BILLING System. For six states namely Delhi, Gujarat, Tamilnadu, Karnataka, AndraPradesh and Mumbai. Analysis &Review of Usage Reports. Scheduling MIU Batches by shell scripting for releasing error calls.
• Configuration of Usage points by using SQL statements. Extensively Performed backend database development tasks such as PL/SQL, Triggers, SQL Queries, Functions and packages. Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in performance tuning and monitoring, tuned SQL queries using Code Statistics and Explain plan features and analyzing number of hits and scans for an optimal execution plan, adding hints, indexes and parallel processing techniques for the queries.
• Provided Cross Training to Team Members on the Developer tools, PL/SQL, SQL. Create and maintain UNIX shell scripts for log rotation and backup.
• Developed custom Oracle Forms based on requirement for the application.
• Generating DDL files to create new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges by incorporating business standards throughout the files.

Environment: VB 6, ORACLE 8i, SQL, PL/SQL, TOAD, UNIX Shell Scripts.