Download PDF

Rashid Mahmood

Software Engineer | Experience in ETL, Data warehouse, Web Development and Cloud Technologies

Summary

Have excellent technical skills, communication skill, and goal-focused professional offering 2+ years of experience in Computer industry. I am motivated and enthusiastic by new challenges and tasks and take excellent approach to achieve success in all projects. I like to work in a complex projects which have scope for learning and challenge. I have experience in working with Big Data/Data warehouse, ETL and Web Development projects mainly focusing AWS (Amazon Web Services) services. Have expertise various quality process and techniques by which I efficiently took care of quality deliverable of myself and my team which helped in gaining satisfied customers for the organization.

Work History

February 2016January 2017

Scholastic

NorthBay Solutions

Tools & Technologies

Redshift, DynamoDB, Data Pipeline, RDS, EMR, EC2, Python, SQL, Bash/Shell, ETL

Worked as a Data Engineer for a famous books publisher based in the US.

Role & Responsibilities:

  • Data analysis and design of source tables as well as warehouse tables.
  • Write and use Sqoop scripts to source data into staging environment in Redshift.
  • Create Data Pipeline templates as per new requirements of data ingestion.
  • Transformation of existing DML logic written in AS400 iSeries into AWS Redshift.
  • Design and write ETL scripts to load facts and dimensions.
  • Create mapping and analysis documents outlining the transformation logic and mapping between source table's columns and target table's columns.
  • Write scripts and build frameworks in Python for different data manipulations and configurations.
  • Work directly with the client team in Agile model. Requirements gathering and sprint planning are the major agendas of daily/weekly meetings.
November 2015 January 2016

Eliza

NorthBay Solutions

Tools & Technologies

AWS (Redshift, Hive, Impala, Presto, Spark, S3, EC2), Eclipse, Java

Worked on this data warehousing project as a Software Engineer.

Role & Responsibilities:

  • Explore various technologies like Hive, Impala, and Presto to determine their feasibility and utility for the current project.
  • Convert queries from Redshift to Hive, Impala and Presto queries and analyze their performance.
  • Participate in warehouse design/update process.
  • Perform data cleansing using Spark.

July 2015October 2015

Liberty Mutual

NorthBay Solutions

Tools & Technologies

AWS (Spark, Kinesis, Lambda, S3, EC2), Elastic Search, Kibana, Eclipse, Java, Scala

 In this project, developed programs (both in Java and Scala) to send logs to Amazon Kinesis and consume it using Spark Streaming and then saved it on Elastic Search after converting logs into JSON format. Finally prepared various reports in Kibana consuming data from Elastic Search.

Role & Responsibilities:

  • Process logs in Amazon Kinesis through Spark Streaming using Scala.
  • Convert logs to JSON format for Elastic Search.
  • Generate Visual Reports and Graphs in Kibana tool.

April 2015June 2015

AWS Training

NorthBay Solutions

Tools & Technologies

Amazon Web Services and Data warehousing concepts

Completed a training plan offered by the company and covered various AWS services.

Role & Responsibilities:

  • Explore and work on different AWS services like EC2, EMR, Kinesis etc.
  • Design sample infrastructures using AWS services.
  • Learn data warehousing concepts like KPIs, Dimensions, Facts etc.
  • Perform operations on Data like data cleansing using EMR.
  • Mentoring and training new team members.
February 2015April 2015

Electronic Guide (HTML5 Refactoring)

NorthBay Solutions

Tools & Technologies

WCC (Content Management System), UCM (Universal Content Management), SPA (Singe Page Application), Spring framework, HTML5, CSS3, Javascript, JSON

Worked as a Web Developer to create an editor to allow clients to edit books content.

Role & Responsibilities:

  • Place books content on UCM.
  • Write middleware services in Spring framework to access content from UCM using native APIs.
  • Create SPA (Single Page Application) to display books content from UCM using middleware.

October 2014January 2015

Electronic Guide (Educational Website)

NorthBay Solutions

Tools & Technologies

HTML5, CSS3, JavaScript

Worked as a Web Developer to convert PDF books into responsive Electronic Guides compatible to Tablets, PC and Mac.

 Major Responsibilities were:

  • Create Website structure in HTML5.
  • Apply CSS to replicate PDF books style and color scheme.
  • Create Dynamic Header and Side Menu.
  • Write javascript code to make website and menus interactive.
  • Automate website code in a way that data entry resources could create similar books without dealing with the Code part.

Education

20102014

BS in Computer Science

University of Gujrat

CGPA 3.79 (Gold Medalist)

Portfolio