SUMMARY:

• 15 years Technical & Management experience coupled with strong education and training in software industry including architecting and leading major Healthcare IT.
• Master Data Management Architect for PRODUCT, VENDOR and CUSTOMER databases.
• Patent on my design to filter claims for ACS EDI Clearinghouse commercial product STEP - UP.
• Leading and Managing teams through developing conceptual and technical designs, including the use of object-oriented analysis and design techniques for healthcare claims.
• Master Data Architect for State Medicaid Record Layout of Healthcare data.
• Created Golden Record for multiple databases as well as mappings from multiple data sources.
• Implemented Customer Data Integration for various State Medicaid functions.
• Implemented SOA architecture and re-engineered a legacy application to multi-platform solution saving millions in hardware and software maintenance.
• Created Business Process Models using IBM’s Websphere Business Modeler Advanced.
• Expertise in managing and delivering components that identify, design, and implement creative technology business solutions for large companies.
• Create, edit and update Physical Data Models using Erwin following corporate naming conventions.
• Perform Data Modeling, Process Modeling, Master Data Management and data warehousing.
• Designed multiple Infocubes providing data for reporting by various functional groups.
• Publish Data models to various environments including DEV, TEST, UAT and PROD.
• Implemented and managed HIPAA transactions 837 Institutional, Professional & Dental, 835 Remits, 270-271, 276-277, 278, 834, 820, 997 and proprietary acknowledgment.
• Active participation in staff recruitment, retention and team building activities.
• Monitored daily claim volume reports along with dollar values and prepare trend analysis of claim volumes.
• Conduct JAD sessions and gather requirements for application development.
• Experience in managing production operations for 24/7 live environment.
• Manage multiple teams for continued customer satisfaction through successful upgrades.
• Leading system performance diagnosis and scalability assessment activities. Coordinates and manages activities of multiple hardware and software vendors (including IBM, Sterling Commerce, Webmethods, Sybase & Mercator) on large project engagement.
• Multi platform multi format integration, design, Implementation & Refactoring of architecture.
• Demonstrated problem-solving and trouble shooting skills.
• Strong UNIX Shell scripting skills including Korn shell, Sed, Awk & Perl.
• Data Architect, Data Modeler and Database Administrator for OLAP & OLTP systems.
• Data Modeling and Design using ERStudio, ERWin and Microsoft Visio.
• Leading system design activities or reviews system designs to ensure that applications solutions will exhibit high levels of performance, security, scalability, maintainability, appropriate re-usability and reliability upon deployment.
• Extensive experience in Architecting, managing and leading healthcare IT solution development.
• Extensive work in Dimensional Modeling, DataWarehousing, BI and Master Data Management.
• Over 6+ years of DB2 UDB DBA & DB group manager: Installed & Configured UDB 7.2 / 8.1 on AIX PSeries Servers, WebSphere Application Server on Linux and Information Server on Linux.
• Extensive Performance Tuning of Application, Data Architecture, Data Modeling, ETL & Design.
• Experience in following EDI transactions: 834, 835, 837I/P/D, 270-271, 276-277, 277U, 278, 810,850,856 & 811.
• Over 10+ years of managing AIX & Windows servers, Storage maintenance, backup, HADR and disaster readiness with Archive & Retrieval of X12 data and compliance for SOX.
• Implementation of Service Oriented Architecture and migration of legacy application to Midrange Servers.
• Written unix scripts using vi, awk, sed and regular expressions to format COBC files from CMS.
• Performed data warehousing, ETL, data modeling, Customer Data Integration and process modeling
• Over 10+ years leading EDI / Siperian, DataStage, Websphere TX and DB2, Oracle, SQL Server experience and implementing innovative solutions.

TECHNICAL SKILLS:

Operating Systems: AIX 5.3/5.2/4.3, OS/390, MVS, WINDOWS 98/NT/2000/XP, Linux

Programming Languages: JAVA, C, COBOL, ABAP/4, PASCAL, HTML, JCL, SED, AWK

Databases: DB2 UDB, DB2, Oracle, SQLServer, MYSQL, MSAccess

SQL Languages: SQL, PL/SQL, SQR, TSQL

Business Intelligence: Business Objects & Crystal Reports

Utilities and Tools: Siperian MRM Hub, Websphere WTX, DataStage, QualityStage, Information Analyzer, Exceros Discovery, MSPROJECT, MSVISIO, ERWin, ERStudio, RUMBA, Smartftp, XMLSPY, VI, SMIT, Lotus Notes, SmartDBA Cockpit, Websphere Integration Suite, IBM Websphere Modeler Advanced, Connect Direct, SAP SD, BIW, CICS, MQSeries, Websphere Information Server and Websphere Application Server.

EXPERTISE

• Master Data Management on Vendor, Customer and Products Databases.
• Merge, Cleanse, Extract, Transfer and load from multiple Vendor databases.
• Install, Configure and Implement following tools: Siperian Hub Server, Cleanse Match Server, Hub Store, DataStage, QualityStage, InfoAnalyzer and IBM Information Server.
• Create DataStage Jobs for Aggregation, Conversion, Cleansing, Enrichment, Normalizing and pivoting of data.
• Prepare education of Master Data Management concepts for entire department.
• Create Master Data Models in ERWin for Golden record of Vendor and Products DB.
• Configure Match and Merge Link Processes for Vendor and Products DBs.
• Load Master data to Siperian MDM Hub and defined lookups.
• Performed data cleansing using address doctor, QualityStage and created cleanse lists.
• Created graph functions, trust rules, validation rules and cell updates.
• Define Data Model and relationships between data model elements.
• Created Batch data Process Flow, Landing Tables, Staging Tables and Base Objects.
• Created Queries, Packages and user exit points in data process flow.
• Systems Architect with patent on designed components.
• Designed and Implemented Master Data Solution for Healthcare claims & Remits.
• Designed & Implemented SOX Compliance for EDI Gateway Clearing house application.
• Designed, Implemented and Managed an end-to-end Balancing System
• Designed, Implemented and Managed a entry-to-exit file/batch/claim Tracking System
• Designed Trading Partner Validation Module (TPVM) and removed Mercator's Commerce Manager saving hundreds of thousands of dollars each year in licensing.
• Created Business Process models and component models.
• Created Golden Records and performed MDM mappings, trust validations and data loads.