Shannon Brewer
Charlotte, NC-http://careers.stackoverflow.com/shannongallagherbrewer
http://www.linkedin.com/in/shannongallagherbrewer
SUMMARY
Experienced Full Stack Developer with superior programming and data analysis skills. Able to successfully migrate large volumes of data from several disparate systems. Sought out by technology teams for complex front end and back end projects due to ability to develop positive relationships with key stakeholders.
TECHNOLOGY
PythonPerlSQLSQL Server
TeradataDSLsVCSTableau
SASPower Pivot.NetVBA
UnixAccessExcelHP Quality Center
PROFESSIONAL EXPERIENCE
Bank of AmericaAugust 2017 - present
Quality Assurance Consultant IV, Data Testing Team - Contractor
Recruited back to same team due to data integrity skills
Partners with key stakeholders to define and review business requirements
Uses Teradata SQL to conduct data transformation of large disparate systems
Determines data collection of business requirements, source data, and logic
Data transformation of current logic into testable SQL by translating a variety of different languages into source to target SQL for testing
Reviews line by line target data to ensure data integrity, identifies data integrity issues, partners with line of business to resolve
Designs and runs test scripts according to business requirements
Prepares observation reports in HP Quality Center for key stakeholder review
Uses Teradata SQL to create reports for external auditing firm (PWC) Price Waterhouse Coopers
Reporting test results, team results, and testing cycle results to key stakeholders
Accomplishment: Improved reporting efficiency by building Access database to load 8 data sources into SharePoint.
Tools:
SQL, Teradata, Excel, HP Quality Center, Perforce, SharePoint, Jira, Perl, Webex
Wells FargoApril 2016 - July 2017
IT Business Data Controls Testing/System Engineer Capital Markets - Contractor
Member of Agile development team for an internal reconciliation tool named DART, a complex reconciliation engine that supports 11 lines of business within Wells Fargo
Partnered with key stakeholders to review business requirements of DART, a large trade reconciliation engine supporting 11 lines of business
Used SQL to extract data from 11 lines of business according to business requirements
Mapped source and target data according to business requirements
Performed data transformation in preparation for matching and custom reporting
Used SQL to conduct data reconciliation of source and target data to ensure data integrity
Created and performed UAT test scripts through production, handed off to support team
Attended Scrum meetings to review new findings
Tools:
SQL, MSSQL, SQL Server, DART, Text, Excel, Jira
Bank of America July 2015 - February 2016
IT Business Data Controls Testing Analyst/ IT Program Manager III - Contractor
Key member of Data Controls Testing team due to consistent understanding and verifying of data integrity between data systems
Defined, collected, analyzed, and reported data from data controls testing
Migrated data testing results to an SQL database to be integrated with other data sources for reporting
Created and maintained a custom Microsoft Access database to enter and evaluated data controls testing results
Programmed Quality Center for a more custom experience for testers and reporting
Led control data testing and business audit review
Accomplishment: Improved efficiency and consistency through design and implementation of reportable data control testing results.
Tools:
SQL, Tableau, SAS, Power Pivot, Excel, HP Quality Center, SharePoint, Jira, Webex
Moore & Van Allen, PLLCJanuary 2008 - June 2015
Full stack developer, database administrator, data analyst and data quality management
Identified and presented technology solutions to automate paper processes
Implemented software technology solutions through entire software development lifecycle (SDLC)
Wrote business and technical requirements for technology solutions
Used Python, QT and SQL Server to develop front end and back end applications including but not limited to scraping, loading, reviewing and reporting
Recommended and implemented Database Design, Administration, Storage and Sunset
Gathered data and accounting reports in various formats including but not limited to: database, web pages, text, excel, word, PDF, ADO, proprietary software, and receipts
Conducted data transformation using a variety of financial, tax, and legal calculations with a combination of programming and SQL to analyze, store, and report large financial data
Created custom confidential and sensitive reports in a variety of forms including; Python QT programs, internal web pages, database forms, excel, text, and IRS submissions.
Used Perl for data collection and reporting
Accomplishment: Automated firm’s paper processing to improve business process management and reporting
Tools:
Python, Perl, VBA, and Iron Python, .Net, QT, MSSQL, SQL, ODBC, ADO, XML, HTML, CSS, Access, Word, Excel
EDUCATION
University of North Carolina at Charlotte
Bachelor of Arts (BA), Elementary Education and Teaching, 2001 – 2003
Central Piedmont Community College, 1999 - 2001
Activities and Societies: Societies for the Deaf and Disabled
Project+ Certification
