Jean D.
Data Analyst

Skills

Python

Jean is available for hire

All Howdy Candidates are vetted for skills and english proficiency.

Bio

Expertise in report automation with VBA and the creation of dashboards and reports in PowerBI, encompassing data structures, transformation, relationships, and data sourcing. Proficient in calculating measures and columns, publishing, and developing custom command buttons for company-specific reports. Experienced in data modeling and relationship management, including the implementation of filters, indicators, and data segmentation, as well as the manipulation and merging of data frameworks. Notable projects include those in fiscal and accounting sectors, focusing on time bank mapping and calculation, service level assessment for various stakeholders, and initiatives enhancing client satisfaction within businesses.

Demonstrated ability in E-Commerce analytics, specifically in product pricing, sales forecasting based on historical data, and the development of performance indicators for sales, call centers, and finance departments. Extensive experience with platforms such as VTex, Mercado Shop, Loja Integrada, UolHost, and BR Lojas Virtuais, with expertise in managing Mercado Livre to adhere to platform-specific regulations and build a solid reputation.

Specialist in the Brazilian Multilevel Marketing platform Youhub, with a focus on understanding key supplier product configuration rules for product and service sales and purchases.

Certified by Google in both Fundamentals and Advanced Research skills, with a strong aptitude for team coordination, marketing, Google Analytics, Adwords, email marketing campaigns, business development, and new business implementation. Skilled in developing social media performance campaigns targeting platforms like Facebook and Instagram.

Call center analysis expert with a focus on the development of sales indicators, market analysis, information analysis, and training database indicator development using CSV and SQL techniques.

Possesses advanced proficiency in Excel, Power Query, VBA, and PowerBI, along with intermediate skills in PowerPoint and Word. Actively involved in meetings and call center monitoring, demonstrating a strong commitment to both active and receptive communication within these environments.

Data-analyst
5/1/2021 - 12/1/2022

Worked as a Data Analyst focused on measuring and optimizing the service levels provided to clients, successfully delivering three critical projects: Work Hours, Tax, and Service Level. Leveraged machine intelligence and ETL processes to extract, transform, and load data, facilitating informed decision-making for both internal teams and external clients.

Collaborated directly with business teams as part of the Engineering and Data Analysts group, effectively delivering complex and challenging projects. Played a pivotal role in the Data Analytics team by developing data-driven answers to business questions, utilizing various data sources and tracking key performance indicators using BI tools such as Power BI and databases like MySQL.

Specialized in data visualization and basic statistics to perform ad-hoc queries in databases and data warehouses. Constructed and enhanced static reports through advanced knowledge in VBA and Power BI. Designed and evaluated A/B tests in collaboration with business teams to derive actionable insights. Developed new indicators, goals, and evolutionary metrics to drive business performance.

Expertise includes advanced-level Excel for the creation of fully automated dashboards, VBA, Power BI, MySQL, and Python. Constantly pursued continuous learning and development in the field.
Planning Analyst
4/1/2019 - 2/1/2021

Analyzed e-commerce operations alongside directors, managers, and coordinators, encompassing various business processes such as logistics, payments, and fraud detection. Planned and executed online promotional campaigns, controlled sales volumes, and generated detailed management sales reports. Proficient in measuring and analyzing performance metrics, monitoring order flows within the company, managing stock levels, and maintaining detailed Excel spreadsheets.

Developed and implemented new data analysis projects aimed at enhancing client sales, established action strategies and goals with coordinators, and conducted thorough competition and opportunity analyses. Utilized Google Analytics for web analytics, as well as Power Pivot and Power Query for advanced data manipulation. Leveraged SQL for building and analyzing data, ensuring insightful decision-making.

Executed price analysis on a per-product basis and performed sales forecasting and projection using historical data. Engaged in strategic planning for the company's e-commerce initiatives by manipulating large datasets and transforming them into actionable insights. Operated the VTex E-commerce platform and CRM CGWeb for comprehensive data analysis and manipulation. Created interactive dashboards using Power BI, managed data via the PORTAL BI database, and handled IT service calls through the QUALITOR SERVICE system.
BI and Digital Marketing Analyst
2/1/2018 - 4/1/2019

Certified in Google Adwords Fundamentals and Advanced Search by Google Adwords, along with certification in Dashboard in Microsoft Excel by T2T. Developed and implemented comprehensive strategies for performance analysis across partners and various divisions, including both online and offline media such as radio and TV, as well as financial and executive boards.

Managed supplier registrations, product listings, and rule configuration on the Youhub platform, which connects industries directly with consumers, facilitating the buying and selling of products for registered members. Directed the creation, registration, and maintenance of an affiliate program on the Eduzz platform, handling products such as food supplements, weight loss products, and vitamin complexes. Responsibilities included creating product listings according to platform rules, calculating sales prices, setting commission values, and monitoring sales and affiliations to ensure product success without investing in an online sales platform.

Provided direct support to an advertising agency's clients concerning their 0800 numbers, including the creation and configuration of receptive and callback queues. Extracted BI information and developed personalized KPIs to measure call volume and conversion rates, thus optimizing the selection of the best communication channels and media types.
Controller Business Intelligence Analyst
1/1/2017 - 2/1/2018

Developed and implemented performance analysis strategies for employees and various business areas including Sales, After Sales, Auditing, Monitoring, Credit Recovery, Financial, and Management. Created and optimized analysis tools specifically for call center teams to enhance their operational efficiency. Mapped business processes and designed the organizational structure to streamline operations. Engineered a network of operational analyses, action plans, and reports linked to corporate databases. Developed data tables for tracking sales, financials, and logistics; organized databases for PABX systems and order tables for better data management.

Efficiently managed the organization of all collaborators in a unified database, facilitating agile and straightforward access. Handled historical sales order data to ensure easy consultation and manipulation. Collected and analyzed default information from the first installment with detailed customer insights via a custom database. Conducted advanced billing analyses based on due dates and production cycles to support corporate financial evaluations.

Compiled and analyzed customer data for logistical returns and coordinated sales reversals. Designed and managed the creation of a comprehensive e-commerce system encompassing product portfolio creation, customer service, query responses, order processing, billing, auditing, monitoring, logistics, and sales order fulfillment. Prepared and analyzed performance awards for call center operators using intricate rules. Structured pricing databases and provided extensive support to all areas including sales, after-sales, auditing, monitoring, collections, logistics, financial, and management.

Collaborated closely with management and executive leadership, including direct reporting to executives. Contributed to the development and configuration of ERP systems with seamless e-commerce integration. Developed strategic partnerships with key marketplaces, including associations with Monetizze and the country's largest platforms like B2W.
Business Development Coordinator
7/1/2015 - 6/1/2016

Coordinated a sales team specializing in consortium products, personal loans, and credit cards, driving successful negotiations and product-specific information dissemination. Conducted thorough evaluations of negotiations and post-sales follow-ups to ensure contract finalizations. Managed marketing campaigns through Google and email marketing platforms, leveraging Google Analytics to optimize sponsored links. Facilitated weekly strategy meetings with partners via phone, Hangout, or Skype, and in-person. Maintained strong business relationships with industry leaders such as Bradesco, Itaú, Banco do Brasil, and managed partnerships with consortium administrators like Embracom, Mapfre, and Consórcio Luiza. Developed new partnerships with financial and service institutions including Santander, Banco Pan, Brazil Pre Paid, Caixa Econômica Federal, and others. Played a key role in implementing new business verticals such as Trackers, Financial Services and Utilities, and Insurance. Collaborated extensively with Content, Marketing, Sales, and IT teams to achieve business objectives.
Analyst Operations and Business Development
7/1/2014 - 4/1/2015

Engaged with the Call Center team to perform sales analysis, developing performance monitoring indicators tailored to each operator. Designed a new sales process model for financial products by thoroughly analyzing the competitive market and collaborating with directors to define innovative sales strategies. Conducted detailed analysis of pricing information and implemented changes in the system to support the sales team, providing necessary training. Played a crucial role in the post-sales process by managing sales contracts, obtaining customer signatures, and preparing documents for partner submission. Developed robust performance indicators leveraging data extracted in CSV format and SQL queries, subsequently using Excel with tailored formulas to populate indicator databases. Created Macros in VBA for Excel to automate essential routines, significantly optimizing the time required to generate critical reports for result meetings.
Operational Analyst
11/1/2013 - 6/1/2014

Actively contributed to the establishment of the company by conducting process studies, designing and filing necessary documentation in company directories. Reanalyzed existing processes to identify potential failures and advised managers and directors on redesign, resulting in error corrections. Engineered real-time indicators for internal control to streamline information distribution to partners. Enhanced the company's billing operations by creating Excel tracking spreadsheets with databases for automatic updates, enabling precise information collection for monthly verification and billing. Facilitated monthly meetings with partners to finalize service billings and managed communications with delinquent partners to schedule payments. Supported directors and managers by collaborating with IT departments to develop new strategic initiatives.
Quality Control Analyst
4/1/2012 - 6/1/2013

Spearheaded the creation of a Quality Control and Processes unit, overseeing a team of three analysts responsible for managing the information flow within the company. Designed and implemented a comprehensive process map that tracked the journey of information from suppliers to live website sales, ensuring accuracy in product registration details such as price, stock, images, descriptions, and taxes. Conducted reanalysis of live products to identify and rectify potential issues, thus minimizing post-sales problems.

Developed expertise in Excel for crafting detailed reports and indicators, utilizing advanced calculation formulas aligned with specific metrics. Created and presented result-driven reports for investors and key stakeholders, including annual conferences attended by CEOs, Managers, and Directors. Collaborated extensively with logistics, commercial, and IT departments to develop and refine processes and analyses, leading to enhanced operational efficiency across sectors.
Process Analyst
1/1/2008 - 4/1/2012

Contributed to the creation and development of the Quality Control Analyst Cell by designing and streamlining processes for the Commercial Support department. Key tasks included participating in all departmental activities, studying each step in the workflow, and developing comprehensive analysis and performance indicators using Excel and Access. Information was systematically extracted from SQL queries to support analytical needs. Managed the introduction of a third shift to update information analysis routines, significantly enhancing team efficiency to reach optimal performance. Cooperated closely with departments such as logistics, B2B, B2C, tax, and customer service to develop and refine analytical routines, leveraging input from analysts in these areas. Actively participated in result monitoring meetings, creating detailed minutes and memos to guide all teams and ensured that new information was gathered according to the meeting agenda.
Administrative Assistant
1/1/2004 - 12/1/2007

Participated in initiatives affecting the entire call center, developing proficiency in creating and analyzing performance indicators using Excel and Access. These indicators included call time, reception, pause time, telephony costs, payments, chargebacks, and metrics related to closing and payment, as well as goals and rewards categorized by portfolio, operator, and sector. Managed the creation of a comprehensive Excel database for company-wide use, containing relevant employee information such as names, work hours, periods, supervisors, managers, and portfolios. Monitored all active and incoming customer service calls, providing feedback to their respective managers. Developed and implemented training programs tailored to the specific needs of each team, ensuring continuous improvement and skill enhancement.