An Analytical Thinker
Shivika Gupta
A Resilient Thinker
About Me
Right from my childhood, I have had a strong inclination towards numbers. I am passionate about Economics and Statistics, I completed my bachelor’s degree in Economics, where I developed an interest in data analysis. This interest motivated me to pursue Master of Science in Business Analytics at Clark University. I am an analytical thinker with strong attention to detail and I am skilled in SQL, Python, and Tableau.
Apart from the above-mentioned skills, I am passionate about sketching and it is a stress- buster for me. I love animals, especially cats.
Education
Clark University- School of Management
Massachusetts , America
August, 2019-June, 2021
Master of Science in Business Analytics
GPA-3.92
Relevant Coursework: Analytical Programming, Big Data Statistics, Foundation of Analytics, Management Information System (MIS), Database Management, Digital Market Analytics, Applied Business Analytics and Business Intelligence.
Hansraj College- University of Delhi
New Delhi, India
June,2016-June,2019
Bachelor of Arts in Economics
GPA-3.7
Relevant Coursework- Data Analysis, Micro and Macro Economics, Statistical methods for Economics, Mathematical methods for Economics, Econometrics and Research Methodology.
Work Experience
Pieces of My Career
Tata Consultancy Services, New Jersey
Data Analyst
Jan,2022- Present
Collaborated with IT team to analyze requirements for client's data and effectively deployed business rules.
Utilized ServiceNow, Rally and Excel for efficient coordination with offshore team and analyzing forecasts to schedule, plan, and control project deliverables and manage associates database.
Extracted and synthesized data from Rally to track development, types and trends in defects, ultimately producing a summary of over 12000 defects to curate weekly reports and present it to top management.
Produced quarterly reports tracking billing discrepancies on weekly basis, analyzing gaps and reconciling variance between actuals and forecast
Tyrula LLC, McLean, Virginia
Business Analyst
September 2021- January 2022
Conducted business and data analysis by gathering requirements from clients for reporting improvements, data issues, etc.
Conducted research to study healthcare trends and techniques for better opportunities and best practices and policies.
Built and developed analytical approaches for analyzing and interpreting strategies and testing business models.
Conducted extensive research to benchmark healthcare trends, best practices/policies, & opportunities and policies that improved the business processes
Created in-depth performance presentations coupled with visual representations to aid the executive team’s understanding of current trends
Facilitated weekly meetings with stakeholders to document existing processes as well as to identify opportunities for process improvements and automation
ESAC Inc, Rockville, Maryland
Data Analyst and Developer Intern
June,2020- August,2020
Built ETL pipeline to dump the data in MySQL database to create a centralized database Proteomic Data Commons (PDC)
Automated the data dumping process for the PDC database using National Cancer institute’s API using Python
Developed comprehensive views, functions, triggers, and procedures to implement complex data processing
Created Stored Procedures to ensure the data consistency, completeness, and patterns in the database
Analyzed the database and built visualizations using Tableau to study data trends and patterns and present them to the team
Identified and communicated the data gaps that impede the fulfillment of operational reporting
Generated content (articles, blogs, and mails), presentations to publicize the company and strengthen its base
Clark University- School of Management
Graduate Assistant
Aug 2020-June 2021
Assisted career services team with planning and execution of its career training and development workshops and job fairs
Facilitated SOM's Career Services team with preparing various departmental reports, utilizing Excel, SQL, and Python skills
Prepared presentations to contribute new ideas, insights and highlight the trends in the database
Analyzed, visualized, and evaluated the accomplishment of SOM and its students to strategize marketing campaigns
Provided general support to the student services department and assisted more than 300 students in their coursework and career
Export Promotion Council for Handicrafts, New Delhi, India
Statistical and Research intern
May 2018- August 2018
Collected and analyzed export data of various countries using trade maps to clients and stakeholders within the company
Created a database for the company using MySQL to streamline the data collection processes
Built and developed analytical approaches for analyzing and interpreting export trends and patterns
Identified strategies and opportunities to improve the business performance of the clients
Hypothesized the prevailing prices of handicrafts in the market to understand the level of competition faced by the exporters
Responded to the ad-hoc research requirements to improve the exports of handicrafts
Certifications
Projects
Market Research Analysis
Working as a market researcher for Coca-Cola, created a survey on Qualtrics and collected and processed data in MS Excel to analyze the data and get inferences.
Prediction for Credit Card Defaulters
In this group project, we tried to predict based on various features whether a customer will default credit card payment or not. Python was to build the models and Tableau was used for exploratory data analysis.
Adobe Analytics Challenge
For Adobe Analytics Challenge, performed exploratory analysis on Nike’s Website data and obtained insights on factors affecting Nike’s products sale using Adobe Analytics platform.
Dorm Database Management System
For the database management project, I created dorm database in MS Access using the Entity -Relationship Diagram and used SQL to run my queries.