Home

Ajay bhat - Data Analayst

[email protected]

Location: Sacramento, California, USA

Relocation:

Visa:

PROFESSIONAL SUMMARY Ajay is accomplished and results-driven technology leader with 20+ years of experience. He has built expertise in leading presales teams, solutioning, leading delivery units, designing roadmaps for Cloud migrations, infrastructure/platform engineering, architecture, strategy, data analytics workloads, product management, and operations. He has experience leading Architecture, infrastructure, and cloud engineering teams. He is adept in writing various strategic plans including Cloud migration strategy, Cloud migration pattern/playbook, Data Governance Plans, Enterprise Data Management Strategies, Master Data Management Plans, Data Conversion Plans, Risk Management Plans, and Configuration Management Plans. Ajay has strong people leadership skills with a proven ability to develop highly engaged teams. Ajay enjoys identifying strengths and coaching team members to meet their full potential through recognition and feedback. Ajay has also successfully led various pre-sales teams in building solutions for various healthcare, finance, banking, telecom, and public sector companies. Expertise Areas Cloud migration, Technology Architecture, business capabilities. Engineering business services and reliable global operations Enhancing and leading Enterprise data management capabilities Projects, Programs, Agile Methodology for consistent delivery Organization readiness for enhancing customer experience Digital Transformation, consistent Innovations Leading teams both onshore and offshore Data Governance, Master Data Management Career insights Capgemini- July 2021 till date Azure COE NA Practice Leader Developed cloud strategy and lead cloud adoption programs. Built a High Availability and disaster Recovery strategy documents. Lead design and implementation of enterprise applications building platforms and frameworks to create consistent, verifiable, and automatic management of applications and infrastructure between non-production and production environments. Built Data migration plans, data management strategy, migration cutover plans, data cleansing plans, data compliance, data security and auditing plans. Wrote various patterns for migrating on-premises workload to Azure including SQL Server to Azure SQL, Oracle to PostgreSQL for Azure, MySQL (on premises) to Azure Helped with designing and building Landing Zone in Azure Helped with discovery of on-premises workload using Azure Migrate and DMA and building a plan for migrating Applications to Cloud. Assessed applications, software and hardware and other environments for cloud readiness. Oversaw cloud governance and helped with risk mitigation. Work with management to budget, estimate cost, and scale environment. Design, configure, implement and document Virtualized, Cloud and On-premise infrastructure technologies. Helped various clients in application modernization and app migration to Azure projects. Built accelerators and cloud migration frameworks. Helped clients with cloud migration assessment, discovery recovery and cloud adoption POV. Conducted various infrastructure compliance and vulnerability assessments. Designed data network systems and applications. Applied troubleshooting skills to resolve network and application issues. Helped in designing Cloud Connectivity options (VPN, Cloud Connect, Public Ingress, Network Security Groups, Network Virtual Appliances, etc.) Configured Azure Event Hub, Event Grid, Stream Analytics, logic/function apps, Load Balancer, Azure SQL, Synapse, Azure Data Factory, Data Lake, Storage accounts, NSG s, Monitoring services Helped in Application Development, including Web Services, Agile, Continuous Improvement/Continuous Deployment, etc. Performed cloud cost forecasting, current state architecture assessments and optimization strategy. Built PII and FTI data security strategy and compliance plans. Build SIEM solutions (AT&T SIEM) for monitoring access to FTI and PII data. Helped with SOC 2 Type 2 compliance, IRS audits(Pub 1075) and various compliance requirements. Helped with monitoring and logging requirements along with methodologies to prevent fraud and fishing, critical alerting mechanism using SOAR by implementing multiple SIEM Solutions (AT&T, Azure Sentinel) Helped various clients with Data platform modernization, app modernization, on-premises to cloud migration. Leading on-shore and off-shore teams, managing Sprints, Sprint planning, Azure DevOps, Building ARM templates for IAC Extensively worked and leveraged Azure DevOps. Experience with setting up and managing CI/CD pipelines and build tools such as Maven, Gradle, and SonarQube. Helped in Codifying software development life cycle (build, deploy, test, refactor, release with no downtime) to enable high-quality release in all environments. Helped in providing on demand ML/AI infrastructure. Helped in Developing reusable tools, frameworks, processes, and automation around build/deploy/test workflows that helped engineers set up, implement, and deliver their services as quickly and easily as possible. Helped in Architecting a DevOps infrastructure from the ground up with a strong Kubernetes and Kafka emphasis. Strong understanding of software development methodologies and practices. Ability to write scripts using shell, Python, or other scripting languages. Fulfilling the roles of Domain Architect, Solution Architect, Senior Technical Manager and Technical leader. Avanade Inc. Oct 2019 to July 2021-Avanade is owned by Microsoft and Accenture. Roles: Cloud Solutions Architect, Delivery lead and Data and AI Senior Manager Solution Architect-certified SISA (System Implementation and Solution Architect). Among selected few in Accenture and Avanade to review the Data & AI, cloud migration deals. Leading sales motions, deals, RFP and RFI s Defining Solution plan and scope, accessing capabilities and constraints, defining solution blueprint, defining delivery strategy, planning, and estimating solution. Performing CDP (client data protection) risk assessment. Defining and building solution contingency. Reviewing the deals with QA Director. Planning and leading customer workshops Presenting and participating in weekly AMBG (Accenture Microsoft Business Group) leadership presales/solutioning calls. Adding new accounts and increasing client footprints. Using data to evaluate progress at each stage of growth. Planning and building go to market accelerators and frameworks. Leading multiple major on-premises to cloud migration projects Build a practitioner level expertise in Cloud Technology core areas including general contracting process and artifacts, Security, Data Privacy and Sovereignty, Compliance, Data Centre Strategy, and Operations, Networking, Integration, Identity and Access Management, Operational Processes, and Patching and Updates, competitive positioning. Lead and participated in strategizing datacenter migrations to Cloud. Planned and recommended the best practices for cloud and hybrid architectures. Planned and recommended the strategy for sunsetting applications. Planned and recommended the strategy for retiring and decommissioning on-premises datacenters. Wrote and peer-reviewed various patterns for migrating on-premises applications to Cloud. Wrote and peer-reviewed cloud migration play books, helping teams to keep up with the velocity of migrating Applications to cloud. Regularly mentored and provided guidance to data engineers and data scientists regarding the cloud best practices and solutioning. Helped in putting together various training programs for upskilling team members. Lead the strategy and planning for: Infrastructure and platform Architecture, Managed Services Private/Public Cloud Engineering & Operations/DevOps Data Engineering & Analytics Capacity planning Tools & Automation Engineering Application modernization-CI/CD pipelines, Microservices, API management. Service/Change Management Program management Built and nurtured positive working relationships with clients and exceeded client expectations. Participated actively in decision making at various engagement levels. Created and delivered various effective presentations and communicated the project and deliverable progress to key stakeholders on a regular basis. Deep insight into HIPPA, GDPR and CCPA regulation requirements and documenting policies and procedures. TC (Talent Community) lead for Data and AI Lead and mentor team of analysts, data engineers and data scientists Managed daily scrum calls with the team and set up DevOps tasks for each sprint. Participated in employee quarterly reviews and helped the advisee s in choosing the right career path Regularly interviewed new candidates for various open roles. Worked with cross-functionally team members to support and drive a collaborative team environment. Building and leading high-performance teams. Building synergy across teams, removing obstacles, and facilitating growth. Various leadership roles from May 2012 till Oct 2019-worked for major public sector clients (California Department of Conservation, California Department of Justice, California Department of transportation, California Secretary of State) through leading consulting companies like Accenture, Deloitte, CGI, KAI Partners Roles: Solutions Architect, Delivery lead, Data and AI Senior Manager, Enterprise Data Architect Presales/Solutions Architect- Solutioned deals with many healthcare, public sector, and commercial clients. Built POC/POV for various clients Responded to various RFPs, RFIs Performed capability reviews, Risk Assessment, solution contingency reviews and pricing estimate Resource planning and project cost estimates. Building trustful relationships with clients. Delivery Lead-Lead many Data modernizations, Advanced Data Analytics, Data migration, Data warehousing projects. Build strategy for data migration from on-premises to Azure Cloud. Wrote patterns for data migrations to cloud. Provided expert-level consultation for the design and development of enterprise-wide ETL architecture. Implemented the ETL strategy and defined ETL standards. Participated in the global definition of information architecture principles, policies, and the application of industry best practices. Performed vendor evaluations and recommended implementation of Information Management tools. Provided senior-level guidance to all aspects of the ETL solution delivery cycle. Actively led various on-site and off-site ETL teams and wrote numerous ETL specification documents. Wrote and peer-reviewed various project deliverables including Deliverable Expectation Documents (DEDs), Data Conversion Plan and Data Conversion Test Plan. Extensively involved in business interviews, gathering ETL requirements, documenting source to target mapping. Architected ETL related process s including harvesting business rules, automated transformation, data validation, and data cleanup. Lead the creation of the Data Governance Council, its vision, strategies, and direction. Actively involved in the creation of data governance policies and standards. Assessed and recommended Data Quality Framework, which included an end-to-end process to ensure the quality and suitability of data for its intended purpose. Oversaw the development of a roadmap for the data platforms, client delivery, and information systems integration. Developed an effective, coherent, reliable, and phased enterprise data governance plan to help the business grow and change. Socialized the value of the Data Governance program including benefits for stakeholders; rules for engagement; and the enforcement of data policies and standards with operational procedures and governed solutions Actively involved in various aspects of Data Governance, Data Stewardships, Enterprise Data Policies, Information Security, Risk Management, Metadata Management, and Master Data Management. Designed a data security process to enable overseas development centers to use data for application build and testing. Created a security policy for data across different environments. Always maintained data integrity and security. Implemented flexible deployment models include monitoring and blocking real-time security alerts. Build expertise in Data Modeling and various Dimensional modeling techniques. Implemented measures to block SQL injection. Mapped and identified different environments to be used for development (in house and overseas), build and deploy, application testing, interface testing and production-like environments. Identified data elements for security, personally identifiable information (PII), and established security hierarchy. Implemented data encryption, data obfuscation, FGAC controls techniques. Built strategies for data reuse, migration, or retirement. Senior Manager, Advance Analytics- Lead data migration, App modernization, Data Governance, Master Data Management for teams on multiple projects. Proactively led the vision for BI and Data Warehousing across a product vertical. Defined and executed a plan to achieve the vision. Defined the processes needed to achieve operational excellence in all areas, including project management and system reliability. Built a high-quality BI and Data Warehousing team and designed the team to scale. Built cross-functional relationships with Data Scientists, Product Managers, and Software Engineers to understand data needs and deliver on those needs. Led the design, building, and launching of new data models and data pipelines in production. Managed resources at onsite and offshore locations, scheduling their tasks, monitoring, and reviewing tasks for completion. Led data quality across the product vertical and related business areas. Managed the delivery of high impact dashboards and data visualizations. Defined and managed SLA s for all data sets and processes running in production. Created, managed, and tracked project activities including project schedules, detailed project plans, project scope statements, cost estimates, resource plans, risk and issues logs, and status reports. Tools: Microsoft Azure, Azure Kubernetes Service, Azure Data Factory, Databricks, Spark, PostgreSQL, MySQL, Cosmos DB, MongoDB, Synapse Analytics, Azure Data Factory, Databricks, Scala, Python, Oracle 12c/11g/10g/9i/8i/8/7.3, SQL Server 2016/2014/2010/2008/2000, T-SQL and DTS, MS Access, DB2, SQL*LOADER, Informatica PowerCenter 8.6/8.1/9.1,ODI 11g, DMExpress, Pervasive Data Integrator, Pentaho DOS, MVS, UNIX (Sun Solaris 8, 7, SCO UNIX, HP-UX 11i, IBM AIX 5L v5.2, Linux), Windows platforms, Oracle Exadata, OBIEE 11g, ODI, BI Publisher, DAC, MicroStrategy, Cognos, Crystal Reports, SAP Business Objects, SSRS, SSAS, Power BI, Tableau, Erwin7, SQL Data Modeler, TOAD (advanced), Oracle Access Management, Tivoli, Oracle Enterprise Manager, SQL White Paper and SQL Black paper, Optim 7.3.1, Oracle Identity Manager (Oracle Fusion Middleware 11g) Certifications Azure Solutions Architect Expert AZ-303: Microsoft Azure Architect Technologies AZ-304: Microsoft Azure Architect Design Microsoft Certified-Azure Data Engineer Associate DP-201: Designing an Azure Data Solution DP-200: Implementing an Azure Data Solution AZ-104: Microsoft Azure Administrator AZ-400 DevOps Engineer Expert AWS Certified Cloud Practitioner DP-900: Microsoft Azure Data Fundamentals AZ-900: Microsoft Azure Fundamentals (PMP) Project Management Professional from Project Management Institute (PMI) Certified in SAS9 Base Programmer Certified ScrumMaster (CSM) Total Quality Management (TQM) certified in Quality System Implementation. Oracle Certified Database Application Developer Oracle Certified in Oracle Web Deployment Brain Bench Certified Java Programmer Certified Public Speaker from Toastmasters International Technology Entrepreneurship from Stanford University (2012) Education MBA (BNT- Business Intelligence) CU Denver Business School (May 2014) B.S. (Mechanical Engineering) from NIT Kurukshetra, India (June 1996) Career insights-prior to last 10 years Client Name Location Project Role Begin Date End Date CalPERS Sacramento, CA myCalPERS and multiple projects ETL Architect, Data Architect, Data Warehouse/ BI Lead, Senior Manager. Mar 2008 May 2012 California DIR Oakland, CA EAMS DW/BI Architect, Senior Manager Aug 2007 Apr 2008 State of Michigan Lansing, MI MiCSES Data-ETL Architect, Manager Dec 2005 Sep 2007 California DDS Sacramento, CA CADDIS Data-ETL Architect July 2004 Dec 2005 Zeeb & Company Denver, CO Data Analysis Oracle DBA/ Data Analyst June 2002 July 2004 Syscommes Inc Denver, CO BPR, Process Improvement Feb 2001 June 2002 Maruti Udyog Ltd. India BPR, ERP implementation Dec 1999 Jan 2001 Jindal Strips Ltd India multiple Java/ Web developer June 1999 Dec 1999 Minda Industries Ltd. India BPR, ERP implementation Senior Associate Oct 1998 June 1999 Path Infotech Ltd India Oracle Web Applications development Lead Developer Aug 1997 Oct 1998 GKN India India BPR, Process Improvement Senior Engineer June 1996 Aug 1997 Keywords: continuous integration continuous deployment quality analyst artificial intelligence machine learning user experience business intelligence database golang hewlett packard microsoft Arizona California Colorado Michigan