Sri Devi Email & Phone Number

Texas, United States

• Experience with Power Automate, Power Bi, Canvas Apps, Model driven and Portals. Familiar with Power Platform administration, and Azure cloud services.• Automated ETL processes using Python and Azure Data factory, reducing manual intervention by 60% and increasing data pipeline reliability.• Utilized pandas for efficient data manipulation, including data cleaning, transformation, and analysis, ensuring high quality datasets. • Leveraged SQL, Python, and ETL tools to extract, transform, and load data, and created interactive visualizations using power BI and Tableau to provide meaningful Interpretation of Complex datasets.• Developed PowerShell scripts to automate database backups, reducing manual effort by 70% and minimizing the risk of data loss.• Performed data analysis with pandas and NumPy, identifying key market trends that shaped the medical products and Devices roadmap and directed strategic planning.• ETL off- Loading from Teradata to Hadoop in Architecture and worked on analyzing Hadoop cluster and different big data analytical tools including Map Reduce, Hive and Spark.• Experience in developing ETL solution using Python scripts in Azure Databricks for data extraction, transformation, and aggregation for multiple file formats and data sources for analyzing and transforming the data to uncover insights into the customer usage pattern.• Developed and optimized complex SQL Queries, stored procedures, and indexes to efficiently manipulate and manage data, ensuring data integrity and enabling effective data analysis for both OLAP and OLTP systems.• Utilized Azure Data Factory to design and deploy end-to-end data integration solutions, extracting data from various sources and loading it into SQL for analysis.• Contributed to the Azure migration team, assisting in migrating on-premises SQL data to the Azure Cloud, ensuring a smooth transition and optimal data performance, validated, and reported migration process using Python scripts

• Developed Spark applications for data extraction, transformation and aggregation from multiple systems and stored in Azure data lake storage using Azure Databricks notebooks.• Created Pipelines in ADF to copy parquet files from ADLS Gen2 location to Azure synapse analytics Data warehouse.• Demonstrated ability to elevate solution quality and foster confidence in insights through adept unit testing practices. Verified data source connections and integration processes.• Deployed trained TensorFlow models using Docker and Kubernetes ensuring seamless integration with existing systems and scaling as needed.• Worked with Data architects and IT architects to understand the movement of data and its storage.• Coordinated with QA team to test and validate the reporting system and its data.• Involved in Continuous integration (CI) and Continuous delivery process Implementation using Jenkins along with Shell Script.• Designed and implemented automated solutions for data processing and analytics using AWS Lambda.• Designed and implemented Cassandra schema for the APIs and responsible for Data Ingestion like Flume and Kafka.• Experienced in using Microsoft Azure services, such as Azure Data Factory, Azure Databricks, and Azure SQL Database, for data integration, processing, and analytics in a cloud environment, resulting in a 30% reduction in cloud infrastructure costs.

• Developed data processing pipelines using pandas and NumPy to efficiently analyze large volumes of claims data, improving data accuracy and processing speed.• Implemented comprehensive development practices to build robust, scalable insurance applications using Python and Java, and ensuring seamless performance across various platforms.• Designed and deployed RESTful APIs using Flask and Django for real time data integration with third party systems, enhancing the company’s policy management and claims processing capabilities.• Optimized SQL Queries for data retrieval and report generation, reducing query execution time by 30% and enabling fast Decision making for underwriters.• Automated the extraction of policy holder information from multiple Sources through web scraping techniques, significantly reducing manual data entry and improving data accuracy.• Managed Version control and collaboration on insurance software projects using Git, ensuring all team members had access to the latest code base and reducing deployment issues.• Developed and maintained client facing web applications using Django, enhancing customer experience by providing intuitive interfaces and real time access to member policy information.• Integrated data sources into company’s analytical platforms using SQL and Pandas enabling more comprehensive risk assessments and better premium pricing policies.• Collaborated with cross functional teams to enhance scalability and reliability of Insurance applications, applying software development best practices and Continuous integration using Git.• Performed Data transformations and statistical analysis using NumPy to identify patterns in claims data, which led to the development of predictive models for fraud detection.

• Designed and Developed Components using Python with Django Framework.• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.• Pulling data daily from OLTP database to OLAP or staging database using the SSIS packages Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.• Experience in working on cube structure optimization for MBX query performance in Analysis Services 2008/2005 (SSAS).• Diagnosed and resolved database related issues promptly, including performance bottlenecks, data corruption, and connectivity problems.• Ability to plan and execute database migration, upgrades and version migrations with minimal disruption to operations.• Experience in handling JSON datasets and writing custom python functions to parse through JSON data using spark.• Managed datasets using pandas’ data frames and MYSQL database using python MYSQL Connector and MY SQL DB Package to retrieve.• Developed programs to automate the testing of controllers in CI/CD environment using Python, and Linux command line.• Designed, built the dimensions, cubes with star schema using SQL server analysis services (SSAS).• Performed the task of data transfer from files in remote server to folders in another server using FTP.• Created database maintenance plans and deleted history data using SSIS packages.• Utilized ASR, PowerShell, and MVMC for on-premises cloud migrations and wrote python modules to view Apache Cassandra instance.• Utilized Python libraries to connect to Elastic search and Retrieve data from Cassandra Data store.