We provide IT Staff Augmentation Services!

Sr. Tableau Developer/analyst Resume

New York City, NY

SUMMARY:

  • Over 7 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms.
  • 3 years of extensive Tableau Experience in Tableau 6.x/7.x/8.x /9.x/10.0 (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.
  • Strong knowledge of Business/Process Data flow in organizations and experienced in data modelling concepts.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Prepared Dashboards using calculations, parameters in 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.
  • End to end experience in designing and deploying data visualizations using Tableau.
  • 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 MS Access and client/server applications.
  • Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.
  • Expertise in analysis, design and implementation of data warehousing/ BI solutions using Tableau, MicroStrategy, SSRS, Informatica and Alteryx.
  • Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
  • Expertise in generating reports using global variables, expressions and functions for the reports.
  • Experience in using SQL Server 2008 Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like MS Access, Flat File, Excel, Oracle, Lotus notes and DTS (i.e. Import and Export) also worked to Automate the ETL operations.(Automate the SSIS Packages and Import, Export).
  • Extensive knowledge on implementation of Set Analysis and worked on the Alternate states to do a comparative analysis in QlikView.
  • Experience in developing User Interfaces and QlikView Dashboards using Chart-Box (Drill Down, Drill up & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars, and Date Islands.
  • Extensively worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema (in source code control) and Entity relationship diagrams from business requirements.
  • Experience with Alteryx to collect the required data from large complex databases.
  • 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.
  • In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
  • 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 v6.x/v7.x/v8.x/v9.x, Tableau Server v6.x/v7.x/v8.x, Tableau Online v9.x, Crystal reports XI/2008, Business Objects XI R1/R2/R3.x/4.x, BO Universe Designer, BO Web intelligence

Databases: Teradata, MySQL, MS SQL Server, Alteryx,Hive, ORACLE, IBM DB2, MS Access, Amazon Redshift

ETL Tools: Informatica, SSIS

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, OpenProj, JIRA

Programming Languages: SQL, PL/SQL, HTML, Java/J2EE, ASP.net

Document Management: 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: Power Designer, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Sr. Tableau Developer/Analyst

Responsibilities:

  • Gather and analyze the business requirements and then translate them to technicalspecifications.
  • Perform Tableau Server 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 andworksheets in Tableau.
  • Advanced knowledge of QlikView/QlikSense platform, including QlikView/QlikSense architecture, technical know-how, performance tuning, extensions, etc.
  • Effectively used data blending feature in Tableau.
  • Prepared and published customized reports/dashboards.
  • Converted SSRS and Microstrategy reports into Tableau.
  • Developed QV Dashboards using various Chart types (straight, pivot, bar, Pie, gauge, combo, List boxes, Input Field, Table Box, sliders).
  • Created different Action filters, Parameters and calculated fields to create most complicated dashboards.
  • Worked with Tableau administrator in managing Production, Test and Development environments.
  • 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 Tableau Online.
  • 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.
  • Converted Pearl Script Query in to SQL Query for ETL.
  • Created reports in Tableau using SSRS SQL Queries and Stored procedures.
  • Created reports using Custom SQL for complex report views.
  • Executed and tested required queries and reports before publishing.
  • Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau 10.x, Tableau Server 10.x, Microsoft SQL Server 2013, Alteryx,ERwin r8, Toad 8.7, SSRS 2013, SalesForce, Sharepoint.

Confidential, Somerville NJ

Sr. Tableau Developer/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
  • Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.
  • 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 9.x, Teradata, SAP Business Objects 4.1/4.0, IDT, UDT, WEBI-BI: SAP BW Query Designer, Analyzer, Teradata SQL Assistant, Teradata Administrator, SQL BI Suite (SSRS / SSAS) 2012, Sharepoint

Confidential, Tucson, AZ

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

  • Involved in reviewing business requirements and analyzing data sources form Excel, 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.
  • Involved in creating interactive, parameterized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
  • Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.
  • Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
  • Creating visually compelling and actionable interactive reports and dashboards.
  • Reviewed and optimized SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time
  • Involved in data conversion to provide reporting capabilities as per the requirement.
  • Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
  • Validated the reports before publish reports to Tableau server, troubleshoot Tableau reports, dashboards, etc
  • Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop /Server), Oracle, SQL Server, DB2, SSIS, SQL, Toad, Unix, MS VISIO, Control-M, Erwin, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatica, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Confidential, Neumann, OH

Sr. Data Analyst

Responsibilities:

  • Conducted one-on-one sessions with business users to Gather Data Warehouse 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 implementing Data Modeling changes.
  • Created ERWIN reports in HTML, RTF format depending upon the requirement.
  • Published Data model in model mart, created naming convention files, co-coordinated with DBAs' to apply the data model changes.
  • Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
  • Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWIN.
  • Created and maintained Metadata, including table, column definitions.
  • Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
  • Responsible for Defining the Naming Standards for data warehouse.
  • Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility.
  • 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.
  • Massaged the existing model to create new logical and physical models that formed the basis for the new application.
  • Eliminated errors in Erwin models through the implementation of Model Mart (a companion tool to Erwin that controls the versioning of models).
  • 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.
  • Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
  • Identified the most appropriate data sources based on an understanding of corporate data thus 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 source data.

Environment: Windows XP/NT/2000, SQL Server 2008, Teradata, Oracle11g, DB2, Informix, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro, OBIEE.

Confidential

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 8i, 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
  • Created Calculated Measures and Dimension Members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
  • 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 Professional, Team Foundation Server, ProClarity, SSIS, SSRS, SSAS.

Hire Now