Data Analyst Business Intelligence

Triveni Ganta

Data Analyst

Minneapolis, MN ***46 612-***-**** *********@*****.***

Professional summary

Results-driven Data Analyst with 4+ years of experience delivering actionable insights and business intelligence solutions across Healthcare, Retail, and financial domains. Proven expertise in Teradata, SQL, Python, Tableau, and Hadoop to design scalable data solutions, optimize query performance, and automate complex reporting processes. Skilled at developing interactive dashboards, predictive analytics models, and automated ETL pipelines, reducing manual effort by up to 70% and accelerating decision-making. Adept at partnering with cross-functional teams in Agile environments to deliver projects on time and exceed stakeholder expectations. Strong background in data validation, warehousing, and financial data mining, with a master’s in information technology and a track record of improving data accuracy, efficiency, and cost savings.

Skills

ETL & Big Data: Informatica 9.1/8.6/7.1.2 SSIS, Data Stage 8.x, Hadoop, Hive

GUI Reporting Tools: Business Objects6.5, Brio, Hyperion, Tableau, Unica Affinium Campaign

Data Modeling: Star-Schema, Snowflake-Schema, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

RDBMS: Oracle 11g/10g/9i/8i/7.x, MS SQL Server, UDB DB2 9.x, Teradata V2R6/R12/R13, R14, MS Access 7.0

Programming: SQL, PL/SQL, UNIX Shell Scripting, VB Script, Python

Environment: Windows (95, 98, 2000, NT, XP), UNIX

Other Tools: TOAD, AWS, MS-Office suite (Word, Excel, Project and Outlook), BTEQ, Teradata V2R6/R12/R13 SQL Assistant

PROFESSIONAL EXPERIENCE

Data Analyst, 03/2024 - Current

BCBS

Optimized large-scale Teradata SQL queries using RANK functions, reducing data retrieval time by 40%, and accelerating report delivery for business stakeholders.

Worked on numerous ad-hoc data pulls for business analysis and monitoring by writing SQL scripts.

Automated batch processing with BTEQ and Unix cron jobs, cutting manual intervention by 50%, and ensuring timely monthly and quarterly reporting.

Designed interactive Tableau dashboards used by senior leadership to track KPIs, improving decision-making speed by 30%.

Implemented dual data validation processes that improved report accuracy to 99.9%, ensuring compliance with regulatory standards.

Developed Python scripts to integrate multi-source Teradata data into CSVs, streamlining data preparation for analysis, and saving 20+ hours per month.

Created reports and charts by querying data using Hive Query Language, and reported the gaps in lake data loaded.

Developed Teradata SQL scripts using RANK functions to improve the query performance while pulling the data from large tables.

Experience in performing dual data validation on various business-critical reports while working with another analyst.

Supported agile best practices, contributing to process improvements, and team efficiency.

Data Analyst, 03/2023 - 02/2024

Walmart

Built Python-based ETL pipelines to consolidate large datasets into Teradata, reducing manual data preparation efforts by 70%.

Automated archival of oversized Teradata tables into mainframes, optimizing database storage, and saving 15% in storage costs.

Developed programs that manipulate arrays using libraries like NumPy and Python.

Enhanced business intelligence by creating pivot-based Excel reports and PowerPoint visuals, enabling leadership to identify key retail performance trends.

Leveraged advanced Teradata SQL techniques (RANK, ROW_NUMBER, OLAP functions) to deliver faster, more insightful ad-hoc analyses.

Developed reusable Korn shell scripts for job automation, reducing recurring manual work by over 25 hours weekly.

Generated reports using Proc Tab, Proc Report, Data Null, Proc SQL, and Macros. Used OLAP functions like sum, count, csum, etc.

Junior Data Analyst, 08/2021 - 11/2022

Atos

Created high-performance Teradata volatile and multiset tables, reducing query runtime for business reports by 35%.

Communicated with business users and analysts about business requirements. Gathered and documented technical and business metadata about the data.

Deployed Tableau dashboards with role-based security, ensuring tailored data access for over 150 users across organizational levels.

Partnered with cross-functional Agile teams to deliver 100% of sprint deliverables on time, improving overall sprint velocity by 20%.

Worked on numerous ad-hoc data pulls for business analysis and monitoring by writing SQL scripts.

Applied Python, NumPy, for advanced data manipulation, reducing the processing time of large datasets by 60%.

Standardized SQL data pull templates reduce duplicate work and improve analyst efficiency across the team.

Created set, multiset, derived, volatile, and global temporary tables to retrieve the data from multiple tables.

Education

Master of Science: Information Technology in Management, 05/2024

University of Concordia St Paul - St Paul, MN

GPA: 3.84/4.0

Bachelor of Science: Information Technology Engineering, 04/2022

Mallineni Lakshmaiah Women's Engineering College - Guntur

GPA: 3.4/4.0

#HRJ#c3e98e85-9070-431d-b3cd-f454efaf4ab3#

Contact this candidate