Home

VAISHU - TABLEAU BI DEVELOPER

[email protected]

Location: Nashville, Tennessee, USA

Relocation:

Visa: H1B

Employer : [email protected]; [email protected]; (609) 778-4215 ext 1000 Vaishnavi 7+ years of extensive experience with design and development of SQL BI and Tableau visualization solutions. Experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau. Experience in Data Warehousing and Business Intelligence applications design, development, Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analytical Services (SSAS). Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, Development, Testing, Reporting, Go-live and Reconciliation. Experience in using Tableau functionalities for creating different Requests, Filters, Chart, Interactive dashboards with Page and Dashboard Prompts. Experience in creating Tableau Scorecards, Dashboards, Heat maps using show me functionality. Extensive Experience with SQL Server relational database models and T-SQL in constructing tables triggers user defined functions ,views, indexes user profiles 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 per the end user requirement. Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services. Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau. Responsible for design, develop and maintain SSIS Packages. Experience in build and control flow data flow task in SSIS Using MS Data Tools. Extensive knowledge in Dimensional Data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling. Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 7.x ,8.x,9.x,10.x Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps. Effectively used Data blending feature in Tableau. Expertise in technologies like Data Warehouse (DWH), Data Visualization and Business Intelligence Concepts and BI Tools. Experience in guiding onshore/offshore development teams to build dashboard applications, developing templates and development framework, design standards and implementation plans. Excellent analytical, problem solving, communication and time management skills. SKILLS Analytical Tools Tableau Desktop/Server, Looker, Power BI, Denodo ETL Tools Informatica, Alteryx, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS). Tableau Tableau Desktop 2019.2/2018.3/10.5/10.3/10.0/9.2/9.1/9.0/8.3, Tableau Server, Tableau Reader, Tableau Online Requirements Management Microsoft Office (Word, PowerPoint Excel), TFS, JIRA, Confluence, Bitbucket Languages SQL, PL/SQL, TSQL, C, C++ RDBMS and SQL Tools Oracle, SQL Server Code Management Tools GitHub, IntelliJ Methodologies Agile, Waterfall Operating System Windows 10, Unix, MS-DOS, Linux EDUCATION 2020 MASTER S DEGREE COMPUTER SCIENCE, MONROE COLLEGE 2019 BACHELOR S DEGREE COMPUTER SCIENCE, MONROE COLLEGE EXPERIENCE JUN 2023 CURRENT BI DEVELOPER, JOHNSON & JOHNSON Developed Power BI reports and dashboards from multiple data sources using data blending. Assist end users with requests and problems regarding the reports, installing and configuring the gateway, connecting to different data sources. Collaborated with business users, collected requests and updated the set of existing BI reports to accommodate business needs. Utilized different functions in Excel to calculate data quickly and easily, making daily tasks more productive. Developed KPI scorecards using power BI desktop. Created and moved the tableau reports from one platform to another. Converted existing BO reports to tableau dashboards. Improved dashboard usability by implementing interactive visualizations resulting in a 20% increase in user engagement. Gathered business requirements from end users, analyzed and documented the same for various reporting needs. Effectively used data blending, filters, quick filters, data source filters, global filters, context filters, actions, Hierarchies feature in tableau. Design interactive dashboards in Tableau Desktop and published them to Tableau Server. MAR 2022 MAY 2023 SQL DEVELOPER, ANTHEM / ELEVANCE HEALTH Responsible for delivery of end to end application, system development and maintenance on complex multi technology platforms within assigned client group, business unit or corporate department and utilizing various customer technology platforms. Involve in writing T-SQL programing to implement stored procedures and functions for different tasks. Developed and own the list of final enhancements. Developed and defined application scope and objectives and prepared technical and/or functional specifications from with programs to be written. Performed technical design reviews and code reviews. Coordinated on-call support and ensures effective monitoring of system. Identified and proposed strategies around technical problems affecting team, communicated standards to get buy-in on solutions. Facilitated group sessions to elicit complex information on requirements clarification, design sessions, code reviews and troubleshooting issues. Developed Deployed and Monitoring SSIS Packages. Created custom Denodo views by joining tables from multiple data sources. Worked on unit testing for SSRS Reports, SSIS Packages and T-SQL Scripts. Maintained the technical development environment. Responsible for maintaining SSIs ETL, Dev, QA, production data warehouse and BI reporting environments. Worked on Bitbucket, maintained and troubleshoot build and deploy issues. Made changes to pipeline scripts, in order to add or delete new features as per DEV team's requirement. Work on source code repositories like GitHub and Bitbucket. Involved in performance tuning and monitoring of both T-SQL and PL/SQL Blocks. Created stored procedures and functions to support efficient data storage and manipulation. Extensively used joins and sub-queries for complex queries involving multiple tables from different databases. Developed ETL packages for cleansing, data integration, and transformation incremental loads incremental loads in the data warehouse using Microsoft SSIS/SSRS. Collaborated with multi-vendor global teams like business analysts, front end developers and testers. Created coaching tables in Denodo different database like MYSQL, Hadoop, Teradata, and Excel. Created the schema, implemented all stored procedures and SSIS packages, created the deployment scripts and managed the code in Microsoft Team Foundation Server. Designed, developed and maintained relational databases. Developed, implemented and maintained enterprise business information systems. Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients. Understand the Requirements and Functionality of the application from specifications. Designed, developed, tested, and maintained Tableau functional reports based on user requirements. Worked on all aspects of the engineering of the service, including such as performance, testing and deployment. NOV 2021 FEB 2022 SQL / TABLEAU DEVELOPER, JOHNSON & JOHNSON Created and moved the tableau reports from one platform to another. Converted existing BO reports to tableau dashboards. Developed advanced SQL queries to generate data reports. Dug into database details to ensure appropriate data filters, randomizations and stratifications are applied based on business requirements. Involved in writing queries with join conditions, correlated sub queries, and nested queries for the business application development. Utilized different functions in Excel to calculate data quickly and easily, making daily tasks more productive. Developed tableau dashboards, scorecards to track Jira team performance, agile planning dashboards for better project management and delivery using tableau desktop, managing tableau extract, and access permissions. Gathered business requirements from end users, analyzed and documented the same for various reporting needs. Effectively used data blending, filters, quick filters, data source filters, global filters, context filters, actions, Hierarchies feature in tableau. Design interactive dashboards in Tableau Desktop and published them to Tableau Server. Executed and tested required queries and reports before publishing. Provide guidance and insight on data visualization and dashboard design best practices in Tableau. Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis. Generated Interactive Dashboards with Quick filters, Parameters and URL Actions to handle views more efficiently. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau. Optimized tableau dashboards for minimal load time, eliminate performance bottlenecks using best practices. JUN 2019 OCT 2021 SR. TABLEAU / SQL CONSULTANT, JOHNSON & JOHNSON As a tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices. Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards. Created and maintained SOX documentation required for critical financial file systems. Mentored and trained less tenured Business Analysts for their development. Use tools such as SQL for investigation of issues and work closely with our Actuarial and Underwriting Customers. Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL Improved application performance by tuning SQL statements and fixing proper indexes, Designed data models. Created, maintained, and queried relational database (MS Access). Understand and use SQL regularly for problem analysis. Maintained the table performance by following the tuning tips like normalization, creating clustered and non-clustered indexes and collect statistics. Involved into updating procedures, functions, triggers, and packages based on the change request. Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production). Member of a team that created the proof of concept for the selection of the ETL tool (BI tool). Sat with vendors and evaluated vendor tools during the proof of concept. A member of the team that designed and created the infrastructure for a Data Store which was used for conversion and routing of information created outside of the company and moved to Safeco data source. Created SSIS packages to load data into SQL Server using various transformations in SSIS. Created specifications for the conversion of data outside of Safeco into legacy data. Learned and understood complexities of outside systems and was able to convert into Safeco terms. Work and communicate daily across departmental boundaries. Quickly and effectively diagnosed and responded to service desk requests regarding data integrity and functional or interactive issues in dashboards. Proven strong analytical and problem-solving skills. Team member of the data warehousing initiative - conducted interviews with high level management about their data warehousing needs. Willingness to learn new technologies. Enjoy working on the technical side as well leading project efforts. Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems Created incremental refreshes for data sources on Tableau Server. Created report schedules, data connections, projects, groups in Tableau Server. Implemented action filters, parameters, calculated filed and set 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. Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop. Strong presentation skills Attention to detail and quality. Ability to work independently and deliver around tight timelines. Coordinate with multiple technology teams on production releases and related administrative tasks. Able to thrive in an environment that requires flexibility and multi-tasking. JAN 2017 MAY 2019 SR. TABLEAU / SQL CONSULTANT, CONCORD MUSIC GROUP Designed, developed, and maintained Tableau functional reports based on user requirements. Mastered the ability to design and deploy rich Graphic visualizations with drill down and drop-down menu option and parameters using tableau. Involved in creating database objects like tables, views, stored procedures, indexes, user defined functions and other T-SQL statements using T-SQL to provide definition, structure and to maintain data efficiently. Used Snowflake functions to perform semi structures data parsing entirely with SQL statements. Implemented Event Handlers and Error Handling in SSIS packages. Extensively used joins and sub-queries for complex queries involving multiple tables from different databases. Expert in performing T-SQL DDL/DML/DCL commands using SQL Server Management Studio SSMS. Extensively involved in creating graphs by using dimensions and measures data from various data sources by using data blending concept. Aided in the design and development of the logical and physical data models, business rules and data mapping for the Enterprise Data Warehouse system. Extensively worked with dynamic SQL, composite data types and global temporary tables. Developed user defined functions based on the requirements and used various built-in functions. Worked on dimensional data modeling using snowflake schemas for fact and dimension tables. Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency. Solving P1 issues for the users in the production. Created spreadsheets, tables, and pivot tables, running and creating macros in Excel. Created different KPI s by using calculated fields. Developed Tableau data visualization using Cross tabs, Heat maps, Scatter plots, Geographic map, bar charts and line charts. Utilized Tableau server and Tableau online to publish and share the reports with the business users. Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's. Worked extensively with advance analysis actions, calculations, parameters, background images, maps, trend lines and table calculations. Utilized Tableau server and Tableau online to publish and share the reports with the business users. Responsible for creating calculated fields, bins, sets, groups, combined sets, and hierarchies using tableau desktop. Worked on all aspects of the engineering of the service, including such as performance, testing and deployment. Checked performance tuning, query optimization and indexing. Experience in creating and editing tableau prep builder flow files by cleaning, joining, merging, aggregating and union to prepare the data for analysis. Involved in creating a dual-axis chart with multiple measures. Implemented data blending to blend related data from different data sources. Created joins to combine the data from two or more tables or sheets based on the related data from the same data source. Implemented various types of filters such as data source filters, extract filters, context filters, dimension, and measure filters to provide correct information to the user by removing unnecessary data. Implemented cascading filters by selecting the data from one filter the other filter shows only relevant values. Created users, groups, projects, workbooks, and the appropriate permission setup for different site roles like publisher, interactor, viewer, unlicensed in tableau server logons. Involved in administration tasks such as Setting permissions, managing ownerships, and providing access to the users and adding them to the specific group. Worked on JIRA for defect/issues logging & tracking and documented all my work using CONFLUENCE. Extensively involved in creating action filters between the source sheet and one or more target sheets. Keywords: cprogramm cplusplus quality analyst business intelligence golang microsoft procedural language