Suraj Rayudu Email & Phone Number

United States

● Involved in every phase of the SDLC process starting from Inception to Transition.● Azure Cloud professional with strong experience in migrating resources to Azure, Azure Administration, Azure Infrastructure Operations, and end to end Project Management.● Created Data mapping, logical data modelling coordinating with data architects, created class diagrams and ER diagrams, and used SQL queries to filter data within the Oracle database.● Involved in the below phases of Analytics… Show more ● Involved in every phase of the SDLC process starting from Inception to Transition.● Azure Cloud professional with strong experience in migrating resources to Azure, Azure Administration, Azure Infrastructure Operations, and end to end Project Management.● Created Data mapping, logical data modelling coordinating with data architects, created class diagrams and ER diagrams, and used SQL queries to filter data within the Oracle database.● Involved in the below phases of Analytics using R, Python and Jupiter notebook.● Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.● Used SSIS for data population from different sources and create SSIS packages for data conversions and load data from flat files and vice versa.● Built multifunction readmission reports using python pandas and Django framework.● Worked on MongoDB database concepts such as locking, transactions, indexes, Sharing, replication, schema design, etc. Performed analysis on implementing Spark using Scala and wrote spark sample programs using PySpark.● Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh. Worked extensively with Advance Analysis using Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies and sets to create detail summary report and Dashboard using KPI's. Show less

India

● Worked with internal architects and assisting in the development of current and target state enterprise data architectures.● Responsible for defining the key identifiers for each mapping/interface.● Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.● Extensively used SQL for accessing and manipulating database systems.● Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases… Show more ● Worked with internal architects and assisting in the development of current and target state enterprise data architectures.● Responsible for defining the key identifiers for each mapping/interface.● Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.● Extensively used SQL for accessing and manipulating database systems.● Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).● Designed and maintained data dashboards and visualizations to provide insights into DTH service performance and subscriber behaviour using Power BI.● Created ad-hoc reports using SQL server Reporting Services (SSRS).● Using Erwin and Visio design different kind of Data Models for various kind of databases as per the requirement.● Created UNIX scripts and environment files to run batch jobs. Managing the Reporting/Dashboarding for the Key metrics of the business.● Responsibilities included roadmap, development and implementation of real-time risk and pricing models, maintenance and development of analytical calculation framework. Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Table.● Creating and managing scheme objects such as tables, views, clusters, Indexes, Procedures, triggers and maintained Referential Integrity.● Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014.● Creating DAX Expressions, createDate to yearly columns and implement partitions in Tabular Models for power BI. Show less

India

● Produced high-standard database solutions to meet stability, reliability. Bash and PowerShell.● Create and deploy ETL packages to achieve various task using Microsoft Integrations Services (SSIS), and Azure Data factor (ADF). Automate Backups, refreshes, maintenance Jobs, Bulk inserts data migration, data extraction, transformation and loading from multiple data sources.● Worked extensively on Data Profiling, Data cleansing, Data Mapping and Data Quality. ● Wrote complex SQL to… Show more ● Produced high-standard database solutions to meet stability, reliability. Bash and PowerShell.● Create and deploy ETL packages to achieve various task using Microsoft Integrations Services (SSIS), and Azure Data factor (ADF). Automate Backups, refreshes, maintenance Jobs, Bulk inserts data migration, data extraction, transformation and loading from multiple data sources.● Worked extensively on Data Profiling, Data cleansing, Data Mapping and Data Quality. ● Wrote complex SQL to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results.● Effectively managed and reduced cost by effectively monitoring databases elastic pool. Configuring Azure Site Recovery for DR and Azure back-up on-premises/Azure Environment. Lead design, architecture, and deploy of solutions in Azure platform. Transact-SQL (T-SQL) ● Migrate SQL Server Databases to Microsoft Azure hosted DBs, Managed instances. Configured High Availability Solution; Always-On, Log Shipping, migration, patching, troubleshooting, optimization, maintenance (modelling, High-Availability (HA) and Disaster Recovery (DR)).● Performed Database Migration from On-Premises SQL environment to Azure Database in cloud Manage database security and users in Active Directory, ensure Database Integrity and setup maintenance plans via SQL Agent. ● Stored Procedures, Automated and reduce workflow with the help of store procedures, scripts, Redgate and Microsoft Integration services, that runs daily to reorganize, rebuild, update statistics, Backup.● Create Data Models for new and modernized legacy Databases, implement database design following best practices to maximize performance and reduce data redundancy. Show less