SUMMARY:

• More than 7+ years of IT experience with designing, developing and implementing database applications and solutions using best of breed technologies and programming languages
• Experience in Oracle 10g/9i, SQL, PL/SQL Programming, Data LOADER, Oracle Forms 10g/6i, Oracle Reports 10g/6i, HTML, Quest Toad, Adobe Reader/Writer, MS Office Suite
• Good understanding of relational databases and extensive experience in database development Stored Procedures, Packages, Functions, Views, Cursors and Database Triggers
• Creation of Table scripts, database triggers
• Translating business requirements into creation of database objects: Tables, Indexes, Constraints, Triggers, Stored Procedures, and Materialized Views
• Very good knowledge about operating systems like Windows Microsoft 98/2000/XP/Win Vista/Win 7, Dos, Linux4/6
• Basic knowledge of Pro C, C, C++, JAVA and other programming languages
• Good at troubleshooting problems regarding the databases and applications
• Excellent communication skills and understanding of business workflow
• A hardworking and well - organized individual accustomed to working on own initiative and in terms of any size and constraints. With high level of commercial awareness and excellent leadership and communication skills
• Highly administrative and decision making qualities.
• Ability to work under tight deadlines while handling multiple tasks.
• Good communication skills (written and verbal) to enable effective interaction with both technical and non-technical people
• Ability to work independently and as a team player.
• Ability to work on multiple projects
• Exceptional customer service skills.
• Strong organizational, multi-tasking, and time-management skills
• Ability to work under pressure and be highly adaptable.
• Ability to use own initiative and good attention to detail.
• An interest in technology and desire to work in a software business
• Ability to manage multiple tasks and competing priorities effectively under pressure.
• Skilled in using MS SQL Server tables, views, stored procedures, Packages and Normalization
• Strong knowledge and experience of Oracle DBMS and related products (PL/SQL, SQL*PLUS)
• Ability to develop, execute, and manage Oracle PL/SQL as well as SQL both Data Definition Language (DDL) and Data Manipulation Language (DML)stored program units such as a procedures, functions, packages and database triggers as well as debugging program code
• Knowledge of basic troubleshooting of Window XP/Windows 7 and installation
• Strong working knowledge of MS Office tools, including MS Word, MS Excel and Visio
• Outlook WinZip

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Java, C/C++, HTML

Databases: MS SQL Server 2000, Oracle 9i/10g/11g, MS Access

Application Servers: Application Server 9i

Development Tools: Forms 6i/9i/10g, Reports 6i/9i/10g, Query Builder, TOAD, PL/SQL, Data Loader

Operating Systems: Windows 98, 2000, XP, Win Vista, Win 7, MS-DOS, Linux4/6

Packages: MS Office Suite

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Developer

Responsibilities:

• Created new Forms and Reports using Oracle Forms 6i/Reports 6i for MFIMS System.
• Written function, procedure, triggers, cursors, and views for system module.
• Constructed and implemented multiple-table links requiring complex JOIN statements, including outer-joins and inner-joins.
• Used Oracle PL/SQL tables, ref cursors to process huge volumes of data
• Wrote complex Oracle SQL using joins, sub queries and correlated sub queries
• Used SQL*Loader to load data from a file into Oracle tables
• Fine tuned database procedures and Oracle PL/SQL scripts for performance tuning
• Worked on development and maintenance of SQL code embedded in Oracle PL/SQL
• Supported the production issue solutions to ensure system availability
• Created Stored Procedures for data transformation purpose.
• Generated new and modified existing reports.
• Created and maintained various reports.
• Created new reports using reports 6i for MFIMS application.
• Involved in requirement gatherings and user meetings.
• Maintenance and support for the existing Oracle Forms 6i and Reports 6i.
• Involved in the Testing and Documentation.
• Ensures adherence to data management regulations and policies.

Environment: Oracle 10G,HTML, PL/SQL, SQL, SQL*Loader, SQL*Plus, Oracle Forms Builder 6i, Oracle Reports Builder 6i

Confidential, CA

Oracle Developer

Responsibilities:

• Developed the front end using Forms 9i/10g and Oracle9i as back end.
• Wrote Procedures, Functions, and Triggers & Database Packages.
• Analysed, built, tested and debugged, fixed, and re-deployed Oracle Forms 10g and Reports 10g code components and outputs (if and as required).
• Generated SQL and PL/SQL scripts to install, create and drop trading exchange connection database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms
• Responsible for capacity planning, Oracle database monitoring and performance tuning of Production databases
• Involved in Oracle PL/SQL debugging and support
• Created Triggers at Form level, Block level, Item level, Alerts, Procedures.
• Involved in business development life cycle, Oracle Forms, Oracle Reports and Oracle PL/SQL programs.
• Fine-tuned PL/SQL Procedures for better performance
• Modifying library and menu item for the forms.
• Worked with the end users and higher management to gather requirements for forms/reports.
• Responsible for resolving all the critical issues relating to oracle forms and reports.
• Responsible for reviewing and confirming forms/reporting requirements as outlined by end-users.
• Work with end users to train them in using the application.
• Used SQL/TOAD to query complex relational databases and validate reporting results

Environment: Oracle 10G, SQL*Loader, SQL, SQL*Plus, PL/SQL, TOAD, Oracle developer, Oracle Forms Builder 6i, Oracle Reports Builder 6i

Confidential

IT Officer

Responsibilities:

• Developed new Custom Forms and Reports for oracle E-Business Suite R12 using Forms/Reports 6i/10g and Oracle9i as back end
• Developed custom reports by writing stored procedures and functions using PL/SQL in Oracle 9i/10g for the Financial Module (AP, AR, Inventory and purchasing) according to business requirement of KTML
• Provided and overview of reports and Forms to business users prior to launch
• Documented created reports, forms and/or changes to existing reports
• Wrote Procedures, Functions, and Triggers & Database Packages
• Constructed and implemented multiple-table links requiring complex JOIN statements, including outer-joins and inner-joins
• Created Triggers at Form level, Block level, Item level, Alerts, Procedures, Visual Attributes, etc
• Fine-tuned PL/SQL Procedures for better performance
• Modifying library and menu item for the forms
• Worked with the end users and higher management to gather requirements for forms/reports and data analysis for Oracle application
• Responsible for resolving all the critical issues relating to oracle forms and reports for Oracle application
• Responsible for reviewing and confirming forms/reporting requirements as outlined by end-users
• Worked with end users to train them in using the application
• Used SQL/TOAD to query complex relational databases and validate reporting results written DML scripts to perform actions on the data based on business requirements

Environment: Oracle10g, Oracle Forms 10g Builder 6i, Oracle Reports10g Builder 6i, Application server 9i, PL/SQL, SQL*Plus, TOAD, Data Loader, Windows XP