Candidates About

 

Hima

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.

·         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, SSIS, Spotfire 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).

·         Good knowledge on Spotfire, QlikView and 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.

·         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 Spotfire and SSIS.

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

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

·         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

 

Technical Skills:

BI Tools: Tableau 9x, 10x (Desktop, Server, Reader), Business Intelligence Development Studio (SSIS/SSRS), Web intelligence, Spotfire 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 Scale with Digital Dashboard.

·         Investing the data using Exploratory Analysis Data for Scale with Digital and FFS tax Reporting Dashboards

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

·         Utilized R-Studio and Tableau to clean, filter and merge datasets with over 200,000 rows and 100 variables to provide preliminary Exploratory Analysis and data 
visualization.

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

·         Worked on scheduling reports, managing data sources and refresh extracts and 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 and Develops and provides documentation, training, and support for Interactors and Power Users

·         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, Hadoop) using data blending. 

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

·         Developed and 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 Consultant    

Roles and Responsibilities: 

·         Gathering the report requirements from various stakeholders, SME’s, 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. 

·         Performing Exploratory data analysis on time-series data of macroeconomic indicators in R over three decades time horizons

·         Implemented Exploratory Data Analysis, Data Cleansing, Preprocessing and Feature Engineering. 

·         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 Complicated Calculation Based LOD (Level of detail) feature.

·         Automated the incoming data intake using R Programming. 

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

·         Prepared backups using Tab admin and Tab cmd commands.

·         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

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

·         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.

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

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

·         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, Crystal Report, 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:  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. 

·         Expertise in deploying SSIS Package, SSRS Reports and SSAS Cubes using command line utilities 

·         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

·          Conducting Exploratory data analytics for the combined data sources In Tableau to evaluate the relationships.

·         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 

·         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. 

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

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

·         Good 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. 

·         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. 

·         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: 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.

·         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.

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

·         Involves data collection, data cleanup, data transformation, Exploratory analysis, statistical Analysis and modeling.

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.

·         Understanding and translation of the current existing reporting system Spotfire, 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.

·         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