Varun Sriram

• Investigated the product sales to determine marketing strategy and to improve store revenue.
• Analyzed 5296 Sales Transactions with 32 Product Categories.
• Performed Segmentation using Latent Gold based on customer buying behavior, marketing expense, and other KPIs.
• Analyzed 5296 Sales Transactions with 32 Product Categories.
• Determined Product bundles for each customer segment using Market Basket Analysis.
• Analyzed Product Sales behaviour using Elastcity.
•… Show more

• Investigated the product sales to determine marketing strategy and to improve store revenue.
• Analyzed 5296 Sales Transactions with 32 Product Categories.
• Performed Segmentation using Latent Gold based on customer buying behavior, marketing expense, and other KPIs.
• Analyzed 5296 Sales Transactions with 32 Product Categories.
• Determined Product bundles for each customer segment using Market Basket Analysis.
• Analyzed Product Sales behaviour using Elastcity.
• Proposed Efficient Marketing Expenditure Plan using Marcom Analysis.
• Finally, Recommended strategies created for each segment to increase revenue

.
Show less

•Designed and developed primary DW using Microsoft SSAS and SSIS.
•Created OLTP system on Microsoft Server SQL 2012.
•Designed SSAS cube to perform MOLAP operations, identifying critical parameters in the data.
•Exported final report to Microsoft Excel and designed a PIVOT chart for visualization of results.

• Create and evaluated a conceptual data model for American Insurance Company
• Converted conceptual data model into a normalized physical relational database
Structure using MSVisio
• Designed and created a database using MS Access SQL database platform.
• Designed forms for data entry and configured UI Screen for data retrieval using MS Access SQL Statements.
• Configured application to generate reports on various filters viz., state wise claim amount for different types of… Show more

• Create and evaluated a conceptual data model for American Insurance Company
• Converted conceptual data model into a normalized physical relational database
Structure using MSVisio
• Designed and created a database using MS Access SQL database platform.
• Designed forms for data entry and configured UI Screen for data retrieval using MS Access SQL Statements.
• Configured application to generate reports on various filters viz., state wise claim amount for different types of insurance, report showing aggregate of claim and release amount and report showing number of polices for an agent.
• Configured to send email to customers on a trigger.
Show less

•Designed an advanced filter to identify and analyze small transactions.
•Created pivot tables and charts to find most lucrative region from a sales perspective.
•Analyzed sales transaction activity level peaks.

• Developed Natural User Interface (NUI) using Kinect for Windows.
• This application developed based on Kinect Skeleton tracking and face tracking.
• This application does STT (Speech to Text), implemented using Speech Recognizer Engine.
• Designed NLP (Natural Language Processing) algorithm to process user commands with throughput less than 30s.
• All the mouse functions are implemented using Kinect SDK.

This Project is selected for Intel App Innovation Contest.

•Connected Spreadsheet as data source to Tableau.
•Created calculated fields and analyzed job growth during economic recovery.
•Created heat map in Tableau to compare job growths in different states.

Windows Phone Application

• A Notetaking Widows Application.
• Various forms of input include Text, Voice, Speech To Text, free hand writing.
• Implemented windows charms share which enables user to share notes instantly on a click.
• Rated as Most Useful Utility by Widows User Community.

Windows Phone Application