Shoaib Mohammed

Experience

• 

  Rilogix Technologies india

  Jan 2020 - Jul 2021

  Data Analyst

  • Optimized MySQL database schema and implemented indexing strategies for a high-traffic web application, resulting in 30% reduction in query response time and 20% increase in application speed.• Enhanced data accuracy by 25% through identification and rectification of inconsistencies in large datasets using custom SQL scripts and ETL tools.•Developed a complex ETL process using Informatica Power Center to extract, transform, and load data from DB2, Teradata, Oracle, and flat files into an optimized Oracle data warehouse, improving data quality and product fundamentals by 20%.• Utilized MDM tools and SQL queries to standardize, de-duplicate, and cleanse data, resulting in a 15% improvement in data integrity and enhanced service transformation for energy services.• Designed interactive dashboards using Tableau and Power BI, reducing reporting turnaround time by 25% and enabling real-time data analysis for embedded systems and daily operations.• Developed and executed SQL scripts for large-scale data migrations from Oracle/DB2 to Teradata, achieving 99% accuracy in the migration process. Show less

• 

  Tata Consultancy Services

  Aug 2021 - Aug 2023

  • Engineered ETL data pipelines for payroll data warehouse project, improving data flow quality and workflow from Workday to vendor system by applying Data Validation and Data Modeling on Informatica, leading to 45% performance increase in service engineering.• Implemented database Views, Indexes, and Partitioning techniques in Oracle-based Data Warehouse handling 1TB data, achieving 45% reduction in query response time and enhanced data efficiency through SQL optimization for improved infrastructure.• Leveraged Azure Data Factory and Databricks in collaboration with data architects and business analysts to optimize cloud resource usage, achieving a monthly cost saving of $8,000 and enhancing organization efficiency.•Optimized Tableau reporting dashboards handling 1M+ records, enhancing user experience and reducing load times. Show less

  • System Engineer

    Oct 2021 - Aug 2023

  • Management Trainee

    Aug 2021 - Sept 2021