Hilton Rodriguez Email and Phone Number

Lead team of 3 direct reports to conceptualize innovative product solutions to complex business problems.Lead the building of a range of products & services that could include responsive digital apps, APIs, and data solutions to drive digital transformation projects. Lead and drive the Digital Product and Services functions end-to-end (establish culture, establish sustainable pace for team's work, maintain pipeline of products and projects, ensure on-time and on-budget delivery of product and projects, partner with Design, Engineering, and Architect teams and provide weekly status reports).Communicate with business stakeholders and sponsors in order to successfully build and launch products.Coach product teams and leadership on how to instill and sustain product thinking for high value delivery.

Designed, developed, tested and implemented database solutions related to optimal data pipeline architecture and infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL Server, Oracle, Sales Force and Big Data technologies.Developed, constructed, tested and maintained NGSE commercial and customer data layers to enable modelingCollaborated with and enabled data scientists on the team to rapidly iterate on model building and deploymentAssisted in data quality, integrity, and documentation efforts in support of data governance initiativesAutomated processes that increase productivity for the NGSE teamDeveloped and implemented controls to ensure data integrity and regulatory compliance (SOX).Packaged and supported deployment of releases of new code within our Azure environment.Drove innovation within the group in areas including development efficiencies within Databricks, and leading-edge industry concepts and developments.Mentored and guided other team members on data engineering skill-setsMonitored the production schedule and provided support to remediate job failures.Provided support to team members when they need a solution to a complex issue.Provided production support to business users.Administered the Tableau environments.

Administered the daily data loads from multiple systems (SQL Server, Oracle, Salesforce, Azure) into our Business Analytics environment using Alteryx.Administered all of Tableau Server environments including Tableau Online for external client reporting.Installed and implemented ThoughtSpot as a Proof of Concept application to complement our reporting tool.Developed Python programs to connect to Tableau’s REST API’s to gather metadata information.Developed Python programs to connect to other API’s including Salesforce Market Cloud and Qualtrics.Developed a program to migrate Tableau dashboards from UAT to Production, reducing the time it takes to migrate a dashboard from 15 minutes to less than a minute.Improved the data load processes by transferring all the Alteryx Workflows into an Azure VM environment.Ensured the success of the team by becoming the main point of contact for all data related questions.

Developed user friendly dashboards for all user levels and multiple business units.Developed Python programs to connect to multiple REST API’s to gather data for reporting.Improved processes within the team to automate data gathering.Developed Alteryx workflows to load data into our reporting environment.Utilized Python and Tableau’s TabCmd to automate the subscription of dashboards.Managed consultant for an external reporting portal project

Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.Design, code, test, and document all new or modified BI systems, applications, and programs.Develop the semantic layer, metadata, reports, and report definitions.Analyze user requirements and, based on findings, design functional specifications for BI front-end applications.Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary.Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts.Identify areas of opportunity for automation that eliminate manual steps and independently propose alternative process improvements, enhancements or additional products.Develop applications to automate administrative related processes: migrations, project back-ups and new user access.

Maintained all business intelligence applications (MicroStrategy and Cognos)Implemented company-wide security model within MicroStrategy and maintained all user access and security.Designed, developed, implemented and tested logical and physical data models and warehouse architecture utilizing MicroStrategy, Cognos, Netezza and SQL Server.Managed all installations and upgrades of the Business Intelligence applications.

Developed business intelligence solutions utilizing Cognos and MicroStrategy.Developed Data Warehouses in MS SQL, Oracle and Sybase.Created user applications using java, .Net and Flex.

Created Data Warehouse in a MS SQL 2005 database and developed business model utilizing MicroStrategy 8.Developed front-end application using Flex and .Net for the Web Service.