Ken Kramer

Ken Kramer Email and Phone Number

Business Intelligence Architect and Data Architect @ Medica
Saint Paul, MN, US
Ken Kramer's Location
St Paul, Minnesota, United States, United States
Ken Kramer's Contact Details
About Ken Kramer

--+12 years experience in healthcare (provider, payer, device, product supply, HIPAA) --11 years of Data Warehousing and Business Intelligence--Certified Business Intelligence TrainerSpecialties: Data Architecture, Business IntelligenceSnowflake architecture, Snowflake modeling, Snowflake data flow

Ken Kramer's Current Company Details
Medica

Medica

View
Business Intelligence Architect and Data Architect
Saint Paul, MN, US
Employees:
17
Ken Kramer Work Experience Details
  • Medica
    Business Intelligence Architect And Data Architect
    Medica
    Saint Paul, Mn, Us
  • Medica
    Business Intelligence Architect/Data Architect
    Medica Mar 2020 - Present
    Minnetonka, Mn, Us
    Worked as both Data Architect and Business Intelligence Architect for Health Insurance company. Involved in all stacks of data from data acquisition, data movement, and consumption for a variety of verticals within the company including claims, payments, contact center, actuarial, finance, membership.Assisted company with move from On-prem warehouse to cloud for both data lake and consumption marts.Worked in Enterprise Data Management in a variety of projects during several restructuring and operational model changes. Worked closely with Senior Vice President of Data Enablement on enterprise roadmap.
  • The Solution Fits, Inc.
    Owner
    The Solution Fits, Inc. Jan 2000 - Present
    Data Warehouse Architect and Business Intelligence Consultant
  • Blue Cross Blue Shield Of North Dakota
    Senior Data Architect
    Blue Cross Blue Shield Of North Dakota Sep 2019 - Dec 2019
    Fargo, N.D., Us
    Roadmap for on-prem ODS for Analytics using vendor provided cloud warehouse while mentoring legacy analytics team on new platform. Work with additional data movement vendors on implementing on-prem ODS
  • Findlaw, Part Of Thomson Reuters
    Data Warehouse Architect
    Findlaw, Part Of Thomson Reuters Dec 2015 - Aug 2019
    Eagan, Minnesota, Us
    Design and implement Oracle data warehouse and data mart as required. The selected pattern for this implementation was a hybrid of Inmon and Kimball method. Worked with the corporate SAP BW and corporate data warehouse to extract data, and load data to eliminate intermediate data marts/flat files to improve data availability and data quality for FindLaw core operational system
  • Mayo Clinic Rochester
    Business Intelligence Architect, Data Lake Analyst
    Mayo Clinic Rochester Nov 2016 - Nov 2018
    Mankato, Mn, Us
    Mayo Clinic was in the process of migrating to the EPIC medical record system. Mayo Clinic needed help extending existing EPIC Business Objects Universes in addition to creating new Universes where needed. I stayed on through the roll out of EPIC to Mayo wide and then transitioned intimate knowledge to internal Mayo personal. This project required a lot of data analysis because of the vast reach of EPIC with a large Healthcare organization comprised of both hospital and clinic care. I became valuable due to prior knowledge of Health Provider organizations which allowed me to flow between several EPIC domains while others, including EPIC personnel, are very specialized.
  • Ameripride Services
    Business Intelligence Architect
    Ameripride Services May 2015 - Nov 2015
    Minnetonka, Minnesota, Us
    Provide information to Customer Service Managers/Reps via mobile application. This project required work in the whole BI stack from source data analysis, data warehouse design, ETL, Universe Design, Web Services, Dashboard Design.
  • Mobe
    Solution Architect
    Mobe Mar 2015 - May 2015
    Worked with C-Level executives at a startup company to provide insight and direction (roadmap planning) for Application and Data areas.
  • Prime Therapeutics
    Business Intelligence Architect
    Prime Therapeutics Jun 2014 - Apr 2015
    Eagan, Mn, Us
    BI Architect for the project in addition to being the SAP Business Intelligence expert and the go to person for everyone at Prime working in the Business Intelligence space.Worked on BI Stabilization project. Recommended and implemented best practices for currently installed data warehouse and reporting system. Prime had several problems with their productive data warehouse at several tiers: Network, Middleware, Business Objects Application server, and database. Successfully corrected the productive system by diagnosing, recommending, and implementing changes at every tier of the solution. Technologies included:• SAP Business Objects Universe • Full Suite of 4.1 SAP Business Object • Dashboard Design, • WebI, • Universe, • BI Workspace, • SAP Lumeria, • Info Steward, • Qwaas, • Data Services • WeIntelligence• DB2 (Data Studio, Tuning, DB2Mon)• BIG IP (F5 appliance)• WebSphere• HIS• Robust Security
  • Findlaw, Part Of Thomson Reuters
    Data Architect/Business Intelligence Architect
    Findlaw, Part Of Thomson Reuters Jun 2012 - Oct 2014
    Eagan, Minnesota, Us
    Design and implement Oracle 11g data warehouse and self service reporting via Business Objects Universe. Developed Mutli-connection universe via the Information Design Tool. Created Xcelsius dashboard for Search Engine Optimization (SEO) consultants. Work with Informatica developers on source to target analysis. Utilized Report Conversion Tool and other conversion techniques to move department from Version 3.1 to 4.x. Received recognition after training end users on WebIntelligence. Performed proof of concept for many aspects of the dashboard solution which allowed me to work with Java, Xcelsius and Oracle OBIEE. Technologies included:• SAP Business Objects Universe Designer/Information Design Tool • WeIntelligence• Tableau• Xcelsius 2008 • Business Objects infoview• Report Conversion Tool • SAP PowerDesigner 16
  • Woodburn Group
    Senior Business Objects Certified Consultant
    Woodburn Group Nov 2006 - Jan 2013
    Minneapolis, Mn, Us
    Business IntelligenceData VisualizationDashboard DesignGo-to-market strategyGeographic visualization
  • Ceridian
    Business Intelligence Consultant
    Ceridian Feb 2011 - Jun 2012
    Minneapolis, Mn, Us
    Design and implement self service report portal, data warehouse, corporate dashboard. Successful implementation of a project utilizing the SCRUM methodology for agile development. Active involvement with the ETL via Microsoft SQL Server SSIS from individual client data sources to warehouse. Design and implement dashboard and reports using SAP Business Objects suite (Universe for meta data layer. WebIntelligence for reporting layer, and Xcelsius/Dashboard Builder for presentation). Technologies included:• SAP Business Objects Universe Designer • WeIntelligence• Xcelsius 2008 • Dashboard Builder• Business Objects infoview • SQL Server SSIS
  • Meeker County Memorial Hospital
    Chief Information Officer
    Meeker County Memorial Hospital Jan 2008 - Mar 2011
    Promoted to Chief Information Officer in January 2008 at the start of a 75,000 sq ft expansion project. Responsible for bringing hospital operational systems current:Data Center design IP network Voice over IP phone system Video Surveillance IP Access Control system Fire and Safety System Infant Protection system Nurse Call System Wireless IP network Wireless IP Phone (Ascom) Guest Wi Fi Bonded T1 service June, 2010 the extreme makeover of the hospital was complete.
  • Meeker County Memorial Hospital
    Technical Project Manager
    Meeker County Memorial Hospital Jun 1998 - Jan 2008
    Laboratory information system Radiology information system Clinical Hospital information system Ordering system Nursing bed board and workflow system Medical records system Data processing and finance function HIPAA compliance including technology infrastructure, security, recovery, and use policies.
  • United Healthcare
    Senior Sap Business Objects Consultant
    United Healthcare Nov 2006 - Jun 2009
    Us
    SAP Business Objects Universe Designer WebIntelligence Xcelsius 4.5 and Xcelsius 2008 Crystal Reports Business Objects Infoview SAP Enterprise Administration Performance Management SQL Server SSIS Dashboard Manager Computer Associates Autosys scheduling
  • Ats Medical, Inc.
    Senior Sap Business Objects Consultant
    Ats Medical, Inc. Oct 2006 - Feb 2007
    Us
    Sales data warehouse SAP Business Objects Universe Designer WebIntelligence Xcelsius 4.5 Crystal Reports Business Objects Infoview SAP Enterprise Administration
  • 3M Global Data Services
    Senior Sap Business Objects Consultant
    3M Global Data Services Sep 2006 - Oct 2006
    SAP Business Objects Universe Designer WebIntelligence Teradata Crystal Reports
  • 3M
    Sap Enterprise Administration
    3M Sep 2005 - Oct 2006
    St Paul, Mn, Us
    SAP Business Objects Universe Designer WebIntelligence Teradata Crystal Reports ETL
  • Carlson Marketing Group
    Program Manager
    Carlson Marketing Group Sep 2004 - Sep 2005
  • Blue Cross/Blue Shield Of Minnesota
    Project Management
    Blue Cross/Blue Shield Of Minnesota Jun 2004 - Sep 2004
  • Bestbuy.Com
    Technical Project Management
    Bestbuy.Com Jun 2003 - Aug 2004
  • Medtronic
    Consultant
    Medtronic Jan 2004 - Feb 2004
    Minneapolis, Mn, Us
    Patent Management
  • Medtronic
    Consultant
    Medtronic Mar 2003 - Jun 2003
    Minneapolis, Mn, Us
    Business process reengineering Risk Management
  • 3M
    Technical Project Manager
    3M Sep 2000 - Dec 2002
    St Paul, Mn, Us
    3M Legal Affairs
  • Us Bank
    Application Architect/Team Lead
    Us Bank Jan 2000 - Sep 2000
    Minneapolis, Mn, Us
    World Perks Visa
  • Lakes Medical Supply
    Technical Consultant/Advisor
    Lakes Medical Supply Mar 1998 - Jun 1998
  • Qwest
    Application Architect/Mentor
    Qwest May 1995 - Mar 1998
  • Integrity Solutions
    Consultant
    Integrity Solutions May 1995 - Oct 1996
    Termini, 3 Arkle Rd, Sandyford, Sandyford Business Park, Dublin 18, Ie
  • Honeywell
    Associate Programmer
    Honeywell May 1990 - May 1995
    Charlotte, North Carolina, Us

Ken Kramer Skills

Business Objects Data Warehousing Business Intelligence Etl Web Intelligence Dashboard Enterprise Architecture Enterprise Software Databases Report Development Teradata Business Analysis Training Agile Methodologies Healthcare Consulting Healthcare Information Technology Healthcare Industry Business Intelligence Sdlc Requirements Analysis Microsoft Sql Server Sql Integration Consulting Data Architecture Amazon Web Services Clarity Healthcare Reimbursement Healthcare Analytics Healthcare Improvement Healthcare Management Hadoop Microsoft Power Bi Mdm Sap Data Services Metadata Etl Tools Business Objects Data Integrator Data Management Master Data Management Master Data Agile Project Management Scrum Kimball Inmon Kanban

Ken Kramer Education Details

  • University Of St. Thomas
    University Of St. Thomas
    Computer Science
  • University Of St. Thomas - St
    University Of St. Thomas - St
    Quantitative Methods/Computer Science

Frequently Asked Questions about Ken Kramer

What company does Ken Kramer work for?

Ken Kramer works for Medica

What is Ken Kramer's role at the current company?

Ken Kramer's current role is Business Intelligence Architect and Data Architect.

What is Ken Kramer's email address?

Ken Kramer's email address is kk****@****law.com

What schools did Ken Kramer attend?

Ken Kramer attended University Of St. Thomas, University Of St. Thomas - St.

What skills is Ken Kramer known for?

Ken Kramer has skills like Business Objects, Data Warehousing, Business Intelligence, Etl, Web Intelligence, Dashboard, Enterprise Architecture, Enterprise Software, Databases, Report Development, Teradata, Business Analysis.

Who are Ken Kramer's colleagues?

Ken Kramer's colleagues are Sheila Cristina Campos De Almeida, Higor Augusto, Letuzia Gomes, Jéssica Pires, Beatriz Alves, Aline Damasceno.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.