Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Tejas Tirupathi

Hyderabad

Summary

Experienced professional with a strong background in technology-related roles. Proficient in software development, system administration, and technical support. Skilled in problem-solving and optimizing performance. Capable of managing projects and collaborating effectively with teams. Committed to continuous learning and staying current with industry trends to contribute to organizational success with Years of IT experience in IT field as Business Intelligence Developer using Power BI, Tableau, PL/SQL,SQL DBA, Linux/UNIX Monitoring, Data Analytics performance, tuning, Troubleshooting and Maintenance of Database.

Overview

2026
2026
years of professional experience

Work History

Data Analyst

HS Tecnologies Inc
Plano
04.2022 - 04.2025
  • Proficient in making DAX queries in Power BI Desktop.
  • Designed and documented the entire architecture of the Power BI POC, and I have expertise in writing complex DAX functions in Power BI and Power Pivot.
  • Automated Power Query refresh using PowerShell script and Windows Task Scheduler, and used various sources to pull data into Power BI, such as SQL Server, SAP BW, and Oracle.
  • I installed and configured the Enterprise gateway and the Personal gateway in the Power BI service.
  • Participated in project planning sessions with project managers, business analysts, and team members to analyze business requirements and outline the proposed solution.
  • Database creation (DDL, DML, DCL), database tuning, SQL tuning, and performance planning.
  • Transformed complex business logic into database design and maintained it by using SQL objects like stored procedures, user-defined functions, views, T-SQL scripting, and jobs.
  • Creating and modifying tables, stored procedures, views, indexes, user-defined functions, and triggers as required.
  • Creating data blending in the case of merging two different datasets using Tableau, and developing Excel Power View, Power Query, and PowerPivot dashboards for data analysis.
  • Performed index analysis for tables and came up with more efficient solutions to use clustered and non-clustered indexes for a significant performance boost using the index tuning wizard.
  • Designed SSIS packages to import and transform data between databases and external data sources using various transformations, like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, and Data flow task.
  • Designed and created data extracts using Access, Excel, XML, OLE DB Source, and Flat Files, while supporting SSRS, Tableau, or other visualization tools for reporting applications.
  • Debugging SSIS packages, and performance tuning on slowly running SSIS packages.
  • Using SQL Server Reporting Services (SSRS), delivering enterprise, web-enabled reporting, so create reports that draw content from a variety of data sources.
  • Assisted with efforts to track, evaluate and report on impact of programs using multiple data sources.
  • Generated reports and obtained data to develop analytics on key performance and operational metrics.

Systems Analyst

Spry Info Solutions
Atlanta
10.2016 - 12.2018
  • Analyzed large datasets to identify trends, patterns and correlations utilizing advanced analytics techniques in Tableau.
  • Managed the entire life cycle of projects from design and development through implementation and maintenance.
  • Participated in design reviews to provide input on functional requirements, product designs, schedules, or potential problems.
  • Integrated various external APIs with Tableau to enable real-time streaming of live data sets.
  • Implemented best practices for optimizing the performance of Tableau reports and dashboards.
  • Assisted in designing and developing ETL processes to extract data from multiple sources into a single repository for analysis in Tableau.
  • Researched new ways to visualize data in Tableau for enhanced presentation of results.
  • Provided technical support on existing dashboards and reports by troubleshooting issues related to data accuracy or report functionality.
  • Worked closely with BI teams to ensure that the right data is being extracted from source systems into the Data Warehouse layer for reporting purposes.
  • Authored and maintained supporting documentation to optimize accessibility and implement compliance with developing best practice and company standards.
  • Manipulated Tableau parameter controls, hierarchies and filters to achieve LOD expressions and geospatial design configurations leveraging multiple data joins for comprehensive analysis.
  • Recommended improvements to facilitate team and project workflow.
  • Worked extensively with lookup transformations for implementing inserts and updates.
  • Created ETL packages to validate, extract, transform, and load the data to data warehouse databases using SSIS.
  • Created Power BI dashboards (Power View, Power Query, Power Pivot, Power Maps) and integrated them into SharePoint.
  • DAX operations were used to create custom calculations in Power Pivot for Microsoft Excel workbooks, and Analysis Services Tabular data warehousing.
  • Set up Splunk dashboards for continuous monitoring for production support.
  • Played a major role in understanding the logs, server data, and brought insight into the data for the users.
  • Integrated Splunk with ServiceNow to create automatic incidents based on the alert.
  • Helped in maintaining the Splunk instance and monitoring the health of the cluster.
  • Continuous monitoring of the alerts received through emails to check if all the application servers and web servers are up.

Business Analyst

Vertucom Inc
Coppell
  • Identify requirements, design, create, deploy, monitor, and support Power BI reports and dashboards, shared objects, and cubes to empower discovery and information sharing for business users.
  • Involved as a Power BI Developer in capturing, analyzing, and monitoring front-end and middleware applications, and worked with client engagements, data onboarding, and writing alerts and dashboards using DAX.
  • Can understand configuration dependencies and interrelationships between Cognos and other data warehouse, business intelligence tools, and designs; troubleshooting in the area with this knowledge.
  • Installed Splunk Forwarders on all servers and configured them with common configuration files, such as Outputs.conf and Inputs.conf, including creating and managing apps, creating a user, role, and permissions to knowledge objects.
  • Involved in standardizing Splunk forwarder deployment, configuration, and maintenance across UNIX and Windows platforms, and providing regular support guidance to Splunk project teams on the complex solution and issue resolution, with the objective of ensuring the best fit and high quality.
  • Worked extensively with lookup transformations for implementing inserts and updates.
  • Onboard new log sources with log analysis. Analyzed large datasets to identify metrics, drivers, performance gaps, and opportunities for improvement.
  • Worked on setting up Splunk to capture and analyze data from various layers, including load balancers, web servers, and application servers.
  • Splunk administration in environments like Windows Servers, Red Hat Linux Enterprise Servers.
  • Worked with IBM Rational ClearCase, ClearQuest, and BuildForge applications to capture the logs and monitor them.
  • Used DAX operations that were used to create custom calculations in Power Pivot for Microsoft Excel workbooks, and Analysis Services Tabular data warehousing.
  • Implemented complex SQL queries and stored procedures to create reports using SSRS from the relational database.
  • Identified gaps between current state and desired future state operations.
  • Facilitated brainstorming sessions with cross-functional teams for problem solving activities.

Education

Master of Science - Computer Engineering

Southern Illinois University
Carbondale , Illinois
12-2015

Skills

  • Proficient in DAX queries
  • ETL workflow management
  • Power BI development
  • Project management
  • Data visualization
  • Data analysis
  • Task prioritization
  • Data organization and maintenance
  • Collaborative teamwork
  • Technical documentation

References

References available upon request.

Timeline

Data Analyst

HS Tecnologies Inc
04.2022 - 04.2025

Systems Analyst

Spry Info Solutions
10.2016 - 12.2018

Business Analyst

Vertucom Inc

Master of Science - Computer Engineering

Southern Illinois University

Similar Profiles

  • Frederick Pickering

    Frederick PickeringFrederick Pickering

    Teacher for a Marine Corps JROTC at Kelly Walsh HS., Northridge HS, Kellogg HS.Teacher for a Marine Corps JROTC at Kelly Walsh HS., Northridge HS, Kellogg HS.

  • CHENXI WU

    CHENXI WUCHENXI WU

    Relief Teacher at Department of Education NSW – Bankstown Girls HS & Strathfield South HSRelief Teacher at Department of Education NSW – Bankstown Girls HS & Strathfield South HS

  • C. Devon Pyper

    C. Devon PyperC. Devon Pyper

    French Teacher at Peninsula HS & Gig Harbor HSFrench Teacher at Peninsula HS & Gig Harbor HS

  • Suresh Bhumireddy

    Suresh BhumireddySuresh Bhumireddy

    Technical Specialist at Bosch Global Software TechnologiesTechnical Specialist at Bosch Global Software Technologies

  • Sameer Telikicherla

    Sameer TelikicherlaSameer Telikicherla

    PAM Consultant at Capgemini India Pvt Ltd.PAM Consultant at Capgemini India Pvt Ltd.

CREATE PROFILE
Tejas Tirupathi