OBJECTIVE:

• A long - term position that will allow me to utilize my knowledge and experience in Enterprise Data Architecture, Data Modeling, ETL, Master Data Management (MDM), Data Warehouse (DW), Meta-Data Repositories, Data Governance

PROFESSIONAL EXPERIENCE:

Confidential

BI and MDM Architect

Responsibilities:

• Designed and implemented from inception to full production a new BI and MDM product Pipeline Activator.
• Solution covered IDG content subscribers and sales leads and integrated data from various internal and external sources such as IDG Subscription database, LinkedIn, Dun & Bradstreet, ORACLE Eloqua, Aberdeen and other third party providers. Master Data has been created for Person and Company records across the sources and multi-terabyte Data Warehouse for the web activity of the target person’s allowed to produce high-quality sales leads.
• Selected technology, designed solution architecture and established infrastructure on the Cloud, optimizing costs and performance (Amazon Cloud)
• Designed MDM and DW data models and created databases on the Cloud (Amazon Redshift DB, Embarcadero ER/Studio)
• Specified and implemented ETL and ELT processes for all feeds (SnapLogic EAI on Amazon Cloud)
• Implemented MDM matching and data retention algorithms utilizing SQL stored procedures and scripting.
• Created specifications for GUI and BI and supervised development in this area.
• Utilized Tableau to analyze and present to the third-party subscribers business summary data, including spatial data of marketing opportunities.

Confidential

Data and Solution Architect - IT Consultant

Responsibilities:

• Developed Master Data Management framework for population data and data warehouse bus architecture to facilitate data analytics across State’s heterogeneous data marts (MS SQL Server, DQS)
• Analyzed and created conceptual and physical data model for The All-Payer Claims Database data (APCD v 2.0), collected by Massachusetts Center for Health Information and Analysis
• Created dimensional model for Data Mart to accept APCD data for data mining/decision support
• Created general architecture for the task and development patterns for the whole ETL team
• Has been solely responsible for design and implementation of staging tables and indexes
• Has been solely responsible for optimization of DB queries performance, utilizing materialized views and other techniques
• Developed mappings and workflows to convert most complicated cases of legacy-to-production transformations

Confidential, Newark, NJ

Responsibilities:

• Architected and developed solution for moving medical imaging (DICOM) data archive to cloud database
• Developed retrieval, reporting and image management system for using by radiology department
• Developed and implemented extraction and integration of metainformation among various systems
• Develop algorithms for image comparison

Confidential, Lexington, MA

Responsibilities:

• Architected solutions and developed logical and physical data models for Business Intelligence in pharmaceutical data domain: healthcare provider information, professional interaction, case management, insurance utilization
• Created and maintained data mart databases on SQL Server
• Architected and implemented ETL processes from Saleforce.com to the data marts using MS Integration Services, developed SSIS and T-SQL transformations

Confidential, Concord, MA

Responsibilities:

• Designed data model and implemented database for large custom MDM solution (all US and Canada customer data, 500 millions + customer records, individual, household, business).
• Designed and participated in implementation of messaging solution based on zeroMQ for robust real-time parallel and scalable processing of updates to MDM (50 million+ record batches).
• Designed and participated in implementation innovative algorithm based on fuzzy logic for matching and scoring business and individual names
• Implemented relational database for storing matching rules for name/address information
• Re-engineered existing reporting solution for USPS rule compliance from AbInitio / MS SQL SSIS/SSRS platform to talenD and Jaspersoft platform based on rule-based transformations.

Confidential, Mansfield, MA

Responsibilities:

• Developed data architecture and application architecture for integrating OneKey Healthcare Providers (HCP) data, expense reporting data and Salesforce.com data into company MDM solution and for implementation of HCP Public Disclosure expense reporting mandate.
• Designed logical and physical data models for reporting Data Marts in SQL Server and ORACLE environments for project management and company financial data.
• Architected and implemented ETL processes, developed Infosphere DataStage and SQL transformations

Confidential, Woburn, MA

As an ETL developer

Responsibilities:

• Developed Operating Data Stores for project management and company financial data.
• Designed logical and physical data models for reporting Data Marts in SQL Server and ORACLE environments.
• Architected and implemented ETL processes, developed SSIS and SQL transformations.

Confidential, Hopkinton, MA

Performed analysis

Responsibilities:

• Analysis, data profiling, data model development and database development for Confidential Customer Data MDM
• Business requirement analysis, project architecture and data architecture for the Risk Management MDM solution for financial industry. This included design for integration of Chart of Accounts, Counterparty, and Financial Product data, BASEL II standards for risk management compliance, hierarchy management and data governance.

Confidential, Boston, MA

Responsibilities:

• Analyzed and documented requirements for the project
• Profiled data in legacy applications and reversed-engineered databases for clinical data and Confidential t registration data, analyzed and implemented standards and interfaces for medical data exchange and coding(HL7, SNOMED, ICD-10)
• Created logical and physical data model for the Data Warehouse
• Worked closely with developers and end-users on defining specifications, business rules and implementing application architecture for the Data Warehouse user access
• Created physical database, developed triggers and stored procedures, ETL procedures and reports.

Confidential, Boston, MA

Responsibilities:

• Analyzing and refining of corporate conceptual data model for healthcare and insurance data
• Creating logical data model for 5010 standard implementation
• Designing and implementing physical database for data staging, generation and maintenance of DDL
• Designing of the information model for data exchange and creation of XSD definitions for data objects
• Designing SOA architecture, web service messages and developing WSDL for web services

(IBM InfoSphere Data Architect

Confidential, Cambridge, MA

Responsibilities:

• Analyzing client’s needs and documenting requirement
• Creating enterprise meta-data repository, reverse-engineering and documenting existing application data
• Creating enterprise logical data model with a full data dictionary, covering both present and anticipated data utilization
• Defining transaction scenarios, scenarios, and CRUD constraints
• Gathering requirements for DW accommodating HL7 standard data
• Creating DW logical data model star schema design
• Creating physical data model for MDM, staging, and ETL scenarios for MDM and DW.

Confidential, Bedford, MA

Responsibilities:

• Define interfaces utilizing XML/XSD for data exchange between TruCare application and customer’s legacy data feeds
• Develop ETL data mapping graphs and data conversion Javascripts
• Define staging database structures and stored procedures

Confidential, Boston, MA

Lead Architect, ETL and Data Modeling

Responsibilities:

• Designing SOA framework and meta-architecture for DST financial applications
• Performing conceptual data modeling, data analysis, data profiling, data mapping and ETL implementation for DSTi’s product integration with client’s applications
• Developing logical data models and physical database design and generating database schemas
• Designing a strategy for integrating HiWay with other DST’s products
• Designed and implemented further enhancement for rule-based text feed parsing, data profiling, data cleansing, multi-level data validation and data transformation procedures for DST Data Warehouse.

Confidential, Newton, MA

Product Architect/Technical Team Leader

Responsibilities:

• Designing an architecture, an object model, algorithms, UML Model, and implementation principles for Bremer’s metaStreamer tool set
• Designing and hands-on developing implementation and full support of the messaging standards including HL7, SWIFT, FIX, FpML, EDI, etc.
• Designed user interfaces and participating in implementing the metaStreamer on clients’ projects.
• Developing data mapping, ETL mapping and scripting for client’s implementation
• Participating in client’s personnel and facilitating knowledge transfer

Confidential, Cambridge, MA

Data Architect

Responsibilities:

• Performing data analysis and conceptual data modeling using Zachman data modeling framework
• Participating in the implementation of SAP enterprise-wide solution at MIT
• Participating in the implementation of MDM practices and tool
• Creating logical data models and database design for various on-going projects
• Installing and maintained enterprise meta-data repository based on ORACLE DBMS
• Creating data definitions, maintained a data dictionary, and generated reports

Confidential, MA

Database Development Contractor

Responsibilities:

• Conceptual and logical data modeling, database design, database application development, and database administration
• Developing meta-data administration and information system integration methodology
• Logical and physical design for EPA Superfund Data Warehouse
• Logical and physical database design for FAA Flight Safety Data Warehouse
• Re-engineering and implementing US Coast Guard logistics and supply system
• Developing Hazardous Waste Management system database

Confidential, Cambridge, MA

Database Analyst

Responsibilities:

• Designed and developed architectural and space planning software.