Web Analytics

Nasir Jamil

  • Senior BI Consultant Jeeny - Middle East
  • Jun 10, 2019
Telecommute Information Technology

Personal Summary

• Experienced in Business Intelligence, Software Development and Data Mining.
• Experienced in BI Dashboards and Reports development in SSRS, Oracle BI Publisher and Power BI.
• Machine Learning
o Supervised Learning (Classification and Regression)
o Unsupervised Learning (Clustering and Dimensionality Reduction)
• ETL, Data Integration.
• Processing and Modelling data with Python scripts and creating backups on Amazon S3.
• Experience working with Version Control System, REST, HTTP and MVC Architecture.
• Implementing and Maintaining Data-Pipelines for periodic/real time data analysis with Apache Kafka.
• Advanced SQL development using Functions, Stored Procedures and Cursors etc.
• Data warehouse Implementation and Development with SSAS Tabular Model.
• Experienced in efficient SQL querying on large data sets based on the given requirements.
• Good understanding of full life cycle Business Intelligence implementations in a project.
• Developed schema for business applications with providing full-life cycle architectural guidance and
ensured quality technical deliverable.
• Experienced in gathering Reporting and Analysis requirements, Business Model and Presentation.
• Experienced in up-gradation and migration between DEV/SIT/UAT/Prod Environments.
• Great Presentation skills, Communication & Interpersonal skill, Multilinguistic with Fluency in English.
• Experience in Web Development mainly in Python, PHP, HTML5, CSS and JavaScript.

TECHNICAL SKILLS

Packaged Applications: Tabular SSAS, Power BI, Pentaho PDI, OBIEE 11g, Apache Kafka
Databases: SQL Server 2014, Oracle 11g, MongoDB, Redshift, Google BigQuery
Operating System: CentOS, Ubuntu, MS Windows Server 2012 R2
Languages and Tools: SQL, Python, DAX, XML, PHP, HTML5, CSS, JavaScript and JQuery
SQL Developer, SQL Server MS, Net Beans, Sublime Text
R-Programming, Excel-Pivot Tables, Robo-3T

Work Experience

Senior BI Consultant Jeeny - Middle East
Jan 2018 - Google BigQuery

Jeeny (aka EasyTaxi) is a ride-hailing startup funded by Rocket-Internet, operating mainly in Saudi Arabia
and Jordan. It generates huge amount of data on daily basis that gets stored in several NoSQL and relational databases like MongoDB, MySQL, Google BigQuery, Redshift and SQL Server. Completely Auto
scheduled python scripts are written to process this data and store it in SQL server after cleaning it.
• Kettle's ETL jobs are written to collect the data from all data sources into a Data-warehouse where it is modelled and prepared for Analysis and Reporting purposes.
• Tabular SSAS and SQL Server Reporting Services is primarily used to meet most of the daily and periodic reporting needs; However, I have also written python scripts to use Apache Kafka for real
time and event-driven analysis dashboards.
• Application is completely implemented on AWS cloud so most of the backups are therefore
destined to S3, AWS's cloud storage.
• Besides data-engineering, management and maintaining data-pipelines; I stay in direct contact
with Business teams to provide them information about Finance by preparing and extracting the relevant data.
• Analyzing Business-Customer trends week-over-week, month-over-month and year-over-year for newly launched and existing campaigns and services.
• Creating databases and schema objects including tables, indexes, stored procedures and functions
as a part of the data migration initiative and scheduling jobs to integrate data from disparate
sources into SQL server and vice versa.
• Performing Root Cause Analysis on failures and resolving performance tuning related issues and queries.

BI Consultant
Jan 2016 - Jan 2018 Speridian Technologies

Worked on Enterprise Report Development and Analytics as well as Data Integration using OBIEE and Informatica. Completed a Project from scratch while co-worked on several other enterprise level projects for our USA and Canadian clients.
Routine tasks included creating BIP Reports, performing Data Analytics with Dashboards, writing on
demand SQL queries and cooperating with the Development team in all respects.
• Analyze, Design, Develop and Support using Oracle Business Intelligence Enterprise Edition
• Development of layers of OBIEE including Physical layer, Business layer & Presentation layer.
• Data Integration using Informatica.
• On demand SQL querying using SQL Server & Oracle PL/SQL
• Coordinate with DBA team for best performance and availability of BI applications.
• Support Business Analysts in use of BI Tools, Analytics and Reporting applications.
• Analyze and identify necessary actions to enhance data accuracy and integrity.
• Create Business reports using BI Publisher 11g, and scheduling them to send as emails in various
output-formats like MS Word, PDF, HTML and Excel.
• Integrating BI Reports with Siebel CRM, and adding Barcode reading support on reports.
• Siebel CRM development and configuration.
• Migrating from on premise OBIEE 11g to 12c Cloud environment.

Training and helping Junior team members
Jan 2014 - Jan 2015 Life-cycle

Served as a Junior Software Engineer, where I was responsible for full Life-cycle development of complete
web solutions including Front-end and Back-end, i.e. From Initial Requirements gathering to Design,
Coding, Testing, Documentation, Implementation and Support.
• Directly in contact with clients from initial stage to final delivery.
• Designed wire-frames and Documented the Client's requirements.
• Developed static and custom websites using HTML, CSS, jQuery.
• Used PHP for backend development and MySQL as database.
• Used Bootstrap to design responsive web pages.
• Handled multiple projects in parallel while meeting deadlines.

Education

BS - Computer Science
Sep 2009 - Dec 2014 COMSATS Institute of Information Technology