SUMMARY:

• 10+ years of experience in PL/SQL.
• 10+ years of experience in Oracle.
• 2 years of experience in SQL Server.
• 4 years of experience in VBA.
• 4 years of experience with MS Access.
• 4 years of experience with MS Excel.
• 1 year of experience with UNIX.
• 10 years of experience in Consulting.
• Over 15 years in Oracle related fields.
• High ability to work on SOA and Agile projects
• Extensive knowledge of SQL, PL/SQL, Forms (4.50/5.0/6i/ 10g/1lg/ 12c), REPORTS (2.5/3.0, lOg), SQL*Plus in Oracle RDBMS versions 7, 8, 8i, 9i, 1Og, 11g, 12c.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, and SQL*Navigator, PL/SQL Developer, Toad for Oracle l2.0.
• Extensive experience in Oracle RDBMS design and developing Stored Procedures/Packages, Triggers, Cursors using SQL and PL/SQL.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Experienced in Analysis, Design, Development and Deployment of Data Warehousing applications using Cognos ReportNct v. 1.1, Cognos PowerPlay v.7.3, Cognos Impromptu v.7.3, Cognos Transformer, Cognos Upfront, Security Server (LDAP SuneOne), Web Servers (Apache, IIS) for Oracle environment, MS Access 2000, TIBCO Jaspersoft Studio - 6.5.1, JasperSoft IReport 5.6.0
• MS Access VBA (Forms/Reports/Macros/Modules)
• MS Excel VBA (Forms/ Macros/ Modules/Charts/Pivot tables)
• Data migration and Data validation/Testing through VBA modules between MS Access and MS Excel 2003 and 2007 workbooks.
• Extensively used embedded SQL in VBA front end.
• Created parameter driven reports in Access and Excel running thru Access VBA front-end.
• Excel programming using VBA (Excel macros)
• Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry.
• Used Excel to create script by editing columns of cells, creating a 200+ line script in less han 10 minutes.
• Capable of handling multitasks in a busy work environment.
• Sharp in learning and comprehending new systems and methods.
• Dependable, reliable, troubleshooter and a team player.
• Strong technical and analytical skills with excellent interpersonal and communications abilities.
• An effective team player that is quick to learn and has the proven ability to work independently with minimal supervision.
• Created reports using Crystal Reports v.6.0/v.8.5/9.0 and Cognos Impromptu v.6.3/v.7.0/Reportnet v.1.1/Powerplay 7.0. Used MS-Office Product Tools such as Office2003, Excel2003, FrontPage2003, Access2003, Visio2003, Project2003 and OneNote2003. Heat v.6.0 for help desk or service management solution software.

TECHNICAL SKILLS:

VAX 7600/4500, VMS 6. 1, DCL, Compaq PC/DELL, Windows2000/Windows NT4.0, Oracle v.6/7.3/8.0/8i/9i/10g, Novell NW 4.0, Developer2000 vl.5/2.1/2.2/6i, Designer2000 v.1.3, C#/C Language/MS Access 2000, VBA, HP Enterprise Servers, HP 9000/800, HP-Unix B.11.0, Toad® for Oracle Sllitev.8.0, PL/SQL Language

PROFESSIONAL EXPERIENCE:

Confidential, Troy, Michigan

Oracle Developer/Salesforce Admin

Responsibilities:

• Engaged in Salesforce Administration.
• Oracle RDBMS design and developing Stored Procedures/Packages, Triggers, Cursors using SQL and PL/SQL.
• Used Oracle tools utilities SQL Loader v.8.0. and TOAD 12 and SQL*Navigator.
• Designed and developed Web - enabled Oracle Forms and Reports. Includ ng Forms based on stored procedures
• Created MS Excel VBA custom application for HR Department.

Confidential

Senior Application Developer

Responsibilities:

• Upgraded 6i client server Oracle Forms and Reports application to web based lOg and ran the application through Oracle Portal and Single Sign - on.
• Strong demonstrable experience in systems architecture and N-tier application development using Microsoft's web technology stack (ASP.NET MVC5, C#, IIS6/7/8, ADO.NET, Entity Framework, SOAP/REST Web Services including Web API and WCF, Http Handlers, Http Modules. Java8, jQuerySpring Framework, JSF, Jasper Reports, Migration Plan
• Strong experience implementing standards based front-end development (HTML5, XHTML5, JavaScript, CSS3).
• Developed efficient PL/SQL programs to access Oracle databases. Manage data retrieval for front-end applications
• Designed and created an interface between custom application and accounting application
• Mentored junior programmers in Oracle database design and development.
• Assisted in setting up the Forms and Reports Services on standalone 1Og App Server.
• Designed and developed Web-enabled Oracle Forms and Reports. Incl udi ng Forms based on stored procedures
• Created MS Excel VBA custom application for Investment Finance.
• Developed MS Access application for Corporate Finance.

Confidential, Trumbull, CT

Oracle PL/SQL Developer/Crystal Developer

Responsibilities:

• Wrote Pl/SQL stored procedures and trigger.
• Coded and debugged triggers at various levels and involved in testing of each module.
• Responsible for writing necessary UNIX Scripts.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Documentation of the Newly Developed ETL System.
• Other task that not assigned to help to accomplish important to IT department.

Confidential, Hopewell, NJ

Oracle PL/SQL Developer/Crystal Developer

Responsibilities:

• Developed VBA Application on Excel Spreadsheet.
• Created reports like: Stockwise Report in Crystal Reports v.9. Used Discoverer/2000 to build and provides a business - like representation of the complex data held in the applications systems.
• Wrote Pl/SQL stored procedures and trigger.
• Coded and debugged triggers at various levels and involved in testing of each module.
• Responsible for writing necessary UNIX Scripts.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Other task that not assigned to help to accomplish important to IT departmen t.

Confidential, Ann Arbor, MI

Oracle PL/SQL Developer

Responsibilities:

• Wrote PL/SQL stored procedures and trigger.
• Created Reports like: Customer Bill Invoice, Customer Transaction listing Report in Crystal Reports v.9.
• Coded and debugged triggers at various levels and involved in testing of each module.
• Responsible for writing necessary UNIX Scripts.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Wrote complex SQLs using joins, sub queries and correlated sub queries.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.

Environment: Oracle 9i/10g, Crystal Reports v. 10, SQL, SQL*Navigator, PL/SQL, HP-UNIX, OADv.8.6, Visual Source Safe v. 6.0, WRQ-Reflection for HP-Unix v.9.0

Confidential, Ames, IA

Oracle PL/SQL Developer

Responsibilities:

• Involved in defining system requirements, designing and prototyping, developing, testing, training and Implementation of the application.
• Involved in Data Modeling.
• Implemented the business rules by writing Oracle PL/SQL Functions and Procedures.
• Worked with the users to identify the business requirements and integrated them into the Oracle Application s.
• Used Oracle tools utilities SQL Loader v.8.0. and TOAD 12 and SQL*Navigator.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Wrote complex SQLs usingjoins, sub queries and correlated sub queries.
• Involved in the design, development, testing and maintenance of the application.
• Performed data analysis using Erwin.
• Responsible for analyzing, designing and coding of Customer Requirement, Material Management, Customer Invoices and Customer transaction listing.
• Designed forms, integrated the sales support system with the existing system which had all the modules like Employee information, Inventory, Customer, Vendors, Brokers Information.
• Troubleshot production problems and worked effectively with other team members to identify and address problems.
• Provided input into project plans for database projects providing timelines and resources required.
• Responsible for writing Stored procedures, triggers, various functions.
• Wrote Pl/SQL stored procedures and trigger.
• Created Reports like: Customer Bill Invoice, Customer Transaction listing, Customer wise Report, Material Stock wise Report in impromptu.
• Coded and debugged triggers at various levels and involved in testing of each module.
• Responsible for writing necessary UNIX Scripts.
• Involved in the GUI design as an active member of the team.

Environment: Oracle 9i/10g, Developer 2000, Oracle Forms and Oracle Reports, SQL, SQL*Navigator, PL/SQL, UNIX, TOAD, Erwin v.4. l

Confidential, Oakville, Ontario

Systems Analyst

Responsibilities:

• Involved in defining system requirements, designing and prototyping, developing, testing, training and Implementation of the application.
• Involved in Data Modeling.
• Implemented the business rules by writing Oracle PL/SQL Functions and Procedures.
• Worked with the users to identify the business requirements and integrated them into the Oracle Applications.
• Participated in system analysis, data modeling and database designing which included creating tables, viewsindexes, synonyms, triggers, procedures and packages.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Wrote complex SQLs using joins, sub queries and correlated sub queries.
• Involved in the design, development, testing and maintenance of the application.
• Performed data analysis using Erwin.
• Responsible for analyzing, designing and coding of Customer Requirement, Material Management, Customer Invoices and Customer transaction listing.
• Designed forms, integrating the sales supp01t system with the existing system which had all the modules like Employee infonnation, Inventory, Customer, Vendors, Brokers Information.
• Created Forms through Oracle Form Builder templates as for Form design using Visual attributes, Property Classes, Alerts, Messages, Object groups and toolbars.
• Troubleshot production problems and worked effectively with other team members to identify and address problems.
• Provided input into project plans for database projects providing timelines and resources required.
• Responsible for writing Stored procedures, triggers, various functions.
• Wrote Pl/SQL stored procedures and trigger.
• Created Reports like: Customer Bill Invoice, Customer Transaction listing, Customer wise Report, Material Stock wise Report in impromptu.
• Coded and debugged triggers at various levels and involved in testing of each module.
• Responsible for writing necessary Unix Scripts.
• Involved in the GUI design as an active member of the team.
• Report generation for various data tables for each module, using Impromptu.
• Created/modified complex report using Cognos Impromptu Reports on Oracle RDBMS.
• ConvaTec System Chargeback (Account Receivable) Customer Service Management (CSM) o Order Management System (OMS)
• Supported US customer in maintaining/administering Catalog.

Environment: Oracle 9i, Oracle Forms, Developer 2000, Cognos Impromptu 7.2 and Oracle Reports, SQL, PL/SQL, XML, UNIX, TOAD, Erwin v.4.1, DBloader