Tayyab Ahmed

Tayyab Ahmed

$25/hr
Data Engineering, Data Analytics & Data Visualization.
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
33 years old
Location:
Lahore, Punjab, Pakistan
Experience:
7 years
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
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.