We provide IT Staff Augmentation Services!

Tableau Developer Resume

Buffalo, NY

SUMMARY

  • Over 7 + years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
  • Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
  • Extensively worked on Tableau 6.x/7.x/8.x (Desktop, Server, Mobile, and Public), Micro Strategy, Business Objects and SSRS.
  • Expertise inSQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)wif good knowledge onSQL Server Analysis Services(SSAS).
  • Created Dashboards of different types for Analysis, Monitoring, Management and better understanding of the business performance metrics.
  • Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSISsuch asData Conversion,Conditional Split,Bulk Insert,Mergeandunion all.
  • Good understanding about Netezza architecture.
  • Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7, Tableau 8 and Tableau 9
  • Extensive experience on building dashboards using Tableau. Worked closely wif Tableau support team during tableau server upgrades to 8.3
  • Strong experience in Data Warehousing and ETL usingInformatica Power Center 8.6.
  • Worked on data blending and increased the dashboard performance by extracting data .
  • Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Work flows, Customized Analytic s Reports.
  • Major responsibilities include getting requirements from the user and preparing estimates, defining technical solutions.
  • Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
  • Develop HTML prototypes and UI deliverables, such as wireframes, flowcharts, screen mock - ups, and interface design specifications.
  • Maintaining proper documentation of the reports for future reference.
  • In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
  • Created solution driven dashboards by developing different charts types including cross tab's, Heat/Geo/tree maps, pie/bar charts/circle views/Lines/Area charts, Scatter plots, bullet Graphs, and Histograms in Tableau Desktop.
  • Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
  • Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
  • Managed netezza queries by performance tuning and techniques such as CBT and Collocation.
  • Worked wif production team to implement UI and create enhancements to optimize user experience.
  • Good knowledge on Tableau Administrator installation, configuration, and load balancing.
  • Designed and Developed reports and dashboards for Insurance domain.
  • Developed several Tableau reports for Sales Data Mart Data.
  • Successfully completed several crystal report projects at major customer sites.
  • Very good knowledge in Business Intelligence concepts and process.
  • Good understanding on OLTP and OLAP based data. Capable of creating visually rich and highly optimized Tableau reports pointing to OLAP and OLTP systems.
  • Ease in dealing wif end users while working on KPIs, Requirements and detail designs.
  • Excellent knowledge in Data Warehouse concepts and multidimensional data.
  • Designed standardized Data Mart wif aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked wif ETL developers, DBAs, Data Modelers to implement the same in Development, Test and Production environment.
  • Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issuesl
  • Provided technical guidance for re-engineering functions of teradata warehouse operations into Netezza.
  • Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating database tables, constraints, indexes.
  • Helped create interactive prototypes and UI specifications, including screen layouts, color palettes, typography, and user-interface elements.
  • Extensive experience working on Erwin utilizing features like Reverse/Forward Engineering, Subject Area, Domain and developing Data Dictionary and publishing Data Models.
  • Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,.

TECHNICAL SKILLS

ETL Tools: Informatica, Data Stage, Microsoft SQL Server Integrated Services

BI Tools: Tableau (Desktop/Server), SSRS, SSAS, Visual AnalyticsBusiness Objects XI/4.0, Micro Strategy.

Relational Databases: MS SQL Server 2005/2008/2012, Oracle 8i/9i/10g/11gMS Access, Teradata.

Tools: and Packages: SQL Server Management studio, Toad, Microsoft Visual StudioLanguages SQL, PL/SQL, C, C#, ASP.Net, HTML, XML

Operating Systems: Windows 2008, Windows 2000/2003 Server, Data center, Windows NT, Windows 95/98/2000 XP, UNIX.

PROFESSIONAL EXPERIENCE

Confidential - Buffalo, NY

Tableau Developer

Responsibilities:

  • Converted theBusiness Objects/OBIEE reports into Tableau Dynamic Data Visualization andcreated Mapping Documents.
  • Gatheird business requirements andtransformed the business into high interactiveData VisualizationusingTableau.
  • Developed working prototypes from UI designs for cross-platform devices
  • Understood the business challenges and translated them into requirements and developed inTableau Desktopaccording to Business Requirements.
  • Created Metadata dictionary dashboard and allowed the business users to audit the metadata of identified data sources.
  • Performed testing and documentation of UI and services
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Converted theBusiness ObjectsTechnical Specification into Tableau MetadatausingWorkbook Tools for Tableau
  • EnsuredAction Filters, created aRow Level Securityand shared the reports wif functional/business users
  • Have RDBMS concepts experience in Oracle 11i/10g/9i/8i/7.x, WinSQL, SQL*Loader,Netezza
  • Created Ddashboards wif the security using filters for the clients to measure cost saving.
  • Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
  • Creating reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
  • Led the development of websites for major national clients, built advanced UI frameworks for web applications, and established design patterns for rapid prototyping of websites.
  • Generated Tableau Dashboards wif filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
  • Generated Tableau reports wif Trend lines, Reference lines and Bands and also generated several drill down and drill up reports.
  • Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes. Combined
  • Multiple data sources by joining tables and using Data Blending.
  • Extensively worked wif Netezza database to implement data cleanup, performance tuning techniques.
  • Published Workbooks by creating user filters and security, so intended teams can view it.
  • Worked on groups, sets, different calculation functions including Table calculations.
  • Hands on Tableau Administrator installation, configuration, and load balancing.
  • Hands on Design and implement security model.
  • Blended data from multiple databases such as MS Excel, MS SQL, Tera data and Oracle.

Environment: Tableau, Data Stage, SQL Server,Oracle, MS Access,Jira, Teradata, Netezza,Microsoft Office Suite (Word, PowerPoint, Excel).

Confidential, Detroit, MI

Tableau Developer

Responsibilities:

  • Interact professionally wif diverse group of professionals in the organization including managers and executives.
  • Create views and dashboards on HR data. Produce powerful dashboards telling story behind the data in an easy to understand format such as pie, bar and line charts dat are viewed daily by CEO and CFO.
  • Experience on developing UI using Struts view tags (HTML, Bean, Logic and Nested), JSP, HTML5, CSS3.
  • Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction wif data layer.
  • Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Hands-on development assisting users in creating and modifying worksheets and data Visualization dashboards.
  • Extracting data from different sources connecting them and used the same to create dashboard.
  • Worked wif NZLoad to load flat file data into Netezza tables.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
  • Created complicated formulas and running totals on summarized totals for business measure calculations based upon various end user requirements.
  • Transformed complex data into easy-to-understand visualizations using Tableau and created a Story.
  • Designed the front-end applications, user interactive (UI) web pages using web technologies like HTML, XHTML, and CSS.
  • Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on dat business or system change to ensure dat the published dashboards are displaying accurate and up-to-date information.

Environment: Tableau Server, Tableau Desktop, Windows Server Standard R2, Clear quest, Clear case, Oracle 11i, Sybase,Netezza Crystal XI, Info view, CMS,Jira, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.4.

Confidential - Orlando, FL

Tableau Developer

Responsibilities:

  • Interacted professionally wif a diverse group including executives, managers.
  • Experience wif the design and development ofTableauvisualization solutions.
  • Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction wif data layer.
  • Involved in creating dashboards and reports inTableau. Created report schedules onTableau server.
  • Worked on Netezza JDBC, ODBC and OLE DB to configure data connectivity clients to connect Netezza system and run queries through the supported drivers.
  • Installed Tableau Server in Dev, QA, UAT and Prod environments.
  • Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
  • Monitored Vizql and WGSQL Server activity to track performance and system stability.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Extracting data from different sources connecting them and used the same to create dashboard
  • Experience wif creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
  • PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
  • Created mappings using pushdown optimization to achieve good performance in loading data into Netezza.
  • Created data blending in case of merging two different datasets.
  • Designed the Conceptual and Physical Data Models, as well as the major components of the user interface for the “MDW” project. The Data Models were built wif Sybase Designer.
  • Created and assisted users in Tableau dashboard development
  • Administered and provided production support for Confidential Enterprise wide Tableau application consisting of multiple key functional business domains.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
  • Defined and created procedures to install Tableau desktop in silent mode.
  • Defined best practices for Tableau report development.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Provided 24/7 production support for Tableau users

Environment: Tableau Desktop, Tableauserver / Administrator,Jira, Oracle 10g, Microsoft Excel 2007,MS Access, Microsoft office 2007.

Confidential - Overland Park, KS

SQL/Report Developer

Responsibilities:

  • Created nested and conditional subgroups and formatting features in reports.
  • Created sub reports called from the main report to implement the business logic.
  • Upgraded MS SQL Server 2005 to 2008using detach/attach, backup and recovery and by replication.
  • Tuned reports for faster execution using stored procedures, views and column indexes.
  • Created complex formulas at the summary level and group level to implement the business logic.
  • Expert in creating Star schema cubes usingSSAS.
  • Used SSIS Import/Export Wizard, for performing the ETL operations.
  • Created Parameter driven reports to restrict volume of data.
  • Performed T-SQL tuning and optimization of queries for reports dat take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008r2.
  • Created complicated formulas and running totals on summarized totals for business measure calculations based upon various end user requirements.
  • Generated reports using SSRS dat could be used to send information to different Primary vendors, clients and managers.
  • Responsible for inserting new records in database using the front end tool in Track wise Team Access.
  • Troubleshootand fixed issues in existing cubes in SSAS.
  • Responsible for running Ad-hoc queries in Track wise Team Access System to test the data in the report.
  • Responsible for documenting reports using standard templates like Design Specification, Operational Qualification and Performance Qualification.

Environment: MSSQLServer 2008r2, T-SQL,SSIS,SSRS2008r2, Jira,Visual Studio 2008r2, Erwin 8.0, HP ALM, UNIX, MS VISIO, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential

Business Objects Developer

Responsibilities:

  • Identified and road mapped the Business Requirements (functional & technical) wif the Business users, which acted as a base for the project initiation and implementation.
  • Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
  • Created New Universes and Managed existing Universes Migrate, upgrade and test the Business Object XIR3 content/environment
  • Setup, execute, and test the assigned programs utilizing BO XIR3 WEBI and DESKI tools
  • Creation of multiple Universes and Linked Universes.
  • Design complex Web Intelligence and Desktop Intelligence Reports
  • Plan the implementation of migration to different Environments in Business Objects.
  • Involved in the Data Warehouse design process
  • Develop Dashboards for the higher management of the company
  • Worked on extensive features of Business Objects XI including Index awareness, Derived tables and Input Controls
  • Creation of reports, working wif database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
  • Analyzed the reports using the Drill Through, Slice and Dice.
  • Trained the users in viewing/scheduling the reports using the Info view and Designed security model for users to access the report
  • Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.
  • Designed, developed, tested and maintained highly complex reports.
  • Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
  • Deployed the reports by using Import Wizard (between DEV and UAT) and archived the reports giving access permission for Business Objects Reports.

Environment: Business Objects XI 3.1/6.5(Web Intelligence/Desktop Intelligence), Designer, Import Wizard) Performance Management, Oracle 9i, DB2, AS/400, SQL Server, Windows XP.

Hire Now