Ankita Nikhar
Data Analyst
About
Data Analyst with 3.5 years of experience in SQL (PostgreSQL, MySQL) and Power BI, building 15+ production dashboards used by 30+ client users, and writing efficient database queries over datasets of 500K+ records to deliver reporting solutions that support data driven decision making. Client focused and strong in requirements management: engage directly with 3 client stakeholders to gather requirements and translate business questions into analysis and reporting solutions. Automated recurring reporting with a Power Automate flow that reduced a three hour daily manual process to approximately 10 minutes, saving ~15 hours per week. Hands on with ETL development, Python and AWS cloud services alongside PostgreSQL, MySQL and Power BI; experienced working in an Agile team of 5 (ETL developer, report developer, scrum master lead and QA).
Skills & Expertise (13)
Work Experience
Data Analyst
Healthcare / Pharmaceuticals | Medical Affairs
Apr 2024 - Present
Spearheaded ETL and data transformation over datasets of 500K+ records using optimized SQL queries and Python, applying data modeling to structure source data into analysis ready tables while ensuring accuracy and adherence to data governance standards. Built a Power Automate flow to automate a recurring reporting process, cutting it from approximately 3 hours of manual effort per day to around 10 minutes, a saving of roughly 15 hours per week. Collaborated in an Agile team of 5 (ETL developer, report developer, scrum master lead and QA) to interpret analytical findings, formulate data driven strategies and optimize sales performance and market share.
Data Analyst
Tulip Technologies
Oct 2023 - Present
Gathered and documented requirements directly from 3 client stakeholders, translating business questions into dashboard layouts and reporting solutions, and running walkthroughs to confirm scope before build. Designed and developed 15+ Power BI dashboards with multilevel drill down, adopted by 30+ client users, which automated the daily reporting process and significantly reduced manual report preparation time while surfacing key product strengths and pain points. Applied Power BI filters, DAX and used M language code to deliver detailed product performance insights, identifying positive and negative trends and recommending actions that informed client business decisions.
Data Analyst
Healthcare / Pharmaceuticals | International Commercial
Nov 2023 - Mar 2024
Extracted and integrated large datasets from multiple source databases hosted on an AWS cloud data warehouse using efficient SQL queries, ensuring accuracy and readiness for analysis. Created detailed, interactive Power BI visualisations and led knowledge transfer sessions with clients, making complex data insights accessible to non technical stakeholders. Provided insights into market share dynamics, supporting informed decision making and strategy refinement for enhancing sales performance. Contributed to delivering analytical reports and reporting solutions, empowering clients with actionable insights to support data driven business decisions.
Data Analyst
ICICI Bank
Apr 2023 - Oct 2023
Wrote SQL queries to extract and consolidate customer, portfolio and transaction data from banking databases, validating accuracy before analysis and reporting. Built and maintained dashboards and periodic MIS reports on portfolio performance, product mix and client holdings, enabling relationship and product teams to track performance against targets. Analysed customer segments, product uptake and pipeline trends to identify growth opportunities, presenting findings that supported data driven decisions on client targeting and product positioning. Performed data validation and reconciliation across source systems, maintained documentation of data definitions and reporting logic, and ensured reporting adhered to RBI, SEBI and ICICI Bank compliance norms. Used advanced Excel (pivots, lookups, conditional logic) to model and summarise large datasets, structuring data into reusable reporting formats for recurring analysis. Worked closely with product, research and operations teams to gather reporting requirements, translate business questions into analysis, and communicate insights to nontechnical stakeholders.
Education
M.B.A. in Finance & Marketing - IBS Business School
- 2023 · Afghanistan
B.B.A. in Finance - City Premier College
- 2020 · Afghanistan
Intermediate Education - MHK Sancheti Public School & JR College
- 2017 · Afghanistan
Secondary Education - Vimaltai Tidke Convent
- 2015 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (13)
Click a skill to find developers with the same skill
