概要

A database developer with over 7 years of experience in multinational companies. Extensive hands on technical expertise inSQL Server
MySQL
SQLite
Azure
RDS Amazon
SSIS
Data warehousing
ETL Operations
Experienced in leading teams of engineers and successfully executed projects. Possess good technical, interpersonal and communication skills, Comfortable in working with varying levels of management and individual team members.

项目

MausakHope

工作经历

公司标识
Principle Database Engineer
The Entertainer
Jul 2019 - 代表 | Lahore, Pakistan


The Entertainer Company is doing in Food and travel sector in multiple countries. Through App you get various offers. My primary responsibilities are to look after team members tasks, Data Analysis, Data Reporting, Database programing(Stored Procedure, triggers, Functions and complex queries) ,ETL operations and Data-Warehousing
Tools are:
Azure Data bricks (ETL Operations)
MySQL
SQL Server 2018
Amazon RDS
Jira

公司标识
Database Developer
SoloTech
Nov 2018 - Jul 2019 | Lahore, Pakistan


Project Description:
Solutions related to the human recognition that targets the workforce management and security industry. Leveraging the most advanced multi model biometric platform for face & retina recognition, our solutions provide a circle of trust around all aspects of the identity and the credentials assigned to it. This includes enrolment, registration, usage, access and reporting.
Responsibilities:
ï‚· Design Tables and Relationships
ï‚· Develop SPs, Functions, Materialized Views, Jobs and Triggers
ï‚· Performance tuning and Optimizing

公司标识
Database Developer
Raaziq Group
Jun 2016 - Sep 2018 | Lahore, Pakistan

Relisys System (CRM,HRM Complete Solution)
Project Description:
Relisys System provides you complete solution for HRM, CRM and Operations. System is at developing mode. Yet we have completed HRM module which ensures all market capabilities. System is very flexible, Reliable and durable.

Responsibilities:
• Modifying databases and products according to client needs.
• Designing and developing database architectures.
• Working to create functional requirements.
• Providing assistance to others in topics related to data management.
• Creating reports on databases.
• Plan and coordinate data migrations between systems
• Develop and maintain the Data Warehouse
• Monitor business use and performance of the BI and provide feedback to BI architects, developers and database administrators.
• Install new equipment and software patches and upgrades
• Develop security procedures to protect databases from unauthorized usage.
• Closely work with report developers to help them understand the Architecture and provide necessary solutions.
• Create ETL mapping document from business requirements.
• Ensure that new database code meets company standards for readability, reliability, and performance
• Design indexes for existing applications, choosing when to add or remove indexes
• When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
• Advise developers on the most efficient database designs (tables, data types, stored procedures, functions)
• Using REDGATE Third party tool to Sync databases

公司标识
Database Developer
ENOVA
Feb 2015 - Feb 2016 | Dubai, United Arab Emirates

Adrenalin Complete HR Software System Project:
Adrenalin offers a comprehensive and powerful HR system with module covering the complete cycle of an employee. Adrenalin is also giving individual modules and as integrated suite for Human Resource management. There are some major modules.
• Pay Slip
• Claims & Reimbursement
• Confirmation Management
• Employee Movement
• Employee separation
• Recruitment
• Reporter
• Leave Management
• My Needs
• Officiating
• Payroll
• Personal information management system
• Performance management system
• Portal management
• Travel management system

SQL Database Responsibilities:

• Modify databases according to requests and perform tests
• Gather user requirements and identify new features
• Ensure all database programs meet company and performance requirements
• Participate in database design and architecture to support application development projects.
• Coordinate internal resources and third parties/vendors for the flawless execution of projects.
• Ensure that the project delivered on-time, within scope and within budget.
• Take the necessary actions for the safe operation in-case of any Operational/ System Emergency.
• Coordinate with Human Resources for appropriate data manipulating.
• Test the project using appropriate tools and techniques.
• Planning, execution of regular data backup and its management.
• Liaise with developers to improve applications and establish best practices
• Provide data management support to users
• Perform data back-up and archival on regular basis.
• Test databases and perform bug fixes.
• Develop, manage, schedule and document BI operations and tasks, including extraction, movement, loading, archival, security, and backup and aggregate table creation.

公司标识
IT Specialist / Project Operation Coordinator
ENOVA
May 2013 - Feb 2015 | Dubai, United Arab Emirates

Asset and Performance Management Systems – CAFM Project
Project Description:
Enova’s CAFM (Computer Aided Facilities Management) system provides the link between the administration and operation at the site and complements the work with the following:
• Bar code and register of all assets
• Provide a comprehensive planning and scheduling system
• Maintain and manage all assets
• Ensure that Client has real time, online access at all times
• Develop and maintain all of Client’s asset management functions
• Provide the Client with lifecycle plans according to their requirements
• Assess the condition of all assets, then propose and agree with the Client a suitable prioritization and categorization of the inputted data provide a Helpdesk for all queries, job requests and reporting

The system is also equipped with a mobile application providing agility, flexibility and control. All work orders are transferred to the appropriate person with the right level of priority. Enova’s Performance Management System measures individual performance of each provider, as well as the collective performance.

SQL Database Responsibilities:
• Identify columns for Primary Keys in all the tables at the design time and create them
• Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Creating database objects such as tables, views, stored procedures etc.
• Creating Business Reports
• Having profound knowledge and hands on experience in software development methodologies that include Agile Development methodologies like Scrum, V Model, Waterfall Model, Iterative mode
• Having experience in Defect Management tool proficiency includes Bugzilla.
• Profound insight to determine priorities, schedule work, and meet critical deadlines within budget guidelines
• Produced new test cases to improved test coverage and quality based on customer investigated problems.

公司标识
Software Quality Assurance Engineer
Wateen Telecom Limited
Jun 2012 - Dec 2012 | Lahore, Pakistan

Askari Bank and China Mobile Pakistan have jointly launched their branchless banking program. Developing BBS for the one of the leading Bank and Mobile Operator of Pakistan and designing the solution for millions of mobile users to process their transactions through mobile using USSD Integration and web portal and main services are:
• Fund Transfer
• Bill Payments
• Salary disbursement
• Bulk Disbursement
• IDP disbursements
• Balance Top up
• Complaint Management System
AGENT mate Mobile Commerce Application (Android, IPhone)

AGENT mate is an innovative application for smartphones that combines new age acquiring with a full set of mobile money and branchless banking functionality. The user experience is extremely interactive and intuitive for the merchants/agents

学历

Punjab University College on Information & Technology
学士, 技术学士, Bachelor in Computer Science‎
SQL Server Database, Database Management System, Software Quality Assurance
所占比重 64%
2012

技能

中级 Agile
中级 Agile Waterfall Methodologies
中级 Amazon RDS
初学者 Big Data
中级 Bug Tracking
中级 Bugzilla
中级 Data Analysis
中级 Data Analytics
中级 Data Maintenance
中级 Data Modeling
中级 Data Warehouse Azure
中级 Database Administration
熟练 Develop complex Queries
中级 ETL
中级 Jira
中级 Microsoft SQL
熟练 Microsoft SQL Server
中级 MongoDB
中级 MySQL
中级 NAVISION
熟练 Official Assignments
初学者 Pentaho
中级 Putty
熟练 Query Language
熟练 RedGate
熟练 Software Projects
熟练 Software Quality Review
中级 Software Testing Life Cycle
熟练 SQL Development
熟练 SQL Server Management studio
中级 SSIS
熟练 SSMS
熟练 Statistical Analysis

语言

中级 乌尔都语
初学者 阿拉伯语
中级 英语

Usman 联系人

Kashif Mehmood
Raaziq Int. Pvt. Ltd