Jadav SaiKrishna

Experience

• 

  Wipro technologies

  Oct 2012 - Nov 2016

  Data Analyst

  Successfully led a data migration project in the British Petroleum (BP) logistics domain, ensuring the seamless transition of critical operational and financial data to a new enterprise system. The project improved data accuracy, reduced inconsistencies, and enhanced reporting capabilities in logistics operations.Key Responsibilities: • Designed and implemented data transformation workflows for logistics and supply chain data processing. • Developed SQL queries for data validation, improving reporting accuracy and operational efficiency. • Successfully mapped and transformed shipment records, inventory data, and financial transactions from legacy systems to new enterprise resource planning (ERP) systems, ensuring data integrity during migration. • Conducted data integrity audits, reducing inconsistencies by 30% in supply chain and transportation records. • Designed and optimized data pipelines and ETL processes in Snowflake, Redshift, and BigQuery for efficient storage and retrieval of logistics data. • Conducted thorough data cleansing and deduplication activities to eliminate redundant records and enhance data quality, improving logistics decision-making. • Created Business Requirements Documents (BRDs) and documented functional and non-functional requirements for the data migration project, aligning with industry standards and best practices. • Collaborated with business teams to define data mapping requirements specific to logistics and fleet management. • Developed and executed test plans, including User Acceptance Testing (UAT), to validate the accuracy and completeness of migrated data, ensuring smooth integration with new systems. • Extracted and transformed logistics data from multiple sources, including warehouse management systems, GPS tracking data, and transportation records, to support real-time decision-making. Show less

• 

  Tikri IT Services Private Limited

  Dec 2016 - Jul 2019

  Senior Data Analyst

  • Develop custom ETL (Extract, Transform, Load) processes to streamline data transfer from various sources into a unified data warehouse.• Create data analysis pipelines in Python using libraries such as Pandas, NumPy, and Matplotlib to streamline data exploration and visualization.• Automate data loading from various sources (e.g., transactional databases, APIs, flat files) into Snowflake, Redshift, or BigQuery using Python scripts and cloud tools. • Utilize Power BI’s DAX language to build dynamic and scalable measures, improving dashboard performance and analytical capabilities• Conducting in-depth data quality analysis to resolve inconsistencies.• Conduct data validation through SQL to ensure accuracy before moving to production.• Lead efforts to integrate and harmonize data from various EHR systems using health record system data dictionaries.• Ensure healthcare data compliance with standards such as HIPAA, HITECH, and GDPR by implementing access controls, encryption, and auditing in SQL databases.• Designing ETL pipelines that efficiently handle large volumes of health claims data, ensuring minimal processing time and resources.• Loading processed health claims data into a Data Warehouse (e.g., Snowflake, Redshift) for analytics and reporting, optimizing for storage and query performance.• Using SQL JOINs (INNER, LEFT, RIGHT) and UNION operations to combine claims data from multiple tables (e.g., Claims, Patients, Providers). • Improve report performance by optimizing DAX calculations and query execution in Power BI, ensuring fast and efficient data retrieval. • Coordinate with key project personnel to gather functional and non-functional requirements during JAD sessions using Agile, iterative techniques.• Implementing logic within ETL processes to remove duplicate, incomplete, or erroneous claims data, improving overall data accuracy. Show less

• 

  Remote

  Aug 2019 - now

  Data Scientist

  Project Description:Successfully integrated and migrated healthcare data to modern platforms, ensuring compliance with HIPAA and other industry standards. It improved data quality, optimized reporting, and streamlined data processing for critical healthcare decisions.Key Responsibilities:• Developing complex SQL queries to validate claims and eligibility datasets.• Designing data mapping structures for efficient standardization.• Prepare monthly performance reports for senior leadership and critical business stakeholders using Epic EHR data.• Ensuring data integrity and troubleshooting ETL pipeline issues.• Involve in the full HIPAA compliance lifecycle, including GAP analysis, mapping, implementation, and testing for Medicaid Claims processing.• Lead the planning and execution of complex data migration projects, ensuring a seamless transition from legacy health systems to modern platforms.• Prepare Business Requirement Documents (BRD), collaborating with SMEs to understand project requirements.• Successfully integrate Jira data with Electronic Health Records (EHR) systems, enhancing cross-functional data access and analysis.• Collaborating with data engineers to optimize data processing performance.• Demonstrate proficiency in data integration tools, including Jira, Epic Systems, Cerner, and other healthcare-specific software• Develop data cleansing and enrichment strategies to bridge data gaps and address inconsistencies in health system data, ensuring high-quality data for critical healthcare decisions.• Writing complex SQL queries to extract relevant health claims data from relational databases like Oracle, SQL Server, or MySQL.• Create use cases and flow diagrams while working closely with development teams to ensure smooth system integration and conduct user acceptance testing (UAT) to validate implemented functionalities. Show less