Data & Application Consultant

• Jul 2023 - Present

Data & Application Consultant

• Jun 2022 - Jun 2023

* Design new multi-source data architecture (Data Lake, Data Mesh), roadmap, principle and standards. * Plan, design and develop benchmark solutions for data management, migration, and integration for existing data warehouse to new modern data warehouse design for increasing data. * Optimise existing application & analytics data to support current business operations. * Create on-prem data solutions similar to modern big data technologies and architecture. * Defined and agreed upon data & application priorities for feature delivery to cross-functional business and technical team members. * Redesigning and migration of excel based dashboard to PowerBI on-prem and cloud. * Design and Develop extensive operation and analytical features in Procurement web application. * Design and delegate new application features to the team. Show less

Senior Technical Architect

• May 2022 - Jun 2022

• Engage all business, data science, visualisation, and other technical team members to gather requirements through new strategies and design solutions across all modern data and visualisation platforms. • Design and document data architecture for structural, semi-structural, and unstructured data (NoSQL / Object Storage). • Understanding data structure, extracting and managing meta-data, business catalogue and master data management. • Design conceptual, logical, and physical data model for operational, data warehouse, data lakes and Data Mesh (Domain-Oriented) on appropriate cloud / on premises platform. • Design data modelling standards and tools infrastructure aligned with best practices related to the enterprise data model and contribute to data governance norms. • Ensure high data quality and reduced redundancy to comply with use cases • Ensure the data model is mature and complies with data governance and management principles. • Design, implement and support technical team for optimised data delivery. • Version controlling, configuration, performance tuning and creation of sandbox POC. Show less

Data & Analytics Architect

• Jan 2021 - Apr 2022

* Data Migration, modelling and data management architecture. * Design, develop and maintain the optimum data pipeline architecture. * Assemble large, complex data sets that meet the functional and non-functional requirements of the activities. * Identify, design, and implement internal process improvements such as manual process automation, data delivery optimization, infrastructure redesign for greater scale-up, etc. * Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using best-practice technologies. * Develop analytics tools that use the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other company key performance indicators. * Collaborate with stakeholders, including management, product, data, and design teams, to help address technical data issues and their data infrastructure needs. * Implement technologies to support data governance and management framework to establish common business lexicon, metadata, cataloging, lineage, reference, and master data, etc. While keeping data separate and secure as appropriate. * Develop analytical data tools to help create and optimize our product. Work with data and analytical expertise to improve the functionality of our data systems. Enterprise Data Warehouse (In Progress with following) Data virtualization (Polybase) Apache Kafka, Confluent Platform LAMBDA Architecture AVRO, JSON, XML, PARQUET Web API / Postman Python / PySpark / jupyter notebook Data Governance Data Profiling, Lineage, Cataloging, Quality, Reference, and Master Data Management DevOps / DataOps Data Vault 2.0 SSAS Power BI Linux, Docker Show less

Data and Analytics Consultant

• Jun 2020 - Jan 2021

* Data warehousing & BI Development using SSIS, Yellowfin, Power BI, SSRS * POC for SQL Server (SSRS,SSIS)To Snowflake and Power BI migration * Database DevOps (Git, Github, Azure DevOps, Octopus, C#) * JIRA, ZENDESK, Kanban, Scrum * Consumer client for Yellowfin to import and export using C#, to automate CI/CD * ETL/ELT * Data warehousing & BI Development using SSIS, Yellowfin, Power BI, SSRS * POC for SQL Server (SSRS,SSIS)To Snowflake and Power BI migration * Database DevOps (Git, Github, Azure DevOps, Octopus, C#) * JIRA, ZENDESK, Kanban, Scrum * Consumer client for Yellowfin to import and export using C#, to automate CI/CD * ETL/ELT

Senior Software Engineer

• Feb 2020 - May 2020

* Data Migration, Integration & ETL/ELT Development * Back-End .Net Web API Development * Azure SQL, Azure Data Factory, Azure Portal Management * C#, SQL / TSQL, Cordova / Phonegap * John Deere API, Zoho API, Xero API, Google Map APIs, SPATIAL, GeoJson, ESRI Shape files and many more external data sources. * Azure webhooks and function * ETL Processes for JSON, XML, Flatfiles, SQL Server, Azure SQL * OAuth 1.0 three leg, OAuth 2.0 * Data Migration, Integration & ETL/ELT Development * Back-End .Net Web API Development * Azure SQL, Azure Data Factory, Azure Portal Management * C#, SQL / TSQL, Cordova / Phonegap * John Deere API, Zoho API, Xero API, Google Map APIs, SPATIAL, GeoJson, ESRI Shape files and many more external data sources. * Azure webhooks and function * ETL Processes for JSON, XML, Flatfiles, SQL Server, Azure SQL * OAuth 1.0 three leg, OAuth 2.0

Senior Business Intelligence Consultant

• Aug 2019 - Feb 2020

* Business Intelligence - SQL Server Stack (SSIS, SSAS, SSRS), Azure SQL Database, Postgre * Full-Stack .Net (JQuery, Javascript, Typescript, AJAX, Bootstrap, Angular & Material) * Business Intelligence - SQL Server Stack (SSIS, SSAS, SSRS), Azure SQL Database, Postgre * Full-Stack .Net (JQuery, Javascript, Typescript, AJAX, Bootstrap, Angular & Material)

BI Developer & Analyst Programmer (IT Programmer)

• Nov 2014 - Jul 2019

* SQL Server (SSIS, SSAS, SSRS), Excel (Power Query, Power Pivot), Access VBA, Excel VBA * ASP.Net MVC, C#, Javascript, JQuery, AJAX, CSS, HTML This was a multi-role commitment consist of project lead, liaison, business intelligence and data warehousing, web and desktop application development. Responsibilities: * Requirement gathering from all stakeholders, analyzing, researching and evaluating software and BI requirements. * Defining project scope, time and budget, and getting approval from the Managing Director. * Suggesting any technical improvements in infrastructure or workflow designs and seeking approval. * Directly reporting to the Managing Director for project status to ensure, development is going on time, within budget and up to the specification. * Deployment of tested and approved software and BI solution conducting training sessions. * Testing, debugging, troubleshooting and correcting errors in applications, ETL processes, dashboards, reports, and other supporting operation applications. * Writing and suggesting common best practices to synchronize all team members delivering stable solutions such as scripting, coding, reporting, dashboard, ETL design patterns such as SCD type 1, 2 and query optimization. * Getting approval for change requests and modifying the existing reports, dashboards and software application to meet the new business needs. Show less

Technical Team Lead (ICT Manager)

• Jun 2010 - Oct 2014

* SQL Server (SSIS, SSAS, SSRS), Excel (Power Query, Power Pivot) * ASP.Net MVC, C#, Javascript, JQuery, AJAX, CSS, HTML, Access, Crystal Reports. * Designing MIS, Data warehousing, Business Intelligence, IVR, CTI, Dashboard, Real-Time Solution * Requirement gathering, designing, development, deployment, troubleshooting and deployment. * Proposals and bidding on local and online projects (odesk, elance, freelancer, guru) * SQL Server (SSIS, SSAS, SSRS), Excel (Power Query, Power Pivot) * ASP.Net MVC, C#, Javascript, JQuery, AJAX, CSS, HTML, Access, Crystal Reports. * Designing MIS, Data warehousing, Business Intelligence, IVR, CTI, Dashboard, Real-Time Solution * Requirement gathering, designing, development, deployment, troubleshooting and deployment. * Proposals and bidding on local and online projects (odesk, elance, freelancer, guru)

Technical Team Lead (AM Professional Services)

• Sep 2006 - Jun 2010

* SQL Server (SSIS, SSAS, SSRS), Excel (Power Query, Power Pivot) * C#, ASP.Net 2, Javascript, JQuery, AJAX, CSS, HTML, Access, Crystal Reports. My responsibilities include requirement gathering, customer support, customer relationship, proposals and bid against requests for software portion for a Trunkey Solutions team player, R & D for VAS, Software Development and Team Lead. My major achievements in this company were; IVR R & D and successful creation of Prototype and CTI Application, Apollo Complaint Management System, Apollo MIS containing more than 200 reports, Data warehousing environment in ufone (Designed, Developed and Deployed an integrated and optimized data marts and data warehouse for ACD, PABx, Recorder, CTI, IVR DBs in a multidimensional model). Show less

PL/SQL Developer (IT Executive)

• Mar 2006 - Sep 2006

Oracle DBMS, PL/SQL, Forms, Reports, Designer, VB.Net, Excel VBA My responsibilities include customization and addition of new ETL and reporting modules in existing data warehousing environment, and to develop some new software to improve the company's processes. During this tenure, I Analyzed, Designed and Developed an Interconnect Billing System named as Banyan Tree Oracle DBMS, PL/SQL, Forms, Reports, Designer, VB.Net, Excel VBA My responsibilities include customization and addition of new ETL and reporting modules in existing data warehousing environment, and to develop some new software to improve the company's processes. During this tenure, I Analyzed, Designed and Developed an Interconnect Billing System named as Banyan Tree

PL/SQL Developer (Software Support Engineer)

• Sep 2005 - Mar 2006

I was responsible for technical support , customization and mentoring monthly operations, using Telco Plus! A "Telco Plus" is a complete CRM solution for telecommunication sector needed to run an efficient and cost effective telecommunication business. Telco Plus consist of the following primary modules: Customer Care Management Franchise Management and Care Supply Chain Management Work-flow Management Switch Provisioning Switch Mediation Interconnect Show less

PL/SQL Developer (Software Engineer)

• Mar 2005 - Sep 2005

At CIBTech (under the umbrella of Citibank Global Technology), as a Software Engineer, I was responsible for the analysis, development, and delivery of multiple projects of CIBTech clients (Citibank departments); including HR, Credit Admin, CMG Operations. At CIBTech (under the umbrella of Citibank Global Technology), as a Software Engineer, I was responsible for the analysis, development, and delivery of multiple projects of CIBTech clients (Citibank departments); including HR, Credit Admin, CMG Operations.

PL/SQL & BI Developer (Software Engineer)

• Oct 2003 - Mar 2005

My role here was as a Software Engineer with major as a Developer, I proved here as a self starter and fast learner with my analytical skills and as great team player. My major projects were PMS (Payment Management System), Customized Reporting for Nortel Symposium Call Center Server (ACD), CR-LIMS (Leasing and Installment Management System) for Faysal Bank Ltd. My role here was as a Software Engineer with major as a Developer, I proved here as a self starter and fast learner with my analytical skills and as great team player. My major projects were PMS (Payment Management System), Customized Reporting for Nortel Symposium Call Center Server (ACD), CR-LIMS (Leasing and Installment Management System) for Faysal Bank Ltd.

PL/SQL Developer (Programmer I)

• Mar 2002 - Sep 2003

My responsibilities were; Analysis of Current System and GAP Analysis with proposed system, Conversion of entire FoxPro ERP environments to customized Oracle ERP environement , Development & Documentation of Proposed Systems, Maintenance and Support of Existing system My responsibilities were; Analysis of Current System and GAP Analysis with proposed system, Conversion of entire FoxPro ERP environments to customized Oracle ERP environement , Development & Documentation of Proposed Systems, Maintenance and Support of Existing system