SUMMARY:

• Worked as a Senior Consultant with 7+ years of experience primarily in Kenan FX Billing. Includes good experience in configuration, customization, automation and testing.
• Requirements specifications gathering and documentation.
• Developed Oracle Stored procedures/packages and triggers for various requirements.
• Developed UNIX shell scripts for meeting customer requirements.
• Worked in OSS/BSS end to end testing of systems which involved Siebel, Metasolv and Kenan.
• Configured the Services which include Broadband DSL, Web Hosting, Web Collocation, MPLS VPN, Message Hosting, Leased Line etc.
• Installed Kenan FX in AIX 5.2 Platform for BSNL’s Development and Production System
• Worked on Usage Processing (COM, MCAP, CAP, RAP, MIU) and Bill Processing (BIP).
• Configured Collections (ARM 3.7.4)
• Configured Journals.
• Configured Payment modules (LBX, EFT, CPM)
• Worked on Kenan API - TS.
• Strong debugging and problem solving skills with excellent understanding of system development methodologies, techniques and tools.
• Good understanding of onsite/offshore work model.
• Sound knowledge in different phases of software development life cycle; including requirement analysis, designing, testing, documenting and preparing requiring specifications as part of software technical requirements.
• Given training and presentation to the client.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX

Tools: Toad, PLSQL Developer, MS SQL Server 2000/2005, Mercury Quality Center

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, XML

Databases/Database tools: Oracle 9i, Oracle 10g

Management Tools: Rational Clearcase

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Windows XP, UNIX AIX 5.2, Oracle 10G

Retail Tester

Roles and Responsibilities:

• Analyze the design requirements document
• Designed and developed Test Scenario/Test Cases/Test steps for various Business Services/methods covering both positive and negative testing requirements.
• Load the test cases into Mercury Quality Center.
• Used Quality Center as the test repository, executing the Test Cases, Test Scripts and logging and generating various reports and graphs for further analysis.
• Identified Defects and discrepancies, documented & tracked Defects in Quality Center
• Co-ordinate with the development team to reduce the gaps.
• Retested defect fixes and provided update to development team.
• Created defect log and metrics summary to be reported to the management.

Environment: Kenan FX 12.0.1, Windows XP, UNIX AIX 5.2, Oracle 10G

Senior Consultant

Roles and Responsibilities:

• Design, configuration and development of Kenan FX for billing application
• Worked on Solution design, system integration and conceptual flows
• Preparation of an analysis & design document that briefly explains the configuration solution based on the requirements provided by the Client. Worked on product configuration for services which include Centrex, Dialup, Broadband, Email, Residential & Business Internet Services etc.
• Responsible for Tax configuration.
• Configuration of the new changes in Test environment, getting approvals for the configurations to be done in production and then the deployment into production database.
• Responsible for handling the change requests/configurations requested by the client which mainly include Package related configurations, Journals, RC’s, Adjustments, NRC’s, Taxes etc.
• Interacting with the client for the feasibility check of the new requirements given by the client.
• Posting general Adjustments and NRC’s for the subscribers with the help of customized PL/SQL procedures.
• Responsible for resolving billing related issues /requests in production environment.
• Responsible for the configuration of Journals for General Ledger system.
• Responsible for preparing and executing the Unit Test cases for the incidents raised by the client.
• Responsible for Deployment and Release Management
• Responsible for training the client and the members of the team in Kenan billing.
• Responsible for analyzing the bill incidents and provide end of month financial forecasts for pending bill incident deployment, highlighting incidents with known Planned Deployment Dates
• Responsible for providing transparency into billing issues.
• Preparing the test cases and loading the test cases into Mercury Quality Center.
• Executing the test cases and updating the status of the test cases in the Mercury Quality Center.
• Co-ordinating with the development team to reduce the gaps.
• Performing the Siebel Production Health check.
• Performing the regression testing in the development environment
• Performing the sanity testing in the development environment

Environment: Kenan FX 1.2, Windows XP, UNIX AIX 5.2, Oracle 9i

Developer

Roles and Responsibilities:

• Responsible for understanding the functional requirements, designing and implementing the complete solution for this module.
• Configured the services offered by BSNL which include Broadband-DSL,BB-Dias, Web-hosting, Web collocation, Message hosting, Leased Line, PSTN, Netone CLI, Dial VPN etc.(Configuration of services, packages, usage rates, discounts, unit credits, NRCs, RCs, Contracts etc)
• Installed Kenan FX for BSNL’s development, Production, Failover and disaster Recovery servers (Unix AIX 5.2 OS and Oracle 9i Database)
• Configured Collections to trigger events like sending remainder letters, suspension notice, suspension, termination due to non-payment
• Configured the Journals for Accounting purpose.
• Developed Oracle Stored procedures/packages and triggers for various requirements.
• Involved in Integration of billing system with mediation which collects raw usage from different network elements and normalize to a format required for billing
• Knowledge about the end to end flow for prepaid subscriber activities
• Given training sessions on Kenan FX for other team members and BSNL.