SUMMARY:

• 9+ years of total IT experience with 5+ years’ experience in Oracle Utilities Customer Care and Billing (CC&B) Functional, Configurational Tools and Testing activities both Manual and Automation tools (HP ALM, QTP) and ORMB Testing
• "Oracle Utilities Customer Care and Billing 2 Essentials" Certified Implementation specialist.
• Very good hands on experience of various CC&B modules like Meter reading, Billing, Rate, Payment, Financial Transactions, Sales & Marketing, Credit & Collection etc.
• Expertise in design and development activities of Oracle CC&B Config Tools components like Portals, Zones, Plug - in scripts, Service scripts, Business services, Business Objects, Case Types and UI Maps.
• Experience in designing Work Flow, automation using Batch Scheduler and Performance Optimization of Oracle CC&B Batch Jobs.
• Understanding business process, study and analyze requirements to design solutions.
• Understand the customer's current business process and future needs, regulatory guidelines and analyze the requirement for solution development
• Experience in CC&B Admin area including Config Lab and Environment Management. Preparing Requirement Document for customer approval.
• Extensive experience with multiple methodologies including Oracle AIM and Agile (AIM)/Scrum, traditional systems development lifecycle (SDLC), change management and change control.
• Handled Functional queries from users and Timely resolution of the high priority tickets raised by business
• Oracle Utilities Customer Care and Billing (CC&B) product implementation experience for Electric, Gas and Water based utility companies at offshore as well as client locations
• Great hands on experience with Quick Test Professional-QTP, Quality Center-QC, ALM, OATS-12.02 and OTM 12.0.0.2
• Great hands on Experience in Framework design with QTP and OATS
• Hands on experience with Visual Basic Script, XML, Java Script, Java, CSS scripting languages
• Good working experience in scripting with QTP and OATS tools
• Good experience in Automating Oracle EBS/ERP applications Forms, Windows, Web and Desktop applications
• Involved in Manual and Automation Functional Testing of Oracle Applications, includes all modules (AP, AR, OM, GL and Projects) and SCM modules (PO, INV, OM) and Iproc
• Avid self-starter and quick learner with strong analytical and problem solving skills.
• Excellent communication, inter-personal skills and can liaise with group.
• Capable of performing under minimal supervision, multi-tasking, meet deadlines as an individual contributor and a committed team player.

TECHNICAL SKILLS:

Products/Tool: Oracle customer care and Billing (CC&B), ORMB, MDM

Configuration Tools: BO's, MO's, BPA script, Service scripts, Plug-in Scripts, Zones, Portals, UI map

Testing Tools: HP QTP9.2,10.0,11.0, HPQC 9.2, ALM, OATS-12.0.2, OTM12.0.2 SOAP API, Manual Testing

Frameworks: Oracle Utilities application frame work(OUAF)

Programming Languages: Core Java

Web Technologies: OUAF Script, JavaScript, VB Script, HTML5, XML

Databases: Oracle 11i, Sql Server 2008 and SQL

Application/ Web Servers: WebSphere Application Server, WebLogic 10.3

IDE (Integrated Development Environment): Eclipse, WID (WebSphere Integration Developer)

Methodologies: Agile, Waterfall

Operating Systems: Microsoft Windows, MAC, Linux and Unix

Development Methodologies: Agile, Scrum and Waterfall

Domain Experience: Utilities, Mining, Stores, Manufacturing, Health

Other Tools: Soap UI, Toad, Putty, WINSCP, Notepad++ and Edit Plus

PROFESSIONAL EXPERIENCE:

Confidential, NC

Responsibilities:

• Worked with project manager to plan testing activities and to provide test estimates.
• Worked closely with technology and project management to ensure appropriate application, user acceptance, performance and end-to-end integrated testing is conducted.
• Worked closely with Dev Leads and production support teams to ensure that application is tested to highest quality.
• Lead the development, publication, and execution of documented QA test plans and test scripts through collaboration with cross-functional teams.
• Manage the planning and execution of product testing efforts, including all associated resources to meet committed delivery dates.
• Represent QA in all planning, leadership and release go/no-go meetings with senior project management and technology staff.
• Analyzed Business Requirements and understood customer and developed QA/UAT Test Plan using Testing Methodology
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the modules (SCM, OM, AR, AP, GL, Project, CM, FA).
• Demo given to the end client on developed scripts and explain the OATS tool Futures
• Set up the environment, OATS Set up and configuration in multiple environments and VMs
• Create and design Automation framework and align the existing scripts with the framework
• Create Automation standards, Best practices and Reusable components across the organization
• Lead the team and grooming the new resources on OATS-Open scripts and OTM
• Import the Manual test cases from QC 9.2 and export the same Manual test cases into OTM
• Analyzed business and user requirements to prepare test plans, test procedures, test cases, and test scripts.
• Worked in Agile Software Development methodology and participated and daily scrum meetings to provide the daily updates and collectively document the team updates.
• Developed test plans and test procedures and executed them manually.
• Used defect tracking tool like QC 9.2 to handle issues. Performed Functional, Regression, backend Testing.
• Executed automation test scripts for GUI, user acceptance, UI, and usability testing.
• Worked in MySQL for backend testing to check the data integrity.
• Generated status reports and reported them to lead on daily basis to communicate testing status using defect tracking tools.
• Performed regression testing for new builds and modified application using OATS.
• Performed web-based testing in multiple browsers using OATS.
• Delivered daily status reports to the team lead and weekly status reports to the project teams.
• Analyzed business, functional requirements and prepared test scenarios and test cases
• Worked with the HR end users for developing UAT test scenarios, test conditions & test cases
• Provided test estimates and timelines to the team lead for different builds and releases
• Performed smoke testing for build verification
• Written standard test scripts for Oracle Financials, HRMS Modules.
• Performed functional, GUI and regression testing of client server based application
• Performed sanity testing on regular basis as a part of the end-to-end testing.

Environment: and Technologies: Oracle R12, QTP 9.2, OATS 12.4.0.2.0, OTM 12.4.0.2.0

Confidential

Functional Consultant

Responsibilities:

• Design and implementation of Change Order:
• Requirement gathering and documentation. It involves preparing Business Requirement Study (BRS) document.
• Map requirements to Oracle CC&B product and identify configuration and customization gap.
• Preparing estimation for the configuration and customization being carried out.
• Prepare Functional design documents and test cases.
• Functionally assist developers during development and unit testing phase.
• Validate unit test results.
• Assist client in performing 'User Acceptance Testing' (UAT).
• Defect Analysis:
• Work on incident tickets raised by client. Analyze defect raised, identify the root cause and provide recommendations to fix the same.
• Prepare analysis document depicting the root cause of the incident and solution for same.
• Work on Unit Test Plan (test cases).
• Depending on the nature of bug, fix the issue by Changing the configuration (if required).
• Work along with developer in case code change is required.
• Product Change Request:Components introduced for integrating CC&B and MDM system: Worked on reviewing functional design, unit test cases and validating System Integration Test results.
• Worked on reviewing functional design and suggesting design changes.
• Executed detailed Quality Assurance testing for Interface customizations at the Post-Go live phase of the Greystone Power electric utility CC&B implementation project.
• Ensured complex client requirements on CC&B product customizations were met.
• Generated test plan scenarios for delivered custom Interfaces which were provided to the client business team.
• Assisted in promotion of Interface code from System Testing to Production environment.
• Led the data conversion effort for the implementation phase & go-live of the Greystone Power CC&B project.
• Completed mapping analysis & documentation for legacy data to adhere to CC&B's different data structure.
• Worked with the client to identify all the mapping between CC&B, MDM and the client's legacy system.
• Developed conversion toolkit scripts for submission of batch jobs on Unix servers which validated & transferred legacy CIS data from Staging to Production on the CC&B product.
• Created complex SQL/PLSQL scripts and processes to validate customized conversion data.
• Analyzed conversion related issues & provided multiple resolution options to the customer.
• Successfully converted CIS data for 120,000 residential & commercial utility customer accounts.
• Consolidated customer account & premise conversion data from legacy ORCOM system to CC&B.
• Delegated a coordinated effort which delivered quality conversion data for the functional testing team.

Environment and Technologies: ORACLE CCB Product, ORACLE CCB 2.3.1 SDK, Java, Hibernate, jsp, Eclipse, Tomcat Server, MySQL, Micro Focus, SQL Developer, SOAP UI, ALM QC, QTP

Confidential

Functional Consultant

Responsibilities:

• worked on Oracle CC&B, Module Billing and Rates.
• Client Interaction & legacy system analysis. Preparation for CC&B module configuration.
• Worked on Case Management such as New Connection Disconnection Re-Connection.
• Generation of V-Structure which includes Person, Account, Premise, SP (with meters attached), SA.
• Generation of bills based on single meter and multi-meter cases.
• Rate Schedules configuration based on consumer categories that is achieved with the help of Rate Components, SQI and Register rules.
• Creation of all the Admin data as per requirement of NDMC based on the type of consumers, tariff structure, collection procedure.
• Creation of user’s hierarchy based on the role and responsibility.
• Full life cycle implementation (Billing & Collection) of ESTATE DEPARTMENT in NDMC.
• Interacting with developers to check and verify the programs customized as per the requirement of the customer.
• Helping Testing Team in debugging the issues related to Billing Module.
• Participated in UAT at Client Site and provided Demo to the Customer. s
• Developing Architect design solutions for a number of processes to fill system gaps for a Smart Grid implementation on the CC&B v2.3.1 product for a client
• Working diligently to meet all customer defined requirements on the Smart Grid effort.
• Leading a group of CC&B Developers in creating viable functional & technical solutions in the CC&B system for 2 new Smart Grid projects.
• Creating functional designs for new extensions in the CC&B product under very aggressive deadlines.
• Providing key functional support to current CC&B users on the client side as well as several implementation partners.
• Participated in data migration for CC&B / MDM data migration
• Worked with the client to identify all the mapping between CC&B, MDM and the client's legacy system
• Involved in the planning/estimate effort for the Smart Grid project design wave phase.
• Applying CC&B product knowledge to create multiple viable solutions in different areas of the system, including a focus on the use of the Configuration Tools capabilities as part of some of the functional designs.

Environment: and Technologies: Oracle 11g, CC&B v 2.3.1, MDM, ALM, QC, ALM QTP

Confidential

Test Consultant

Responsibilities:

• Participated in Requirement review sessions to gather, write and formulate test case scenarios for unit, technical and functional testing of the Oracle RMB application (specifically testing Billable Charges)
• Completed implementation of project through Go Live as well as provided post Go Live support
• Test Consultant for implementing Oracle RMB v2.2.4 application at Confidential, which involved manual testing of the application, providing test planning, test execution and troubleshooting support for the Customer Project team
• Develop test estimates, test plan, test cases and define test data based on business requirement and technical specifications
• Utilize PL/SQL Developer to run various queries and troubleshoot Oracle 10g database tables, Reported, assigned and tracked system defects utilizing Mercury Quality Center
• Involved in analyzing the applications and development of test cases.
• Analyzed and reviewed the software requirements, functional specifications and design documents.
• Developed test scenarios and test procedures based on the test requirements.
• Participated in Preparing Test Plans.
• Developed Test Objectives and test Procedures.
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Defects were traced, reviewed, analyzed and compared using Quality Center.
• Analyzed and imported test data from spreadsheets into Quality Center using Excel.
• Ran scheduled automated test scripts for QTP using Quality Center.
• Conducted database verification testing by using different SQL queries.
• Used QTP to create Regression suite for various test scenarios and executed the suite whenever a code was changed.
• Developed, Enhanced, and Maintained automated testing scripts with QTP for Regression.

Environment: and Technologies: RMB v2.2.4, HP ALM 11.0, HP QTP 11.0

Confidential

Functional Consultant

Responsibilities:

• Understanding business process, study and analyse requirements to design solution.
• Configure the different portals and zones as per business process requirement.
• Working on Oracle Utilities CC&B (Customer Care & Billing) Module.
• Functional and Technical analyst in Billing Module.
• Provide production support for Oracle CC&B project.
• Co-ordinating with analysts for the closure of bugs in the application
• Involved in Customization in CC&B Tool.
• Provided support for testing of CC&B and MDM interfaces.
• Monitoring ticketing tool to identify bugs and closure of the same.
• Writing the SQL queries to provide the data as requested by the client.
• Configuration in CC&B Tool including rate schedules, bill factor and so on.
• Involved in Environment access support.
• Coordinated with clients in order to solve their problems in effective way and quickly
• Responsible for delivering design documents as per functional requirement.
• Creating new connection, providing rates and making bill generated for their connection.
• Interacted with senior managers and taken care by requirements and completed the task as per their requirements.
• Testing support for various change requests
• Responsible for all the Quality work including Audit, Process improvement plan.
• Already Configured the system as per requirement of client in CC&B Module, which involves: Admin Data Preparation and V- Structure generation
• Rates Configuration and Rate Checks and Batch Configuration for Billing & Late Payment Surcharge
• Good exposure in User and role access configuration in CC&B application.
• Coding, Unit Testing, Integration Testing, Peer Reviews.
• Also, involved in Case Management & Order Management by identifying requirements of client & considering
• CC&B Module's configuration & structure & discussion with the development team about to generate the required Algorithms & Scripts to make the system more effective & user friendly. These processes include: New Connection, Dis-Connection, Meter Replacement, Load Enhancement, Misuse/Theft (Enforcement)

Environment: and Technologies: ORACLE CCB 2.2, MDM,SDK, Java, Hibernate, jsp, Eclipse, Tomcat Server, MySQL, Micro Focus, SQL Developer, SOAP UI, ALM QC, ALM QTP

Confidential

Responsibilities:

• Create test plan & Test Strategy for functional testing on Oracle apps R12.
• Propose & implement Test Methodologies/plan (project planning) for onshore-offshore model.
• Expanding testing scope from functional testing to backend testing & automation testing.
• Created and executed GUI, Functional and Regression test scenarios via OTM
• Developed Keyword driven framework for Oracle Application testing suite(OATS’s) for Oracle EBS application.
• Created library of functions, methods and Reusable Actions.
• Enhance the automated scripts and framework depending upon the CR.
• Mentor the junior members in the team.
• Executed SQL queries to validate the data.
• Coordinate with developer & for un-interrupted build & test cycles.
• Review weekly status with key project stake holders.
• Participated in Phase Gate Meeting, Daily Defect Meeting and Sign-Off Meeting.
• Provided Test estimations and Testing Metrics for testing project.
• Preparing Staffing Plan, Work assignment plan for weekly & Daily Basis.
• Preparing Status reports like Monthly Status Report, Weekly Status Report and Daily Defect Report.
• Prepared/reviewed Manual Test Plan, Test Scenarios Documents & Test cases.
• Performed manual testing (Smoke, Integration, System, Compatibility, and Regression).
• Identifying the Risk Based scenarios to execute them on time when the QA timelines are not met.
• Coordinated with offshore team to make sure that all deliverables are in time and accurate.
• Performed Automation Testing, Functional Testing, Smoke testing, Regression testing, System testing and UAT testing in Agile Methodology
• Presenting status reports and communicating project status to the client

Environment: and Technologies: Oracle Apps R12, OATS-12.0.0.4, OTM

Confidential

Software Test Engineer

Responsibilities:

• Involved in development of automation scripts using OATS for oracle EBS SCM Module.
• Involved in development of automation scripts using OATS for custom applications.
• Parameterized the data using data bank feature in OATS.
• Involved in development of a driver script to run all the scripts in a batch mode.
• Identifying the actions in the Script for reusable purpose
• Coding the Identified actions in the Script
• Debugging to Troubleshoot the issues
• Regression Testing when patches applied in the application.
• Execution of the Scripts.
• Performed Automation Testing, Functional Testing, Smoke testing, Regression testing, System testing and UAT testing in Agile Testing Methodology

Environment: and Technologies: Oracle Apps 11.5.10, OATS 12.4.0.2, OTM 12.4.02

Confidential

Associate Test Engineer

Responsibilities:

• Involved in the monthly regression testing release cycle (Every 2nd week in a month) including running the automated test scripts and raises the defects.
• In every monthly release, I prepared the peer reviews and defect and error tracking status and calculate test hours.
• Based on the requirement change the code and write the new functions in the scripts
• Involved to edit /add/delete the scripts OR business components in QC.
• Involved to raising the new defects and add existing defects to the scripts in QC
• During the regression testing, if any functional issue comes, contact to functional team and get the solution accurately.
• Involved in the DC-Migration testing in both SIT and UAT
• Involved in the migration of QTP 9.2/QC 9.2 to and QTP 11/QC11
• Develop and Executed the automation scripts to cancel the requisition in UAT and production environment
• Develop and Executed the automation scripts on PO’s to finally close bulk n UAT and production environment
• Update the category of blankets in production manually as well as through automation script.
• As per the requirement developed the script in QTP for Access team and Security team.

Environment: and Technologies: Oracle Apps 11.5.10, QTP 9.2,11, QC 9.2,11