Miroslav Maraz
SQL Developer in Philadelphia, PA, United States
Member since May 15, 2016
Miro is a versatile software engineer with a mix of skills ranging from application development to data engineering and data science. He has 15 years of experience building and delivering data-driven applications to clients of all sizes. He is extremely flexible and able to work as a standalone freelancer or integrate within teams. Miro currently builds intelligent web applications and APIs with embedded smart algorithms and machine learning.
Miroslav is now available for hire
Portfolio
- Untitled ResearchPython, R, C#, SQL Server 2016, PostGres, HTML, JavaScript, Angular, BreezeJS...
- Coldlight | PTCTalend, AWS, Redshift, SQL Server, PostGres, MySQL, MongoDb, C#, Python, Java...
- Connolly (Cotiviti)SQL Server (Full-Stack), Pervasive Integrator, SSIS, OLAP, R, HTML, ERStudio
Experience
- SQL, 16 years
- Database Design, 10 years
- OLAP, 10 years
- .NET, 7 years
- Python, 4 years
- NoSQL, 3 years
- APIs, 3 years
Availability
Part-time
Preferred Environment
Visual Studio, VS Code, Spyder, PyCharm, RStudio
The most amazing...
...project I've architected was a smart healthcare platform that combined medical data from 160 million individuals with machine learning to predict various risks.
Employment
CTO | Lead Architect
2015 - PRESENTUntitled Research- Created a predictive API with Python, Flask, MongoDB, PostGres, and H2O.ai.
- Designed a desktop master data management application using C#, SQL Server, Entity Framework and DevExpress components.
- Developed a responsive Angular application for movie data.
- Created an internal toolkit based on R Server, SQL Server 2016 and H2O that enables rapid development of predictive models and collects supporting data and metadata.
- Crafted interactive noetebooks that visualized historic data for a music industry client with R Markdown, Bootstrap, Plotly, and Impala SQL.
Technologies: Python, R, C#, SQL Server 2016, PostGres, HTML, JavaScript, Angular, BreezeJS, DockerTechnical Director | Data Services
2014 - 2015Coldlight | PTC- Architected a database system that collected 1.1 billion+ healthcare transactions and events for 160 million individuals with Talend and Amazon Redshift.
- Created a metadata-driven feature engineering and data transformation utility capable of transforming raw data into input features for a machine learning process.
- Created several workflows in Talend that interacted with several database systems and machine learning and persist the results of machine learning processes.
- Oversaw an implementation of a Talend-based master data management solution that replaced proprietary, labor intensive solution.
- Assisted colleagues from various departments to optimize data engineering and data transformation techniques and methods.
Technologies: Talend, AWS, Redshift, SQL Server, PostGres, MySQL, MongoDb, C#, Python, Java, TableauLead SQL Developer | Technical Data Analyst
2009 - 2014Connolly (Cotiviti)- Led the re-engineering effort of a 6+TB data warehouse that enhanced performance while reducing storage footprint by 20%.
- Designed a custom, data collection framework that enabled collection of previously unattainable information from 3rd party systems access with AutoIt, SQL Server, and PowerShell.
- Implemented various enhancements and optimizations to SQL based ETL processes to enhance performance and reduce processing time by 63%.
- Developed various data mining analysis of healthcare claim data aiming at identifying anomalies with SQL Server SSAS Data mining algorithms.
- Created a custom rule engine with XML based storage and SQL based execution that allowed users to create, store and execute business rules against the data warehouse and find qualifying records.
- Authored and lectured a SQL server advanced course for an internal team of SQL developers.
Technologies: SQL Server (Full-Stack), Pervasive Integrator, SSIS, OLAP, R, HTML, ERStudioSoftware Engineer | Data Architect | Co-founder
2006 - 2009KRESS, Slovakia, EU- Designed a custom data processing and master data management platform that integrated pharmaceutical sales, logistics and CRM data with VB.NET, DevExpress, and SQL Server.
- Led the development of a data analysis tool that allowed 400+ users to explore and visualize millions of rows of sales data offline with a proprietary ROLAP technology.
- Created a GIS-based mapping module that enabled the end users to customize maps and create and analyze sales across custom regions.
- Automated data aggregation processes used to create offline cubes with metadata driven by using VB, SQL Server, and a proprietary ROLAP engine.
Technologies: .NET (C#, VB), SQL Server, MySQL, MDX, OLAP, HTML, DevExpressIT Consultant
2002 - 2009Freelance Work- Designed and implemented a production management system powered by bar code based data collection that enabled real-time insights into the production progress.
- Designed a PocketPC based app that allowed plant managers to monitor production progress in real-time from anywhere within the facility.
- Built a school management application that helped manage courses, classrooms, scheduling, billing, and reporting.
- Implemented and customized a groupware system for the knowledge base, internal scheduling, articles, and polling.
Technologies: VB6, VB.NET, SQL Server, Oracle, MySQL, Firebase, MDX, OLAP, Citrix
Experience
- Medical Transportation Intelligence Center (Development)
A business intelligence system for a medical transportation company that integrated otherwise isolated billing and dispatch systems to allow for simplified reporting, analysis, and effective business management.
- FLIQ.AI (Development)https://fliq.ai/
FLIQ is a movie intelligence platform powered by AI technology. It gives unprecedented access to rich, interactive movie analytics.
Skills
Languages
SQL, JavaScript, C#, Python, R, Visual Basic, ML Programming Language, Markdown, HTML/CSS, AutoItStorage
Microsoft SQL Server, SQL Server Management Studio, PostgreSQL, MySQL, NoSQL, MongoDB, SQL Server Integration Services (SSIS)Frameworks
.NET, ASP.NET Web API, Flask, Windows PowerShell, AngularJSTools
Microsoft Visual Studio, Talend ETL, MongooseParadigms
REST, Database Design, OLAP, Agile Software Development, DevOpsPlatforms
Docker, Talend, RStudio, Azure, Amazon Web Services (AWS)Other
Predictive Analytics, Machine Learning, APIs, Natural Language Processing (NLP), Virtualization, Data Mining, Lean Startups, DevExpress, Angular BootstrapLibraries/APIs
Flask-RESTful, Node.js, NumPy, Breeze.js, NLTK, Windows Forms
Education
- Master's degree in Industrial Engineering and Management1998 - 2004Slovak Technical University - Bratislava, Slovakia, EU
Certifications
- MCITP SQL Server Database AdministrationJANUARY 2012 - PRESENTMicrosoft
- MCITP SQL Server Business IntelligenceJANUARY 2012 - PRESENTMicrosoft
- MCITP SQL Server Database DevelopmentJANUARY 2012 - PRESENTMicrosoft
