m bilal

m bilal

Data Analyst !
Pakistan
Urdu

About Me

Skilled data analyst with more than 4.5 years of industry experience in collecting, organizing, interpreting and disseminating various types of statistical figures. Energetic presenter and confident communicator with the…

Experience

Computer system Manager

Main Group of chakwal
Dec 2019 - Present · 6 years 6 months

 Evaluates current technology use and needs of company and recommends software and hardware improvements.
 Creating Standard operating procedures for operational Activities and Systems development
 Conducts performance evaluations that are timely and constructive.
 Supervising IT teams for designs, development and implementation of Database Management Systems.
 Collaborating with Data Analysts to Ensure Best Data Driven Decision
 Troubleshoot and upgrade existing Data management systems
 Implements and oversees operational budget and expenditures.
 Testing and modifying systems to ensure operations reliability
 Managing and supervising the processes of Information Systems.
 Collaborates with customers, Staff, technicians, and managers to understand and assess computing and system needs and requirements.

Data Analyst

Main group of Chakwal, Rawalpindi
Jan 2020 - Present · 6 years 6 months

Gather data from primary and secondary sources, ensuring the upkeep of databases Systems
Detect, examine, and decode trends or patterns within intricate datasets
Coordinate with management to align business and informational priorities
Convey insights through both reports and visual presentations
Employ statistical techniques to scrutinize data and produce actionable business insights
Collaborate with the management team to determine and rank the needs of different Business units
Develop data dashboards and charts to support decision-making across departments
Partner with Product development teams to understand business requirements

Junior Data Analyst

Atrix Digital, Rawalpindi
Aug 2019 - Jan 2020 · 5 months

Studied, analyzed and understood business requirements in context to business intelligence.
Designed and mapped data models to shift raw data into meaningful insights.
Utilized Power BI to build interactive and visually appealing dashboards and reports.
Spotted key performance indicators with apt objectives.
Analyzed previous and present data for better decision making.
Transformed business requirements into technical publications.
Built multi-dimensional data models.
Made essential technical and strategic changes to improvise present business intelligence systems.
Identified requirements and developed custom charts accordingly.
Performed SQL querying for better results.

Data Analyst intern

Mahroof Health Services Ltd, Rawalpindi
Jan 2019 - Jul 2019 · 6 months

Helped automate manual data extraction processes by doing auto classification of health care documents (prescriptions, doctor notes, equipment orders) using Python, Tesseract and regex.
Improved SLA for the classification process from 50 minutes to 2 minutes per document.
Prepared various BI dashboards in Tableau for month-on-month insurance business reports.
Evaluated and analyzed insurance claims dataset using Excel V-lookup, Chi-square, Normal and T-distribution.
Removed outliers using Python and Pandas.
Helped business decide in dynamic pricing by identifying business insights and forecasting trends for future months using time series analysis in Excel.

Junior Data Analyst

Atrix Digital, Rawalpindi
Aug 2019 - Jan 2020 · 5 months

Study, analyze and understand business requirements in context to business intelligence
Design and map data models to shift raw data into meaningful insights
Utilize Power BI to build interactive and visually appealing dashboards and reports
Spot key performance indicators with apt objectives
Analyze previous and present data for better decision making
Transform business requirements into technical publications
Build multi-dimensional data models
Make essential technical and strategic changes to improvise present business intelligence systems
Identify the requirements and develop custom charts accordingly
SQL querying for better results

Data Analyst intern

Mahroof Health Services Ltd, Rawalpindi
Jan 2019 - Jul 2019 · 6 months

Helped automate manual data extraction processes by doing auto classification of health care documents (prescriptions, doctor notes, equipment orders) using python tesseract and regex. This work improved SLA for the classification process from 50 minutes to 2 minutes per document
Prepared various BI dashboards in Tableau for month-on-month insurance business reports
Evaluation and analysis of insurance claims dataset using Excel V-lookup, Chi-square, Normal and T-distribution & removed outliers using Python and Pandas
Help business to decide in dynamic pricing by identifying business insights and forecasting the trends for future months using time series analysis using Excel

Data Analyst

Main group of Chakwal, Rawalpindi
Jan 2020

Gathered data from primary and secondary sources, ensuring the upkeep of databases systems.
Detected, examined, and decoded trends or patterns within intricate datasets.
Coordinated with management to align business and informational priorities.
Conveyed insights through both reports and visual presentations.
Employed statistical techniques to scrutinize data and produce actionable business insights.
Collaborated with the management team to determine and rank the needs of different business units.
Developed data dashboards and charts to support decision-making across departments.
Partnered with product development teams to understand business requirements.

Various – Small works

ABX Financial

Performed root cause analysis for bad data by querying almost 2 million records and loading them in a Jupyter notebook.
Worked closely with data engineers to understand structure of data and wrote Python routines to collect desired dataset.
Identified inefficiencies and lack of validations in the business processes of ABX Financial.
Prepared demonstrations for senior management to address lack of validations.
Resulted in implementing strict enforcement of loan and credit validations in ABX financial website.
Saved the company 1.5 million $ in credit and loan frauds.

Web traffic data analytics process

ABX Financial

Analyzed user navigation habits using SQL and Tableau.
Surfaced UX problems on the website.
Increased web traffic by 25% after addressing UX problems.
Resulted in sales increase of 10%.

Skills

Power BI Tableau Advanced Excel SAP Business Objects Crystal Reports Python SQL Apache Hive HTML CSS Java MySQL Microsoft SQL Server Tesseract Regex Pandas V-lookup Chi-square Normal distribution T-distribution Time series analysis Jupyter Notebook Apache Hadoop
Report this Profile?