I'm Raul Garcia a Business Data Analyst from Mexico.
I’m an Electronic Systems Engineer with a Master in Education and a diploma in Finance.
I have been working for 16 years in three main roles:
Business Data Analyst (6 years), Web Developer (6 years) and Voip Network Engineer (4 years).
Currently, as a New Products Financial Specialist, I develop insightful presentations that summarize data and facilitate decision-making process to the top management of the company. I work with associated financial departments such as Incentives, Volumes, Sales Contribution, Financial Services, Vehicle Parts and Fixed Costs as also with Marketing, Sales and Product Planning teams, to evaluate business impact of new initiatives and strategies for all FCA brands, (Chrysler, Dodge, Jeep, Ram, Fiat and Alfa Romeo), to deliver the financial support that includes revenue, cost, expenses, margins, profit and business impact for key business decisions. Also, I provide financial analyses to Global Product committees, and to the Group Executive Council in order to achieve the approbation of new products or new strategies for Mexico.
As Business Data Analyst, I have been working with data in several ETL processes generating complex VBA Macros and dashboards, using Excel, Power Bi, Tableau, Qlik View and Qlik Sense, to create useful reports that summarize data from different areas of the company, in order to support the decision making process of the top management and achieving big savings as a result of the automation of several transactional activities.
I’m able to lead technological projects from conception to implementation, proposing monitoring tasks, key performance indicators and continuous improvement strategies, in order to ensure business continuity and information security. I’ve used agile methodologies like scrum with Kanban dashboards and I master software development life cycle and software architecture.
When I was at the University, I grew up with the internet evolution, I had to resolve the early issues related with the first versions of html, css and the browsers war. I am able to understand all the concepts, scope and How this technology changed the world, I’m really an Internet technologies specialist.
I’m good using Windows, Linux and Unix, I lived the evolution of the operating systems, also I have worked with virtual environments using different service models used by the large-scale cloud computing like IaaS, PaaS and SaaS , (Azure, AWS & GCP).
I have been taken the Cisco CCNA courses and I’m good with Routing and Switching tasks, with specialization in VoIP technologies.
As an Electronic Systems Engineer, I know the fundamentals of the digital systems, I can code in assembly language, program microcontrollers and microprocessors. I have a strong knowledge of math, physics and statistics.
Cooperative spirit and mutual respect.
I enjoy to play an active part in the projects. I don't sit around and wait..
I can manage situations and people, and have the ability to make decisions.
Using analytical and creative thinking to find solutions, most of the times applying technological tools.
Now, I’m learning Game Development in Zenva Academy and I’m in the middle of a Data Science Training in Udemy & Coursera. I want to become a Data Scientist this year. (I expend around 8 hours a week to my online education). Also, I'll hope to finish my IoT project.
This is my education path. You can follow their most important points.
Master of Education (M.Ed.) in Educational Management degree
A Master's Degree in Education can allow a person to teach in the subject area of their choice, become a principal or administrator. (Titulation process)
Develop the necessary skills that allow you to improve your performance as professional negotiators, for the management and resolution of disagreements, in their negotiation processes; in order to enhance their communication processes, emotion management and strategies, in their interaction with others, seeking to generate the best alternatives in the negotiations they carry out.
Train the Trainer (Qlik Sense Specialization)
Train the Trainer is a face–to–face course for experienced Qlik Sense professionals. Participants develop the knowledge and skills they need to train the future Qlik Sense trainers working in te company.
Employee Development Plan
A comprehensive e-learning program
Game Development using HTML5 y Quintus
HP ATA – Connected Devices
Certification (Designing & Deploying Connected Device Solutions)
CCNA Routing and Switching v5
online education platform
Certificación MOS (Microsoft Office Specialist)
Java Programming Language, Java SE 6 (SL-275-SE6) (1 month)
ORACLE CERTIFIED PROFESSIONAL JAVA PROGRAMMER
The Java Programming Language course provides students with information about the syntax of the Java programming language; object-oriented programming with the Java programming language; creating graphical user interfaces (GUIs), exceptions, file input/output (I/O), and threads; and networking. Programmers familiar with object-oriented concepts can learn how to develop Java applications.
Fundamentals of the Java Programming Language, Java SE 6 (SL-110-SE6) (50 hours)
ORACLE CERTIFIED PROFESSIONAL JAVA PROGRAMMER
This course is also appropriate for novice programmers and those programmers who prefer to start learning the Java programming language at an introductory level.
Electronic Systems Engineer
Strong mathematical background with application in computer science and digital electronics.
This is my career path. You can follow their most important points.
New Products Financial Specialist at Sales & Marketing, Product & Financial Controlling
A kind of Business Data Analyst that works with associated financial departments such as Incentives, Volumes, Sales Contribution, Financial Services, Vehicle Parts and Fixed Costs as also with Marketing and Product areas, in order to analyze and support financial decisions as well as their impacts in the market and within the company. Responsible to participate in the local Product Committees providing sensitive information to senior management and board of directors from financial point of view. Also, I provide financial analyses to Global Product committees, and to the Group Executive Council, in order to achieve the approbation of new vehicles or new strategies for Mexico.
Understand and implement pricing and net pricing strategies based on FCA and Competitors actions. Supporting the creation of competitive analysis and looking for pricing opportunities and providing information to the monthly pricing analysis for all FCA brands.
Build the financial analysis and track the new products since the preliminary costs, (Material Cost, Transportation, Homologation, Warranty, Floor Plan, etc.) until their launching in order to get the best estimation of the total variable cost and providing variable margins for all FCA brands. In some cases, is required to include fixed costs, markups and other assumptions, to get a global analysis of the vehicle. After that, a validation of the production and manufacturing costs is needed, and finally in the invoicing process, is required an additional analysis, in order to identify the potential cost variances.
Credit & Collections Coordinator at Treasury
A kind of Business Data Analyst, responsible of the units’ allocation process to the dealers, monitoring their available credit line, to avoid any potential issue related with the payment, in order to ensure the cash flow. I was in charge of consolidate and validate the corporative reports that show the health of accounts of the company, through the aging report and the correct alignment between Niagara and PSAP accounts. Contributing to the periodic reporting process and the development of consolidated business intelligence reports in order to automate the main transactional activities of the position.
Business Data Analyst at ICT Department
I was in charge of developing and managing BI projects (Design, Develop & Implementation) to provide a vertical bridge through the business and the available data, to communicate information of high value to support decision making demands for Finance and Marketing areas. And search for patterns, trends and inconsistencies in the information to audit and validate some processes.
I collaborated with business users, analyze business processes and requirements to create and maintain documentation including requirements through Business Requirements Documents (BRD). Designed and developed BI dashboards and scorecards, and generate some digital publications, through the Data Storytelling tool of Qlik Sense. Also, I provided reports, processes and Excel VBA applications.
I coordinated activities with US BI Team, in order to in order to accomplish the objectives of the area: access, infrastructure, documentation, global processes, training, technology alignment, incidents, requests and proofs of concept. All the communications written and oral, were in English. Responsible to create new reports as required and to automate the production of reports currently manually produced.
Main projects implemented:
Web Developer & Business Data Analyst
Set up new business initiatives through internet.
Data Mining, ETL, Excel VBA, Tableu and Qlik View.
Technology Supervisor & Business Data Analyst
Teacher & Freelance Web Developer
VoIP Network Engineer & Software Developer
Routing & Networking
“Whether you want to uncover the secrets of the universe, or you just want to pursue a career in the 21st century, basic computer programming is an essential skill to learn.”
I am mostly Business Data Analyst but familiar with commonly used frontend & backend techniques. I try to provide very high code standards and I pay attention to details to provide a great user experience.
Here, you will find code examples, tutorials and some videos about the wonderful world of coding.
It's all about data, in this section you will find a lot of stuff related with machine learning, data science, business intelligence and analytics.
I'll show you some tips, some examples and how to do it by yourself.
If you want to contact with me you can send me a message through the contact form below.