Patrick Reynolds Email & Phone Number

• Engaged with team members in identifying and troubleshooting processes and or system related issues
• Worked with customers both internal and external to deliver accurate analysis and interpretation of data.
• Working with team members in developing and maintaining data warehouses and ETL processes.
• Worked with large datasets in various formats to create and perform data integrity/QA/reconciliation for basic accounting systems.
• Prepare complex deliverables in Excel spreadsheets in a consistent and reusable format.
• Meeting routine deadlines and work schedules for a timely and accurate completion of special projects. (Tangier, QGenda, Migration from 2005 to 2008+ SSIS packages)

Dallas

• Troubleshot statistical/data anomalies and reconciled data discrepancies. Logged issues into JIRA.
• Created ad-hoc queries and reports, analyze data in Excel using Pivot table and formulas.
• Created and executed data load/ETL packages from large datasets and perform data analysis.
• Performed full-scope analytics to include data integrity, QA/QC, and trending.
• Prepare and validate monthly client report packages - Collect, analyze, interpret, and summarize data in preparation for generation of reports based on our client’s needs.
• Updated data mart/web objects by utilizing/creating stored procedures, SQL, and basic GUI interface.

Garland

• Helped with the implementation, configuration, testing and training of a new LMS system at Raytheon.
• Created, and or modified over 150 reports for the new LMS in time for “Go Live”.
• Spoke with business users to develop requirements for new reports that would meet the needs they required.
• Tracked bug issues, figured out if it could be duplicated, and then see how it needed to be fixed (internal, or external).
• Modified, or fixed any issues that were found. Added anything to the reports that was found to be needed after development from the end users.

Plano

• Defined functional requirements for the project, proposed development solutions, and validated that these solutions meet the needs of the business.
• Assisted business users with ad-hoc reporting tasks and troubleshooting report system performance and functionality problems.
• Extracted data from multiple relational databases and other, non-relational, sources to create and distribute periodic executive/summary reports.