Neha Khetan Email & Phone Number

-Creation of Azure LakeHouse architecture ,Delta lake.- Designed, developed, and implemented data pipelines on Microsoft Azure using services such as Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.- Implemented data governance and security best practices to ensure compliance with regulatory requirements.- Collaborated with cross-functional teams to gather requirements and design data solutions that meet business needs.- Developed and maintained real-time data processing solutions using Azure Stream Analytics and Azure Event Hubs.- Conducted performance tuning and troubleshooting of data pipelines to ensure optimal performance and reliability.

Washington, Dc, Us

• Volunteered at American Red Cross as a Power BI Developer. • Learned new technologies : Data Visualization : Power BI and Azure Data Factory . • Developed multiple dashboards with data integration in Azure Data Factory and reports and dashboards in Power BI . • Created datasets with loading of data from disparate data sources like flat files and web , transformed them in Power Query Editor with use of Data Analysis Expressions (DAX) . • Built data model and created relationships in the Power BI Desktop. • Built various interacted visuals with filter context and published them to Power BI Service. • Configured Security measures like Row level Security and Object level in Power BI Security with specific roles assigned to consumers. • Shared and collaborated the dashboards with end users. • Created Dataflows in Power BI Service workspaces. • Extracted data from Azure BLOB storage accounts , flat files and created Data pipelines in Azure Data Factory with varying transformations in Data flows and load data to Azure Data Lake Storage Gen2. • Loaded transformed data to Azure SQL Database which was used as data source for Power BI reports. • Followed Best practices for performance optimization at the data load level , in DAX for calculative fields and calculative measures and at the visual / report level.

• Imported data between different Excel files using SSIS/DTS utility and load it to SQL Server after the data transformation. • Data Validation was done to ensure ambiguous data is not loaded in the database. • Various components of SSIS like Control Flow, Data Flow ,, Event Handler , Package Explorer and Parameters were used to create the packages. • Created configuration files to deploy the SSIS packages across all environments. • Created complex SSIS packages using proper control and data flow elements with error handling. • Created the ETL process flow document. • Creation of dimensions and facts in star schema to store source data files. • Creation of OBIEE Metadata Repository using OBIEE Admin Tool by importing the required objects Dimensions, Facts Aggregates into Physical Layer using Connection Pool, developing multiple dimensions drill-down Hierarchies, Logical Facts, Measure objects in Business Model Layer, and creating Presentation Catalog in the Presentation Layer. • Creation of Logical data model and relationships . • Creation of Technical Mapping document to map dimension fields and measures in the Business Model Layer with the Presentation layer. • Configuration of Interactive Dashboards with drill-down capabilities using Filters and Dashboard Prompts, OBIEE Security Setup groups, access privileges , Metadata objects and Web Catalog objects Dashboard, pages, folders, and reports . • Set up Security and architecture with OBIEE 11g by using web logic admin console and enterprise manager. • Configured and scheduled Intelligence Agents iBots to send real-time alerts to the end users using Delivers and created reports using BI Publisher.

Mumbai, Maharashtra, In

• I was the Single Point of Contact for any Oracle Database related queries in the module. • Was Involved in all the cycles of the SDLC for the project starting from requirements gathering to production. • Developed the complete database with all the different database objects , procedures, functions,packages,indexes, views . • Prepared the logical and physical data models using ER Studio • Ensured stable requirements were implemented which are specific to each SDLC phase. • Maintained proper scripts in the Source Control (Clearcase) and updated Release notices accordingly.

Pune, Maharashtra, In

• Created PL/SQL procedures and functions for the automation of our data quality checks. • Interacted with clients understanding their requirements and determining the process to be followed to ensure data quality throughout the system. • Onsite experience. • Developed the Packages, procedures, functions . • New functionalities were added as per client’s requirement • Apply constraints and indexes to maintain integrity. • Responsible for development and implementation of PL/SQL Procedures, Functions and Triggers as per client requirement. • Created new Database tables and updated their relations with existing ones.