Patrick A. Burrows
**** ******** **** • Schertz, Texas 78154 • United States
Home: 210-***-**** • Cell: 210-***-**** • Email: *********@***.***
•23 years of diverse Report processing and Service Delivery Management
•20 years of direct data mining and intuitive report creation (relational databases and spreadsheets)
•Mastery of MS Excel (Pivot table, vlookup, if functions, nesting formulas, and writing VBA code in the backend)
•Analytics champion with a proven ability to turn complex data into a meaningful statistical story
•Understanding of executive level expectation and focal points
•Advance experience in MS Access (Tables, forms, queries and SQL code)
•Consistently delivers high quality metrics with a high accuracy rate within SLA
•Extensive knowledge in business reporting and KPI’s
•Expertise in headcount, rosters, attrition, inventory control, audits and related databases
•Complete knowledge of business operations, including human resources, procurement, project management and office processing
•Strong knowledge of business sales, merchandising, manufacturing, wholesale and retail procedures
•Works well in a team setting or autonomously
•Remarkable presentation and technical writing skills
•Other Programs used: Qlikview, SAP ECC 6.0, Service Now, Success Factors, JD Edwards, Cognos, ATAs, MS SQL Server 2012-2014, Peoplesoft, myScheduling, Counterpoint, Quickbooks/POS, Micros
PROFESSIONAL EXPERIENCE
Accenture 2013-Present
Senior Human Resource Reporting Analyst – Workflow Coordinator (Nov 2015 – present)
•Subject Matter Expert on all areas of reporting including data mapping and lean processing
•Prepare complex reports for All of HR functions and support staff, including recruitment, talent fulfillment and sales
•Mine and scrub data for accuracy, converting and formatting for a more readable version
•Generate adhoc reports at request
•Directly responsible for the flow of 300+ standard reports and 20-30 adhocs, ensuring each one meets SLA
•Compile data from 20 different systems and integrate them into weekly, monthly and quarterly reports
•Develop new automated tools to streamline processes
•Draft and audit detailed work step instructions for every standard report
•Encrypting data where necessary to protect sensitive data
•Member of the hiring committee for new reporting analysts
Key Accomplishments:
Created the Daily Deliverables tool – a shared excel file that 12 employees use to track individual deliverables and show progression to completion. It is automated to assign tasks that are due in a given day
Procurement Analyst (Oct 2013 – Nov 2015)
•Procured parts and supplies for client-companies and schedule delivery through supply chain
•Submitted quotes for price, lead time and specifications
•Exported, cleaned, sorted and filtered data from SAP software for reports and part tracking
•Provided detailed price justification for audit review
•Communicated with vendors to meet schedule deadlines for customer projects
•Researched and initiated alternative methods to replace urgent backorder parts and minimize surplus
•Assisted team members with efficient processing
Adhoc reporting and analyzing as requested by client
Key Accomplishments:
Co-Developed the “Buyers Database” in MS Access used by 70+ buyers on the project
HEB 2012-2013
Produce (Manager in Training)
•Received daily shipments and prepared them for replenishment
•Analyzed stock for levels below par
•Submitted orders through system
•Accounted for damaged or perished goods while maintaining low shrink
•Supervised food safety operations
•Assisted leading the team through all daily activities
Flavors Bake Shoppe 2009-2012
Business Development Manager/Co-proprietor
•Developed business for contract operations
•Calculated cost for all recipes, via custom created spreadsheets
•Negotiated with vendors for ingredient pricing
•Supervised wholesale and retail operations
Key Accomplishments:
Increased customer base by 150% through marketing campaign
Starbucks - Nassau, Bahamas 2010-2012
General Manager
•Managed all operations at Harbour Bay store
•Submitted regular reports and audits to corporate office to meet deliverable deadlines
•Reviewed KPI’s to adjust strategy as need to accommodate business
•Monitored merchandise sales and inventory control, via spreadsheets
Coordinated inventory orders through distribution center
Key Accomplishments:
Achieved record sales for store 1st quarter 2011 (10% increase over previous year)
Implemented new data tracking reports adopted by region.
Auto Care Products, Nassau, Bahamas 2006-2010
Store Manager/Warehouse Manager
•Managed all operations of business
•Maintained inventory control and systems (Excel, Access, Counterpoint, Quickbooks POS)
•Motivated and trained staff to provide quality service
Yakima Valley Community College 2005-2006
Financial Aid Data Manager
•Transmitted student records from Federal database
•Isolated and fixed calculation errors from multiple databases
•Converted raw data to a query table using MS Access
•Analyzed reports to determine student eligibility
•Monitored and allocated State Need Grant fund among eligible students (budget $3 million)
•Prepared reports and spreadsheets for deadlines, daily, weekly, quarterly and annually
Key Accomplishments:
Restructured application seminars. Introducing a Powerpoint presentation
Streamlined award eligibility determination by implementing custom Excel template
Heritage University 2002-2005
Associate Director of Financial Aid Outreach
•Trained new financial aid and recruitment staff on department processes (both on and off campus)
•Maintained efficiency of procedures by evaluating databases for simplification
•Managed Financial Aid Customer Service Desk
•Managed and award all Washington State Need Grant funds (budget $1.5 million grant)
Awarded and process all Institutional Scholarship
Key Accomplishments:
Developed new Outreach program to assist off-site administration financial aid concerns
Implemented new award notification system adding more efficiency for staff and customers
EDUCATION
2005-2006 Washington State University, Pullman, WA
1999-2001 Yakima Valley Community College, Yakima, WA