Business Intelligence Power Bi

Chandra Gadde

**************@*****.***, 925-***-****

Hillsboro, Oregon

Senior BI Analyst / Developer

Summary

Accomplished successful history delivering Business Intelligence and Analytics derived from data integration, visualization, and reporting.

Over 15 years of IT industry experience in gathering Business Requirements, Analysis, Design, Development, Testing and Implementation of Data warehouse & Business Intelligence applications.

Over 10+ years of experience working in Data Warehousing and Business Intelligence using Tableau, Power BI, SAP HANA

Experience in Healthcare domain in creating the Data analysis platform Tableau for the end user reporting.

Worked on SAP HANA (Fashion and CFIN) configuration for SEC implementation Project.

Knowledge on SAP Business ware housing technologies using SAP BW and reporting suite.

Been part of Successful Implementation of NIKE SEC for Market place activation Greater China

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau

Hands on experience importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa, and analyzing data using Hive, Impala & Pig Latin Scripting

Define the system configuration requirements, identify gaps and recommend system modifications and process changes to optimally satisfy business requirements using the ETL tools like Informatica, SSIS and BI applications like Tableau, Power BI, Cognos etc. Define client reporting, data conversion and interface requirements.

Very proficient in working with large Databases in Databricks, Snowflake, Oracle, and SQL Server

Represented/lead discussions related to product/application/modules/team (for example, leads technical design reviews). Builds relationships with internal customers/stakeholders. Represent the team in front of the customer.

Took part in maintaining SSIS and SSRS reports and replicating them into Tableau.

Proficient in R Programming Language, Data extraction, Data cleaning, Data Loading, Data Transformation, Predictive Modeling and data visualization using R and Tableau

Worked on developing data extracts from HDFS to Spark shell for analysis.

Produce a detailed functional design document to match customer requirements.

Business Intelligence Tools:

TableauDesktop7.0/8.2/9.0,9.3/10.4.5,2020.4 Tableau server 9.3 &10.2,10.4, Data Bricks, Python, Microsoft Access, Cognos10.1.1, Qlik View, SSRS, Power BI, Splunk, SAP BW, SAP FIORI,

ETL/DataPrep Tools:

BeX Analyzer, SSIS, Informatica 9.x, Data Stage, Alteryx, SAS, Tableau prep

RDBMS:

Data bricks, Snowflake, Teradata, Oracle, MS SQL Server, My SQL, PostgreSQL, Netezza

Database Tools:

My SQL Management studio, Visual studio, Microsoft Visual Studio

Environment:

SAP HANA, SAP BW, BeX Analyzer, AWS EC2, Azure, Hadoop, R, R-studio

Process Methodologies:

Agile and Waterfall

PROFESSIONAL EXPERIENCE

Nike Inc., Hillsboro, OR

Senior BI and Visualization Engineer, Sep 2015 to Dec 2017

Jan 2019 to August 2022

Feb 2024 to till date

Projects Worked: APLA LATAM DSM Analytics, NA Analytics, NALC DC Operations, SEC Finance Reporting (MAGC), Supply Chain Planning, HR Analytics

Built Data model and executed analytics for CaSA DSM now LATAM for Assortment Planning and MFP.

Worked with APLA Business Geo team in getting the requirement and build Dashboards using POS data

Worked with CaSA Retailers in injecting the POS data into the APLA POS Pond snowflake and built dashboards on Tableau for visualization

Streamline processes and bridge the gap between IT and Business stakeholders.

Built Newsletter Dashboard for APLA LATAM POS to view Variance between Plan data and POS for all the Seasons and Quarters

Worked on managing the metrics like AOP, STD and RSV

Worked on building and align Microsoft access forecasting tool for Assortment Planning to view Bottoms up, Bookings, product line data

POC on Databricks integration with Tableau and replacing the snowflake data sources.

Worked extensively with LATAM Business partners in preparing Adhoc reports and issues and mitigate them to enhance the productivity

Worked on creating Availability and Quality Dashboards for R360 and POS data for Business users

Made Tableau Connect Aurora DB to extract the data and create a query to capture all the metrics based on ERD

Integrate Python libraries to Tableau for better visualization

Worked on Data Migration of Sh-16 daily DC Operation report from Cognos to Snowflake for extensive visualization

Scheduled automated workflows using Airflow DAG’s for the data sources which flow inside the Dashboards

Handling supporting requirements by developing Reporting solutions on the Tableau BI platform. This role will work within the Corporate IT department and support day to day reporting needs for multiple businesses.

Configured Operating Concern for CO-PA Business in SAP HANA

Created new BeX Queries as per the business requirement

Integrated Internal Orders and WBS projects from Source SAP to Downstream analytical systems

Mitigated Finance objects Cost Center, Profit Center and GL accounts flow in SAP Fashion to SAP BW COPA

Worked on the enhancements to add new fields in the advanced DSO Layer

Involved in high-level discussion with the customer to understand requirement

Better understanding on SAP BW landscape and data architecture

Involved in requirements gathering, solution design, development and implementation of SAP BI/BW Data Models.

Orchestrated non-SAP reporting, Inventory by Channel data from different entities to have one baseline data source for MAGC

Extensively worked on MultiProviders, InfoCubes, DSO’s and DataSources

Maintained the large data sets for the OLTP/OLAP systems in snowflake

Tested Tableau API calls and data validation using Postman

Set up and configuring Tableau token authentication for user API calls.

Data cleansing using Alteryx, loading the file with transformation and showing the output in TDE format

Worked on the application UI to present end-users with Tableau Dashboards and visualizations on the web and mobile platforms.

Experience with diverse source connection and requirements; Redshift, Initial SQL, Complex joins and data prep

Tested node.JS API calls in configuration to Tableau

Implemented user authentication, authorization and session management on the server using OAuth 2.0

Applied configurational changes to the Tableau Server application as needed and perform upgrades

Controlled user’s access to protect the environment

Created a user filter and secured it on restricting access at the data row level

Scheduled automated Tableau dashboards using Python on Autosys

Defined BI Strategy and Road Map to meet short-term business needs

Orchestrated and migrated Tableau server V 9.3 to 10.2

Worked on creating Interactive dashboards for IMP Activation

Responsible for supporting about 500 users accessing the Tableau Reports

Responsible for integration between tableau server and Drupal platform utilizing JavaScript

Responsible for data cleansing and ETL using Alteryx

Designed, created, and published customized interactive reports and dashboards using Tableau server

Administered user groups access levels to view data from the dashboard to API Tool

Integrate R using R serve install packages and help Tableau Workbook access

Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily

Created Alerts to the specified user if their published data source is failed to refresh or reached threshold limit

Built an enterprise BI strategy to deliver up-to-date reports and dashboards

Trained users on how to create and modify worksheets and data visualization dashboards

Technical Environment:

Tableau Desktop2020.4.19, 9.3, Tableau server 9.3, Teradata14, Data lake, SQL Server Microsoft Access, Python scripting, Snowflake, Management Studio, Oracle 10g, MS Access, R studio, Alteryx 10.6, Informatica 9.x, java script API, Drupal, SAP BW, SAP BeX Analyzer and Designer

United Health Group, MN

Sr BI Analyst/Developer July 2023 – Jan 2024

Facilitated business decision-making by developing, publishing and distributing regular reports,dashboards and metrics which increase in accuracy of the 12-month outlook by 30%

Performed Analysis on the data received for Client data Implementation on the inbound data platform and create dashboards.

Worked on data profiling activities for all the health care domains such as Eligibility, Cohort, Chronic conditions, Claims,.

Create a File Specification document which contains all the specs to perform the data ingestions from the initial raw layer.

Setting up Airflow dag to process the client file data until Operations data source layer.

Extensively used Spark framework in triggering the jobs for data processing

Worked with Business teams in gathering requirements to build the end-to-end layout for implementation of the new health plan and do the changes in the existing plans.

Worked on creating health plan ID and crosswalk rules for each CDO

Worked on writing complex queries to perform the validations on the health plans after inserting the data to the Hive Layer

Participated in establishing the connection between the Hive and HDFS Raw layer for data transformation.

Load the data from HDFS to SQL server layer and perform quality checks on the data captured in all the layers.

Perform data validations in the SQL server Production Enterprise Datawarehouse layer.

Worked with Data Operations team on creating synch activities with EDW to Tableau and Ubiquity

Perform validations on Tableau and create end user reports on top of it for Business Visualization

Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily.

Created Alerts to the specified user if their published data source is failed to refresh or reached threshold limit.

Built an enterprise BI strategy to deliver up-to-date reports and dashboards.

Trained users on how to create and modify worksheets and data visualization dashboards.

Technical Environment:

H-Scale, SQL Server,Tableau Desktop2020.4.19, 9.3, Tableau server 9.3, Ubiquity, Snowflake, Spark, NiFi, Management Studio, Oracle 10g, MS Access, Alteryx 10.6

Apple, Cupertino, CA

Senior BI Analyst /Developer, Sep 2022 – Feb 2023

Projects Worked: GBI Sales

Curated exceptional stakeholder communication by recommending improvements, managing daily work and support special projects, yielding 10% increase in project-based productivity

Worked extensively on migrating GBI Sales Teradata Dashboards to Snowflake platform

Created custom data sources to replace with the existing data source and map the metrics

Developed region specific Tableau dashboard view for Apple Marketplace Activation Dashboard

Worked directly with stakeholders and have business meetings on their new requirements and changes to the development

Involved in review meetings with the Business team to understand the requirements and changes

Worked in developing the dashboards as per the MIRO UI designs and have regular approvals with UI/UX teams in developing the dashboards

Created Data extracts for better performance and accessing data offline

Blended data from multiple databases into one report by selecting primary keys from each database

for data validation

Experience in snowflake data extraction from Tableau and build data models in snowflake as per the requirement.

Worked on ETL to modify the source data flowing into the End report

Experience on deploying the data into Azure data ware house

Experience in writing complex calculations in Tableau for various business processes

Used Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc.

Update data Extracts as per the schedule and update as per the production schedule.

Manage Tableau GBI Sales Project on the Tableau server and give access as per the Business requirements

Worked on Validating data with the respective integration teams to provide consistent data at all the layers

Run and Publish Tableau extracts on the server as both full and incremental refresh.

Solving the Performance barrier for the Dashboards after publishing on to the server

Technical Environment:

Tableau Desktop 2022.4, 2020.4.19, 9.3, Tableau server 2022.1.3, MIRO, QUIP, Snowflake, Teradata14.

BLUE SHIELD OF CA

Senior Tableau Administrator/Analyst, Jan 2018 to Jan 2019

Installed and configured the Tableau Server application

Created dashboards for Marketing, Strategy and Insights teams for Open Enrolment planning

Used advanced calculations like Level of Detail expressions and quick table calculations in most of the dashboards

Experienced in writing SQL queries

Migrated Netezza Tableau related historical data to Postgres with a new schema and schedule the automation

Coordinated database middleware issues with DBA's, system performance issues with System Architects.

Experience in creating dashboards for sales and marketing team to track and analyze weekly marketing campaign performance by different media

Designed and deployed interactive reports with Drill Downs, Drop down menu option and Parameters

Created Data extracts for better performance and accessing data offline

Blended data from multiple databases into one report by selecting primary keys from each database

for data validation

Experience in writing complex calculations in Tableau for various business processes

Experience in using Tabmon, Tabjolt, Scout, and Real player

Resolved various performance issues and analyzed the best process distribution for different projects

Used SAS enterprise guide for cleaning the data and ETL process

Used IBM’s data governance tool for understanding the logical data model

Create customized email alerts as needed

Experience in creating bar charts, pie charts, scatter plots using SAP Business Objects Webi

Used Tableau Desktop, create customized views on the performance of Tableau Server

Published workbooks and views to the Tableau server

Environment: Tableau Desktop/Server 9.1.3/9.3.1/10.1.3,10.4.5, Postgre SQL, SQL Server, IBM Netezza 7.2, SAS 9.4, Business Objects Webi 4.2, Splunk, IGC

GE POWER GENERATION SERVICES, San Ramon, CA

Senior Tableau Admin/dev, Feb 2014 to Aug 2015

Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop

Migration of QlikView reports to Tableau

Supported the reports developed in SAP BO – WebI, Dashboard design and crystal reports

Developed mappings using Informatica 8.6 to process different source files and load data into staging and extracting data from staging and loading into production using Informatica 8.6

Technical Environment:

Tableau Desktop 8.2, Tableau server, Informatica 8.x, SQL Server 2012, Teradata, SAP BO, Oracle 10g, MS Access, Windows 2007 server, MS Office 2007

LONGVIEW INC. AND RELAY HEALTH

Senior Tableau Developer, Oct 2011 to Dec 2013

Designed the Reports as per client Requirement and created the reports using Excel file and Oracle database

Created sets, groups and data bins when required

Created Parameters for desired functionality

Created conditional filters to filter the data on dashboard

Technical Environment:

Tableau Desktop 8.2, Tableau server, SQL Server 2012, Oracle 10g, MS Access, Windows 2007 server, MS Office 2007.

AVIVA INSURANCE & BASKIN ROBINS (Intern)

Cogno’s Developer, Aug 2009 to Sep 2011

Actively involved in business meetings with the customers for understanding the as-is process flow and new business requirements or enhancement activities

Prepared the technical and functional specification documents for report development, coding and testing

Developed a Framework Manager model by importing Meta data, preparing business logic, setting up object level security and developing and publishing package

Technical Environment: Cognos 8.4/8.3 BI (Report Studio, Query Studio, Analysis Studio, BI Modeling

EDUCATION

Bachelor of Technology (Computer Science), Nagarjuna University, India, 2010

Contact this candidate