Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sindhura Edarapalli

Prosper,TX

Summary

  • Proficient IT professional with Experience in Architecture, Design, Development, Documentation and Implementation of Various BI Solutions which includes Tableau, Microsoft PowerBI, IBM Cognos
  • Created Various Scorecards/Dashboards to provide ice on the glass view of the business to the leadership, Created Business process development metrics to identify the pane points and bottlenecks in the business planning process to drive efficiency,
  • worked with various Datasets like customers and sales Datasets, traditional RDBMS Datasets (Oracle, SQL Server, Teradata Etc) and Cloud Datasets (Snowflake & Azure).
  • Knowledge and Understanding of Cognos BI Suite 11/10/8 (All Studios), Migrating reports from Cognos 10.2.2 to Tableau (2021.x).
  • Well versed with the complete SDLC Methodologies and BI Life Cycle Development Process. Dexterous in congregating, comprehending and documenting Business Requirements, A good team player with excellent communication skills, ability to meet deadlines, multi-tasking and passionate when it comes to Data. Dexterous in congregating, comprehending and documenting user requirements.

Overview

6
6
years of professional experience

Work History

Business Intelligence Engineer

COSTCO WHOLESALE / TechEon Solutions
10.2019 - Current
  • Costco Wholesale Corporation is a membership-only warehouse club that provides a wide selection of merchandise
  • As of July 2012, it is the second largest retailer in the United States, the seventh largest retailer in the world and the largest membership warehouse club chain in the United States
  • Responsibilities:
  • Build various dashboards and scorecards for warehouse managers and higher executives, Implemented Row Level Security by building User/Groups in Tableau
  • Designed solutions for Tire Center and Warehouse Sales Projects, Worked end to end in creating Tableau Solutions for the business
  • Building Brand New Dashboards on Tableau 2021.x/2020.x/2019.x for Various Stakeholders across Costco International, Which included Complicated LOD calculations, RLS Securities, Performance Tuning, Dynamic Parameters and published to various dashboards to the Tableau Server
  • Retired multiple Dashboards/Reports from IBM Cognos 10.2.2 to Tableau, Migrated and implemented solutions in Tableau by using Azure Synapse as the Cloud source for Dashboarding/Reporting
  • Goal is to utilize Tableau as the Visualization platform to meet analytical requirements through the migration, combination, and restructuring of existing reports where appropriate
  • Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions
  • Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc
  • Using show me functionality
  • Articulating the business requirements into Reporting Requirement Documents and worked with our Product Owners to size our development stories for various Projects at Costco
  • Closely working with the Tableau Platform Support Team to understand Tableau Server Structure (Computation) and handling Viewer/Explorer Roles Licensing and Migration Process/Guidelines
  • Worked as a key role in Migrating Tableau Optical Dashboards to PowerBI, This involved Architecting solutions end to end and also providing users with Training in PowerBI
  • Worked with Power BI Admins in creating Change requests to deploy dashboards from Development to QA and to Production through Azure DevOps Release Pipelines
  • Environment: Tableau(2018.3,2019.2),PowerBI, Cognos 11/10.2 (Framework Manager, Dashboards), Azure Synapse, Oracle, SQL Server

Senior Visualization Engineer

Nike. Inc / TechEon Solutions
06.2018 - 09.2019
  • Nike is an American Multinational Corporation engaged in the design manufacturing and sales of footwear, apparel, equipment, accessories, and services, :
  • Worked as a Senior Visualization Engineer which involved working on various BI Tools (Tableau, Cognos, Business Objects), which involves Tableau Dashboard Development, Migration and Optimization
  • Worked on various Dashboards for Territories under APLA Team (Asia Pacific Latin America)
  • Worked on a Migration project which involved Migrating Cognos 10 Content to Tableau 2018.x, which involved end to end Migration with Role based security (RLS) in Tableau against Snowflake Database
  • Daily/Weekly meetings with Japan/SEA&I Teams to understand their business scenarios, and help performance tune their Tableau Dashboard’s
  • Worked with higher management and understanding Data Insights and comprehending business requirements and Created Self-Serve Datasets, Row Level Security for Extracts with POS Data (Snowflake), New Dashboards including business cases like Samples/Inventory and Demand Planning/Tracking/POS/Sales and Revenue for Territories
  • Understanding the Data sources behind the Business Object Universe (Japan Shipping) and Working with Data Engineer’s to get aggregated views (Consumption Views) created for Tableau Visualizations
  • Worked as a SiteAdmin for APLA, Which involved working for various teams across WHQ and understanding their business use case, Suggest/Educate the best practices on Tableau Site
  • Worked on a Dynamic way to trigger an extract using RestAPI (3.2 and 3.4) and the first to implement across Nike
  • Environment: Tableau(2018.3,2019.2), Power BI , Cognos 11/10.2 (Framework Manager, Transformer, Dashboards), Teradata, Snowflake, SQL Server

BI Developer

Cetera Financial Group / TechEon Solutions
05.2017 - 04.2018
  • Cetera Financial Group is one of the nation’s largest independent broker-dealer and investment adviser families
  • Responsibilities :
  • Migration Process : Involving completely into HRIS Human Resource Information System, understanding specific KPI’s, Actively involved with the DBA’s for Transformations from ULTIPRO (HRMS) to ORACLE (CRM)
  • Technical meeting with the Oracle team to understand futuristic cloud based Oracle Transactional Business Intelligence (OTBI) tool
  • Scorecards and Dashboards on Tableau which included RLS Security (Row Level Detail) with LOD Calculations and published Data Sources and Workbooks on the Tableau Server
  • Developed close to 35 reports which includes Tableau Dashboards (Cetera Human Resource), Scheduled reports (Directly to VP’s of Cetera)
  • Directly reported to the VP of Planning and Execution and worked closely with the IT team from Drivestream (Offshore Team)
  • Daily and weekly meeting with the Offshore team, Collecting status reports for migration, Planning deadlines and production issues for migration
  • SME for Specific Areas of HR which include Benefits, Payroll, Core Data, Commission, Bonus Structure, PTO’s, W4’s and Earnings
  • Developed various reports with Oracle’s OTBI Tool and Validated reports with Ultipro’s Cognos reports as a part of migration
  • Environment: Tableau (Dashboards, Scheduled Reports), SQL Server
  • Compiled, maintained and developed database systems for tracking tailored content reports.

Education

Bachelor of Science - Computer Science

Gitam Engineering College
Visakapatnam, India

Skills

  • BI Tools
  • Tableau (9x,10, 2018x, 2019x & Above), PowerBI, Cognos 1022
  • OS : Windows 11/10/7/XP Server 2003
  • Databases : Oracle /0/11g, MS SQL Server 2005, DB2, Teradata, Snowflake, Azure
  • Languages :SQL, HTML, XML
  • ULTIPRO (Human Resource Information System), TOAD, VMware Macromedia Flash
  • Languages :SQL, HTML, XML
  • ULTIPRO (Human Resource Information System), TOAD, VMware Macromedia Flash
  • Languages :SQL, HTML, XML
  • ULTIPRO (Human Resource Information System), TOAD, VMware Macromedia Flash

Timeline

Business Intelligence Engineer

COSTCO WHOLESALE / TechEon Solutions
10.2019 - Current

Senior Visualization Engineer

Nike. Inc / TechEon Solutions
06.2018 - 09.2019

BI Developer

Cetera Financial Group / TechEon Solutions
05.2017 - 04.2018

Bachelor of Science - Computer Science

Gitam Engineering College
Sindhura Edarapalli