Sabahat Asif Durrani
Business Intelligence Developer
Rawalpindi,Punjab
Summary
Experienced business intelligence professional well-versed in mining data, designing ETL pipeline ,developing databases/datawarehouse and generating reports
Overview
4
4
years of post-secondary education
3
3
years of professional experience
Work History
Business Intelligence Developer
MTBC
Rawalpindi, Punjab
11.2019 - Current
- Interpreted data models for conversion into ETL diagrams and code.
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
- Created ETL Pipeline using Microsoft tool SSIS
- Tested Data with Source System through SQL Scripts and SSIS jobs
- Created 15+ ETL Projects .
- Supervised team for ETL Projects
- Documented Deployment of ETL Projects as well as ETL steps using Microsoft Word
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Created Paginated Report in SSRS
- Developed and delivered business information solutions.
- Gathered data on integration issues and vulnerabilities and reported all findings, including improvement recommendations.
- Created accurate and efficient test scripts in SSIS to manage automated testing of certain products and features.
- Explained data results clearly and discussed how it can be utilized to support project objectives.
- Contributed to internal activities for overall process improvements, efficiencies and innovation.
- Prepared functional and technical documentation data for warehouses.
- Mapped data between source systems and warehouses.
- Validated warehouse data structure and accuracy.
- Coordinated troubleshooting support for warehouse personnel.
- Designed data models for complex analysis needs.
Database Developer
MTBC
Rawalpindi, punjab
03.2018 - 10.2019
- Designed and implemented TSQL queries for reporting and complex solution development.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Documented and analyzed business reports for prompt communication, follow-up and ongoing support.
- Developed custom database objects, stored procedures .
- Created and implemented database designs and data models.
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
Intern(PHP Developer)
Holistic Solution
Rawalpindi, Pakistan
08.2017 - 11.2017
- Developed user-oriented visuals and features using front-end languages, including Bootstrap and perform SEO to increase site traffic .
- Worked on code igniter MVC frame work to wrote back end code in PHP
- Worked on HTML,CSS and Javascript to develop front end of Web Application
Education
Bachelor of Science - Computer Science
PMAS Arid Agriculture University
Rawalpindi 09.2013 - 08.2017
Skills
Data Warehousing
Data extracting
T-SQL coding
SQL Programming
Microsoft SQL Server
Data Analysis
reading
I read Spiritual , Financial,Technology and Inspirational books.
Timeline
Business Intelligence Developer
MTBC
11.2019 - Current
Database Developer
MTBC
03.2018 - 10.2019
Intern(PHP Developer)
Holistic Solution
08.2017 - 11.2017
Bachelor of Science - Computer Science
PMAS Arid Agriculture University
09.2013 - 08.2017