We provide IT Staff Augmentation Services!

Oracle Rmb Developer Resume

Norfolk, VA

OBJECTIVE:

Around Eleven Plus years of professional experience in design, development, maintaining Java/J2EE Applications, Oracle Utilities Application Framework Customer Care and Billing (CC&B) / Revenue Management and Billing (RMB) & it’s database using Oracle tools on Windows, UNIX and Linux.

SUMMARY:

  • Over Eight plus years of experience in Oracle Utilities Customer Care & Billing (CC&B) Revenue Management & Billing (RMB) Techno functional area and Technical Java Development.
  • Around three years of experience in Java/J2EE Applications development.
  • Hands on experience on Application development using Oracle Utilities Application Framework,
  • Oracle Utilities Customer Care and Billing.
  • Oracle Utilities Meter Data Management.
  • Oracle Utilities Mobile Workforce Management.
  • Oracle Utilities Revenue Management Billing.
  • Hands on experience in creating custom tables, creating Business entity and Entity page maintenance java programs using eclipse SDK.
  • Hands on experience in writing different Batch programs using eclipse SDK.
  • Hands on experience in writing different types of Algorithms, Batch Programs using eclipse SDK.
  • Hands on experience in testing the Algorithm and Batch jobs using JUnit.
  • Hands on experience in developing Change Handlers, Business Components, Page Service, Search Service using eclipse SDK.
  • Good understanding of Core MF - COBOL Programs and customizing the COBOL programs in CC&B
  • Very good experience in writing Java programs, hibernate and HQL queries for customizing Java based Application.
  • Have good understanding most of the core CC&B tables, so can write SQL queries for ad-hoc data.
  • Knowledge in Oracle Architecture, Database Creation.
  • Knowledge on SQL processing, multiplexing the control files and renaming the database.
  • Hands on experience in of in-bound and out-bound interfaces development in using Java.
  • Hands on experience in Premise interfaces development in using Java.
  • Hands on experience in understanding of Autopay and Autopay interfaces development in using Java.
  • Have good experience in oracle tools such as SQL*Plus, PL/SQL.
  • Written SQL and PL/SQL scripts to update data records in mass.
  • Experienced in Crystal Reports, BI Reports and PL/SQL reports on CC&B.
  • Having hands on experience in creating Maintenance Object(MO’s), Business Object(BO’s) and Business Services(BS’s).
  • Hands on experience in UI Map, Different types of zones, Portals, Menus and Navigation Options etc.
  • Hands on experience in writing and developing Data areas, Service scripts, BPA scripts and plug-in scripts.
  • Hands on experience in customizing Schema HTML, CC&B tags, writing Java scripts etc.
  • Hands on experience in developing exposing and consuming web services using CC&B XAI application.
  • Very good understanding of Synchronous, Asynchronous Messages and configuring the XAI application.
  • Good understanding of Oracle CC&B tables and data flow.
  • Strong understanding of CC&B ‘V’ structure and data flow.
  • Strong understanding of effective dated tables and the data.
  • Very Strong understanding of USA Country Utilities Architecture.
  • Have gained knowledge on CC&B Customer Meter Data Management, Payment Processing, Billing, Credit & Collections, and Field Orders & Devices.
  • Very good understanding of Meter Read Import (MRI) - Download and Meter read Export (MRE) - Upload files for ITRON from CC&B.
  • Have good knowledge in payment upload batch process.
  • Good functional knowledge on tenders, tender controls and deposit control of payment processing.
  • Good understanding of Payments balancing and reconciliation.
  • Operating Systems Windows, Unix and Linux.
  • Good Communication and Interpersonal Skills.
  • Development Experience in Oracle Utilities Application Framework using
  • Java (J2EE)
  • Cobol
  • Hibernate/SQL
  • HTML/Javascript
  • XML Web Services

SKILLS AND TECHNOLOGY:

Operating Systems: Windows, UNIX and Linux.

Programming Languages: Java 1.8/1.7/1.6/1.5/1.4 , C, C++, SQL, PL/SQL, HTML, XML and COBOL.

Web Technologies: Java Web Services, JSP, Servlets, SOAP, WSDL, XML, XSL, XSLT. HTML, HTMLDOM, DHTML, XHTML, CSS and JavaScript

Web Servers: Apache Tomcat 6.x and WebLogic 10/9.x

Applications: CC&B (Customer Care & Billing), RMB(Revenue Management and Billing), Version 2.3, 2.3.1,2.4 and 2.5

Modules: Customer Information, Meter Data Management, Field Orders, Payments and Billing Modules.

Java Configuration Tools: Business Objects(BO’s),Business Services(BS’s),Maintenance Object(MO’s),UI Map, Service script, BPA script, Cases, XAI, Zones, Portal, Menu, XAI and CM Packaging.

SDK: BusinessEntity, EntityPageMaintenance, Batch Jobs, Algorithms, Business Components, Change Handler and Junit for Testing.

Development Tools: Java Application Framework, Eclipse IDE, IntelliJ IDE, Crystal reports, BI Reports, PL/SQL for Reporting.

Data Management Tools: SQL Plus, SQL Developer and TOAD.

Integration Tools: Web Services, XML, XAI, and Java

Tools: Utilities Technologies: SoaptoUI for Testing XAI, Azure Devops

RDBMS / DBMS: Oracle 9i, 10g, 11i and 12c, MS Access 2003 and 2007

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, VA

Oracle RMB Developer

Responsibilities:

  • Oracle Revenue Management Billing (ORMB) Framework in turn is based on Oracle Utilities Application Framework (OUAF).
  • Customizing, Developing and implementing code on all RMB modules and SQL Queries
  • Responsible for troubleshooting production issues and fixing the problem after successful troubleshooting.
  • Developed Algorithms and Batch programs based on the requirements.
  • Writing SQL and HQL queries for the application requirements.
  • Modified existing Algorithm java programs
  • Developed Algorithm java program to create To-Do whenever FT type “PS” payment segment is frozen.
  • Developed change handler using java program which will not allow the users to add payment with Match type General suspense on Online.
  • Developed and Modified generic Batch properties file.
  • Developed algorithm to advance the accounting date to the first of the next month within configured window.
  • Developed reports on Financial Transactions (FT's), GL's, Payment and Billing.
  • Developed PL/SQL scripts on billing information and payments.

Environment: ORMB 2.8, RMB SDK, Business Object, Business Service, Maintenance Objects, Zones, Business Entity, Entity Page Maintenance, Portals, XAI, UI Maps, BPA Scripts, Service Scripts, PL/SQL, Stored Procedures, Plug-in Scripts, Batch Program, Algorithm, JUnit, Business Component, Change Handler, Hibernate, Java 1.8, Java Script, HTML, XML, Web Services, Eclipse IDE, SoapUI, PL/SQL, Oracle Developer, Toad for Oracle, Oracle 12c Windows and UNIX/Linux, JIRA for defect tracking.

Confidential, Miami, FL

Oracle CC&B Developer

Responsibilities:

  • Application development using Oracle Utilities Application Framework (OUAF) for Customer Care and Billing (CC&B).
  • Customizing, Developing and implementing code on all CC&B modules and SQL Queries
  • Written PL/SQL Procedures, Functions to process data for reporting in CC&B.
  • Wring Stored Procedures for Crystal reports to pull data.
  • Analyzed and developed different CIS reports on CIS Plus, CIS-OV, CC&B and Banner.
  • Developed start and stop services using WSDL files for the new UI along with email notification to the customer about the start and stop service request.
  • Developed SQL Queries, Views, Functions, Indexes and Stored Procedures for accessing CIS data from the Oracle and SQL Server data bases.
  • Design, Develop and Deploy complex and interactive reports using Crystal reports.
  • Developed Interfaces for different CIS application to collect Meter Reads.
  • As part of On-Demand reports forms/pages development developed UI Maps, Query Zones, Info Zones and Portals in CC&B.
  • Wrote queries on Payments tables, Tender Control and Deposit control tables used for Payments balancing and reconciliation
  • Developed script for water and sewer service point types to know the total consumption and total amount for account per year
  • Writing SQL and HQL queries for the application requirements
  • Developed java program for ACI real time notifications when the customer made the payment through ACI
  • Created of Zones, Portals and Menus for MWM requirement.
  • Developed custom batch program to cancel the FA's when customer paid the full severance amount and cancels FA also completes severance process.
  • Developed change handler using java which will cancel the FA’s based on the MWM status flags.
  • Developed change handler using java program which will validate Person email address and Start Stop mailing override email address format.
  • Responsible for converting custom Cobol programs to java as part of upgrade from CCB 2.3 to CCB 2.4 and CCB 2.4 to CCB 2.5
  • Developed java program using WSDL file for Pool Credit.
  • Developed Service Script and BPA script for different requirements.
  • Developed reports on Financial Transactions (FT's), GL's, Payment and Billing.
  • Developed reports on Payment tenders, Tender Controls and Deposit Controls.
  • Developed java program for service request using WSDL file which can be tracked by the customer's online WASD account
  • Developed reports on ACH payments, Aging reports and bank files.
  • Developed Payment reconciliation, SARA, SOLAR Incentives Reports etc.
  • Created custom tables, creating Business entity and Entity page maintenance java programs using eclipse SDK.
  • Developed Business service and corresponding Java program for custom solutions.
  • Writing Batch Jobs, Algorithm upon requirement of client Using Java and COBOL.
  • Packaging, Migrating and deploying the code to remote client server.
  • Design and Develop complex reports using Crystal reports.
  • Developed Auto pay Services Enrollment using Java SDK and XAI Inbound services to generate WSDL file.
  • Developed programs in CC&B SDK environment for ACI to collect payments, process data and upload the data in CC&B application.
  • Developed Java based algorithms for pay-plan alerts, Field activity alerts.
  • Developed batch jobs for ACI payment processing
  • Written PL/SQL scripts for generating reports on consumptions of services, billing information and payments.
  • Developed Service Programs, Business Service, Application Services and XAI Inbound Services through which XAI Inbound services generates WSDL file.
  • Developed services related to contacts like enabling SMS alerts to a particular account, updating existing contacts details through Java SDK and XAI Inbound services.
  • Developed java programs for Account Enquiry Services.
  • Developed custom customer contact using Java SDK.
  • Developed Case Type, Characteristic, and lifecycle to create Case object.
  • Developing XAI Inbound web services using Java SDK for Interfaces and following
  • Enrolling and un-enrolling of account
  • Services for validating of account and person
  • Created services for retrieving billing information, payment information and financial information
  • Generated services for alerts like partial payments, past due amounts and field activity status.
  • Created custom Look-up for Feature Configuration in CC&B application.
  • Developed services for update Customer contact information using web services.
  • Developed services for IVR to retrieve account number by giving Phone number.
  • Developed Email and Phone update services to update contact information.
  • Developed Start and stop services using web services.
  • Developed Java program using WSDL file for Pool Credit services.
  • Developed High Bill Investigation services using Java program and generated WSDL file.
  • Developed Payment extension services using Java program and generated WSDL file.
  • Developed High bill investigation eligibility and process services using XAI inbound services and generated WSDL file. Developed service program, application service and business services.
  • Developed custom services for Payment extension eligibility and process services using XAI inbound services and generated WSDL file.
  • Modified existing defects on Pool Credit Services on submeter for SP and Water only accounts for denial accounts with denial reason and create customer contact with that denial reason.
  • As part YBYO (You Build You own), I develop my scripts in development environment and deploy them and test them in staging environment and deploy it in Production Server.
  • Customizing, Developing and implementing code on all CC&B modules and SQL Queries
  • Created business component for reusability of common code.

Environment: Oracle SPL Customer Care & Billing (CC&B) v2.3.1,V2.4, MWM V2.2, CC&B SDK, Business Object, Business Service, Maintenance Objects, Zones, Business Entity, Entity Page Maintenance, Portals, XAI, UI Maps, BPA Scripts, Service Scripts, Crystal Reports, PL/SQL, Stored Procedures, Plug-in Scripts, Batch Program, Algorithm, JUnit, Business Component, Change Handler, Hibernate, Java 1.6, 1.8, Java Script, HTML, XML, Web Services, Eclipse IDE, SoapUI, PL/SQL, Tomcat 6.x, Oracle Developer, Toad, Oracle 11G and 12c Windows and UNIX/Linux, Azure Devops.

Confidential, Austin, TX

Oracle CC&B Reports Analyst

Responsibilities:

  • Customizing, Developing and implementing code on all CC&B modules and SQL Queries
  • Written PL/SQL Procedures, Functions to process data for reporting in CC&B.
  • Wring Stored Procedures for Crystal reports to pull data.
  • Analyzed and developed different CIS reports on CIS Plus, CIS-OV, CC&B and Banner.
  • Developed SQL Queries, Views, Functions, Indexes and Stored Procedures for accessing CIS data from the Oracle and SQL Server data bases.
  • Well versed with generation reports using OUAF module, Customer Care and Billing.
  • Design, Develop and Deploy complex and interactive reports using Crystal reports.
  • Developed Interfaces for different CIS application to collect Meter Reads.
  • As part of On-Demand reports forms/pages development developed UI Maps, Query Zones, Info Zones and Portals in CC&B.
  • Wrote queries on Payments tables, Tender Control and Deposit control tables used for Payments balancing and reconciliation
  • Writing SQL and HQL queries for the application requirements
  • Created of Zones, Portals and Menus for MWM requirement.
  • Developed Service Script and BPA script for different requirements.
  • Developed reports on Financial Transactions (FT's), GL's, Payment and Billing.
  • Developed reports on Payment tenders, Tender Controls and Deposit Controls.
  • Developed reports on ACH payments, Aging reports and bank files.
  • Developed Payment reconciliation, SARA, SOLAR Incentives Reports etc.
  • Created custom tables, creating Business entity and Entity page maintenance java programs using eclipse SDK.
  • Developed Business service and corresponding Java program for custom solutions.
  • Writing Batch Jobs, Algorithm upon requirement of client Using Java and COBOL.
  • Packaging, Migrating and deploying the code to remote client server.

Environment: Oracle SPL Customer Care & Billing (CC&B) v2.3.1, CC&B SDK, Business Object, Business Service, Maintenance Objects, Zones, Business Entity, Entity Page Maintenance, Portals, XAI, UI Maps, BPA Scripts, Service Scripts, Crystal Reports, PL/SQL, Stored Procedures, Plug-in Scripts, Batch Program, Algorithm, JUnit, Business Component, Change Handler, Hibernate, Java 1.6, Java Script, HTML, XML, Web Services, Eclipse IDE, SoapUI, PL/SQL, Tomcat 6.x, Oracle Developer, Toad, Oracle 11G and 12c Windows and UNIX/Linux.

Confidential, Orlando, FL

Oracle CC&B Analyst

Responsibilities:

  • Customizing, Developing and implementing code on all CC&B modules and SQL Queries
  • Written Interface between MWM and CC&B.
  • Wrote queries on Payments tables, Tender Control and Deposit control tables used for Payments balancing and reconciliation
  • Writing SQL and HQL queries for the application requirements
  • Created of Zones, Portals and Menus for MWM requirement.
  • Developed Service Script and BPA script for different requirements.
  • Created custom tables, creating Business entity and Entity page maintenance java programs using eclipse SDK
  • Developed XAI Application between CC&B and MWM.
  • Developed Business service and corresponding Java program for custom solutions.
  • Writing Batch Jobs, Algorithm upon requirement of client Using Java and COBOL.
  • Packaging, Migrating and deploying the code to remote client server.

Environment: Oracle SPL Customer Care & Billing (CC&B) v2.4, CC&B SDK, Business Object, Business Service, Maintenance Objects, Zones, Business Entity, Entity Page Maintenance, Portals, XAI, UI Maps, BPA Scripts, Service Scripts, Plug-in Scripts, Batch Program, Algorithm, JUnit, Business Component, Change Handler, Hibernate, Java 1.6, Java Script, HTML, XML, Web Services, Eclipse IDE, SoupUI, PL/SQL, Tomcat 6.x, Oracle Developer, Oracle 11G, Windows and UNIX/Linux.

Confidential

Development of code and Support

Responsibilities:

  • Customizing, Developing and implementing code on all CC&B modules and SQL Queries.
  • Customized and modified the inbound and outbound process written in java programs. i.e. MRE(Meter read Export) and MRI(Meter read Import).
  • I have written queries on Payments tables, Tender Control and Deposit control tables used for Payments balancing and reconciliation.
  • Writing SQL and HQL queries for the application requirements.
  • In CC&B implemented Maintenance Object MO, Business Object BO, Business Service BS, UI Maps. Java Script, HTML and XML Schema.
  • Created of Zones, Portals and Menus for different requirements.
  • Developed Service Script and BPA script for different requirements.
  • Creating custom tables, creating Business entity and Entity page maintenance java programs using eclipse SDK.
  • Developed XAI Application for Premise Char from GIS, Bank Account Validation and Payments.
  • Writing Batch Jobs Algorithm upon requirement of client Using Java and COBOL.
  • Created Batch jobs on Characteristic Types and Ad-hoc Characteristic Value, changing characteristic type with user defined values.
  • Created Java based algorithms on Hi-Low MR, DailRotate of meter read, Encryption, different Alerts based upon the requirement using Java.
  • Created Change handler on premise table on Address page for not to change the address i.e. do not allow user to change any values.
  • Testing of Batch Job and Algorithm using Junit.
  • Written Business components in SDK for reusable code, and written Change Handlers for customizing cc&b application.
  • I have involved in customizing and developing GIS (Geographical Information System) XAI Interface project using XML Schema Web Services on BO, BS.
  • I written the code on add or update premise, premise characteristic information based on received GIS values from GIS XAI service exposed.
  • I created a new GIS/Premise Portal that will allow users to add premises in CC&B using data coming from GIS.
  • Developed BPA Scripts, Service Scripts and Plug-in Scripts for different requirements.
  • I have updated the characteristic type of Account characteristics, Service Point Characteristics, Field Activity Characteristics with adhoc characteristic value using Java SDK programs.
  • I have edited the existing Characteristic type with characteristic value and adhoc characteristic value.
  • Experience in CC&B application navigation in different modules like Customer information, Meter data management, Field Orders, payments and Billing.
  • Have very good understanding of relations between Service Agreements, Service Points, Premise and SA-SP relations.
  • Have very good understanding of CC&B data relationship between Person data, Accounts data and SA data.
  • Have very good understanding between Premise, Service points, Meters and Meter reads.
  • Know the navigation of Control Central, Start/Stop Services for a Premise/SA, identifying account alerts, Premise tree, Person tree, Meter Read tree etc.
  • Good knowledge on relation between Register Read, Meter Read and Registers.
  • Have very good knowledge on outbound interface for meter read down load process (MRI) for ITRON and Inbound Meter read upload process file MRE from ITRON.
  • Have in-depth knowledge on MRI & MRE file formats and the data elements in the MRI & for ITRON and CC&B tables.
  • Have hands on experience in setup and configuration of the Service Cycle, routes and meters for the ITRON download and Upload process.
  • Have hands of experience in identifying flow of data in database tables for the ITRON Download and Upload process.
  • Good Knowledge in identifying different types of Field activities (FA's) and there dispatch groups and there events when they will be created.
  • Good understanding of relation between Field Activities, dispatch groups and corresponding generation Field Orders.
  • Very well know the relationship between Service points, Field Activities and Field Orders.
  • Very Good understanding of Field Orders generation and its corresponding process for creating data in FO download staging table.
  • Have good understanding on Payments processing in CC&B.
  • Know the Relationship between Deposit Controls, Tender Controls and Tenders.
  • Know how to configure new Tender Source (payment vendors) and Tender Types in setup tables.
  • Know how the payments balancing (reconciliation) works in CC&B to balance Vendor payments deposited in bank.
  • Have good understanding of Batch payment upload process and its corresponding staging tables to load the payments in CC&B.
  • Know the purpose of creating tender control id’s and Deposit control ids.
  • Can write easy to complex SQL queries in identifying and updating data in CC&B.
  • Good understanding of Payments Distribute and Freeze Algorithms.
  • Have hands-on experience in writing Oracle stored procedures.
  • Hands on experience in troubleshooting CC&B Algorithms developed in COBOL and developing new interfaces in JAVA using eclipse IDE.
  • Knowledge on Batch Billing process and collections process in CC&B
  • Know the steps in Collection Process, Severance process and Write off Process and there events.
  • Knowledge on Master Batch billing process and there dependent and sequence of process and jobs need to run.
  • Know the purpose of using XAI applications and web services in CC&B, need to work with a team to learn and experience the real time use.
  • Can easily Identifying problems in existing COBOL programs and can customize or fix issues as per the company requirements.
  • Experience in Code packaging, packaging scripts, code migrations using CM Packaging Tool.

Environment: Oracle SPL Customer Care & Billing (CC&B), RMB v2.3, v2.3.1, CC&B SDK, Business Object, Business Service, Maintenance Objects, Zones, Business Entity, Entity Page Maintenance, Portals, XAI, UIMaps, BPA Scripts, Service Scripts, Plug-in Scripts, Batch Program, Algorithm, JUnit, Business Component, Change Handler, Hibernate, Java 1.6, Java Script, HTML, XML, Web Services, Eclipse IDE, soupUI, PL/SQL, Tomcat 6.x, Oracle Developer, Oracle 11G, Windows and UNIX/Linux .

Confidential

Team Member for Support & Enhancements

Responsibilities:

  • Involved in Business Meetings with the customer for fit gap analysis.
  • Involved in Design Meetings and interact with the customer to design the system.
  • Involved in creating Functional Requirements (FS) and Technical Design Document.
  • Participation of Analysis and Design phases the system
  • Developing code on Modules Student, Parent, and Staff .
  • Developed the application using Java, JSP, Servlets, jquery JDBC, HTML, JavaScript
  • Writing PL/SQL queries for the application requirements.
  • Worked from creating JSP to creating Servlets, Java Beans, DAO and EJB components for business specific requirements.
  • I have Used Hibernate as the Persistence Framework, for mapping the object, DB2 as the Database and Hibernate Query Language ( HQL ) to minimize the Queries
  • Developed client and server side validations using JavaScript and Validators of Spring .
  • Resolving all technical issues in student and parents login.
  • Involved in Unit Testing, Performance Tuning and Bug Fixing of the system
  • Developing reports for an application and print options.
  • Debugging/Testing the Applications by providing valid data.
  • Generated XML schema (XSD Files) for each using WSDL.
  • Developed the required web based Day to Day , Monthly and Yearly reports

Environment: Java1.6x, 1.5x, JDK, J2EE, JDBC, Servlets, Hibernate 3.0, JSP, dojo, DWR (Direct Web Remoting), JavaScript, CSS, HTML, HTMLDOM, DHTML, XML, XSL, XSLT,, Web Services, Eclipse, glassfish, mySQL. Oracle.

Confidential

Team Member for Support & Enhancements

Responsibilities:

  • Involved in analysis and design phase for Re-engineering of the existing website
  • Involved in design and development of several students and parent modules in skoolbag.
  • Resolving the issues with Student Profile page issues like data validation, DB constraints etc.
  • Involved in designing new pages and corresponding backend tables etc.
  • Writing complex queries for the application requirements.
  • Involved in resolving technical issues raised by the clients on different modules.
  • Developed Monthly, Daily, Yearly, batch and ad-hoc reports for the application.
  • Developed the application using Java, JSP, Servlets, jquery JDBC, HTML, JavaScript
  • Involved in resolving all technical issues in student and parents modules.
  • Developed SMS notification for the parents module events notification etc.
  • Development and deployment of Enterprise Java Beans.
  • Implemented code for Servlet and JSP Pages and DAO Objects to Connect to Database.
  • Used Hibernate as the Persistence Framework, for mapping the object, DB2 as the Database and Hibernate Query Language ( HQL ) to minimize the Queries
  • Implemented client side validation using Java scripts and Responsible for GUI design.
  • Involved in testing and documentation.
  • Development and deployment of Enterprise Java Beans.
  • Involved in Unit Testing, Performance Tuning and Bug Fixing of the system

Environment: Java 1.6, JDK, J2EE, JDBC, Servlets, Hibernate 3.0, JSP, dojo, DWR (Direct Web Remoting), JavaScript, CSS, HTML, HTMLDOM, DHTML, XML, XSL, XSLT,, Web Services, Eclipse, glassfish, mySQL, Oracle.

Hire Now