Data Warehousing Specialist
Al Rajhi Bank
Total years of experience :4 years, 8 Months
• Collaborated with the Data Management department to define data movement requirements and synchronized Disaster Recovery with the Production System using Teradata Data Mover, ensuring data integrity and system reliability.
• Collaborated with Data Integration Team to understand business requirements, ensuring Teradata Query Grid solutions aligned with organizational objectives.
• Adept at aligning TASM configurations with business objectives to enhance overall system efficiency.
• Utilized TASM to monitor and analyze system performance, proactively identifying and resolving performance bottlenecks to maintain optimal system operation.
• Played a key role in optimizing data warehouse performance and scalability by implementing best practices in data modeling, indexing, and query optimization, resulting in enhanced system efficiency and responsiveness.
• Skilled in query optimization techniques, optimizing query performance to enhance overall system efficiency and responsiveness.
• Excellent communication and presentation skills, delivering impactful insights and recommendations to clients, as well as conducting training and knowledge transfer sessions to empower client teams.
• Designed and executed a robust ETL pipeline using Talend and Python, seamlessly integrating a new source system.
• Provided expert technical solutions in Teradata platforms, optimizing performance and significantly improving ETL job execution time.
• Streamlined operations and maximized efficiency through proactive automation using Python and Shell scripting, delivering timely alerts.
• Automated data purging in Teradata Database and facilitated seamless data archiving from Teradata to Hadoop using Shell Scripting.
• Developed data processing components and implemented high-quality data pipelines using Apache NiFi. Monitored and managed Apache NiFi workflows to ensure data integrity and timely processing.
• Conducted comprehensive analysis of datasets generating influential business reports using Power BI Report Builder and Power BI Desktop.
• Demonstrated exceptional programming skills in Python and SQL, effectively extracting, cleansing, and manipulating large datasets.
• Designed and optimized workloads in Teradata Workload Management (TDWM) to enhance quer performance and resolve performance issues for the Teradata Database, resulting in a 40% reduction in query execution time and overall system performance by 70%.
• Created TASM rulesets and evaluated workloads for optimized performance.
• Conducted system analysis to optimize system health and performance.
• Analyzed data and provided statistical reports, on a day-to-day basis.
• Developed and deployed stored procedures along with packages in Teradata Database.
• Successfully spearheaded the management of multiple databases, expertly overseeing backups and servers using Teradata Net Vault.
• Streamlined operations by automating crucial processes through Shell Scripting and SQL, including statistics collection and data purging, which helped optimize the queries and maintain space on the database.
• Performed Workload Designing in TASM to automate workload assignment, optimizing system resource allocation, and mitigating the risk of system halts.
• Developed and implemented workload management policies to ensure optimal resource allocation based on business-critical requirements.
• Designed and optimized workloads in Teradata Workload Management (TDWM) to enhance query performance and resolve performance issues for the Teradata Database, resulting in a 40% reduction in query execution time and overall system performance by 75%.
• Successfully coordinated and managed business requirements using Jira and GitHub, ensuring efficient project implementation as well as products used by business users.
• Proactively addressed and resolved production environment bug fixes, encompassing both frontend and backend stored procedures, ensuring uninterrupted system functionality and user experience.
• Ensured seamless builds in lower and production environments by taking charge of deployment activities, minimizing downtime and ensuring smooth system performance.
• Played a pivotal role in strategic planning, devising initiatives aligned with key objectives to drive future success and achieve organizational goals.
• Effectively oversaw and managed multiple domains, including Web Applications, Mobile Apps (Android/iOS), SharePoint, Middleware, and CRM, ensuring seamless support and optimal performance across diverse platforms.
• Successfully fulfilled audits, compiling comprehensive reports and addressing identified shortcomings, ensuring compliance and maintaining high-quality standards.
• Took ownership of test case documentation and led user acceptance testing (UAT) efforts, resulting in user satisfaction and needs, and seamless implementation of each product.
Projects:
• CBS Migration Project (Upgrade of Customer Billing System and Migration of Services)
Successfully led the CBS Migration Project, overseeing the upgrade of the Customer Billing System and seamless migration of services.
• Service Migration from TopEng to Nokia (Provisioning)
Orchestrated the service migration from TopEng to Nokia, ensuring efficient provisioning of services and minimizing disruptions.
• PTCL Joint Shop Integration (Ufone Android Applications on PTCL Joint Shop Devices)
Spearheaded the integration of Ufone Android Applications on PTCL Joint Shop Devices, enabling seamless access and utilization of services.
• Ufone API Integration (Bill Payments, Subscriptions, Transfers)
Facilitated API integration with Bank Al-Falah, HBL Bank, Meezan Bank, and Faysal Bank, enabling customers to conveniently perform bill payments, subscriptions, and transfers.
• My Ufone App & UPaisa
Played a key role in the development and implementation of the My Ufone App and UPaisa, enhancing customer experience and enabling seamless transactions.
• Facebook Integration with Ufone
Successfully integrated Ufone services with Facebook, expanding reach and enabling customers to conveniently access and utilize subscription services through the platform.
• QR-Based Subscription and OAuth Integration for Golootlo
Implemented QR-based subscription and OAuth integration for Golootlo, streamlining the subscription process and enhancing user convenience.
• Designed and implemented a comprehensive system to efficiently organize customer applications, enabling streamlined resolution in bulk using Java.
• Enhanced an existing system to create daily backups for customers' data in a bulk process, ensuring data integrity and availability using Java.
• Upgraded an internal web application by migrating PHP code from PHP 3 to PHP 7 version, improving performance and compatibility with modern frameworks.
• Demonstrated proficiency in handling Oracle database and effectively managed it using Microsoft SQL Server Management Studio.
• Utilized Linux Operating System to manage and maintain database servers, ensuring stability, security, and smooth operation of critical database systems.
Moto Bako - Final Year Project Sep 2018 - Jun 2019 Moto Bako was based on the management of the bakery system using a Web App by the staff members, to have the ability to manage their bakery's internal system. An Android Application was designed to provide the ability to order online or place an order before arriving. Emergency Tracking System - Android (Semester Project) Apr 2018 - Jun 2018 Developed an Android application using Android Studio which also included a database system using Firebase Database. An emergency tracking system was created to be able to track the location of someone who adds you to their circle (Lost Devices). An emergency alarm would set off automatically at the time of danger or can be turned on manually if the person is not unconscious, to alert people around you and had the ability to send an automatic text to that particular circle at the time alarm would set off, telling them about the danger and sharing location coordinates to help them track the person. 3D Fighting Game - Unity (Semester Project) Mar 2018 - May 2018 Created a 3D fighting game for a semester project. Character Designing, Environment Design & Utilization, Combats, Graphics, Sound & Rendering were all done with the help of Blender and Unity. Coded using C# for all the functionality used inside the video game. Management System with UI - Visual Studio (Semester Project) Apr 2017 - May 2017 Designed a management system using C# in Visual Studio. Football Team - DBMS (Semester Project) Apr 2016 - May 2016 SQL Server Management Studio was used to create the database management system with a graphical user interface for ease of usage.
URL removed due to policy violation. Please contact support for further information.