Dipesh Shahu Email & Phone Number

Ahmedabad, Gujarat, India

• Monitoring and assessing risk on daily & monthly usage based KPI.• Attaining KPI targets and SLAs to mitigate revenue leakages/losses due to fraud/network abuse.• Carry out root cause management to identify and then implement specific process/people/technology improvements with demonstrable results.• Participate on corporate reporting, MIS, internal audits, process reviews, reporting revenue loss/prevention and SOX audit assistance.• Doing of various analysis like of billing rejection, validation of mediation & billing extract during any network level changes, migration or new product implementation and processing to revenue enhancement & loss prevention.• Work with cross-functional team members from each functional area to review the potential implementation plans and identify the measurable impacts of the implementation plan to each functional area.

Ahmedabad, Gujarat, India

Key Responsibilities as FRS Analyst – Vodafone carrier service➢ Basic responsibility in this role is to diagnose vulnerability to fraud, detect gaps in anti-fraud control continually or periodic monitoring, develop fraud response plan and investigate based on alleged fraud. ➢ Performing early detection, prevention and minimization of losses through reviews of suspect Call Data Records as generated by fraud detection systems.➢ Reviewing and processed alerts on fraud detection systems and recommended appropriate follow-up.➢ Interacting and communicating with the team and internal team members to highlight suspicious cases to the management.System Knowledge –• FMS Tools: IxDetect• Other Tools : Basic of Power BI, MS Access, VBA (visual basic advance ) Coding, Advanced Excel

Ahmedabad, Gujarat, India

Key Responsibilities as Business Analyst –Enterprise Ops (NZ)➢ Teamwork: Develop cross-site relationships to enhance leverage of ideas. ➢ Develop consistency across reports and develop meaningful dashboards and publish them. ➢ Teamwork: Develop cross-site relationships to enhance leverage of idea ➢ Individual Contributor (IC)/Managerial: Individual Contributor ➢ Data driven solutions and working on critical Initiatives, identify opportunities to drive data analytics solutions ➢ Code, Test and Execute information systems projects➢ Order assurance and fulfilment of Mobile business customer by coordinating with various suppliers, stakeholders and onshore clients.➢ Accumulate, formulate and represent the business insights for Quarterly/Monthly/weekly business reviews to managements and clients.➢ Creating the SOP (Steps of Procedure) for the new and the existing activities to provide complete governance.➢ Coordinates and carries out the activities and processes required to deliver and manage services at agreed levels for Enterprise customers.➢ Accountable for the management of incident resolution and all service requests fulfilment➢ Management and continuous improvement of the end to end service to the customer, mitigation of the service risks and management of service issues resolution and escalations.System Knowledge –• Assigned Activity :Order Assurance, MIS reporting, MBR ( Monthly business review ), Daily/Weekly/Monthly Dashboards, Productivity report, SoP Updating• Provisioning & Billing Tools: Salesforce, VIPMS, Siebel, Chorus Gateway, Promapp• Other Tools : Basic of Power BI, MS Access, VBA (visual basic advance ) Coding, Advanced Excel ,VDIProject –• I have designed MS Access form base tool (The Vector) for data/entry storage purpose. Due to this now our team can able to publish insight of out business to client. Before this team don’t have feasibility to store day to day operations details.

Ahmedabad, Gujarat, India

Key Responsibilities as Senior Data Analyst – AdvantMed India LLC➢ Import the client data file into company’s system through SQL.➢ Sent the files back to client when Abstraction and coding has been completed.➢ Co-ordinate with software team to develop export format or another special requirement from client side.➢ Co-ordinate with other department for process gap or process enhancement.➢ Providing different projects related reports to department head for project visibility.➢ Responsible for all the automations preparation in MS Access/SQL/SAS for HEDIS and HCC projects to reduce manual efforts.Achievements:• Prepared Export file validation in SAS.• Prepared CFV and Project launch call document in MS Access and SQL.System Knowledge –• Provisioning Systems: Clarify, SASCOMS, GTOMS, Salesforce• Billing Systems : Arbor/Kenan, GCB, SSBS, Thus UNO, Movex, Manual Billing• Other Tools : Ratty, BOXI, , Citrix, Crystal

Ahmedabad, Gujarat, India

Key Responsibilities as Prepaid Billing Configuration Analyst –Fin Ops (VSSI)➢ Billing Configuration Validation check: To ensure the rating and configuration of billing systems, we perform an activity, which compares the Product Catalogs (P-CAT) dumps by version to version. This activity provides us the assurance of all the Products, Tariffs, Voice and Data Plans, GLT codes and Short codes etc.➢ CDR Rating validation: To ensure the charging on raw CDR (Call detail record) level as a post check we perform this activity; in which we take the random Raw Call logs from the UPSS (Unified Prepaid support system) and rate this CDRs manually we compare the same with the Master tariff delivered by the marketing team. This will help us to find and cure the discrepancy in charging of prepaid calls.➢ Handling Audits during the year: To assure all the task which is been designed by the department stakeholders and TRAI we gone through many audits such as TRAI (M&B) audit, Internal audit, Process audits and Compliance audits.➢ Base Validation & Complaints resolution: Due to some manual errors from the different or same vendor, customer got different benefits, henceforth for providing then the desire benefit we accomplish the eligibility check to overall impacted customer base and deliver the actual result.Achievements:• Perform paired circle refund calculation for KOL, ROB, UPE and UPW circle• Successful prepaid billing migration from Siemens to Ericsson for HAR & UPE circle• Prepare tool in .NET for all 23 circle to ensure all the tariff details at one placeSystem Knowledge –• Systems : Comverse I, Ericsson, Amdocs , UPSS, I reporting• Tools & Packages : MS Access , SQL , Unix, Cygwin, MS Word, MS Excel, MS Power Point• Other Tools : IDE, Rating Tree