SUMMARY:

• Business - to-Business Marketing/New-Market Entry Strategy Account Management, CRM Implementation and Market Communications Management.
• Building relationships/networks and value-based engagements between firms and professionals from C-level to focused specialists.
• Forecasting, Scheduling, coordinated weekly and quarterly supply plans and reviews.
• Devised marketing program, new value propositions, developed and submitted Request-for-Proposals and reorganized distribution channels.
• Conducted requirement gathering, developed strategy for customer data integration, led project teams for Master Data Management (MDM), Data Warehouse and Business Intelligence Reporting implementations.
• Budgeting, Forecasting, development of quarterly operating plans, Revenue Planning, Account Management for AP/AR and deal structuring.
• Compiling CRM and market data to identify top market segments, prospecting customers for new product as well as new market.

PROFESSIONAL EXPERIENCE:

MDM Architect

Confidential, Sacramento, CA

Responsibilities:

• Gathered business requirements, and translated into technical solution requirements to implement on Confidential MDM v11.5 SE.
• Educated & Socialized roles and responsibilities with Data Governance, Data Quality and Data Stewardship teams during the various pre & post implementation phases of project.
• Worked with Confidential team to help install & document MDM application on non-production server.
• Documented existing and to-be business processes and work flows for legacy data sources as well as downstream consuming systems.
• Created & presented MDM Architecture and Integration Design deliverable for Confidential MDM v11.5 SE.
• Designed for multiple MDM Domains relating to Provider, Account & Customer/Patient data.
• Led architecture and development activities to fully utilize the Confidential ecosystem - Data Profiling (Information Analyzer), Data Quality (QualityStage), Data Integration (DataStage), Data Governance (Governance Catalog).
• Gathered match algorithm & survivorship/golden-record (via Composite Views) requirements for Provider Domain.

Confidential, Sacramento, CA

Responsibilities:

• Leveraged Party domain Confidential model for Confidential MDM and extended to accommodate provider domain requirements.
• Socialized new data model with Business leadership as well as Enterprise Architecture team.
• Re-designed pME matching algorithms for Confidential MDM provider implementation.
• Conducted Weights & Threshold configuration as well as sample-pair testing with the business team to ensure meeting business requirements.
• Designed end-to-end architecture for MDM migration, to include batch integration as well as real-time services being designed for downstream and portal consumers.
• Validated, Optimized & Automated Bulk Cross-match (BXM) process for ACO & Anthem HL7 files on existing Confidential Initiate v9.1 platform.
• Initiated effort to deploy monitoring tools on MDM server, as well as all MDM real-time services.
• Enhanced existing Confidential Initiate Provider Hub to consume Social Security Admin (SSA) & California Dept of Health (CDH) death index files, along with Advanced Illness Management (AIM) as additional data source.
• Designed, developed & implemented a standardized file format to be used for all inbound data sources.
• Participated in daily SCRUM meetings to receive updates and identify road-blocks for technical & business teams.
• Contributed design ideas for a parallel Informatica MDM upgrade from v9.5 to 10.1.

Confidential, Salt Lake City, UT

Responsibilities:

• Participated in proof of concept for Confidential MDM Advanced Edition v11.5 implementation.
• Extended & socialized Confidential Party data model to accommodate requirements from Banking, Corporate Card Lines, Mortgage business units and Customer Service Centers for IVR systems.
• Gathered pME match algorithms requirements for person and organization entities, and incorporated survivorship rules as defined by the various business units.
• Designed decommission plan with help from EA team, to identify end-of-life application systems and data cutover targets.
• Identified and designed batch as well as real-time integration scenarios for various legacy and downstream systems.
• Designed Confidential MDM real-time services structure to accommodate business needs for Customer Portal requirements.

Confidential, Scottsdale, AZ

Responsibilities:

• Designed for MDM Provider Comp Hub on Confidential MDM Advanced Edition v11.4.
• Leveraged Party domain Confidential model and extended to accommodate provider compensation project requirements.
• Socialized the designed data model with Business Delivery Executive, Business Development & Marketing teams as well as Data Management & Enterprise Architecture team.
• Gathered pME match algorithms requirements for person and organization entities, and incorporated survivorship rules as defined by the business.
• Conducted Weights & Threshold configuration as well as sample-pair testing with the business team to ensure meeting business requirements.
• Designed end-to-end architecture to include one-time batch integration from legacy sources, point-to-point integration with Confidential BPM for future data authoring, as well as various downstream consumers using real-time services.

Confidential, San Francisco, CA

Responsibilities:

• Enhanced MDM Confidential data model with data table additions & extensions to meet Confidential ‘s requirements.
• Created Probabilistic Algorithm for individual entities for matching and linking purposes.
• Configured Weights & Threshold to match Confidential requirements and minimize manual suspect tasks.
• Designed end-to-end architecture to include batch integration for multiple source systems, Netezza platform and MDM.

Confidential, Washington, DC

Responsibilities:

• Led multiple teams & work effort on design, development and implementation of MDM Hubs including Securities, Party, Property, Reference, Loans & Products using Informatica 9.7 MDM platform.
• Created additional domains to address single-family & multi-family businesses and integrated them with external vendor applications like Profit & Trade Center alongside Dun & Bradstreet, Blackrock, Bloomberg for the Mortgage Backed Securities business.
• Instrumented an upgrade from Informatica MDM 9.5 to Informatica MDM 9.7.
• Participated in enterprise workshop for Agile training, and implemented Agile Kanban & SAFE for the MDM teams.
• Addressed performance concerns and helped alleviate key performance statistics to help meet SLAs.
• Designed architecture to transition from batch oriented processing to real-time services (SIF), while aligning with enterprise architecture framework EDA 5.0.
• Presented architecture strategy for new MDM Domains and transition plan for existing MDM processes to the Architecture Review Board for approval & budgeting.
• Integrated MDM with Siebel CRM, Integrated Data Store (IDS) & Enterprise Data Warehouse (EDW) on Confidential Netezza appliance.
• Helped Data Governance team with Metadata Management, Data Standardization, Data Quality rules as well as Reference Data Management strategy.

Confidential, San Francisco, CA

Responsibilities:

• Coordinated across teams to complete development, testing and deployment of Provider hub into production.
• Developed MDM strategy and roadmap to integrate with the overall enterprise architecture.
• Led workshops with IT SMEs to capture current process and sources of records in design and implement changes to business policies, and procedures.
• Led proof of concept activity, (with vendors for SAP MDG, Oracle PDH, Informatica MDM & Confidential MDM), to help identify a suitable MDM application for data-mastering and customer 360 view for the enterprise.
• Captured existing business processes and performed GAP analysis for Product, Customer and Location domains.
• Helped Data Governance team design and implement processes, standards, KPIs & metrics to help monitor and analyze data quality.

Confidential, Phoenix, AZ

Responsibilities:

• Coordinated across teams to complete development, testing and deployment of Provider hub into production.
• Led proof of concept effort to help identify a suitable MDM application for next-gen data-mastering and customer 360 view for the enterprise.
• Conducted GAP analysis for upgrade from current Confidential Initiate 9.2 platform to Confidential 11.1 AE Hybrid.
• Designed 3-year strategy and roadmap for MDM implementation and presented to EDG (executive decision group) for budget, resourcing and planning approval.
• Developed integration architecture for Initiate MDS with CRM (SFDC) cloud at partner clubs both for real-time service calls and ETL batch jobs.
• Worked with data-stewards to set guidelines and benchmarks for resolving linkage and duplicate tasks in Initiate hub as well as develop an enterprise error framework.
• Helped business partners to develop process & data standards for newly set up data governance organization.
• Designed Party Domain data model for Confidential v11 MDM to socialize with Confidential & Confidential data model teams.
• Developed additional future domains for Claimants, Agents and Prospects data from across the organization and merge with the organization’s overall Big Data strategy.
• Designed process and architecture to integrate future MDM with 3rd party systems like Merkle and LexisNexis and perform data-enrichment in the hub.

Confidential, Sacramento, CA

Responsibilities:

• Coordinated across teams to complete development, testing and deployment of Provider hub into production.
• Designed outbound integration architecture for MDM Provider Hub to down-stream systems of EPIC and SFDC as well as Flat File extracts for Confidential .
• Led Project Discovery for real-time integration between MDM and EPIC eHR system.
• Conducted GAP Analysis and integration options, including a hybrid approach to integrate with EDW as well as MDM using eGATE interface.
• Budgeted for project implementation costs, including expected number of project hours and resources needed both for technical as well as business IS teams.
• Participated in Proof of Concept for ICD 9 to ICD 10 crosswalk solutions and presented recommendation to purchase and implement the Informatica-Highpoint Solutions crosswalk product.
• Supported data modeling effort for i4 & i5 releases on the data-warehouse project and maintained release management in conjunction with MDM releases.
• Designed architecture and strategy roadmap to implement Informatica MDM as enterprise solution for People & Place Hubs, as well as timeline for migrating Patient & Provider Hubs from Confidential Initiate to Informatica MDM.
• Presented Data Quality & Data Governance guidelines and recommendations to the newly established Data Governance committee.

Confidential, Houston, TX

Architect/Technical Lead

Responsibilities:

• Managed MDM Technical and Data Governance teams along with activities for integrating data while managing and enhancing quality on Informatica MDM platform.
• Socialized with Senior Leadership team (SLT) on project activities ranging from task & resource planning, to major milestones, and project financials.
• Led design, development and production support activities for 5 Hubs in production, and 2 new Hubs under development.
• Performed impact analysis for integrating customer data from SalesForce.com and Siebel interfaces into the new Hub.
• Deployed new MDM Hub for WM SITEs in conjunction with user interface on Informatica BDD application.
• Implemented design to integrate email validation processes from ExactTarget.
• Performed data-enrichment in MDM Customer Hub with bi-weekly updates from Dun & BradStreet, while also implementing customer file as Prospect data-mart on Confidential Netezza appliance.
• Worked with business team to design Trust and Validation framework to ensure the best quality for the golden copy of customer data.
• Co-ordinated with database, unix and websphere teams along with enterprise architects to purchase & implement infrastructure for Disaster Recovery and POD.
• Mediated the conversations between in-house technical team and Informatica support for escalating bug-fixes and implementing hot-fixes.

Technical Lead

Confidential, Milwaukee, WI

Responsibilities:

• Responsible for GAP Analysis to help identify current and proposed structure of MDM system.
• Led meetings with business clients to identify expectations for the customer data integration effort.
• Delivered presentations to distributor services & marketing division of businesses in effort to promote advantages of customer data integration and business impacts.
• Performed task, resource & systems analysis to aide re-planning and re-organization efforts within the Business Information Systems (BIS) group.
• Analyzed existing business systems reports and helped create new reports focusing on customer penetration and product catalogue to aide business in decision making.
• Performed data analysis to help design data conversion procedure for moving data from SAP MDM to Teradata MDM application.
• Co-ordinated with Teradata design team, business users, as well as off-shore technical development team to establish user-interface designs and set data-standards.
• Participated in platform re-assessment effort under the new senior leadership team to prepare and present cost-benefit analysis for the client.

Sr. Systems Analyst

Confidential, Erie, PA

Responsibilities:

• Responsible for GAP Analysis to help identify current and purpose and structure of MDM system.
• Led effort for gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the senior management.
• Designed and Planned the work-breakdown structure as well as schedule/milestones for ETL development and testing teams.
• Conducted data-profiling on 3rd party data to identify match-merge scenarios & rules and also differentiate to flag customers from prospects.
• Participated as member of Data-Modeling team to create models for MDM, ODS & the Data-Warehouse, as well as aide in designing the star schema for Business Objects & WebFocus reporting.
• Designed services and business objects in the XMLs to extract data from legacy systems and direct them to appropriate MDM tables.
• Led 4 member ETL team towards designing and development of extraction mappings for Inbound source to MDM and then Outbound MDM to consuming systems using DataStage 7.5.2 & 8.0.
• Led ETL team to convert ETL jobs from DataStage 8.0 to Informatica PowerCenter 8.6.1.
• Led 3 member BI Team to develop business objects reports to fulfill the reporting requirements for Marketing Intelligence, along with Personal, Commercial & Life lines of business.
• Helped integrate and synchronize geo-spatial data between business objects, MarketScope and SalesForce data-systems.

Confidential

Analyst, MDM & Business-Intelligence

Responsibilities:

• Responsible for GAP Analysis to help identify current & proposed states of MDM implementation.
• Led effort for gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the senior management.
• Designed and Planned the work-breakdown structure as well as schedule/milestones for ETL development and testing teams.
• Conducted data-profiling on 3rd party data to identify match-merge scenarios & rules and also differentiate to flag customers from prospects.
• Participated as member of Data-Modeling team to create models for MDM, ODS & the Data-warehouse, as well as aide in designing the star schema for Business Objects reporting and iDashboard.
• Worked along with Confidential /Perficient development team to validate Data Stage mappings and Metadata Management.
• Designed services and business objects in the XMLs to extract data from legacy systems and direct them to appropriate MDM tables.
• Participated in Business Objects upgrade from XIR2 to XIR3 and validation of universes, user profiles as well as existing reports & objects.

Confidential

Systems Analyst

Responsibilities:

• Performed GAP analysis and impact analysis of states of data between the current application and proposed application, and prepared project estimations.
• Converted functional specifications into technical specifications by creating DFDs through MS Visio for proof-of-concept.
• Reviewed promotion document, identified missing components & prepared production checklist to migrate application to production environment.
• Responsible for complete data modeling design using ERwin Data modeler to be utilized in ETL development using Teradata, Oracle and Informatica.
• Identified Facts, Dimensions and Hierarchies for Dimensional Modeling and designed universes for Business Objects v6.5.
• Wrote test plans for Business Intelligence reports, Unit & Integration testing.
• Developed External PL/SQL packages, Procedures, and functions to fill gaps where ETL design is not supported by Oracle and Informatica.
• Involved in migration from Informatica 7.1.4 to 8.1.1 SP3 and integrating with IMS mainframes for Confidential .

Confidential, Newport Beach, CA

Business Development Manager

Responsibilities:

• Developed Los Angeles Confidential Authority as clients for implementing their SAP based Payroll and HR solutions.
• Account Manager for implementing data integration solution and standardization on a single platform using Informatica Powercenter and PowerExchange for agency wide data access at Chicago Transport Authority.
• Implemented strategy to increase account manager headcount for more competitive recruitment and management of IT consultants on H-1b work authorization.