Rocky Brazier Email & Phone Number

Calmount Park, Ballymount, Dublin 12, Ie

City Of Tshwane, Gauteng, Za

• Team lead for pharmacy procurement software (3 Developers – 2 Support staff – 4 Data capturers) o ASP.net reporting/admin portal for wholesalers or pharmacy groups to manage pharmacy ordering systems ○ o National pharmacy stock file which linked and combined 42 wholesaler product files into a single managed stock file. +- 95k products made up of 472k wholesale products.o Online electronic ordering system linked to 42 wholesalers (written in react / js / c# / SQL)o Converted a PostgreSQL and java ordering server backend to SQL server / .net ○ o Pharmacy CRM system that gave pharmacies the ability to identify and communicate with their patients via SMS.o Created and maintained hosted QlikView models for over 200 pharmacies as well as pharmacy groups.o Automated processing of wholesaler and pharmacy price updates using SQL and SSIS• Drive and monitor business objectives• Project management• Database design and development using Microsoft SQL Server / SSIS / SSRS • QlikView scripting and development• QlikView server setup and maintenance o Multiple solutions for Retail pharmacy groups, wholesalers and manufacturers• Ad HOC SQL reporting and data analysis using SQL, Excel, Qlikview and SSRSo Internal and external stakeholders• Developed and maintained complex ETL processes using VB.net and SSIS• External Stakeholder management (Retail Pharmacies / Medical Manufacturers / Medical Wholesalers• Basic PowerBI models (basic power query)

• QlikView scripting and development• QlikView server setup and maintenance • Drive and monitor business objectives• Project management• Data Warehouse Development and Maintenance (SQL Server)• SMS communication service management• Developed and maintained complex ETL processes using VB.net and SSIS• Ad HOC SQL reporting and data analysis using SQL, Excel, Qlikview and SSRS• Create and maintain data-driven subscriptions in SQL Server Reporting Services (SSRS)• Stakeholder management (Retail Pharmacies / Medical Manufacturers / Medical Wholesalers)• Develop and maintain an internal information system• Manufacturer Rep training on data and reporting tool• Designed, developed and implemented:o SMS Server (SQL/API) which pharmacies could use to communicate with their patients, and which automatically sent out thank you messages and repeat reminders.o Built an internal information management system for the data

• Responsible for all hardware• User Support• General IT administration• Run month-ends for two stores

• Managed a team of 5 technicians and 4 call centre agents that was responsible for 155 pharmacies • Setup and Maintained SuSe 8 / Red hat 5 Linux• Configuring of Uniterms (Dumb terminal / Serial based thin client)• General hardware support and Software support for in house pharmacy software• Customer support and account management• Configure and Support WAN• Cat5 network cabling• Configuring new pharmacies and training staff (converting patient and sales information)• Manage outstanding technical call lists• Training of Technicians and Call Centre operators• Sales

• Ad Hoc pastel reporting - MS Access• Build and configure PC's• Hardware support• Network cabling and setup• Customer support and account management• Configure and Support WAN• Hardware sales

Certificate, Uct Business Analytics

Bachelor Of Commerce - Bcom, Business Management

Mcts Sql 2008, Information Technology

Qlikview Developer Course, Information Technology

Qlikview Professional, Information Technology

Reporting Services, Information Technology