Tammy Locklear Email and Phone Number

• Using Transact SQL to profile data in tables and provide updated code to process new transactions. Created error handling code in new process and monitored it.• Responsible for loading, monitoring and maintaining data flow in new tables and related stored procedures. This involved daily checks for errors and troubleshooting any found.• Participated in daily and weekly Scrum meetings to ensure projects were delivered on time and stayed on track.

• Subject Matter Expert (SME) on SQL Server platform tracking sales, spends, and balances for over $1 Billion portfolio on Prepaid Gift Cards in a PCI (Payment Card Industry compliance) environment. Created roll forward process to balance credits and debits to actual and calculated balance for 300+ million cards, daily. Provided all platform reporting to company CFO.• Worked in extremely complex data warehouse environment involving multiple SQL servers, linked servers, databases and platforms. ERDs (Entity Relationship Diagrams) were not provided for these disparate servers requiring analysts to profile the data to develop an understanding of it.• Coded and managed the creation of billing reports for multi-million dollar GPR (General Purpose Reloadable) and Pre-Paid Gift Card portfolio. Created process to export files via BCP (Bulk Copy Paste) and transfer them from non-PCI to PCI environment. Loaded and processed them, decrypted card numbers and created final file to send to partner. Considered the SME on all aspects of this reporting.• Lead a team of 4 developers, including performance evaluations and coaching, assisting with understanding of assignments, assigning tasks and checking work output.• Created and ran coding to pull information for Compliance and Licensing requests for 50 state agencies to support banking license. Considered the SME on all aspects of this reporting.• Managed all aspects of reporting including building T-SQL Stored Procedures, views, and tables (temporary and permanent), indexes, transferring files, creating and scheduling jobs, troubleshooting data integrity issues, calling and scheduling jobs, importing and exporting data, and setting up flags to confirm data readiness in an Agile environment.• Used TFS to interact with SSRS server to copy and build new reporting, link to Shared Data Sources and Shared Datasets

• Responsible to provide Sales, Spend and Balance information to the Fraud department on as requested in affidavits from law enforcement. Looked at information from an MCC (Merchant Category Code) perspective to find trends to look for fraudulent and/or churning activities. Considered the SME on all aspects of this reporting.• Managed all aspects of reporting including building T-SQL Stored Procedures, views, and tables (temporary and permanent), indexes, transferring files, creating and scheduling jobs, troubleshooting data integrity issues, calling and scheduling jobs, importing and exporting data, and setting up flags to confirm data readiness.• Recognized as go-to person by all levels of management when urgent information and quick turnaround is needed.• Praised by all levels of management for excellent communications skills and ability to interface effectively with non-technical members of the business unit.

• Responsible for the creation and execution of daily, weekly, monthly and ad hoc reports including building stored procedures, tables, queries, views and importing and exporting data (ETL) to support report creation, generation and validation in multiple credit card portfolios valued at over $1B. • Converted over 200 credit card portfolios valued at $360M from credit card processors such as Certegy, TSYS, and EDS to FDR (First Data Resources) including ETL, data validation and verification, and transfer of data and balances using monetary and non-monetary transactions.• Managed all aspects of multi-functional senior management daily report including building and troubleshooting stored procedures, creating an access database to enter and store customer service information and create additional, independent reporting, making enhancements per end user requests, providing full year data for creating budget plan, building training documentation for backup and addressing and correcting data anomalies. The reporting pulls information from 10 unrelated information sources into a one page summary of daily, month to date, year to date and year over year data.• Analyzed monetary transaction file to create highly requested month end calculations for purchases, balance transfers, cash, overdraft protection and other monetary classifications and integrated new calculations into all aspects of DSS (Decision Support Services) reporting. • Selected by management to lead cross-divisional team to address deficiencies in Employee Satisfaction Survey resulting in an action plan presented to and acted upon by senior management. • Recognized as go-to person by senior management when urgent information and quick turnaround is needed.• Praised by all levels of management for excellent communications skills and ability to interface effectively with non-technical members of the business unit.• Consistently exceeded expectations ratings in performance evaluations.