Gazelle R Email & Phone Number

Boston, Massachusetts, United States

• Build complex ETL jobs that transform data visually with data flows or by using compute services Azure Databricks, and Azure SQL Database• Develop and maintain various data ingestion pipelines as per the design architecture and processes: source to landing, landing to curated & curated to process • Use various types of activities: data movement activities, transformations, and control activities; Copy data, Data flow, Get Metadata, Lookup, Stored procedure, Execute Pipeline• Dealt with Storage services named Data Lake Storage Gen 1 and Gen 2, Storage Explorer for hosting CSV, JSON and Parquet files and managing access across storage accounts.• Write Databricks notebooks (Python) for handling large volumes of data, transformations, and computations• Utilize Databricks Delta Lake storage layer to create versioned Apache Parquet (delta) files with transaction log and audit history• Work with various file formats: flat-file TXT & CSV; parquet & other compressed formats• Build Delta Lake for the curated layer, maintain high-quality data available for the teams: data scientists, finance etc.• Utilize Azure’s ETL, Azure Data Factory (ADF) services to ingest data from legacy disparate data stores - SAP (Hana), SFTP servers & Cloudera Hadoop’s HDFS to Azure Data Lake Storage (Gen2)• Automated dataflows using Logic apps and Power Automate (Flow) which connects different Azure services and Function apps for customizations.• Scheduled and maintained Azure Databricks jobs.

Ashburn, Virginia, United States

• Created complex ETL Azure Data Factory pipelines using mapping data flows with multiple Input/output transformations, Schema Modifier transformations, row modifier transformations using Scala Expressions.• Implemented real time data integration for faster data insights, using the Change Data Capture of database applications, Azure Event hubs and Azure Databricks.• Designed and developed SSIS Packages to pull data from heterogeneous sources like Excel, Flat files, and DB2 into destinations like Azure SQL DB, Azure SQL Data warehouse, and Flat Files• Created Power BI dashboard from Azure Analysis Services and Published in Power BI workspace• Use T-SQL to develop and maintain SQL tables, indexes, stored procedures, views, and triggers created for Power BI reporting • Implement the full cycle of power BI visualizations such as extracting and transforming data in Power Query, designing various visualizations in Power BI desktop, publishing reports into Power BI Services, and developing and managing dashboards.• Create, maintain, and improve databases, schema objects, SQL queries, stored procedures, indexes, functions and views for data migration and ad-hoc reporting.• Used SSIS to source data, extract and transform from various source systems (Oracle, SQL Server, and Flat Files).• Develop ETL workflows and mappings to extract, transform, and load data into target environments, in line with current data loading architecture or on an ad-hoc basis.• Implemented Slowly Changing Dimensions to incrementally load dimension tables to the target Data Warehouse.

Tucson, Arizona, United States

• Worked on building Enterprise Data Warehouse in Azure DW/Synapse using different Azure services.• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics• Develop dynamic Data Factory pipelines using parameters and trigger them as desired using events like file availability on Blob Storage, based on schedule and via Logic Apps.• Using Polybase migrated/loaded large data sets from on-premises to Azure SQL Datawarehouse / Synapse.• Built ETL solutions using Databricks by executing code in Notebooks against data in Data Lake using Delta Lake and loading data into Azure DW.• Extensively worked on Accessing, Processing, Transforming and Analysis of big data using Databricks.• Used Data Flow debug for effectively building ADF data flow pipelines. Improved performance by using optimization options by effectively using partitions during various transformations. • Applied power platform technologies for building applications using PowerApps and integrating them with Power BI using PBI Integration to provide direct data access to users.

Parsippany, New Jersey, United States

• Designed SSIS packages to efficiently handle heterogeneous and unusual data from various external sources• Designed and Developed metadata db to stored meta data such as execution log and exceptions• Created Data Dictionary to derive definitions and understand data elements within the warehouse• Automated Exception reports generation for Customer and Products data and sending them out to source• systems• Used various data flow components for performing Data profiling, cleansing, and auditing• Used Checkpoints to save the state of the package at failure and rerun the package from the point of failure• Implemented handling of Type 2 dimensions and inferred members using Slowly Changing Dimension• Secured and Configured SSIS packages for deployment to production using Package Configurations and• Deployment Wizard• Created Event Handlers for various runtime events and created Custom Log Provider in SQL Server to log• those events for audit purposes• Designed and maintained cubes in MS Analysis Services 2005 in Star and Snowflake schemas• Defined measures, and calculated measures in Analysis Services based on business requirements

Parsippany, New Jersey, United States

• Designing relational database and data warehouse as per business requirements• Develop and support the ETL process using SSIS to extract, transform and load data from and to various heterogeneous sources and destinations.• Built efficient SSIS packages for processing dimension and fact tables with complex transformations to accommodate Type I, II and III SCDs using Merge.• Successfully implemented the POC of Power Pivot using MS-SQL Database and Microsoft Excel as sources.• Employed incremental and full loading to populate dimension and fact tables into the Data Warehouse.• Design and develop user-friendly dynamic reports and dashboard using parameter, expression, conditional formatting, and grouping to reduce ongoing ad hoc requests.• Maintained and optimized existing databases, monitored database performances and growth, performance tuning,• Developed a strong understanding of the business and associated systems to support customers’ strategic objectives.• Monitoring nightly jobs and investigate if there is any failure and fix the problem before the next run time.

Bachelor'S Degree, Computer Science

Associate'S Degree, Computer Science

High School Diploma