Steven Kohn Email & Phone Number

Wharton, Nj

Providing technical support services to clients in diverse capacities, technologies and functions - leveraging experience gained throughout a career in corporate information technology.Supporting on-site clients, as well as remote, in training and coaching - as well as troubleshooting and resolving technical issues.Delivering technology solutions by understanding the problem, analyzing appropriate and cost-effective options, planning and executing the delivery and supporting the customer after deployment through training and follow-up.Owner of SJK Consulting LLC (Wharton, NJ) https://www.sjkconsulting.net/

Jersey City, New Jersey, United States

Designed self-service and canned report solutions by reverse engineering 100 legacy reports.Developed a first-of-its-kind model that maps the Siebel data to reporting attributes based on how legacy reports utilize the information.Produced specialized SQL solutions converting a relational data model into a dimensional model using the MicroStrategy toolset.

Parsippany, Nj

Post-corporate spin-off, continued to deliver business intelligence solutions for the world's largest and most diverse hospitality business, with a global portfolio of more than 9,000 hotels around the world - now part of a large consolidated team of data scientists and analysts.Guided enterprise and data architects in the creation of entirely new underlying data structures to feed a new Analytical Data Store (ADS) servicing a new business intelligence platform in the cloud - sourced from Master Data Management (MDM) facilities as well as re-platformed and migrated business data to Amazon Web Services (AWS) and re-located legacy sources and new feeds.Designed the semantic layer beneath the business intelligence environment to ensure adherence to standards and the ability to satisfy reporting and analytics needs.Architected attributes, facts, database and logical views; defined entity relationships; developed applications to support "at-a-glance" and deep-dive analytics capabilities. Hands-on development of complex reports and dashboards.Held oversight of an integrated project plan across all disciplines and technologies.

Parsippany, Nj

Created and managed a best-in-class Business Intelligence Center of Excellence team of six developers, architects and administrators. Performed recruiting, training, coaching and development of staff.Oversaw all key enterprise-wide business intelligence projects with a particular focus on developing and maintaining a secure corporate and franchisee platform to expose company key performance indicators (KPIs), dashboards and tools that provide insight into business metrics, engagement scoring and overall value proposition.Worked with leadership and the IT community to ensure added value and organizational efficiencies. Provided a fundamental, must-have resource across the company.Translated application functional requirements into technical requirements and solutions, built and integrated solutions, managed implementation, and provided ongoing support.Implemented new processes, controls and procedures to ensure data integrity and standard definitions for data elements. Key driver of data management, data quality, proper performance tuning and data governance. Drove data governance and maintenance of best practices.Rolled out self-service solutions through Intelligent Cube and visualization deployments.Reverse-engineered MicroStrategy metadata to provide transparency into database objects used by reports and dashboards. Provided an automated means to document everything used in legacy reporting in preparation for new architecture build out.

Technical leader and next-generation business intelligence tool expertServed in all capacities including developer, technical lead, resource manager, business analyst and project manager. Efforts were routinely delivered early and under budget.Utilizing rapidly obtained deep knowledge of the business, designed and developed the company's first implementation of MicroStrategy (including back-end data structures, all schema objects and reports.Creatively utilized the Datamarting facility of MicroStrategy (including pre- and post-SQL) to create and maintain look-up tables, fact aggregates and to build custom, ad-hoc extracts and processes.Designed and developed MicroStrategy interactive dashboards to enable the business to see their data in totally new ways. Several are delivered regularly to the senior leadership team.Identified scores of data quality issues in source data, often determining the cause. Submitted support tickets and tracked them to resolution and verification.Streamlined business processes using SQL to dramatically improve runtimes; one process was improved 2400% (from days to hours).Supported legacy BI toolsets, Informatica DataAnalyzer and OBIEE; developed and maintained a home-grown metadata reporting tool which was deployed to business analysts.Created an internal scorecard reporting system (including key metrics), peering into DataAnalyzer metadata and generating monthly snapshots of tool performance.Achieved MicroStrategy certifications.

Managed sales and marketing Business Intelligence projects for customer base of 300Immediately filled project lead role with minimal direction and system documentation.Instituted best-practice quality procedures in the development of customer reports resulting in increased efficiency and reliability.Streamlined a business-critical reporting environment by combining two separate projects into one. Eliminated 55% of all schema and application objects and created a single "one-stop-shop" place for all reporting for the business unit.Re-architected a large legacy sales and marketing reporting system, dramatically reducing the number of schema and application objects.Supported a MicroStrategy environment of 22 production projects serving different business audiences and reporting needs.

Performed development and support for legacy Sanofi MicroStrategy projects and coordinated integration efforts as the two companies merged.Implemented data quality measures in the warehouse and reporting systems.Coordinated ETL (extract, transformation, load) resources developing new data structures.Performed development, testing, quality assurance and migration activities.

Developed reporting solutions in support of field force of over 5000 and home office pharmaceutical sales staff.Documented business and technical requirements for Sales, Rx and Call reporting.Designed data warehouse tables and views in support of specialized reporting requirements for Call reporting.Supported the logical data modeling; defined rules for ETL (extract, transformation and load) in order to satisfy complex business requirements for pre-calculated fact tables.Developed complex reports in MicroStrategy sourced from underlying data structures using slowly changing dimensions, aggregate tables and ragged hierarchies.Managed four consultants, overseeing their work and managing project plans.

Long Grove, Il

Held various positions and titles of overall increasing scope and responsibilities. Introduced data warehousing and Business Intelligence to the company through research, development and deployment of systems.