Vijaya Bireddy

904-***-****

adxxgu@r.postjobfree.com

Tableau Public:https://public.tableau.com/app/profile/vijaya.lakshmi.bireddy#!/ SUMMARY

• 6+ years of experience in IT Industry. Expertise in the field of Business Intelligence (BI) Analytics, Reporting & Dashboard development using Tableau 9.x/10.1/2018.x/2019.x/2020.x, ArcGIS, Looker.

• Experience in gathering Business requirements, Analysis, Design, Implementation, and documentation of various functionalities of Data marts and Business Intelligence.

• Hands on experience in following the SDLC methodologies like Waterfall model and Agile model.

• Worked in all phases of BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation, and end-user training.

• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users, and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.

• Extensive experience with design and development of Tableau visualization solutions.

• Expert in writing SQL Queries, Dynamic-queries, sub-queries, and complex joins for getting the data into Tableau desktop.

• Well versed in Tableau products Tableau Desktop 2020.x, 2019.x, 10.x and 9.x, Tableau Server, Tableau Online, Tableau Prep and Tableau Public.

• Experienced in Tableau working with different Enterprise Data sources likes Hadoop HDFS, Alteryx, ServiceNow, Mongo DB, Google Cloud SQL, GCP, Google Big Query, Google Analytics, Planview, SQL Server, Data Lake, Oracle Enterprise Servers, AWS Redshift, JIRA, and the Extracts

(auto/incremental).

• Proficient in data visualization, Reporting, Analysis, Pie Charts Bar Charts, Cross Map, Scatter Plots, Geographic Map, Page Trails, Density Chart and other making use of actions, other local and global filters according to the end user requirement.

• Established Best Practices for Enterprise Tableau Environment and application intake and Development processes.

• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameters, and using Tableau calculations.

• Implemented Row level, Column level and Object level security in the universes to restrict the sensitive data.

• Experience in Migrating from Power Bi to Tableau.

• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.

• Hands on experience in developing geographical based dashboards via using ArcGIS.

• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint.

• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing, and processing, writing data extract scripts/programming of data conversion, and researching complex data problems.

• Experience in connecting snowflake, JIRA for getting the data into tableau desktop for creating visual reports.

• Deploy, Configure, Maintain Compute on Azure Cloud.

• Proficient in working with Azure Dev ops.

• Experienced in writing complex SQL Queries involving various tables using SQL joins and writing Sub Queries. Experienced in writing complex-SQL Stored Procedures and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity.

• Hands on experience in writing macros via using VBScript for data extracts and data prep

• Having experience on various data analyzing techniques, reports efforts estimation, Reports development planning.

• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables

• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies, and facts.

• Good independent/team working skills and experiences, excellent communication skills and Self- motivated team player with strong problem-solving skills and thirst to learn the advanced concepts within the field of interest.

TECHNICAL SKILLS:

BI Tools Tableau Desktop 2020.x, 2019.x,9.x,8.x,7.x, Tableau Online, OBIEE 11g, Languages C, Java, SQL, PL/SQL, TSQLand VB Script

Databases Oracle 9i/10g/11g/12c, SQL server 2012 Teradata, Sybase, MYSQL, GCP, Snowflakes, AWS Redshift, Excel

ETL Tools Informatica Power Center 9.x/8.x/7.x, Oracle Data Integrator Operating Systems Windows, UNIX (Linux, Solaris, AIX) Data Modeling Tools Erwin, Visio, Toad Modeler

Big Data Technologies Hadoop, Hive, HBASE, SQOOP, STORM Tools Informatica IDQ, Jira, Planview, ServiceNow

PROFESSIONAL EXPERIENCE:

Citi, Tampa FL 16 Sep2022 – Till Now

Sr.Tableau Developer/ BI Developer

Responsibilities:

• Experience in design and development of Tableau Visualization solutions.

• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

• Mapped and documented the data as per the requirement.

• Created graphs to determine profit generation by using measures and dimensions data from MS Excel.

• Experience in Migrating from Power Bi to Tableau.

• Created Relationship, Advance connections and join new tables,

• Actively participated in the business requirement discussions and reviewed business requirements for the purpose of creating visualizations/ dashboards.

• Analyzed data sources such as Flat files/Excel for designing, developing, and testing the reports built on Tableau Desktop.

• Created Dual Axis, Stacked bar, Text tables, Drilldown (collapse and extend), and Area charts using Tableau Desktop.

• Prepared proof of concept for best practices in Tableau Deployment

• Developed and implemented data collection systems for optimizing the report performance

• Assisted end users in creating reports and dashboards with context filters, quick filters and Parameters, thereby creating a Self-service BI environment across different departments.

• Designed & developed Visual analytics and interactive Reporting Dashboards.

• Data blending has been used to generate reports based on different data sources.

• Participated in the review meetings and acquired insight on the metrics that need to be translated into reports and dashboards.

• Developed and reviewed SQL queries for the purpose of joining data in Tableau Desktop.

• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel. Environment: Tableau 2019.x, Tableau Server, Microsoft Office, MS Excel. BCBS, Michigan Nov 2021 – 15 Sep2022

Tableau Developer/ BI Developer

Responsibilities:

• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area

• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

• Created Bullet graphs to determine profit generation by using measures and dimensions data from MySQL, Oracle, SQL Server, and MS Excel.

• Configure a single server installation, administer content, users, groups, and the data server, administer security and permissions, administer sites in tableau server, tasks and create extracts, embed views, perform basic administration.

• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.

• Developed Tableau workbooks from multiple data sources using Data Blending.

• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.

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

• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

• Actively participated in the business requirement discussions and reviewed business requirements for the purpose of creating visualizations/ dashboards.

• Analyzed data sources such as Flat files/Excel/Oracle/SQL Server/Teradata for designing, developing, and testing the reports built on Tableau Desktop.

• Created ad-hoc reports based on the user requests and assisted them in understanding the logic behind each report.

• Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.

• Created Dual Axis, stacked bar, Pie, Text tables, Line graphs, Waterfall, Bubble and Area charts using Tableau Desktop.

• Created a live dashboard that visualizes the status of support tickets by using Tableau.

• Developed and implemented data collection systems for optimizing the report performance

• Performed ETL / Data analysis on a weekly basis to ensure that the data being displayed on dashboards are accurate.

• Involved in Metadata (python scripts) to provision and Deprovision VM's in AWS and Azure.

• Assisted end users in creating reports and dashboards with context filters, quick filters and Parameters, thereby creating a Self-service BI environment across different departments.

• Designed & developed Visual analytics and interactive Reporting Dashboards.

• Created canned reports for the purpose of assisting end users in using their own data sets.

• Data blending has been used to generate reports based on different data sources.

• Participated in the review meetings and acquired insight on the metrics that need to be translated into reports and dashboards.

• Developed and reviewed SQL queries for the purpose of joining data in Tableau Desktop.

• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel. Environment: Tableau 2019.x, Tableau Server, Oracle 12c, MYSQL, Informatica 9,x, JIRA, Microsoft SQL Server 2008/2000, Microsoft Office, AWS Redshift, Microsoft Visio, Windows 7, Custom SQL, PostgreSQL, Mobaxterm.

State Of California (CGI), CA. April 2019 - Oct 2021 Tableau Developer/BI Developer

Responsibilities:

• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau 10.4 and excel.

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

• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's

• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

• Created views using various axes like Individual Axes, Dual Axes.

• Created Data extracts for better performance and accessing data offline.

• Used parameters and input controls to give users control over certain values.

• Implemented Data blending with multiple data sources on a single worksheet for data analysis.

• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

• Cleared errors according to business requirements excel sheet and helped to create Documentation for the dashboards.

• Used ETL process and exported data via a supported data source and then visualized that data in Tableau.

• Used R functions in Table calculations (aggregated) like Median, Mean, Sum, MIN, MAX etc. in Tableau.

• Hands on experience in gathering data from snowflake cloud environment.

• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement.

• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

• Hands on experience in writing the complex queries, to increase the performance for retrieving and refreshing the Visual dashboards.

• Hands on experience in running the predefined python scripts that are used to pull the data from different source.

• Work with customers in gathering business requirements for data cleansing and performed data cleansing and data scrubbing.

• Expert in using the Alteryx for Data Cleansing and standardization, as most of the times the data is coming in the form of Flat files.

• Extensively used the macros in Alteryx for automating the repeated workflows.

• Experience in using the Alteryx for preforming the ETL operations for data modeling and integrate with Tableau for creating the best Visual dashboard.

• Having a good exposure on how to load the OLAP data into the Tableau server and generate the reports as per the business requirements.

• Experience in following the Data Modeling practices to drive our Key Business decisions.

• Created and maintained technical documentation for launching Hadoop Clusters for executing Hive queries.

• Experience in loading the data into tableau desktop from Splunk environment.

• Participated in development / implementation of Hadoop environment.

• Hands on experience in configuring ODBD connector to connect Hive DSN for getting data into tableau server.

• Hands on experience in using the transformations like, Auto field, Data Cleansing, filters, Input/output, Multi-field Binning, imputation, and Join operation. Environment: Tableau Desktop 2019.1, 10.x, Tableau Server, JIRA, Metadata, Snowflake, SQL 2012, Oracle 10g/11g, Windows 10,Macros, Alteryx, Erwin Data modeler, UNIX, HIVE, Hadoop and Splunk AWS Redshift, Mobaxterm.

Cognizant, India Sept 2016 – Feb 2019

Tableau Developer /SQL Developer

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.

• All applications are mapped into a specific list of customized pre-defined codes through a mapping data source.

• Working extensively using Excel to validate the data and use as the source data files.

• Analyzing the data using Statistical features in Tableau to develop trend analysis.

• Provided mock up visuals to speed up requirements visualization.

• Experience in following the Data Modeling practices to drive your Key Business decisions.

• Hands-on development in creating and modifying worksheets and data visualization Dashboards.

• Created Level of detail expressions (LOD Expressions) data source columns are computed for each row in the underlying table.

• Applied action filters specific sheets in the dashboard and cross dashboard.

• Experience Dual Axes and show the graph in new visualization.

• Experience in data blending with multiple data sources also using new features multi data source.

• Experience in table calculations like windows max and percentage of total.

• Created data source level filters, context filters and cascading filter to improve performance and user flexibility.

• Developed Tabular, drill down, parameterized, cascaded, and sub-reporting

• Designed and Optimized Connections Live, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.

• Performance tuning of reports and resolving issues within Tableau Server.

• Interacted with the users and troubleshooting the problems involved with the reports, dashboards and problems related to the privileges.

• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.

• Testing dashboards to ensure data was matching as per the business requirement if any changes in underlying data.

Environment: Tableau Desktop 9, Tableau server, JIRA, SQL Server, Oracle and Hive, Windows 2007, MS- Access and MS Excel, Snowflakes, Mobaxterm, AWS Redshift. Education: Bachelor’s in Computer Science & Engineering, 2017.

Contact this candidate