We provide IT Staff Augmentation Services!

Sr. Bi/tableau Developer Resume

New York, NY

SUMMARY:

  • Confidential possesses five years of professional work experience in the business intelligence realm in analysis, design, development and maintenance of various software applications - -mainly in Tableau. He has extensive experience in analyzing and translating end-user requirements into robust, reliable systems that streamline workflows with dynamic graphical user interfaces and stored procedures.
  • Confidential also has an intense drive to plan and execute large-scale technical projects individually, and/or while leading a team. He has worked in close association with the clients while training, support them and accomplishing organizational objectives in turn.
  • Proficient in building compelling, interactive dashboards in Tableau that answer key business questions.
  • Professional in writing complex Formulas, Sub Reports, Summary Reports.
  • Worked on the development of Dashboard reports for the Key Performance Indicators for the top management
  • Built, published and customized interactive reports and dashboards using Tableau server.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD analysis.
  • Was actively involved in the Server migration and the Fresh Tableau Server Installation process.
  • Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop.
  • Analyzed data requirements, application and processing architectures, data dictionaries and database schemas while designing, developing, amending, optimizing and certifying database designs to satisfy client needs.
  • Developed Hive queries and spot emerging trends by comparing fresh data with EDW reference tables and historical metrics
  • Design and development of Hbase tables according to various needs of the tenants while taking into consideration various issues related to performance.
  • Developed strategy and road maps including tactics, project plans, milestones and KPIs.
  • Interfaced with data miners and analysts to extract, transform and load data from a wide variety of data sources using SAS and SQL.
  • Worked closely with visual design team to select the appropriate visualizations for BI deliverables
  • Data Visualization, Visual Analytics, BI Architecture and Management
  • Experience in maintenance of BI Warehouses and good acumen in troubleshooting & performance tuning.
  • Capable of working in team as well as independently with excellent communication, interpersonal and analytical skills, ability to work under pressure in fast-paced environments.

TECHNICAL SKILLS:

Database: Oracle, SQL Server, MS Access, MYSQL

Big Data Ecosystem: Apache Hadoop, Hbase, Hive, Pig, Talend

Web Servers: MS IIS, Tomcat4.1.24

Languages: SQL, Python, XML, XSL, VBScript, HTML

SAS Tools: SAS, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/Stat, SAS/Report

Data Visualization: Tableau 9.3/10.2, Spot fire 6.5, Qlikview11, OBIEE, SSRS

SAP Business Objects: Universe Designer, Webi, Deski, Crystal Reports, Xcelcius

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. BI/Tableau Developer

Responsibilities:

  • Created dashboards for analyzing POS data using Tableau 9.3/10.2
  • Cleansing and analyze Instantis Financial data by creating SAS/macros.
  • Built, published and customized interactive reports and dashboards using Tableau server.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Design, analyze and validate clarity system in SAS Enterprise guide.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created and edit check programs to find data discrepancies in raw datasets
  • Experience on scripting using Tabcmd and Tabadmin.
  • Worked on administration tasks like adding workbook Permissions, Ownerships.
  • Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets .
  • Involved in integrating the Instantis, Jira and Clarity with business users.
  • Developed code using data step programming and macros to extract, clean and validate date from external source.
  • Analyze the data in tableau by connecting to Hive by Hortonworks Hive ODBC driver.
  • Developed various forms of outputs like RTF, HTML, PDF files using SAS/ODS.
  • Created Bar charts, donut Charts, trend charts, Control charts in tableau.
  • Created donut chart for high/medium/low task in clarity portfolio management.
  • Created users, groups and authentication and maintained in tableau server.
  • Developed Bullet charts, pie charts, dual axis charts, Combination chart, cross tab using tableau.
  • Worked on data blending and analyze data from multiple data source.
  • Developed and published Instantis and clarity data visualization charts in tableau server.
  • Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering.

Environment: Tableau 9.3/10.2, Qlikview 11, SAS/BASE, SAS Enterprise Guide 7.1, Oracle, Talend, Hadoop Hive, Hbase

Confidential, New York, NY

Tableau Developer

Responsibilities:

  • Built HON (Health of Network) system performance KPIs of all product using tableau and sport fire and published in server.
  • Develop, build and deployed executive dashboard using tableau and sport fire.
  • Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Created Bar charts, funnel charts; waterfall charts, Control charts in tableau.
  • Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Connected Tableau with Oracle database to extract multiple tables and views.
  • Interact with Business Users, Business Analyst and source system owners to gather the requirements and Business logics.
  • Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Strong Excel skills, including pivots, Vlookup, conditional formatting, large record sets Including data manipulation and cleaning.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Developed POCs by building reports and dashboards using Tableau 9.3/10.2
  • Scheduled all visualization reports in tableau server.

Environment: Tableau 9.3, Spot fire 6.5, splunk, Oracle, PL SQL Developer, Hadoop Hive, Pig, Hbase

Confidential, New York, NY

Tableau Developer/Admin

Responsibilities:

  • Collected business requirements from different sources and wrote the technical specifications for building the Data model.
  • Strong leadership, problem-solving and multi-tasking abilities.
  • Developed workbooks and dashboards using Tableau Visualizations like Heat Maps, Pie Charts, Dual Axis workbooks and Charts, Bar Graphs, Scatter Plots, Trending and Forecast dashboards, Waterfall Charts, Geographic maps using local and global filters.
  • Involved in creating calculated fields, mapping and hierarchies.
  • Worked creating Aggregations, calculated fields, mapping, hierarchies, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
  • Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
  • Develop, build and deploy complex reports involving formulas, dynamic parameters, cross-tabs.
  • Created Daily, Weekly and monthly reports in Tableau.
  • Scheduled automatic generated reports in Tableau Server.
  • Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports in Tableau desktop.
  • Played an active role during the requirement gathering, analyzing and designing of the system.
  • Responsible of monthly reconciliation Q13 - Revenue Reconciliation reports which need to be submitted before every month first seven business days to the agencies.
  • Analyze PDR Details and Summary report every month for the Q13 Reconciliation.
  • Analyze Account Details, Toll summary, GL Summary every month for the Q13 Reconciliation.
  • Analyze 16A Truck Volume discount report with Q13 for monthly reconciliation.
  • Analyze F3M with PDR for the monthly reconciliation.
  • Analyze Q8M. Q4P and F3M report with Q13 for Monthly reconciliation.
  • Analyze Q13 direct revenue with F3M for monthly reconciliation.
  • Analyze 61 and 62 report with Q13 for monthly reconciliation.
  • Analyze PDR Payment summary by Payment Type (57) with Summary by Transaction (58) for Q13 reconciliation

Environment: Tableau, Spot fire, Crystal Reports XI, CMC, Business Objects, Webi, Oracle, Hadoop, Hbase, Hive

Confidential, Hartford, CT

Tableau Developer

Responsibilities:

  • Involved in business analysis and technical design sessions with business and technical staff to develop requirements document.
  • Develop, build and deploy complex reports involving formulas, dynamic parameters, cross-tabs and subreports.
  • Analyze the requirement and prepared the specification document.
  • Developed various operational Drill-through and Drill down reports using Crystal Reports.
  • Worked on conversion project from access database reports and oracle reports to Crystal Reports
  • Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using Crystal Reports.
  • Played an active role during the requirement gathering, analyzing and designing of the system.
  • Created sql queries to fetch data for reporting.
  • Followed HL7 standards and Message Validation.
  • Migrated existing application from MS-Access to Oracle and Crystal Reports.
  • Created DTS packages for Data migration and transformation from oracle/access/Excel to SQLServer.
  • Created stored procedures, packages, function and cursor management and exception handling.

Environment: Windows Scripts/log, Tableau, 2008, Webi, Universe, SQLServer 2008, Oracle 10g

Hire Now