SUMMARY

• Over 22 years of experience in designing/developing application software primarily in Oracle with Oracle tools, utilities and database functionality in UNIX (Solaris, HP - UX, AIX, Linux) and Windows Server NT platforms.
• Over 20 years of experience in North America.
• Experience in System Analysis and Design, Database & Application architecture, Data modeling, Programming (Development and Customization), Testing and Integration, Quality Assurance, Implementation, Production and Technical Support, and Documentation of user interface, program units and database applications using Oracle 12c/11g/10g/9i/8.x/7.x and PL/SQL.
• Proficient in analysis of user requirements and transforming them into comprehensive design and functional specifications.
• Extensive experience in design and development of user interface using Oracle Fusion Middleware 12c/ 11g / Oracle Developer Suite 10g (Oracle Forms and Reports versions 12c/11g/10g/9i/6i/5/4.5), Oracle Confidential (versions 19.x/18.x/5.x/4/x) and reporting tools like Oracle BI Publisher, BI/Crystal Reports, SQR etc.
• Competent in design and development of Oracle database objects, including Packages, Procedures, Functions, Triggers, SQL Statements etc.
• Technical/Functional understanding and working experience with Oracle E-Business Suite R12/Oracle Applications R11i with particular emphasis on core modules such as Supply Chain Management, Manufacturing and Distribution, Financial, Workflow etc.
• Highly experienced in developing & personalizing Oracle Forms, Reports and Libraries in Oracle Applications.
• Technical/Functional understanding and development experience with Oracle Retail Product suite and Oracle Health Sciences Application Suite (Oracle Clinical) which includes design, development and deployment at client locations.
• Proficient in Data Modeling (Logical & Physical Design of Databases) using Oracle SQL Developer/ Toad Data Modeler, Oracle10gR2 Designer, ERwin, ER/Studio, Visio etc.
• Highly proficient in Query Optimization and Performance Tuning (using tools such as ADDM, AWR, Statspack, Explain Plan, SQL Trace/ Confidential, DBMS Profiler, AutoTrace, Indexing, Hints etc.), Troubleshooting etc.
• Well versed with Oracle’s/ PL/SQL’s advanced features such as Oracle Streams Advanced Queuing, Oracle Scheduler, Object Management, Collection data types, Oracle Large Objects etc
• Experienced in data migration from/to Oracle database using tools such as SQL Loader, Data import and export (IMP/EXP) utilities, Oracle Data Pump (expdp/impdp) etc.
• Good working knowledge in all aspects of Oracle database administration such as installation, design, creation, development, enhancements and maintenance of Oracle database servers.
• Worked on Database Logical/Physical Design, Hot/Cold Backups, Export/Import, Tablespace Creation and Modification, Creation/Modification of various tables, indexes and other database objects, Users/Security Administration, Performance Tuning etc.
• Strong skills in Server-side scripting including Unix Shell Scripting, Perl scripting etc.
• Good working knowledge of Internet technologies including Java, Java EE technologies, JSP, Oracle ADF, Oracle JDeveloper, ASP.NET, PHP, XML/XSL, HTML/XHTML, CSS, JavaScript etc.
• Broad knowledge of Data Warehousing and architecture design of ETL environments using Oracle Warehouse Builder 11gR2, Informatica PowerCenter 9.6, Pentaho 6.1.0.1 (EE) etc.
• Extensive experience in developing scalable enterprise applications for different sectors like Transportation, Insurance, Retail, Inventory, Energy, Academic research, Health care solutions, Telecommunication billing, ERP solutions, Multi-national banking etc., all of these implemented full fledged Oracle based data management and online transaction / batch processing systems.
• Also worked on onsite, onshore, offshore models.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, Java, C/C++, Pro*C/C++, Perl, Unix Shell scripts (sh, csh), AWK, XML/XSL, HTML, Transact-SQL, Delphi, Pascal, Ada etc

Databases: Oracle 12c/11g/10g/9i/8.x/7.x, Microsoft SQL Server 2008, MySQL 5.6, Confidential Informix etc.

Development Tools: Oracle Fusion Middleware 12c/11gR2 (Oracle Forms and Reports 12c (12.2.1), Oracle Confidential 19.x/18.x, Oracle BI Publisher, Oracle Forms/ Reports 11g/ Oracle JDeveloper 12c/Oracle BI Discoverer 11g, Oracle ADF 12c, Oracle Developer Suite 10g (Oracle Forms 10g/Oracle Reports 10g/Oracle Designer 10g/Oracle JDeveloper 10g/Oracle BI Discoverer 10g), Oracle9i Developer Suite (Oracle9i Forms Developer/Oracle9i Reports Developer/Oracle9i Designer/Oracle9i JDeveloper/Oracle9i Discoverer Administrator), BI/Business Objects 11.x, Crystal Reports 12/11, Power Builder 7.0, Visual Basic 6.0 etc

Oracle Tools/Utilities/Applications: Oracle E-Business Suite R12/Oracle Applications R11i, Oracle Enterprise Manager, Oracle Warehouse Builder, Oracle Streams AQ, Data import and export (IMP/EXP) utilities, Oracle Data Pump (expdp and impdp), SQL*Loader, Oracle XML Developer Kit (XDK), Oracle Developer Tools for Visual Studio (ODT), Oracle TopLink, Tuxedo, Oracle Essbase, Oracle Data Integrator (ODI), Oracle Data Miner, Oracle SOA Suite, Oracle's Primavera Project Portfolio Management (PPM), PeopleSoft PPM, PeopleSoft HRMS/CRM etc

Operating Systems: Windows Server 2008/Windows Server 2003/Windows 2000/Windows NT 4.0, UNIX ( Confidential AIX V6, HP-UX 11i, SUN Solaris 10), Oracle Enterprise Linux 5, Red Hat Enterprise Linux AS/ES/WS/Desktop, Novell NetWare 6.5, MS-DOS 7.x

Database Tools & IDE’s: Quest Software’s TOAD & SQL Navigator, PL/SQL Developer, Oracle SQL Developer, Eclipse, NetBeans IDE, POSIX (UNIX), Microsoft Visual Studio, IntelliJ IDEA, Confidential VisualAge, Confidential Rational Rose XDE etc

Internet Technologies: Java EE technologies (JDBC, RMI, JMS, Web service, XML, EJB, JCA, JSP, Servlets, Portlets, JSF, Spring, Hibernate, Apache Struts, Swing etc), JavaScript, Oracle WebLogic Server/ Confidential WebSphere, Apache, PHP, ASP.NET, .NET Framework, CORBA, Ajax etc

Applications: Distributed Concurrent Versions System (DCVS)/CVS, Perforce, Bazaar, Apache Subversion (SVN), Microsoft Visual SourceSafe (VSS), Borland StarTeam, SVK, Rational Synergy, PVCS, Remedy Action Request System (ARS), Request Tracker (RT), Rational ClearCase/ ClearQuest, Peregrine, Primavera, Microsoft Visio, Bugzilla, Microsoft Project, Confidential Lotus Notes etc.

Others: ETL Tools (Oracle Warehouse Builder 11gR2, Informatica PowerCenter), Confidential Tivoli Workload Scheduler ( Confidential scheduler), Cron job scheduler, CMMI, SOA, HP Quality Center (QC) etc.

PROFESSIONAL EXPERIENCE

Confidential, NY

Oracle Consultant

Responsibilities:

• Supported development, test and production environments using Oracle Database 12c/ Oracle Forms and Reports 12c/ 11gR2.
• Created/enhanced complex forms/reports/libraries based on user requirements.
• Demonstrated mastery in creating and maintaining Oracle database objects, PL/SQL scripts, SQL queries, as well as proficiency in PL/SQL development.
• Worked with complex/large database packages, procedures, functions and triggers with Oracle Database 12c
• Modified database schema design as needed including creating tables, views, indexes, partitioning, roles/privileges, grants, constraints, sequences etc.
• Developed, maintained, and submitted appropriate database documentation, per project requirements.
• Diagnosed issues in complex application architectures and suggested improvements in database infrastructure where appropriate, identified potential issues and limitations, monitor and improve performance, Evaluate and solicit feedback on processes to identify possible areas of improvement for optimizing transactions, Perform impact analyses of changes to database schema objects,
• Provide technical assistance with custom development and configuration, Performed knowledge transfer in the areas of Oracle DBA, Oracle Forms/Report, SQL/PL-SQL programming and performance monitoring.
• Developed front end applications using Oracle Confidential, developed reports using Confidential reports/ Oracle's BI Publisher.
• Developed and enhanced JavaScript in Confidential applications using either external JavaScript files or dynamic actions in Confidential pages.
• Added HTML and CSS Code Snippets.
• Worked intensively on performance tuning of PL/SQL Code, on Oracle database level using utilities such as utlbstat/utlestat, Confidential, statspack, Explain Plan, SQL Trace, event interface, rule/cost based optimizer's, Enterprise Manager Tuning Pack etc.
• Managed system administration tasks and automation of routine tasks using UNIX shell scripts.

Environment: HP-UX/ Confidential AIX, Windows Server 2003, Oracle Database 12c with Oracle Fusion Middleware 11gR2 (Oracle Forms and Reports 11gR2 / Oracle WebLogic Server 11gR1 etc.), Oracle Confidential 19.x/18.x, JavaScript, HTML, CSS, BI Publisher 12, Java SE 8, Oracle Designer 10gR2, Oracle Enterprise Manager Cloud Control 12c, Oracle 12c PL/SQL, SQL* Plus 12c, SQL Developer, UNIX Shell Scripting etc.

Confidential, New York

Systems/Programmer Analyst

Responsibilities:

• Involved in upgrade, maintenance, and support of company’s entire client/server applications, from SQL Forms/SQL Report Writer to Oracle Developer 12c/11gR2 Forms/Reports, which are used by company’s staff to process incoming medical data, maintain groups/members, process claims and provide customer service support.
• Installed and configured oracle internet application server/weblogic server to run company’s web site, and to web-enable Oracle Forms 11g, and created company’s web site, implemented with J2EE-JavaServer Pages, CSS, and Ajax, to provide live access to medical and payment records; data accessed with JDBC.
• Coded complex stored packages, procedures, functions and triggers to in corporate business logic into the application.
• Design and developed the scripts to create table, views, indexes and sequence.
• Developed the SQL Loader scripts to bulk load data into the staging tables from external files.
• Created Bash scripts to control the execution flow of ETL steps.
• Developed business plans and involved in conversion of existing Oracle Forms/ Reports applications to Oracle Confidential 5.x/4.x applications and Oracle BI Publisher reports
• Tuned application using Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, Bulk Collects and Bulk Binds) and involved in analysis and tuning of SQL queries by using EXPLAIN PLAN and Confidential for faster and better performance of the SQL queries.

Environment: Sun/ Fujitsu UNIX Server SPARC Enterprise M5000/M4000, Oracle Solaris 11.2, Oracle WebLogic Server 12c, Oracle Database 12c with Oracle Fusion Middleware 112c/11gr2 (Oracle Forms and Reports 11gR2 / Oracle BI Publisher 11g/ Oracle JDeveloper 12c / Oracle Business Intelligence Discoverer 11g etc.), Oracle Confidential 5.x/4.x, JavaScript, HTML, CSS, Java SE 7, Oracle Designer 10gR2, Oracle Enterprise Manager 12c, Oracle 12c PL/SQL, SQL* Plus 12c, TOAD/ SQL Developer, UNIX Shell/PERL Scripting, SQL Loader, Oracle Warehouse Builder 11gR2, Pentaho 6.1.0.1 (EE) etc.

Confidential

Systems/Programmer Analyst

Responsibilities:

• Involved in collection and rationalization of user requirements, functional gap analysis, preparing solutions designs, specs to build teams, leading development activities, conducting end-user training, leading integrated testing and deployment and post-deployment support
• Involved in the product extensions/custom development comprising design, extensive development and testing of the extensions to the Oracle Retail Merchandising product based on customer requirements.
• Developed and implemented RMS batch processing
• Designed and developed database objects including PL/SQL Packages, Procedures, Functions, Triggers, Forms and Reports to extend Oracle Retail functionality based on user requirements

Environment: AIX 6.1, Solaris 10, and HP-UX 11i v3, Oracle E-Business Suite R12/Oracle Applications R11i, Oracle 11g with Oracle Fusion Middleware 11g (Oracle Forms 11g/Oracle Reports 11g /Oracle JDeveloper 11g/Oracle BI Discoverer 11g, SOA etc), Java/WebLogic, Oracle Confidential 4.0, Crystal Reports 12, 10gR2 Designer, Oracle Enterprise Manager 11g, PL/SQL 11, SQL* Plus 10.1, TOAD/ SQL Developer, UNIX Shell/PERL Scripting, SQL*Loader, Oracle Warehouse Builder 11g etc

Confidential, Auburn Hills, MI

Programmer Analyst

Responsibilities:

• Involved in the product extensions/custom development comprising design, development and testing of the extensions to the Oracle Applications product based on customer requirements
• Developed PL/SQL Packages, Request sets, Forms, Menus and Reports to extend Oracle applications functionality based on user requirements and registered them as concurrent programs.
• Performed setup steps, for defining key flex fields and descriptive flex fields.
• Created various lookups and value sets.
• Sound knowledge of flex fields, value sets, concurrent processing, workflow, set-up and profile options.

Environment: Sun SPARC Enterprise M8000/T5220, Sun 4800/3960, Solaris 2.9/10, Oracle 11.5.9/Oracle 12i, Oracle Developer Suite 10g (Oracle Forms 10g/Oracle Reports 10g /Oracle JDeveloper 10g/Oracle BI Discoverer 10g), Java/WebLogic, Crystal Reports 9, 10g/9i Designer, Enterprise Manager 10g/9i, PL/SQL 9.2, SQL* Plus 9.2, TOAD, UNIX Shell Scripting, PERL Scripting, SQL Loader, Oracle Warehouse Builder etc

Confidential

Principal Analyst

Responsibilities:

• Responsible for requirement gathering, documenting specification, Analysis, Detailed Technical Design, Data Modeling, Development and Customization, Testing, Integration and Implementation of Confidential ’s fleet management solution Willow.
• Designed, developed and customized modules using Oracle Forms and Reports, PL/SQL, database and client-side packages, procedures, functions, triggers, UNIX shell scripts etc
• Created batch-processing jobs using server-side procedures, control files and shell scripts to schedule and execute nightly and weekend batch jobs using Confidential Job Scheduler

Environment: HP 9000, HP-UX 11.23/11.20 , AIX 5L 5.2/5.1, Sun Solaris 10, Oracle 10g/9i/8i with Developer 9i Suite (9i Forms Developer/9i Reports Developer /Crystal Reports 11), 9i Designer, PL/SQL 10.2, SQL* Plus 9.2, SQL*Loader, TOAD, J2EE, Java, Oracle JDeveloper, Web Services, XML, Perl Scripting, UNIX Shell scripting, SOA etc

Confidential

Customer Service

Responsibilities:

• Designed, developed and maintained applications using Forms and reports, PL/SQL database and client-side packages, procedures, functions, triggers, UNIX shell scripts etc required for ongoing development and maintenance of customer service billing and other legacy applications/projects
• Created batch-processing jobs using server-side procedures, control files and shell scripts to schedule and execute nightly and weekend batch jobs using Confidential Job Scheduler

Environment: HP 9000, HP-UX 11.11/11.0/10.2 , AIX 5.2/5.1.4.x, Sun Solaris 7/2.6, Windows 2000/NT, Oracle 10g/9i/8i with Developer 9i Suite (9i Forms Developer/9i Reports Developer), 9i Designer, PL/SQL 10.2, SQL* Plus 9.2, SQL*Loader, TOAD, J2EE, Java, Web Services, XML, UNIX Shell scripting, CMMI etc

Confidential

Programmer Analyst / Systems/Jr. Database Administrator

Responsibilities:

• Designed, developed, validated, and maintained Oracle Clinical databases for clinical trials
• Designed, developed and maintained internal applications using Oracle forms, Crystal Reports, PL/SQL database and client-side packages, procedures, functions and triggers required for ongoing management of clinical trial data and operations.
• Provided technical support to data management and worked as a technical resource for the administration of oracle databases and related applications

Environment: HP ProLiant ML570/ML370, Compaq ProLiant 5500/3000/800 , Windows 2000/NT, Oracle Clinical 4.x, Oracle 9i/8i with Developer 9i Suite (9i Forms Developer/9i Reports Developer), Crystal Reports 9, 9i Designer, Enterprise Manager 9i, PL/SQL 9.2, SQL* Plus 9.2, TOAD, UNIX Shell & PERL Scripting, SQL*Loader, Performance Tuning with Explain Plan & DBMS Profiler etc

Confidential

Systems Analyst

Responsibilities:

• Senior team member of the development team and involved in the design and development of Forms and Reports, Oracle PL/SQL server-side packages, Triggers, Pro C/ C/ C++ programs.
• Involved in full project life cycle Analysis, design, development and implementation of applications.
• Analyzed user requirements, and prepared design and functional specifications based on these requirements.

Environment: HP-UX, Windows 2000/NT, Oracle 9i/8i with Developer 9i Suite (9i Forms Developer/9i Reports Developer), SQR, 9i Designer, PL/SQL 9.2, SQL Plus 9.2, Pro*C/C++, UNIX Shell Scripts, PERL, Performance Tuning using Explain Plan and DBMS Profiler; SQL*Loader etc.Clients: Nabi, ZLB, Biomat, Plasmacare, Bio-Medics, LifeSera, DGH

Confidential

Responsibilities:

• Senior team member of the development team and involved in the design and development of Oracle PL/SQL server-side packages, Triggers, Forms and Reports, UNIX Shell Scripts, Perl, Pro* C/ C/ C++ programs.
• Involved in unit/ regression/ integration/ team lead testing, implementation and support

Environment: HP UX, Windows 2000/NT, Oracle 8i with Developer 6i/6 Suite (Form Builder 6i/6, Report Builder 6i/6), PL/SQL 8.1, SQL* Plus 8.0, Pro*C/C++, Designer 6.0, Performance Tuning using Explain Plan and DBMS Profiler etc

Confidential

Software Developer

Responsibilities:

• Project team member of the R & D team and involved in the design and development of PL/SQL server-side packages, Triggers, Forms and Reports.
• Worked in C++/Pro* C/CORBA for writing interfaces.
• Also involved in testing and implementation.

Environment: UNIX/Windows 98/95, Oracle 8i with Developer 6.0 suite (Form Builder 6.0, Report Builder 6.0), PL/SQL 8.1, SQL* Plus 3.3, Pro*C, C++ and Designer 6.0, SQL*Loader etc

Confidential

Programmer Analyst

Responsibilities:

• Project team member of the team and worked in the design and development of PL/SQL server-side packages, Java classes, server-side components using Enterprise Java Beans, object/relational mapping with TopLink, XML/HTML documents etc.

Environment: Windows NT, Confidential Visual Age for Java, Enterprise Java Beans, XML, CORBA, Web Logic Enterprise and the persistence is implemented using TOPLink/WLE, Oracle 8.0.5, PL/SQL 8.1.

Confidential

Systems Analyst

Responsibilities:

• Project team member and involved in the design and development of PL/SQL server-side packages, Triggers, Forms and Reports, defining standards, Testing and Implementation.
• Performed database administration and application tuning.

Environment: Windows NT/95, Oracle 8.0 with Developer/2000 Rel. 2.1 (Form Builder 5.0, Report Builder 3.0, PL/SQL 2.3, SQL* Plus 3.3) and Designer/2000 Release 2.0.

Confidential

Software Engineer

Responsibilities:

• Project team member and involved in design and development of PL/SQL server-side packages, Stored Procedures, Functions, Triggers, Forms, Reports.
• Also Involved in testing and implementation.

Environment: UNIX/Windows 95, Oracle 7.3 with Developer/2000 Rel. 1.3 (SQL* Forms 4.5, SQL* Reports 2.5, PL/SQL 2.3, Pro* C, SQL* Plus 3.2, SQL* Menu) and Designer/2000.

Confidential

Responsibilities:

• Project team member and involved in design and development of PL/SQL server-side packages, Stored Procedures, Functions, Triggers, Forms, Reports.
• Also Involved in testing and implementation.

Environment: SCO UNIX, Oracle 7.0 with SQL* Forms 3.0/2.3, SQL* Report Writer 1.1/1.0, PL/SQL 1.x, SQL* Plus, Pro*C, SQL* Menu 5.0 etc.