George Sam Email & Phone Number

Philadelphia, Pa, Us

Eden Prairie , Mn, Us

• Managing a team of Data Architects, DBAs, Developers and BAs at UnitedHealthcare’s Home and Community division.• Build data pipelines that encompass Azure, Databricks, Synapse, Kafka, PostgreSQL, SQL Server and Snowflake. • Responsible for architecting a persistent layer that stores data in PostgreSQL and an EDW in Snowflake.• Led the Data Migration between acquired entities of UnitedHealthcare by migrating data from Sales Force, Azure Databricks and SQL Server into MongoDB.

• Data Management and Data Architect Consultant for a leading Biopharmaceutical company, Oncology group – Health Economics & Outcomes Research;• Leading the Design and Development of the Database system that supports Analytics of Health Economic and Outcome Models with security-controlled access to modelers across multiple Regions and countries for multiple Clinical Trials in adherence to regulatory practices and industry standards.• Manage Global development team and Liaison with external Vendors at the Product level.• Evaluated migration of on-premise software components to the AWS cloud environment. Additionally, weighing solutions for data storage, scaling, security, performance, reliability and processing.

Us

• Led Medicare and Retirement (M & R) Database and Data Warehouse Projects for Policy Administration, Enrollment, Billing, Fulfillment, Data Warehouse and Reporting Systems.• Managed 16 Data Migrations that encompassed Member Eligibility, Claims and Billing from multiple source systems that were both internal and external.• Data Warehouse, DataMart, Database & Software Design & Development, Data Integration and Reporting activities.• Leveraged Data Analytics, Business Intelligence (BI) Solutions, Data/File Validation, and Profiling to Business objectives.• Provided Leadership and Mentored teams both Off-shore and On-shore.• Agile Methodologies (Scrum/Kanban) –Occasional Scrum Master.• Data Modeling: Conceptual, Logical & Physical. Design of Canonical data models.• Application Development DBA activities • Documentation of Systems Requirements, Technical Designs, Transformations, Source to Target Mappings, Features & Functionality. • Change Management and Post Production support activities.• Strategies for Big Data Development, Cloud, Business Process improvements and Enhancements.• Data Mining & Statistics for both Business and IT teams.

• Merck & Co., West Point, PAMigrated primary marketing analysis data from Access/VBA to Oracle.• University of Pennsylvania (ISC Dept.), Philadelphia., PADeveloped the Disbursement and Refund processing module of the Student Loans System.• Aramark – Philadelphia, PALogical & Physical Data Model of a Payroll Data Mart.• Prudential Financial (Prudential Annuities), Shelton, CT Designed and Implemented a Common Repository Data Warehouse of an Electronic Documents Module System.• Thomson Reuters Elite (Law Manger), Conshohocken, PA Customized and Implemented a Legal CASE management system (Law Manager) for the State of New York, Department of Taxation and Finance. • Ace International, Philadelphia, PADesigned & Developed a Policy and Claims Data Warehouse (PCW) to load Claims data from over 50 countries.• Aventis Pharmaceuticals, Collegeville/Berwyn, PADeveloped a Corporate Data Warehouse System for Sales, Credits and Aggregates.

• Independence Blue Cross, Philadelphia, PADevelopment of Sales Incentive System & Enrollment System.• ADP, Roseland, NJAnalyzed, Designed & Developed a Quality Survey Data Mart.

Masters In Commerce, Financial Accounting

Bachelors In Commerce, Cost Accounting & Banking

Icse