Attique Yousaf

• Demonstrated adaptability by taking on additional responsibilities as needed, ensuring the overall success of migration projects.
• Identified and addressed the limitations between technology stacks of Teradata, Snowflake, Informatica and Matillion
• Designed the architecture of AWS cloud platform for the new technology stack
• Supported system integration efforts by aligning data structures between legacy systems and target platforms.
• Reviewed incoming change requests related to data migrations, assessing impacts on ongoing projects while offering informed recommendations accordingly.
• Contributed to the development of internal processes for automating repetitive tasks in the migration process, boosting team productivity levels significantly. Increased productivity by 40%.
• Researched and resolved complex technical issues discovered during migrations.
• Designed Test strategies for Unit tests, Integration test and User Acceptance tests of more than 2000 migrated ETL routines
• Offered input for complex documents to support client-ready final versions.
• Collaborated with upper management to drive strategy and implement new processes.

• Achieved seamless integration of new systems by collaborating closely with cross-functional teams throughout the development cycle.
• Developed innovative solutions by analyzing client needs and designing customized Data Models.
• Provided technical guidance to project teams throughout the development lifecycle, ensuring adherence to established design principles and quality standards.
• Increased efficiency through thorough analysis of existing systems and identification of areas for improvement.
• Conducted thorough post-implementation reviews to assess the effectiveness of designed solutions and identify areas for further improvement.
• Reduced project costs by streamlining processes through efficient solution design methodologies.
• Demonstrated strong technical expertise in a variety of tools and platforms used in the development of customized data solutions including Teradata, Snowflake, MS SQL, Oracle, Informatica, SSIS, SSRS, Power BI, Matillion and Data Stage
• Managed project scope, schedule, status and documentation.
• Reviewed work of developers, designers and Ops Gurus, assigned tasks and monitored performance against targets.

• Designed and Developed Campaign Data Mart for marketing teams using Enterprise Data Model standards for Communication Industry
• Migrated existing data from legacy system to new Data Mart
• Designed and developed routines using SAS and Teradata BTEQ for data visualization and orchestration
• Streamlined data integration processes for improved efficiency in business intelligence reporting.
• Reduced report generation time by optimizing the queries written in SQL
• Analyzed data to identify root causes of problems and recommend corrective actions.
• Collaborated with stakeholders to identify business needs and data sources.
• Assisted with creating data cubes and OLAP models to improve data analysis.

• Designed and Implemented a customized data model using Teradata’s Enterprise Data Model for Communication Industry
• Collaborated with cross-functional teams to gather requirements and translate them into logical and physical data models.
• Collaborated with system architects, design analysts and others to understand business and industry requirements.
• Assisted in the migration of legacy systems to modern platforms, ensuring seamless data transfer and minimal downtime.
• Facilitated effective communication between technical and non-technical stakeholders through clear documentation of data model specifications and diagrams.
• Improved data-driven decision making by integrating disparate data sources using ETL processes and other integration tools.
• Enhanced database performance through normalization, denormalization, indexing, partitioning, and other optimization techniques.

• McCain Foods (Canada) ETL Migration (Role: Offshore Technical Lead)
• Al Rajhi Bank (KSA) EDW Migration and Evolution (Role: Onshore Solution Architect / Data Architect)
• DU Telecom (Dubai) EDW Migration & Evolution (Role: Onshore Data Migration Analyst)
• Emirates Airlines (Dubai) EDW Migration (Role: Onsite Data Profiler/Analyst)
• VOLVO Cars (Sweden) QWDATA Migration (Role: Onsite Tech Lead)
• VOLVO Cars (Sweden) CRM Integration (Role: Offshore ETL Lead)
• Jazz Telecom (Pakistan) Postpaid Billing Migration Integration (Role: Onsite Data Modeler)
• T-Mobile (Netherlands) DWH Migration (Role: Onsite ETL Developer)
• Jeronimo Martins (Portugal) DWH Migration (Role: ETL Developer).

• Managed, Modeled, Designed and Implemented OLTP and OLAP Databases
• Recovery and Backups of Databases
• Identified the key business drivers for the data warehouse initiative.
• Managed large-scale databases to ensure timely access to critical information for key stakeholders.
• Conducted ad-hoc analysis to address urgent business questions, facilitating rapid response to market changes.
• Automated routine data analysis tasks, freeing up time for more complex analysis.
• Analyzed data to identify root causes of problems and recommend corrective actions.
• Updated and developed scripts and queries to extract and analyze data from multiple sources.
• Designed and developed data pipelines to acquire, clean and process data.

• Developing JAVA Applications
• Stock Pro Mobile Application Development using J2ME Polish
• Testing of Mobile Applications over the SDK’s of different Vendors
• Development of Web Application using JSP, JAVA WEB SERVICES, Servlets and Oracle
• Using JExcel and POI API’s
• SWT Development in ECLIPSE JAVA
• Macros Development
• Working with Packages, Procedures and Queries in PL/SQL.

Data Modeler - Manufacturing Industry

Remote | May 2024 - July 2024

• Facilitated effective communication between technical and non-technical stakeholders through clear documentation of data model specifications and diagrams.
• Ensured data consistency across applications by enforcing referential integrity constraints within databases.
• Promoted a culture of collaboration and continuous improvement through regular feedback loops with project stakeholders, ensuring alignment with evolving business needs.
• Assisted in the migration of legacy systems to modern platforms, ensuring seamless data transfer and minimal downtime.

Data Modeler - Medical Industry

Remote | April 2022 - September 2022

• Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
• Gathered, defined and refined requirements.
• Collaborated with system architects, design analysts and others to understand business and industry requirements.
• Progressed and maintained official description of enterprise datasets.
• Organized integration of data and migration activities to enhance operations.
• Evaluated and recommended appropriate tools and technologies for ETL development, ensuring alignment with business objectives and budgetary constraints.
• Designed scalable ETL solutions for efficient data extraction, transformation, and loading across various platforms.