Candidates About

 

Sai Tableau

BI DEVELOPER

Professional Summary:

·      7+ years of IT experience in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools

·      4+ years of extensive experience with design and development of Tableau visualization solutions.

·      Certified Tableau Desktop 9 Qualified Associate with extensive experience in Tableau Desktop, Tableau Server, Tableau reader in various versions of Tableau (7.x/8.x/9.x) SQL and various ETL tools.

·      Good understanding of Data Modeling techniques employing Normalization and Data Warehouse concepts using Star schema and Snow flake schema modeling, Fact and Dimensions tables, Physical and Logical Data Modeling.

·      Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.

·      Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.

·      Efficient in identifying and analyzing Business requirements from documents and end-user discussions and deliver the data requirements necessary to support DW subject areas.

·      Extensive experience on designing database using ER modeling and Normalization

·      Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.

·      Experience in aggregating data and configuring reports from different data sources using data blending.

·      Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. and other making use of actions, other local and global filters according to the end user requirement.

·      Extensive knowledge in various reporting objects like Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Parameters etc.

·      Author training documents and run monthly training to facilitate user adoption

·       Designed scheduled reports, events and bursts that dynamically extract different time period values

·       Created dashboard for leadership that covers all important metrics

·      Hands on experience in embedding Tableau reports and dashboards on external websites using Java API scripting.

·      Good knowledge on Embedded views of Tableau with web applications to integrate reports.

·      Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development

·      Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.

·      Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for developed ETL Mappings.

·      Experience in guiding onshore/offshore development teams to build dashboard applications, developing templates and development framework, design standards and implementation plans.

Technical Skills:

Analytical Tools	Tableau Desktop/Server(9.0,9.2,10.2), SSRS, Crystal reports
ETL Tools	DataStage, Informatica, SSIS
Requirements Management	Microsoft Office (Word , PowerPoint   Excel)
RDBMS and SQL Tools	Teradata, Oracle, SQL Server, Toad, SQL Assistant, SQL Plus
Languages	C, C++ , C# , SQL ,T-SQL, PL/SQL,HTML
Methodologies	Kimball/Inmon, OLAP, Waterfall, Agile
Data Modeling Tools	ERwin, ER Studio, MS Visio
Operating System	Windows family , Unix, Linux

 

 

Professional Experience

 

UBS, Chicago, IL                                                                                                                                                 Jan 2016- till date

Role: Sr. Tableau Developer/ Sr. Data Analyst

Description: UBS is a diversified financial services company providing banking, investments, mortgage and consumer and other commercial services across North America and internationally. Worked on a project loan monitoring system which is intended to deliver a system to support credit management for the bank. The system is used for accepting loan forms and generating detail history on loan.

Responsibilities:

·      Worked with internal management and team members to understand and clarify reporting requirements / needs.

·      Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.

·      Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.

·      Identify key business metrics measurements and develop methods to represent data in support of the measurements.

·      Provide guidance and insight on data visualization and dashboard design best practices in Tableau

·      Creating customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle and performing data blending in reports.

·      Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.

·      Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.

·      Stretched Tableau limits to create unconventional Tableau charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Heat maps and logical calculations to create groups.

·      Designed and developed Big Data analytics platform for processing customer viewing preferences using Java, Hadoop, Hive and Pig.

·      Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.

·      Embedded Tableau reports/dashboards on to the external web pages.

·      Provide innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.

Environment: Tableau (Desktop/Server) 9.x/8.x, Teradata 15, Oracle 12c/11g, Teradata SQL Assistant, Java API, Putty, UC4, Microsoft Office.

 

Florida Department of Health, Tallahassee, FL                                                                                 Jul 2015- Dec 2015

Role: Sr. Tableau Developer

Description: Florida Department of Health administers healthcare programs, such as Medicare, Medicaid, Children's Health Insurance Program (CHIP), and these three major national healthcare programs benefit about 100 million Americans.

Responsibilities:

·      Worked with Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.

·      Produced accurate analyses of fraud data as defined by the required specifications.

·      Manage the application’s users, groups, licenses and integration with Active Directory.

·      Perform production readiness audit of tableau applications developed by the development team or users.

·      Maintain professional links with project clients as directed by the manager, particularly with regard to the collection and analyses of their data, including responding to ad-hoc queries or requests and to gain an understanding of their needs.

·      Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.

·      Involved in design and implement tableau security, and worked with other team members to establish right physical architecture /layout.

·      Performed administrative and support activities across a multi environment tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.

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

·      Gathered Data from FWIR, RTQ and Epay application analysts and used SQL server analytic and integration services to organize the data, integrate the data and clean the data.

·      Provide Line of Efforts (LOE) for the requirements using the tool.

·      Developed interactive Dashboards and created reports like The areas in which fraud can occur, To find data patterns amongst data elements, stratification of numbers, Validating the entry dates, Identifying the missing values  in sequential data where it should not be none etc. to minimize the fraud occurrence.

·      Communicate requests to development teams to support appropriate staging and configuration of data to make dashboard more per-formant.

·      Created different visualizations e.g. side by side bars, Scatter plots, Stacked Bars, Heat Maps, Filled Maps, Symbol Maps and predictive models according to deliverable specifications.

·      Developed and Maintained Universes by defining joins, cardinalities between tables, applying contexts and alias tables to remove cyclic dependencies using TOAD .

·      Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.

·      Provided 24/7 production support for Tableau users.

Environment: Tableau Server 8.0, Tableau Desktop 8.0, Oracle, TOAD 7.0, MS Excel 2010, Windows, UNIX

 

Kitara Media Corp, Jersey City, NJ                                                                                     Aug 2014- Jun 2015

Role: Tableau Developer

Description: Kitara Media is a digital media company bringing together video, display and mobile strategies to offer advertisers and publishers a robust full-service solution for today’s ever changing digital landscape.

Responsibilities:

 

·      Design, and development of reports, and dashboards connecting to data marts, and cubes. I have used a combination Tableau, SQL Server reporting Services (SSRS), Excel and Power Pivot to expose data to the business users. I have built tactical reporting solutions using tools such as Tableau to connect to heterogeneous data sources using logical data relationships. The knowledge gained has been used to build a strategic data warehousing platform, and reporting systems.

·      Created appropriate technical documentation. 

·      Shared knowledge within a dynamic team. 

·      Worked as part of team as well as independently with minimum guidance. 

·      Performed code reviews for other team members. 

·      Prepared estimates of effort and duration for development tasks and activities. 

·      Identified and validates solution interfaces, dependencies, and integration points. 

·      Ensured that developed code is compliant with best practices, standards, and enterprise architecture. 

·      Worked on “big data”/Hadoop to development Data Model.

·      Participates in and supports quality assurance and testing. 

·      Responsible for ongoing support and troubleshooting.

·      Analyze, study and understand business domain data requirements, user task flows and objectives and create pixel perfect design solutions for visual data delivery and analysis.

·      Develop multiple prototypes, mock ups and conceptualization of ideas that bring simplicity and context to complex design challenges.

·      Identify and promote design best practices in data visualization that promote user friendly solutions and high quality products.

·      Develop Extract/Transform/Load processes using SQL and Excel.

 

Environment: Tableau Desktop/Server, Distributed systems, DB2, Windows XP, Oracle 11g, UNIX

 

 

 

Crompton Greaves, India                                                                                                                            Nov 2011– Jul 2014

Role:  Crystal Reports Developer

Description: CG is a USD 2 billion engineering conglomerate with an impressive and diverse portfolio of products, solutions and services ranging from high-end power and industrial equipment and solutions, to consumer products and home appliances, addressing myriad needs. Enjoying a reputation of stature for over seven decades, CG, which originates in India, has transformed itself into a global corporation. With a permanent footprint and manufacturing facilities in nine countries across Asia, Europe and North America, CG is fast emerging as a first choice supplier of high quality, “smart” electrical, industrial and consumer products and solutions all over the world. 

Responsibilities: 

·      Responsibilities include understanding the business functionality, direct interaction with users for specifications.

·      Designed and developed reports using Crystal Reports.

·      Written Stored Procedures and Views on SQL Server 2000 to be used in various Crystal Reports.

·      Involved in Physical/Logical design of database, creating and managing the database and all the database objects.

·      Developed and modified applications, authored database procedures and triggers for data processing.

·      Experience in writing, testing, and implementation of the PL/SQL triggers, stored procedures, functions, and packages to implement business logic.

·      Worked on SSRS extensively to create and design reports.

·      Created entry forms/reports for various modules. Created databases, loaded initialization data, generated users, and assigned roles and access.

·      Generated the reports and giving those reports to users for verification.

·      Responsible for drafting documentation for end user usage and develop training materials.

·      Responsibilities included setup and troubleshooting final product on user desktops.

·      Developed database connections, SQL joins, loops, views, aggregates.

·      Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports2008 (12).

·      Used prompts, alerts, drill down analysis as per the end user requirements.

Environment: Crystal Reports2008 (12), SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), TOAD and PL/SQL.

Surya Electronics, India                                                                                                    Aug 2010 to Nov 2011

Role: Crystal Reports Developer

Description: Surya Electronics is focused on creating sustainable value growth through Innovative Solutions, Quality, Business Ethics and Customer Delight. For the past 15 + years Surya Electronics has provided services to meet industry’s expanding technology needs and we are proud to be involved in this vital industry.

Responsibilities:

·      Involved in requirement analysis and planning of delivering projects using Waterfall model

·      Manage in-house MS Access databases and work with users to develop new Access database solutions that create efficiencies and provide for easier entry of and access to data. 

·      Using Crystal Reports, Access, Excel and SQL, produce reports that provide the organization’s leadership with targeted statistical information for planning, research and communications purposes. 

·      As needed, design new reporting and query options, transforming raw data into useful, actionable information. 

·      Provide training and support in the use of database software and MS Office applications. 

·      Primarily involved in migrating existing manually recurring reports and processes to automated and scheduled Crystal Reports 2008 objects in a Business Objects environment.

·      Create training guides and reference materials to support users in the rollout of new applications, and document database systems and procedures. 

 

Environment: Crystal Reports 2008, SQL Server, Quality Center, Windows XP, Excel Reports, MS Office Suite (Word, Excel, PowerPoint)