Tableau Developer & Data Analyst Resume
SUMMARY
- Over 6+ Years of BI experience which includes Design, Development, Integration, Implementation and Maintenance of Business Intelligence Platforms.
- Develop and Maintain reports and dashboards in Tableau as per business requirement.
- Understand the Math and Statistics of the requirement, interpret and prescribe from data to deliver actionable recommendations using effective visualizations
- Involve in code construction using SQL, Vizql, Level of Detail expressions and Regular Expressions in Tableau to meet the business needs of the proposed requirements.
- Develop Scripts to load data and work with multiple data connections including SQL, Hue and Impala and by performing data blending for multiple type data sources.
- Create wireframe/ paper design / design document to finalize the number of dashboards or graphs, graph type & color code.
- Optimize Dashboards using the information provided by the Tableau performance reports using various techniques such as Reducing Redundant Data, Optimizing Data Filters, Empty Extract Functionality, Eliminating Unused Dimensions and Measures to help reduce the load time and increases performance of the dashboards.
- Create Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me and Marks Card Functionality.
- Provide the Security while Publishing to the Tableau Server using Active Directory, Tableau Security service called ‘Roles’ and providing Row Level security when requested by the user for sensitive reports.
- Visualize and communicate findings using reports and dashboards and provide a quantitative framework for evaluating and analyzing alternatives
- Automate tasks and files backup using Batch Script coding.
- Responsible for conducting prototypes, developing functional specifications, data mapping, function mapping.
- Publishing dashboards on server and giving access to users. Getting reviews from end users and modifying the dashboards accordingly.
- Perform Data Quality Testing by comparing output of dashboard with database. Functional testing by checking filters, navigation etc and Troubleshoot visualization issues
- Defining access control levels for different types of users and communicating the requirements to the Tableau Server team to apply the same to the workbooks.
- Extracting the functional rules from requirements and converting them into high and low level design components.
TECHNICAL SKILLS
- Tableau Desktop, Tableau Server, Microsoft Power BI, Excel, QlikView
- Corporate Glossary, Data Dictionary, Naming Convention, Change Management
- R Programing, R Studio, Python, Anaconda, Mathematical Modeling
- MS SQL Server, Impala, Oracle MySQL, PostgreSQL, GreenPlum DB, Hive
- Distribution Policies, Reports Security, SAML, Data Project Management
- Windows 7, 8.1, 10, Windows Server 2003, Server 2008, Server 2012, Linux.
- EC2, Redshift DB, VPC, S3 Storage, Route - 53 DNS, IAM Management
- Microsoft Office suite, Batch Script, Photoshop CS5, ServiceNow
- DNS Management, Web Hosting, SSL, Security Group Management, SSH
PROFESSIONAL EXPERIENCE
Confidential
Tableau Developer & Data Analyst
Responsibilities:
- Create SQL from the Standard Mapping document of the report
- Create the Tableau dashboard for the Migration and adhoc report deliveries.
- Perform data analysis for ensuring data quality is high enough for report development.
- Create Calculations, Logics & documentations for the team to assist with successful completion of the projects.
Environment: Tableau Desktop, Tableau Server, Hue, Impala, AtScale, AWS EC2
Confidential
ETL and Tableau Developer
Responsibilities:
- Create ETL for the data migration into data ware house, create custom views to develop the dashboard
- Create the Tableau dashboard for the trader risk management platform.
- Perform data analysis for ensuring data quality is high enough for report development.
- Create SQL queries and views for the ad hoc data requirement
- Created Calculations, algorithms for risk management for the client.
Environment: Tableau Desktop, Tableau Server, Oracle SQL Developer, SSIS, Monaco Trader Risk Platform
Confidential
ETL & Tableau Developer
Responsibilities:
- Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
- Support server migration to cloud by modifying report sources of PowerBI reports in large volumes.
- Managed data migration of various oil rigs in various locations around the world to create a central data repository for analytical purposes.
- Advanced data conversion Techniques on Python used to convert industry specific data files such as .LAS, .BHAT files to convert the data into standard ingestible file system.
Environment: Tableau Desktop 10.0, Tableau server 10, windows server 2008, Oracle 10g, Microsoft Excel, MS Access, MS SQL, Photoshop, Amazon Web Services- Redshift, EC2, Qlikview, Qlik Management Console, Qlik NPrinting, PowerBI, MySQL, SQL Server 2012, Informatica Cloud, SAP, GateWorks, RTPro.
Confidential
BI/Tableau Developer
Responsibilities:
- Created dashboards as per requirements for various departments in the agency (HIPAA certified).
- Created interactive dashboard as per complex requirement using live data and extracts.
- Implemented Tableau dashboards for various applications from Microsoft TFS, WASP asset Tracker, FOCUS.
- Consulted on Tableau server performance enhancements; upgrades from version 8.1 to 9.3 and server.
Environment: Tableau Desktop 10.02, 9.3, 9.0, 8.3, Tableau server 10.02, 9.0, 8.3 windows server 2008, Microsoft Excel, Microsoft TFS Server, Microsoft Project Manager, Photoshop, Amazon Web Services- Redshift, EC2.
Confidential
Research Assistant-Finance Dept.
Responsibilities:
- Assisted the professor in proving het theory of female entrepreneurship on why female executives tend to budge down the growth compared to male executives.
- Proctored examinations and help assessing the papers of students in examinations.
- Provided professor a historic student performance report in Tableau by self-implementation.
Environment: Tableau Desktop 8.2, Microsoft Excel, Photoshop, Amazon Web Services.