概要

Computer science graduate with a versatile experience in backend development on different stacks. Sound expertise in AWS, databases, Business Intelligence. My career goal is to assume a role in the company where I can utilize my extensive experience and further grow by learning new skills.

项目

TMUS Billing Engine
Wyless Porthos IoT/M2M
Scraping
Flywheel Digital

工作经历

公司标识
Senior Database Developer (SSE)
Strategic Systems International
Sep 2017 - 代表 | Lahore, Pakistan

• Database developments (SQL Server, Redshift, MySQL Aurora)
• Amazon Web Services with deep expertise in Amazon Redshift, ETL using Data Pipelines, Database Migration Services(DMS), State machines, Lambda, IAM, SNS, s3, Cloud watch, Scheduling, SES, Glacier, Athena, EC2, AWS Transfer for SFTP, Linux Worker Group implementation with crontab
• Lifecycle Transition policies
• Responsible for creating/managing database, database objects, users, roles
• Data optimization
• Daily monitoring/troubleshooting of ETL process
• Assistant to QA team for testing of different complex scenarios
• Good hands on experience in implementing Data Ware Housing Star & Snow flake schema Structure
• Responsible for Sort Key & Distribution Key strategies and optimizations in Amazon Redshift
• Responsible for creating database, database objects, users, roles.
• Developed stored procedures to optimize statistics collection process on Production databases.
• Automation of Data ETL

公司标识
Database Developer
ZIN Technologies (Pvt.) Ltd.
Feb 2015 - Jun 2017 | Lahore, Pakistan

• Designed and implemented stored procedures views and other application database code objects.
• Maintained SQL scripts indexes and complex queries for analysis and extraction.
• Performed quality testing and assurance for SQL servers.
• Deployment of SSIS packages with ETL & Reporting Services
• Worked in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Bug fixing, Deadlock handling in SQL with performance improvements

公司标识
Associate Software Engineer
ZIN Technologies (Pvt.) Ltd.
Feb 2015 - May 2015 | Lahore, Pakistan

• Analyzing & Reviewing current system
• Maintaining the stability of all live systems
• Analyzing Client requirements

学历

National University of Computer and Emerging Sciences
学士, 商学士/理学士, Bachelors in Science‎
Database Management System, Computer Software, Software Quality Assurance
CGPA 2.6/4
2015
Government Science College
中级/A级, 中级/A级, ‎
FSC
所占比重 84%
2010
New Saint Mary’s High School
大学入学/0级, 大学入学/0级, ‎
Chemistry, Computer Science, Mathematical Physics
所占比重 83%
2008

技能

初学者 ATHENA
中级 Automation Languages Command
熟练 AWS
熟练 CloudWatch
熟练 Data Pipeline
熟练 Database Migration Service
熟练 EC2
熟练 ETL Tools
熟练 Glacier
中级 IAM
熟练 Lambda
熟练 MySQL
熟练 Redshift
熟练 S3
熟练 SES
中级 SFTP
熟练 SNS
熟练 SQL 2008/2005/2000
熟练 State Machine

语言

熟练 乌尔都语
中级 英语