Experience:

Confidential

Business Systems Analyst

• Currently working with Corporate Trust to implement an in house payment accrual solution that will result in annual revenues in excess of .5M. Gathered requirements from all stakeholders, use cases, process flows, worked closely project manager and developer
• Performed analysis of physical mailing of customer notices and letters. Concluded annual savings in excess of 100,000 exists if execution of electronic notification process is implemented in conjunction with an internally developed solution
• Carried out analysis on customer facing application usage rates and correlation to number of accounts customer has on record
• Crafted a presentation around the analysis using PowerPoint and presented it to Application and Data Service's Vice President
• Company implemented a new branch teller solution that resulted in reporting gaps. Gap analysis was performed, data mapped old fields to new database fields using existing schemas, data dictionaries, and SQL Server Management Studio
• Discovered multiple issues with vendor databases during gap analysis and testing phase of project, including compliance related problems. Problems were then escalated through the project manager. Also ensured a resolution was documented, signed off, and provided prior to pilot
• Completed process flow, application diagram, and work flow diagrams in Visio for an image capture process as well as for our report manager servers which included server diagrams, IP Addresses, SQL Versions, and all the software running on servers
• Completed documentation of internal process for Internal Releases, Software Releases as well as Promotion from Dev to Test and Test to Prod environments for the new Branch Automation Solution
• All reports and dashboards are developed in a test environment and deployed onto a new 2008 R2 SQL Server using SSRS
• Have developed and continue to develop dashboard reporting on SSRS using SQL2008, Report Builder 3.0, SQL Server Management Studio, and Visual Management Studio. Continually monitor all usage and functionality of reports once deployed
• Self-taught ability to call data into an SSRS Report via a stored procedure located on a separate SQL Server, which creates and drops a temp table, and then inserts data into temp table via select queries and inserts
• Currently enrolled in University of Delaware's Certificate in Analytics: Optimizing Big Data
• I am most recently a graduate of the University of Delaware's Business Analyst Certificate program, a comprehensive business analysis course

Confidential

Business Analyst II

• Automated multiple excel reports using VBA, which included emailing report to stakeholders
• Created excel dashboard and detail report for Department Manager, which is linked to Access DB via an ODBC connection
• Engaged Judgmental Lending stakeholders and performed gap analysis to determine what existing reports would and would not be needed for dashboard reports to be developed
• Took ownership of a half dozen daily reports that access their data via SAS, Access, and multiple SQL editing tools
• Created desktop procedures for work-related functions to ensure workload can easily be cross trained to prevent possible delays in report distribution
• Met with senior management on monthly basis to ensure expectations were being met or exceeded

Confidential

Marketing Intelligence Analyst

• Continually conducted gap analysis with stakeholders including our CMO to develop reports, spreadsheets, and PowerPoint presentations through various Microsoft Office products that directly supported senior management decision making
• Created Monthly and Quarterly productivity report using Access 2007, Excel, and SharePoint
• Completed and submitted requirements to change existing duplication verification process within SAP that involved communicating with various stakeholders in IT, Marketing, Web Services, and Project Management
• Managed 1 contractor and 2 interns that assisted in automating several reports intended to measure the ROI and productivity of various marketing campaign tactics
• Identified and emphasize to all levels within organization key metrics on performance data being distributed to help ensure interpretation of the results across departments is consistent
• Quantified and communicated the performance of external email campaigns via Microsoft Office products
• Negotiated dozens of contracts with vendors both domestically and Internationally for emails, newsletters, and banner placements
• Provided CMO and Directors with weekly report, which included analysis on trending, performance, and any anomalies that appeared through research for analysis
• Consistently worked with large data sets

Confidential

Research Analyst

• Was working to develop skills to write extensive macros into SAS programs that dealt with Alerts to BCBS Physicians
• Leveraged existing SAS Programs to adjust for change in year, month, day, date of birth as well as change in the way data steps are being executed
• Validated recently uploaded data from flat file with existing data from previous batch file

Confidential

Sr. Reporting Analyst, Reporting and Analytics

• Performed ad hoc analysis using SAS, SQL, and Access
• With PC SAS, created report that measured run-off rate of existing loans month over month
• Assisted team members to meet project objectives, schedules, and operational SLAs
• Developed and analyzed tables, queries, and reports with Access, SQL, and SAS
• Using Access, created marketing campaign tracking and commission tracking reports
• Created multiple Access databases used to export and manipulate large data sets
• Utilized SQL and Access for data mining with the intent to consolidate data from redundant sources as well as eliminate multiple duplicate observations

Confidential

Sr. Business Analyst Contractor , Strategic Data Solutions

• Worked closely with Risk, Marketing, IT, Operations, and outside credit bureau vendors to construct and develop innovative online solutions for acquisition-related activities
• Acted as Project Manager for Lowermybills.com online point of sale product launch in June of 2008
• Conducted performance analysis of online and prescreen products
• Utilized UNIX based SAS with Proc SQL, Freq, Sum, and Order to create daily reports that measured approval, decline, and no hit rates per lines of business
• Performed quality assurance audits of the online and prescreen decision platforms and their criteria
• Developed strong internal relationships to build upon existing risk criteria and identify areas of opportunity
• Created monthly executive dashboards using PowerPoint and Excel to illustrate credit quality of customers and performance of various credit reporting platforms
• Analyzed billing invoices for potential cost save opportunities, saves exceeded 250,000

Confidential

Business Systems Analyst

• Acted as a liaison between client area and technical organization by planning, conducting, and directing the analysis of moderately complex-to-complex business problems solved with automated systems

• Utilized knowledge of SQL, PC SAS, and Excel to data mine large data sets and ultimately create user-friendly reports
• Ran monthly SAS program that measured delinquency, outstanding dollars and used basic weighted methodology to measure individual analysts performance
• Performed gap analysis for various departments to determine reporting needs via facilitating meetings with senior leadership team and business system experts. Also acted as subject matter expert for Credit Department
• Worked with business to analyze requirements and review specifications for any new/change to reporting needs
• Wrote multiple technical specifications and business use cases as well as functional specs
• Strengthened business partnerships by seeking out opportunities through effective and proactive communication
• Worked side by side with Crystal report developers plus QA'd all reports prior to submission to business leaders.
• Interacted with all levels of technical and business associates to meet reporting and analytical needs