Professional Services Consultant at Bilytica Private Limited
Work categoryProfile Activity
Abdus Saboor Ahmad's Professional Experience
Bilytica Private Limited - Professional Services Consultant
-Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
-Analyze user requirements and, based on findings, design functional,specifications for BI front-end applications.
-Develop the semantic layer, metadata, reports, and report definitions.
-Write relational and multidimensional database queries,
-Create and deploy Ad hoc reports,customizing Graphs and reports as per client requirements,
-Design,plan,debug, monitor, and troubleshoot BI solutions,
-Work with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.
-Providing BI Consultancy in different BI Technologies in the Market like Microstrategy, SSRS, Cognos , OBIEE, Tableau etc..
-Data Integration/Synchronization for Sifter API [It's just a simple and friendly hosted bug tracking tool designed for small teams] and Google DFP API [Google's DoubleClick for Publishers (DFP) API lets developers build applications that interact directly with Google's next-generation display advertising platform]
*Fetch the data using API's Client Library (C#) from respective Sifter & DFP URL's and Load data into MySQL DB for BI Analysis Purpose,Schedule the job to run on daily basis.
~: Conduct in House Staff Training :~
(i)- Tableau
(ii)- Microstrategy (MSTR)
~*HP Dashboard*~
-Conversion Company
~* Micro-strategy Training *~
-Client: 'Joseph Berwind'
~* Mobily ( KSA Telecom Company Location Riyadh,C3 Mobily near Kingdom Tower) OBIEE Project (Marketing Dashboard Business Intelligence Reporting)
Analytics Pvt Ltd - ETL/BI Developer
Job Responsibilities:*
-Capture ETL Requirements,
-Logical and Physical Data Modelling
-Design, Develop ETL solution using Teradata Tools and Utilities (Software-as-a-Service (SaaS) model with Teradata) and test processes for extracting data from legacy systems or production databases,
-Design, develop, and test processes for validating and conditioning data prior to loading into a data warehouse,
-Design, develop, and test processes for loading initial and cyclical data into a data warehouse,
-Develop and unit test semantic layers, reports, and GUIs
-Define BI application requirements.
~*Trainings*~
*Teradata Factory
Instructor: Mr. Adnan Yousuf Kazi and Mr. Tahir Hussain Syed,
Teradata Lahore,Pakistan.
*Microstrategy (Business Intelligence Tool)*
Instructor: Mr. Belal Saeed
Teradata Lahore,Pakistan.
~*Project :Courier Industry*~
-LDM and PDM
-Source Mapping Document
-ETL Process using Teradata Utilities
-Unit Analysis Testing (UAT)
-Business Intelligence Reporting in MSTR
~*XML to CSV Tool*~
Make a .Net Application which fetch data from client server,data format is XML and convert it into the csv file which is used in the ETL process.
~*Talend Open Studio (TOS)*~
-Operational Data Integration,
-Data migration and synchronization,
-Implement complete ETL Process in TOS,
-Highly scalable and fast execution open source platform that leverages a grid of commodity hardware, and the only solution to support the dual ETL + ELT architecture.
-Built-in advanced components for ETL, including string manipulations, Slowly Changing Dimensions, Automatic Lookup handling, bulk loads support, etc.
*~*Implement Change Data Capture Process in TOS means
Connect to the Client Remote Server to fetch data from MYSQL DB convert it into CSV zip file after that move it from the Local Server to the Remote Server and remove the data from server if its Older than 2 weeks ~*
~: Details about TOS @ http://www.talend.com/solutions-data-integration/etl-for-analytics.php