Mohamed Ramees Raja A Email & Phone Number

𝐁𝐈 𝐂𝐥𝐨𝐮𝐝 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧 - 𝐎𝐫𝐚𝐜𝐥𝐞 𝐭𝐨 𝐃𝐚𝐭𝐚𝐛𝐫𝐢𝐜𝐤𝐬● Implemented BI migration from Oracle to Databricks, integrating batch and streaming data from 10+global regions to generate facts and dimensions for Power BI reporting.● Converted 25+ complex PL/SQL procedures to PySpark and Spark SQL notebooks for efficient businesstransformations.● Designed a semantic model for the sales team and implemented data governance using medallionarchitecture,performance optimizations, PII data management, and sensitivity tagging.● Ensured data quality through ETL constraints and automated orchestration with Databricks workflows𝐀𝐜𝐜𝐞𝐥𝐞𝐫𝐚𝐭𝐨𝐫 𝐋𝐚𝐤𝐞𝐡𝐨𝐮𝐬𝐞 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭Designed and implemented Pyspark accelerators, utilities, and templates. Reduced development time by 40%, enhanced operational efficiency, and decreased QA issues by 20%. This initiative drove a 50% increase in sales inquiries for Microsoft Fabric implementations

Calgary, Alberta, Canada

𝐌𝐨𝐝𝐞𝐫𝐧 𝐂𝐥𝐨𝐮𝐝 𝐁𝐈 𝐢𝐦𝐩𝐥𝐞𝐦𝐞𝐧𝐭𝐚𝐭𝐢𝐨𝐧 - 𝐒𝐀𝐏 𝐇𝐀𝐍𝐀 𝐭𝐨 𝐒𝐧𝐨𝐰𝐟𝐥𝐚𝐤𝐞● Led the migration from SAP HANA to Snowflake cloud using a hub-spoke architecture with dbt, storedprocedures, and Tableau, implemented in 3 phases with a team of 5, resulting in a 90% reduction in SLAand improved data quality.● Addressed latency and memory limitations in SAP HANA by implementing a lambda views in Snowflake cloud, enhancing system performance and scalability.● The hub-spoke design minimized data silos and promoted collaboration among stakeholders, streamlining data accessibility and usage across the organization.● Custom made the CI/CD process and setup git pipelines for project requirements.

Calgary, Alberta, Canada

𝐁𝐈 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧 - 𝐒𝐐𝐋 𝐒𝐞𝐫𝐯𝐞𝐫 𝐭𝐨 𝐒𝐧𝐨𝐰𝐟𝐥𝐚𝐤𝐞 ● Led a modern BI migration to Snowflake from SQL Server/SSIS, ensuring a seamless transition to a cloud-based data warehouse.● Collaborated with the dbt think tank to develop best-in-class coding practices for PII handling, real-time views, and established naming and coding conventions.● Integrated data governance, testing, and documentation into the development process, enhancing data accuracy and compliance by using custom macros, custom tests, and YAML configs.● Facilitated seamless data sharing with the parent company through Snowflake Shares, improving collaboration and data accessibility.● Designed and developed CI/CD processes, ensuring efficient and reliable data delivery.Facilitated seamless data sharing with the parent company through Snowflake Shares, improving collaboration and data accessibility.

Chennai, Tamil Nadu, India

𝐃𝐚𝐭𝐚 𝐒𝐜𝐢𝐞𝐧𝐜𝐞 - 𝐂𝐮𝐬𝐭𝐨𝐦𝐞𝐫 𝐂𝐡𝐮𝐫𝐧● Designed and implemented a data-driven solution to help Sales representatives prioritize high-value customers and manage their workforce efficiently.● Analyzed historical sales and order data to extract actionable insights and improve data processing.● Solved key business challenges using clustering and bucketing algorithms to segment and categorize data.● Migrated complex business logic from SAP HANA to Databricks using R, enabling more flexible and efficient analytics.

Chennai, Tamil Nadu, India

𝐎𝐮𝐭𝐚𝐠𝐞 𝐅𝐨𝐫𝐞𝐜𝐚𝐬𝐭𝐢𝐧𝐠● 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.

Chennai, Tamil Nadu, India

𝐂𝐥𝐨𝐮𝐝 𝐁𝐈 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧 - 𝐒𝐀𝐏 𝐇𝐀𝐍𝐀 𝐭𝐨 𝐀𝐳𝐮𝐫𝐞 𝐒𝐲𝐧𝐚𝐩𝐬𝐞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.

Chennai Area, India

𝐂𝐥𝐨𝐮𝐝 𝐁𝐈 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧 - 𝐒𝐀𝐏 𝐇𝐀𝐍𝐀 𝐭𝐨 𝐀𝐳𝐮𝐫𝐞 𝐒𝐲𝐧𝐚𝐩𝐬𝐞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.

Chennai Area, India

𝐂𝐥𝐨𝐮𝐝 𝐁𝐈 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧 - 𝐒𝐀𝐏 𝐇𝐀𝐍𝐀 𝐭𝐨 𝐀𝐳𝐮𝐫𝐞 𝐒𝐲𝐧𝐚𝐩𝐬𝐞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.

Chennai Area, India

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

Hyderabad Area, India

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

Hyderabad Area, India

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

Bachelor Of Technology (B.Tech.), Information Technology

Activities and Societies: ITRIX,IT department symposiumPursued a bachelor's degree in Information Technology.The programme basically.

School, Basics Of Education, 92 % In Board Exams

Table tennis player,Hindi Drama club