SAITEJA NAMPALLY
Summary
Results-driven Data Analyst skilled in data cleaning, analysis, and visualization. Proficient in SQL, Python, and R, with expertise in PowerBI, Tableau and Excel for creating impactful dashboards. Adept at ensuring data integrity, modeling datasets, and tracking KPIs. Proven ability to translate complex data into actionable insights and communicate effectively with stakeholders to support strategic decision-making.
Overview
3
3
years of professional experience
Work History
Data Analyst
Limsons IT Services
Reston, VA
03.2024 - Current
- Utilized SQL, Python, and Excel to analyze financial data, identify trends, and develop statistical models, enhancing forecasting accuracy and investment assessments.
- Created and maintained Power BI dashboards to visualize KPIs and financial metrics, facilitating executive decision-making.
- Reduced data processing time by 20% through optimizing financial reporting and streamlining operational processes.
- Conducted ad-hoc analyses for strategic initiatives, including pricing optimization and risk management, and prepared comprehensive reports and presentations on financial performance.
- Supported senior analysts with financial modeling and valuation for investment opportunities and contributed to discussions on market trends and economic forecasts.
- Enhanced data quality and reporting accuracy by collaborating with cross-functional teams to refine data collection processes.
- Performed statistical analysis to evaluate marketing campaign effectiveness, resulting in a 15% increase in conversion rates.
- Utilized data visualization tools to effectively communicate business insights.
Data Analyst
TCS
Louisville, KY
02.2022 - 03.2024
- Designed and modeled analytical databases and ER diagrams, integrating data from multiple sources into Amazon S3 and PostgreSQL.
- Developed and maintained end-to-end data pipelines using SQL, Python, and Azure services for efficient data transformation and analysis.
- Engineered data standardization and automated report generation with Power BI, reducing manual effort by 50% and providing actionable insights.
- Implemented advanced ML models and rule-based systems for record linkage, achieving up to 65% accuracy and improving data matching processes.
- Collaborated with cross-functional teams to address data challenges, create documentation, and convert business needs into technical requirements.
Data Analyst
Slesha Inc
USA
11.2021 - 02.2022
- Identified and analyzed source data from Oracle and SQL Server, performing data profiling, validation, and integration.
- Developed and executed SQL scripts for database modifications, including table updates, view creation, and stored procedures.
- Wrote SQL and PL/SQL queries to manipulate data, and created Tableau reports and dashboards, distributing them in PDF format.
- Interpreted data to extract key performance metrics and insights, collaborating closely with project teams to address and resolve issues promptly.
Data Analyst Intern
Slesha Inc
USA
05.2021 - 07.2021
- Managed extensive databases and utilized advanced techniques to collect, analyze, and interpret data from customers and partners.
- Developed and implemented quantitative models to stabilize the business and maximize efficiency.
- Spearheaded a successful project on startup success using data visualization, where I cleaned and analyzed datasets to identify key factors affecting startup performance.
- Leveraged Python and Tableau to create insightful visualizations on industry trends, company size, employment metrics, and founder experience.
- Collaborated with cross-functional teams and executed strategic tasks as assigned by management, driving impactful results and supporting business objectives.
Education
Masters in Information Systems -
Cleveland State University
Bachelor of technology, Mechanical -
Jawaharlal Nehru Technological University
Skills
- Data Cleaning
- SQL Databases
- Data Validation
- Data Analysis
- Data Visualization and Presentations
- Python Programming
- R Programming
- Statistical Analysis
- Tableau Software
- KPI Tracking
- Data Modeling
- Excel Functions
Projects
Startup Success Analysis using Data Visualization | Python, Tableau
Analyzed factors impacting startup success, such as organizational structure, market timing, and funding, by cleaning and examining relevant datasets. Utilized Python and Tableau to create dynamic visualizations, highlighting key metrics like industry trends, company size, employment counts, and founder experience. Provided actionable insights to support strategic decision-making and identify critical success factors for startups.
Stock Market Analysis and Prediction | MongoDB, PySpark, Time Series Forecasting
Gathered and analyzed stock data from multiple companies over the past five years, focusing on daily net values and high stock prices. Employed PySpark for data processing and the Prophet model for time series forecasting to predict future stock trends. Delivered insights into stock behavior and potential investment opportunities based on historical patterns.
Timeline
Data Analyst
Limsons IT Services
03.2024 - Current
Data Analyst
TCS
02.2022 - 03.2024
Data Analyst
Slesha Inc
11.2021 - 02.2022
Data Analyst Intern
Slesha Inc
05.2021 - 07.2021
Masters in Information Systems -
Cleveland State University
Bachelor of technology, Mechanical -
Jawaharlal Nehru Technological University