Abhijit Menon Email & Phone Number

Austin, Tx, Us

Peachtree City, Georgia, United States

Developed solutions as a data liaison for marketing, sales and product teams. Took charge of all the data needs throughout the company and delivered results using Python, Tableau, and SQL.• Created ETL methods to extract and transform data from the company’s business management system and load it to Tableau Online. Designed dashboards to facilitate the transitioning of all existing reports to Tableau.• Built python scripts using the HubSpot API to automate manual tasks and reduce time consumption by over 95%. • Partnered with the sales and marketing teams to identify KPIs and created Tableau dashboards for tracking them. Provided technical assistance for data needs throughout the company.• Increased data visibility and availability for the product development team by building a python pipeline to extract application data through API calls. Designed a postgreSQL database to store this data.

Played a pivotal role in supporting the commercial team to obtain the sales objectives by providing consultative, strategic, and analytic insights regarding potential clients leading to an increase in YOY revenue by 50%.• Database Development and ETL: Designed and implemented a new centralized database to consolidate and serve information for the sales team. Developed an ETL pipeline to extract data from different sources (Excel files, text files, Airtable API) and save all the information to the centralized DB.• Lead Generation using a Python Web Scraper: Developed a web scraper using Python (BeautifulSoup and Scrapy) to extract potential leads from municipal web pages. Transformed the data using regex, NLP and stored them into the database. Increased number of available leads by 10x.• Business Intelligence Dashboards: Created BI dashboards for tracking sales performance, calls volume, revenue generation, and other ad hoc requirements. Increased data-driven decision making and improved the operational efficiency of the commercial growth.• Prospect Targeting Tiers: Collected demographic data on current clients, consolidated this data into a single table and created visualizations to understand the niche demographic for our product offerings. Created different tiers of prospects for sales team to target based on this analysis. Increased demos booked per week by 75%.

Developed a framework for comparing and evaluating different machine learning platforms. providing valuable insights to the end user community, allowing them to make better choices on platforms.• EDA and Data Wrangling: Performed data exploration, cleaning, and transformations (scaling, log transformations and feature splits) on large data sets using pandas and skcikit-learn. Created pipelines to prepare the data for regression models.• Model Training, Evaluation and Tuning: Performed stratified sampling and hyper parameter tuning for Random Forests, SVM, Neural Networks, Bagging, Boosting and Decision Trees. Optimized parameters to minimize RMSE Scores.• Model Deployment and Comparison: Applied best parameters and deployed models on testing data. Compared RMSE scores on Python,R and Azure ML Studio to find the optimal platform.

Phoenix, Arizona Area

Increased the social media engagement of Arizona’s largest casino chain by over 600% by leading a 4-member intern team to optimize social media marketing on Twitter. Led to savings of over $1,00,000 in marketing expenses. • Data Extraction and KPI Definition: Created an ETL pipeline to extract raw data from Twitter using API calls, clean and transform the data, and store the data as flat files using Python (TweePy, pandas, and string functions). Defined KPIs relevant to the business problem to help derive meaningful insights. • Collaborated with the marketing team to improve data reliability, quality, and efficiency while optimizing data collection performance and cost.• Dashboard Development: Developed Tableau dashboards to track KPIs to deliver insights and drive decision making.

Established a collaborative environment promoting outside the box thinking and creative solution implementation to solve challenging projects. Utilized data to drive decision making. • Implemented stored procedures, pre, and custom-defined functions, complex joins, and window functions on SQL to extract data from multiple sources and perform analysis. • Developed a financial model for the optimization of investment decisions to maximize total profit using Excel.• Engineered features from visualization of data for machine learning. Ranked among top 20 percentile in multiple Kaggle competitions.

Delivered extensive insights and strategic recommendations about purchase drivers, marketing campaigns, and churn for external clients and helped increase client satisfaction by more than 50%. • Provided strategic recommendations to clients in the Nordic market (Sweden, Finland, Norway) through data analysis, market segmentation, and competitor benchmarking using primary research data. • Project Management and Strategic Planning: Collaborated with cross-functional teams for requirements gathering, KPI definition, and analysis of over 60 market research projects. Evaluated campaign performance and provided recommendations and insights to stakeholders. • Designed customer surveys based on ad campaigns to understand customer journeys through the marketing funnel. Created functions to clean data using Python reducing time taken by 40%.

Navi Mumbai, Maharashtra, India

Created revenue reports and presentations for tracking revenue and expenses using SQL and Excel. Developed ETL pipeline on SSIS from scratch to create a data warehouse for sales, purchasing and client information.• Created data dictionaries for tables in the relational databases and analyzed connections using star schema before migrating data into data warehouse.• Calculated probabilities of landing a client through data analysis and projected revenue through the deal.

Master Of Science - Ms, Business Analytics, 3.8

Analytical Decision Modeling I - Linear Programming, Integer Programming | Microsoft Excel - Solver, Data Analysis Analytical Decision.

Bachelor Of Engineering - Be, Mechanical Engineering