Technical Project Manager Advisor Resume
Boston, MA
SUMMARY
- A business, growth and strategy - driven Chief Enterprise Architect and Project Manager for Master Data Management (MDM), data quality, data integration, data warehousing, business intelligence, and analytic initiatives. Innovates, discovers, invests, empowers and transforms the way businesses make executive decisions. Designs cross-organizational enterprise architecture solutions that involve business, technology, processes and information changes to meet the business goals.
- Collaborates with sales, marketing, finance and IT executives to ensure that business goals and IT solutions are aligned. Fosters, promotes, and develops governance policies, data stewardship, business processes, and standardization to increase sales revenues, boost cross-selling and up-selling, increase marketing campaign effectiveness, improve profitability, decrease operational cost, expedite new product or service launch, and comply with regulations.
- A Trusted Advisor with more than fifteen years of achievements of providing guidance, overall direction, implementing architecture strategies, coaching and mentoring team members, and setting up short-term goals to meet the long-term vision of the company.
- A proven Thought Leader with the ability to lead medium to large Enterprise, MDM, Data Quality, Data Governance, Data Warehouse, Business Intelligence engagements, conduct discovery meetings with stakeholders, comprehend complex business requirements, define detail project plans, identify master entities and data source providers, define data quality approaches, and apply deep knowledge of best practices, methodologies and advanced concepts.
PROFESSIONAL EXPERIENCE
Confidential
Role: Informatica MDM Engagement Advisor, Chief Informatica MDM Architect, Technical Project Manager Advisor, Data Governance and Data Stewardship Adviser, Lead Data Modeler
Responsibilities:
- As an Informatica MDM Engagement Advisor and an MDM SME providing expert advice and ensuring that the business requirements and the MDM solution are aligned and developed in accordance with the industry and Informatica MDM best practices
- Establishing and promoting data governance and data stewardship council
- Providing guidance, overall direction, implementing MDM strategies, coaching and mentoring team members
- As a Technical Project Manager Advisor initiating overall MDM project management based on Informatica Velocity and mentoring project managers with best practices
- Leading Infrastructure and architecture planning for selecting core MDM components such as MDM Hub Master, ORS, hub Server, Process Server, Resource Kit, IDD, Informatica Platform, and ActiveVOS,
- Heading logical and physical data modeling sessions with data stewards, business executives, IT leads and project managers
- Spearheading topology planning for standalone application sever versus application server cluster topology
- Facilitating licensing and production directional meetings with IT team and Informatica Corporation
- Directing installation and deployment objectives based on High Availability, Scalability, Load Balancing and Maintainability
- Leading installation of Informatica MDM 10.2 HF1 EBF 3 that includes installation of MDM hub store, hub server, process server, and ActiveVOS
- Leading the configuration of MDM Hub Console Operational Reference Stores (ORS), and building the schema/creating the main base objects and lookup base objects
- Supporting setting up the IDQ/Informatica Platform to load data directly from the source to the MDM Hub staging tables; skipping the landing tables
- Setting Trust and Validation Rules, Match and Merge Rules
- Leading custom error handling strategy, restartability process and command line execution for auto-scheduling
- Performing data profiling for understanding the source data for fine tuning the data models, matching rules, and creating reference tables
- Configuring Informatica Data Director (IDD)
- Building IDD subject area, relationships, menus and custom search queries
Confidential
Role: VP/Enterprise Architect
Responsibilities:
- Streamlining overall enterprise architecture of a banking reconciliation product for key business sectors such as retail and commercial banks, capital markets, credit card processors and regulators. Aligning business strategies with the reconciliation modules including ATM, credit & debit card processors, and Nostro & Vostro accounts. Reworked the overall reconciliation lifecycle with clearly defined business sectors, data sources, reconciliation processes, and reconciliation benefits for the business sectors.
Confidential, Boston, MA
Role: Pre Sales, Training and Certification - Master Data Management (MDM), Data Governance, Data Quality, Data Modeling
Responsibilities:
- As a part of the Informatica MDM Admin and Configuration certification performed:
- Informatica Master Data Management installation and upgrade process
- Identify the components of Master Data Management Hub Architecture
- Master Data Management Hub Administration tasks
- Party data model
- IDD/Data Governance Policies and Profiles
- Troubleshooting and performance tuning of batch processes
- As a part of the Informatica Data Quality Specialist certification performed:
- Data Quality processes from Profiling to Standardization, Matching and Consolidation
- Select and configure Data Quality transformations tools
- Build, debug and execute Data Quality mappings
- Integrate Data Quality mappings into Power Center and Microsoft Excel
Confidential, Boston, MA
Roles: MDM Project Manager, Informatica MDM Architect, Senior Business Analyst
Responsibilities:
- Managing and Transforming an MDM implementation to serve broader business functions including sales and compliance.
- Leading the MDM initiative to provide the best version of the truth, enable 360 degree view of healthcare providers, and support spend analysis, contracting, and compliance regulations. Managing project, reporting weekly status to senior management, developing master project plans, managing risk and issues, estimating and analyzing schedules, engaging senior business executives to collaborate, and leading MDM developers for loading critical business data from Alanda, Veeva/Vista, Specialty Pharma (ISPP), MedPro, Cegedim, Invoke, and Concur to MDM Hub, while defining trust validation, match and merge rules. Involved in Data Quality Scorecard definition.
Confidential, Boston, MA
Roles: Chief Solution Architect, MDM SME, Data Modeling, Data warehouse and BI Lead
Responsibilities:
- Lead for responding to RFP, solution feasibility, and technical architecture overview of MDM, data warehousing, data quality and business intelligence initiatives. Presented solutions to clients to address data governance, data stewardship, data profiling, and six components of data quality including Completeness, Conformity, Consistency, Accuracy, Uniqueness/De-duplication and Integrity.
Confidential, Boston, MA
Roles: MDM Business Service Layer Functional Lead, MDM Test Lead, Enterprise Data Management Project Manager, Planning Data Conversion Lead, Lead Business Analyst
Responsibilities:
- Part of a core multimillion dollar Planning solution team for delivering system and business capabilities through MDM and EDW. This solution is needed to accelerate business growth and enable future planning. Working on multiple highly visible initiatives including Oracle MDM - SiteHub and Oracle DRM, data conversion, data validation and MDM testing.
Confidential
Roles: Pre Sales Solution Architect, Lead Generation, Lead Management with Salesforce.com, MDM SME
Responsibilities:
- Lead generation, lead nurturing using Salesforce and Marketing Automation for Informatica MDM including IDS, and Hierarchy Manager, data quality, data warehouse and business intelligence solutions.
Confidential, Boston, MA
Roles: Project Management, MDM/DW/ETL Architect, Senior Data Modeler, Lead Business Analyst, Report Lead
Responsibilities:
- Defined, enhanced, and excelled UMass/EHS/New Medicaid Management Information System (MMIS) ETL and reporting architecture for the Third Party Liability (TPL) function of Masshealth to provide capabilities to manage the private health, Medicare, and other third-party resources of Medicaid members, and ensure that Medicaid is the payor of last resort. This function works with a combination of cost avoidance and cost recovery (post-payment billing to insurers). Continued with developing best practices for MS Business Intelligence stack including SQL Server SSIS, SSRS, and SSAS.
Confidential, Boston, MA
Roles: Management Advisor, State of Mass Steering Committee, Senior Data Modeler, Project Management
Responsibilities:
- Steered Massachusetts State’s Medicaid/Healthcare office to recognition as one of the nation’s most sophisticated Medicaid offices by leading, co-managing and implementing a multi-million, state-wide, ambitious, and expansive State’s Analytics Unit project for the Massachusetts Medicaid Office and University of Massachusetts. Providing leadership as a Senior Project Director, Steering Committee member, and Management Advisor. Collaborated, evaluated and conceived best practices for Master Data Management, Data Models, ETL, Database Design, Data Governance and Data Architecture for the state-wide healthcare data. Continued with developing best practices for MS Business Intelligence stack including SQL Server SSIS, SSRS, and SSAS.
Confidential, Boston, MA
Roles: Project Management, MDM/DW Architect, Senior Data Modeler, ETL Lead, Lead Business Analyst, Tableau Report Lead
Responsibilities:
- Furnished an analytical solution for business users and executive dashboard using Tableau software for senior management at University of Massachusetts/Masshealth Medicaid Office through a ground-breaking architecture for state/government Healthcare agencies. Directed, managed and designed a universal healthcare claim MDM analytical model based on HL7 RIM, MSIS, MMIS, PHCDM and MITA that streamlined the analysis of medical claims conforming to HIPAA compliance and helped to develop the logic for Family Planning Reimbursement program for more than $8 Million in revenue from the federal/CMS agency. Evaluated and participated SOA for the ODS data accessibility. Designed, demonstrated and developed best practices for MS ETL using Oracle, SQL Server SSIS, SSRS, and SSAS. Reviewed and recommended optimization for source data for Business Objects reports, developed and delivered OLAP reports using MS ProClarity, PerformancePoint and Sharepoint.
Confidential
Role: MDM Solution - Pre Sales, Lead Generation, Lead Management
Responsibilities:
- Worked on fulfilling/responding to business requirements from prospects, lead generation through salesforce.com, preparing for business workshops, project kickoffs, conceptual and logical data models, data warehouse assessments, MDM initiatives, data profiling and data quality workshops using Informatica Data Explorer and Informatica Data Quality.
Confidential, Boston, MA
Role: Program/Project Manager, MDM/DW Architect, Technical Advisor
Responsibilities:
- Worked as a Senior Program Manager/Senior Project Manager to manage and implement data migration, data integration, pre Master Data Management and data warehousing initiatives. Provided comprehensive roadmap, best-practices, high level conceptual data model, strategic project plan, resource plan and cost analysis for budgeting purposes. Provided feedback for technical evaluation of Informatica PowerCenter 8.5, Informatica Data Explorer and Informatica Data Quality.