Business Intelligence Analyst
Akwad
Total years of experience :6 years, 9 Months
Design solutions that align with the firm’s data management principles, policies,
standards and best practices
Translate requirements and generate and develop a roadmap utilizing the best
technologies for the project with comprehensive and obtainable milestones
Develop and deploy dashboards, visualizations and autonomous and dynamic
reporting interfaces to be distributed to stakeholders via the BI reporting platform, web
portal, mobile, tablet devices, widgets and email
Optimize report distribution, execution and the scalability of all reporting solutions so
they are autonomous and dynamic
Work with the Data Management team to provide input on logical and physical
database design, data modeling and/or mapping
Generate large and complex data extracts and queries for the Analytical Leads for data
analysis by utilizing various database schema such as Microsoft SQL Server, Oracle, and
Netezza
Design and create Power Bi reports
Analyze and design ETL processes
Technical environment: Power BI, Agile, Scrum, SSIS, Report Server, Sql Server, Mysq
Learn the functional area of business customer
Supervision treatments ETL
Running the upgrade maintenance based specifications
Extracting data from SQL server and CSV and analysis in dashboards and reports using
Power BI
Daily dashboard to analyze dispatch items of total month orders.
Revenue wise list of transactions.
Products launch category wise analysis to make insight for best product performance,
City wise revenue breakup and feedback analysis.
Coordination with store manager for collection discrepancies.
Maintaining monthly.
Technical environment: Power BI, SQl.
Analysis of existing reporting
Collection of reporting needs necessary to improve management.
Delivery and documentation of reports
Create indicators gathering data from multiple sources
Definition of good development practices
Extraction of data from heterogeneous sources (flat files, SQL server, Oracle)
Analysis of detailed functional specifications
Design and implementation of the Datawarehouse
Development of several datamarts.
Technical environment: Power BI, SQl, Agile, Scrum, Talend Data Integration 6.4.1.
Development and maintenance of an ERP solution.
Identify the needs expressed by the project manager
Produce the technical and functional design documents
Set data and modify the components
Create crystal reports
customers support.
Technology used:
Technical environment: C# /.net / sql