Satya Sree Email & Phone Number

Austin, Texas, United States

• Designed and implemented a high-performance data warehouse solution, enabling real-time data analysis and reporting for business intelligence initiatives.• Developed and maintained complex stored procedures, triggers, and ETL processes to support mission-critical applications and data integration requirements.• Optimized database performance by analyzing query plans, indexing strategies, and implementing caching mechanisms, resulting in a 30% improvement in response times.• Implemented robust database security measures, including role-based access controls, data encryption, and auditing, ensuring compliance with industry regulations.• Collaborated with cross-functional teams to gather requirements, design data models, and develop database solutions aligned with business objectives.• Conducted database performance tuning, capacity planning, and troubleshooting activities to ensure optimal system availability and scalability.• Implementing various Power BI visualizations for dashboard and ad-hoc reporting solutions, connecting to diverse data sources and databases.• Led efforts to connect Power BI with Snowflake and Azure data sources, extracting, transforming, and loading data into Power BI while ensuring understanding of data structures and schemas.• Designed, developed, deployed, and processed Tabular Models using Azure Analysis Service and MS Excel, managing data for less than one million journal entries.• Developing SQL queries to validate data integrity, including checks for duplicates, null values, and truncated data, ensuring data quality and accuracy for reporting purposes

India

• Assisted in the development of SQL databases, writing, and optimizing queries, stored procedures, and triggers to support various business applications.• Performed routine database maintenance tasks, including backups, restores, and performance monitoring, ensuring data integrity and availability.• Supported the development and execution of ETL processes to integrate data from multiple sources into the centralized database system.• Contributed to physical and logical data modeling efforts, assisting in the design and normalization of database structures.• Monitored database performance using SQL Server tools, identifying and addressing issues to maintain optimal operation.• Provided support to end-users and developers, assisting with database-related queries and troubleshooting issues to ensure smooth operation of applications.• Assisted in implementing security measures to protect data, including user access controls and encryption techniques.• Automated data cleansing and formatting to check data quality and integrity by creating MS Excel Macros.Analyzing reporting requirements and developing various Tableau Dashboards, using trend lines and reference lines.• Created no of views, calculated tables, calculated columns, and measures.• Used advanced Excel and Google Sheets formulas to analyze the pipeline of insurance accounts which resulted in an increase in monthly closed write-offs.• Developed weekly AR (Account Receivables, denials) Claims using Excel (Pivot, VLOOKUP's, Macros) to assign appropriate teams.• Worked on exporting the daily tracking reports from the team members to understand the denial reasons from the payer and consolidated it to the denial reporting tool using Excel.• Worked on Enhanced data visualization in SSRS reports by utilizing components like action filters, quick filters, groups, bins, and hierarchies for improved clarity and insight.