Jay Fernandez Email & Phone Number

Austin, Tx, Us

Austin, Tx, Us

Palo Alto, California, Us

- Take inventory of all data pipelines, products, and processes supporting the business.- Define the project plan and scope for the migration of data integrations from legacy data infrastructure to new cloud infrastructure by outlining the tasks that reflect the effort for the migration.- Work with the business to identify enterprise tools that will be procured and that will need to be supported by the worker master data management system.- Augment worker master data management system to support account provisioning for new enterprise applications. Synchronizing data across all enterprise applications for members of the security business unit.- Assist in the development of Data lake, focusing on the development of data integrations using cloud infrastructure and python scripting.- Work with the business to design and develop a Services Insight Tableau application that compares services data to account characteristics by combining customer-facing data from various customer experience teams. Allowing the services teams to better understand how service engagements may impact renewals and product adoption.- Worked with the business to design and develop a Product consumption Tableau application that looked at product telemetry and customer licenses data. The application provided insights on customer licensing, product and services adoption.- Migrate, optimize and maintain data integration jobs across Enterprise Applications- Design, develop and maintain AWS Glue ELT data pipelines.- Diagnose and resolve performance issues across data pipelines, processes and systems.- Monitor ELT jobs and ensure reliability and accuracy remains high.- Maintain and developed source code and follow CI/CD process for deployments

Palo Alto, Ca, Us

- Define the project plan and scope for the migration of data integrations from legacy systems to new infrastructure by outlining the tasks that reflect the effort for the migration.- Augment the worker master data management system to support account provisioning for third party applications. Synchronizing data across all third applications for members of the security business unit.- Assist in the development of an Operational Data Store. Primarily focusing on the development of data integrations using python.- Consolidated customer and case support analytics applications into a single application to facilitate migration to newer infrastructure. This effort provides the Support, Customer Success, and Engineering teams access to valuable analytics.-Develop and maintain our internal Worker Master Data Management system which synchronizes worker data across many different systems.-Develop and maintain Data Integration jobs across Enterprise Applications.-Design, Develop and Maintain SQL Server ETL Jobs.-Design, plan, and develop programs to optimally extract, transform and load data between data sources.-Diagnose and resolve database performance issues.-Optimize and Tune ETL Jobs as well as DB Views, Stored Procedures and Functions.-Monitor ETL Jobs and ensure that reliability and accuracy remains high.-Maintain developed source code in the repository for all databases and keep all build programs up to date

Palo Alto, California, Us

-Develop and maintain our internal Worker Master Data Management system which synchronizes worker data across many different systems.-Develop and maintain Data Integration jobs across Enterprise Applications.-Design, Develop and Maintain SQL Server ETL Jobs.-Design, plan, and develop programs to optimally extract, transform and load data between data sources.-Diagnose and resolve database performance issues.-Optimize and Tune ETL Jobs as well as DB Views, Stored Procedures and Functions.-Monitor ETL Jobs and ensure that reliability and accuracy remains high.-Maintain developed source code in the repository for all databases and keep all build programs up to date

Bedford, Ma, Us

- Create and deploy BI reports- Tableau- Google Analytics Reporting- Working with ETL technologies such as SQL Server Integration Services (SSIS)- Working with OLAP tools such as Microsoft Analysis Services (SSAS)- Developing reports and dashboards on SQL Server Reporting Services (SSRS)-Developing reports and dashboards using SharePoint Dashboard designer - Write relational and multidimensional database queries - scripting using visual basic or C#- Debug, monitor, and troubleshoot deployed solutions

Responsibilities include direct care as well as development and implementation of individual support plans.

Information Systems

Education record