Resume

Sign in

Manager Data

Location:
Dubai, Dubai, United Arab Emirates
Posted:
October 28, 2018

Contact this candidate

Resume:

Shrilekha Mahalle

BI Consultant & Data Science Practitioner

Phone: +971-*********

LinkedIn: https://www.linkedin.com/in/shrilekhamahalle

Email: ac7izm@r.postjobfree.com

Burjuman Center,

Mankhool Area, Bur Dubai,

Dubai

Professional Summary

Dynamic and resourceful professional with 6.5 years of experience in interpreting & analyzing data for driving business solutions. Good understanding of business operations and analytic tools for effective data analysis

Played a stellar role in transformation of business requirements of customers into optimized MicroStrategy 10.x interactive Dossiers/iPhone/iPad/web dashboards

Certified Scrum Master with experience in working in agile framework

Proven ability to successfully implement the complete lifecycle of BI reporting in MicroStrategy framework

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables

Worked at logical/physical data model level using Erwin according to requirements

Well versed with the Extraction Transformation and Loading (ETL) process to ensure data availability and better performance of schema

Strong knowledge of Data warehouse concepts, design techniques, responsible for the relevant experience in RDBMS such as Oracle, Netezza, MS SQL Server, Teradata etc.

Expertise in creating normalized/de normalized schema using objects (Attributes, Facts, Hierarchies and Transformations, Logical Tables)

Troubleshoot and resolve performance issues like cross joins, loops and performance tuning of I Cubes, reports and documents using VLDB settings, table indexing, fact merging, partitioning etc. Recommended performance tuning changes using optimized SQL generation and relevant database improvements

Performed admin responsibilities such as Security Setup, User creation, object migration, Integrity manager test, process automation using command manager

Hands-on experience & knowledge of Transaction Services, Command Manager, Integrity Manager, MSTR Mobile

Exposure in overall SDLC including Requirement Gathering, Product Release Management, Solutioning, Data Analysis and Visualization, Designs and Wireframes, Change Management, UAT and live demo to business

Sound knowledge of other data visualization tools like Tableau, Qlikview, Power BI

Key Skills

MicroStrategy 10.x/ 9.x BI

Technical Troubleshooting

Schema Architect

MSTR Mobile Development

Data Analysis

Data Visualization

Analytical Reporting

Initiatives and Presentation Skills

Requirements Gathering

Technical Skills

Business Intelligence : MicroStrategy 10.x ( Report Services, Dossiers/RSD/Dashboards, Mobile, Architect, Desktop, Web, Intelligence Server, Object Manager, Command Manager), Business Objects

Data visualization: Tableau, Qlikview, Power BI

Data Science: Microsoft Azure ML(Beginner)

Data Modeling : ERwin, Normalized, De-normalized, Star & Snow Flake Schemas, Fact Tables, Lookup Tables and Drill hierarchy

ETL : Informatica, Alteryx (Beginner)

Programming: Advanced SQL, Python & R(Beginner), HTML, CSS and Java Script

Database: MS-SQL Server, Oracle11g, PostgreSQL, Toad, Redshift, Netezza, Teradata

Agile and Helpdesk Systems: BMC Remedy IT Service Management System, Rally

Certifications

MicroStrategy 10 Certified Specialist Analyst (MCSA) by MicroStrategy

Certified Scrum Master by Scrum Alliance

Binary Classification Model in Microsoft Azure Machine Learning by Udemy

Tableau for Data Science by Udemy

Intro to Python Programming for Data Science by Udemy

Big Data and Hadoop Essentials by Udemy

Career Achievements

Awarded as Honorary Mention for Load Status iPhone App at BMC Hackathon 2018

Awarded Outstanding Performance for consistently 2 years at BMC

Awarded as “Get it done” at BMC for ability to work in a fast-paced environment and meet tight deadlines of project

Received Third position for creating intuitive and interactive Hospitality dashboard for InfoCepts Data Visualization Contest 2014

Got appreciation from leadership team for conducting MicroStrategy Training Sessions within BMC

Achieved recognition by manager and team for quality work and initiatives taken in BMC

Achievements in MicroStrategy

Custom Metric Selector in Dossier / Visual Insight

Created a custom Geo locator widget for mobile

Default selection for a selector using URL API and HTML

Implemented out of box functionality to save and open personal view on click of button using URL API

Discovered a unique feature of MSTR for Checking dependents of table Columns through Registry Editor

Projects

Data Science Practitioner

Prediction of Life in Titanic

Oct 2018 –Present

This project involves prediction of whether you would have lived or would have died if you were aboard the Titanic disaster 1912. This is created in Microsoft Azure Machine learning cloud. I have used binary classification model to predict the probability of someone surviving if they had been aboard the Titanic.

Loaded and analyzed the .csv data (Kaggle dataset) and classified the data under numerical and categorical

Predict based on Accommodation Class, Age, Fare, Sibling, Parent & child your chance to survive

Worked on cleaning data and getting the missing data of important columns using median values

Splitting data and trained using Machine Leaning algorithm

Several models based on various classification method were trained and tuned using cross-validation

Using web service for trained model, completed the predictive analytics

Algorithm Used - Two Class Decision Forest Tree with precision of 80% and Area Under Curve 84%, algorithm for model comparison. Environment: Microsoft Azure ML, Kaggle Dataset

Credit Risk Prediction and Self-Assessment

Sep 2018 – Oct 2018

Credit risk prediction is an effective way of evaluating whether a potential borrower will repay a loan and helps lower the risk of default on debt. The model in Azure is created using the Two-Class Support Vector Machine and trained on the replicated (cost-sensitive) training data set provided the best accuracy.

Loaded and analyzed the .csv data (German Credit Card data set from the UC Irvine repository) and did data processing

Worked on cleaning data and giving meaningful names to features using Edit Metadata of Azure

Replicated the high risk data 5 times using R script

Split data and trained using Two-Class Support Vector Machine model

Converted it to Predictive model to do self-assessment of given data

Algorithm Used - Two-Class Support Vector Machine with cost-sensitive accuracy of 70%

Environment: Microsoft Azure ML, R Script

Employer: BMC Software

BI Consultant

April 2015 – May 2018

Renewal Rate

Dec 2017 – May 2018

This dossier makes the company to identify renewal rate of each product when it gets sold or renew to customer. Calculates various complex metrics which will give idea about the new rates or discounts given to customer.

Worked closely with the business to Gather, Review, Validate and Document the Business Requirements

Developed architectural framework for MicroStrategy components.

Reviewed data models and provided recommendations for optimization

Analyzed Business needs and deliver the insights in dossier as well as mobile

Architected 400 entities in schema using Command Manager in 2 weeks agile fashion

Suggested and Implemented valuable workaround for Metric Selectors in Dossier

Used the VLDB properties for performance tuning and SQL optimization.

Investigated and analyzed critical data quality issues and provided resolutions to that issues which are reported by analysts and functional stakeholders

Embed hand-crafted SQL statements directly into the Microstrategy BI platform using The Freeform SQL editor

Proactively raised and improved the data quality issues by using SQL

Coordinated with ETL team to design flexible and scalable data models

Experienced administrative capabilities; Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management

Environment: MicroStrategy 10.11, Netezza,Informatica

ESO Pulse iPhone Application

Sep 2017 – Dec 2017

This is ESO Executive Summary iPhone application built using excel data source and MicroStrategy reporting tool. Alteryx is used as data preparation tool in this project. This application developed for 5 screens -Executive Summary, Financial Performance, Customer Experience, Product Innovation & Growth Strategy

Involved in requirements gathering and clarifications from client

Created UI Designs for the iPhone dashboard and presented to customers

Designed and developed extremely beautiful and fast MicroStrategy iPhone application using images, widgets, information windows and various selectors

CFO’s benefits from project - Got business metrics at his fingerprints at any location

Environment: MicroStrategy 10.9, Netezza,Alteryx

Info Load Status iPhone Application

July 2017 - Sep 2017

This mobile application will be useful for the Business Users to know the data availability in Enterprise DW, so that they can prioritize their business processes efficiently. This application developed for 4 screens – Welcome, Overview, Current Load Status, Trend

Created complex SQL to fetch data from Informatica Repository

Implemented various KPI’s and developed,tested MicroStrategy pixel perfect mobile application

Investigated, documented, and implemented requests for new additions to database tables based on business requirements from the business owners

Worked on Transaction Services

Demo of Mobile Application to BMC Solution Delivery Heads

Mentored a team of 3 interns and provided technical directions on data warehousing and mobile reporting

Environment: MicroStrategy 10.9, Netezza

YTD Roll forward RSD

Feb 2017 - July 2017

This RSD gives ability to business to analyze roll forward for deferred revenue from year to date perspective. It also gives metrics like Beginning balance, Additions, Recognition from Deferred, Currency impact of converting to USD, Ending balance in their quarter end financial activities.

Worked with business users to collect the requirement and definitions of finance metrics

Created complex metrics and advanced qualification filters to calculate business definition

Validated the SQL and report results using specific business scenarios

Developed RSD using multi datasets and data blending feature

Conducted regular demos for end users

Environment: MicroStrategy 10.3, Netezza

FY18 Product Hierarchy Changeover

Jan 2017 - April 2017

This project include new product and sales hierarchy changes to the existing source systems.

Responsible for understanding the requirements from business and writing epics and user stories

Developed business architecture using requirements such as scope, process, alternatives and risks

Involved in creation of Business Requirement, Strategy planning and Functional Requirement document

Involved in Impact Analysis for Enterprise Project using Command Manager Scripts

Facilitated monthly meetings with users to document and explore potential solution

Conducted 5+ levels of testing including functional, regression, user acceptance, integration and performance to ensure the customer’s needs are met

Coordinate with other applications team for the changes and UAT approval

Environment: MicroStrategy 10.3, Netezza

BO2M Migration Project

April 2015 – Jan 2017

The Business Objects to MicroStrategy) project is using a phased approach to migrate current internal Business Objects Universes to a new enterprise Business Intelligence (BI) reporting platform called MicroStrategy

Involved in requirements gathering and clarifications from client

Interacted with the data modeling team for the Logical and Physical model design

Worked with VLDB properties which improved the performance of reports from minutes to seconds

Developed schema with proper parent-child relationships

Created complex filters with advanced qualification involving 'ApplySimple' and 'ApplyComparison' functions.

Worked on understanding reports of SAP Business Objects, Crystal Reports and converting into MicroStrategy Layer

Experience in integrating MicroStrategy functionality into other applications (portal Integration): Displaying MicroStrategy Data within Salesforce

Conducted 5+ levels of testing including functional, regression, user acceptance, integration and performance to ensure the customer’s needs are met

Developed RSD’s using multi datasets and data blending feature

Involved in MicroStartegy Upgrades ( Version 10 to 10.3 and version 10.3 to 10.9)

Environment: MicroStrategy 10, Netezza

Employer: InfoCepts Technologies

Associate Consultant

March 2012 – April 2015

Numerify

Oct 2014 - April 2015

This project involves development of various dashboards such as Finance Dashboard, ITSM Dashboard, and CRM Dashboard in MicroStrategy 9.4.1. These dashboards will be used by the senior executives for analysis

Involved in requirements gathering and clarifications from client

Solution Architect for Reporting

Analysis of mockups and performed gap analysis

Created a MicroStrategy Mobile Apps and Dashboards with proper look and feel

Customized and optimized reports for users using MicroStrategy features like VLDB properties at project and report level

Configured Enterprise Manager and developed customized reports to depict the usage and performance of dashboards, user activity and cache analysis

Environment: MicroStrategy 9.4.1, Oracle

Biltmore Technologies, Mobile App

Jan 2014 - Oct 2014

The Mobile App in MicroStrategy is an important app which provides sales and performance data for the Incivek drug. The data for this app is updated on a weekly basis and is viewed by different levels of business users within the organization.

Involved in requirements gathering and clarifications from client

Created Source to Target mapping document by checking complex SQLs

Developed MicroStrategy pixel perfect mobile application

Conducted 5+ levels of testing including functional, regression, user acceptance, integration and performance to ensure the customer’s needs are met

Environment: MicroStrategy 9.4.1, Teradata

Standard Chartered Bank, WB HR Project

Sep 2013 - Jan 2014

WB HR is the Human Resources department of Wholesale Banking division of Standard Chartered bank. This project involved development of a set of RSD documents and dashboards in MicroStrategy.

Involved in requirements gathering and clarifications from client

Highly Helped business users to analyze such as compensation, benefits, recruitment, fulfillment ratio, attrition etc.

Analyzed data load strategy with possible scenarios

Developed MicroStrategy pixel perfect web dashboard

Conducted 5+ levels of testing including functional, regression, user acceptance, integration and performance to ensure the customer’s needs are met

Worked with business to elicit high-level requirements and capture business needs for preparation of business requirement document, FSD, TSD, Security Matrix, User list

Environment: MicroStrategy 9.4.1, Oracle 10g

Standard Chartered Bank, Group HR Project

July 2013 –Sep 2013

Group HR is the strategic Human Resources function which operates at Standard Chartered group level. The aim of this project was to develop a comprehensive MicroStrategy dashboard which would provide better analytical capabilities and better visualization of statistics of Group HR Head Count Data to the executive leadership of the bank.

Developed schema, designed mockups and developed dashboard

Performed ETL scripting for oracle Database (Staging Area) since source was “.csv” file

Designed Dashboard Mockups and developed dashboards

Implemented Manual SQL scripting for Data Testing, ETL and validation on Oracle 10g DB

Configured Mobile server and Intelligence server

Worked on optimizing the performance of the dashboard using Enterprise Manager, Diagnostic tool

Environment: MicroStrategy 9.4.1, Oracle 10g

MicroStrategy Interactive Mobile Applications

May 2013 – July 2013

Payments Insights (Corporate Banking Transaction)

Using this Mobile App, the executives from transactions department can view and analyze their bank’s transactions. This is deployed on MicroStartegy App Store

Market Basket Analysis

Using this Mobile App, the planners, merchandising teams and product teams can make decisions about promotions, displays and product placements, store segmentation, customer segmentation and targeting. This is deployed on MicroStrategy App Store

Treasury Management App

Using this Mobile App, the head of treasury to measure the performance of the Proprietor and Client Desk for FOREX, interest rate, money market and derivatives to corporations and financial institutions

Achievements

This mobile apps are deployed on app store of MicroStrategy Analytics Mobile Platform

Reduced the 72 number of datasets to 17 by aggregating the datasets in short span of time

Fixed the complex issues raised by MicroStrategy and delivered the high-performance mobile application

Restored the database from one machine to another machine SQL Server using scripts

Worked on setting up Mobile Configurations

Implemented automatic switching from Landscape to Portrait in mobile using manage views

Learnt and implemented BFSI domain knowledge

Developed schema, designed mockups and developed dashboard

Environment: MicroStrategy 9.4.1, Redshift, SQL Server

Merrimack DW and Reporting

Dec 2012 - May 2013

ZS Team is a partner to Merrimack’s Pharmaceuticals data solutions. This dashboard has KPI which are based on the performance of the newly introduced product “Onivyde” in the market and detailed information about the Accounts and Practitioners involved in the Sales of the product. This enables detailed analysis as well as support to the decision making.

Worked from onsite location for client, involved in requirement gathering and clarification from client

Designed Dashboard Mockups and developed dashboards

Developed schema and application objects in MicroStrategy

Implemented Security based on the Users and Geographies

Implemented Manual SQL scripting for Data Testing, ETL and validation on Oracle DB

Fixed the schema, dashboard, performance related issues

Helped ETL Team in designing tables in warehouse

Environment: MicroStrategy 9.4.1, Oracle 10g

Highmark, Credit Information Company

March 2012 – Dec 2012

This dashboard is for Indian Credit Information Company which keeps a record of loan repayment history on credit facilities extended to an individual across the board. The project helps lenders analyze the risk profile of individuals before extending credit. This also keeps non-performing loans in check.

Involved in database analysis

Analyzed the data and suggest reports/dashboards which can be built to do better risk management

Developed schema and application objects in MicroStrategy

Implemented Manual SQL scripting for Data Testing, ETL and validation on Postgre SQL

Learned and implemented banking domain knowledge

Environment: MicroStrategy 9.4.1, Postgre SQL

Educational Qualification

Bachelor of Engineering in Electronics and Telecommunication Engineering, Amravati University, Maharashtra

Date: 25 October 2018

Shrilekha Mahalle



Contact this candidate