Raheel Waqar

SENIOR SOFTWARE ENGINEER

NorthBay Solutions

Experience Summary

● Bachelor’s degree (4 years) in Computer Science with 3+ years of experience in software development, Expertise in the analysis, design, and development of software applications and general problem-solving.

● Quick learner who adapts to extraneous assignments and exploring new dimensions while solving development problems.

● An experienced team player with excellent communication skills and has the ability to work independently.

● Ability to learn quickly and adapt to new technical environments.

● Ability to research, design, and implement scalable applications for information identification, extraction, analysis, retrieval, and indexing.

● Hands-on experience in Cloud Computing services of AWS (Amazon Web Services) especially in Data Warehousing (Redshift) and Data Processing (EMR) as well as on native mobile hybrid technology.

● Proficient in Big Data domain for Data Ingestion, Data Management, Data Lake, ETL(Pandas, Numpy), MapReduce (Spark), CI/CD pipelines, and BI reporting, having an excellent understanding of Hadoop Architecture and underlying Hadoop framework including Storage Management.

● Expert in creating complex queries in MySQL, PostgreSQL, SQL using joins and subqueries, views, effective functions, and appropriate stored Procedures to facilitate efficient data manipulation and data consistency.

● Data validation scripts development using Jupyter Notebook.

● Experience of working in Agile Development and Scrum Model. Technical Skills

Cloud Platform: AWS Cloud: IAM, VPC, APIs, CLI, S3, KMS, EC2, EMR, ELB, Lambda, API Gateway, CloudWatch, CodeCommit, CodeBuild, CodePipeline, CloudFormation, DataPipeline, DMS, DynamoDB, RDS, SNS, SQS, SES, Sagemaker, Athena, Glue, Cognito, Secret Manager, Step Functions, Cloud9, QuickSight Languages: Python, Javascript, JSON

Frameworks Serverless, AWS Chalice, Apache Spark

Libraries Pandas, Numpy

Databases: DynamoDb, Postgres, MySQL, SQL, SQLAlchemy Software Tools: CI/CD, GIT, Atlassian Agile, Sourcetree, Pycharm, Visual Studio Code, DBeaver, PgAdmin, Workbench OS: Linux, Windows 10/7, Mac

Professional Experience

Role

Company / Location

Senior Software Engineer

July 2019 – Present

Northbay Solutions / Lahore, Pakistan

Technologies AWS (Amazon Web Services), Python, Pandas, Numpy, SQLAlchemy, SQL, PostgreSQL, Jupyter Notebook, Git, Jira.

● Gathered and analyzed Requirements & Designed Database after meetings with the Product Team in the US and made deployments to production, staging, and development environments.

● Implemented ETL code that extracts information from the multiple sources, performs some analysis, and then transforms information using the Python Pandas/ Numpy library and saves it to the PostgreSQL databases.

● Worked on performance tuning for all databases and authored complex queries and views. Role

Company / Location

Full-Stack Developer

August 2018 – July 2019

Northbay Solutions / Lahore, Pakistan

Technologies React Native, AWS (Amazon Web Services), Python, SQLAlchemy, Git, Jira, Code Commit

● Created RESTful APIs using AWS chalice (Serverless Microframework).

● Created UI Screen and Modules in both IOS and Android and integrated with React Native applications.

● Integration of frontend components with Amazon Web Services and 3rd party APIs.

● Deployments of application to both App Store and Google Play. Role

Company / Location

Cloud Engineer

February 2018 - August 2018

Northbay Solutions / Lahore, Pakistan

Technologies AWS (Amazon Web Services), Python, Hadoop, Spark, PySpark, Git, Jira

● Ingested data from on-premises databases to AWS cloud by doing JSON (parsing), unstructured data management, ensuring data quality, and data profiling.

● Processed data using EMR (Spark) for different data zones. Denormalization of received data tables, parquet conversion, files lineage to dynamo dB, data deduplication was included in the data processing.

● Consumed data using Amazon Athena, Amazon QuickSight (BI).

● Created DevOps scripts using AWS CloudFormation. Role

Company / Location

AWS Cloud Engineer

November 2017 - February 2018

Northbay Solutions / Lahore, Pakistan

Technologies AWS (Amazon Web Services), Python, Hadoop, Spark, PySpark, Git, Jira

● Created data lake which contains many modules including Data Ingestion, Data Quality, Profiling, Data Management & Data Processing, Data versioning, Parquet conversion, Hive (Tables), Spark processing, application of compression, data ingestion in Redshift, and Data Lineage.

● Consumed data using Redshift Spectrum, Amazon Athena, Amazon QuickSight.

● Created DevOps scripts using AWS CloudFormation. Role

Company / Location

Software Engineer

October 2017 - November 2017

Northbay Solutions / Lahore, Pakistan

Technologies AWS (Amazon Web Services), Reactjs, NodeJs, Git, Jira

● Access control project on the AWS S3 service of Amazon.

● Users can upload an image, auto-resize the image using AWS Lambda.

● Each user will have special access to every file & folder in the AWS S3 Bucket.

● Frontend development to handle all the above tasks. Academics

Bachelor in Computer Science, University of Punjab (PUCIT), Lahore. (2013–2017)

● Graduated with 3.62 / 4.00 CGPA.

● Received Merit-based scholarship four times during the degree.

● Three times selected in the Dean's List.

● Awarded merit-based Solar Panel from Chief Minister of Punjab Scheme.

● Awarded Laptop for Prime Minister Laptop Scheme. Certifications

● AWS Certified DevOps Engineer Professional

● AWS Certified Developer – Associate

● AWS Technical Professional

● AWS TCO and Cloud Economics Online

● AWS DevOps ExamReadiness

Contact this candidate