Ganesh Nair

Company Overview: Gainwell Technologies provides the broadest range of healthcare cost containment solutions for healthcare payers in America. Gainwell uses innovative technology as well as powerful data services and analytics tools to increase system efficiency to implement cost containment strategies

• Leading efforts for Re-engineering for multiple feeds
• Identified the root cause for data loss by leveraging Hadoop and DB2 data analysis tools
• Fixed the gap by adding additional mapping logic and improved the delivery by 900%
• Collaborated with Client engagement team to address the issue of data quality and reduced bad data from 72% to 22%
• Assisted and coordinated multiple data testing and review efforts
• Developed new mapping template from source to target data mapping document for ETL developers for coding
• Provide resolutions on Service Now tickets for production support
• Coordinated with Informatica developers to understand data onboarding issues
• Trained Junior Analyst on Hadoop and data analysis techniques

• Implemented several data migration projects
• Carried out Gap Analysis between client layouts and HMS requirement document
• Performed Client source data Analysis using Hadoop
• Coordinated with the Client Engagement team to communicate data issues and data anomalies
• Performed data validation and cleansing which increased data integrity by 20%.
• Provided actionable insights from data analysis to support decision-making, leading to a 10% uplift in performance metrics.

• Manipulated data using pivot tables, pivot charts and macros in Excel
• Visited customer (Pharmacy) sites to understand issues and defects onsite
• Coordinated with marketing department for resolving issues and writing requirements for new products and existing product enhancements
• Used DQL (Data Query Language) to query SQL server 2012 DB to understand the data and provide inputs to testing team
• Prepared testable use cases and assisted the QA with writing of test cases
• Conducted JAD sessions with cross functional teams
• Worked on multiple product lines to gather requirements, managing change request and change control
• Coordinated with sales force team to resolve customer issues
• Analyzed test cases in TFS (Team Foundation Server)

• Worked with cross-functional resources to implement direct marketing programs to increase customer base
• Identified bottlenecks in processes and implemented new and improved procedures and policies to ease friction and improve productivity
• Gap Analysis between the AS-IS and TO-BE systems
• Mobile application development and online banking system up gradation
• Assisted developers in developing web services in online banking application
• Moderate understanding of XML schema
• Defect tracking and defect management on JIRA
• Followed agile scrum methodology
• Helped identifying relationships between entities to establish hierarchies in data model
• Tennessee State Project:
• Conducted JAD sessions and called out meetings for gathering system requirements
• Developed Use Cases and Use Case Diagrams
• Good understanding of Informatica 91
• Followed agile methodology
• Reading Informatica maps and preparing Standard Operating Procedure's (SOP's) for the end users
• Understanding the functionality of As-Is process and doing GAP Analysis
• Documented the As-Is processes and developed Flow Diagrams in Visio
• Participated regularly in Walkthrough and review meetings with Project Manager, QA Engineers and development team
• Content Management and Data Mapping to facilitate GAP Analysis