ABHISHEK RANJAN

ac9c3c@r.postjobfree.com

Mob: +974-********

DOB: 31-May-1980

SUMMARY

I hold an industry total experience of 14+ years and have focused on deliveries in various international projects such as UK Banking and Insurance (Abbey National Bank, Norwitch Union), US Logistics and Supply Chain Company(The Home-Depot) and most recently worked on US and Canadian Telecom projects (T-Mobile and Bell-Canada). I hold a 3 years full time Bachelor’s Degree in Electronic Commerce. I hold an enriching experience in managing all aspects of the telecom processes in Revenue Assurance sector. I carry a stable attitude with an ability to work well under pressure, highly flexible,self motivated, futuristic and adaptable to a fast changing environment with good interpersonal communication skills. PROFESSIONAL EXPERIENCE

Amdocs Development Center LLP

Nov’12-Nov’18

Consumers expect immediate and constant connectivity to personalized services, information and applications. Empowering customers to take control of their experiences in real time, across any channel, network, service or device requires service providers to reshape their BSS, OSS and network domains. Amdocs Customer Experience Solutions redefines the service providers' operating environment by delivering real-time integration from the device to the network, removing traditional barriers to service and system convergence and enabling enriched customer experiences.

As the market leader in software and services for service providers in the communications, media and entertainment industry, Amdocs has a more than 30-year track record of ensuring service providers' success and embracing their biggest challenges. Our extensive product portfolio and wide-range of proven services enable service providers to simplify and personalize the customer experience, harness and capitalize on the data explosion, stay ahead of the competition with new digital services and improve operational efficiency.

(Sr. Revenue Assurance Analyst) Nov’15—

Nov’18

Project: Canadian Telecom: Bell Canada

• Do important Usage validations wherin we check all the usages (OC/UC/RC) one- time/recurring and usage charges applied to customer’s bill cycle is correct and as per his choices by referring service agreement tables etc.

• Prepare documentation on new releases and involved in preparing new queries as per the releases as and when required.

• Runs various SQL queries using SQL Developer, Putty, UNIX to check the issue and release the bill cycles within the set TAT.

• Work on various issues which are constant mainly termed as pull ban issues to be added to each cycle prior releasing it.

• Do sample validations as per different socs/price plan combination so that each one of us does unique bans not the same bans.

• Raise any issues in the bill to our immediate POC which is ABP and do follow ups with various AS teams (CRM, Usage, PP etc) to close the issues.

• Prepare QA Parameter upload every month to track all best top 250 selling PP’s to be added in the coming month.

• Do invoice validations for various type of bills including landline(obe), sympatico(internet), mobility(mobile) and conso( one parent bill).

• Do important Huge Variance checks and the RA report to find any discrepany in trends in recent months vs past few months and run queries to check the cause.

• Raise issues to different support teams with our findings like usage, amdd, amss, application support etc for timely resolutions.

• As Revenue Assurance Analyst, we also do 1st QA, 2nd QA,Pre and Post FBF cycles in QA to check that the issues has been removed and the cycles are in good health to release the cycles.

• Do EOC (end of cycle ) validations every month which checks all big corporate bans are having all usages and adjustments going in as per current bill seq.

• Provide bulk or full release to cycles once all the recurring issues are resolved and given go ahead with different support peer teams.

(Revenue Assurance Analyst)

Nov’12-Nov’15

Project : US Telecom : T-Mobile

• Prepare different reports prior releasing each cycles such as RT Report, DCR Report, QA Automation, Pre-bill, Post-bill shock report etc.

• Prepare sub count sheets by taking approx 1 million customers bans to be worked upon by our group of team members for validation and sample auditing on these Bans.

• Work on various issues which are constant mainly termed as pull ban issues to be added to each cycle prior releasing it.

• Do sample validations as per different socs/price plan combination so that each one of us does unique bans not the same bans.

• Raise any issues in the bill to our immediate POC which is ABP and do follow ups with various AS teams (CRM, Usage, PP etc) to close the issue.

• Do Hierarchy validation which defines the process whether each node is getting correct discounts as per the discount engine set on them.

• Do cycle release as per the final pull ban issues to be forwarded to all the different AS Teams to make them aware of the issues highlighted and found per cycles.

• Work on RT Check Configuration of all the new socs which are going in production as per the set deadlines so that we pull them and validate them on time.

• Prepare QA Parameter upload every month to track all best top 250 selling PP’s to be added in the coming month.

• Doing important checks and validations as per the recent changes went in as per Release document.

• Prepare and modify existing queries as and when required.

• Managed a team of 10 people and been involved in various reporting activities. Zensar Technologies Pvt Ltd - Sr SAP EDI Analyst

Apr’11- Nov’12

Project: US Logistics: The Home Depot

Zensar Technologies is a globally focused software and services company spread across eighteen countries across the world. Zensar provides end-to-end services from IT development to Business Process Outsourcing, from consulting to implementation. With more than 5400 associates and sales and operations presence across US, UK, Germany, Sweden, Finland, Middle East, South Africa, Singapore, Australia, Japan and Poland, the Company delivers comprehensive services in mission-critical applications, enterprise applications, e-business, BPO Services. Zensar is the world's first enterprise-wide SEI CMM Level 5 Company and now a CMMI Level 5 Company with industry expertise that spans across Utilities, Retail and Distribution, Banking, Financial Services and Insurance, Manufacturing and Telecommunications. Zensar Technologies Pvt Ltd - CRM Data Analyst Dec’08 – Nov’12

Project: USA Biomedical Co. ( Fluke Biomedical) LTQ.

• Went to US for transition of this new project called ‘’Biomedical’’ through Zensar.

• Successfully migrated the process offshore and took a sign off on this project single handedly.

• Established and did the setup of this new process successfully here in India at Zensar.

• Successfully trained my backup on this new project called ‘’Fluke- Biomedical’’.

• Was handling a team of 3 members initially on this new project.

• Working in MS-CRM -Dynamics & Citrix platform.

• Responsible for handling all complete company profiles associated with Fluke (Danaher) across US.

• Responsible for generating leads and providing up to date quotations as per the request received.

• Responsible for sending weekly and monthly dashboards to the stakeholders on a regular basis.

• Updating CRM Monthly Funnel reports for territories across US. Project: US Logistics : The Home Depot

• Dealing with our vendors based in US.

• Extensively supporting our Vendors/Suppliers via email or phone.

• Working in a B2B environment with our Vendors.

• Assisting the Vendors with the EDI data transmissions on web.

• Working as Supplier services EDI expert for the Vendors.

• A hardcore inbound/outbound calling process.

• Worked on people management,trainee management and work management.

• Successfully handled many migrations to offshore like GIS,SAP etc. very crucial to process.

• Worked as a liasion for our Level 2 and Level 1 team at offshore.

• Responsible for collating all client updates and maintaing data logs on a weekly and monthly basis.

• Worked as a Trainor/Mentor for the new joinees on the floor.

• Handling client con-calls on a weekly basis and briefing in the monthly meetings.

• Have won many appreciation emails and awards to support my quality work.

• Have succesfully handled TMS process for our THD-SS.

• Worked extensively in preparing SOP’s for the process.

• Worked on SAP/EDI/CITRIX/AS2/VAN environments.

• Worked on EDI documents like 850, 856, 812,864,997,210,214,315 etc.

• Handled onboarding the new partners to the company's Commerce Desk portal

• Strong knowledge in handling B2B production queries of the customers once they are moved in Production.

• Won best Mentor award and best employee award for the 2 succesful quarters in a row.

• Have successfully created many SOP’s which is used in our daily work.

• Have undertaken part in different training activities for the new joinees like cross skill, overall and work specific trainings.

• Have successfully mentored many new joinees which are doing great on production floor.

• Have received many appreciation in the form of emails or on call from internal as well as external customers to prove my quality work.

• Have successfully handled TMS process for our THD-SS.

• Received many recognition awards like IPOD,USB CORD, Home Depot Apron, Orange Certificate award etc to name a few.

• Succesfully handled 812-RTV-CD project across all Vendors who were getting affected due to our internal system glitch and were retransmitted thus submitted the project and shared with all the big who’s who of ‘’THE HOME DEPOT’’ which saved millions of dollars which were earlier used in retransmitting the documents.

• Worked on applications like SAP/EDI/GIS/VAN/IDOC etc.

• Been chosen for and awarded ‘’THE BEST MENTOR AWARD’’ for two successful quarters in a row.

• Been awarded with ‘’THE BEST EMPLOYEE AWARD’’ for our client in the year’10. Ntrance Customer Services Pvt Ltd Jan’

07-Nov’08

WNS Global Services is a recognized leader in Business Process Outsourcing ( BPO ) & dealing in Insurance Business in the sales category.. Our proposition is simple. We deliver value to our customers by bringing operational excellence and deep industry and functional knowledge to their critical business processes.

SR.C.S.A – UK ( Norwitch Union) Insurance

Jan’07-Nov’08

• . A Group Personal Pension UK process with operations all over UK and Ireland.

• . Dealing the customers queries on phone or via email.

• . Providing assistance to our customers regarding his group personal pension & policies.

• . Helping with the various aspects of policy requirement since inception till maturity.

• .Worked extensively in handling the finance part of the customers for his pensions.

• .Guiding and updating the customers with different new schemes and strategies being rolled out as per UK norms.

• . Won appreciation emails and cash prizes many a times in my entire 2 years work period at Ntrance.

• . Chosen as IT & FUN spoc for our team

• . Doing quality checking and sample auditing for the policies processed by the new agents.

• . Chosen as one Point of Contact for conducting the weekly updates session in the team. Mphasis(India) Pvt Ltd, Pune

Oct’04- Oct’06

Mphasis supports G2000 companies around the world in the improvement of their business processes. Company’s unique strength lies in the intersection of our Information Technology( IT) and Business process Outsourcing( BPO) capabilities. Their forte is in the BFSI( Banking, Financial Services, Insurance & Technology Industries.) Transaction Process Executive

Oct’04-Oct’06

Project: UK Bank: Abbey National PLC

• Updating information on customer’s account online.

• Updating reports on Quality and Productivity for the Unit Manager.

• Nominated representative for the agents in within the team as one point of contact to handle issues relating to the agents and queries while processing tasks.

• Cascading quality updates to the team members.

MoneyLine (India) Private Limited,

May’03-Jul’03

A Leading direct sales team of ICICI Bank dealing in credit cards, loans, finances & Banking facilities.

Sales Executive(Credit Cards)

May'03- Jul'03

• The above two months experience was a part of the Final Semester Project to gain marketing skills and upcoming strategies in the respective field.

• Responsible for selling Credit cards for ICICI Bank with the help of Field Executives.

• Collating all valid data submitted by the sales executive for a particular region and upgrading these in the client database.

• Identifying all potential fraud cases within a particular region.

• Proud to be a team member of ‘’The Customer Satisfaction Survey Team’’.

• Awarded as the best performer in the Sales category. TECHNICAL SKILLS:

• Languages: Oracle,SQL, PL/SQL

• Domain: Telecom

• Operating Systems: Windows XP/7/8, UNIX, LINUX,ORACLE etc.

• Tools: WIN SCP, SQL Developer, Remedy, Secure Shell Client, Ultra Edit,Putty, Telnet, RSA, Sharepoint,MS Office Tools, WinZip etc.

• Certificates : Basic and Advanced level completion certificates in Telecom, Orange Certificate(The Home Depot), and UK banking training completion certificate, Letter of Appreciation Certificate for catching exceptional issues in Telecom(T-Mobile) etc.

• Rewards/Recognitions: Various rewards and recognitions including work appreciation certificates and monetary rewards on several occasions. ACADEMIC BACKGROUND

Graduation: Bachelor’s in Electronic Commerce, (IIST, Ghaziabad). 2001-2003 Senior Secondry Education: ST. Xavier’s School, Bokaro Steel City 1998-2000 Higher Secondry Education: ST. Xavier’s School, Bokaro Steel City 1996-1998 Primary Secondry School: ST. Xavier’s School, Bokaro Steel City 1985-1996 HOBBIES

• Cooking veg-non veg tasty delicacies, listening to music, playing cricket/chess with my son.

• Helping him in his studies.

• Writing stories and columns.

EXTRA-CURRICULAR ACTIVITIES

• Participated for “Inter school Football Tournament”.

• Actively participated in various team bonding activities.

• Played in ‘Bokaro District Cricket Association’ representing the state.

• Represented school in various other games like Hockey, Basketball, Atheletics etc.

• Have participated in various socio-economic causes concerning elderly and disabled people at school, organization and near society premises. FAMILY BACKGROUND/ADDRESSES

• Marital Status: Married

• Family Details:. Wife, Shayista Parween and a son Shafin Danish (9 years)

• Permanent Address:. D-405, Splendid Square, Lohegaon, Pune 47, Maharashtra, India.

• Visa status: Looking for work permit visas, open to contracts and fixed tenures.

• Joining Status:. As soon as possible.

• Accommodation :. Required.

ABHISHEK RANJAN

Contact this candidate