You have data that needs to be analysed and/or cleaned and/or transferred. You need a data analyst, somebody who lives, breathes and revels in raw data, the messier the better. I'm that data analyst. A master datasmith, someone who can model, automate and animate any data resource. With over 30 years experience hewing and hauling data across BI, CRM, ERP systems and of course Excel. My Datasmithing "Toolbox" SQLite, because a SQL powered database engine is essential for fast and accurate data crunching. Combined with .. Python, a modern data friendly scripting language to go where VBA fears to tread. All packaged up in my own open source project... xLite, I built the xLite code-base to combine the above three best in class products in a single integrated tool. My Datasmithing "Heavy Plant" Amazon EC2, pay-as-you-go Linux and Windows 2K3 Amazon S3, for secure data transfer and storage. Talend ETL, an open source ETL tool. | What I specialise in: Business Intelligence initiatives, especially those centred around Sales & Marketing, CRM, budgeting & financial control. Business re-orgs, mergers & acquisitions, need help remodeling making sense of and consolidating merged datasets. CRM sales targeting and campaign planning. Master Data (Customer, Product etc.) & Data Quality initiatives. Data Conversions. be that systems commissioning, de-commissioning or integration. Excel VBA consultancy. Excel report automation. Excel based barely-repeatable process automation. ETL programming; VBA,Python,Oracle PL/SQL or Talend ETL. SAP to Excel or other desktop environments. SQLite virtual table and user defined functions development. Datasmithing mentor, want to take more control of your data assets, want to use tools such as xLite, Palo, Amazon AWS? I'll be your guide, a datasmith's datasmith |
