Melvin Mel Phillips

Database & Information Management Analyst @Health Care Service Corporation

Evanston, IL, US
MOBILE NUMBERS
+91 *********19

Signup · Get unlimited contacts

WORK HISTORY

Oct 2022 — Present

Database & Information Management Analyst @Health Care Service Corporation

View department →

US

Projects involve extracting data using Teradata Studio Express from various data sources, then applying transformations before loading data into SQL tables, Power BI, MS Access, and/or exporting to Excel/Flat Files-Writing code for data cleansing, data validation, data transformation for data coming from various source systems-Responsible for extracting, transforming and loading data from flat files using BTEQ tools and utilities-SharePoint, Power BI, Power Automate, Power Apps development-BAT file automation scripts-Develop, migrate, and enhance existing data platforms and solutions-Built forms using selective list boxes, sub-forms, selective displays, and views. Created processes and functions using VBA to enhance native MS-Access functions-Collaborated with project manager for improving data flow processes-Attended weekly Team project meetings.

EDUCATION

2011 — 2011

ITT Technical Institute

Associate's degree, Computer Network Systems

2012 — 2013

Directions IT and Certification Training Inst.

Microsoft SQL Certifcation, Information Technology

SKILLS

ManagementNetworkingWindows 8Windows ServerVpnMicrosoft OfficeProject ManagementNetwork AdministrationVendor ManagementWindowsCrmSqlComputer HardwareDatabasesBusiness IntelligenceInformation TechnologyProgram ManagementVbaAccessDisaster RecoverySharepointTrainingTestingCustomer Relationship Management (Crm)Web DevelopmentTechnical SupportBusiness AnalysisConsultingSap Business ObjectsMicrosoft ExcelMicrosoft AccessSoftware Development Life Cycle (Sdlc)Software DocumentationSdlcWindows 7TroubleshootingSql Server 2012Microsoft Sql ServerSql Server 2012-Reporting ServicesLeadership

ABOUT MELVIN MEL PHILLIPS

With over 38 years of IT and database experience, I am a data expert who can lead, develop, and deliver enterprise-level database projects for various industries, especially in healthcare, insurance, and pharmaceutical. I have various Microsoft training certificates and associate\'s degree courses in Computer Network Systems from ITT Technical Institute, demonstrating my technical skills and knowledge in data manipulation methodologies.Currently, I work as a Database and Information Management Analyst at Heath Care Services Corporation (BlueCross and BlueShield) where I developed Performance Guarantees/Internal Audit- Data Tracking and Reporting tools using MS Access, Tableau, and Power BI. I extract, transform, and load data from the data warehouse (EDW) and various data sources along with creating decision - making reports and visualizations. Previously, I was a Senior REDCap Database Administrator at Pfizer, where I implemented a research study protocol using the Redcap web application. I have strong skills in database design, SQL, VBA, data analysis, data management, and data visualization, and I am committed to delivering high-quality database solutions that meet the business and process requirements. I have excellent communication, analytical, and problem-solving skills, and collaboratively with the business customers and technology teams.

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.

Melvin Mel Phillips — Database & Information Management Analyst at Health Care Service Corporation in Evanston, IL, US | Unifers