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 BISuite11/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
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.