Neelanshu Kothari Email & Phone Number

Toronto, Ontario, Canada

Chicago, Illinois, United States

Greater Chicago Area

• Design and implement data processing solutions, enabling clean data flow directly to the data model using different technologies such as Python, Talend, Java, Postgres, SQL Server• Engineered, supported and addressed the proprietary process of loading and validating highly specialized medical claims from 10s of payers into a proprietary system• Built dashboards and alerts to support production operations and automate manual and time-based checks to increase operational efficiency and accuracy• Built Python apps to send data anomalies to operations team

Greater Chicago Area

• Validated the data stream, dependencies, and provenance in the platform pipeline and perform data quality check through Postgres, Docker, Elastic Search and Kafka to continuously improve accuracy, timeliness, and availability of data• Developed python scripts and Grafana dashboards to automate the monitoring tasks and fire alerts if data anomalies are detected• Partnered with Data Science, Engineering, Product, and Operations to manage complex requests and solve daily production issues and streamlining multiple data pipelines• Involved with data pipeline validation process by identifying validation gaps, testing new iterations and changes, configuring and troubleshooting data pipeline and adapting the process with incremental feedback

Greater Chicago Area

•Worked in a team to on-board 40 dealerships across the world, on Uptake's platform, to provide them with analytical service and streamlining the onboarding process • Managed the handoff of data ingestion streams from implementation teams to full production and coordinate data providers with various database technologies to maintain escalation protocol, communicate inbound scorecards and track resolution of issues• Developed implementation strategy, plan and schedule and coordinated logistics of implementation with customers.• Responsible for building a business relationship with the technical leads at customer sites, performing detailed field-by-field data mapping from the customer’s current system to Uptake’s data platform, identifying complex functions and queries to map and validate the data transformations by conducting quality assessments.• Utilized in-depth knowledge regarding connecting and ingesting multi-source of data from different ERP systems such as SAP, Infor M3, MS Dynamics etc.• Developed strategy for streamlining data mapping to create a scalable, replicable process • Conducted quality assessment and validation of end result data transfer • Led and worked as a part of teams that build and support a product by identifying requirements, testing new iterations, installing and configuring applications, and adapting the process with incremental feedback • Traveled domestically and internationally to customer sites to perform data mapping

Greater Chicago Area

• Used agile software development methodology in defining the problem, gathering requirements, development iterations and communicating with the technical team for development of a reporting system• Involved in Data Quality Analysis to determine cleansing requirements while migrating old access database to SQL server• Worked closely with both the business and development teams to coordinate and schedule testing efforts• Developed patron sign-in system on MS Access using VBA and wrote data queries to prepare weekly, monthly, and quarterly reports• Cleaned patron data in Excel and created various data visualizations and dashboards on TABLEAU for the annual reporting

Indore Area, India

• Gathered drop call data from 125 mobile towers, analyzed it using R and identified problems and patterns for the possible reasons for dropped calls.• Engineered complex SQL queries to retrieve, monitor, filter data and perform data analysis.• Provided solutions and corrective measures of the problems identified after analysis and created detailed report of it using SSRS.• Created hypothesis on customer call duration data followed by testing it on R and submitted report to the customer service manager• Compiled and validated data; reinforce and maintain compliance with corporate standards• Detected fault and provided corrective measure in the network design and saved 10,000 $ approved for the entire redesigning of the network.

Indore Area, India

• Created the project plan using MS Project while analyzing application needs and delivered the following artifacts as needed: (Project Charter, Business Requirements Document, Use Cases , cost analysis)• Worked as Python programmer in a team dedicated to develop application for the city library

Master'S Degree, Management Information Systems

Activities and Societies: •Won of Ernst and Young case study competetion

Bachelor Of Engineering (B.E.), Electrical, Electronics And Communications Engineering, Honors

Activities and Societies: Organised TED India 2010