Customer Service Sales

RUCHITA TRIVEDI

Email: *******.********@*****.***

Phone: +1-408-***-****

Linked in Profile: https://www.linkedin.com/in/ruchita-trivedi-analyst

OBJECTIVE

An experience public sector banking professional turned student, seeking a position to utilize my skills as an analyst and learn from experience .

ACEDEMIC

Master in Business Analytics (perusing), 2015 – Fall 2016

Major: Business Analytics

Skills:

oQuerying: SQL. Statistical Analysis: SAS (Advanced Level)

oBusiness Intelligence Tools: Tableau, JMP, Microsoft Excel, Microsoft Word.

o Machine learning Tools: JMP, R. Big Data & Analytics : Hive, Pig, Mapreduce.

California State University, East Bay

Bachelors in Technology, 2005 - 2009

Uttar Pradesh technical University, India

Major: Computer Science & Engineering

Diploma Cyber Laws & Intellectual Property, 2009 - 2010

Asian School of Cyber Laws Pune, India,

Major: Cyber laws & Intellectual Security

MAJOR RELEVANT PROJECT

As Masters student in Analytics, we work with relevant datasets in all assignments, class room explanations, Project etc, and apply different algorithms and mining procedures using SAS, JMP, R, Excel and Tableau visualizations. Below are some fairly large size datasets that I worked on

Airline Data: Performed descriptive statistical summaries, Regression, ran various models like Decision Trees, Neural Network, and Clustering in R and SAS to model and predict delay in airlines in a fairly huge dataset.

Medical Provider Dataset: It an interesting real life dataset with deep and complicated relationships between attributes. Tried to model variables of business importance, for answering business questions like what explains the Risk Profile of the patient to Medicare companies, difference in amount paid by Medicare and raised by provider, detecting frauds committed by providers in raising payment claims etc, what explains the difference in payment of Medicare services by states

Pipeline layout optimization at EMUD : My most recent (ongoing) project includes leading a team of 3-5 fellow students to help Fremont Municipal Authorities to optimize water & sewage pipeline installing process. This Project includes understanding the existing process, analyzing the huge amount of existing data that is gathered and understanding the cross-department collaboration. Once complete, project will deliver a model to optimize timeline and cost, a recommendation to collect additional data-points to further improve overall model and propose changes to improve existing process.

PROFESSIONAL EXPERIENCE

Assistant Manager, Industrial Development Bank of India, Bangalore (Feb 2011 – Nov 2013 Current)

Cleared the nation-wide aptitude test and a series of rigorous interviews to join the 10th largest development bank in world (in terms of reach): The Industrial Development bank of India, as an Assistant Manager.

Competed more than 700,000 applicants to secure a place in final 200 seats

Recognized as a youngest officer in the class -1 cadre in The Industrial Development

As an asset officer, did priority sector lending of various kinds including housing loans, education loans, mortgage loans etc. Delivered an annual disbursement target of $350K+ monthly achieved annual disbursement target of ~$8M+.

As a customer service executive, performed time bound operations like RTGS, NEFT,ECS cheque transfers, with a high level of accuracy.

As a sales officer, managed a team of direct sales executives (DST s), to lead various initiatives and sales target. Was a single point of contact for 150+ customers, with a target of moving deposit books by $166K monthly.

Responsible for converting the leads in the CRM software and generating business,

Maintained team performance reports of DST s to identify ' Dead-woods' .

As a customer relationship officer, offered customer friendly services, while minimizing risks and making the business more viable.

Led the negotiations of winning high net worth Indian defense subsidiary account after meticulous negotiations and rigorous follow-ups.

Suggested and implemented various methodological reforms like tracking deliverables under single customer id, which led to proper tracking of deliverables and saving time.

Accomplishments:

Accuracy, Professionalism and attention to detail were some of the skills I inculcated. Maintaining and updating huge customer data to the minutest level of accuracy was something that I had to perform on day –in day-out basis.

Finally, I worked extensively on Microsoft Excel analyzing huge amount of data

Project Trainee - Garrison Engineering Office, Military Engineering Service, Department of Defense, Indian Government (Feb 2010 – Jul 2010)

Key Responsibilities and Accountabilities

Calculated the total of the break-up tenders, for any mathematical errors by

contractors while submitting their bids for contracts.

Prepared fact -sheep on various parameters of construction deployed by the builder, to

facilitate comparative examination by supervisors.

Maintained and kept record of files of builders, pertaining to their previously completed

projects at M.E.S

Key Achievements

1.Project Management & Physical records maintenance

VOLUNTEERING WORK

Actively participated in 'Helpage India' initiatives since school time. Managed raising

funds by organizing stalls, collecting and selling trash and visiting orphanages.

Active contributor to 'Save the Children' non-government organization.

OTHERS

Languages: Hindi, English

Nationality: Indian

Interests: Adventure Sports, Trekking

REFERENCES

Academicians:

Prof. Eric Suess (****.*****@**********.***.)

Prof Vish Hegde (****.*****@**********.***)

Managers:

Pradeep Kumar (********@****.**.**)

Avneet Mahajan (******.*******@****.**.**)

Contact this candidate