Sql Server Business Intelligence
Resume:
Bryan Reynolds
Gladewater, TX 75647
*.********@********.***
Executive Summary
Expertise in database architecture design, stored procedures, ETL and Data Analysis
Over 20 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, PL SQL, and others.
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 small team to develop data warehouse reporting environment with MSSQL and Azure building data sets for PowerBI
Elicited requirements for data warehouse designed to provide metrics and KPIs for representatives, contractors, and account managers and company performance
Architected Snowflake data warehouse based on elicited business rules and requirements with attention to data grain and efficient processing for PowerBI reporting
Created data warehouse for reporting of KPI activity for reps and business health financial data for executives and accountants
Translated new sources into existing Data Warehouse, including new ERP systems, HR data sources, and GL data
Built and Managed PowerBI gateways to TSQL database in PowerBI Portal
Built daily ETL using SSIS for Vendor-side storage and TSQL stored procedures for locally hosted data
Maintained and aided troubleshooting on PowerBI Gateways
Educated team on data process, best practice, and analysis
Managed Data Mirror including backups, updates, and insuring uptime
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
Education
BS of Computer Science, University of Texas at Dallas, Richardson, TX
AS of Aerospace Technology, Alvin Community College, Alvin, TX
Contact this candidate