Usama Bin Sadiq

Enterprise data, analytics and technology solutions leader with more than 18 years of progressive experience across enterprise applications, product and solution architecture, business intelligence and data engineering. Leads data analysts and data engineers at K-Electric, where a multi-source SQL Server data warehouse supports executive dashboards, KPI frameworks, recovery and distribution-loss analytics, and Generative AI-enabled KPI analysis. Combines hands-on depth in SQL Server, Oracle, SSIS, Qlik Sense and Python with leadership of multidisciplinary teams and senior stakeholder engagement.

Manager Data Analytics at K-Electric (2021-02 – Present)

• Lead a team of 8 data analysts, data engineers and officers delivering executive reporting, dashboards, analytics and data models for OT, IT and business functions; mentor the team in SQL, T-SQL, data engineering practices and Qlik Sense development.
• Built a SQL Server enterprise data warehouse integrating SAP ERP, SAP BW, OMS, MDMS, HES, GIS and other operational sources, spanning 6 structured systems and 10 unstructured sources; designed SSIS pipelines with custom Change Data Capture mechanisms and multi-level (L1, L2, L3) datasets using T-SQL, stored procedures, functions and Python.
• Developed denormalised, indexed datasets optimised for GPT models, enabling generated SQL queries to execute in 2–5 seconds, and built a Generative AI chat application that provides descriptive analysis of dashboard KPIs.
• Developed Recovery Ratio Dissection analysis by defaulter ageing and portfolio and automated portfolio-level recovery reporting, giving operations teams decision support to identify priority segments and plan more targeted recovery efforts.
• Automated feeder-loss calculations, reducing a monthly process that took a team of three 15+ working days to one day, and making it more repeatable and consistent for distribution performance analytics and subsequent-month planning.
• Established the analytics stream, including BW setup, as part of the Meter Data Management (MDM) implementation, overseeing development, deployment and maintenance; built process knowledge across SAP IS-U, MDM and BW to turn OT and technical parameters into quality analytics.
• Consolidated multiple reports and dashboards into concise executive-level summaries, and translated operational and business requirements into data models, pipelines, KPIs and decision-support products for executives, operations teams and business stakeholders.
• Established data-sharing policies and access rights for end users; safeguard data integrity, security and compliance and provide continuous data support, including emergency and after-hours assistance.

Freelancer at Self-Employed (via Upwork) (2019-03 – 2021-12)

• Delivered 10 major projects across 17 jobs as an independent Oracle, PostgreSQL and Qlik technology specialist (6 Oracle APEX, 3 Qlik Sense, 1 PostgreSQL), managing client engagements from design through implementation and ongoing support.
• Built cloud-connected Oracle APEX applications with REST web services, AWS-based image storage, QR/barcode scanning and customer portals; Kemdb was showcased at Oracle OpenWorld 2019.
• Designed full applications for third-party clients, including a goal tracker for a Government of Zimbabwe engagement (via Trumpet International), and created self-service Qlik Sense analytics.

CTO at OvacSol Private Limited (2017-03 – 2019-02)

• Managed teams developing products and solutions across software, mobile, database, integration and analytics, while serving as primary developer on complete client applications.
• Redesigned and developed a secondary sales solution end to end, modernising mobile (Android to React Native), core software (Oracle Forms and Reports to Oracle APEX, ORDS, Jasper Reports) and analytics (QlikView to Qlik Sense).
• Tested new technologies and versions and modernised the solution where they suited the overall architecture.

Product Manager at OvacSol Private Limited (2016-03 – 2017-02)

• Managed product development teams and researched market trends to design new solutions combining mobile apps (Android Studio, React Native), core software (Oracle APEX, ORDS, Jasper Reports) and analytics (QlikView, Qlik Sense).
• Delivered implementation, training and support for secondary sales, asset tracking and ERP/CRM platforms.

Senior Consultant / Team Lead at TMC (TallyMarks Consulting) (2015-04 – 2016-02)

• Managed the technical team and its assignments; developed management and departmental QlikView dashboards integrating data from multiple sources.
• Created and enhanced Secondary Sales modules (trade marketing, tools of trade, market equipment management, market research) and integrated them with client ERPs through web services.
• Oversaw design, development and tuning of forms, reports, packages and web services on Oracle Developer Suite and Database.

Business Systems Consultant (Technical) at Sidat Hyder Morshed Associates (2014-06 – 2015-04)

• Designed, developed and tuned forms, reports and packages in Oracle EBS R12 (Developer Suite 10g, Database 11g), including value sets, concurrent programs and segments.
• Customised layouts, reports and SQL queries in SAP Business One using SAP Query Generator, SQL Server and SAP Crystal Reports; provided implementation, training and support.

Analyst Programmer at ISR Software Services Private Limited (2011-03 – 2014-06)

Progressed through four successive roles on custom Oracle ERP solutions for client organisations.

• Served as resident engineer on a custom Oracle-based ERP for a manufacturing client, developing and tuning forms, reports, procedures, functions and packages across finance, payroll, HR, procurement, inventory and sales.
• Set up Oracle Database (8i–10g) and Oracle Developer (6i, 10g) environments; delivered user training, error rectification and production support.

Programmer at ISR Software Services Private Limited (2010-02 – 2011-02)

• Designed and developed forms, reports, procedures and functions for custom ERP clients; provided maintenance and support.

Junior Programmer at ISR Software Services Private Limited (2009-01 – 2010-01)

• Developed Oracle forms and reports and supported client installations on Oracle Database 8i/9i and Developer 6i.

Software Trainee at ISR Software Services Private Limited (2008-07 – 2008-12)

• Trained in Oracle Forms, Reports, database structures, SQL and PL/SQL, and built a Store Management System project applying coding standards.

Bachelor in Business & Information Technology – Virtual University of Pakistan (VU) (2021-10 – 2027-02)

Intermediate in Commerce – Govt. Premier College, Karachi, Pakistan (2007-07 – 2009-06)

Matriculation – Muslim Popular GBSS, Karachi, Pakistan (2005-07 – 2007-06)