Swetha Mogadati

Clients: Elevance Health

• Perform Health care Data Analysis, Data profiling of source data to derive meaningful insights, and document data requirements to support the new data source onboarding.
• Integrating data from various sources, including electronic health records (EHRs), medical devices, and external datasets.
• Implementing data integration solutions to ensure seamless flow and accessibility of information.
• Managing and optimizing databases to ensure efficient storage, retrieval, and processing of healthcare data.
• Implementing security measures to protect sensitive patient information.

Clients: First Command Financial Services

• Designed and implemented data integration solutions using Azure Data Factory.
• Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
• Developed and managed enterprise-wide data analytics environments.
• Configured SSIS packages for scheduled data loads from source systems to target tables.
• Wrote and coded logical and physical database descriptions, specifying identifiers of database to management systems.
• Integrated multiple sources of structured and unstructured datasets into a single platform.
• Optimized existing queries to improve query performance by creating indexes on tables.
• Managed performance monitoring and tuning while identifying and repairing issues within database realm.
• Worked with cross-functional teams to achieve goals.
• Monitored performance metrics of various services running on Microsoft Azure platform using tools such as Application Insights and Log Analytics.
• Deployed applications to the cloud using ARM templates with CI and CD pipelines in Azure DevOps.
• Migrated legacy workloads from on-premise data centers to public cloud platforms like Microsoft Azure.
• Configured, monitored and maintained Azure Storage Accounts, Virtual Networks, App Services, Web Apps and VMs.
• Analyzed cost optimization opportunities for existing resources deployed in the cloud environment.
• Provided production support for all ETL related issues involving Informatica PowerCenter.
• Created mappings, sessions and workflows to move data from source systems to target systems using Informatica PowerCenter.
• Monitored loading jobs on daily basis to ensure that all ETL jobs are running as scheduled.
• Tested and validated the loaded data in the target system for accuracy and completeness.
• Modified existing ETL pipelines to enhance performance and add new features.
• Worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services.
• Collaborated with cross-functional team to define features and build powerful and easy-to-use products and customer-facing workflow tools.
• Developed ETL packages for data loading from various sources such as flat files, XML files and Oracle databases into the Data Warehouse using SSIS.
• Created documentation such as technical specifications for each task involved in ETL process.
• Configured error handling for all SSIS packages by establishing connection managers, event handlers and logging to track package execution status.
• Deployed SSIS packages from development environment to QA, UAT, Production environments successfully.
• Created complex SSIS packages with multiple transformations such as derived columns, lookups, conditional splits, script tasks and execute SQL tasks.
• Implemented Slowly Changing Dimensions Type 1 and 2 in SSIS Packages to capture changes in the source data over time.

Clients: VISA, Department of Civil Services State of New York

• Developed data pipelines to extract data from various sources and load it into Azure Data Lake Storage and Azure Synapse Analytics.
• Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for generating reports using SSRS.
• Involved in migrating data from on premise to Azure Cloud, performing many copy activities and Data flow with many transformations involved.
• Created triggers such as scheduled, and event-based triggers and monitored and tested them.
• Worked on Databricks for analysis works to build tables and views.
• Worked on user stories to fix bugs in the Production.
• Unit tested, peer reviewed the scripts and SSIS Packages after development.
• Closely worked on CI/CD pipeline creation and creating YAML files for automatic deployment in all environments like QA, DEV, and Production.
• Migrated data from informatica packages to SQL Server with SQL Server Integrated Services SSIS.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created Dashboards and Reports using Power BI.

Clients: University Of Illinois Springfield,Judicial Council Of California

• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop).
• Developed and maintained data models and schema designs for data integration solutions
• Wrote complex SQL queries and stored procedures to support data integration workflows.
• Created data validation scripts and implemented data quality checks.
• Collaborated with other team members to ensure successful delivery of projects within the specified timelines.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2017.
• Designed and implemented stylish report layouts.
• Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated.
• Sub query, complex Stored Procedures and ad-hoc TSQL statement.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2014.Designed and implemented stylish report layouts.