Home

Faraz M - TDM/Data masking specialist

[email protected]

Location: Chicago, Illinois, USA

Relocation:

Visa: GC

Faraz Mohammed Saleem Email: [email protected] Phone: +1 (224) 216 - 2498 LinkedIn: https://www.linkedin.com/in/faraz-md-pmp%C2%AE-0b6236b0/ Professional Summary Seasoned Data Management and Compliance professional with over a decade of experience spanning data engineering, ETL development, data security, compliance and governance in healthcare domain. Expertise in implementing dynamic data masking, managing sensitive data (PHI/PII), and creating synthetic test data to support secure and compliant operations. Skilled in leveraging tools like Informatica (Test Data Management , PowerCenter , IDMC , DVO ) , SecuPi, and GenRocket to enable efficient data integration, protection, and quality management. Strong foundation in PL/SQL scripting, metadata management, and data classification, with a focus on enabling business insights through secure and accurate data handling.Proven track record in implementing governance solutions that enhance compliance, data accessibility, and data reliability for informed decision-making. Technical Skills Programming Languages: SQL, SparkSQL, PL/SQL, Perl ETL Tools: Informatica PowerCenter, Informatica Data Management Cloud (IDMC), Informatica B2B, Data Validation Option (DVO) Data Governance & Security: SecuPi (Dynamic Data Masking), Informatica Data Catalog (IDMC), GenRocket, Informatica - Test Data Management, Metadata Management Big Data Technologies: Spark, Hadoop Cloud Platforms: AWS S3, Azure Databases: Oracle, MS SQL Server, DB2 Tools: Git, Docker, Kubernetes, Jenkins, Power BI, Tableau Data Modeling Tools: ER Studio, ERWIN Project Management: PMP Certified, Agile, SAFe Professional Experience Manager/Data Lead Capgemini/Sogeti, Tampa, FL May 2024 Present Client: Zelis Healthcare Enhanced data security and compliance by implementing SecuPi, applying dynamic data masking to protect PHI/PII during ingestion, storage, and processing, ensuring adherence to HIPAA and global privacy regulations. Addressed governance gaps by automating policy enforcement and audit logging, providing real-time visibility into data access patterns while streamlining compliance efforts. Eliminated dormant accounts and established Privileged Access Brokering (PAB) with Zero Standing Privileges (ZSP), reducing risks of insider threats and unauthorized data exposure for offshore teams. Defined Attribute-Based Access Control (ABAC) policies based on user roles, access purpose, and location, enabling contextual and granular control over sensitive data access. Developed and applied masking policies for healthcare claims data, ensuring role-based masking aligned with compliance requirements for patient and provider information. Utilized GenRocket to generate synthetic datasets for healthcare claims, enabling comprehensive testing scenarios without exposing real data. Simulated edge cases to improve system robustness. Conducted thorough data classification of claims, provider, and financial data to streamline audit readiness and enhance regulatory reporting. Established data lineage to enable traceability of critical data assets, improving oversight across healthcare claims processing workflows. Improved operational efficiency by securely enabling offshore teams to access required data, accelerating timelines for product development and testing. Delivered ROI with a transparent deployment process, achieving rapid implementation without requiring changes to existing codebases. Led governance initiatives for healthcare payer data and processes, improving the quality and compliance of claims data management while aligning with industry standards. Informatica ETL/TDM Developer Priority Health, Grand Rapids, MI March 2018 April 2024 Led data masking, sub-setting, and synthetic data generation for FACETS, PHDB, and other healthcare applications, ensuring HIPAA compliance. Directed comprehensive data projects for the State of Michigan, utilizing Informatica tools for data masking, cleansing, and transformation to ensure data integrity and compliance. Implemented advanced data masking solutions for Medicaid and Medicare data, adhering to strict regulatory requirements. Conducted extensive data masking for Ford Motors to protect sensitive information, enhancing data security and compliance across automotive projects. Developed and executed ETL extracts and transformations for the State of Michigan, handling sensitive data in adherence to data governance standards. Developed and optimized complex PL/SQL procedures and packages for automating data integration and transformation processes. Implemented data validation and cleansing using PL/SQL scripts to ensure data accuracy and efficiency. Directed comprehensive data projects for healthcare payer data and processes, including masking and sub-setting sensitive claims data to ensure compliance with healthcare regulations. Created and managed data quality rules for standardization, parsing, consolidation, and match operations for various data formats, including EDI, CSV, XML, and ACH transactions. Implemented file encryption and securing protocols for NACHA and EDI files, ensuring safe transfer and storage of sensitive information. Designed and developed ETL processes with Change Data Capture (CDC) and Slowly Changing Dimensions (SCD) types 1, 2, and 3 to maintain historical accuracy and data integrity. Applied push-down optimization techniques to improve ETL performance, reducing data processing times. Enhanced data governance by using IDMC s profiling and data quality capabilities to identify duplicates, improve data accuracy, and ensure data consistency, reducing error rates and improving reporting reliability. Implemented a centralized metadata catalog and lineage system within IDMC to classify and track key data elements, providing transparency in data flow and improving the organization s ability to manage data ownership and accountability. Applied data quality rules and standards within ETL processes to validate data, reducing inconsistencies in healthcare claims and improving compliance with regulatory requirements. Migrated from Informatica PowerCenter to Informatica Intelligent Cloud Services (IICS)/Informatica Data Management Cloud (IDMC), ensuring a seamless transition and enhanced data management capabilities. Implemented synchronization and replication tasks in IICS/IDMC for efficient data integration and replication. Leveraged Cloud Data Integration (CDI) and Cloud Application Integration (CAI) to streamline data workflows and application integrations. Integrated Informatica Metadata Command Center (MCC) to centralize metadata governance, automating metadata collection and ensuring HIPAA compliance by improving PHI traceability across multiple healthcare systems. Created a centralized metadata repository where healthcare providers could quickly access key metadata definitions and data lineage paths. This streamlined data cataloging and provided transparency into the flow of sensitive healthcare data. Configured AWS S3 buckets for securely storing National Automated Clearing House Association (NACHA) files, ensuring compliance with data protection regulations. Developed and implemented custom policies using JSON for fine-grained access control and enhanced security of sensitive data in AWS S3. Implemented data classification and lineage to ensure the accurate handling and tracking of PHI data, providing traceability from ingestion to reporting. This helped reduce compliance risks and improved audit readiness. By defining critical data elements (CDEs), we ensured that data lineage tracking was focused on the most important and sensitive datasets, reducing the need for redundant governance efforts. Developed data lineage tracking and governance workflows in CDGC, ensuring end-to-end visibility of PHI data from ingestion to reporting, providing traceability and maintaining Priority Health s compliance with HIPAA standards. Leveraged IDMC s AI-powered Claire to enhance metadata discovery and improve cataloging efforts. ETL Consultant Kemper Insurance, Jacksonville, FL January 2016 March 2018 Developed Informatica workflows to collect data from multiple data sources based on mapping specifications. Assisted project team with unit testing and developed system test plans for full system testing prior to implementation. Conducted extensive data profiling and classification to prepare data for masking processes, ensuring that sensitive information in property insurance data was accurately identified and managed. Developed data lineage workflows that provided visibility into data transformation processes from source to final reports, improving data traceability and ensuring audit readiness. Worked with business stakeholders to define key data elements (KDEs) for property insurance claims, enhancing data governance and making it easier to audit data lineage and usage for regulatory compliance. Provided guidance to onshore, offshore, and near-shore development service providers. Developed Informatica code and modified existing software to correct errors and improve performance. Data Engineer AIM Specialty Health, Deerfield, IL December 2014 December 2015 Designed and created detailed Technical Mapping documents with information on implementation of business logic. Leveraged Python libraries such as Pandas and NumPy to perform data manipulation, analysis, and ETL processes. Used Pandas to write and execute SQL queries within Python scripts, integrating seamlessly with database operations. Performed duties including IPA administration and technical configuration management of core Infor Lawson and third-party products. Designed ETL mappings for change data capture and performed performance tuning at various levels. Classified customer claims data based on sensitivity and implemented rules for data access, improving compliance with internal data governance policies. Designed and implemented data quality rules within Informatica PowerCenter, ensuring that data used in insurance claims processing was accurate and met governance standards. SQL Developer/Data Analyst Inforick Corp, New York, NY December 2012 December 2013 Analyzed data trends and developed SQL queries for data extraction. Ensured data integrity across databases and systems. Optimized queries and database performance. Developed scripts to identify and remove duplicates and incorrect records in healthcare data warehouses, ensuring high data integrity for patient reporting and analytics. Education Bachelor of Engineering (ECE) Master of Science in Information Systems and Security Certifications Project Management Professional (PMP) Cloud Data Governance & Catalog Foundation Series Certification (CDGC) Intelligent Data Management Cloud Foundation Series Certification (IDMC) GenRocket Certified Engineer Level 1 (GCE - Level 1) Technical Proficiencies Requirement Gathering, Documentation, Design, Analysis, Development, Testing, UAT Facilitation, On-Call Support, Project Management, Team Leadership, Solution Analysis. Operating Systems: UNIX/Linux, Windows Databases: Oracle, MS SQL Server, DB2, AWS S3 Applications: MS Office Suite, SharePoint, Visio Reporting Tools: Power BI, Tableau, Oracle Apex. Data Modeling Tools: ER Studio, ERWIN 7, Informatica Data Profiler Database Tools: TOAD, SQL Developer, Data Studio, SQL Management Studio Version Control: Jenkins, Git, Tortoise SVN, Bitbucket, JIRA API Development & Testing Tools: Postman, SOAP UI Containerization & Orchestration: Docker, Kubernetes, OpenShift Previous Clients & Roles Capgemini/Sogeti: Manager/Data Lead (Tampa, FL) YS Technologies / Priority Health: Informatica ETL/TDM Developer (Grand Rapids, MI) Kemper Insurance: ETL Consultant (Jacksonville, FL) AIM Specialty Health: Data Engineer (Deerfield, IL) Inforick Corp: SQL Developer/Data Analyst (New York, NY) References: Provided upon request Keywords: artificial intelligence user interface business intelligence sthree information technology microsoft procedural language Florida Illinois Maryland Michigan New York