Debashish Lenka Email & Phone Number

Houston, Tx, Us

Danville, Pa., Us

Geisinger is one of the largest healthcare providers in Pennsylvania. Geisinger Health System to support On-going Clarity extract, Creating Roster Extract for associated entities and other third-party Clarity extracts.Responsible for validating the ETL extracts against the mapping document and validation of business logic rules.Create and maintain a large ETL process for tracking different extracts and File load for business use and simplify the process of File tracking.Work with Clarity business Analysts to understand the Clarity data model for third-party vendor extractsGeisinger Health Plan: Geisinger planned to retire existing Claim processing system to the new FACETS System to automate Claim processing, Billing,Payer Adjustment and many more functionalitiesKeeping low Admin and maintenance cost Geisinger achieved operational efficiency while supporting enterprise-wide businessinitiativeMentored Six team members on Facets Data model and Informatica Low level design.Conducted extensive analysis on migration and conversion of Provider and Member data, Group configurations, plan codes,benefit set-ups, fee schedules, provider pricing, capitation set-ups, etc from Legacy system to FACETSPrepared ETL Test Cases to validate data between Source Facets source systems to Target ODS SystemConducted Daily, Weekly and Monthly Check point with DEV and QA team and PMs for project health check-upEnhanced and deployed the SQL Server Packages from development server to production server for Hedis work and project.Worked on Nextgate Patient Matching tool to create EMPI record.Performed Documentation for all kinds of reports for Internal Quality Review

Canton, Massachusetts, Us

Tufts Health Plan implemented a new Data warehouse with different subject Areas to focus on a centralized database and store aggregated data for business user to access and process various extracts to outside vendors and partners. -----Managed multiple Data warehousing projects in Tufts for it's enterprise Data Warehouse (TDW).Extensively working with Informatica Power Center and Power Exchange CDC (Change Data Capture) to provide real-time data for business analysis.Implementation of ETL processes for loading the Tufts data warehouse from 22 different sourcesystems including mainframe data in both VSAM and sequential files, Microsoft SQL Server,Oracle, flat-files, XML based data and unstructured data. This ETL consists of more than 300Informatica mappings and associated workflows.

Hartford, Ct, Us

Data Masking Portfolio at The Hartford was one of the largest in terms of number of Application involved and databases used. Idea behind this biggest masking project was to protect customer data from downstream environments (Development , Testing, Performance Tuning, UAT ..etc)-----Managed the data masking portfolio having 800+ databases of 100+ ApplicationUsed Informatica ILM (Test Data Management) for Masking PII (Personally Identifiable Information) data for various upstream and downstream applications at organization level.Involved in exploring the first version of Informatica ILM tool and fixed numerous bugs as part of this implementation.

Redmond, Washington, Us

One of the very first steps for Microsoft to try Informatica packages for data loading and storing data in SQL server. This was a big migration project of converting various old SSIS packages to Informatica Workflows.----Understanding the SSIS package and the corresponding data loading jobs.Creating business design document for Informatica mappings and workflowsCreating Informatica mapping and workflows manually in designer and validating with SSIS packageManaging a team of 5 resource and deploying Informatica jobs into production for successful conversion of SSIS jobs.

New York, Ny, Us

1.Requirement Analysis and High Level Design2.Configuration Management, Designing, Gap Analysis3.Software Development, Code Walkthrough4.Unit testing and Integration testing