SUMMARY

• Expertise in MicrosoftAzure Cloud Services,ADF, ADL, Spark, Azure Synapse, Data Bricks, ARM templates, Virtual machines, Runbooks, Key Vault, Azure storage, Azure Site Recovery, Visual Studio Online (VSO).
• Good hands on experience to migrate on - prem applications to cloud using SQL managed instance, SQL Virtual machine.
• Worked on various source systems to transform the data using azure data factory and azure data bricks notebooks.
• Create and manage the data bricks clusters and monitor the performance of the clusters.
• Good experience to troubleshooting the pipeline failures and provide the resolutions.
• Adopt modern Engineering Practices to Implement CI/CD pipelines, Creating the releases, Nightly Builds, Gated Check-in, One Click build and releases, managing the code using Azure Devops, git.
• Experience in Systems Analysis, Design, Development, and Implementation of various applications includingWebandClient/ServerApplication development usingMicrosoft .NET Framework,C#.NET,ASP.NET.
• Strong database schema design and developing SQL Server SQL scripts, analyzing data and performance tuning. Engaged in the projects for developing business intelligence reports and data models using MS Visual Studio 2005/2008/2012 and SQL server reporting services.
• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSIS, SSRS.
• Hands on experience to create a power BI reports, design a tabular model.
• Developed methodologies for cloud migration, implemented best practices and helped to develop backup and recovery techniques for applications and database on virtualization platform.
• Developed an effective build automation, continuous integration and test environment that reduced integration issues and improved code quality.
• Worked effectively with cross-functional design teams to create software solutions that elevated client-side experience and significantly improved overall functionality and performance.
• Worked closely with other business analysts, development teams and infrastructure specialists to deliver high availability solutions for mission-critical applications.

TECHNICAL SKILLS

Open Source: Spark/Scala

Azure: ADF, ADL, Data Bricks, Synapse and all other Azure stackSSIS, SSAS, SSRS, Power BI.Net / C#/ASP.Net

Java Scripts: Power Shell/DHTML

SQL: Server 2005 to 16

PROFESSIONAL EXPERIENCE

Confidential, Bellevue

National Data Warehouse

Responsibilities:

• Created the Azure Data factory (ADF) solutions to pull the data from various source and process the data.
• Created the solutions to store data on Azure data lake\Azure delta lake and write transformations in azure data bricks pyspark notebooks to process the data using data bricks clusters.
• Maintained the connection string on secure way using Azure key vaults.
• Created the solution to pull 500 million Confidential alarm data in 2 hours using adf parquet files and data bricks clusters.
• Designed the architecture to run adf pipelines on both SQL managed instance and SQl virtual machines to avoid the customers business operations during the system migration from SQL MI to SQL VM’s.
• Worked on data migration from SQL managed instances to SQL server VM’s.
• Create the azure release pipelines to push the code to various stages (Dev-Stage-Prod) in automated fashion.
• Create an automated solution to stop\start adf triggers.
• Debugging failures and resolve the issues.
• Worked effectively with cross-functional design teams (Azure product teams and business teams) to create software solutions to improved overall functionality and performance of the data processing.
• Worked on Cloud services, Created the Azure Automation Account, created the runbooks to automate server patching.

Confidential, Redmond

Corporate Finance

Responsibilities:

• Worked on the user stories to deliver the business requirements.
• Involved to provide the story points on the each sprint backlogs.
• Worked on automated solutions to manage the database backups and restore mechanism on pre-production environments.
• Worked on VSO branch management strategies using azure git.
• Worked on devops release pipelines to automate the deployments.
• Create Azure Site Recovery solutions to manage the server failures, backup and restore the virtual machines on different azure regions.
• Manage the pre-production environments for end-to-end factory runs.
• Co-ordinate with all scrum team members to manage every monthly releases.
• Worked on hybrid cloud environment to process the transactions.
• Debugging build\release failures, coordinating with other team members to resolve issues.
• Worked effectively with cross-functional design teams (Azure product teams, Finance BI teams) to create software solutions that elevated client-side experience and significantly improved overall functionality and performance.
• Day to Day connect with Confidential clients on application development status and attend the. Standups, Scrum of Scrum to discuss software-related technical issues\ blockers.
• Worked closely with other business analysts, development teams and infrastructure specialists to deliver high availability solutions for mission-critical applications.
• Developed an effective build automation, continuous integration and test environment that reduced integration issues and improved code quality
• Worked on automation solution to migrate the on-prem servers to cloud using azure resource manager templates.

Confidential

BI Engineering

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Developed the classes using C#, which incorporate N-tier architecture and database connectivity.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration of DTS packages to SSIS packages
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Involved in SQL Server Configuration, Administration, Implementation and Troubleshooting for Business work.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.

Confidential

Integrated Web applications

Responsibilities:

• Designed and developed Logistics software web applications using .net framework, C#.net, java Scripts.
• Developed the middle tier business logic components using .net framework that interact with the database and processes all the data for the presentation layer to display and also involved in various phases of database design like Logical and Physical layers.
• Java Script was written for the client side validation, browser detection and application functions.
• managed team of five developers and discussed issues to provide resolution and apply best practices.
• Adjusted software parameters to boost performance and incorporate new features for meeting customer needs.
• Performed regression and system-level testing to verify software quality and function prior to release