Snowflake Essentials

Tel: 07969 412292 Email: jim@jimohara.com A Microsoft certified Azure Data Engineer offering a consistent track record in eliciting, understanding and documenting complex business and technology requirements and building robust business-critical data solutions to drive change and improve productivity. Leverages over 15 years' commercial experience... using T-SQL and stored procedures to develop and deliver sustainable solutions; utilising multi-sector experience including financial services, telecommunications and technical services to develop clear insights for delivery across multiple domains; developing clearly scoped reports and communicating complicated technical information to diverse audiences including non-technical personnel; and consistently delivering SQL and Data Warehouse projects in line with demanding timelines. giffgaff required a solution to managing the growing number of SMS abusers using giffgaff SIM cards to send spam texts to thousands of people on a daily basis. Worked closely with the Head of Fraud Detection to identify SMS spammers; defined technical requirements; designed and developed system to identify SMS abusers; implemented new solution which became a major tool for fraud detection. Succeeded in developing a robust system using test driven development to identify SMS spammers which significantly reduced the number of SMS abuser using Giffgaff to harass and spam people with unwanted text messages. Visa Group required a solution to investigate problems with the Visa transaction processing system. Engaged as Developer to develop SQL server and report configuration for a transaction reporting tool. Gathered business requirements with senior managers; liaised with Business Analysts to develop user stories and reports; supported deployment into test, QA and production phases; ensured transaction reporting tool was fit for purpose; and ensured stringent internal requirements were met. Succeeded in developing transaction reporting tool to promptly identify issues with Visa transactions and ...Read More