Ramees Abbas

Experience

• 

  IBM India Pvt Ltd

  Aug 2013 - May 2017

  PROJECT : PFIT- FETL (Client: PayPal)• Core member in team for integrating transaction data from oracle and Teradata source system to build OLAP system for analysis and reconciliation. • Have understood and experienced in working with STM data model• Experienced in gathering the business requirement and translating into informatica mappings.• Transformed the business rules into MDM data and rendered code for the classification of transactions • Developed a dynamic code that handles the changes in business rules without any code change.• Developed BTEQ, Fast-Export, Fast-Load and SQL Plus scripts to load and extract data • Developed shell scripts for various functional requirements of the project.• Experienced in tuning informatica mappings and sessions for optimum performance.Tools used:• Informatica• Oracle • Teradata• Unix Show less PROJECT : ANTI MONEY LAUNDERING(AML) (Client: Royal Bank of Scotland)• Member in team for developing EDS and EDW solutions for the bank’s AML data • Developed reusable mappings and worklets which helped in performance of the jobs. • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.• Involved in the design and development of referential integrity process of the project• Have modified the scheduling code of CA7 tool and executed jobs in Pre-production environment for UAT testing• Automated the process of smoke test by parametrizing the environmental parameters and variables • Developed BTEQ and Teradata scripts to remediate the data in Production system.Tools used:• Informatica• Oracle • Teradata• Unix • CA7 Show less PROJECT : SINGLE VIEW OF CUSTOMER(SVOC) (Client: Royal Bank of Scotland)• Member in team for developing EDS and EDW solutions for the bank’s data. • Developed mappings, sessions and workflows using the required transformations in Informatica tool according to technical specifications • Automated the procedure of creating parameter files required for the workflows using python scripts• Developed scripts to create informatica workflows using python and shell scripts.• Developed shell scripts for error handling, batch execution from back end and other project related functional codes.• Performed unit testing at various levels of the ETL and actively involved in team code reviewsTools used:• Informatica• Oracle • Teradata• Unix Show less

  • Data Specialist

    Jul 2015 - May 2017

  • ETL Developer

    Aug 2014 - Jul 2015

  • ETL Developer

    Aug 2013 - Jul 2014
• 

  Visual BI Solutions, an Atos Company

  Aug 2017 - Dec 2019

  𝐎𝐮𝐭𝐚𝐠𝐞 𝐅𝐨𝐫𝐞𝐜𝐚𝐬𝐭𝐢𝐧𝐠● Built pipelines in Azure Data Factory to move business data from Oracle system into Azure Data Warehouse.● Analysed historical outage information using data interpretation algorithms and graphs to understand the nuances of data.● Developed Pyspark code in Azure Databricks for identifying outliers in the data.● Used Time Series graph in Power BI to visualize outage forecasting.● Developed Azure logic app flow to orchestrate and schedule ETL process. Show less 𝐂𝐥𝐨𝐮𝐝 𝐁𝐈 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧 - 𝐒𝐀𝐏 𝐇𝐀𝐍𝐀 𝐭𝐨 𝐀𝐳𝐮𝐫𝐞 𝐒𝐲𝐧𝐚𝐩𝐬𝐞Point of Sale – Automated Data Validation● Built an Automated solution to notify the Data Quality status of the loads to the stakeholders.● Developed complex Azure Data Factory mappings and Table Value functions to compare the results of the source with the target system.● Developed Azure Logic App flow to orchestrate various applications to facilitate the automation process.● Developed Pyspark notebooks/USQL for complex comparison logic.● Worked with Client architects to achieve most the integrated solution, incorporating all the organizational best practices. Show less 𝐂𝐥𝐨𝐮𝐝 𝐁𝐈 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧 - 𝐒𝐀𝐏 𝐇𝐀𝐍𝐀 𝐭𝐨 𝐀𝐳𝐮𝐫𝐞 𝐒𝐲𝐧𝐚𝐩𝐬𝐞PROJECT : QUALITY DASHBOARD (Client: Retail Company)• Data Engineer for Azure cloud based solution to integrate site inspection data from various sources and generate reports in PowerBi for 3 KPI’s.• Gathered and analyzed business requirements with users for project planning and delivery.• Developed data orchestration pipelines in Azure Data Factory V2.• Developed Pyspark notebooks & U-SQL scripts for data transformation.• Modelled schema for Azure Data warehouse and Azure Analysis Service for deeper and intrinsic analysis.• Incorporated the best practices in Azure Data warehouse and Azure data lake analytics for optimal performance. Show less 𝐂𝐥𝐨𝐮𝐝 𝐁𝐈 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧 - 𝐒𝐀𝐏 𝐇𝐀𝐍𝐀 𝐭𝐨 𝐀𝐳𝐮𝐫𝐞 𝐒𝐲𝐧𝐚𝐩𝐬𝐞PROJECT : CARELINE DASHBOARD (Client: Retail Company)• Data Engineer for Azure cloud based solution to integrate Salesforce CRM data and generate reports in PowerBi for 8 KPI’s.• Gathered and analyzed business requirements with users for project planning and delivery.• Developed data orchestration pipelines in Azure Data Factory V1.• Developed U-SQL scripts for data transformation.• Modelled schema for Azure Data warehouse and Azure Analysis Service for deeper and intrinsic analysis.• Incorporated the best practices in Azure Data warehouse and Azure data lake analytics for optimal performance. Show less

  • Senior BI Solutions Developer

    Jun 2019 - Dec 2019

  • Senior BI Solutions Developer

    Apr 2019 - May 2019

  • Senior BI Solutions Developer

    Dec 2018 - Mar 2019

  • BI Analyst

    Dec 2017 - Nov 2018

  • BI Analyst

    Aug 2017 - Dec 2017
• 

  Visual BI Solutions, an Atos Company

  Mar 2020 - Dec 2021

  BI Solutions Specialist
• 

  Maven Wave, an Atos Company

  Jan 2022 - Apr 2023

  Senior Consultant
• 

  Eviden(Atos)

  Apr 2023 - Oct 2024

  Manager

  𝗖𝗹𝗼𝘂𝗱 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 – Designing scalable data solutions with seamless batch and streaming integration.𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗲𝗱 𝗗𝗮𝘁𝗮 𝗣𝗶𝗽𝗲𝗹𝗶𝗻𝗲𝘀 – Building efficient ETL pipelines and workflows for high performance.𝗗𝗮𝘁𝗮 𝗚𝗼𝘃𝗲𝗿𝗻𝗮𝗻𝗰𝗲 – Ensuring compliance, data quality, and performance optimization.𝗔𝗰𝗰𝗲𝗹𝗲𝗿𝗮𝘁𝗼𝗿 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 – Creating reusable tools to enhance efficiency and reduce development time. Show less

• 

  ILink Digital

  Jan 2025 - now

  Senior Data Architect