| Candidate Information | | Title | Sql Server Software Development | | Target Location | US-VA-Ashburn | | Phone | Available with paid plan |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateName: SrinivasCurrent Location: Ashburn, VAWork Authorization: US CitizenActive Security Clearances Status: Public TrustPhone: PHONE NUMBER AVAILABLESummary:Microsoft Certified Professional (Azure Data / DevOps, Solution Architect and MCAD) with 15+ years of total experience.Extensive knowledge and working experience on Software Development Life Cycle (SDLC).Experience in developing applications using Agile/ SaFe methodologies using Scrum framework.Programming skills in C#.Net, Java, Python, SQL, Scala, ASP.Net/MVC, .Net Core, Web API and Visual Studio.Experience with migrating applications to Azure Cloud in a Lift and Shift approach and in a refactoring approach for efficiency and integrating Hybrid Cloud with back-end, traditional data center services.Experience using Azure studios such as Storage Explorer, Data Studio and Synapse Analytics.Experience in Azure Integration runtime, ETL & ELT, Data factory, Databricks, Azure SQL data warehouse and Synapse Analytics.Experience in creating the IaaS & Paas and Faas components including Azure App & Logic apps, Azure Functions, Azure SQL databases, Data Lakes and Cosmos DB.Expertise in databases like SQL Server 2022/18/17/12/14/08/05, Oracle10g/9i/8i and U-SQL.Orchestration Azure DevOps using ARM templates, Terraforms, Classic Editor / YMLExperience in Content Management System using SharePoint.Experience in Installing & Configuring GIT, TFVC, VSO, TFS, SVN and Continuous integration builds.Ability to take and give directions and instructions and provide assistance through completion of tasks.Excellent communication, interpersonal skills and Subject Matter Expert.Proficient in requirement analysis, system design, and Object-Oriented Design (UML).Experience in logical and physical data modeling using ER Studio and Microsoft Visio.Extensive experience in the development of Reports using SQL Server 2016 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, drilldown reports and score cards in multiple formats using multi dimensional objects.Experience in developing and managing reports and Dashboard using Power BI.Expert in monitoring SQL Server Performance, troubleshooting using SQL Profiler, Index Tuning Wizard (DTA), Windows Performance Monitor and Maintenance plan.Deployment of SSRS Reports and power view reports on SharePoint Portal and integrating Reports, Analysis Reports with SharePoint 2010(MOSS).Extensive experience in T-SQL programming in creating and using Stored Procedures, Triggers, Functions and complex queries on various versions of SQL server.Expertise in OLTP/OLAP and developed database schema like star schema and snowflake schema used in relational, dimensional, and multidimensional modeling.Exceptional versatility and adaptability, extremely diligent, having excellent communication skills and ability to work both as an individual and as a team member.Migrate PostgreSQL to SQL server.Mentor junior team members.Good exposure in Machine learning/ MLOps and Azure AI services.Experience with Unit testing & Test-Driven Development (TDD).Excellent team player with problem-solving and trouble-shooting capabilities.Education:Master of Science (M.S.) in Computer Application.Technical Skills:DatabasesMS SQL Server 2022/19/16/14/12, My SQL, Sybase, Oracle, Azure SQL, Cosmos DBProgramming LanguagesSQL, T-SQL, PL/ SQL, C#, VB.Net,Java, Python, Kusto.BI ToolsCrystal Report, SSRS, Power BIETL ToolsBIDS/SSDT, SSIS, SSAS, ADF, Synapse,OLAP/Reporting ToolsMS SQL Server Reporting Services 2016/14/12/2008R2, MS Excel, Tableau, Power BI.SQL Server ToolsSSMS, Query Analyzer, SQL Server Profiler, SQL Server Agent.Data Modeling ToolsErwin tool, Visual Studio 2022/19/17/15/12, Microsoft Visio, Business Intelligence Development Studio (BIDS).Other ToolsMS Office, MS Excel, MS Project, MS PowerPoint and MS Visio, Teams, WebExOperating SystemsWindows VariantsCloud TechnologiesAzure, Azure Data Bricks, Azure Functions, Blob, Storage, S3, VM, EC2, Vnet, App Insights, Logic Apps, App services, AWS,Glue, Athena, RDS,VPC, DevOps etc.Version ControlsVSS, TFS, Git and GitHubProfessional Experience:Department of Veterans Affairs Washington, DC (Remote) Sept 2023 to PresentSr. Azure Data EngineerResponsibilitiesUnderstanding business requirements and architecture solutions to meet the business requirements.Config & Setup Cloud environments (Dev, UAT & Prod).Setup & Config Bronze, Silver and Gold/Curated layer Medallion architecture.Create & Config Server less and Dedicated SQL Pools.Create & Config Apache Spark Pools.Installed and Configured packages Cluster and Workspace level for Azure Databricks / Synapse.Implemented optimized caching features Apache Spark and SQL Pools.Data ingestion using Azure Data Factory into the Azure Data Lake and orchestration.Created integrated pipelines to ingest data into ADLS from upstream systems to bronze layer.Created Synapse/ Databricks Notebooks to develop data products from parquet files.Created reusable/ Delta table functions using Python, SQL and Scala languages.Created external tables and Views using Serverless pool.Implemented Delta tables using PySpark and SQL.Transform & Clean and filter data using Python and SQL.Understood the ELT & ETL processes and general Data transformation / Pipelines.Ingest data from multiple sources like AWS DBs,S3, SQL Server, Salesforce, Oracle Golden gates, and REST API etc.Transform raw data and aggregate data into the data products to use downstream systems such as Power BI and Tableau reports and other systems.Implemented Azure logic apps to send email notification for Azure Data Factory / Synapse integration pipelines status.Created Collaboration / Feature branches repositories for various features.Config & Setup branch policy and approval process of PR for various repositories.Created ADO CI /CD pipelines for Azure Synapse.Created Tasks and dashboards for sprints.Created Build & Release automation pipelines for CI/CD.Create Pull Requests and broadcast PR in teams for code reviewers.Automation of deployment process for Synapse/Azure data bricks Notebooks / Pipelines.Created Azure Key Vault and managed scripts and Cryptographic keys, such as authentication keys, storage account keys etc.Designed architectures and ER diagrams using Lucid charts.Config and deploy code to development, UAT, Prod Cloud Azure environment.Monitored and troubleshoot failed pipelines, SQL and Spark pools.Performance tuning for Dedicated SQL Pools.Environment: Windows10, VS2019, Agile, Teams, Azure DevOps, GitHub, Python, Blob Storage, Key Vault, Azure Active Directory, SSMS, Oracle, Synapse, Azure Data Factory, Azure Data bricks, Storage Explorer, App logic, Log Analytics, Lucid charts, Power BI, Tableau, Collibra, AWS database,Saleforce.S3,JIRA,Confluence,Slack,Github.Tennessee Valley Authority, Knoxville, TN (Remote) May 2021 to Sept 2023Sr. Azure DataOps EngineerResponsibilitiesAnalyze & Understand requirements and provide Level of efforts(LOE) for design,development and testing ofapplications.Designed& Develop PTP application using C#.Net,Angular,ASP.Net,SQL Server,Oracle,SSIS,Azure Data Factory,Azure blob storage,Azure Synapse, SRSS, Power BI and Git.Design & Develop Database tables, Views, Stored procedure and user defined functions using Oracle,SQL Server.Involved in design, development, data analysis, identifying and gathering business requirements, user testing andmaintenance of BI applications and information systems including database management systems like SQL Server and Oracle.Imported data from multiple sources such as Oracle, SQL Server, SAP, and REST API etc.Transform raw data and aggregate data into the data products to use downstream systems such as Power BI, Tableau and SSRS.Design & Develop database using Star schema.Created Collaboration / Feature branches repositories for various features.Created Tasks and dashboards for sprints.Design & Develop Database tables, Views, Stored procedure, and user defined functions using Oracle and SQL.Deploy SSIS Packages & SSRS RDLs and Config environment variables for various environments.Deploy SSRS and SSIS packages in various environments.Extensively worked with SSIS tool suite, designed and created mapping using various SSIS transformations likeOLEDB command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.Migrated SSRS reports to Power BI from SQL Server 2014 to 2017.Migrated SSIS Packages & SQL Agent Jobs from SQL Server 2014 to 2017.Migrated SSIS from SQL Server 2014 to 2017.Config and Setup email to send jobs run status of all environments corresponding teams.Created various types of reports such as cascading, complex drill-down reports, drill through reports,parameterized reports, matrix reports, Sub reports, non-parameterized reports and charts using reporting servicesbased on relational and OLAP databases.Ingest upstream systems CXL Gas & Fuel various formats such as Flat files,Oracle,Excel file using Azure data factory.Enrich raw data using Azure data flows.Support O& M for Comtrac, CXL,MDI,ELLIS,Dataservices enterprise applications.Migrate existing security applications from Akana to MulesoftTroubleshoot failure SSIS SQL agent jobs for a various environment.Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multipledata providers, using defined objects, chart.Support various C#.Net,Angular,Oracle applications.Interacted backend java applications.Environment: Windows10, VS2019, Agile, Teams, Azure DevOps, C#.Net,ASP.Net, MVC, Angular,Python,Office365,Sharepoint,AzureActiveDirectory, Devops,ServiceNow, SSMS,TOAD, Oracle, SSIS,Java,Azure Data factory,Azure blob storage, Synapse,Mulesoft, SSRS,Power BI and Tableau.Microsoft Corporation Redmond, WA (Remote) Sep 2019 to Feb 2020Sr. Azure Data EngineerMicrosoft Federal (MSF) commercial Sales and Partner insights is a CRM system. It consists of two major products, MSF Sales and Partner sensitive information. Development is done in the Microsoft corporate environment using Azure Cloud platform. Pre-Production and Production environments are split between Microsoft corporate environment and Microsoft government environment (Azure US Gov [AM95]).ResponsibilitiesUnderstanding business requirements and architecture solutions to meet the business requirements.Create Azure Data Factory (ADF) pipelines ingest data into data lakes from Corp partners to MSF zone.Created Databrick Notebooks to develop data products from parquet files.Created reusable/Delta tables functions using Python, Spark language.Transform & Clean and filter data using Python, Spark language and U-SQL.Understood the ELT & ETL processes and general Data transformation/ Pipelines.Imported data from multiple sources such as CRM APIs and SAP etc.Transform raw data into the data products used to power reports for the business using Azure Databricks.Data ingestion into the Azure Data Lake and orchestration of insights refresh.Stored data products are staged for refreshing PBI datasets and reports in Synapse warehouse.Used to develop & deploy the tabular models that drive reports written by the business.Created Collaboration / feature branches repositories.Utilized Azure Functions/ logic apps in automating some of the Business Processes for the Client.Created Pull requests and set up approval process for various repositories.Created Tasks and dashboards for sprints.Created Build & Release automation pipelines for CI/CD.Create Pull Requests and broadcast PR in teams for code reviewers.Created ARM templates using VSC and Visual studio IDEs.Automation of deployment process for Data factoriesConfig and deploy code to Corp, AM95, UAT, Prod Cloud Azure environment.Monitor & Troubleshoot failed ADF pipeline.Environment: Windows10, VS2019, Agile, Teams, DevOps, Git, Azure PowerShell, Python, Blob Storage, Azure Active Directory, Databrick, HDInsight, Data Factories, Synapse Studio, Storage Explorer, ARM templates, Power BI and Dynamic CRM.Dept. of Transportation, Washington DC Jan 2014 to Aug 2019Lead Data EngineerTravel Monitoring Analysis System web-based system oers a method for Federal, State, and local data providers to upload, quality control, process and run reports on traffic volume, vehicle classification, Weigh-In-Motion (WIM) and non-motorized data processing.ResponsibilitiesUnderstanding business requirements and architecture solutions to meet the business requirements.Analyze & Understand requirements and provide Level of eorts (LOE) for design, development, and testing of applications.Design of enterprise Data Warehouse applications, Built Data Lake platform while providing technical leadership for Data Warehouse implementations & coding standards.Written SSIS packages to validate customer upload datasets.Designed database and SQL performance tuning existing Ad Hoc queries.Design, architect, prototype, and implement solutions to address Dataset and Data Science needs.Create tables, views, stored procedures, indexes, SSIS packages, and SQL Agent Jobs in SQL Server and Azure SQL DW to support ETL processing and end user reporting.Created Azure Key Vault and managed secrets and Cryptographic keys, such as authentication keys, storage account keys etc.Created Storage accounts to store Upload batch data.Created Azure Functions to clean up customer upload batch files periodically.Worked with Infrastructure Team to design and configure Virtual Networks (VNets), subnets, network settings, Virtual machines, DNS settings, routing, and security policies.Worked with Ops team and network security team to create and deploy Azure IaaS Virtual Machines (VMs) and App Services (PaaS role instances) into secure VNets and subnets.Designed Network Security Groups (NSGs), Application Security Group to control inbound and outbound access to network interfaces (NICs), VMs and subnets.Worked with DBA team Migrated SQL Database to Azure SQL database in Lift and Shift approach.Worked with DBA team Migrated SQL Database SSIS packages, Data warehouse data using Azure Data factory and Data lakes for Weigh-In-Motion data type.Transform & clean and filter data using Python and U-SQL.Installed, configured, and O&M support of monitoring solutions across the support platforms.Migrated On-Premises Data to Azure SQL Database and Azure Datawarehouse using Azure Data Factory pipelines.Imported data from multiple sources such as SQL, Oracle, Excel files in SharePoint, APIs, and SAP etc.Develops data processing pipelines to ingest data from various event producer sources into Azure DataLakes Storage, Azure SQL Data warehouse, Azure Synapse analytics and Azure Data.Created Azure SQL database, performed monitoring and tuning of Azure SQL database.Performed migration of Microsoft SQL server to Azure SQL database.Apply data modeling techniques to ensure development and implementation support eorts meet integration and performance expectations.Applied the ELT & ETL processes and general Data transformation/ Pipelines.Utilized Azure Functions to automate some of the Business Processes for the Client.Used Databrick Notebooks to transform data using Python, U-SQL, C# and Apache Spark.Utilized Azure Log Analytics in troubleshooting issues in the Enterprise environment.Worked with Windows team to migrate Active Directory user management data to Azure AD using AD connect.Created & Integrated Azure Logic Apps to send email notification for failed pipeline Jobs and Users to approve submitted batches data.Created ARM templates and deployed them using PowerShell scripts and .NET SDKs.Debugged and automated PowerShell scripts to reduce manual administration tasks and cloud deployments using Kudu and Yarn.Development and architecture of applications for Non-motorized using .Net,.NetCore, ASP.Net MVC, SSIS, DevOps and SQL server etc.Created Collaboration / feature branch repositories for various Data factories.Created Pull requests of Data factories and set up approval process for various repositories.Integrated Export / Import ARM templates for multiple Data Factories.Created CI /CD pipelines for Data factories.Automation of deployment process for Data factories.Created GIT repositories.Created Tasks and dashboards for sprints.Created Build & Release automation pipelines for CI/CD.Created Pull Requests and set up code reviewer workow.Created Web Jobs for execute PowerShell scripts and exesCreated ARM templates using VSC and Visual studio IDEs.Config and deploy code to DEV, UAT, Prod Cloud Azure environment.Implement & Integrated authentication and roles using Azure Active Directory.Create branch & Merge code with dierent branch, Check-in, and Check-out code.Environment: Windows10, VS2019, C#, .NET, Java, Python, Visual Studio code, Microsoft Azure, Azure DevOps, Git, Azure PowerShell, Azure Active Directory Connect, Synapse Studio, Azure Data Studio, Data Factories, File Storage Explorer, Databricks, SQL DW, Oracle, SAP, Web API, ASP.Net, SQL Server, Cosmos DB, DataLakes, SharePoint, Office 365, Agile SaFe.Divine IT Services, North Wales, PA Jun 2008 to Dec 2013Sr. Software Engineer ResponsibilitiesGathered business requirements by attending regular project meetings with the client.Designed & Developed discrepancy reports graphs, pie, and bar charts using JPlot and jQuery.Write various complex scripts to provide support for Backend as well as Front end.Worked on parent/child relation dataset for hierarchical data display.Worked on improving SQL query performance.Designed and Developed dashboards using ASP.Net MVC.Migrated existing data Access layer code from code first to DB first approach using Entity Framework.Implemented Repository, Unit of Work and Dependency Injection Ioc design patterns.Written DataLoad to Insert Existing Data from heterogeneous systems.Implemented Performance tuning Tips. SQL Query Optimizations Techniques.Developed Comprehension and Extension Lambda Expression using LINQ.Consumed WCF Service to Authenticate and Authorization against Active Directory.Designed & Developed UI ASP.Net MVC View screens.Performance tuning using ANT Profiler.Merged code from various branches and freeze the branch.Interacted with User groups to gather business requirements.Involved in Analysis, Design, Development, Testing, and Implementation of the Application.Migrated PowerBuilder screens to ASPX pages.Development of Web Forms for Client-Server interaction using ASP.NET 3.5.Designed and Developed ASPX and Master Pages.Modified Existing Windows forms for new requirements.Modified existing VB.Net COM components for Language tracking of FRED and Modal office.Created Business and data access layers using .Net Framework 2010/4.0 for Full house registration.Participated in gathering Business Requirements by attending regular project meetings with the client.Designed and Developed ASPX and Master Pages.Created WCF Service and Configured Endpoints and Bindings.Written WCF Services and Hosted on IIS.Written Queries LINQ to Objects, LINQ to XML, DataSet, Array list and Collections.Schedule reports delivery email configuration using Reporting services Manager.Implemented AJAX functionality to improve the interactivity and responsiveness of the webpages.Implemented SQL Query Optimizations Techniques.CRM integration with Salesforce.Configured & Consumed Salesforce web services using Apex.Extracted New business, Agents and Commission feed from legacy databases using SSIS.Integrated SSRS reports with ASPX pages using ASP.Net.Written Data load components such as Agents, Commission, New Business using Winforms.Developed Test Driven Development (TDD) using Visual Studio Team Suite 2008.Involved in all phases of implementation including requirements gathering, design, development, testing, deployment, and trainingCreated Business and Data Access layers classes using JAVA.Everyday Build & Deployed Code daily basis in various environments.Environment: Windows, VS2015/2013, C#, .Net, Javascript, CSS3, HTML5, Jquery, EF, Sharepoint, ASP.Net/MVC5.0, IIS, Oracle, SQL Server, Agile, SSIS, Elmah, Webforms, Active Directory, VB, Java, TFS, SSIS,SSRS. |
