Hima

ac34iw@r.postjobfree.com

704-***-****

Professional Summary:

Over 8+ years of extensive Experience in the Business Requirements Analysis, Development, Testing, Implementation and maintenance of Business Intelligence, Data warehousing, Client Server applications, Web applications and Tableau Platforms.

5+ years of extensive Tableau Desktop, Tableau Server Experience in Enterprise Environment, in various Tableau versions of 6.x, 7.x, 8.x, 9.x and 10.x as a developer and Administrator.

Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.

Created 1000+ worksheets and 200+ Dashboards in large BI environments using Tableau.

2+ Years of Experience in Talend Administration (Using TAC)

Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.

Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.

Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.

Reports development using various reporting tools like Tableau, SAS and SSRS.

Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.

Used R Programming and SAS Enterprise data miner for the analysis.

Experience in complete Software Development Life Cycle (SDLC).

Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Data analytics Reports.

Good knowledge on OBIEE and QlikView, Qlik Sense.

Experienced in OLTP, OLAP, GUI, Relational Database Management Systems (RDBMS) and Report Development.

Compiled and generate excel spreadsheets capturing key data using formulas, Pivot Tables, and VBA

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.

Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle

Extensive used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.

Implemented a User Based Collaborative predict the influence of politicians on their

Filtering Algorithm using R Programming and Python. Followers using MS Excel, R Language and SQL.

Extensive experience on building dashboards using Tableau and involved in requirements gathering/analysis, design (Mock ups, Proto types, frame works), development, testing and production rollover of reporting and Analysis projects.

Experienced in understanding database structures and writing complex queries in SQL.

Good Understanding of various analytical report KPI’s, Indicators and Gauges.

Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.

Expert in modeling, Extraction Transform Loading (ETL) using DTS and SSIS.

Expertise to Heterogeneous Data Sources data integration to Cognos and QlikView like Hive, Netezza, Oracle, MySQL, Share point Files, Flat files and Excel.

Expertise in design, analysis and implementation of data warehousing/ Power BI solutions using Tableau, Teradata, Oracle, Alteryx, Micro Strategy and Informatica.

Experienced in Data Analytics and Machine Learning with strong skills in analyzing large datasets using R, Weka and AWS.

Proficient in creating Tableau scorecards, Tableau dashboards using advance Tableau functions like calculated fields, LOD (Level of Detail), Ad hoc Calculations, etc.

Skilled in data manipulation & cleansing, visualization, predictive modeling, and regression analysis using R, Python and Tableau

Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, Greenplum, Netezza, MySQL, MS SQL Server

In-depth experience in End to End Testing Lifecycle Phases including Test Planning, Test Design, Test Execution, and Defect Reporting. Extensive experience in Microsoft Office suite (MS Word, MS Excel, and MS PowerPoint) and IAM web based reports.

Technical Skills:

BI Tools: Tableau 9x, 10x (Desktop, Server, Reader), Business Intelligence Development Studio (SSIS/SSRS), Web intelligence, Xcelsius 2008 and Crystal Reports, Alteryx, 2008 XI, QlikView, SAP, Qlik sense, Power BI, MicroStrategy and Cognos

ETL tool: Informatica Power Center 7/8, SQL Server Integration Services (SSIS), Data stage

Databases: Teradata, Oracle, Server 2000/2005/2008/2008R2/2012, DB/400, MS Access, Oracle 11g/10g, Excel Flat files, Sybase, Hadoop, DB2, Cloud Computing / Services Amazon Web services - AWS, Amazon Redshift, Hive (Cloudera Hadoop), Netezza, SAS, SQL server, Greenplum

Applications: Microsoft Office, ProClarity, AdobePhotoshop7, Adobe Illustrator, MS Visio, Visible Analyst

Operating Systems: Windows Server 2000/2003/2008, Windows 98/2000/XP/VISTA/7 UNIX, Linux, Solaris, Mac

Languages: C, C++, T-SQL, XML, UNIX, Oracle, Java, Python, VB, PL/SQL

Web Scripting Languages: XML, XHTML, JavaScript, Ajax, J Query, ASP 3.0, Visual Studio 2003/2005

Web Tools: MS-Front Page, Dream Weaver

Data Modeling tools: Star Schema Modeling, Snow Flake Modeling

Professional Experience:

Vanguard, Malvern, PA Oct 2017 – PRESENT

Sr. Tableau Developer

Roles and Responsibilities:

Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.

Created Tableau Bread Crumbs, using tableau filter actions for Tax reporting system Dashboard.

Developed Tableau Excel incremental refresh for year 2017 and up to Jan 2018 at vanguard for various financial dashboards.

Developed various dashboards, used context filters, sets while dealing with huge volume of data. Provided tableau desktop training for end users. Worked on creating Pivots, sets, groups, and parameters.

Worked on Creating various plots and drill down analysis using Tableau desktop. Worked on scheduling reports, managing data sources and refresh extracts. Developed SQL scripts to create database objects like Tables, Views and Sequences.

Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization and Financial dashboard

Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau.

Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.

Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Work with client and team members to understand and clarify visualization requirements and check performance tuning of dashboards.

Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.

Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.

Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.

Tested reports and uploaded tableau dashboards onto server and provided production support for tableau users

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Published the dynamic dashboard reports to Tableau server for navigating the developed dashboards in web.

Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.

Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.

Successfully administered users, user groups, and scheduled instances for reports in Tableau. Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau (Desktop/Server), MS SQL Server 2008, UNIX, Microsoft Office Suite (Word, Excel, PowerPoint), Teradata Administrator.

Client: CTIS, Rockville MD Dec 2015 – Sep 2017

Role: Sr. Tableau Developer/ Data Analyst

Roles and Responsibilities:

Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the reports specifications document and report inventory.

Worked on gathering and converting data over to Tableau using SQL/SAS/Excel data over to tableau reports and Dashboards.

Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data Creating New Schedule's and checking the task's daily on the server.

Involved in creating ad-hoc analysis and reporting requests in a timely manner for Business Risk related to fraud, Approval's, Declines daily, monthly and yearly.

Created organized, customized analysis and visualized projects and dashboards to present to executive leadership.

Created Complicated Calculation Based LOD (Level of detail) feature.

Expert in SAP Service Connections, Applying support packages, Add-on components, Kernel Upgrades and SPAM updates

Designing and developing data warehouse and Amazon Redshift BI based solutions.

Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.

Automated the incoming data intake using R Programming.

Involved in managing the application's users, groups, and integration with Active Directory

In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.

Evaluated database performance issues and executed database optimization.

Prepared backups using Tab admin and Tab cmd commands.

Promoted and supported the infrastructure of reporting and Power BI strategy, including standards and best practices.

Experience in designing and developing complex Talend/Data Stage jobs, routines

Use various data source like SQL server, SQL Analysis server (cube), Amazon Redshift, Hadoop and Hive

Expertise in installing, configuring, Clustering, Load balancing and Multi-node installation of Qlik view and Qlik Sense Environment

Act as a Tableau Administrator, using Tableau Server for publishing the developed dashboards to server, authentication, authorization, security, Tableau Extracts scheduling and refreshments, User Management Adding users and Groups, Content Restriction to users, to content based on access level as a Tableau Content Administrator

Effectively communicated with team members and Business teams to Tableau the requirements to ensure the correct functionality is achieved.

Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS

Created SQL Server Reports and developed query for generating drill down and drill through reports using Power BI

Formulated learning strategies for students on dummy datasets SAS UE, SAS 9.4, SAS Studio and R Programming Studio.

Acted as Tableau Developer (for designing and developing, proto typing the various dashboards using tableau desktop. Also involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering (Quick Filters, Cascading filters, context Filters), ranking, Top-N Analysis, hierarchies)

Involved in scheduling data refresh on Tableau Server for weekly and monthly basis on business change to ensure that the views and dashboards were displaying the updated data correctly.

Experience with managing multiple Data analytics work streams, spanning across data engineering, data science and data visualization- review.

Wrote heavy Netezza SQL scripts to load the data between Netezza tables and implemented ELT process for SCD type 1 and SCD type 2 dimensions

Implementation of Physical modeling on Teradata such as creation of tables, indexes, views, normalization.

Strong experience in creating the extensions using Java script both in Qlik view and Qlik Sense.

Involved in designing Amazon Redshift DB Clusters, Schema, and tables.

Security implementation among Congo’s applications using Access Manager Documenting API guides for development web portal.

Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.

Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.

Interacted with user groups for delivering 100+ enterprise Reports using SSRS/Crystal reports for various reporting needs.

Having good experience on Portal Administration in Congos Connection.

Connected to Amazon Redshift through Tableau to extract live data for real time analysis.

Environment: Tableau Desktop 9.x, 10.x, Tableau server, JavaScript API, Teradata, Tableau public, SQL Server, Data view, Alteryx, Hadoop, Oracle 10g, Excel files, Python, MySQL, API Development Toad, Netezza, SAP Hana, R Programming, AWS, VLOOKUP, SAS, k90Talend, Data Microsoft Excel 2007, Cognos, Java Script API, MS Access, Windows 2007 server, Informatica.

Client: Health Plan Services, Tampa, FL Jan 2015 – Nov 2015

Role: Sr. Tableau Developer/BI Developer/ Tableau Admin

Roles and Responsibilities:

Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.

Gathered user requirements, analyzed and designed software solution based on the requirements.

Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Designed and built statistical and machine-learning models and feature extraction systems in Python and R Programming

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality

Studied various Statistical Data Mining Methods, Random Forests, Neural Nets and applied them on data to get insights using R Programming.

Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Have clear understanding of Data Warehousing concepts with emphasis on ETL, BI and Life Cycle Development including requirement analysis, design, development, testing and implementation

Expertise in installing ECC/BW on HANA, Administration of HANA systems, HANA studio, HANA migration, S/4 HANA migration using DMO option, HANA system backup/restore

Managed selection, architecture and implementation of a SaaS reporting and Data analytics platform for medical data collection using Tableau analytics server technology to provide dashboard reporting and client project health in real-time using the web or mobile devices.

Created reporting solutions for clients incorporating cloud data warehouses, local data storage, Data analytics and various online platforms.

Power BI developer with skills as well to help deliver a set of dashboards.

SAP Solution Manager implementation activities like Installation, Post installation activities, Technical Monitoring for different SAP components like ABAP, Java, HANA, MS SQL, R programming, EWA configuration, MOPZ, Maintenance Planner, etc.

Monitor and plan for Teradata disk space quotas. Promptly respond to warnings that disk space is running low.

Extracted data from various sources like Oracle, Netezza and flat files and loaded into the target Netezza database

Involved in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI

Involved in writing complex SQLs using windowing functions to extract data from Amazon Redshift without Stored Procedure

Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.

Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.

Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.

Created Parameterized reports, Cross-Tab reports, Drill Down reports by using SSRS.

Administered user, user groups, and scheduled instances for reports in Tableau.

Handling big data loads to Qlik view and Qlik Sense and implemented impactful solutions.

Creating users, groups, projects, Data connections, settings as a tableau administrator.

Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.

Review new API development specification releases and update portal content.

Created rich dashboards using Power BI to deliver actionable insights for end client.

Python and R Programming and develop analytical and reporting solutions to visualize data and information using Microsoft Power BI

Designed schema in Amazon Redshift cluster to store EBS operational data optimally.

Experience in using Multi-Dimensional Expressions (MDX) to query the SSAS Cubes, identifying Key Performance Indicators (KPIs), and in creating Dashboards Score Cards using R Programming.

Design Amazon Redshift based Power BI solution platform for optimized performance and usability.

Maintaining server activities, user activity, and customized views on Server Analysis.

Worked on tab cmd to schedule the report's and setup email reports using command lines.

Environment: Tableau Desktop 9x, Tableau Server, SQL Assistant, SAP Lynx, SharePoint, Hadoop, Microsoft SQL Server, Terada, MS Visio, Greenplum, Excel files, MySQL, SSRS, SSIS, Toad, Python, VLOOKUP, JavaScript API, IVR, Cognos, AWS, R Programming, Microsoft Office Suite (Word, Excel, PowerPoint), Alteryx Designer, OLAP, MS Access

Client: Inter-American Development Bank, Minneapolis, MN Jan 2014 – Dec 2014

Role: Sr. Tableau Report Developer

Roles and Responsibilities:

Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects

Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.

Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.

Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.

Administered user groups and scheduled instances for reports in tableau.

Used Parameters, Calculated fields, LOD's, and sets to handle views more efficiently on Tableau Reports.

Built complex formulas in Tableau for various business calculations.

Extensively used SQL in command objects of Crystal Reports,

Enhance/modify existing reports by creating new Parameters, Formulas, Filters

Created User Groups, Roles to implement the Congos Security.

Explored on new feature like Teradata Virtual storage

Successfully integrated backend interface with hosted IVR in WSO2 Gateway that included: Building tokenized APIs with WSO2 API Manager and from Swaggers

Designed, developed, tested and deployed ECR (Enterprise Custom Reports) on internal and client environments using SQL Server Reporting Services(SSRS)

Schedule the reports using Info View to run at specific times in a day/week as desired by the Business Users using Business Objects Enterprise, Central Management Console.

Provided 24/7 production support for Tableau users

Combined views and reports into interactive dashboards in Tableau Desktop which are presented to End User.

Converted existing Crystal Reports and Xcelsius into Tableau Dashboards.

Involved in the validation of data in ETL and Power BI layer with the source systems

Wrote complex SQL queries on Netezza and used them in lookup SQL overrides and Source Qualifier overrides.

Experiences in migrating client’s reports from Micro Strategy, excel (static) based solution to an interactive service.

Environment: Tableau 8.2, Tableau 7 desktop, Tableau server, Oracle 11i, Informatica 8.x, Sql server, TOAD, MS-Access, JavaScript, crystal report 2008

Client: AT&T, Richardson, TX Oct 2012 – Dec 2013

Role: Tableau Analyst (Tableau Developer\Tableau Admin)

Roles and Responsibilities:

Involved in Exploring, Designing, Building, Testing and Deployment of the high-level dashboards for Board of Directors, Marketing Decision makers, Finance for critical metrics using Tableau Desktop

Involved in understanding the reporting requirements and providing Tableau reporting solutions.

Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.

Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

Understanding and translation of the current existing reporting system SSRS reports to convert them as Tableau reports and dashboards.

Configured Tableau server to use Kerberos, SSO solution so that all the authentication is handled by the SSO solution.

Installation and configuration of Tableau Products Tableau Desktop and Tableau Server in different environments DEV, STAGE and PROD.

Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.

Created stored procedures on Netezza and Oracle database to achieve complex ETL logic.

Applying SAP Notes, maintaining OSS connections, Generating Developer/Object keys.

Extensively used Talend Big data tool to load the big volume of source files from S3 to Amazon Redshift.

Developed complex SAS programs, macros for data updates, data cleansing, and reporting

Involved in publishing of various kinds of live interactive data visualizations dashboards

reports and workbooks from Tableau Desktop to Tableau servers.

Created actions parameters Filter Local Global and calculated sets for preparing dashboards and worksheets using Tableau Desktop.

Evaluated the quality of voice channel received in IVR systems

Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.

As a Tableau Analyst, used Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis. Also, to slice and dice the data, for analyzing the data of patterns, trends and fashions of various KPIs, Measures using various graphs, charts, indicators, and gauges.

Identified the factors involving the performance of the reports and coordinated in creation of indexes statistics to improve the query turnaround time efficiently.

Involved in Installation and upgrade of Tableau server and server performance tuning for

Optimization.

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.

Environment: Tableau Desktop 8, 9.1, tableau server 8.0,9.1, MS office suite, Hadoop, Teradata, Oracle, SQL Server, visual Studio 2010/2012, Greenplum, Informatica, MySQL, SSRS, SSIS, Toad, Netezza, OLAP, Excel files, Python, JavaScript API, SAS, AWS, R programming, MS Excel, IVR, Flat File Microsoft SQL Server 2005\2008 data base.

Client: In rhythm Solutions, Hyderabad, India May 2009 – Sep 2012

Title: SQL Developer/ ETL Developer

Roles and Responsibilities:

Assisted clients with physical database modeling, data archiving strategies, data purges and disaster recovery planning.

Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification, indexing and statistics update.

Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.

Expertise in developing SQL's and stored procedures for interacting with the database.

Strong Experience in developing Sessions/Tasks, Worklets, and Workflows using Workflow Manager tools - Task Developer, Workflow & Worklet Designer.

Experience working with ASP.NET as frontend team.

Designed, developed, and deployed reports in MS SQL Server environment using SSRS 2008.

Used DDL and DML to be writing Triggers, Stored procedures to check the Data Integrity and payment verification at early stages before calling them.

Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data

Involved in creating project related analysis, approach and testing documents.

Created/Maintained clustered/non-clustered Indexes for fast and efficient reporting process

Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster

Experience in UNIX shell scripting, FTP and file management in various UNIX environments.

Involved in writing T-SQL statements for retrieval of data.

Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.

Performed daily database backup & restoration, monitored the performance of the Server.

Experience in using the Informatica command line utilities like pmcmd to execute Workflows in non-windows environment

Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.

Environnent : MS SQL Server 2000, Enterprise Manager, MySQL, Toad, T-SQL, DTS, Netezza, OLAP, Query Analyzer, SQL Profiler, Star-schema, Snowflake schema, SSRS, SSIS, Crystal Reports, Teradata, Software Development Life Cycle – Agile, Tableau, Unix.

EDUCATION:

Bachelor of computer engineering, Jawaharlal Nehru Technological University, India

Contact this candidate