Experienced Accounting professional offering 14 years solid experience in Accounting, Bookkeeping, Auditing, Payroll, Financial Management, Budgeting and Forecasting, Accounts Receivable, Accounts Payable and Process Improvement. I am competently qualified and superbly experienced with QuickBooks and Xero. I have advanced skills with Quicken, MYOB, Wave and Freshbooks. I can fulfill immediate and temporary needs such as fixing bookkeeping errors, rectifying files that had been severely mishandled by previous bookkeepers, migrate data files from other accounting system or start a new file for you. I also have capabilities in directing a team as well as simultaneously coordinating projects in different locations. I am an excellent problem solver with strong communication skills and ability to deliver results both independently and in a team environment.
Six Sigma Job Cost Overview
Typical total cost of oDesk Six Sigma projects based on completed and fixed-price jobs.
oDesk Six Sigma Jobs Completed Quarterly
On average, 5 Six Sigma projects are completed every quarter on oDesk.
Time to Complete oDesk Six Sigma Jobs
Time needed to complete a Six Sigma project on oDesk.
Average Six Sigma Freelancer Feedback Score
Six Sigma oDesk freelancers typically receive a client rating of 4.72.
Over the last 6 years I have worked in a variety of multinational companies in operational excellence (Lean Six Sigma), engineering and project management roles. I am currently starting a consultancy business and would like to generate some additional income as a business consultant, data/statistical analyst or virtual assistant. While my skills tend towards more technical roles, I would also consider more general roles too.
Greetings of the day, Thank you for visiting my profile. I am an accomplished professional with robust experience for around 7 years in process management and optimization, client servicing, supply chain management , business transition, team management and last but not the least in continuous quality improvement. I am a Maestro in bringing changes for improvements. I have a strong affection with customer requirement and aligning processes to meet demands. I hate wastes and don’t like investing time doing something which tools can do for us. Handling project is one of my passions. Be it anything, I like them to be perfect. Mentoring and coaching are my favorite activities. Customer service is my top most priority. Converting challenges to opportunities have taken a shape of science however its core still remains at art and this is the only art, I am fond of most. ☺ Let’s connect and bring the change together.
Lean Six Sigma Blackbelt (BSi Certified) Create excel dashboards and analysis tools ranging from very simple to highly complex. Provide solutions to business issues you have to help you active business goals. More than just programming but also providing solution after working in some large corporations, I understand what businesses need and want. Highly skilled in most statistical tools. Advanced Microsoft Office user. VBA/Excel/Powerpoint/Access/SQL/Word Minitab/Visio/ Can create excel dashboards and tools to high specification and deliver basically anything the customer needs. Also will help with consulting to provide a solution that maybe better suited.
My goal is to utilize my extensive background in the Information Technology industry where I've held roles in software development, systems analysis, and currently in IT Service Delivery Management and IT Program and Project Management. My core competency is in the area of IT Program and Project Management. I hold an MBA degree along with a Computer Science degree. I'm also a certified Project Management Professional (PMP), Microsoft Certified Professional (MCP), Information Technology Infrastructure Library (ITIL) certified, Microsoft Operations Framework (MOF) certified, and Six Sigma Greenbelt (SSGB) certified. I'm seeking opportunities to lend my extensive experience in Information Technology project management to execute projects on time and on budget.
Over the last 8 years, I had the opportunity to use a number of statistical/data/Presentation software tools, these are MS Excel, Minitab, Power point. These tools were primarily used to manage & compiling data, create analysis, produce reports and dashboards. I worked in MNC’s as a process engineer and I have 8 years experience as statistical analyst. My core expertise is statistical analysis and dashboards creation using line chart, bar charts, bubble chart, scatter plot, Gantt charts, trend analysis, pivot tables, macros, filters and formulas. My skills on Excel listed below. Recording and Running Macros • Recording Macros • Adding Macros to the Quick Access Toolbar • Editing a Macro • Start the Vba Editor • Absolute and Relative Recording • Macro Storage Locations • Running macros from toolbars, menus or worksheet buttons Calculating Data with Advanced Formulas • Using Logical Functions • Understanding of Sumifs and Countifs Function • Dealing with one and multiple conditions • Summing values in a range which has error values (without sorting/filtering/deleting) • Summing values (based on one/multiple conditions) from another workbook • Using Statistical Functions • Using Date Functions o Converting non dates to dates o Displaying non dates as dates o Retaining date/number formatting when concatenating with data in cells • Using VLOOKUP o Making the column index in a VLOOKUP() function dynamic formula when new rows get added o Looking up data within upper and lower limits o Performing lookup in a range where there are multiple occurrences of a string. o How to make Column Index Dynamic in Vlookup Function. o How to provide a good error message Instead of “#N/A” in Vlookup. • Using HLOOKUP • INDEX AND MATCH FUNCTION • ARRAY FUNCTION Analyzing Data Using Pivot Tables and Pivot Charts • Performing calculation in pivot tables What to be careful about when working with pivot tables Resolving problems when grouping numeric data / dates in a pivot Addressing issues when writing formulas within pivot tables Use Slicer to filter Pivot Table data to Excel 2010.Using External Data Sources • Multiple consolidation ranges • Pivot table advance options • Creating a PivotTable Report • Analyzing and Modifying a PivotTable • Creating Pivot Charts and Dashboard • Sorting and Filtering Worksheet or Table Data • Using Database Function • Applying Data Validation to a Worksheet Basics of graphing and nuances • Creating 2 y axis charts • Dealing with dates in the x-axis • How to create Interactive Charts Using Excel Objects? • Customising data labels on charts • Presenting data in “Bar of Pie” and “Doughnut charts” • Getting total labels in stacked column charts • Use of XML and its mapping in excel • Creating forms in MS excel
Manuel Albuera, Jr. Agency Contractor
As a third class cadet at the Philippine Military Academy in 2005, I was the sole recipient, among the members of the class of 2008, of a United States Naval Academy (USNA) scholarship. As a midshipman at USNA from 2005 to 2009, I studied Applied Physics. I have honed my management skills through supervisory and management roles in the security industry here in the Philippines before I went full-time with online freelancing. I have a passion for learning and, as an online freelance, have developed my skills on web development and design. My constant goal is to excel in every field that I step on. It is being reflected on my oDesk work history as one of the top-rated freelancers.
Andrie James Lim Agency Contractor
Andrie has been in the outsourcing and off-shoring industry for more than 10 years of with exposure to vast and various industries in travel, telecommunications, Web and IT among others. As an Operations and Project Manager for various start ups and well known global brands and companies, he is widely exposed and has been working with people from different geographies from around the globe. He is also into process management and focuses on process improvement with Six Sigma background under his belt. Since 2010, he has been a project and operations manager consultant and support for various companies around the globe. He handles a wide range of facets across projects and operations from people management, recruitment, process management and improvement, finance/budgeting, client communication and management among others.
I am Six Sigma Green Belt Certified Statistician and have vast experience working on Statistical tools such as SPSS, SAS, JMP, and Minitab etc. I am among the Top scorers in Statistics and MS Excel tests on oDesk. I have taken several online courses such as Moodle, MathXL/ My Math Lab/ My Stat Lab and have scored exceptionally well in them (See screenshots attached in my Portfolio) I also have advanced Microsoft Excel skills and have worked extensively with Pivot Tables, Macros and Advanced Excel Functions like VLOOKUP, HLOOKUP etc. I am a Maths Wizard. An MBA in Operations Management and an Engineer in Computer Science, I have a high IQ level of 128 and I am a member of the prestigious Mensa society. A deep observer having an unending urge to learn, I love to explore and learn new technologies that come along the way.
I hold a degree in MBA specialising in Projects& Operations management. I have done a PRINCE2 foundation. Im also a certified LEAD AUDITOR (ISO 9001:2008).Im interested in any documentation related job . Also I have a flair towards languages. I can speak,write and understand English,Hindi and Tamil very well. I can read and understand sanskrit as well. Im looking forward for a career as a language translator. I have completed various certifications in Hindi language.I have a score of 7/9 on IELTS. Presented lot of papers during college and won many prizes. Anybody needs a tamil to hindi/englishtranslation,blog/articlewriting.Pl contact me.