| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address
PHONE NUMBER AVAILABLE EMAIL AVAILABLE GitHubEDUCATIONMaster of Science in Business Analytics December 2022University of Illinois Chicago GPA: 3.69Key Courses: Machine Learning, Big Data Analytics, Marketing AnalyticsBachelor of Technology in Electronics and Communication Engineering May 2020SRM Institute of Science and Technology, Chennai, India GPA: 3.2TECHNICAL SKILLS AND CERTIFICATIONSData Visualization: Tableau, Qlik Sense, Power BI, and Qlik ViewProgramming Languages: R, SQL, PythonBig Data: Spark, Hadoop, Pig, MapReduce and PySparkDatabase: Microsoft SQL Server 2014, Oracle SQL developer, RDBMS, Informatica MDM, MySQLAnalytical Tools: MS Excel, R Studio, Google SheetsMachine Learning: NumPy, Pandas, Matplotlib, XGBoost, NaiveBayers, caret, dplyr and randomForestTableau Certified Desktop Specialist and Qlik Sense Business Analyst CertificationEXPERIENCESnap On Crystal Lake, IllinoisData Analyst Intern June 2023 - presentCreated 10 Tableau dashboards to track individual productivity from production, inventory and receiving departmentsAnalyzed data from 10+ SQL databases to write complex queries using joins, sub queries and window functions that help in tracking KPIs like Receiving efficiency per day, Inventory turnover, Cash to Cash Cycle time and Order fill rates.Using predictive analytics created dashboards that help in calculating overall efficiency across departments, reducing overhead costs in labor planning and finding opportunity for improvements in various receiving processesPresented insights to senior leadership and gained appreciation from them for pointing out bottlenecks with their solutionsHelloFresh Aurora, IllinoisOperational Planning Analyst Feb 2023 May 2023Collaborated with different departments (inventory, kitchen, and production) to collect data and identify operational needsDeveloped dashboards in Google sheets to reduce the amount of meal discards by 50% from different fulfillment centersPerformed ad hoc data analysis for product teams to explain different data collection points and forecasting methodsReduced technical errors by 30% in planning tools by improving the troubleshooting process and removing recurrent errorsMediaOcean LLC Chicago, IllinoisBusiness Operations Intern June 2022 Dec 2022Collaborated with functional teams (Finance, Sales, and Operations) to collect relevant data and identify business needsDesigned a data architecture to create 6 Power BI dashboards by aggregating more than 30+ flat files and developed dashboards that track YoY revenue growth, client health and media spend through different social media platforms for over 200 users to strategize their marketing towards consumersDesigned an operational database aggregating financial, revenue and operations data in the Snowflake environment to reduce data aggregation from 2 hours to 2 mins for data accessibility in one placePerformed ETL using staging tables to clean 1 million+ records to reduce data cleansing activity from 1 hour to 5 minutesCognizant Technology Solutions Chennai, IndiaProgrammer Analyst July 2020 July 2021Developed 10 Tableau dashboards for annual sales review by 20+ business analysts by aggregating 30+ SQL databases containing information about customer demographics, product descriptions and sales channelsDeveloped SQL queries for reducing time for MDM data loads & displaying data in CRM tools from 1 hour to 10 minutesImproved customer satisfaction scores (CSAT) from 8 to 10 by managing aggressive SLAs, prioritizing, and closing high-priority tickets within 5 days.Performed data cleaning for quarterly review by removing 100+ products performing poorly in APAC regions to enhance 30+ Tableau dashboards by performing site administration to reduce failed data extracts refresh, which led to dashboard breakages and managing users |
