*

GANAVI KRISHNAPPA

SR. BUSINESS INTELLIGENCE DEVELOPER

925-***-**** adcmkl@r.postjobfree.com

https://www.linkedin.com/in/ganavi-krishnappa-808b62104/ Objective

• Sr. Business Intelligence developer with 11 years of experience. Worked extensively on BI reporting & analytics, Business Intelligence & Data warehousing. Have worked on end to end Data warehousing projects. Have experience in ETL using Informatica, Reporting using MicroStrategy and Visualization using Tableau. Extensive database experience working on Oracle, Sql server, Teradata and Netezza databases. Experience in performance tuning of complex sql queries, analysis on large datasets, database analytic functions usage. Certified as Tableau Desktop Qualified Associate 2018.1. Intermediate level experience in Python programming and have completed courses on AWS. Strong analytical and problem-solving skills and able to quickly recognize, isolate, and resolve technical problems & develop deeper technical and business skills through self-study and proactive approaches. Skills

• Visualization: Tableau Desktop/Server

2018.1,2019.2

• Reporting: MicroStrategy Tool Suite 8.1/9.3/10.4

• ETL: Informatica PowerCenter 8.6/9.1, Informatica Power exchange 9.1

Education

Bachelor of Engineering: Electrical Engineering, 2008 Visveswaraya Technological University - Belgaum,

Karnataka, India

Accomplishments

• Bravo (On the Spot) Award in 2013

• Most Valuable Player Award in 2014

• The Insta Award in 2015

Certifications

• Database: Oracle 9i/11g, SQL server 2008 R2,

Teradata SQL Assistant, IBM Netezza

• Programming: Python (Intermediate level)

• OS: Unix, Windows 2000/ XP/10

2

• Tableau Qualified Associate 2018.1

• MicroStrategy Certified Project Designer 9.2.1

• MicroStrategy Certified Report Developer 9.2.1

• MicroStrategy Certified Document Developer 9.2.1 Courses:

• Tableau 2018 Advanced: Master Tableau in Data

Science - SuperDataScience

• Tableau for Business Analytics and Marketing –

SuperDataScience

• Python A-Z: SuperDataScience

• Introduction to AWS – Cloudguru

• Introduction to Cloud Computing – Cloudguru

• AWS Certified Solutions Architect - Associate 2019 Work History

Have been out of work after H4 EAD expired on Dec 29th 2019. It got approved on 2/28/2020 for till 05/31/2022. Senior BI Developer 06/2019 to 12/29/2019

Talen Energy – The Woodlands, Texas

• Worked with the key stakeholders in requirement gathering and business understanding to cater the business requirements well. Created low level design document and functional requirement document.

• Created interactive profit and loss dashboard, position report to replace the traditional excel reports. This report has interactivity to display data at various levels for different regions with required filters on the business units, trade types and all the required drill down.

• Created sets, actions, calculated fields, LOD expressions, Groups, hierarchies, table level calculations.

• Worked on data blending multiple source systems like oracle, sql server and excel file for reports, Union of data tables for tableau reports, worked on live and extract sources. Created Trend Lines, forecasting & statistics summary card. Created various types of filters in tableau, totals, followed sorting and best practices in Tableau.

• Worked on admin related activities like creating schedulers, user provisioning activities and access control on the projects and reports for users.

• Training business users on the dashboard usage. Worked on application aid document for helping users.

• Well verse in sql with all the required fine tuning or performance considerations required for custom sql source in Tableau.

• Created management dashboard & stories used by C level executives for the Financial snapshot of the company.

3

Tableau Certification 06/2018 to May 2019

Self-trained – Houston, Texas

• Created sample visualizations with various graphs like pareto chart, Bollinger chart, simple time series chart, heat map, scatter Plots, stacked Bars, Box and Whisker plots using reference lines/bands/distribution, Bullet charts, Heat Maps, histograms, Filled Maps, Symbol Maps.

• Blending, Cross database join, Joining multiple sources, union, pivot data, data prep for further analysis and visualization.

• Knowledgeable on custom geocoding, creating maps using map box maps or wms servers, working with spatial files.

• Perfect Pivoting with Cube data sources, Slicing filters, User filters for row level data security.

• Created worksheets, dashboards, stories. Well verse on optimization of workbooks, best practices of dashboards, handing different types of data sources, publishing data sources & workbooks to Tableau Server or Tableau Online, scheduling extracts refresh in Tableau Server, Tableau Online using Tableau Bridge.

• Creating dashboard layouts for different device types. BI Consultant at Bank of America 05/2017 to 04/2018 Diversant LLC – Concord, California

• Worked on the pilot project creating dashboard and stories using Tableau Visualization tool. Created Scatter Plots, Stacked Bars, Box and Whisker plots, using reference lines/bands/distribution, Bullet charts, Heat Maps, Histograms, Filled Maps, Symbol Maps. Well verse in Actions, Calculations, Parameters, filters, Background images, Maps, Map layering, Trend Lines, forecasting, statistics summary card, table level calculations, LOD expressions, Groups, hierarchies, sets, workbooks, dashboards & stories. Hands on experience on Data Blending, Cross Join, Union, Pivot Data Sources .Live/extract source, knowledge of products of Tableau, different file types in tableau, types of filters, Totals, Sorting, best practices in Tableau, Device designer, row-level Security, custom geocoding, tooltips. Created Tableau dashboard using excel data to arrive at the YoY trend analysis of the performance of various line of business (LOB)s at the bank. Worked on LOD expressions, groups, sets, parameters, filters, actions.

• Used MicroStrategy 10.4 suite Microstrategy Intelligence Server, Microstrategy Desktop, Microstrategy Web, Microstrategy OLAP Service, Visual Insights to create Reports, Documents, Dashboards, Dossiers including visualization, Intelligence Cube, Freeform sql reports, linking related documents for interactivity.

• Created Intelligent Cube based report, visualization based(dossier) on cube for the analytics users, created freeform sql reports, documents using reports. Created document-style dashboards with multiple datasets as sources and dashboards including charts like Vitara Pie, Combo, Maps, Heat map, Box plot, Vitara KPI, trend lines, reference lines, derived elements, derived metrics, use analytical skills for finding outliers in dashboards/reports used for decision making.

• Created Microstrategy Schema and Application objects such as attributes, facts, metrics, transformations, prompts, filters, consolidations, custom groups, hierarchy.

• Designed, developed, tested, and maintained MSTR reports based on user requirements.

• Utilize SQL skills and create simple to complex Schema objects as per the requirements.

• Work with complex Microstrategy reports using advanced filters, level metrics, transformation metrics, pass through functions in schema objects.

• Troubleshoot and tune Microstrategy reports to determine and fix data issues, incorrect joins and performance issues.

4

Technology Lead at Gap Inc 08/2013 to 05/2017

Infosys Ltd – Pleasanton, California

• Worked on Admin functionalities of MSTR such as ACL, Events, Schedules, Subscriptions and created Microstrategy Schema and Application objects such as attributes, facts, transformations, hierarchies, drill maps, tables, logical views, metrics, prompts, filters, consolidations and custom groups.

• Building reports using Metrics, Prompts, Relationship Filter & worked on DataMart report, Multi-Sourcing reports, Object Templates for adhoc report creation by Users, Intelligent Cube reports, Documents, Dashboards, Freeform sql reports, Datamart reports, Multi-sourcing reports.

• Troubleshoot high level issues to identify and resolve issues caused by functionality/Data issues/Performance Issues. (common examples: nulls in data causing joins to function incorrectly; Microstrategy Objects not set up properly).

• Troubleshooting, System Optimization, performance monitoring and sql tuning of MicroStrategy reports using VLDB settings at metrics/report (handling product join /Index creation on tables/Collect Stats on tables). Created time triggered and event triggered schedules, subscriptions.

• Trained less senior team members and business users.

• Worked on Flash Reporting for Black Friday used by Gap Management for decision making. Technology Analyst at Canadian Pacific Railways, Canada 01/2011 to 07/2013 Infosys Limited – Bangalore, Karnataka

• Involved in requirement gathering and design discussion for data load strategy for target tables. Worked on low-level & high-level design documents.

• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Normalizer, Source Qualifier, Union, Router, Stored Procedure, Rank, etc., transformations to implement complex logic while coding mapping.

• Developed mapplets, reusable Transformations, sessions, workflows, scheduling workflows.

• Worked on DBMS Constraint, Materialized Views, Table Indexes, Stored Procedures, triggers.

• Worked on Automation for tracking long running sessions in Informatica using Metadata Exchange Views.

• Tuned Informatica mappings/sessions for better ETL performance by eliminating bottlenecks. Involved in the optimization of SQL queries.

• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Business rules associated with ETL.

• Implemented restart strategy and error handling techniques to recover failed sessions. Assistant Engineer 06/2010 to 12/2010

KARNATAKA POWER TRANSMISSION CORPORATION LIMITED – Bengaluru, KA

• Determined budget, manpower, schedule and material needed to successfully execute projects.

• Handled administrative duties such as recordkeeping and ordering supplies.

• Performed load calculation for sizing wire and circuit protection.

• Applied principles of electrical theory to advance and improve product development and efficiency.

• Provided technical assistance to staff when needed. 5

Software Engineer 11/2008 to 06/2010

Infosys Limited – Bangalore, Karnataka

• Involved in Requirement gathering & documentation, Detailed design documentation for all workstreams.

• Worked on Slowly Changing Type2 mapping, required transformations for the mapping, session, workflow. Scheduling workflow, debugging mappings, optimizing mappings by removing ETL bottleneck.

• Worked on database objects like creating stored procedures, triggers, functions, views, sequences, materialized views, constraints on tables.

• Unit testing, Acceptance testing of all work streams & worked on post production related code fixes and documentation.

Contact this candidate