Akansha Wadhwa
Jaipur
Summary
Experienced Data Analyst adept in Python, SSIS, SQL, Excel, and Power BI. Excels in data manipulation, analysis, and visualization, delivering actionable insights for informed decision-making. Collaborative and detail-oriented, with a focus on leveraging analytical skills to address business challenges and optimize processes, ensuring effective communication of findings to stakeholders. Creative Business Analyst with broad-based background in highly competitive and dynamic organizations. Recognized as decisive leader and excellent team player. Committed to forming strong, productive teams.
Overview
2
2
years of professional experience
Work History
Business Analyst /ETL Developer
Surgical Notes
Noida
05.2024 - Current
- Conducted market research to identify potential opportunities for new product development.
- Analyzed customer data to determine trends in purchasing behavior.
- Collaborated with stakeholders across departments to define requirements for new projects.
- Designed test plans, scenarios, scripts, cases, and results matrices to validate system functionality.
- Developed reports using SQL queries to track progress against key performance indicators.
- Evaluated business processes for improvement opportunities through automation or streamlining.
- Conducted insightful, ad hoc analyses to investigate ongoing or one-time operational issues.
- Performed daily, weekly, and monthly reviews and analyses of current processes using operational metrics and reports.
- Monitored performance of the ETL processes by creating log files with SSIS logging features.
- Maintained source system metadata information in order to ensure accuracy of the ETL process.
Data Analyst
Circulant Solutions Ltd.
Jaipur
07.2022 - 05.2024
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Developed dashboards with Power BI to monitor key performance indicators.
- Gathered requirements from stakeholders to design data models and reports.
- Leveraged SQL queries to extract, transform and load data into databases.
- Designed automated ETL processes for efficient data extraction, transformation and loading in order to improve accuracy and reliability of reporting systems.
- Maintained documentation of all the processes related to Data Analysis.
- Automated manual reporting processes by developing scripts in Python or SQL.
- Optimized existing database structures for better performance on analytics tasks.
- Defined KPIs based on collected data sources.
Education
Bachelor of Computer Applications - Data Analysis
University of Rajasthan
Jaipur , Rajasthan07-2023
Skills
- Data models
- System architecture
- Data quality
- Data visualization tools
- Data warehouse
- Data accuracy
- Data efficiency
- Automated data pipelines
- Quicker analysis
- Decision-making
- Enterprise data model
- Ad-hoc analyses
- Operational efficiency
- Customer segments
- Target markets
- SQL
- Database integrity validation
- Large dataset manipulation
- Data Mastering (MDM)
- Data Integration Services
- Salesforcecom
- Veeva CRM analysis
- Pharmaceutical and Life Sciences implementations
- Sales Information
- Data Mapping
Timeline
Business Analyst /ETL Developer
Surgical Notes
05.2024 - Current
Data Analyst
Circulant Solutions Ltd.
07.2022 - 05.2024
Bachelor of Computer Applications - Data Analysis
University of Rajasthan
Similar Profiles
Carrie LaraCarrie Lara
Accounts Receivable Manager at Surgical NotesAccounts Receivable Manager at Surgical Notes
Nimita RangaNimita Ranga
AR Collection Specialist at Surgical NotesAR Collection Specialist at Surgical Notes
Jazmin GarzaJazmin Garza
AR Specialist at Zulu Health/ Surgical NotesAR Specialist at Zulu Health/ Surgical Notes