Tableau Developer / Data Analyst Resume
Chesapeake, VA
SUMMARY:
- Over 5 years of experience in IT industry in design, development, implementation and maintenance of BI tools and applications, report development, and visualizations using Tableau, SSRS, Oracle, SQL Server, SSIS, Informatica etc.
- Around 4+ years of experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7.x/8.x/9.x/10.x.
- Proficient in creating Tableau Visualizations with Dashboards using tableau features like Action Filters, Quick Filters, Hyper Linking, Drill down, and Ranking.
- Expertise in designing dashboard reports with Key Performance Indicators(KPI) for higher authorities by making use of local and global filters, Attributes, Facts, Hierarchies, Level of Detail, Calculated fields, analytics commands, groups, sets, parameters, Transformations, Prompts in Tableau.
- Ability to achieve optimization through extracts or SQL queries, troubleshooting, performance tuning and supporting Business reporting platforms effectively.
- Very good knowledge in entire Business Intelligence Project Life Cycle and proficient in visualizing through Tableau to analyze, attain insights into large datasets, create visually compelling and actionable interactive dashboards and reports.
- Mastered in ability to design and deploy rich Graphic visualizations using Lines and Pies, Bars, Scatter plots, Maps, Bubble charts, Bullets, Histograms, and highlight tables.
- Cleaning and blending various data sources Data mapping from source to target database, skilled in best practices in determining a live connection versus Tableau Data Extract.
- Well experienced in assisting/training users to modify and create worksheets and data visualization dashboards using Tableau Desktop, administered user, user groups, and scheduled instances for reports in Tableau.
- Having good knowledge in Retail, Financial, and Educational domains and on creating stages, and jobs by using DataStage ETL Tool, Meta - data management.
- Expertise in writing and updating simple and Stored Procedures, complex Packages, Functions, Views, indexes, cursors and Database Triggers using SQL and PL/SQL.
- Proficient in developing Entity-Relationship diagrams, Star/Snow Flake schema designs and expert in modeling transactional databases and data warehouse.
- Enthusiastic and goal-oriented with ability to communicate to both the end users and technical team for requirement gathering, documenting, and suggesting the capabilities of Tableau Visualization for effective outcomes and able to drive the team with challenging spirit.
- Ability to grasp and assimilate trending applications and technologies within no time and help in the development of business process.
- Excellent analytical and problem-solving skills and can work independently and willing to relocate.
TECHNICAL SKILLS:
Languages: C, SQL, HTML, CSS, XML, Java, C, Java Script, SQL
Operating Systems: Windows 7,8,10, MAC OS X, Linux, iOS, Android
Tools: Tableau, SharePoint, SSRS, Eclipse, Oracle 11g Database, XCode, MS Office Suite, GitHub, MS Project 2013
BI Tools: Tableau 10.x, 9.x, MicroStrategy SQL Server Reporting Services(SSRS), Tableau Server
Methodologies: Waterfall, Agile, BI Life cycle
Data Modeling: MS Visio, ERwin
Database Tools: SQL Developer, Teradata, SQL Assistant, TOAD
Data Blending Tools: Informatica, MS SQL Server Integration Services (SSIS), Alteryx
PROFESSIONAL EXPERIENCE:
Confidential, Chesapeake, VA
Tableau Developer / Data analyst
Responsibilities:
- Gathering the requirements and comprehension the source systems to actualize DW/BI
- Data Analysis and giving proposals to higher authorities
- Present the investigation to inner and outer groups and explain the information in business perspective and importance of Key Performance Indicators
- Interacted with Business Analysts and Data Modelers and characterized Mapping reports and design process for different Sources and Targets
- Developed and audited SQL queries for data validation
- Using tableau extract to perform offline investigation
- Blended data from different information sources by utilizing connecting component as a part of Tableau desktop
- Developed perspectives using modern counts like Table estimations, Logical computations, Date figuring, and Trend Lines.
- Developed Views and Intelligent dashboards using Parameters, Filters, Actions, Bar/Bullet/Dual Axis graphs, Area/ Geo/ Heat maps, scramble plots/ Bubble charts and so forth, in Tableau desktop
- Developed various views and consolidated them into dashboards for intelligence by using Quick Filter and Parameters to further information penetrating ability
- Creating Users, Groups, Projects, Sites, and Permissions in Tableau Server.
- Working on creating dashboards in Tableau server utilizing different sources
- Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including specialized bolster, investigating, report plan and checking use of framework
- Presenting training to business users of Tableau
Environment: Tableau 10.4, .Csv files, MS Excel, MS-SQL Server 2007, TOAD, Informatica Power Center, Teradata
Confidential, Virginia Beach, VA
Tableau Developer / Data analyst
Responsibilities:
- Involved in the entire project lifecycle and communicated with the project teams.
- Communicated with the client and the BI team to collect the site specifications and business requirements to design functional and technical Business Requirement Document (BRD).
- Mentored the BI teams in creating reports, dashboards in tableau desktop.
- Designed and developed complex active reports and dashboards with various data visualizations using Tableau desktop on customer data.
- Translated the business needs into a documentation for assigned project teams and designed conceptual business process models.
- Developed the key indicators for appropriate tracking reports with graphical and written summations to help in quality improving initiatives.
- Created interactive dashboards with views and actions, drill downs, trends, and created sets to show progress in the fields based on the success rate.
- Provided better insights using Mark types and Mark properties for huge data sets.
- Created data extracts and published the sources to tableau server, refreshed extract in Tableau server from Tableau desktop.
- Designed the reports with user level security with best practices and different visualizations, built complex calculations using advanced functions.
- Implemented the features of Tableau such as Data blending, Data extracts, Forecasting, Dashboard actions, calculations, views/dashboards, and statistical data analysis for end users.
- Tested the SQL scripts to develop the reports, dashboards, scorecards, and handled the performance issues very effectively.
- Published the developed dashboards, reports on to the Tableau Server allowing the end users to access and view the data from server.
- Monitored the project performance to be on-time and on-budget with the assigned efforts for the satisfaction of the authorities.
Environment: Tableau 10.4, MS Access, MS Excel, MS-SQL Server, Oracle, Alteryx, SQL, PL/SQL, T-SQL, Microsoft office 2007
Confidential
Data analyst
Responsibilities:
- Requirements gathering, analysis including data analysis, gap analysis, and specification documentation for users.
- Designed and developed the functional specifications and Use cases.
- Performed the gap analysis on re-engineering and updating the present system on necessity.
- Business requirements and site specifications analysis and created Business Requirement Document and Design Document.
- Designed the conceptual and business process model depending on the requirement document.
- Integrated and implemented new systems with existing systems.
- Verifying the systems installed to ensure the requirements were met.
- Developed the workflows and mappings in Informatica for extracting data files which acts as source for different Tableau reports.
- Created parameters, action filters, and calculated sets for designing dashboards and worksheets in Tableau.
- Involved in writing procedures, test cases, reports and software release approval, and modifying Teradata stored procedures and performance tuning of various tables and mappings to improve the performance of Tableau dashboards and reports.
- Monitor the project development phase and involve in User Acceptance Testing as soon as the change requests are released from testing.
- Designed and developed the Complex Active reports and dashboards with multiple visualizations with Tableau desktop on customer data.
- Developed design requirements, technical requirements, and user acceptance documentation by comparing the screens of actual report and tested report in documentation.
Environment: Tableau 9.0, Teradata, Oracle 11g, SQL Server 2008, SQL Developer, MS VISIO, SQL BI Suite, (SSIS, SSRS), Java API, SharePoint, Microsoft Office Suite (Word, Excel, PowerPoint)
Confidential
Tableau Consultant
Responsibilities:
- Played active role in the team of requirement collection and analyzing the needs of End user and system specifications
- Developed and maintained a high-level overview of data flows through MS Visio
- Developed the Business Intelligence analysis and designed dashboards to deal with various aspects using Tableau desktop
- Designed dashboards with calculated fields, calculations, parameters, sets, groups, hierarchies in Tableau
- Developed scripts to load data into Tableau repository and work with multiple data by blending
- Developed mappings and workflows to extract data files for Third party vendors
- Data is extracted from multiple sources and used ETL load scripts to concatenate and clean source data
- Developed the testcases, reports, procedures, and software release approval
- Developed SQL queries using join clauses in Tableau Desktop for static and dynamic data validation
- Deployed the error free code by managing the timeline set for the project
Environment: Tableau 8.0, Teradata, Oracle 11g, SQL Server 2008, SQL Developer, MS VISIO, MS Suite, Informatica, Micro Strategy, Erwin, Microsoft (Word, PowerPoint, Excel, Outlook)
Confidential
Web Designer
Responsibilities:
- Performing the web designing skills using Dreamweaver, HTML with CSS, JavaScript and Adobe Photoshop.
- Developing profound knowledge in software packages such as Adobe Dreamweaver, Microsoft visual Studio, Notepad++, Adobe Photoshop, MS Office.
- Planning, Designing, implementing structure, navigation, and layout of the website at server side and dynamic content.
- Well knowledge in developing TITLE and META tags and page content for search engine optimization.
- Perform testing on multiple browsers to ensure the best possible compatibility.
- Expansive knowledge in web designing and graphic designing along with hosting and maintenance of websites through SEO.
Environment: Windows 7, DOS, HTML, Visual Basic, XML, CSS, .Net programming, SQL, MySQL, SQL Server.
