Ravi Joura

• Headed the customer returns department of Amazon Canada and managed a team of 150 associates
• Reported department metrics and measurements to initiate projects for process improvement
• Initiated project of revamping the inhouse system for processing returns with 150% improved efficiency and CAD 250,000 in saving per year
• Delivered coaching, delegated tasks, set deadlines, recognized high performances and encouraged and motivated team members to strive for peak performances

• Worked on operations records to improve data integrity and accuracy for migration to new CRM system
• Analyzed data stored in a database using statistical principles, SQL Queries, MS Access and Excel
• Completed using automated scripts and manual interventions as appropriate
• Worked with analysts and experts to address various issues

Technical Scope: Tableau, SQL, PL/SQL,Teradata, Unix, Python

Assisted with the development and modification of scripts and procedures in PL/SQL and Teradata as well as built workflows in informatica to modify database tables and developed the scripts using Python and Unix. Supported the creation of a logic for transforming and loading the data in the target tables via appropriate procedures. Established and implemented the reports using Tableau by working in effective collaboration with team members.

Key Achievements:

▪ Developed and delivered a CII Track 4 project for a key client named Anthem/Associate Insurance Company (USA), which handled the data of insurance company WellPoint associated with Anthem. The application help to analyze and present the historical data of customers and prepare quarterly report with Tableau to visualize the growth/loss of company.

▪ Developed ACBI application for Apple to facilitate company in maintaining information of sold Apple products, customer details, and store details for future analysis and identification of key areas of improvements.