Neelkant Newra

Data Analyst

Merkle•  July 2022 - Present•  Bengaluru

Identified and resolved key inefficiencies in data processing workflows, resulting in a 15x reduction of task duration; implemented automated customer selection processes that enhanced productivity for the entire analytical team. Streamlined budget forecasting processes by developing an interactive tool that reduced reliance on a six-member team to just one, resulting in improved clarity and faster decision-making across financial operations. Designed Tableau dashboards for monthly campaign reporting and performance grids across customer segments; created targeting waterfalls to reduce intermediate errors. Conducted Ad hoc analysis for efficient targeting in Retail Banking campaign, increasing funds, and reducing terms for higher-income segments. Developed Quality Starts model to predict the likelihood of targeted individuals passing the initials approval process, increase accuracy from 55% to 76%, while adhering to MRM documentation. Built a funnel to attribute Direct Mail campaign using the response window from the mail drop date and measured marketing performance by assessing campaign efficiency through A/B testing. Demonstrated strategic decision-making and insightful analysis by evaluating the customer journey and cross-product attribution, achieving a 43% cost reduction through the removal of redundant mail and enabling precise targeting across segments. Identified Overpaying and Underpaying segments across different metrics to make better decisions in targeting. Developed Stored procedures for ETL and automated daily runs using task handler. Created function to calculate Multi-touch, reducing runtime by 50% and code length by 80%. Optimized Git integration with Snowflake for real-time code synchronization, and produced process documentation that reduced training time for new team members by approximately 50%.

Data Engineer

Upwork•  June 2020 - July 2022•  Remote

Developed and integrated a web scraping pipeline with Airflow for real-time data sharing; implemented PDF scraping using BeautifulSoup4, image segregation with Computer Vision, and tagging. Built Chatbot using RASA for internal data retrieval and updates. Engineered and maintained Python libraries for internal projects, reducing redundancy and speeding up development workflows. Constructed Model using Vertex (GCP) for beauty product segmentation from data across various E-commerce site. Utilized VBA to automate repetitive tasks reducing time by 100% and made full documentation for the client. Managed Jira, creating layout for task description, status, assignee, due date, etc making the process smooth and manageable.