Data Analyst Assistant

Utsab Shrestha

Phone: 862-***-**** E-Mail: ******@*****.***

Website: http://www.sutsabs.com

Proactive and fast learning individual with strong analytical and quantitative skills seeking to work in a dynamic data analytics role utilizing analytical and methodical skills and relevant expertise to help the company achieve business goals while sticking to company’s vision, mission and values.

EDUCATION:

Master of Science in Predictive Analytics, GPA: 3.68 DePaul University, Chicago, IL

Bachelor of Science in Information Management, Minor in Mathematics, GPA: 3.4 Caldwell University, NJ

EXPERIENCE:

Business Intelligence Analyst Jan 2020 – April 2020 Fareportal, New York

• Scripted advanced SQL queries using Stored Procedures and created pipelines to pull in data into PowerBI dashboard report that track KPIs and daily trends to monitor business health and revenue growths.

• Performed analysis of highest growth opportunity areas in python to identify and recommend new ways to improve revenue (e.g. analyses around pricing opportunities, competitive positioning, and customer behavior) to stakeholders.

• Built insights to improve customer retention and marketing opportunities. Worked with cross-functional teams to structure problems, identify appropriate data sources, extract data, and develop integrated information delivery solutions.

Business Data Analyst Aug 2016 – Jan 2020

Alight Solutions, Bridgewater, NJ

• Prepared adhoc reports to track current trends and issues on client team using R studio.

• Improve data cleansing process by creating automation for data cleaning and data validation process in python.

• Gathered information and requirements from new clients to create new enhanced benefits management systems.

• Created complex SQL queries to find test population and ad-hoc queries for updating records in DB2 database DB Client Technology Analyst Dec 2011- Aug 2016

Aon Hewitt, Bridgewater, NJ

• Worked on multiple clients to deliver TBA system that manages client employee benefits

• Worked on automation spreadsheets to improve efficiency and accuracy on manual calculations of client employee benefits using advanced excel tools.

• Introduced Streamdiff tool that compared differences between documents to reduce data testing time by 30 hours.

• Hosted ICAT meetings with the client teams to handoff changes and discuss strategies at the end of each iterations. Public Media Service / Technical Support Assistant Feb 2008 - Dec 2010 Caldwell College, Caldwell, NJ

• Managed and posted announcements in the form of posters, flyers, power point presentations in Caldwell College TV channel and website. [Internship]

• Collaborated with college professors to create a comprehensive digital ‘Teacher’s Evaluation’.

• Provided technical support in repair and installation of software to the students and staff members.

• Supervised and trained students in the computer lab application including Microsoft Word, Excel, Windows and Internet.

Data Science Projects:

• Risk assessment of Suicide using the machine learning techniques (Capstone project)

• Unemployment Rates – Used time series models to compare the unemployment rate forecasts for male, female and overall population

• West Nile Virus – Used various statistical techniques (multiple regression, PCA, LDA, Clustering) to identify conditions and locations where WNV infected mosquitos thrive

• Arson Crime – Used regression model to identify socio-economic factors responsible for arson crime in the US TECHNICAL SKILLS:

Python, Java, HTML, Advanced Excel, Tableau, Power BI, Microsoft SQL Server, R, Oracle, Agile Methodology, Google Analytics

HONORS & AWARDS

Caldwell College Presidential Scholarship, FAVA scholarship, Dean’s List Fall 2007- Spring 2011

Contact this candidate