David Abayev, Pmp Email & Phone Number

Hicksville, Ny , Us

• Lead data governance team efforts to enhance enterprise data governance and quality• Design and implement platform and data integration solutions for interconnected and unified metadata, data quality and governance • Deploy and productionize enterprise data quality processes

Hicksville, Ny , Us

• Design architecture and build framework for enterprise data governance and quality. • Design and implement long-term solutions and processes to automate data quality life-cycle from data production to consumption, from issue identification to resolution. • Improve the process for corporate business glossary development and data assets maintenance. • Establish technology platform for integrated ongoing data governance and quality.

Detroit, Mi, Us

• Built a team and implemented process to define and execute data quality and data governance initiatives on a new technology platform. Identified, classified, analyzed, tracked, reported and resolved data quality issues to increase efficiency and data reliability.• Maintained compliance with regulatory requirements and data management maturity; implemented data governance principles and practices; • Facilitated productive collaboration between analysts, developers, and business partners to provide integrated and comprehensive IT solutions and reliable business intelligence.

Detroit, Mi, Us

Data management and data warehouse team leadership; enterprise information architecture• Lead team efforts in creating Enterprise Conceptual Data Model, As-Is and To-Be process flows and data flows, gathering DW requirements• Analyzed and documented client system and data needs and requirements, facilitated executive interviews, BI and reporting assessment • Designed roadmap, solution implementation strategy and created functional and technical specifications• Architected data warehouse dimensional model, data integration and conversion processes, ETL flows; defined facts and dimensions, designed DW Metadata model.• Mentored client and internal resources on best practices in data governance, data architecture and modeling.

Designed Data Management Roadmap, process flow, Enterprise Conceptual Data Model for the legacy data migration to cloud, implementing migration methodology and best practices. Participated in formation of the Data Governance Council and assisted in defining the Enterprise Data Standards and Policies, Goals and Metrics. Advised the implementation team and the enterprise technology management on strategy, architecture, modeling, tools assessment, and mentored the team.

Ann Arbor, Michigan, Us

• Responsible for designing, building and supporting solid data foundations for variety of high-visibility clients (see respective entries for Comerica, Citigroup and BCBS below) . • Architectured and implemented solutions on major data quality, data governance, data strategy, master data management, data conversion, and data integration projects. • Recommended and installed best practices, methodologies and tools.

Detroit, Michigan, Us

• Led team efforts to create the conceptual design and knowledge engineering documentation for BCBSM healthcare providers credentialing. • Assessed the source data and legacy systems entities, identified critical data elements, and their relationships. Mapped data to the new functionality in Portico application, and built a foundation for ETL and implementation processes.

New York, New York, Us

• Managed information audit and data profiling for global initiative at world largest financial services company. • Provided in-depth analysis of data quality and structured recommendations to remedy data issues. • Built universal dashboards to display/alert users about status of data quality in a clear, consize and effective way.• Reviewed and analyzed risk scoring and matching for anti-money laundering initiative and government regulations compliance.

Dallas, Tx, Us

• Recommended and implemented strategy and methodology for Enterprise Data Quality.• Led group of data analysts and ETL developers through the data profiling and analysis, evaluation of anomalies, design and implementation of data standardization and data enrichment routines for Comerica Enterprise Data Warehouse(EDW).• In support for Data Governance developed the data quality rules and processes for cleansing data. Facilitated approval by business users and data owners.• Creatively resolved inconsistencies and issues to accelerate loading the enterprise data warehouse with clean data, providing solid data foundation for Know Your Customer(KYC) and Anti-Money Laundering(AML) initiatives and government regulations.

Detroit, Michigan, Us

• Led the formation of the development teams, managed resources to support, enhance and extend the Global Vehicle Configurator System. • Created the infrastructure and environments to support projects development needs. Coordinated the change control process. • Created the knowledge acquisition plan and facilitated the knowledge transfer, shadowing, and transition of the skills/responsibilities to new global teams.• Estimated efforts for new project development and system enhancements; allocated resources, planned and scheduled implementation.

• Led vendors and client teams’ efforts to convert over 500,000 insurance claims with over 10M transactions and associated policy data from multiple disparate legacy systems to new enterprise claim system. • Managed integration, data quality and conversion, data mapping, integrity and security, and systems interfaces.• Planned, executed and controlled the conversion scope, timelines/milestones, data extracts, data cleansing and transformation, and the conversion’s end-to-end balancing. • Worked closely with client business managers, VP of Claims, IT resources and vendors’ development teams.• Defined and maintained data quality standards. • Created an approach, methodology and documentation for determining the sufficient volume of legacy business data to convert. • Mitigated go-live risks by piloting multiple test conversions. Optimized conversion processes data conversion, resulting in timely and error-free converted data.

Ann Arbor, Mi, Us

• Managed Enterprise Data Conversion project. Integrated multi-platform architecture and diverse technologies of legacy and emerging applications. Supported interoperability and business continuity during Business Systems Replacement. • Led research, analysis, evaluation, selection, acquisition and installation of software for ETL, Data Warehouse and Business Analytics. Built applications knowledge base, and facilitated developers’ training. • Led on-going data quality management, user acceptance testing and QA efforts. Provided production support and systems enhancements.• Managed Oracle Financials 11i Upgrade project using off-shore, consulting and in-house resources. Managed schedule, oversaw deployment across US, Canada, UK.• Deployed the infrastructure upgrades for development and test environments.

Minneapolis, Mn, Us

• Developed and implemented database marketing solutions for Marketing and Fulfillment Systems Management.• Responsible for the data warehouse initiatives of Johnson & Johnson’s LifeScan division. • Planned and managed the acquisition of 4 external marketing vendors systems, and consolidation and integration of their data into the on-line Marketing Data Warehouse as a part of CRM solution.• Managed client engagement/relationship. Established and maintained provider credibility with client’s senior business executives, securing approvals of project plans and deliverables.• Maintained and enforced data quality and integrity standards. Assembled a team of experts and led them from project conception to the delivery of the complete solution.

• Conducted site inspections, user and management interviews, JAD sessions, and presentations• Analyzed, designed, and developed Manufacturing Quality Data Management(QDM) System. • Redefined the business process model, developed ER diagrams, business rules and constraints, logical tables’ design. • Integrated QDM with the corporate information model and performed the model management• Designed Data Replication Strategy for 15 manufacturing plants; facilitated its implementation.• Managed distributed team development environment.• Architectured Data Warehouse for QDM decision support system; completed migration of legacy data into RDBMS, extraction, transformation/cleansing and loading

Dallas, Tx, Us

• Analyzed, designed, and developed Customer Initiated Payments System: redefined process model, developed ER diagrams, RI constraints, logical tables design, user interfaces• Designed Transaction Billing Application automated testing, and facilitated user acceptance process • Created reusable components, queries, stored procedures, system utilities and reports to maximize data usage

Dearborn, Michigan, Us

• Wrote DBMS software requirement specifications, collaborated with Gartner Group on vendor/package evaluation and selection for Worldwide Diagnostic System• Designed and developed Software Parts Tracking and Request Management Systems• Analyzed business process, developed process model and ER diagrams. Performed quality, and referential integrity checks, data normalization, logical and physical RDB design. • Created user interface prototype and developed front-end for data entry/tracking system.

• Developed, operated and maintained Energy Conservation Decision Support System. Administrated multiple databases and applications. • Designed, and implemented modifications to production systems. Trained and supported 30 end-users• Prepared monitoring, statistical and government reporting for MPSC, database marketing tracking. • Designed and developed Meter Data Collection and Aggregation Data Mart.