Tableau And Alteryx Developer Resume
3.00/5 (Submit Your Rating)
SUMMARY
- Over 3 years of experience in Business Intelligence, data analysis, visualization using Tableau Desktop and Server, Matlab, Alteryx, Excel and SQL
- Strong background in Analysis, Design and Development in teh field on research, analytics, data analysis and visualization applications
- Extensive knowledge of Data Warehousing concepts, RDBMS, Star and Snowflake Schema and worked on both OLAP and OLTP databases.
- Proficient in writing complex SQL queries, scripts in Python & automating teh data pulling from multiple sources by creating Alteryx ETL workflows
TECHNICAL SKILLS
Data Analysis: Tableau Desktop and Server, SQL, ETL, Alteryx, Python, Data Studio, UML (Unified Modelling Language)
Databases: IBM Db2, Oracle 11g, MS SQL server
Digital Marketing: Google AdWords
Process Tools: Service NOW, Jira, Agile, Waterfall
Artifacts: Stakeholders requirements, use cases design, vision document, pre/post condition, business cases
PROFESSIONAL EXPERIENCE
Tableau and Alteryx Developer
Confidential
Responsibilities:
- Worked wif business stakeholders and participated in requirement gathering sessions to understand Client’s business needs.
- Developed dashboards for over 15 metrics such as CPC (Cost Per Click), Click Through Rate (CTR), Impressions, Clicks, Conversions, VTC etc
- Created Executive Scorecard dat provided insights on campaign performance for key metrics and KPI’s across business, region & devices
- Developed dashboards using Tableau to compare YTD, MTD, YoY, WoW performance and published teh same to Tableau Server for users
- Conducted unit testing of teh reports and responsible for teh migrating teh Tableau reports from development to user acceptance.
- Worked on developing training program, user guide for Tableau Dashboards and Tableau best practices.
- Converted various Excel and Power BI reports for client’s different business to Tableau dashboards
- Wrote SQL code wif multiple joins to pull teh data from multiple Oracle Database. Optimized and automated teh query in Alteryx
- Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data
- Created all teh calculations wifin Alteryx for performance improvements and scheduled teh workflows to output TDE
- Used Stories for some interesting snapshots of data, integrated R and Tableau for proof of concept on R clustering, sentiment in Tableau
- Performed Data Quality Testing, Interface testing, Performance Testing
- Implemented row/user level security by creating groups on Tableau server and granting user access depending on teh group
- Analyzed Server logs using Administrator to see what is happening on teh server, such as access logs
Environment: Tableau 8.3/9 Desktop and Server, Alteryx, Windows Server 2008, Oracle 10g, Amazon Redshift, Google BigQuery
Data Analyst Intern
Confidential
Responsibilities:
- Analysis of teh digital marketing click stream data by building effective data visualization reports, dashboards and inferences in Tableau
- Created SQL queries in oracle for data extraction, compared teh results and automated teh data pulling by creating ETL process in al
- Data Manipulation using Oracle SQL and automated creation of Tableau Data Extract by creating ETL workflow using Alteryx
- Created Continuous monitoring dashboards in Tableau to track drastic change in KPI’s such as Clicks, CPC, Impressions
- Identified teh existing paid search campaign reports in excel, documented teh process and migrated them to Tableau