Sormane D.Data Analyst
Skills
This professional boasts extensive expertise in information technology, specializing in support, maintenance, development, and integration of both structured and unstructured data sources. Proficient in database modeling using OLAP and OLAP with DBMS platforms such as PostgreSQL, Oracle, MySQL, and NoSQL, they demonstrate comprehensive skills in data handling. Their expertise spans the entire data analysis pipeline, from collection to transformation, processing, cleansing, and loading (ETL), utilizing sophisticated tools including Python, Spark, Pentaho, R, and Hadoop. They are adept at version control with GitHub and GitLab on both Windows and Linux operating systems.
In the domain of data science, their skills include implementing machine learning algorithms for classification and regression using scikit-learn. They are also proficient in natural language processing techniques such as bag of words, CBOW, skip-gram, fastText, and TF-IDF. Programming capabilities encompass SQL, PL/SQL, PG/SQL, Python, PySpark, and R, leveraging development tools like Data Modeler, Pentaho Data Integration, VisualCode, PyCharm, GitBash, GitHub, DBeaver, robot 3T, Hadoop, Jupyter Notebook, and RStudio.
Their experience with database management systems includes PostgreSQL, MySQL, Oracle, and MongoDB, alongside robust competencies in Linux operating systems (Red Hat, Debian, CentOS) and various Windows versions (XP, 2000, 2003, 7). Their multifaceted IT knowledge positions them to effectively contribute to projects involving support, maintenance, development, integration of data sources, and data analysis, as well as database modeling and version control within Windows and Linux environments.
Senior Data Engineer
12/1/2022 - Present
Developed machine learning algorithms for classification and regression, utilizing Python and Jupyter Notebook for comprehensive data analysis and modeling. Implemented machine learning models using the Scikit-Learn library and managed version control with Git. Specialized in developing solutions for Natural Language Processing (NLP).Data Engineer
10/1/2022 - 12/1/2022
Designed and implemented automated data pipelines with Azure Data Factory for efficient extraction, transformation, and loading of data from diverse sources into Azure Data Lake. Developed proficiency in writing Python notebooks within Databricks for exploratory data analysis and large-scale data processing using Spark. Created SQL queries to extract data from relational databases for subsequent analysis and visualization. Developed interactive dashboards and business intelligence reports leveraging Power BI and Metabase to facilitate data-driven decision making.Data Engineer / Data Scientist
6/1/2017 - 10/1/2022
Developed expertise in ETL processes utilizing Pentaho Data Integration to integrate data from diverse sources into a unified data warehouse. Conducted comprehensive data analysis using Python and SQL to derive insights, create reports, and develop interactive dashboards to support decision-making processes. Configured and managed Linux operating systems specifically for the production environment of the data warehouse. Gathered requirements from business areas to understand their needs and translated them into technical solutions. Managed code versioning with GitLab to ensure the security and control of source code changes.DBA
3/1/2014 - 6/1/2017
Successfully executed data extraction, transformation, and loading (ETL) processes using Pentaho Data Integration to integrate data from diverse sources into a unified data warehouse. Conducted in-depth data analysis using SQL to generate insights and crafted interactive reports and dashboards to facilitate informed decision-making. Managed and configured Linux operating systems to support the data warehouse production environment, ensuring robust performance. Performed Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL) operations on relational databases, including creating tables, users, indices, and managing access permissions. Ensured database management and maintenance, prioritizing data availability and security. Developed PL/SQL and PG/SQL routines to automate tasks and optimize database performance.Support / Development Analyst
3/2/2013 - 6/1/2014
Administered Oracle 11g database, focusing on implementing improvements and identifying and resolving issues. Customized scripts using DML, DDL, and DCL commands, and developed proficiency in programming and developing databases with PL/SQL. Contributed significantly to the improvement of system performance and scalability.Support Coordinator
4/2/2011 - 10/2/2012
Oversaw the coordination of local and remote support teams for the development of corporate solutions. Administered and maintained PostgreSQL 8/9 databases, including script customization using DML, DDL, and DCL commands. Specialized in programming and developing with PL/pgSQL and SQL languages, creating functions, procedures, triggers, views, and other database objects. Focused on optimization and tuning of DML commands to enhance performance. Implemented various database features aimed at performance improvement. Administered and maintained both Windows and Linux operating systems.Military personnel
9/2/2007 - 9/2/2009
Expertly administered and maintained Windows Operating Systems, along with proficient installation and configuration of peripherals. Developed and maintained systems utilizing Visual Basic. Conducted thorough research and implementation of new technologies and services to enhance operational efficiency and technological advancement.
Information Security Technologist at AD1 College
2003 - 2007Data Science at IESB
2020 - 2021Data Modeling/Storage and Database Administration at Estácio
2018 - 2019
Microsoft Certified: Azure Data Fundamentals at Microsoft
11/1/2023PCEP-30-02 - Certified Entry-Level Python Programmer at OpenEDG Python Institute
1/1/2023Business Intelligence at Instituto de Gestão de Tecnologia da Informação
7/1/2020Data Analyst at Instituto de Gestão de Tecnologia da Informação
5/1/2020PostgreSQL Database Administration at Dígitro Tecnologia
1/1/2019
Sormane is available for hire
Hire Sormane D.All Howdy Candidates are vetted for skills and english proficiency.