Faheem Khan Email & Phone Number

Pakistan

Consulted on development of DWH and OLAP databases for an offshore client. Consulted on critical analysis of a healthcare R&D web portal for physician and medicine practitioners. Led / guided multiple ETL / ELT projects for various clients across multiple industries as well as helped developed dashboards. Worked with startups on healthcare products as well as distribution products.Conducted chance training courses on Software Architecture & Cloud Computing (MS Azure Web Apps &… Show more Consulted on development of DWH and OLAP databases for an offshore client. Consulted on critical analysis of a healthcare R&D web portal for physician and medicine practitioners. Led / guided multiple ETL / ELT projects for various clients across multiple industries as well as helped developed dashboards. Worked with startups on healthcare products as well as distribution products.Conducted chance training courses on Software Architecture & Cloud Computing (MS Azure Web Apps & Azure SQL Database)Conducted training on "Deploying HA / DR solutions using MS SQL Server" for DBA(s) working at banking sector. Coached/assisted on a few interesting projects e.g. privacy focused browser written in C#, additionally worked on video conferencing interface for Android / iOS. In addition, developed scrappers in C# for scrapping web & PDF documents. Consulted on improving software architecture of retail/POS system, Tuning and Performance Optimization of database as well as HA / DR processes & strategies for throughput load distribution.Completed R&D on a Forex app for Android & iOS, distinct to this I also provided E2E solution(s) for business automation for small automobile traders i.e. lead generation to automatic dialing using Xlite / Bria API plus asp.net interface. Show less

Abu Dhabi

Worked on Port Transit modules built on Microsoft technology stack i.e. C#.net, Biztalk Server, Microsoft SQL Server. Mainly participated in back-end development of port transit modules.

Karachi, Pakistan

Managed large scale EDWH / Analytical Processing solutions built on MS SQL Server 2012 and AWS (Redshift) for a large automobile dealers (U.S.) along with sister-concern financial entity (U.S.). Virtualized management interfaces to the entities infrastructure using VMware Workstation / VirtualBox for better and simultaneous management of DB Servers. HA maintenance and Performance Tuning and Optimization of SQL Server objects and processes.Developing ETL / ELT solutions using custom… Show more Managed large scale EDWH / Analytical Processing solutions built on MS SQL Server 2012 and AWS (Redshift) for a large automobile dealers (U.S.) along with sister-concern financial entity (U.S.). Virtualized management interfaces to the entities infrastructure using VMware Workstation / VirtualBox for better and simultaneous management of DB Servers. HA maintenance and Performance Tuning and Optimization of SQL Server objects and processes.Developing ETL / ELT solutions using custom components (SFTP), DTS components and intrinsic components build in SSIS.Developed test reports and data visualization using Tableau and PowerQuery®Maintenance / Study of CDR billing (Telecom) product inclusive of its front-end (ASP classic) and back-end (SQL Server 2000). Developed UX design for the improved version of the product suing MS SketchFlow.Developed a SaaS PoC for a healthcare client using ASP.net 4.0, Knockout.js, Backbone.js, HTML, CSS and SQL Server®.Developed UX design for another healthcare project using Balsamiq®. Show less

Karachi, Pakistan

Maintenance of a business application comprising of 20+ million LOC in VB6 built using Layered Architecture (n-tier). Developed data synchronization C#.net Windows service to run between client(s)/server to synchronize the server database and client database. It also has a complex set of time table for scheduling, as well as notification system. Developed fully functional prototype using DocuSign API to be incorporated into VB6 application as inter-operable component. Led… Show more Maintenance of a business application comprising of 20+ million LOC in VB6 built using Layered Architecture (n-tier). Developed data synchronization C#.net Windows service to run between client(s)/server to synchronize the server database and client database. It also has a complex set of time table for scheduling, as well as notification system. Developed fully functional prototype using DocuSign API to be incorporated into VB6 application as inter-operable component. Led development of DWH for capturing observability data from multiple ERP(s) and helped develop scorecard for observability. Show less

Built web interfaces using asp.net 3.5, jQuery for call center analytics.Led, managed & developed DWH / OLAP database(s) for call center analytics, besides maintaining web interface built using asp.net 2.0. In addition, built boilerplate forms (MS Word), and knowledgebase database for L2-L3 support teams as well as cross-functional teams.Built a watchdog PoC application using VC++, MSU codec and ITU-T specification.Built some web view using ASP.net 2.0 (Web forms) for an HRM MS… Show more Built web interfaces using asp.net 3.5, jQuery for call center analytics.Led, managed & developed DWH / OLAP database(s) for call center analytics, besides maintaining web interface built using asp.net 2.0. In addition, built boilerplate forms (MS Word), and knowledgebase database for L2-L3 support teams as well as cross-functional teams.Built a watchdog PoC application using VC++, MSU codec and ITU-T specification.Built some web view using ASP.net 2.0 (Web forms) for an HRM MS SharePoint application, and interacted with globally distributed team. Functioned as a member of production DBA team performing Backups, data archiving, index organization and server management. Led platform transition as SME expert with a distributed team for 3 subsidiaries. Developed CRM programs using proprietary software mostly for 𝖥𝗈𝗋𝗍𝗎𝗇𝖾® 𝟧𝟢𝟢 companies. Show less

Managed data migration of a financial institution during her M&A, in addition ensured data conformity to the resident data model of the flagship product. Prime developer for SQL development of flagship product, and led DB team in development / management of stored procedures, triggers, views and functions as well as complex business reports using SSRS and crystal reports.Improvised database architectures, designs and led team members perform tuning and performance optimization (TPO) of… Show more Managed data migration of a financial institution during her M&A, in addition ensured data conformity to the resident data model of the flagship product. Prime developer for SQL development of flagship product, and led DB team in development / management of stored procedures, triggers, views and functions as well as complex business reports using SSRS and crystal reports.Improvised database architectures, designs and led team members perform tuning and performance optimization (TPO) of SP(s), View(s), and UDF(s).Employed ETL / ELT procedures (T-SQL scripts) as premier methodology to migrate data from disparate /legacy databases to MS SQL Server 2000.Development DBA operations such as differential / regular DB backups, data archiving, and job scheduling of DTS packages, and windows batch file(s). Managed iterative incorporation of change requirement to flagship product by updating the database models & all affected DB objects.Contributed for adoption of DBA tools, product phase database deployments and DB development practices.Early adoption of SSRS and helped team to integrate in asp.net web view(asp.net web forms).Development of DWH using Kimball methodology.Initiated exploration of SQL Server 2005. Show less

Karachi, Pakistan

Individually contributed highly to the development of an academic institution management solution producing 46% increase in initial price quote. In addition to developing the all modules for the system, I also developed 130+ business reports such as cross-tab, ageing and returns. Heavily worked as development engineer on ERP(AIS) modules like HRM, Inventory, Procurement, Sales and etc. for various clients and played a role of QA engineer for a Retail Management System. Took part in… Show more Individually contributed highly to the development of an academic institution management solution producing 46% increase in initial price quote. In addition to developing the all modules for the system, I also developed 130+ business reports such as cross-tab, ageing and returns. Heavily worked as development engineer on ERP(AIS) modules like HRM, Inventory, Procurement, Sales and etc. for various clients and played a role of QA engineer for a Retail Management System. Took part in developing a few addendums to Procurement / Purchase modules. The system was built in AS400 RPG for large automobile manufacturer.Developed many independent interface modules using Win32® API. Show less

Karāchi, Sindh, Pakistan

• Consulted multiple clients for IT infrastructure development/procurement/deployment.• Consulted on implementation of educational software system across 10 branches of an institution. • Consulted a telecom client for transformation of legacy application to new technology platform. Study the legacy application, and preparation of gap analysis report, preparation of SOW and proposal. Led the development of the software application as well as complex data reports. •… Show more • Consulted multiple clients for IT infrastructure development/procurement/deployment.• Consulted on implementation of educational software system across 10 branches of an institution. • Consulted a telecom client for transformation of legacy application to new technology platform. Study the legacy application, and preparation of gap analysis report, preparation of SOW and proposal. Led the development of the software application as well as complex data reports. • Consulted on Supply/Chain management software application for channel distributor: Implementation of said software application at the client. Training of the staff on said software application. Show less

Karāchi, Sindh, Pakistan

Led and participated in product showcase meetings with various clients.Provided L2 support for a ERP modules as well as training / resolution of application usage challenges. Developed, and designed disparate applications for offshore and onshore clients,Worked on Token based Security application and Federated Data Architecture.Delivered, maintained and enhanced applications like HR & Payroll system, Recruitment Management system, Recreational Club Management System and Event… Show more Led and participated in product showcase meetings with various clients.Provided L2 support for a ERP modules as well as training / resolution of application usage challenges. Developed, and designed disparate applications for offshore and onshore clients,Worked on Token based Security application and Federated Data Architecture.Delivered, maintained and enhanced applications like HR & Payroll system, Recruitment Management system, Recreational Club Management System and Event Management System. Show less