Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
AccountManager

Shravya Ponuganti

Cloud Engineer
Hyderabad,TG

Summary

Around 8 years of experience in IT sector and Azure Cloud Engineer with 4+ years of experience in Windows Administration (Microsoft Azure IaaS & PaaS), Configuration Management, Continuous Integration, Continuous Deployment and Cloud Implementations. Should be well versed and creating Azure services like Virtual Machines, Storage Accounts, Azure Key Vaults, Azure AD & Roles, and Resource Groups. Hands-on experience on configuring and troubleshooting Application Gateway Firewall, Load balancers, VMs/Disks encryption/increase, Azure Key Vaults, Network Security Group. Hands-on experience and taken ownership on troubleshooting the Reactive issues which are related to Application configurations, Jobs implementation, Access/Permission level and resolved and supported to Functional teams. Hands-on experience and implemented Azure Update Management Automation for to install Windows Updates automatically. Hands-on experience and implemented Low Disk Space Alerts Rule/Monitor Automation for to receive email notification on disk space. Having experience on Azure AD Administration. Hands-on experience on replicating the Virtual Machines in other Regions. Hands-on experience and procured SQL and Web Servers by using ARM templates for Dev, UAT and PROD environments under IaaS & PaaS subscriptions. Hands-on experience on PAAS Resource creation under Azure Cloud services such as Data Factories and SQL Servers. Experience in handling backend data sources like MS SQL Server 2012/2019. Develops and maintains cloud infrastructure user access roles under PAAS subscription level. Deploy, Configure, Maintain Compute on Azure Cloud. Hands-on experience and installing, configuring Virtual Machines, Storage Accounts, Virtual Network, Azure Load balancer, Automation Accounts in the Azure cloud. Hands-on experience and creating Resource Groups, Resources under Subscription level and configured to Workspace, Azure Key Vaults, Storage Accounts, Automation Accounts. Hands-on experience and Remote login to Virtual Machines to troubleshoot, Monitor and deployed applications related issues. Hands-on experience and implementing the Azure DB backups like Full/Differential/Transactional db’s backups from Server level. Hands-on experience and implementing the CI/CD pipelines for copying data using Azure Data Factories. Manage on-premises resources, authentication configurations and on-premises infrastructure using Azure Active Directory (ADD). Hands-on experience and creating the Replication of Azure VM in other regions with same configurations. Hands-on experience and enabling the Inbound & Outbound rules.

Overview

8
8
years of professional experience
7
7
years of post-secondary education

Work History

Azure Cloud Engineer

Microsoft, Microsoft Azure IaaS
06.2020 - Current
  • Environment : Windows Azure IaaS, Windows Power shell, Express Route, Windows SQL Server 2016/2019, VNet, ADF CI/CD Pipelines, Azure Key Vaults, Azure Update Management, Log Analytics Workspaces, Monitoring VM Health Checks, Monitor Alerts, ADD, Storage Accounts, Logic Apps, Azure Backups, IAM, Load balancer, ARM Templates, GitHub repository.

Data Warehouse

01.2017 - Current

Application Development Senior Analyst

Exxon Mobil
02.2016 - 01.2017
  • ExxonMobil is a chain of gas stations and a brand of motor fuel and related products.Data from all channels and sources will be ingested, processed, and persisted in the cloud.
  • Roles and Responsibilities:.
  • Implemented code fixes to major components of clickstream data analytics per given change requests.
  • Hands on experience on analyzing the requirement and bringing the right set of data to the end user through analytics.
  • Worked on Azure environment and HDInsight.
  • Development and modifications of pipelines in data factory.
  • Worked on Azure SQL scripts.
  • Created – external and managed tables in HIVE to store the processed results and performed various operations (Joins, Sub queries to group data) on structured and semi structured data (JSON).
  • Unit testing of end to end flow process which includes pipelines, hive scripts, stored procedures, views etc.
  • Actively involved in deploying packages across various environments after due code fixes were made.
  • Early detection of bugs and smooth testing process in various instances.
  • Fine tuning the performance of queries by following best practices in Hive.
  • Technologies Used: Azure Data Factory, Azure SQL, Azure Functions, Data Factories, Hive, Power BI.

Application Development Analyst

Microsoft
12.2014 - 01.2016
  • Microsoft Manufacturing, Supply Chain, and Information Services (MSCIS) group is a Global Supply Chain Management group at Microsoft.
  • Every year, Microsoft launches new products.
  • MSCIS is responsible for bringing these new products to market.
  • To support these products, new partners are added to the Supply Chain, including Supplier, Manufacturer, Distributor, Retailer, Service Center, Carrier, and so on Roles and Responsibilities:.
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
  • Optimized queries using SQL Profiler and Database engine tuning advisor.
  • Used SQL Server Agent for scheduling jobs and alerts.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
  • Understanding the Requirements and Functional Specifications of the Campaign that the circle going to launch on specific zones.
  • Attended the daily meeting on the change request of campaign.
  • Working on RCAs on Major Incidents and drive for corrective actions till closure.
  • Creating on Major Problem Review reports and deliver the reports.
  • Tracked the MPRs and CAs and updated the tracker as and when required.
  • Collaboratively work with SO/SE Teams for root causes of the issues.
  • Proactively identify the repetitive issues for the applications in scope and drive for the permanent fix.
  • Technologies Used: SSRS, SSIS, MSSQL, Visual Studio.

Application Development Associate

SAP, Accenture System Diagnostics
08.2012 - 11.2014
  • Accenture’s innovation in SAP, ASD helps accelerate knowledge transition to improve the quality of knowledge gathered and increasing the efficiency in supporting client applications.
  • ASD connects to client’s landscape SAP system, extracts relevant data, and does analysis of data and churn out report which provides a blueprint of the client SAP system.
  • These reports have been build keeping in mind the usability during the knowledge transition process continuous improvement and due diligence.ASD interacts with the SAP ECC / APO / SRM / CRM / BW / BI / PI box in client landscape using JCO Connector (library provided by SAP).
  • It extracts the required master and summary transaction information, performs analysis on the same and stores the analyzed data in to (Accenture configured laptop and installed) database used for deployment in client landscape.
  • This data is then transferred to Staging/UAT server for further delta validation, post which it is uploaded to Accenture production cloud where client is allowed to view their report after appropriate Accenture authentication and ASD authorization.
  • This data is available 24.
  • 7 on ASD website https://aies.accenture.com thus anyone outside Accenture will never be able to view this client confidential report data.
  • Roles and Responsibilities:.
  • Written complex queries / stored procedures / functions / triggers / cursors using JOINs,.
  • Sub-queries, common table expressions, CASE statements, table values parameters and.
  • Other logical condition handling.
  • Fine-tuned the existing queries.
  • Constructed and optimized queries for high volume of data.
  • Provided SSRS and SSAS support for internal IT projects requiring report development.
  • Extracted data from internal data warehouse system to SSRS.
  • Designed and developed stored procedures, queries and views necessary to support SSRS reports.
  • Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like flat file, Excel file.
  • Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
  • Designing database as per the industry best practices.
  • Implemented the normalization for the tables.
  • Resolved performance issues.
  • Doing some basic DBA tasks.
  • Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
  • Involved in peer reviews with team members.
  • Experienced in Installing,Upgrading and Configuring of Microsoft SQL Server and Databases.
  • Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
  • Understood the Requirements and Functional Specifications of the application.
  • Participated in Review Business Requirements.
  • Identified and created test data for Test Scenarios and Test Cases.
  • Technologies Used: SQL Server Integration Services, SQL, SSRS, MS SQL, Query Analyzer, SQL Profiler.

Application Development Senior Analyst

Microsoft Business Solutions
, SNOW
03.2019 - 07.2020
  • Roles and responsibilities:.
  • Working as Cloud Administrator on Microsoft Azure, involved in configuring Virtual Machines, Storage Accounts, Resource Groups.
  • Remote login to Virtual Machines to troubleshoot, Monitor and deployed applications related issues.
  • Managing Windows 2016 servers, troubleshooting IP issues and working with different support teams.
  • Managing day to day activities of the cloud environment, supporting development teams with their requirements.
  • Configuring and managing Virtual Machines using Windows Azure portal.
  • Troubleshooting the RDP and Server level connectivity related issues.
  • Install and configure Virtual machines, Storage Account, Virtual Network, Azure load balancer in the Azure cloud.
  • Trouble shoot Azure related issues and engage Functional teams and vendor for Reactive kind of issues and resolutions.
  • Implemented Automation for install monthly Windows patches automatically by AUM.
  • Implemented Automation for to send alert notification on Low Disk space when actual size reached to 10%.
  • Increased the Drive space or Shrink the log files based on the disk alert for the data.
  • Maintained the Server backups (Full/Differential/Transactional Logs) for weekly base and scheduled job for it.
  • Procured SQL & WEB servers and configured for Windows Server 2016.
  • Created Azure Key vaults for storing the sensitive data (Passwords).
  • Created Storage accounts for storing the server DB backups using Azure Backup Key Vaults.
  • Monitored the System logs using Jarvis portal.
  • Restricted the Permissions for different Functional teams based on their usage for PROD env.
  • Created the CI/CD Pipelines for copying the data from one server to other server by using the Azure Data Factory and deployed successfully., This project is related to managing the Enterprise Data Warehouse for the clients Real Estates division.
  • The DW helps the business provide an insight to the Capital and Operational expenditures occurring for the Buildings the client owns.
  • The DW also helps manage and analyze the optimum use of the space (Space Management) available in a building and the rooms available for the resource (People Management) on the client’s payroll.
  • The delivery of the project was through Agile, comprising of a 2-week sprint, and CICD approach towards deployment.
  • Roles and Responsibilities:.
  • Direct interaction with the Business users and Business Analysts for requirement gathering.
  • As a Directly Responsible Individual (DRI), was responsible for the development as well support of the application.
  • Actively participate in the Scrum calls, retrospective and sprint planning meetings to discuss the user stories with the Product Owners.
  • Worked on Production and SIT deployments.
  • Worked on Azure V1 to V2 Migration.
  • Develop ADF activities on Azure to absorb the data from different sources (flat files, SQL Server, Azure Data Lake), and push them as Facts and Dims in the DW using Stored Procedures.
  • Created simple to complex stored procedures to transform the upstream data into Facts and Dimensions for the DW.
  • Maintain Master data for DW using SQL Server Master Data Services.
  • Integrate (ICM – Ticket Management Tool) with DW, to call out production failures and work on them as per SLA, as a part for DevOps (DRI) model.
  • Technologies Used: Azure Data Factory, Azure SQL, Azure Functions, .Net, PowerShell.

Education

Bachelor of Technology - Electronics communication and Engineering

G.Narayanamma Institute of Technology And Science
06.2008 - 05.2012

Intermediate - MPC

Sri Chaitanya Jr. College
07.2006 - 08.2008

SSC -

Gayathri High School
06.2005 - 04.2006

Skills

Azure cloud Engineer

undefined

Additional Information

  • Application Development senior Analyst in Accenture, Hyderabad from 20th May 2012 to till now.

Timeline

Azure Cloud Engineer

Microsoft, Microsoft Azure IaaS
06.2020 - Current

Application Development Senior Analyst

Microsoft Business Solutions
03.2019 - 07.2020

Data Warehouse

01.2017 - Current

Application Development Senior Analyst

Exxon Mobil
02.2016 - 01.2017

Application Development Analyst

Microsoft
12.2014 - 01.2016

Application Development Associate

SAP, Accenture System Diagnostics
08.2012 - 11.2014

Bachelor of Technology - Electronics communication and Engineering

G.Narayanamma Institute of Technology And Science
06.2008 - 05.2012

Intermediate - MPC

Sri Chaitanya Jr. College
07.2006 - 08.2008

SSC -

Gayathri High School
06.2005 - 04.2006

Similar Profiles

CREATE PROFILE
Shravya PonugantiCloud Engineer