Summary:

• Over 10 years' experience in commercial application design and development, testing, reverse engineering Oracle Developer/2000 tool sets in Windows NT.
• Excellent skills in designing and development of applications using Oracle 11g/10g/9i/8i/7.2, SQL, PL/SQL Good knowledge on Oracle tools like SQL PLUS, PL/SQL, SQL and used TOAD in many development projects.
• Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms.
• Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.
• Experience in Bulk Data loading using Oracle utilities namely SQL Loader and External Tables.
• Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle database issues.
• Worked on Dynamic SQL, Oracle Hints.
• Worked on Crystal Reports.
• Experienced in DB Design, Oracle Forms reports, PL/SQ Development and DBA.
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL Loader and UTL File Utilities.
• Experience working in both Data Warehouse and OLTP environments.
• In-depth development experience with warehouse or OLAP based technologies, preferably on Oracle's 10g OLAP or Express platforms, to include all phases of the software development lifecycle, including production support.
• Proven track record of database design and modeling.
• Good knowledge of Data Modeling using ETL tools, OLAP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.
• Team Player with ability to maintain team spirit and resolve conflicts within the team with ease and calmness. Ability to drive team with ideas and thoughts and keeping everyone engaged.

Technical Skills:

Front-end tools/Utilities

TOAD, SQL Navigator, Oracle Sql Developer, Dreamweaver 4.0, Crystal Reports. Oracle Forms and Reports.

Databases:

Oracle 11g/10g/9i/8i,7.2, Access 2007, and MySQL.

ETL Tool:

SQL Loader

Programming:

C, C , Java, JavaScript, SQL, PL/SQL, UNIX, XML, Linux, Apache, PHP, HTML, CSS, Visual Basic.

Operating Systems:

Windows 7, Windows XP/2003/2000/NT/98/95, UNIX, LINUX.

Status: US Citizen.

Confidential

Programmer Analyst

Responsibilities:

• Provide production support for SCDE Supply Chain Data Exchange application.
• Transform the data from flat files using SQL Loader, SQL Plus, and Sql Developer.
• Performance tuning and optimization of SQL statements.
• Writing packages, complex stored procedures, functions, views, and data base triggers using SQL and PL/SQL in Oracle.
• Schedule Oracle jobs for update, validate data and create vendor reports for analysis.
• Use Oracle Collections, Bulking techniques, Partition utilization to increase performance.
• Guide and code review of junior developers,
• Interact with the clients, collect requirement, and develop technical specification.

Environment: Windows 7, Oracle11g, PL/SQL, SQL PLUS, SQL Loader, Oracle Jobs, Sql Developer, HTML, JavaScript.

Confidential

Senior Oracle Developer

Responsibilities:

• Performance tuning and optimization of SQL statements.
• Writing packages, complex stored procedures, functions, views, and data base triggers using SQL and PL/SQL in Oracle.
• Designed, Developed Inquiry Counters, Inquiry Counters Detail, and Inquiry Counters Trend Applications.
• Support Developed, Designed and Tested Purchase Order Inquiry forms, Vendor On Hold Forms.
• Schedule Oracle jobs for update, validate data and create mortgage reports for analysis.
• Modules used are Loan Management, Refinance Management and BOM.
• Use Oracle Collections, Bulking techniques, Partition utilization to increase performance.
• Interact with the clients, collect requirement, and develop technical specification.
• Transform the data from flat files using SQL Loader, SQL Plus, and TOAD.

Environment: Windows 7, Oracle11g, PL/SQL, SQL PLUS, SQL Loader, Oracle Jobs, TOAD, HTML, JavaScript, and MKS.

Confidential

Role: Sr.Oracle Developer.

Responsibilities:

• Attended daily Scrum meetings with the team for daily updates on the projects.
• Self-starter, with ability to work in a team environment and as an individual.
• Collect requirements from the customers and prepare Business, Functional and Technical Documents.
• Working experiences using SQL Loader, SQL Developer, SQL Plus, and TOAD.
• Maintain and modify PL/SQL programs.
• Strong experience on SQL and PL/SQL performance tuning using Tkprof /EXPLAIN/SQL Trace.
• Data Modeling, Data Warehousing, PL/SQL, ETL processing.
• Managing Oracle objects including tables, indexes, views, constraints, db links, jobs, snapshots, etc.
• Worked extensively on 15 TB Oracle Data Warehouse, designing, writing specifications,
• and writing SQL and PL/SQL on a daily base, including Functions, Procedures, Packages, Triggers and ETL Processes. Special attention was given to performance using ALL Oracle newest features like Analytical Functions, Index Organized Tables, Function Based Indexes and Exchange Partition.
• Ability to write well-abstracted, reusable code for all modules.
• Extensively used BULK COLLECT Implicit/Explicit Cursors , FORALL statements for bulk binding, Partition Utilization to increase performance.
• Used Data Pump, Export/Import, and Oracle Scheduler.
• Troubleshoot/Resolve any Database/Application issues.
• Written Perl and Shell script to upload files, images from User Interface.
• Design, Develop and Maintain of related Forms and Reports.
• Reviews, designs, tests, implements and maintains Crystal Reports.
• Codes complex stored procedures in Oracle for use by the Crystal Reports.
• Developed advanced database driven Web Applications.
• Managed multiple assignments, set priorities and meet deadlines..
• Documenting features, technical specifications infrastructure requirements.
• Used TOAD to develop all Oracle objects.

Environment: Windows NT 4.O. Windows XP. Unix, Perl, Oracle 10g,11i , Dynamic SQL, PL/SQL 8.0, SQL PLUS,TOAD,HTML,JavaScript , LAMP, VB 6.0. And MKS

Confidential

Responsibilities:

• Responsible for complete development lifecycle from requirement gathering till Go Live and warranty support.
• Attended daily scrum meetings with the team for daily updates on the projects.
• Should be able to effectively handle team up to 4 members in onsite-offshore model.
• Review work done by other developers before delivery.
• Should provide post implementation support to fix the production issues.
• Communicated with different client, team members, project managers, and co-workers.
• Participate in technical discussions. Come up with innovative ways to improve the product and process.
• Strong PL/SQL, SQL experience writing Packages, Procedures, Functions, Triggers, Views, DB Links, Synonyms etc
• Designed developed code using ORACLE Dynamic PL/SQL, SQL, FORMS, HTML, CSS, JavaScript, and TOAD.
• Develop and maintain interfaces to/from external systems and custom code in accordance with business requirements.
• Performed key role in cross-functional teams through development, testing, and product launch.

Environment: Windows NT 4.O. Windows XP. Unix,Oracle 10g,11i , Dynamic SQL, PL/SQL 8.0, SQL PLUS,TOAD,HTML,JavaScript , VB 6.0. And MKS

Confidential

Responsibilities:

• Attended daily scrum meetings with the team for daily updates on the projects
• Communicated with different client, team members, project managers, and co-workers
• Worked with Business Analysts and customers to understand and validate end-user requirements in accordance with business need.
• Develop PL/SQL packages, Procedures, Functions, Triggers by Using TOAD.
• Developed advanced Web Reports by using PL/SQL, SQL, HTML, JavaScript, and CSS.
• Managed multiple assignments, set priorities and meet deadlines.
• Performed key role in cross-functional teams through development, testing, and product launch.

Environment: Windows NT 4.O. Windows XP. Unix,Oracle 10g,11i , Dynamic SQL, PL/SQL 8.0, SQL PLUS,TOAD,HTML,JavaScript , LAMP, VB 6.0. And MKS.