Sr Tableau Developer/sr Data Analyst Resume
Hunt Valley, MD
SUMMARY
- Over 8 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms.
- 4+ years of extensive Tableau Experience in Tableau 9.x/8.x /7.x (Desktop, Server, Reader, Mobile) as a Developer and Analyst.
- Competent in Software Development Life Cycle methodology (SDLC) and Software Testing Life Cycle (STLC) which includes RUP, Agile and Waterfall Methodology.
- Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
- Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies,
- Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.
- Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
- Excellent understanding of Data Modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases Oracle, SQL Server, Teradata, DB2, MS Access and client/server applications.
- Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.
- Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axes, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters.
- Extensive experience in creating rich visualizations in Tableau - Means, Modes, Percentiles, Outliers, Histograms, Box Plot, Control Charts, Derivatives, etc. by Dimensions, Time Series line charting and forecasting.
- Strong expertise in developing high performance dashboards with Story points and Advanced calculations.
- Experience in implementing Dynamic Bin and hyperlink to connect applications outside Tableau.
- Experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
- Experienced in tuning long running SQL queries for better performance.
- Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level Data Analysis and Data Management Services.
- Experience in Technical Support, Troubleshooting, Report Design and Monitoring of system usage.
- Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
TECHNICAL SKILLS
Reporting Tools: Tableau Desktop 9.x/8.x/7.x, Tableau Server 9.x/8.x/7.x, Tableau Online v9.x, SSRS, OBIEE, Business Objects
Databases: Teradata, MySQL, MS SQL Server, Oracle, DB2, MS Access, Amazon Redshift
ETL Tools: Informatica, SSIS, Pentaho
Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, JIRA
Programming Languages: SQL, PL/SQL, javascript, HTML, Java/J2EE, Visual Basic, PERL
Document Management: PVCS, Documentum, Share point, Ultra Edit
Defect Management tool: HP Quality center
Service Management Tool: HP Service Manager, CA Service Desk
Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile, Iterative)
Data Modeling: ERwin, Power Designer, MS Visio
PROFESSIONAL EXPERIENCE
Confidential, Hunt Valley, MD
Sr Tableau Developer/Sr Data Analyst
Responsibilities:
- Understand the client requirement, prepare the solution proposal and the architecture of the solution. Create the data model, design the ETL process approach, identify the metrics, KPI's from the data and design the mockups to present the data on Tableau dashboard.
- Prepared the data in Tableau, create calculated fields, create set groups etc. create dashboard and create dashboard story telling
- Create an integrated data mart in SQL Server to combine the data from different areas like, like NPD, Operations, People and Customer shares data.
- Create the data model, design the ETL process approach, identify the metrics, KPI's from the data and design the mockups to present the data on Tableau dashboard.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
- Created Custom complex SQL Queries to generate the data from data base and use it for making Innovate and Powerful Dashboards for easy Data Visualization and Forecasting in Tableau
- Used Appropriate Formatting Headers, Worksheets with different Visualization Color Coding for showing the Complex Data in Dashboards to View easily.
- Created calculated fields (including the new features in 9.2 for: filtering on discrete aggregates and additional LOD dimensionality-Fixed and Include), debugging complex Calculated Fields.
- Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
- Writing SQL queries for data validation of the reports and dashboards as necessary.
- Involved in Performance tuning the reports and dashboards for optimization.
- Created scheduled PDF extracts using TABCMD.
- Restricted data for particular users using Row level security and User filters.
- Create user guide and provide to business users.
Environment: Tableau (Desktop/Server) 9.x/8.x, SQL Server 2012, SSIS, Oracle 11g, Toad, Power Designer, PVCS, JIRA, Microsoft Office Suite (Word, PowerPoint, Excel, Visio).
Confidential, Baltimore MD
Sr. Tableau Developer/Analyst
Responsibilities:
- Gather and analyze the business requirements and then translate them to technical specifications.
- PerformTableauServer admin duties; add users/groups from Active Directory; instances in Tableau Server.
- Gathered SSRS reports requirements and created in Tableau.
- Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets inTableau.
- Effectively used data blending feature in Tableau.
- Prepared and published customized reports/dashboards.
- Created different Action filters, Parameters and calculated fields to create most complicatedDashboards.
- Worked with Tableau administrator in managing Production, Test and Development
- Used data blending feature in Tableau and defined best practices for Tableau report development.
- Created report on Cloud based environment using Amazon Redshift and published on TableauOnline.
- Integrated dashboards with live Connection in Microsoft PowerPoint.
- Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau
- Desktop to validate static and dynamic data for data validation.
- Created SharePoint site to store all Tableau workbooks and data source.
- Published packaged workbooks.
- Developed Geo/Area Maps to show details on which states have most sales vs. the least sales.
- Created Custom Hierarchies to meet the Business requirement in Tableau.
- Created reports in Tableau using SSRS SQL Queries and Stored procedures.
- Executed and tested required queries and reports before publishing.
- Participated in weekly meetings, reviews, and user group meeting as well as communicating withStakeholders and business groups.
Environment: Tableau Desktop/Server 8.x, Tableau Server 9.x, SQL Server, Oracle 11g, Toad, SSRS, Amazon Redshift, GitHub, SharePoint.
Confidential, Boston, MA
Tableau Developer/Sr. Data Analyst
Responsibilities:
- Involved in planning, defining and designing data based on business requirement and provided documentation for further .
- Involved in installation and configuration of Tableau Server.
- Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
- Designed and developed dashboards by extracting data from different sources and created dashboard using parameters, sets, groups and calculations in Tableau Desktop
- Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.
- Created calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
- Implemented data blending to blend related data from two different data sources.
- Created incremental refreshes for data sources on Tableau server.
- Monitored VizQL server, Application Server and data server activity to track performance and system stability.
- Administered user, user groups, and scheduled instances for reports in Tableau
- Generated insights out of voluminous and complex datasets and built story lines.
- Configured Cache settings which improved the performance of the reports and Dashboards.
- Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
- Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly.
- Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
- Involved in reviewing business requirements and analyzing data sources from MySQL/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
- Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
- Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
- Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
Environment: Tableau (Desktop/Server) 8.x, Pentaho, MySQL, Oracle, Linux, ERwin, AWS, ClearCase, UC4, MS Office.
Confidential, Atlanta, GA
Tableau Developer/Data Analyst
Responsibilities:
- Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
- Developing and maintaining high level overview of the project and design flows using MS Visio.
- Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
- Building, publishing customized interactive reports and dashboards using Tableau.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Effectively used data blending feature in Tableau and defined best practices for Tableau report development.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Executed and tested required queries and reports before publishing.
- Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
- Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
- Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
- Provided support for Tableau developed objects and understand tool administration.
- Created Custom Hierarchies to meet the Business requirement in Tableau.
- Worked with Tableau administrator in managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
- Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
- Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
- Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
- Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.
- Created SharePoint site to share project related documents.
Environment: Tableau 8.x/7.x, Teradata, Oracle, SAP Business Objects 4.1/4.0, SAP BW Query Designer, Analyzer, Teradata SQL Assistant, Toad, SharePoint.
Confidential, Chicago, IL
Sr. Data Analyst
Responsibilities:
- Conducted one-on-one sessions with business users to GatherDataWarehouse Requirements.
- Updated existing models to integrate new functionality into an existing application.
- Analyzed database requirements in detail with the project stakeholders by conducting joint Requirement Development sessions.
- Developed normalized Logical and Physical database models to design OLTP system.
- Created Dimensional Model for the reporting system by identifying required dimensions and facts using Erwin.
- Created DDL scripts for implementingDataModeling changes.
- Used forward engineering to create a PhysicalDataModel with DDL that best suits the requirements from the LogicalDataModel.
- Created and maintained Metadata, including table, column definitions.
- Worked with Database Administrators, BusinessAnalystsand Content Developers to conduct design reviews and validate the developed models.
- Extensive experience in PL/SQL programming - Stored Procedures, Functions, Packages and Triggers.
- Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
- Used ERwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
- DevelopedDataMigration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
- Identified the most appropriatedatasources based on an understanding of corporatedatathus providing a higher level of consistency in reports being used by various levels of management.Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the sourcedata.
Environment: ERwin, Windows XP/NT/2000, SQL Server 2008, Oracle11g, DB2, MS Excel, MS Visio, Rational Rose, Requisite Pro, OBIEE.
Confidential, Atlanta, GA
Data Analyst/ Business Systems Analyst
Responsibilities:
- Analysed the business requirements of the project by studying the Business Requirement Specification document.
- Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks
- Created a logical design and physical design in Erwin.
- Maintained security and data integrity of the database
- Identified the business function activities and processes, data attributes, and table metadata, and documented detailed design specifications
- Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
- Run batch jobs for loading database tables from Flat Files using SQL*Loader.
- Extensively used Erwin for developing data model using star schema methodologies.
- Created Entity relationship diagrams (ERD), Function relationship diagrams(FRD), data flow diagrams(DFD) and enforced all referential integrity constraints using Erwin data modeling tool
- Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
- Good knowledge and experience on Global Custody operations, capital markets, securities services, vendor management operations, trade finance, trade settlements, income processing, tax, corporate actions, market claims and reconciliations, NAV generations
Environment: Oracle 9i, SQL, PL/SQL, Erwin, SQL*Loader, Perl, TOAD and UNIX.
Confidential
MS SQL Server Developer/BI Developer
Responsibilities:
- Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
- Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
- Created Stored Procedures, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
- Implemented Data Mart, Facts, Dimensions, Snow Flake schema, Star Schema and OLAP cubes
- Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
- Worked in visually enhancing reports as per user requirements.
- Responsible for tuning and Optimizing Queries for the reports.
- Expert in SQL Server Management Studio interface for writing queries and stored procedures.
- Created and maintained Roles and Database users.
- Created database objects like views, indexes, user defined functions, triggers and stored procedures.
- Responsible for trouble shooting the reports.
- Maintained DTS 2000 Packages and migrated them to SSIS
Environment: MS SQL Server 2005, MS Visual Studio 2005, Windows XP, Team Foundation Server, SSIS, SSRS.