Anjali Katara

857-***-**** ad4lj3@r.postjobfree.com linkedin.com/in/anjali-katara Durham, NC

PROFILE SUMMARY

Data interpreter and information manager with a firsthand experience of analyzing & turning large data sets into progressive ideas through the creation of summarized analysis, compelling infographics, maps, data visualizations, interactive media, and product designs. EDUCATION

Master of Science in Data Analytics, Northeastern University – Boston, MA, USA Apr 2019 – Dec 2020 Courses: Communication & Visualization in Analytics, Data Warehousing and SQL, Big Data Management, Predictive Analytics Bachelor of Technology in Information Technology, JECRC, RTU – India Jun 2011 - May 2015 Courses: Data Mining & Warehousing, Python for Data Science, Database management system using SQL TECHNICAL SKILLS

• Programming languages : Python, SQL, R, Java (J2EE), C, C++, HTML5, CSS

• Packages: NumPy, Pandas, Matplotlib, Seaborn, Scikit-learn, Dplyr, ggplot2

• Databases: MySQL, SQL Server, Snowflake, MS Access

• BI Tools: Tableau, PowerBI, Alteryx, Advanced Excel (VBA, Macros, Power Pivot)

• Analytical Techniques: Regression, Clustering, Classification, Time Series

• Statistics: Hypothesis tests, Sampling Techniques WORK EXPERIENCE

Senior Business Analyst, Crum & Forster, Durham(NC, USA) Mar 2023– Current

• Collaborate with business partners in cross-functional efforts to solve business problems using data

• Perform deep dive insight analysis to discover customer behavior patterns

• Develop highly detailed and interactive Tableau dashboards to communicate analytical findings and actionable insights to executive leadership and stakeholders

• Providing timely and accurate analysis/reporting to decision-makers and supporting predictive modelling led by Actuarial team

• Perform data quality assessments and identify data anomalies or inconsistencies using SQL queries and R scripts

•Provide guidance and support to junior analysts on data analysis techniques, SQL querying, Tableau development, and R programming

•Review business processes and identify opportunities and strategies to improve business efficiency Business Analyst, Crum & Forster, Durham(NC, USA) April 2021 – Feb 2023

• Developed dashboards and detailed automated reports highlighting the results that help making appropriate data-driven decisions

• Developed performance tracking and reporting strategy, including audience segmentation, frequency, KPI identification, dashboard definition for identifying impactful and actionable data trends to strategize renewals and track leads

• Generated reports and analyzed large datasets as required by end users using SQL, data visualization and advanced Excel skills to provide timely and accurate analysis to extract some actionable intelligence from the organizational data

• Working with business partners in cross functional efforts to solve business problems using data by building multiple Tableau Dashboards with global context filters to track KPIs in real time Associate Consultant, Capgemini, Pune (MH, India) Oct 2015 – Oct 2018

• Performed data modeling and developed highly detailed and interactive Tableau dashboards to communicate analytical findings and actionable insights to executive leadership and stakeholders

• Assessed and mitigated risk of fraudulent transactions by generating alerts using optimized SQL and Python scripts

• Appreciated by stakeholders for automating critical business integration & processes using Tableau and Alteryx including CASS and Street Geocoder, reducing at least 25% of manual efforts & reliability on MS Excel

• Leveraged visualization capabilities of Tableau to derive insightful and fast dashboards and discovered high revenue generating zones in US for more than a dozen different target factors, and increased efficiency by ~10%

• Automated ad-hoc queries in SQL for frequently requested reports increasing the efficiency of report generation by 30%

• Developed 4 self-serviced ad-hoc Tableau dashboards to forecast network traffic and published reports to server TECHNICAL PROJECTS

Future sales and store location analysis, AT Home Group Jan 2021 – Mar 2021

• Developed ML models utilizing K-nearest neighbor and Linear regression for efficient capital planning in future

• Translated technical insights into recommendations using Tableau dashboard and Python libraries and presented project in storytelling manner to the Director of Data Science and Analytics team at At-Home Group Customer Segmentation, Viacom Aug 2020 – Dec 2020

• Developed estimation models using K-means clustering and Random Forest to maximize engagement factors like Click Through Rate (CTR), Cost per Mile (CPM) and Pay per Click (CPC) at minimal costs. Leveraged Tableau dashboards to showcase analysis

Contact this candidate