Home

Sesha chaitanya - Technical consultant Architect

[email protected]

Location: Salt Lake City, Utah, USA

Relocation: Yes

Visa: H1B

Around 15+ Years of professional IT experience as an Accomplished Cloud Architect with extensive experience designing, implementing, and optimizing cloud solutions on Azure and Google Cloud Platform (GCP) Managing BI and Cloud applications using Azure, GCP, SharePoint Online, Project Online/Server, Project for Web, SQL Server, SSIS, SSRS, SSAS, T-SQL, Proven track record in architecting scalable, secure, and highly available cloud infrastructure to meet business objectives in domains like Manufacturing, Oil & Gas, Telecom, Banking, E-commerce, and Health Care, proven ability to lead project teams to successfully deliver agreed upon solutions of the highest quality, often in the complex and challenging customer environment. Proficient in designing and deploying cloud solutions on Azure and GCP, Expertise in cloud architecture, including compute, storage, networking, and security. Strong understanding of hybrid and multi-cloud environments, Experience with containerization technologies like Docker and orchestration tools like Kubernetes. Conversant with all phases of the Software Development Life Cycle (SDLC) involving System Requirements, Analysis, Design, Development, Implementation, Integration, Testing, Deployment and Maintenance. Extensive experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau. Extensive experience in Data warehousing concepts, DW Architecture, DW/BI tools, MS Azure - Azure SQL, AAS, Azure Synapse, Azure Data Factory (ADF), Azure Data Lakes, Azure DevOps, Azure Logic apps, Azure Data Bricks, MS SQL, MSBI - SSIS, SSRS, SSAS, Power BI, QlikView, Informatica, Oracle, Excel VBA, VB and Excel Pivot, Strong experience in Azure SQL stack architecture - Azure SQL, Synapse, Azure AS, Azure Function, Cosmos DB, Azure Data Factory, Data Lakes, Logic apps and Azure laaS Technologies - VMs, SaaS, PaaS and laaS architectures Well-versed with Microsoft Office Suite, including Office365, Lync, MS Visio, MS Access, Project, Power Query, PowerPivot, DAX, SharePoint, and SharePoint Design. Expert knowledge of architecting and developing Power BI solutions by configuring the data security, assigning the licenses, and sharing the reports and dashboards with the different user groups in the organization. Experienced in client requirement Analysis, Physical, Logical Design, Development, Debugging, Testing, Deployment, Support, and Maintenance of business applications using SQL Server 2019/2016/2014/2012/2008/2005, SSIS and SSRS 2005/2008/2012/2014/2016/2019. Experience developing Custom Reports, different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (MS POWER BI SSRS) in the Business intelligence development studio (BIDS). Experienced in migrating Data from Excel, Flat file, and Oracle to MS SQL Server using SQL Server Integration Services (SSIS) and expert in Creating, Configuring and Fine-tuning ETL workflows in SSIS. Experience in creating and deploying MS POWER BI SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column and Data Conversion Transformations Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2019/2016/2014/2012/2008/2005. Experience in writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as tables, views, indexes, complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs). Strong Data modelling experience using ER diagrams, Dimensional data modelling, Working knowledge of ODBC, OLEDB, T- SQL, SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers, and scripting languages. Experienced in working with SQL Query Analyser, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Security Architecture and SQL Profiler Experience in designing and implementing various SharePoint Features, Content Types, List, User Permissions, and Solution Packages. Hands on experience in deploying and customizing Collaboration, Meetings and Enterprise Site Collections, Templates, Sites, Libraries, Web Parts, Lists, Columns, User Groups, Directory and views for branding of SharePoint portals. Responsible for Data Modeling, Enterprise Data Management, Data Presentation, Visualization, Optimization, Risk assessment, predictive analysis, advanced Data Analysis, Business Research and Quantitative Analysis Experienced in ETL processes, Data warehousing methodologies and concepts, including Star schemas, Snowflake schemas, Dimensional modelling, Reporting tools, Operations Data Store Concepts, Data Marts and OLAP technologies. Extensive experience in developing tabular and multidimensional SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, deploying and Processing SSAS objects. Proficient in SQL Server Integration Services like Package creation, Check Points Implementation, Dynamic Configuring of packages, Logging, Custom script writing, Package deployment using Manifest, Implementing Transactions, and Package encryption. Proven mentor and trainer, skilled at communicating with all organizational levels and cross-functional teams to develop a shared vision and foster a culture of excellence. Eager to learn new Technical and industry skills and derive simplicity from complex problems. With Strong technical writing skills helps in Problem-solving issues that arise in during the documentation while requirement gathering and while creating technical / functional documents, running of automation processes and providing timely responses and solutions as required. CERTIFICATIONS 70-778 Analyzing and Visualizing Data with Microsoft Power BI PL-300 Microsoft Power BI Data Analyst AZ-900 Microsoft Azure Fundamentals MS-900 Microsoft Office 365 Fundamentals AZ-104 Microsoft Azure Administrator 70-533 Implementing Microsoft Azure Infrastructure Solutions 70-532 Developing Microsoft Azure Solutions Keywords: business intelligence database active directory information technology microsoft procedural language Arizona