Who is Cheshta Kaul!

Academic Background

Master of Science in Information Systems, University of Cincinnati (UC), Cincinnati, OH
Carl H. Lindner College of Business (Expected Dec 2022)
Bachelors in Computer Science and Engineering from Visvesvaraya Technological University (VTU) Bangalore, India
Atria Institute of Technology (AIT) August 2011

Professional Background

University of Cincinnati (UC), Carl H. Lindner College of Business Aug 2021-Till Date
Graduate Teaching Assistant, DIGITAL TECH IN BUS, Cincinnati, OH

Teaching Course work included MS Excel; Access & Python basic

Standard Chartered Bank, Bangalore, India April 2017-Oct 2020
Research Specialist (Global Talent Research Team)

Transforming data into insights from various data sources to support development of Global strategy and initiatives.
Process variety of adhoc/on-demand client requests for reporting and analytics.
Data analysis and market trend analysis based on employee lifecycle within the organization in various locations globally.
Design and build reports, processes, and analyses with a variety of business intelligence tools & technologies (e.g. Advance Excel, Taleo – ATS, Linked IN (for Market research) and Tableau). Present periodic Dashboard reports on the current projects, future opportunities and custom reports analysis.
Manipulating, cleaning & processing compensation data using Excel & handling database using SQL queries for custom projects.
Well exposure to Market data analysis, Stakeholder Management with a focus to foster enhanced client relationships.
Project Management: Design and implement the annual review cycle of the Total Reward principles and implantation guidance, the foundational document of Reward Strategy and Compensation Framework, execution & delivery of assignments with high degree of Client (internal & external) satisfaction.
Tools: SQL queries, Data Modelling, Excel and Tableau

Concentrix, India (Contract), Bangalore, India Aug 2015 to Jul 2016
Lead Analyst

Generate and distribute management reports (Weekly, Monthly and Ad Hoc) in accurate and timely manner (Headcount, attrition, Hire and Monthly compensation reports).
Develop MIS documentation to allow for smooth operations and easy system maintenance. SQL Statements for running report based on the specific criteria. Prepare reports to analyze and forecast business requirement.

Wipro Technologies (Contract), Bangalore, India Apr 2015 to Aug 2015
Consultant

Prepared Quarterly Business Reviews for Company Executives based on the Analysis done on different HR matrices - on different dimensions like Headcount, Terminations, Promotions & Transfers of Employees based. Writing SQL queries to extract data reports.

Sunrise Systems INC., Bangalore, India Oct 2012 – Feb 2015
Analyst

Generating reports and visualization dashboards based on available employee data for workforce planning and management.
Prepare scheduled monthly/weekly reports and HR scorecards to highlight HR metrics for the IT Services and Communication BU.

Eventra Media, Bangalore, India Aug 2011 – April 2012
Business Analyst - Worked onsite at Singapore for Event Management.

Experience in R

During my course in MS IS in UC learnt setting up the R environment to run it successfully on your machine, - Covered fundamental concepts of variables, basics of R; like taking user inputs , printing the output in R and much more.
Learnt structures used in R, the loops, using the built-in functions and creating user functions in R.
In-depth understanding of data structures in R, including vectors, matrices, arrays, lists, dataframes and factors in R programming.
Finally using all the knowledge, learnt visualizing and analyzing data in RStudio by plotting charts and graphs for different use case examples.

Experience with other analytics software

The other analytics software I have worked on are:

Business intelligence technologies,
Data Modelling,
Database Design,
Data extraction,
Data analysis & reporting (MS Excel, MS Access),
SQL queries,
Data Wrangling R,
Tableau and
Python