Ali Y.
Passed Allshore's advanced assessmentPortfolio
Aga Khan University Examination Board
Aga Khan University Examination Board (AKUEB) project is one of the first technology-enabled boards in Pakistan, It has many challenging modules like E-enrollment, school affiliation, question bank, personalized exams, secure electronic marking, online and transparent results, etc. Worked on managing the development team, identified the requirements, managed project timelines and the quality of the products. Used VB6 & VB.NET Desktop, SQL Server, TFS, JIRA, SQL Queries, and Data Model using ERWIN.
Sales Tracker Dashboard for Branch Banking
Sales tracker dashboard keeps up-to-date C-level executives about branch banking financial targets. It includes current statuses of a deposit, top-performing branches, and other product targets such as insurance, loans, debit and credit cards, etc. Worked on building automation of data pipelines and fetched data from different systems and pushed in Data Warehouse. Used SSIS, SQL Server, Dimension Modeling, Testing of Dashboard, Tableau.
URL: https://www.hbl.com/
Master Data Management of Patient Information
Aga Khan University and Hospital (AKUH) is one the best and state of art hospitals in Pakistan. AKUH offers a lot of patient services such as In-patient, Out-patient, Radiology, Laboratory, billing, etc. Worked on the integration of all modules and managed the master data management. Used SSIS, IBM Cognos Framework Manager, IBM Cognos Report Designer, C#, SQL Server,
Experience
- ETL - 10+ years
- Power BI - 10+ years
- SSIS - 10+ years
- PL/SQL - 10+ years
- MS SQL Server - 10+ years
Availability
Preferred Environment
The most amazing...
Change is inevitable but growth is optional.
Projects
Aga Khan University Examination Board
Aga Khan University Examination Board (AKUEB) project is one of the first technology-enabled boards in Pakistan, It has many challenging modules like E-enrollment, school affiliation, question bank, personalized exams, secure electronic marking, online and transparent results, etc. Worked on managing the development team, identified the requirements, managed project timelines and the quality of the products. Used VB6 & VB.NET Desktop, SQL Server, TFS, JIRA, SQL Queries, and Data Model using ERWIN.
Sales Tracker Dashboard for Branch Banking
Sales tracker dashboard keeps up-to-date C-level executives about branch banking financial targets. It includes current statuses of a deposit, top-performing branches, and other product targets such as insurance, loans, debit and credit cards, etc. Worked on building automation of data pipelines and fetched data from different systems and pushed in Data Warehouse. Used SSIS, SQL Server, Dimension Modeling, Testing of Dashboard, Tableau.
URL: https://www.hbl.com/
Master Data Management of Patient Information
Aga Khan University and Hospital (AKUH) is one the best and state of art hospitals in Pakistan. AKUH offers a lot of patient services such as In-patient, Out-patient, Radiology, Laboratory, billing, etc. Worked on the integration of all modules and managed the master data management. Used SSIS, IBM Cognos Framework Manager, IBM Cognos Report Designer, C#, SQL Server,
Work Experience
Allshore Virtual Staffing
Data Architecture
Project19
- Identified data sources, both internal and external, and worked out a plan for data management that is aligned with organizational data strategy.
- Coordinated and collaborated with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise data system.
- Managed team of BI developers and reviewed their progress.
- Developed and managed the data model of the data warehouse.
- Developed and managed data pipeline using SSIS and Store Procedures to sync the data warehouse.
- Developed and published dashboard board and business reports using Tableau and Power BI.
- Design, develop, and optimize ETL pipelines through best practices for Data Engineering.
- Design, develop, and maintain optimized data-centric solutions including components for ETL, Data Warehousing, Data Modeling, and Visualizations.
- Manage a portfolio of solutions, work with multiple stake holders and communicate effectively on progress and blockers with project team and sponsors.
- Adopt existing best practices or contribute to improving them.
- Work on ad-hoc and urgent requests in a timely manner.
Unit Head Project Manager
HBL
- Identified data sources, both internal and external, and worked out a plan for data management that is aligned with organizational data strategy.
- Coordinated and collaborated with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise data system.
- Established and managed the BI reporting unit.
- Provided training to functional users about their reporting needs.
- Developed Sales Tracker Dashboard in Tableau and integration with MS-Excel.
- Developed Compliance Performance KPI software using .NET C# Desktop.
- Managed ad hoc reporting for the regularity authorities using SSRS, SQL Queries, Tableau, and Excel.
- Manage Business Compliance projects and automation of business process.
- Lead and manage MIS and As Unit Head Project Manager, managed Business Compliance projects and automated business processes while leading and managing MIS and data analytics projects.
- Spearheaded the enterprise data lake project, developed and monitored data ingestion pipelines using SSIS and PySpark and feeds into the Data Lake and DWH, and led the development of regulatory reports and C-Level dashboards in Tableau and Power BI.
Education
Master of Science in Information Technology
Hamdard University, Karachi
Bachelor of Science in Computer Science
Institute of Leadership & Management (ILM)
Certifications
IBM Cognos Framework Development
Tableau Desktop 1 and 2
- Schedule A
Free Consultation - Interview remote
Professionals - Meet Your team
- start your
10-day free trial
UNPRECEDENTED CUSTOMER SUPPORT
You have complete control over project management, priorities, and deadlines, but we’re here to help you succeed. Your Client Success Manager and Technical Success Managers are with you every step to ensure that our work for you it top notch. Feel free to use your project management system or our complimentary Basecamp account.
COMMUNICATION AND TRANSPARENCY
No project can be successful without effective communication. Our remote professionals are fluent English speakers, vetted and trained in effective communication and are available to you directly in real-time. We allow direct, real-time access to your team via Skype, GoToMeeting, or other communication software. You can have meetings on your time and get demos anytime you want.
AMERICAN OWNED AND OPERATED
Work with an American company under American laws and regulations. Our offshore employees work U.S. business hours so you can communicate directly with them. Our month-to-month contracts protect our clients’ intellectual property and projects, so you can focus worry-free on your work.
QUALITY WORK - GUARANTEED
Even after passing our rigorous interview process, our remote professionals are continuously training to learn new skills and keep up with changing trends in their fields. We guarantee our associates work, and have a 99.5% customer satisfaction rating. We take quality, and your success, seriously.