$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Junior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Business Intelligence Developer
Tahira Ali
,
London, United Kingdom
Experience
Other titles
Skills
I'm offering
Certified Business Intelligence Professional with more than 8 years of experience in Data warehousing, Business Intelligence and Databases.
Experienced in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
Proficient in development and design of report and dashboards for supporting business analysis using Micro Strategy Desktop & Web and Oracle BI Discoverer.
Excellent Command on Databases; Microsoft SQL Server and Oracle.
Practice Software Development Life cycle – SDLC
Expert in Data warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flake data models.
Experience in Designing Data Model.
Hands on Shell Scripting using UNIX / Linux Platform.
Technical Skills
Databases: MS SQL Server, Oracle.
Microsoft Technologies: SSAS, SSIS, SSRS.
Reporting Tools: Microstrategy Desktop & Web, Power BI, Oracle BI Discoverer, Brio Hyperion, iReports.
ETL Tools: Talend, SSIS
Query Languages: T-SQL, MDX, PL/SQL.
Software’s: Toad, Erwin
Experienced in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
Proficient in development and design of report and dashboards for supporting business analysis using Micro Strategy Desktop & Web and Oracle BI Discoverer.
Excellent Command on Databases; Microsoft SQL Server and Oracle.
Practice Software Development Life cycle – SDLC
Expert in Data warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flake data models.
Experience in Designing Data Model.
Hands on Shell Scripting using UNIX / Linux Platform.
Technical Skills
Databases: MS SQL Server, Oracle.
Microsoft Technologies: SSAS, SSIS, SSRS.
Reporting Tools: Microstrategy Desktop & Web, Power BI, Oracle BI Discoverer, Brio Hyperion, iReports.
ETL Tools: Talend, SSIS
Query Languages: T-SQL, MDX, PL/SQL.
Software’s: Toad, Erwin
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2018 - ?
job
BI Developer
BI Developer.
Cubezix Technologies, UK
Developer, BEE
2018 - ?
job
BI Developer
Cubezix Technologies.
Job Description:
• Abstract responsibility is to convert data into information and information into
intelligence with BI team at Cubezix Technologies.
• Maintain source Database and develop Staging Database from source and loaded data
from Staging Database to Destination Database by using different transformation
techniques.
• Design SSIS packages to load data into warehouse.
• Create SQL queries to ensure that the expected changes/updates were reflected in the database.
• Develop test plans and test cases in accordance with new application and application
change requirements.
• Oracle and MS SQL hands-on experience. Ability to write SQL queries and conduct large
data sets analyses.
• Develop Reports, Dynamic Dashboards and Scorecards by using MicroStartegy tool to meet client's Business requirements.
• Develop metrics and use graphs to show the trends and performance of business.
• Test numerous standard and customized forms and reports integrated with the application.
• Software testing experience across all phases of the Software Development Life Cycle
• Develop the test matrix based on the analysis of the project specification documents.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
Strategic expertise in design of experiments, data collection, analysis and visualization.
• Design Power BI data visualization utilizing maps, scatter plots, pie, bar and Sankey
charts.
• Design Power BI reports and dashboards from multiple data sources using data
blending.
Professional Projects at Cubezix Technologies:
Emirates Post Group:
• Implement the ETL Data Model and create Staging, Source and Target Tables in Oracle
11g Database.
• Extensively working with tool like PL SQL Developer for writing queries, procedures and functions.
• Analyzing the table structures and implement it in Talend using different components.
• Developing complex jobs in Talend Integration Suite and extensively using the concept
of ETL to load millions of data from source to target database.
MCTS MS SQL Reporting Services Business Intelligence Developer 2
• Abstract responsibility is to convert data into information and information into
intelligence with BI team at Cubezix Technologies.
• Maintain source Database and develop Staging Database from source and loaded data
from Staging Database to Destination Database by using different transformation
techniques.
• Design SSIS packages to load data into warehouse.
• Create SQL queries to ensure that the expected changes/updates were reflected in the database.
• Develop test plans and test cases in accordance with new application and application
change requirements.
• Oracle and MS SQL hands-on experience. Ability to write SQL queries and conduct large
data sets analyses.
• Develop Reports, Dynamic Dashboards and Scorecards by using MicroStartegy tool to meet client's Business requirements.
• Develop metrics and use graphs to show the trends and performance of business.
• Test numerous standard and customized forms and reports integrated with the application.
• Software testing experience across all phases of the Software Development Life Cycle
• Develop the test matrix based on the analysis of the project specification documents.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
Strategic expertise in design of experiments, data collection, analysis and visualization.
• Design Power BI data visualization utilizing maps, scatter plots, pie, bar and Sankey
charts.
• Design Power BI reports and dashboards from multiple data sources using data
blending.
Professional Projects at Cubezix Technologies:
Emirates Post Group:
• Implement the ETL Data Model and create Staging, Source and Target Tables in Oracle
11g Database.
• Extensively working with tool like PL SQL Developer for writing queries, procedures and functions.
• Analyzing the table structures and implement it in Talend using different components.
• Developing complex jobs in Talend Integration Suite and extensively using the concept
of ETL to load millions of data from source to target database.
MCTS MS SQL Reporting Services Business Intelligence Developer 2
It, Power, BEE, Software, Visualization, Development, Testing, Data collection, Developer, Test cases, Software testing, Transformation, Design, Ssis, Test, Integration, Database, ETL, Software development, Power BI, Oracle, Business Intelligence, Writing, Sql
2015 - 2015
freelance
BI Consultant
Creo Technologies.
UAE
Organization: Creo Technologies, Dubai
Role: BI Consultant
Experience: March 2015 to June 2015
Job Description:
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Developed complex T-SQL queries and designed SSIS packages to load the data into
warehouse.
• Designing SSIS Packages using several transformations to perform Data profiling, Data
Cleansing and Data Transformation.
• Did the whole documentation of packages and applied Naming Standards.
• Explained the whole design of Data warehouse for different projects using Visio tool.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily
Load.
• Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Involved in implementing business requirements in Dashboard, Documents and Reports
developed in MicroStrategy.
Organization: Creo Technologies, Dubai
Role: BI Consultant
Experience: March 2015 to June 2015
Job Description:
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Developed complex T-SQL queries and designed SSIS packages to load the data into
warehouse.
• Designing SSIS Packages using several transformations to perform Data profiling, Data
Cleansing and Data Transformation.
• Did the whole documentation of packages and applied Naming Standards.
• Explained the whole design of Data warehouse for different projects using Visio tool.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily
Load.
• Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Involved in implementing business requirements in Dashboard, Documents and Reports
developed in MicroStrategy.
Stored procedures, Server Management, Naming, BEE, Server, Oracle PL/SQL, CREO, Transformation, Ssis, T-SQL, Design, Visio, Management, Pl/sql, Database, Data Warehouse, SQL Server, Oracle, Sql
2014 - 2015
job
BI Developer
Momin Solutions.
Pakistan
Organization: Momin Solutions, Dubai
Role: BI Developer
Experience: March 2014 to Feb 2015
Job Description:
• Create, maintain and execute test plans, test cases, problem logs, timelines, strategies,
screen captures, problem reports, defects, and summary documents to ensure
application quality.
• Created and executed test cases for all aspects, including smoke, load, stress and regression.
• Validated specific requirements and ensured applications adhered to quality and functional requirements.
• Experience in Business Analysis of the Functional Requirements of the application,
development of functional specifications and project planning.
• Responsible for testing mobile applications for Androids and iPhones.
• Worked closely with product and project managers, developers and change
management to ensure software business requirements are achieved.
MCTS MS SQL Reporting Services Business Intelligence Developer 3
Organization: Momin Solutions, Dubai
Role: BI Developer
Experience: March 2014 to Feb 2015
Job Description:
• Create, maintain and execute test plans, test cases, problem logs, timelines, strategies,
screen captures, problem reports, defects, and summary documents to ensure
application quality.
• Created and executed test cases for all aspects, including smoke, load, stress and regression.
• Validated specific requirements and ensured applications adhered to quality and functional requirements.
• Experience in Business Analysis of the Functional Requirements of the application,
development of functional specifications and project planning.
• Responsible for testing mobile applications for Androids and iPhones.
• Worked closely with product and project managers, developers and change
management to ensure software business requirements are achieved.
MCTS MS SQL Reporting Services Business Intelligence Developer 3
Sql, Business Intelligence, Business Analysis, Management, Test, Test cases, Developer, Testing, Development, Software, BEE
2013 - 2014
job
Senior Executive IT BI
Warid Telecom Pvt Ltd.
Pakistan
Organization: Warid Telecom Pvt Ltd, Pakistan
Role: Senior Executive IT BI
Experience: Dec 2013 to Feb 2014
Job Description:
• Devised and developed corporate business solution for our corporate clients to facilitate
them with monthly corporate bill summaries on bill run basis.
• Developed Corporate Tax Summaries to accommodate business requirements of corporate clients on monthly/yearly basis.
• Supported Ad-Hoc reporting requests which includes some common ad-hoc requests
and change requests as well this includes Monthly/yearly invoices with/without Tax, ad-
hoc CBS requests, billing requests on different parameters, MSISDN's based data
requests etc.
• Generated Invoices with/without Tax against given Customer Number or list of Contract
Numbers or Subscribers Numbers given. Invoices includes total bill amount against each
subscriber and contract number, total tax amount and total Invoice with Tax Details.
• Facilitated GR LEA with 24 hours KPI for their CDRs requests which can be based on
backdated or live data.
• Devised CELL ID based CDRs extraction mechanism.
Professional Project at Warid:
VAS (Value Added Services) Analysis:
• Analyses of all VAS related Services for postpaid & prepaid customers.
• Identify criterion against all active services.
• Developed VAS Services Detail Reports against EQUIP IDs and bill codes for Postpaid e.g:
GPRS- 500 (Infinity) Package or provide details of VAS records attached against given
subscriber/contract Number against a Customer Number.
• Developed VAS Services Detail Report against Transaction Codes for Prepaid.
• Automated these reports on daily basis for Prepaid and bill run wise for Postpaid.
• Make these reports available on Oracle BI Discoverer for clients use.
Organization: Warid Telecom Pvt Ltd, Pakistan
Role: Senior Executive IT BI
Experience: Dec 2013 to Feb 2014
Job Description:
• Devised and developed corporate business solution for our corporate clients to facilitate
them with monthly corporate bill summaries on bill run basis.
• Developed Corporate Tax Summaries to accommodate business requirements of corporate clients on monthly/yearly basis.
• Supported Ad-Hoc reporting requests which includes some common ad-hoc requests
and change requests as well this includes Monthly/yearly invoices with/without Tax, ad-
hoc CBS requests, billing requests on different parameters, MSISDN's based data
requests etc.
• Generated Invoices with/without Tax against given Customer Number or list of Contract
Numbers or Subscribers Numbers given. Invoices includes total bill amount against each
subscriber and contract number, total tax amount and total Invoice with Tax Details.
• Facilitated GR LEA with 24 hours KPI for their CDRs requests which can be based on
backdated or live data.
• Devised CELL ID based CDRs extraction mechanism.
Professional Project at Warid:
VAS (Value Added Services) Analysis:
• Analyses of all VAS related Services for postpaid & prepaid customers.
• Identify criterion against all active services.
• Developed VAS Services Detail Reports against EQUIP IDs and bill codes for Postpaid e.g:
GPRS- 500 (Infinity) Package or provide details of VAS records attached against given
subscriber/contract Number against a Customer Number.
• Developed VAS Services Detail Report against Transaction Codes for Prepaid.
• Automated these reports on daily basis for Prepaid and bill run wise for Postpaid.
• Make these reports available on Oracle BI Discoverer for clients use.
Oracle, SoMe, It, Telecom, KPI, Detail, BEE
2011 - 2013
job
Software Engineer
Systems Limited.
Pakistan
Organization: Systems Limited, Pakistan
Role: Software Engineer
Experience: April 2011 To Dec 2013
Professional Projects at Systems Limited:
FNPC Business Intelligence Services:
• Development of ETL routines using PL/SQL procedures and packages to provide
analytics.
• Experienced in MicroStrategy tool Suite including MicroStrategy Administrator,
MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web and MicroStrategy Narrowcast Server.
MCTS MS SQL Reporting Services Business Intelligence Developer 4
• Exclusive knowledge in creating and integrating MicroStrategy reports and objects
(Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Generated and implemented MicroStrategy Schema objects and Application objects by
creating facts, attributes, hierarchies, reports, filters, metrics and templates using
MicroStrategy Desktop and Architect.
• Created Transformations for comparative reports like sales this year-to-date, Month- to-
date, Quarter-to-date etc.
• Worked extensively on creating Application Objects like Metrics and Compound metrics,
Filters, Custom Groups and Consolidations for complex reports.
• Created complex custom groups using hierarchy to overcome the restriction of
MicroStrategy where total on columns and average on rows cannot be calculated at the same time.
• Designed Prompts and Filters to generate reports in grid and graph mode.
• Designed various kinds of reports like Scorecards & Dashboards, Business Reports, and Ad-hoc Reports.
• Worked with Narrowcast server for sending reports via email to a large executive
distribution group.
• Identification of Key Performance indictors KPI's of system for the development of interactive dashboard design.
• Experienced with Dashboard & Scorecard Reports for Corporate Financial Forecasting as
per user requirements.
• Created Dynamic Dashboard Documents with multiple panel stacks, selectors, and customized widgets.
• Developed dynamic dashboards for iPad & Mobiles using Microstrategy Web & Desktop.
• Created and executed test cases for functional modules of BI application.
• Performed black box (usability, GUI, functionality, regression) testing and gray box
testing (validating test results against backend data).
• Ensured data quality by querying the database.
IBM Ecom Metrics Integration:
• Metrics analysis from IBM Core metrics website.
• Develop the shell scripts in UNIX to extract data from IBM core metrics website for
different brands by using the curl command and place to FTP server.
• Develop the shell script to manage ETL process.
• Develop the ETL process in PL/SQL to read the data file and load data to data
warehouse.
• Manually automate the complete flow of data extraction, ETL process and data loading
to data warehouse by writing the scheduler script in UNIX.
• Development of Facts, Attributes, Metrics and Prompts in BI.
• Designed Ad-hoc report by using attributes, metrics, and geography and time
hierarchies.
PLS (Product Lifecycle System):
• Query Writing in SQL & Oracle
MCTS MS SQL Reporting Services Business Intelligence Developer 5
• Designed Reports of PLS by using Brio & Hyperion in SQR.
• Performed Unit Testing of PLS Application.
• PLS Integration Testing.
• Understanding PLS Domain and incorporating the business requirements in reports
development.
• Functions & Stored Procedures writing.
Organization: Systems Limited, Pakistan
Role: Software Engineer
Experience: April 2011 To Dec 2013
Professional Projects at Systems Limited:
FNPC Business Intelligence Services:
• Development of ETL routines using PL/SQL procedures and packages to provide
analytics.
• Experienced in MicroStrategy tool Suite including MicroStrategy Administrator,
MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web and MicroStrategy Narrowcast Server.
MCTS MS SQL Reporting Services Business Intelligence Developer 4
• Exclusive knowledge in creating and integrating MicroStrategy reports and objects
(Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Generated and implemented MicroStrategy Schema objects and Application objects by
creating facts, attributes, hierarchies, reports, filters, metrics and templates using
MicroStrategy Desktop and Architect.
• Created Transformations for comparative reports like sales this year-to-date, Month- to-
date, Quarter-to-date etc.
• Worked extensively on creating Application Objects like Metrics and Compound metrics,
Filters, Custom Groups and Consolidations for complex reports.
• Created complex custom groups using hierarchy to overcome the restriction of
MicroStrategy where total on columns and average on rows cannot be calculated at the same time.
• Designed Prompts and Filters to generate reports in grid and graph mode.
• Designed various kinds of reports like Scorecards & Dashboards, Business Reports, and Ad-hoc Reports.
• Worked with Narrowcast server for sending reports via email to a large executive
distribution group.
• Identification of Key Performance indictors KPI's of system for the development of interactive dashboard design.
• Experienced with Dashboard & Scorecard Reports for Corporate Financial Forecasting as
per user requirements.
• Created Dynamic Dashboard Documents with multiple panel stacks, selectors, and customized widgets.
• Developed dynamic dashboards for iPad & Mobiles using Microstrategy Web & Desktop.
• Created and executed test cases for functional modules of BI application.
• Performed black box (usability, GUI, functionality, regression) testing and gray box
testing (validating test results against backend data).
• Ensured data quality by querying the database.
IBM Ecom Metrics Integration:
• Metrics analysis from IBM Core metrics website.
• Develop the shell scripts in UNIX to extract data from IBM core metrics website for
different brands by using the curl command and place to FTP server.
• Develop the shell script to manage ETL process.
• Develop the ETL process in PL/SQL to read the data file and load data to data
warehouse.
• Manually automate the complete flow of data extraction, ETL process and data loading
to data warehouse by writing the scheduler script in UNIX.
• Development of Facts, Attributes, Metrics and Prompts in BI.
• Designed Ad-hoc report by using attributes, metrics, and geography and time
hierarchies.
PLS (Product Lifecycle System):
• Query Writing in SQL & Oracle
MCTS MS SQL Reporting Services Business Intelligence Developer 5
• Designed Reports of PLS by using Brio & Hyperion in SQR.
• Performed Unit Testing of PLS Application.
• PLS Integration Testing.
• Understanding PLS Domain and incorporating the business requirements in reports
development.
• Functions & Stored Procedures writing.
Mode, Data quality, Test, Website, Test cases, Usability & UX, Developer, Testing, KPI, Analytics, Development, Software, Web, Server, BEE, Administrator, Backend, Design, Integration, Sales, Stored procedures, Pl/sql, Database, Data Warehouse, ETL, Usability, Unix, Forecasting, Oracle, Business Intelligence, Writing, Backend, Sql
2010 - 2011
job
Software Engineer
Netsol Technologies, Inc.
Pakistan
MCTS MS SQL Reporting Services Business Intelligence Developer 1
Organization: Netsol Technologies, Inc. Pakistan
Role: Software Engineer
Experience: March 2010 TO April 2011
Professional Projects at Netsol Technologies:
NFS (Netsol Financial Suite):
• Query Writing in SQL Server 2005 & Oracle
• Data Model maintenance using ERWin
• Designing Reports of CMS in iReports
• Design changes incorporation in Data Model
• Performed Data Migration activities for CAP & WFS, including data migration using SSIS
packages, unit testing and verification
• CAP Integration Testing
• Functions, Cursors & Stored Procedures writing
GMAC-SAIC China:
• Query Writing in SQL & Oracle
• Performing CAP Application Testing
• Updating Data Model according to specified changes
Abeam Consulting:
• Prepare Prototypes for demonstration at client side.
MCTS MS SQL Reporting Services Business Intelligence Developer 1
Organization: Netsol Technologies, Inc. Pakistan
Role: Software Engineer
Experience: March 2010 TO April 2011
Professional Projects at Netsol Technologies:
NFS (Netsol Financial Suite):
• Query Writing in SQL Server 2005 & Oracle
• Data Model maintenance using ERWin
• Designing Reports of CMS in iReports
• Design changes incorporation in Data Model
• Performed Data Migration activities for CAP & WFS, including data migration using SSIS
packages, unit testing and verification
• CAP Integration Testing
• Functions, Cursors & Stored Procedures writing
GMAC-SAIC China:
• Query Writing in SQL & Oracle
• Performing CAP Application Testing
• Updating Data Model according to specified changes
Abeam Consulting:
• Prepare Prototypes for demonstration at client side.
Integration, SQL Server 2005, Performing, Server, Software, China, Testing, Developer, Ssis, Design, Stored procedures, Consulting, CMS, SQL Server, Oracle, Business Intelligence, Writing, Sql
My education
?
-
2009
Bahauddin Zakriya University
BSc, Computer Engineering
BSc, Computer Engineering
Tahira's reviews
Tahira has not received any reviews on Worksome.
Contact Tahira Ali
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Tahira directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark