Tayyab Ahmed
-
-
Profile
I am a results-driven Data & BI Consultant with 9 years of experience in Data Analytics, Engineering, and
Business Intelligence. My expertise spans SQL, DBT, Data Warehousing (EDW, Data Marts), Azure, AWS, SSIS,
Power BI, Tableau, Excel, and Python.
I have successfully designed and built multiple Data Marts and Operational Data Stores across Energy,
Healthcare, Insurance, Banking, and Retail industries, delivering scalable, high-performance analytics
solutions. With 7+ years of experience in AWS (S3, Lambda, Redshift) and Power BI, and 5+ years mastering
Microsoft BI Stack (SSIS, SSRS, SSAS) and PL/SQL, I have a deep understanding of ETL processes, data
modeling, and real-time reporting.
I thrive in collaborative environments, excelling as both a leader and a team player. I take ownership of
challenges, ensuring timely, high-quality deliverables with a problem-solving mindset and a can-do attitude.
My strong communication, presentation, and stakeholder management skills ensure that solutions not only
meet technical requirements but also drive business success and client satisfaction.
Data isn’t just numbers to me—it’s a story waiting to be told, and I love turning raw information into actionable
insights that drive real-world impact.
Experiences
E-TeleQuote Insurance Inc. (A GoHealth Company) June 2023 – Present
Director Reporting & Analytics (Remote)
Key Function & Responsibilities:
•
Lead the Reporting & Analytics division, driving data-driven decision-making for business operations
and Medicare sales performance.
•
Oversee the design, development, and optimization of Datawarehouse, Reporting and BI solutions,
including Power BI dashboards and automated reporting frameworks.
•
Manage data integration and alignment between E-TeleQuote and GoHealth’s CRM & Databricks-based
data infrastructure.
•
Collaborate with senior leadership and cross-functional teams to enhance data accessibility, accuracy,
and strategic insights.
•
Spearhead initiatives to improve ETL processes, data warehousing, and performance analytics, ensuring
seamless data flow and reporting efficiency.
•
Partner with GoHealth’s CTO and Data Team to integrate E-TeleQuote’s data warehouse into
GoHealth’s Customer 360 (C360) platform.
10Pearls Mar 2021 – May 2023
Staff Business Intelligence Developer Lahore, Pakistan
Key Function & Responsibilities:
•
•
•
•
•
•
•
Leading a team of Data Engineers & BI Developer.
Assisting the team with performance tuning for ETL and database processes.
Manage project and task priorities of other developers on the project.
Meetings and discussion directly with US Clients for project roadmap and also work for future scope.
Design, develop, implement and assist in validating processes.
Work with data providers to fill data gaps and/or to adjust source-system data structures
to facilitate analysis and integration with other company data.
Develop security procedures to protect Enterprise Datawarehouse from unauthorized usage.
Future Now (Pvt) Limited Jan 2018 – Feb 2021
Senior Software Engineer Lahore, Pakistan
Key Function & Responsibilities:
•
•
•
•
Design, develop, implement and assist in validating processes
Self-manage time and task priorities and of other developers on the project
Develop mapping / sessions / workflows
Conduct ETL performance tuning, troubleshooting, support, and capacity estimation
Future Now (Pvt) Limited Mar 2016 – Dec 2017
Software Engineer Lahore, Pakistan
Key Function & Responsibilities:
•
•
•
•
•
•
Develops and enhances complex systems and/or software from requirements and specifications.
Participates as technical expert to analyze technical system problems, and designs and
implements effective solutions.
Creates SSIS packages using BIDS (Business Intelligence Development Studio) so that we can merge
data from multiple data sources and populate data warehouses with clean and standardize
data.
Contributes to the development of project plans.
Assists in training less experienced software development staff.
Work with business analysts and developers to create technical solutions that meet business
and technical requirements.
•
•
Contribute to efforts to improve quality of applications.
Participate in code, design reviews and maintain technical documentations.
Techleadz (Pvt) Limited Jan 2014 ‐ Mar 2016
Web Developer Lahore, Pakistan
Key Responsibilities:
•
•
•
•
•
•
Program, test and debug web applications.
Develop appropriate code structures to solve specific tasks.
Design, develop and implement database systems based on customer requirements.
Create complex functions, scripts, stored procedures and triggers to support
application development.
Coordinate with other designers and programmers to develop web projects.
Assist and support in the up keep and maintenance of web sites.
Projects
E-TeleQuote Insurance July 2024 – Present
Company: E-TeleQuote Insurnce Inc.
Tools: SQL Server, SSIS, Power BI, SSRS, Informatica, CRM, Google Ads, Facebook Ads, Financial Systems, Carrier
Systems, Azure Databricks.
As the Director of Reporting and Analytics, I led the development of a data warehousing and
business intelligence solution for E-TeleQuote Insurance, a Medicare plan broker. Leveraging my
project management skills, I directed the centralization of data from online/offline marketing,
agent sales, and carrier performance into a SQL Server data warehouse. Using Power BI and SSRS,
we created dashboards and reports for lead tracking, agent performance, and carrier sales.
Automated reporting and real-time analytics enhanced decision-making, increasing lead
conversion by 25%, reducing manual reporting by 60%, and ensuring Medicare compliance. Key
tools included SQL Server, SSIS, Power BI, and CRM integration.
Squeaky Energy Oct 2021 – May 2023
Company: 10Pearls (Pvt)Limited.
Tools: AWS Redshift, SQL, Python, DBT, Talend, S3, Lambda, Informatica
This project is related with AWS Redshift. Here we implemented a data warehouse for the Energy
sector. Multiple data marts are also established depends upon the reporting layer. Our processes
depend upon the Billing, Half hourly consumption, Capacities, Cashflows and flow of energy.
Bank Salesforce Integration Mar 2021 – Oct
2021 Company: 10Pearls (Pvt)Limited.
Tools: Power BI, SSIS, SQL, Salesforce
This project is related with SSIS and DBT, but here we have to implement different Business
intelligence for Salesforce marketing cloud. Here we have to extract data from Salesforce Instance
and pushed it into the Staging server, where we implement multiple data cleansing, transformation
tasks. Use of lookups and then merge data into single source of truth that is upserting into a
Salesforce Object.
Insurance Application (IA) Jul 2016 – Feb 2021
Company: Future Now Technologies (Pvt)Limited.
Tools: PowerBI, Azure Data Factory, BLOB Storage, SQL
Server
Enterprise Datawarehouse for one of my insurance clients. Our processes are for
consolidated data for Insurance agents, Insurance premiums and Insurance claims. The client has
different sources of data i.e., XML, JSON, SQL, ADO.net & Excel sheets. We did this using SQL Server
Integration Services (SSIS) & Azure Data Factory. After that I created multiple Dashboard for
Insurance insights using PowerBI.
Labor Market Information System (LMIS) Mar 2016 ‐ Jul
2016 Company: Future Now Technologies (Pvt) Limited
Tools: PHP, CodeIgniter, JavaScript, Angular Js, SQL Server, Bootstrap.
LMIS is the systematic collection, analysis and dissemination of information regarding the demand
for and supply of Labor in Punjab Province.
Project Management System Nov 2014 ‐ Mar 2015
Company: Techleadz Pvt Ltd
Tools: ASP.Net MVC, jQuery, JavaScript
Task management helps to assign tasks and deadlines to employees and monitor their
performance on completion of these tasks. All the tasks are assigned with a start and end date,
employees update the task on completion. Administrator and employees with special
administrative permissions can check the status of the task and prepare report when it is complete.
Human Resource Information System Jan 2014 ‐ Mar
2015 Company: Techleadz Pvt Ltd
Tools: ASP.Net MVC, jQuery, JavaScript
An intersection of human resources and information technology through HR software. This allows
HR activities and processes to occur electronically.
To put it another way, a HRIS may be viewed as a way, through software, for businesses big and
small to take care of a number of activities, including those related to human resources,
accounting, management, and payroll. A HRIS allows a company to plan its HR costs more
effectively, as well as to manage them and control them without needing to allocate too many
resources toward them.
Education
•
•
•
BS(Honors)in Computer Sciences from COMSATS institute of information technology (2010‐
2014).
Intermediate (ICS) from Pakistan Airforce Intermediate College, Lahore. (2008 - 2010)
Matric from Army Public School, Lahore. (2007 - 2008)
Interpersonal Skills
•
Leadership – Leading cross-functional teams in developing reporting and analytics solutions.
•
Communication – Effectively conveying complex technical concepts to non-technical
stakeholders and senior leadership.
•
Collaboration – Working closely with marketing, sales, and IT teams to align data
strategies with business objectives.
•
Problem-Solving – Resolving data-related challenges and ensuring seamless integration
of various systems.
•
Stakeholder Management – Engaging with senior leadership, agents, and external vendors
to ensure data and reporting needs are met.
•
Adaptability – Adjusting to shifting priorities in a fast-paced environment.
Technical Skills
•
•
•
•
•
•
•
Dimensional Modeling, Power BI, EDW, DBT, S3, Stitch, Talend, SSIS, SSRS, MDM, Microsoft
Azure, ADF.
ETL Development. Control flow task, data flow task, lookups, data cleansing, data
massaging, data validations using SQL Server Data tools 2012.
Languages (Python, .Net, PHP, Gold).
. Net software (visual studio).
PHP Software (Dreamweaver, Eclipse, Easy PHP).
Web Development (PHP, ColdFusion, JavaScript, HTML, CSS, XML, AJAX, jQuery).
Database Software’s (PostgreSQL, Teradata, My‐SQL, Microsoft SQL Server (2005,2008),
Oracle11g, MS‐ Access