Abdul Majid

Contact Islamabad, Pakistan - (Mobile)- www.linkedin.com/in/amsiddiquie (LinkedIn) freelancerodesk.wordpress.com/ (Company) Top Skills Microsoft Office Peachtree Microsoft Excel Languages Punjabi Urdu English Abdul Majid (AM Siddiquie) Freelancer VA, Cin7 Core / DEAR Inventory, SAP ERP S4 HANA FICO, Xero, Data Collection, Word, Excel & Accounts Pro. Islāmābād, Pakistan Summary I have a strong background in Bookkeeping and Virtual Assistance, with more than 15 years of experience in Accounting and Finance. I am a motivated, reliable and disciplined accounts expert, who uses a proactive approach to overcome challenges and implements effective accounts management systems and procedures. My core competencies include: • Advisor of Cin7 Core formerly known as DEAR Inventory System (A Complete solution for your Business Inventory) • Bookkeeping - Cloud Accounting (Xero, Quickbooks Online, MYOB, BigRedCloud, FreshBooks, SAP S4 Hana FICO) Desktop (Quickbooks, Sage 50, Peachtree, MYOB, Excel & Access) • My Own designed Excel Based POS • Cin7 Core (formerly DEAR Inventory) & Xero Templates Designing & Customization • PDF conversion to Excel, Word, Database or text, PDF Editing & Designing fill-able PDFs • Invoicing and Billing • Reconciliations • Custom Reports and Formats • Integrations with different Channels • MS Excel Module, template & Spreadsheet Development (including using Advance Excel functions, Forms, Power Pivot, Charts, Macros & VBA) • MS Word template / Document automation (including Forms, eBooks, Mail merge, Macros & VBA) • MS Access database designing & database management • MS PowerPoint Presentation designing with animation & transition effects • Product listing, Store Management & order processing on Amazon, Play.com, Shopify, Vend, Magento, Prestashop, WordPress, Drupal, Joomla, Moodle & other eCommerce platforms • Web data scraping using VBA & other tools, Data Collection, Data Entry, manipulation, sorting & Analysis, Web Research Work Page 1 of 6 • Google Spreadsheets & Google Docs I am easily reachable via Skype, Whatsapp, Email & Phone. Please contact me if you need help in any task related to my skills. Regards, AM Siddiquie Google: abdulmajid1979 Skype: majid_ams Mobile & Whatsapp: - Web: http://freelancerodesk.wordpress.com/ Experience Cin7 Implementation & Support Specialist January 2015 - Present (9 years 2 months) Virtual Providing ongoing support to maintain Quality of services for customers, replying ticket, template customization, Data conversion, bug testing and testing integrations The PEO Group & BRG Group Virtual Assistant Lead & File Management September 2014 - Present (9 years 6 months) Virtual Initially Kenn hired me for doing some excel tasks, but after reviewing the results and my skills, he asked me to manipulate data and Lead management in Zoho CRM on regular basis. It is great experience to work with him https://www.upwork.com/jobs/~0164bea18b915f2ec9 Medical Optics Bray Accounts Executive September 2012 - Present (11 years 6 months) Virtual Position Maintaining Accounts, Supplier's ledgers, reconciliation bank statements and supplier's ledgers, on Cloud Accounting application www.bigredcloud.com. Upwork 14 years 3 months Page 2 of 6 Freelance Virtual Assistant December 2009 - Present (14 years 3 months) I have completed Several Diversified Projects including Ms Access, Ms Excel, Ms Word, Ms Power point, database designing, data collection, data analysis, Product listing on eCommerce Websites/Web stores, Account Handling (LinkedIn, Facebook, twitter), Customer Support Via email / Live Chat etc. Excel Sheet Designer October 2012 - October 2012 (1 month) Designing Excel Spreadsheet for maintaing Expenses & Incomes of a small Business. BESROCK (PVT) LTD Accounts Officer November 2008 - March 2022 (13 years 5 months) Islamabad Maintaining Accounts on MS Excel based accounting system, Entering vouchers, Preparing Bank reconciliations, Watching & maintining Suppliers & Customer's Ledgers/Accounts, Payroll, Preparing different type of accounting information whenever required Better Engineered Solutions Pvt Ltd Accounts Officer November 2008 - March 2022 (13 years 5 months) Islamabad Maintaining Accounts on MS Excel based accounting system, Entering vouchers, Preparing Bank reconciliations, Watching & maintining Suppliers & Customer's Ledgers/Accounts, Payroll, Preparing different type of accounting information whenever required Leading Analytic Company Virtual Assistant (Data Analyst) June 2014 - June 2021 (7 years 1 month) Virtual The role requires that data is taken from PDF invoices and inputted into Microsoft Excel for Analysis, Commitment to timely completion of task need to be assured https://www.upwork.com/jobs/~01b81dd1b1e9c61964 Studio Blue Creative Page 3 of 6 Excel Data Manipulation Expert April 2013 - April 2013 (1 month) Convert data provided by client on a template that can be uploaded to Virtue mart eCommerce using Excel Formulas & Filters Biomeme, Inc. CLIA Data Scrapper April 2013 - April 2013 (1 month) Get database data for Compliance 1) Go to: Source website 2) Scroll down to "By Geography" and select "AK" in the dropdown 3) Scroll down to "Application Type" and select "Compliance" in the dropdown 4) Scroll down and click the "Submit" button 5) In the browser options, select Edit > Select All, then Copy the text 6) Open an Excel workbook document, label the sheet "AK" and paste the copied text 7) Repeat this for every state in the "By Geography" dropdown, labeling a new Excel worksheet with each state Raine Goh Financial Data Analysis April 2013 - April 2013 (1 month) Please open the download the source files - Contracts.xls (1 sheet) - Statements.xls (3 sheets) 1. Open both files. 2. For Statements, the "Amount" indicated in column E is in USD. I want to change it to SGD. 3. Go to http://www.oanda.com/currency/converter/, put in the correct values, remember to change the DATE. I have put in one example, (file: convert example) for the first value of USD33.33. 4. Repeat and do it for all the values in all 3 worksheets in "Statements.xls". Total 130 entries. 5. Next, open up Contracts.xls, find the contractor's name, copy the "Title" to "job title" in statements.xls. 6. Repeat and do it for all the values in all 3 worksheets in "Statements.xls". Total 130 entries. Page 4 of 6 Interest applicants please answer the following: - How long do you need to complete the job? The sooner you can do it, the more likely you will get the job - To prove that you have understood my requirement, please do the compulsory trial. **COMPULSORY TRIAL** What is the SGD amount and job title for Statement.xls, sheet 1 (1. Fixed), ROW 3 (Ranti Martins)? - SGD: - Job title: Applicants who do not answer what I want to know will be rejected immediately. Thank you! Morgan Skenderian Investment Real Estate Group Realtor's Virtual Assistant December 2012 - April 2013 (5 months) Follow these instructions 1) Go to Google. 2) Enter in `Real Estate Agent, Tyler, Texas. 3) Find as many email addresses as possible and add it to the spreadsheet. 4) Sometimes, you have to look around on the website to find as email address. 5) on the website, a good place to look for the email address is under: About Us, Contact Us, Agents, etc. Also, please make sure you do the above search for `Tyler Texas Commercial real estate agents’. Once you have done this, repeat the process for the following terms: Tyler, Texas, real estate. Tyler, Texas Homes for sale. Tyler, Texas, Commercial Real Estate. Real estate brokers, Tyler, texas. Page 5 of 6 Also, go to this website and click on the link that says Members. Go to the websites for each one of the companies and get the email addresses for all of the agents with each company. JH Consultants Medical Products & Producers Data Collector February 2013 - March 2013 (2 months) Client needs a data entry professional who is also an expert with importing excel spreadsheets into Access database file. The following will be required: - Create an Access database file - Import a list of 30,000 companies that will each have 10+ records each, fields are imported from different excel files. - Access an online info site and download excel files to be imported. Each company has a separate file to be imported. - Each company has a product list with additional records that you will import from excel to the database. Medical Optics Fairview, Ireland Accountant August 2012 - August 2012 (1 month) Prepared Accounts for FY 2011-12 as client requirements Egudo Customer Support Manager December 2009 - June 2012 (2 years 7 months) I was assigned duties of Handling customer queries and replying emails as well as providing live support via Skype. Education Virtual University of Pakistan Master of Business Administration (MBA), Banking and Financial Support Services · (2008 - 2010) University of the Punjab, Lahore Bachelor of Commerce (B.Com.), Accounting and Finance · (1997 - 1999) Page 6 of 6