Currently Working as Data Analyst with Responsibilities
Imported data from SQL Server DB, Oracle ERP (HRMS, Inventory, Payroll, Procurement and Financial etc.) and .CSV File to Power BI to generate
reports.
Created DAX Queries to generated computed columns in Power BI.
Generated computed tables in Power BI by using DAX.
Design and develop data warehouse database schemas and ETL (Extract Transform Load) using ODI (Oracle Data Integrator) , Microsoft SQL
Server 2014/18 and SSIS,
Creating new stored procedures and optimizing existing queries and stored procedures.
Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
Explore data in a Variety of ways and across multiple visualizations using Power BI
Used Power BI Gateways to keep the dashboards and reports up to date.
Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services. Published reports and dashboards using Power BI.
Translate business needs to technical specifications
Code and support provided through ASP.NET, T-SQL, Microsoft SQL Server, and Oracle.
Design, build and deploy OBIEE 11 g, OBIEE 12c, Oracle Business Intelligence.
Environment: MS SQL Server 2014/17, Power BI, ETL, T-SQL, Visual Studio 2010/19, Dashboard, SQL Server Management Studio, SQL Server Data
Tools , Oracle , Oracle Data Integrator ODI.
Work Terms
all will be client friendly :)
Attachments (Click to Preview)
-