Shivam Rai

1) Directv Project (Streaming Network USA):
• Working for Fraud and Strategy Operations with the U.S. Team of the DirecTV streaming network for revenue protection.
• Investigate the fraudulent customers, and make strategic designed to safeguard an organisation streams from various threats, including fraud, operational inefficiencies, and market fluctuations.
• Provide a deep analysis of subscription fraud, theft of identity, and identity verification.
• Using Oracle Service Cloud, Snowflake SQL, LexisNexis, Salesforce, and Excel to verify both residential and commercial clients.
• We run an SQL query in Snowflake to get data on DirecTV customers for batch filling. After a generic review, we upload the data back into Snowflake.
• Applications used: Oracle Service Cloud, Snowflake SQL, Salesforce, CRM, ADAM, RIO, DTV360 (Power BI dashboard), CARMA, CASWEB, eTRACS, and LexisNexis.
2) AT&T Telecom Commercial Billing, USA, and Canada:
• Company Overview: AT&T is an American multinational telecommunications holding company.
• Query handling, quality check, and RCA, mailbox handling, and billing consolidation macro for adjustments.
• Supported the downstream team in making payments to the vendor during high volume.
• Reporting and OE documentation, supported in initiating and implementing the automation process.
• I have done monthly commercial billing for the US and Canada on the IBS tool and run TR102 on a weekly basis to check the payment of clients.
• Application used: IBS billing, DSR Portal, Doc Viewer, Excel, and CIS.

• Ability to read, analyze, and understand the HUB location and CO route in ArcGIS.
• I have worked for Frontier communication fiber project on F2 jobs. As a drafter, I am familiar with AutoCAD.
• Also, knowing ArcGIS tools and map verification from map view, aerial map view, and near map view to verify the easement and utilities where the work would be done.
• I have placed both aerial and buried handhole placement, terminal, and hub placement, and verified the parcel, lot line, easements, and utilities from the county.
• I also know how to draft work prints on AutoCAD, and I know how to work on Aerial View and Hybrid View, in which we can verify the street names: EOP, ROW, Sidewalk, Driveway, and dimensions of the street.

• Ability to read, analyze, and understand specific project scopes of work, and translate them into drafting requirements.
• Aramis (G-tech): In G-tech software, I have done AT&T fiber projects, both geo and workprint. In geo, I placed cable, FST, HH, etc.
• In work prints worked on both Aerial and Buried, I drew land base EOP/BOC and ROW, road name, DOP symbol, show house, and D/W, and placed annotation of cable, pole placed using IKE, etc.
• I have worked in the West Market region, worked on job placement, activation, CBAND, CRAN, and aerial.
• I have also worked on the MOKA project in the South-West market region on activation jobs.
• I also know how to use KMZ files in Google Earth; through that, we can find the work location and verify the pole location and types of poles with the help of latitude and longitude.