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)• Create databases, schemas, tables, indexes, stored procedures, and views as necessary for new clients or special projects.

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.• Mentored other co-workers local and worldwide so they could successfully grow in their job. • Develop reporting packages with business objects/crystal reports and all the backend required.

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.