We provide IT Staff Augmentation Services!

Sr. Tableau Architect/ Developer Resume

Cedar Rapids, IowA

PROFESSIONAL SUMMARY:

  • Tableau Solution Consultant with 7+ years of professional experience in Business Intelligence Tools and Database Design in Information technology with skills in all phases of Data Warehouse lifecycle developments, Risk Market analysis predictive in Fraud claims. Client/Server Applications and Internet Applications. Handling Critical and Sensitive data with Banking (Mortgage) and Insurance domains.
  • Strong SQL platform to derive and develop code and construct the data in multiple various according to the user needs.
  • Solid experience in development, installation, administration, migration, configuration, technical support, troubleshooting, maintenance and overall health of the Tableau implementations.
  • Experienced with Create/Manage Groups, Users, Workbooks and Projects, Database Views, Data Sources and Data Connections in Tableau.
  • Anticipating trends to with the analytics process to
  • Transforming the claim process with predictive analytics, insurers can use data to determine events, or other factors that could affect the outcome of claims.
  • Insurance analysis through robust data governance, security and data source integration
  • Analyzing data to react on the market and put the needs up to date even in critical times.
  • Detect Fraudulent claims and mitigating the loss.
  • Quickly assess potential insurance fraud and subsequent loss with annual trend monitoring, geographic hotspots, and type of coverage
  • Experienced in Add/Edit Sites and corresponding administration rights (System vs. Content)
  • Experienced with Tableau backup and restore.
  • Experience with reading through Tableau logs to work through problems finding root causes and rectifying.
  • Experienced with alternative authentication providers such as Active Directory.
  • Respond to and resolve tickets on technical issues related to Tableau Platform within defined SLAs.
  • Co - ordinate with Tableau Support for any unresolved issues and tool specific issues or hot fixes/patches.
  • Experience with reading through Tableau logs to work through problems finding root causes and rectifying.
  • Installation, Upgrade, maintenance and support of all Tableau components.
  • Experience in implementing patches including both minor and major upgrades to ensure the Tableau have constant uptime and proper tuning.
  • Experienced in troubleshooting performance issues, capacity planning and load balancing both scheduled and ad-hoc reports.
  • Expertise in configuring, administering, managing, maintenance all upgrades and support of the Business Objects BI 4.2/4.1/XI 3.1/XI R2,Crystal Reports 2013/2008, SAP Data Services 4.2 and in migrating the Business objects from 5.1.x/6.1.5/6.5,Crystal Reports 10/9 to Business Objects XI R2/R3, BO 4.x.
  • Extensive experience in designing, implementing, and managing MicroStrategy Suite in a large enterprise data warehouse environment.
  • Experience in identification of Business and Data requirements and converting them into conceptual and data models using Erwin, Oracle Designer, MS Visio etc.
  • Extensive database experience using Oracle (11g, 10g, 9i & 8.x), MS SQL Server 2000/2005, DB2, Teradata and MS Access.
  • Detailed understanding and experience with Data Transformation / ETL processes, JBDC and ODBC.
  • Excellent interpersonal skills, motivated, energetic team player with demonstrated proficiency for learning new tools and business environment with excellent communication and analytical skills.

TECHNICAL SKILLS:

Reporting Tools: Tableau 8.x/9.x/10.x /2018, Tableau2018/10.5/10.0/9.x/8.x/7.x Tableau Desktop, Tableau Server, Tableau Reader, Tableau Online, Tab jolt, Tableau Prep, JavaScript API , REST APIs MicroStrategy BI 10.11/10.4

ETL: SAP Data Services 4.2, Data Stage, INFORMATICA 8.6/7.1/6.2 (Power Mart &Power Center), Data Integrator XI/11.5 Alteryx v 11.7/10(Alteryx Designer, Alteryx Server, Alteryx Connect), Informatica Power Center 10.1/9.x

Amazon Web Services: Amazon S3, EC2, Redshift, Aurora

Server Tools: AppDynamics, Unified Infrastructure Management, WinSCP. TOMCAT 7/6/5.5, Web Logic Application Server 9.x, Web Sphere 8.0/6.1/5.0, IIS. Snowflake

Testing Tools: HP Quality Center, IBM Rational Manual Tester

Programming: Python, SQL, PL/SQL, JavaScript, HTML, XML, R, PowerShell

Tracking Tools: Rational Suite (Jazz, Clear Case, Clear Quest), IBM Smart Cloud Control Desk

HADOOP/Big data: No SQL Database, Cloudera, Apache Spark

SAP Business Objects Business Intelligence: BOBI 4.1/3.1/XIR2 (WebI, BI Launch Pad, IDT, CMC)

Domains: Media, Technology, Healthcare, Financial Markets, Manufacturing and Logistics, Supply Chain Management.

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2012/2005/2000 , Teradata V14/13/12, DB2 V9/10.5, MS-Access, My SQL 5.5

Languages: PL/SQL, T-SQL, VB Script, HTML, XML, Unix Shell Scripting

OS: Windows 8/7/2012/2008 , Red hat Linux 6/5.11, IBM AIX 5.1/5.3, Sun Solaris 8/9

Servers Tools: Erwin 4.1/3.5, TOAD 6.5, SQL Navigator 4.1, SQL Developer, Load Runner 7.5/9.0

PROFESSIONAL EXPERIENCE:

Confidential, Cedar Rapids, Iowa

Sr. Tableau Architect/ Developer

Responsibilities:

  • The Mortgage integrated Data Environment ( MIDE ) is an extensive effort requiring collaboration across multiple teams across United Fire Home Mortgage
  • The successful implementation of the MIDE program will provide the opportunity to query and report across loan origination and servicing systems
  • Developed complicated Date Calculations like Rolling 12 MTD, Partial Calendar and Current Calendar for different MTD, QTD, YTD, 3 Months, and Previous Year Calculations. political and market views up to date and be ahead with the information than our competitors.
  • Leverage your data to share key KPIs across the organization to enable business users to make data-informed decisions.
  • Market Trends and providing the necessary analytics keys to invest in building a new platform for streaming health plans
  • Fact in analyzing Healthcare Payer Customer Benefits and driving towards future directions
  • Building data analytics to target more in digital marketing strategies and artificial intelligence to improve customer care protocols.
  • Worked extensively with Advance analysis actions, calculations, parameters, background images, maps, trend lines, statistics and table calculations.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Experience in integrating Tableau server With AWS Cloud computing platform to provide the Flexibility for Designing the and publishing the Dashboards to the Tableau server.
  • Launching for set up of Tableau server in AWS using AWS Virtual Private Cloud (VPC), EC2 Virtual Machine (VM)
  • Used Alteryx to wrangle or blend data (on need basis) and Tableau to develop the dashboard and finally publishing via Tableau Server.
  • Extensive experience in various Tableau Desktop objects like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table calculation, Calculated Fields, Sets, Context Filters, Clusters, Custom Territories, Actions, Groups, Parameters, Forecasting, Data blending, Reference Lines/Band/Distribution and Trend lines.
  • Identifying Risk of Fraud and prevent potential fraud before it happens by gathering data after a claim is settled to monitor insured’s online activity for red flags.
  • Create calculation including string manipulation, arithmetic calculations, custom aggregations and ration, date math, logic statements, level of detail and quick table calculations.
  • Navigating to data to analyze and choose healthcare choices through business process.
  • Checking the integrity in the payments and providing the solutions.
  • Medicare landscape to visualize and simplify in view the eligibility, services, enrolments and payments
  • Predictive analytics in insurance can help insurers identify and target potential markets
  • Experience in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
  • Leveraging existing documentation for Tableau Server , and Amazon Web Services
  • Worked extensively with Advance analysis actions, calculations, parameters, background images, maps, trend lines, statistics and table calculations.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Experience in integrating Tableau server With AWS Cloud computing platform to provide the Flexibility for Designing the and publishing the Dashboards to the Tableau server. leveraging existing documentation for Tableau Server, and Amazon Web Services (AWS)
  • Launching for set up of Tableau server in AWS using AWS Virtual Private Cloud (VPC), EC2 Virtual Machine (VM)
  • Risk Management and geological data representations to check the claims and new insurance policies.
  • Data management and knowing the market up to date to provide the better analytics and loops to beat the competitors
  • Created roles and implemented Row level security for user Authentication in Power BI
  • Used Alteryx to wrangle or blend data (on need basis) and Tableau to develop the dashboard and finally publishing via Tableau Server.
  • Extensive experience in various Tableau Desktop objects like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table calculation, Calculated Fields, Sets, Context Filters, Clusters, Custom Territories, Actions, Groups, Parameters, Forecasting, Data blending, Reference Lines/Band/Distribution and Trend lines.
  • Experience analyzing large data and creating visually compelling and actionable interactive reports and Dashboards using Tableau.
  • Participate in requirement gathering and analysis of Business needs and responsible for creation of Functional Specification Document.
  • Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards .
  • Responsible for creation of Detail design documents for reports and universes.
  • Experience in writing the SQL queries into Tableau for getting the desired results and writing the LOD expressions and using Table calculations into Tableau.

Environment: Tableau Desktop 8.2, 8.3,9.1,9.0, Tableau Server, MS SQL Server, Unix, MS Access, AWS, Alteryx.

Confidential, Peoria, IL

Tableau Architect/Power BI Analyst

Responsibilities:

  • Involved in upgradation of Tableau server 9.3 -> 10.0
  • Setup the Cluster environment in Prod
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau .
  • Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
  • Defined and created procedures to install Tableau desktop and server.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Experience Implementing Proactive Tableau Environment Health Checks and Performance Threshold Alerting
  • Tableau User Group and User Entitlement Administration
  • Experience with Tableau application performance monitoring, capacity planning, and tuning for multiple members on multiple projects
  • Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations
  • Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Power BI
  • Using Tableau Desktop created Interactive-reporting dashboards by combining multiple views.
  • As a Tableau Developer, using Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis.
  • Developing predictive statistical models using statistical analysis and other predictive modeling techniques.
  • Created calculated fields, parameters and action filters for building dashboards and worksheets in Power BI
  • Created roles and implemented Row level security for user Authentication in Power BI .
  • Created Workbooks and dashboards for analyzing statistical billing data using Tableau .
  • Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs.
  • Preparing Dashboards using calculations, parameters in Tableau.
  • Performed statistical analysis using third party method R
  • Managed datasets using Panda data frames and MySQL, queried MYSQL database queries from python using Python-MySQL connector and MYSQL db package to retrieve information
  • Developed wrapper in Python for instantiating multi-threaded application.
  • Integrated Tableau with JAVA-API and Interacted with Dashboard with HTML web page and captured actions

Environment: Tableau 10.1/9.3, JAVA API, R MODEL, Python, MS SQL 2016/2012, Oracle, Windows Server, TabMon, TabMigrate. Power BI

Confidential, Milpitas, CA

Jr. Tableau Developer / SQL Developer

Responsibilities:

  • Responsible for the Development of Data &Visual Analytics, Advanced Analytics, Complex Dashboard s and Data Integration for Operations, HR, Train Performance, Host Rail roads, End-point Performance, Safety measurements, Labor, Mechanical, and Labor Way side detectors Data, C IO/ CEO/ Management Data.
  • Installed, configured and supported Tableau 10.0 in a Distributed environment and Responsible for Tableau Server performance &Tableau Workbooks optimization.
  • Created Tableau Visualizations for YTD - Year to Date, MTD - Month to Date, YoY - Year Over Year, MoM - Month Over Month, WOW - Week Over Week Analysis.
  • Worked as offshore coordinator/Lead in this Global Delivery Model project.
  • Worked closely with customers for Requirements gathering, Knowledge Transfer.
  • Interacted with End Users, Cross Functional teams to Create & Support Visualizations, Reports

Technical Environment: Tableau 10.0 /9.3 (Desktop, Server, JavaScript, Amazon Web Services (Amazon Redshift, Amazon Aurora), Snow flake, Oracle 12c,Microsoft SQL Server 2016(SQL Server Management Studio, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS)), Team Foundation Server) , R(R Studio, IDE)

Confidential

SQL Developer / Tableau analyst

Responsibilities:

  • Responsible to Design and Development of Data Analytics. Tableau Dashboards & Support TableauServer.
  • Upgraded Pre TSM-Version of 3 mode Tableau cluster to TSM enabled Tableau cluster.
  • Worked on the GAP analysis in for the BI analytics platform to adopt new innovations in Analytics platform.
  • Tableau Prep has been used for Data Visualizations of Year Over Year, Month Over Month, Rolling Year, Year To Date, Month To Date Week Over Week Analysis.
  • Implemented Proactive Tableau Environment Health Checks, Performance Threshold Alerting and automating redundant Tableau Maintenance activities.
  • Design, implement, test & maintain major scalable Sybase T-SQL components
  • Define new product features in conjunction with product management & provide specifications
  • Ensure quality & completeness of the product through unit testing, documentation & maintenance
  • Provide 2nd or 3rd line support capability
  • Partnering with global teams to achieve successful business delivery
  • Knowledge of Sybase T-SQL or Microsoft MS-SQL
  • Strong ability to write & maintain stored procedures
  • Strong database analysis & design skills
  • Data Modelling tools/Diagrams/Documentation
  • Competence in Unix/Linux environments
  • Experience working on mission critical high-performance systems
  • A firm focus on quality & high attention to detail
  • Bright & enthusiastic, self-starter, highly motivated, comfortable taking the initiative and bringing ideas to the table
  • Ability to work independently or with others within a distributed global development team, and to deliver within strict timelines
  • Be flexible and adaptable

Environment: SQL Server 2016(SQL Server Management Studio, Azure, VSTS, SSDT, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS)), Python v3.7 (Git, PyCharm IDE)MS SQL Server, SQL, PL/SQL, SQL Loader, SQL Plus, TSQL

Hire Now