Accomplishments: - Scrubbed reporting systems to remove redundancy and streamline reports.- Created business requirements documents and workflows outlining improvements andprocess changes to the company-wide error tracking system.Responsibilities:- Using SQL to create queries for SSRS reports and views for Tableau use.- Designing and managing SSRS reports.- Designing and managing Tableau dashboards for executive and sales team consumption.

Working as part of a three-person team, I revolutionized the auditing and tracking of federally required Software Development Lifecycle (SDLC) documentation within the firm’s IT department. I hand-designed and coded the firm’s SDLC tracking database using SQL, Microsoft Access and C#. I created push-button reports using C# and Excel and prepared the data from these reports for third party consumption and compliance tracking. The percentage of the firm’s SDLC compliant projects raised from less than 10% to 85% during my time as an auditor.Additionally, I was responsible for creating and maintaining executive dashboards concerning SDLC compliance and project spend analysis. These dashboards took shape on several platforms, including Tableau, Azure, and PowerPoint presentations. My final project was dissecting previously created reports from third parties into technical reporting requirements and migrating SDLC compliance reports to ServiceNow.  I also coded and maintained the IT department’s SDLC information site.

Projects managed included an enterprise-wide client data scrub, the creation of a client data editor for the firm’s Data Management team, and the implementation of a new enterprise financial reporting and accounting system. I worked with both in-house developers and overseas contractors, in teams ranging in size from 8 to 35 people.