خلاصہ

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
ستمبر ۲۰۱۷ - موجودہ | 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.
فروری ۲۰۱۵ - جون ۲۰۱۷ | 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.
فروری ۲۰۱۵ - مئی ۲۰۱۵ | 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
انٹرمیڈیٹ / اے لیول, انٹرمیڈیٹ / اے لیول, ‎
FSC
فی صد 84%
2010
New Saint Mary’s High School
میٹرک / او لیول, میٹرک / او لیول, ‎
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

زبانیں

ماہر اردو
متوسط انگریزی