Asmita Samanta Email & Phone Number

Washington, Dc, Us

Washington, United States

•Analyzed survey data from 500+ graduating seniors of US dental schools to evaluate backgrounds & future plans, through relevant metrics that aided accreditation processes & led to a 15% improvement in program offerings•Reduced data preparation time by 67% using Python libraries to automate the cleaning of structured and unstructured data, resulting in more efficient reporting to C-level executives•Developed data visualizations & summaries in PowerBI to evaluate applicant turnover for the dentaleducation community, improving the distribution of a diverse student demographic with a 15% increase in revenue

College Park, Maryland, United States

Conducted lectures, prepared course material teaching fundamentals of RDBMS using SQL & effectively led a team of 7 staff members to manage grading, labs, discussions for 150+ undergraduate students

Lake Forest, Illinois, United States

•Led the overhaul of KPI data pipelines by merging datasets into Azure Data Factory to boost the performance of 20+ Power BI dashboards, reducing data infrastructure costs by $250K•Conducted exploratory analysis using advanced Excel functions like VLOOKUP, PIVOT tables, to identify trends in customer claims and policy renewals, boosting renewal sales by $32M•Built a database in Azure Synapse with 18+ structured tables, organizing the raw data into easy-to-use tables along with comprehensive documentation, reducing report generation time for teams by 40+ hours

Bangalore Urban, Karnataka, India

•Led daily client discussions using Scrum Agile methodologies to translate day-to-day business requirements into reporting strategies that significantly contributed to 3.4% revenue growth for FY22•Demonstrated importance of database migration to Google BigQuery for $5.6B revenue market segment by leading the migration of new features to boost user productivity, reducing query latency & wait times by 30%•Designed scheduled Alteryx workflows with optimized queries to pull data and populate 50+ Tableau dashboards daily to enable users to receive scheduled reports daily, reducing manual data retrieval by 20%

Bengaluru, Karnataka, India

•Created a budget automation tool for fleet management using Excel VBA & implemented it toanalyze costs associated with transitioning to electric vehicles, successfully predicting a subsidized 21% rise in monthly budget•Collaborated with the client's Marketing, Product, and Finance teams to translate day-to-daybusiness requirements into SQL queries for ad hoc data pulls, while resolving data-related blockers

▪ Supervised several technical workshops, annual technical fests, hackathons for external & internal college students▪ Collaborated with technical, design leads to curate monthly newsletters for professors & students

Kanpur

▪ Assessed the commercial Impact of rooftop solar panels on consumers, distribution companies & projected the RSVP capacity at 4kW for minimal loss to distribution companies

Masters, Information Science/Studies, 3.90

Bachelor Of Technology - Btech, Information Technology