We provide IT Staff Augmentation Services!

Tableau Developer/ Admin Resume

Stamford, CT

SUMMARY:

  • More than 7 years of experience in design, development, implementation and administration of various Business Intelligence tools and expertise in implementing various functionalities of Data warehouse.
  • Extensive experience in Tableau Desktop and Tableau Server in various versions of Tableau 8,9,10.
  • Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
  • Extensive experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
  • Experienced in SQL Server Business intelligence tools like SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS)
  • Well versed in query optimization for performance tuning and monitoring of processes.
  • Expert in creating universes on OLAP SAP BW, Oracle, SQL server, Teradata, DB2
  • Extensive knowledge on visualization of data and knowledge of tools such as tableau.
  • Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts etc Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
  • Worked on different table calculations for different Scorecards.
  • Published dashboards on Tableau public.
  • Worked closely with Tableau support team during tableau server upgrades to 10x
  • Worked on data blending and increased the dashboard performance by extracting data.
  • Worked on Python for Data Mining and Trend Analysis in Operations Dashboard Project.
  • Perform Enterprise analysis to understand the needs of the business as a whole, its strategic direction and work with System Business Analyst and Enterprise Architects to identify solutions to enable the business to achieve its strategic goals
  • Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
  • Deployed tableau server in clustered environment by adding worker machines.
  • Broad experience in resolving universe issues like Loops and Traps using Alias and context.
  • Database development with Python DB - API, SQL, MS SQL Server.
  • In-depth knowledge in building/maintaining Repository, Universes and creating ad-hoc reports.
  • Working in both Semantic layers of Business objects like Universes and Business views as Data source for Crystal reports.
  • Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
  • Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
  • Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
  • Familiar with Oracle BI Apps (OBIA) 7.9.x modules- Sales, Service, Marketing, HR, and Finance.
  • Expertise in full life cycle Business Intelligence implementations and have an understanding of all aspects of an implementation project using OBIEE 10.1.3.x/Siebel Analytics 7.x.
  • Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository (.rpd)using Oracle BI Administration Tool.
  • Experienced in up gradation and migration of OBIEE between dev/test/prod environments
  • Proficient in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Standard Snow Flake schemas.
  • Skilled at creating and scheduling iBots in Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
  • Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables and configuring object level and database level security.
  • Well versed in working with ETL Tools such as Informatica Power Center/ Power Mart 8.x/7.x in creating Source/ Target definitions, building Mappings/ Mapplets and creating and monitoring Sessions/ Workflows.

TECHNICAL SKILLS:

Tableau: Tableau Desktop 10.x/9.x/8.x, Tableau Server 10.x/9.x/8.x,Tableau Mobile.

OBIEE: (OBIEE11g), Oracle BI Admin Tool, Catalog Manager, Answers (Analytics), Dashboard, BI Publisher, and Delivers.

BI TOOLS: SAP Business Objects 4.1, XI 3.1.

Business Intelligence Tools: OBIEE 10.1.3.x, Siebel Analytics 7.x Databases Oracle 9i/10g, MS SQL Server 200x, MS Access Database Tools TOAD, Oracle SQL Developer

Oracle Financials App: GL, AR, AP, FX.

Databases: Oracle Teradata and MySQL, SQL Server .

Oracle Admin: Enterprise Manager, WebLogic Console.

Languages: SQL, PL/SQL, R, Python XML, SQL*Plus.

Operating System: Windows 7/8, Windows NT, UNIX.

Management Tools: Control-M.

ETL: Informatica Power Center Versions 9.0.1.

PROFESSIONAL EXPERIENCE:

Confidential, Stamford, CT

Tableau Developer/ Admin

Responsibilities:

  • Worked with various teams to design and develop tableau reports and visualizations according to business user requirements
  • Migrated various reports from excel to Tableau 10.X
  • Implemented best practices to develop optimized tableau reports and published them on the server
  • Extensively used calculated fields, LOD expressions and table calculations .
  • Leveraged regular expressions in tableau to extract key value pairs in nested JSON
  • Participated in tableau user group meetings to learn new implementations of tableau environment.
  • Wrote stored procedures and views exclusively for tableau data source.
  • Built custom admin views for users, workbooks, data sources usage on tableau server by querying the postgres Sql repository.
  • Wrote power shell scripts to send tableau reports to users on a weekly basis with specified parameters by leveraging tabcmd utility.
  • Wrote power shell scripts for tableau server backup and maintenance with tabadmin utility.
  • Write azman scripts to create stores and roles for tableau server users management.
  • Implementation R and Python for data analysis in tableau server as an external host .
  • Performed upgrades, configuration of Kerberos and SSL configuration of tableau servers.
  • Managed user access and permissions for projects and individual workbooks.
  • Wrote power shell script to alert the users in case of extract failures by using a dsn odbc connection to tableau postgres repository.
  • Laid out an upgrade plan and co-ordinated with different teams to perform pre and post upgrade tasks. co-ordinated with mobile iron team to implement and configure tableau mobile for users inside the organization.
  • Helped the users in trouble shooting issues with embedded views from tableau server in their applications.

ENVIRONMENT: Tableau Desktop,Server 10.x/9.x, Tableau Mobile,SQL Server 2012,Postges SQL, pgadmin, powershell v4.

Confidential, Jersey City, NJ

Tableau Developer

Responsibilities:

  • Understand the Requirements and Functionality of the application from specifications.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
  • Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
  • Converted existing BO reports to tableau dashboards
  • Created different KPI using calculated key figures and parameters
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Developed donut charts and implemented complex features in charts like creating bar charts in tool-tip.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
  • Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Also involved in administration tasks such as Setting permissions, managing ownership and providing access to the users and adding them to the specific group.
  • Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

ENVIRONMENT: Tableau 9.x, Business Object 5x, Amazon Redshift.

Confidential, Roseland, NJ

TABLEAU / ETL - BI / BO Consultant

Responsibilities:

  • Involved in discussing Requirement Clarifications with multiple technical and Business teams.
  • Involved in developing Functional Design document based on client requirements.
  • Provided technical solutions to resolve complex issues.
  • Connected BW data by using Tableau server.
  • Resolved long running SQL queries in tuning SQL for better performance.
  • Involved in developing dashboards using Tableau.
  • Generated Tableau reports with Trend lines.
  • Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
  • Performed incremental extracts for OLAP database.
  • Generated Tableau combination charts using Tableau visualization software.
  • Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
  • Involved in creating and visualizing dashboards using Tableau Desktop.
  • Developed various dashboards, used context filters, sets while dealing with huge volume of data.
  • Generated dashboard for Finance team, provided security by using user filters.
  • Created adhoc reports to users in Tableau by connecting various data sources.
  • Developed Tableau dashboards with combination charts for clear understanding.

Environment: Teradata, SAP BW 7.3, Tableau 8.0

Confidential, Cincinnati, OH

BI Developer

Responsibilities:

  • Involved in business requirement analysis and responsible for providing LOE for Tableau reports and dashboards
  • Created various Tableau dashboards and visualizations using filters, custom calculations, parameters and dashboard actions etc.
  • Developed Critical Performance dashboards in Tableau for Dish External Regional Service Providers RSP and Sub-Contractors SUB
  • Created Daily Average, Weekly Average, Day of Week averages, 8/16 week Averages and various other custom calculations to show the performance for RSP's and SUB's
  • Reported on various other metrics such as Daily work order completion rate, Survey Scores, Trouble call work order rates etc.
  • Executives use the performance dashboards to give incentives and bonuses to RSP's and SUB's
  • Leveraged user level security for Tableau Dashboards to be able to display data pertaining to RSP's/SUB's who logged in • Implemented tableau data extracts and created dependencies to trigger subscriptions once the extracts are finished through TABCMD utility
  • Increased the existing dashboards performance by decreasing the report rendering time from 3 mins to 15 sec.
  • Created tableau visualizations for Sales Channel training groups
  • Dashboards show the training quizzes completion rate and scores obtained by users, their supervisors and also aggregated by the locations
  • Leveraged tableau built in graphical capabilities to create bar charts, tree maps, area charts and also created custom visualization like donut charts, trellis plots etc.
  • These dashboards also contain drill down capability to be able to drill down from country to state to city to Supervisors to individual user level
  • Created Tableau dashboards and reports for Dish Retailers to show their daily, monthly activations over the course of 24month period
  • Various Slicing and Dicing capabilities like by the Activation Plan, Credit Score Buckets, Language etc. are provided in the form of filters to give ad-hoc reporting capability
  • Leveraged dashboard actions to provide drill through capability to individual account level
  • Implemented Row level security for the reports to be able to restrict data related to a particular retailer who logged in • Responsible for administrative tasks like creating schedules for subscription, extracts etc.
  • Imported users and groups and provided permissions in Tableau Server manually and though TABCMD scripts.

ENVIRONMENT: Tableau Desktop 8, Tableau Server 8.0, MS Office Suite, Teradata, Oracle, SQL Server, MS Excel.

Confidential, Cambridge, MA

Data Warehouse Developer

Responsibilities:

  • Extensively involved in Coding PL/SQL, Packages, Procedures, Functions and Database Objects according to Business rules.
  • Extensively coded Forms, Reports using Developer.
  • Performed tuning the application (includes Packages, Procedures, Functions, Triggers and Database
  • Objects)
  • Created Database Objects (indexes) to boost the performance of the Application.
  • Extensively involved in coding of Triggers, Packages in the Application Level at each and every Transaction.
  • Database Triggers, Cursors were used for the Data Validation at every Transaction level.

Environment: Oracle 7.x, SQL, PL/SQL, Developer/2000 (Forms 4.5, Reports 2.5) and Sun Solaris/Windows.

Confidential

SQL DEVELOPER

Responsibilities:

  • Perform database consistency checks at regular intervals.
  • Monitor SQL Server activity through profiler.
  • Developed stored procedures used by application developers for displaying reports.
  • Modified existing database by adding tables and establishing the relationships using constraints.
  • Created Data Models using Erwin tool.
  • Created several stored procedures to Archive the old data in the database.
  • Wrote custom T-SQL Stored procedures to improve performance, preserve referential integrity, and provide additional application functionality for maintaining hierarchal data.
  • Created SSIS Packages.
  • Knowledge of Database Performance Monitoring tools.
  • Migration from SQL Server 7.0 to SQL Server 2008
  • Maintained and improved high availability and disaster recovery strategies for the database and fail-over methods.
  • Developed reports using complex formulas to query the database to generate different types of ad-hoc reports using Crystal Reports.
  • Experience working with ASP.NET as frontend team.
  • Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
  • Scheduled jobs for Backup, and created alerts for error reporting.

Environment: SQL Server 2008 Enterprise Edition, T-SQL, Excel, Erwin, Windows 2008/XP, Visual Studio, Crystal Reports.

Hire Now