Uday kumar

• Over 9+ 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.

 

• Experience in complete Software Development Life Cycle (SDLC). Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Data analytics Reports.

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

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

 

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

 

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

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

 

 

 

WORK EXPERIENCE

 

Sr .Tableau Developer

 

Client : Bank of America                    

Location : Austin, TX

Duration :July '16 to Present

 

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. Designing and developing data warehouse and Amazon Redshift BI based solutions.

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

 

•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 Tabadmin 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

 

•         Effectively communicated with team members and Business teams to Tableau the requirements to ensure the correct functionality is achieved. Designed and implemented SSL server authentication for Redshift clusters.

 

 

•         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 workstreams, 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.

 

 

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

 

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

• 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, MySQL, API Development Toad, Netezza, AWS, VLOOKUP, SAS, k90Talend, Data Microsoft Excel 2007 , Java Script API, MS Access, Windows 2007 server, Informatica.

 

Sr .Tableau Developer

 

Client : Capital One

Location : Plano, TX

Duration : Jan '14 to May '16

 

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.

 

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

• Designed SSL client authentication for Redshift clusters. 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.

 

 

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

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

 

•Effectively used data blending feature in tableau and tested required queries and reports before publishing.

 

•Create, customize & share interactive web dashboards in minutes with simple drag & drop.

 

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

•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. Created User Groups, Roles to implement the 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 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.

 

•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, VLOOKUP, JavaScript API, IVR, AWS, Microsoft Office Suite (Word, Excel, PowerPoint), Alteryx Designer, OLAP, MS Access

 

Sr. Tableau Analyst

 

Client : AT&T

Location :Richardson, TX

Duration : June'11 to Dec'13

 

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 the entire 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.

 

•Extensively used Talend Bigdata 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: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2008, VISIO, T-SQL, SSIS 2008.

 

 

SSIS  Developer

 

Client : Hudson City Bancorp, Inc

Location : Paramus, NJ

Duration : Feb'10 to May'11

 

Responsibilities:

 

•         Understand the data requirements from the business analysts to analyze the source data and derive required datasets.

•         Designed and developed the ETL process (SSIS packages) to make the data available from various relational databases, excel, flat files etc., for analysis and reporting purposes.

•Utilized multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union-all. Created various types of reports like Tables, Matrix, List, drilldown and drilldown.

•Utilized event handling effectively to generate audits and logs for the generated SSIS packages.

 

• Created OLAP Cubes using SQL Server Analysis Services 2008. Created Database Objects like Tables, Views, Stored Procedures, Indexes and Triggers.

•Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.

 

 

•Written the Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data

•Involved in for end-to- end testing, Data Validations and Reconciliation of the Data. Responsible for project documentation, maintaining scripts

 

Environment: Microsoft SQL Server 2005 Enterprise Edition, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Windows server 2003 and IIS 5.0, Visual Source Safe.

 

SSIS  Developer

 

      Client : Prism Life Sciences

      Location : Mumbai, Maharashtra

      Duration : July '08 to Jan '10

 

 

Responsibilities:

 

•         Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.

• Validated change requests and made appropriate recommendations. Standardized the implementation of data.

• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.

•         Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.

•Managed user access and Created new security accounts. Performed Backup and restore of databases.

 

•Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.

•         Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.

• Updated the statistics information for both the old and new servers. Assisted with various ad hoc query requests. Provided back-end support for functional testing and performance testing.

 

Environment: SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS.