• Manage data-driven SSRS report subscriptions sent out to clients through both email and file share• Build SSIS packages to create and distribute data files to clients based on custom formatting and layout requests• Troubleshoot discrepancies between reports by identifying and correcting errors within the source queries or by recognizing and articulately explaining the differences in business logic between the sources• Respond promptly to a variety of requests through ServiceDesk by communicating with the requester to identify problems, implementing a sustainable solution, and relaying all relevant technical information in layman’s terms

• Managed organization of the AML database by developing and maintaining a data vault in SQL Server which consisted of slowly changing dimension tables and was updated by executing stored procedures and ETLs• Automated formerly manual processes to save analysts hours of time by building SSRS reports and automatically populating calculated and conditional columns by implementing business rules in SQL queries• Proposed new methods to enhance risk analysis based on statistical knowledge and application• Promoted security and departmental cohesiveness by constructing a web-based user interface that housesd user-interactive reports for each department branch in addition to general department information

• Facilitated frequent group meetings and organized campaign events• Performed data entry using the database QuickBase• Improved leadership, recruitment, planning, and organization skills