AKANKSHA KOSANA
Richmond
Summary
Accomplished Data Analyst with 6 years of experience in SQL development, business analytics, and data engineering across consulting and technology domains. Skilled in extracting, transforming, and analyzing complex datasets to generate actionable business insights. Proficient in Python, SQL, Tableau, Power BI, and cloud platforms (AWS, Azure).
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Analyst
Motorola Solutions
05.2023 - Current
- Collected, cleaned, and processed complex datasets using Python and SQL to support business operations.
- Developed and maintained dashboards in Tableau and Power BI to track KPIs and provide actionable insights.
- Conducted data validation and root-cause analysis to ensure accuracy and reliability of reporting.
- Collaborated with cross-functional teams to translate business requirements into technical solutions.
- Optimized SQL queries and automated reporting workflows, improving efficiency by 20%.
Computer Science Teaching Assistant
Virginia Commonwealth University, VCU
08.2023 - 05.2024
- Assisted in teaching Python, SQL, and data structures with practical applications in data analysis.
- Guided students in writing SQL queries and using Python libraries (Pandas, NumPy, Matplotlib) for data handling.
- Designed and evaluated assignments/projects simulating real-world data problems to enhance analytical skills.
- Mentored students on best practices in coding, debugging, and applying computational techniques.
- Enhanced student understanding by incorporating real-world examples and hands-on activities in lesson plans.
Business Data Analyst
Accenture Solutions Pvt Ltd.
09.2020 - 07.2022
- Designed and implemented ETL workflows to consolidate and transform business data for reporting and analysis.
- Developed interactive dashboards and reports in Power BI and Tableau for business stakeholders.
- Assisted in requirement gathering, data modeling, and analytics to support decision-making.
- Ensured data quality, consistency, and governance across multiple sources and systems.
- Automated manual reporting processes using Python and SQL scripts, saving significant operational time.
SQL Database Developer
Accenture Solutions Pvt Ltd.
06.2019 - 08.2020
- Maintained complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision.
- Developed T-SQL scripts, SSIS packages, and optimized queries for ETL and reporting workflows.
- Created and maintained SSRS reports and dashboards for business analysis and operational reporting.
- Conducted data extraction, transformation, and validation to ensure accuracy for analytics projects.
- Implemented data quality checks and monitored database performance for continuous improvement.
Education
Master of Science - Computer Science
Virginia Commonwealth University
Richmond, VA05.2024
Bachelor of Technology - Electronics and Communication Engineering
Koneru Lakshmaiah University
05.2020
Skills
- Database programming and SQL
- Python programming
- Data visualization and presentations
- MS Excel
- Tableau
- Data analysis
- Data cleaning
- Statistical analysis
- Reporting tools
- Agile methodologies
Certification
- Certified as RPA Developer Advanced in UIPATH Platform, C#.
- Other Certifications: AD Fusion 360 - ALM
- AWS Data Engineering - Foundations
- Business Analysis - ECBA,CCBA, CBAP
- Business Intelligence (BI) Analyst
- Google Data Analytics Professional Certificate
- Google Advanced Data Analytics Professional Certificate
Timeline
Computer Science Teaching Assistant
Virginia Commonwealth University, VCU
08.2023 - 05.2024
Data Analyst
Motorola Solutions
05.2023 - Current
Business Data Analyst
Accenture Solutions Pvt Ltd.
09.2020 - 07.2022
SQL Database Developer
Accenture Solutions Pvt Ltd.
06.2019 - 08.2020
Bachelor of Technology - Electronics and Communication Engineering
Koneru Lakshmaiah University
Master of Science - Computer Science
Virginia Commonwealth University
Similar Profiles
CATY GHALYCATY GHALY
Federal Systems Engineering Intern at Motorola SolutionsFederal Systems Engineering Intern at Motorola Solutions
Scott ThorpeScott Thorpe
Senior Presale Business Manager at Motorola SolutionsSenior Presale Business Manager at Motorola Solutions
Anabel SalazarAnabel Salazar
Work Order Admin at Motorola SolutionsWork Order Admin at Motorola Solutions
Ajay ReddyAjay Reddy
.NET Developer at Fifth Third Bank.NET Developer at Fifth Third Bank
Jaqueline Gomez-MacedoJaqueline Gomez-Macedo
Restaurant Hostess at RestaurantRestaurant Hostess at Restaurant