Home

Vamsi Krishna - Business Analyst

[email protected]

Location: Rocky Hill, Connecticut, USA

Relocation: Yes

Visa: GC

Resume file: Krishna K BA_1768226518897.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Around 9 years of experience as a Business & Data Analyst in Healthcare Industry with proven expertise in EMR data migration, integration of EDI transactions and ensuring compliance with healthcare regulations. Extensively worked on gathering, defining, and analyzing requirements, creating documentation, communicating with the business team, and identifying areas for improvement and change management. Proficient in utilizing ICD-9, ICD-10, LOINC, SNOMED, HL7, CMS, Health Assessment Systems, and HL7 Standards. Well-versed in HIPAA, HITECH, HIE, and FHIR regulations. Collaborated cross-functionally to customize EMR workflows, tailoring solutions to meet departmental needs while optimizing system functionality and user experience. Analyzed Medicare and Medicaid reimbursement practices and made recommendations, which helped healthcare organizations operate more effectively and spend less money. Worked on Claims insurance experience with emphasis on personal lines and business owner s lines. Experienced working on EDI Transactions like EDI 835(Medical Claims Payment), EDI 837(Medical Claims Submission) and EDI 270(Eligibility Inquiry), EDI data mapping and migration. Maintained knowledge of diagnostic coding conventions such as ICD-9-CM and ICD-10-CM. Worked on Cerner applications for Citrix Workspace and Relay to process claims and charge for medical services under CMS (1500) and uniform billing (UB04). Involved in all phases of the Software Development Life Cycle (SDLC)and created use case diagrams, process flow diagrams, and AS-IS diagrams. Experience in gathering functional and non-functional requirements and preparing Business Requirements Documents (BRDs). Experienced in multiple SDLC models, including Waterfall and Agile methodologies, and created user stories using the JIRA tool. Proven ability to write detailed user stories and use cases that capture all necessary requirements and provide a clear vision for the development team. Developing test cases and conducting user acceptance testing to validate that the requirements are being met. Experienced in preparing, traceability matrix and technical documentation that meet the requirements of the stakeholders. Experienced in collaborating with the business team and development teams and acting as a bridge. Extensive experience in preparing Data Dictionaries, technical documentation, and source-to-target data mapping document. Experienced in conducting JAD sessions and interviews with the business team and tech team. Extensive Expertise in transforming business requirements into technical specifications to be used by the technical team. Developed data mapping strategies to identify and define relationships between data elements in different EHR systems, ensuring data consistency and interoperability. Designed and executed data migration plans, coordinating with technical teams to extract, transform, and load data while maintaining data integrity and minimizing downtime. Experienced working with Data Bricks, Informatica, SSIS for data transformation, extraction, and in-depth analysis. Optimized ETL workflows and performance by implementing Teradata specific techniques, such as partitioning, indexing, and query optimization, resulting in improved data processing speed and efficiency. Created queries, executed reports, conducted extensive manipulation, and analyzed large-scale datasets employing a diverse set of tools, including SQL Server, MySQL, SQL Server Integration Services (SSIS), Oracle SQL, Access, Excel, Tableau, and Power BI. Developed complex SQL queries, stored procedures, and triggers to automate routine data tasks, enhancing data accuracy and efficiency across the organization. Collaborated with cross-functional teams to gather requirements, design data models, and ensure seamless integration of new data systems with existing healthcare platforms. Used complex SQL queries to create UMT tables, aggregate tables and create Trend reports, Pivot, and List reports. Created and maintained reports using SQL Server Reporting Services (SSRS) to improve data visibility. Proficient in designing star and snowflake schemas for effective data modeling, and proficiently utilized the JIRA tool to formulate user stories. Worked extensively on DML, DDL, and DCL statements, and worked on complex SQL queries such as joins (inner joins, left outer joins, right outer joins, and self joins). Worked with T-SQL, Python, XML, JSON scripting to scrape data from multiple sources. Worked with Azure data bricks to speed up the preparation of high-quality data. Defined and tracked key performance indicators (KPIs) for RPM initiatives, developing interactive dashboards and reports in Power BI and Tableau to monitor patient health metrics and program effectiveness. Designed and executed ETL processes for healthcare data migration across Cloud and Traditional databases using AWS, GCP, and Azure. Keywords: business intelligence