Supplier Spend Optimization
Customer Problem
- Budget Constraints
- Optimize Vendor Spend
Solution
- Created Dashboard in Power BI showing
- Spend across regions
- Spend across vendors
- Spend across business units
Business Impact
- Real-time analysis of data through the Power BI Dashboard enabled
- Consolidation of Vendors
- Introduce Volume discounts
- Reach targets in a better manner
- Helped in Optimizing the spend
Agile Quality Dashboard
Customer Problem
- Agile projects running in silos
- No consolidated info available on projects
- Difficult to drill down on quality metrics to identify root cause of issues
Solution
- Collected info from various sources/tools, test cases, bugs, root causes and other critical information
- Integrated Power BI with different tools for a seamless real-time view
- Built a Power Bi Integrated, Intuitive Dashboard with a drill down feature
Business Impact
- Bird’s eye view of projects in-flight at any given point in time
- Enabled stakeholders to focus only on projects that needed attention, thus saving time and effort
- Facilitated the quality team to showcase their value addition through various quality metrics
Customer Profitability Report
Customer Problem
- Multiple products across multiple clients
- Planned to introduce revenue based profit share to executives
- Look at growth of Executive based revenue
Solution
- Collected info from various sources/ tools, sales database, customer database
- Created Dashboard in Power BI showing
- Total Revenue
- Gross Margin Percentage
- Executive based Target Vs Actuals
Business Impact
- Real-time analysis of data through the Power BI Dashboard enabled
- Consolidation of Executive based information
- Introduce revenue based profit share for executives
- A better understanding of executive growth
Data Analytics – Case Studies
FORTUNE 100
Financial Services Company
Problem
- Productivity across distributed teams, Location, Project
- Quality Metrics consolidated across projects done manually
- Value-add to Testing Team – Dollar Saving
Solution
- Created automated Dashboard and integrated with the Quality tool used.
- Targets based on past performance identified for KPIs
- Real-Time interactive reports indicating the current status as against targets for all releases
Business impact
- Real-time analysis of data through QlikView Dashboard (now being migrated to Tableau) enabled
- Single source of truth – Consolidation of all projects
- Customized Filters (Project wise, Location wise metrics) enabled faster action
- Proactive, timely course corrections through real time status of various projects
FORTUNE 100
Insurance Services Company
Problem
- Manual collection of data from various sources and then reported in Excel and PowerPoint for monthly COO review; each month this step is repeated
- Audit and Compliance data are maintained in excel in various places; collating and reporting this info on monthly basis is a tedious process
Solution
- Standardized the data flow, metrics/KPI collection, business rules
- Created fully automated live, intuitive and interactive reports and dashboard.
Business impact
- Real-time, Objective information to COO and Senior Leaders (data refreshed automatically, no manual intervention)
- All stakeholders (Auditors, Auditees) sharing same common view helps in better audit, security compliance
- Drill down options helped in effective analysis from Application availability to SLA agreement to Root Causes which helps in SOX compliance
- Better Fund Management through Finance Forecasting dashboard
Agile Test Assessment
Business Impact
- Maturity level of the organization improved
- Enabled customer to go to market faster
- Agile Model-based delivery improved customer satisfaction
Problem Statement
- The organization wanted to deliver high-quality software with speed and consistency across all their projects
- The need was to baseline their current Agile Test Maturity and identify a roadmap for improving maturity levels
Solution Provided
- Assessed based on Customized Agile Test Maturity Model
- Conducted Agile Assessment for the organization and for each project
- Submitted Gap Analysis document with Top 5 Recommendations
- Created roadmap to improve Agile test maturity of projects
Agile Test Consulting
Business Impact
- Quality of the projects improved drastically
- Customer was able to intervene proactively due to dashboard and improve customer satisfaction
Problem Statement
- Customer did NOT have the skills to create Agile test strategy for a large, critical, cloud project
- Customer had test leads with varied skill maturity and wanted help in improving their skills and delivery capabilities
Solution Provided
- Created Agile test strategy for critical and other projects along with Test Leads
- Provided Agile Test Coaching for the test leads and test team members in improving their test design, quality metrics
- Reviewed, Recommended Test Automation Strategy, Architecture
- Performed periodic check on the implementation of Agile Testing
- Implemented Agile Delivery Dashboard for consolidated project performance view
Agile Test Training
Business Impact
- Agile Test Training improved the skills of the entire team and enabled them to deliver faster with better quality to their customers
Problem Statement
- Organization decided towards Agile for their Testing Practice
- Skills of test managers, leads and test team across the globe was NOT up to the mark
Solution Provided
- Created Agile Testing material for two roles – Test Mgrs/Leads, Test Team Members
- Multiple real-life examples made the training interactive and useful to the audience
- Conducted Agile Training across the globe
- Shared Agile Test Maturity Model for project execution
- Gave sample guideline to migrate to Agile
Test Process Improvement - BFSI Domain
Problem Statement – Testing practices needed a revamp
Solution Provided
- Conducted Back to Basics Testing Training for Managers and Testers
- Conducted a Project Assessment covering all test practices
- Identified Top 5 Improvement opportunities at the organization level and project-specific improvements
- Introduced Test Delivery Dashboard
Business Impact
- Improved Testing practices
- Created Intuitive Dashboards to show the status of various projects from high level with drill-down option to defect level
- Introduced Targets/Thresholds based on past performance for the various metrics
- QA Managers performance are reviewed against the targets
On Premise Product – Move as SAAS Product
Problem Statement – An inhouse ITSM On Premise tool to be migrated to SAAS and sold as a solution to customers
Solution Provided
- Analyzed the modules in the product for SAAS ready operation
- Segregated SAAS convertible and Non-Convertible modules
- Identified options for Non-Convertible module usage in a SAAS environment – Add on to Browser or client configurable options were chosen
- Migrated to Open Source Suite for cost effective licensed based selling
- Introduced Multi-Server based Load balancing operation
- Analyzed the Infrastructure needs and built a plan around monitoring this for effective, efficient and timely upgrades
Business Impact
- Cost effective licenses
- Segregated costing for client configurable modules
- Faster Go To Market Strategy
- Effective load balancing enabling multi-users without impacting performance
- Easily deployable upgrades to the product without impacting the end users
Test Process Assessment for a Gaming Company
Business Impact
- Improve Go to Market Strategy
- Better control of the Critical Parameters
- Upskilling of resources enhanced
Top 5 Recommendations
Considering the Vision of the Organization along with the competency levels, current project execution levels and potentials, recommendations were provided to enable them align to Industry best practices
Problem Statement
- Reduce Defect Slippage to Production
- Improve Test Automation Maturity
- Reduce Test Cycle Time
Deliverables
- Project Level Test Assessment along with Strengths & Areas of Improvement
- Organization Level Test Assessment with Strengths, Areas of Improvement, Top 5 Recommendations
Continuous Learning Model
Problem Statement
- Skills are not focused as part of career growth
- Skills was focused only on current needs and not future
Solution Provided
- Showcased industry trends
- Skill evaluation (Online, Offline) across Beginner, Professional, Expert Levels on a periodic basis
- Skill upgrade (current needs and future needs) as part of career review – a KRA
- Targeted Training Modules for critical resources
- Online/Classroom Calendar based training
Business Benefits
- Regular upskilling of resources increased Quality and Productivity
- Industry trend based modules/curriculum enabled them to compete better in the dynamic market
- Effective utilization of non-billable time