Tejaswini Nallamothu
Parker,CO
Overview
6
6
years of professional experience
Work History
Data Analyst
BitsolutionsUs
01.2023 - Current
- Conducted in-depth data analysis using Google BigQuery, writing complex SQL queries to extract and transform data, generating actionable insights that informed strategic decisions and enhanced overall operational efficiency
- Developed interactive dashboards and reports in Tableau, enhancing data accessibility for stakeholders and enabling real-time performance monitoring
- Performed statistical analyses using R identifying trends and patterns that informed strategic decision-making across departments
- Collaborated with cross-functional teams to design and implement ETL processes, integrating data from various databases and data structures to support comprehensive analysis, research, and evaluation within a centralized data warehouse
- Assisted in data collection and cleaning processes, ensuring high data quality and accuracy for further analysis
- Utilized SQL for querying databases and generating reports, leading to the identification of critical business insights that informed sales strategies
- Created visualizations in ggplot2 to communicate findings to non-technical stakeholders, improving understanding of complex data trends
- Supported machine learning model development in BigQuery ML, contributing to enhanced predictive capabilities
- Created SAS dataset from tables in Database using SAS/Access and Retrieved the Sales data from flat files, oracle database and converted to SAS datasets for Analysis using SAS/Stat procedures
- Wrote various queries using SAS/Base, SAS/SQL and SAS/Macro for creating reports according to the Users requirement
- Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access
- Automated data collection and reporting processes with R scripts, reducing manual reporting time by 30 hours per month
- Designed and implemented a custom R package for internal use, improving efficiency and standardization of data analysis across the organization
- Developed strong data governance practices, ensuring compliance with data privacy regulations and maintaining data integrity across all projects
- Utilized advanced Excel skills, including pivot tables, VLOOKUP, and macros, for data analysis and reporting tasks
- Demonstrated proficiency in data storytelling, effectively translating complex analyses into clear and compelling narratives for diverse audiences
Graduate Assistant
Eastern Kentucky University
08.2021 - 12.2022
- Collaborated with a professor to design and execute data-driven research studies, focusing on gathering, cleaning, and analyzing large datasets to derive actionable insights that informed academic research objectives
- Developed and maintained sophisticated data models using SQL and R, facilitating in-depth statistical analysis and predictive modeling that advanced the professor's research outcomes and academic publications
- Created impactful data visualizations using Tableau and Power BI, significantly enhancing the clarity and effectiveness of research presentations for academic conferences and journal submissions, leading to increased visibility and engagement
- Performed comprehensive compliance checks and data analyses for internal audits, playing a crucial role in bolstering data governance practices and enhancing risk management processes within the research department
- Contributed to the preparation of academic articles and presentations, leveraging data insights and tailored visualizations to support research conclusions and strengthen the overall narrative of the findings
- Led data literacy training sessions for undergraduate students, imparting best practices in data management, advanced analysis techniques, and visualization tools, which improved their analytical skills and understanding of data-driven research methods
Data Analyst
CGI Information Systems
05.2019 - 06.2021
- Utilized Python libraries such as NumPy, Matplotlib, Scikit-Learn, and SciPy to develop a suite of capacity planning reports, enhancing strategic planning and decision-making processes; graphical data presentations contributed to a 15% increase in forecasting accuracy
- Conducted extensive data profiling, mapping, and cleansing, ensuring high data quality and integrity, which resulted in a 20% improvement in analysis and reporting accuracy
- Utilized SQL for data extraction and manipulation, crafting complex queries to analyze large datasets, improve data accuracy, and streamline reporting processes
- Employed data modeling techniques (e.g., entity-relationship modeling, normalization) to optimize database structures, ensuring efficient data storage and retrieval
- Developed and maintained dashboards in Tableau and Power BI, integrating real-time data for enhanced visibility into key metrics and facilitating timely decision-making processes
- Collaborated with stakeholders to understand business requirements and develop problem statements; effectively gathered, analyzed, and validated data, creating insightful reports and dashboards in Excel and Tableau
- Conducted exploratory data analysis (EDA) using Python and R to uncover underlying patterns and anomalies in data, leading to improved understanding of business challenges
- Utilized version control (Git) to manage code bases and ensure reproducibility of analyses, facilitating collaboration in team projects and maintaining organized project workflows
- Integrated machine learning models into data analysis workflows, utilizing libraries such as TensorFlow and Keras to enhance predictive accuracy and derive advanced insights from datasets
- Conducted sentiment analysis on customer feedback using natural language processing (NLP) techniques, providing valuable insights into customer satisfaction and product improvements
- Implemented A/B testing methodologies to evaluate the impact of changes in business processes and marketing strategies, providing actionable insights based on quantitative data
Timeline
Data Analyst
BitsolutionsUs
01.2023 - Current
Graduate Assistant
Eastern Kentucky University
08.2021 - 12.2022
Data Analyst
CGI Information Systems
05.2019 - 06.2021
Similar Profiles
Landrie FlowerLandrie Flower
Senior Staff Accountant at The Tendit GroupSenior Staff Accountant at The Tendit Group
Hannah MillHannah Mill
Assistant Lacrosse Coach at University of Colorado at Colorado SpringsAssistant Lacrosse Coach at University of Colorado at Colorado Springs
Amanda SteinerAmanda Steiner
RN Care Coordinator (VN 2, Step 07) at VA Office Of Community Care (full-time Position)RN Care Coordinator (VN 2, Step 07) at VA Office Of Community Care (full-time Position)
Natalie KrausNatalie Kraus
Head of New Market Implementation and Operations at Guaranteed HealthHead of New Market Implementation and Operations at Guaranteed Health
Manoj Singh RawatManoj Singh Rawat
Data Analyst/Data Migration Analyst at Sopra SteriaData Analyst/Data Migration Analyst at Sopra Steria