-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
160 lines (124 loc) · 8.75 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
<html lang="en-US">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Begin Jekyll SEO tag v2.6.1 -->
<title>Leopoldo Araujo | 💻📊🌎🌟</title>
<meta name="generator" content="Jekyll v3.9.0" />
<meta property="og:title" content="Leopoldo Araujo" />
<meta property="og:locale" content="en_US" />
<meta name="description" content="Leopoldo Araujo - CV" />
<meta property="og:description" content="Leopoldo Araujo - CV" />
<link rel="canonical" href="https://poloaraujo.github.io/cv/" />
<meta property="og:url" content="https://poloaraujo.github.io/cv/" />
<meta property="og:site_name" content="💻📊🌎🌟" />
<script type="application/ld+json">
{"@type":"WebSite","headline":"Leopoldo Araujo","url":"https://poloaraujo.github.io/cv/","description":"Leopoldo Araujo - CV","name":"💻📊🌎🌟","@context":"https://schema.org"}</script>
<!-- End Jekyll SEO tag -->
<link rel="stylesheet" href="/cv/assets/css/style.css?v=e1205a83a041fc962f9fb58fe9aadce6321fa39d">
<!--[if lt IE 9]>
<script src="//cdnjs.cloudflare.com/ajax/libs/html5shiv/3.7.3/html5shiv.min.js"></script>
<![endif]-->
</head>
<body>
<div class="wrapper">
<header>
<h1><a href="https://poloaraujo.github.io/cv/">💻📊🌎🌟</a></h1>
<p>Leopoldo Araujo - CV</p>
<p class="view"><a href="https://github.com/poloaraujo/cv">View the Project on GitHub <small>poloaraujo/cv</small></a></p>
</header>
<section>
<h1 id="Leopoldo Araujo">Leopoldo Araujo</h1>
<p><em>SQL Developer & Data Analyst</em> <br />
<em></em></p>
<p><a href="mailto:[email protected]">Email</a> / <a href="https://www.linkedin.com/in/leopoldo-araujo-reyes/">LinkedIn</a> / <a href="https://twitter.com/Poloisms/">Twitter</a>
<h2 id="-technical-experience">👨💻 Technical Experience</h2>
<p><strong>BI Analyst</strong> @ <a>Freelance</a> <em>(May 2020 - Present)</em> <br /></p>
<ul>
<li>Developing specific data models to respond to business needs, enabling users to filter dynamically and drill down to details in the visuals.</li>
<li>Developed reports and dashboards to allow a cosmetics company to evaluate the performance of sales personnel through time in order to create training and motivation programs that will increase their performance.</li>
<li>Created a data model to enable an NGO to evaluate the results and achievements of institutional programs implemented in Mexico through time using established goals and indicators as parameters. I also automated the data extraction and transformation process, guaranteeing data integrity and quality.</li>
<ul>
<li><strong><em>Technologies used:</em></strong> Power BI</li>
<li><strong><em>Skills used:</em></strong> Data modeling, data visualization, data analysis, requirements gathering and documentation
<br /><br /></li>
</ul>
</ul>
<p><strong>SQL Developer</strong> @ <a href="https://www.ipointsystems.com/">Inflection Point Systems</a> <em>(Jan 2014 - Sept 2018)</em> <br />
Monterrey, Mexico</p>
<ul>
<li>Responsible for assessing and executing the migration of every report used by a financial company based in Massachusetts from Actuate to Microsoft SQL Server Reporting Services.</li>
<li>Set a new SSRS reporting infrastructure, making report requests more accessible for the users and increasing usability and demand by 56%.</li>
<li>Developed customized, detailed and dynamic SSRS reports as requested by users and in several Agile projects with teams across the US, the UK and India.</li>
<li>Enabled the financial company's stakeholders to make crucial financial decisions for their own clients with the relevant information in the reports.</li>
<li>Developed and updated MSSQL, Oracle and Sybase stored procedures and embedded queries that would result in relevant information for the reports.</li>
<li>Leveraged my teamwork skills to work with BAs and testers to gather requirements appropriately, ensuring every release met the stakeholders’ needs and expectations</li>
<li>Fully adapted to Scrum framework to work in Agile teams and projects.</li>
<li>Trained over 10 new developers on SSRS, the company's web reporting platform and proper technical support practices</li>
<li>Released reports into the report web platform, working closely with DBAs and Release Engineers to review stored procedures and embedded queries used by the reports before release to mitigate all issues.</li>
<li>As the main technical support for the financial company's web report platform, I consistently fixed 100% of the report issues within the same day as the ticket was created by the user.</li>
<li>Learned Crystal Reports to develop reports for a new trading system.</li>
<ul>
<li><strong><em>Technologies used:</em></strong> Microsoft SQL Server, Oracle, Sybase, SSRS, Crystal Reports, TFS, SSIS.</li>
<li><strong><em>Skills used:</em></strong> Report development, complex SQL querying, stored procedure development, SQL tuning, tech-support, Scrum, requirements gathering.
<br /><br /></li>
</ul>
</ul>
<p><strong>Data Analyst & SQL Developer</strong> @ <a href="https://tec.mx/en">ITESM</a> <em>(Jun 2013 - Dec 2013)</em> <br />
Monterrey, Mexico</p>
<ul>
<li>Learned Informatica PowerCenter to model ETL workflows. This allowed the BI team to develop insightful reports, which were used by various departments at the university to make crucial decisions regarding student enrollment and the development of programs and courses.</li>
<li>Wrote PL/SQL stored procedures for a migration from Microsoft SQL Server to Oracle, ensuring data consistency across all of the university’s platforms.</li>
<ul>
<li><strong><em>Technologies used:</em></strong> Microsoft SQL Server, Oracle, Sybase, SSRS, Crystal Reports, TFS, SSIS.</li>
<li><strong><em>Skills used:</em></strong> ETL, data manipulation, complex SQL querying, stored procedure development.
<br /><br /></li>
</ul>
</ul>
<p><strong>BPM Analyst & Developer</strong> @ <a href="http://tegik.com/">Tegik</a> <em>(May 2009 - Sep 2012)</em> <br />
Monterrey, Mexico</p>
<ul>
<li>Performed analysis, development and tests using Processmaker.</li>
<li>Successfully implemented a complete workflow automation for clients in the retail, oil and financial industries, replacing the clients’ manual processes.</li>
<li>Successfully trained users during the implementation phase of Openbravo ERP for a retail company, ensuring that users thoroughly adapted to the new processes outlined by the company to handle sales and inventory information.</li>
<ul>
<li><strong><em>Technologies used:</em></strong> Processmaker BPM, Openbravo ERP, PHP, JavaScript, HTML, MySQL.</li>
<li><strong><em>Skills used:</em></strong> Business process mapping and modeling, report development, requirements gathering, user training.
<br /><br /></li>
</ul>
</ul>
<h2 id="-technical-experience">👨🏫 Teaching Experience</h2>
<p><strong>Foreign Languages Teacher</strong> @ <a href="https://www.eumeia.com.tw/Espa%C3%B1ol.html">Eumeia</a> <em>(Nov 2018 - Sept 2019)</em> <br />
Taipei, Taiwan</p>
<ul>
<li>Worked as a teacher and examiner of Spanish, German and French to Chinese-speaking students.</li>
<li>Awarded a scholarship at the National Taiwan Normal University to study Mandarin.
<br /><br /></li>
</ul>
<h2 id="-certifications">📜 Certifications</h2>
<p><strong>Scrum Master Professional Certification</strong> @ <a href="https://certiprof.com/">CertiProf</a> <em>(Jun 2020)</em></p>
<p><strong>Scrum Fundamentals Certified</strong> @ <a href="https://www.scrumstudy.com/">SCRUMstudy</a> <em>(Aug 2017)</em></p>
<p><strong>COMING SOON: AWS Certified Developer - Associate</strong>
<br /><br /></p>
<h2 id="-education">🎓 Education</h2>
<p><strong>Bachelor of Science</strong> in Information Technology<br />
<a href="https://tec.mx/en">Instituto Tecnológico y de Estudios Superiores de Monterrey</a> - Monterrey, Nuevo León, Mexico <em>(2006 - 2010)</em>
<br /><br /></p>
<h2 id="-languages">🌐 Languages</h2>
<p><strong>English 🔴🔴🔴🔴🔴</strong></p>
<p><strong>Spanish 🔴🔴🔴🔴🔴</strong></p>
<p><strong>French 🔴🔴🔴🔴⭕</strong></p>
<p><strong>German 🔴🔴🔴🔴⭕</strong></p>
<p><strong>Russian 🔴🔴🔴⭕⭕</strong></p>
<p><strong>Chinese 🔴🔴⭕⭕⭕</strong></p>
<br /><br />
</section>
<footer>
<p>This project is maintained by <a href="https://github.com/poloaraujo">Leopoldo Araujo</a></p>
<p><small>Hosted on GitHub Pages — Theme by <a href="https://github.com/orderedlist">orderedlist</a></small></p>
</footer>
</div>
<script src="/cv/assets/js/scale.fix.js"></script>
</body>
</html>