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