Over 7+ years of IT experience in various phases of software development especially in Analysis, Design, Development, testing and implementation as Oracle PL/SQL developer.

• Good experience in writing PL/SQL scripts for the database objects like tables, views, procedures, functions, packages, database triggers, indexes and sequences,
• Generated forms for data validation according to the business rules using Oracle Forms 6i/10g and fixed some bugs that were already developed.
• Experience in scheduling processes and maintaining up to date information, manage folders for sharing reports, exporting data generating Crystal Reports 8.5/10g and Oracle Reports 6i/9i/10g.
• Experience in System Development Life Cycle (SDLC), which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
• Very Good Knowledge about the Oracle tools like SQL, PL/SQL, SQL*PLUS, SQL*Loader, and data pump utilities like Export/Import.
• Experience in application fine-tuning and database fine-tuning using Explain Plan and TKProf.
• Experience in writing shell scripts for loading data and running the batch processes through Control+M .
• Experience in handling tools like TOAD, PL/SQL Developer, Visual Sleek Edit, also used the X Windows for handling the Oracle Forms in Unix environment.
• Experience in using Oracle development tools like SQL Developer, Oracle Enterprise Manager, PL/SQL Developer, and using TOAD in secure databases.
• Transferred data using FTP (File Transfer Protocol), SFTP (Smart FTP), WRQ Reflection, Visual Sleek Edit, Winscp, Humming Bird took back-ups of the data using SCP (Secured Copy).
• Able to work independently and as team member; adept at motivating staff to ensure smooth workflow and increased productivity.
• Developed proactive monitoring shell scripts for loading of data and also for loading the data files into the archive directories for easy processing.
• Documented business rules, functional and technical designs, test cases, and user guides.

TECHNICAL SKILLS

Operating Systems:

Sun Solaris 5.8/5.6/2.6, AIX 4.3/5.3, HP UX 10/11i, Unix, Red Hat Linux, Win NT/2000/9x.

Database:

Oracle 10g//9i/8i/8.0/7.x and SQL Server 2000,SQL Server 2005.

Database Tools:

Import, Export, SQL*Loader, SQL*Plus, OEM, TOAD and Net8

Case Tools:

ER Studio 7.1.2, Designer/2000/6i/9i, Erwin

Languages:

C,C++,JAVA, Shell Script (Bourne, Korne), Perl, SQL, PL/SQL and BASIC.

Web:

HTML, XML, JavaScript, and VBScript.

Reporting Tools:

Oracle Reports (reports 2.5/3.0/6i/9i), Crystal repots

Utilities

SQL Navigator, TOAD, SQL* Loader, PCAnywhere, SQL Developer, PL/SQL Developer, SmartFTP, WRQ Reflection, Visual Sleek Edit, X Windows

GUI

Forms 6i/9i/10g, Reports 6i/9i/10g,

CERTIFICATIONS

• Introduction to Oracle SQL 9i
• Oracle 9i Program with PL/SQL
• Brainbench certified Oracle Developer

PROFESSIONAL EXPERIENCE

Confidential,CA (Oracle developer) Aug 2009 – Mar 2010
Responsibilities:

• Worked on developing the AFS Framework.
• The business process here are embedded in SQL and perl and most of them do the same functionality so globalize all the SQL\'s and perl scripts
• Created Stored Procedures for all the various SQL Scripts already existing.
• Created a new controlling Stored Procedure is created to call the above created Stored Procedure containing the individual SQL Scripts and these Store Procedures and contained in a Global Package.
• Created shell scripts to call all these Global Created Packages.
• Converting some of the perl scripts into shell scripts.
• Created Shell script to perform NDM (Network Data Mover) which is converted from perl to shell
• Monitored the Autosys jobs and analyzed the dependencies of the jobs.
• Created backups for all the database objects and also compared the volume of data .
• Exclusively worked on query optimization.
• Created FSD (Functional Design Document) SIA (System Interface Agreement) documents for one of the interface getting data from AFS Oracle.
• Created Snapshot on the SUIFT interface to pull data from AFS.

Environment : UNIX, Toad 9.1, Clear Case, Oracle 10g, SQL Developer, Autosys
Confidential,OH (Oracle Developer) Oct 2008 – Jul 2009
Responsibilities:

• Worked on developing and maintaining the loans system and also upgrading various servers.
• Migrated Oracle forms and reports from 6i to 10g and also helped in upgrading various servers.
• Developed scenarios for Unit testing to ensure that all the components worked correctly when the applications are migrated.
• Various daily and monthly processing batch scripts are created using Unix shell scripting to include the new enhancements, accordingly.
• Modularized the shell scripts already existing pertaining to the loans system flow and inturn helped in partly re-designing the existing codes for better efficiency.
• Helped in tracking many test and production servers which support many applications in the system.
• Gained experience migrating the jobs scheduled through cron to Maestro the scheduler used in Nationwide for most of the applications.
• Generated various monthly, daily and quarter-end reports for the loans system using the SQR scripting.
• Involved in code review before dropping into QA environments and made changes if necessary according to the suggestion of the team lead and other team members.
• Involved in documenting users requirements, technical specifications, testing documents and Reporting manuals.
• Involved in Oncall Production Support and troubleshooting data quality issues and resolving the Service center tickets in a timely manner.

Environment: UNIX server, Oracle 10g, TOAD 9.0, PL/SQL, SQR 6.2, Oracle Forms and Reports 6i/10g, Maestro, Lotus Notes, HP Quality Center, HP Service Center, Harvest
Confidential,CT (Lead Developer) May 2008 – Oct 2008
Responsibilities:

• Yale provides funding to all Graduate Students every semester, involved in handling two projects one is the GSPS (Graduate Student Payment System) Cost Transfer and GSPS Commitments.
• In GSPS Cost Transfer this tells us how Yale manages the funding system and how the funds are being transferred from different departments to the students account, and my role involved in identifying which student was funded and from which department and what is the period of their funding .
• Created SQL scripts, PL/SQL functions, procedures and packages for user interface.
• The jobs are created to load the data into the GSPS system through Oracle Financials being the front-end application that was majorly used.
• Created PL/SQL procedures and functions necessary for validation of transaction records into interface tables.
• Involved in working with the Datawarehouse team to help them load and transform data from the GSPS system to the warehouse environment.
• Developed many reports according the business requirement using Oracle Reports and also using Brio and also migrated Brio reports to a later version.
• Created PL/SQL procedures, packages for retrieval of data as per the business rules.
• Majorly involved in tuning and extracting data from remote systems using Materialized Views and creating DBLinks.
• Associated with the DBA’s in monitoring performance related issues using Explain Plan, TKProf and SQL Trace Utility.
• Coordinated with clients, involved in gathering requirements and designing.

Environment: Windows NT server, Oracle 10g, TOAD 9.0, PL/SQL, Brio 7.5
Confidential,NJ Nov 2007 – Apr 2008 (Application/PL/SQL Developer)
Responsibilities:

• Every week A&P gets it’s data in the form of text files from Pathmark my role here involved in loading the data from the flat files using the shell scripts that automatically picks up the data and control files with the assigned load(a sequence generated number) into the staging tables.
• Gained experience in debugging the forms and fixed some bugs with the already developed forms and changing some functionality within the forms according to the business requirement and rules.
• Involved in writing packages and procedures, functions according to the business requirement process flow.
• Created scripts to create tables, indexes, synonyms, grants, ddl’s as well as involved in doing Table Partitioning and Sub partitioning on tables to improve the performance.
• Used the Version Control tools like PVCS, Visual Source safe which helps the multiple users to make simultaneous changes to a collection of forms and scripts.
• Worked with the team lead in setting up the control +M’s for the batch jobs that are scheduled to run every week (batch processing).
• Worked on the Oracle Forms 6i that were already developed for fixing the bugs and also changing the functionality of the form based on the client’s requirement.
• Created triggers both at the form and the block level based on the business requirement.
• Worked with the business and also the users to develop and customize the Forms and Reports according to their requirement and for user interface.
• Used PL/SQL tables to avoid mutating of tables problem in database trigger.
• Experience in writing complex SQL queries including inline queries and subqueries for faster data retrieval from multiple tables.

Environment: Windows Xp, AIX, Oracle 10g, PL/SQL, SQL * PLUS, PL/SQL Developer, Toad 9.0.1, Oracle Forms 6i, Oracle Reports 6i
Confidential,NC (Oracle Developer) Mar 2007 – Oct 2007

• Played a major role in understanding the agent requirements and providing them with the complete data that was retrieved from the Data warehouse.
• Loaded data from the flat files into the database tables using the Toad.
• Worked with tera bytes of database and involved in doing Table Partitioning and Sub partitioning on tables to improve the performance
• Created indexes on the tables, for easy retrieval of the good or the bad data to make data search and retrieval faster.
• Created various procedures and cursors for providing the agents with the original data that was initially stored as a flat file, by suspending the incomplete data.
• Extracted data from Flat files, Oracle and SQL sever sources and transforming it in accordance with the Business logic mentioned by the client
• Used the Explain Plan. Skilled at task performance evaluation and methods. Able to create and test different methods to achieve best possible speed.
• Experience in writing complex SQL queries including inline queries and subqueries for faster data retrieval from multiple tables.
• Created database Triggers for the security purposes and also for auditing purposes.

Environment: Windows Xp, Oracle 10g, PL/SQL, SQL * PLUS, PL/SQL Developer 6.0, Toad 9.1, Java, SQL Developer 1.2

Confidential,CT (Oracle Developer) Jan 2006 – Mar2007

Responsibilities:

• Gathered the requirement from different clients and translated user requirements into data flows, detail technical specifications and database requirement
• Created stored procedures, packages, generated triggers for security purposes.
• Extensively used the PL/SQL tables for avoiding the mutation.
• Developed UNIX shell scripts with embedded SQL*Loader, calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Used DBLinks and Materialized views for accessing the data in the production system database.
• Worked in coding, debugging, testing and supporting Company’s web-based Reports and Forms.
• Enforced the Integrity using the Integrity Constraints and the database triggers.
• Involved in Unit Testing by writing the formal procedures around the software for convenience of the developers to test their own individual code.
• Performed the data validation using the database triggers.
• Worked with different FTP clients for loading data from the windows environment to the Solaris environment.

Environment : Sun Solaris 5.9, Oracle 9i, PL/SQL, Oracle Forms 9i, Reports 9i, Windows Xp.

Confidential,GA (Oracle Developer) Feb 2005 – Nov 2005.
Responsibilities:

• Responsible for requirements analysis, design and development phases of the system.
• Created stored programs in the form of PL/SQL Packages, Procedures and Functions returning record sets, which in turn, are used for developing HTML reports.
• Created Stored Packages for moving the data from the staging area tables to the Fact and the dimensional tables.
• Created some executable programs running in UNIX operation system by using PRO*C and C languages.
• Used SQL Loader, for moving data from Flat Files (Fixed Record Length) to staging area.
• Involved in creating database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Performed data migration from the SQL server to Oracle using DTS.
• Developed and Tuned SQL, PL/SQL triggers and stored procedures.
• Involved in extensive unit testing, system testing and user acceptance testing.

Environment: Oracle 9i, SQL, PL/SQL, SQL*PLUS, Windows 98, SQL Server 2000.

Confidential,CA (PL/SQL Developer) Jan 2004 – Dec 2004

Responsibilities:

• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).
• Involved in monitoring existing SQL code and tuned if necessary
• Extensively involved in new systems development with Oracle 9i.
• Developed complex transactional screens using developer 2000 and fine tuned the existing/new front end screens for better performance
• Used EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also extensive usage of Indexes.
• Read data from flat files and load into Database using SQL*loader.
• Created the External Tables in order to load data from flat files and PL/SQL scripts for monitoring
• Involved in Unit Testing of newly created PL/SQL blocks of code.
• To conserve the resources used the anonymous blocks within the IF statements.
• Developed UNIX Shell scripts to automate repetitive database processes.

Environment: Oracle 9i, Solaris 2.8, PL/SQL, SQL*PLUS, TOAD 8i.

Confidential,India (PL/SQL Developer) Feb 2003 – Dec 2003

Responsibilities:

• Involved in development and testing of oracle back-end objects like database triggers, stored procedures.
• Used PL/SQL Wrappers for data authentication and security.
• Loaded data from the flat files into the databases using the SQL Loader.
• Contributed to tuning the SQL queries, create database objects and optimally set storage parameters for tables and indexes.
• Involved in taking backup and recovery using the tar , gzip and creating a secured copy using scp
• Received online messages from the defaulters and then querying these messages and finally generating the reports for these received messages.
• Involved in Testing and maintenance of various application modules.
• Support from Onsite for implementation.
• Environment: Oracle 8i, SQL, PL/SQL, AIX 4.1

EDUCATION

• Bachelor of Engineering