Business Intelligence Developer
Resume:
Revanth Reddy
************.**@*****.***
SUMMARY:
* ***** *****-** ********** as a Data Analyst, Database Designer, Reports Developer, and Data Visualization expert in Business Intelligence
4 years of experience with Tableau Desktop, Tableau Server, and Tableau Online (versions 9.x and 10.x)
Great experience with creating complex analytical dashboards in various industries like Finance, Retail, and marketing
Served as a liaison between development team and the branch business management team to identify business needs and provided the solutions
Experienced working with large-scale databases utilizing various data sources such as MS-SQL Server, MySQL, Excel, Access, and Text file in multiple industries
Assisted power users in getting started consuming data from data
warehouse and create their reports using self-service BI tools: Power Pivot and Tableau
Experience working with various teams in Agile models
Authored and presented business requirements documents, functional requirement documents, and business cases to stakeholders and technical teams
Experience creating analytical reporting that includes Dashboards for Executive and Mid-Level shareholders utilizing SharePoint, Access, Excel and Microsoft's Power BI tools including Power Query and Power Pivot
In-depth experience with data warehousing, data architecture, data quality processes, table structure, fact and dimension tables, logical and physical database design, data modelling, and reporting
Developed UI pages using JavaScript and embedded Tableau Dashboard
Proficient in creating calculated fields and business logic using parameters and formulae to achieve desired results on the visualization.
Background includes troubleshooting and resolving issues within Tableau Server, Tableau dashboards, and data extracts
Server Administration expertise includes, but is not limited to, performing server installation, server configuration, server upgrade, server backup, and setting up group permissions/access on Tableau Server
Proficient in both Tableau Server and Tabadmin Commands
Prepared Ad-hoc reports based on client requirements and developed dashboards for Key Performance Indicators (KPI)
Trained Business Users, Junior Tableau Developers, and Data Analysts in using Tableau as a primary data analysis tool
Great experience with preparing business requirements documents and use cases
Self-motivated, quick-learner with the proven aptitude to deliver results in high-pressure environments
Strong interpersonal and communication skills with the ability to maintain effective relationships with all levels of personnel
Good knowledge of Software Development Life Cycle (SDLC) and Agile methodologies.
TECHNICAL SKILLS:
Reporting: Tableau Desktop, Tableau Server, PowerBL IBM Cognos, Crystal Reports
Database Design: MS-SQL Server, MySQL, Oracle
Others: SAS, SAP, Python, MS Office Tools
EDUCATION:
Bachelor of Technology in Engineering, Electronics and Communication, JNTUH 08/2011 – 04/2015
Master of Science in Industrial Technology, California State University 08/2015 – 05/2017
PROFESSIONAL EXPERIENCE:
Credit Union of Texas 10/2017 – Present
Data Analyst/ BI Developer
Interacted with Business partners, gathered requirements and provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches to senior management as part of the Proof of Concept (POC)
Evaluate and analyzed business requirements for developing business specifications
Performed user acceptance testing (UAT) and developed user guides for firm-wide use
Conducted multiple Tableau training sessions to educate both high-end reporting analysts and low-end business users on how to use Tableau
Managed a team of three and been the point of contact to ensure standards and best practices are established and met for consistent and accurate use of Tableau across the company.
Worked as a Single Point of Contact for end-to-end development of dashboards.
Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales
Helped Business partners to set up sites in the Tableau server as per the taxonomy structure of the organization
Designed and created 10 stored procedures, 5 views, and several tables in MS SQL for the specific requirements of two projects
Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages
Published worksheets using the manual and automated process on Tableau development server.
Developed reports in Tableau using features like measure, dimension, folder, hierarchy, extract, filter, action, calculation, set, group, parameter, forecasting, data blending, trend lines, etc.
Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
Performance recording feature in Tableau is used to troubleshoot the decreased performance of dashboards and improved the performance by optimizing data sources, filters and extracts.
Worked on visualizations by utilizing dual axis, bar chart, scatter plot, pie chart, heat map, treemap, waterfall chart, filled map to best present client requirements
Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
Developed budgets, variance reports, and other financial analysis
Worked using all types of aggregations like Sum, Average, Count, Count (distinct), Median, Minimum, Maximum, Percentile and St. Deviation etc.
Developed, organized, managed and maintain graph, table, slide and document templates that will allow for efficient creation of reports
Developed performance Dashboards, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL, SSAS and Excel and gives powerpoint presentation to client for this on a daily basis
Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning
Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
Created Power BI Dashboards (Power View, Power Query, Power Pivot, and Power Maps) and integrated them to share point
Effectively used data blending, filters, actions, Hierarchies feature in tableau and Power BI
Used Power BI (power Pivot) to develop data analysis prototype and used power view and power Map to visualize reports.
Utilized Power BI (Power View) to create various analytical dashboards that depict critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging and Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
Developed SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
Accessed data from SQL server and validated using stored procedures by querying each category listed in the stores.
Utilized Power BI gateway to keep dashboards and reports up-to-date with on-premise data sources.
Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
Worked on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries.
Responsible for Developing a Dashboard and preparing ad-hoc Reporting. Professional interaction with a diverse group, including executives, managers.
Environment: Tableau Desktop, Tableau Server, Power BI, MS SQL, MS Excel, MS PowerPoint
FedEx 02/2017 – 09/2017
BI Developer
Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches to senior management as part of the Proof of Concept (POC)
Formulated BRD (Business Requirement document) and FRD (Functional Requirements Document) with detailed specifications and workflow diagrams
Analyzed and evaluated business requirements to develop business specifications
Performed user acceptance testing and developed user guides for firm-wide use
Worked with the following data sources: MS SQL, Excel, and Text file
Exposed to multiple reporting software including Birt and Google Charts
Server Administrator duties:
oMaintained 3 Tableau Servers
oInvolved in installing and configuring Tableau Server 10.3
oInvolved in upgrading Tableau Server and created server backup
oChanged Tableau Server logo to client logo
oManaged user permissions
oProvided end user support 24/7
Created more than 190 worksheets within 21 dashboards for one project
Created context filters to limit the data seen by the worksheets in order to optimize dashboards performance and reduce report rendering time
Frequently used features like measure, dimension, folder, hierarchy, extract, filter, action, calculation, set, group, parameter, forecasting, data blending, trend lines, etc.
Picked appropriate visualizations by utilizing dual axis, bar chart, scatter plot, pie chart, heat map, treemap, waterfall chart, filled map to best present client requirements
Designed global filters across different dashboards to make more interactive dashboards
Used performance recording feature to troubleshoot the reasons for slow dashboards and improved dashboards performance significantly by optimizing data sources, filters, and extract
Developed storytelling dashboards in Tableau Desktop and published to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on-demand information
Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers
Collaborated with test team to verify dashboards accuracy and performed strong troubleshooting ability to find root causes of data integrity
Worked closely with the client team and provided frequent status/execution updates
Gained domain knowledge in a very short amount of time and was able to apply the knowledge to real situations.
Played an important role in team coordination and management of the time estimation for the entire project
Environment: Tableau Desktop, Tableau Server, MS SQL, MS Excel
Principal Financial Group 12/2015 – 01/2017
Tableau Developer
Developed a strong understanding of loan servicing and default reporting
Performed data extraction, analysis, and reporting on this project
Worked on about one hundred tables and millions of records in each table
Analyzed user and business requirements, and attended review meetings to discuss changes in the application requirements and documents
Create BI reporting for Executive and Mid-Level shareholders utilizing SharePoint. Access, Excel, Microsoft Power Query and Power Pivot to create conventional and interactive reports and Dashboards
Utilized multiple data sources for design, development, testing, and production (MS Excel, CSV files, and MS-SQL Server)
Introduced and implemented Tableau Desktop and Tableau Server as a primary analysis tool and reporting system
Added users to Tableau Server and assigned permission access based on groups
Scheduled daily extract auto-refresh on Tableau Server
Collaborated with business users to develop efficient ways to make tables and graphs, which were visually easy to understand while maintaining accuracy of the core information content
Created multiple visually compelling and actionable interactive dashboards to meet specific business requirements
Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
Created several dashboards with special charts based on client requests which are not default options in Tableau (i.e. doughnut, pie chart and waterfall chart)
Frequently used calculation field, action filter, parameters, group, set, hierarchy, table calculation, dual axis, bin, etc.
Designed and developed various charts including geographic maps, pie, bar, stacked, line, area, histogram, Gantt, etc.
Created detailed curriculum to teach Tableau, as well as, a Tableau Center of Excellence where business users could find resources to help them succeed in using Tableau to create exemplary dashboards
Participated in daily meetings, reviews, production support meetings
Effectively maintained a positive and productive working relationship with internal and external teams
Environment: Tableau Desktop, Tableau Server, MS SQL Server 2012, Team Foundation Server, MS Excel
Modus Information Systems 02/2014 – 06/2015
SQL Server Developer / Report Developer
Worked with Crystal Report for creating complicated reports including sub-reports, parameter-based reports, graphical reports, formula-based reports, drilling reports, analysis reports, data reports
Created several automated reports in Crystal Reports that reduced maintenance time
Hands-on experience working with multiple reporting tools (Crystal Report, Tableau, and Excel)
Developed SSIS packages to transform data extensively between MS-SQL Server and other source systems
Created views and stored procedures by joining tables in MS-SQL Server ensure accurate information was pulled to create reports
Managed database in MS-SQL Server to provide the national fraternity with a stronger process to identify changes
Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
Created multiple dashboards using Tableau Desktop
Used filters, quick filters, table calculations, parameters in Tableau reports
Created context filters to improve dashboards performance
Created Table of Contents (TOC) common navigation page which had links to various reports
Worked closely with business users to create reports/dashboards on different reporting tools
Environment: Crystal Reports, MS Excel, Tableau Desktop, Tableau Server, MS SQL Server 2012
Contact this candidate