We provide IT Staff Augmentation Services!

Data Architect Resume Profile

3.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY

Analytical, business user oriented and innovative technical business systems advisor and data management lead with MBA and IT Master Degrees. Over 15 years of experience in Business Analysis, data analysis, developing and implementing innovative business processes and system solutions for healthcare, energy, e-commerce, manufacturing and finance organizations. Proficient in use case-driven RUP and Agile methodologies in healthcare software development lifecycle. Proficient in identifying business rules, preparing workflow process models, use cases, collaboration diagrams, concept of operations, testing scenarios and implementation guidelines. Demonstrated experience in healthcare data domains, master data management practices on data warehousing and data distribution, data quality, data governance and relational data modeling. Excellent at meeting deadlines and submitting deliverables on time.

PROFESSIONAL EXPERIENCE

Confidential

Technical Architect, Federal Information Management

  • Developed relationships with FDA 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
  • Led and instructed development team on infrastructure 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
  • Built and shared a knowledge base for FDA business processes and business needs with development team to enable team for faster delivery of solutions and addressing upcoming business needs more thoroughly / end to end from technical perspective.
  • Analyzed upcoming production operation problems data quality problems, process improvement needs, data model extension needs and their underlying 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
  • While developing solutions their level of efforts for FDA 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

Master Data Architect

  • 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 framework.
  • Analyzed the alignment between Medicare and Medicaid beneficiary data models, logical relationships and business rules impacting the unique identification of a beneficiary.
  • 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.
  • 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 procedures for functional design of enrollment payment system.
  • 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.
  • 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 9.0
  • 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 against state data.
  • Proposed areas MDM will support integrated data warehouse strategy including data quality management, business relevance, scalability, accessibility, transparency and governance in informatica MDM and Data Quality Center.
  • Experienced in creating and aligning solution architectures utilizing IBM Websphere application server, IBM MQ Series messaging processes and SOAP, 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 membership data reconciliation
  • Catered to end user inquiry requests by providing detailed analysis on core MDM building blocks

Confidential

Data Architect / Sr. Technical Advisor

  • Owned and driven the planning, tracking, scheduling, and releasing of medical claims, membership 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 membership 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 membership 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 data quality for membership and claim data.
  • Assisted with defining the claim and membership 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.

Confidential

Sr. Technical Business Systems Analyst / Core Systems Engineering

  • 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 accomplishments, milestones reached, pending decisions, risks and dependencies to support enterprise PMO processes and policies.

Confidential

Systems Analyst Advisor Sr. / Systems Delivery Healthcare Reform Implementation

  • Analyzed all reform provisions to define the functional and technical impacts to the existing membership eligibility,
  • medical claim adjudication and benefit administration systems.
  • Leveraged existing system architecture and data repositories to support new mandatory requirements
  • 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

Confidential

  • 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 shared technology 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.

Confidential

  • 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 Wellpoint 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

Confidential

  • Implemented a new hybrid line of business HSAPLUS across the CDHP portfolio and embedding last quarter carry over logic into claim adjudication after analyzing state mandate provisions
  • Prepared functional and technical requirements across all modules of enterprise CDHP claim adjudication system including benefit configuration dependencies based on the high level business requirements.
  • Conducted walk throughs to ensure accuracy, completeness and clarification of functional specifications with each module's SMEs and architects. eligibility, claim adjudication, benefit administration, member portal, call care browser for customer service, monthly health statements, pharmacy interface and datawarehouse extracts
  • Implemented of new business rule validations thru the eligibility data exchange process and identified decision points and resolution steps of error occuring cases.
  • Facilitated meetings to clarify key issues by use cases to come up with clear functional specifications across tracks.
  • Provided status periodically to project management office about these issues, risks and decisions needed and made.
  • Managed and communicated changes to the custom extract layouts for new line of business including datawarehouse extracts, eligibility extracts for financial vendors, pharmacy vendors, incentive program vendors and external clients.
  • Provided expertise of new line of business to the operations for effective and complete implementation across enterprise to support product launch processes and policies.

Confidential

  • Integrating LITES CDHP engine with Wellpoint source membership and claim systems.
  • Facilitated 2 recurring weekly meetings between IT teams of different wellpoint systems to prepare common file layouts to sync up different business processes of integration. Preparation of agenda items, facilitation of discussions, capturing and assignment of action items and follow ups for achievement of results
  • Performed mapping tasks for new file layouts to extract layouts of existing downstream systems.
  • Prepared business requirements document for different levels of integration including client, group, product, subscriber and contract eligibility including use cases, end to end syncronization of different data flows and main requirements for datawarehouse.
  • Wrote test cases for eligibility implementation, performed user acceptance testing, data mapping/validation testing.
  • Provided ongoing support for claims team from eligibility, accumulators and benefit design perspective for medical and rx claim adjudication.
  • Communicated directly with clients and client implementation managers to provide insight around CDHP benefit changes, impacts of HRA claims adjudication and downstream extracts.
  • Performed data mapping and validation testing for medical claims for different eligibility scenarios.
  • Provided weekly status for the project milestones, key issues risks, key decisions needed/made and key meetings for eligibility team.

Confidential

Analyst

  • Commuincated with internal and external team members developing accurate data and system flow model.
  • Gathered, analyzed data producing first of kind reports with historical anlaysis trends for client ultimatly resulting in successfull software implementation.

Confidential

Systems / Software Analyst

  • Conducted workflow and functional analysis providing process compatibility model.
  • Analyzed two ERP systems determining best overall system based on integration, cost and timing.

Confidential

Database Developer and Web Design

  • Conducted functional / content requirement walkthroughs, and of website company stakeholders.
  • Analyzed current process workflows designing effective relational database.

Confidential

Business Development Specialist

  • Analyzed workflows, business rules and web functions for Yahoo, AOL and Associated New Media Group.
  • Developed and configured colloboration models with e-retail clients for online shopping venue.

We'd love your feedback!