Usman Siddiqui
Data Analyst | Data Pipelines & Warehousing
3 recommendations
Salary / Daily rate
3 people recommend
Karachi, Karachi City, Sindh, Pakistan
Freelance, open to permanent contract
Can come onsite
Skills
Languages
Recommended by
About me
Intro
Data Analyst with 7+ years of expertise in ETL pipelines, data warehousing, and BI solutions. Proven track record building interactive dashboards using Power BI, Tableau, and Apache Superset while managing complex databases including Oracle, MySQL, and Postgres. Specialized in transforming raw data into actionable insights that drive strategic decision-making and business growth.
Work experience
Data Analyst
Sapphire Consulting Services
Apr 2022 - Present
4 years 7 months
Karachi, Karachi City, Sindh, Pakistan
Experienced professional specializing in analysis, data pipelines, and data warehousing. I possess advanced skills in using tools like Apache Superset, Microsoft Power BI, Oracle OAS, Tableau, Talend, and databases such as MySQL, Oracle 11gXE, Oracle 12C, MSSQL, and Postgres. My expertise includes developing advanced dashboards, automated reports, and data algorithms to provide actionable insights and support strategic decision-making, all while ensuring data integrity through rigorous quality checks and aligning with organizational goals. I work closely with stakeholders to understand their business needs, objectives, and challenges. Through in-depth discussions, I gather insights into their data requirements and tailor solutions that address their unique goals. I utilize a variety of data analysis techniques and tools to extract, clean, and transform raw data into meaningful insights, uncovering trends, patterns, and correlations through well-designed data models and algorithms. In addition, I design and develop interactive dashboards and reports using BI tools such as Power BI, Tableau, Oracle OAS, and Apache Superset, customizing visualizations to effectively communicate key metrics and performance indicators. My visualizations simplify complex datasets, making insights accessible to both technical and non-technical stakeholders. I have extensive experience managing and optimizing databases and data warehouses, ensuring efficient storage, retrieval, and processing of large data volumes. I also develop ETL processes to extract data from diverse sources, transform it into usable formats, and load it into target systems. I continuously identify opportunities to improve the performance, scalability, and efficiency of BI solutions, implementing optimizations and best practices to enhance system responsiveness.
Multinet Pakistan (Private) Limited
Apr 2018 - Mar 2022
4 years
Karachi, Karachi City, Sindh, Pakistan
Senior Engineer
Feb 2020 - Mar 2022
2 years 2 months
Karachi, Karachi City, Sindh, Pakistan
As a Senior Engineer, I was responsible for overseeing the network infrastructure’s performance through proactive monitoring and data-driven decision-making, ensuring maximum uptime. By analyzing network data from performance graphs and metrics, I optimized connectivity and swiftly addressed potential issues. My focus was on maintaining the peak efficiency of all network circuits, including DWDM, SDH, IPLC, DPLC, and VPNs, while leveraging real-time data to minimize downtime and ensure service continuity. By identifying trends and patterns in the data, I was able to anticipate network challenges and resolve them before they impacted customers, consistently meeting service level agreements (SLAs). Additionally, I collaborated closely with cross-functional teams to enhance network reliability and effectively manage technical queries from international clients, all while ensuring data security. This approach enabled me to make informed, proactive decisions that significantly contributed to the overall stability and efficiency of the network infrastructure.
Network Engineer
Apr 2018 - Jan 2020
1 year 10 months
Karachi, Karachi City, Sindh, Pakistan
As a Network Engineer (NOC Engineer) in the TXN and GSAC Department, I was responsible for managing and maintaining complex network infrastructure involving DWDM (Huawei & Nokia Siemens) and SDH (Huawei & Nokia Siemens) technologies. My role required in-depth troubleshooting of various network circuits, including Layer-1 TDM, IPLC, DPLC, Internet, L2 VPN, and L3 MPLS VPN, ensuring seamless connectivity and optimal performance across all systems. I played a key supervisory role, providing 24/7 level-2 support to the NOC team, ensuring prompt resolution of network-related issues within the agreed Service Level Agreements (SLAs). This role involved constant monitoring of incidents, proactively identifying potential issues, and taking swift actions to prevent service disruptions. In addition to internal team support, I was responsible for managing and addressing international customers’ technical queries, ensuring all inquiries were handled with the utmost focus on security and confidentiality of the end-user data. My proactive approach to incident monitoring and management ensured minimal downtime, and I worked closely with cross-functional teams to troubleshoot and resolve complex network issues effectively.
ENERGY MANAGEMENT SYSTEM
companyFreelance
Aug 2017 - Dec 2017
5 months
karachi · On-site
EMS for commercial purpose done with the core and upgraded equipment of Lovato Electric (Smart Energy Meters) & Autonics (Integrated PLC ). Supervising the design of general and smart EMS. Supervising after sale services team for energy management products.
Internee
Pakistan International Airlines
Jun 2017 - Jul 2017
2 months
Jinnah International Airport, Karachi, Pakistan · On-site
battery station line maintenance base maintenance engine overhaul battery shop Isphani hanger electrical lab HF, VHF,UHF
Internship
Civil Aviation Authority
Jul 2015 - Aug 2015
2 months
Karachi, Karachi City, Sindh, Pakistan
CAA Electronics Engineering Department General electronics Radar Ranges and modes of frequencies for communication ( in-station as well as out-station) CAA airworthiness
IEEE
May 2014 - Dec 2014
8 months
Karachi, Karachi City, Sindh, Pakistan
Member
May 2014 - Dec 2014
8 months
Karachi, Karachi City, Sindh, Pakistan
feb-2014
event committe
May 2014 - Oct 2014
6 months
hamdard university
working as event committe member at HIIT IEEE, to upgrade the motive and work of IEEE in HIIT branch of university
Education
Hamdard University
Bachelor of Engineering (B.E.)
2013 - 2018
5 years 6 months
Army public college hyderabad cantt
Intermidiate
2010 - 2012
2 years 1 month
Anis Hassan school of excellence
Matricuation
2008 - 2010
2 years 1 month