David Farley Rpa Expert Email and Phone Number
►► I am a champion and expert in all the following business related processes: ★ Robotic Process Automation (RPA) ★ Excel Programming ★ SQL Database Creation and Automation ★ Business Intelligence ★ Data ConversionI have over 23 years of automating business processes and performing Robotic Process Automation.UiPath - Robotic Process Automation (RPA) - Certified UiPath developer, with expert skill level. Expert at using UiPath Orchestrator also. I have built many automated processes using UiPath. I have also built many interactive automation processes in Excel, using the UiPath API, to create true end-to-end solutions.I am an off-the-charts expert user of Microsoft Excel, Microsoft SQL and Microsoft VBA. I have automated business tasks with these programs that business users did not believe could be accomplished.Nicknames given by clients: Robo King; Excel Jedi; Wizard; Doctor; Magician; Silver Bullet.I started my career as a Certified Public Accountant (CPA) and have continued to provide consulting related to Accounting/Finance.My technology specialties include:► UiPath - Robotic Process Automation (RPA)► Microsoft Excel► Microsoft SQL► Microsoft Power BI► Microsoft Visual Basic► Microsoft PowerPoint► Microsoft Access► Microsoft Word► Hyperion Essbase► Microsoft FRx► Crystal ReportsMy business experience specialties include:► Robotic Process Automation (RPA)► Business Analysis & Business Process Improvement► Business Intelligence► Data Analysis► Data Conversion► API ProgrammingSome companies consulted: TOYOTA, NIKE, SAPUTO, SANTANDER CONSUMER USA, CYRUSONEExamples of a project and results include:Automated vehicle incentive process, using interactive UiPath and Excel automation processes. This helped significantly remove errors from the process and change the roles of multiple employees. Prior process took the entire month, is now completed in 1-2 days. Dealers are now paid immediately, instead of 2-3 months later. Employees no longer correct errors or work significant overtime. The overall benefit to the company is immeasurable.I have used many database related applications and have also developed the skills to query and edit data on cloud platforms and API solutions.My hybrid business and technology experience allows me to communicate very easily with business personnel and also information technology personnel.I have a strong desire to educate those who I work with. I am more than happy to share my knowledge and help empower people to use automation technology programs with better efficiency.
Accelerated Business Solutions, Inc
View- Website:
- texasexcelexpert.com
- Employees:
- 1
-
President | Champion In: Robotic Process Automation | Excel And Sql Automation | Business IntelligenceAccelerated Business Solutions, IncTexas, United States
-
President | Champion In: Robotic Process Automation | Excel & Sql Automation | Business IntelligenceAccelerated Business Solutions, Inc Jul 2012 - PresentFrisco, TxFor over 21 years, I have developed a HYBRID skill set of strong Accounting & Finance skills combined with strong Information Technology skills, specifically UiPath - Robotic Process Automation (RPA), Microsoft SQL Automation, Microsoft Excel Automation and Microsoft Visual Basic.With the combination of UiPath (Robotic Process Automation), Microsoft SQL Automation, and Microsoft Excel automation, I can literally automate any business process. This will allow your analysts to be analysts - they won't have to spending hours performing repetitive tasks, when their time can be spent analyzing and performing value-added tasks.With my strong understanding of the business side and the information technology side of complex projects, I am able to literally program Microsoft Excel to do whatever you want it to do. I have performed projects that were otherwise thought to not be possible.Return on Investment (ROI) - have helped many companies to save hundreds of thousands of dollars, by creating efficient and accurate tools that will perform data related projects, in minutes, instead of hours, days or even weeks.Accuracy and Efficiency - business process automation, including Robotic Process Automation (RPA), Excel Automation, and SQL Automation, helps to dramatically improve accuracy and efficiency. Your company can save thousands of dollar by having processed completed correctly the first time.- Provide consulting and automation services related to: - Robotic Process Automation (RPA). I am Certified UiPath Developer. - Microsoft Excel Automation - Microsoft SQL Automation - can automate using any data source, including online API. - Business Intelligence - Expert user of Microsoft Power BI - Business Analysis and Business Process Improvement - Data Conversion - Accounting & Finance - Financial ReportingOur company performs big and small projects - whatever your needs. We also partner with other consulting companies.
-
Senior Business ConsultantXllerate Consulting, Llc Oct 2016 - Mar 2018Dallas/Fort Worth AreaProvide consulting services related to information management, business process automation, data conversion implementation, accounting, finance, analysis and reporting.Streamline and automate business processes using Microsoft Excel, Microsoft SQL and Microsoft VBA (Visual Basic for Applications) and other technology tools, saving companies hundreds of hours of work and hundreds of thousands of dollars.Some examples of projects include:- Netsuite data conversion specialist for Healthcare company. Historical Quickbooks accounting balance data, for over 100 subsidiary locations, was setup in Microsoft Excel, modified by VBA procedures, and then loaded into SQL. Excel could not have handled all the data. Created SQL stored procedures to convert the large data into a table which was then used by Excel to create upload files for Netsuite.- Workday data conversion specialist. Using Microsoft Excel and VBA, created tools to convert Great Plains General Ledger account balance data to Workday. Provided upload files to Workday implementation team.- Workday journal entry uploads. Using Microsoft Excel and VBA, created numerous journal entry tools to convert data into files that were then uploaded into Workday.- Build SQL database with warehouse related data for large (well-known) recreational vehicle company. Loaded data into SQL and then provided views and stored procedures to calculate inventory turns. Provided analysis related to 1) sales and shipping of products from each warehouse; 2) products being shipped from facing warehouse vs shipping warehouse, allowing recommendations on how to reallocate products at different warehouses throughout the company.- Filled in for Finance Manager of Healthcare company. Modified and automated Business Development models and financial forecasts. Automated a number of business processes, allowing employees to use data more efficiently and removing the need for data entry.
-
Hybrid Information Management & Accounting Consultant | Business Intelligence | Data ConversionRgp Apr 2015 - Sep 2016Dallas/Fort Worth AreaProvide consulting services related to information management, business process automation, data conversion implementation, accounting, finance, analysis and reporting.Streamline and automate business processes using Microsoft Excel, Microsoft SQL and Microsoft VBA (Visual Basic for Applications) and other technology tools, saving companies hundreds of hours of work and hundreds of thousands of dollars.Some examples of projects include:- Workday data conversion expert for worldwide Dairy company. Created automated process, using Microsoft Excel and Microsoft Visual Basic for Applications, to populate nearly 40 Workday iLoad conversion templates in under one hour.- Workday iLoad templates can be very complex and frustrating. Many of the Workday iLoad templates take hours to manually populate the required data. Some even take days to populate. Most of the Workday iLoad templates I created completed the population process in one second. The longest Workday iLoad template took about ten seconds. - When there are multiple test iterations and the final "Go Live" iteration, the Workday iLoad templates I automated saved the company hundreds of hours of work and delivered completed data without errors or need for corrections. -
Consultant | Business Intelligence Expert | Data Conversion ExpertRobert Half Management Resources Jul 2014 - Apr 2015Dallas/Fort Worth AreaProvided consulting services related to business process automation, business intelligence, and data implementation.Streamlined and automated business processes using Microsoft Excel, Microsoft SQL and Microsoft VBA (Visual Basic for Applications) and other technology tools, saving companies hundreds of hours of work and hundreds of thousands of dollars.Some examples of projects include:- Implemented data conversion to Yardi ERP system for Data Warehousing company. The data conversion process used automated tools created in Microsoft Excel, using VBA, to make the conversion process very fast. Data reconciliation reports were provided instantly and the conversion process was accomplished much quicker than management expected.- Automated reporting process for Aerospace Part Manufacturing company, using SSRS, SSMS and Microsoft Excel automation. -
Senior Business AnalystSizzling Platter, Llc Jul 2009 - Jul 2014Provide business and data analysis for restaurant management company. Streamlined and automated innumerable accounting, finance, analysis, reporting, marketing, human resources and other miscellaneous business processes using Microsoft Excel, Microsoft SQL and Microsoft VBA (Visual Basic for Applications).I cannot begin to number the business processes throughout the company that I have personally streamlined and simplified. By doing so, I have saved the company hundreds of hours of labor every month and tens of thousands of dollars every year.Some examples of projects include:- Period-end and Year-end Financial Reporting - created Microsoft SQL Server database tables to customize financial data storage - Streamlined customized Financial Statement Package using Microsoft Excel and Microsoft VBA . This process used to take multiple days and is now completed within one day.- Weekly Management Reports - Programmed weekly financial reports using Microsoft Excel and Microsoft VBA to obtain data from Microsoft SQL Server and then create hundreds of store reports and charts for District and Regional Managers. This process used to take two to three days and has been reduced to one to two hours.- Budget Consolidation Tools - Simplified and streamlined budget financial reports using Microsoft Excel, Microsoft SQL and Microsoft VBA. The process to compile budget data used to take six to eight hours and now only takes a few minutes. The entire budget consolidation process, which used to take multiple days, is now completed in less than one hour. -
Financial & Accounting Consultant | Microsoft Sql | Business IntelligenceRobert Half Management Resources Feb 2002 - Jul 2009Provided consulting services related to accounting, finance, analysis and reporting functions.Streamlined and automated business processes using Microsoft Excel, Microsoft SQL and Microsoft VBA (Visual Basic for Applications) and other technology tools, saving companies nationwide hundreds of hours of work and hundreds of thousands of dollars.RHMR management called me their "Silver Bullet"!Some examples of projects include:- Saved a large insurance company nearly one million dollars by creating a customized daily time management system. This was done using Microsoft Excel, Microsoft VBA and Hyperion Essbase. The company did not have to purchase another extremely expensive ERP module.- Streamlined and simplified a waterfall forecasting model for multiple product lines using advanced features in Microsoft Excel.. What used to take three days of manually updating charts and data, is instantly updated by entering the effective month and year.- Reduced monthly financial closing cycle for a utility company from 7 days to 4 days, saving the company thousands of dollars per month. Many processes were automated using Microsoft Excel, Microsoft VBA and Hyperion Essbase, but the biggest process of creating over 850 reports for management was reduced from two days to 30 minutes.- Trained Title XVI Program Expert at Social Security Administration how to program Microsoft Excel and Microsoft VBA. An application was finalized with my help and is now used by all offices nationwide. The time savings for this application saves the SSA tens of thousands of dollars per month.- Created a procedure in Microsoft Excel and Microsoft VBA that retrieves data from Microsoft SQL Server, dynamically updates hundreds of charts and reports and then populates hundreds of PowerPoint slides, all within a few minutes.Also served a variety of roles including Controller, Assistant Controller, Accounting Manager, Financial Reporting Manager, Financial Analyst and Budget Analyst.
-
Financial & Accounting Consultant | Microsoft Excel | Microsoft VbaResources Connection, Inc. Mar 1999 - Feb 2002Provided consulting services related to accounting, finance, analysis and reporting functions.Streamlined and automated business processes using Microsoft Excel, Microsoft SQL and Microsoft VBA (Visual Basic for Applications) and other technology tools, saving companies hundreds of hours of work and hundreds of thousands of dollars.One company continued to use me as a consultant for nearly two years when the engagement was only supposed to last for six to eight weeks.Some examples of projects include:- Implemented and maintained Lawson Financials software including General Ledger, Accounts Payable, Asset Management, Budget, Report Writer, Lawson Environment and user security, saving the company hundreds of thousands of dollars if they would have used Lawson personnel.- Created custom software application, using Microsoft Excel and Microsoft VBA to integrate store accounting data with corporate accounting ERP system; this process eliminated Accounts Payable double entry of vendor invoices, reducing weekly invoicing cycle for entire Accounts Payable department from one week to one day, saving the company over $10,000 per month.- Streamlined and automated repetitive monthly accounting and analysis activities using Microsoft Excel and Visual Basic, saving the company thousands of dollars per month.
David Farley Rpa Expert Skills
David Farley Rpa Expert Education Details
-
Brigham Young UniversityBachelor'S Degree
Frequently Asked Questions about David Farley Rpa Expert
What company does David Farley Rpa Expert work for?
David Farley Rpa Expert works for Accelerated Business Solutions, Inc
What is David Farley Rpa Expert's role at the current company?
David Farley Rpa Expert's current role is President | Champion In: Robotic Process Automation | Excel and SQL Automation | Business Intelligence.
What schools did David Farley Rpa Expert attend?
David Farley Rpa Expert attended Brigham Young University.
What skills is David Farley Rpa Expert known for?
David Farley Rpa Expert has skills like Powerpoint, Cpa, Accounting, Enterprise Resource Planning, Microsoft Sql, Financial Modeling, Data Analysis, Forecasting, Certified Public Accountant, Microsoft Sql Server, Crystal Reports, Business Analysis.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial