Marcus Newsome

• Create custom T-SQL scripts to make client data compatible with new database • Help clients write and troubleshoot their own T-SQL scripts • Assist in creating and correcting standard T-SQL scripts used in client conversions • Completed 4 full data conversions for clients and assisted 1 client with their data conversion • Maintain custom and standard scripts using version control tool, Tortoise Hg (Mercurial) • Participate in daily Scrum meetings and keep track of project tasks via SharePoint

• Created SQL-based reports out of Cognos, a database reporting tool • Maintained reports using case statements, joins, unions, and Boolean logic • Kept track of changes made to Cognos reports using MotioCI versioning • Verified data accuracy between application and reports • Shadowed in basic SSMS tasks, which included creation of T-SQL scripts • Participated in Scrum meetings and kept track of tasks via JIRA ticketing system

• Managed SIS gradebooks and systems permissions for 10 schools • Carried out import/export of datasets sent to outside organizations • Used MS Excel/Google sheets VLOOKUPs and pivot tables for data validation • Utilized Cognos to create SQL-based custom reports with prompt screens • Audited district attendance reports, transcripts, and student demographics • Maintained track of requests via Zendesk ticketing system