Data Entry Executive Assistant

MADHURI MADHU

SKOKIE, ILLINOIS 847-***-**** ***********@*****.***

Personal Summary

Industrial Engineering professional for 4 years of progressive experience in a complex fast paced environment.

Highly skilled, hard worker, self-motivated, problem-solver and positive attitude person and clearly communicates ideas to different audiences.

Skills

Auto CAD, SQL, SSRS, SSAS, SSIS, Salesforce, SAP, Tableau, Microsoft Outlook, Microsoft Access, Microsoft Office, OCR.

Cetrificates: Six Sigma, Tableau, and Salesforce Admin

Languages: English, Telugu and Beginner Korean

Work Experience

Strateg Commerce - Chicago, IL September’2018- Present

OCR Specialist

Effectively communicates among various internal departments to inform or troubleshoot operational concerns relating to work in general or for specific clients. Works with large data sets of Excel reports through the financial audits, shipment audits using advanced excel techniques like Vlookups, concatenate, pivot tables using Transaction KPI Tracker.

Address all pricing requests coming in from sales team. Respond to requests for creating or editing pricing conditions from sales force and divisional personnel via email. Must manipulate large amounts of data in Excel efficiently and accurately.

Perform invoice charge code breakdown per shipment; look up and assign charge code numbers to individual charges on a freight invoice to convert to an electronic file using pivot tables by determining shipment types like LTL-standard, TL-ground, Ocean, Air, Worldwide saver, Brokerage charges.

Under limited supervision, engage, process and complete operational invoice CCP reports.

Configured Order to Cash (OTC) process including Sales Order Types, Sales Documents Types, Standard Order, Returns Order, Credit Memo and Debit Memo as per the customer’s specific requirement.

Bijjam Information Technologies Inc – Chicago, IL February 2016 – May 2018

Executive Assistant/ Data Analyst

Compiled, sorted and verified information and make the accuracy of data before it entered and update data when needed.

Located and corrected data entry errors.

Anticipate and initiate action regarding administrative detail as it relates to the office management and the company operations. In-Depth knowledge of policies, procedures and practices.

Plan, organize, instruct and assign clerical responsibilities to support the CEO.

Record and transcribe all reports, meetings, updates, correspondence, handwritten copy.

Perform necessary processing and maintain files and records and compile, analyze and prepares special reports (Tableau, Excel) as required.

Arrange meetings and conferences, preparing agenda, and summarizing information.

Maintain and adjust appointment calendar schedules as needed due to the emergency or unforeseen events and take an initiative in rescheduling appointments.

Perform day-to-day administrative functions and general office duties including but not limited to word processing, copying, filing and faxing.

Manage multiple projects simultaneously, providing regular status reports to stakeholders through timelines, resources, budget vs actual spend.

Develops a purchasing strategy for the goods ordered and received and maintains records. Reviews and processes purchase orders.

Negotiates prices and contracts with suppliers and builds and maintains relationships with vendors and suppliers.

Internships

University of Illinois At Chicago January 2015 – December 2015

Revamping Plant Layout at Kirloskar

Designed a plant layout involves devising the best and efficient arrangement of departments and machinery in the plant. The plant consists of existing plant layout of manufacturing unit at Kirloskar and seps to install a new assembly line in their existing plant. This involving making a space for the new assembly line by rearranging the departments using the systematic approach.

Air Cleaner Replacement Filter

Designed an air cleaner replacement filter in the 3D printer by using solid works to design the printer with exact dimensions. On the industrial engineering aspect, estimate the transportation costs, manufacturing cost and functionality.

Administrative Assistant

Anticipate and initiate action regarding administrative detail as it relates to the office management and the operation of the college as a whole.

Plan, organize, instruct and assign clerical responsibilities to support the office of the Financial Affairs.

Record and transcribe all records, meeting minutes, correspondence, and handwritten copy.

Receive and answer questions for the international visitors, review inquiries and work with functional area for the international student affairs and providing information for the international students and parents.

Compile, analyze students records and reports, grades, and maintains files and records as required.

Work closely with the FAFSA team and international student affairs team to discuss about the loan payments and accounts receivable payments.

Oakton Community College January 2012 – May 2012

Design and Print a 3D Model of a Torch Light using AutoCAD

Designed a torch light using the directions that the professor has given. I have to design all the parts of the Torch light and print in a 3D printer. It looks like the real torch light after we have printed in 3D.

Education

University of Illinois at Chicago, Bachelors in Industrial Engineering, December 2015

Contact this candidate