Absar Ahmed Email & Phone Number

Riyadh, Sa

United Arab Emirates

Accomplishments: ✔️ Partnered with stakeholders to gather and refine requirements and translate them into robust data models that align with strategic business goals.✔️ Leveraged hands-on expertise in SSIS and Power BI Report Builder to enhance data integration and reporting processes.✔️ Co-created SSIS packages in collaboration with cross-functional teams to support reporting initiatives.✔️ Engineered sophisticated reporting solutions and data integration tasks for diverse source systems to enable comprehensive data consolidation.✔️ Built and optimized complex reports in alignment with the newly implemented Dynamics 365 solutions.Duties:Managed requirement gathering process and developed mapping documents to guide developers.Liaised with Business Team to define requirements and develop data models tailored to business needs.Spearheaded Data Migration project for Hasana Services by serving as the primary technical lead.Led data profiling and analysis to validate data integrity, accuracy, and consistency across systems.

United Arab Emirates

Accomplishments:✔️ Formulated and enforced data governance policies, standards, and procedures to maintain data consistency and quality.✔️ Partnered with business and IT stakeholders to define and document business glossaries, data dictionaries, and data lineage.✔️ Enabled data lineage tracking and impact analysis to strengthen regulatory compliance and support robust data governance frameworks.Duties:Directed the Data Quality project at the Federal Demographic Council (FDC) as the technical lead to drive overall project strategy and execution.Orchestrated the design and architecture of Informatica IDQ for Data Warehouse solutions, incorporating Staging, ODS, and Reporting layers.Led client engagement sessions to gather requirements, define objectives, and align team tasks for optimal project delivery.Assisted data modelers in developing Business Requirements Specifications (BRS) and Technical Design Documents (TDD) to mainatain accurate documentation.Developed and implemented FuzzyMatch. ScoreCardsl, and data quality rules, while training team members and successfully deploying solutions across 2 critical subject areas.Conducted sessions with Informatica’s team to implement Data Governance tools (Axon & EDC).

Karāchi, Sindh, Pakistan

Accomplishments:✔️ Developed and optimized the Data Mapping Sheet (DMS) to facilitate accurate data migration processes.✔️ Deployed Informatica PowerCenter to streamline data integration and migration from SQL to Temenos, enhancing system efficiency.✔️ Facilitated client engagement sessions for environment setup and tool configuration.✔️ Deployed Informatica PowerCenter to drive efficient data integration and migration activities.✔️ Automated and maintained complex ETL processes and data pipelines by leveraging robust software and testing methodologies.✔️ Assembled and guided the development team through data migration activities by providing technical support and issue resolution.Duties:Drafted comprehensive project plans for multiple data streams to secure client approval and alignment.Collaborated with the client to gather requirements and define prerequisites critical for development.Applied full software development life-cycle expertise, including Agile methodologies, Git version control, and CI/CD pipelines.Led the Data Migration Project for The Temenos System at United Bank Limited, Pakistan to ensure seamless data transfer and system integration.

Karāchi, Sindh, Pakistan

Accomplishments:✔️ Designed and implemented mappings on Informatica BDM across multiple logical layers (Staging, Load Ready, Semantic), integrating Data Lake with Teradata, Hive, Cloudera, and SSMS to optimize data flow, storage, and retrieval capabilities.✔️ Delivered successful integration of 9 complex source systems by employing advanced transformations through various layers (Staging, UTL, LDR, FSDM) and incorporating mappings into workflow applications to enhance data movement and transformation.✔️ Partnered with subject matter experts to design robust solutions for several applications, including batch processing, OLTP, OLAP, and data warehouse architecture while adhering to strategic goals.✔️ Developed, tested, and managed data parsing from JSON format into databases per SMX document specifications, while overseeing the creation and maintenance of critical database objects (tables, views, indexes, stored procedures, packages, functions, triggers, and integrity constraints).✔️ Collaborated with product owners and development teams to define new features and user stories, manage task development, comply with timelines, and provide ongoing status updates to leadership.Duties:Conducted unit testing of end-to-end source systems and performed technical analysis, design, development, and deployment of IT solutions aligned with business objectives.Assembled and trained a high-performing team to lead the Data Lake Project at United Bank Limited.Managed full project life cycle and coordinated with clients to gather requirements, create Data Definition Language (DDL) scripts, and devise SMX sheets for seamless data integration.

Karāchi, Sindh, Pakistan

Accomplishments:✔️ Created dynamic ETL mappings and custom workflows in Informatica (BDM, PowerCenter) for seamless data processing across multiple logical layers (Staging, Load Ready, Semantic), ensuring data accuracy, validation, and integration into the Data Lake and Teradata Database.✔️ Established robust data governance processes by creating error-handling mechanisms, such as Target Error tables in Oracle, to enhance data quality controls, and transforming/parsing data from JSON format based on SMX document specifications.✔️ Partnered with stakeholders, including product owners and subject matter experts, to define data architecture solutions, implement batch processing, OLTP, OLAP, and data warehousing strategies, and ensure alignment with business requirements.✔️ Designed and implemented core database objects (tables, views, indexes, stored procedures, packages, functions, triggers) and automated data pipelines to support complex reporting, enhance operational efficiency, and facilitate data-driven decision-making.Duties: Managed ETL repository operations, including exporting workflows and version control through SVN, and performed end-to-end unit testing to validate source systems and maintain functionality.Headed a team as an Inference (Java Drools) and ETL Developer, managing data integration, transformation initiatives, and overseeing the full software development lifecycle, including requirements gathering, design, development, testing, and deployment.