Zulfiqar Ali is currently working as a Database Developer (MS SQL Server) at NaVetor. He is performing data migrations, ETL Data integration via SSIS, SQL Scripting and performance optimization.
Prior to Navetor he worked as a Web and Database Developer in Techleadz (IT Solution Provider). Overall he has expertise on MS SQL Server, its services, Performance optimization, Data migrations between systems, SQL Scripting and Data integration.
Zulfiqar holds Bachelors degree in computer science from UET (Lahore) with 3+ years of databases and web experience. He has MCSA, Oracle 11g and CCNA (Routing and Switching) training certificates.
Before Database Developer he worked on building and optimizing a talent hunter job board platform using Apache Solr, Cold fusion, SQL Programming, Database designing and query optimization.
Following is the list of technical skills he possesses
1) SQL Programming (SQL Scripts writing, SQL Server Agent and debugging).
2) SQL Complex Stored Procedures, Functions, Views, Triggers.
3) SQL Complex batch & dynamic Query Writing and its optimization.
4) Databases Design/Development/Debugging.
5) ETL Data integration via SSIS.
7) PHP (MVC, Code igniter).
8) Python Web Scraping .
9) MVC framework (PHP, Cold fusion).
10) Practical expertise on OOP (Object Oriented Programming) Concepts.
12) Cold fusion (MVC, Taffy and Core programming).
He also got experience to work on below mentioned technologies
1) Fw1, MVC, Taffy (Coldfusion Framework).
2) WordPress
3) HTML5, CSS3
4) Ajax, Java script, JQuery
5) C, C++, C#, Java (Intermediate Level).
My duties at NaVetor includes
Plan and coordinate data migrations between systems.
Design and deploy table structures, reports and queries.
Development and maintenance of the database stored procedures, views, triggers and functions.
Creation and maintenance of technical documentation.
Coordinate and work with other technical staff to develop relational databases and secondary databases.
Conduct research and make recommendations on database products, services and development efforts.
Applying upgrades to existing databases.
Identify inefficiencies in current databases and investigate solutions.
Diagnose and resolve database access and performance issues.
Develop, implement and maintain change control and testing process for modification to databases.
Development and maintenance of data warehouse.
Submit reports on database health and performance and participate in meetings with customers.
My duties at Techleadz includes
Enhance functionality of a talent hunter recruiting web application.
Create Relational Database of web applications, its optimization and maintenance.
Tune query by analyzing execution plan, DETA and Query execution steps
Automate complex processes with SQL Agent jobs
Establish and Maintain Backups on Local and Remote Media.
Work on Apache SOLR, it interaction with MS SQL Server and its search engine techniques.
Work on DB Core functionalities like SQL Cursors, Loops, stored procedures, functions triggers, indexes.
Work on MVC Framework of Cold Fusion for building web applications.