Solution Architect in AWS Startup working with APAC customers to help them build strategy to migrate on AWS services. The work requires interaction with Cx level executives to help them innovate using AWS cloud services. As an accomplished AWS Solution Architect, I play a pivotal role in architecting and implementing robust cloud solutions that empower organizations to achieve their strategic goals. My responsibilities encompass a broad spectrum of duties, combining technical expertise with a client-focused approach to drive successful cloud transformations.Key Responsibilities:Solution Design: Collaborate with clients to understand their business needs and design scalable, secure, and cost-effective AWS architectures. Develop comprehensive architectural diagrams and documentation.Technical Leadership: Provide technical leadership throughout the project lifecycle, guiding development teams, and ensuring the successful implementation of cloud solutions.Cloud Migration: Lead and facilitate cloud migration projects, assessing existing infrastructure, developing migration strategies, and executing seamless transitions to AWS.Client Collaboration: Act as a trusted advisor to clients, offering insights and recommendations on AWS best practices, cost optimization, and security measures. Build and nurture client relationships to ensure ongoing satisfaction.Innovation: Stay abreast of emerging AWS technologies and industry trends. Integrate new tools and features into existing architectures to enhance performance and efficiency.Performance Optimization: Continuously monitor and optimize AWS environments to ensure optimal performance, scalability, and cost efficiency.Cross-functional Collaboration: Collaborate with cross-functional teams, including developers, operations, and security, to deliver end-to-end solutions that meet business objectives.

• Working in the Service Architecture, Governance & Enablement of team globally.• Steering Implementation of advanced Microsoft Azure adaptation and transition from on-prem to Cloud -PaaS and SaaS models. • Driving Cloud Governance on Enterprise-wide engagements and steering Data & BI Technology adaptations.• Implementation of MS-O365 setup, configuration, and management including Teams, Power Platform (Power BI, Power Apps, Power Flow)• Formulated Modern-Day warehouse using cloud database design techniques across data warehousing, SQL Server, MySQL, NoSQL & Postgres and Bigdata technologies.• Onboarding Power BI for enterprise suites and Transition of existing dashboards to Power BI.• Managing deliverables with agile project management principles using GitLab and Azure DevOps

• Completed end-to-end Cloud migrations for IaaS and PaaS for enterprise clients.• Implementation of end-to-end Data Integration Projects based on Associative Data Modelling and Azure Data Stream (for IoTs) as well as AWS Kinesis for live streaming of Data.• Completed Database Migration Projects from On-Prem to Azure Cloud (SQL Azure) and AWS Redshift with ~1.5 TB of Volume Involved• Driving Technology roadmap with clear millstone presentation to stakeholders and other executives liable for decision making.• Driving Cloud Governance on Enterprise-wide engagements and publishing Data & BI Technology Policies and this helped to reduce the data volume by 18% and total storage cost by 63% overall.

• Migration of 20 servers from On-Prem to Microsoft Azure as IaaS (total production data size of 11 TB)• Leveraged the technical capabilities of the organization by introducing cutting edge technologies such as Azure, Power BI (replacing SSRS), ADF (replacing SSIS), Azure Cloud Storage (replacing FTP and file servers)• Created service principal using SSL for automation using PowerShell and ARM templates.• Design infrastructure based on HUB and SPOKE model for Big Data requirements• Configure Azure AD Application Proxy connectors to work with outbound proxy servers• Defined data model for each Confidential service for managing information and Established Azure Governance Committee for the organization and driving towards the cloud excellence• Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets• Agile/Scrum with multiple cross-functional teams.• Developed and presented customer database to internal database loading strategy that leads to first-ever direct warehouse loading project at S+ resulting in significantly shortened development and warehouse loading time

• Standardization of data warehouse design and ETL towards a dimensional model.• Established the QlikView/NPrinting BI suite of tools as the preferred standard for DSS and worked diligently to optimize the DW architecture and performance.• Became an early adopter of ITIL and established the Business Intelligence team as the model of effectiveness in Service Desk Management within Net-Link India• Developed Solutions for real-time Data Analytics using Azure Stream and Power BI for NL Decision Support.• Provide technical guidance on building solutions using Azure PaaS and other services to other teams.• Troubleshoot and identify performance, connectivity, and other issues for the applications hosted in Azure • Developing, implementation, and documentation of operating policies, methods, processes, measures, and tools.

• Fixed major gaps in reporting and data management capabilities and developed mitigation strategies which helped the executive dashboards prediction by 36%• Developed and presented customer database to internal database loading strategy that led to first-ever direct warehouse loading project at Fetter Logic resulting in significantly shortened development and warehouse loading time.• Implemented data extraction tool using metadata to generate Extract, Transform and Load (ETL) loader code for large warehouse (VLRDB) and Operational Data Store (ODS).• Designed and implemented a financial dashboard to track the company's performance against the annual budget enabling the management to make better, faster, and more informed business decisions• Implementation of GCP – Big table/Query setups as well designing cloud platform for a solution approach, cloud assessment workshops, POCs, and development/migration Plans.• Engaging with customer base to understand their evolving business needs and align IT strategy on priorities

• Wrote Company's MetaData standards and practices, including naming standards, modelling guidelines and Data Warehouse Strategy.• Built and tuned complex and large data load from various sources to ODS (Operational Data System), Financial Star Schema and Campaign Analysis Mart ETL (ADF/SSIS, Power BI and R)• Re-designed SQL data warehouse to implement consistent naming conventions. Applied normalization as appropriate. Implemented Type 3 slowly changing dimensions. Created multiple calendars (including fiscal and 454). This data warehouse was 4 TB in size.• Evaluation of Various technologies in Data and BI area as well as driving the overall vision for technology roadmap Business Intelligence. • Published the enterprise wide tech specification for Databases and BI tech framework for Qlikview, Qliksense, Tableau, Microsoft Power BI, and MSBI which is a standard code of conduct for all technical implementation in these areas.• Interfacing role for stakeholders including external and internal as well as hands on as consultation for various enterprise needs for many of the Tavisca’s clients. • Reviewed and updated project plans, identified and resolved issues/concerns, and coordinated completion of project activities

• Created Technical Architecture for Synechron ERP system based over MVC framework 3.0/4.0, Microsoft SQL Server 2008 R2, SSIS, SSAS and Qlikview 11.20.• Published the enterprise tech specification for Databases and storage and BI tech framework for Qlikview with Google Analytics and SAP connector and MSBI which is a standard code of conduct for all technical implementation in these areas.• Analyzing business requirements from technical & functional standpoint and planning future strategies.• Working in the capacity of Solution cum Technical Architect to provide solutions to various business needs and then design the software product model.• Managing delivery with strength of nearly 35 members in team utilizing Agile – Scrum management approach.• Responsible for managing client and serving as single point of contact for Client Communication & Leadership Team. Participating in Business review meeting with various stakeholders and business heads for reviewing project milestone and taking appropriate measures for project establishment till completion.Highlights:• Handling delivery of 9 Critical projects in global platform with customer satisfaction rate more than 90%.• Awarded Best Employee Nomination and winner the Best Employee Category as “Surpass Award Q2 2013”.• Awarded Best Employee “Oscar Award – 2013”

• Functioning as a Subject Matter Expert (SME) for SQL Server and various Business Critical applications supporting Microsoft business worldwide.• Facilitated and documented evaluation of business/IT systems for an internal IT systems Audit project (As-Is vs To-Be)• Created "white papers" to direct data clean-up efforts and performance enhancement recommendations in an Oracle and MS SqlServer environment.• Provided recommendations on data gathering and analysis based on best practices and emerging technologies.• Led the implementation architecture effort for a large scale, multi-year client data integration Hub project spanning multiple business units. Successfully created the reference architecture, the implementation architecture, services APIs, and data models, all of which were implemented using MS-DW platform• Successfully tech-upgraded of mission critical applications from Windows to Cloud Platform.• Designing and implementation of system availability with Microsoft Cluster Services (MSCS), Storage Attached Network and SQL Server 2008 R2 / 2012 with Database Mirroring, Log-Shipping & HADRON.• Organized and coordinated the Data Governance Council. Recruited business executive and senior staff members, organized and chaired quarterly meetings. Framed data quality issues for discussion and resolution. Facilitated business data stewards in defining business entities and attributes and data quality requirements• Development of SQL Server Reporting Solution using SSRS for various business needs, thereby overseeing the overall design and development.• Handling migration of Critical Servers from ‘End of Life Retirement’ to Stay Current as per Microsoft Standards.• Developing backup strategy and disaster recovery solution for various businesses across Microsoft• Actively involved in Monthly Business review and quarterly business review to keep alive the rhythm of business (ROB) & Prepares documentation in compliance to establish company standards

Handling SQL Server Practices across projects as being part of "SQL Server Center of Excellence"Implementing SQL Server Best Practices and Database Standards.Handling SQL Server "Production DBA Team" for The digital Group Inc. - A CMM level 5 CompanyDexterously handled 9 projects with total strength of 15 people, which includes 5 business critical projects, along with a technical team who worked with SQL server core production environment with BI tools such as SSRS, SSIS and SSAS. Accredited with ‘Achiever’s Award’ for successfully delivering a critical project for Fiji Government.

Involve in decision management where critical decision can be taken in favor of the business.

HSBC Technology and Services USA database support on SQL Server 2000/2005.End-to-End Database support.

Servers and Database Management, Fine Tuning, Planning and Supporting High Availability and Disaster Recovery for mission-critical environment.Design environment, security, and supported a wide variety of EFT (Electronic Fund Transfer) Application such as ‘Postilion’.Installation of Production Server and Databases across the business locations.

Assisting senior DBA in managing over 26 nos. of High-end SQL Database Servers that hosts Insurance, operations and development databases.Assisting in the availability of the Databases and optimum running of the Business Applications.Working with Multiprocessor and huge Memory IBM Blade Server, X440/342 series Virtual Server (VMware) technology, SAN (FastT) and NAS (Network Attached Storage) for hosting dedicated SQL Servers.Monitoring the performance of SQL Servers to tune workload. Involved in the development/ Performance Tuning/ Backup (SQL/Legato) and Restoration/ Maintenance of Databases.