VEENA KATKAM

SENIOR DATA ANALYST

Email: ad1ci0@r.postjobfree.com Location: Norfolk, Virginia

Professional Summary

Objective: Leveraged 8 years of senior data analyst experience in Healthcare and Pharmaceutical to enhance data integration, data warehousing, and data visualization, optimizing healthcare processes, ensuring HIPAA compliance, and developing advanced analytics solutions for marketing and CRM.

Extensively working knowledge with application development using Python, R, Pyspark, Java, XML, JSON and HTML.

Proficient in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI.

Experienced with TriZetto FACETS and supported new business requirements by extending the functionality of the core Facets system using the Facets extensibility architecture feature.

Have knowledge with BI tools and technologies for continuous improvement in data mart operations.

Strong proficiency in supporting Production Cloud environments (AWS, Azure) as well as traditional managed hosted environments.

Experienced with version control systems like Git, GitHub to keep the versions and configurations of the code organized.

Adept knowledge of Unified Modeling Language ( UML ) and creating Activity Flow Diagram, Sequence Diagram, Use Case, Workflows, and Data Flow Diagrams using MS Visio.

Demonstrated expertise in Snowflake, contributing to effective data warehousing and analytics, enhancing data accessibility and insights.

Experienced in designing Data Warehouse applications using Business Intelligence tools like Informatica Power Center, Data Stage, Mainframes, SSAS, SSIS, SSRS, OLTP, OLAP, and Business Objects.

Very Good Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

Experienced in high performance data integration solutions- Microsoft SQL Server Integration Service (SSIS), including extraction, transformation, and load (ETL) packages.

Experience in Data Analysis, data modeling, process flow, quality assurance skills, MDM Data Analysis / Data Profiling and ETL development and design.

Good Knowledge in gap analysis and gathered necessary data for analysis from different sources, prepared data for data exploration using data mugging.

Experienced in operations like data migrations and updating using LINQ and XRM that help in facilitating data migration within CRM across various entities.

Demonstrated ability in using ETL methods, functions, database triggers, schema design in Oracle, SQL Server and Google Big Query.

Full Software Development Life Cycle (SDLC) experience including analysis, design and review of requirement specifications document as per Agile, Waterfall and RUP development methodology.

Proficiently utilized Jira for project management and issue tracking to ensure streamlined data analysis processes.

Extensive knowledge of Medical Management Information Systems (MMIS), Medicaid, Medicare and Claims Process.

Experienced in PBM- Pharmacy Benefits Management, HL7 Messages and Medicare-D projects on Mainframes and Java environment.

Profound knowledge of healthcare standards such as HIPAA 4010, 5010, ICD-9 and ICD-10 codes. Excellent knowledge of EDI Transactions (270, 271, 278, 820, 834, 835, 837).

Experienced working with EHR (Electronic Health Record) and EMR (Electronic Medical Record) team for data requirement.

Demonstrated competencies in managing clinical trials data by developing and implementing new or improved processes for data management.

Excellent analytical, problem solving, communication and time management skills.

Professional Experience

Role: Senior Data Analyst

Client: Merck & Co, Kenilworth NJ Feb 2021 to Present

Project Description: The project's core objective is to harness data analysis for Merck & Co., centered on their Medicaid Management Information System (MMIS). It has encompassed data extraction, transformation, and visualization to enhance decision-making and pharmaceutical operation optimization, ultimately driving data-driven strategies for improved healthcare services and cost-efficiency.

Responsibilities

Implemented new logic on large medical encounter dataset using Oracle database and data science tool as Python and Tableau.

Worked on embedding Tableau reports to Microsoft Power BI Launchpad and Crystal reports.

Masterfully crafted informative data visualizations employing Tableau, Power BI, and Matplotlib, enabling robust support for data-driven decisions.

Assisted in developing Spark/Scala, Python for regular expression (regex) project in the Hadoop/Hive environment with Linux/Windows for big data resources.

Designed and built the Reporting Application, which uses the Spark SQL to fetch and generate reports on HBase table data.

Responded to JIRA tickets that update PL/SQL packages and Application Express Components in HTML.

Participated in solving Billing issues from the FACETS Problem Log for Trizetto and Billing Entities.

Proficiently harnessed SQL for the precise querying and manipulation of extensive datasets, ensuring meticulous data accuracy and consistency.

Spearheaded the orchestration of Extract, Transform, Load (ETL) processes to seamlessly integrate multifaceted data from diverse sources, all while optimizing data organization through the development of intricate logical and physical models.

Spearheaded the meticulous design and unwavering maintenance of data warehouses, ensuring a well-oiled system for the efficient storage and retrieval of structured data.

Oversaw data warehouse structures, ensuring efficient storage, retrieval, and governance compliance, including data modeling and integration.

Worked in client reports in SQL Server Reporting Services (SSRS) and wrote TSQL stored Procedures on the back-end.

Enforced stringent data quality standards through the application of meticulous data cleansing techniques, overseeing the comprehensive management of various Database Management Systems (SQL Server, Oracle, MySQL, and PostgreSQL).

Created and modified SQL Server DTS Packages to extract, transform, and load data from multiple enterprise systems Data Warehouse.

Spearheaded the implementation of rigorous version control systems such as Git, enabling a methodical approach to tracking and managing code and data changes.

Applied advanced statistical methodologies, complex machine learning algorithms, and meticulous regression analysis to extract data-driven insights and deploy cutting-edge predictive analytics.

Effectively harnessed the power of prominent cloud platforms including AWS and Google Cloud, ensuring efficient data storage, analysis, and adherence to stringent security compliance standards.

Used IAM to grant fine-grained access to AWS resources to users. Also, managed roles including permissions of users to AWS account through IAM.

Migrated historical data into AWS cloud and set up automated process in cloud for incoming Clickstream Data.

Drove the development and execution of Business Intelligence (BI) solutions, delivering comprehensive data reporting and actionable insights that foster informed decision-making.

Conducted methodical A/B tests to optimize decision-making strategies while seamlessly facilitating data transformation processes, thereby ensuring the accuracy and integrity of data analysis.

Utilized corporation developed Agile SDLC methodology and used Scrum Work Pro and Microsoft Office software [XL, Visio] to perform required job functions.

Participated in Daily status Check-point team meetings, Development meetings with Lead and conducted internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Worked within project team to identify and interpret state Medicaid and Medicare policies as applicable to customer defined algorithm research as well as assist with internal development of new analytics.

Integrated data from key operational systems, including the Medicaid Management Information System (MMIS), Pharmacy Benefits Manager (PBM), Integrated Eligibility, Medicare, into relational and dimensional data models.

Involved in processing claims in Facets and validating the full cycle process to make sure the checks are generated.

Supported data-driven decision-making by providing in-depth analysis of pharmacy benefit data, contributing to the effective management of healthcare costs.

Implemented guidelines and principles for practice-based clinical applications, including various practice management and EMR systems.

Performed GAP Analysis between existing and TO-BE Business process Models to understand the additional functionalities required meeting HER standards. Electronic Data Interchange (EDI), EMR, EHR, HL7.

Role: Data Analyst

Client: Centene, St. Louis MO Dec 2017 to Jan 2021

Project Description: This project was aimed at enhancing HIPAA compliance for a prominent healthcare provider. It involved assessing current compliance, conducting data analysis for privacy and security, and implementing risk mitigation strategies. The project also aimed to optimize data governance, establish monitoring and reporting systems, and create educational initiatives for staff. The goal was to ensure ongoing adherence to HIPAA regulations, safeguarding patient health information.

Responsibilities

Created interactive data visualizations using Tableau and Power BI to enrich data analysis and reporting across various healthcare domains, including health tech, and patient registries.

Worked with the Facets product management team to create reports in Tableau; Created data modeling and data mapping documents for facet provider and Payer.

Involved in FACETS Implementation, involved end to end analysis of FACETS Billing, Claim Processing and supported Team members in Preparation of Test Plan, Scenarios and the Testing procedures.

Involved in updating the pages using HTML 5 and CSS 3 for the new look and feel of their current application pages and worked on new CSS3 effects to enhance user experience as per the client requirements.

Used big data tools Spark (Pyspark, SparkSQL) to conduct real-time analysis of transaction default based on AWS.

Implemented Spark using Scala and Spark SQL for faster testing and processing of data.

Customized interactive dashboards in Periscope using SQL, R to show data trends and Communicate findings to stakeholders using visualization and charts.

Participated in JAD sessions and interacted with technical leaders from various departments and conducted Data Analysis and created Data Mappings for back end systems using SQL on DB2.

Validated data successfully loaded into staging SQL Server tables by verifying workflow monitor record count matches the records in SQL Server stage table.

Transformed SAS datasets to align with business model requirements using various SAS data step techniques and procedures, while also utilizing SSIS for data integration and prepared reports using SSRS Data Model projects in Microsoft Visual Studio and Report Builder.

Demonstrated an unwavering mastery of big data tools including Hadoop, Spark, and No SQL databases, expertly navigating the complexities of vast datasets.

Interacted with the ETL team, developer(s), and management to get the requirements, document them and write specifications and stored data from various sources including other databases like Teradata, SQL, and Oracle.

Prepared test data and expected outcomes with several types of data management systems such as: corporate data warehouse (CDW), Oracle, and UNIX and completed all tasks associated with testing of controls with test-data.

Managed data integration and governance efforts, maintaining standards and compliance while enhancing data understanding and accuracy.

Assisted in developing dashboards using MS Power BI Desktop with complex DAX calculations using data from Azure Analysis Services Models.

Used JIRA tool for issue tracking, user story management and requirement traceability. Assisted in entering and updating Issues (Epics, User Stories, and Tasks) onto JIRA Agile application.

Worked with clients to better understand their needs and present solutions using structured SDLC approach.

Performed Gap Analysis to find out changes and impacts on the MDW phase 1 components that may occur in HIPAA 4010 to HIPAA 5010 migration. Contributed significantly in developing all Business Objects universes in the Medicaid Data Warehouse.

Created dashboards and reports from concept to execution with clinical data from electronic health records, health information exchanges, relationship management database.

Assisted in developing HL7 messaging for bi-directional case and disease report exchange, in HTML and XML formats, in accordance with HL7 specifications EMR, EHR, HL7.

Implemented robust data security and privacy measures to maintain HIPAA compliance, GDPR compliance, and FDA regulations, safeguarding sensitive healthcare data, including patient registries and claims data.

Analyzed and performed quality assurance to determine areas impacted by HIPAA 5010 and ICD 10 related data.

Role: Data Analyst

Client: HCA Healthcare, Nashville, TN Dec 2015 to Nov 2017

Project Description: The project aimed to establish a robust Data Warehouse for Care Coordination, Performance Measurement, Outreach & Engagement, and Innovation. Utilizing Business Intelligence Data Marts, it streamlined user-friendly analysis with intuitive reports and dashboards. With collaborative efforts with cross-functional teams’ fostered continuous improvement, aligning the Data Warehouse with organizational goals and driving transformative outcomes in healthcare information management and business intelligence.

Responsibilities

Worked with data warehouse concepts for data cleaning, data integration, data transformation and also a periodic data of refreshing.

Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and ETL loading strategy designing. Involved with Data Warehouse team and generated reports using Oracle BI tool.

Implemented the Cloud Data warehouse solution for descriptive, Diagnostics and predictive analytics.

Development of dashboard in Tableau for data visualization to expedite the data analysis process and report automation.

Created Proof of Concept visualizations using Tableau and demonstrated capabilities to the management.

Built the Data Visualizations using Charts, Drill-Downs, and Quick Filters. Creating row level/data level security for tableau report.

Analyzing and compiling the data with the source systems to ODS and to data warehouse incident data. Data

Managed the feasibility and performed Gap analysis on the requirements for the Murex application.

Process definition for EDI processing and interact with Client/Carrier to gather all the requirements required for the feed build.

Worked on Preparing Unit test cases/ SQL Queries for the components developed in Power BI Reports.

Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.

Facilitated user acceptance testing and test strategies with Tableau power users.

Played a crucial role in functionalities like Role Level Security (RLS) with Power BI desktop, assigned and validated in Power BI Service to ensure visualization data security for the enterprise.

Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation.

Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Helped to create mapping to load data into AWS S3 bucket using Informatica S3 connector also populated data into Snowflake from S3 bucket using complex SQL query.

Interacted with the project team in understanding the requirements and provided some inputs with required system information. Participated in JAD sessions with business stakeholders to integrate the requirements of the project.

Analyzed existing Business units, Business process, System/ Application and there Interfaces with their capability through open-ended discussions. Created scheduled and ad-hoc reports for internal and external departments efficiently using Excel and MS Access.

Reviewed state documents (policies, manuals, business processes, systems documents, banners, bulletins) from various divisions. Analyzed and performed quality assurance to determine areas impacted by HIPAA 5010 and ICD 10 related data.

Incorporated integration with multiple applications due to Healthcare legislation to introduce the Medicare and Medicaid Plans review. Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.

Created a thorough Data Analysis document in order to gather the accurate data for the rewrite of the application and also to demolish the bad data. Ran SQL queries to create, modify, delete and update the Oracle database and to analyze the data.

Designed and developed complex SQL scripts in SQL server database for creating tables for tableau reporting.

Utilized corporation developed Agile SDLC methodology used Jira and Microsoft office software to perform required job functions. Maintained Requirement Traceability matrix throughout the project. Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.

Education

Master’s in Pharmaceutical Analysis (Sri Venkateshwara College of Pharmacy)

Contact this candidate