RAMYA KUPPALA

• Managing a multidisciplinary team of designers, developers, and engineers to plan, execute, and deliver agile projects, ensuring successful outcomes and alignment with business goals
• Managing 5 Azure project with 25 resources
• Connects with Business Stakeholder and gather requirements and implement Database objects and share work with in team
• Involved in Presales calls and shared capabilities of data w.r.t to Azure
• Review all team design and architecture and provided suggestion w.r.t to performance and best practices
• Helps team members in providing implementation solution.

Textile Industry

• Involved in Requirement Gathering to build datawarehouse system to textile domain
• Design ADF Pipelines and shared with team to be align across system
• Implemented data flows for all business transformation using flatter, look up, execute sql task etc
• Implemented multiple data validation at Ingestion and EDW layer using SQL stored Procedures
• Provided Solution to automate process for new Ref codes to be included in system instead of manual process
• Provided design solution and implemented mcr rule module in system
• Identified Issues in provided data model design for EDW and reporting layers and revamped complete data model to fix duplicate data issues and business gaps in data too
• Provided Power BI data model to align with Reporting needs
• Review code of team members and shared multiple suggestion to avoid manual process in system
• Suggestion and helped team in reducing multiple hit for OAR API with workaround of sending 1000 records at a time
• Tuned all reporting procedures and improved performance of it by 70%
• Helped team in providing performance tuning techniques to resolve performance issues.

Health Care Services System & DWH Cloud Migration

• Migrating Datawarehouse system from on prim to cloud
• Implemented transformation process using Data Bricks, python, SparkSQL
• Implemented a solution to merge new transaction DB data to DWH
• Identified data anomalies in new system and reported to client.

Financial System for Large Machinery

• Migration from on prim Datawarehouse (Oracle, DataStage) to cloud (Snowflake, Matillion)
• Developed Matillion transformation jobs for EBS, Xref and Offsystem modules similar to data stage
• Involved in implementing similar Orchestration jobs for all transformation jobs using python script
• Performed Data Validation and reported all consequences/issues with detail report
• Reviewed jobs implemented by team and suggested best practices
• Identified Unnecessary logic implemented in oracle and reported to client
• Tuned Oracle Queries and implemented tuned logic in Matillion
• Provided a solution to track Data differences between legacy and cloud system day by day
• Proactively took responsibility of fixing ABAT issues for better utilization of team.

Document storage System

• Requirement gathering and helping team to implement requirement
• Provided solution to send a report of data mismatch among three system SF, TR, GP every day using Dynamic SQL and SSIS
• Provided suggested to have a power bi dashboard for mismatch count among three system across six Categories
• Provided solution to sync data from Azure Salesforce to Datawarehouse using SQL and SSIS
• Automated package generation for data load of more than 50 tables using SSIS BIML
• Identified data anomalies in contract module and reported to client
• Implemented a process to push files from FTP/SFTP to High Radius using dell Boomi.

Vendor Management System

• Responsible to look over performance of Application SQL DB
• Have good knowledge on business domain
• Identified data anomalies and reported to business team
• Identified Long running DB objects using Monitoring tool SolarWinds and extended Events
• Tuned more than 100 long Running DB Objects to less than 3 sec
• Changed search list views to procedure for better performance
• Implement logic to change dynamically based on filter and sort applied on page using dynamic SQL
• Implemented pagination logic at DB level instead of application
• Responsible to review DB business functionality logic implement by dev teams
• Involved in design of Archive, Audit and purging process
• Automated process to include new tables into Archive process
• Provided Support in production deployment
• Involved/Implemented solution to migration new client Data to existing System
• Implemented Entity Access solution to another module i.e SOW
• Provided Design solution for Customer segmentation process and implemented it
• Hand on experience on DBA Task i.e Database backup, restore and HADR
• Implemented this task in dev and QA environments
• Hand on experience in Maintenance jobs in SQL i.e Index rebuild, Database Backup full/diff, Statistics update
• Implemented solution to consolidate all modules databases to single Database for azure migration readiness
• Identified and implement alternative solutions for unsupported features in Azure SQL
• Involved in migration of on prime to Azure SQL.