Andrew Cramer Email & Phone Number

Osseo, Mn, Us

Osseo, Mn, Us

Eden Prairie, Minnesota, Us

Saint Loius Park, Mn, Us

Business Intelligence developer specializing in data migration, ETL development and data warehouse development. Worked on various contracts consisting of SQL Server upgrades as well as data warehouse and ETL development migrating data from a legacy to new system. SQL and SSIS development was used to populate and update the new data warehouse and create new measures needed for reporting.

Bloomington, Mn, Us

Bloomington, Mn, Us

Data Warehousing/Implementation Consultant specializing in client configuration of ETL processes. Responsible for optimizing queries that populate client online dashboards and ensuring data integrity.

Richmond, Virginia, Us

Reporting developer for major customer loyalty program responsible for SSRS development and ETL development using Hive/Hadoop technologies. Developed financial and invoice reports that were delivered to every client location on a weekly, bi-weekly or monthly basis. Report and ETL performance were key requirements when development and execution took place.

Us

Database Developer working primarily on data warehouse ETL procedures using transact SQL and stored procedures. Develop and maintain Business Intelligence Engine used to query data warehouse for complex reporting done by end users. Subject Matter Expert for data loads, dataset creations and BI Engine development.Part of a team responsible for development and deployment of a reporting dashboard for the United Kingdom's National Healthcare System. Traveled to London to deploy and test the new features developed specifically for the NHS as the data lead for this project.

Edina, Mn, Us

Managing internal company applications and data projects. Building data structures for new projects and acting as data subject matter expert for external vendors. Managing data using SSRS, SSIS, SSAS and SQL server ETL processes. Automation of corporate processes and design of management reports.

Edina, Mn, Us

Responsible for building data structure for corporate data warehouse, building SSRS reports used by dealerships, maintain and enhance current SSIS packages for data retrieval, and data analysis and maintenance.

Maple Grove, Mn, Us

Back end data verification for reports and applications used by State Departments of Education.

London, Gb

Performed production support tasks for the shipping, receiving and Inventory systems. Fielded calls from users with problems, documented the issues and worked to troubleshoot/resolve the issue using extensive knowledge of the system and/or data manipulation. SQL was an essential skill to perform basic support tasks such as report generation, issue troubleshooting and data manipulation. Edited and created stored procedures to enhance current system functionalities or add new functionalities in both the shipping/receiving and Inventory systems.Production support tasks were vital to the correct and efficient performance of the systems as well as keeping the warehouse operations up and running.Trained users on basic system functionalities as well as suggested possible enhancements.

Marlborough, Ma, Us

LATITUDE Production Support team. Team was responsible for keeping LATITUDE system up and running at all times. Responsibilities included handling trouble tickets that involved problems with the system, problems with patient hardware and questions from doctors and clinics about the system. SQL knowledge was required to access data in the Oracle database. Also, basic Linux commands were used to access information stored on servers.

Dublin 2, Ie