PROFESSIONAL SUMMARY

• Over 7 years of experience creating and maintaining processes and applications using PLSQL packages, triggers, procedures, etc. Oracle Forms, Oracle Reports.
• More than 2 years tuning Oracle OLTP and OLAP applications.
• Played major role in analysis, development and deployment for a Data Migration Project in a Fortune 100 company including onsite support in the US.
• Over 1 year using case-tool Oracle Designer.
• Extensive knowledge of entire system's life cycle.
• Industry experience includes insurance, healthcare, government, financial and marketing.

Databases:

Oracle 6i, 9i 10g, SQL Server 2005, Access.

Software and Tools:

Oracle Forms 10g, Oracle Reports 10g, SQL Loader, Oracle Designer 6i, SQL Developer, Toad, Visual Basic 6, Microsoft Visual C 6, Embarcadero.

Languages:

PL/SQL, SQL, C , C, C .net, VBS, ASP.

Packages:

Lotus Notes, MS Outlook, MS Excel macros, dynamic reports , MS Power Point, MS Word.

Operating Systems:

Windows, UNIX, Linux, DOS.

App Servers:

OAS, Apache

Confidential

Senior Oracle Consultant

• Performance Project: Working with OLTP and OLAP applications, using TKPROF and EXPLAIN PLANS tools. The project was to improve performance and reduce waiting times on top 20 most time consuming processes.
• Responsible for the improvement on the data relabeling process used by the Oracle VPD virtual private database successfully reducing times at 70 .
• Improved performance on main month end financial reports, reducing times from 13hrs to only 40 minutes.
• Improved performance OLTP applications using TKPROF and EXPLAIN PLANS, reducing user wait times and increasing productivity.
• Worked on Tier 1 for Data Migration Project, improving elapsed times around 70 for transformation/pull of data.
• Data Migration Project: By working directly with a Fortune 100 company, being responsible of the insurance module, analyzing, developing and deploying all changes related. Worked onsite with client in the USA giving onsite support to dry run s and releases dates. Using performance knowledge to improve whole process.
• Successfully migrated over 500,000 customer's data from an old system to an already existing Oracle system.
• Attended meetings with business users to discuss new changes, giving ideas and best ways to achieve user's requests.
• Collaborated with BA's to modify/clarify BRD's documents and CR's documents all together with business user.
• Create and maintain Oracle objects package, store procedures, db links, indexes,
• Worked on the performance improvement of the whole migration process, validating table statistics, explain plans, number of nods running on the database, trace files.

Technologies Oracle 10g, Oracle Forms 10g, Oracle Reports 10g, Toad, SQL Developer, Oracle VPD.

Confidential

Senior Oracle Consultant

• PAC Project: Being the Technical lead on a project to create a new system. From the analysis, development and deployment, designed the ER diagram, getting in touch with user to generate mockups and final screens.
• Created entire ER diagram using oracle designer.
• Developed and maintained system using Oracle Forms and Reports.
• Developed triggers, store procedures, packages and functions on PL/SQL.
• Analyzed users' requirements, giving best approaches.

Technologies: Oracle Forms10g, Oracle Reports 10g, Oracle Designer, Toad for Oracle.

Confidential

Oracle Consultant

• Developed new forms and reports using Oracle Forms/Reports as well as to analyze errors in the production database. Worked in conjunction with India Offshore team.
• Analyzed and fixed existing errors in Production Database.
• Developed new forms and reports using Oracle Forms.
• Created and maintained shells in UNIX.
• Created triggers, stored procedures, packages and functions on PL/SQL.

Technologies: Oracle Forms 10g, Oracle Reports 10g, Toad for Oracle, Pro C, PL/SQL, and UNIX

Confidential

Oracle Consultant

• Worked with Oracle Designer, Oracle Reports and Oracle Forms with WebUtil
• Created forms using CASE tool Oracle Designer.
• Maintained ERD using Oracle Designer.
• Developed triggers, store procedures, packages and functions with PL/SQL.

Technologies: Oracle Designer, Oracle Forms 10g, Oracle Reports 10g.

Confidential

Oracle Developer

• Developed new forms and reports using Oracle Forms/Reports as well as to analyze errors in the production database. Worked in conjunction with India Offshore team.
• Analyzed and fixed existing errors in Production Database.
• Developed new forms and reports using Oracle Forms.
• Created and maintained shells in UNIX.
• Created triggers, stored procedures, packages and functions on PL/SQL.

Technologies: Oracle Forms 10g, Oracle Reports 10g, Toad for Oracle, Pro C, PL/SQL, and UNIX.

Confidential

Developer and Database Analyst

• Responsible for elaborating the data mining as well as for creating reports for display trends of marketing campaigns.
• Improved users' response, loaded information faster and created batch files.
• Worked with Data mining with oracle PL / SQL creating universes, trend analysis, tracking customers' response for new marketing campaign .
• Created reports using Oracle Developer, in order to display trends for marketing campaigns.
• Helped updating the client's information by merging the data between Access and Oracle databases.

Technologies: Oracle Forms 6i, Oracle Reports 6i, Toad for Oracle, PL/SQL, and Access 2005.

Confidential

Oracle Developer

• Developed forms and reports by using Oracle in order to help the clients system migrate from Oracle 6i to Oracle 10g.
• Developed project, implemented Oracle Forms and Oracle Reports.
• Maintained and configured the database.
• Development and maintained web pages in Dreamweaver.

Technologies: Oracle Forms 6i, Oracle Reports 6i, Toad for Oracle, Dreamweaver

Confidential

Programmer

• Created small system to control help desk tickets.
• Created small system using C .net to have control of the help desk tickets.
• Designed and developed Web sites using ASP, JavaScript, AJAX and C in Visual Studio Net.
• Helped the QA team to test new changes on existing system.

Technologies: Microsoft Visual Studio .Net 2005, Toad for Oracle, ASP, JavaScript, AJAX, Access 2005