Arham Sorangwala

***-**** ***** *****, ******, ON, K1G 4E2 613-***-**** adi064@r.postjobfree.com

DATA AND RESEARCH ANALYST

Skilled and energetic Data and Research Analyst with 4+ years of experience in supporting organizational growth and success

CAREER SUMMARY:

Business Intelligence graduate, certified with Power BI, MySQL and Machine learning (with Python and R)

Identifying and analyzing business needs, conducting requirements gathering, and defining scope and objectives

Developing an analytical model and building reports of the survey data using Power BI and also have the knowledge of data improvement using MS Excel and Power BI

Highly analytical and proficient with methodologies and techniques related to statistical and mathematical skills

Team player with effective interpersonal skills and strong oral and written communication skills

Developed business models, wrote proposals and technical reports

Strong work ethics, positive attitude and customer relationship management experience

Excellent attention to detail and strong presentation skills

Ability to work well under pressure, multitask, take initiative and be results-oriented

TECHNICAL SKILLS:

Business Intelligence: Power BI, MySQL, Microsoft Access, Python, R, SAS

Data Analysis: MS Excel, IBM SPSS, SPSS Modeler

Data Visualization: Tableau, MS Excel, Qlik, Plotly E-tab Graphique

Qualitative Analysis: I-tracks, Recollective

Other(s): Social media analytics, Google analytics, MS Project

PROFESSIONAL EXPERIENCE:

Project Coordinator and Data Analyst – Elemental Data, ON (Jan 2019 – Ongoing)

Data collection and analysis for government and private projects, field operations, and senior management for better decision-making.

Taking leads and handling data collection and analysis on project with clients like Privy council of Canada, ESDC, Sun Life, University of Montreal, Finance Canada, etc.

Analyzed and researched upon different market trends in USA and Canada.

Presented the results of complex analysis in easily understandable SPSS Outputs, Wincross Crosstab software, Excel and PowerPoint documents, allowing clients to quickly engage with the findings

Analyzed data using SPSS and presented results of segmentation (cluster analysis), customer behavior patterns and potential factors (regression analysis)

Participated actively in the design, development, testing and implementation of online and telephone survey (Voxco CATI/ Voxco Acuity / Voxco Command centre / Lime surveys / Fluid surveys).

Collaborate with reporting team on a daily basis to go over required targets and to conduct the market data analysis to maintain the accuracy

Contribute to the management of project schedules and providing routine reporting to clients

Collaborate with other team members and internal departments to ensure smooth operation of the study

Arham Sorangwala

211-1541 Lycee Place, Ottawa, ON, K1G 4E2 613-***-**** adi064@r.postjobfree.com

Research Analyst and Field Executor – Algonquin College (Applied Research Department, ON (Sep 2016 – Dec 2018)

Analyzed, interpreted and converted statistics into charts and graph reports to present findings at executive meetings.

Reported findings to supervisor by writing effective reports.

Developed and managed a database in MS Access to gather and streamline the information throughout different departments in the college.

Conducted implementation of early alert activities in place within the academic departments

Collected data through online surveys, in-person focus groups, online focus groups and workshops

Produced reports based on survey by tracking and analyzing it to develop feedback for implementation

Recruited and trained interns to conduct data collection at study sites

Identify and document intervention activities with the faculty members, and administrative and support staff

Reported data to SEMC (Strategic Enrollment Management Committee), Dean, members of faculty and other academic operations in all department

Recommended best practices and suggested metrics to measure impact of intervention on student performance

Data Analyst – Algonquin College (Multiple Projects), ON (Apr 2016 – Aug 2016)

Applied Research Department:

oDeveloped database of all LEAN reports for the college with support of project manager

oHelped on KPMG modelling tool for input into college reports

oGathered data from SEMC SharePoint to transfer to EPE (Education Program Effectiveness) SharePoint

oCompiled data from quantitative research survey, generate reports and conduct focus groups

AC Umbrella Project:

oDrafted several deliverables supporting the social and psychological impact of student lifestyle and habits

oOrganized data by cleaning, sorting and preparing it for analysis in SPSS

oPrepared reports and graphical illustrations using SPSS and tools from MS Office Suite

oProduced data tables and charts for quick visual assessment on the sorted data

oCreated dashboard and customize reports in google analytics

International Education Centre (IEC):

oDrafted deliverables in support of economic impact for international student population

oCompiled extensive data from the results of Annual Barometer Survey

oCompared results from previous years to provide a comprehensive view to Project Manager for prospects

Business Research and Planning/Data Analyst Intern – Transport Canada, Ottawa, ON (Jan 16 – Apr 16)

Conducted meetings with internal project managers to discuss their projects and budget requirements

Collected and analyzed data from industry websites, databases and stakeholders to provide a summary of findings

Processed and entered the data into business planning templates and online application

Provided support to the Program Manager of Business Planning in preparing tables, charts, and reports

Supervisor, Cashier and Store-front Associate – Tim Hortons, ON (Nov 14 – Aug 16)

Handled cash accurately everyday while providing outstanding customer services to diverse customers

Recognized for high quality of work, ability to interact with customers positively and maintain hygiene standards

Increased store profit by addressing customer complaints and turning them into selling opportunities

Earned customer loyalty by practising good listening skills

Arham Sorangwala

211-1541 Lycee Place, Ottawa, ON, K1G 4E2 613-***-**** adi064@r.postjobfree.com

EDUCATION:

Business Intelligence and Market Research – Algonquin College, School of Business, Ottawa, ON (Sep 2015- Aug 2016)

Financial Services – Algonquin College, School of Business, Ottawa, ON (Jan - Aug 2015)

Canadian Securities Course Certification – Canadian Securities Institute (CSC 1 accomplished)

Bachelor of Commerce – The Maharaja Sayajirao University of Baroda, India (Apr 2014)

VOLUNTEER ACTIVITIES:

Student Representative – Algonquin College, Ottawa, ON (Jan 2015 – Aug 2015)

Expose Event – Algonquin College, Ottawa, ON (Feb 2015)

Member of Student Association – The Maharaja Sayajirao University of Baroda, India (Jan 2011 – Apr 2014)

References available upon request

Contact this candidate