Summary

• Over 8 years of experience as an Oracle developer. Involved in complete SDLC including architecture, analysis, design, development, testing, implementation & maintenance of application software in the Client/Server and web based environments.
• Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views using Oracle PL/SQL database programming language.
• 5 Years of experience in Production Support
• Experience in using Oracle Forms 10g/6i/5.0&4.5, Reports 10g/6i&2.5,Oracle designer 6i/4.7,Oracle discoverer 10g for developing end user screens and reports and also adept in using Oracle Tools like SQL* Plus, Toad, SQL Developer, SQL Loader, Data Loader, SQL navigator, JDeveloper .
• Experience in developing SQL*Loader control programs and PL/SQL validation scripts for validating data to load data from staging tables to production tables.
• Proficient in writing UNIX KORN Shell, PERL Scripts.
• Good understanding of Data mining concepts, ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
• Very good experience in production support
• Developed and implemented authorization and authentication rules for Application Administrators in order to manage the Oracle APEX applications, users, and their log activity details.
• Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
• Extensive experience with various test efforts like data validation, integrity testing and Unit testing.
• Experience with Star Schema Modeling and knowledge of Snowflake Dimensional modeling.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.

Technical SkillS:

SKILL SET:

Database: Oracle 11g/10g/9i/8i/7x, MS Access

Languages: SQL, PL/SQL, C, C++, Perl, JAVA, Unix shell scripts

Web Technologies: ASP, HTML, DHTML, XML, VB 6.0, Oracle apex 4.1/4.0/3.2,OBIEE

Operating Systems: Sun Solaris, Unix, Windows NT/2000/XP, Linux

Tools: SQL*PLUS, TOAD, SQL*Loader, Oracle Forms 10g/6i/4.5, Reports 10g/6i/2.5, Oracle Designer 6i/4.7,Oracle Discoverer 10g SQL Navigator, JDeveloper, Rational Clear case, Rational Clear quest, Load runner, Win runner, Erwin 3.5, Test Director, Microsoft Visio, Rational Rose, XML publisher, Jira, Kintana, pvcs, Informatic power centre 9.0

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Project name: Confidential

Description: Confidential is an Oracle based application that tracks all capital project costs, bonds outstanding, and debt awards, and computes debt service for debt funded projects. In addition, Confidential provides customized management reports with roll-up and drill-down functionality and forecasting capabilities

Responsibilities

• Studied user requirements and functional specifications. Converted User Requirements into formal Functional specification and Interfacing with client.
• Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures. Developed Database Triggers to enforce security also used ref cursors
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Used advanced SQL features like Inline views, advanced Joins, Decodes, Indexing, Bulk Inserts, Bulk collects and other analytical functions in 10g.
• Used Oracle designer to produce the ER diagrams, Dataflow, function Hierarchy
• Designed and developed complex procedures to handle errors and exceptions level using PL/SQL and SHELL scripts.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
• Written shell scripts and executed them as Cron jobs on UNIX.
• Designed and developed Oracle Forms & Reports using Forms10g and Reports 10g. Including Forms based on stored procedures
• Supplied packages were used to extend the functionality of pl/sql programs such as DBMS JOB for scheduling, UTL FILE to read and write from database, DBMS SQL to write Dynamic SQL etc.
• Planned version control of production source code using Concurrent Version System (PCVS).
• Using CAB for any production changes and attending the meeting to get an approval.
• Providing Post production support of the systems.
• Xml Publisher reports have been developed.
• Support existing applications and prioritize the tickets using JIRA
• Responsible for application testing and support, version control, production staging and implementation planning, overseeing development efforts, support and training .
• Developed database triggers to enforce security. Also implemented materialized views for remote instances.
• Responsible for application testing and support, version control, production staging and implementation planning, overseeing development efforts, support and training .
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.

Environment: Oracle 11g/10g, Forms 10g, Reports10g, Designer 10g, SQL *Plus, Perl, XML, Oracle apex 4.1/4.0,TOAD, PL/SQL, HP-UX, Windows NT/2000, Oracle apex, sql developer, XML publisher, Kintana, Jira, PVCS

Confidential, South Portland, ME

Sr. Oracle Developer

Responsibilities:

• Developed various Oracle PLSQL packages, functions, procedures for process design and extensions.
• Designed and developed Programs for data integration from external source or interface flat files into database tables using SQL*Loader (SQLLDR)
• Responsible for writing complex SQL queries and developed the back-end programs in PL-SQL for this application.
• Created Daily, Weekly, Monthly, Quarterly, Yearly Reports and Several Complex Reports for Group Finance and Payables using Oracle Reports Builder 10g.
• Designed and Developed User Interface for customer analytics project using Form Builder 11g, deployed to the client server and complied them as per the business requirements.
• Designed manual, custom reports as per client’s requirements using Reports Builder 11g.
• Created over 20 forms with complex master detail relationships, Triggers and firing events, Custom PLSQL libraries and Database API.
• Deployed the scripts in to DEV, INTEGRATION using version control software and Release approval process.
• Authored Business Requirement Documents, Functional and Technical Design documents, Integration Documents and User training Documents.
• Redesigned and coded some of the existing Procedures in the system to extend the existing functionality.
• Extensively used Dynamic SQL for DDL and DML commands in PL/SQL. The procedures are built to generate reports with dynamically varying conditions based on the input parameters passed.
• Optimized SQL Queries by performance tuning using Explain plan, creating Indexes for reporting requirements and providing hints as of when required.
• Supported post production deployments with and code or Database related Issues.
• Worked in close proximity with business users understanding the need for extensions and acted as liaison for new reports and Forms design and development.
• Extensively involved in various phases of testing the products before migrating Production, from Unit testing through regression, UAT and performance testing.
• Expertise in Loading in multiple tables data and able to use merge statement of conditional
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• Worked on ETL tools like Power Center8.0 which are used for data integration and also mapping the data.
• Created batch jobs in regular maintenance, production support to load the data using UNIX shell scripting and KORN shell scripting.
• Worked on Oracle OLAP tool to produce analytic measures, including time-series calculations, financial models, and forecasts.
• Implemented table and index partitioning of various tables with huge data.
• Detected and corrected bugs during system integration and user acceptance testing.

Environment: Oracle Database11g, Linux oracle 6, TOAD, SQL*Developer, UNIX, Reports Builder 11g, Forms Builder 11g, Rational Clear Case, Share point, MOVEIT Central, Informatica Power Center8.0, HP Quality Center.

Confidential, NY

Oracle Developer

The Confidential Limited based in Tokyo, Japan, was one of the largest banks in the world during the latter half of the 20th century. It combined with Dai-Ichi Kangyo Bank and Fuji Bank in 2002 to form Mizuho Financial Group. The project is mainly to design and develop report for Advanced Commercial Banking System data mart for IBJ bank using Oracle middleware fusion, Oracle discover 2000 which design and develop complex data models for the advanced lending solutions (ALS) and using data model reports. And also involved in a creation of views and procedures to calculate the loan commitment details withdraw amounts and the participation amounts.

Responsibilities:

• Analysis of Sources data, analyzing the Oracle Source Objects and identifying the method for migrating data to target.
• Created and used EXTERNAL TABLES for migrating flat file data into target.
• Identified the row migration and row chaining rows and modified the target design to minimize them in the target.
• Created the Staging tables to avoid the lookup on large tables. Developed procedures to load data from staging tables to Target tables.
• Responsible for the creation of Packages, Functions and Procedures
• Performed Testing of the Packages, Procedures and Functions.
• Worked on Crystal reports. Worked on troubleshooting of database connectivity and performance tuning.
• Optimized the performance of the database queries and involved in De-normalization of the queries.
• Worked on Oracle Discoverer 2000.
• Worked on UTL file utility to transfer data from Oracle application to external systems.
• Exported the reports into the required formats
• Developed various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder, and Application Object Library.
• Worked with users through all Software Development Lifecycle (SDLC) phases
• Wrote technical design documents for conversions, extensions, interfaces, and reports
• Recovered troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conducted quality reviews of code developed by other development staff.
• Developed several complex reports using various features like multiple grouping, drill down, parameterized fields, formulas and conditional formatting using Crystal reports

Environment: Oracle Database 9i, Developer 2000, Forms 9i/6i, Reports 9i/6i,Discoverer 2000, Crystal report, TOAD, PLSQL Developer, Sun Solaris 8.0, Windows XP Professional, PL/SQL, Java applications, Shell Scripts.

Confidential, Foster city, CA

Oracle Developer

Responsibilities

• Writing complex SQL queries and PL/SQL procedures and functions to extract data from various source tables.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling
• Designed and developed Oracle Forms & Reports using Forms10g/6i/4.5 and Reports10g/ 6i/2.5. Including Forms based on stored procedures
• Extensive experience with various test efforts like data validation, integrity testing and Unit testing.
• Used Oracle designer to produce the ER diagrams, Dataflow, function Hierarchy.
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.
• Working Knowledge of MS Access advanced functions and VBA
• Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
• Wrote Shell Scripting programs to execute PL/SQL and SQL Files. Wrote the Corn Jobs to schedule the batch files. Written batch files to execute the backend PL/SQL Programs, and Oracle Reports.
• Written shell scripts and executed them as Cron jobs on UNIX.
• Created New and modified Database procedures, functions, triggers and other database objects by using TOAD tool.
• Used UNIX Shell (Korn) Scripts for Extraction, Transformation and Loading of data.
• Responsible for analyzing, designing and coding of the applications by utilizing the Perl
• Providing support for the EWB systems.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.

Environment: Oracle 10g, Forms 10g, Reports10g, Designer 10g , SQL, PL/SQL, TOAD, Perl, SQL *Plus, Windows NT

Confidential, Madison,WI

Oracle Developer

Responsibilities

• Involved in Data Loading and Data Migration.
• Used Erwin to produce the ER diagrams.
• Written SQL scripts, PL/SQL stored procedure, functions, triggers, and packages.
• Implemented materialized views for remote instances.
• Involved in Query Optimization and Tuning tasks.
• Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database.
• Making whole process run through Custom built ETL (SQL*Loader, Shell Scripting, PL / SQL Stored Procedures).
• Developed forms according to user requirements using Forms 6i.
• Designed and developed several matrix and master-detail reports with Oracle report designer.
• Developed Reports using Reports 6i based on client requirements.
• Generate SQL Scripts and create views for reports.
• Scheduled the jobs using cron jobs in UNIX.
• Performed Shell scripting in UNIX to automate the various processes.
• Prepare technical documents for all the programs developed & generated.
• Responsible in coding, trouble shooting and debugging.
• Developed stored procedures, packages and functions for the application that could be called by Forms & Reports.
• Developed complex reports like matrix reports, tabular reports for the systems using running totals, sub totals, grand totals and daily balance.
• Developed new Data Input forms and Reports using Oracle Forms and Reports builder.
• Written scripts to create Temporary tables in various schemas and Audit Transactions.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.

Environment: SQL, PL/SQL, SQL * Loader, Windows 2000/XP, Oracle 9i, Forms 6i, Reports 6i, TOAD 6.4