Sri Sai Sruthi Pampana
Orlando,FL
Summary
Data Analyst with over4 years of experience specializing in data integration, visualization, and reporting using tools like Power BI, Tableau, SQL, and Python. Expertise in extracting, cleaning, and analyzing data from systems like SAP S/4HANA, Oracle, SQL Server, and MongoDB to deliver actionable insights and improve decision-making processes. Skilled in developing automated ETL pipelines using Informatica and Python, building DAX-driven Power BI dashboards, and conducting statistical analysis for business intelligence solutions. Experienced in Agile methodologies, utilizing JIRA and Confluence to manage workflows, collaborate with cross-functional teams, and deliver high-quality data solutions on time.
Overview
5
5
years of professional experience
Work History
Data Analyst
New Wave Telecom and Technologies Inc
01.2023 - Current
- Integrated data from multiple sources, including SAP S/4HANA, SAP CRM, SQL Server, Oracle, MongoDB, and AWS, streamlining data aggregation for comprehensive analysis
- Designed and implemented automated ETL pipelines using Informatica PowerCenter and Python, reducing report generation time by40%
- Created dynamic Power BI dashboards utilizing DAX formulas to analyze financial KPIs and operational metrics across sales, finance, and inventory departments
- Conducted A/B testing to evaluate marketing campaigns, leading to a15% increase in conversion rates and a10% boost in revenue
- Optimized Power BI report performance using DAX Studio, reducing report load times by30%
- Built scalable data models (Star and Snowflake Schemas) to improve data warehousing and reporting efficiency
- Automated data validation processes using Python, Power BI, and Excel, reducing manual effort by60%
- Led User Acceptance Testing (UAT) for dashboards, ensuring accuracy and functionality before deployment
- Collaborated with stakeholders in Agile sprint cycles, defining user stories, prioritizing tasks, and ensuring timely delivery
- Environment: SAP S/4HANA, SAP CRM, Power BI, DAX, Informatica PowerCenter, SQL Server, Oracle, AWS, MongoDB, JIRA, Confluence, Python, Excel
Data Analyst
MSR Technologies
08.2021 - 07.2022
- Extracted and merged healthcare data from systems like Epic and Cerner into Oracle databases, ensuring accuracy and consistency for analysis
- Developed and maintained data pipelines for continuous data updates, improving EHR system reliability
- Utilized SQL and Python for data cleansing and transformation, addressing issues like missing values and duplicates
- Built interactive Tableau dashboards visualizing healthcare metrics such as patient admissions and lab result turnaround times
- Conducted system performance evaluations using SQL scripts and automated testing tools, optimizing system performance under high traffic
- Collaborated in JAD sessions with stakeholders to refine requirements for patient care workflows and scheduling systems
- Maintained a Traceability Matrix to map project requirements to test cases, ensuring comprehensive validation
- Environment: Oracle, Epic Systems, Cerner, SQL, Tableau, Python, JIRA, MS Visio, Agile, Kanban
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
Junior Data Analyst
CA Technologies
05.2020 - 06.2021
- Gathered and analyzed data from public and internal sources using web scraping tools and SQL, providing insights for academic research projects
- Conducted Exploratory Data Analysis (EDA) to uncover trends in student performance and retention
- Built centralized databases for academic data management, ensuring accessibility and accuracy for reporting purposes
- Automated data collection pipelines using Python, reducing manual processing time by30%
- Created Power BI dashboards to track academic metrics such as enrollment rates and course performance, aiding strategic decision-making
- Provided actionable insights to faculty and administrators, improving resource allocation and academic program outcomes
- Environment: Python, SQL, Power BI, Excel, Web Scraping, Data Transformation, Data Visualization, Agile
Education
Master of Science - Information Technology Management
Webster University
Orlando, FL03.2024
Bachelor of Technology - Electrical and Electronics Engineering
SRKR Engineering College
India05.2021
Skills
- Data Analysis Tools: Power BI, Tableau, Excel (Pivot Tables, Charts, VLOOKUP)
- Programming & Scripting: Python (Pandas, NumPy, Matplotlib, Seaborn), SQL (T-SQL, PL/SQL)
- ETL & Data Integration: Informatica PowerCenter, Web Scraping (BeautifulSoup, Selenium)
- Database Systems: Oracle, SQL Server, MongoDB, MySQL
- Cloud Platforms: AWS (S3, EC2)
- Statistical Analysis: EDA, A/B Testing, Regression Analysis
- Agile Tools: JIRA, Confluence, Kanban, Scrum
Timeline
Data Analyst
New Wave Telecom and Technologies Inc
01.2023 - Current
Data Analyst
MSR Technologies
08.2021 - 07.2022
Junior Data Analyst
CA Technologies
05.2020 - 06.2021
Master of Science - Information Technology Management
Webster University
Bachelor of Technology - Electrical and Electronics Engineering
SRKR Engineering College
Similar Profiles
Biswajit ShialBiswajit Shial
Network & IoT Engineer at Light Wave Technologies Pvt. LtdNetwork & IoT Engineer at Light Wave Technologies Pvt. Ltd
Lalith Kishan RachamallaLalith Kishan Rachamalla
SQL Developer Intern at Nxt Wave TechnologiesSQL Developer Intern at Nxt Wave Technologies
Naga Sindhu BhargaviNaga Sindhu Bhargavi
Independent Contractor at Alpha Wave TechnologiesIndependent Contractor at Alpha Wave Technologies