Krishnam Raj Jatoth

Plano,TX

Summary

Certified Snowflake and ThoughtSpot Solutions Architect with over 10 years of experience creating effective data analytics solutions. Skilled in using various business intelligence tools like Qlik Sense, Qlik View, Tableau, and ThoughtSpot to turn complex data into useful insights. Strong business understanding and problem-solving abilities. Good at collaborating with cross-functional teams (IT and business units) to turn business needs into effective technical BI solutions. Experienced with both on-premises databases (SQL Server, Oracle, Teradata, DB2) and cloud platforms (Snowflake, Postgres, NetSuite) to build solid data models. Proficient in the entire BI development process, from gathering business needs to creating interactive dashboards that help stakeholders make informed decisions. Passionate about keeping up with the latest trends in Business Intelligence to deliver innovative data solutions. Hands-on in designing and building ETL and ELT pipelines for processing large data from multiple sources into Data Warehouses/Data Lakes using Informatica and DBT (Data Build Tool). Focused on best practices in data modeling and ensuring data quality, with strong skills in SQL. Experienced in data modeling for both transactional (OLTP) and analytical (OLAP) systems, as well as Data Warehousing, Data Mining, and various ETL tools. Skilled in providing training for users to make data accessible to all departments.

Overview

years of professional experience

Work History

ThoughtSpot/Qlik Data Solutions Developer

XPO Logistics

Clayton, MO

10.2022 - Current

Led the comprehensive process of managing data from initial collection through to reporting, ensuring the infrastructure and technical processes were robust and efficient
Worked closely with Business Owners and IT teams across the organization to understand their reporting needs and develop user-friendly dashboards and mobile applications
Engaged with stakeholders to identify their specific data requirements, creating project plans that outline how to translate these needs into functional specifications for BI tools like Power BI, Tableau, Qlik, and ThoughtSpot
Facilitated the migration of reports and dashboards from Cognos to ThoughtSpot, ensuring a seamless transition by mapping existing data structures and visualizations to the new platform while maintaining data integrity and functionality
Collaborated with stakeholders to understand their reporting needs and optimized the migration process by implementing best practices for data modeling and visualization in ThoughtSpot, enhancing user experience and accessibility of insights
Extract, Transform, Load (ETL) pipelines to facilitate the movement of data in and out of the data warehouse, ensuring data integrity through validation using advanced SQL queries
Integrated Qlik applications with Google Sheets using Google Drive Connector, allowing real-time data loading and management while scheduling regular data refreshes
Established connections within ThoughtSpot to create data models, pulling in necessary tables, setting up column attributes, and constructing worksheets to visualize business data effectively
Oversaw the ThoughtSpot environment, handling user administration, security settings, and system monitoring to ensure smooth operation
Created detailed documentation outlining best practices for the development and implementation of ThoughtSpot solutions, helping maintain quality standards across projects
Conducted comprehensive training sessions for business users and data analysts on navigating ThoughtSpot, performing advanced searches, writing formulas, and customizing visualizations
Designed innovative methodologies and architectures to enhance the functionality of ThoughtSpot's search engine, improving user experience and data retrieval
Provided expert guidance in designing, developing, and implementing solutions using Tableau and ThoughtSpot, ensuring alignment with business goals
Implemented data governance policies to maintain data quality, lineage, and metadata management, which is crucial for reliable reporting
Developed multi-tenancy features in ThoughtSpot, allowing for the creation of isolated organizational units within the platform for better data management
Actively tracked user adoption rates and optimized query performance to enhance the overall search experience for business users
Utilized QlikSense's built-in GeoAnalytics capabilities to create interactive maps and visualizations for analyzing spatial data, integrating external geospatial data sources as needed
Developed custom APIs using Qlik Sense's server-side extension framework to allow seamless integration with other applications, enhancing functionality
Addressed complex data modeling issues within ThoughtSpot, such as chasm traps and fan traps, ensuring accurate data representation
Provided ongoing support and troubleshooting for ThoughtSpot users, resolving technical issues to ensure smooth operation and user satisfaction
Created and optimized ETL processes using Power Query and Qlik Script Editor to clean and transform data from various sources for reporting
Designed and developed dynamic, interactive dashboards and reports across multiple BI platforms, highlighting key performance indicators and insights
Conducted sophisticated data transformations from on-premises databases and cloud sources into Snowflake, enabling effective data analysis and reporting
Employed advanced analytical techniques using DAX in Power BI and Set Analysis in Qlik to uncover trends and insights from the data
Created Qlik Mashups, combining QlikSense visualizations with other web content to enhance user interaction and data presentation
Managed data refresh schedules, caching strategies, and query optimizations to enhance the performance and responsiveness of BI reports
Leveraged Python and dbt tools to build SQL-based ETL processes, pulling data from various sources to facilitate thorough data analysis and reporting

Sr. Business Intelligence Developer

Greemus Software Technologies Private Limited

Hyderabad, India

04.2014 - 07.2022

Worked on the Server related tasks including setting up the environment and maintenance of the existence Qlikview applications
Consulted with and advised senior management and multiple clients on high impact data or database management issues, influencing strategic direction
Developed Macros to do the write backs from the applications into SQL Databases
Performed data analysis, gap, and impact analysis
Developed SQL code to manipulate and analyze high-volume, high-dimensionality data from various sources using a variety of tools and data analysis techniques
Helped end users to design test cases and worked through multiple UAT cycles
Developed various QlikView Associative Data Models by extracting and using the data from various sources like QVD files, MS SQL DB, Excel, and Flat Files
Involved in the daily standup with business analysts and data architect to resolve the business issues and Data challenges
Worked independently and capable of multitasking & prioritizing in a fast paced and agile work environment
Created the desired data model, we have implemented a lot of visualizations on QlikSense, QlikView, Tableau and Cognos where we have created the Master Items for Dimensions, Measures and Visualizations so that we can reuse them in other sheets
Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software
Developed Master resource library across Qlik Sense Apps and trained users in leveraging them to create custom stories/additional visualization based on their need
Prepared the project estimates and SOWs with effort hours based on the scope, size, and expectation of the users
Implemented Application-Level Section Access and configured security rules on Qlik Sense streams to control user actions over Qlik Sense Hub
Involved in design, development, and documentation on various phases of product life cycle
Performed Data Cleansing to avoid duplicate, corrupt or inaccurate data using SSIS tools and performed data validation
Developed standards to ensure that data designs follow architectural best practices and appropriate business rules
Facilitated data integration, conformity, data quality, integrity, and consolidation
Created and maintained critical data documentation and metadata that allows data to be understood and leveraged as a shared asset
Aug' 19 Jul' 22

Business Intelligence Developer

04.2014 - 07.2019

Built ingestion processes to prepare, extract, and enrich a variety of structured and unstructured data sources (social media, news, internal/external documents, images, video, voice, emails, financial data, and operational data)
Utilized a hypothesis-driven, problem-solving approach to design, construct, and rapidly test/iterate exploratory models that will reveal insight and opportunities for the client; proactively broaden and deepen client relationships by working with varying levels of client team members
Customized and tweaked the scripts and necessary data transformation, created simple and complex expressions using Set Analysis
Conducted discussions with Business Analysts (BAS) and end users to create several test scenarios for running the reports
Implemented data transfer from various types of databases with conversion through SSIS
Participated in Business Processes with the Business Analyst to understand the requirement and reviewed High Level Design Documents, Functional Specifications documents with the Technical Manager
Wrote SQL queries and created ad hoc queries to perform data validation and analysis
Tested Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users
Played a major role in Regression Testing, Beta Testing, bug fixing and promoting changes to Production
Involved in the implementation of Data warehouse on Amazon Redshift
Worked on migration of visualizations from Qlikview to Tableau Platform
Involved in the migration of various Dashboards and Analysis Reports from Cognos and Sql Server Reporting Server into Qlikview
Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software
Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts
Created Queries in T-SQL, Stored Procedures, Clusters and Views to store the data of clients, advisors
Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance
Performed T-SQL tuning and optimization of queries for reports that took longer execution time
Worked with the SSRS Dashboards and SSIS Packages and involved in parameterizing the deployments
Evaluated system performance and made technical recommendations to resolve any performance issues related to SSRS and BI solutions
Provided documentation and training to transfer knowledge and operational support
Responsible for maintaining data integrity and the ongoing quality control of delivered reports
Validated system build/reports design and perform audit report findings of security and data controls

Education

Master of Supply Chain Analytics -

Saint Louis University

Saint Louis, MO

12.2023

Bachelor of Technology - Information technology

Jawaharlal Nehru Technological University

India

05.2014

Skills

Database Systems: Snowflake, Postgres, Teradata, Oracle, DB2, Mainframes, No SQL Neo4j Graph Database, AWS Data Lake, Amazon RedShift, Dynamo DB, Microsoft SQL Server, MySQL, Merchandise Management Systems, AS400, DB2, Access, NetSuite Cloud, Amazon Redshift, Numina, Salesforce CRM
ETL Tools & Data Pipeline Platforms: dbt cloud, Informatica, Airflow, Alteryx, AWS Glue, SQL Server Integration Services, DTS
Data Storage and Warehouse Platforms: Snowflake, Postgres, AWS S3

Event Stream processing Platforms: Kafka, Spark, Data Bricks, Rabbit MQ
Reporting Tools: ThoughtSpot, QlikSense, QlikView, Tableau, Cognos, Google Analytics, Google Data Studio, SQL Server Reporting Services
Programming: DAX, Qlik Scripting, ThoughtSpot TML, Python, T-SQL, Shell Script, HTML, XML, COBOL

Environment:

QlikView v11.2 SR 4/11.2 SR 5/10, Qlik Sense 1.1/2.0, Numina, Merchandise Management System, AS400, SQL Server& SSRS 2014, NetSuite Cloud, BOX

Timeline