Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Venkata Laxmana Srikanth Bharam

Arlington,TX

Summary

Detail-oriented Data Informatics Analyst with experience in data visualization, analytics, and business intelligence. Proficient in Power BI, SQL, Python, and cloud technologies (AWS, Snowflake) with a strong understanding of data warehousing and ETL processes. Adept at transforming raw data into meaningful insights to drive data-driven decision-making. Passionate about leveraging AI to optimize analytics workflows.

Overview

7
7
years of professional experience
1
1
Certification

Work History

TECHNICAL ASSISTANT

Government of Andhra Pradesh
Razole, India
10.2019 - 12.2022
  • Developed and automated dashboards using Tableau to provide actionable insights into key performance metrics, improving decision-making efficiency by 30%
  • Automated ETL workflows using Alteryx, streamlining data preparation and blending from multiple sources, reducing processing time by 40% and enhancing data accuracy for reporting in Power BI
  • Cleaned, transformed, and analyzed large datasets using Excel (Pivot Tables, Power Query) and SQL, ensuring 98% accuracy and consistency in reporting
  • Managed defect tracking and resolution workflows using Jira, improving the resolution rate by 25% and reducing average defect turnaround time by 15%
  • Streamlined data preparation by leveraging Power Query to clean, transform, and merge datasets from multiple sources (SQL, Excel, APIs)
  • Improved data refresh times by 40% and enhanced report efficiency for stakeholders
  • Collaborated with cross-functional teams to deliver detailed reports and presentations in Word and PowerPoint, supporting data-driven policy decisions that improved operational outcomes by 20%
  • Performed statistical analysis to identify trends and patterns, using tools like Python Streamlined data analysis processes, reducing manual effort by 10 hours per week through advanced Excel macros and automated scripts

SYSTEMS ENGINEER

TATA CONSULTANCY SERVICES LTD
Chennai, India
09.2015 - 09.2017
  • ETL developer for a USA-based commercial insurance company, using Informatica PowerCenter 9.0 for 10+ data transformations (both active and passive like filter, router, joiner, sorter, rank, expression, lookup) and cleansing
  • Ensured accurate, error-free data through debugging with MySQL and Oracle DB with 100% quality assurance
  • Championed the integration of SVM for version control, streamlining the workflow for 10+ developers, which improved coding efficiency, reduced merger conflicts by 30%, and minimized downtime during updates
  • Designed 100+ SQL queries for table joins, extracting business insights based on customer requirements
  • Led Guidewire functional testing for a USA-based insurance company, creating 100+ test cases
  • Executed nearly 100 test cases and delivered daily defect reports to stakeholders
  • Collaborated with agile teams across the USA and India to ensure timely issue resolution by participating nearly 30 iterations

Education

Master of Science - Information Systems

University of Texas At Arlington
USA
12-2024

Bachelor’s of Technology - Electronics & Communication Engineering

GITAM University
Visakhapatnam, India
04-2015

Skills

  • Languages: C, C, Python (Data Analysis), C#, SQL
  • Database: SQL Server, MS Access, MySQL, Oracle DB
  • Data Visualization: MS Power BI, Tableau
  • Machine Learning: Linear & Logistic Regression, Random Forest, KNN, Keras, Convolutional Neural Networks
  • Data Warehousing: Alteryx, Informatica PowerCenter
  • Big Data Technologies: Hadoop, Spark
  • Microsoft Excel: Data Analysis, Advanced Excel (Pivot Tables, VLOOKUP, Macros, Data Reconciliation)
  • Methodologies: Agile
  • Web Technologies: HTML, CSS, ASPNET
  • Project Management: Jira, Microsoft Project, SAP
  • Cloud Computing: Amazon Web Services (AWS)

Certification

  • Informatica tutorial: From Beginner to expert level, Udemy
  • Tableau 2020 A-Z: Hands-on Tableau Training for Data Science, Udemy
  • Python for Data Visualization: Matplotlib and Seaborn, Coursera
  • Graduate Certification in Business Analytics, University of Texas at Arlington
  • SQL – Basic, Hacker Rank

Timeline

TECHNICAL ASSISTANT

Government of Andhra Pradesh
10.2019 - 12.2022

SYSTEMS ENGINEER

TATA CONSULTANCY SERVICES LTD
09.2015 - 09.2017

Master of Science - Information Systems

University of Texas At Arlington

Bachelor’s of Technology - Electronics & Communication Engineering

GITAM University
Venkata Laxmana Srikanth Bharam