Built the data and reporting infrastructure from the scratch using SQL services like SSIS and SSRS to provide real-time insights into the product, marketing funnels, and business KPIs for Healthcare client Built data visualizations using Tableau for KPIs that reduced manual reporting by 11 hours weekly Collaborated with stakeholders to model and document business requirements and goals, communicating transparently to meet 98% of deadlines Created user stories in JIRA’s for business requirements and had driven the sprint grooming sessions Identified operating improvements from internal data with SQL, which reduced man hours by 10% year over year Utilized Salesforce Marketing Cloud for personalized customer engagement and journey building Contributed to weekly and monthly reports on product development and design Built a logistic regression model to help the SEO team decide which keywords to target, resulting in a 10% lift in YoY site visitors Partnered directly with the executive team to formulate and report on KPIs across their web properties that received 200M visitors annually using SQL and Excel Developed root cause reports to address problems with customer conversions, successfully revealing insights that boosted conversions by 20%

Hexaware Technologies | Dec 2020 - Aug 2022

Data Analyst

Identified strategic marketing opportunity through detailed analysis with intern team, making recommendations that saved the client over $10K in yearly campaign costs in retail Analyzed, interpreted, converted raw data to information and information into actionable insights for successful business solutions using SQL, Python, MS Excel, Tableau Built data models and maps to generate meaningful insights from customer data, boosting sales by 15% Utilized Pentaho for data integration, created mappings, transformations for data cleaning and preparation Designed and implemented A/B experiments for products to improve the conversion rate by 25% and reduce churn by 10% Proposed interactive feedback ideas on the newly introduced features and gather accurate data Collaborated with product managers, gaining insights into marketing aspects and writing documents Led a team of 1 full-time and 2 contractor employees Trained 3 interns, contributing to a 21% increase in overall team efficiency

ConverseNow.AI | Jun 2020 - Dec 2020

Data Analyst

Developed and owned reporting for a nationwide retention program with Python, SQL, and Excel, saving ~80 hours of monthly labor Tested the web application and came up with optimized solutions to the technical problems as per the business needs Received positive feedback on customer surveys for friendliness and efficiency to help boost repeat customers by 17% Built operational reporting in Tableau to find areas of improvement for contractors resulting in $250K in annual incremental revenue Collaborated with stakeholders for gathering requirements and document them for technical implementations Split the requirements into workable user stories and create JIRA’s for each of them Extracted data in csv format to tables using pentaho integration tool to clean and prepare data for analysis and generating reports in tableau

Publicis Sapient | Dec 2017 - Dec 2019

Data Analyst

Utilized Tableau and SQL to redefine and track KPIs surrounding marketing initiatives for automotive client and provided recommendations to increase the landing page conversion rate by 30% Developed and enhanced several reusable components using HTML, CSS, JavaScript and jQuery for Web application and increased the sales by 25% Entrusted with JIRA admin tasks for both client and team groups Conducted several daily scrum calls and sprint grooming sessions with client and team Organized and documented sprint retrospectives in Confluence Interacted with business stakeholders, analysts to gather, understand, analyze, and document the requirements of Data Warehouse Focused on new system and tools with minimal supervision and trained on Project Architecture by team members Performed application-level DBA activities creating tables, indexes and monitored queries for performance Worked on performance tuning of user queries, execution of frequently used SQL operations and improved the performance by 20% Understand the architecture and navigation and building reports and graph visualizations using tableau

Pixentia | May 2017 - Nov 2017

Data Analyst - Intern

Developed high-value insights through data aggregation, leading to a 25% revenue growth and greater market share for Banking Client Constructed and executed novel solutions to help reach organizational goals and objectives, with an 80% success rate Maximized data integrity with error-detecting processes, resulting in 95% accuracy across databases and data sources Maintained a complaint resolution rate of 93% by resolving customer complaints promptly and effectively Written complex SQLs using joins, sub queries and correlated sub queries Analyzed and conducted studies on the forecast demand and capital of the product Writing scripts for data cleansing, data validation, data transformation for the data coming from different source systems Installing, configuring, managing, monitoring, and troubleshooting MySQL server Creating sprint tracking sheets in Excel and involved in all phases of SDLC process

My Education

Take a look at my formal education

Bachelor of Technology - BTech National Institute of Technology Agartala | 2017

About Me

Actively looking for jobs related to data analysis, data visualization and SQL queries

Create Your Data Portfolio for Free