Data Analyst

ABHISHEK NILAJAGI

**********@*****.*** 617-***-**** LinkedIn Dashboards

EDUCATION

Mumbai University, Mumbai, MH, India Bachelors in Computer Science Northeastern University, Boston, MA, USA Masters in Informatics, Data Analytics New England College, Henniker, NH, USA Masters in IT Project Management WORK EXPERIENCE

Analyst Technical Operations, LG Ad Solutions, Boston, MA Feb 2024 - Present

• Automated performance reporting workflows with Python, reducing processing times by 15%, and enhancing overall team efficiency

• Maintained dashboards using Tableau, Looker and SQL to visualize product usage and KPIs, enabling SLTs to make data-informed decisions enabling global market penetration

• Swiftly resolved technical issues across multiple product verticals as SME, unblocking revenue-impacting product issues

• Launched 500+ live branded channels globally, collaborating with programmatic, engineering and external media clients Team Lead Manager, Ad Operations, LG Ad Solutions, Boston, MA June 2021 - Feb 2024

• Led a team of 4 managing $200M+ annually in Ad spend, ensuring smooth campaign execution and exceeding client KPI goals

• Collaborated with various teams in developing scalable campaign management tools, and process to improve overall campaign management efficiency reducing timelines by 30%

• Led Political vertical launch, managing clients, automated reports using AWS S3 and managing ads, driving $2M+ in revenue

• Optimized multi-channel advertisements by managing tools like DSPs, 3P vendors, and custom audiences for seamless execution

• Collaborated with Data Science team to implement ML models to optimize CPM bidding rates for real time cost optimizations Business Analyst, Adwaita Solutions Inc, Boston, MA July 2020 - April 2021

• Created visual user stories, for A/B testing, and designing use cases using Azure DevOps to make data-driven decision

• Analyzed business data using SQL and Power BI, providing actionable insights that boosted sales performance by 15% Business Analyst, Climate Creatives, Boston, MA (Capstone) Jan 2020 - April 2020

• Defined requirements by the client, delivered a new website with 6 new features increasing the web traffic by 20%

• Tested and rolled out new solutions by creating business documentation, ensuring all goals are met with Agile project lifecycle Data Analyst, LedgerOps, Boston, MA (Capstone) April 2019 - July 2019

• Led a team of 4 to deliver solutions and digital marketing strategies to upsurge the online presence for LedgerOps

• Scraped web data using Python and APIs (Google, Twitter, SEMrush) to analyze blockchain trends, increasing website traffic by 30% Data Analyst, Flow Tech Engineers Ltd, Mumbai, MH July 2017 - Dec 2017

• Developed a Material Requirement Inventory platform using SQL, Excel, and CRM to streamline data collection and reduce costs

• Improved manufacturing timelines by 15% and cut delivery time by 20% through data analysis and automation Financial Analyst, Shivam Chemicals Pvt Ltd, Mumbai, MH Jan 2017 - June 2017

• Built Tableau dashboards using ETL pipelines and data warehousing to access large financial and client datasets

• Improved 12% on trading and transaction durations by ranking analysis of traders and financial expenditures with forecasting SKILLS

Expertise : Business Intelligence, Data Analysis & Visualization, Stakeholder Management, Team Management, Project Management Languages : SQL, CSS, HTML, XML, Python, R, (Pandas, NumPy, Matplotlib, Pyspark, scikit-learn, seaborn) Data Tools : MySQL, AWS S3, Tableau, Power BI, Looker Tools : MS Excel, Jupyter Notebooks, Salesforce, MS Office Suite, ASANA, Confluence, Google Analytics, Beeswax, Spring Serve ML concepts : Regression Analysis, Random Forests, Gradient Boosting, Decision Tree, KNN PROJECTS

Boston Bike Sharing, LINK March 2020

• Built Tableau dashboard on 100,000+ records with action filters and heat maps, identifying the top 10 busiest stations

• Developed interactive reports on KPIs like station traffic and customer types, increasing operational efficiency by 25% Adult Income Dataset Prediction Dec 2019

• Worked with a team to comprehend income data and test multiple prediction algorithms using Python

• Trained and evaluated ML models in Python, achieving 80% accuracy with a Decision Tree, 20% higher than Random Forest Malware Classification Using Machine Learning May 2018

• Developed and implemented ANN and K-Nearest Neighbors models for malware classification into distinct families, achieving up to 91% accuracy, introducing innovative grayscale image-based feature extraction, and publishing findings in IJCIR, Vol. 14

Contact this candidate