Jul 2014 – Oct 2017 · 3 yrs 3 mos · Bangalore

• I was part of one of the challenging projects by name MVRIS for SMMT. The Society of Motor Manufacturers and Traders exist to support the interests of the UK automotive industry at home and abroad. Working closely with its member companies, SMMT acts as the voice of the motor industry, promoting its position to government, stakeholders, and the media.
• The complete BI solution, along with the application development, leads the manufacturers to create/amend the variant, dealership, area, postcode, user defined calendar, report schedule, create ad hoc reports from the application, registration file import, and report delivery.
• I was one of the architects for a complete solution design that includes OLTP database design, OLAP database design, and reporting architecture design, along with leading the BI team.

Jun 2009 – Jul 2014 · 5 yrs 1 mo · Bangalore

• I was part of the Volt Data warehouse team, which is a repository of aggregated, normalized transactional data. The complete BI solution leads the industry in facilitating impact analysis, cause-and-effect review, and in identifying critical program areas that can benefit from improvements in such areas as bill rates, cycle times, supplier performance, quality, and compliance.
• I was involved in dimension modeling, OLAP cube design, ETL framework design, and designed many reports using SSRS, PerformancePoint Services, PowerPivot, and PowerView.

Nov 2007 – Nov 2008 · 1 yr

• I was part of the development of the web analytics product by name iAPPS Analytics. The application has many KPI, such as exit pages or top pages, to determine how and when changes to web content impact analytical results. For example, an exit page report will illustrate the trend in how frequently users exit a website from a particular page and if a change in that trend, negative or positive, correlates with a published modification to that page. Also, it offers superior visitor loyalty reporting as well as an improved analytics dashboard with graphical enhancements that provide quicker access to meaningful analytical data results.
• I was involved in data warehouse design, OLAP cube design, ETL framework design, and MDX query design to use in the application.

Mar 2006 – Nov 2007 · 1 yr 8 mos · Bangalore

• I was part of product development in the retail apparel industry. The application provided information that is critical at any given point of time to facilitate in understanding program status, merchandise planning, building marketing strategies, customer purchase behavior, purchase patterns, seasonal trends & revenue inflow, and many more.
• I was involved in application design using .NET, OLTP, OLAP data model design, ETL, Cube, and reports design.
• The market basket analysis, footfall analysis, square feet analysis, top and bottom selling product behavior analysis were highly appreciated in this application.