Harshita Neppalli

Technology leader with 10 + years of IT experience including oversight of infrastructure, application support and security services. Dedicated to customer satisfaction with focused delivery of technical solutions. Proven leader in directing operations, maintenance and support of complex systems. Data architect experience in various Industry verticals defining Strategy and building Data Architecture, Data warehouse, Data Lake, Business Intelligence, Big Data and modern Data pipelines. Led the transformation initiatives to provide best in class offerings to the customers on Cloud Adoption roadmap; Data Platform frameworks; Advanced Analytics; Artificial Intelligence solutions and Application Modernization solution grids using Microsoft Azure Cloud. Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system. Proficient in T-SQL programming on implementing Stored Procedures, Functions, Constraints, Joins, Keys, Indexes, Views, Triggers, Data Integrity. Have good command on Entity Relationship Diagram and Database Normalization. Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. Hands on experience in production/staging/test/development database administrative: Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication. Proven experience in modern data architecture patterns and practices, developing and delivering effective technology strategies, conceptual, logical, and physical architecture. Written T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers. Used Try catch block, Merge and Common table expressions in T-sql Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity. Strong experience in migrating other databases to Snowflake. Developed complex SQL queries using SnowSQL. Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc. Involved in Performance tuning and Query Optimization of Stored Procedures and queries using execution plan and profiler. Driven the Data Analytics consulting team to provide a road map to the client for Application Modernization solutions which included a multiyear initiative of migrating from traditional ETL to Hadoop based solutions. Clarity Data Model - Grand Central and Prelude - Epic 2020 certified user with experience identifying, extracting and transforming data from Clarity and worked with Clarity work bench reports. Extensive training in quantitative and qualitative research on care coordination, risk adjustment methodologies, and readmissions policy. Developed Tableau visualizations and dashboards using Tableau Desktop. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Experience in Analysis, Understanding, Development, and Validating and Implementation of Business Intelligence reports using Tool Power Bi. Developed the Dashboards using Growth rate calculations (YTD, MTD and YOY etc…) Worked on Row-level security (RLS)in Power Bi Worked on DAX functions in Power Bi Experienced in creating different visualizations using Bars, Lines, Pies, Maps, Graph, Bubble, Tree Map and Histogram. Designing, building and deploying, publishing data analysis reports/dashboards for large volumes of data. Developed Tableau workbooks from multiple data sources using Data Blending. Provided 24/7-production support for Tableau and SSRS users. Expertise in SQL Server DTS and SSIS package design, constructing, and deployment. Have good command on Entity Relationship Diagram and Database Normalization. Had experience in developing reports on SSRS on SQL Server (2005/2008 R2) and MS Successfully demonstrated experience driving solution review boards in evaluating design, code, data, security best practices to drive data product development, driving Architecture Review Board discussions to socialize and finalize emerging data architecture solutions and patterns. Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects. Insightful Information Develops creative business solutions, leveraging diverse methodologies and delivering engineering solutions for leading organizations. Highly adept in request for proposal development, technology needs assessments and staff training. Equipped with strong problem-solving abilities, willingness to learn, and excellent communication skills. Poised to contribute to team success and achieve positive results. Ready to tackle new challenges and advance organizational objectives with dedication and enthusiasm.