Senior Oracle eBusiness Applications Consultant

Uday

Senior Oracle eBusiness Applications Consultant

401-***-****(M)

***************@*****.***

• More than 10 years of experience in Web, Client/Server and Oracle Enterprise Applications (R12 and 11.5.10.2) that includes Analysis, Design, Coding, Testing and Implementation of the systems

• Proficient in Oracle & Java Technology products –OA Framework (OAF), XML publisher Workflow, ESB,BPEL, Forms, Report, PL/SQL,ADF, APEX, J2EE.

• Extensive functional and technical experience in Oracle iProcurement, Purchasing ,Financials, Payroll, HRMS, , Order management, Inventory, Install Base, iSupplier, iSupport, eBTax & iRecruitment.

• Working Experience with Oracle SOA-Fusion Middleware Technologies(ESB,BPEL,BPM, Oracle Integration Adapters)

• Expertise in defining Payroll and HR business processes, process charts and Solution design documents.

• Having Strong experience in implementing Financial, Self Service and CRM modules with complex customizations including form customizations, Reports Customizations, Workflow Customizations, OA Pages and XML publisher reports.

• Designed and developed various critical business processes (Forms, Reports, Interfaces & Workflows) for different clients across the globe in a very efficient manner without compromising with the Quality.

• Sound understanding of Oracle Business Intelligence Enterprise Editions (OBIEE) components (OBI Server, Oracle BI Presentation Services, Web cat file, config files and other tools and utilities) and Siebel Analytics 7.X

• Extensive experience with Oracle Business Intelligence Publisher (XML Publisher).

• Designed & Implemented Common Framework Classes includes Custom Exception Classes, Data Access Frame work classes using JDBC, Logging mechanism using Log4J

• Expertise in analysis (OOA), design (OOD) and OOP concepts. Experience in object modeling using UML (Sequence Diagrams, Class Diagrams) and design patterns.

• Working experience with Relational Database’s like Oracle, DB2, SQL Server and MS-Access.

• Knowledge of Ant, Web Services, SOAP and Spring Framework.

• Experience in E-Commerce domain.

• Worked on all major platforms including UNIX, Windows NT/2000.

• Excellent Communication skills and proven track record of leadership skills with the ability to work both independently or on a team

EDUCATION

• Masters in Computer Applications

TECHNICAL SKILLS

Apps Technology Oracle Application Framework(OAF), XML Publishing ,Workflow, BPEL,

ADF, APEX, Forms, Reports.

Fusion Middleware BPEL, BPM, ESB, Oracle Integration Adapters

Reporting BI Publisher (XML Publisher),OBIEE

Languages: C,C++, Java2.0, HTML, XML, JavaScript, SQL, PL/SQL, COBOL, and UML

Utilities Jdeveloper 9i/10g, IntelliJidea 3.0, IBM Visual Age for Java 4.0, NetBeans,

JBuilder, Visual café, Eclipse, WSAD, CVS, Clear Case, Clear Quest, Dreamweaver, FrontPage

Java Technologies J2EE (EJB, JNDI, JTS, JTA, JSP, Servlets, JDBC, RMI), JNI, XML, XSLT, JAXP, Web Services, BC4J, Java Beans

Architecture Struts Design Patterns, Object Oriented, J2EE Design Patterns, UML, Rational Rose, MVC

Application Servers WebSphere 5.0/4.0, WebLogic 8.1/7.0/6.1/5.1/4.5,Oracle 9i/10G AS

Web Servers iPlanet web server6.0, Apache Tomcat Server

Scripting Languages Shell Scripts, Java Script, JSP, HTML, XHTML DHTML, XML, CSS and XSL

Databases Oracle 8i/9i , MS Access, SQL Server 2000, Sybase, DB2 8.1

Operating Systems Windows NT/XP/2000, UNIX/Solaris, Linux

Protocols HTTP, TCP, FTP, WAP, SOAP

PROFESSIONAL EXPERIENCE:

DeKalb County Government Oct ‘08 to till date

Oracle Purchasing/iProcurement-R12 (Customization & Extension) Senior Consultant

Oracle iProcurement is the self-service requisitioning application that controls employee spending. Oracle iProcurement provides a Web-based shopping system that allows employees to create, manage, and track their own orders while the Purchasing department retains central control.

‘RedBook’ is web enabled catalog search solution for iProcurement users of DeKalb County.

Role & Responsibilities:

• I designed and delivered all the business functionality and customization on top of R12. Used personalization, developers JRAD Components to deliver on R12 technology stack.

• Used Extension & Personalization features for IProcurement customizations.

• Developing Core Components using J2EE, Java, JSP, JDBC,BC4J, XML, SQL deployment in Oracle 9iAS,Quick Apache.

• Developed Model Objects like Entity Objects, View Objects, Application Modules

• Automated installation & uninstallation process using Unix shell scripts.

• Implemented ‘Logging Infrastructure’ features in UI pages.

• Developed several reports using XML Publisher(BI Publisher) for Oracle Procurement, Purchasing.

• Integrated OAF and XML Publisher.

• Implemented bursting for electronic distribution remittance report to suppliers.

• Worked with Physical, Logical and Presentation Layer of BIEE

• Implemented calculations to the fact.

• Defined dimension Hierarchies for the Dimension Logical Table

• Customized “PO Doc creation workflow”, “PO Approval & Requisition Approval Workflow” for iProcurement.

Environment:

OA framework (Self Service), Jdeveloper 9i/10g, QuickApache with Jserv, PL/SQL Windows NT, UNIX Shell Programming, XML publisher (Oracle BI publisher), HTML DB, Workflow

DeKalb County Government Jan ‘07 to Sep’08

SAMS Senior Consultant

SAMS2 is the e-biz replacement for the real estate tracking module ‘OASIS’ of DeKalb County. SAMS2 uses Install base to track the real estate parcels (land plots) and Oracle Billing for collecting the tax revenues. SAMS2 uses TCA interfaces to build a customer repository and customer data quality management (DQM) techniques to validate the customer data. Custom screens were developed using OA framework and JSP to track the sales and new owners. Oracle fusion middle ware(ESB,BPEL) is used to integrate external applications.

Role & Responsibilities:

• Worked as a Technical lead and lead developer.

• Prepared the MD70 and the custom table design for the custom sales screens.

• Developed migration/transformation logic using Oracle ESB.

• Developed process management markups using BPEL and Oracle Adaptors (for Integration with Mainframe to Oracle business Suite)

• Developed wrapper APIs to build custom business logic for TCA and IB using PL/SQL.

• Developed UI screens using JSP and OA Framework

• Designed and developed the conversion and integration with other custom applications(ESB,BPEL)

• Developed different SOAP services and Web Services using WSDL, SOAP, AXIS, and Oracle JDeveloper.

• Developed custom XPath functions to transform messages.

• Used JDeveloper IDE for coding BPEL Process Models.

• Implemented Exception Handling for the BPEL Process models to handle System, Business exceptions and used Compensation handlers to handle the transaction if an exception occurs

• Analyzed the business needs for the processes and modules that needed migration

• Design and Implement Adapters for backward compatibility with old modules.

• Implement old processes into new modules and make sure all the business needs are addressed. Design, development and deployment of Web Services was done using Oracle BPEL, JAVA, and XML (WSDLs)

• Assisted in training others on BPEL and determining how to integrate BPEL into the Common Services projects.

• Extensively used BPEL to determine dynamic partner link calls, updating databases via BPEL, generating proxy stub classes to call BPEL process from a web application, etc

• Assisting in the coding and testing of the Shared Security Common Service which is intended to be a building block for the rapid development of applications. By providing a configurable, stable, standardized set of security-related services, designers and developers will not have to worry about the implementation of a security system and will just need to invoke the web service.

• Created reports generation using XML publisher technology.(Involved in authoring, managing , and delivering all types of highly formatted documents solutions)

Environment:

OA framework (Self Service), Jdeveloper 9i, QuickApache with Jserv, PL/SQL Windows NT, Unix Shell Programming, Oracle Fusion Middleware (BPEL, ESB), Oracle 10gAS, XML publisher.

DeKalb County Government May ‘07 to Dec’07

Oracle Purchasing & Project Contracts & Contract Compliance–LSBE Senior Consultant

The LSBE system will allow Contract Compliance department to manage certifications, provide access to contract information and automate reports and letters that are used in their daily business processes.

Role & Responsibilities:

• Worked as a Technical lead and lead developer.

• Prepared the MD70 and the custom table design for the custom sales screens.

• Developed UI screens using JSP and OA Framework

Environment:

Oracle ADF, Jdeveloper 10g, QuickApache with Jserv, PL/SQL Windows NT, Unix Shell Programming, Oracle 10gAS,XML publisher

DeKalb County Government Jan ‘07 to Dec’07

Oracle iProcurement - Supplier Portal & Payables Implementation Senior Consultant

Oracle iProcurement is the self-service requisitioning application that controls employee spending. Oracle iProcurement provides a Web-based shopping system that allows employees to create, manage, and track their own orders while the Purchasing department retains central control.

Role & Responsibilities:

• Implemented all the iProcurement customizations using AK Developer and JSP Screens in 11.5.7-11.5.9.

• Re-Implemented iProcurement & all its customizations using Oracle Framework on 11.5.10. Did the entire iProcurement upgrade project myself. Used JDeveloper 9.0.3 to make all extensions/changes to OAF components.

• Enabled supplier punchouts using Oracle Exchange to enable XML/cXML messaging. Helped suppliers resolve

• Developed programs to create Approved Contract PO’s, customized PO Print report for XML related changes.

• Customized “PO Doc creation workflow”, “PO Approval & Requisition Approval Workflow” for iProcurement.

• Configured various SelfService screens in iProcurement, using AK Developer & XML Templates.

• Resolved problems with cXML messages/encoding. Enabled PO_007 outbound messages via exchange for suppliers

• Negotiated OAG XML PO_007 & response BOD documents with various suppliers for seemless B2B integration.

DeKalb County Government Jan ‘07 to Dec’07

Oracle iProcurement - Supplier Portal & Payables Implementation Senior Consultant

Oracle iProcurement is the self-service requisitioning application that controls employee spending. Oracle iProcurement provides a Web-based shopping system that allows employees to create, manage, and track their own orders while the Purchasing department retains central control.

Role & Responsibilities:

• Implemented all the iProcurement customizations using AK Developer and JSP Screens in 11.5.7-11.5.9.

• Re-Implemented iProcurement & all its customizations using Oracle Framework on 11.5.10. Did the entire iProcurement upgrade project myself. Used JDeveloper 9.0.3 to make all extensions/changes to OAF components.

• Enabled supplier punchouts using Oracle Exchange to enable XML/cXML messaging. Helped suppliers resolve

• Developed programs to create Approved Contract PO’s, customized PO Print report for XML related changes.

• Customized “PO Doc creation workflow”, “PO Approval & Requisition Approval Workflow” for iProcurement.

• Configured various SelfService screens in iProcurement, using AK Developer & XML Templates.

• Resolved problems with cXML messages/encoding.Enabled PO_007 outbound messages via exchange for suppliers

• Negotiated OAG XML PO_007 & response BOD documents with various suppliers for seemless B2B integration.

DeKalb County Government July ‘06 to Dec’06

Oracle Payroll, HRMS Implementation –R12 Senior Consultant

Role & Responsibilities (Techno-Functional)

• Designed process flows for Payroll and HR processes

• Understood the current county business process and designed a functional solution using Oracle Payroll/HRMS.

• Performed setup steps, for defining key flex fields and descriptive flex fields. Created various lookups and value sets.

• Created elements, element links, balances and dimensions for various information elements

• Developed Fast Formulas and Defined Processing Rules by assigning Elements to Formulas.

• Designed and developed custom views for payroll earnings, deductions, net payment, and payroll summary for custom reporting.

• Prepared and tested all conversion programs, mappings for legacy HR and Payroll data

• Defined standard operating manuals for end users

• Performed various extensions to iRecruitment, OLM & SSHR using OA Framework, Business Events & Web Services. All the extensions were made in upgrade-safe manner. Set benchmarks for extensions in OAF

• Customized the core Self Service HR Workflow to implement various different business requirements.

• Coordinated all systems related training for the Payroll department

• Oracle HRMS/Payroll patches management. Maintain patch schedules, analyze patch impacts, and coordinate with business, development and infrastructure team to deploy patches and upgrades

Environment:

OA framework (Self Service), Jdeveloper 9i/10g, QuickApache with Jserv, PL/SQL Windows NT, UNIX Shell Programming, XML publisher (Oracle BI publisher), HTML DB,WorkFlow

TASQ JAN ‘06 to Jun’06

Order Management, Receivables, Inventory, Order Management Senior Consultant

TASQ offers state of the art POS products including terminals and peripherals, Ethernet, IPenabled devices, and contactless readers.

Role & Responsibilities:

• Personalized/Customized OAF pages in Order Management, implemented PPR,

Substituted/extended the seeded regions, COs & VOs.

• Created Order search functionality in OAF for Call center -Tasq employees

• (Call center department will not have access to oracle eBusiness,This will facilitates the department to search order information with out login in to oracle)

• Personalized Sales Order screen as per user requirement (added filters)

• Created a custom-wrapper in Sales Order entry search screen - Result region to show Order link only when order is confirmed or approved.

• Created security function model in OAF -It will make sure pricing info will be displayed only to authorized users

• Created a custom search functionality of finding invoices in Order status tab.

• Delivery details screen - Result region to show Order link only when order is confirmed or approved.

• Delivery details screen - Created a customized folders/views in OAF for requested to users based on pickup status

• Order Details screen - Created a Order detail report in XML Publisher and integrated the Report in OAF,

• Developed Order Import API to import Sales Orders from Hire Sales screen into standard Oracle Order Entry. - Using order management open interfaces

• Workflow -Created Defect workflow is created which will send notification to subscribed group when Defect Report data is entered in Order delivery screen.

• Created summary of sales order reports in xml publisher which will be sent automatically to management Customized the transactions Adjust page to change the commission amount and type.

Environment:

OA Java, JSP, Workflow, Developer 6i, TOAD, Linux

TASQ Jun‘05 to Dec ‘05

Oracle CRM Implementation Senior Consultant

Implementation of Oracle CRM to support CHC-Tasq information system (call centers) that enhance constituent service and improve efficiency. With CHC, customers benefit from one easy-to-remember point of contact for government information and services, while government agencies minimize non-emergency calls to 911, leverage visibility into cross-departmental data, enhance service delivery and reduce administrative costs.

‘

Role & Responsibilities:

• Analyze requirements and write functional, technical, and design specifications for CHC.

• Work with various teams to gather requirements, configure modules and implement solutions to meet the requirements.

• Design, Develop, Test and implement application extensions and enhancements.

• Enforce application standards and procedures.

• Provide the subsequent technical support of these production systems and/or enhancements.

• Troubleshoots complex problems in relation to systems requirements.

Environment:

OA framework (Self Service), Jdeveloper 9i, QuickApache with Jserv, PL/SQL Windows NT, Unix Shell Programming.

Oracle Corporation Mar‘02 to Jun ‘05

Oracle eBusiness Tax Senior Applications Engineer

Oracle eBusiness Tax is a single point solution for transaction-based tax service needs. With Oracle eTax, transaction-based taxes are simpler, easier and faster to configure, maintain, manage, and access. To address the myriad of tax needs, from managing global tax compliance requirements to responding to local tax audits, Oracle eTax is the solution for content, determination, recording, administration and information services.

The implementation of this common tax platform requires a meta data model that can be easily maintained and expanded. New and current markets alike can be supported with a tax knowledge base that stores tax definitions and tax rules, which can be extended to support local and industry rules. As local regulations change, this model provides the flexibility to add and modify rules accordingly. A common tax platform can also prevent data fragmentation across regimes and geographies, while providing integration and a collaborative environment by leveraging the knowledge base throughout the E Business Suite. A global company should have visibility of their data, both content and business transactions across different tax regimes or geographies, hence providing the necessary information for global and comprehensive tax management.

Also involved in integration of Selfservice HR, iExpenses and iProject modules through Selfservice customizations.

Role & Responsibilities:

• Integration of Selfservice HR, iExpenses and iProject modules through Selfservice customizations.

• Developing Core Components using J2EE, Java, JSP, JDBC,BC4J, XML, SQL deployment in Oracle 9iAS,Quick Apache.

• Development of UI and subsequent coding for the business logic of the eBTax module

• Involved in designing and development of business rules and transactions into in BC4J components

• Developed Model Objects like Entity Objects, View Objects, Application Modules

• Implementing Specific UI Features like Charts and Graphs, List of Values (LOV),

HGrid, Hide/Show and all form Components

• Implementing Server-Side Features like Java Entity Objects , Entity Experts, Validation View Objects and Validation Application Modules

• Implemented ‘Browser Back Button Supporting ’ feature in the eBTax UI pages.

• Implemented ‘Logging Infrastructure’ feature in the eBTax UI pages.

• Involved in the preparing/reviewing the Detailed Design documents and Unit Test Plans.

• Used PL/SQL, Stored Procedures and triggers for handling database processing.

• As an SQA Involved in Quality Planning, Defect Prevention, Metrics collection ,IA/IIA, Process Maintenance.

• Completely involved in Production support from client requirements to developmental aspects with coding, system optimization and testing.

Environment:

Java2.0, OA framework (Self Service), J2EE, Servlets, JSP, Jdeveloper 9i, Oracle 9i AS,, QuickApache with Jserv, RCS, PL/SQL, XML/ Windows NT, Unix, Tarantella.

Perot Systems July ‘01 to Mar’02

Avalon Associate

Avalon Project is a web application developed for the US Embassy to organize the processing of US Visas for the applicants of the same. The idea behind the project is to facilitate the stamping of Visas for individuals or groups by allocating a fixed date on behalf of the Embassy, when they could come and get their visa processing done. US Embassy would have a number of registered agents in various parts of the state. These agents would use Avalon web application. Those people who would like to fix a date for appointment with the US Embassy for their visa interview would approach agents. Agents log onto the application and choose a suitable date for the appointment. Facilities are provided for rescheduling and postponement both from the agent’s side and the Embassy’s side.

Role:

• Involved in the architecture of the modules according to the J2EE standards (Client tier, Web tier and Business).

• Developed web tier by using Struts Framework, JSPs, Tag Libraries, Servlets, Java Script, HTML, iFrames, Layers, and XML

• Designed & Implemented Common Framework Classes includes Custom Exception Classes, Data Access Frame work classes using JDBC, Logging mechanism using Log4J.

• Involved in Installation and Configuration of Websphere Application Server 5.0

• Developed Stateless Session Beans using Session Façade EJB Design Pattern.

• Developed Singleton classes for initializing the Data Sources.

• Implemented Transactions by setting the Transaction attributes and Isolation Levels for the Session Bean methods.

• Implemented EJB Homes Caching Mechanism using Service Locator Pattern.

• Implemented ANT as the build system.

• Writing complex SQL queries and various Queries, Stored Procedures and Triggers to augment the application logic.

• Designed and Involved in developing Regression Test Suite for the Server Side Components.

• Used CVS for Source Control and Version Management.

• Involved in Reverse Engineering the code and generating Sequence, Activity Diagrams using Rational Rose

Environment:

WebSphere 5.0, Oracle 9i, WSAD, Struts, JSP, EJB, Ant, Java Script, XHTML, CSS, Win CVS, JDBC, Java, J2EE, Log 4J.

Contact this candidate