Yeshwanth Reddy

Responsibilities:

· Gathered data-related requirements from clients to ensure local and regional data needs were met, facilitating data-driven decision-making.

· Evaluated complex business requirements and performed data analysis to assess customer activities, identifying optimal data solutions and alternatives for process improvements.

· Prepared and reviewed Gap Analysis Documents (GAD), mapping data requirements to product functionalities and identifying necessary customizations to meet client specifications.

· Collaborated with UI/UX designers to develop wireframes and prototypes for UI enhancements, improving data visualization and user interaction with data tools.

· Extracted business requirements from end-users and created Business Requirement Documents (BRD), ensuring that data needs were accurately captured and translated into actionable insights.

· Performed testing during User Acceptance Testing (UAT) to ensure data integrity and provided approvals during production to ensure successful deployment of data solutions.

· Created Business Requirements, Functional Design, and Functional Specification Documents, ensuring all data-related requirements were clearly outlined for development teams.

· Analyzed and optimized SQL Server production databases, improving query performance and ensuring data accuracy for reporting and analytics.

· Wrote and optimized SQL scripts to extract and transform data into data sets for reporting purposes.

· Created and managed on-demand and ad-hoc reports using Microsoft Excel (pivot tables, charts, VLOOKUP, and conditional formatting).

· Constructed dashboard and ad-hoc reports in Excel and Tableau.

Environment: SQL Server, UI/UX, BRD, UAT, Business Analysis, Gap Analysis, Tableau, MS Excel, VLOOKUP, VM, SQL scripts.

Responsibilities:

· Worked with the data modeling team to create conceptual, logical and physical data models for the Regulatory Data Repository so that it accommodates accounting and reg-reporting requirements of several Systems of Records.

· Implemented metadata standards, data governance, master data management, ETL, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling.

· Performed Metadata & Data Dictionary Management, Data Profiling, Data Mapping, DDL & DML generation & usage.

· ETL Design & Implementation - Data Extraction, Transformation & Loading (using Informatica, SSIS, SQL & PL/SQL)

· Used Data warehousing for Data Profiling to examine the data available in an existing database and also created Data Mart.

· Designed and developed complex SQL stored procedures and SSIS packages for ETL processes to load the data warehouse.

· Analysis and Physical data module for ETL Mapping extensively used Informatica Power Center for loading the data from various sources involving Fact files and Oracle tables.

· Involve in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse, ETL, OLAP, Client/Server applications.

· Built various packages in SSIS to load the data coming from various input sources like excel, flat files.

· Experience with BI Reporting in Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Web Reporting.

· Performed testing for Medicare, Medicaid and X-Over claims for Medicaid Management Information System (MMIS)

· Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.

· Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing

Environment: Visual Studio. .NET, VB.NET, SQL Server, SSIS, SSRS, VSS, Crystal Reports, MS office, Visio, Windows 7.