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

TECHNICAL SKILLS:

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, Miami, FL

Oracle CC&B Developer

• 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 in bound 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 in bound 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

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

• 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

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