About Me
To gain maximum knowledge in the field of programming especially in database and Business Intelligence. Always looking forward for a challenge to design and develop ERP solutions with the latest Microsoft BI stack support with the combination of m...
Show MoreSkills
Data & Analytics
Database
Programming Language
Software Testing
Web Development
Others
Positions
Portfolio Projects
Company
CareMonX
Role
Backend Developer
Description
- Manage the database department and the team of experienced and professional database administrators
- Designing and Implementing HA / DR solutions like Failover Clusters, Database Mirroring and Log Shipping.
- Design and Analysis for BI solutions and centralized Reporting solutions.
- Full utilization of MS BI stack for efficient and timely deployments for complex cubes and ETL Processes.
- Monitoring the database department performance and take necessary steps to increase the performance and technical abilities of the DBAs within the department.
- Requirement Analysis, Database Designing , Development and Capacity Planning
- Design and Implementing Data Synchronization strategies between Client / Database Server and Database Server / Reporting Server
- Defining and Implementing strategies for Backup / Recovery of Data files and Log files to get the point-in-time recovery
- Preparation of Documents related to the Database Department
- Presentations and trainings to junior resource
- Writing Complex Stored Procedures, functions and queries to implement the business logic of the clients
- Query Optimization and Performance Tuning
- Writing CLR Procedures and Functions
- Implementation and Support for Service Broker in SQL Server 2005 for asynchronous messaging between database servers
- Suggestions to Developers on performance of the applications
- Other SQL Server Administration Tasks Mirroring, Log Shipping and Replication
- Developing Cubes on the clinical dataset of the company using SQL Server Analysis Services and Excel for Enhanced reports
- Design and implementation of Reports in SQL Server Reporting Services for OLTP and OLAP datasets
Company
CrossTabs
Role
Backend Developer
Description
- Design and Implement Multi-lingual Cube with Dynamic Dimension Security and SSAS Stored Procedures in SQL Server 2012 and SQL Server 2016
- Design and implement the database design and Scripts for data migrations, up-gradations and new implementations in SQL Server 2012 and SQL Server 2016.
- Implementing Complex Hierarchies in the Cube as per the requirement of the client.
- Design and Implement ETL and Views to develop SSAS Cube in SQL Server 2012 and SQL Server 2016
- Analysis of IRs and CRs. Writing RCAs for the incidents and suggest permanent solutions
- Implementing Query Optimization techniques using ColumnStore Indexes and In-Memory OLTP in SQL Server 2016 Standard edition for faster response on application end.
Company
Lease Business Suite
Description
- Involved in complete Software development Life Cycle including Analysis and Initiating Technical Design Documents.
- Database Designing and Development
- SQL Server Administration including Backup, Recovery, Log Shipping and Replication.
- Designing and implementing complex Stored Procedures, Views, Triggers and User defined Functions.
- Implementation and support to team members for Database High Availability Solutions and Disaster Recovery Plans.
- Optimization of complex queries and processes.
- Data conversion using DTS and self written T-SQL Scripts.
- Coordinating with different departments to ensure timely and accurate processing of data and related issues.
- Involved in Development and Implementation phase of Lease Business Suite. Lead a team of four programmers and involved in the coordination with top management for Requirement Analysis and Other issues.
- Having sound knowledge of Finance, Treasury, Credit, Recovery and Customer Services.
- Develop sophisticated Programs to get and resolve client queries. Provide information about Re-Structuring of Leases and Revised Rentals of their Lease.
Skills
SQL Server 2000 VB 6.0 SQL T-SQL TriggersCompany
ASKLife
Description
- Design, Development and Implementation of AskLife Consumer Finance System. Running successfully in all Branches of Pakistan
- Awarded with a DVD Player for the fastest and successful development and Implementation of AskLife. Running successfully in all Branches of Pakistan
Skills
Visual FoxPro SQLTools
Visual Studio (Win)Company
Business Intelligence InnovaCare
Description
- Analysis, Design and development of Cube on InnovaCare data
- Design and develop ETL process for Cubes
- Design complex jobs for data loading in SQL Server Integration Services
- Daily and Weekly Reports email to the Management