saiteja vajrapu

Location

Texas City, TX
Dallas, TX
Education
    Wichita State University
    August 2022 - April 2024
    degree
    Master's
    major
    Computer Science
    Vellore Institute of Technology
Work Experience
    Invision Global tech TX Data Analyst
    July 2023 - present
    title
    Invision Global tech TX Data Analyst
    overview
    - Utilized Python (Pandas) and Databricks for gathering and preprocessing large ERP - Leveraged AWS services for data storage and advanced analytics, increasing data - Developed and optimized data pipelines using Azure Data Factory, AWS Glue, and Apache Spark, reducing processing time by 50 - Implemented and optimized Snowflake data warehouse, including designing data - Created interactive visualizations in Tableau (geo maps, Gantt charts, Pareto charts, scatter plots) and integrated with AWS QuickSight, improving decision-making by 15 - Built 85% custom Microsoft Power BI dashboards and integrated with SSRS, Databricks, and AWS Redshift to deliver actionable insights - Managed ETL processes with Apache Kafka, SSIS, and AWS Lambda for seamless data - Optimized data transfer using Apache Hadoop and Spark, reducing transfer time by 20% and centralizing data in PostgreSQL - Designed and deployed Tableau reports with drill-down, drill-through, and parameterized - Conducted root cause analysis using Databricks and AWS Athena, reducing operational
    Accenture
    Associate software engineer
    IN
    June 2021 - July 2022
Skills
Languages
EnglishTamil
Skills
A/B TestingAgile MethodologyAirflowAmazon RedshiftAmazon S3Amazon Web ServicesAnalytical ThinkingApache HadoopApache HTTP ServerApache KafkaApache SparkAutomationAWS GlueAWS LambdaAzure Data FactoryBusiness ModelCloud ComputingCluster AnalysisCollaborative SoftwareCommunication SkillsConfluenceDashboardsData AnalysisData ArchitectureDatabasesDatabricksData CleansingData IntegrationData MiningData ModelingData PipelinesData ProcessingData QualityData Storage TechnologiesData TransmissionsData WarehousingDecision Making SkillsDrilldownDrilling OperationsEnterprise Resource PlanningEr-WinExtract Transform Load (ETL)Forecasting SkillsFront End Software DevelopmentGantt ChartsGithubInformation TechnologyInVisionJIRAKnowledge of FinanceKnowledge of StatisticsLinear AlgebraLinuxMachine LearningMarketingMatplotlibMetricsMicrosoft AccessMicrosoft AzureMicrosoft ExcelMicrosoft OfficeMicrosoft OutlookMicrosoft PowerPointMicrosoft ProjectMicrosoft SQL ServerMicrosoft Visual StudioMicrosoft WindowsMicrosoft WordModelling SkillsMongoDBMoulding MachinesMySQLNumPyOnline Analytical ProcessingOnline Transaction ProcessingOperational SystemsOracle ApplicationsPandasParametrizationPareto ChartPivot TablesPlotlyPL-SQLPostgreSQLPower BIPredictive Data AnalysisPredictive ModellingProject ManagementPython (Programming Language)Regression AnalysisRoot Cause AnalysisSAS (Software)Sas Visual AnalyticsScalabilityScikit LearnSciPyScrum MethodologyServer ApplicationsSnowflakeSoftware EngineeringSQL DatabasesSQL Server Integration ServicesSQL Server Reporting ServicesStakeholder ManagementStatistical Hypothesis TestingStock ControlSystems Development Life CycleTableau (Software)TalendTensorflowTeradata SQLTransact-SQLUnix ShellWorkflows