Ambika Viswanathan
Toronto,ON
Summary
Associate Business Analyst (holding a Canada Open Work Permit) and Microsoft Power BI Certified Analytics Professional with 7 years and 6 months of Analytics work experience in interpreting and analyzing data for driving business solutions (Printing, Retail, Pharma, and Supply chain). Providing analytical solutions to a leading multinational information technology company that involve critical and time-sensitive deliverables. With strong technical knowledge and an ability to understand business and data, I am looking for opportunities to provide solutions for challenging business problems.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Associate Business Analyst
Mphasis - Contract Worker For HP
08.2021 - Current
- Responsible for gathering the requirements (improve customer onboarding experience and feature usage) from the Business and Engineering teams for the products.
- Developed SQL scripts for data processing and performed analysis on customer support call and Net Promoter Score data.
- Developed dashboards and Performed analysis to track onboarding experiences (onboarding journey funnel, errors and impacts during onboarding, onboarding time analysis) at different levels and feature usage.
- Derived and presented actionable insights from the analysis and dashboard to the business and Engineering teams to expand business
- Organized daily tasks for better efficiency and use of resources.
Senior Business Analyst
Tredence Analytics Solutions
04.2019 - 08.2021
- Developed affinity dashboard for largest retailer in US to identify product combinations that have large interest and sales opportunity for both online and store.
- Worked with customer analytics team of omnichannel marketing to extract data for Merchandising dashboard which provides basket/customer metrics and demographic purchase patterns at different period and hierarchy levels.
- Worked on Customer segmentation based on their frequency to analyze their basket/customer metrics.
- Worked on ad hoc tasks like sticky customers and data pulls.
- Worked with Data Engineering team to develop process dashboard to monitor their scheduled tasks with live process data.
- Worked on Data quality management dashboard that involves various rules such as completeness, timeliness to check quality of raw data with alert report for better analysis.
- Worked on load consolidation to optimize delivery strategy for resource supplier company
- Crafted Retailer's dashboard to track Performance of sales, Store & Inventory
- KT and work assignment to beginners in team
Programmer Analyst
Cognizant Technology Solutions
02.2016 - 04.2019
- Created monthly/ weekly performance reports that includes various KPIs by processing raw data and performing data validation.
- Developed views using PL/SQL which process the raw data to project it in a report friendly format for various tabs.
- Developed Report Generator using Excel/VBA for creating separate Reports for each Rep/Manager with their respective KPIs.
- Developed automated QC tools to reduce number of defects, man – hours and ensure seamless deliveries.
- Worked on generating automated excel based charts for good data insights.
- Worked on Ad-hoc analysis & reporting changes
- KT and work assignment to beginners in team
Education
Bachelor of Engineering - Electronics And Communication Engineering
CARE Group of Institutions
Trichy, India05.2015
Skills
- SQL
- Tableau
- Power BI
- Advanced Excel
- Python (Analytics)
- Databricks
- VBA
- Big Query, Hive and Data Proc
- Oracle, SQL Server and Redshift
- Stored Procedures
- Linear Regression and NLP
- Power Point
Certification
- Certified Microsoft Power BI Data Analyst Associate (PL-300 Certification Issued by Microsoft)
- Cleared Cognizant Certified Professional Examination in Analytics (Issued by Cognizant)
- SQL Advanced Certificate (Issued by HackerRank)
AWARDS & RECOGNITION
- Recognizing Excellence Award (Mphasis) for excellent contributions towards the project
- Quarterly STAR Award - Q3'2022 (HP) for delivering the dashboards during the product launch
- Spirit of Winning Award (Mphasis) for successfully delivering the project in the absence of critical resources
- Be Entrepreneurial Award (Tredence) for reflecting the value of the company
- Stellar Award - Q3'2017 (Cognizant) for taking complete ownership of all reports and delivering defect free deliverables and handling ad- hoc Client change requests efficiently
- Secured 7th Place out of 1200+ participants in SQL Champ Challenge (Cognizant)
Timeline
Associate Business Analyst
Mphasis - Contract Worker For HP
08.2021 - Current
Senior Business Analyst
Tredence Analytics Solutions
04.2019 - 08.2021
Programmer Analyst
Cognizant Technology Solutions
02.2016 - 04.2019
Bachelor of Engineering - Electronics And Communication Engineering
CARE Group of Institutions
- Certified Microsoft Power BI Data Analyst Associate (PL-300 Certification Issued by Microsoft)
- Cleared Cognizant Certified Professional Examination in Analytics (Issued by Cognizant)
- SQL Advanced Certificate (Issued by HackerRank)
Similar Profiles
Aditya SinghAditya Singh
Technical Support Representative at Mphasis LTD (For HP)Technical Support Representative at Mphasis LTD (For HP)
Abhilash SahuAbhilash Sahu
Senior Analyst at Mphasis -Deputed at HP -Pumori ProjectSenior Analyst at Mphasis -Deputed at HP -Pumori Project
Sarang PSarang P
Associate Software Engineer at Mphasis An HPAssociate Software Engineer at Mphasis An HP