SUMMARY OF QUALIFICATIONS:

• Over FIVE years of experience in the field of Software Design, Development, Implementation and production support with proficiency in Oracle8i/9i/10g/11g, SQL, PL/SQL that includes Complete System Development LifeCycle from Analysis and Design to Implementation.
• Over THREE years of Experience in Java, J2EE.
• Over THREE Years of Experience in Perl Scripting&UNIXShell scriptingPerl/awk.
• Over THREE Years of Experience in VB6.
• Expertise in writing Packages, Stored Procedures, Functions, Views and DatabaseTriggers using SQL and PL/SQL in Oracle.
• 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 ERDiagrams on Erwin using Normalization Techniques. Exposure to concepts ofData warehouse like Design, Data Modeling, OLTP, ETL and Reporting.
• Has knowledge and understanding of underlying DatabaseArchitecture and Concepts.
• Experience in data migration from legacy system to OracleRDBMS.
• 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 Oracledatabaseenvironments of up to 10terabytes 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 querymaterialized views.
• Strong in writing StoredProcedures and SQLqueries. Designed and developed the Extraction, Transformation and Loading (ETL). Strong Domain knowledge of Insurance,Banking Systems,TelecomSystems andHealth Care.
• Involved in MigratingDatabase for text files to Oracle databases UsingSQL * 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.

PROFESSIONAL EXPERIENCE:

EMPLOYMENT

Employer: Confidential
Client Name: Confidential,Merrimack,NH february 2012 – April 2012
Job Title: Sr. Oracle Developer
Worked with the user to gather and study the user requirements on the project. Created Technical specification document based on the Business specifications document, which includes the database objects/changes needed and the clear approach includes pseudo code to meet the project requirements.
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 manipulatedStoredProcedures, Functions, Triggers and Packages using TOAD. Created numerous views and materialized views based on the business requirement. Using SQL * Loaderscriptcreated 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 Kornshellscripts on Oracledatabase with partitions and sub-partitions.
• Involved in migrating database from OracleCreated and used Table Partitions to further improve the performance while using tables containing large amount of data. Created a secure FTPscript 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 .SQLscripts, .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
• 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.
• Successfully moved these objects to the Production server. Worked on production support and resolved the issues occurred with the jobs. Using Perlscript, parsed the XML file which is then used by Java.
• Led and technically mentored a group of 7 intermediate and senior developers. 9i to Oracle10g for horizon application.

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

Employer: Confidential.
Client Name: Confidential, Goodlettsville, TN October 2009 – November 2011
Job Title: Sr. Oracle PL/SQL Developer
Responsibilities:

• Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• 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 datamodeling, 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.
• DevelopedDatabaseTriggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQLpackage. Used PL/SQL to validate data and to populate billing tables. Using UNIXShellscriptingPerl/sh/awk.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
• 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 Oracle9i to 10gdatabase. Involved in developingscreens and generating reports.

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

Employer: Confidential
Client Name: Confidential, Louisville, KY May 2007 - April-2008
Job Title: Oracle Developer/Analyst 
Confidential provides various individual, Medicare, group and mess-up plans like PDP, GPDP, HMO, PPO, FFS and GFFS.
Responsibilities:

• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic, using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting sing ParallelQueries, Javastoredprocedure, HTPPackage 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 UNIXshellScripting. 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 databaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle.
• 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 targetdatastructures.
• 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 UNIXShellscripts to automate repetitive databaseprocesses.

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

Employer: Confidential
Client Name: Confidential April 2006 – January 2007
Job Title: 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 MIUBatches by shell scripting for releasing error calls.
• Configuration of Usage points by using SQLstatements. Extensively Performed backend databasedevelopment tasks such as PL/SQL, Triggers, SQLQueries, Functions and packages. Built complex queries using SQL and wrote storedprocedures using PL/SQL.
• Involved in performance tuning and monitoring, tuned SQLqueries 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 UNIXshellscripts for log rotation and backup.
• Generating DDL files to create new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, storedprocedures, roles and granting privileges by incorporating business standards throughout the files.

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

EDUCATION:
Bachelor of Science in Information Technology, Confidential.
Master of Science in Computer Engineering, Confidential