SUMMARY:

• I have more than 9 years’ experience in Information Technology, more than 6 years in billing and OSS/BSS systems customization, integration, Migration and production support and 9 years of PL/SQL and Oracle experience.
• I have got an extensive experience in systems development methodologies, building and customizing applications, working with the end users to analyze their requirements, defining software design, architecture, specifications, translating requirements into practical systems design and managing all these activities as part of my project assignment.

MY AREAS OF STRENGTH INCLUDE:

• Designing and implementing SQLs and Stored Procedures, Triggers and Functions.
• Strong Knowledge in Materialized View, View and Oracle AQ and Oracle Scheduling Jobs.
• Experience in handling business requirements inside and/or around billing systems and translating them into billing solutions in addition to integration aspects between Billing systems, CRM and Dunning, also one of my main roles was to support billing systems activities (Bill cycle, Payment, Invoicing, Billing reports, Interconnect and integration between different systems).
• Data Migration across billing systems. Involved in end to end Data migration between Telecom COTS products
• Experience in Preparing Cut Over Plan and Migration Strategies.
• Verifying change requests and defects, documenting, tracking and communicating test plans, test results; preparing test reports.
• Performance Tuning and Performance Analysis.
• I have Basic Knowledge in Banking and Heathcare Domain.

TECHNICAL SKILLS:

Databases: Oracle, Mysql, Postgress

Tools: Clarity, Confidential telecom Billing system, Appworx Scheduler,Flexcube, CSG Billing SYSTEM,ICOMS BILLING SYSTEM

Operating Systems: Windows 7/vista/XP/2000, Linux, Ubuntu

Programming Languages: PL/SQL, GoLang, SQL, Python

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Tools: Oracle SQL Developer, Attunity, CSG, ICOMS, APPWORX(Scheduling tool)

SME,SENIOR TELECOM BUSINESS ANALYST/DEVELOPER

Responsibilities:

• Development of Stored Procedure, Package and Function Using Oracle PL/SQL for migration
• Unit testing, Integration Testing Support and User Acceptance Testing Support.
• Develop Logic on Attunity and Data modeling.
• Mapping and developing Scripts (big bang load and Incremental load) for Real time data and Non Real time data between Vantage (CSG) and SOLODB.
• Mapping and developing Scripts (big bang load and Incremental load) for Real time data and Non Real time data between ICOMS and SOLODB.
• Implementing preferred communication in SOLODB.
• Implementing Account match rate calling using SOLODB.
• Implementing Computer telephony integration using SOLODB.
• Confidential (Local Exchange Routing guide) Implementation in SOLODB.
• PPV Implementation using SOLODB to world Box (Ordering and Billing)
• Mapping and developing Scripts (big bang load and Incremental load) between RDM (Data Standards) and SOLODB
• EPC (Enterprise Product catalogue) data Implementation to SOLODB for Ordering.

Confidential

Tools: Facets, Oracle SQL Developer

Designer

Responsibilities:

• Requirement Analysis and Design for the Services on FACETS Perspective
• Development of Stored Procedure, Package and Function Using Oracle PL/SQL.
• Unit testing, Integration Testing Support and User Acceptance Testing Support.
• Facets Designer for Services and Interfaces.

Confidential

Tools: Facets, Oracle SQL Developer

PL/SQL Developer

Responsibilities:

• Requirement Analysis and Design
• Development of Stored Procedure, Package and Function Using Oracle PL/SQL.
• Unit testing, Integration Testing Support and User Acceptance Testing Support
• On - exchange initial enrollment transactions sent by HPS.
• Off-exchange initial enrollment transactions sent by HPS
• Initial enrollment transactions sent by Shop Exchange in the form of X12.
• On-exchange initial enrollment conformation sent back in X12 format to HPS
• Off-exchange initial enrollment conformation sent back in X12 format to HPS
• Off-exchange maintenance transaction sent back in X12 format to HPS
• Initial enrollment transactions sent back in X12 format to Shop Exchange.
• Shield link to Facets Interface to load Groups.
• CR’s on Retrieve Employer Roster.

Confidential

Tools: Flexcube banking System, Oracle 11g,SQL Developer tool

PL/SQL Developer

Responsibilities:

• Requirement Analysis and Design
• Development of Stored Procedure, Package and Function Using Oracle PL/SQL.
• Unit Testing.
• Integration Testing Support and User Acceptance Testing Support
• Development of Notification to customer on Fund Transfer and Booking Contracts.
• Account Masking logic Creation.
• Anti-Money Laundering Upload development
• Flexcube Application and database schema setup for IUT,ITR and UAT
• Anti-Money Laundering implementation on Fund Transfer and Letter of credit module
• Chinese to Numeric Translation for Swift Character On Fund transfer module
• Support for UAT on The development of the above module.

Confidential

Tools: Confidential Telecom Confidential system, Oracle 11g

PL/SQL Developer

Responsibilities:

• The primary target of the assignment was to migrate the existing customer base into HOB platform. I was responsible for end to end billing migration.
• As migration analyst/developer I have not only implemented migrations scripts but also developed solutions for Dunning, Credit Limit Monitoring and batch payment processing and so on.
• Oracle DB Setup on Development, ST, SIT, UAT and Production
• Billing and Reports Developer
• Migration Analyst and developer
• Reports Data model Design and Development
• Oracle DB Setup on Linux Cluster on co-ordination with cable and wireless in London.
• Importing all data and the structure into production.
• Database Script Tuning and Maintenance.
• Integrating the CRMS with Confidential Billing system.
• Dunning and Credit limit monitoring implementations.
• Order management integration with the billing system
• Implementation of Quality Assurance on Billing and Bill runs for a sample customer.
• Migration analyst role at onsite to collect requirements for Loyalty management system, Dunning, Payments and Billing.
• Migration of legacy billing from Metracare to Confidential billing system
• Design and Script development for migration
• Data staging model Design for Migration.

Confidential

Tools: Confidential Telecom Confidential system, Oracle 11g, Berlin SO Scheduler

PL/SQL Developer

Responsibilities:

• The primary role is maintaining the database of the billing system which has Real application cluster.
• I have been developing the customer care system and providing solution to the database issues for a telecom system.
• I have implemented Interconnect Settlement for two or more partners.
• I have been in the client place (Nepal) for 5 months from May to October. I have involved in developing Billing system for the same.
• I was part implementation customer care Prepaid System for Confidential limited and also part of migration to prepaid systems from the base system.
• Post-paid to prepaid number conversion
• Payment follow-up action
• Credit control Limiting
• Migration of data between Billing systems
• Support the billing system 24X7
• Roaming CDR’s billing and rating system
• Build a Management information system ( Confidential ) reports over Post-paid and Prepaid traffic details.
• Build a Management information system ( Confidential ) reports over International Calls (ILD).
• Inter Connect settlement Reports for two operators.
• Migration analyst role at onsite to collect requirements for Dunning, Payments and Billing.
• Migration of legacy billing from Converges to Confidential .
• Data staging model Design and Script development for migration
• Cut over Design and decision planning