Following are the brief details of various roles & responsibilities during my tenure at Infosys:

1. PPQR PaaS Migration [ Aug 2021 – Current]

Job Title: Technical Project Manager (Acting Sr. TPM) & Technology Architect Start date: Aug 2021 End date: Current

Project Description: Partner Portfolio & Quality Review (PPQR) is one streamlined and integrated IaaS based solution for one of the accounting firms to handle partner assignments, rotation, succession planning, partner portfolio review, partner quality review meetings, related Ronak Sanghavi

Technical Project Manager Technology Architect Azure Cloud Professional about

• Experienced Technical & Management me Professional with 13+ years of experience in Software development, People management, Client management and execution of large-scale technology projects from analysis, architecture and design, through development and deployment.

• International exposure and experience working from multiple countries (US, Canada, UK, China, Hong Kong, Macau & India)

• Expertise in coordinating diverse teams and resources to accomplished objectives in an efficient & timely manner. Organized & detail oriented with proactive in nature.

contact

919-***-****

adqvwn@r.postjobfree.com

125 Orianna Dr., Morrisville,

North Carolina - 27560

C o r e

Q u a l i f i c a t i o n

T E C H S K I L L S C E R T I F I C A T I O N

Software Design & Architecture

Web Application Development

Programming

Project Management

Team Building & Mentoring

Customer Management

Requirement Gathering

Databases

Agile Methodology

System Design

Azure Cloud (logic app, function app,

service bus, storage, key vault, event grid,

event hub, web app, api app, azure sql, data

factory, AAD, Service Principle, MS Identity)

MS technologies: NET Core, ASP.NET, C#,

MVC Architecture, Web Service, .NET Core

API (Microservices), Rest API, Rest API

(OAuth2 authentication), OData API, LINQ,

Entity Framework, SSRS, SSIS, DTS

CI/CD Automation in Azure DevOps

SQL Server (Developer & DBA),

Cryptographic implementation in SQL

Server

Az-303 -MS Azure Architect

Technologies (2021)

Az-203 – Developing Solutions for MS

Azure (2020)

Az-900 – MS Azure Fundamentals

(2019)

70-462- Administering SQL Server

(2018)

70-464- Developing MS SQL Server

(2018)

professional experience

B.E. Electronics &

Communication 2008

CITC, Gujarat University, India

Company Period

Infosys Limited July 2008 - Present

large PCAOB data requests and leadership approvals. Brainstormed idea and proposed solution to migrate application IaaS to PaaS to reduce infra cost, achieve high availability with no downtime and unaccountable for security patches & upgrade.

Technology: .NET Core 6, NET core Web API (microservices) with EF, Azure SQL Server, Azure Service Bus, Rest API (oAuth2 authentication), Azure Key Vault, Azure Storage,Azure Data Factory, Azure Active directory, Service Principle, CI/CD Automation in Azure DevOPs, DMA

(Database Migration Assistance)

Responsibilities:

• Brainstormed & getting started with PaaS ideation, defined the advantages for client, mapped each of existing technologies (IaaS) against corresponding Azure PaaS services to come up with ecosystem mapping.

• Calculated the indicative Azure services cost & ROI against each of the offering services & proposed complete package to client along with advantages.

• Prepared the high-level architecture solution, reviewed with IT architecture group & IT director from enterprise perspective and received sign-off.

• Provisioned Azure resources with necessary configuration, define the RBAC roles and setup.

• Prepared skeleton of project solution in visual studio .NET Core 5 with separation of layer (UI project, Core Project, Services Layer - .Net core 5 WEB API (microservices) with EF database first approach & DB project and committed into GIT source control for team to commence the full-fledge development. Later, .Net core 6 launched & project migrated to .NET Core 6.

• Implemented core project with reusable functionalities across the service layer such as connectivity to Service Bus, Key Vault, Storage account, Function app & SharePoint etc.

• Implemented Rest API with oAuth2 authentication using client credentials authorization flow to connect SharePoint in .Net core.

• Prepared database design strategically with scope of Azure SQL Server.

• Migrated the database using DMA from SQL server to Azure SQL Server.

• Lift & shift the existing SSIS packages to Azure Data Factory (ADF) using Azure SSIS IR.

• Project Planning, effort & estimation, resource planning & allocation, customer management and billing.

• Plan and implement scrum ceremonies - sprint planning, daily stand-ups, sprint reviews, retrospectives, backlog grooming & refinement - with Scrum team and Product Owners

• Clearly communicate goals, roles, responsibilities, and desired outcomes to internal cross- functional and remote project teams.

• Oversee the various stages of these programs, proactively mitigating risk and collaborating with many teams including the development, engineering and business stakeholders. Status monitoring & reporting to senior leadership.

• Support team to achieve goals by removing impediments & technical blockers, identifying, and resolving conflict, facilitating communication both within team and externally.

• Regularly encourages, motivates & appreciates team members publicly & provide constructive feedback one-to-one to grow potentially.

• Provisioned service principle using app registration and establish connectivity from devops to azure resource group for deployment.

• Achieved function app authentication using Microsoft Identity.

• Achieved CI/CD Automation in Azure devops.

• Conducted the Azure cloud training for more than 120 participants in organization, knowledge transition on Azure cloud along with deep insightful experience of migration journey. Purpose of this training to reskill & upskill the talents within organization. 2. Know Your Client (KYC) Integration layer

Roles: Technical Project Manager (Acting Sr. TPM) & Technology Architect Client – One of leading accounting firms

Start date: Jun 2020 End date: Jul 2021

Project Description: KYC is the process of conducting Client Due Diligence (CDD), by gathering information and documentation to understand who client may be entering into a Business Relationship with. It is an important measure in the identification, evaluation and mitigation of financial crime and reputational risks associated with clients and their business relationship. Required to have a single enterprise level system which can facilitate the data flow from all client applications and act as an integration point to internal & external systems. KYC Integration Layer the cornerstone this objective which helps to facilitate the requirement and fulfil the KYC process. Technology: Azure Integration services - Logic Apps, Function apps, Event Hub, Event Grid, Azure Storage, oData API, Azure Key Vault, Azure SQL Server, Azure Active Directory, Service Principle, Microsoft Identity, CI/CD Automation in Azure devops Responsibilities:

• Worked on project proposal with Project scope, Feature list, Timeline & Estimated cost, High Level Architecture Solution, AIS indicative cost for given requirement.

• Reviewed the logical architecture solution with IT architecture group from enterprise perspective.

• Provisioned Azure resources with their specification & required configuration, define the RBAC roles and setup.

• Prepared skeleton of project solution in visual studio with function app in .NET Core 5 & Logic app with standard connectors and committed into GIT source control.

• Extensively worked on Logic apps, function app, Event Grid, Event Hub.

• Implemented oData API for internal system to consume data.

• Plan and implement scrum ceremonies - sprint planning, daily stand-ups, sprint reviews, retrospectives, backlog grooming & refinement - with scrum team and Product Owners.

• Resolved challenges to deliver project on time while integrating with multiple teams and each team follows different sprint cycle. Continuous collaboration, communication with multiple stakeholders to align same deployment cycle on time.

• Clearly communicate goals, roles, responsibilities, and desired outcomes to internal cross- functional and remote project teams.

• Act as a coach and mentor to promote and enhance Agile adoption and proficiency across the organization.

• Support team to achieve goals by removing impediments & technical blockers, identifying, and resolving conflict, facilitating communication both within team and externally.

• Provisioned service principle using app registration and establish connectivity from devops to azure resource group for deployment.

• Achieved function app authentication using Microsoft Identity.

• Achieved CI/CD Automation in Azure devops.

• Established Splunk & SF connectivity.

• Prepared the case study implementing first AIS based solution org-wide & best execution project strategy following agile methodology, shared with client to replicate the best practices in other projects.

• Conducted the training for more than 85 participants in Azure Integration Service to share the knowledge & reskill the talents within organization. 3. PPQR K2 to Custom Workflow

Roles: Technical Project Manager & Technology Lead Client – One of leading accounting firms

Start date: Feb 2020 End date: May 2020

Project Description: K2 workflow being used in PPQR application and client was paying high cost for K2 license. As K2 license was about to expire in Jun 2020, proposed solution to convert K2 to custom logic in application as K2 workflows were not being used extensively and mainly used for stage progress.

Technology: Asp.NET Core 3.1 Web API (Microservices) with EF, Azure SQL Server, DMA (Database Migration Assistant)

Responsibilities:

• Proposed solution and showcase us as valued partner who is focused cost reduction, presented & materialized.

• Project Planning, effort & estimation, resource planning & allocation and customer management.

• Following agile methodology and practicing scrum ceremonies using Azure devops.

• Worked on database design, database maintenance, database performance improvements, Index maintenance and various database tasks

• Prepared skeleton of project solution in visual studio .NET Core 3.1 WEB API (microservices) with EF database first approach & DB project and committed into GIT source control for team to commence the full-fledge development.

• Migrated the K2 database to existing PPQR Azure SQL server using DMA for historic data.

• Involved in implementation of K2 specific logic into custom logic.

• Coordinating with scrum team, motivate them, track progress, reporting progress to leadership.

• Planning and managing all program stages

• Diagnosing & resolving issues.

• Successfully delivered bug free product without compromising the quality in a timely manner.

• Prepared case study on great example of cost saving value added product. 4. Partner Portfolio & Quality Review (PPQR)

Job title: Technical Project Manager, Business Analyst Client – One of leading accounting firms

Start date: Jul 2018 End date: Jan 2020

Project Description: Partner Portfolio & Quality Review (PPQR) is one streamlined and integrated solution for one of the accounting firms to handle partner assignments, rotation, succession planning, partner portfolio review, partner quality review meetings, related large PCAOB data requests and leadership approvals.

Technology: .NET framework 4.7, ASP.NET MvC, SQL Server 2016, Kendo UI, Web API, HTML, CSS, Javascript, JQuery, SSIS, SSRS

Job duties:

• Participated in requirement elicitation, seek clarification, impact analysis, effort & estimation with timeline.

• Involved in requirement gathering for most of the requirements, capture as product backlog and seek the sign-off from product owner.

• Involved in project estimation, resource planning, leading technical solution & tracking progress, customer management and project billing.

• Design Application based on identified architecture and support implementation of design by revolving complex technical issues faced by the project team during development.

• Involved in implementing the Web API to connect to the database from application and to execute select, insert, update, create, delete SQL queries

• Deployment of application in various cloud server and troubleshooting of issues and monitoring the logs

• Configuring the Application and Server monitor tools to track server performance and application performance to automatically notify to IT support teams.

• Extensively worked on Azure technologies and certified in Azure.

• Responsible for developing and delivering the application in ASP.NET MVC 4/5 (model-view- controller), Web APIs (secured APIs), HTML/CSS/JavaScript/JQuery as frontend and extend the same API business logic for mobile device.

• Implemented solution to encrypt and store sensitive information in database with help of certificate, asymmetric/symmetric keys and master keys using cryptography concepts in database.

• Maintained SQL server database and played a SQL Server Database Administration role.

• Worked on database design, database maintenance, database performance improvements, Index maintenance and various database tasks. Certified SQL Server Developer.

• Worked on DB performance improvement by query tuning, analysis of query execution plan, applying necessary indexes, monitoring Index fragmentation/defragmentation, monitoring deadlock and high CPU utilizations queries.

• Analyzing business requirement and process challenges from stakeholders/users and coming up with innovative solutions which helps them to improve the processes in their business.

• Requirement Analysis and performing sanity checks on the application.

• Defect reporting, tracking using Microsoft Visual Studio Team Services.

• Status Monitoring & Reporting.

• Coordinate with the different teams at onsite and offshore.

• Taking Corrective Actions and preventive measures to ensure On-Time Delivery with Highest Quality

5. Project Title: Web Admission System (WAS)

Job title: Technology Lead (Acting Technical Project Manager) & DBA Client: Leading airport lounge management

Start date: April 2015 End date: Jun 2018

Project Description: Web admission System for admission of airport lounge visitor. System handles all lounge user admission and also cashless admission such as contract with Bank, Airlines, and corporate clients. All bank transactions (dealing with cards) save in database with high security by implementing cryptographic concepts of database due to PCI DSS compliance. Every month billing records generated from isolated secured Environment to respective bank for billing purpose. Application handles bank, airline, plaza cards, coupon / corporate vouchers, Loyalty, void and reports functionalities.

Technology: C# ASP .Net 4/4.5 framework, MVC Architecture, LINQ / Entity Framework, SQL Server 2012/2014, cryptographic implementation in SQL server 2012, SOAP/REST secured web services, JavaScript, J Query, CSS/HTML, SSIS, SSRS, Executable batch job in asp.net, ActiveX Job duties:

• Business Requirements gathering and analysis from Stakeholders and PO.

• Analysing business requirement and process challenges from stakeholders/users and coming up with innovative solutions which helps them to improve the processes in their business. Single point of contact for entire project.

• Responsible for developing and delivering the Web admission system in ASP.NET MVC, Web APIs and extend the same business logic for mobile/kiosk device. Responsible for developing secured APIs for many clients such as Amex, Dragon Pass, cTrip etc.

• Responsible for providing solution to encrypt and store sensitive information in database with help of certificate, asymmetric/symmetric keys and master key using cryptography concepts.

• Responsible for database design, database maintenance, database performance improvements, Index maintenance and various database tasks, worked as SQL server DBA.

• Responsible for delivering and developing challenging implementation such as use of Roton (card swipe), Read card swipe data using ActiveX implementation, Boarding Pass scan.

• Subscribe and automate all SSRS business reports for each client in a most efficient way.

• Followed continuation delivery of every week release cycle and delivered each week without failure.

• Highly appreciated by customer in terms of quality of delivery, quick fixes of issues, part of performance initiative and provided valuable turn around. Also, setup TFS and development environment includes IIS, SSRS reporting portal and Database setup. 6. Project Name: Gaming Entertainment Management System (GEMS) Job title: Technology Lead Client : Leading Macau based Casino Start date: April 2014 End date: Mar 2015

Project Description: Gaming entertainment application is used in one of the leading casino based in Macau. A person comes to play in casino called patron. This application handles patrons account, registration, and loyalty module of patron and coupon/voucher redemption. Single point of contact for Loyalty module includes patron play activities, point calculation (very complex business logic to calculate), earn points, void and redemptions of points and reports. Technology: C# ASP .Net 4.0, SQL Server 2012, LINQ, Entity framework, SSRS, SSIS, HTML5 Job duties:

• Direct Customer interaction for requirement gathering and analysis.

• Involved in core development and implementation of complex business logic for point calculation.

• Responsible for database design, database maintenance, database performance improvements, Index maintenance and various database tasks, worked as SQL server DBA. Also involved in lot of DB related issue and improved the performance.

• Main role in go-live of this project due to lot of issues in UAT then lead the front for go live. 7. Project Name: Single Interface (SI)

Job title: Senior system engineer & Technology Analysts Client – Leading telecommunication provider

Start date: Jan 2011 End date: Mar 2014

Project Description: SI is a critical ASP. Net real time web application which handles the faults for UK based leading telecommunication provider. An engineer can work on any of the faults through this centralized web application. SI is capable of receiving faults data through various systems like CSS, CAMSS, NFMTH, GPMS, ExpedioIM, Flow, AIB, NEO, One Siebel etc., e-mails, call and eChat. SI provides features like Task Allocation, Jeopardy Management, SLA Management, and Business Rules Configuration for Routing and Prioritization, Association of jobs. Technology: Asp.Net 3.5 (C#), SQL server 2008, SSIS, SSRS,JavaScript, Jquery, CSS Job duties:

• Responsible for application development in ASP. Net (C#) language and SQL server as backend. Did code optimization in asp.net and SQL server.

• Involved in all performance improvement initiative and proactively handled many performances related escalations.

• 1 year of onsite experience in UK to handle SI application along with support of 2 new legacy applications SG, IVOR etc.

• Single point of contact for all applications support and development from client location, highly acclaimed by client.

• Direct Customer interaction for requirement gathering and analysis.

• Lead Designer for Single Interface, Design Authority for SI designs so that functionalities across Lobs would be reused.

• Identifying various design options and ensuring that the best option from performance/ implementation perspective is chosen which can also fit in project deadlines/delivery dates and meet customer/business need.

• Technical feasibility and impact analysis in terms of different ways of implementation, impact of each option on application, best option which would suit for new requirement/ new business.

• Extensively used ETL-SSIS for handling the multiple source system files, data extraction, transformation, cleansing, loading, task scheduling, error tracking and logging etc...

• Handling complex and challenging requirements that require changes on the complex modules. Having discussions with technical architects from 4-5 different platforms that SI interacts with. Understands the technical complexities involved in generating responses for cross platform communications.

• Participate in setting up TFS as Source Control mechanism for project.

• Proactively provide technical support (C#.net, implementation structure –classes/functions, DB schema structure) or design support (business requirement understanding) to development

/Testing/ASG team in resolving technical/implementation issues.

• Interact with Solution Designers, CE leads, BTO Portfolio Architect, Program Manager, Head of Business Improvement, Project Director and Design Authority, Platform Architect lead for business requirements and SI Architecture

• Show and Tell with Solution Designers, BT Operations teams, business leads, end users. Conducted training sessions for operations user community

• Responsible for actively participating in scope discussions with business. 8. Project Name: MAC (Make Account Clear)

Job title: Systems Engineer Client – Leading telecommunication provider Start date: Dec 2008 End date: Dec 2010

Project Description: MAC is a component of telecommunication provider in the service area under Billing & Payments Platform. The MAC (Make Accounts Clear) application is a business critical application which interfaces with the billing system to generate the verified & accurate charges and corrected invoices for customers. Developed the Real Time order processing business critical ASP.NET based Web-Application consists of TRC,AVC, SFI, Billing process Technology: C# .Net 3.5, SQL Server 2005, JavaScript, CSS, SSIS – DTS, Batch file Job duties:

• Coding, Testing, Review, Analysis, Deployment and Support.

• Developed a Code is easy to understand, maintain and enhance and bug free and maintain a coding standard as well.

• Involved in Type of Testing like regression testing, Unit Testing and Integration Testing and delivered quality product.

• Deploy the versioning of highly quality product on live.

• Given support to live application and find a root cause of any live issue and close the issue.

• Automated every report and eliminate the manual intervention. Personal Information

• Gender : Male

• Marital Status : Married

• Visa Details : H1B

Contact this candidate