We provide IT Staff Augmentation Services!

Oracle Cc&b Functional Analyst/tester Resume

IL

SUMMARY

  • 10+ years of IT experience in software Design, Development, Analysis, Maintenance, Testing, Support and troubleshooting in Energy & Utilities, Banking, Insurance, and Financial Domains.
  • 4+ years of experience in Energy & Utilities industry having worked in variety of challenging environments.
  • Comprehensive understanding of the skills needed to design, develop and implement Oracle Utilities Application Framework (OUAF).
  • Strong knowledge in Oracle Customer Care and Billing (CC&B) using Java, Web Services, SOA, XML, PL/SQL, and database integration techniques with expertise in both Financial Services and Insurance payment processing.
  • Expertise in defining testing overview, approach, strategy, roles and responsibilities and providing SQL back - end testing approach for data migrations
  • Development of test requirements, Creation and execution of test scenarios and scripts for UAT, End to End, functional, system and integration Testing in CC&B
  • Specialized in providing Software QA Black-box testing such as unit, integration, system and acceptance testing for Web, IVR, Intranet & Client-Server applications
  • Expertise in automation tools(ALM, HP Quality Center)
  • Managed and reported on quality, stability and scalability
  • Defined Structured Software Development Methodology and standards for Requirements, Interface, and Software Architecture & Design Specifications, Project Plans, and Verification & Validation Test Plans as well as Programmer Maintenance Manuals plus internal programming templates for module headers and comments.
  • Highly motivated, quick learner, effective communication and strong analytical, organizational skills with anability to get things done on time
  • Excellent Communication and Interpersonal Skills with Strong Technical and Analytical reasoning ability who effectively interacts with Customers and all levels of management

TECHNICAL SKILLS

Billing Applications: Oracle Customer Care & Billing

Programming Languages: C, C++, Java, SQL, PL/SQL, Linux shell scripts

Database Oracle: 11g/10g, MS-SQL Server, MySQL

Web Technologies: HTML, XML, JDBC, JSP, JavaScript, SOAP, WSDL

Tools Used: Eclipse, Putty, Winscp

Operating System: Red Hat, Windows, Mac OS

Testing Tools: HP ALM Quality Center (QC), SOAP UI

Application/Web: Servers WebLogic, Apache Tomcat

Version control: JIRA, GIT

Project: Management

Project Planning: Microsoft Project - MPP, Process Model, MS-Visio, Excel

Tools: HPQC- Issue & Defect Tracker

PROFESSIONAL EXPERIENCE

Confidential, IL

Oracle CC&B Functional Analyst/Tester

Responsibilities:

  • Facilitated meetings with the client and helped in the creation of future state business process documentsbased on existing processes, industry best practices and regulatory requirements for a Utilities client as part of an Oracle CC&B implementation.
  • Responsible for facilitating report design sessions with clients to develop reports in Cognos.
  • Responsible for functional design of reports in CC&B suitable for being developed in the Cognos framework.
  • Responsible for reviewing procedures which will be used to train end users at the client site to use CC&B.
  • Responsible for identifying areas of risk and designing controls to mitigate those risks for one functional areaWithin the CC&B implementation.
  • Analyzed data to compare two methods of estimating future bills for customers based on historical energyconsumption to help senior management make a decision on future state business process.Completed implementation of project through Go Live as well as provided post Go Live support
  • Performed functions in CC&B such as start/stop service, field activities, adjustments, billing, payments
  • Created and executed test scenarios and scripts for UAT, End to End, functional, and system and integrationtesting in CC&B
  • Assisted with Credit & Collections and User Profile testing, including test planning, data staging, configurationchanges, and business process development
  • Managed issues and defect recording and re - testing via documentation using defect management tool SharePoint
  • Assisted in development of training materials, prepared staged data, and conducted end user training courses
  • Provided support in validation and creation of Business Processes by collaborating with business divisionheads to discuss practices and procedures
  • Assisted clients with research, problem solving, and resolution regarding business products, practices procedures, delinquency and disputes
  • Provided general assistance to client regarding a variety of questions, concerns and tasks related to CC&B'sfunctional design acting as SME to team members
  • Lead bill print project to ensure accuracy of the data, layout, and special messaging for all bill print types and variations by producing mapping documentation of software's data file and determining programming rulesand calculations
  • Worked closely with interfaces and vendors including bill print, meter management, reports, and web selfService

Environment: Oracle CC&B 2.3.1, Oracle CC&B 2.4.1, Oracle CC&B 2.4.2,Unix, Java, Oracle, PVCS,HQL, CC&B Java Framework, Putty, SQL Developer, MS-Excel, MS-Word, MS-PowerPoint, Visio, Lotus Notes, XAI

Confidential, IL

Oracle CC&B Functional Analyst/Tester

Responsibilities:

  • Completed implementation of project through Go Live as well as provided post Go Live support
  • Performed functions in CC&B such as start/stop service, field activities, adjustments, billing, payments
  • Created and executed test scenarios and scripts for UAT, End to End, functional, and system and integrationTesting in CC&B
  • Assisted with Credit & Collections and User Profile testing, including test planning, data staging, configurationChanges, and business process development
  • Managed issues and defect recording and re - testing via documentation using defect management tool
  • Assisted in development of training materials, prepared staged data, and conducted end user training courses
  • Provided support in validation and creation of Business Processes by collaborating with business division headsto discuss practices and procedures
  • Assisted clients with research, problem solving, and resolution regarding business products, practices Procedures, delinquency and disputes
  • Provided general assistance to client regarding a variety of questions, concerns and tasks related to CC&B'sfunctional design acting as SME to team members
  • Lead bill print project to ensure accuracy of the data, layout, and special messaging for all bill print types and variations by producing mapping documentation of software's data file and determining programming rulesand calculations
  • Worked closely with interfaces and vendors including bill print, meter management, reports, and web selfservice

Environment: Oracle Customer Care & Billing 2.3.1, Unix, Java, Oracle, GIT, Putty, SQL Developer, MS-Excel, MS-Word, MS-PowerPoint, PL/SQL

Confidential, OH

Oracle CC&B Functional Analyst/Tester

Responsibilities:

  • Responsible for researching regulations and identifying appropriate controls to mitigate risks for variousbusiness processes as part of the risk and controls team for an Oracle CC&B implementation.
  • Co - leader of the CCB Training, Refresher Training Courses and Implementation Team, reviews and revisework procedures and instructions, creates and updates training manuals, ensures compliance to companyregulations and effective training tools for front-end users
  • Provided CC&B system testing & support for the CC&B BSA's for the Customer Service, Collections & Remittance business areas functionalities within the system
  • Assisted with the process and review of system design documents
  • Provided direct CC&B training companywide to employees pertaining directly to each business area's need
  • Conducted new hire training for the Customer Service, Remittance & Credit & Collections Departments
  • Cross trained MSD(Metropolitan Sewer Department) Customer Service Representatives on CustomerService, Remittance & Collection Processes
  • Creates work documents and work procedures for Customer Service, Collections & the Remittance businessareas for the new CC&B system.
  • Responsible for maintaining an issue tracker and organizing meetings with subject matter experts and collaborating with team members to support the creation of future state business process documents.
  • Analyzed access control documentation that summarized end-dated users and responsibilities for observations noted during a pre implementation review related to user access control for a client and createdpivot tables to summarize potential sources of SOD (segregation of duties).
  • Developed an internal portal (Sharepoint) to share documents and created video tutorials and user guidesto help users to use the site effectively.

Environment: Oracle CC&B 2.3.1, Oracle SQL Developer, HP ALM, JIRA, Putty, Citrix Control, CRM, Java, Oracle, Visio, Windows XP/2000, XML, TOAD, SQL PLUS, SharePoint, J Meter

Confidential, TX

Sr. QA/Analyst

Responsibilities:

  • Developed framework related components and Hive analytical queries to extract business critical information as per the business requirements
  • Developed the custom record reader to handle specific inputs
  • Developed the Hive scripts for processing the logs to identify the critical user information like no. of shares purchased
  • Created Hive queries to determine the Sell to cover information
  • Scheduled the workflows using the Oozie workflow scheduler
  • With Map - Reduce, focused on finding frequency of stocks options each year
  • Improved the Hive queries performance by implementing partitioning and clustering
  • Importing & Exporting data from web servers to HDFS, Hive
  • Used Flume to collect, aggregate and store the web log data from different sources like web servers and pushed to HDFS
  • Develop and execute Tests for all new code pushed to the applications. The testing includes UAT, regression and system testing end-to-end.
  • Reviews Functional Specifications, Impact Matrices and Test Cases to understand the functional and technical requirements in order to test the application and verify requirements are successfully met.
  • Conducts test strategy, scenario reviews and test plan walkthroughs. Works with Development teams to insure test coverage for all functionality.
  • Work in conjunction with the Business Analysis and Development teams to ensure that applications meetrequirements and are of high quality.
  • Design test procedures, maintenance procedures and configurations
  • Creates test strategies for application release, Execute test scripts and documents defects for test scripts where the actual results do not successfully meet expected results.
  • Expertise in Mocking up XMLs for Docdata CRs and sending them for LLN for letter transmission.
  • Responsible for loan conditioning in Agent Desktop, VLS, MSP and foretracks
  • Responsible for creating and sending Docdata and Doc simulation requests.
  • Responsible for accessing the third party tools like LLN, GBDS and Vault for checking images for generated letters including cover letters.
  • Usage of Test Management Tool - HP ALM 11.0
  • Usage of Oracle SQL for Test Data analysis in several Databases and Schemas.

Environment: HP ALM, Main Frames, MSP, Agent Desktop, Foretracs, VLS, Java, Oracle, SQL DEVELOPER UNIX, Windows XP/2000, XML, TOAD, SQL PLUS, SharePoint, J Meter

Confidential, MA

Senior Programmer Analyst

Responsibilities:

  • Confidential provides and Investment Operation services for Confidential(Investment managers) in the UK and Paris/Germany, and Fund Accounting for the UK. These functions are currently serviced on the existing Confidential legacy platforms.
  • The services operating on the Confidential platform are converting onto the SSC platform by means of phased approach through which progressive functionality is introduced.
  • The Migration to Enterprise (MTE) includes below
  • Trade capture from Clients Trade Order Management Systems (TOMS)
  • Trade enrichment with security/portfolio reference data and SSI information
  • Trade matching to Broker confirmations (Electronic Trade confirmation): manual and electronic
  • Trade settlement instruction to Custodians (Electronic Trade Settlement).
  • Trade notifications to other third parties (Electronic Trade Notification).
  • Applications used in this approach are Global Transaction Manager(GTM), Global Reference System(Repository),OASYS Global, Quadrant II, Trade Interface Management System/Tloader(For Trade flow into GTM) and Extended Enterprise Reports(Global Transaction Manager/Open Systems Accounting Reports).
  • Understand the Business requirements and convert them into technical specification
  • Written complex SQL's using joins, sub queries and correlated sub queries in Oracle accordingly
  • Created database objects such as Stored Procedures, Functions, Packages, Collections, Cursors, Ref Cursors, Constraints, Views, Database Links and user - defined data types
  • Created Custom Triggers on Application tables to keep track of changes for Auditing in AOMA application
  • Matching the Investment Manager Trades with Counterparty Confirms in GTM.
  • Escalating the discrepancies to Client AXA and making sure the trades are matched within Value date.
  • Trouble shooting i.e. resolving the errors on broker confirmations in GTM.
  • Fund set up in Open System Accounting i.e. Confidential Report generation Application.
  • Data setup in GRS (Repository) such as Broker Delivery instructions etc.
  • Manual Confirmation of the Trades through Manual Confirmation Blotter for the Brokers which are not ETC Eligible.
  • Updating the status of the IM trades to AXA IM on daily basis.
  • Implement various advanced features of Oracle such as Table Partitioning, Indexing strategies, DBMS Scheduler according to the requirement
  • Used Concurrent Version System (CVS) Plug in along with Eclipse tool so that all the developed scripts are checked in, checked out accordingly for any future production build so that different
  • Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines
  • Developed Unix Shell Scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application
  • Provided insights into Performance Tuning, Analysis, and Troubleshooting of the DB layer of the application
  • Documented the work by creating various reference manuals for reference by future testers and users
  • Participated in the QA process through code review, test case and release notes preparation
  • Prepared and Executed Unit Test Plan and Unit Test Cases
  • Performance enhancement and bug fixing of database objects

Environment: Java, Oracle 10g, 11g, TOAD, SQL Developer

Confidential

Programmer Analyst

Responsibilities:

  • Participated in the Analysis and Design of the applications enhancements including both the databaseand application design
  • Created Autosys jobs to automate the Report Generation in .csv and pdf formats.
  • Developed Unix Shell Scripts and as to call the java executables which in turn generate the reports according
  • to the business requirements.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Developed Packages, Stored Procedures, functions and Triggers for the application to validate and create
  • reports in PDF and .Csv format. Has used the UTL FILE Package.
  • Created scripts to create new tables, views, queries for new enhancement in the applications.
  • Developed PL/SQL packages to fetch complex data from different tables in remote databases using joins, sub queriesand database links.
  • Involved in the continuous enhancements and fixing of errors detected in QA and UAT
  • Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error
  • Messages in the application.
  • Involved in designing and execution of test cases.
  • Defect reporting using Synapp Test.
  • Preparation of test logs Using Synapp Test Tool.
  • Participation in Status Reviews with the Customer

Environment: Java, Oracle 10g, 11g, TOAD, SQL Developer

Confidential

Programmer Analyst Chennai

Responsibilities:

  • Developed web components using JSP, Servlets and JDBC
  • Developed presentation layer using HTML, CSS and JavaScript
  • Developed stored procedures and triggers in PL/SQL
  • Involved in fixing defects and unit testing with test cases using JUnit
  • Made extensive use of Java Naming and Directory interface (JNDI) for looking up enterprise beans
  • Developed user and technical documentation
  • Generation of test cases, test scripts for automation and manual testing. Black Box testing, Regression testing.
  • Running test cases and posting defects
  • Prepared Test Summary Report and Test Report
  • Preparation of weekly status report

Environment: Java, JSP, JDBC, SQL Server, Win Runner

Hire Now