Smita Shivanandan
Power BI Consultant at Salesorder.com- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Python: Working with Predictive Analytics
LinkedInJul, 2022- Nov, 2024 -
Google Analytics Essential Training
LinkedInJan, 2019- Nov, 2024 -
Google Analytics Essential Training (2017)
LinkedInJan, 2019- Nov, 2024 -
Marketing Analytics: Setting and Measuring KPIs
LinkedInJan, 2019- Nov, 2024 -
070-320 Developing XML Web Services and Server Components
MicrosoftFeb, 2009- Nov, 2024 -
070-300 Analysing Requirements and Defining Solution Architectures
MicrosoftJan, 2009- Nov, 2024 -
070-431 Microsoft SQL Server 2005 – Implementation and Maintenance
MicrosoftDec, 2008- Nov, 2024 -
070-316 Developing and Implementing Windows based Applications
MicrosoftMar, 2008- Nov, 2024 -
070-315 Developing and Implementing Web based Applications
MicrosoftMar, 2007- Nov, 2024 -
Certificate program in Banking Competency, TCS FTC
- -
Certificate program in Investment Banking Competency, TCS FTC
-
Experience
-
Salesorder.com
-
United States
-
Technology, Information and Internet
-
1 - 100 Employee
-
Power BI Consultant
-
Apr 2020 - Present
● Implement end to end BI solutions for Salesorder(SO) customers - Lead PBI adoption for SO customers having monthly revenues of 10 MN+ - Help SO customers achieve a data driven culture using a self service BI model. - Data analysis across sales, fulfilment and accounting datasets. - Setup data gateways and schedule dataset refreshes. ● Liaise with CTO on PBI architecture and deployment for SO customers - Design and develop data models in star and snowflake schemas. - Implement reports and dashboards for SO for reuse and distribution to its customers. - Create views, function and fine tune queries on the MySQL reporting database for PBI consumption. ● Go to market strategy for SO and PBI - Liaise with the CEO to create GTM strategies for using Power BI with SO. - Develop content and strategies for customer onboarding Show less
-
-
-
The Kaagaz Store
-
Pune, India
-
Founder & Marketer
-
Oct 2011 - Dec 2018
Marketing & Lead Generation -Implemented digital and social media strategies/campaigns to build multiple sales channels. -300% increase in web traffic through integrated digital and social media campaigns. -Boosted lead generation by 200% via search engine optimization -Performed keyword research and analysis, SERP analysis, site audits. -Performed on-page, off-page optimizations. -Created reports in Google Analytics to monitor KPIs relevant to business. -Top 3 ranking for website on Google in the paper packaging domain for 5 years. -Launched Facebook presence with fan base to 50+ in a month and expanded to 1500+ https://www.facebook.com/TheKaagazStore/ Web Content Creation -Created product descriptions and marketing materials. -Created and updated website content depending on changing business landscape Strategic Planning -Performed SWOT analysis, impact analysis on various processes within e-Commerce business. -Created design specifications for business logic, screens and feature functionality. Business Development -Interacted with the client to understand requirements and deliver added value. -Promoted brand awareness through product demonstrations and prospect meetings. -Conducted competitive research on companies and positioning of products. -Performed online market and competitor research to understand business trends and competition. Customer Relations -Established customer centered culture of communication and collaboration with strong focus on customer satisfaction. Operations and Resource Management -Collaborated with vendors on creative design, execution, quality improvements. -Created and implemented strategies to reduce inventory levels by 75%. -Evaluated, hired and provided training to resources. -Successfully trained and managed a resource pool of 50+ women. Show less
-
-
-
eCoexist Enterprises
-
India
-
Environmental Services
-
Intern
-
Nov 2010 - Jul 2011
-Represented Eco-exist at KISAN- India’s largest Agri Trade Show with a footfall of more than 1,00,000 and 100+ national and international company participation. -Setup exhibition stand, product introduction, prospecting, communicating with clients, requirement gathering, follow-up after events. -Maintained marketing database of client and contacts and developing new sales channels. - Online marketing, prospecting, product management, inventory management, quality control and packaging and distribution of 1.5 tonnes of eco-friendly Holi colors. - Maintained a comprehensive system to track inventory and streamline business to improve quality and efficiency of operations. - Minimized shortages and reduce wastage. Investigated and resolved inventory discrepancies. Show less
-
-
-
Tata Consultancy Services
-
India
-
IT Services and IT Consulting
-
700 & Above Employee
-
IT Analyst
-
Jun 2005 - Sep 2010
Database Development -Designed, developed, optimized, fine tuned and maintained PL/SQL scripts, stored procedures, triggers and views in SQL Server 2005, 2008R2. -Designed and developed reporting solutions in SSRS and SSIS Business Analysis -Interacted with internal and external stakeholders as a part of the requirement gathering phase for re-design and implementation of several enhancement modules on the database and reporting servers. -Created UI wire frames/prototyping during requirement analysis. -Created functional and technical requirement document. -Database designing and created ER diagrams. -Technical contributions to RFP and created POC. Project Management -Designed and documented unit and system integration test of new enhancements. -Maintained defect log and co-ordinated UAT and sign-off process -Created and maintained requirement traceability matrix. -Taking accountability for controlled and smooth change management process. -Identified risks and issues and addressed in a timely manner -Ensured high quality and on time execution of key projects. -Performed internal and external quality audits for more than 15 account level projects -Assisted in the unit test modules of Masketeer – tool for data masking launched by TRDDC for use by banking client. Technical Writing -Created user manuals, project training manuals, system installation guides and release documentation. -Created white papers on technical topics. Training & Development -Improved team level awareness of new business requirements by conducting training sessions and demos and developing appropriate documentation and training manuals. -Conducted account level induction programs. -Initiated and conducted weekly account level knowledge sharing sessions to help share and collaborate best working practices among the projects within the account. -Trained members in SSRS to create a resource pool within the account. Show less
-
-
Education
-
Indian Institute of Management, Bangalore
-
D.Y. Patil College of Engineering, Pune
Bachelor of Engineering