Services
Video meeting . 15 mins
Video meeting . 30 mins
Video meeting . 60 mins
Video meeting . 30 mins
Video meeting . 30 mins
About me
These credentials reflect the steady accumulation of in-depth experience as a Business Intelligence Consultant and Azure Data Engineer.
• Over 13 years of very good experience in Datawarehouse, Data Analysis, Data Migration, Data Cleansing, Data Integration, Data Modeling, Data Quality and Data Profiling.
• With over 3 years of experience working with data on the Azure cloud platform, I have the ability to collaborate with cross-functional teams to ensure that data solutions meet business needs. Whether it's building a new data pipeline, optimizing an existing data warehouse, or troubleshooting a data-related issue, I am committed to delivering high-quality solutions that drive business value.
• Strong knowledge in Azure Data Lake, Azure Delta Lake, Azure Data Factory, Azure CI/CD and Hands-on coding experience in various Azure Services.
• Specialized in designing, implementing, and managing data solutions on the Azure cloud platform. Top skills include SQL, Pyspark, Azure Databricks and Azure Data Factory which I use to build and maintain data pipelines, data warehouses, and data lakes.
• Experience with Azure Key Vault in managing and storing confidential credentials.
• Worked with various Transformations like Flatten, derived column, surrogate key, select, union, aggregate, filter, Lookup, Conditional Split, exists & alter row.
• Worked on Data Migration/Modernization from Traditional Databases to Cloud Data Warehouse.
• Expertise in Requirement gathering, Mapping documents creation, Design Document creation, Impact Analysis, Testing, Agile methodologies.
• Very strong in identifying and resolving Data Issues in OLTP/Datawarehouse datasets to maintain operational schedules.
• Expert in creating OLTP (Business Data Model) and OLAP (Dimensional Data Model; Star Schema, Snowflake Schema, FACT tables, Dimension tables) Logical and Physical Data Models.
• Sound knowledge of RDBMS, with strong experience in Oracle Database, MY SQL and SQL Server using views, stored procedures, functions, indexing and partitioning, performance tuning of databases and queries.
• Experienced in developing Test Plans, Test Strategies, Test Cases and defect management for Data Warehousing projects ensuring the data meets the business requirements.
• Expert in end-end implementation of Extraction Transformation and Loading (ETL) using variety of tools Informatica, Oracle Data Integrator and SSIS.
• Expert in gathering stakeholder requirements and presenting technical findings to non-technical audiences through effective data visualizations.