Nelson C.Data Analyst
Skills
Possesses extensive experience as a Data Specialist, adept in contracting consulting roles to provision, integrate, and optimize both structured and unstructured data using a variety of database products, technologies, and methodologies. Demonstrates expertise in managing database projects, developing information models including logical, physical, and dimensional, crafting data migration plans, and developing Data Warehouses. Proficient in identifying requirements, specifying needs, evaluating data and outcomes, and compiling reports through effective data structuring techniques such as ETL, OLTP, OLAP CUBES, and DWDM.
Consulting Specialist
1/1/2020 - 2/1/2022
Served as a Data Specialist, focusing on the development of sales reports and dashboards tailored to the precise requirements of the Sales and Marketing departments. Achievements in this role include proficiency in data visualization tools such as Tableau and Power BI, and expertise in SQL for data querying and manipulation. Developed complex data models and implemented ETL processes using Python and SQL Server Integration Services (SSIS). Leveraged knowledge of business intelligence frameworks and reporting tools to facilitate data-driven decision-making. Utilized advanced Excel functions, including pivot tables and VLOOKUP, for data analysis and reporting. Collaborated extensively with cross-functional teams to gather requirements and ensure the delivery of actionable insights. Demonstrated strong analytical skills and attention to detail in creating comprehensive and accurate reports. Ensured data accuracy and integrity through rigorous testing and validation procedures.Specialist Consultant
1/1/2018 - Present
Developed and implemented Microsoft solutions specifically focused on Human Resources, Engineering, and Projects. Achievements include the design and execution of software solutions that optimized HR processes, facilitated effective engineering project management, and streamlined various project operations. Mastered technical skills in utilizing Microsoft Azure, Power BI, and SharePoint for creating integrated and scalable systems. Gained extensive experience in conducting requirement analysis, process mapping, and workflow automation. Successfully employed Agile methodologies to manage and deliver projects on time and within budget. Excelled in stakeholder management through regular consultations and feedback sessions to ensure solutions met organizational needs. Established data-driven decision-making processes by integrating advanced reporting and analytics tools. Enhanced collaboration within teams using Microsoft Teams and Office 365 suite.Consulting Specialist
1/1/2016 - 12/1/2021
Developed and implemented Microsoft solutions across multiple business functions. In Human Resources, created an automated spreadsheet for managing and monitoring career policy professionals and tracking turnover rates. In Sales, developed a comprehensive sales dashboard tailored to Brazilian market criteria as well as general corporate indexes. For the Marketing department, designed a local tool to support salespeople and stock replenishers in optimizing product distribution on shelves, taking into account competitor sales capacity. Demonstrated technical expertise in Microsoft Excel, Power BI, and other relevant Microsoft Office tools.Consulting Specialist
1/1/2014 - 12/1/2018
Developed and implemented Microsoft solutions targeting the areas of Supply, Receiving, and Manufacturing. Gained extensive experience in utilizing tools such as Microsoft Dynamics 365 and Power BI. Demonstrated expertise in business process analysis, requirement gathering, and creating technical specifications. Utilized SQL for database query writing and data analysis. Showcased strong project management skills, including resource allocation, timeline management, and stakeholder communication. Enhanced process efficiency through the integration of Microsoft Power Automate workflows. Conducted system testing, user training, and provided comprehensive documentation.Special Projects Consultant
1/1/2010 - 6/1/2022
Gained extensive experience in software development and implementation across multiple sectors within the organization. Developed proficiency in various programming languages and frameworks, including PHP, Doctrine, and Silex. Expanded technical expertise through work with Ext JS 4.2, NodeJS, and Vue.js. Demonstrated strong skills in database management using PostgreSQL and MongoDB. Successfully maintained collaborative codebases using version control systems such as SVN and Git.
Business Administration with an emphasis in Systems Analysis at São Paulo School of Management
1980 - 1988Information Technology at Associated Colleges of São Paulo
1984 - 1988
Nelson is available for hire
Hire Nelson C.All Howdy Candidates are vetted for skills and english proficiency.