Sarah Ellis Email & Phone Number

Cornelia, GA, US

Alpharetta, Georgia, United States

Alpharetta, GA

• Create and monitor SSIS Packages, SSMS Jobs, and T-SQL Merge ETLs on SQL Server, including 28 separate integrations with outside data sources
• Design and maintain Staging and Data Warehouse databases
• Write complex Stored Procedures for updating the Data Warehouse and creating reports
• Design, standardize, deploy and maintain SSRS reports
• Interface with all levels of the company to troubleshoot issues, discover needs, and respond to those needs in a highly efficient and service-oriented manner
• Test data accuracy with extremely detail oriented skepticism

Kennesaw, GA

• Create Reports using Tableau and SSRS
• Clean and standardize data

Atlanta, GA

• Lead developer on Tableau BI development initiative
• Collaborate with users to develop actionable, useful reports
• Write complex T-SQL stored procedures in SQL Server Management Studio 2012 to support hundreds of SSRS reports
• Troubleshoot existing stored procedures, update with latest best practices, and optimize for speed and accuracy
• Create effective and powerful reports and dashboards utilizing best practice visualization techniques
• Manage SQL RD report and delivery automation

Atlanta, GA

• Gather and document report requirements from customer
• Write Stored Procedures for reporting
• Assist Data Developers in integrating new data into existing data model
• Produce reports using SSRS
• Design and implement a new Project Management System using MS Access
• Improve the look and feel of reports using company colors and designed new gauges

Greater Atlanta Area

• 1. Golden Key National Honours Society
• Legacy to MS Dynamics CRM conversion
• Established user needs, improved processes and developed better tools in CRM and SSRS
• Created custom entities in CRM
• Developed audit queries to insure data integrity
• Created very complex Accounting and Operations Reports in SSRS, utilizing T-SQL2. CARE

Greater Atlanta Area

• Fiserv
• Developed multiple Access databases using VBA to architect user friendly GUIs which updated, reported and provided analysis for various projects.
• Extracted data from multiple sources, clean and convert reference documents, diagrams and data into Reference Articles for new Knowledge Management module of an ITIL System
• Uploaded > 3000 articles into Remedy 7.6 KM using RKM Converter

Alpharetta, GA

• Programming, Ad Hoc Queries, Data Mining, Analysis, Designing, Automating & Publishing Custom Reports
• SAP Administrator Support
• Database and Report Documentation
• Data Accuracy and Cleanliness, Uploads, Downloads
• Train others on use of Access, Excel, SAP Query Generator and other software as needed
• Spreadsheet Consolidation including Manual Inventory, Budgets, Customer Data Implementation

• Programming, Ad Hoc Queries, Data Mining, Analysis, Designing, Automating & Publishing Reports
• Handled many projects at once, requests from 3 departments, including >100 people, plus the Sr. Management.
• Month End Reporting on Sales, Forecasting, Customer and Item Analysis
• Data Accuracy and Cleanliness
• Responsible for setting up pricing promotions, contract pricing, basket discounting and fee adjustments, effecting 700K lines daily and $350M/yr in sales. - Reduced acquisition related discounting by 74% and pricing.