Sarah Ellis

Sarah Ellis Email and Phone Number

Business Intelligence Development Team Lead @ Safe Systems
alpharetta, georgia, united states

Sarah Ellis Current Company

safesystems.com

Safe Systems

Business Intelligence Development Team Lead
alpharetta, georgia, united states
Website:
safesystems.com
Employees:
136
Industry:
Information Technology And Services
A perceptive, detail-oriented Senior Business Intelligence Developer with 20 years of experience, solid work ethic, exceptional problem solving skills, a passion for integrity and strong commitment to excellence. * Effectively Interpret Reporting Needs of Any Client * Transform Data into Useful, Actionable, Information * Strong Communication and Listening Skills * Comfortable Working with All Levels of Management * Quickly Digest Unfamiliar Systems to Locate and Extract Meaningful, Relevant Data * Exceptional Response and Turnaround Times with a “Can Do" Attitude

Sarah Ellis Work Experience

  • safesystems.com
    Business Intelligence Development Team Lead
    Safe Systems Sep 20 - Present · 4 yrs 3 mos
    Alpharetta, Georgia, United States
  • safesystems.com
    Sql Reporting Services Developer
    Rsui Group, Inc. Oct 12 - May 15 · 2 yrs 7 mos
    Atlanta, Georgia, United States
    * 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 * Managed successful migration from SQL 2008 R2 and Visual Studio 2008 to 2012 * Maintain Reporting Portal Database for proprietary front end reporting application * Maintained “Exceeds Expectations” on every review Show less
  • safesystems.com
    Data Analyst
    Larson-Juhl May 95 - Mar 03 · 7 yrs 10 mos
    Norcross, Georgia, United States
    * 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 errors by 24%. * Streamlined & automated price list updates, shaving 3 months off the process, increasing accuracy to <1% error. * Provided training, technical support and automation on internal systems. * Vice President of Marketing’s mandate: “If it takes longer than 20 minutes, take it to Sarah to automate.” * Created complete architecture for advanced pricing module of JD Edwards * Integrated four acquisition companies into company pricing system * Pricing Project Leader on major AS400 ERP upgrade
  • safesystems.com
    Data Analyst
    Industriaplex May 07 - Oct 09 · 2 yrs 5 mos
    United States
    * 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 * Large Data Projects including Conversion, Analysis of Retail Chain Buying Habits * As the first and only programmer/data analyst on staff, I took business with zero accurate reports or business visibility and built the information infrastructure required to run a successful Inc. 500 company. * Explored & Digested structure of SAP database without any data mapping or guide * Designed FoxPro based data warehouse, integrating multiple data sources and types * Led Team to develop and implement Standard Cost revealing our actual Gross Profit for the first time * Created and automated over 50 scorecards, reports and dashboards in Sales, Operations, Accounting & Finance
  • safesystems.com
    Senior Business Intelligence Developer
    Safe Systems Jun 16 - Sep 20 · 4 yrs 3 mos
    Alpharetta, Georgia, United States
    * 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 * Work with my team to brainstorm and collectively determine best practices and standardization Show less
  • safesystems.com
    Business Intelligence Consultant, Medical Group Informatics
    Kaiser Permanente Nov 11 - Jun 12 · 7 mos
    Oakland, California, United States
    * 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 * Produced the report that was given the first ever applause from the doctors
  • safesystems.com
    Contract Developer And Data Analyst
    Technisource Jul 10 - Jan 11 · 6 mos
    Fort Lauderdale, Florida, United States
    * 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
  • safesystems.com
    Contract Developer And Data Analyst
    Robert Half Oct 09 - Nov 11 · 2 yrs 1 mo
    Menlo Park, California, United States
    * 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-SQL * CARE * Rapid rescue of a database project that was behind schedule and in trouble * RR Donnelley Project Center * Developed custom interactive Access Databases to house national inventory of Chick-fil-A Menu Boards and provide senior management with a Reporting Database using a SQL Server backend.
  • safesystems.com
    Senior Data Analyst
    Marketplace Insight Jun 15 - May 16 · 11 mos
    Suwanee, Georgia, United States
    * Create Reports using Tableau and SSRS * Clean and standardize data

Sarah Ellis Education

Frequently Asked Questions about Sarah Ellis

What company does Sarah Ellis work for?

Sarah Ellis works for Safe Systems

What is Sarah Ellis's role in his workplace?

Sarah Ellis's role in his workplace is Business Intelligence Development Team Lead.

Which industry does Sarah Ellis work in currently?

Sarah Ellis works in the industry Information Technology And Services.

What is Sarah Ellis's email address?

Sarah Ellis's email address is richsarah@bellsouth.net

What is Sarah Ellis's direct phone number?

Sarah Ellis's direct phone number is +17708861237

What schools did Sarah Ellis attend?

Sarah Ellis attended Georgia State University Perimeter College.

What are some of Sarah Ellis's interests?

Sarah Ellis has interests in Poverty Alleviation, Poverty Alleviation. and Environment.

Who are Sarah Ellis's colleagues?

Sarah Ellis's colleagues are Kiel Motsinger, Kiel Motsinger, Matthew Sharpton, Matthew Sharpton, William Mcwilliams, William Mcwilliams, Allison Stahlman, Allison Stahlman, Sean Eddington, Sean Eddington, and Eric Delgado. and Daniel Brownell.

Who are Sarah Ellis's peers at other companies?

Sarah Ellis's peers at other companies are Dinesh Nt, Anwar Yusuf, Snehal Patil, Talita Travassos, Sandro Shoji, and Björkvall Yngve. and Jyrki Martti. Sarah Ellis's peers at other companies are Dinesh Nt, Anwar Yusuf, Snehal Patil, Talita Travassos, Sandro Shoji, and Björkvall Yngve. and Jyrki Martti.