Sumit K.

Sumit K.

Datawarehouse , BI and Visualization Technical Expert

Ghaziabad , India

Experience: 12 Years

Sumit

Ghaziabad , India

Datawarehouse , BI and Visualization Technical Expert

12 Years

Now you can Instantly Chat with Sumit!

About Me

Technical Architect /AWS Consultant having around 12 Years of extensive experience in ‘BI Analytics & AWS Cloud’ Solutions on Insurance, Heal...

 

  • Strong experienced 10+ in Database Design & Development, Analytics, Business Intelligence application with Tableau BI Data Visualizations and MS-BI (SSRS, SSIS), Python & R Visualizations.
  • 2+ Years of experienced in different services of AWS (Redshift, Data Pipeline, Lambda (code in Python), SNS, EMR, S3, EC2, Glue, Kinesis etc.).
  • Hands on experience in creating Database objects, Database modeling and implements Data warehouse solution with ETL concept.
  • Extensive experience in Tableau Desktop, Tableau Server, Tableau Reader, Public and Mobile in various versions of Tableau 6, Tableau 7 and Tableau 8.x.
  • Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Experience in leading and managing teams. Handled multiple roles in Project- Tech Lead, Delivery Lead, Solution Architect, AWS Cloud, Technical Consultant, Data modeler, Developer, Tableau Admin, BI/DWH Solution analyst.
  • Expertise in working with all phases of Software Development Life Cycle (SDLC) - requirement gathering from business users, analysis, design specification writing, development, testing and implementation.
  • Very strong analytical skills, ability to learn quickly, good understanding of Business Process Management and Business requirements of the customers and translating them to specific Software Requirements.
  • Expertise in analysis, design and implementation of data warehousing/ BI Analytics solutions using SQL Server, Tableau, SSIS, SSRS technologies.
  • Experienced for various data migration, data integration, data security modules for data lake project using various AWS cloud technologies like Redshift, EMR, AWS Glue, AWS Athena, S3, AWS CLI, RDS, EC2, Kinesis, SQS, DMS, IAM, Cloud Formation, Cloud Watch, Elastic Load Balancer etc.
  • Strong experience in building solution & Technical design, hands-on implementation for AWS data ecosystem, Solution and Technical Architecture for DW/BI, engineered end-to-end ETL & BI architecture for BI Products and projects

Show More

Portfolio Projects

Guardian Data Lake

Company

Guardian Data Lake

Description

Guardian Data Lake is an Enterprise Master Data Ecosystems for all the Guardian’s company data. It’s a centralized, curated, and secured repository that stores all consolidated data, both in its original form and prepared for analysis.

Guardian Data Lake system delivers an integrated suite of services that provide everything needed to quickly and easily build and manage a data lake for analytics. It enables to break down data silos and combine different types of analytics to gain insights and provide better business decisions in cloud environment and all reporting and ML system using this ecosystem as a source. Client data extracts to Data Hub, to S3 and finally into the Redshift data warehouse. For this process used Matillion. Matillion for AWS Redshift is a GUI-based ELT tool designed for S3 and Redshift specifically.
 

Show More Show Less

Tools

AWS

REED Enterprise Data Warehouse

Company

REED Enterprise Data Warehouse

Description

  • Designed data models and ETL processes to deliver high quality information to the end user.
  • Brought down the execution time of data processing in ETL packages from 7 days to < 6>
  • Worked with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
  • Introduced visualizations (world map, boxplots, trend prediction, etc.), slice and dice functionality to drive powerful insights in the reliability.
  • Responsible to rethinking and automation of routine process, and apply solution in new ways.
  • Integrated Python and R with Tableau for higher level visualizations.
  • Created Interactive Dashboards using Tableau and Shiny programming.
  • Designed applications for Load the data from various sources like excel files, text file and different database.
  • Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Agile project methodology approach.
  • Created Business Requirement Documents & Functional Design Documents. Created Use Cases, User Stories & Test Cases implemented Mapping logics and complex transformations as per business requirements.

Proposed several architectural solutions to the existing design and performance improvement processes

Show More Show Less

Tableau Push Email

Company

Tableau Push Email

Description

Tableau Push Email is an automation platform intended to seamlessly communicate with Tableau Server with the help of tabcmd utility. The idea behind it is that anyone should be able to easily share and customize any tableau report on email to user. In its current form, Tableau Push Email exists as a PowerShell script that is set up to run at frequent and regular time intervals.  All the information it needs to enable to access Tableau Server PostgreSQL repository, and the published views of the Tableau Server it is set to run against. This was a limitation with Tableau server product to send tableau reports in .csv format for user’s inbox.

  • Designed and Developed the Tableau Push Email Tool/Process from scratch to final deliver to business.
  • Developed the complete script using the PowerShell, Tabcmd, and Python.
  • Responsible for developing the client’s internal and External BIA reports and Client Standard data story for emailing.
  • Responsible for modification in existing script as per client need.
  • Worked on Jenkins deployment for customized report.
  • Designed a python script to invoke the tableau server.

Worked on SharePoint form customization

Show More Show Less

Absence Management System

Company

Absence Management System

Description

  • Gathering and analyzing business requirements, providing solution directions using Tableau thereby translating business requirements into report visualization and insights.
  • Developed interactive data visualizations reports and developed automated processes for updating content-Data used in standardized dashboards. Created formulas and calculations within Tableau to meet the needs of complex business logic and comfortable with advanced Tableau topics such as parameters, geographic mapping/coding, data blending and extract optimization.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using customer and campaign KPI's.
  • Developed Visualizations using Cross tables, Bar Charts, Pie Charts, Donuts Charts, Maps, Line Charts, Scatter Plots and Combination Chart, Filters, Marking, Drill Down, Hierarchies, Color and Custom Expressions, Actions and Calculations.
  • Defined Group level security and ensured Active Directory Integration within Tableau Environment for automated user provisioning, SAML for security architecture and IIS (Ports) for Web Servers., licenses, integration and the appropriate permission sets for Tableau server logons and security checks.
  • Managed Tableau platform administration functionalities and Internal Web portal FIT Metrics, by adhering to best practices, metadata management, cache/ history management, user management (managed the users, groups, projects, sites, workbooks), scheduling refreshes, content delivery administration, security implementation, data source configuration, platform environment monitoring and support, server back up and load balancing techniques to deploy Tableau server architecture to support high availability and scalability.
  • Acted as tier one support to build custom Admin views (Dashboard/Visualization) of server usage based on input from support team and service reporting (KPI) by leveraging PostgreSQL.
  • Performance tuning of workbooks, data sources, and providing best practices for user community.
  • Serve as a primary point of contact supporting the Tableau Server platform in Development, Production, and QA and Production Support issue resolution. Monitor and troubleshoot platform to guard against preventable issues and ensure performance that meets SLA.
  • Experienced administering using TABCMD and TABADMIN for Tableau server in a multi-site environment, server /platform sizing for projects, hardware and software requirements with a particular emphasis on performance maximization.

Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.

Show More Show Less