Badges
Certifications
Work Experience
Data Engineer
Dycom• June 2019 - Present
• Develop Power BI reports for different business units, subsidiaries, mid-management, & upper management. • Assist Business Analyst in gathering requirements including repot draft(s), business logic, data sources, and the entity relationships between tables. • Administer and publish Power BI reports to the cloud, set up refresh schedules, and user provisioning. • Inform Data Architecture of new drivers and/or connectors to install to connect to current or new data sources • Demo new Power BI applications throughout the organization by explaining the purpose of development for specific/numerous reports. • Back up scripts, reports and dashboards to github for disaster recovery.
Senior Data Analyst
TherapeuticsMD• January 2019 - May 2019
• Developed SQL Server and Snowflake views for Tableau reporting. • Utilized SSIS to create a single package which pulled data from an SFTP location to our current file system and then to a table in SQL Server. • Leveraged Alteryx dynamic workflows for marketing surveys. • Quality checked data from the staging to the production environment. • Document SSIS packages importing and exporting processes. • Distribute weekly and monthly product updates to senior leadership and mid-level managers.
Data Analyst
Otis Elevator• December 2016 - January 2019
Sales Data Analyst
Healthplan Services• September 2015 - September 2016
Education
Northwestern University
Data Science, MS• January 2018 - Present
Nova Southeastern University
Business Administration, MBA• August 2013 - December 2015
Master in Business Administration with a CC in Business Intelligence & Analytics
University of South Florida
Business Economics, BS• January 2008 - May 2010
Links
Skills
gusjguedes has not updated skills details yet.