Oracle Sql

Summary

Over ** years of IT Industry experience, adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion.

Proven background developing packages, procedures, and applications/modules.

Proficient with 11g Relational database, Oracle Forms/Reports, Oracle Forms migrate to 10g, SQL, PL/SQL, Open Interfaces, workflow, SQL queries and performance tuning, OAF & APIs.

Have a keen focus on performance tuning, testing, and quality assurance. Collaborate well with project management, business analysts, and department management teams. Have a superior communication, organizational, and interpersonal skills.

Technical Skills

ERP

Oracle Applications R12.1, 11i (11.5.8, 11.5.9, 11.5.10) (AK, FND, ALR, GL, AP, AR, FA, PO, OM (ONT), ASO, BOM, INV, WSH, HRMS (PER), CS, OKS, CSI, ICX, EAM, PLM/PIM)

Tools

Oracle Forms 9i/6i/4.5/3.0/2.3, Oracle Reports 10g/9i/6i/4.5, TOAD, SQL *Navigator, SQL *Plus, Oracle Discoverer, SQL *Loader, Oracle Workflows, APPWORX, PL/SQL Developer

RDBMS

Oracle 11g/10g/9i/8i/7/6/5

Languages

PL/SQL, C, HTML, JavaScript, Java, Eclipse, and Shell Scripting.

OS

UNIX, Sun Solaris, Linux and Windows NT/7/XP/Vista.

MS Office

Word, Outlook, Excel, Access, and PowerPoint.

Education

Presently pursuing certification in Big Data and Hadoop, including HDFS, YARN, Zookeeper, Map Reduce, PIG, HIVE, HBase, Flume, Sqoop, Oozie from edureka.

Presently pursuing certification in Apache Spark and Scala, including Big Data and Spark, RDD, Dataframes, DAGs, Functional programming in Scala, REPL, Spark Streaming, MLLib, ML Pipelines, GraphX, Spark SQL, Apache Kafka, SBT, Spark Web UI, PySpark, SparkR, JFreeChart from edureka.

Presently pursuing certification in Java/J2EE and SOA, including ESB, Java frameworks like Hibernate & Spring, JSP, Servlets, JDBC, XML, Ajax and Design Patterns, Web Services, WSDL, SOAP, UDDI, HTTP, RESTful Web service, Apache Axis2, JAX-WS, JAX-RS.

Java certificate of professional development from the O’Reilly School of Technology.

Project Management Professional (PMP) Certificate in Project Management - Project Management Institute (PMI), USA

Bachelor in Physics - University of Bombay, India

Advanced Diploma in Computer Systems Management - NIIT, India

Professional Experience

State Compensation Insurance Fund Inc., Vacaville and Pleasanton, CA 03/12 – 12/15

Senior Oracle Developer

As a Senior Oracle Developer supported the development and maintenance of SCIF’s ECF and CARE claims applications. The development effort involved using Oracle forms and reports version’s 9i and 10g, Oracle Discoverer Reports, PL/SQL, Oracle Designer, SQL, Oracle Relational database 11g, Unix, and Oracle Applications AP R11.

Front End development on legacy code in Oracle forms Version 9i and 10g

Migrate Oracle Forms from version 9i to 10g.

PL/SQL development - packages, procedure, functions, autonomous procedures, handling arrays

Provide assistance in performance tuning of any SQL queries, SQL tuning and tkprof

Oracle Discoverer reports development for management

Data Migration/conversion

Interfaces with COMDB, WISP, ECF, DB2 and vendors

Payment Processing using Oracle AP

Update Oracle database, tables/indexes/sequences/TAPI (Table API) as needed.

Work with the Business and IT teams to complete the project analysis, scoping, and scheduling

Worked on ASC X12N (1450, 1500) and NCPDP healthcare (Hospital, Doctor and Pharmacy) bill processing.

Chegg Inc., Santa Clara, CA 02/11 – 03/11

Technical Consultant

As a technical consultant supported the development of Chegg’s Oracle Applications AP Supplier and Invoice API process.

S/W tools: Windows 7, PL/SQL, SQL Developer, SQL*Plus, Oracle Relational database 10g, SQL, Oracle Applications AP.

Intelligrated, Inc., Cincinnati, OH 09/11 – 11/11

Technical Consultant

As a technical consultant supported the Oracle Applications R12.1 implementation by developing custom extensions and reports using Oracle Applications R12.1 AOL, OM, HRMS, OAF and PLM/PIM.

Enhance existing report using Oracle Reports 10g

Assist in testing and user acceptance of the Oracle Sales Order shipping interface with UPS World.

In development: Oracle HRMS Pre-hire interface. Sales Order form personalization. Advanced Pricing - Price list form personalization. Oracle HRMS “Document of Record” OAF personalization and customization. Fix “Issue Management“ self service form problem for Issue Type: Oracle Manufacturing Product Request (MPR), possibly with Oracle Support's help.

S/W tools: Windows 7, PL/SQL, SQL Developer, SQL*Plus, Oracle Relational database 11g, SQL, Oracle Reports 10g, Oracle Applications R12.1 AOL, OM, HRMS, OAF, PLM/PIM, SharePoint.

Multiple locations, USA 06/09 – 09/11

Senior Developer

Developed software using these Oracle Database and Oracle tools: Oracle 10g & 11g Relational database, Pl/SQL, SQL, C++, Java, Oracle ADF, Oracle SOA.

S/W tools: Technical Books, Oracle OTN, Oracle learning by example, Oracle Virtual Box VM, Windows OS.

King County, Seattle, WA 04/09 – 06/09

Oracle Application Developer

As a Oracle Application developer used my technical work experience to develop Oracle Applications Financials version 12 solutions for existing King county Financials applications. Used Oracle Applications R12 AR, AP, Budget, PL/SQL, SQL Developer, SQL*Plus, Oracle Relational database 11g, SQL and Linux.

Research and recommend suitable tools for the application development environment

Prepare pre-functional specification using Oracle AR, AP, Budget

Assist in preparing Interface Strategy document

Develop SQL scripts for data extract

S/W tools: Linux, Windows XP, PL/SQL, SQL Developer, SQL*Plus, Oracle Relational database 11g, SQL, Oracle Applications R12 AR, AP, Budget

Open Text Corp, Bellevue, WA 11/07 – 04/09

Senior Software Developer

Developed reports, interfaces, conversions, custom extensions and work-flow using, Oracle Forms 6i, Oracle Reports 6i, Linux, PL/SQL, SQL Developer, SQL*Plus, Oracle 10g Relational database, SQL and Unix shell scripting.

Support the existing Oracle Application 11i implementation using multi-org

Develop enhancements using Oracle AR (TCA), AP, GL, PO, INV, OM, IB, OKS, WSH, BOM

Develop open interfaces (inbound) using Oracle API for IB, OKS, EAM

Develop conversion using Oracle BOM using BOM exploder

Develop customizations Oracle OM, Oracle AR including revenue recognition.

Develop reports using Oracle AR, AP, GL, PO, INV, OM, IB, OKS, WSH, BOM

Evaluate the sales quoting systems to convert from Onyx

Using the Custom.pll library to customize Oracle Applications AR forms 6i.

S/W tools: Oracle Applications 11i, Oracle Forms 6i, Oracle Reports 6i, Linux, Windows XP, PL/SQL, SQL Developer, SQL*Plus, Oracle 10g, SQL, Shell Scripting.

Areva T&D Inc., Redmond, WA 08/06 – 08/07

Oracle Forms Developer – “DART” Application.

As an Oracle Forms developer, developed Oracle forms to enhance Areva’s “DART” energy management application used by various energy distribution companies to manage energy distribution across their energy grids.

Used Oracle 9i Relational database, Oracle Forms 6i, PL/SQL 9i, Toad, Visual Source Safe and DevTrack, SQL, UNIX and Unix shell scripting.

Maintaining the “DART” application

Develop custom enhancements

S/W tools: Oracle 9i, Oracle Forms 6i, PL/SQL 9i, Toad, Visual Source Safe and DevTrack, SQL, Unix, Shell Scripting, Windows OS.

Tide Works Technology Inc., Seattle, WA 07/06 – 08/06

Oracle Developer - Genoa terminal management application.

As a Oracle Developer, used Oracle 10g Relational database, Oracle Designer 10g, Oracle Forms 10g, Oracle Reports 10g, PL/SQL 10g, SQL, Linux and Linux shell scripting to develop fixes to the existing Genoa application problems.

Worked on fixing Genoa application problems raised by Genoa application users.

S/W tools: Oracle 10g, Oracle Designer 10g Relational database, Oracle Forms 10g, Oracle Reports 10g, PL/SQL 10g, SQL, Linux, Shell Scripting, Windows OS.

Holland America Line – Westours, Seattle, WA 04/05 – 05/06

Oracle Developer – Time Capture application and Paymaster application

As a application developer used Oracle 8i Relational database, Oracle Designer 6i, Oracle Forms 6i, SQL*Plus, SQL*Menu, PL/SQL, Oracle Pro*C, C, Korn shell, Bugzilla, UNIX, SQL and Unix shell scripting to develop the TimeCapture application and the Paymaster application.

Lead the design of the TimeCapture application. Along with a colleague developed the Oracle part of the TimeCapture application.

Along with a colleague lead the design of the Paymaster application. Lead the development of the Paymaster application.

S/W tools: Oracle 8i Relational database, Oracle Designer 6i, Oracle Forms 6i, SQL*Plus, SQL*Menu, PL/SQL, Oracle Pro*C, C, Korn shell, Bugzilla, UNIX, SQL, Shell Scripting, Windows OS.

PeopleSoft Corporation, Pleasanton, CA 7/03 – 3/04

Senior Product Support Analyst - PeopleSoft Financials (Expenses)

As a senior product support analyst supported the PeopleSoft Financials (Expenses) module. Used PeopleSoft Financials (Expenses) 7.x & 8.x, PeopleTools, PeopleCode, SQL, SQLServer, Oracle, Unix and Unix shell scripting.

Managed, designed, implemented and supported a custom development to support PeopleSoft's “Financials Product Support case history analyzing solution” for their Global Support Center. There were a total of 50+ stakeholders / contacts / resources involved in requirement gathering and consensus negotiations to support this project.

Performed product technical support for customers of PeopleSoft using PeopleSoft Financials (Expenses) module.

Attended brown-bag sessions and worked on trial-runs for, and during the roll-out of the new process.

Actively worked with the Product Management team to ensure that effective reporting levels are set and accurate project data is being reported on, to meet multiple levels of authority and need for information.

S/W tools: PeopleSoft Financials (Expenses) 7.x & 8.x, PeopleTools, PeopleCode, SQL, SQL Server, Oracle Relational database, Unix, Shell Scripting, Windows OS.

Cisco Corporation, San Jose, CA 12/02 – 06/03

IT Consultant - CARAT and WIPS business intelligence enhancement and implementation application

As a IT consultant developed enhancements to ERP CARAT, Cisco’s business rule engine that derives and automates the assignment of customer roles and distribution strategies to ERP transactions. Developed enhancements to WIPS, Cisco’s business rule engine that derives and automates the assignment of customer roles and distribution strategies to all Point of Sale transactions. Used PL/SQL, SQL, Oracle 8i, SQL*Loader, HP-UX, $Universe Unix scheduling tool, UNIX shell scripting, Unix and Oracle TCA architecture.

Designed and implemented custom enhancements, supporting the Customer and Role Attribute Tracking (CARAT) business rule engine based on key stakeholders needs.

Designed and implemented custom enhancements, supporting the Worldwide Inventory Point of Sale (WIPS) business rule engine based on key stakeholders needs and implemented ad-hoc custom queries and reports.

S/W tools: PL/SQL, SQL, Oracle 8i Relational database, SQL*Loader, HP-UX, $Universe Unix scheduling tool, Shell scripting, UNIX, Windows OS, Oracle TCA architecture.

Pacer StackTrain Corporation, Walnut Creek, CA 6/02 – 10/03

Technical Project Manager

As a Technical project manager lead the ERP technical implementation team to implement Oracle Financials 11i. Used Oracle Financials 11i (11.5.7), AR, AP, GL, PO, EDI, Procure to Pay, Order to Cash, Oracle 8i, SQL*Loader, Workflow 2.6, Korn shell, SQL, Unix and Unix shell scripting.

Managed a team of developers and testers, performed requirements gathering and consensus negotiations to support this project, documented new business processes, identified and communicated with other cross-functional teams (90+ stakeholders).

Created project plan to align it with the various other cross-functional teams, conducted CRP (Conference Room Pilots) to review internally and with project sponsor and worked with the production support teams to create the post-implementation support process and procedures.

Explore the use of Oracle Multi-Currency.

S/W tools: Oracle Financials 11i (11.5.7), AR, AP, GL, PO, EDI, Procure to Pay, Order to Cash, Oracle 8i Relational database, SQL*Loader, Workflow 2.6, Korn shell, SQL, Unix, Shell Scripting, Windows OS.

ONI Systems Corporation, CA, USA 4/01 – 6/02

Senior Analyst

As a Analyst, used Oracle Applications 11.0.3, CRM, HRMS, OM, INV, Workflow, Procure to Pay, Order to Cash, Oracle 8i Relational database, XML, PL/SQL, JSP, Servlets, Apache-SOAP, Agile 6.0/7.5, Sun Solaris 8, SQL, Unix and Unix shell scripting to develop workflow, reports, interfaces, customizations and extensions to Oracle Applications 11.0.3.

Managed, designed and implemented custom applications, open interfaces (inbound and outbound), Oracle API, workflow and support the Oracle CRM, OM & INV applications.

Managed, designed, implemented and supported customizing the Oracle HRMS application.

Managed and designed a Oracle API and Web Service using Apache-SOAP & XML for Oracle INV.

Managed, designed, implemented and supported a custom web based self-service application for Oracle CRM using PL/SQL, XML, “JSP” & Servlets.

Managed, designed, implemented and supported a custom web based self-service application for Oracle OE using PL/SQL, XML, “JSP” & Servlets.

Managed and supported the interface between Agile and Oracle.

Co-managed the upgrading the Agile product from version 6.0 to 7.5.

Using the Custom.pll library to customize Oracle Applications forms 6i.

S/W tools: Oracle Applications 11.0.3, CRM, HRMS, OM, INV, Workflow, Procure to Pay, Order to Cash, Oracle 8i Relational database, XML, PL/SQL, JSP, Servlets, Apache-SOAP, Agile 6.0/7.5, Sun Solaris 8, Windows 95/NT/2000, SQL, Unix, Shell Scripting.

Covansys Corporation, Milpitas, CA 1992 - 2001

Technical Manager (Client: Verizon Wireless) – Oracle HRMS Application 11.0.3 Implementation (10/00 – 3/01)

As part of a large cross-functional HRMS Application implementation team:

Managed, designed, implemented and supported custom web based self-service extensions to Oracle HRMS using XML and JavaScript and custom Oracle workflow for Oracle HRMS.

S/W tools: Oracle HRMS 11.0.3, Workflow, Oracle 8i Relational database, XML, PL/SQL, Sun Solaris, Windows 95/NT/2000, SQL, Shell Scripting.

Technical Manager (Client: Icarian Corp) – Icarian Workforce Interface Implementation (10/99 – 9/00)

As part of the Icarian Workforce (IWF) Interface implementation team:

Managed, designed, implemented and supported a custom XML interface between IWF (Icarian’s Applicant Tracking System) and Oracle HRMS using HTTPS and Java.

Analyzed user requirements, prepared design specifications, prepared database schema design, performed database optimization and tuning.

S/W tools: Oracle HRMS 11.0.3, Oracle 8 Relational database, XML, HTTPS, Java, IBM RS6000, AIX, Windows 95/NT, SQL, Shell Scripting.

Technical Manager (Client: AirTouch Communications) (7/98 – 9/99)

As part of a large cross-functional HRMS Application implementation team:

Managed, designed, implemented and supported customizations using Oracle API and custom open interfaces (inbound and outbound) to Oracle HRMS.

Managed, designed and implemented conversions of employee, assignment, location, organization, job, and salary data from legacy system into Oracle HRMS using Oracle API.

Managed, designed, implemented and supported screens for “HR Connect online” a custom web based self-service application on Oracle HRMS.

S/W tools: Oracle HRMS 11.0.3, Oracle 8, Designer 2000, Developer 2000, EDMS, Korn shell, Sun Solaris, SQL, Shell Scripting, Windows OS.

Senior Programmer Analyst (Client’s: APL Corp, HSD Corp, Convoy Corp) - Multiple projects (12/94 – 6/98)

As a part of the IT group at these client locations:

Managed, designed, implemented and supported custom Oracle Applications. Tasks included physical and logical database design, application performance tuning. Installed and supported Oracle 7.x databases.

S/W tools: Oracle 7.x, SQL*Forms 4.5, SQL*Reports 2.5, PL/SQL, C, Korn Shell, SQL, Unix, Shell Scripting, Windows.

Senior Programmer Analyst (Client: Holland America Line) – SGP and CAP systems (3/92 – 11/94)

As part of a large cross-functional implementation team:

Developed and supported the custom Seagoing personnel and Crew Administration and Payroll systems.

Developed and supported the Source Control and Release Management system and Ship Calendar reports.

Oracle 7.x database installation, configuration, physical and logical database design, performance tuning and support.

S/W tools: Oracle 7.x, Oracle Case 5.0, SQL*Forms 3.0, SQL*ReportWriter 1.1, SQL*Plus, SQL*Menu, SQL*Net, PL/SQL, Korn shell, Sun Sparc station, SQL, Unix, Shell Scripting, Oracle Pro*C, C, Windows OS.

InMac Pvt, Ltd. And Kale Consultants Pvt, Ltd., Bombay, India 1988 - 1992

Project Leader (Client’s: The Paper Products Company, Canadian Department of Fisheries and Oceans, Proctor and Gamble) - Multiple jobs (1/88 – 2/92)

As a part of the IT group at these client locations:

Prepared a Feasibility Study report. Designed and developed the Integrated Order Processing and Production Control system. Lead a team of programmers. Oracle 6.x database installation, configuration, physical and logical database design, performance tuning and support.

Designed, developed, and implemented the Foreign Fisheries Information system using Oracle 5.x, Pro*C, Bourne shell, SQL*Forms 2.3, SQL*ReportWriter1.1 and the Catch and Effort System using Dbase and Clipper and the Sales Information System using Dbase and Clipper for Proctor & Gamble.

S/W tools: Oracle 6.x, SQL*Forms 3.0, SQL*ReportWriter 1.1, SQL*Plus, SQL*Menu, SQL*Net, Korn shell, Motorola MC8088, PC’s, SQL, Unix, Shell Scripting, Oracle Pro*C, C, Windows OS.

Contact this candidate