579c8b82-db98-4dfd-b70e-fa78b03ed6f7

Andrew Smith

Professional Summary

Analytical, accomplished, professional Data Analyst with over 5 years of experience in multifaceted roles requiring operations management and business compliance.  Skilled in the areas of report generation, dashboard builder and data analytics. Motivated and eager to advance my career with a growth-oriented, technically-advanced organization as a Data Analyst.

Employment history

MIS Executive, Hartmann Inc. New Jeromy, Maryland
Mar. 2019 – Present
  • Genrating P&L process & Business Wise 
  • Daily Basis Performance And DSR report publishing
  • Cheque handling and Co ordinate to Insurance Company. 
  • Prepare to Client Reports 
  • New car policy and Renewal & Rollover policy issuance 
  • Preparing monthly base process wise 
  • Preparing Performance PPT Process & Business wise 

MIS Executive, Johnston and Sons. Arnoldomouth, Iowa
Sep. 2015 – May. 2017
  • Report Analysis 
  • Billing & Pay out Report Analysis 
  • Sales Report & Process Wise APR & Performance Report Analysis 
  • Agent wise and Centre wise performance reports analysis 
  • Clients reports & Daily Comparison Reports 
  • Schedule adherence & Basic Pay roll Record Preparation 

Education

North Montana Academy, East Hye, Virginia
BBA, Management, Oct. 2019

The Langosh, Aldenview, Arkansas
HSC, Higher Secondary Schooling, Oct. 2010

South Heaney, Port Josefamouth, Alabama
SSLC, High Scooling, Dec. 2008

Personal info


Phone:

(000) 000-0000

Email:

andrew_smith@example.com

Address:

287 Custer Street, Hopewell, PA 00000

Languages

Tamil








English








Skills

MS Access Database Handling








Excel Reporting & Dashboard








Data Analytics by Advanced MS Excel








Stakeholder Coordination








61dabdf2-f5ff-46f9-bd19-a07d57552c97

Andrew Smith


287 Custer Street, Hopewell, PA 00000

andrew_smith@example.com

(000) 000-0000

Professional Summary

Tenured administrative professional with extensive experience providing support to the Chief Executive Officer of a multi-million-dollar organization.  Analytical, detail-oriented leader adept at multitasking within a fast-paced environment.  In-depth knowledge of standard office procedures, software, and machines; proficient use of Microsoft Office Suite, scheduling software, the internet, and database software.

Employment history

MIS Executive, Ruecker-Reilly. West Jarrodbury, Alabama
Nov. 2019 – Present
  • Conduct research, compile data, and prepare papers for consideration and presentation by executives, committees and boards of directors.
  • File and retrieve corporate documents, records, and reports. 
  • Work on analytics in entire Microsoft office as MIS executive.
  • Manage and maintain executives’ schedules.
  • Review operating practices and procedures to determine whether improvements can be made in areas such as workflow, reporting procedures, or expenditures.

Procurement Associate, Conn-Dietrich. Cummeratashire, Louisiana
May. 2019 – Jun. 2019
Monitoring the day to day shipment, which include end to end shipment visibility of all types of modes of transportation, worked with superiors which includes daily report, coordinating and for the free flow of shipment. Done BCP Testing and also took some of the training for the folks. 

Education

Oberbrunner Academy, North Carsonport, Hawaii
MBA, Supply Chain Management and Logistics, May. 2015

South Hirthe, Medhurstton, Connecticut
Bachelor of Commerce, Commerce Accounting and Tax, Jan. 2013

Skills

Leadership

Thinker

Advance Excel

Innovator

8f2ac6cf-50b1-470a-88ed-b181a7d60cb6

Andrew Smith

Professional Summary

Tenured professional with total 5+ years of extensive experience providing support to the Chief Executive Officers & top management of a multi-million-dollar organisation. Analytical, detail-oriented leader adept at multitasking within a fast-paced environment. In-depth knowledge of standard office procedures, software, and machines; proficient use of internet, database software and Microsoft Office Suite with expertise in Advanced Excel. 

Employment history

Sr. MIS Executive, Abbott-Hessel. Pfefferfurt, Wyoming
Jun. 2018 – Present
  • Provide support and maintenance to existing management information systems (MIS). 
  • Generate and distribute management reports in accurate and timely manner. 
  • Develop MIS documentation to allow for smooth operations and easy system maintenance. 
  • Provide recommendations to update current MIS to improve reporting efficiency and consistency. 
  • Perform data analysis for generating reports on periodic basis. Develop MIS system for internal communication. 
  • Provide strong reporting and analytical information support to management team.
  • Generate both periodic and ad hoc reports as needed. 
  • Understand problems and provide appropriate technical solutions. Analyse business information to identify process improvements for increasing business efficiency and effectiveness. 
  • Participate in cross-functional meetings to resolve recurring issues. 

Sr. Executive – MIS & Placement Operations, King-Vandervort. New Wendell, Nevada
Jan. 2016 – May. 2016
  • To publish accurate and timely reports. 
  • To keep the report data bank ready for any requests received from time to time. 
  • Reports/dashboard generation & Publishing– Daily / Weekly / Monthly. 
  • Coordinating with Operations and other support groups. 
  • Measuring performance against set KPIs. 
  • Provides insight on highlights /challenges as input for course correction. 
  • Continuous engagement with internal teams to identify analysis requirements, identify process gaps and provide regular reports to improve the performance. 

Process Associate, Kautzer LLC. East Delmerhaven, Oklahoma
Sep. 2015 – Nov. 2015
  • Working in a US Mortgage Process in Post-Closing Department. 
  • The work profileincludes Validation of mortgage loan documents by Borrower, checking authenticity of documents, coordinating with Investors regarding queries and suspense conditions on loan file, gathering documents as required by investor by coordinating with onshore teams and making loan files ready for purchase. 
  • Updating the loan file in CRM with notations & current status for management reference. 

Customer Support Associate – Data, Watsica-Treutel. Brunildaberg, Kansas
Oct. 2014 – Nov. 2014
  • Work Process: Vodafone Enterprise Backoffice–Activation. 
  • Activating & deactivatingservices, handling queries of account managers, providing required data to management to make decision making simpler & MIS activity. 
  • Interact with various delivery and technical teams to ensure on time service delivery. 
  • Provide documentation and technical support that simplify the work through Email. 
  • Arranging services, tracking delivery of services, keeping accounts & Audit. Processing work of the clients. 
  • Drafting, checking, and storing various documents required by the management. 
  • Gather the information, check the authenticity. TAT management. 

Executive – Business Excellence & Recruitments, Jones, Lesch and Lehner. Blockchester, Virginia
Jul. 2011 – Mar. 2012
  • Strategic Consulting, including business plan & contract management.
  • Identifying new opportunities and initiating client development through sign up with the companies for recruitment process. 
  • Responsible for managing an account effectively in terms of delivery commitments and closures to serve the existing clients who are in board for feel good factor.
  • Handling the mid senior and senior level recruitments along with client interaction/coordination. 
  • Screening candidates from the job portals and the resources whichever available. 
  • Client management, calling candidates, scheduling interviews, MIS Activities. 

Education

Northern Hoppe University, Lake Shanellborough, Montana
High School Diploma, Science, Oct. 2008

South Massachusetts Institute, Heaneybury, Massachusetts
Oct. 2005

Personal info


Phone:

(000) 000-0000

Email:

andrew_smith@example.com

Address:

287 Custer Street, Hopewell, PA 00000

Skills

Advanced Excel








Data Analysis








TAT Management








MIS Reporting








Visual Basic








SQL Server








MS Powerpoint








MS Access








7369b1f9-ab08-4536-95f4-e210c9186362

Andrew Smith


Phone:

(000) 000-0000

Email:

andrew_smith@example.com

Address:

287 Custer Street, Hopewell, PA 00000

Professional Summary

I have an interest in the area of learning and implementing Cyber Security with respect to its technical practical application as well as the Compliance and Standards related to it. I have a keen interest towards exploring the domain of Data Protection and Privacy and its related laws. 

My STRENGTHS: Good communication skills, Optimistic approach, Hardworking, good grasping power, I try to complete the work allotted with perfection, Multitasking.

Employment history

Mar. 2018 – May. 2018
New Reedmouth, Louisiana
MIS Executive, Mitchell Inc

  • Determine customers’ financial services needs and prepare proposals to sell services that address these needs.
  • Prepare forms or agreements to complete sales.
  • Develop prospects from current commercial customers, referral leads, or sales or trade meetings.
  • Review business trends to advise customers regarding expected fluctuations.
  • Make presentations on financial services to groups to attract new clients.
  • Complete sales order tickets and submit for processing of client-requested transactions.
  • Record transactions accurately, and keep clients informed about transactions.
  • Develop financial plans based on analysis of clients’ financial status, and discuss financial options with clients.
  • Offer advice on the purchase or sale of particular securities.
  • Contact prospective customers to present information and explain available services.

Aug. 2014 – Dec. 2014
New Gertie, South Carolina
Deputy Manager I, Keebler, Graham and Harber

  • Plan, direct, or coordinate the activities of workers in branches, offices, or departments of establishments, such as branch banks, brokerage firms, risk and insurance departments, or credit departments.
  • Approve, reject, or coordinate the approval or rejection of lines of credit or commercial, real estate, or personal loans.
  • Establish and maintain relationships with individual or business customers or provide assistance with problems these customers may encounter.
  • Network within communities to find and attract new business.
  • Prepare financial or regulatory reports required by laws, regulations, or boards of directors.
  • Oversee the flow of cash or financial instruments.
  • Review collection reports to determine the status of collections and the amounts of outstanding balances.

Education

Nov. 2019
Post Graduate Diploma In Computer Application (PGDCA): Computers

  • Nikolaus Academy – East Estebanborough, Oklahoma

Jul. 2017
M.Com: Commerce

  • East North Carolina University – North Carry, Kentucky

Dec. 2014
Post Graduate Diploma In Banking (PGDB): Banking

  • O'Connell Academy – Lake Chun, Pennsylvania

Aug. 2012
B.Com (Hons.): Commerce

  • North Rhode Island University – Port Byron, New Jersey

Jan. 2009
XIIth Class CBSE Board: Commerce

  • East Schinner – Schmittland, California

Feb. 2007
Xth Class, CBSE Borad: English, Maths, Science, Social Science, Sanskrit

  • Western Williamson – Homenickberg, Massachusetts

Skills

Proficient in working on Windows and Mac

Working knowledge of Microsoft Office – Word, Excel – Vlookup, Hlookup functions , Powerpoint

Have completed course on TALLY

Completed "Leadership Development Programme" from CRISP

mis executive

  • Develop and implement database, data collection system, data report to end users. 
  • Assign monthly & Yearly stock take 
  • Provided training to users, promoter third party users and supplier. 
  • Traveling training to West & East Malaysia. 
  • SPOC for HO on Sales MIS for region, Co-ordinate with various functional role holders for data and for driving new initiatives,   Support Managers by being SPOC for Development & analysis of New MIS & regular MIS, Co-ordinate with Managers for Regional Meetings, Coordination with R&R, Marketing, Reimbursements etc.  

mis executive

  • Perform entire bookkeeping services.
  • Tracking & reporting paid invoices from vendors & pending to be paid invoices from vendors on a monthly basis.
  • Reporting of outstanding payment due from customers and vendors on a monthly basis.
  • Recording & reporting of leads from customers for various courses on a monthly basis.
  • Co-ordination with vendors for technical improvement of the organization & maintaining vendor database.

mis executive

  • To ensure and keep monitoring the entire workstation, accessories and server is running with good condition. 
  • A local and overstates server troubleshooting. 
  • Perform daily & weekly scheduled data backup operations to ensure the entire database are successfully backed up to the appropriate backup type or disk was created. 
  • Perform system analysis, system structure process & database algorithms design to develop the solution to internal developer. 

senior mis executive

  • Pertaining to daily business and agent recruitment for region. Preparing daily snap shots and summary of various reports for easy reference. 
  • Collating, maintaining and flashing the data for the same on regional level. Providing support to the region and HO for data analysis and maintenance. 
  • Data interpretation in order to draw conclusion for managerial action and strategy, also presenting data and conclusions to manager in order to improve strategy and operation. 
  • Track & Analyse performance on Business level, Produce comparative statements on the above, Forecast & Project possible trends based on past performance and projections received from Sales Managers. 
  • Highlight the highs and lows of performance, Highlight Gap between actual figure and target. 
  • Collect and analyse competitor information on distribution set-up and performance for respective regions, Highlight Key competitor performance changes. 
  • Preparing power-point presentations for various local, regional and national level Meetings and Contests. 

mis executive

  • Prepare invoices, reports, memos, letters, financial statements and other documents, using word processing, spreadsheet, database, or presentation software.Direct, plan, or implement policies, objectives, or activities of organizations or businesses to ensure continuing operations, to maximize returns on investments, or to increase productivity.
  • Participate in product development and implementation. 
  • Regular data back up
  • Miscellaneous duties/projects as assigned.

mis executive

  • Support over 200 employees & Support over 300 outlet retails and counters. 
  •  Assist in maintenance of POS System (fronted & backed hardware and Application support) 
  • To attend METAMATRIX will log local calls to the ticketing system. 
  • Responsible office users to troubleshoot company with faulty workstation, printer, Network and others IT equipment to ensure all is work properly. 
  • Support and troubleshooting finance, payroll and store inventory application for ANAKKU, AUDREY, BUM, DISSEY, ZUCCA and etc. 
  • To ensure all the daily & monthly data collection receiving. 
  • Create & Modify user authorizer function of system application and folder access permission. 

mis executive

  • Analyzed,examined and interpreted records, compiled financial Information, and reconciled reports and customer data.
  • Perform process analysis and communicated recommendations to management with sql queries.
  • Process Journal entries and perform corrections to ensure accurate records with T-sql. and different Excel functions(Vlookup, Hlookup,Aggregate functions).
  • Share the report with Dealer management and MB India for business analytics.

mis executive

  • Cost/enquiry report for the month.
  • Stock report (Dealer stock, transit stock)
  • Stock age report.
  • Manpower report (Plan Vs Actual, Training status etc)

mis executive

  • Create and maintain Management reports including end-of-month, quarterly, and annual report used by various departments.
  • Assist with the release of information relating to systems upgrades and changes to processes, provide system training to users
  • Automate and schedule report generation.
  • Network management, web-site maintenance, and trouble shooting.
  • Maintain Business Analytics program for internal users.
  • Data analysis and reporting
  • Maintain process for Management to request reports and support.

mis executive

  • Read documents such as PO and SOW enter data in specific tool.
  • Prepare gross margin, management reports like vendor time, employees hours, etc.,.
  • Compare the sales report and monthly margin report with previous month and write an interpretation.
  • Allocation of resources.
  • On boarding / creation, maintaining and closing  of projects in SMART (Tool) 

mis executive

  • Daily, Monthly, Quarterly and Annual sales report.
  • Competition sales report.
  • Market share report.
  • Market penetration report.
  • Conversion report (Suspect>prospect>Test drives>orders>retails)
  • Source wise enquiry report. (Walk-in, Tele-in, Events, Road Shows)
  • Advertisement effective report.

mis executive

  • Working as a seller on Amazon US and resolve customer complaints regarding sales and service on e-mails.
  • Direct and coordinate activities involving sales of products and FBA shipments 
  • Monitor New Release of books determine focus of sales .
  • Manage 2 MIS Executives to ensure MIS Reports are timely flashed to the Clients & Internal Departments. 

mis executive

  • Used SAP, Dolphin & Sequel to generate, analyze and model data.
  • Punching of New Sales Order in SAP.
  • Prepare Daily Dashboards & to publish the same to Clients & Internal Departments.
  • Do Analysis of the data given by Clients & to Publish the same.

senior mis executive

  • For Loop Mobile & Airtel Prepaid & Postpaid Inbound Process – MIS Department.
  • Prepare Daily Attendance of Overall Staff.
  • Prepare Billing, Invoice, Audit Report on Daily Basis.
  • Prepare Daily Inbound Report, VAS Upselling Report on Daily basis & also to send it to Clients on daily basis.
  • Prepare Weekly, Bi-Monthly, Monthly MIS reports &send it to Clients & Internal Departments.
  • Sort Out VAS Discrepancy & to publish the same on Weekly & monthly Basis.
  • Prepare Monthly KPI (Key Performance Indicator) for CSR & Support Staff.

mis executive

  • Prepare and maintain production records. 
  • Develop and implement strategies to achieve organizational goals
  • Collecting data related to the necessary tech specifications of each department
  • Prepare Attendance Report.

mis executive

  • Dealing with customers/franchisee ,solving their queries.
  • Part of account opening department, verification, KYC etc.
  • Maintaining excel spreadsheet of everyday work done.
  • Collecting Data and performing Inbound And Outbound Calls.

mis executive

  • The commands used for the above purpose were vlookup, Macros, Filter, Pivot Table, Pivot Charts, Reports, Excel formulae’s whenever required. 
  • Exporting raw data from SAP using various T-codes into Excel for making Analysis of the data and preparing Reports. 
  • Processing and Uploading of Time Reports, Reimbursement claims of employees into SAP using various transaction codes. 
  • Solving employee’s queries via email, chat conversation or phone conversation. 

mis executive

  • MIS Management. 
  • Uploading documents of new trainees on Skill India portal. 
  • Daily Reports generations. 
  • Daily Attendance Management for Employees as well as Students. 
  • Help the mobilizers in mobilization to get admissions. 
  • Taking feedback from Mobilizers on daily basis. 

mis executive

  •   Preparing the data using MS Excel and MS Access.   
  • Preparing Health Check Dashboard, Revenue Dashboard, Look to Book Dashboard, Hotel Dashboard in waterfall format and publishing it on daily basis. 
  • Preparing Daily, Weekly and Monthly reports and sending it to the concerned department. 
  • Sending data to senior as per their requirement.  

mis executive

  • Preparing India and UAE Sales Dashboard, dynamic packages dashboard mostly in waterfall format and publishing it on daily basis. 
  • Preparing the SEM Campaign sales calls report and send it to marketing team on daily basis. 
  • Coordinating with all the Outsourced Vendors to get all the daily reports on time and checking for correctness of data. 
  • Daily reconciliation for short collection, excess collection, transaction details having no trip id.

mis executive

  • Set up and manage paper or electronic filing systems, recording information, updating paperwork, or maintaining documents, such as attendance records, correspondence, or other material.Collect and deposit money into accounts, disburse funds from cash accounts to pay bills or invoices, keep records of collections and disbursements, and ensure accounts are balanced.
  • Analyzing CSAT as per the survey data and publishing it on weekly basis. 
  • Maintaining attendance data of the floor and submit it to HR on monthly basis. 
  • Checking the leaves applied by agents and allotting them properly which helps in weekly rostering. 

mis executive

  • Cater to ad-hoc reporting requests by the management.
  • Ensure timely delivery and quality of reports.
  • Analyzing daily call flow and reason for High Call Flow and high AHT. 
  • Analyzing call forecast on daily, weekly and monthly basis. 

mis executive

  • Worked as an MIS Executive in Time and Expense (Controllership Finance Department) team, handling a team of four people. 
  • Making Analysis, Comparison, Consolidation, Reconciliation, and Ageing of Data, preparing Reports and then submitting it to Team Leader, HR, Project Manager and other Finance Departments. 
  • ·Making Analysis of time reports submitted and missing for each fortnight, consolidating and comparing the records of every fortnight and submitting the trend to Team Leader. 
  • Providing information to our Controllership Head about the employee’s count, GMU details, Designation, Bill Rate, Cost Rate, Project work done. This information is submitted every fortnight after a thorough check is done. 
  • Ageing of suspense data from SAP and suspense website, comparing them and submitting the changes to Team Leader and other Departments. 
  • Making Analysis of Vacation data, Public holiday data, Flex Leave data of employees who have charged excess. Pivot Table is prepared to find out the excess hours charged. 
  • Headcount Report was prepared everyday and after making the comparison the final report is submitted to Team Leader. 

senior mis executive

  • Preparing presentation slides for weekly management meeting and sending it to seniors. 
  • Serving the Operations floor as a WFM-MIS with a team of two executive’s directly reporting to me. 
  • Preparing Schedule Adherence report, Shrinkage Report, Attrition Report, Agent Break Report on daily, weekly and monthly basis. 
  • Preparing Stack Ranking report, Dollar Game report and Agent performance report on monthly basis. 
  • Preparing and Publishing Ops Dashboard, CSAT Dashboard, Fulfillment Dashboard and Fulfillment Revenue Dashboard on daily basis. 
  • Preparing monthly incentives payable to CSE Agents, SME, TL as per the structure set by HOD and sending it to HR for processing. 
  • Compile and interpret statistical information to calculate and project staffing requirement of the department. 

mis executive

  •  Generate production performance reports for various teams.
  • Providing and analysing data for daily & Weekly Performance dashboards.
  • Meeting client requirements within TAT accuracy.
  • Making power point presentation for weekly & Monthly review.
  • Generating and publishing of reports at specific and pre-determined time.
  • Detailed reporting with sub-metric drill downs and also summary dashboards have to be published.
  • Respond to queries by end users of reports.

mis executive / data analyst

  • Material Flow Project for Mega DC Automation Warehouse for Inbound, Outbound and Replenishment and Storage Capacity.
  • UAT testing and development of automated reports in Qlikview application with the help of IT team.
  • Team work with Logistics Executives and Managers for process development, reports modifications across all Middle East Countries.
  • Development of reports (OBIE, SCP) through system level with the help of IT team.
  • Supply Chain MIS reports preparation and submission to the management.
  • Preparing reports and calculations of lead times and presenting to the management.
  • Presentation of PPT reports of Productivity and Organization SOP.