Extremely driven and experienced analyst with comprehensive knowledge of database types, big data capture, curation, manipulation and visualization. Creative in finding solutions to problems and determining modifications for optimal use of organizational data to endow analytics, insights, and business intelligence used to advance opportunity identification, process reengineering and business growth.
Overview
6
6
years of professional experience
Work History
Senior Business Intelligence Analyst
ZoomInfo
Waltham, MA
06.2021 - Current
Lead analytics team supporting Zoominfo's TalentOS product, helping product team understand customer base and make data driven decisions.
Created reporting workflows using Tableau & Amplitude for larger Product Analytics team including Requirements Gathering, Development, Testing Integration & Maintenance. Establishing Product Analytics as the Center of Excellence for Data Presentation in ZoomInfo.
Established Analytics GUILD bringing all analytics teams and personal to single forum for discussing analytical challenges, sharing best practices, obtaining data parity and working towards larger organizational goals.
Designed confluence space with all product analytics information including info on KPI's, past and present analysis attachments, prioritization lists and dashboards information. Reducing time spent on prioritization and answering questions on metrics and analysis by 20%
Performed multiple strategic & descriptive analysis to improve TalentOS product adoption, retention, usage and reduce churn.
Built customer engagement scoring system for TalentOS to understand user engagement and predict churn, reducing customer churn rate by 36%.
Conducted search term analysis to identify key search types and search terms with no results using NLTK stop word dictionary and tagged terms using SpaCy pipeline, achieving 50% reduction in search term error rates.
Business Intelligence Engineer
Amazon Robotics
North Reading, MA
11.2018 - 06.2021
Developed project goals, roadmaps, KPIs, data models and analytical solutions for Amazon's automated delivery system.
Lead team of 3 Business Intelligence Engineers, driving data driven informed decision making across enterprise through strategic leadership and guidance.
Built aggregation tables using Glue ETL in Athena to help business analysts and economists to perform analysis; reducing process time by more than 70%.
Gathered requirements, defined metrics, monitored progress and executed multiple statistical analysis' using python by leveraging Jupyter notebook, Pandas, Numpy, Matplotlib and Seaborn packages for multiple beta programs.
Automated package distribution analysis and A/B testing workflows using Python, AWS tools and Spark SQL.
Set up multiple alerting systems to monitor robotic systems performance based on Python, PyAthena, EMR and Outlook.
Designed and deployed more than 30 Tableau dashboards to support, monitor, communicate and present progress of various programs to leadership team.
Served as team's Tableau Server administrator and Subject Matter Expert for data visualization, descriptive analysis, ETL and reporting tools.
Established standard BIE workflow, dashboard creation processes, quality assurance testing, standard of operations documents (SOP) and best practices documents reducing turnaround time by 50%.
Organized various knowledge sharing sessions (Tableau best practices, Tableau and SQL query optimization, Python for data analysis) to improve teams performance and gain customer trust.
Played key role in major data migration project working closely with multiple teams to map schemas, identify discrepancies and quality issues between two platforms, and onboard in-house aggregated tables and dashboards.
Competitive Intelligence Analyst COOP
Wayfair.com
Boston, MA
01.2018 - 06.2018
Executed multiple data clean-up and de-duplication projects like "Google PLA Table Clean-up" achieving 100 million unique rows from billion rows of data.
Developed dashboards using Tableau/Grafana to effectively communicate insights.
Modified/Updated SQL queries and Created/Altered database tables to produce reports on standard/ad-hoc basis.
Enhanced data flow through various tables by creating and editing various stored procedures in SQL.
Implemented various processes related to matching Wayfair catalog to competitor catalogs to better pricing and web content which heavily contributed to Wayday sale of 100 million dollars.
Automated various daily manual data cleanup/extraction/input processes using VBA macros reducing process times by 80% and was presented "Innovator" award.
Collaborated with data scientists, engineers to develop and enhance matching algorithm/tool obtaining record 6 million product matches to various competitors earning "Team Player" award.
Supervised multiple offshore teams (120 employees) contributing to Wayfair data by allocating and reviewing their work.
Business Analyst
Amrit Breeder Farms PVT. LTD
Kolkata, India
08.2015 - 08.2016
Examined KPIs such as in-stock levels, inventory cost, sales and obsolescence delivering savings of $100K annually.
Performed sensitivity analysis (Python/Excel) on seasonal data to forecast sales and develop pricing strategy improving gross profit by 20%
Implemented just-in-time inventory and cycle count procedure that attained 98% inventory record accuracy.
Built SQL Server repository using ETL to manage extraction, transformation and population of data.
Presented weekly/monthly reports using QlikView/Tableau to executive team highlighting performance of ongoing strategies with opportunities for growth.
Employed Economic Modeling techniques like cash flow, present worth and internal rate of return (IRR) analysis to compare between proposed future projects and assisted in making decisions on most suited plan for starting new feed manufacturing plant.
Catalog Associate
Amazon.com Services
Chennai, India
07.2014 - 07.2015
Managed new item setup for categories - Sporting Goods, Hunting, Toys, Tools and Home for NA retail marketplace.
Refined quality of product data by creating various data cleanup and quality check macros improving data quality by 90%
Directed "Catalog Clean-up" project for US Sporting goods involving data gathering, manipulation, synthesis, modeling and problem-solving to help refine Amazon web page and was presented with "First Among Equals" award.
Composed SQL queries, sub-queries and complex joins for generating ad-hoc reports.
Analyzed data and modeled dashboards in Tableau to create and disseminate reports and share trends and areas of opportunity for further improvement.
Education
Master of Science - Engineering Management
Northeastern University
Boston, MA
08.2018
Bachelor of Engineering - Mechanical Engineering
Anna University
Chennai
04.2014
Skills
Programming/Scripting Languages - Python, SQL, R, C, C, HTML, XML
Data Warehousing & Business
Intelligence - SSIS, Alteryx, Talend, SSAS,
SSRS, Toad Data Modeler, SAS, Amplitude
MS Office Suite - Excel (Macros, Pivot
Tables, VBA), Access, Project,
PowerPoint, Visio, Word
Data Analysis - Predictive Analytics,
Machine Learning, Statistical Modeling
and Regression, Text Mining