Veera Reddy Akkili

· Architecture, Design, develop, implement, and support database solutions using Microsoft Azure Technology stack.

· Executed end-to-end Azure Cloud solutions by deploying, configuring, implementing, and

· maintaining services.

· Implementing Azure Logic Apps, Azure Functions, Azure Storage and Service Bus Queues for ERP

integration systems.

· Utilized ARM and Bicep templates for Azure service creation, ensuring seamless integration without altering existing infrastructure.

· Leveraged Azure Functions, Logic Apps, and Event Grid to construct scalable serverless

infrastructure, resulting in improved performance, cost efficiency, and flexibility across applications.

· Utilized Azure Service Bus as a messaging infrastructure to decouple applications and enable reliable communication and message-based integration patterns such as queues, topics, and subscriptions.

· Worked with containerization tools like Docker and orchestration systems like Kubernetes to

optimize application deployment in cloud environments.

· Demonstrated excellent troubleshooting skills in resolving complex technical issues and

implementing viable solutions.

· Configure SFTP server to get the files from storage account.

· Migrated On-premises Data to Cloud to Azure SQL Database, Azure Data warehouse, Cosmos DB, and Azure Data Lake using Azure Data Migration Assistant, Database Migration Service, Live Data Migrator (LDM), Azure Migrate, Azure Data Factory (ADF).

· Involved in building up the data pipeline using Azure Service like Data Factory to load the data from Legacy SQL server to Azure Data Base using Data Factories, API Gateway Services, SSIS Packages, Talend Jobs, and Python codes.

· Managed Azure Databricks cluster, including creation, configuration, and optimization for high concurrency.

· Oversaw the deployment and scheduling of Databricks jobs for data extraction, transformation, and loading from SQL Server to various destinations using Azure Data Factory.

· Used Azure Key vault as central repository for maintaining secrets and referenced the secrets in Azure Data Factory and also in Databricks notebooks.

· Created Pipelines in ADF using Datasets/Pipeline to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.

· Identifying and documenting the business concepts, for legacy projects, from reversed engineered OLTP Data Models

· Maintain enterprise level conceptual and logical data models along with the corresponding metadata. Update the existing Data Mart models with meta-data information using source-to-target mapping documents.

· Audited database(s) and suggested improvements in terms of normalizing or deformalizing table structures.

· Developed Database Migration Cookbook containing steps and procedures with end-to-end migration details.

· Proficient in identifying and tuning slow performing queries, suggesting indexes, partitioning tables;

· Performed Data Profiling, Data Cleansing on key data elements and business rules for Loan Care data. Performed reverse engineering to create a physical data model from database and SQL scripts.

Improved and streamlined ServiceLink Customer Relationship Management (CRM) application. Wrote User Stories, Elaborated User Stories and Acceptance Criteria; Reviewed user stories with teams Wrote extensive SQL queries for data validation, analysis and manipulation.

• Designed Data Architecture, designing Conceptual, logical and Physical data models and maintaining the data Dictionary as for the Standards. Involvement in the data quality tests and code reviews Worked on feasibility of data migration from On-Premise to Amazon Redshift.
• Prepared documents such as Project Scope, Vision, Success, Business Requirements, Functional Specification, Data Warehouse Process Flow (SQL queries) using MS Office (Word, Excel, Visio) and dashboards.
• Responsible for creation of Collaboration Diagrams, Activity Diagram, ER Diagrams, Project Flow Diagram in MSVisio.
• Based on Business Requirement document, reviewing and approving (with the goal of ensuring data quality, consistent use of data element names, data types, business definitions as well as domain / range values ) source-to-target mapping document, ETL mappings documents showing new/updated data structures for the Target ( EDW )
• Analysis of existing Data-warehouse Model, Data-mart Models, source application models, PL/SQL source codes , Source Data Analysis - for understanding the data objects to be modeled ( bottom-up approach )
• Developed star and snowflake schema models for OLAP data warehouse. Implemented SCD/Kimball methodology
• Created / maintained of EDW Model ( Dimensional Model ) based on re-engineering Project requirements
• Worked on different degrees of normalization and in designing Business Data Model (conceptual), Entity-Relationship logical data model (ER models) using ERwin to support business needs.
• Reconciled Business requirements, Process Model and Enterprise Logical Data Model (ELDM) and created CRUD Matrix. Defined futuristic Domain Models, Data Dictionaries and MDM
• Involved in design, development, implementation, and support for MDM solution. Data Governance activities -
• Validating metadata with Mortgage Industry Standard Models ( MISMO ) and CORE / Enterprise Data Glossary
• Obtaining approval from the Data Review Board for any new / enhancement to existing Data Models in terms of data modeling standards and requirement capture. Generate Data Model Quality Control Reports
• Perform data profiling and upload relevant data to a repository used by Data Stewards for data quality.
• Convert models to XML format and upload to Enterprise Meta-data Repository for sharing of meta-data across enterprise. Maintain model versions in ERWin Model-mart.

• Worked on Mule Soft Any Point API platform on designing and implementing Mule API. Experience with Mule administration, configuration, and tuning.
• Used MUnit for mocking and unit testing Mule flows.
• Implemented Advertisement Bidding engine using Tibco Business Events.

• Designed and implemented purge process that does the logical purge from TIBCO BE cache.
• Designed and implemented generic JMS serializer in TIBO BW and Java for use in logging and replay message module

• Automating the creation of purchase orders from requisitions for special orders and direct shipments.
• Middleware integration primarily between web Methods / IBM Mainframe and TANDEM/IBM.

• Designed Business rules for Navigation in TIBCO BE 4.x
• Worked with Tibco Business Events extensively for creating rulesets, rules, events, and channels.
• Implemented Web services components SOAP, WSDL, and UDDI to interact with external systems by using TIBCO BW as part of SOA.
• Responsible for EDI integration architecture using TIBCO Business Connect.