Darlan P.
Data Analyst

Skills

Delphi

Apache Hadoop

Databricks

Microsoft Sql Server

Oracle Database

Java

Python

Postgresql

Mongodb

Microsoft Azure

Darlan is available for hire

Hire Darlan P.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

Experienced Information Technology professional with extensive expertise in developing and upgrading technological data infrastructures, both cloud-based and on-premises. Skilled in crafting, defining, and implementing strategies, systems, and projects with a strong proficiency in needs assessment, and the analysis and control of methods and processes. Specialized in Big Data, Data Science, Business Intelligence (BI), and ETL processes. Proficiencies include software development in Java, .NET, C, Python, PHP, and C++, as well as creating, supporting, and maintaining databases such as Oracle, SQL Server, and Sybase. Knowledge extends to big data tools like Hadoop, Hive, Spark, and R, alongside platforms such as Denodo and MongoDB. Experienced with both AWS and Azure, ensuring alignment with corporate goals through optimized routines that lead to cost reduction and improved timelines.

Data Specialist
6/1/2021 - Present

Supported teams as a Data Specialist with a focus on enhancing data infrastructure and analytics capabilities. Developed proficiency in Denodo Data Virtualization, optimizing data integration and delivery processes. Leveraged Metabase for creating intuitive data visualizations and dashboards, improving data accessibility and insights. Utilized Looker for advanced analytics and business intelligence, enabling data-driven decision-making. Integrated AWS Glue to streamline ETL (Extract, Transform, Load) processes, ensuring efficient data workflow and management. Applied Databricks for big data processing and analytics, optimizing performance and scalability of data endeavors.
Data Engineer / Data Architect
11/1/2019 - 6/1/2021

Specialized in data analysis and prediction within the Quick Withdrawal team. Led the development of ETL routines, dashboards, and BI processes, ensuring streamlined data flow and insightful reporting. Managed the creation of data architecture, ETL processes, and functions to comply with LGPD regulations. Served as the technical leader for the data team, guiding strategic initiatives and delivering data-driven solutions. Proficient in leveraging tools such as MicroStrategy, SAS, SQL Server, Oracle, Azure Functions, Azure Data Factory, Kafka, Parquet, Azure Databricks, Azure Data Lake, HDFS, Hive, Hadoop, and Spark. Developed strong expertise in Python programming for various data manipulation and analysis tasks.
Technical Leader BI / Data Science
3/1/2019 - 11/1/2019

Provided technical leadership for the Business Intelligence team, overseeing the development of ETL routines, dashboards, and BI processes. Implemented new procedures and optimized existing ones to enhance operational efficiency. Developed machine learning models for discovering NCM codes, achieving a resource-saving accuracy rate of 92%. Created machine learning solutions for procurement processes to identify inconsistencies between purchased values and the period's inflation. Utilized a range of tools and technologies, including Oracle, Pentaho, Tableau, Orange, Python, AWS Redshift, AWS Aurora, and AWS Lambda.
Data Engineer
1/1/2019 - 3/1/2019

Maintained ETL routines and stored procedures, ensuring smooth data operations and workflow. Developed solutions for LGPD compliance through effective use of database views. Created and secured approval for essential stored procedures, contributing to optimized database performance. Conducted continuous database monitoring to preempt and resolve issues. Demonstrated expertise in utilizing Oracle, SQL Server, and Power BI for various data management and visualization tasks.
Data Scientist
1/1/2018 - 1/1/2019

Spearheaded the creation of crawlers to collect, transform, and identify patterns for products and services. Developed machine learning models utilizing prediction algorithms to validate new product acceptance in the market based on social network data analysis. Designed and implemented routines to systematically feed data into servers. Exhibited strong team management capabilities. Utilized a robust technical stack including Oracle, SQL Server, Hadoop, Hive, Spark, Python, and HDFS.
Senior BI Analyst
7/2/2017 - 1/2/2018

Evaluated, costed, analyzed, and developed Business Intelligence (BI) solutions, focusing on multiple business fronts. Executed comprehensive analysis, design, ETL processes, and the overall conception of BI solutions. Developed technical expertise using SQL Server for procedures, triggers, views, and database modeling. Proficient in additional tools and frameworks such as QlikView, Microsoft Power BI, and Microsoft .NET (C#). Conducted detailed requirements analysis and function point analysis, and employed UML for system modeling.
Senior Business Intelligence Analyst
4/2/2016 - 6/2/2017

Responsible for the design, drawing, and development of a proprietary solution in Business Intelligence, which improved agility and independence from Pentaho suite updates. This technology facilitated the rapid development of high-quality dashboards. The role involved comprehensive analysis, design, ETL, and conception of BI solutions specifically for supermarkets, alongside the development of predictive analyses for these environments. Proficiency was developed in MySQL, employing procedures, triggers, views, and database modeling, along with utilization of Pentaho, MS Power BI, R language, Hadoop, Teradata, and SQL Server for similar tasks. Adopted SCRUM methodology for project management and engaged in requirements analysis, UML design, and coding in Java and PHP. Gained experience with frameworks and tools including Primefaces, JQuery, JPA 2.0, Maven, Laravel, and Google Maps API.
Systems Analyst (Business Intelligence)
2/2/2015 - 3/2/2016

Developed a custom development platform based on Pentaho, utilizing Kettle and Mondrian under the Java platform with an Oracle relational database. Led end-to-end construction of dashboards for cities, encompassing design, ETL processes, cube design, and dashboard development using MDX queries. Engineered various types of dashboards and optimized ETL processes to transfer data every minute, achieving loading times of less than 3 seconds.
Project Manager
7/2/2012 - 6/2/2014

Coordinated international staff for the Picxies project, which was developed in India. Implemented SCRUM methodologies to streamline project management processes. Managed a Business Intelligence project utilizing MS-Analysis Services and Report Services. Oversaw the Network Management System project, ensuring smooth operations and effective management. Successfully delivered the Picxies project within three months, despite it being in development for two years. Implemented a comprehensive knowledge management system within Picxies, which included a set of analytical reports and dashboards for managerial monitoring.
Systems Analyst
6/2/2011 - 7/2/2012

Managed and executed the implementation of a financial system enabling line reconnections within 15 minutes post-payment of a ticket. Demonstrated skills in improving collections processes, significantly enhancing customer service efficiency. Developed technical expertise in financial system integration and operational workflow optimization. Utilized tools and frameworks to streamline system operations, ensuring timely and accurate transaction processing. Implemented improvements resulted in better customer satisfaction and operational efficiency.
BI Consultant
5/2/2010 - 6/2/2011

Developed expertise in analyzing and developing a new Corporate Data Warehouse (CDW) based on the IFRS standard, upgrading the data granularity from monthly to daily. Created an environment conducive to Mainframe ETL techniques while developing use cases, RBPM documentation, and overseeing preparation and coordination of the Mainframe team. Demonstrated proficiency in ETL development using Datastage and report development with the Cognos front end. Applied project management skills utilizing Risk Based Project Management (RBPM). Successfully created a new CDW within the stipulated timeframe, achieving over 30% budget savings. Innovatively integrated mainframe and Business Intelligence (BI) technologies, which led to reduced development times and improved performance. Ensured thorough project documentation in alignment with regulatory standards.
Development coordinator
10/2/2009 - 5/2/2010

Oversaw the successful implementation of the company in Curitiba, including staff recruitment, managing physical workspace, and negotiating telephony and backbone contracts. Coordinated project teams on significant innovations in ERP systems including Document Management, Business Intelligence (BI), Assessment, and HR Systems. Managed various technological innovations in ERP, including the integration of online chat functionalities for internal and customer use, BI deployment, and GED implementation. Utilized SCRUM methodology, supported by Extreme Programming (XP) and Pomodoro techniques to drive project efficiency and quality. Achieved qualitative improvements in the company’s main product, the ERP system, by implementing new innovative features and enhancements.
BI Support Coordinator
10/2/2008 - 10/2/2009

Managed an ASM support team effectively, ensuring high satisfaction rates for six consecutive months in user reviews. Expert in managing SLAs and coordinating the implementation of Data Warehouse systems. Implemented ITIL standards and established a multidisciplinary team for configuration management. Provided deployment and support for Business Intelligence (BI) systems. Facilitated continuous monitoring of analyst activities to ensure quality and productivity, successfully meeting all SLA goals.
Security Analyst / System Analyst / Consultant
9/2/2001 - 9/2/2008

Developed expertise in security analysis, team coordination, and SOX testing management. Managed annual pentest projects and acted as the Latin American representative for internal server monitoring activities, ensuring the implementation of ISO 27001 security standards. Undertook analysis, project management, and system implementation for the Ideal Portfolio, Stock Loan system, and private pension plans. Created B.O. ETL reports and supported the Oracle team in strategic decision-making processes. Contributed to the implementation of the RBPM methodology using the Ideal Portfolio pilot project, proposing new controls.

Achieved notable results, including reducing the rate of debit card fraud by 65% through a project focused on alphanumeric password development. Enhanced the safety index of a major financial institution through SOX and pentesting initiatives. Improved efficiency for portfolio managers, saving 30% of their time by implementing the optimal portfolio system. Successfully implemented the Stock Loan system two months ahead of schedule, resulting in a 35% budget savings and managing coordination with three outsourcing companies and approximately sixty employees.