Alison Kramer Email & Phone Number

New York, NY, US

Administer Azure environment including multiple VMs and SQL serversDesign data warehouse architectureBuild ETL to integrate data from six EMR/PM data sources Introduce master data concepts and recruit data stewardsManage BI team membersProvide expert data analysis as needed

Paris, Paris - Issy-les-Moulineaux, FR

Clients:T. Rowe Price – Data Analyst – 10 months- Facilitated the transition of an existing reporting system from one dataset and environment to another- Analyzed report requirements- Created documentation for various consumers- Refined report requirements based on business needs and data availability- Built an Excel VBA solution to scrape MicroStrategy.

US

Constructed a data model for a warehouse to provide a reporting environment for a variety of usesBuilt and tested data structure required to restrict combined data by companyEvaluated report presentation optionsCreated and maintained user security for a varied user pool through multiple access pointsDeveloped stored procedures to run overnight which enable.

Nashville, TN, US

Spearheaded HCAHPS data management in the initial stages of the projectManaged and tracked 200+ studies throughout the data collection process ensuring all deliverables were met prior to every deadlineNetworked with contacts to ensure client side project requirements were metReviewed and interpreted CMS project requirementsImplemented numerous QA processes.

Improved workflow using technology while being employed as a tempDeveloped technology without interruption to assigned responsibilities, including scheduling, transcription, and superbill creationCreated a patient database using MS Access including user forms enabling various employees to intuitively maintain patient data as well as create daily superbills

Researched and compiled a database of all known cryptography products.Created a process to produce an HTML document in 1995 using paradox DBConverted a paradox DB to MS AccessRedeveloped HTML output using VBA, Perl and.bat files to produce web pages displaying information from MS Access databasesDeveloped several GUI-driven Access database solutions for.