SUMMARY

• Over 5 Years of experience as Oracle developer and in Software Development Life Cycle (SDLC) process by performing the Requirement Analysis, Architectural Design, Coding and Debugging, Testing, Implementation, Maintenance of Business Application Systems. Strong Business and Application analysis skills with excellent communication & professional skills
• Extensive experience in Client/Server application development, implementation with solid programming and analytical skills and system design
• Technical Expertise in Software Development using Oracle server (11g/10g /9i /8i), PL/SQL and SQL, UNIX
• Expert level skills as an Oracle backend developer including stored procedures, packages, functions, cursors, triggers, constraints, views, DDL, UNIX scripting and Perl
• Hands - on experience in creating tables, sequences, indexes and also in setting up roles, users and security
• Expert level skills in handling materialized views including tuning, system packages
• Performed export/import of data using external tables and datapump in 10g, UTL FILE and sql*loader
• Worked on collections such as PL/SQL tables, and created and monitored batch jobs using BULK COLLECT, FORALL
• Tuned SQL queries and performed refinement of the database using Explain Plan, SQL Trace, TKPROF leading to significant improvement in response time and efficiency
• Working experience with applications such as forms 6i/9i/10g, reports 6i/ 9i/10g
• Sound knowledge in oracle memory structure, background processes, performed RMAN backup and Recovery
• Proficient in data modeling tools such as Erwin, Embarcadero, E R Studio
• Extensively worked on UNIX and RED HAT LINUX platforms with Oracle databases
• Experience in developing Pro* C, C codes
• Sound knowledge and experience in DWH concepts, data mart, ETL and informatica
• Experience with Learning Management System (LMS) designed on .NET framework
• Excellent talent to quickly adapt to different project environments.

TECHNICAL SKILLS

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2000, 2005

Rational Tools: Clearcase, Clearquest

Oracle Tools: Development TOAD 7.3, PL/SQL Developer 7.0.0, SQL Developer, SQL +, isql*plus, Text Pad, SQL*Loader

Languages: SQL, PL SQL, Pro*C, C, C#, Unix Shell (K-shell), Visual Basic

GUI: Forms 6i, 9i, 10g, Reports 6i, 9i, 10g, Designer 9i/10g

Web Technologies: HTML, XML, XPATH, XSLT, JavaScript, ASP.NET

Tools: Visual Studio 2005, Visual Studio 2003, Erwin, E R Studio, Embarcadero

O/S: UNIX, Red Hat Linux, Windows95/98/2000/XP/Vista and MS-D0S

PROFESSIONAL EXPERIENCE

Confidential

Oracle developer

Responsibilities:

• Analyzed new business requirements and major developments
• Prepared Analysis Document, Design Document, Low Level Design & Unit Test Plan
• Documented impact analysis for the proposed changes
• Prepared System Test Plan, Functional Specifications, User Manual, and Data Model using the normalization process
• Developed and finalized data models including physical and logical models
• Interacted with client through meetings & presentations
• Involved in developing various Forms, Reports, Procedure, Functions and the PL/SQL libraries to support the GUI application
• Worked on creating stored procedures, functions, triggers and packages
• Worked on performance tuning using the execution plan, explain plan and oracle HINTS
• Worked on Ref cursors, materialized views and table partitioning, index creation for the better performance
• Refreshed materialized views using DBMS MVIEW
• Performed tuning by creating materialized views to reduce repeated I/O
• Partitioned base tables and also performed parallel DML for quicker refresh of materialized views
• Created and maintained schemas for new users using Oracle datapump in Oracle 10g and OEM
• Used external tables to load large flat files in the database
• Performed faster batch processing to increase efficiency using new features of Oracle
• Provided Production Support & User Acceptance Testing Support
• Used informatica in performing ETL
• Developed components (Pro*Cs, C, Unix Shell Scripts)
• Coded Unix Shell Scripting for job automation
• Shared domain knowledge within & across projects
• Provided DBA support and troubleshooted LMS front end .NET application
• Performed debugging within & across projects

Environment: Oracle 10g, PLSQL Developer, Toad, SQL Developer, Reflection, E R Studio, Unix (HP UX)

Confidential

Oracle developer

Responsibilities:

• Interacted closely with the end users to gather requirements and iteratively tested the usability of the User Interface design throughout the software development life cycle
• Redesigned the database schema for Management Systems in Oracle 10g
• Extensively Worked with Oracle to create the users, tables, indexes, user defined functions, and stored procedures
• Loaded data from flat files using sql*loader, external tables
• Tuned pl/sql queries for faster performance using DBMS OUTPUT, SQL Trace, and table partitions using range
• Created and developed materialized views

Environment: Oracle 10g, forms 9i, Sql loader, Toad, Redhat Linux

Confidential, Pittsburgh

Oracle PL/SQL Developer

Responsibilities:

• Participated in SDLC of software processes and on Oracle db 10g
• Discussed, analyzed and assisted in decision making for various requirements
• Analyzed design requirements for various domains and created logical/physical data models using Microsoft VISIO
• Created and developed from scratch procedures, functions, packages for data driven application
• Created heavily views, materialized views, triggers, for data retrieval over various domains
• Refreshed and maintained materialized views on a regular basis
• Created database links, synonyms, export/import scripts to access data between databases
• Worked heavily on ref cursors, pl/sql tables, collections, objects, types in oracle
• Created indexes, partitions, and performed export/import operations at database level
• Performed tuning for efficient performances and quicker data retrieval
• Performed unit testing, functional testing and created test scenarios for every stage
• Assisted with front end .NET applications in designing efforts

Environment: Oracle 10g, UNIX (Sun Solaris), SQL developer, PVCS, MS Visio, OEM

Confidential, St. Louis

Oracle/Web Developer

Responsibilities:

• Assisted with the automation of schema changes through the ETDC development and tested the databases
• Built an automated tool to facilitate schema promotion process to meet testing needs of Central Data, AIM as additional database environments were spawned
• Accommodated data population by creating database links to individual websites through the DBA promotion tool
• Facilitated data population for release managers by providing the ability to enable/disable constraints at schema level
• Created audit logs to track schema alterations during data population
• Created and customized Oracle Forms 10g
• Created triggers to monitor various operations on the DBA tool
• Created Users, Setup Roles for access to the tool and logged user entries
• Created and developed Ref Cursors and PL/SQL libraries to support GUI
• Created and developed materialized views to generate budget reports
• Tuned PL/SQL batch jobs using BULK COLLECT, FORALL
• Performed ETL transactions
• Coded Perl scripts for moving database items and creating directories
• Tracked and controlled the dependencies between CQs
• Enhanced GUI features on the DBA Promotion tool using ASP.NET
• Accessed DBA role in performing Backup/Recovery, startup/shutdown of database when necessary
• Created web forms to submit CQs
• Worked on Fixed Income, Cash Management and Alternative investment products with strong representation in both retail and institutional channels

Environment: Oracle 10g, TOAD, Oracle Forms 10g UNIX (HP UX), PL/SQL, PERL scripting

Confidential

PL/SL Developer

Responsibilities:

• Conducted Requirements Definition, later translated the requirements into logical and physical data model for various applications
• Worked very closely with global development team and developed those applications where appropriate
• Interacted with the traders and the other end users for requirements gathering, demonstrations and supported issues and credit derivatives systems in a helpful and professional manner
• Followed defined change control procedures to ensure an orderly roll-out of systems and to maintain the stability of existing systems
• Performed ETL using Toad
• Followed defined development methodologies when possible and to make efforts to re-use and share developments
• Extensively used SQL Loader to load data from flat files (excel/access) to Oracle database

Environment: Oracle 9i, Forms 6i/Reports 6i, PL/SQL, Visual Basic