SUMMARY:

• I have 17 plus experience Confidential SDLC and Release Management, Business Analysis (Requirement’s validation and verification), Solution Architecture Design & Development, Database Administration (SQL Programming) & Business Intelligence / EDI/ ETL
• CRM, Provider Insurance Services (Claims, Encounters), UCM, HIPAA EDI, HL7
• Medicare Part D, Medical prescription Drug, Clinical Management, Encounters
• Online & Trade Advisory
• Portal & Content Management, TOGAF, SOA, Big Data
• Entertainment / Telecommunications - CRM

TECHNICAL SKILLS:

Project Management: Waterfall, Agile Scrum and RUP

BI: ERWIN, ETL Design and Development, Crystal / access / Tableau / Oracle / SQL Server reports

Databases: sql server, oracle, mysql, db2, ibm ims

Server Platforms: IBM mainframe (Cobol), WebSphere (WAS, BPM, Portal Server, ESB & Process Server), Oracle

Architecture Frameworks: TOGAF, Zachman, SOA, SCA, BPEL, Hadoop

ERP: SAP Supply chain

Design & Modeling Tools: Rational Software Architect, Borland Together, MS Visio, UML, XML

PROFESSIONAL EXPERIENCE:

Confidential

IT Consultant

Responsibilities:

• Data modeling, ETL Design, CRM Architecture and Data Governance.
• IDM Report requirement analysis, Design and Development documentation.
• ETL automation with SSIS, IBM DataStage, Informatica 9.x on LA Data masking project analyzing hl7 EDI / ETL Files and Oracle/sql server databases
• OFFSHORE & Release Management

Confidential

Lead DB Programmer Analyst / Architect

Responsibilities:

• Confidential Data Analysis of Claims, encounters, member, pharmacy, vision, hl7 data of MEDICARE / MEDICAL from providers and Partners.
• Reviews, analyze LDAP and SOA Architecture, Data Model, design CRM architecture and Develop / Enhance Access Management and Automate, Healthcare Data systems / ETL Jobs which include Data Migration SQL Server/SSIS Oracle performance Tuning.
• Create MS Access / Tableau / Oracle reports for Various Departments such as Confidential, QNXT, NCQA, Providers Specialty etc.
• Collaborating with Various stakeholders (GDIT, Confidential, OPTUM) and align them Derive Business / Reporting requirements and relevant Design solution and Document them.
• Documentation of Technical Reqs, Lessons Learned and User guides.

Confidential

IT Consultant

Responsibilities:

• Define Business / System Detailed Reqs, analyze, data model and design SOA / SOAP - Restful API architecture.
• Data Analysis and conversion: Primarily migrate existing IBM IMS database (Data in EXCEL) and COBOL application (1 Menu/ Module out of 3)
• Manage the Project with GIT HUB / Visual studio 2015.
• Onsite / offshore Team Management 5 to 10 Engineers with JIRA and Technical Lead including EDI/ ETL Design, SQL / Performance Tuning.
• Reviews, analyze, and Design Healthcare Data ( Confidential, Claims, Member, encounters) systems ETL Jobs / Processes which include Data cleansing (Pervasive Tool for EDI), Migration and Transformation (SSIS, IBM DataStage) testing and SQL Server SQL Tuning.
• Deliverables Project performance status reports, SOPs, Issue log, change log, change requests, Technical Documentation.

Confidential, Los Angeles

ENTERPRISE Solution Architect

Responsibilities:

• Develop High Level & Detailed CRM Design Documents that consists of Conceptual Design (component Diagrams) and Architecture Models (Sequence, Class, Object interaction, Data flow diagrams)
• SOA / API (SOAP and RESTful) Gap Analysis between current and Target Architecture
• Data Analysis and Design Data Warehouse Conceptual / Logical Data Models
• BI / DWH ETL Design collaborating with BI Architects / SQL Developers developing Tableau and Cognos reports.
• Technical writing including Refining BRD, Functional specification, Weekly Status reports and other documentation
• Production support / Report Development and Performance Tuning Oracle/ Sql server Data Base

Confidential, Los Angeles

IT Subject Matter Expert / Solution Architect

Responsibilities:

• Interface stakeholders to derive requirements and document the solution design.
• Responsible for SOA Confidential Application (J2EE Websphere and Oracle) Performance and Root Cause Analysis.
• Collaborating with Vendors such as offshore Confidential Business Partners such as Confidential
• Resolve Production Priority issues with Remedy, QC and SharePoint.
• Documentation and analytical work to support the functional and reporting requirements of Confidential .
• Develop Daily and Weekly Proactive Findings/ Recommendations Report of Confidential Oracle DB and J2EE Application Analysis.
• Production Support Handling Performance related issues of Production Websphere J2EE Application and Oracle 10/11g Database. ETL IBM DataStage and BI report Development support and Documentation.

Confidential, Los Angeles

Sr IS Programmer Analyst / Information Systems Coordinator

Responsibilities:

• Adapted Waterfall, RUP Methodologies to Design multi-tier and CRM architecture
• Responding to Vendor RFPs, Monitoring SLA and Manage vendor consultants.
• SPOC to Group heads for service escalations, incident tracking & release management, migration and overall coordination around communications with Management
• Data modeling, Application Architecture design and Development of multi-tier applications
• Supervise and Mentor Development team 5 to 7 and Coordinate with various teams of 25 Senior Analysts, Programmers, Testers, Security, Operations and Vendor (IBM, Oracle) Consultants.
• Technical writing of Developing Clear case version control user manual, Project Plan and other documentation.
• Presenting the Product Demo’s and gain Buy-in to Business (other Dept units Executive Management).
• Develop and Maintain documentation including Network Diagrams using tools like Microsoft Project, Clarity, IBM Rational
• Single Sign on implementation with LDAP Integration of Confidential edirectory, MS Active Directory and IBM Tivoli
• Integration of hl7, Lotus notes, Cold Fusion Apps, JEE application Websphere, .NET apps and portlets.

Confidential, Los Angeles County

Consultant

Responsibilities:

• Developed Crystal Reports, programming with Oracle PL SQL Tuning, maintenance of web applications using Java Script & HTML and tuning Oracle SQL.