Data Analyst with 5 years of professional experience in developing, interpreting and analysing data for driving business solutions. Proficient in SQL, Python and R Language. Excellent understanding of multiple data analytical platforms like MS SQL Server, MS Business Intelligence Development Studio, Tablue and MS Office. Specialise in developing solutions to complex business problems by building analytical solutions and delivering operational effectiveness through automation of processes.
SKILLS SUMMARY: • Data Warehouse Development • Data Mining • Proficiency in SQL, Python & R Languages • Expertise in SQL Server, Oracle DB and IBM DB2 • Expertise in SSIS, SSAS & SSRS • Proficient in Data Modelling • Expertise in Informatica, and Teradata • Sound Knowledge about Big Data Technologies • Worked on Cloud Solutions (Azure and AWS) • Worked on IBM Watson and SAP Business Objects
PROFESSIONAL EXPERIENCE:
Data Analyst (Software Developer II) Jan 2016 – July 2017 Employment: S&P Global Market Intelligence, Islamabad, Pakistan.
• Worked on developing data warehouse solution to address Banking and Insurance business problems. • Developed Automated ETL Solutions on MS SQL Server to collect and transform raw data into essential insights. • Utilized R and SQL programming language to predict future insights and potential difficulties for the business. • Created Story Telling Dashboards on Tablue and Power BI to showcase my data findings to the stakeholders.
Business Intelligence Analyst Aug 2012 – Dec 2015 Employment: Digital Processing Systems, Islamabad, Pakistan. • Effectively transformed business requirements into data model using Entity Relationship (ER) Modelling. • Coordinating between Stakeholder to analyse data and determine possible business opportunities. • Implemented a module "Effective KPI Identification for employees" in one of our client's Project "LEVELSPRO" using the principles of Predictive Analytics and Data Mining Techniques. • Develop Ad-hoc reports and dashboards for business stakeholders in Excel and Tablue using SQL. • Data exploration via SQL to collect key consumer insights for analysis according to business needs. • Addressed the business questions raised by various business units by sound and thorough analysis and recommendations.
VOLUNTEER EXPERIENCE • Code For Pakistan Jan 2016Participated in change for Pakistan Software Challenge, where I developed an APP called "Awaaz", whose sole moto was to empower the voice of Pakistani People. It collects the complains and suggestions of the people from social media, and consolidate into categories. I have then present the important information in a data visualisation dashboard, which the government people see and analyse• Android Workshop Mar 2012Worked as a volunteer in an android workshop held in Nust University Islamabad, Pakistan.EDUCATION:
• Master of Data Analytics Jul 2017 – Aug 2019 Deakin University, Melbourne, Australia
• Bachelor of Science (Computer Science) Aug 2008 – Jun 2012 National University of Computer and Emerging Sciences, Islamabad, Pakistan