Business intelligence consultant

a)	Performance Optimization (Sky Italia)
•	Responsible for performance optimization to significantly reduce report execution time from 15 hours to 3 hours.
b)	Platform Migration (Sky Italia)
•	Migration of existing set of reports from BO2 to BO 4.
•	This activity involved adapting and redesigning reports to make them efficient and functional in BO 4.
c)	Reports Redesign (ACEA)
•	Redesigned the report user interface to align with new business requirements using QlikSense.

a)	Risk Foundation Discovery Platform
•	Designed and developed an enhanced Basel III Credit Risk Reporting System for a global Tier 1 bank.
•	The Risk Foundation platform won two awards at The Asian Banker Risk Management Awards 2017:
-	Compliance Risk Technology Implementation of the Year
-	Risk Technology Implementation of the Year
•	Implementation done in collaboration with Moody’s Analytics using Qlikview 11.
•	Integration of custom reports into the Risk Discovery Suite with data volumes of over 500 million records for a year’s data.
•	End to End software development responsibility from requirements gathering, design to production deployment.
•	Close working relationship with senior management, business users and vendors across multiple countries.
b)	Performance Management Information
•	Group Performance management information infrastructure to support the wide range of reporting needs for a global Tier 1 bank.
•	Key analytics system providing golden source of Client / Transaction level revenue and combined risk and return view at individual Contract level
•	Designed and developed the revenue distribution between anchor and spoke for the PMI platform using PL/SQL (ETL) and OBIEE (Reporting)
c)	Pre Sales Engagements using Microsoft Azure and Power BI
•	Designed and created pre sales proposals for prospective customers.
•	Created various proof of concept implementations using data from Oracle ERP Framework including General Ledger, Procurement, Purchase Cycle, Sales Cycle and Order management
•	Integration of D3.js charts with Power BI for property management analytics.
•	Proof of concept implementation of IOT based real time analytics using Microsoft Azure and Power BI.

Assistant Vice President                           Feb’2013 to Oct’2015

a)	Client Profitability
•	Complete End-to-End responsibility and ownership of Equity and Fixed Income products application which would give a holistic picture of client’s profitability with a view to client’s revenue and expenses across different comparative metrics and ratios.
•	Primary responsibilities are designing expense model and cost calculations from the ledger file and further allocation of individual cost at client level based on different cost drivers.
•	Trusted technology focal for business to interact, solution requirements and drive solution design to closure.
•	Additional responsibilities include leading a team of 5 people and managing quality deliveries to meet cost and delivery timelines. This also includes a team that generates pre-canned reports.
•	The application is built using Qlikview reporting tool with extended features of comparative analysis, what if scenario analysis, reconciliation to books, benchmarks and performance analysis, time survey, pricing models.
•	Metrics measured across different parameters of product, region, tiers, client types includes:
	Expense: BCE ,Support Costs , Trading , Sales , Research
	Inventory and Finance Balance Sheet
	Risk weighted assets
	Margins and Wallet Gap analysis 

•	Tools / Database Used: Qlikview 11, Sybase IQ 
•	Qlikview Expertise involves:  Script development, Integration of Extension objects, development of dashboards on Mobile /Desktop version,  features like Comparative analysis , what if scenario analysis, benchmark screens, extensive use of aggregate functions and set analysis, incremental loading and data performance, managing server/ document Cal licenses using qmc, distribution of reports with publisher, SVN integration with Qlikview.

b)	Qlikview License Analyzer 
•	Designed and built an inventory application which tracks all the license information of Qlikview servers. 
•	This application is being widely deployed and used in the organization with significant realized monetary saving from 600+ duplicate and unused licenses.

c)	Reporting Strategy Task force
•	As part of the reporting strategy task force, my responsibilities were to create an evaluation matrix on comparison of different reporting tools like Microstrategy, Cognos, business objects, qlikview.
•	This evaluation matrix also involves integration of Nprinting with Qlikview reporting tool.
•	Within the market sales organization, this matrix is used extensively to evaluate suitability of reporting tools for a specific unit/subunit.

a)	Open wave 
•	Openwave Inc. is a leading provider of different telecom solutions in the fields of Location, Messaging, Mobile Advertising and Mobile Browsers.
•	I was the prime focal for Telstra account including interacting with the customer and prompt resolution for customer queries and issues. Handled team size of 4 people.
•	My roles and responsibilities were data modeling, create ad hoc universes, built custom and pre-canned reports, performance tuning of existing reports, handling roles and securities, scheduling and distribution of reports.
•	Tools used : Business Objects XI 3.1
b)	Intuit 
•	Intuit Partner Platform enables developers to create new innovative applications for small businesses and consumers by providing access to powerful data and platform APIs
•	I was responsible for developing reports in Qlikview for IPP and also build a data warehouse and provide analytical dashboards on IPP. These dashboards were available on iPad and smart phones for the management team. Handled team of 6 people.
•	Tools used:  Pentaho Data Integrator (Kettle), QlikView 11.
c)	Satyamev Jayate 
•	India’s hugely popular reality talk show, Satyamev Jayate prompted viewers to share their experiences, views and comments on the social issues discussed on the show.
•	I was responsible for creation of dashboards in Qlikview. The dashboards presented the relevant data with analytical information across various access media such as iPad, web browser and smartphones. 
•	Scope of work in Qlikview involved creating dashboards, handling access restrictions, use of web extensions and embedding d3.js advanced charts to the dashboards.
•	Tools used: Qlikview 11
d)	iPayment
•	iPayment provides payment processing solutions across all industries.
•	My scope in this project was to predict the churn of merchants every month.
•	Tools used: WEKA , TreeNET (Salford Systems)-Predictive Modeling Suite
e)	HeartBeat
•	Heartbeat Experts’ Key Opinion Leaders or KOL data analytics are designed to help life sciences companies identify, manage, profile, and communicate with their key opinion leaders. The analytical services provide logically-structured view of all company Key Opinion Leaders segmented by brand, therapeutic area, region, role, and level of influence.
•	I was responsible for automation of the existing code and design the data model of the data services module, leading a team of 8 people.
•	Tool used: SQL Server Integration Services (SSIS)

PDS Operational Reports 2008B Release
•	This project adds operational reports to 2008A PDS DQ related to the areas like Paper Medical Record Administration, Analysis of PMR Transfer process, EMR Transfer Monitor and Tracking, Cross border Medical Record and Cross Border Deaths, GP Service User list Assignments.
•	I was the core member of the design team and requirement analysis for the project. Interacted with customer for requirements, validation, designing and customer training.
•	I worked on building adhoc universes, customization of reports using JAVA SDK, customization and implementation of bar code, role based access restriction of prompts, integration of crystal reports and use of business views.
•	Tool used: Business Objects XI R2, Crystal Reports.

a)	Enhanced Reporting Services (ERS)
•	ERS provides mechanism for non/near real time reporting in the areas like Views for non-clinical reporting, Restriction of sensitive and non-sensitive data, Audit report changes, Adhoc reporting.
•	I was responsible for developing 2 adhoc universes with end to end responsibility including client interaction, requirement validation and deployment. 
•	Tool used: Business Objects XI R2

b)	PDS Operation Reports 2008A Release
•	PDS DQ 2008 A provides operational reporting to monitor and support quality information on personal demographic services.  The reporting area focused on aspects like analysis of PDS data by age bands, monitor pharmacy nominations, NHS number allocations, changes to birth data received from NN4B, fulfillment of data protection act subject access report. 
•	I was responsible for developing pre canned reports and deploying the code to the production environment. I was also involved in the analysis and implementation of performance improvements on BO report queries.
	Tool used: Business Objects XI R2