Sandy Ashby
About Sandy Ashby
Sandy Ashby is a Senior Data/Systems Analyst at Ally in Detroit, Michigan, with extensive experience in systems analysis and business systems analysis, having worked for companies like TEKsystems and EDS.
Senior Data/Systems Analyst at Ally
Sandy Ashby has been serving as a Senior Data/Systems Analyst at Ally since 2014. In this role, Ashby has undertaken significant projects, including the transition of the Recovery system from mainframe to SQL Server/.Net technology. This transition required a thorough understanding and implementation of Credit Bureau Reporting requirements and Shaw Recovery capabilities. Additionally, Ashby developed custom code to meet specific Ally requirements that were not part of the commercial off-the-shelf (COTS) product, particularly during the Debt Manager to Recovery Project. These contributions have been key in enhancing the technical infrastructure at Ally.
Previous Experience at TEKsystems and EDS
Before joining Ally, Sandy Ashby worked at TEKsystems, holding positions as a Systems Analyst and Business Systems Analyst from 2011 to 2014. During this tenure, Ashby worked on projects for Ally Financial and General Motors. Prior to this, Ashby had an extensive career at EDS, an HP company, from 1996 to 2009, where they served in multiple roles including Systems Analyst, Technical Lead, Project Lead, and Consultant/Developer/Project Manager. This diverse experience provided Ashby with a solid foundation in systems analysis, project management, and technical development.
Education at Walsh College
Sandy Ashby holds a Bachelor of Business Administration (BBA) degree in Computer Information Systems from Walsh College, attained between 1994 and 1996. This academic background provided Ashby with a comprehensive understanding of business and information systems, forming a strong foundation for their career in data and systems analysis.
Key Projects and Contributions
During Ashby's tenure at Ally and other organizations, they played a crucial role in several key projects. Notably, Ashby contributed to the creation and management of the 1099 extract process in the Shaw Recovery system and authored SQL stored procedures to automate manual business processes, significantly enhancing efficiency. Ashby also created mapping documentation for Collection interfaces to CARS table fields, aiding in Alfa mapping exercises. Ashby’s analytical skills were pivotal in understanding SAS code for complex Collections reports as part of the Information Warehouse Team and in designing test cases for new fact tables and Cognos reports.
Technical Expertise in Data Integration and Reporting
Sandy Ashby demonstrated formidable expertise in data integration and reporting throughout their career. At Ally, Ashby analyzed new data sources like SAM BK and iRepo to design solutions for incorporating data into the Information Warehouse. Their skill set includes SQL, SAS, and Cognos, which were crucial for analyzing data, designing test cases, and creating detailed mapping documentation for various data integration projects. These technical capabilities have been instrumental in ensuring data accuracy and enhancing the overall efficiency of business processes.