o*****d
About Candidate
Design ETL (Extract, Transform, Load) processes to efficiently extract data from multiple sources, transform it to fit
the data warehouse schema, and load it into the target system.
Normalize and denormalize data for performance optimization, ensuring efficient query performance and fast
reporting.
Established data quality standards and validation rules, ensuring data accuracy, consistency, and integrity within the
data warehouse.
Work closely with business analysts, data engineers, and stakeholders to gather requirements, understand business
processes, and translate them into effective data models.
Automated workflows and data transformation tasks with SSIS packages, improving efficiency by 25%.
Used Databricks notebooks for advanced analytics, machine learning workflows, and data visualization.
Did Data Profiling and Analysis using SQL to come up with a mapping document for the Dev Team and
documentation purpose.
Worked with data architects to created Conceptual, Logical/Physical, Relational and Multidimentional Models to
provide a more detailed representation of the system’s data requirements and ensure relationships between different
datasets are properly managed.
Optimized queries in a Data Warehouse to improve reporting by 5%
Used modeling tools like Erwin Data Modeler, IBM Data Architect and ER Studio to ensure data consistency while
optimizing data management
Education
Awarded a Degree
Work & Experience
Provided remote assistance to 300+ end users to ensure business continuity. Developed customized reports for clients using SQL to ensure customer satisfaction. Collaborated with teams in India, US and Russia to provide timely solutions to clients. Diagnosed and maintained hardware/software to ensure optimal performance and reliability of computer systems.
Did installation and configuration of Oracle Hospitality Management System for 8 clients. Provided both off-site and on-site training of the system and ensured a successfull transition. Provided consultations and technical support to 500+ clients to enhance user experience and minimize downtime.
Design ETL (Extract, Transform, Load) processes to efficiently extract data from multiple sources, transform it to fit the data warehouse schema, and load it into the target system. Normalize and denormalize data for performance optimization, ensuring efficient query performance and fast reporting. Established data quality standards and validation rules, ensuring data accuracy, consistency, and integrity within the data warehouse. Work closely with business analysts, data engineers, and stakeholders to gather requirements, understand business processes, and translate them into effective data models. Automated workflows and data transformation tasks with SSIS packages, improving efficiency by 25%. Used Databricks notebooks for advanced analytics, machine learning workflows, and data visualization. Did Data Profiling and Analysis using SQL to come up with a mapping document for the Dev Team and documentation purpose. Worked with data architects to created Conceptual, Logical/Physical, Relational and Multidimentional Models to provide a more detailed representation of the system's data requirements and ensure relationships between different datasets are properly managed. Optimized queries in a Data Warehouse to improve reporting by 5% Used modeling tools like Erwin Data Modeler, IBM Data Architect and ER Studio to ensure data consistency while optimizing data management
