*

Igor Gonchar

**** ***** ******, ********* ** *3019

Cell: 1-305-***-**** acrrhi@r.postjobfree.com

Professional Profile

Igor Gonchar is Executive Architect, and Certified Consultant in Technology for SWG Analytics and Information Management. As Data Architect he provided IBM Industry models support, financial management, compliance and IBM solutions for financial services and cross industries worldwide. His responsible included: Focused on the elements required to manage all aspects of data and information (both structured and unstructured) from business requirements to logical and physical design. Experienced in the data warehousing multi-dimensional database concepts, large project experience, and Data Warehousing project leadership, full project development life cycle for Data Warehousing, Data Modeling and CRM.

Responsible for effective data governance of the BI function to remain within program guidelines and procedures. Primary Technical /General Accountabilities

Igor has the following experience and skills in Big data, Business Intelligence and Analytics:

• Experience building Architecture for complex, scalable, and high-performance data centric BI architectures with Hadoop and other big data/open source technologies

• Successfully designed and implemented a large-scale data warehouse and an enterprise Operational Data Store (ODS)

• In-depth knowledge of data Extraction, Transformation, and Load (ETL) Tools

• Data modeling skills with respect to VLDB's and data warehouses (star and snowflake schemes)

• Evaluate and implement massive, scalable data stores

• Directing the data modeling support for project specific needs, while ensuring enterprise consistency

• Developed Business Intelligence Solutions including the design, architecture and service proposals.

• Directing the data modeling support for project specific needs, while ensuring enterprise consistency

• Defined, developed and supported the Meta Data Strategy

• Very knowledgeable in the Data Warehousing, Business Area Analysis, Object-Oriented Analysis, Conceptual, Logical and Physical Data Modeling, Client/ Server Application design and construction

• Vast industry perspectives on solution requirements, development, delivery and selection of technology to meet business requirements

• Expert knowledge on Information Management solutions and Data Governance

• Leads and supports IA client Solution Briefings/Workshops, IA Roadmap Workshops and Business Value Assessments

• Responsible for architecture, development, updates to data models, including physical and logical to meet new and changing business requirements.

• Leading technical project efforts including project planning, design, build, test, and data conversion/migration as well as report design and build.

• Develop overall strategic data architecture direction and provide a comprehensive road map for the Enterprise Data Warehouse.

• Create robust, scalable, sustainable data architecture that supports requirements and provides for expansion given budgetary constraints and availability of data and skilled resources.

• Develop processes for capturing and maintaining metadata and data-linage for all Enterprise Data Warehousing components.

• Estimate design capacity and costing efforts to meet near-and long-term design requirements.

• Identify current and emerging technologies that define by 'Best Practice'.

• Translate business and technical requirements into a solid technical design and solution to include architecture diagrams and design documents for a multi-client environment.

SOMA and • SOA Ability Architect-to work Consultant as the IT and Business liaison to translate requirements into model designs. Responsibilities included: client solution design as well as some service briefing and project definition work. Familiar with the IAA, IFW reusable asset specifications, and was able to apply them in developing SOA assets based on engagement experience and opportunities. Was be able to perform component and service placement, design for overall performance and availability, developed infrastructure component specifications, Designed business architecture, Designed technical architecture, Performed architecture gap analysis, Develop architecture transition plan, and Design architecture governance. Has lead and performed on client SOA engagements. Has integrated IBM and partner software for SOA enablement. Data Governance Has developed, Consultant evaluated, and designed to client non-functional requirements. Has designed and implemented SOA solutions. Provides methodology and advised for Data Quality, Master Data Management, Metadata Management. Responsible for managing project reviews, feasibility, cost benefit analysis, prioritization, initiation, execution, and closure for all project work related to the work related to the program. Provides input to the development and maintenance of Data Governance DQ, MDM processes, standards and procedures according to industry best practices. Provided contributions to the development of an enterprise wide data governance strategy.

Experience and Accomplishments

11/1998-present IBM

Executive IT Specialist for Southeast IBM Business Analytics (March 2015-present) Igor Gonchar

1251 Grant St, Hollywood, FL33019

Mobile: 1-305-***-**** email: acrrhi@r.postjobfree.com

USA Citizen

2

Igor Gonchar

1251 Grant Street, Hollywood FL 33019

Cell: 1-305-***-**** acrrhi@r.postjobfree.com

Responsible for architecting Business Analytics solutions to prospects in both the Commercial, State and Local sectors to solve business problems.

GBS Business Solutions Executive and Architect, Executive IT Architect, Certified Consultant in Technology and Integration (2013-2015)

Created and sold Smart City intuitive to St. Petersburg, solution was based on IBM Smart City methodology and IBM Intelligence Operation center software package (http://www.agencysgm.com/en/news/saint-petersburg-is-tended-to-be-a- smart-city/). Generated $500 mln new opportunities Led workshops for Russian Oil industry to create analytics-driven oil and gas organizations, which provide trusted information to predict business outcomes, and to make real-time decisions that help them outperform their competitors. Using IBM Big data reference Architecture for Oil and Gas, which provides a scalable, easy to use, secure information management and analytics platform for complex and large-scale analysis and economical storage of drilling production data STG CEE BAO Leader (2011-2013)

Responsible for STG CEE Smart Analytics target achievement

Leads the STG Smart Analytics strategy across the CEE region (deliver more than $20 mln in sales)

Personally engages in key CEE Smart Analytics deals

Owns content of Smart Analytics offerings, enablement and competitive positioning

Initiate, develop and manage go to market campaigns to achieve target achievement.

Defines the STG CEE sales approach and executes with the BSS who is the opportunity owner

Ensures cross business unit coordination and sales execution (STG, SWG, ITS, S&D, BPO)

Assigns the technical owner in coordination with TSM to architect the Smart Analytics design to win against competition

Identifies skill gaps to sell and deliver Smart Analytics offerings

Works with STG CEE GI leader to close skill gaps through critical hiring and trainings

Interlocks with BPO on Business Partner enablement for channel fulfilled and channel led Smart Analytics deals

Personally engages with key Systems Integrators, ISVs and Business Partners Executive IT Architect, IBM Software group Information Management Sale (2007-2011) Reviews and/or recommends changes, exceptions and new architecture & technology standards globally. Supports the review of business capabilities to identify unmet and future business requirements. Aligns the business requirements with respective architecture and technology components. Develops enterprise-level conceptual, logical and physical data models working in concert with Enterprise Data Management objectives.

Provides architecture oversight on IT projects.

Reviews and/or approves project requirements, design and application integration globally. Ensures that projects align to Enterprise Architecture model and comply with Enterprise Architecture Standards. Delivered $6 mln in new sales

Establish and maintain Center of Excellence (CoE) around Data Architecture Provide expert knowledge of technical and middleware architecture, and serve as Subject Matter Expert (SME) to business, operations and technology teams on those topics

Review business drivers, needs and strategies with Business and Architects to understand implications for application and middleware architecture

Provide input to Solution Architect in the development of project initiation documents, including the definition of objectives, scope, approach, and deliverables

Provide support and guidance to the development teams during the analysis, design, development and testing processes. Defines design patterns that ensure performance, scalability, operability and maintainability, and holds teams accountable to their correct use.

Be able to identify and communicate risks (business, application, technical) associated with component or application implementation

Provide input to determine where all hardware and software components will be deployed relative to an application Prepare application architecture deliverables in accordance with enterprise standards and methodologies and consistent with the target business architecture

Proactively identify and capitalize upon opportunities to share / re-use existing components where possible Understand data flows and lineage from operational data sources to analytical data sources Analyze, design, and build dimensional and relational data models and logical data specifications. Assist ETL developers with specifications, documentation, and development of data migration mappings and transformations for Data Warehouse loading.

Review and approve project designs including data mappings, data models and ETL Work with other IM and IS team to evaluate new/upgraded software and infrastructure Work closely with users to understand and help develop functional specifications. Work with IS Security to ensure proper classification and protection of enterprise data (PII, CPNI, etc.) 3

Igor Gonchar

1251 Grant Street, Hollywood FL 33019

Cell: 1-305-***-**** acrrhi@r.postjobfree.com

Partner with our Data Governance / Data Management business partners in the development and maintenance of enterprise data architectures, data management standards and conventions, data dictionaries and data element naming standards and conventions for multiple computing environments.

Research and evaluate alternative solutions and recommend the most efficient and cost effective data related solutions for improved data integrity, accuracy, and delivery cost. Partner with IM stakeholder/clients for ad hoc data in support of business analysis and BI development. Associate partner/ Executive Consultant / Lead Data Architect / Lead Data Warehouse Architect (1998-2006) IBM Business Consulting Services, Financial Sector. Marketing & Customer Intelligence Igor was involved in the development of business cases requiring Data Warehousing solutions. These solutions include data modeling, development and implementation of data, multigigabyte to terabytes size warehouse solutions, and establishment of new and enhancements to existing data transformation rules. He has determined business deliverables, data discovery processes, recommended a data warehouse approach (i.e. IAA, IIW, BO or DSS data application tool, etc.), dimensional modeling, database sizing, physical database design, system infrastructure, data mapping, extraction, cleansing, transformation, propagation, and performance tuning. Additional responsibilities included recommendation, development, and implementation of information access and delivery tool(s) appropriate and scalable for IBM clients (i.e. custom, OLAP/OLTP, ad hoc, web based, etc.).

• Led Offering Development in an effort to help take capability to the market, position against client problems, and feed industry o o o Shaped Led Developed issues development analytics and delivery offering strategy of and thought needs sales and leadership: into assets offerings the which offering publishable support development analytics content, offerings white papers

• Partnered o Helped with client clients teams define to understand a future state business strategy problems and supporting and strategies business case for the implementation of o o o Track, Track analytics Interpreted and monitor analyze the and results key analyze success of the spend analytical metrics and achieved to insights ensure and benefits team communicate is delivering from project the desired results impact to the client in a business o context Supported to drive clients value who seek to develop their predictive capabilities and integrate the business value of predictive analytics into the fabric of business decision-making

• Understood where advanced data techniques can be applied to solve client problems (machine learning, Examples optimization, of Projects: o o o Understood Knowledge Data data management mining, of analytics big etc.data skills ) at techniques platforms, client efforts and tools bringing application and applications to bear: of services

• Lead Information Architect for the Caterpillar Finance Transformation project and Enterprise Information management assessment project.

• Enhance the Conceptual data model to incorporate the additional systems of scope and perform the physical design of the staging area to store the Client Data Hub entities and attributes for Merrill Lynch CEDP project

• Provide Systems Architecture and Data Management Detailed Design and Implementation Support for the Boeing Finance Transformation program to support its vision of establishing processes and information systems that provide accurate, timely, consistent and robust financial information. Provided advisory, subject matter and best practice knowledge to Boeing as part of the preliminary analysis phase of the Finance Transformation Program, which included review of current as-Is processes, conceptual design of future state To-Be processes, and implementation planning.

• Project manager and Lead Architect for the design and analysis of the HR Lincoln Financial Reporting Data warehouse project (HR RDM).

• Technical Director of AOL-IBM OnRamp project, which including complete redesign of AOL Information Architecture and Systems. Project is to enable AOL to provide a comprehensive view of their customers and their experiences to any real-time system for immediate decision-making.

• Lead Data Architect for FMEA project of Department of Defense. For the Department of Defense’s (DoD) Financial Management Modernization Program (FMMP), led a data management team in creating an enterprise data management strategy as a foundation to DoD’s Financial Management Enterprise Architecture (FMEA). Responsibilities included: data modeling, systems analysis, and systems design work in support of the C4ISR compliant enterprise architecture. Led a team composed of system engineers and data modelers in creating C4ISR products in Popkin’s System Architect to define the enterprise application integration and data sharing functionality, enterprise metadata and business rule management, conceptual business model management, logical operational data store design, logical data warehouse and data mart design, and external interface functionality.

• Lead Data Architect for multiple multibillion-dollar Insurance companies on IBM’s projects

• Lead Data Architect for e-commerce marketplace, using XML and MQSI), AFG, and ING engagements.

• Lead Technical Data Warehouse architect for IIW implementation for Large Equitable Company, American Bankers Insurance group and Commercial Insurer

• Leader of a Data modeling process for creation of enterprise Data model for Larger HealthCare Insurance 4

Igor Gonchar

1251 Grant Street, Hollywood FL 33019

Cell: 1-305-***-**** acrrhi@r.postjobfree.com

• Led Data Warehouse Architecture proposals for Data Warehouse Implementations, using IBM IAA and IIW for several of the largest US Insurance companies (USAA, GEFA, CONSECO, ING and more)

• Led Data modeling process for creation of the enterprise Data model for Aetna HealthCare Insurance

• Led Technical and architectural implementation of a Data Warehouse for Insurance Information Warehouse and Insure Risk Network products of IBM

Database Architect-Consultant

Lockheed Martin Integrated Business Solutions, King of Prussia, PA 9/1997-11/1998

Modeled and built Corporate Data Warehouse (> 1 TB) for Freddie Mac (McLean, VA) using SP2 server and DB2 Universal Parallel Processing Database. Consulted on modeling, design and architecture of component applications. Modeling business processes and database design for enrollment and eligibility for CIGNA Insurance Company in Philadelphia. He was Created Standards, Procedures, System architecture and design for Data Warehouse solutions. Created Executive Reporting system for Citibank Credit Cards Data Warehouse (>2 TB of historic data) using COGNOS, SAS. Involved in Database Architecture Design and Data Warehouse development, enchantments to reporting systems (using Crystal Info and Business Objects) for Ernst and Young Financial and HR databases. Senior Systems Specialist (Consultant)

Naviant Technology Solution, W. Conshohocken, PA

6/1996-9/1997

Project leader of Data Warehouse implementation (Oracle) for Nationwide Insurance Company at Portland, Oregon. Prepared Data Warehouse models for Data Mining, DSS and Business Analysis. Application level DBA. Created indexed, tables, access level Designs an information strategy that maximizes the value of data as an enterprise asset

* Maintains logical/physical data models

* Coordinates the metadata associated with the application

* Develops technical design documents

* Develops and communicates data standards

* Maintains Data Quality metrics

* Plans architectures and infrastructures in support of data management processes and procedures

* Supports the build out of the Data Warehouse, Data Marts and operational data store

* Effectively communicates with other technology and product team members Enterprise Database Analyst/ Architect

Crozer-Keystone Health System, Chester and Delaware Counties, PA 6/1996-6/1997

Developed proposals for platforms rollout and implementation projects, which included coordinating and planning application integration activities with IS personnel or clients, aiding in planning the software lifecycle for supported products, recommending upgrades and implementation plans, support and training. Provided senior level planning and consulting for IS management and clients. Supervised all Databases management and development activities for the healthcare Informatics group, and provided senior level research, planning, and administration and consulting services relating to the data associated with the healthcare Informatics business function. Responsible for optimizing the design and utilization of development tools and products. Provided technical consultation and support to software development teams. Developed Enterprise database models using business process models; establish entity relationships within databases. Build and managed different Sybase databases, populated Sybase databases using MDI Gateway connections from mainframe DB2 databases (SMS INVISION and Signature). Managed enterprise object oriented encyclopedias (data dictionaries).

Designed and developed Business Intelligence reporting solutions, Performed analysis of reporting requirements and provided plans for implementation of Cognos technology. Supported graphical, visual presentation of data, created queries & reports data Using Cognos software (Impromptu, Power Play, and Scenario). Worked with SMS Information Systems team in the development of the Enterprise data warehouse. Worked with clinicians and interdisciplinary teams to respond to request for special databases and client-server applications and solutions. Developed and ensure uniform standards among various databases used throughout company.

Senior Systems Analyst/ Programmer

The Prudential Healthcare Insurance Company, Eastern Operation, Horsham, PA 5/1994-6/1996

Interacted with business partners to understand business needs and issues help business partners define effective business processes and define system requirements that will meet their needs. Used CASE Tool to develop Business Area Model, Analysis Models, Process Modeling, and Logical Data Modeling for Eligibility and Medicaid projects. Using Analysis workstation to provide Data Modeling, Analysis and Data Mining. 5

Igor Gonchar

1251 Grant Street, Hollywood FL 33019

Cell: 1-305-***-**** acrrhi@r.postjobfree.com

Developed detailed specifications for Decision Support System for the design of programs, code, debug and document using CASE Tools and Information Engineering methodology, Systems Analysis and mainframe programming. Responsible for Encyclopedia Management and Technical Support of ADW (CASE) users and Methodology Acquisition, provide internal consulting service.

Developed, Design and coding applications for Client-Server Projects, Business Area Model and Database Design, using CASE Tools, SQL server and MS Access, Visual Basic V.4. Provide training of programmers in using ADW (CASE Tools). Senior System Engineer

Continental Insurance Company (Consulting- KSM Associates, Inc.), NJ 3/1993-6/1994

Developed project schedules and assigned tasks, coordinated activities of project team performing Automation Management Process Systems (COBOL).

Provided supervision in testing, implementation and installation of these systems. Performed system analysis, design and programming. Served as the primary contact with users. Responsible for maintaining existing systems for Corporate Planning, Sales and Marketing Systems using MicroFocus COBOL developed PC applications, creating installation packages for PC. Developed new Corporate Planning Systems, using spreadsheet technology and wrote Macros Using EXCEL 5.0 Systems Analyst

Defense Support Automation Center {(Consulting -RJO (RSI) Enterprise), NJ} 1/1992-3/1993

Responsible for development of new mainframe batch applications, following government methodology, analysis, design, coding, testing and implementation, maintained existing systems, recommended solutions. Developed detailed specification using information Engineering methodologies and CASE (ADW) tools. Support PC-based applications including network applications, trained associates installed software. Responsible for various stages of development and implementation of inventory applications using Oracle 6.0. Created several Forms and Reports, using SQL Forms and SQL Report Writer.

Research and Software Specialist

Department of Electrical and Computer Engineering, Drexel University, Philadelphia, PA 9/1990-1/1992

Responsible for Software development and maintenance of computer simulation physical model for semiconductors including calculation; analysis, design, programming, debugging, testing and implementation of scientific application, data research, management and analysis of scientific data for developing the best model of Solar Cell. Published this work 12/1991. Education

BS in Computer Science, Kiev Polytechnic University, Kiev, Ukraine MS in Electrical Engineering & Physics, Rostov State University, Russia Graduate Courses in Information Science, Drexel University, Philadelphia, PA. (GPA 4.0) Ph.D Courses in Electrical Engineering, Drexel University, Philadelphia, PA. Wharton Executive Education, the Wharton School, University of Pennsylvania, Publication

“Industry Models For Semantic Information Management” Published in BI Report in May 2004. DMReview.com http://www.information-management.com/specialreports/20040518/1003610-1.html

“IBM: Awards: IBM Professional как USA поставить Department Certification: информацию of Defense’s на службу BMP 2003, project бизнесу” IBM “BRAVO” Certified http:award Consultant //old.9/cio-30/world.2003 ru/products/485962/ 2004, IBM Certified Consultant in Technology and Integration 2012, IBM Certified Sales Architect

2013, IBM Senior Certified Consultant

USA Citizen

Expertise summary

21+ years overall IT leadership with Strong Data Modeling, Data Architecture Background 20+ years – Enterprise Data Architecture, Data Modeling Solutions Designing, Data Analysis and BI solutions delivery, Data Warehouse implementation

20+ years – Deploying Enterprise models across complex environments (both physical and logical) 20+ years – Expert skills in development and documentation of complex Enterprise Data Warehouse data sourcing 6

Igor Gonchar

1251 Grant Street, Hollywood FL 33019

Cell: 1-305-***-**** acrrhi@r.postjobfree.com

and transformation requirements including Extensive experience on Data modeling 20+ years – Expert skills in conducting Data Analysis, Data Profiling and Data Discovery on disbursed operational source systems.

10+ Years of Any DW appliance like Teradata, Netezza, PDW, Oracle Exadata• 20+ years of overall leadership and management

12 years – MPP Database experience but not limited to Netezza, Teradata, SQL Server, Oracle, DB2 20 years - Leading technical project efforts including project planning, design, build, test, and data conversion/migration as well as report design and builds 20 years – Data Architecture: application, reporting frameworks, processing, availability and scalability 20 years - Translating business and technical requirements into a solid technical design and solution to include architecture diagrams and design documents for a multi client environment 20 years - Advanced skills in using the 3 or more of the following modeling techniques: MDM, ERD, Temporal, Generic

& Reusable, or Time-variant, 3rd Normal Form, 4th Normal Form, Column aggregations 20 years – BI-Solutions: Architecture, Design and Development of data marts, business semantic views and reporting models

20 years - Erwin, ETL, PL/SQL, SQL, XML, or other development language 20+ years of data integration architecture understanding and architecture skills leveraging tools but not limited to IBM DataStage, SSIS, Informatica and/or Ab Initio

Developed overall strategic data architecture direction and provide a comprehensive road map for the Enterprise Data Warehouse.

Advanced Enterprise Development Methodology and oversight of complete SDLC and/or IDLC for complex projects Advance technical understanding and knowledge of tools and products used in Enterprise Data Warehousing and data integration: Oracle, DB2, Netezza, Teradata, SQL Server, and/or UNIX • Understand advanced architectural principles of Enterprise Data Warehousing including modeling concepts and architectural principles applied to Enterprise Data Warehousing

Ability to create robust, scalable, sustainable data architecture that supports requirements and provides for expansion given budgetary constraints and availability of data and skilled resources Responsible for architecture, development, updates to data models, including physical and logical to meet new and changing business requirements

Developed processes for capturing and maintaining metadata and data-linage for all Enterprise Data Warehousing components

Experienced in using various types of dimension hierarchies: classification, construction, and variation including the creation & deployment of star and snowflake schema and in-depth and full life cycle experience in Enterprise Data Warehousing life cycle

Expert ability to work as the IT and Business liaison to translate requirements into model designs Estimates design capacity and costing efforts to meet near-and long-term design requirements Identified current and emerging technologies that define by 'Best Practice'. Expert level communication, presentation, organizational and interpersonal skills, problem solving and analytic skills Expert understanding of business application or product being developed Expert design/coding skills, testing methodologies and techniques 7

Igor Gonchar

1251 Grant Street, Hollywood FL 33019

Cell: 1-305-***-**** acrrhi@r.postjobfree.com

Contact this candidate