Crop Picture
NOTE: Do not upload any image that violates our Picture Policy. Doing so will result in the removal of the concerned image without prior notification.
概要
I am Data Analyst Having 5+ years of IT experience as Data Analyst using Oracle BI, Power BI, Microsoft SQL Server developer implementing SSIS, SQL Server data tools (SSDT).Developed ETL in Oracle Data Integrator ODI and SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server and oracle.Experience in Requirement Analysis, Design and Development of Web applications using ASP.NET, VB.NET and C# Hands on experience in Performance Tuning, Query Optimization Strong Knowledge on Power BI to import data from various sources such as SQL Server,Oracle ,MS Excel etc. Experience in DAX Queries , Power BI , Power Pivot to develop
项目
工作经历
Business Intelligence Developer
Currently Working at PEL (Pak Electron Limited) 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.
