Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Anamita Goswami

Bengaluru

Summary

Experienced professional with a strong background in technology-related roles. Proficient in software development, system administration, and technical support. Skilled in problem-solving and optimizing performance. Capable of managing projects and collaborating effectively with teams. Committed to continuous learning and staying current with industry trends to contribute to organizational success.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Data Analyst

Deloitte
Bengaluru
08.2021 - Current
  • Built out the data and reporting infrastructure from the ground up using Tableau and SQL to provide real-time insights into the product, marketing funnels, and business KPIs
  • Designed and implemented A/B experiments for products to improve the conversion rate by 19 basis points and reduce churn by 12 basis points
  • Implemented long-term pricing experiment that improved customer value by 25%
  • Built operational reporting in Tableau to find areas of improvement for contractors resulting in $250K in annual incremental revenue
  • Led a team of 2 full-time employees and 4 contractors.

PLSQL Developer

Deloitte
Bengaluru
07.2019 - 08.2021
  • Partnered directly with the executive team as the first data hire to formulate and report on KPIs across their web properties that received 225M visitors annually using SQL and Google Sheets
  • Built a logistic regression model to help the SEO team decide which keywords to target, resulting in a 15% lift in YoY site visitors in 2018
  • Collaborated with product managers to perform cohort analysis that identified an opportunity to reduce pricing by 22% for a segment of users to boost yearly revenue by $730K
  • Developed root cause reports to address problems with customer conversions, successfully revealing insights that boosted conversions by 32%.

SQL Developer

Deloitte
Bengaluru
12.2018 - 07.2019
  • Developed and owned reporting for a nationwide retention program with Python, SQL, and Excel, saving ~90 hours of monthly labor
  • Identified procedural areas of improvement through customer data, using SQL to help improve the profitability of a nationwide retention program by 8%
  • Applied models and data to understand and predict repair costs for vehicles on the market, and presented findings to stakeholders.
  • Integrated multiple data sources into one unified view using views or joins in SQL queries.
  • Performed backup and recovery of databases on a regular basis.
  • Resolved customer service requests related to database errors or performance issues quickly and efficiently.
  • Created database objects like tables, views, indexes and synonyms in Oracle 11g and 12c databases.
  • Evaluated and integrated new database technologies and tools to enhance development efficiency and system capabilities.
  • Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications.
  • Utilized version control systems to manage changes to SQL scripts and database objects, ensuring consistency across environments.
  • Automated routine database tasks through scripting, reducing manual intervention and improving productivity.

PLSQL Developer

Capgemini
Bengaluru
08.2015 - 10.2018
  • Developed shell scripts for automating routine maintenance tasks like index rebuilds and reorgs.
  • Prepared documentation for all the processes involved in developing a software product.
  • Performed Database Administration Tasks such as Creating Users, Granting Privileges.
  • Identified and resolved various issues related to data integrity, security and performance tuning in Oracle databases.
  • Documented SQL development processes, creating a knowledge base for best practices and troubleshooting.
  • Analyzed and resolved complex database and data integrity issues to maintain high availability and reliability.
  • Participated in data modeling sessions, contributing to the development of logical and physical database designs.
  • Created and maintained database objects including tables, views, indexes, and triggers to ensure data integrity and performance efficiency.
  • Provided technical support and training to end-users on database querying and reporting tools.

Education

Bachelor of Technology - Electrical And Electronics Engineering

Sikkim Manipal Institute of Technology
Bengaluru, KA
07-2015

Skills

  • SQL
  • SAS Enterprise Guide
  • Alteryx
  • Power BI and Tableau
  • Excel/ Google Sheets
  • Python Programming
  • Statistics and SAS
  • Statistical Analysis
  • Git
  • Data Analysis
  • GCP Testing

Certification

  • Microsoft Power BI Certification
  • Udemy Alteryx Bootcamp
  • Growth School Data Analytics Program
  • Microsoft Excel -Data Analysis with Exc3l Pivot Tables

Timeline

Data Analyst

Deloitte
08.2021 - Current

PLSQL Developer

Deloitte
07.2019 - 08.2021

SQL Developer

Deloitte
12.2018 - 07.2019

PLSQL Developer

Capgemini
08.2015 - 10.2018

Bachelor of Technology - Electrical And Electronics Engineering

Sikkim Manipal Institute of Technology

Similar Profiles

CREATE PROFILE
Anamita Goswami