Sunitha Ambala Email & Phone Number

Toronto, Ontario, Canada

Toronto, Canada Area

• Proficient with managing large complex data sets of shopify, provincial liquor boards and cannabis boards. Setting business requirements and rules for BI tools.
• Leading BI development and manage audience-specific status reports of defined metrics to key stakeholders at all levels. Delivering timely and value-added insights that support decision making.
• Participation in data warehouse and data mart design by integrating data from various Cannabis data providers Buddi, Fire & Flower and Cana Cabana.
• Hands on experience in implementing KPIs for market share distribution, promotion uplift, product mix, category analysis, price segment analysis, store distribution and recommended replenishment.
• Developed meaningful charts on Seasonality index, Pareto principle, dynamic tool tips, donut and dual axis charts in Tableau. Validating the quality and integrity of the data included in the Reporting Packages and.
• Maintenance and scheduling of Tableau Data extracts using Tableau server and the Tableau Command utility.

Victoria, British Columbia - Canada

• Working with EDM (Data Governance & Data Operations) team in developing Visual Analytics Dashboards in Tableau and PowerBI.
• Understand the requirements and identifying the data for analytics.
• Building the Data Models and Metadata information to support reporting.
• Understanding the Asset Management Industry and supporting the team in enterprise level analytics.
• Managing Data Marts for Visualizations and Building Data Quality dashboards for the Enterprise Data Management team in BCI.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Halifax, Canada Area

• Work with Business users to understand reporting requirement and provide the optimal solution.
• Responsible for developing and managing various Dashboards on Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated fields for preparing dashboards and worksheets in Tableau.
• Created PL/SQL Tables, collections, procedures, functions and packages. Fine-tuned SQL Queries for maximum efficiency and performance. Loaded data into stage tables using SQL* loader.
• Designed and developed meaningful reports using SQL server reporting services(SSRS).

Hyderabad Area, India

• Solid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.
• Involved in Requirement Gathering, analysis, Design, Development, Unit Testing, Production Deployment and Support
• Coordinate with application team and design ETL processes.
• Expertise in SQL and PL/SQL programming, developing complex code units.
• Experience in data migration/conversation using SQL*Loader.
• Expertise in creating views, materialized views, indexes on tables and partitioning the table for SQL tuning purpose

Master’S Degree, Computer Science And Engineering, 78.75%

Activities and Societies: Worked as Visiting Lecturer for various student batches an trained them on Data Structures. Studied and Excelled.

Master’S Degree, Computer Applications, 80.27%

Ranked among top 3 students of the program. Studied and Excelled Operating Systems, Operations Research, Unix Programming, Software.

Bachelor’S Degree, Computer Science, 82.27%

Opted for Specialisation in Computer Science Secured top in Mathematics - I , II and III