SUMMARY:

• Extensive experience in Oracle RDBMS design and developing Stored Procedures/Packages, Triggers, Cursors using SQL and PL/SQL using the Oracle Database 12c Release 1: 12.1.0.1
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Knowledgeable in JAVA (J2EE, Javascript), HTML5, CSS3, ADP.NET, MVC5 Entity Framework 6.1.and C#, AJAX, JQuery, AJAX, JSON, XML, CSS and HTML.
• EDP experience encompassing System Design/Development and Implementation Skill in Oracle RDBMS and other Programming Languages.
• Over 25 years of IT experience and over 15 years in Oracle related fields.
• 4 years of experience in Analysis, Design, Development and Deployment of Data Warehousing applications using Cognos ReportNet 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.
• Extensive knowledge of SQL, PL/SQL, FORMS (4.50/5.0/6i/10g), REPORTS (2.5/3.0,10g), SQL*Plus.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, and SQL*Navigator, PL/SQL Developer, Toad for Oracle 12.0
• 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:

Software/Hardware: DEC-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 v 1.5/2.1/2.2/6 i, 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 Suitev.8.0, PL/SQL Language.

EXPERIENCE:

Confidential

Senior Application Developer

Responsibilities:

• Develop efficient PL/SQL programs to access Oracle databases in Oracle Database 12c Release 1: 12.1.0.1. 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.
• Upgraded 6i client server Oracle Forms and Reports application to web based 10g and ran the application through Oracle Portal and Single Sign-on.
• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.
• Designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures
• Created MS Excel VBA custom application for Investment Finance.
• Developed MS Access application for Corporate Finance.
• A year experienced 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.
• A year experienced implementing standards based front-end development (HTML5, XHTML5, JavaScript, CSS3).

Confidential, Trumbull, Connecticut

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, New Jersey

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 department.

Confidential, Ann Arbor, Michigan

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, Iowa

Oracle PL/SQL Developer

Responsibilities:

• Involved in defining system requirements, designing & prototyping, developing, testing, 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.
• Using Oracle tools utilities SQL Loader v.8.0. 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 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.
• Designing forms, integrating 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.
• Provides 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.
• Also 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.1

Confidential

Systems Analyst

Responsibilities:

• Involved in defining system requirements, designing & prototyping, developing, testing, 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, 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 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.
• Designing forms, integrating the sales support system with the existing system which had all the modules like Employee information, 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.
• Provides 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.
• Also involved in the GUI design as an active member of the team.
• Report generation for various data tables for each module, using Impromptu.
• Create / Modify complex report using Cognos Impromptu Reports on Oracle RDBMS.
• ConvaTec System
• Chargeback (Account Receivable)
• Customer Service Management (CSM)
• Order Management System (OMS)
• Support 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.

Confidential

Application Support Analyst

Responsibilities:

• Performed, developed and maintained programming to the VIP (In-House) System using PL/SQL (stored procedure/functions/triggers) v.2.0, SQL*Loader v7.1.3.0, SqlPlus v.3.30/8.0.
• Created new report using Crystal Reports 6.0/v. 8.0.10./9.0/10.0. using multiple data sources. Responsible for designing, writing in-depth crystal reports, using drill downs, creating graphs, charts and sub reports and other crystal report features, and implementing the necessary security.
• Administered and created catalog and reports using Impromptu Cognos v. 7.0. migrated to Reportnet v.1.1 afterwards using Transformer 7.0. Maintaining cubes for PowerPlay 7.0.
• Conducted/Reviewed the requirements and assessed Users request and make a resolution on the Financial Reporting, from end-to-end testing up to the user acceptance.
• Deployed reports in the web using JAVA / HTML scripts.
• Administered/Maintained/Modified code for Payroll System using MS Access2000/VbA and Excel2000.
• Lead the conversion of JDEdwards System and ADP Payroll database to Oracle RDBMS using Oracle tools utilities SQL Loader v.8.0. and SQL*Navigator v.4.0.
• Assisting in the development or modification of Software Quality Assurance methodologies and Quality plans. Responsible for software optimization, project and software change management, maintenance, integration, and system support strategy and policy.
• Resolved any other technical issues other than above (e.g. network problems, software installation and upgrade, installation of ODBC to each client).
• Assisting in maintaining system documentations for future s and help keeping website up-to-date.
• Worked with a team and independently with minimal supervisions. Ability to prioritize multiple, competing tasks and demands.
• Created new forms for Oracle Financial v.10 using Developer2000 Forms 4.5/5.0.

Environment: HP-UX B.11.0 / 4500, Oracle RDBMS v.7.3 /8.0/8i, Dell Optiflex / Windows NT 4.0/Windows 2000.Impromptu and PL/SQL, TOAD, ERWIN, SQL*Navigator

Confidential

Programmer Analyst

Responsibilities:

• Planned and designed creation for all modules and developed all user input screens.
• Performed the data analysis of the requirements.
• Analyzed the data, normalized the data and created the ER diagrams.
• Created the Physical databases.
• Developed the User interface using the Oracle Forms.
• Wrote the required stored procedures and triggers.
• Tuned the stored procedures and the database for the better performance.
• Created the Reports using the Cognos impromptu.
• Coded and debugged triggers at various levels and involved in testing of each module.
• Used Oracle 9i application Server for deployment of applications pertaining to various modules.
• Documented each module for user level and system level maintenance
• Performed maintenance programming to the Confidential Pension Trust System (OPTIMS) using PL/SQL (stored procedure/functions/triggers) v.2.0, Forms/Reports, SQL*Loader v7.1.3.0.
• Created, modified, enhanced OPTims using FORMS 3.0/4.5/5.0/6 i.
• Created new forms in Oracle Financial v.10 using Developer2000 Forms 4.5/5.0.

Environment: DEC-VAX 00, Oracle RDBMS v.7.3 /8i, Compact Proliant 1600/6000 Windows NT 4.0