Michal Roguski

Michal Roguski Email and Phone Number

Data Wrangler - digital nomad @
Michal Roguski's Location
United States, United States
Michal Roguski's Contact Details
About Michal Roguski

I am data enthusiast.It is my belief that regardless of continuously evolving tools, protocols and techniques dedicated to information exchange, at the very root we always depend on data.Data transformed into information and knowledge discovered through analysis.Merger of data engineering and science is foundation of my passion.Primary skills:> Data acquisition requirements identification, design, implementation, testing, extraction,cleanse, normalization, validation, analysis and visualization.> Relational databases, SQL Server, MySQL, TSQL, SPs, SFs, SSIS, SSAS, CLR, BCP, performance tuning> BigData (NoSQL) solutions based on document and columnar oriented architectures (certified MongoDBA): MongoDB, Cassandra, Hadoop.> All phases of machine learning driven systems: conception, prototyping, assembling, training data, model design, feature selection, implementation, evaluation, model fitness estimation. Introducing real life applications rather than academic approach.> Predictive & quantitative analytics, data mining, forecasting methods, data modeling, regularization through R, Weka, Python and DMX (SSAS).> Ability to employ cloud computing solutions EC2, S3, Redshift, DynamoDB, Elastic MapReduce, Azure with HDInsight> Experienced in working with large data volumes (5 billion+), large scale ETL (SSIS, Pentaho).> Design, implementation and management of Kimball oriented data warehouses> Classification models: decision trees, neural networks, random forests, Bayesian networks Clustering models: K-means, Fuzzy C-meansDatabasesSQL Server 2005/2008/2012, MySQL, Oracle 8i/9i, MongoDB, Hadoop, Cassandra. Data WarehousingOLAP data structures, data mining (SSAS mining models), data cleaning, Kimball architecture, Redshift (Amazon).Data Analytics R, Weka, Python, SSAS, Pentaho, Tableau.Programming LanguagesPython, SQL, C#.NET, ASP.NET, Visual Basic, Extra Basic, Object Pascal, PHP, Java Script, PL/SQL, MDX, VBA .

Michal Roguski's Current Company Details
Self-employed

Self-Employed

Data Wrangler - digital nomad
Michal Roguski Work Experience Details
  • Self-Employed
    Data Wrangler - Digital Nomad
    Self-Employed Aug 2019 - Present
    As an independent professional, I am taking pleasure in working with not-for-profit organizations, offering help with any data layer related projects (infrastructure, flow, scalability, research), in asynchronous manner. I am focusing on projects open to the public; targeting betterment of environment and community.
  • Humana (Former Healthrageous)
    Senior Db Engineer, Data Scientist
    Humana (Former Healthrageous) Dec 2012 - Jun 2021
    Healthragous was a startup in a Wellness market, got acquired by Humana in 9/2013.> Data layer design, implementation and testing for new product based on MongoDBdocument oriented data store. Introduced paradigm shift in data architecture movingaway from classical relational architecture and ACID concepts towards simplicity of bigdata and nested documents with data replication, BASE idea and CAP theorem.> Proposed, implemented and continuously improve set of classification and clustering datamodels focusing on engagement risk score estimation and outliers detection (R, Weka).Utilizing Decision trees, neural networks, random forests and K-clusters models.> Managing large data stores able to handle semi structured and unstructured diversifiedfeeds coming from multiple biometric devices within schema-less environment.> Designed, implemented and managing MongoDB sharded and replicated cluster,deployed within AWS environment.> Implemented ETL process delivering data to relational Redshift columnar data store fromschema-less MongoDB environment, maintaining data integrity and quality.> Utilized MongoDB oplog file for most accurate identification of data change trackingmechanism allowing for well performing ETL data flow.> For Microsoft stack of legacy system, implemented machine learning environment basedon SSAS data mining models and MDX language, focusing on engagement analysis withdecision trees algorithm.> Implemented data visualization layer in form of static and dynamic reports anddashboards based on Tableau interface.Technology: MongoDB, Redshift, SQL Server 2012, R, Weka, SSAS, Pentaho, Tableau, AmazonAWS, JSON, DynamoDB, TSQL, SSIS, PowerPivot, Python, Subversion, Mercurial, GIT, RedGate bundle, Nools,Kimball architecture, agile development, machine learning, data mining, predictive analytics.
  • Enservio
    Database Engineer
    Enservio Mar 2012 - Dec 2012
    Needham, Ma, Us
    Designing, implementing and maintaining new datawarehouse serving as primary structure for predictive analytics platform focusing on contents insurance estimations (Kimball architecture)Identifying, constructing and executing ETL tasks ensuring data flow between multiple different environments (Windows/Linux) and data structures (SqlServer 2008/2012, MySQL, MongoDB) for continuous growth of data warehouse and data marts utilizing SSIS and Pentaho Testing and implementing most efficient and acurate fuzzy matching algorithms in order to recognize unique canonical data elements crucial for data warehouse qualityAuthor and modify complex SQL/T-SQL queries/stored procedures/UDFsCollaborating directly with business owners to define data requirements, reporting requirements, data analysis requests and technical specificationsResponsible for developing and maintaining data source views, dimensions, hierarchies, cubes, interactive reportsAssisting with ongoing OLTP database design, development and operational supportModeling, developing and deploying OLTP and OLAP data models for business-critical applications and advanced analytics platformCollaborating with product management and business stakeholders to refine and prioritize new requirements. Assisting with ongoing OLAP data warehouse system design, development and operational supportBuilding, designing and deploying web-based front-end reports and data analysis using Microsoft SQL Server 2008 Integration, Analysis and Reporting Services and Jasper
    View
  • Beacon Health Strategies
    Business Intelligence Developer
    Beacon Health Strategies Jun 2011 - Mar 2012
     Developed and improved efficiency of managed care behavioral healthcare data sets complete lifecycle (from ETL and architecture to final reporting). Provided internal teams (analytics, clinicians, business analysts, quality analysts) with analyses focusing on utilization reviews, case management, behavioral and medical claims, authorizations and reviews. Introduced new standard reports coding framework for BI developers – utilization of dynamic SSIS packages invoked and managed (error handling) directly from TSQL procedures. Improved performance of time sensitive production processes by detailed performance tuning including data architecture and coding techniques upgrades. Introduced SQL Source Control system utilized across development servers with RedGate Source Control and Team Foundation Server as client-server mechanism. Member of Business Intelligence Center of Excellence group; participating in business merger from BI data integration perspective, utilizing Kimball's data warehouse architecture. Following agile development methodology, holding responsibility for ETL's design and development, data validation and flow error management (SSIS main environment).
  • Connolly Consulting
    Business Systems Analyst
    Connolly Consulting Jul 2008 - Jun 2011
    South Jordan, Ut, Us
     Partnered with audit teams directly in the field to identify medical claims overpayments. Per auditors and medical coders requests, translated their concepts based on insurer-provider contract analysis and payment policies compliance verification into SQL queries. Worked with local team of analysts as well as with remote groups of corporate developers and analysts on other sites, encouraged high intensity knowledge sharing efforts. Developed complex monthly and weekly time critical ETL processes merging multiple data sources, along with immediate data validation and volume stratifications. Introduced and implemented number of projects focusing on medical overpayment detection based on trend analysis and data modeling. With BIDS(SSAS) and Decision Trees and Logistic Regression algorithms prepared models identifying medical data variables supporting possible overpayment per particular concept. Solution utilized in medical chart review requests and coordination of benefits lines of business. Performed extensive performance analysis from queries optimization, indices, statistics and views structural analysis to SQL tracing and server diagnostics counters collection. Collaborated with DBA to prepare performance best practices documentation for internal Data Analysts community. Developed custom MS Access with VBA frontends and supported global software solutions offered by development team.  Presented ability to work on number of competing and time critical projects combined with constant end users support. Provided user support on daily basis varying from performance complaints, software functionality requests, assisted with new overpayment concepts development. Periodically, per request, prepared custom corporate management reports.Technology: TSQL, Visual Basic, Access, SQL Server 2005/2008, SQL Server Management Objects, SSIS, BIDS, DMVs, Pervasive Maps, BCP.
    View
  • Omniclaim
    Sql Server Developer/Dba
    Omniclaim Sep 2006 - Jul 2008
     Designed and implemented from scratch medical claim overpayment detection infrastructure: database architecture, logical data structure, stored procedures framework and user frontend (C# Windows Forms). Direct cooperation with healthcare auditors. With knowledge base in medical claims coding and billing, created a set of data mining routines responsible for detecting large data sets anomalies – potential overpayments – on month to month basis. Introduced methodology of gathering information directly from clients’ mainframe systems with telnet client automation, data gathering and processing, screen scraping. Performed time critical ETL operations with data sources varying from flat files, Access and Excel files to DB2 and SQL Server. Introduction of parallel loads for performance gain. Responsible for databases performance monitoring, backup solutions and general disaster recovery, managed SQL user roles as well as their Active Directories accounts.Technology: TSQL with CLR stored procedures, C#.NET, Visual Studio .NET 2005, SQL Server 2005, CLR Routines, SQLXML 4.0, SQL Native Client Programming, SQL Server Management Objects, BCP, SSIS
  • Macena Systems
    Web Developer/.Net Developer
    Macena Systems Jan 2006 - Aug 2006
     As a systems analyst and developer I implemented and modified back-end and front-end web based applications in order to maximize capabilities of information flow in existing and new born systems.  Utilized up to date server side programming framework allowed me to reorganize and transform existing distributorship management system to fully functional, modularized and transformable administrative tool.  Designed and implemented .NET client-side application responsible for managing online PHP-based storefront using Web Services.Technology: C#.NET, Visual Studio .NET 2005, MySQL, PHP (Symfony framework), Java Script, Web Services, Visio, UML, Macromedia Dreamweaver, Adobe Photoshop.

Michal Roguski Skills

T Sql Microsoft Sql Server Ssis Data Warehousing Etl Data Modeling Data Mining Agile Methodologies C# Oracle Access Asp.net Big Data Sql Tuning Sql Database Design Mysql Javascript Sql Server 2008 Hipaa Visual Basic Hadoop Object Pascal Tfs Data Warehouse Architecture Ssas Bcp Cpt Stored Procedures Crystal Reports Subversion Agile Project Management Ssas 2008 Mongodb Machine Learning Clr Procedures Dynamic Management Views Powershell Php Sql Server 2012 Pentaho Tsql User Defined Functions Cdc Kimball Methodology Microsoft Bi Suite Powerview Powerpivot R Weka Data Science

Michal Roguski Education Details

  • Wrocław University Of Science And Technology
    Wrocław University Of Science And Technology
    Information Systems
  • Techniczne Zaklady Naukowe
    Techniczne Zaklady Naukowe
    Computer Systems

Frequently Asked Questions about Michal Roguski

What company does Michal Roguski work for?

Michal Roguski works for Self-Employed

What is Michal Roguski's role at the current company?

Michal Roguski's current role is Data Wrangler - digital nomad.

What is Michal Roguski's email address?

Michal Roguski's email address is mi****@****ail.com

What schools did Michal Roguski attend?

Michal Roguski attended Wrocław University Of Science And Technology, Techniczne Zaklady Naukowe.

What are some of Michal Roguski's interests?

Michal Roguski has interest in Animal Welfare, Environment, Science And Technology, Health.

What skills is Michal Roguski known for?

Michal Roguski has skills like T Sql, Microsoft Sql Server, Ssis, Data Warehousing, Etl, Data Modeling, Data Mining, Agile Methodologies, C#, Oracle, Access, Asp.net.

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

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.