Nicolas Hurtado, Database Developer in Philadelphia, PA, United States
Nicolas Hurtado

Database Developer in Philadelphia, PA, United States

Member since September 7, 2022
Nicolas is a BI and data professional with over six years of expertise in Power BI, Tableau, SQL Server, and Azure. Having significant knowledge as a trusted advisor, Nicolas works with customers to provide BI and analytics solutions that meet critical business needs. He worked in various industries and business units, from Financial Planning and Analysis (FP&A) to sales, operations, and IT in the pharma, retail, eCommerce, mortgage, telecommunications, and chemicals industries.
Nicolas is now available for hire

Portfolio

  • Eliassen Group
    Microsoft Power BI, SQL Server 2017, Azure SQL, Azure Synapse, Azure DevOps...
  • Holts Cigar
    SQL Server 2017, Microsoft Power BI, DAX, Power Query, Analytics, Azure SQL...
  • COMSORT
    Tableau, Spotfire, Teradata, Oracle, Excel 365, Data Visualization...

Experience

Location

Philadelphia, PA, United States

Availability

Part-time

Preferred Environment

Microsoft Power BI, Azure SQL, Azure Synapse, SQL Server 2017, Oracle, R, RStudio, Python, Jupyter Notebook, Tableau, Business Intelligence (BI), Data Analysis Consultant, Business Intelligence Consultant, Data Analyst, Microsoft SQL Server, Dashboards, BI Reports, Reports

The most amazing...

...project I've done is an information services dashboard for executive reporting. Built KPIs, resulting in leadership creating adjustable data-driven goals.

Employment

  • Senior IT Associate Consultant

    2020 - PRESENT
    Eliassen Group
    • Built an information services (IS) dashboard for executive and director reporting. Designed key performance indicators (KPIs) for five department areas, resulting in leadership creating data-driven goals for each quarter and fiscal year.
    • Created reusable Python PySpark Notebooks that allowed for collecting API data into an Azure Synapse SQL table, allowing for Power BI reporting on an automated basis for various reporting needs and use cases.
    • Led new analysts into the organization by providing mentorship, training, and support throughout their onboarding process and ongoing.
    Technologies: Microsoft Power BI, SQL Server 2017, Azure SQL, Azure Synapse, Azure DevOps, Power Query, Jupyter Notebook, PySpark, Data Visualization, Excel 2013, Microsoft Excel, Dimensional Modeling, MySQL, Azure, Business Intelligence (BI), Data Analytics, Data Analysis Consultant, Business Intelligence Consultant, APIs, Data Analyst, Microsoft SQL Server, Dashboards, BI Reports, Reports
  • SQL Developer and BI Analyst

    2018 - 2020
    Holts Cigar
    • Created, maintained, updated, and oversaw more than 85 reports within the Power BI Service platform in the company, divided into seven workbooks with different permissions and over 150 SSRS reports and subscriptions.
    • Developed SQL queries and T-SQL stored procedures on our data warehouse and reporting server to generate required data points and calculations for Power BI and SSRS reports.
    • Met with business leaders within the company, gathered reporting requirements for each project, and developed, prototyped, tested, and deployed reports according to business needs.
    Technologies: SQL Server 2017, Microsoft Power BI, DAX, Power Query, Analytics, Azure SQL, RStudio, R, Data Visualization, Excel 2013, Microsoft Excel, Dimensional Modeling, Business Intelligence (BI), Data Analytics, Data Analysis Consultant, Business Intelligence Consultant, APIs, Data Analyst, Microsoft SQL Server, Dashboards, BI Reports, Reports
  • Data Analyst

    2017 - 2017
    COMSORT
    • Updated existing dashboard reports from Excel and PowerPoint into BI Tableau and Spotfire reports.
    • Maintained new reports according to changing business needs and updated goals and trends for emerging pharmaceuticals.
    • Synchronized with Tableau and Spotfire to create various BI reports for needs across the brands I support.
    Technologies: Tableau, Spotfire, Teradata, Oracle, Excel 365, Data Visualization, Excel 2013, Microsoft Excel, Dimensional Modeling, Business Intelligence (BI), Data Analytics, Data Analysis Consultant, Business Intelligence Consultant, APIs, Data Analyst, Microsoft SQL Server, Dashboards, BI Reports, Reports
  • Business Intelligence Analyst

    2016 - 2017
    New Penn Financial, LLC
    • Generated, updated, and maintained 320 reports in the Tableau server on a proactive and requested basis, depending on business needs.
    • Developed SQL queries to generate required data points and calculations.
    • Led and managed business process change projects that calculated how the company measured revenue, ultimately reducing the department’s margin of error compared to the numbers booked by accounting.
    Technologies: Microsoft Power BI, SAS, SQL Server 2015, Jira, Tableau, Excel 365, Data Visualization, Excel 2013, Microsoft Excel, Business Intelligence (BI), Data Analytics, Data Analysis Consultant, Business Intelligence Consultant, APIs, Data Analyst, Microsoft SQL Server, Dashboards, BI Reports, Reports

Experience

  • Information Services (IS) Dashboard

    Problem
    The client, a telecommunications research and development (R&D) organization, needed an executive and director-level dashboard for all areas of the information services (IS) business unit.

    Solution
    I collected requirements from all IS leadership regarding reporting for business areas, including cybersecurity, operations, talent investment, IS financials, project management, and FP&A.

    I collaborated with various teams to find existing data sources or build datasets for reporting. Built automated Power BI reports according to requirements, designed KPIs to help create data-driven goals for each area of interest, and tested and deployed the BI solution.

    Result
    The project brought visibility to critical components of the business, which increased demand for business intelligence solutions from other business units. I assisted the client with creating an internal data team, establishing processes, and providing leadership and mentorship until the end of the project.

  • Automation of Excel Reports

    Worked on a project with a fortune 500 chemicals company that went through a recent merger involving the automation of inventory analysis reports maintained in Excel.

    Stakeholders used to log into a reporting system where they could select datasets and extract columns and metrics as a CSV file; from there, they would bring this data into Excel and perform manual calculations and lookups to create their desired charts. They used to spend hours each month updating these reports.

    They explained the process to me, and I found the database and tables associated with the reporting system and created some SQL queries to pull the raw data and perform some calculations. I was able to automate the analysis while adding some additional BI functionality like slicers, drill-downs, KPI cards, and indicators. Ultimately, the resulting product was a fully automated BI solution that allowed the team to track their inventory management data in real time rather than retroactively at the end of every month. There was no need for manual updates besides additional analysis or enhancements.

Skills

  • Tools

    Microsoft Power BI, Power Query, Excel 2013, Microsoft Excel, Tableau, Spotfire, Jira
  • Paradigms

    Business Intelligence (BI), Azure DevOps, Dimensional Modeling
  • Other

    DAX, Data Visualization, Business Intelligence Consultant, Dashboards, BI Reports, Reports, Azure Synapse, Excel 365, SQL Server 2015, Data Analytics, Data Analysis Consultant, Data Analyst, Analytics, Econometrics, Economics, Macroeconomics, Microeconomics, Statistics, Calculus, Data Analysis, APIs
  • Languages

    SQL, R, Python, SAS
  • Platforms

    Azure, Oracle, RStudio, Jupyter Notebook
  • Storage

    Azure SQL, SQL Server 2017, MySQL, Microsoft SQL Server, Teradata
  • Libraries/APIs

    PySpark

Education

  • Bachelor's Degree in Economics
    2011 - 2016
    Temple University - Philadelphia, PA, USA

Certifications

  • Microsoft Certified Professional
    OCTOBER 2021 - PRESENT
    Microsoft
  • Microsoft Certified Solution Developer
    JULY 2020 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others