o Working in a leading bank in SEA using powerful data mining algorithms to find best automation release logs using engineering data in real time.o Led initiative to build statistical models using historical data to predict release automation in several dimensional approaches. Focused on analyzing the factors affecting the volume of release across LOBs and regions.o Developed prediction modelling using advanced data mining algorithms to classify similar trends together to identify pros & cons.o Used R programming for predictions and trendso Used rattle package to find – Correlation (Pearson) Associate rules Decision tree technique (from root to terminal nodes) K-Means clusteringo Conducted data preparation, and outlier detection using MongoDB, XML & APIs; built the model using R.o Created and presented executive dashboards and scorecards to show the trends in the data as well as Green $ and Blue $ savings using Excel and VBA-Macros.o Managed data operations team and collaborated with data warehouse developers to meet business user needs, promote data security, and maintain data integrity.o Consulted with and developed to effectively access data and optimize QlikView, High Chart & Power BI dashboards.o Maintained multiple QV Scripts to create and populate tables in data warehouse for daily reporting across departments.o Developed QVDs and ETLs for data sources used in production reporting for management & internal teams.o Created customized reports and processes in R and QlikView / QlikSense and Power BI Desktopo Promoted enterprise-wide business intelligence by enabling report access in QlikView Access Point and on High Chart online as well as Power BI desktop.

Responsibilities: Provide consulting services on o business intelligence, business analyticso Data Analytics o Data warehousing & ETLo Setup BI / DW software & hardwareo BI project management & delivery optionso Pre-sales and Proof-of-Concept / Seeing is BelievingRole Company / Industry Tools & methodology usedProject Manager / Consultant Ryobi / Construction QlikSense, ACCPAC, Navision, Project Manager / Consultant Beste / Retail distributors QlikView, ACCPACProject Manager / Consultant IIa Technologies QlikSense, SQL ServerProject Manager / Consultant India International Insurance QlikView, SQL ServerProject Manager / Consultant Servier / Health Care QlikSense, EasyMedProject Manager / Consultant Association of Muslim Professionals QlikSense, .Net, SQL Server

• Create & maintain QlikView dashboard and reports using QV11 for corporate BI / data analysis on the following areas:o Revenue & Gross Margin Analysiso AOP (Annual Operating Plan), Commit, and Revenue transactions o DSO (Daily Sales Outstanding)o DRQ (Design Request)o RFP (Request for Pricing)o RFQ (Request for Quotation)o RFI (Request for Information)o SQS (Sales Quote System)o Win/Loss reports on SQSo Material Management & Usageo PTM (Product Technology Marketing) • IBM Cognos TM1 on demand forecasting and predictive analysis• Gather requirements, do POC on BI solutions, involve in development and maintenance, successful roll-out of projects, follow PMP methodology on all stages

Analyze product brand & loyalty details and provide revenue opportunities & solutions :• Work with OR (Original Rewards) project team for the BI & reporting solutions• Analyze data and build data analysis solutions• Build OLAP & data cubes for analysis purpose• Do presentation on charts and diagrams for the business analysis• Work with the team on the requirement gathering, provide data analysis solutions, build reports & dashboards, backend support

• Provide BI & Reports solutions for the clients• Create QlikView data model, reports and dashboard for the clients• Analyse data and perform data cleansing for the effective data analysis• Gather requirements and do pre-sales activities on QlikView v.4.5• Handle databases - MySQL, SQL Server, Oracle, MS Access and other RDBMS• Implement QlikView solutions by server setup and management, report distribution and data security for the clients

• Analyse the source data on Sales, Order, Inventory, Delivery data which are loaded in the Corporate Data Warehouse• Liaised with the source data developers in Australia to enhance the performance of the SQL queries which are run to generate the flat file (.csv format) and dump the same to the Informatica Server (FTP Directory) & SQL Server• Used Flat File and relational database as the sources for the Informatica and SSIS ETL process.• Assisting other team members in the whole process and phases of the project• Involved in coding, testing and implementation. Also maintained the various instances of the database schema.• Involved in developing and coding various Modules which are the integral part of the project. • Create and execute complex stored procedures to do the data cleansing and for easy loading.• Single point of contact for all the technical questions related to the project.