Archana A
Chennai
Summary
Results-driven Business Intelligence and Data Analytics Professional with a proven track record in delivering data-driven insights and scalable reporting solutions across e-commerce and market research domains. Experienced in leading analytics teams, developing impactful Power BI dashboards, and optimizing SQL data pipelines for high-performance reporting. Skilled at translating complex data into actionable strategies that drive revenue growth, improve operational efficiency, and enhance decision-making. Strong expertise in Power BI, SQL, and DAX processes. Recognized for stakeholder engagement, cross-functional collaboration, and training initiatives.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Lead
Amazon Development Centre
10.2016 - 10.2023
- Spearheaded 40+ Power BI dashboards that drove a 15% improvement in vendor operational decisions and resulting in a 2% increase in vendor-related revenue through improved decision-making and reporting accuracy.
- Handled premium projects for Adidas, Under Armour,NB, Kimberly-Clark, Samsung and Levi's
- Worked on reports for there Profit ,Inventory and Shipment Management using different modes in getting date from different data sources into power bi and working in Dax functions.
- Embedded 18+ Power BI reports on a Vendor Central Portal and successfully managed access to data
for over 4K users using 'Roles.' - Generated reports using time intelligence functions and created Slicers in Power BI Implemented Role Based Security as part of security in Power BI.
- Led a team of 5 analysts, overseeing daily tasks, mentoring team members, and ensuring timely delivery of BI solutions aligned with business objectives.
- Monitored team performance and project progress, creating weekly performance reports and presenting them to senior managers to support workforce planning and optimization.
- Streamlined SQL data pipelines, improving data refresh efficiency and reducing report load time by 40% through optimized queries and Data Modeling.
- Integrated data from Amazon Redshift and Amazon Athena into Power BI using Direct Query and Import modes, ensuring scalable and timely analytics.
- Designed and maintained ETL workflows using Power Query and SQL improving data reliability and traceability.
- Managed report publishing and dataset scheduling in Power BI Service (Member access) maintaining 99% data refresh success rate across all active reports.
- Collaborated with cross-functional teams to automate manual Excel-based reports, saving over 15+ hours per week and reducing reporting errors by 70%.
- Implemented Row-Level Security (RLS) across datasets, ensuring secure data access for over 100+ users based on Regional and Category-level access control.
- Drove 25% increase in self-service BI adoption by training stakeholders, simplifying complex reports, and delivering intuitive and build dashboards tailored to business needs.
- Audited existing reports and consolidated outdated dashboards, improving accessibility and workspace efficiency.
- Achieved 95%+ user satisfaction rate (based on internal feedback surveys) for dashboards delivered, driven by interactive design and clear data storytelling.
- Presented key insights and strategic recommendations during monthly business reviews, influencing decisions that led to 10% improvement in Inventory turnover.
- Established standardized DAX and Data Modeling best practices, reducing calculation errors and ensuring consistency across 20+ dashboards.
- Delivered actionable insights through Power BI reports that influenced vendor negotiations, resulting in 12% increase in contribution margin across key categories.
- Implemented KPIs to track individual and team performance, aligning metrics with business goals and improving overall team productivity by 30%.
Report Analyst
Tata Consultancy Services
08.2013 - 02.2016
- Company Overview: Nielsen Market research
- Contributed to business growth initiatives by providing timely analytical support, and identifying data-driven opportunities.
- Developed automated, recurring performance and progress reports for multiple market research projects, improving reporting efficiency on their sales data by 98%.
- Presented key project updates and insights during stakeholder review meetings, enabling informed decision-making.
- Interpreted large datasets into actionable insights with visual summaries (charts, graphs, narratives) using Excel macros to support business decisions.
- Supported UAT (User Acceptance Testing) by documenting issues, facilitating communication between users, developers, and ensuring technical readiness.
- Created detailed project scope documentation, ensuring alignment across cross-functional teams, and stakeholders.
- Authored and maintained 10+ comprehensive project scope documents, aligning technical and business teams, ensuring timely delivery, and reducing scope creep by 25%.
- Nielsen Market research
Education
Bachelor of Arts - Corporate Secretaryship
Ethiraj College For Womens
Diploma - Investment Management
Ethiraj College For Womens'
Chennai, IndiaSkills
- SQL
- DAX
- Advanced analytics
- Data visualization
- Data Modeling
- Cloud data warehousing
- Power BI service
- ETL workflow design
- Stakeholder reporting
- Stakeholder management
- Data-driven decision making
- Project documentation
- Scope management
- Problem solving
- Analytical thinking
- Leadership
- Team management
- Stakeholder enablement
- Cross-functional collaboration
- Adaptability
- Strategic Thinking
Certification
Tableau Desktop, Tableau, 05/01/25
Languages
Tamil
English
Hindi
Awards Recognition
- On Spot Award (TCS)- 100% quality and on-time delivery for clients
- Einstein Award (Amazon) - Streamline in-process SQL data pipelines, improving data refresh
- Extra Miles Award (Amazon)- Implemented KPIs to track individual and team performance, aligning metrics with business goals
- Star of the year (Amazon)- High conversion rate and business expansion
- Multiple appreciations from clients and stakeholders for 'Problem solving,' 'Bias for action,' 'Operational excellence,' and 'Deep Drive'
Additional Qualifications
Diploma in investment management
Roles and Responsibilities
- Work allocation and delivery management – Assign tasks using Zesus based on team strengths and project priorities, conduct regular sync-ups, and ensure timely delivery of high-quality solutions.
- Quality control – Oversee the quality checks—validating data, reviewing visual accuracy, and ensuring alignment with business requirements.
- Stakeholders requirement gathering – Regularly interact with stakeholders to understand reporting needs. In many cases, clients provide the initial report skeleton or a sample layout, review and refine to ensure feasibility, data availability, and scalability.
- Status reporting – Provide regular status updates to business stakeholders on development progress, blockers, estimated timelines, and completed milestones. I also consolidate updates from the team and escalate issues proactively when needed.
- Power BI Service – Manage on publishing of reports and datasets, schedule and monitor refreshes, through Enterprise data gateway.
Timeline
Lead
Amazon Development Centre
10.2016 - 10.2023
Report Analyst
Tata Consultancy Services
08.2013 - 02.2016
Bachelor of Arts - Corporate Secretaryship
Ethiraj College For Womens
Diploma - Investment Management
Ethiraj College For Womens'
Similar Profiles
KARUNESH GUPTAKARUNESH GUPTA
Senior Product Manager | Technical Program Manager at AMAZON DEVELOPMENT CENTRE INDIASenior Product Manager | Technical Program Manager at AMAZON DEVELOPMENT CENTRE INDIA
Divya MadukalDivya Madukal
Quality Associate (LMAQ - Quality) at Amazon Development CentreQuality Associate (LMAQ - Quality) at Amazon Development Centre
BALAJI MBALAJI M
CXQO associate at Amazon Development Centre India Pvt. Ltd.,CXQO associate at Amazon Development Centre India Pvt. Ltd.,
Amit TakalkarAmit Takalkar
Device, Digital & Alexa Support Ops D2TS GrpM at Amazon Development Centre (India) Pvt. Ltd.Device, Digital & Alexa Support Ops D2TS GrpM at Amazon Development Centre (India) Pvt. Ltd.
Zaheer Syed.SZaheer Syed.S
Team Manager at GSR Global ServicesTeam Manager at GSR Global Services