https://greenm.io/GreenM is the engineering and professional services provider for Data-centric solutions. We start from understanding your goals and then leverage a wide variety of top-notch technologies to co-build Analytics products for your business.Our senior-level engineering team brings to the table diverse backgrounds and expertise in numerous technology areas. This enables us to create easy-to-use Analytics platforms that are insightful, scalable and responsive.My responsibilities include, but are not limited to:- Design and own scalable Data architecture for BI environments enabling our clients continued growth by providing key reporting and analytics for their customers.- Design and implement effective Data Pipelines, DWH solutions, models and integrations to retrieve, process and store company data enabling different departments with Data for self-service decision making.- Formulate, define, and document detailed solution objectives and scopes to develop BI, DWH and ETL considering best-practice methodologies.- Plan and oversee legacy systems modernization and migration of data from legacy systems to new solutions.- Adjust existing system design to solve new and existing problems in a dynamic environment. Detecting performance bottlenecks and investigating improvement opportunities.- Creation of DWH documentation for the management and executive teams. Arranging knowledge-sharing sessions and training for remote teams to guarantee a seamless switch to the support phase.- Compose long-term BI solutions roadmaps according to the business needs and industry trends.- Coach developers and QAs in Data best practices and Data engineering.Technology stack: MS SQL, Amazon EMR, Apache Spark, Apache Airflow, Vertica.

In cooperation with MedeAnalytics Inc. (www.medeanalytics.com), worked under a customer-driven, web-based SaaS solution that provides Business Intelligence and Analytical tools for the US healthcare industry. For each customer – Healthcare Provider or Payer - specific product solutions were developed based on a common platform and independent customized data storages. Solutions included Revenue Cycle Management, Population Health, Quality Management, Payer Operations, etc.Main responsibilities:-Data warehouse design and development according to business requirements-Full cycle ETL development and ongoing data import support- DWH and data import performance optimization- OLAP database design, development, and structure optimization- Implementation of client’s change requests: customization of application reports according to client’s business needs via new metrics, dimensions and settings, charts and dashboards, custom data transformation, etc., issue and performance troubleshooting.Technology stack: MS SQL Server, SSRS and SSIS, OLAP, MDX, and SQL query optimization.