SaiKrishna, Sr. BI Consultant | Bench Resource on Contract

SaiKrishna (RID : g8qolhsz3q9w)

Sr. BI Consultant

Location : Andhra Pradesh, India

Experience : 14 Year

Rate: $28 / Hourly

Availability : Immediate

Work From : Any

Category : Information Technology & Services

Shortlisted : 2

Total Views : 92

Key Skills

Python Tableau Server Hive Scoop PostGres Hadoop AWS Athena

Discription

Saikrishna

professional Summary

14 Years of IT experience in area of Data ware housing like Data Analysis, Visualization, Design, Development, Production Support, troubleshooting and Implementation with DWH tools like Tableau, IBM Cognos, Python and IBM DataStage
Completely involved in Planning, Setting up, Installation, Configuration of tools Tableau, DataStage v9.1, Cognos 10.2.1
Had worked on Databases Oracle 9i, 10g, 11g, MS SQL Server 2008, 2012, Teradata, Snowflake
Having good understanding about Python programming and Hadoop Eco system, AWS, PySpark
Strong knowledge on Data Ware Housing concepts like Entity-Relationship Model, Facts and Dimensions, and Dimensional Modeling (Star and Snowflake Schemas), Top down, Bottom Up approaches, and Data modeling
Design, Planning, setting up the BI Environment, migrated from Tableau 9.x to 10.x, ETL, SQL Server, Cognos BI
Working knowledge on Python scripts programing for Data manipulation, Data Extraction, Data Analysis and Conversion
Extensively worked with Tableau on Dashboard Design for Better Visualization and Analytics of User Data with adhoc
Had worked on ETL Tool – IBM DataStage with Processing Stages like Aggregate, Lookup, Join, Merge, Sort, Transformer, Remove Duplicate Stage, Funnel, Sequential Stages
Good working experience on Alteryx ETL tool
Good exposure in SQL concepts like Tables, Views, SPs, Functions, Indexes and Materialized views.
Good knowledge on implementing Slowly Changing Dimensions (SCD), DWH and RDBMS, Normalizations Concepts
Good Hands on experience on Hadoop Components like HDFS, Hive, Scoop, Flume, PIG, Impala, HBase, Zoo Keeper, Oozie, SPARK, Kafka, Hue
Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
Good knowledge on AGILE Development methodology for Implementation of Projects

Education: Bachelor of Technology in I.T., Bapatla Engineering College, Acharya Nagarjuna University, INDIA – 2008

TECHNICAL SUMMARY

SKILLS

TOOLS

Reporting BI

Tableau Desktop 2020.x, 10.x, 9.x, Tableau Server 2020.x, 10.x, 9.x, Birst v5.32, IBM Cognos v10.2.1, BI Cognos Framework Manager, SAS EG

ETL Tools

IBM Info Sphere DataStage v9.1, v8.1, v7.5, Informatica PowerCenter 8, Tableau Prep

Databases

SQL Server 2012, 2008 Oracle 9i, 10g, Teradata, Snowflake

Database tools

TOAD, AQT, SQL Developer, SQL Management Studio, Teradata SQL Assistance

Other Skills

Python, Notepad, Notepad++, MS office

Hadoop Components

Hive, Scoop, Flume, PIG, Impala, HBase, ZooKeeper, Oozie, SPARK, Kafka, Hue

EXPERIENCE SUMMARY

Deltacubes Technology Pvt.Ltd. Dec 2021 – till date

Sr BI Consultant

Domain – Retail

Tesco plc is a British multinational groceries and general merchandise retailer headquartered in Welwyn Garden City, England. In 2011 it was the third-largest retailer in the world measured by gross revenues and the ninth-largest in the world measured by revenues

Job Responsibilities:

Gathering requirements with Business Users and demoing wireframes of Dashboards during the requirements
Designed and Developed Dashboards using Tableau Desktop and published to Server
Designing Cost Monitoring System, Procurement Analysis and Supplier Analysis Dashboards
Extensively used most of the charts depending on need and design the attractive Dashboard with storytelling.
Having strong understanding of SQL and used Custom SQLs as Data sources.
Very strong knowledge on RLS and implementation in Dashboards
Good Working experience in automating Extract automation using tabcmd and Windows Batch program.

Environment: Tableau 2020.1, Tableau Server, Postgres, Python, Excel, SQL Workbench, Hadoop, Alation

Fidelity Charitable, Durham NC (TechnoSoft Corp) Oct 2019 – Apr 2021

BI Data Analyst