Sr Cloud Data Architect/Engineer

Vandana Kandala Mail ID: ***************@*****.***

Ph No : 404-***-****

Summary:

Accomplished Azure Cloud Data Architect with 13+ years of IT experience in cloud architecture and transformation. Expertise in designing, implementing, and managing On Prem servers and Azure solutions, showcasing leadership, technical skills, and experience with cloud architecture patterns and Azure services Led the migration of on-premises applications to Azure Fabric resulting in lowering infrastructure costs

Experience migrating on-premises workloads to Azure by optimizing Azure infrastructure for performance, cost, and security.

Highly experienced in designing and implementing large-scale cloud solutions. Proven ability to lead technical teams, drive cloud adoption, and optimize Azure environments for performance, cost, and security

SQL BI technologies on versions 2000-2021 with SSIS/SSRS/SSAS (Tabular & Dimensional Model), Microsoft Azure, Power BI analytical tools and worked extensively on Database design including data modeling and creation of database objects.

Highly experienced Azure Cloud Architect experience in designing and implementing cloud solutions. Proven ability to reduce infrastructure costs, improve system performance, and support business growth through strategic cloud adoption.

Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems along with extensive knowledge of RDBMS with in-depth of T-SQL and good understanding of the Agile Scrum and Waterfall Development methodologies.

Worked on Database usage in cloud, design, administration, OLAP, OLTP and data warehousing, clustering, performance, XML, text search.

Extensively worked on Design, Development, Deployment & Maintenance of ETL process using SSIS to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML /SQL/ Oracle/Teradata) to different targets (DB/Files).

Work extensively in Design, Development, and Test to maintain business intelligence reporting solutions.

Collaborate with business stakeholders to understand business goals, reporting/data needs and build scalable Dashboard solutions.

Experienced in MS SQL Server configuration, Partitions, Table Compressions, performance tuning, client/server connectivity, query optimization, back-up/recovery.

Extensively worked on Data modeling for Data Warehouse/Data Mart development, Data Analysis for OLTP and OLAP/ (BI) applications, concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Core Skills & Competencies:

T-SQL, SQL, PL/SQL, .NET Framework, VBScript, XML, HTML, DHTML, Shell Scripting, SQL Server 2021-2000, Oracle 11.0, SSRS, SSAS, SSIS, BIDS, Visual Studio 2019, DTS, Crystal Reports, MS Access, Excel/VBA,VB Coding, Teradata 14.0, TFS, Web Service, Power BI, Microsoft Azure, Python, Azure Synapse, Microsoft Fabric certified, Team Foundation server, Jira, Azure DevOps, Visual Code, PySpark, Salesforce, JDE(AS400), Azure IaaS/PaaS/SaaS, Multi-Cloud Strategy, Landing Zones, Hybrid Cloud, Application Gateway, Azure Firewall, Azure SQL, Cosmos DB, Data Lake, Blob Storage, Backup & Disaster Recovery

Projects Summary as Sr Cloud Data Architect

Dunwoody GA 12/2021- Present

Beazer Homes USA, Inc. is a home construction company based in Atlanta, Georgia. In 2016, the company was the 11th largest home builder in the United States based on the number of homes closed. The company operates in 13 states. As of December 31, 2016, the company had 161 active communities.

Responsibilities:

Working in Azure cloud migration and enterprise architecture, cost optimization, security, and DevOps automation to deliver scalable, compliant, and highly available solutions with proven success designing and leading migrations to Azure Synapse by Automating cloud deployments using CI/CD pipelines.

Strong expertise in SQL BI (SSIS, SSRS, SSAS), data modeling, ETL development, and building Power BI reporting solutions. Adept at guiding technical teams, aligning cloud strategies with business goals, and ensuring regulatory compliance.

Extensive knowledge and experience in working with RDBMS, Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Views, Cursors, UDF and Data integrity.

Experienced in leveraging initially TFS but used ADiTaaS for some time and then right now using ServiceNow as a ticketing system to track issues, manage sprints using Jira to coordinate development efforts

Designed and led the implementation of a scalable, AI-driven data platform on Microsoft Azure, integrating data from multiple sources, modernizing pipelines with Azure Data Lake, Synapse, and Machine Learning services, and enabling advanced analytics while improving processing speed

Implemented Legacy systems to Azure migration example: JDE, Salesforce, SQL Server, BOSS, BuildPro, Hyperion, Pathlight Pro, Trust Builder, Mortgage choice etc.

Modified cloud environments using Azure Resource Manager (ARM) templates, Managed data migration from SQL Server to Azure, reducing data retrieval time.

Redesigned cloud architecture using Azure Fabric and integrated OneLake to centralize raw data collection for some systems which are business critical.

Design, develop, maintain and support and test advanced SSIS packages related to the extraction, transformation and loading (ETL) process.

Imported JSON data via REST APIs using PySpark notebooks, aggregated and analyzed the data, and ingested it into semantic models to enable Power BI dashboards that provide business users with deeper insights

UPS Dunwoody GA 07/2016- 11/2021

United Parcel Service (UPS) is a 110-year-old package Delivery Company and a provider of supply chain management solutions. The global logistics company UPS's primary business is the time-definite delivery of packages and documents worldwide.

Responsibilities:

Working on UPS Revenue per Plane & Other F&R Projects using different types of Conceptual, Logical & Physical Data Modeling to build the Data Model and analyze the data for Business Users.

Transformed traditional IT infrastructure into Azure cloud, reducing infrastructure costs.

Implemented Azure DevOps pipelines to automate deployments and migrate from Team Foundation Server, reducing cycle times and improving team efficiency.

Deployed, configured, and maintained SSIS packages on SQL Server 2019 to support ETL workflows.

Managed the deployment of SSIS solutions to SQL Server 2019 environments using TFS for source control and release automation

Extensively worked in development and tuning of SQL queries SQL queries (SQL commands DDL, DML and DCL), CTEs, Stored Procedures, data extracts, Data analysis and query optimization and other performance tuning.

Streamlined ETL processes by cleansing and integrating data from diverse sources (Teradata, Oracle, flat files, legacy systems) with SSIS and SQL Server tools.

Improved system reliability by scheduling and managing SQL Server jobs, monitoring performance, and proactively resolving server issues.

Write advanced complex SQL queries and stored procedures to perform complex database tasks using T-SQL, PL/SQL, Teradata and implemented best practices to maintain optimal performance.

Import JSON Data using REST APIs, Aggregated and analyzed data then ingested into SSRS for creating Dashboards, Metrics, and KPI for the business users to have a better insight into the business.

Environment: Microsoft SQL Server 2008R2/2012/2014, SSIS, SSRS, SSAS, MS Access, ODBC, Oracle 12c, Teradata 14.0, MS Office 2010, SVN, SharePoint 2010, Power BI, TFS

AT&T (Atlanta GA) 01/2015- 06/2016

AT&T is one of the world’s largest communications companies operating globally under the AT&T brand. It is one of the world’s most advanced and powerful global backbone networks, carrying 82.8 petabytes of data traffic on an average business day to nearly every continent and country.

Responsibilities:

Working in a fast-paced team for performing Extraction Transformations and Load DTV Merger data while working for both Mobility & Home Solutions.

Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams and Translated business user concepts and ideas into comprehensive business requirements and design documents.

Extensively worked as business analytics with a strong focus on customer relations and the drive to produce accurate deliveries that fit both the needs and wants of the client.

I am highly skilled in business process research, data analysis and problem-solving

Write advanced SQL queries and stored procedures to perform complex database tasks using T-SQL, PL/SQL, Teradata and implemented best practices to maintain optimal performance.

Involved in data migration & building data Model for the MicroStrategy reporting team.

Develop interactive dashboards, scorecards, highly formatted reports for the business users to analyze the call center evaluation and analytics.

Worked extensively on key concepts in data analysis, Dimensional Data Model (Star Schema), Data Mapping and data visualization Develop to Reports & Dashboards for business users

Created SSIS packages for the purpose of building reports for business users and deploying them.

Created visually impactful dashboards in Excel and Power BI for data reporting by using pivot tables and VLOOKUP. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.

Experience in Batch processes, SSIS, DTS, BCP, Import, Export, and Backup.

Environment: Microsoft SQL Server 2008R2/2012/2014, SSIS, SSRS, SSAS, MS Access, ODBC, Oracle 11g, Teradata 14.0, SQL Assistance 14.01, MS Office 2010, SVN, SharePoint 2010, Microsoft Azure, Power BI.

Norfolk Southern Corp. (GA) 05/2012 –12/2014

Norfolk Southern Corporation is one of the nation’s premier transportation companies. Its Norfolk southern Railway subsidiary operates approximately 21,000 route miles in 22 states and the District of Columbia, serves every major container port in the eastern United States, and provides efficient connections to other rail carriers. Norfolk Southern operates the most extensive intermodal network in the East and is a major transporter of coal and industrial products.

Responsibilities:

Understanding the requirement and working with different teams to do Data Analysis on different Data Sources like (Oracle 11g, Teradata 14.0 and MS Access) to provide Power BI for the business users.

Used Fast Export utility to unload large volumes of data to feed downstream data marts.

Converted the cubes built on DTS Packages from SQL Server 2000 to SSIS packages SQL Server 2008 R2 and added the new business logic for some cubes.

Skilled in development and tuning of SQL queries (SQL commands DDL, DML, DCL and TCL), Stored Procedures, data extracts, Data analysis and query optimization, and other performance tuning.

Create solutions that heavily rely upon T-SQL which requires strong analytical skills to interpret and provide analysis of data and design the best possible ETL process around those goals.

Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008 R2

Created Tabular Models from Data Warehouse (SSAS) for the LEADER Project.

Actively participated in transforming enhanced logical data model to physical data model

Actively involved in Data Gathering, recognizing and confirming the data sources/elements.

Upgrade/Changes Legacy DTS/SSIS packages related to the extraction, transformation and loading (ETL) process.

Environment: Microsoft SQL Server 2005/2008/2008R2/2012, SSIS, SSRS, SSAS, Excel/VBA, MS Access, ODBC, Oracle 11g,TeraData 14.0, SQL Assistance 14.01, MS Office 2010, SharePoint 2010, TFS, Power BI.

CareerBuilder Norcross, GA 01/2012 – 04/2012

CareerBuilder is an employment website founded in 1995 and with offices in the United States, Canada, Europe, and Asia. CareerBuilder.com provides labor market intelligence, talent management software, and other recruitment solutions, including online career search services for more than 1,900 partners as of March 2008.

Responsibilities:

Responsible for maintaining and improving operational reporting including new development in accordance with best practices

Involved in Scrum Project Management activities.

Ability to collaborate with peers in both business and technical areas, to deliver optimal business process solutions, in line with corporate priorities.

Extensively involved in Data Extraction, Transformation and Loading (ETL process) from different Sources to target systems using SSIS.

Created stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.

Created SSRS reports, Deployed and published on SSRS report server which were later consumed by business users.

Environment: Microsoft SQL Server 2008R2, SSIS, SSRS, BI, DTS, SQL, MS Access, ODBC, Oracle 10i, Tortoise SVN, MS Office 2007, DTS

NYK Business Systems Americas Inc., Secaucus NJ 02/2009 – 12/2011

NYK Business Systems Americas Inc. is a Global provider of IT for NYK, a Global logistics shipping company. The aim of the project is to provide prompt and accurate Freight business solutions and change of certain business rules that require the development of new modules to the system.

Responsibilities:

Migrated data from Heterogeneous data Sources and legacy system to centralized SQL Server databases using SQL Server Integration Services to overcome transformation constraints.

Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.

Extensively worked on Developing, deploying and supported SSIS packages on SQL Server integration catalog using flat files, SQL Server and Oracle as the source.

Supported data warehouse database and multidimensional cube to make sure the jobs are processed successfully, and the cube is processed in a timely manner to meet the SLAs.

Participate in JAD sessions to understand the existing and new business requirements and document the respective design specifications number of processes.

Interact with the users, subject matter experts (SME) and other stakeholders to acquire a better understanding of the business processes and needs.

Created and monitored database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.

Maintained Documents for the business users on Microsoft SharePoint to store, organize, share, and access information

Worked closely with the development team on monthly releases and helped fixing the bugs encountered by proactively addressing the issues.

Worked flexibly at late hours with the development team on making any changes and deploying code to the Production Servers.

Setup Windows task scheduler jobs to push all the outbound files to different vendors generated by our daily process.

Environment: Microsoft SQL Server 2000/2005/2008R2, SSIS, SSRS, BI, DTS, SQL Profiler, MS Access, ODBC, Oracle 10i, Microsoft Visio, Erwin, MS Office 2007

Contact this candidate