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
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
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
Senior Software Development Engineer at Trellix ( Musarubra Software India Private Ltd )Senior Software Development Engineer at Trellix ( Musarubra Software India Private Ltd )
Partner Support Analyst at Mcafee rebranded to Musarubra Software India Private LimitedPartner Support Analyst at Mcafee rebranded to Musarubra Software India Private Limited