Architect
Dubizzle, (Part of OLX Group)
Total des années d'expérience :15 years, 0 Mois
Leading and managing BI Team for Dubizzle, the leading classified marketplace in the UAE. Managing off-shore and onsite
team to deliver BI and ETL projects. Extensively worked with AWS services for Data warehousing projects.
● Led the team to deliver dashboards and data analysis to the management on user behavior and funnel
analysis for critical decision making of the business
● Led project on data science/Machine Learning to generate price prediction and recommendation of similar
listings to the users
● Worked with performance marketing, and product development teams to get BI insights to the management
● Worked with tools including Pentaho, MicroStrategy, Redshift, Spectrum, Athena, presto, Jenkins to deliver BI
requirements
● Worked on user-generated data as well as data generated from various trackers in the site to get the analytics
● Developed client’s utilization and performance dashboards
● Developed a unified view of the customer across all the channels and made the sales team to make better
decisions in negotiations with the clients
Developed and implemented Data warehousing and Business Intelligence (DWBI) resources and solutions for international property development firm, to extract and utilize information for effective decisions on business projects. Led the development team as BI Architect, Design data models. Developed ETL ( Extraction, Transformation, and Loading ) packages, dashboards using various tools and diverse technologies. Evaluated various BI and analytical tools.
Developed Footfall and Sales IPad dashboards, and apps for mobile phones using SDK. Utilized Google maps and visual insights dashboards based on OLAP cubes
Developed Tableau dashboards for the sales department, and performed training business users for its utilization
Utilize Radiant 6, and social media analytics for sentiment analysis
Work with R language
Administer and support Cognos environment
Converted and migrated over 100 reports from Cognos to MicroStrategy environment
Developed ETL package for Oracle HRMS ERP application, using Informatica Power Center 9.5
Implemented Big Data use case as POC.
MicroStrategy
Developed projects for clients of Marketing Services Company that provide solutions to help small businesses to
collect, analyze and utilize information to succeed and grow. Led five-member team.
● Built a KPI Sales reporting project from inception. Analyzed data, and worked with business users to define
requirements. Designed architecture, developed, implemented and administered the system
● Designed MicroStrategy Schema objects such as Attributes, Facts, Hierarchies, and Transformations
● Used MicroStrategy Narrowcast Server and provided self-subscription capabilities and delivered
personalized content to the subscribers. Conducted data validation testing to ensure quality
● After deployment, administered, monitored and maintained the system
Oversaw and implemented major upgrades in reporting systems to clear inconsistencies in gross margins, and to
report physical inventory requirements. Administered and supported environment. Upgraded company’s
MicroStrategy system from 8.1.2 to 9.0.1.
● Administered system and maintained security. Created users, assigned privileges, managed caching, specified
query governing thresholds, and optimized reports. Used and configured LDAP server for authenticating
users of MicroStrategy tools, and imported user groups from LDAP server to I-server.
● Maintained environment. Managed connection mappings,
● Migrated objects between environments.
● Backed up data in SQL Server database.
● Researched and resolved issues related to warehouse tables, metadata platform, missing columns, and other
conditions.
● Used transformations to perform time-series analysis over various phases, and calculate variance and growth
percentage trends.
For motion picture studio, managed MicroStrategy project to develop financial reports and develop dynamic
dashboards. Also worked on an initiative to enhance Paramount’s home entertainment business. Trained other team
members on the functionalities of MicroStrategy tool suite.
● Developed Static and Ad-hoc reports using prompts, metrics, filters, custom groups for consolidations and
transformations
● Created transformations for comparative reports for sales and other information
● Worked on troubleshooting MicroStrategy Web Reports, and optimized the SQL using the VLDB Properties
Ramps International, Edison, NJ, US 2009 - 2010
Business Intelligence Consultant - as Internship and pre-OPT when in college
Led project to develop easily accessible reports for process improvement and cost reduction. Designed and generated
reports for sales and finance teams, and trend-based reports for forecasting.
PRANEETH GANDE Resume, Page 3
● Created all possible metrics for users to build their reports on The Web by creating their templates and filters
using the available metrics. Created different transformations for transactions, to effectively use them with
metrics. Developed dashboards and scorecards for visualization
Designed, developed and managed a supply-chain data warehouse and implemented on MicroStrategy Intelligence
Server/Web and DB2.
● Used MicroStrategy Narrowcast Server to provide self-subscription capabilities and to deliver personalized
content to the subscribers. Involved in installation and configuration of the Narrowcast Server and performed
various tasks to enable subscriptions and other features.
Computer
Electrical and Electronic Engineering from Vaagdevi College of Engineering Warangal