Swetha Mogadati

• Led end-to-end data migration projects from HubSpot CRM and Snowflake to Salesforce, ensuring data accuracy and integrity across systems.
• Collaborated with cross-functional teams for seamless integration of data sources into the company''s data ecosystem.
• Worked on sales force opportunity and service contract data ensuring smooth data mapping and validation.
• Built Revenue Retention logics to track financial performance.
• Created efficient solutions for handling duplicate records, ensuring a seamless transition of data during migrations.
• Analyzed and refined data related to email preferences, opt-in statuses, and marketing exclusions as part of CRM data readiness.

• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
• Implemented solutions in Azure utilizing Azure SQL, Azure Functions, Azure Data Factory.
• Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
• Worked on CI/CD pipeline creation and creating YAML files for automatic deployment in all environments like QA, DEV, and Production.

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.
• 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/CD pipelines in Azure DevOps.
• Migrated legacy workloads from on-premise data centers to public cloud platforms like Microsoft Azure.
• Configured SSIS packages for scheduled data loads from source systems to target tables.
• 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.
• 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.
• Designed, Developed, Implemented and maintained data integration solutions using Ab Initio's suite of tools, including Graphical Development Environment (GDE), Express - It, Mhub and Control Center.
• Tested and validated the loaded data in the target system for accuracy and completeness.
• 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 High Level Documentation (HLD) and Low Level Documentation (LLD) 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.
• Implemented Slowly Changing Dimensions Type 1 and 2 in SSIS Packages to capture changes in the source data over time.

Clients: First Command Financial Services, VISA

• 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.
• Designed and optimized BigQuery tables, writing SQL queries and creating data visualizations for business Intelligence and reporting.
• Utilized Google Cloud Storage for storing, accessing, and managing structured and unstructured data in the cloud.
• 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.
• Deployed and orchestrated containerized applications using kubernetes for container management and scaling.
• 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.
• Implemented parallel processing techniques using Partition by key and Gather components, improving overall system throughput by 50%.

Clients: Judicial Council Of California, Department of Civil Services State of New York

• 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.
• Engaged with cross-functional teams to design and implement scalable and efficient data integration solutions using Ab Initio GDE.
• 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.