Home

Keerthi Reddy - BI/ Tableau Developer

[email protected]

Location: Dallas, Texas, USA

Relocation:

Visa:

Resume file: Keerthi J Tableau_BI Developer_Resume_1746478956489.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

PROFESSIONAL SUMMARY: Experienced Business Intelligence (BI) / SQL Developer and Data Analyst over 9+ years of experience in software design, development, integration, and maintenance of BI and database platforms. Expertise in T-SQL, SSIS, SSRS, Power BI, and Tableau for business intelligence solutions, data visualization, and report development to support data-driven decision-making. Strong T-SQL development skills, including the creation of tables, views, user-defined functions, indexes, stored procedures, CTEs, cursors, and triggers using SQL Server 2008 R2, 2012, and 2014. Advanced Data Analysis skills, including data profiling, data cleansing, data mapping, and transformation, ensuring accurate insights for business users. Proficient in developing on-demand and scheduled reports for business analysis and management decision-making using SSRS, Tableau, and Power BI, scheduled on daily, weekly, monthly, and quarterly intervals. Hands-on experience in Power BI, including DAX, Power Query (M Language), Power View, Power Map, Heat Map, and KPI visualizations to enhance business reporting. Expertise in Tableau Dashboard Development, including LOD Expressions, Calculated Fields, Sets, Groups, Parameters, Data Blending, and Custom Charts to improve data insights and visualization. Experienced in designing and optimizing Tableau and Power BI reports, ensuring efficient performance, interactive dashboards, and user-friendly reporting solutions for executive-level decision-making. Proficient in Data Modeling, including Star and Snowflake Schema design, Fact and Dimension tables, Data Normalization, and Denormalization for enhanced BI reporting. Strong background in Data Warehousing and ETL processes, implementing OLTP and OLAP systems, database schema design, and working with ER diagrams. Deep understanding of BI Architecture, including data extraction, transformation, and loading (ETL), data staging, and metadata management. Experience in SQL query performance tuning using TOAD, SQL Profiler, indexing strategies, and query optimization techniques for handling large datasets efficiently. Worked extensively in cloud-based BI environments, including installing and managing Tableau Server on AWS (Amazon EC2) and configuring Power BI Service for cloud-based reporting. Strong knowledge of business intelligence best practices, including ad-hoc reporting, data governance, and security role management in Tableau Server and Power BI Service. Experience in advanced Excel reporting, including VLOOKUP, HLOOKUP, Index Match, Pivot Tables, GetPivotData, Macros, and Data Validation for data analysis and reporting. Proficient in Data Storytelling and Dashboard Design, using Tableau and Power BI to communicate insights effectively through visually compelling reports and interactive dashboards. Familiar with additional BI tools, including MicroStrategy, Informatica, Alteryx, and SAS (BASE, MACRO, ETL, OLAP, EG) for enterprise-level reporting and data processing. Competent in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC), following Agile, Waterfall, and RUP methodologies. Strong ability to explore and analyze data across multiple visualizations using Power BI and Tableau, ensuring actionable insights for business decision-making. EDUCATIONAL DETAILS: Bachelors in Computer Science at Jawaharlal Nehru Technological University Hyderabad Masters in Data Science at University of Memphis, TN TECHNICAL SKILLS: Databases & RDBMS: Microsoft Access, MS SQL Server (2000, 2008, 2008 R2, 2012, 2014), SQL Server Management Studio (SSMS), SQL Query Analyzer, SQL Profiler, Oracle, DB2, Teradata, MongoDB (NoSQL) BI & Data Analytics: MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), MS SQL Server Integration Services (SSIS), PerformancePoint Server, OLTP, OLAP, Data Warehousing, ETL, Data Modeling (Star & Snowflake Schema) BI Tools: Tableau (Desktop & Server: Versions 9.2 - 10.2), Power BI, SAP BOBJ 4.0, QlikView, BIRST Tableau Skills: Calculated Fields, LOD Expressions, Parameterized Reports, Dashboard Design, Performance Optimization Power BI Skills: DAX, Power Query (M Language), Data Modeling, Report Publishing, Power BI Service Development Environments: Microsoft Visual Studio (2008, 2010, 2012), Microsoft Visual Studio Team System (2008, 2010, 2012), Microsoft SQL Server Management Studio (2008, 2012, 2014), Oracle, Excel, Smartsheet Programming Languages: SQL (T-SQL, PL/SQL), Python, PySpark, R, XML, C#, C, C++, HTML Front-End & Other Tools: Microsoft Project, Microsoft Office, Visible Analyst PROFESSIONAL EXPERIENCE: Client: Pfizer, Fort Worth, TX April 2023 Present Role: Sr. BI/Tableau Developer Project Overview: Aimed to enhance Pfizer s business intelligence capabilities by designing and implementing robust Power BI and Tableau dashboards. The goal was to streamline data visualization, improve decision-making through interactive reporting, and ensure data accuracy across multiple data sources. The project involved data preparation, ETL development, and integration with various databases, ensuring seamless user accessibility and high-performance dashboards. Roles and Responsibilities: Designed, developed, and tested interactive Power BI and Tableau dashboards for ad-hoc and strategic reporting. Created various data visualizations, including scatter plots, box plots, Sankey charts, bar graphs, Gantt charts, trend lines, waterfall charts, heat maps, and geo-maps. Built dynamic reports using parameters, quick filters, table calculations, and calculated fields for trend and cost analysis. Developed complex dashboards incorporating sets, groups, hierarchies, and drill-down/drill-up functionalities. Collaborated with DBAs to design conceptual and physical data models. Developed ETL workflows using SSIS and Talend, ensuring seamless data flow from source systems to target databases. Created ETL mapping documents defining the transformation logic and data movement. Worked with Subject Matter Experts (SMEs) to map and validate extracted data. Wrote and optimized SQL queries for data validation, transformation, and testing. Utilized SQL queries at the custom SQL level in Tableau and validated results against Microsoft SQL Server and Google BigQuery. Integrated Google BigQuery as a data source while transitioning from sample data to cleaned production data. Conducted requirement-gathering sessions with business stakeholders and director-level members. Presented solution approaches and best practices for data visualization and dashboard creation. Gathered business requirements and translated them into technical specifications. Managed Power BI Portal, including data refresh, user management, and gateway setup. Scheduled data extract refreshes and optimized dashboard performance. Conducted user acceptance testing and mentored business users on utilizing dashboards efficiently. Created issue logs for tracking business user feedback and incorporated necessary modifications. Participated in daily stand-up meetings, sprint planning, and retrospective sessions. Coordinated onsite-offshore development efforts to ensure timely deliverables. Published dashboards to production, ensuring data integrity and accuracy. Environment: Tableau Desktop (8.1/8.2), Tableau Server, Power BI, Microsoft SQL Server, Google Big Query, Salesforce, SSIS, SSAS, Talend, Scatter plots, Waterfall charts, Bullet charts, Geo-maps, Statistical models, SQL, Agile, Scrum. Client: Chevron, Houston, TX Dec 2021 Mar 2023 Role: Sr. Data Analyst / Tableau Developer Project Overview: The project focused on developing and optimizing BI solutions to support data-driven decision-making at Chevron. The primary responsibilities included designing and building interactive Tableau dashboards, creating SQL-based datasets, performing data analysis and visualization, and ensuring seamless data integration from multiple sources. Enhanced reporting efficiency, improve data accuracy, and provide real-time business insights through advanced data modeling, ETL, and report automation. Roles and Responsibilities Designed and developed recurring and ad-hoc reports in Tableau by connecting to various data sources. Built interactive dashboards using filters, parameters, drill-downs, and advanced visualizations. Created joins and sub-queries to support complex queries across multiple tables. Designed and optimized CTEs, subqueries, and cumulative queries for efficient data retrieval. Developed scorecards, pivot tables, heat maps, geo maps, tree maps, and statistical models for data visualization. Created, maintained, and scheduled reports in SSRS and Oracle Roast (Tabular, Matrix, and Parameterized Reports). Connected Tableau to multiple data sources including SQL Server, Oracle, DB2, Teradata, and SAS. Performed data extraction, transformation, and loading (ETL) using SSIS and Informatica. Used Control-M and Autosys for job scheduling and monitoring data refresh cycles. Wrote complex SQL queries for data extraction, validation, and transformation. Reviewed and optimized SQL queries to enhance dashboard performance. Created context filters and data extracts to optimize Tableau Server reports. Conducted data profiling and validation to ensure reporting accuracy. Involved in data conversion and migration for reporting purposes. Gathered business requirements by working closely with stakeholders, project managers, and business users. Provided advanced Tableau training to executives and end-users. Conducted super-user training sessions covering basic and advanced Tableau functionalities. Created Story Points and presentations to showcase data-driven insights. Performed dashboard performance tuning and resolved issues within Tableau Server and reports. Validated reports before publishing them to Tableau Server and provided ongoing troubleshooting support. Monitored daily, weekly, and monthly data refreshes and validated data integrity. Participated in weekly meetings, user group discussions, and Agile sprint planning. Environment: Tableau Desktop / Server, SSRS (SQL Server Reporting Services), SAS Visual Analytics, Microsoft SQL Server, Oracle, DB2, Teradata, Google BigQuery, SSIS (SQL Server Integration Services), Informatica, Autosys, SQL, Teradata, Agile / Scrum, Microsoft Visio, SharePoint, Unix Client: University of Houston (Protiviti), TX Mar 2021 Nov 2021 Role: Data Modeler / Power BI Developer Project Overview: This project focused on enhancing the University of Houston's data-driven decision-making capabilities through robust data modeling, reporting, and dashboard development. The role involved designing and implementing data models, developing interactive reports and dashboards, and ensuring data integrity across various platforms. This encompassed the full lifecycle of data management, from requirements gathering and data modeling to reporting and analysis. Roles and Responsibilities: Conducted detailed analysis of database requirements with stakeholders, facilitating joint requirement development sessions. Developed normalized logical and physical database models for OLTP systems. Created dimensional models for reporting systems using Erwin, identifying required dimensions and facts. Generated DDL scripts to implement data modeling changes. Maintained and implemented data models for the Enterprise Data Warehouse (EDW) using Erwin. Utilized forward engineering to create physical data models from logical models. Performed reverse engineering using Erwin to create ER diagrams from existing databases and ODS. Defined and enforced naming standards for the data warehouse. Managed model versions and facilitated collaboration using Erwin's Model Mart. Eliminated errors in Erwin models through the implementation of Model Mart. Massaged the existing model to create new logical and physical models. Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW). Created and maintained Metadata, including table and column definitions. Developed interactive dashboards and reports using Power BI and Tableau. Connected to diverse data sources, including Oracle, SQL Server, Hadoop, ODBC, and flat files. Created and deployed various SSRS reports (tabular, matrix, parameterized), including drill-down and interactive sorting. Implemented subscriptions and snapshots in SSRS Report Manager. Designed and implemented Power BI dashboards, scorecards, views, pivot tables, and charts. Utilized Power BI's Power View/MAP and Story Points for data visualization and presentation. Developed confidential analytical tools and reports using Microsoft Excel, Power Pivot, and PowerPoint, including slicers, pivot charts, and macros. Created SQL datasets for Power BI and Ad-hoc Reports. Hands-on experience assisting users in creating and modifying worksheets and data visualization dashboards. Researched problems thoroughly to diagnose the root cause by pulling data from multiple Sources, Developed Reports and dashboards using Power BI. Managed enterprise services by diagnosing root causes of incidents, determining detection time, and resolving issues through data analysis. Created SSIS packages to extract and load data from database servers and SharePoint lists. Identified appropriate data sources to ensure consistent reporting across management levels. Verified data integrity during ETL processes. Performed PL/SQL programming, including stored procedures, functions, packages, and triggers. Conducted one-on-one sessions with business users to Gather Data Warehouse Requirements. Worked with Database Administrators, Business Analysts, and Content Developers for design reviews and model validation. Possessed strong documentation skills and facilitated knowledge sharing within the team. Environment: SQL Server 2008, Teradata, Oracle 11g, DB2, Informix, Tableau, Power BI, SSRS, OBIEE, Erwin, MS Visio, Rational Rose, MS Excel (including Power Pivot), MS PowerPoint, Office 365, Windows XP/NT/2000, Requisite Pro. Client: Value Labs, Hyderabad, India Dec 2017 Jul 2019 Role: MS SQL Server / BI Developer Project Overview: This project centered on designing and implementing a robust Enterprise Data Warehouse (EDW) and delivering actionable business intelligence solutions. The role focused on developing ETL processes, creating data models, designing OLAP cubes, and building comprehensive reports and dashboards. The aim was to transform raw data from diverse sources into valuable insights, supporting strategic decision-making and operational efficiency. Roles and Responsibilities: Designed high-level ETL architecture, encompassing data flow, column mapping, data dictionaries, and metadata management. Extracted and transformed data from heterogeneous sources (Excel, CSV, Oracle, flat files, text) using SQL Server Integration Services (SSIS). Implemented ETL processes for data loading from source systems to staging areas and then to production data warehouse tables. Designed and modified SSIS packages, utilizing transformation tasks like Script Component, Lookup, Derived Column, Conditional Split, Union All, Copy Column, Aggregate, and Audit Transformation. Created Data Profile packages for data quality assurance using SSIS Data Profiling Task. Managed the migration of DTS 2000 packages to SSIS. Implemented Data Marts, Facts, Dimensions, Snowflake schema, Star schema, and OLAP cubes. Designed and implemented MS Analysis Services (SSAS) setups, including tuning, cube partitioning, and dimension design (hierarchical and slowly changing dimensions). Created Calculated Measures and Dimension Members using MDX, mathematical formulas, and user-defined functions. Created and maintained database objects, including stored procedures, triggers, cursors, tables, views, indexes, and user-defined functions. Developed complex SQL queries, CTEs, and subqueries for stored procedures. Optimized SQL queries for report performance. Created and maintained Roles and Database users. Developed parameterized reports (tabular, drill-down, drill-through, sub-reports) using SSRS 2008/2012. Generated on-demand and scheduled reports for business analysis and management decision-making. Visually enhanced reports based on user requirements. Troubleshot report issues. Built SQL Server Queries for Power Pivot based reporting. Provided complex reports using Excel, Access and PowerPoint. Used Excel, Access and SQL Server to cleanse, de-duplicate and format client files. Extracted and reviewed data from various sources. Worked on extensive SQL Server Integration Services (SSIS) - Extracting data from multiple sources and load into data warehouse after applying business logic and data profiling. Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, ProClarity, Power Pivot, MS Visual Studio 2005, SQL Server Management Studio, Windows XP Professional, Team Foundation Server, MS Excel, MS Access, MS PowerPoint. Client: Novartis, Hyderabad, India Jul 2015 Nov 2017 Role: Data Analyst / SQL Server Developer Project Overview: This project focused on developing and implementing robust data warehousing solutions, creating comprehensive reports, and providing actionable data analysis to support business operations at Novartis. The role encompassed the full spectrum of data management, from ETL processes and database design to report creation and data analysis. Roles and Responsibilities: Developed dynamic metadata-driven SSIS packages for source data extraction and destination system updates within Microsoft Visual Studio 2008/2012. Designed and implemented ETL processes using SSIS, extracting data from heterogeneous sources like Access, Excel, CSV, and flat files. Automated SSIS packages using SQL Server Agent Jobs. Exported and imported data between flat files, CSV files, Excel, and SQL Server databases using SSIS. Developed DTS packages to transfer data between SQL Server and other databases/files. Designed and modeled databases based on requirements and implemented necessary changes. Created and maintained database objects, including stored procedures, functions, triggers, indexes, and views using T-SQL. Wrote and optimized T-SQL queries, stored procedures, and triggers. Scheduled and re-scheduled jobs on production databases using SQL Server Agent. Managed and maintained customer relationship management (CRM) system data. Developed SSRS reports with functionalities like drill-down, drill-through, and parameters. Created tabular, list, and matrix reports, and implemented drill-down operations in SSRS. Utilized various report items (tables, sub-reports, charts) in SSRS and uploaded reports to Report Manager. Designed, developed, and modified various reports as per business requirements. Developed reports using stored procedures and T-SQL. Designed, developed, and tested complex queries for report distribution. Built and performed user acceptance testing (UAT) on modified reports. Created, maintained, and analyzed various reports and Excel spreadsheets for senior management. Maintained error logs. Oversaw departmental software drives and files. Skilled in running jobs in Enterprise Manager using job-scheduling tool. Environment: MS SQL Server 2000/2005, MySQL, SSRS, SSIS, Microsoft Visual Studio 2008/2012, MS Office Suite (Word, PowerPoint, Excel), MS Access, Lotus No Keywords: cprogramm cplusplus csharp business intelligence active directory rlang trade national microsoft procedural language Delaware Tennessee Texas