* Identified System of Record * Worked in an agile DW SCRUM development process. * Composed and wrote user stories that were passed onto the ETL team. * Performed data validation using SQL extracts. * Led and documented business requirements for JAD sessions. Insured business requirements were approved. * Attended daily SCRUM status sessions. collected and consolidated monthly billing data for Long Distance and AT&T VPN financial reports. * Implemented business process improvements which reduced a 10 to 12 day manual process to approximately two days. * Using Microsoft Word Excel and Visio developed step by step run book for each system. * Extracted data from several billing systems (SAART eCRM) using SQL Queries as input to monthly reports. * Imported data from several sources into access database to create final monthly data source for reporting. * Created and documented data integration processes from disparate sets of data. * Participated monthly data mining data analysis and report validation for AT&T commercial accounts for signature top 450 business clients and premier clients (next 22000). * Performed Ad-Hoc and data validation of very large volumes of data using SQL Excel and Microsoft Access. * Created report mock-ups using Visio and databases to consolidate monthly data using Microsoft Access. * Executed User Acceptance Test to confirm report requirements were met. * Created Visio diagrams to show overall systems data flow.

Highlights:

• Integrate
• Application Development
• Business Analysis
• Business Analyst
• Consulting
• Data Modeler
• KPMG
• Project Management
• Project Manager
• Business Requirements