Software Developer Intern → I
Promoted to Software Developer I this year.
Not an exhaustive list. Items below were picked to reflect the shape of my work that year and don’t cover everything I did.
Support Frontline
-
Multiple months working in tandem in the support team (2 developers serving about 5 customer service representatives).
- Sending new versions of the software or the database schema, to all clients. (Done via a custom orchestrator software)
- Juggling multiple tasks at the same time, all the while providing a constant rate of delivery and stability.
- Upwards of 200 pharmacies supported during my tenure.
- Quick addition of every approved vaccine from AQPP, leading to an increased vaccination rate in pharmacies using our software (most competitors were slow and had pharmacists do manual entries of new compounds)
Support Tooling
-
Monitoring solution aimed at physical disks space through SQL Server stored_procedures to alert when disk space is low.
-
Secured
xp_cmdshellusage on more than 200 servers with feedback relay via Microsoft Teams.
-
Secured
- Multiple reusable and shared SQL script that could be used to fix/optimize/speed up/debug a pharmacy.
- Documenting and sharing of the ‘happy path’ upgrading process for all clients inside the custom ‘orchestrator’ software.
- Work with price grids and pill dispensing machines.
Pharmacy Conversions
-
Multiple contributions to the ‘converter’ project allowing McKesson to bring new clients while providing a seamless data transfer to our systems.
- In charge of the actual conversion process which is done during off-hours (the night). This was a high responsibility job since any errors in our process would mean the pharmacy could not operate the next day (for licensing reason they would tend to block their previous software on the conversion day).
- Providing support (often in the dead of night) to failing conversions, which would necessitate quick thinking under pressure to correct data alignment or worse resource issues while converting.
- Validating the conversions once done via SQL scripts before pharmacy open.