Ashok Ghattamaneni

Current Project: HEMI, Client: Optum

• Build a cloud-based content and integration platform that unlocks data for consuming applications on digital and marketing channels adhering to the organization standards of security, availability, reliability, and performance.
• Stream changes in data from legacy systems real time to the cloud
• Transform the streaming data into an enriched canonical format for consistency and standardization across systems.
• Group Micro services into functional domains that share nothing to support loose coupling between domains. Construct our processes in a way what leverages the advantages if the cloud including manages services, IaaS, auto scaling, multi regions etc.
• United AI Studio is a platform that enables you to easily connect to datasets and build, deploy, manage, and scale machine learning (ML) models responsibly. United AI Studio provides federated access to existing data sources and enables users to quickly launch tools like Azure Machine Learning (Azure ML) or Azure Databricks to build new ML models and analytics.

Professional Responsibilities highlights:

• Technology Evaluation and Standardization- Currently spearheading the end-to-end Database, Integrations, Analytics, Cloud and AI solution selection process, rigorously evaluating and piloting cutting-edge technologies at Optum. Driving the endorsement of selected solutions as standard platforms by the Architecture board.
• Cloud Services and Platform Implementations - Proficiently orchestrated the implementation of Azure services adhering to the Well-Architected Framework, including AKS, Cosmos, Azure Search, Redis, AzureSQL, Data lake, Data Bricks, APIM, AI, Log Analytics, Machine learning . Additionally, successfully deployed and secured Confluent Kafka, Snowflake, Mongo, Oracle and ensuring resilient architecture and fortified security measures
• Data Platforms Architecture and Administration - Orchestrated the installation, upgrading, and administration of a 400 TB Azure Cosmos, Azure SQL, and Azure search, and Data lakes to scale out cluster, devising innovative solutions to maximize efficiency, performance and saving significant infra costs.
• Efficient Data Management and Optimization - Implemented data ingestion strategies into Snowflake from data lakes using ADF, pipelines, and tasks.
• Build the Innovative Solutions and Cost Savings
• Automation and Process Improvements - Automated DB code promotions for Oracle databases using GIT and Jenkins, streamlining development processes and ensuring version control.
• Strategic Planning and Operational Oversight - Developed strategic plans, road maps, policies, and guided stakeholders to achieve organizational growth objectives, ensuring efficient resource allocation and budget management.
• Analytical Insights and Improvement Initiatives - Analyzed operational data to identify trends and opportunities for improvement, providing valuable insights for strategic decision-making.
• Business Consulting and Solution Development - Provided consultative expertise across diverse business units, developing tailored solutions to meet varied business needs. Contributed to building specialized capabilities beneficial to multiple business sectors within the enterprise.
• Leadership and Team Guidance - Provide technical guidance to staff, overseeing complex operational issues and facilitating skill development, ensuring operational excellence

• Technology: SQL Server, .net , MSBI, Tableau
• ECAC is mainly used by Hospitals in order to enhance the medical coding performance
• Manage and upgrade the SQL Server 2008 to SQL 2012 databases.
• Build the SSIS packages and SSAS Analytical Data models .
• Developed Logical and physical data models
• SqlServer, Oracle databases performance tuning and period analysis of reports for very large databases.
• Database propagation, capacity planning and consultation with developers on technical issues, database design, and systems analysis.
• Provided expertise related to DB performance, HA, scalability, Database security and diagnostic maintenance of Sql Server and Oracle.

• Technology: SQLServer, .net, Oracle,MySql
• Primary as a database developer and DBA including design and development, regular maintenance, updating the schemas, Stored procedures,..etc, Replication, Log Shipping, Performance Tuning and Alerts.
• Developed scripts and processes for data integration and maintenance.
• Identified issues within databases, performed troubleshooting and implemented effective solutions.