Summary
Overview
Work History
Education
Skills
Accomplishments
Additional Information
Certification
Timeline
Generic

Srikanth Cheguri

Summary

AS a Senior BI Analyst with 13 years of IT industry experience, specializing in data analytics and business intelligence. A certified expert in AWS Architect, and Tableau Desktop and Tableau server and SysOps Admin Engineer, i'm strong on track record of migrating complex datasets between Tableau and AWS QuickSight, utilizing ETL processes and Snowflake for optimized data warehousing. He excels in designing and implementing interactive BI reports and dashboards across various platforms, including R, RStudio, and Tableau,Power BI coupled with extensive administration and performance tuning of Tableau environments. proficiency in SQL, alongside his hands-on experience with AWS data technologies (S3, IAM, RDS, Redshift, Glue), empowers him to deliver robust, data-driven solutions that enhance operational efficiency and decision-making. His commitment to best practices and continuous improvement in BI systems makes him a valuable leader in data strategy and analytics.A collaborative team player and leader,in cross-functional environments, where he effectively gathers reporting requirements and translates them into actionable insights. His strategic use of AWS data technologies and tools like Athena and IAM ensures robust data management and security practices, aligning with organizational goals and enhancing overall performance.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Sr. BI Analyst | Aws Quicksight | Tableau

Salesforce
09.2023 - Current

· Work with our Technical Business Analysts, customers & data source system experts to understand reporting needs, underlying source data and associated business rules

· Using ETL tools and/or SQL, develop data extract routines from a variety of disparate data sources and conform them to the Harris Resolve Data Integration Template format

· Develop data visualizations using a variety of applications such as AWS Quick Sight, Tableau, Tableau Online, and others. Participate in functional and technical design sessions Gather end-user requirements for data dissemination and reporting. Use various applications to analyze source system data and identify data quality issues and anomalies that will need to be corrected and/or handled in ETL routines

· The migration of legacy Tableau reports to AWS Cloud, enhancing data accessibility and system performance.

· Orchestrated the transition of critical business reports from AWS Big Site to Tableau Cloud, ensuring seamless integration and minimal downtime.

· Led extensive migrations between Tableau and AWS Quick Sight, optimizing visualization capabilities and dashboard performance.

· Managed reverse migrations from AWS Quick Sight back to Tableau, ensuring data consistency and alignment with user preferences and business requirements.

· Collaborated closely with the Product Manager and leadership board to align project objectives with strategic business goals.

· Played a pivotal role in architectural design sessions, contributing expertise in scalable cloud solutions and data integration strategies.

· Utilized the Tableau Content Migration Tool for efficient content transfer, maintaining data integrity and report functionality.

· Experience with AWS API Gateway, Lambda Functions.

· Design experience using Node, Express, REST.

· DynamoDB Streams by using NoSQL you can trigger a Lambda function to perform additional work each time a DynamoDB table using NOSQL

· Analyze and communicate test results and advancement

· Log and verify defects

· Work with partners and third parties on troubleshooting and analyzing issues

· Work as key member of R&D team to analyze and program changes in product suite

· Maintain development deadlines and provide accurate estimates

· Analyze and troubleshoot product stability issues reported by clients

· Follow functional/technical specifications and work with Business Analysts to ensure delivered products meet specifications

· Participate in a cross-functional team to design, build, test and deploy complex analytical solutions utilizing Quick sight.

· Participate in business requirements and design review sessions.

· Perform detailed analysis of source systems and source system data and model that data in Quick sight.

· Design, develop, and test Quick sight dashboards to meet customer requirements.

· Participate in design workshops, providing technical insight and knowledge.

· Experience in AWS data technology products and AWS environment S3, IAM policies, roles, RDS, Redshift, Glue.

· Strong SQL skills for data wrangling, querying, and transformation with AWS Athenas.

· Interpret written business requirements and technical specification documents.

· Create and maintain technical design documentation.

· Perform quality coding to business and technical specifications.

· Constructed API through AWS Gateway & Lambda, to ensure server calls are authorized before they modify the database, and handle API calls in a separate environment without database access

Sr, Data Science Analyst | AWS | Tableau

Wisconsin Department of Health Services
Madison, WI
10.2020 - 08.2023
  • I Involved Tableau and AWS Quick sight developer is involved in the full technology life cycle and responsible for reports designing, coding, automating, configuring, testing, implementing, and supporting
  • Will work closely with Technical Architects, Data Engineer and Data Analysts and to understand the business requirements that drive the develop the reports
  • The DHS Tableau implementation and the associated charts, graphs, maps, and table data are critical to DHS’ COVID-19 response AWS Quick Sight Tableau supports all of the dynamic charts, graphs, tables, maps, etc
  • For the COVID-19 data on the DHS website in addition to supporting similar opioid publication information
  • As part of the State Emergency Operation Center, numerous internal and external staff have built processes and procedures to gather and present data dynamically via the Tableau system
  • My Responsible I used to handle Pricing team and Generate reports like generate like File claims Reports, View claim status and payment details View pending claims, Respond to document requests and Activate mortgage insurance coverage, Transfer servicing, Transfer servicing, Report loan modifications, Cancel mortgage insurance and Access billing and premium details
  • Develop and document predictive models in a clear and reproducible manner
  • Work on some of the most complex problems imaginable at the intersection of two dynamic industries – finance and technology
  • Assist in growing data science economic research skills in the team
  • Build relationships with clients by understanding their business challenges and formulate business solutions using text analytics Work with our Technical Business Analysts, customers & data source system experts to understand reporting needs, underlying source data and associated business rules
  • Using ETL tools and/or SQL, develop data extract routines from a variety of disparate data sources and conform them to the Harris Resolve Data Integration Template format
  • Develop data visualizations using a variety of applications such as AWS QuickSight, Tableau, Microsoft Power BI, and others
  • Participate in functional and technical design sessions Gather end-user requirements for data dissemination and reporting
  • Use various applications to analyze source system data and identify data quality issues and anomalies that will need to be corrected and/or handled in ETL routines

The DHS Tableau implementation and the associated charts, graphs, maps, and table data are critical to DHS’ COVID-19 response AWS Quick Sight Tableau supports all of the dynamic charts, graphs, tables, maps, etc. for the COVID-19 data on the DHS website in addition to supporting similar opioid publication information. As part of the State Emergency Operation Center, numerous internal and external staff have built processes and procedures to gather and present data dynamically via the Tableau system.

My Responsible I used to handle Pricing team and Generate reports like generate like File claims Reports, View claim status and payment details View pending claims, Respond to document requests and Activate mortgage insurance coverage, Transfer servicing, Transfer servicing, Report loan modifications, Cancel mortgage insurance and Access billing and premium details

Develop and document predictive models in a clear and reproducible manner.

Work on some of the most complex problems imaginable at the intersection of two dynamic industries – finance and technology. Assist in growing data science economic research skills in the team.

Build relationships with clients by understanding their business challenges and formulate business solutions using text analytics

Work with our Technical Business Analysts, customers & data source system experts to understand reporting needs, underlying source data and associated business rules

Using ETL tools and/or SQL, develop data extract routines from a variety of disparate data sources and conform them to the Harris Resolve Data Integration Template format

· Develop data visualizations using a variety of applications such as AWS QuickSight, Tableau, Microsoft Power BI, and others. Participate in functional and technical design sessions Gather end-user requirements for data dissemination and reporting. Use various applications to analyze source system data and identify data quality issues and anomalies that will need to be corrected and/or handled in ETL routines

· Execute testing of our software

· Analyze and communicate test results and advancement

· Log and verify defects

· Work with partners and third parties on troubleshooting and analyzing issues

· Work as key member of R&D team to analyze and program changes in product suite

· Maintain development deadlines and provide accurate estimates

· Analyze and troubleshoot product stability issues reported by clients

· Follow functional/technical specifications and work with Business Analysts to ensure delivered products meet specifications

· Developed expertise in Power BI and Tableau by completing online tutorials and hands-on projects.

· Migrated existing reports and dashboards to Power BI and Tableau, improving data visualization capabilities and user interactivity.

· Transformed data extraction, cleaning, and modeling processes to leverage the functionalities of Power BI and Tableau.

· Collaborated with cross-functional teams to gather reporting requirements and translated them into interactive dashboards and visualizations.

· Integrated multiple data sources into Power BI and Tableau, including databases, APIs, and spreadsheets, ensuring comprehensive data analysis.

· Designed intuitive and visually appealing dashboards in Power BI and Tableau, enabling stakeholders to make data-driven decisions effectively.

· Implemented advanced calculations and measures using DAX in Power BI and calculated fields in Tableau to derive valuable insights from the data.

· Participate in a cross-functional team to design, build, test and deploy complex analytical solutions utilizing Quick sight.

· Participate in business requirements and design review sessions.

· Perform detailed analysis of source systems and source system data and model that data in Quick sight.

· Design, develop, and test Quick sight dashboards to meet customer requirements.

· Participate in design workshops, providing technical insight and knowledge.

· Experience in AWS data technology products and AWS environment S3, IAM policies, roles, RDS, Redshift, Glue.

· Performance tuning / Server management of tableau server environment (clustering, Load

· balancing).

· Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data

· Connections.

· Manage and support migration of objects (dimensions, measures, hierarchies, reports,

· workbooks, dashboards), from development to production environments.

· Results oriented with an ability to work in team and individual contributor work environments.

· Innovative thinking to solve challenging problems.

· Results oriented with an ability to work in team and individual contributor work environments.

· Involved tableau server creating architecture, design, and development skills.

· Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that

· Strong SQL skills for data wrangling, querying, and transformation with AWS Athena.

Senior Data Analyst | AWS Services|Tableau

WellCare Health Plans
Tampa, FL
03.2019 - 09.2020
  • Collects, analyzes, and shares data to help business teams drive improvement in key business metrics, customer experience, and business results
  • Works with the BI Analyst during implementation, gathering additional information when needed and keeping the business informed
  • Using Tableau Desktop 2020.2.4 Version
  • Implements data structures using best practices in data modeling, processes, and technologies
  • Performs data conversions, imports and exports of data within and between internal and external software systems
  • Implements tools and frameworks for automating report generation, identification of data-quality issues, and data governance
  • Excellent team player with very good communication skills and problem solving abilities
  • Data Preparation experience with Alteryx
  • Well acquainted with SDLC process and it’s various aspects like functionality, performance and integration
  • Worked extensively with Advance Analytics, Actions Filters, Calculations, LOD, Blending, Parameters, Background images, Maps, Trend Lines, Statistics, and Dual Axes
  • Experience in creating various views in Tableau like bubble, donut, tree map, bar chart etc
  • Also Developed custom USA Geo Coding map & with help of WMS Servers, illustrating the potential
  • Revenue change across different geographic markets
  • Created Monthly PTD analysis Dashboard to monitor the application status based on specific Doses
  • Designed Whole sale inventory Based on budget and LE
  • Developed different types of Tableau Reports like Cross tab
  • Creation and modification of some of the existing reports and dashboards
  • Utilizing capabilities of Tableau such as Forecasting, Table Calculations, Basic Arithmetic
  • Calculations, String Manipulations, Custom Aggregations and Dashboard actions
  • Daily use of complex Excel formulas and pivot tables to manipulate large datasets
  • Taking existing data from a separate document and inputting it into Excel
  • Created External filter, internal filter, and Context filter to improve performance
  • Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data from different perspectives
  • Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations
  • Used dimension on Page shelf for a detailed analysis of the view by members of the dimension
  • Rev Pro Implementations Netsuite ERP Knowledge and experience Mandatory requirement is to have functional experience with the following Netsuite modules for Receivables, Order Management and Inventory Experience in Configs, Customizations and working knowledge of integrations for Rev Pro implementation is mandatory
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views
  • Created Dashboards with interactive views, trends, and drilldowns
  • Published Workbooks and Dashboards to the Tableau server
  • Designed and setup user security for the entire landscape to facilitate Windows AD login
  • Used Tableau Cmd for various Dashboard migrations from one environment to another
  • Setup of Distributed Server environments for optimum load balancing
  • Creating a financial strategy or budgeting plan from scratch and typing it into Excel
  • By using Rev Pro Transferring a schedule from an outside source and rebuilding it in Excel
  • To calculate and record data sets efficiently in Excel has various functions and shortcuts
  • Utilized the Tableau Content Migration Tool for efficient content transfer, maintaining data integrity and report functionality.
    Led multiple projects leveraging AWS services, including Lambda, Athena, DynamoDB, S3, and Redshift, to optimize data storage and retrieval processes.
    Implemented AWS Glue for streamlined data management and transformation, significantly reducing manual data handling.
    Developed and maintained PostgreSQL and Snowflake databases, ensuring robust data architecture and support for analytics.
    Enhanced data operations by integrating advanced AWS technologies, facilitating more agile data access and analysis.
    Promoted Agile methodologies within the Salesforce project team to improve project responsiveness and stakeholder satisfaction.
    Contributed to continuous improvement initiatives by proposing and implementing innovative data solutions that reduced costs and improved efficiencies.
    Conducted thorough testing and quality assurance of migrated systems to ensure compliance with original specifications and business needs.
    Provided ongoing support and training to team members on new cloud technologies and data migration processes.

Business Analyst/Tableau, Data Transformation

Fannie Mae
Washington, DC
11.2018 - 02.2019
  • Gathers business requirements from different Department in single family & Creating Data Structure According in Spread Sheets & Creating Scripts in Oracle Database
  • Experienced working with unstructured data creating workflows in Alteryx software with documentation and implementation of the processed data
  • Worked on visualization using technology such as R, RStudio and QlikView
  • Design, develop, and deliver interactive data visualizations using Tableau desktop and Tableau server and also design, develop, and deliver reports using other business intelligence tools
  • Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server
  • Successful and rapid conversion of Legacy BO XI 3.1 Reports to BI 4.1 SP3
  • Design and Developed Multisource universes using Rev Pro
  • Enhanced report performances by tuning the derived tables and join structures
  • Provided technical guidance and solutions to peer technical teams
  • Created Dashboards for tracking live data which are highly optimized for faster runtime
  • Advised top management on Appropriate Employee Corrective actions in Alteryx
  • Created organizational flow charts in Single Family score cards to path reports
  • Working with Mortgage Loan payment processing, Accounting and reporting etc
  • Worked with senior-level management to create fair and consistent HR policies and procedures
  • Used to be Maintains security permission structure in Tableau server and in Bi Tools
  • Worked on Data consulting Activities & in client support
  • Conducts other data analysis and data consulting activities as required to support client delivery
  • Create dashboards and reports within Tableau used Design and implement proof of concept solutions and create advanced BI visualizations

Sr. Data Analyst III/AWS QuickSight | Redshift

Capital One
Richmond, VA
01.2018 - 10.2018
  • Creating tables in database in Aws Redshift Cloud by using SQl Workbench, and also objects like tables, views, procedures, triggers, and functions
  • Writing python script to Automate the data from Teradata to cloud Environment
  • Configure the VPC, EC2 instances, S3 buckets, RDS (MySQL)
  • Configuration of AWS in built SNS/SQS setup for job scheduling
  • Create required shell or python scripts for data push from Tableau/Teradata to S3
  • Developed Tableau visualizations and dashboards using Tableau Desktop
  • Experience in SQL development with understanding of relational and multi-dimensional design
  • Led extensive migrations between Tableau and AWS QuickSight, optimizing visualization capabilities and dashboard performance.
    Managed reverse migrations from AWS QuickSight back to Tableau, ensuring data consistency and alignment with user preferences and business requirements.
    Collaborated closely with the Product Manager and leadership board to align project objectives with strategic business goals.
    Played a pivotal role in architectural design sessions, contributing expertise in scalable cloud solutions and data integration strategies.
  • I used work Hadoop Table ,Impala and HVE update the table and create Tables , Insert, Delete etc
  • Worked on Smart forms and Sap Scripts
  • Module pool Programming
  • Participate in client meetings to understand project definitions and offer design reviews
  • We Use agile methodology for Project related issues and Monitor according to that
  • I used to slove according to that issues immediately
  • Expert in optimization and query performance tuning in Netezza using various techniques involving distribution analysis, data-type analysis, zonemaps, CBTs, configuration parameters etc
  • Expertise in working with different databases like Netezza, Teradata, MS
  • SQL Server 2008 R2, Oracle 10g/9i/8i and tools like Aginity, Toad, SQL
  • Navigator, Teradata SQL Assistant
  • I am working on opens workbook in Tableau Desktop 10.7, refreshes the
  • Tde extract, publishes to Tableau Server 10.7
  • Working on Tableau Desktop 10.7 and Tableau Server 10.7 can read
  • Tde and
  • Hyper extracts, so you can open and view workbooks with extracts in either format
  • Such as stored procedures and views
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction
  • Provide database coding to support business applications using Sybase T-SQL
  • Perform quality assurance and testing of SQL server environment
  • Develop new processes to facilitate import and normalization, including data file for counterparties
  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options
  • Used Tableau Cmd for various Dashboard migrations from one environment to another
  • Setup of Distributed Server environments for optimum load balancing
  • Experienced in developing applications using Agile Methodologies and Scrum stories in a python-based environment
  • Knowledge in Model View Controller (MVC) frameworks
  • Installed various packages in python using pip and easy install
  • Experience in using LAMP (Linux, Apache, MySQL, and Python) Architectures
  • Engineer datasets using Alteryx, SQL, or scripting languages
  • Skill with Microsoft Excel
  • Previous Analytics experience using SQLlike Gitlab
  • Having knowledge on deploying applications by using Jenkins that provides Continuous Integration and Continuous Deployment
  • Design and maintain databases using Python and developed Python-based API (RESTful Web Service) using Django models and PostgreSQL
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
  • Creating New Schedule's and checking the task's daily on the server
  • Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

Sr. Data Analyst/Tableau \ AWS Services

Lincoln Financial Mortgage
Radnor, PA
11.2016 - 12.2017

· Spearheaded the migration of legacy Tableau reports to AWS Cloud, enhancing data accessibility and system performance.

· Orchestrated the transition of critical business reports from AWS Big Site to Tableau Cloud, ensuring seamless integration and minimal downtime.

· Collaborated closely with the Product Manager and leadership board to align project objectives with strategic business goals.

· Played a pivotal role in architectural design sessions, contributing expertise in scalable cloud solutions and data integration strategies.

· Utilized the Tableau Content Migration Tool for efficient content transfer, maintaining data integrity and report functionality.

· Led multiple projects leveraging AWS services, including Lambda, Athena, DynamoDB, S3, and Redshift, to optimize data storage and retrieval processes.

· Implemented AWS Glue for streamlined data management and transformation, significantly reducing manual data handling.

· Developed and maintained PostgreSQL and Snowflake databases, ensuring robust data architecture and support for analytics.

As a Business Objects and Tableau Developer at Lincoln Financial Group, I am proficient in creating database objects such as tables, views, procedures, triggers, and functions. My expertise in T-SQL allows me to provide definition, structure, and maintain data efficiently while creating Oracle SQLs, PL/SQL procedures, and queries. I am skilled in writing complex queries, using MS Excel for executing comparisons,

My experience with Tableau server involves building, publishing customized interactive reports and dashboards, and report scheduling. I have conducted extensive GAP analysis in projects and am adept at designing, building, and running Tableau dashboards. I have assisted business analysts in gathering requirements and in the design and development of ETL processes.
I have validated schemas, identified errors present in ETL, and participated in providing recommendations to fix problems. I am proficient in writing stored procedures in Netezza and converting cursor-based PL/SQL procs into set-based nzsql procs. My hands-on and extensive working experience in ETL processes using Informatica
I am experienced in creating dashboards, action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau. My expertise extends to Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Informatica. I am adept at restricting data for particular users using Row-level security and User filters and have developed Tableau visualizations and dashboards using Tableau Desktop & Tableau Support.

Tableau Admin, Comcast
, PA
03.2016 - 10.2016
  • Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards
  • Setup and configuration of Tableau server 9.3 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices
  • Hands on experience with Tableau 10.0
  • Used the multiple data sources joins in Tableau 10.0
  • Build from the ground up reliable infrastructure services in AWS to deliver highly scalable services
  • Configure the VPC, EC2 instances, S3 buckets, RDS (MySQL)
  • Configuration of AWS in built SNS/SQS setup for job scheduling
  • Create required shell or python scripts for data push from Tableau/Teradata to S3
  • Provide the user access to team for AWS console and SSH connectivity to the Edgenode
  • Used Tableau to provide the standard user interfaces for visualizing and filtering date/time data, and Hive will construct the Map/Reduce jobs necessary to parse the string data as date/time to satisfy the queries Tableau generates
  • Used Hive to have native support for date/time as a data type, but it does have very rich support for operating on date/time data stored within strings, changed the data type of a string field to Date or Date/Time to work with pure date or date/time data stored in strings
  • Worked with Microsoft Power BI for visualizing and filtering date/time data, and Hive will construct the Map/Reduce jobs necessary to parse the string data as date/time to satisfy the queries Tableau generates
  • Used Hive and Hadoop configuration variables for a given connection from Tableau to tune performance characteristics
  • Used additional UDFs which Tableau does not yet expose as formulas for use in calculated fields in HIVE
  • Used Tableau "Pass Through" functions for using UDFs, UDAFs (for aggregation) and arbitrary SQL expressions in the SELECT list
  • Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level
  • Published Tableau dashboard on Tableau Server and embedded them into portal
  • Setup trusted authentication in Tableau server and pass requests from Web server
  • Worked heavily using Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups and Users
  • Microstrategy DSS Agent create cache table on schedule
  • Created External filter, internal filter and Context filter to improve performance
  • Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives
  • Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations
  • Used dimension on Page shelf for a detailed analysis of the view by members of the dimension
  • Created parameters and quick filters
  • Created sets to display top products based on their sale
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views
  • Created Dashboards with interactive views, trends and drill downs
  • Published Workbooks and Dashboards to the Tableau server
  • Designed and setup user security for the entire landscape to facilitate Windows AD login
  • Used Tableau Cmd for various Dashboard migrations from one environment to another
  • Setup of Distributed Server environments for optimum load balancing
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
  • Creating New Schedule's and checking the task's daily on the server
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Tableau Admin

Kimberly Clark
Charlotte, NC
10.2015 - 03.2016
  • Upgraded tableau 7.0 to tableau 8.0
  • And gathered requirements, analyzed from raw data
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel
  • Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon
  • Involved in created stored procedures, views, and custom sql queries to import data from sql server to tableau
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
  • Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards
  • Working on generating various dashboards in Tableau server using various sources such as Teradata Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc
  • In Data flows
  • Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard
  • Created mockup dashboards and presented to the higher level end users to have them a look and feel of the dashboards
  • Develop and maintain reporting and analytical tools, including Business Objects
  • Developed mappings to support incremental loading
  • Used change data capture (CDC) tables as source tables for incremental
  • Lead BI work stream projects in the implementation and use of new BI software tools and systems
  • Got involved in designing the Data model for the Data warehouse and for different Data marts
  • Performed End to end testing using SQL Queries in Oracle

Tableau Developer

NC dot
Raleigh, NC
05.2015 - 09.2015
  • Deep experience with the design and development of Tableau visualization solutions
  • Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop
  • Importing data from HDFS to Hive using Sqoop The connector then gets the closing price for the specified company for one year back from today's date
  • Created External filter, internal filter and Context filter to improve performance
  • Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives
  • Used data connectors that are already available in Tableau, to create web data connector (WDC) that reads data from virtually any site that publishes data in JSON, XML, or HTML
  • Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations
  • Configuring and creating reports based of Hive
  • Big Data Ecosystems: HDFS, MapReduce, Hive, Pig, Sqoop
  • Used the Web Data Connector JavaScript library for enabling the app to interface with the Tableau API
  • Used dimension on Page shelf for a detailed analysis of the view by members of the dimension
  • Created parameters and quick filters
  • Created sets to display top products based on their sale
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views
  • Created Dashboards with interactive views, trends and drill downs
  • Published Workbooks and Dashboards to the Tableau server
  • Combined visualizations into Interactive Dashboards and publish them to the web
  • Created groups and users in Tableau server
  • Used commands in Tab cmd
  • And Tab admin utility tool and migrated Workbooks and Dashboards
  • Environment: Oracle 11g, Python, Chef, Puppet, Kickstart, Cron, Perl, Tableau Desktop 8.2, Tableau server, Oracle SQL developer, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL,MS Access, Windows 2007 server, Teradata, MS Office 2007

Data analyst

Intergraph
Hyderabad, India
10.2010 - 11.2013
  • Installed and configured Oracle 10g/11g RAC databases as per company standards
  • Installation, Configuration, upgradation and administration of Sun Solaris, Linux
  • Implemented and managed Oracle 10g RAC and 11g RAC databases on UNIX, LINUX and Windows platforms
  • Manipulating, cleansing & processing data using Excel, Access and SQL
  • Responsible for loading, extracting and validation of client data
  • Liaising with end-users and 3rd party suppliers
  • Analyzing raw data, drawing conclusions & developing recommendations Writing T-SQL scripts to manipulate data for data loads and extracts
  • Developing data analytical databases from complex financial source data
  • Performing daily system checks
  • Data entry, data auditing, creating data reports & monitoring all data for accuracy
  • Designing, developing and implementing new functionality
  • Monitoring the automated loading processes
  • Advising on the suitability of methodologies and suggesting improvements
  • Carrying out specified data processing and statistical techniques
  • Supplying qualitative and quantitative data to colleagues & clients
  • Using Informatica & SAS to extract, transform & load source data from transaction systems.

System Administrator

Aditya Birla Group
Hyderabad, India
08.2009 - 09.2010
  • Maintained History of all the repositories using Subversion
  • Used Clear case (Base) as version control to store source code
  • Helped developers to resolve subversion code merging issues
  • Involved in creating new elements in vobs
  • Responsible for designing and deploying best SCM processes and procedures
  • Used ANT as build automation tool for Java based projects
  • Build and release software baselines, code merges, branch and label creation and interfaced between development and infrastructure
  • Good Quality release notes
  • Implemented sustainable branching models for organizations
  • Performed regular builds and deployment of the packages for testing in different Environments
  • Production Support & Systems engineering duties related to Red hat system administration DNS, DHCP, NFS, NIS, LDAP, user account maintenance, backup & recovery, Auto-mounting, License Management, Printer configuration
  • Following up with the Test Team & Development Team to resolve the build issue
  • Documented the policies and procedures for branching, labeling, code merging, checkin/check-out, and builds
  • Deployed artifacts to WebSphere application servers
  • Installing and configuring Apache Tomcat and supporting them on Linuxproduction servers
  • Troubleshooting the network issues and response problems
  • Installation and configuration of Logical volume manager-LVM and Netbackup
  • Experience with Nagios Network management and System monitoring tool
  • Documentation of all the setup procedures and System Related Policies (SOP's)
  • Experience in configuring DNS, NFS, NTP, FTP on Linux servers
  • Worked in the Java development team, assisting in coding using core java programming and MS SQL Server.

Education

Master of Science -

Wilmington University – IT
Wilmington, DE
01-2016

Master of Science - Information Technology

Punjab Technology University
India
01.2009

Bachelor of Science - Computer Science

JNTU
Hyderabad
01.2007

AWS certified Sysops Administration (AWS-ASOA-5601) AWS Certified Solutions Architect – Associate Tableau Certified Trained in CCNA, CCNP and MCSE Trained in Power Bi, Alteryx, Splunk -

Skills

  • Python Programming
  • NoSQL Databases
  • Data Visualization
  • BI tools expertise
  • AWS QuickSight
  • Tablea Desktop
  • Tableau Online
  • Tableau Server
  • AWS Redshift
  • Aws Services
  • S3, DynamoDB , NOSQL
  • Lamda
  • RDS
  • Power BI

Accomplishments

  • Strong SQL skills mandatory reporting
  • Performance turning
  • JIRA
  • Used SAML for configuration of Tableau Server SSO supplementing Kerberos authentication on the side
  • Used Kerberos for user authentication thru Active directory (Win AD)
  • Used Sign in Method using the REST API for successful sign in operations
  • Setup of SSO between Tableau portal and Oracle
  • Used Kerberos for user authentication thru Active directory (Win AD)
  • Performance tuning for the Tableau Visualizations and Tableau server for more than 150 concurrent users
  • Improved Reports performance in tableau using extracts and context filters
  • Published Workbooks by creating User filters and sites (User groups, access) so that only appropriate teams can view it
  • Created calculated fields to interact with parameters dynamically to visualize the data on the fly.

Additional Information

  • Involved Tableau and AWS Quick sight developer is involved in the full technology life cycle and responsible for reports designing, coding, automating, configuring, testing, implementing, and supporting. Will work closely with Technical Architects, Data Engineer and Data Analysts and to understand the business requirements Expertise in Tableau 2024,2023,.2.7/2020.2.4/2019.4/10.2/Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Cloud Worked on different Tableau versions (Tableau 2024,2023,2022,2021,2019 9.3/9.2/9.1/8.0/7.0) Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices Setup and configuration of Tableau server 10.0/9.2 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices. Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices Used ETL process to Extract, Transform and Load the data into stage area and data warehouse. Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.

Certification

  • AWS Architect Associate
  • Tableau Desktop Specialist
  • Tableau Server Data Analyst
  • Power Bi Data Analyst
  • SQL certified

Timeline

Sr. BI Analyst | Aws Quicksight | Tableau

Salesforce
09.2023 - Current

Sr, Data Science Analyst | AWS | Tableau

Wisconsin Department of Health Services
10.2020 - 08.2023

Senior Data Analyst | AWS Services|Tableau

WellCare Health Plans
03.2019 - 09.2020

Business Analyst/Tableau, Data Transformation

Fannie Mae
11.2018 - 02.2019

Sr. Data Analyst III/AWS QuickSight | Redshift

Capital One
01.2018 - 10.2018

Sr. Data Analyst/Tableau \ AWS Services

Lincoln Financial Mortgage
11.2016 - 12.2017

Tableau Admin, Comcast
03.2016 - 10.2016

Tableau Admin

Kimberly Clark
10.2015 - 03.2016

Tableau Developer

NC dot
05.2015 - 09.2015

Data analyst

Intergraph
10.2010 - 11.2013

System Administrator

Aditya Birla Group
08.2009 - 09.2010

Master of Science -

Wilmington University – IT

Master of Science - Information Technology

Punjab Technology University

Bachelor of Science - Computer Science

JNTU

AWS certified Sysops Administration (AWS-ASOA-5601) AWS Certified Solutions Architect – Associate Tableau Certified Trained in CCNA, CCNP and MCSE Trained in Power Bi, Alteryx, Splunk -

Srikanth Cheguri