Anu Chakilam
Vancouver,BC
Summary
Self-motivated Developer adds high level of experience over more than 10 years collaborating and working on multiple web-based projects. Passionate, hardworking coder with penchant for developing customized interfaces that factor in unique demands for accessibility, reachability and security. Organized approach to meeting multiple, concurrent deadlines. Pulls from active knowledge of current technology landscape to promote best practices in web design.
Overview
12
12
years of professional experience
6
6
years of post-secondary education
Work History
Senior BI Developer
Lululemon
10.2020 - Current
- Collaborate closely with business stakeholders to elicit and define requirements for interactive BI dashboards and reports, focusing on key performance indicators such as sales, product trends, headcount, and compensation
- Drive the end-to-end dashboard design process, starting from ideation using mock Visio diagrams and data model wireframes, to final delivery and user acceptance
- Develop comprehensive KPI, Sales, Inventory, and Compensation reports utilizing advanced DAX queries in Snowflake, ensuring robust data analysis and meeting precise reporting needs
- Create real-time BI dashboards using Power Apps for seamless data collection from end-users, integrating data flows into SharePoint for immediate access and utilization
- Manage multiple workspaces and Power BI apps tailored to different user personas, ensuring customized and efficient data visualization experiences
- Assist in optimizing data modeling efforts by developing Snowflake views to enhance data consistency and reduce redundancy, improving overall data quality and accessibility
- Engage in cross-functional team collaborations within a scrum environment to identify and resolve impediments affecting report delivery and quality
- Design and implement Power BI reports utilizing varied datasets such as sales figures, product performance metrics, and mobile application logs sourced from Snowflake, ensuring comprehensive data analysis and visualization
- Develop complex Power BI dashboards integrating multiple data sources from Snowflake, including sales, product, and customer data, to provide holistic insights into business performance
- Optimize Snowflake views to streamline data retrieval processes and enhance report generation efficiency, reducing redundancy and improving data consistency across reports
- Collaborate with data engineers and architects to establish best practices for data modeling in Snowflake, contributing to the development of efficient data pipelines and optimized reporting solutions
- Implement data governance principles within Power BI to ensure data integrity and security across all reporting functionalities, adhering to organizational standards and compliance requirements.
Program Manager
Amazon
02.2020 - 10.2020
- Led Product Merge project aimed at improving a seller’s catalogue by merging duplicates, spread across a selection of 55 million Product pairs. This project aims to improve customer experience by pulling traffic to high performing Products’ in Europe marketplaces
- Developed a Python application to translate Asin attributes into various languages saving 2 FTE’s per annum
- Developed, implemented, and maintained an interactive Power BI / Tableau reporting dashboard for analyzing and monitoring business performance for Data-driven Decision Making
- Developed a Macro that helps reduce 0.5 FTE per annum, required for creating files that contain “Top Selection Product analysis” specific to a seller’s listings. This macro creates 10 files per minute versus 1 file in 10 minutes manually
- Developed a Macro that accepts multiple ETL output data sets & generates analytical reports (pdf and excel), thereby saving 0.5 FTE (full-time equivalent) per annum & eliminating human errors.
Business Analyst
Deloitte
08.2017 - 02.2020
- Developed Tableau dashboard for employee performance management in the firm which show key details of any professional in the firm. This dashboard is a single point data source for SVP’s which helped gauge performance of any professional during an appraisal cycle
- Worked in an Agile environment to generate key insights for the firm on all US and India operations by structuring, organizing, and analyzing all project related data
- Lead a project team of 5 to build a “Learning and Development” portal. This portal has enabled business to have a centralized system to store & analyze the firm’s L&D activities, thereby saving 1 FTE hours per annum
- Automated report generation of various teams within the firm using macros. This process has also enabled to publish error free reports from multiple data sources with actionable resource utilization insights, thereby saving 3 FTE hours per annum
- Lead a project team of 3 to develop a firm wide activities portal. This portal acts as an automated system, triggering mails to Senior Management requesting for action, thereby saving 1 FTE hours per annum
- Continuously interacted with Senior Management of the firm (SVP’s, VP’s and PPMD) to deliver end to end automation processes used for project streamlining.
Localization Automation Specialist
Amazon (Ecommerce)
12.2015 - 08.2017
- Ideated & designed the team’s first ever MySQL driven macro to capture, store and retrieve daily operational data for the team
- Developed a work flow system using macros for associates of a portfolio. This enabled their interaction with the database for data retrieval and manipulation for everyday operations without the need of MySQL Workbench
- Developed excel macros for daily uploads to Amazon’s Data net systems (ETL), which helped automate manual file preparation for two portfolios of the teams. This helped reduce 2 FTE hours per annum
- Automated WBR generation to give accurate & real time data for Leadership, which was used for Amazon wide reporting
- Developed an excel macro to automate an entire portfolio there by saving 4 FTE hours per annum.
Programmer Analyst
Cognizant Technology Solutions
05.2012 - 05.2013
- Commenced work on testing projects to check database consistency across environments for the team, which helped acquire basic skills on MySQL. Owned & delivered client pitches through presentation on various project details.
Education
MBA/MS: Information Systems -
Deakin University
03.2013 - 05.2015
Bachelor of Technology: Mechanical Engineering - undefined
Sreenidhi Institute of Science and Technology
09.2008 - 05.2012
Skills
Power BI
SQL / DAX / Power Query
SharePoint / Power Automate / Power Apps
MS Excel / VBA Macros
Data Processing / Data Transformation
Jira/ Confluence
Accomplishments
- Won ‘Best Dashboard Visualizer’ award for two consecutive quarters in Lululemon
- Was mentioned in two Deloitte.com publications for designing tableau visuals - The changing face of North America’s tech ecosystem and The most valued technology gadgets of the last decade
- Received Deloitte’s “Applause” award for automating manual budget tracking process using SharePoint and developing a Tableau dashboard for senior leadership on the same, 2019
- Awarded ‘Best Employee' by Amazon for automating a manual process of uploading data into ETL, which is bound to error with manual efforts. This helped save 2 FTE hours per annum, 2017
- Awarded ‘Star Employee' by VP Amazon, Terry Hanold, for automating an entire portfolio which helped save 4 FTE hours per annum, 2016
- Awarded ‘Employee of the Month' in Cognizant Technology Solutions, 2012
Timeline
Senior BI Developer
Lululemon
10.2020 - Current
Program Manager
Amazon
02.2020 - 10.2020
Business Analyst
Deloitte
08.2017 - 02.2020
Localization Automation Specialist
Amazon (Ecommerce)
12.2015 - 08.2017
MBA/MS: Information Systems -
Deakin University
03.2013 - 05.2015
Programmer Analyst
Cognizant Technology Solutions
05.2012 - 05.2013
Bachelor of Technology: Mechanical Engineering - undefined
Sreenidhi Institute of Science and Technology
09.2008 - 05.2012