We provide IT Staff Augmentation Services!

Data Architect / Specialist Master Resume

Rosslyn, VA

PROFESSIONAL SUMMARY:

  • Over 19 years of experience managing, leading and executing on enterprise data management solutions at various commercial and federal clients.
  • Hands on experience in the data management lifecycle from initial business requirement analysis, translation to data requirements, and ultimately developing and implementing innovative business processes and data solutions for healthcare, energy, e - commerce, manufacturing and finance organizations.
  • Demonstrated experience in healthcare data domains, master data management, advanced analytics, data governance and data quality practices on data warehousing, data distribution and relational data modeling.
  • Demonstrated AI (Machine Learning and Deep Learning) experience on Phython and R platforms including model development, event simulation and knowledge of AI techniques to solve different business problems.
  • Proficient in identifying business rules, preparing workflow process models, predictive modeling, use cases, collaboration diagrams, concept of operations, testing scenarios and implementation guidelines.
  • Strong EDI technical & business background across SDLC with a focus on HealthCare Transactions, ANSI X12 standards and HIPAA Security Protocols.
  • Functioned as EDI X12 SME for number of healthcare organizations and and HIPAA 5010 Implementations.

PROFESSIONAL EXPERIENCE:

Confidential, Rosslyn, VA

Data Architect / Specialist Master

Responsibilities:

  • Currently creating future environment operating model and BI modernization roadmap for entire Confidential program. (SAS Visual Analytics Upgrade)
  • Defined, planned and coordinated key migration activities with technical team while transforming from on premise servers to MS Azure Cloud.
  • Designed and delivered the data warehousing solution in SAS Data Integrator for Medicare Advantage plan appeals and reconciliation on the Risk Adjustment Data Validation ( Confidential ) program for CMS, an annual BI $4.0M effort to support machine learning and predictive modeling activities.
  • Developed a unified reporting platform to help CMS with operational and analytical insights into a complex payment validation Review process under the Medicare Advantage Program (SAS as a technology platform).
  • Identified pilot use cases and their technology solutions utilizing IBM MDM to reduce provider enrollment burden on three specific areas: historical tracking of location changes, reassignment of benefits and ownership/controlling interest changes.
  • Prepared cloud based, flexible and scalable solution architecture proposals to support CMS’ current and future provider enrollment, encounter data and innovation model needs using the principles of Infrastructure, Software and Data as a service by using informatica data services and propagation.
  • Currently leading the MDM Community of Practice within the firm. Played SME role within multiple client engagements leveraging informatica MDM, IBM MDM and Reltio MDM to manage full lifecycle of shared data and integration with standards-based data services.
  • Successfully demonstrated proof of concept for predicting future cost of diabetes patients to Medicare program through medical claim payment calculation with machine learning. Used sparse matrix algorithms and trained them iteratively with historical claim data from multiple states. Demonstrated applicability of same methods to capture data anomalies on claims, risk adjustment for health risk and cost.
  • Played founding architect role on establishing Deloitte's cognitive analytics lab to shape up AI solutions/offerings, industry use cases and solutions, leading techniques, cognitive computing tools, Deloitte vendor and partner alliances.

Confidential

MDM Architect / Infrastructure Lead

Responsibilities:

  • Analyzed upcoming production operation problems (data quality problems, process improvement needs, data governance needs, data model extension needs) and their underlying design root causes. Provided advises around how to address these business requests and issues by translating the business need into technology implementation models with specific flows and technical implementation steps. (Understands Business to Technology Translation)
  • Re-designed facility master data domain logical model, match and merge process and publish layer based on the inspection management and user fee management specific business scenarios.
  • Prepared implementation roadmap options for domain re-design by decoupling architectural changes accordingly with business release schedule, resource availability and system decommissioning plans.
  • Created facility business & data process scenarios providing mapping of facility business events back to redesigned facility relational data model
  • Led and instructed development team on informatica MDM 9.7 and ETL Powercenter 9.6 upgrade project and addressing the roadblocks and other challenges relating to coordination with other parties (HP, Oracle) for obtaining the results timely as well as completing installation and configuration tasks on time. (Manages to Results)
  • Developed relationships with Confidential (client) stakeholders and decision makers to understand their expectations on outcomes from O&M team for ensuring client satisfaction. (Builds Relationships)
  • Teamed up with other Deloiite project teams on understanding the changes they are implementing to existing system design component by component as well as assigning an owner for the impact and timeline for addressing the impact. (Teams with Others)
  • While developing solutions their level of efforts for Confidential requests, communicated our business requirement assumptions, technical and data dependencies and implementation risks clearly and effectively for ensuring proper support from client, help client make decisions timely as well as establishing consensus between multiple parties involved while executing a change request. (Communicates Clearly & Effectively)

Confidential, Woodlawn, MD

Master Data Architect

Responsibilities:

  • Analyzed Medicaid data domains (Operations, Program, Performance, Quality) in detail to create process workflows and multi-tier requirements for analytical processing environment between MDM, Medicaid Data Environment (TMSIS) and States based on the MITA 3.0 framework.
  • Determined and proposed master data management integration points and methods with big data platform for sharing master data records with the hadoop distributed file system, as well as loading new profile information into the MDM system from big data sources for existing master records.
  • Created process workflows for consumer registration and initial enrollment processes on federal and state based exchanges, defined attribute level information exchange packages across multiple interfaces with states and issuers utilizing various X12 EDI transactions.
  • Oversaw the mapping of data sources, data movement, interfaces with the goal of ensuring data quality for person, application and policy data across marketplace.
  • Evaluated and modified data models and metadata policies and reconciliation procedures for functional design of marketplace enrollment payment system including aggregated X12 files for enrollment reconciliation.
  • Identified opportunities for master data index reuse, sharing and federation related platform initiatives.
  • Identified key data elements that defines the relationships between medicaid Beneficiaries, Programs, Providers, Health Plans and Claims for MDM.
  • Created master data quality management plan including master data quality dimensions and metrics, data process quality components including identification, cleansing and matching quality based on the data governance direction.
  • Proposed master data governance framework and work flow relationships between MDM and CMS data governance board.
  • Participated into workflow and algorithm design for Medicaid beneficiary identity resolution process in IBM Workbench 11.4
  • Provided subject matter expertise relating to transforming Medicaid beneficiary and provider data into MDM index database and design of medicaid beneficiary and provider profiles as part of Medicaid EMPI.
  • Determined the impacts of findings of Medicaid EMPI Pilot with states to MDM as it relates to matching performance and accuracy comparison between CMS enterprice cross referencing (ECR) systems vs. IBM initiate 11.4 against state data.
  • Proposed areas MDM will support integrated data warehouse strategy including data quality management, business relevance, scalability, accessibility, transparency and data governance in Informatica Data Quality Center.
  • Experienced in creating and aligning solution architectures utilizing IBM Websphere application server, IBM MQ processes, SOAP and RESTful webservices to ensure end to end solution will meet client expectations and comply with enterprise architecture standards.
  • Provided leadership and strategic guidance during the solution development process to ensure bridging of the gap between business problem faced by client and benefits available from infosphere solutions and services.
  • Created use cases on utilization of Initiate WorkBench & Inspector tool for data reconciliation
  • Catered to end user inquiry requests by providing detailed analysis on core MDM building blocks

Confidential, Arlington, VA

Data Architect / Sr. Technical Advisor

Responsibilities:

  • Owned and driven the planning, tracking, scheduling, and releasing of medical claims, and pharmacy claims datamart solution releases.
  • Worked with the various stakeholders and managing directors to plan, scope, and identify present and future datamart improvements for claims and facts and dimensions based on star schema.
  • Worked with MicroStrategy BI suite of tools that interfaced with SQL Server analysis services data and dimensions.
  • Worked with clinical analytics team to determine measurements, metrics, and facts for clinical performance measurement processes that determine the design of MicroStrategy reports. (Attributes, Filters, Metrics, Facts, Consolidation and Custom Groups)
  • Translated the various work items, dependencies, and information about available resources into an integrated project schedule
  • Participated the claims and data discovery process for new clients while building internal data intake standards.
  • Oversaw the mapping of data sources, data movement, interfaces with the goal of ensuring sufficient data quality and governance for and claim data.
  • Assisted with defining the claim and layout standards and interfaces that Evolent will propose to clients during implementation.
  • Assisted with defining standard data quality checks at appropriate stages to ensure that vendor data meets requirements for analytics and reporting.
  • Assisted with documenting client specific data mapping needs, transformation rules, and any business rules related intelligence.
  • Helped coordination of the data collection (FTP) and support analytics activities for specific clients to ensure timely delivery of the opportunity assessment, interfacing with the client, UPMC and the Evolent team.
  • Provided subject matter expertise to data analysis team on designing, monitoring and on HIPAA x12 transactions and EDI applications.

Confidential, Rockville, MD

Sr. Technical Business Systems Analyst

Responsibilities:

  • Conducted IT Systems Assessments, created Business Process Documentation for building a master data management system from ground up. Exhibited an attention to detail and excellent verbal/written communication skills.
  • Demonstrated ability to synthesize client master requirements into technical specifications and to generate functional and technical requirements documentation.
  • Led Joint Application Design (JAD sessions) for small groups of users to understand master data domain.
  • Acted as a liaison between application development, client services, finance and billing teams for a new client and contract master management system development project
  • Analyzed and captured existing functional, reporting, integration needs of business from master data and created business requirements document, vision and scope documentation for multiple releases. Conducted walk thru sessions and obtained project stake holders signoff.
  • Translated business requirements into their functional components thru wireframes and use cases.
  • Created non-functional requirements document containing information to support system functionality including scalability, user access management, security and usability. Obtained agreement and sign off from business stakeholders.
  • Defined reporting attributes for client services operations, finance & billing reports and datawarehouse client reporting needs for end to end view of master data thru enterprise.
  • Created requirements for custom client (sold case) object in Salesforce including picklists, field dependencies, and custom formula fields with validations.
  • Defined custom workflow rules and approval process based on the client master business requirements in Sales force that updates fields, send notifications as per approval steps and actions.
  • Determined process improvement opportunities within existing opportunity and client setup process and planned for functional and business flow implementation.
  • Defined integration requirements and created field & entity maps between Salesforce and Client master application thru Salesforce web service APIs.
  • Defined synchronization requirements for integration with multiple claim adjudication engines thru web services, host integrator tools.
  • Produced traceability matrices to ensure requirements are covered against functions, attributes, wireframes and test scenarios thru SDLC.
  • Created master test plan including testing objectives, testing level & strategy and test cases to support testing efforts.
  • Performed project management duties in planview to meet management expectations including project plan maintanence, monitoring of the consumption of total hours spent, activity progress tracking and reporting, internal and external dependency management.
  • Provided weekly project status reports including key s, milestones reached, pending decisions, risks and dependencies to support enterprise PMO processes and policies.
  • Served as EDI Subject Matter Expert for HIPAA version 5010 readiness and implementation for claims, eligibility and referral authorization transactions.

Confidential, Alexandria, VA

Systems Analyst Advisor

Responsibilities:

  • Analyzed all reform provisions to define the functional and technical impacts to the existing eligibility, medical claim adjudication and benefit administration systems.
  • Leveraged existing system architecture and data repositories to support new mandatory requirements including HIPAA 5010
  • Proposed updates to existing system functionalities and data repositories including benefit administration coding changes as necessary, to serve the key business needs of different stakeholders with careful consideration on upstream and downstream dependencies
  • Prepared high level solution overviews, impacts and technical requirements for group, benefit and enrollment functionalities of consumer driven health plans. (Removal of annual and lifetime limits provision for claim adjudication, Grandfathering of benefits)
  • Conducted process analysis and walkthroughs of technical changes with downstream and upstream system SMEs to ensure different all scenarios and conditions have been covered across integrated systems with use cases

Technical Business Systems Analyst

Confidential

Responsibilities:

  • Facilitated architectural assessment of member portal release 10 by external teams (DSI, Microsoft) leveraged knowledge of these teams to identify process improvement oppostunities. areas that can be improved; outlined the solution advices, determined impacted layers and prepared remediation plans in planview to manage execution.
  • Effectively processed TSB (Technology Steering Board) Requests submitted to Confidential solutions team, brought them into a closure by managing external dependencies. Exceled at day to day execution and process improvement.
  • Researched, found and facilitated technical solutions for these TSB requests which best fits the e-business objectives and team needs.
  • Articulated expectations of cross functional teams (MTM, CTO, TSB, OSB) from eBusiness domain to the development team, identified the changes needed in impacted areas to meet their process improvement needs and incorporated the related tasks into master project plan in planview.
  • Planned and facilitated end to end security assesment of new member portal by external teams (Microsoft and Internal Information Security Team). Acted as a bridge between development leads and security experts to review and understand the issues found and fixes needed. Prepared the remediation plan in planview and provided status to program management.
  • Prepared security guidelines in developing web applications to help prevent most of the known security risks under the supervision of security architects.
  • Prepared security enforcement flow including authorization steps thru each layer of MVC including content management system with application tech leads.
  • Managed a team of off-shore .NET developers and architects in the design and implementation of a two-tiered web-based test harness system that enables production support and MTM audit teams to validate member data being delivered to UI layer from source back end systems. Worked closely with MTM audit team to ensure meeting audit requirements.
  • Led gathering and assessment of environment configuration requirements from tech leads of multiple tiers for accomodating multi stream development of member portal across all environments from development to production fix.
  • Acted as a liasion between Microsoft and eBusiness development team for improving IIS and SQL server performance improvement initiative and adhoc basis technical support for issues involving Microsoft technologies.
  • Implementing a new incentive product line across all books of businesses with same level of flexibility and customizability on a consolidated centralized technical platform
  • Conducted walkthroughs with multiple teams to explain incentive benefits domain, current process analysis across systems, dependencies and growth and process improvement need comes with client migration.
  • Participated and and provided thought leadership in design discussions with architects, conveying knowledge of incentive rule and claim adjudication, process flows and timeframe realities.
  • Provided and created detailed process oriented flow charts for multiple different incentive process models.
  • Communicated pros & cons and operational impacts of different incentive processing models to the business, technical project management, channel leads.
  • Led meetings on high level design with product architects to develop new 360 health product benefit meta data model.
  • Developed technical solution approaches including incentive benefit administration and proposals across integrated Confidential systems to meet business needs and strategic goals within the project.
  • Facilitated discussions and organized gathering technical responses within system experts for the system specific implementation requirements documentation
  • Worked in conjunction with enterprise integration services (EIS) for realtime communication of benefit and eligibility information across source systems, rules engine, incentive vendors and disbursement systems.
  • Identified eligibility and benefit data elements necessary for each system to perform assigned process workflows
  • Worked with information architects for enterprise level common file layouts and benefit and claim data definitions

Hire Now