Kiran Hameed
Mississauga,Canada
Summary
Experienced Data Engineer with expertise in ETL development using Informatica and Azure. Proficient in SQL and Python for data development, validation, testing, and automation. Skilled in BI analysis and reporting with Power BI, MicroStrategy, and Excel. Experienced in shell scripting and automation, as well as database administration and migrations.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Executive Data Development & Data Analysis
Ufone Telecom
12.2022 - 08.2024
- Experienced in ETL development and administration using Informatica and Azure
- Skilled in writing and optimizing complex SQL queries and procedures for data testing and performance enhancement
- Conduct ETL testing, data validation, and troubleshooting for complex data processes
- Lead the development of source-to-target mappings and ETL processes using Informatica and Teradata BTEQ
- Streamlined operational workflows by designing and implementing several database-level procedures
- Consistently identified and resolved issues in workflows, reducing downtime and improving efficiency
- Extensive experience in working with star schema and snowflake schema for optimized data structuring
- Experience with managing CI/CD pipelines
- Knowledgeable in Microsoft Azure services, including IaaS, PaaS, SaaS, and Azure Data Factory
- Designed and developed MicroStrategy, Power BI and Microsoft Excel reports, dashboards, and scorecards for business users
- Built and maintained data models, metadata, and schema objects to optimize reporting and data aggregation
- Worked closely with business analysts and stakeholders to understand requirements and translate them into technical solutions
- Experience in Informatica domain setup, version upgrade, installing patches
- Experienced in administering user management, Informatica environments, including installation, configuration, troubleshooting, Informatica logs to ensure seamless ETL operations
- Experienced in creating schema documentation and designing data flow diagrams to visualize and optimize data processes
Executive Data Warehouse & Database Operations
Ufone Telecom
06.2021 - 11.2022
- Experienced in Informatica ETL operations and administration in Informatica and SLJM
- Experienced in developing ETL pipelines and workflows using Informatica Power Center
- Experience in monitoring and optimizing day to day Informatica power center ETL operations
- Experience in developing and documenting policies and procedures for Informatica system processes, maintain and document Informatica related data profiles/engineering and architecture
- Proficient in Teradata and SQL database management, including database administration, query optimization, indexing, and schema design
- Experienced as a DBA in optimizing and tuning database performance
- Proficient in database migrations, managing user roles and rights, and resource allocation
- Experienced in documenting migration processes and best practices, with strong knowledge of data flow design diagrams
- Skilled in backup and recovery processes, leveraging metadata and NetBackup for on-premises systems
- Expertise includes configuring and optimizing database storage and indexing strategies to enhance query performance and resource utilization
- Implemented robust backup and recovery strategies, leading BAR operations to protect critical data and ensure resilience
- Developed and maintained shell scripts for SLJM job automation
- Experienced with Teradata Query Grid and Viewpoint for advanced data management and analysis
- Actively monitored the MicroStrategy BI Reporting Tool, resolving issues to enhance user experience
- Experience in MySQL, Oracle Data Integrator and Oracle business Intelligence Operations
- Experience in Hive and Big data operations
Executive CRM Operations
Ufone Telecom
10.2020 - 05.2021
- Proficient in 24/7 uptime of CRM and IBM IIB systems, adhering to OLAs to guarantee reliable service and minimize downtime
- Experience in web service development and monitoring, optimizing system performance and reliability through expert queue management in IIB MQ Explorer
- Extensive experience handling diverse data formats, including MQ, File, Database, HTTP, and SOAP requests, effectively resolving challenges and ensuring smooth integration across platforms
- Proficient in working with IBM Integration Bus (IIB), CRM systems, and IBM Maximo
- Skilled in managing MQ, ensuring efficient message processing and communication between systems
Education
Bachelor's - computer science
Capital University Of Science & Technology
Pakistan05.2020
Skills
- ETL
- Informatica Power Center
- Teradata
- SQL
- Oracle
- Azure
- Data Modelling
- Power BI
- BTEQS
- MicroStrategy dossiers
- Teradata Utilities
- Linux
- Data warehousing
- Bar Operations Management
- Oracle Data Integrator
- Oracle Business Integrator
- Python
- Golden Gate
Certification
Microsoft Azure Data Fundamentals DP-900 Certified, Core Data Concepts, Considerations for relational data on Azure, Considerations for working with non-relational data on Azure, Analytics workload on Azure
Projects
Adventure Works, This project was aimed at constructing a Data Warehouse (DWH) & Business Intelligence (BI) solution to address a diverse range of business queries., Oversaw all phases of the DWH & BI pipeline, from Extract, Transform, Load (ETL) processes to conceptual data modelling and semantic layer modelling for BI reporting., Utilized Power BI for data visualization, creating an intuitive platform for stakeholders to analyze and draw insights from the processed data. Facebook Analysis, Sentiment analysis project involving the extraction and analysis of data from various Facebook pages., Leveraged Power BI to compile, process, and visualisation of the data, enabling a comprehensive understanding of the patterns and trends observed.
Phone
+1, 4034315609
Organisationalskills
- Verbal & Written Communication
- Problem Solving & Team Player Mindset
Timeline
Executive Data Development & Data Analysis
Ufone Telecom
12.2022 - 08.2024
Executive Data Warehouse & Database Operations
Ufone Telecom
06.2021 - 11.2022
Executive CRM Operations
Ufone Telecom
10.2020 - 05.2021
Bachelor's - computer science
Capital University Of Science & Technology
Similar Profiles
Sohail Hanif MughalSohail Hanif Mughal
Administrative Manager at Ufone Telecom Ltd.Administrative Manager at Ufone Telecom Ltd.
Samia BasitSamia Basit
Sales Agent at Ufone - Pak Telecom MobileSales Agent at Ufone - Pak Telecom Mobile
Ahmed Nawaz KhanAhmed Nawaz Khan
Officer FAR & NLM at Ufone - Pak Telecom MobileOfficer FAR & NLM at Ufone - Pak Telecom Mobile
Tina CharbonneauTina Charbonneau
Parts Sales Executive at World AmericaParts Sales Executive at World America
Mugunth Gurusamypalayam ElanchelianMugunth Gurusamypalayam Elanchelian
Business Analyst at Wipro TechnologiesBusiness Analyst at Wipro Technologies