AMIT TIWARI

Project : Eircom Limited : Trading as Eir, is a fixed, mobile and broadband telecommunications company in Ireland, and a former state-owned monopolist. It is the largest telecommunications operator in the Republic, with a division to service the business & corporate telecom markets in Northern Ireland and Britain.

• Application Details : Telephone Information System (TIS): TIS system is the main billing system used for switched service billing of eircom Retail and Wholesale customers. TIS issues bills to the value of Euro 1.25 billion/annum to eircom's 1.5 million residential and business customers. TIS system is part of the central services. TIS functionality is from Ordering through Payments in the Billing and Customer care. TIS system is the main source for billing and customer data, and it provides input to many systems in eircom.
• TIS is divided into a number of Sub systems which interface with each other: Service Orders(OR),Call processing(DC),Billing(BL),Payments(PM),Flexible Tariffing(FT),Flexible Billing(FB),Archiving(AH),Financial Systems(FS)

Roles and Responsibilities:

• Creating and Modifying new JCL Batch & validation programs for Service orders, Billing and Payments.
• Creating alerts for monitoring and Processing of Bank payment and other interfaces files.
• Automated correcting error accounts and reprocessing them for billing.
• Responsible for code change via FILEAID script and ENDEVOUR change and migration to production after thorough testing ( Like COBOL ,JCL & COBOL DB2 programs etc)
• Various service order code rate change process for wholesale customers
• Preparing HLD , LLD and Deployments plans for various new programs and JCLs Also modification in the batch program and JCLs.
• Responsible for Unit testing , Online change delivery & Creating packages for prod and test migration via Endevour.
• Analyzing various defects, Abends (Abnormal ends) on JCL , COBOL/PL1, DB2 and IMS Programs and providing the permanent fix or workaround till permanent fix.
• Correction for invalid payments and service orders on the accounts for the billing.
• Working on various Demand requests which include Process related queries , File processing , Functional change etc.
• Creating & Working on mantis program for CICS related issues in PROD and TEST.
• Attending requirement analysis meeting to prepare the Ideation Document for new projects.

Project : Eircom Limited : Trading as Eir, is a fixed, mobile and broadband telecommunications company in Ireland, and a former state-owned monopolist. It is the largest telecommunications operator in the Republic, with a division to service the business & corporate telecom markets in Northern Ireland and Britain.

• Application Details : Telephone Information System (TIS): TIS system is the main billing system used for switched service billing of eircom Retail and Wholesale customers. TIS issues bills to the value of Euro 1.25 billion/annum to eircom's 1.5 million residential and business customers. TIS system is part of the central services. TIS functionality is from Ordering through Payments in the Billing and Customer care. TIS system is the main source for billing and customer data, and it provides input to many systems in eircom.
• TIS is divided into a number of Sub systems which interface with each other: Service Orders(OR),Call processing(DC),Billing(BL),Payments(PM),Flexible Tariffing(FT),Flexible Billing(FB),Archiving(AH),Financial Systems(FS)

Roles and Responsibilities:

• Creating and Modifying new JCL Batch & validation programs for Service orders, Billing and Payments.
• Creating alerts for monitoring and Processing of Bank payment and other interfaces files.
• Automated correcting error accounts and reprocessing them for billing.
• Responsible for code change via FILEAID script and ENDEVOUR change and migration to production after thorough testing ( Like COBOL ,JCL & COBOL DB2 programs etc)
• Various service order code rate change process for wholesale customers
• Preparing HLD , LLD and Deployments plans for various new programs and JCLs Also modification in the batch program and JCLs.
• Responsible for Unit testing , Online change delivery & Creating packages for prod and test migration via Endevour.
• Analyzing various defects, Abends (Abnormal ends) on JCL , COBOL/PL1, DB2 and IMS Programs and providing the permanent fix or workaround till permanent fix.
• Correction for invalid payments and service orders on the accounts for the billing.
• Working on various Demand requests which include Process related queries , File processing , Functional change etc.
• Creating & Working on mantis program for CICS related issues in PROD and TEST.
• Attending requirement analysis meeting to prepare the Ideation Document for new projects.

Client Detail : Telstra Corporation Limited (known as Telstra) is Australia's largest Telecommunications and media company which builds and operates Telecommunications networks and markets voice, mobile, internet access, pay Television and other entertainment products and services.

Project 1 Detail: FLEXCAB (FLEXible Customer Account Billing): is the major billing system for Telstra, performing the billing function for PSTN, Mobile (where single bill) and special services. The FLEXCAB system is made up of many components performing message collection, message billing, reporting, bill invoicing, format of invoicing, credit assessment database.

• Under FLEXCAB I work under Invoicing, Pricing And Finance Batch teams as a Shared Resource :

FLEXCAB Invoicing:

• Invoicing Batch collates and formats document and billing information for printing and distribution. It takes-in detailed call charges, other charges, discount information and debtor information (i.e. total of last bill, amount paid, and outstanding balance) from other FFLEXCAB applications, processes them to create totals and then formats them with appropriate headings and messages to create the Invoice. It calculates GST as part of the processing. Along with the actual invoice it can collate/format a score of the other documents like
• · Telstra Group Plan statements (MIPP Memo)
• · Service and Equipment Inventory (S&EI)
• · Call Detail Statements
• · Missed call details
• · Adjustment memos
• · Treatment Notices (Corporate Only)
• · Single Invoice Customer Rate Report(SICR)
• · Multiple Invoice Customer Rate Report(MICR)

FLEXCAB Pricing:

• Responsible for the creation of charges and discounts. These are then used for the creation of bills, discount statements, revenue postings and accruals.
• Pricing uses reference tables which define rate methods and values, and discount plans and structures. The structure is managed by Product Management Application (PMA) Group and Charging and Rating Management System (CHARMS) and processing of these tables lies within the application.
• The product structure reference tables are used by Pricing, and are critical to the application. Processing surrounding the product tables is owned by the application; however the product structure is managed by the Product Management Application (PMA) Group, currently external to the FLEXCAB system.
• · There is no online component to the application.

Project 2 Detail: MARS (Message Access Rating System): is aimed to provide the detail charges for both SMS and MMS Services that are used by Telstra Customers.

• MARS is an application that runs on MVS platform under the logical partition VIO on the E-Plex Server. It is a rating and billing system for Telstra Wholesale. Though the major component of the system is in batch, there is the online component for report creation purposes.
• The number of users to the system is around 20 and mostly comprised of the supporting staff of Telstra Wholesale. The purpose of MARS is to process Network Call Records (NCRs) which are forwarded to MARS by Convergent Mediation Platform (CMP) and other upstream interfaces. These records represent those calls that are passed between Telstra and other carrier networks.
• Depending on the specific call scenario the call records are ignored, reconciled, rated for billing of other carriers or for reconciliation against invoices payable by/to Telstra andother carriers.

Project 3 Detail:The Bank of Queensland (branded BOQ) :is an Australian retail bank with headquarters in Brisbane, Queensland. The bank is one of the oldest financial institutions in Queensland and has 252 branches throughout Australia, including 78 corporate branches and 166 "owner managed" branches.

• Core Banking: Specialized in dealing with Loans, Credit and Debit card transactions oriented with online banking, transaction postings, accruals, generation of reports real time and batch for various departments of the bank.
• Purpose of Application: Signature is the Core banking application used by BOQ. It holds the data for the customers, accounts, transactions and other key data for running the banks processes .It store and forward the information to the external interfaces .It perform accounts accrual processing and postings.
• Key Features of the Application: Account processing - Transaction, time and loan accounts, Branch processing management solutions – BT, CRS, MyClient and Connect, Electronic service – ATM, Internet based retail banking, POS Devices , FDI( First DATA by Fiserve) & ITM( International Transaction Machine).
• Components of the Application: Customer,Common file,Transaction, Time,Loan &General Ledger.

Roles and Responsibilities:

• Validation of batch program and job creation for teams Pricing, Invoicing, Finance and MARS (Message Access Rating System).
• Incident Management, Change Management, Problem Management.
• Working on three productions , six testing environments & online monitors to resolve run-time problems
• Monitor the batch changes , batch performance and resolving the night abends
• Working on various defects, Abends (Abnormal ends), PKEs (Problem Known Errors), PBIs (Problem Investigations), UTR and IAs (Impact Assessment) ,UAT(User Acceptance Testing) , PCR (Project Change Requests ) and accordingly creating JCL , COBOL and DB2 Programs.
• Execution of daily workarounds, monitoring job flows, creating logs, Dashboard weekly and monthly reports using Excel.
• Migration activities both permanent and temporary on WORKBENCH and ENDEVOR during the code fixing and defining a new job.
• Programming, testing and automation using JCL, COBOL , DB2 ,IMS , CList and REXX.
• Responsible for Both paper and electronic billing , Retail Billing, Wholesale Billing PAPER RECOVERY &rebilling .
• Responsible for SKIPPING & REINPUT process for the error Account and USAGE RATE CHANGE PROCESS for selected customers.
• Monitoring, schedule changes ,LATE SHOUTS &scheduling the jobs for testing in Control M in Prod &Dev Environment.
• SQL migration and DB2 query execution in QMF for any change in TABLE.
• Installing & upgrading software for IDMS and third party products
• Recycling IDMS and Defining new Schemas and subschemas also resizing and rebuilding of indexes.
• Fixing DB2 COBOL abends and perform backups ,data recovery, including rollback and roll forward
• Responsible To keep the application rolling and to process all the batch postings, interest accruals on the current balances of accounts, generation of reports, generation of maintenance reports and rolling the system date to the next business date
• Responsible To generates the statements of accounts depending on the statement cycles set up in the common file parameters
• Responsible To The accruals, batch postings, statement and generation of all reports happen on daily basis in the end of day job PCOMB (Process COMBined Daily).
• Common file change like to create new cards , Configurationally changes to provide user access for banking system.
• ITM related issues like ATM & POS link disconnection then using FDI tool INSIGHT2 for temporary connection.
• BSB updates ( any update for branch data), user mandate updates ( user access related), Creating new cost centre for any branch.
• Changing different types of rates for different products of bank, Branch Amalgamation ( Migrating closed branch account customers to any active branch)