Candidate Information Name Available: Register for Free Title Microsoft Excel, Microsoft Word, Microsoft PowerPoint, SQL, Pyth Target Location US-NJ-Springfield Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Real Estate Microsoft Office New York, NY Microsoft Office Administrative Assistant Hillsdale, NJ C A Microsoft Office Ossining, NY Project Management Microsoft Office Willingboro, NJ Microsoft Office Specialist Mount Holly, NJ Information Technology Microsoft Office Far Rockaway, NY Customer Service Microsoft Office Dover, NJ

Candidate's Name
EMAIL AVAILABLE  PHONE NUMBER AVAILABLELINKEDIN LINK AVAILABLEOBJECTIVEAn entry-level analyst with a bachelors degree in economics with broad knowledge and experience using SQL, Python, R programming language, and Microsoft Office looking to provide value through hard work and technical excellence. EDUCATIONMontclair State University, Montclair, NJMajor  Economics Minors - Business Analytics & Data Science Summa Cum Laude - GPA: 3.97TECHNICAL SKILLS Expert - SQL, Microsoft Excel (Certified), Microsoft PowerPoint, Microsoft Word, Microsoft Outlook, Microsoft SharePoint Proficient - Python, Tableau, R programming language; Microsoft PowerBI WORK EXPERIENCECustomer Supply Chain Intern (Professional Products Division) - LOral USA Clark, NJ June - August 2024 Created more than 10 pivot tables from order detail reports in Microsoft Excel to allow the customer visibility to summarized order quantity, delivery quantity, and cuts for a specific product. Utilized Microsoft Excel including formulas for cleaning monthly inventory data to visualize it to display KPIs. Leveraged the VLOOKUP formula in Microsoft Excel to pull in store on hand, distribution center on hand units for assorted brands for August from inventory forecast files and showed correct rank of products using a database. Ensured smooth flow of orders from LOrals warehouse to Amazon fulfillment centers so that Amazon knew estimated delivery of shipments. Generated replenishment purchase orders in Amazon Seller Central system to make sure that inventory is continuously flowing through supply chain. Calculated the amount Ulta charges LOral for various violations so LOral is aware of the amount that they must pay when they didnt follow specific predetermined requirements. Updated LOrals warehouse floor cut report daily to show the most current amount of floor cuts in total as well as by customer.COLLEGIATE PROJECT EXPERIENCEData Analysis Automation Project - Spring 2023 (Introduction to R Programming) Wrote a script with R for automating data analysis for use by a mock wine vendor. Generated various data visualizations (box plot, bar plot, scatter plot) and charts to show the distribution of price for three types of wine, average wine bottle prices of five countries, and the relationship between vintage and points. Presented the project to tell a story about the wines data set and help the stakeholders better see, understand, and make sense of data in an organized way.Python Data Cleanup Project - Spring 2023 (Introduction to Data Science) Utilized Python to remove irrelevant information from a large data set of approximately 20,000 entries. Wrote code to remove unnecessary columns and rows with missing values in numeric columns. Analyzed data set using descriptive statistics with groupby and average functions. Wrote code to create visualizations (bar plot, line graph and scatter plot). Business Operations Data Visualization - Fall 2022 (Data Visualization) Generated Tableau dashboards with seven interactive visualizations. Created an informative story about business operations highlighting profit and revenue for each Red Hawk Cafe based on its location over three years. Explored customer preferences by demographics, products, and store location over multiple years. Presented Data with viz in tooltip, line graphs, tree maps, highlight tables, bar charts, and histograms. Oracle Database SQL Project - Fall 2022 (Database Management Systems) Created views and wrote queries in SQL Oracle Database. Utilized advanced SQL tools including joins, nested queries, and aggregate functions. COCURRICULAR ACTIVITIESData Driven Student Alliance - President; Vice President Led five workshops for students about SQL, Microsoft Excel, R Programming Organized guest speaker events on different data analysis and learning strategies averaging 200 attendees.