Loading

RaulGarciaMx

Personal Portfolio

#AllAboutData

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).

About me

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.

I learned to code when I was at High School, my first code lines were in Basic, Pascal and Cobol, using as a database, Dbase. I know several programming languages and frameworks like, C++, Visual Basic, VBA, Perl, PHP, Java, Javascript, Python, Laravel, CSS, Soap, HTML, Vue.js, Mysql, SQL, Phpunit, composer, anaconda, ruby and I’m begging with (Go, Angular, Node.js, and MongoDB).

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.

Profile image

Collaborative Work

Cooperative spirit and mutual respect.

Initiative

I enjoy to play an active part in the projects. I don't sit around and wait..

Leadership

I can manage situations and people, and have the ability to make decisions.

Problem-Solving

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.

Education

This is my education path. You can follow their most important points.

Education

+
Dec 2019

Universidad Digital del Estado de México / ETAC

Master of Education (M.Ed.) in Educational Management degree

Company

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)

+
Oct 2019

Universidad Iberoamerica

Negotiation

Company

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.

+
Sep 2018

Chrysler Technical Center (CTC), Auburn Hills, Detroit, Michigan

Train the Trainer (Qlik Sense Specialization)

Company

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.

+
2016 -2017

FCA

Employee Development Plan

Company

  • Finance Fundamentals
  • Fundamentals of Business Analysis (BABOK)
  • Qlik Sense Workshops Basic & Advanced
  • Fundamentals of Adobe Analytics
  • Fundamentals of Project Management (PMBOK)
  • +
    2016 -2017

    Cisco Networking Academy Program

    A comprehensive e-learning program

    Company

  • Mobility Fundamentals Series: Wireless Technology and Standards
  • Webinar Series: IoE and Security
  • Introduction to Cybersecurity
  • Introduction to the Internet of Everything
  • Entrepreneurship
  • +
    2016

    Zenva Academy

    Game Development using HTML5 y Quintus

    Company

    Learn to create vide games using the Quintus HTML5 game framework, which is a lightweight yet powerful JavaScript library used to create professional 2D games.

    +
    2015

    Tecnológico de Estudios Superiores de Coacalco, Coacalco, México

    HP ATA – Connected Devices

    Company

    Certification (Designing & Deploying Connected Device Solutions)

    +
    2015

    Instituto Tecnológico de Toluca, Metepec, México

    CCNA Routing and Switching v5

    Company

  • CCNA Routing and Switching v5: I. Introduction to Networks (42 hours).
  • CCNA Routing and Switching v5: II. Routing and Switching Essentials (42 hours).
  • CCNA Routing and Switching v5: III. Scaling Networks (42 hours).
  • CCNA Routing and Switching v5: IV. Connecting Networks (42 hours).
  • +
    2014 -2015

    Platzi

    online education platform

    Company

  • Laravel
  • Javascript and Jquery
  • Python
  • Git & GitHub
  • UX
  • +
    2014 -2015

    Universidad Tecnológica del Valle de Toluca, Lerma, México.

    Certificación MOS (Microsoft Office Specialist)

    Company

  • Microsoft Excel 2010
  • Microsoft PowerPoint 2010
  • +
    2009 -2010

    Universidad Tec Milenio, Metepec, México

    Java Programming Language, Java SE 6 (SL-275-SE6) (1 month)

    Company

    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.

    +
    2009 -2010

    Universidad Tec Milenio, Metepec, México

    Fundamentals of the Java Programming Language, Java SE 6 (SL-110-SE6) (50 hours)

    Company

    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.

    +
    2000 - 2003

    ITESM Toluca & Monterrey

    Others

    Company

  • Robotic Workshop using Basic Stamp Microcontrollers. (20 hours)
  • SIEMENS and Technische Universitaet Muenchen:
            SummerSchool 2002 “The future of Automation” (16 days)
  • Programmable Logic Controllers Course (16 hours)
  • Cisco Networking Academy Program CCNA v2.0 I, II, III y IV.
  • +
    1998 - 2003

    ITESM Toluca

    Electronic Systems Engineer

    Company

    Strong mathematical background with application in computer science and digital electronics.

    Career

    This is my career path. You can follow their most important points.

    Career

    +
    Jun 2018 - now

    FCA Chrysler Mexico | Santa Fé

    New Products Financial Specialist at Sales & Marketing, Product & Financial Controlling

    Company

    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.

    Achievements:

  • Process Improvement, Crystal awards 2016, 2018, 2019 (Winner).
  • Train the trainer initiative, Crystal awards 2018 (Winner).
  • Automation of the Competitive Pricing report (Daily process).
  • Creation of the Free and Mandatory options rate report.
  • Cost Opportunities: Cost Configuration Calculator (New Vehicles).
  • MSRP Positioning.
  • Job1, PCS1 and STV analysis.
  • Working Capital Template (Parts and Vehicles)
  • Collaboration in the Business Cases process automation (Six Panel, NPV and Sensitivity Matrixes)
  • Weekly and Monthly report improvement.

  • Technologies: Excel, Knime, Qlik Sense, Di-Diver (Dimensional Insight’s Diver Platform), VBA, BlueZone, MainFrame DB2, javasript.

    +
    Feb 2017 - Jun 2018

    FCA Chrysler Mexico | Santa Fé

    Credit & Collections Coordinator at Treasury

    Company

    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.

    Main activities:

  • Daily closed credit line report.
  • Generation of the wholesale inventory forecast.
  • Advanced invoicing process for the last day of the month.
  • Dealers Network credit line management.
  • Management of the Vehicles assignments.
  • Follow up of the dealers’ network invoicing.
  • Create local and corporative (US & Italy) reports.
  • Credit Committee Package (Monthly).
  • Credit Risk (Quarterly).
  • Reconciliation of PSAP and Niagara Accounts.
  • Calculate and verify special incomes.
  • Verify & calculate Revenue share for retail sales.
  • FCA Financials portfolio
  • Active participation in the wholesale process.

  • Achievements:
    The automation of two critical process of the position:
  • The process to close and release dealers credit line. (from 3 hours to 1 hour. Daily process).
  • The revenue share validation (Retail sales). (from 8 hours to 2 hours. Monthly process).

  • Technologies: Excel, Qlik Sense, Di-Diver (Dimensional Insight’s Diver Platform), VBA, BlueZone, MainFrame DB2, JavaScript.

    +
    Jan 2017 - Feb 2018

    FCA Chrysler Mexico | Santa Fé

    Business Data Analyst at ICT Department

    Company

    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:

  • BWS Calculation.
  • Auditor report.
  • Variation in use report.
  • Reconciliation of Finished Vehicles.
  • Revenue Share validation.
  • Report JEU1 for export units.
  • FIAT Balanced Scorecard
  • Monthly WoW Report for Alfa Romeo
  • FCA financials’ reports: daily data feed, portfolio reports, demographic data reports, applications and contracts status and key performance indicators for dealers’ network
  • Others: Slow moving, Stock status and Digital Marketing Dashboard

  • Technologies: Excel, Qlik View, Qlik Sense, Di-Diver (Dimensional Insight’s Diver Platform), VBA, BlueZone, MainFrame DB2, Google Analytics and Adobe Analytics.

    Methodologies:
  • SCRUM, KANBAN, USER STORIES, CRISP-DM, BABOK and PMBOK
  • +
    Jan 2014 - Dec 2015

    iFactory | Metepec, Mexico

    Web Developer & Business Data Analyst

    Company

    Set up new business initiatives through internet.
    Data Mining, ETL, Excel VBA, Tableu and Qlik View.

  • House of representatives
  • The senate
  • Official Federal Gazette

  • MySQL, PHP, Laravel and Web Services (NuSoaP).
  • PSV Legislative Monitoring.
  • Callejas Legislative Monitoring.
  • OpenIOT System
  • iPolitica
  • AgroWeb
  • IBCity
  • GeekSchool
  • DeitaFactory
  • +
    Jan 2011 - Dec 2013

    Legix SA de CV | Mexico City

    Technology Supervisor & Business Data Analyst

    Company


    Technology Supervisor

  • I was in charge of the IT department and the technological infrastructure.
  • Management of technological resources and suppliers. (Management)
  • Ensure business continuity. (Politics, processes and documentation)
  • I was in charge of the development team; I coordinate the web site and the web tools development. (Team Leader)
  • Solve the internal needs of the company, defining and implementing systems that automated the internal processes, standardizing activities and establishing policies, which allowed us to increase our productivity and identifying performance indicators.

  • Business Data Analyst
  • Create presentations and demonstrations of the legislative services, analyzing the themes, that could be important from the Senate and the House of Representatives.
  • Definition of processes related to the extraction, transformation, protection and delivery of digital information through different channels.
  • Creation of Qlik View Dashboards related to legislative monitoring, in order to follow the initiatives evolution until its publication in the DOF (Diario Oficial de la Federación).
  • Design, development and delivery of the digital publications.
  • Analysis the web statistics in order to improve the performance of the web page.
  • Design and planning of the technical aspects of new Information products and services.

  • Customized reports and dashboards from the following public data sources:
  • House of representatives
  • The senate
  • Official Federal Gazette
  • State governments of Mexico
  • Secretaries of the Mexican State
  • Legislative commissions
  • Lobbying

  • Technologies: Qlik View, VBA Excel, MySQL Queries, php parsing scripts, html, css and Javascript

    +
    Sep 2008 - Dec 2010

    Freelance / Tec Milenio / IUEM / UTVT | Toluca, Mexico

    Teacher & Freelance Web Developer

    Company

    As a Freelance, I developed 7 different Web Systems for different purposes, elearning, real state, sports league, clinic management, etc. based in PHP & MYSQL using CSS, HTML and Javascript.

  • Web Application Development | Software Development | Operating systems
  • Networking Basics | Cisco Networking
  • Information Security | IT audit | IT Project Management
  • Software Engineering | Control Engineering | Digital Control
  • Introduction to MATLAB | Java development | Numerical methods
  • Telecommunications Applications "Introduction to the Internet of Things" (Arduino, PHP and Python)
  • Introduction to Business Intelligence (Qlik View, Qlik Sense, Tableau)
  • Web Application Development. (Laravel, Python, NuSOAP, JavaScript, HTML, CSS and MySQL)
  • Project Management. (PMBOK)
  • +
    Mar 2004 - Sep 2008

    iLabs Solutions (IXNS) | Toluca Mexico

    VoIP Network Engineer & Software Developer

    Company

    Routing & Networking

  • Experience with Cisco routers and switches.
  • Install and upgrade networking Cisco equipment.
  • Perform IOS upgrades.
  • Network Router and Switch Installations and Configuration.
  • Experience with all aspects of networking including IP, TCP, VPN, Routers and Firewalls.

  • VoIP
  • Experience with VoIP protocols SIP, RTP, RTCP, UDP, SS7, SDP and voice codecs G.711 (A Law and Mu Law), G.729, G.723.1
  • Ability to analyze, use, and configure VoIP networks.
  • Detailed knowledge of the SS7 and SIP protocol stack and the requirements for a carrier-grade VoIP platform.
  • Experience on Cisco Routing & Switching, LAN/WAN design, Carrier, PSTN Services.
  • Experience on Cisco Voice Infrastructure.
  • Experience on Cisco Soft switches, BTS 10200 and PGW 2200.
  • Basic experience provisioning Cisco Call Manager Express.
  • Configure and troubleshoot VOIP gateways, Session Border Controllers, and other VOIP processing equipment.
  • Perform interoperability testing with VOIP vendors.
  • Significant experience in VoIP and network environment.
  • Solid experience with switching platforms, knowledge of PBX features including Asterisk.
  • VOIP & SIP messaging knowledge.

  • Monitoring and Troubleshooting
  • Monitor and test network performance and provide network performance statistics and reports.
  • Troubleshooting network issues.
  • Interface to the vendor for problem analysis, tracking and problem solving.

  • Software Development of real-time applications
  • Development and implementation of a Linux-based IVR using SIP protocol.
  • Development of a Web-based interface to configure Cisco devices like PGW and SPS.
  • Development of a Web-based interface to configure Asterisk PBX.

  • Operating Systems
  • Proficient with Linux and Unix Server Administration.

  • Project Management
  • Designing, planning and implementation of new projects.
  • Good organizational, project management and planning skills.

  • International Experience:
  • SITEL - Lima, Peru: Providing Training and Technical Assistance.
  • Management and Operations of Cisco PWG 2200 (Cisco Transit Solution)
  • Strengths

    “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.”

    Stephen Hawking

    Business Data Analyst

    Excelent

    Web Developer

    Very Good

    Voip Network Engineer

    Good

    IT/IoT solution architect

    Good

    Data Scientist

    Good

    Skills

    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.

    95%

    PHP

    85%

    JavaScript / Jquery

    85%

    Python

    80%

    Java

    80%

    HTML + CSS

    80%

    MySQL

    50%

    Vue.js

    40%

    Angular

    40%

    Node.js

    80%

    R

    95%

    Qlik Sense/View

    95%

    VBA

    90%

    Matlab

    80%

    Power BI

    80%

    Arduino

    To see my code in practice, please visit my github account

    There you can find my jQuery plugins, games, templates, widgets, websites.

    See my github account

    Coming Soon

    Send me a message

    If you want to contact with me you can send me a message through the contact form below.