David Farley Rpa Expert Email & Phone Number

Texas, United States

Frisco, Tx

For 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.

Dallas/Fort Worth Area

Provide 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.

Dallas/Fort Worth Area

Provide 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.

Dallas/Fort Worth Area

Provided 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.

Provide 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.

Provided 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.

Provided 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.