Senior Database/Data Warehouse Developer and Architect
Resume:
Bryan Reynolds
Tyler, Tx. *****
*.********@********.***
Executive Summary
Expertise in database architecture design, stored procedures, ETL and Data Analysis
Over 10 years of experience in all phase of Software Development Life Cycle (SDLC) such as planning, analysis, design, development, testing and implementation of distributed Web based Client-Server and N-tier architecture in Finance, Banking, Accounting, Healthcare, and Business Intelligence product development.
Extensive experience in working with various relational databases such as MS SQL Server.
Experienced in working with iterative Agile Programming Methodologies, and non-iterative Waterfall methodologies.
Extensive knowledge on Object Oriented Programming (OOPS) Concepts including Inheritance, Abstraction, Encapsulation and Polymorphism.
Reporting skills using SQL Server Reporting Services (SSRS).
Data skills using SQL Server Integration Services (SSIS).
Experience in using Source Code Control Systems like Version control with Subversion (SVN) and Team Foundation Server (TFS) as code repositories, compare different files and maintain history during development.
Experience in leading a team, performing code reviews, and meeting deadlines.
Experience interviewing prospective employees
Expertise in writing Test Plans and Test cases and documenting the entire testing process.
Possesses outstanding ability to learn new skills and technologies, analytical and problem solving skills, resourcefulness, and initiative.
Technical Skills
LANGUAGES SQL, T-SQL, PL/SQL (Oracle), C++, C#, VB.net and ASP.net; BASIC, Visual Basic, Assembly, GUIScripting, Pascal, and Perl, Java, Jscript, general scripting
OPERATING SYSTEMS Windows: XP, 2000, NT 4.0 Workstation and Server, 98 (including SR2), 95 (including OSR2), 3.0, 3.1, 3.11; MSDOS 5.0 – 6.22, Linux
SOFTWARE FTK, SMART, Visio, Nemex Email Examiner, Backupexec, MS Office Pro, MS Office Suite, MS Outlook, Internet Explorer, Netscape, Word Perfect, Adobe PhotoShop, Lotus Notes
NETWORKS TCP/IP, IPX/SPX
SYSTEMS Servers and desktop workstations; IBM XTs and ATs, 80386-80486DX; Pentium MMX, Pro, II, and III
PERIPHERALS ISA, PCI, PCMCIA, SCSI, RJ-45/coax Ethernet cards, video cards, and sound cards; IDE, SATA, CD-RW, FAX/modems, UPS, tape drives, hard drives
Professional Experience
The Intersect Group May 2021-Present
Lead Data Warehouse Architect/Developer
Led three person team to develop data warehouse reporting environment
Elicited requirements for data warehouse
Architected data warehouse based on existing business rules and requirements for PowerBI reporting
Created data warehouse for reporting
Translated new sources into existing Data Warehouse
Built daily ETL using SSIS for Vendor-side storage and TSQL stored procedures for locally hosted data
Educated team on data process, best practice, and analysis
Managed Data Mirror
Boeing January 2019-January 2021
Database ETL Developer
Created complex, innovative Oracle/PLSQL scripts for IPDM and LDM ETL transforms
Improved and upgraded existing scripts for ETL
Crafted complex, innovative MSSQL/tSQL queries for data transfer
Collaborated with business and engineering stake-holders to insure data integrity and mapping
Reviewed code of other developers
Tested code for integrity and compliance
Facilitated active tests of data mappings
Created complex, multi-faceted ETL scripts for application migration effort
Led 5-person ETL & Triage team, performing code review & bug triage
Translated business into technical requirements
Experian September 2018 – January 2019
Database/DOS ETL developer
Facilitated transfer of sensitive customer data with Experian Divisions
Crafted complex, innovative MSSQL/tSQL queries for data transfer
Maintained DOS server scripts for large, sensitive data transfer
Improved server scripts, including error-checking, logging, and resume capabilities
Senior Care Centers December 2016 - September 2018
Database/Reporting developer
Migrated data across Vendor systems
Crafted complex, innovative reports on all aspects of the business
Worked with business to develop requirements for reports and applications
Managed Jr. Developer
Conducted phone screens and interviews for Jr. Developer
Maintained daily scheduled jobs
Provided relationship and problem solving interactions with vendors
Built ETL systems for automatic, secure intake and output of data to vendors
Assisted colleagues with basic HIPPA compliance
Wrote SQL queries and stored procedures for delivery of data to internal and external parties
Developed new functionality for various applications
Republic Group September 2013 - November 2016
Database Developer
Wrote SQL queries and stored procedures for delivery of data to internal and external parties
Developed new functionality for various applications
Managed vendor systems
Vetted and applied updates to vendor systems
Created interfaces between various systems and platforms in a multi-function environment
Built SSIS packages to move data between Mainframe, T-SQL, and other platforms
Designed SSRS reports from user requirements
Built SSRS reports from business requirements
Repaired SSRS reports/data sources after vendor changes and data outages
Managed complex update and upgrade projects with multiple developers involved
Argo Data, Richardson, TX October 2011-August 2013
Software Developer
Wrote SQL queries and stored procedures for delivery of data to banking platform
Developed new functionality for large-scale banking applications
Provided trouble-shooting and integration of fixes
Created and maintained documentation
Learn proprietary software language
Wrote test plans
Maintained and built functions which integrate modern languages and the proprietary language
Promoted to Programmer Analyst
Takes lead role on projects
Environment: MS-SQL Server 2005,Visual Studio.Net 2010, C#.Net 4.0, ADO.NET, Javascript,
HTML/DHTML, XML
KPMG, Dallas, TX October 2010-August 2011
Computer Forensics/Data Analytics
Analyze, using T-SQL, purchase card data for major retailer and create report detailing the use of card
Import, using SSIS, various sources of data into SQL for analysis
Build stored procedures and queries to analyze and display useful information organized from provided data
Use ETL practices to format, import, and verify data
Model data to represent card use
Compare card use to company guidelines
Import Manual Journal Entry information into SQL from various sources
Test Manual Journal Entry SQL information for completeness
Convert Manual Journal Entry SQL database information for processing
Report on findings based on SQL Data Analysis
Communicate results to business users
Environment: MS-SQL Server 2005/2008, SSRS, SSIS, Visual Studio. Net 2008, FTK, SMART/Linux
KPMG, Dallas, TX March 2010-September 2010
Software Developer/Maintenance Programmer
Maintain MSSQL/C# web software
Manage and tune MSSQL database
Provide troubleshooting and repair of MSSQL/C#.net applications
Develop and update internal MSSQL based C#.net web application software based on programming requirements
Provide Enhancements to existing software based on updated user requirements
Use ASP.net to create lists, dropdowns and other controls
Coordinate multi-city alpha-test of distributed web application
Edited Visual Studio generated HTML and XML code when needed
Model data to assist business owners in decision making
Environment: MS-SQL Server 2000/2005, SSRS, Visual Studio. Net 2008, C#, ASP.Net 3.5
Probity Advisors, Dallas, TX November 2007-April 2009
Software Developer/Maintenance Programmer
Manage MSSQL database of client and trade information
Elicit business requirements for new custom software and software updates
Provide day-to-day support for company’s custom software
Maintain custom MSSQL, VB.net driven web interface for client and trader interaction
Repair MSSQL /VB.net applications and web interface as errors were found
Decipher uncompleted projects and continued development
Create programming requirements from business needs
Develop and update internal software based on programming requirements
Use ASP.net to create collapsing tables views, lists, dropdowns, and other controls
Create automated SSIS packages to daily import of stock data into SQL
Evaluate SSRS for utility in the company environment, recommended against it for the given application
Edit Visual Studio generated HTML and XML code when needed
Create scripts using SSIS and ETL practices for daily data imports
Environment: MS-SQL Server 2005,Visual Studio .Net 2005, ASP.Net 2.0, VB.Net, Java Script
XO Communications, Dallas, TX December 2006-June 2007
Computer Forensics/Security Support
Provide day-to-day support for computer security operations and investigations
Perform forensic imaging and analysis with SMART, FTK, and dd
Write scripts to cull log data and provide regular reports
Receive, log, and store evidence
Retrieve data from failing hard drives
Write and develop preliminary procedures for various functions of IT Security department
Update and assist in maintaining investigation records
Design databases to track various security records
Develop requirements for database to track various security records
Environment: MS-SQL Server 2005,Visual Studio. Net 2005, ASP.Net 2.0, Web Services, .Net Framework Class Libraries, Java Script, FTK, SMART/Linux, PERL
G-C Partners, Dallas, TX November 2005-October 2006
Computer Forensic Analysis Support
Reconstituted systems and restored data from forensic images, ghost images, and tape backups
Rebuilt and analyzed Exchange server clusters
Rebuilt internal computers to perform forensic analysis before hard drive wipes
Programmed tools with Perl and AutoHotKey GUI scripting
Performed forensic imaging and analysis with SMART, FTK, and dd
Wrote and delivered reports on analysis findings
Completed Access Data boot camp and windows forensics training courses
Environment: VB 6.0, Windows 2000, PERL, GUI Script
Delivery Limited, Dallas, TX June 2004-December 2004
Computer/Network Support Specialist
Installed and configured Cisco PIX VPN firewall for home interface and work-from-home users
Maintained small business network and employee computers and software
Provided VPN end-user training
Environment: VB 6.0, Windows 2000
University of Texas Dallas, Richardson, TX August 2001-May 2005
Student, BS in Computer Science
Cooperated on multiple group projects
Managed group projects
Gave verbal presentations for various projects
Environment: VB 6.0, Windows 2000, C++
Halliburton, Houston, TX June 2001-July 2001
Windows 2000, Windows NT, SAP Rollout
Troubleshooting and break-fix for new software and hardware
Installed and configured Windows 2000 and Windows 95 desktops and laptops
Installed and configured various software, including Outlook XP and SAP
Provided end-user training
Environment: VB 6.0, Windows 2000
Exxon Mobil Downtown, Houston, TX October 1999-April 2001
Application Coordinator
Deployed desktops and laptops and performed desktop backups
Restored lost or damaged data, replaced lost or damaged hardware
Troubleshot network connectivity issues
Assisted with NT4.0 Workstation Rollout project
Maintained lists of application cross-references, issues, and requirements
Checked user information packets for application issues, submitted revisions to application database to maintenance, and approved user information packets for rollout
Performed security reviews and checks with end-users and provided end-user training
Environment: VB 6.0, Windows 2000
GHG Corporation-SRQA, NASA, Houston, TX October 1998
Technical Writer
Kept minutes for safety/reliability meetings, verified with engineers and supervisors
Produced formal material for review and posting to NASA intra-net
Chandler Supply, Alvin, TX September 1995-September 1999
Freelance Technical Support and Computer Assembly
Diagnosed and repaired complex network and stand-alone MS-DOS and Windows systems
Assisted businesses and individuals in assessing their hardware and software needs
Built computer systems to business and private individual specifications
Upgraded hardware and software for networked and stand-alone computers
Rockwell International, NASA, Houston TX June-August 1995
Summer Intern, Staff Support for training personal
Used a nested flow-chart program to help develop storyboards for new training computer programs
Packaged and sent storyboard information to remote sites for coding
Received, tested, and performed initial back up of Toshiba notebooks and provided further technical support
Handled connectivity issues to Windows for Workgroups network
Education
BS of Computer Science, University of Texas at Dallas, Richardson, TX
AS of Aerospace Technology, Alvin Community College, Alvin, TX
Contact this candidate