Vignesh Venkatachalam Email & Phone Number

Chicago, Illinois, United States

Chicago, Illinois, United States

• Designed new data models for diverse healthcare data sources (pharmacy/medical claims, EHR) across raw, stage, and fact datasets• Rebuilt and optimized Oak St. Health’s data warehouse infrastructure by streamlining data ingestion & transformation processes and implementing complex automated ELT pipelines• Refactored existing data pipelines and migrated legacy stored procedures for cloud-native distributed data processing• Collaborated closely with Product teams to enhance patient outreach initiatives through seamless integration with external systems (viz. Salesforce) and facilitated robust data analysis and debugging• Performed QA and set up automated data quality monitoring to ensure high data reliability across products for operational stakeholders (Finance, Data Science, Analytics, Pharmacy)

Chicago, Illinois, United States

• Streamlined tabular and geospatial data from public data sources to analyze avenues for introducing regenerative agriculture practices in the upper Midwest United States for an AgriTech non-profit• Built data capacity and provided technical infrastructure support to local Chicago organizations involved in education and entrepreneurship

Chicago, Illinois, United States

Developed automated data pipelines by compiling, enriching, and mapping data from 15+ sources using ESRI ArcGIS Online’s analytical tools to reduce manual overhead and built public-facing interactive ArcGIS dashboards leveraging the pipeline to support community leaders with data-driven policymaking

Bengaluru Area, India

Successfully pitched digital transformation solutions around end-to-end solution architecture for real-time analytics, Business Intelligence (BI) tool evaluation, integrated chat-bot solutions, model operationalization, and Data Governance and Data Quality Management frameworks directly to client leadership, bringing $1.5M in new businesses. Recognized for excellent client handling and clarity of thought in building analytical strategy

Bengaluru Area, India

Benchmarking support for Enterprise Analytical Platforms | Fortune 50 Bank in US• Led a team of 7 data scientists and engaged directly with the SVP of the Global Consumer Technology team to provide consultancy on setting up an Enterprise Analytical Platform to enable large scale machine learning and deep learning• Oversaw benchmarking of the above platform serving ~3500 users with 420 cores and 8 TB RAM hosting Base SAS, SAS Viya, Microsoft R, Grid R and Python. The team was responsible for evaluating scalability, speed and accuracy of gradient boosting algorithms across the entire model life cycle and across different data volumes and cluster configurations.• Oversaw the design and development of an in-house repository and collaboration site in support of tools on the platform. The site would be a one-stop solution for any information about tools available, processes to gain tool-access, use cases and best practices. The final solution accelerated business on-boarding onto the analytical platform and the visibility it brought to the client received a highly positive recognition from the bank's Global Head of Data• Helped streamline analytical platform usage and load performance report to facilitate critical decisions around resource allocation and budgeting

Bengaluru Area, India

Consumer Insights and Optimised Targeting | Europe's Leading Sports-merchandise Manufacturer• As Client Partner, was responsible for driving consumption of analytical targeting solutions and was invited on-site to participate in quarterly strategic planning meetings and workshops• Served as a technical liaison with multiple teams in designing A/B testing frameworks, solution architecture and model productionalisation to provide an end-to-end analytical solution for dynamic content personalised emails. Single-handedly also owned campaign performance tracking and reporting.• Created advanced analytical models to score consumers' affinity towards a product category. The model was the underlying intelligence powering personalisation campaigns focused towards improving retention, engagement and reducing un-subscriptions.• Designed a consistent, integrated and implementable KPI framework centred around improving client's reach, engagement, sales and advocacy, that fed into a monthly CRM Overview and Trends report. Oversaw the report's conversion into a live dashboards owing to its success and widespread consumption by global markets and business units for CRM performance tracking and goal setting.Other key projects: Product Affinity Score, RFM Segmentation, Customer Life Time Value (CLTV) analysis, High Value Consumer analysis, Personalised Email Send-Out Time analysis.Analytical Tools used: MicroStrategy, Tableau, Exasol (SQL), R-programming language, Atlassian - JIRA & Confluence, Adobe Analytics

Master Of Science In Computational Analysis, Computer Science

Activities and Societies: Harris Community Action Fellow Data Fellow at the Data Science Institute Tutor: Python Programming TA: Linear.

Bachelor Of Technology (B.Tech.), Electrical And Electronics Engineering

Activities and Societies: Institute Student Council, Student Mentorship Program, Training and Placement Cell, Institute Magazine Committee