Ernest Brown Email & Phone Number

Jacksonville, Florida, United States

Jacksonville, Florida Area

Jacksonville, Florida Area

EXPERIS (CONTRACTOR TO BLUE CROSS BLUE SHIELD OF FL – JACKSONVILLE, FL )IT Consultant/Systems Analyst III (2010 – May 2012)Senior Systems Analyst for the EDW (Enterprise Data Warehouse) within Information Management. Responsibilities include evaluating project scope, analysis, leading requirement sessions, detail design, planning, testing and project implementations. • Provide project/production support for database structures and data• Provide leadership, direction and consultation to technical staff for system solutions• Lead JAD/JAR sessions and project meetings to for requirements and database designs• Work with the Data Architects and DBA’s in identifying existing and new attributes to be added for new database tables and modification to existing data models• Lead design meetings including code reviews with System subject matter experts• Prepare Detailed Design Documents including mapping and business rules for developer, map Data Mapping Rules (DMRs) into the Enterprise Metadata Environment (EME)• Assist in testing new or upgraded system solutions• Provide cost estimates for business partners based on current cost models• Design and create reports using OBI

Provide consultant management to several companies creating/designing database structures used for reporting purposes. Using MS Access and SQL Server for database creation and Crystal Reports for reporting. Designed processes and procedures to support new and updated reports/databases. Provide project support (business and technical) to ensure processes and programs are developed to company objectives.

Managed a staff of 12-16 IT professionals within IT department for system development and maintenance of claims processing systems. Provided front line leadership, coaching, defining clear roles, expectations and general direction to staff within IT department · Provided support for the Claims Repository (data warehouse) and Codes Repository, development for ITS Host/Home, FEP, NASCO and OPL claims processing systems· Directed technical construction and delivery of reporting and data services to business partners for Blue Cross Blue Shield Association, Federal Government and national accounts· Provided project management and participated in IT projects at all phases including requirements, analysis, design, coding, testing and implementation for project installations mandated by the Blue Cross Blue Shield Association, Federal Government and national accounts· Led requirement sessions with business units to translate business needs to IT requirements· Led staff in the Software Development Life Cycle (SDLC) using RUP, Summit, Six Sigma and project life cycle methodologies· Managed internal IT projects at all phases, including requirements, analysis, design, coding, testing and implementation· Managed / directed and assigned resources to projects and maintenance activities for reporting and data analytical analysis· Managed the day-to-day operational and tactical activities including Change Management, Problem Management and Incident Management processes and maintenance activities

Led a team of 5 IT professionals to develop and implement software projects within Information Management·Managed the development, conversion, and release of the Transaction Data Mart (TDM - Electronic Transactions) and Management Information System (MIS) using Hyperion Analyzer OLAP technology across multiple teams to several business units by building effective customer relations·Coordinated/conducted 10 training classes on the OLAP technology across the state of FL to business partners·Converted IM’s databases to use Codes Repository to satisfy new HIPAA requirements·Participating in several work groups representing IM to develop a reporting strategy between IM and Decision Support Operations and Availity transaction balancing·Provided communication to customers as a SME regarding delays, decisions and requirements for enhancements and improvements to current IM data structures, reports ·Created and updated MS Project plans using BCBSFL’s Project Management Methodology (PMM) for multiple projects within IM·Managed four to six team members in the analysis, design, development and testing of program, database (Oracle) and report changes for the Transaction Data Mart (TDM) for major releases ·Developed extract programs (C and SQL) and reports (IQ) for TDM·Managed workload design and development of reports to support Service Management activities using Crystal Reports and Excel

Provided leadership to four-member IT department for system development and maintenance of claims processing systems, company networks and overall IT support related activities. Responsible for approximately $800K in IS budgets and acquiring of computer hardware, operating systems and application software·Maintained existing managed care software including user support, product enhancements and / or modifications (HSD Diamond BBX) ·Managed the development and maintenance of all computer systems (IBM RS / 6000, Windows NT Server, PC’s, terminals), software, network hubs / routers (Cisco), LAN network modems·Performed AIX and Windows NT administration functions·Designed and developed the data processing / reporting activities using General and Access including creation of user defined reports, HEDIS reports and reporting for NCQA ·Developed and implemented IS request database / DSS system using Access, Visual Basic and SQL Server

Provided technical support for the design, development, maintenance and documentation for claims processing systems. Created application programs and developed reports for operational teams.·Maintained managed care software including product enhancements/modifications (HSD Diamond BBX) ·Managed accurate month end processing for FL, MO and VA plans·Created and designed user reports, HEDIS and NCQA reports (General, Access, and BBX programs)

Coordinated the network installations and implementations of provider management systems. Managed 200 network installations including loading system software, application and communication software·Designed and developed claims processing system for Medicare and Blue Cross Blue Shield claims ·Developed and implemented release of XENIX / UNIX / AIX communication software

Bs, Computer Science

Bachelor'S Degree, Computer Science