Anchal Bansal Email & Phone Number

United States

• Data Analysis, Data Gathering & Cleansing:
• Analyzed data using Python in Databricks Notebooks to perform regression analysis and statistical analysis for predictive modeling of machine operations. This led to actionable insights which improved dealership sales.
• Used R to analyze and transform raw data for data analysis and to identify trends which led to an improvement in data collection of operational metrics.
• Developed KPI metrics to track performance using insights from analysis of more 18,000 machines’ data in Microsoft Databricks SQL.
• Conducted quantitative analysis and correlations on machine data to forecast significant trends within the data and optimize resource allocation.
• Extracted and transformed data from Oracle DBeaver and Azure Cosmos DB. Improving query performance by 35% through optimized use of SQL and stored procedures.

United States

• Data Analysis, Data Gathering & Cleansing:
• Extracted raw data and validated it to make it usable for analysis within Databricks Notebooks and SQL, which fed the data for different machine learning models.
• Cleansed and created clusters of machine data to remove data anomalies and improve the accuracy of data reporting and overall data quality by 46%.
• Analyzed big data in Databricks Notebooks using Python to provide actionable insights to business stakeholders. Data Visualization & Reporting:
• Visualized data in PowerBI reports and provided data-driven insights which were used to improve business outcomes regarding data reporting.
• Used UX principles to improve the user experience and make it easier for stakeholders to get meaningful recommendations from PowerBI reports and PowerBI App.

Boston, Massachusetts, United States

• Data Gathering and Cleansing: Collected data on user feedback and doubled new user acquisition by improving marketing strategies.
• Data Analysis: Created root cause reports and converted data into actionable insights related to payment issues.
• Data Visualization and Reporting: Conducted operational reporting in Tableau to find areas of improvement while fulfilling case queries from the Microsoft Access database.
• Excel and SAP Systems

Bloomington, Indiana, United States

• Analyzed data using Excel on marketing channels and advertising opportunities.
• Converted data from Salesforce’s CRM and predicted and modeled future outcomes.
• Gathered data from Google Analytics and created insightful visualizations on Tableau.
• Created a Business Requirements Document (BRD) and used VISIO to document layout.

Bloomington, Indiana, United States

• Created a front-end prototype using HTML/CSS for their website which allowed for easy usability.
• Performed SEO audit using Google Analytics, Google Trends, and Google Keyword Planner and prepared reports outlining website SEO performance.
• Using SCRUM methodology, managed the JIRA board to establish sprints and increase operational efficiency.
• Collaborated with stakeholders to document Software Requirements Specification (SRS) documents.

Bloomington, Indiana Area

• Dashboard Visualization: Compiled excel sheets to visualize interactive dashboards for marketing research.
• Email/Social Media Marketing: Maintained the company’s front-end website page, and wrote advertising content to generate website traffic.
• Marketing Design: Designed marketing campaigns using Adobe Suite to create Display Ads, Placement Ads, Search Ads, and Remarketing Ads for the target audience.
• Analyzed ad performance for keywords through the Google Ads portal and Google Analytics and improved their placement.

Bloomington, Indiana Area

• Coordinated with Indiana University talent groups to participate in a talent show fundraiser.
• Brainstormed ideas and designed posters to market the talent show fundraiser.
• Executed the talent show fundraiser and raised more than $1500 for the non-profitorganization.

Mumbai Area, India

• Interacted with clients about shipping orders of over 60,000 garment pieces.
• Collaborated with a team to deliver the shipping orders for over 20 different garment styles.
• Analyzed and created financial documents of cost analysis for shipping orders.

Master Of Science - Ms, Computer And Information Sciences, General, 3.8/4.0

Concentration: Data Analytics

Graduate Certificate, Information Technology

Bachelor'S Degree, Information Systems, Marketing, Senior

Activities and Societies: Net Impact Organisation, IU Tassel, American Marketing Association, The Baking Club at IU, Kelley Mentor