Summary
Overview
Work History
Education
Skills
Timeline
Generic

SAI TEJA SUGGUNA

Frisco,TX

Summary

Accomplished Data Analyst/ETL Developer with over 5 years of experience in database development, data analysis, and ETL processes. Expertise in SQL, PL/SQL, and data warehousing with a proven track record in implementing the full SDLC. Skilled in leveraging Informatica Power Center, Python, and Java for automation and proficient in data visualization tools like Tableau, Alteryx, and Power BI to derive meaningful insights. Complex problem-solver with analytical and driven mindset.

Overview

5
5
years of professional experience

Work History

Data Analyst

Medica
06.2023 - Current
  • Interacted with business users to understand the requirements for development.
  • Developed SQL queries and updated existing SQL queries according to business requirements.
  • Used SQL Queries to extract data from Legacy database and made necessary changes in data.
  • Generated SQL and PL/SQL scripts for Database design and development including Tables, Primary and Foreign Keys, Indexes and Stored Procedures.
  • Designed and developed various Informatica mappings using multiple different transformations like Expressions, Aggregator, External Procedures, joiner, router. Developed various Ad-hoc mappings.
  • Utilized Informatica Power Centre as an ETL Tool to fetch data from sources, apply transformations and load into target Tables.
  • Experience in using AWS Glue to implement ETL process.
  • Analyzed data from source(Legacy System) and destination(Present system) tables and involved in creating design document with Team members.
  • Involved in developing Data Modelling to create conceptual, logical, and physical modelling techniques using ERWIN.
  • I have slight experience with data reporting, data management, and data integration.
  • Developed program using Python scripting to split large size files into small chunks.
  • Created meaning insights using data visualization tools like Power BI & Tableau.
  • Actively participated in day-to-day Scrum meetings and responsible for updating status and submitting reports to Team Lead.

Junior Data Analyst

Wells Fargo
01.2022 - 05.2023
  • Configured facets modules such as Claims, Pharmacy, Membership and Group customer.
  • Worked closely with customers, vendors, business analysts and application development project teams to resolve information flow and content issues.
  • Designed and implemented SQL queries for report and validation of various lab data coming from different vendors on weekly and monthly basis.
  • Data mapping, logical data modeling, created class diagrams, ER diagrams and used SQL queries to filter data within the Oracle database.
  • Used Informatica to extract and transform data.
  • Utilized SDLC Methodology to configure and develop process, standards, and procedures.
  • Analyzed program needs and translated them into data warehousing and data mart requirements.
  • Prepared detailed reports and presentations using SQL.
  • Converted all business requirements into Teradata SQL scripts and developed monthly business reports.
  • Writing SQL queries for data analysis and data validation as per requirements and disseminated data through Microsoft Excel.
  • Worked with data architects to design the common customer view of information.
  • Involved in defining the source to target data mappings, business rules, business, and data definitions.
  • Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
  • Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team

SQL Developer

CGI
07.2019 - 07.2021
  • Used SQL queries to filter data within Oracle database.
  • Prepared detailed reports and presentations using SQL. Converted all business requirements into Teradata SQL scripts and developed monthly business reports.
  • Writing SQL queries for data analysis and data validation as per requirements and disseminated data through Microsoft Excel.
  • Used Import/Export Utilities of Oracle.
  • Participated in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and Power View, Power Pivot.
  • Participated in daily scrum calls to update progress regarding the project.

Student Trainee

Acuvate
01.2019 - 06.2019
  • Effectively applied theoretical concepts learned during academic coursework to real-world scenarios encountered during training program tenure.
  • Utilized critical thinking skills while analyzing complex data sets, resulting in valuable insights for project outcomes.
  • Enhanced training experience by incorporating hands-on activities and real-life examples.
  • Maintained accurate records of project progress, ensuring seamless transition between tasks for efficiency purposes.

Education

Bachelor of Technology - Computer Engineering Technology

DEVRY COLLEGE OF NEW YORK
MANHATTAN, NY

Master of Science - Computer Science

Wichita State University
Wichita, KS
05.2023

Skills

  • SQL, PL/SQL, T-SQL
  • Data Warehousing
  • Python, Java, HTML
  • Informatica Power centre
  • Tableau, Power BI, Alteryx
  • Oracle, MS Access
  • ERWIN, Power Designer, MS Visio
  • AWS

Timeline

Data Analyst

Medica
06.2023 - Current

Junior Data Analyst

Wells Fargo
01.2022 - 05.2023

SQL Developer

CGI
07.2019 - 07.2021

Student Trainee

Acuvate
01.2019 - 06.2019

Bachelor of Technology - Computer Engineering Technology

DEVRY COLLEGE OF NEW YORK

Master of Science - Computer Science

Wichita State University

Similar Profiles

CREATE PROFILE
SAI TEJA SUGGUNA