Home

Krishna Tandava - Power BI Developer

[email protected]

Location: Dallas, Texas, USA

Relocation: Any

Visa: H1B

Krishna Professional Summary: Around 12+ years of Experience in data analytics, Business Intelligence tools like Tableau/Power BI/GCP Looker/ SSRS/ MSTR/ DOMO/Cognos/Alteryx in Telecom, Retail, Financial and Banking. Full Life-cycle BI and Data warehousing projects experience with Requirement s analysis, proof-of-concepts, Design, Development, testing, Administration (BI tools, cloud (Azure, AWS, Snowflake) and Production support. Experience in data modelling, schema design, implementing and upgrading the code in SSIS/Azure/Informatica iics/ DOMO/ Dremio/ Matillion/ Snowflake/ BI tools based on user requirements. Ability to introduce Tableau to Client s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions. Worked extensively on creating reports, dashboards and stories and also worked with different charts in Tableau. Provided data reporting functions to the business and technical community using SQL querying to enable the team to gain insight into various parts of the business Partnered with business and technology teams to build insightful analytical solutions Investigated data discrepancies, resolved them, and support the team's ability to do effective data analysis Experience in creating tables, views and stored procedures in snowflake data warehouse. Expertise in Joining Tables, multiple data connections using Blending, Actions, Calculations, Forecasting, Parameters in Tableau. Good understanding of concepts like Star, Snowflake schema using fact, dimension tables and relational databases. Develop standard reports and templates, dashboards, master detail reports. Generated Extract Filters, data source filters, context filters while handling huge volume of data. Worked closely with DevOps and management teams to create IT and data visualization solutions. Expertise in creating complex reports using Drill Maps and implementing Conditional Formatting, Sets, Grouping, Filtering, Derived Metrics and Apply Conditions. Worked extensively with advance analytics actions, calculations, parameters, background images, maps, forecast, trend line and reference lines and table calculations. Designed and developed various business rules, client scripts, UI actions, UI policies and scheduled jobs. Published Workbooks by creating user filters, so that only appropriate teams can view it. Experience on distributing Tableau Reports using techniques like packaged workbooks, PDF to END Users. Experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint Strong expertise in providing business solutions and creating executive dashboards with most relevant KPI s and Storyboards using (DOMO tool) Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse using Alteryx (Data extraction, blending and Reporting). Experience in working with Sales and Marketing Team to build Tableau CRM (formerly Einstein Analytics) dashboards and reports. Worked with End Users and the Management to prioritize business and information needs. Experience in writing complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx. Prepare technical specifications and documentation for Alteryx workflows, supporting BI reports. Translate business logic from one system (Excel, SQL, etc) into Alteryx in a quick and accurate manner. Proficiency in Power BI Desktop, Power Query, DAX, M, and Power BI Service Experience in Modifying power cubes by adding new dimensions and measures etc Experienced with Power BI Data Modelling and Customized, built data model regions. Developed Power BI reports and dashboards from multiple data sources and published on Power BI Service. Experience in working and creating CDM (Common Data Model), Power Automate and Dynamic parameters. Experience in creating data models within Power BI to support efficient, optimized data warehousing and reporting workflows. Implement and modify business objects central management console and management of complex reporting environments and supported Business Objects products, including Web Intelligence (Webi) Crystal Reports and dashboard designer Created SSIS package to load data from flat files and XML files to Report-Data mart and Data warehouse. Implemented configurations for data viewers, logging and error during package handling Building business Intelligence solutions (reports, dashboards, scorecards) using Microsoft Business Intelligence technology stack (SSRS, SSIS, SSAS) Debugged the processes, triggers and views monitored the system and SQL server job schedule and recorded any errors. Monitored daily Processes for different Data Loads and resolved Issues. Analyzed the performance, tuned and optimized, supported database objects migrate to production, executed stored procedures. Created SSIS Packages to Extract Transform and Load (ETL) the data into Reporting instance to generate the reports quickly. Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Lookup, Merge Join, Conditional Split, Slowly Changing Dimensions, Data Conversion etc..,) in SSIS Package Development Create/manage Projects, Database Views, Data Sources and Data Connections and publish interactive reports, visualizations and dashboards using SSRS Installed and maintained Jenkins for continuous delivery against production infrastructure. Knowledge on Azure data factory pipelines and CI/CD pipelines. Experience in creating tables, views and stored procedures in snowflake data warehouse. Proficient in working with large databases like Redshift, oracle, Teradata, and SQL Server. Having production support experience in Tableau, DOMO, Dremio, MSTR, SAP BO, Informatica, AWS Cloud and Okta Admin. Having good experience in with Education departments, Schools, HR departments, Department of Research. Providing the best practices and performance optimization techniques for development and administration process and documentation. Certifications: AZ-900 Microsoft Azure Fundamentals SnowPro Core Certification. Tableau Desktop Specialist Certification. Academic Qualifications: Master of Computer Application (MCA) from Osmania University, Hyderabad, INDIA Skill Sets: Business Intelligence Tableau 2023.1, 2022.2, 2020.4, 2021.2, 2019.2,10.5,10.2, Tableau Cloud, Power BI 2.x, Cognos, 11.x, Microstrategy 9.3, 10.2, 2021, SSRS, DOMO, SAP BO 4.1, 4.2 ETL Tools Matillion, Informatica 9.4, 10.5, DOMO, WebFOCUS 8.X, SSIS, ADF, Tableau Developer, Alteryx 2019.x, 2022.x, Teradata 12 Cloud Technologies AWS, Snowflake, Azure, DOMO, Tableau, Dremio, Salesforce Query Tools Aginity, SQL Developer, Toad, T-SQL, Sql Server Management Studio (SSMS), Database Redshift, Oracle, SQL Server, Teradata, Netezza, SAP Hana, Big Query, DB2, PostgreSQL Languages HTML, XML, Python & Power Shell Other Tools ServiceNow Desk plus, Zoho Desk, SCCD, ACUT, Excel, MS-Office, MS-Access, Sharepoint, Putty, Visio, MS SharePoint, Airflow, WinSCP, Rally, JIRA, Splunk, SVN, GIT, Unix, Control m, Teams, Slack, WebEx. Program Management Process Improvement\Operations Professional Experience: Client: USAA Sep - 2022 to Till Date Location: Plano, Texas Role: Sr. BI Developer Responsibilities: Developed Tableau Dashboards as part of AML remediation effort, to provide required insights needed for Claims, Auto, Property and guided analysis for wires/debit LOBs for Audit and balance controls Worked along with data and business team in determining the attributes required for tables and dashboard development. Developed and maintained interactive dashboards and reports using Tableau and Power BI. Experience in working with Azure SQL Database, AWS, GCP and Snowflake. Transformed raw data into valuable and meaningful insights in the form of appealing dashboards and reports. Converted existing SAP BO reports and SAS reports to Tableau and Power BI Reports/Dashboards. Involved in Data Analysis & Data Mapping to track all data elements used in the application from the user interface through different interfaces to the target databases in which they are stored. Experience in performance optimization techniques, including data extracts, data blending, and data aggregations to enhance dashboard performance. Worked with Salesforce business users to translate the sales and marketing data to dashboards using Tableau CRM platform. Developing tableau interactive dashboards to monitor KPIs related to overages, shortages and damages. Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality. Worked on building complex dimensional data models and reports from the bottom up Experience in auditing existing Reports efforts with a focus on improvement Gathered business requirements from users and converted them to technical specifications by building dashboards and reports. Developed Power BI data modelling and customized reports, dashboards from multiple data sources and publish them on BI Service. Experience in restricting data for particular users using Row level security and User filters. Designing the Logical and Physical data models using the Dimensional modeling techniques. Designed and Develop/Review ETL programs primarily using Matillion. Performance improvement & tuning of Matillion mappings, Data validation, testing of ETL Objects, Source data analysis. Generated detailed design documentation for the source-to-target transformations in Matillion. Experience in working on production issues and code fixes in Matillion and BI, configuration/Administration Created CI/CD for Azure data factory deployment from lower to higher environment. Created Pipelines and Linked services in Azure data factory and key vaults in Azure Worked along with data and business team in determining the attributes required for tables and dashboard development. Developed metadata driven ETL process using Azure stack and azure ELT pipelines for data extraction from different sources. Developing complex SQL queries in Snowflake cloud data warehouse for business analysis and reporting. Experience in validating the data coming from Netezza Database to Snowflake Database. Improvised existing Tableau workbooks by doing performance analysis, performance monitoring, and implementing the best Experience in connecting to various data sources, including Snowflake, Salesforce, Dremio, Netezza, SQL Server, Oracle, to extract and transform data for visualization. Analysed the database tables and created database views based on the business requirements. Perform release management activities to support certification and deploy of code to production systems. Environment: Tableau, Power BI, Matillion, ADF V2, DOMO, Snowflake, Salesforce, Alteryx, Teradata, Redshift, Azure, Dremio, SAS, SAP BO, Hadoop, Informatica, Rally, JIRA, Netezza, DB2, SQL Server, Control m Client: CS Wholesale logistics Sep - 2021 to Aug - 2022 Location: Chennai, India Role: Technical BI Engineer/BI Developer Responsibilities: Involved in gathering System requirements analyse business needs and specifications. Conduct Gap Analysis and interacted with business stakeholders for complete understanding and assessment of critical Business requirements. Involved in reviewing business requirements and analysing data sources form different databases for design, development, testing, and production rollover of ETL and BI dashboards. Reviewed Quality of the Code delivered during Build Phase. Developed Tableau Workbooks from multiple data sources using Data Blending. Used Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending, Joins and Maps etc. Created analytical reports and provided valuable and relevant business insights for internal and external clients. Cleaned and transformed data using Power BI Query Editor to prepare ETL processes to optimize reporting datasets. Created data models, tables within Power BI to support efficient, optimized data warehousing and reporting workflows. Created interactive dashboards and visualizations in Tableau such as dual axis, box plots, bullet graphs, tree maps, bubble chart. Developed and reviewed simultaneous SQL queries in Tableau Desktop to validate both static and dynamic data for data validation. Generate complex reports to application development management on a regular and timely basis Build, customize and publish interactive reports, visualizations and dashboards using Tableau Trained end client users on DOMO Tool and Tableau by providing step-by- step guidance from basics to advanced functions working with calculations, parameters, and date functions. Created the dynamic cubes using Cognos Cube Designer 10.2 and created reports and dashboards using the MDX functions. Created the Cognos dashboards using the Cognos Report Studio with the Oracle data. Have extensively used MDX functions for creating the reports using the cube data. Provided the training and documentation to the users on creating the reports using the cube packages and relational packages. Interacted with the existing database developers to understand the existing schema. Scheduled data refresh on tableau server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately. Perform data analysis and troubleshoot issues and applying the fix. Support universe creation and development in SAP BO. Worked with Business users and functional team to solve blocked Issues. Created Pipelines and Linked services in Azure data factory. Extensively used ADF General Activities, move and transform activities. Created data flows in Azure data factory and used different transformations. Created technical design documents for the Build Phase and their review. Created CI/CD for Azure data factory deployment from lower to higher environment. Having Good Experience in Tableau Server Installation, upgrading and Configuration, creating users, groups, projects, providing access levels. Environment: Tableau, CRM, Power BI, SSRS, Looker, Redshift, Tableau Server, ADF, ServiceNow, Informatica, Alteryx, Netezza, Oracle, Snowflake, DOMO, Cognos, Dremio. Client: Prodapt Solutions/Cable and Wireless Communications Aug 2017 to Aug 2021 Location: Chennai, India Role: Lead Engineer/BI Consultant/Production Support Engineer Responsibilities: Involved in reviewing business requirements and analysing data sources form Excel/Oracle/SQL Server for design, development, testing, and production rollover of reporting and analysis within tableau. Worked on tableau server and admin activities with tabadmin and tsm commands. Supporting a team of high performing, innovative and productive BAU/Offshore MI Reporting Analysts and report developers Providing level 0/1/2/3 development support Developed story telling dashboards in tableau and published in tableau server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information. Generated and implemented Micro Strategy schema objects and application objects by creating reports, filters, metrics and templates using Micro Strategy. Worked on development of reports, object templates and intelligent cubes based on the technical and business specifications of the customer. Created reports using intelligent cubes. Worked as enhancement team member and performed the roles of salesforce.com administrator and developer in the organization. Strategically implemented incremental data extracts (which were updated on a timely basis as data updates), refreshed extracts, optimized and tuned applications for maximum memory management, and performed scheduling. Served as a Tableau Liaison to mentor our team on all Tableau best-practices while supporting other developers specifically in data-source identification. Managed users, profiles, permissions, roles, hierarchies, org-wide defaults, groups and sharing rules. Provide support to all sap business objects and provide appropriate upgrade on environment. Design universe on SAP Business Intelligence and prepare ad hoc reports for same. Analyse all information from end users and prepare reports with help of various software Development of various apteryx workflows for automation of cash balances, gross notional exposure and building reports for risk and operational metrics Worked with Informatica to automate ETL workflows for daily/weekly reports Promoting the changes in Production by using the RFC approvals. Managing tableau users and group s security configuration and integration with AD. Back tracking the issues and providing RCA to fix the same on temporary and permanent basis Involved in resolving critical issues in all the situations without escalations Key liaison between technical and testing team in Issue Analysis, Defect Triage and troubleshooting through Defect Management tools (DIET Defect, Incident and Enhancement Tracking). Interacting with stakeholders, business groups and project teams for seamless integration. Environment: Tableau, Power BI, SSRS, ADF, DOMO, MicroStrategy, Informatica, ServiceNow, Jenkins, Splunk, Stash, Git, SAP BO, AWS Redshift, Aginity, S3, Lambda, RDS, SNS, Data Pipeline, EC2, EMR, Cloud Watch, IAM, Oracle, SQL Server. Client: Cognizant/ Kimberly Clark Jan 2016 to Apr 2017 Location: Chennai, India Role: Tableau Developer Responsibilities: Interacting with users in requirement gathering and design meetings Demonstrate strong problem-solving skills and excellent attention to details Experience creating tables, reports with Microsoft Access, Tableau SQL, Crystal Reports as data analytics or troubleshooting tools Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL server, oracle, spreadsheets etc). Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart. Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies Converted Microstrategy reports into Tableau. Created different Action filters, Parameters and calculated fields to create most complicated dashboards. Worked with Tableau administrator in managing Production, Test and Development environments. Ability to build strong relationships with internal clients Responsible for developing dashboards and preparing ad-hoc reporting. By using custom SQL in Tableau build complex reports. Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server Prepared Parameterized, Linked Report, drill down, drill through and sub-reports in SSRS. Also used Report Server Manager to create Shared Data Source, Dataset, Subscription and Caching to auto generate the Report. Worked on Tableau Server and admin activities with tabcmd, tabadmin commands. Familiar with Installation, configuration, patching and upgrading of tableau tool across the environments. Environment: Tableau, Tableau server, MSTR, SSIS, SSRS, Oracle, SQL Server, SAP HANA. Client: Syntel / State Street Sep 2014 to Dec 2015 Location: Chennai, India Role: Report Developer Responsibilities: Examines/evaluates purpose and content of business reports to develop new, or improve existing, format, use and control Reviews report specifications to determine basic characteristics, such as origin and report flow, format, data elements, frequency, distribution, and purpose of report function Develops report per specifications in Tableau, Jaspersoft and SSRS Prepare and issue instructions concerning generation, completion, and distribution of reports according to new or revised practices, procedures, or policies of reports management Understand and comprehends system changes as they affect data, reports, and reporting systems Responsible for dashboard design, layout, look and feel and development. Design, develop, and support reports and dashboards using Jaspersoft reporting platform Work within an agile methodology to design, develop, test, implement analytics and analyze data to provide reports for departments to utilize in decision making and measuring results. Create queries to provide ad hoc reports, analysis, and datasets based on business needs. Trouble shoots data issues, validate result sets, recommend and implement process improvements. Environment: Tableau, MicroStrategy, Cognos, Jasper soft, Oracle, SQL Server, Teradata. Client: Spretnost /Syntel/ the Container Store Sep 2011 to Aug 2014 Location: Chennai, India Role: Developer Responsibilities: Involved in application development, enhancement, support, deployment, performance tuning, testing. Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching business requirements to Teradata RDBMS. Created scripts of BTEQ, FastLoad, MultiLoad, FastExport utility to extract large volumes of data at high speed from Teradata RDBMS and written queries to move the data from source to destination. Partitioned Primary Indexes to achieve and exceed desired performance. Wrote scripts for data cleansing, validation, data transformation for data coming from source systems. Involved in the analysis of Issues and proposing solutions to client Involved in analysis of test results and documenting test results. Development of scripts for loading the data into the base tables in EDW using utilities. Created RFC s for change request and regular follow up s by interacting with different Teams. Environment: Teradata, Tableau Desktop, Tableau Public, SQL Server. Keywords: continuous integration continuous deployment user interface business intelligence sthree active directory information technology microsoft Arizona Michigan