| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateName: Hemanth TEmail: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLEProfessional SummaryAround 9 Years of Experience as an Informatica IICS Cloud Data Integration Analyst Demonstrated expertise in identifying trends, patterns, and insights to optimize healthcare delivery, enhance patient outcomes, and streamline operational processes.Expert in designing and optimizing data models within the Informatica MDM SaaS environment, ensuring scalable and high-performance architecture for large data sets, specifically tailored for Medicare Part A billing and EMR system integration.Extensively worked on the Metric stream applications using the Manual method based, Data Analysis Master Test Plan (MTP) and ALM on the companys requirements data mapping.Skilled in configuring and managing Informatica MDM Hub solutions, including match paths, match columns, and validation rules, to maintain data accuracy and integrity across various healthcare applications.Leveraged Informaticas Customer 360, Supplier 360, and Product 360 UIs within the IDMC platform to manage and centralize customer, supplier, and product data for Medicare Part A billing.Demonstrated ability to develop and execute data validation checks and quality controls within Informatica MDM to ensure regulatory compliance and data precision in healthcare data management.Strong background in utilizing Informatica Intelligent Data Management Cloud (IDMC) and Customer 360 for comprehensive data integration and management, aligning with business needs and regulatory requirements.Expertise in leveraging Cloud Data Quality (CDQ) tools and methodologies to drive quality assurance initiatives, with a proven track record of implementing robust QA automation frameworks.Extensive experience in managing Informatica Cloud Data Quality (CDQ) projects, collaborating with cross-functional teams to establish best practices, and driving continuous improvement in data quality processes.Skilled in utilizing Informatica Data Quality (IDQ) for data profiling, cleansing, and validation, combined with QA automation experience, to deliver high-quality solutions that meet business objectives and regulatory requirements.Optimized Informatica workflows and mappings to improve data processing performance, scalability, and efficiency, thereby enhancing overall data quality and system performance.Demonstrated mastery in the Informatica tool suite, including Informatica Data Quality (IDQ), PowerCenter, and Master Data Management (MDM), leveraging them to streamline data quality processes and enhance organizational data integrity.Successfully implemented ANSI X12 and HL7 standards for CPT transactions, optimizing healthcare claim submissions and ensuring compliance, demonstrating expertise in data migration and integrity maintenanceManaged data quality using GCP tools like Big Query and Dataflow, ensuring accuracy and compliance. Implemented data profiling and cleansing to maintain high data integrity.Integrated Informatica Data Quality (IDQ) with GCP services to automate data quality workflows. Developed and executed tests to improve data integration and transformation.Created detailed reports and interactive dashboards using Big Query and Data Studio. Delivered actionable insights to support data-driven decision-making and process improvements.Expertly integrated CPT and HCPCS codes into billing systems, ensuring precision in coding and reimbursement processes, while collaborating with coding specialists to maintain compliance with industry standards and regulations.Proficient in utilizing Informatica tools to ensure the quality, accuracy, and integrity of data across various systems and platforms.Collaborated closely with QA teams to identify and rectify data mapping discrepancies, ensuring data integrity and compliance throughout integration processes.Designed, monitored, and maintained QA reports, KPIs, and quality trends for internal data systems, providing actionable insights to stakeholders.Executed and automated test cases, proficiently tracking bugs and driving continuous improvement in data quality and system performance.Implemented ad-hoc analysis techniques using SQL queries and Power BI to swiftly address stakeholder inquiries, refining ICD code mappings for enhanced project outcomes and informed decision-making.Leveraged SQL queries for exploratory data analysis and report generation, supporting informed decision-making processes across various projects.Shared Power BI reports and dashboards with stakeholders through the Power BI Service, enabling collaborative data analysis and decision-making.Conducted data modeling tasks in Tableau Desktop to establish data relationships and hierarchies, facilitating dimensional analysis for comprehensive insights.Fine-tuned Tableau dashboards and worksheets to optimize performance, minimizing data load and leveraging aggregation techniques for enhanced efficiency.SkillsAnalysis tools: SQL, SAS, Python, Tableau Desktop, MS-Excel, SQL Server, Power BI, Spreadsheets, SAS, MySQL, Visio, R studio, Oracle SQL, Informatica, SSIS, SSRS and SAAS, QlikViewLanguages: SQL, R, SAS, Oracle SQL, XMLTesting Tools: Manual U Automated Testing ToolDatabase: Oracle, MS Access, SQL Server, MySQLComputer Skills: Data visualization, Data cleaning, Data Mining, Data Warehouse, Microsoft Office, Microsoft Teams, problem-solving, and analytical abilitiesHealth care Skills: EHR, EMR, SNOMED CT, HIPAA, HL7, FHIR, ICD 10, Medicare, MedicaidExperiencesState of Pennsylvania Sept 2021 - PresentInformatica IICS Cloud Data Integration AnalystResponsibilitiesConducted in-depth analysis of billing data from EMR systems, detecting revenue discrepancies and reimbursement trends, including Medicare Part A billing, ensuring compliance with HIPAA regulations and leveraging Git for version control.Analyzed and transformed data from various ETL tools, consolidating it into Golden Records using Informatica MDM.Integrated and automated data blending from diverse sources including CSV, MS Excel, and SAP DB, with default primary key assignment in MDM.Designed and optimized data models within the Informatica MDM SaaS environment, ensuring scalable and high-performance architecture for large data sets.Designed and optimized Informatica MDM Hub solutions, creating mappings, trust rules, and validation rules for accurate billing data integration.Configured match paths, match columns, and match rules in Informatica MDM, ensuring precise data matching and integrity between EMR and billing systems.Gather and analyses the requirements, design, develop, implement automated testing and integrate the test scenarios manual testing procedures per the guidelines and schedules stated in the Software Development Lifecycle (SDLC) plan created for each project MS SQL ETL and databases.Revamped critical components such as Base Objects tables, Match & Merge rules, Survivorship logic, Trust validation protocols, user roles, and standardization rules to enhance system performance for Medicare Part A billing.Post-modernization configured additional elements required within the MDM SaaS platform to ensure comprehensive system optimization.Implemented REST APIs with Postman for managing records, including creation, updates, and deletions, ensuring effective data handling.Designed and implemented MDM solutions using Informatica, focused on integrating Medicare Part A billing data from EMR systems to ensure seamless data flow and compliance.Configured and managed match rules and validation rules in Informatica MDM to ensure accurate and reliable billing data processing, adhering to Medicare Part A standards.Implemented Informatica Data Quality controls specifically for Medicare Part A billing, ensuring that all transactions met the required industry and regulatory standards.Led the integration of clinical and billing data within the MDM framework, facilitating accurate reimbursement processing and enhancing the overall efficiency of Medicare Part A billing.Utilized Customer 360 for data management, including data creation, merging, and file imports to facilitate comprehensive data integration.Leveraged Reference 360 for creating reference objects like Gender, Country, and Category, enhancing data consistency across systems.Led the integration initiatives utilizing Informatica to facilitate smooth data transfer and synchronization between EMR systems and billing software, enhancing project efficiency and ensuring compliance with HIPAA standards.Utilized Informatica's robust data migration capabilities to guide cross-functional teams through the waterfall development lifecycle, ensuring milestones achievement, stakeholder communication, and adherence to HIPAA guidelines for seamless EMR and billing integration.Automated data analysis using Python scripts, detecting revenue discrepancies and trends in EMR billing data while ensuring HIPAA compliance.Automated data analysis using Python scripts, enhancing the detection of discrepancies and trends in EMR billing data.Integrated Python into data migration projects, optimizing processes and maintaining transparent data lineage for billing synchronization.Combined advanced SQL querying with Python scripting to optimize database performance and uncover insights in billing data analysis, maintaining HIPAA compliance.Conducted training sessions on data migration methodologies and best practices, facilitating knowledge transfer among team members and stakeholders, and ensuring compliance with HIPAA regulations.Identified and mitigated risks associated with data lineage, ensuring consistent data integrity during migration initiatives, and maintaining compliance with HIPAA regulations.Demonstrated advanced proficiency in SQL programming across various relational database management systems, enabling effective data manipulation and querying, while adhering to HIPAA guidelines.Utilized Tableau for in-depth analysis of EMR and billing data, identifying revenue optimization opportunities and discrepancies, and ensuring compliance with HIPAA regulations.Implemented data validation checks within Tableau dashboards to maintain accuracy and consistency across EMR and billing platforms, while adhering to HIPAA guidelines.United Health Care May 2018 Aug 2021Informatica IICS Cloud Data Integration AnalystResponsibilities:Orchestrated mapping requirements alignment with project objectives, leveraging Microsoft Azure Health Data Platform. Engaged in Scrum meetings to ensure progress alignment and conducted root cause analysis for seamless integration.Designed and developed robust data models within a SaaS environment, optimizing data architecture for seamless integration between ELN systems and laboratory equipment, ensuring scalability and enhanced performance.Established and implemented advanced data quality rules, applying them to various business entities to maintain data integrity during the integration process.Configured Match, Merge, and Survivorship settings for multiple source systems, ensuring accurate and consistent master data management in the integration of laboratory equipment data.Crafted prioritized user stories with healthcare stakeholders, utilizing Epic's EHR system for clinical insights. Contributed to Scrum meetings for user story refinement and conducted root cause analysis to address disparities.Collaborated on cloud-based healthcare applications migration, maximizing integration with Microsoft Azure and Epic's tools.Led the design and development of ICD code mapping solutions, utilizing Informatica MDM to ensure accurate and consistent data integration across healthcare systems.Integrated ICD code mappings within the Epic EHR system, leveraging Informatica MDM for seamless data synchronization and improved clinical data insights.Collaborated with healthcare stakeholders to gather requirements for ICD code mappings, translating them into effective Informatica MDM configurations.Implemented robust data quality checks for ICD code mappings using Informatica Data Quality tools, ensuring the integrity and accuracy of mapped data.Engaged in Scrum meetings, providing updates on ICD code mapping progress and addressing integration challenges with Informatica MDM and Epic systems.Conducted root cause analysis for discrepancies in ICD code mappings, utilizing Informatica MDM's capabilities to identify and resolve issues efficiently.Leveraged expertise in designing, developing, and optimizing Informatica MDM Hub solutions to configure match paths, columns, and rules for accurate ICD code mapping.Managed daily operations of MDM solutions, ensuring ICD code mappings were monitored and troubleshooting issues proactively to maintain data accuracy.Utilized Azure Boards to track development tickets for the ICD code mapping project, facilitating efficient task management and collaboration across teams.Collaborated with stakeholders to ensure data governance specifications were applied, maintaining data quality and syncing ICD code mappings across various healthcare systems.Captured and documented business requirements specific to ICD code mapping capabilities within the MDM system, ensuring alignment with project goals.Executed SOAP UI and Postman API for complex data operations such as hard and soft deletion, as well as merging and unmerging records, to maintain accurate ICD code mappings.Supported data owners and stewards in maintaining the integrity of ICD code mappings, ensuring consistent application across systems.Validated ETL processes specific to ICD code mappings, conducting SQL queries, design and code reviews, and preparing technical documentation and test plans.Applied Data Stewardship and Governance processes, including manual merging and unmerging of ICD code data, to maintain high-quality data across systems.Executed profiling, standardization, matching, and survivorship techniques for ICD codes, leveraging fuzzy matching to improve mapping accuracy.Implemented MDM functionality within Informatica IICS and MDM Foundation 360, aligning with the project needs for accurate ICD code management.Designed and maintained data integration solutions using Informatica IDMC, facilitating seamless integration of ICD code mappings with healthcare data.Executed and automated test cases using industry-leading tools and technologies, while actively tracking and managing bugs to facilitate prompt resolution and maintain product integrity.Played a key role in the creation and implementation of quality processes and requirements, collaborating with cross-functional teams to establish best practices and ensure adherence to regulatory standards.Utilized Informatica's data profiling and validation capabilities to validate data accuracy and integrity, providing valuable insights to inform decision-making and drive continuous improvement.Optimized SQL queries on Microsoft Azure, reducing execution time and ensuring seamless data retrieval from Epic's databases.Implemented robust data quality checks in SQL, leveraging Epic's data validation features for enhanced data integrity.Presented mapping specifications effectively to stakeholders, leveraging insights from Power BI analytics and Epic's visualization tools.Generated insightful progress reports and dashboards using Power BI, integrating data from Microsoft Azure and Epic. Contributed to Scrum meetings for progress updates and conducted root cause analysis for reporting accuracy.Cassava Sciences Pharma Nov 2016 Apr 2018Data AnalystResponsibilities:Led the assessment of ELN vendors, ensuring adherence to HL7-SQL standards for seamless integration and regulatory compliance, while optimizing project management workflows through JIRA utilization.Led the integration of ELN systems with laboratory instruments, utilizing Informatica MDM Hub for seamless data capture and regulatory compliance, while optimizing data synchronization across systems.Designed and developed Informatica PowerCenter mappings to facilitate the smooth exchange of data between ELN systems and laboratory equipment, ensuring accuracy and adherence to HL7 standards.Configured match rules, validation rules, and data quality checks within Informatica MDM to ensure precise data handling and compliance with HIPAA and FDA guidelines.Orchestrated the integration of ELN systems with laboratory instruments, ensuring seamless data capture and analysis workflows, while adhering to regulatory requirements such as HIPAA and FDA guidelines, optimizing patient data management.Collaborated with research teams to define ELN requirements and specifications, ensuring alignment with laboratory workflows and compliance with industry standards, promoting clinical research integrity.Streamlined project implementation by adhering to regulatory standards and fostering seamless communication among stakeholders, facilitating efficient ELN integration with lab equipment.Designed data validation checks within ELN pipelines to ensure adherence to HL7 standards, elevating data precision and regulatory compliance.Ensured compliance with HL7 standards by implementing data validation checks in ELN pipelines using SQL scripting.Implemented comprehensive strategies to manage Protected Health Information (PHI) within ELN integration projects, ensuring strict compliance with HIPAA regulations and maintaining confidentiality of patient data across the data lifecycle.Developed detailed Business Requirements Documentation (BRD) to articulate project objectives, stakeholder needs, and system specifications for ELN integration, ensuring clear communication and alignment with business goals.Collaborated with stakeholders to identify data mapping requirements and ensure comprehensive coverage of business needs and HL7 compliance.Led Agile teams in ELN integration projects, utilizing Microsoft Teams for effective communication and collaboration to meet project objectives.Conducted detailed analysis of ELN requirements and laboratory workflows, leveraging Informatica MDM to integrate and streamline data management processes, enhancing clinical research integrity.Utilized FMEA methodology to identify and mitigate potential failure modes in ELN integration processes, ensuring robust risk management strategies and maintaining data integrity throughout project implementation.Created and managed data validation rules within Informatica MDM to ensure compliance with industry standards and regulatory requirements for ELN integration projects.Implemented Python scripts for automating data processing tasks, improving efficiency and reducing errors in ELN data workflows, while integrating with Informatica for streamlined operations.Implemented AWS storage solutions to enhance data scalability and security, optimizing storage management for ELN integration projects and ensuring compliance with regulatory standards such as HIPAA and FDA guidelines.Advised on strategic technology investments for SQL-compatible ELN software solutions to enhance data management efficiency.Implemented real-time data acquisition workflows using Informatica, enabling immediate access to experimental results for timely analysis.Facilitated Joint Application Development (JAD) sessions, gathering insights from clinical staff and IT professionals to define requirements and ensure alignment with project objectives, enhancing communication and driving successful ELN integration.Mentored junior analysts on HL7 integration methodologies, Informatica workflows, and Power BI development, fostering skill development and knowledge sharing.Leveraged Tableau to develop interactive and insightful visualizations, enabling stakeholders to gain actionable insights from complex datasets, driving strategic decision-making and project success.Privia Health Group Sep 2015 Oct 2016Junior Data AnalystResponsibilities:Developed predictive models to simulate the impact of EHR system upgrades on operational metrics, utilizing R statistical analysis for robust predictive modeling.Collaborated in the development of change management plans and training materials, incorporating user acceptance stories to ensure effective end-user adoption.Led the development of an automated data quality assurance framework leveraging Informatica Data Quality (IDQ) and QA automation tools.Implemented continuous integration pipelines integrating IDQ tests with version control systems (Git) and CI/CD tools (Jenkins).Orchestrated regression testing suites to validate data sets for internal data systems, ensuring adherence to quality standards and regulatory compliance.Conducted quality assurance checks on EHR data post-upgrade, ensuring compliance with regulatory standards such as HIPAA and HITECH.Utilized Lucid chart to create data mapping documents, ensuring accurate data migration and alignment with SNOMED standards.Engaged in Joint Application Development (JAD) sessions with clinical staff and IT professionals to gather insights and requirements for system upgrades.Translated business requirements into comprehensive Functional Requirements Specifications (FRS), facilitating the development of upgrade plans.Conducted stakeholder interviews and workshops to prioritize requirements and ensure alignment with organizational goals.Utilized JIRA for tracking project tasks and facilitating communication among team members during the upgrade process.Documented data lineage using tools like Erwin and Collibra to ensure transparency and compliance with regulatory requirements.Documented SQL queries, data mapping processes, and testing procedures in knowledge repositories for future reference.Utilized SQL scripts for data transformation and cleansing during the upgrade process, maintaining data consistency.Created interactive Tableau dashboards to visualize key performance indicators and trends related to EHR upgrades.Pursued additional training in Tableau visualization techniques to enhance proficiency and contribute to impactful data visualization solutions.Employed statistical methods for interpreting findings and presenting actionable insights through Tableau dashboards and reports. |
