VENKATA SUNIL KISHORE
Summary
Prudent Business Intelligence Analyst with 8 years providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.
Overview
8
8
years of professional experience
1
1
Certificate
Work History
Sales Analyst
Musarubra Software India Pvt Ltd
Bangalore
03.2021 - Current
- Database and Flat file Connection to Power BI and create Data model as per requirements and build Reports
- Create Package and map flat files in server location and creation Source and destination connection to load data to Datamart using SSIS
- Go To Market Functional Analysis
- Also part of data migration from development to staging and then staging to Production environments
- Designed advanced conceptual, logical and physical data organizations models, repository, dashboards, reports using Power BI within complete architecture
- Work regularly with Product stakeholders and support
- Prepared database objects like tables, views, materialized views, procedures and packages using
- Environment: Power BI, Oracle OBIEE12.2.1.0.0, MS SQL Server 2017,Clari, Sales Force, Qlik Sense, MS Office.
Data Analyst
Catalog IT Solutions Pvt Ltd
08.2017 - 07.2020
- Created databases and schema objects including tables, indexes and applied constraints, connected various applications to database and written functions, stored procedures and triggers
- Generated periodic reports based on statistical analysis of data from various time frame and division using power pivot, power query, power view
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
- Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to decision makers for strategic planning
- Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
- Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis
- Environment: Power BI, MS SQL Server 2017, MS Office, SSIS, MS SQL Server 2012, Oracle 11g, Toad, Linux.
SR. Consultant
Aufait Technologies
07.2016 - 01.2017
- Developed technical solutions to business problems in OBIEE repository
- Imported data from Oracle to OBIEE and developed all three layers
- Also part of data migration from development to staging and then staging to Production environments
- Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables
- Enhance performance by creating Aggregate tables, Indexes and managing Cache using OBIEE Administration tool
- Involved in defining system requirements, designing & prototyping, developing, testing, training and Implementation of the applications
- Interacted with Procurement and Operation/Maintenance business representatives for gathering OBIEE Reports/Dashboards requirements and to define business and functional specifications
- Developed repository model for different work streams with necessary logic that involved creating Physical, BMM and Presentation layer
- Also created hierarchies, variables, and event poll strategies in repository
- Configured OBIEE for LDAP Users
- Creating Dataset and RTF for BI Publisher Reports
- Inserting BI Reports URL in ADF portal page
- Adding BI Reports in Share Point Public Page
- Environment: Oracle OBIEE11.1.1.7.1,Oracle 11g, Toad, Linux.
Sr.OBIEE Consultant
TruGlobal Software India Pvt Ltd
Bangalore
11.2015 - 06.2016
- Used the OBIEE Administration tool to develop and enhance meta-data
- Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
- Configured and Created repository using OBIEE Admin tool
- Create/Modify Metadata repository (.rpd) as per the data requirements by using Oracle BI Analytics Server Admin tool
- Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer
- Worked on setting up Dimensional Hierarchy
- Created numerous executive level reports
- Involved in defining system requirements, designing & prototyping, developing, testing, training and Implementation of the applications
- Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables
- Involved in modifications of physical, business and presentation layers of metadata repository using Administration Tool
- Identified the aggregate levels for each source and created dimension sources for each level of aggregates
- Environment: Oracle OBIEE11.1.1.7.1,Oracle 11g, Toad, Linux.
Sr. Data Warehouse Consultant
Nexgen Technologies Pvt Ltd
Bangalore
11.2013 - 11.2015
- Used the OBIEE Administration tool to develop and enhance meta-data
- Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
- Configured and Created repository using OBIEE Admin tool
- Worked extensively with Physical Layer, Business Layer and Presentation Layer
- Created numerous executive level reports
- Dashboards’ were generated to provide insight into the sales/marketing/financial data
- Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables
- Involved in modifications of physical, business and presentation layers of metadata repository using Administration Tool
- Identified the aggregate levels for each source and created dimension sources for each level of aggregates
- Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements
- Managed security privileges for each subject area and dashboards according to user requirements
- Created groups in the repository and added users to the groups using External database security table and granted privileges explicitly and through group inheritance
- Environment: Oracle OBIEE11.1.1.7.1/OBIA 7.9.6.X,Oracle 11g, Oracle ODI, Toad, Linux.
Senior Consultant
DAZSI Systems
Hyderabad
12.2012 - 10.2013
- Worked on building Siebel Analytics / OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer
- Create/Modify Metadata repository (.rpd) as per the data requirements by using Oracle BI Analytics Server Admin tool
- Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer
- Worked on setting up Dimensional Hierarchy
- Identified and created aggregate tables to improve query performance
- Created Aggregate level and level based measures
- Created Web-groups for security purpose with access privileges
- Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions
- Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching
- Assigned Data level & UI level security to the Users
- Managed security privileges for each subject area and dashboard according to user requirements
- Customized Reports look and Feel using Column Formatting, Conditional formatting
- Customized Dashboard reports using drill-down capabilities
- Migrated Analytics RPD and Web catalog from one environment to another
- Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC
- Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor
- Environment: Oracle OBIEE11.1.1.6/OBIA 7.9.6.X, Oracle Applications R12 (HRMS), Oracle ODI,Oracle 11g, Toad, Linux
Education
Electronics and Communications Engineering
JNTU
HyderabadSkills
OLAPundefined
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Sales Analyst
Musarubra Software India Pvt Ltd
03.2021 - Current
Data Analyst
Catalog IT Solutions Pvt Ltd
08.2017 - 07.2020
SR. Consultant
Aufait Technologies
07.2016 - 01.2017
Sr.OBIEE Consultant
TruGlobal Software India Pvt Ltd
11.2015 - 06.2016
Sr. Data Warehouse Consultant
Nexgen Technologies Pvt Ltd
11.2013 - 11.2015
Senior Consultant
DAZSI Systems
12.2012 - 10.2013
Electronics and Communications Engineering
JNTU
Certification
1Z0-591 - Oracle Business Intelligence Foundation Suite 11g Essentials - English (ENU)
Similar Profiles
Dejohn David NDejohn David N
Senior Software Development Engineer at Trellix ( Musarubra Software India Private Ltd )Senior Software Development Engineer at Trellix ( Musarubra Software India Private Ltd )
Nepe KonyakNepe Konyak
Partner Support Analyst at Mcafee rebranded to Musarubra Software India Private LimitedPartner Support Analyst at Mcafee rebranded to Musarubra Software India Private Limited
Kiran NyamgoudarKiran Nyamgoudar
IT Support Specialist at Musarubra Software India Private Limited (Trellix)IT Support Specialist at Musarubra Software India Private Limited (Trellix)
Oisin McConnonOisin McConnon
Sales Analyst at BlackRockSales Analyst at BlackRock
Awanda GitaAwanda Gita
Sales Analyst at PT Semen IndonesiaSales Analyst at PT Semen Indonesia