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
USA12-2024
Bachelor’s of Technology - Electronics & Communication Engineering
GITAM University
Visakhapatnam, India04-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
Similar Profiles
Sravani SuravarapuSravani Suravarapu
Women and Welfare Assistant at Government Of Andhra PradeshWomen and Welfare Assistant at Government Of Andhra Pradesh
DEEP ANVESH REVUDEEP ANVESH REVU
Panchayat Secretary (IT Administrator) at Government of Andhra PradeshPanchayat Secretary (IT Administrator) at Government of Andhra Pradesh
Gollu Raja Venkata Surya PraveenGollu Raja Venkata Surya Praveen
Digital Assistant (Gr-VI) at Panchayat Raj Department – Government of Andhra Pradesh, IndiaDigital Assistant (Gr-VI) at Panchayat Raj Department – Government of Andhra Pradesh, India