Décio C.Data Analyst
Skills
An accomplished professional with a decade of experience specializing in the generation of comprehensive management reports. Expertise encompasses detailed analysis, database structuring, and programming utilizing VBA, Excel, and Access. Proficiencies include formulating documentation tailored to system adaptations based on client requirements, with a strong focus on problem-solving. This involves meticulous planning, execution, and oversight of various improvement projects.
Commercial Analyst
7/1/2018 - Present
Developed proficiency in creating queries using Oracle Developer and SAS with a focus on utilizing proc SQL. Led the development of PowerBI dashboards for monitoring TVRO, actively participating in API implementation project meetings. Spearheaded project development with Business Intelligence for the Service Order table to integrate CSI data. Acted as a knowledge multiplier for the SAS tool, effectively educating team members. Developed key performance indicators for analyzing service attendances and played a crucial role in verifying results for variable payment and analyzing bonuses. Adjusted projection calculations for withdrawals and gathered databases for analyzing suspected fraud.Senior Commercial Planning Analyst
2/1/2018 - 7/1/2018
Engaged in the Sales and Operations Intelligence sector with a focus on Sky Broadband Services Ltd. Spearheaded the automation of S&OP reports utilizing tools such as SAS Guide, Oracle Developer, Analytics, Access, Excel, and VBA. Additionally, facilitated a comprehensive database migration from Access to SAS Guide, thereby enhancing data processing efficiency and operational intelligence.Junior Commercial Analyst
1/2/2015 - 1/1/2017
Demonstrated expertise in automating Pipeline Dashboard updates and handling Salesforce CRM as a key ad-hoc user. Developed skills in parameterizing legacy systems using Oracle. Prepared Integrated Schedules for basic education areas and automated the sending of indicators related to Returns, Billing, Order Cutting, and Transfer utilizing Power BI, SQL Server, Access, Excel, PowerPivot, VBA, and Outlook. Conducted in-depth analysis of transfer, cuts, and order requisition processes. Created spreadsheets for control and routing of promoter visits with VBA, and developed sales simulation spreadsheets. Analyzed costs involved in book manufacturing and structured databases from various systems using SQL Server Management Studio.Sales Assistant
4/2/2013 - 2/2/2014
Developed proficiency in Excel, Access, VBA, PowerPoint, and Outlook through the preparation and analysis of sales indicators, promoters' visits, pipeline, and billing. Created a simulator for field negotiations utilizing advanced Excel functions, VBA for automation, and Outlook for streamlined communication. Demonstrated the ability to handle complex data sets, perform detailed analyses, and present findings effectively using PowerPoint.Senior Commercial Planning Analyst
1/2/2011 - 9/2/2012
Developed expertise in database consolidation utilizing SQL Server, Access, and VBA. Elaborated KPIs for incentive campaigns and managed billing by products and partners, with a focus on goal establishment and monitoring. Conducted thorough analysis of indicators to detect signs of fraud and created presentations on discount policies for partner collaborations using PowerPoint. Authored comprehensive business plans and performed in-depth competition analysis. Designed a knowledge timeline aimed at identifying opportunities for converting former students. Compiled a Strategic Planning Book employing the PDCA cycle, SWOT analysis, and 5W2H methodology. Created flowcharts adhering to BPNM standards using Bizagi. Managed budget development, forecasting, and pricing strategies.Legal Operations Assistant I
7/1/2005 - 5/2/2010
Displayed expertise in preparing documentation with enhancements and parameterization for legal process management software. Spearheaded updates to the internal procedures manual and designed comprehensive flowcharts for operational routines. Conducted thorough research on client history using bank systems and managed supplier payments in SAP. Efficiently collected documents via email and phone from various contract custody areas and agencies. Established goals and work methodologies for the collection team, ensuring optimal performance. Developed controls for the Subsidies area and related departments, consolidating results achieved through the implementation of the Lean Manufacturing project. Created a database in Access utilizing VBA and mapped processes to identify areas for improvement and lead time reduction. Analyzed existing KPIs and developed new ones to enhance process management.
Business Administration at Paulista University
1998 - 2001Business Logistics at Presbyterian Institute Mackenzie
2007 - 2008
Décio is available for hire
Hire Décio C.
All Howdy Candidates are vetted for skills and english proficiency.
