César is available for hire
Hire CésarCésar Montaña
Verified Expert in Engineering
Software Developer
Thames, Waikato, New Zealand
Toptal member since May 4, 2021
Bio
César believes good data allows organizations to be ahead of the competition by creating baselines, benchmarks, and goals based on evidence. He's an SQL Server certified .NET developer with 15 years of experience designing and building strategic data platforms that host huge amounts of data, solving problems, and supporting performance issues for companies from all over the world. You can trust César to maintain your data and translate it into a usable form via models, reports, and dashboards.
Portfolio
Apata Group
Microsoft Power BI, SQL Server BI, APIs, Mapbox API, Data Visualization, DAX...
Horizon Energy Group
SQL Server BI, C#.NET, Microsoft Power BI, Data Visualization, DAX...
Vista Entertainment Solutions
C#.NET, SSAS Tabular, JSON, Azure SQL, Scrum, TFS, Git, DAX, Data Analysis, SQL
Experience
- SQL Server BI - 14 years
- SQL Server Integration Services (SSIS) - 14 years
- Business Intelligence (BI) - 14 years
- C#.NET - 13 years
- SQL Server Reporting Services (SSRS) - 8 years
- Microsoft Power BI - 6 years
- SQL Server Analysis Services (SSAS) - 5 years
- SSAS Tabular - 3 years
Preferred Environment
Windows
The most amazing...
...thing I've made is a metamodel and libraries in .NET capable of generating tabular models, views, documentation, and so on automatically in different languages.
Work Experience
BI Analyst
2021 - PRESENT
Apata Group
- Designed, developed, and supported Power BI dashboards and reports.
- Performed data modeling. Developed and supported SSAS models.
- Developed interface APIs to connect to different data sources.
Technologies: Microsoft Power BI, SQL Server BI, APIs, Mapbox API, Data Visualization, DAX, Data Analysis, SQL, Python
Systems and Integration Analyst
2020 - 2021
Horizon Energy Group
- Designed, developed, and supported Power BI dashboards, SSRS reports, SSAS tabular and multidimensional models, and SSIS ETLs.
- Designed, developed, and supported Web Forms applications and Microsoft Access applications.
- Executed DBA tasks like backup management, creation of tables, views, indexes, stored procedures, tunning, migrations, and many more.
Technologies: SQL Server BI, C#.NET, Microsoft Power BI, Data Visualization, DAX, Data Analysis, SQL
Software Developer
2018 - 2020
Vista Entertainment Solutions
- Modeled, developed, and deployed models to Azure of tabular SSAS with both DirectQuery and in-memory sources.
- Developed a metamodel and libraries in .NET capable to generate tabular models, views, analytic views, column store indexes, indexed views, and documentation of models.
- Designed and developed libraries for deploying models that had been translated to customers' languages.
Technologies: C#.NET, SSAS Tabular, JSON, Azure SQL, Scrum, TFS, Git, DAX, Data Analysis, SQL
Senior BI Developer
2017 - 2018
TEAM International
- Designed, developed, and deployed ETLs, reports, stored procedures, and BI solutions according to client specifications in the Microsoft platform for Imerys USA.
- Designed and developed .NET (C#) and MVC applications with SQL Server and Telerik.
- Supported internal customers' requirements and requests.
Technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server BI, C#.NET, MVC Razor, Kendo UI, Data Analysis, SQL
BI Engineer Level II
2011 - 2017
Igerencia
- Designed a process that uses a user-given parametrization to automatically calculate complex operations among accounts.
- Led the design and development of a module that extends the functionality of Microsoft technology in order to manage the on-row security.
- Developed a tool that generates XML ETL code. This tool reduced about a month of development time to the team.
Technologies: Business Intelligence (BI), SQL Server BI, IIS, SSAS Tabular, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SAP HANA, SAP BusinessObjects Data Service (BODS), C#.NET, ASP.NET, Data Analysis, SQL
Junior Analyst
2011 - 2011
G2
- Designed and developed a data warehouse for market and customer analysis (SQL Server 2005, SSIS, SSAS, and SSRS).
- Generated reports for supporting market analysis operation tools (MySQL, PHP).
- Developed and supported Drupal functionalities and modules.
Technologies: SQL Server BI, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), PHP, MySQL, Drupal, Data Analysis, SQL
Master Student — Developer
2010 - 2011
Universidad Politécnica de Madrid
- Developed Java web services (REST) for Spanish and European research projects.
- Developed a test automation process in order to release new versions.
- Developed and researched on semantic web technologies (XML, XSLT, RDF, OWL, SPARQL, Jena, Virtuoso, and Protégé).
Technologies: Java, REST, XML, RDF, OWL, SPARQL, Jena Semantic Web Framework, OpenLink Virtuoso, Protégé, Data Analysis, SQL
Software, Database, and Business Intelligence Consultant
2009 - 2009
Ingenio Soluciones Informaticas Ltda
- Developed software for projects for various customers.
- Developed business intelligence projects for different clients.
- Managed, tuned, and supported databases for a range of customers.
Technologies: SQL Server BI, C#.NET, Data Analysis, SQL
Software and Database Developer | Consultant
2007 - 2009
Freelance
- Changed a Cinemark web application in Colombia by including Ajax which resulted in a dramatic improvement in performance.
- Created a queued system that received SMS notifications, processed them, and gave a quick reply.
- Supported and maintained web applications and improved the performance.
Technologies: PHP, SQL Server BI, C#.NET, Data Analysis, SQL
Software Developer
2006 - 2007
Mareigua
- Supported and developed a Webform application in C#.NET.
- Developed and supported SQL Server 2005 databases and obtained the certification.
- Analyzed requirements and created designs according to customer needs.
Technologies: ASP.NET, SQL Server BI, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#.NET, VB.NET, SQL
Professional Project Assistant
2005 - 2006
University of Andes — LIDIE Research Group
- Built virtual learning environments to support university courses.
- Developed a project web page with functionality for storing and consulting all the virtual learning environments.
- Gathered requirements and designed solutions according to professor needs.
Technologies: PHP, MySQL, SQL
Software Developer
2003 - 2005
University of Andes — Admissions Office
- Managed, supported, and developed on the Banner platform, which stores grades, courses, schedules, and more for the university.
- Developed the admissions office web page in PHP and PostgreSQL.
- Participated and developed the customer side of models in Cognos.
Technologies: PHP, PostgreSQL, Oracle, IBM Cognos, Banner, SQL
Experience
Data Warehouse for Vista Entertainment
I handled data modeling, development, and deployment to Azure of tabular SSAS with both DirectQuery and in-memory sources. I also developed a metamodel and libraries in .NET capable of automatically generating tabular models, views, analytic views, column store indexes, indexed views, and model documentation.
Education
2010 - 2013
Master's Degree in Artificial Intelligence
Polytechnic University of Madrid - Madrid, Spain
2003 - 2007
Master's Degree in Computer Engineering
University of Andes - Bogota, Colombia
1995 - 2002
Bachelor's Degree in Computer Science
University of Andes - Bogota, Colombia
Certifications
MAY 2020 - PRESENT
Data Analyst Associate
Microsoft
MAY 2014 - PRESENT
Certified Professional (MCP) SQL Server 2012
Microsoft
MARCH 2012 - PRESENT
Certified IT Professional (MCITP) SQL Server 2008
Microsoft
JANUARY 2007 - PRESENT
Microsoft Certified Technology Specialist SQL Server 2005
Microsoft
Skills
Libraries/APIs
Mapbox API
Tools
Microsoft Power BI, SQL Server BI, TFS, Git, OpenLink Virtuoso, Protégé, IBM Cognos, Banner
Languages
SQL, Java, C#.NET, PHP, XML, RDF, OWL, SPARQL, C, VB.NET, Python
Paradigms
Business Intelligence (BI), Scrum, REST
Storage
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SSAS Tabular, JSON, Azure SQL, MySQL, PostgreSQL
Frameworks
MVC Razor, Kendo UI, ASP.NET, Jena Semantic Web Framework
Platforms
Windows, SAP HANA, Drupal, Oracle
Other
Data Visualization, DAX, Data Analysis, Machine Learning, Computer Vision, Semantic Web, OData, IIS, SAP BusinessObjects Data Service (BODS), APIs
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring