Professional Profile

• Igor Gonchar is CEE GBS Business Solutions Executive and Architect for RCIS, Executive IT Architect, Certified Consultant in Technology and Integration for the IBM System and Technology Group STG, Information Management and Information Agenda and responsible for the information management, integration services, as Data Architect he provided IBM Industry models support, financial management, compliance and e - business solutions for financial services and cross industries worldwide. His responsible included
• Industry subject-matter-expert who drives incremental revenue software, services and hardware, through the sale of integrated industry solutions to New Buyers LOB and functional executives that address specific business outcomes Leverages IBM's Growth Initiatives including Cloud, Analytics, Mobility, Social CAMS including Security, Smarter Commerce and Smarter Cities Demonstrates knowledge in industry-specific IBM Smarter Planet Industry Solutions and Smarter Analytics Signature Solutions, Smarter Commerce solutions, GBS Strategic Business Solutions and SWG Buyer-Aligned solutions Builds trusted relationships to help clients develop customized Industry Solution Roadmaps which formalizes short-term and long-term strategies for Smarter Solution software and services and overall IBM solutions growth within account Leads ISST Workshops, Industry Solution Roadmap Workshops and client executive briefings to senior line-of-business sponsors Supports Business Value Assessments BVAs, proof-of-concepts POCs and client technical briefings as required Effective teaming and interaction with other industry practitioners in S D, SWG GBS Primary ISST interface supporting IBM Managing Directors, Client Executives, Software Client Leaders and Brand Sales teams for all assigned accounts Deployed in major client opportunities working three-in-a-box with ISST Business Solution Specialists and Solution Architects Responsible for achieving personal attainment of ISST sales and signings targets
• 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

Primary Technical /General Accountabilities

• 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. He provides the full information management lifecycle from acquisition, through cleanse, transform, classify and storage to presentation, distribution, security, privacy and archiving. As Information Architect he provides services, which include databases relational, hierarchical and object-oriented, file systems and storage management, as well as document imaging, knowledge and content management, taxonomies and business intelligence. He is capable of designing centralized or distributed systems that both address the user's requirements and perform efficiently and effectively.
• 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.
• Manage, develop, and execute the Business Intelligence strategy. Responsible for providing strategic leadership for BI in the areas of Data Warehousing, Business Intelligence, Dashboards, and other associated systems. Responsible for effective governance of the BI function to remain within program guidelines and procedures. Be the liaison between the BI team and the corporate IT team. Assure development and documentation standards are enforced. Responsible for BI production support
• He has lead teams responsible for the definition, design, and construction of core Data Warehouse Data Management solutions within large-scale Customer Relationship Management CRM initiatives. As part of the global organization, he has lead teams of data warehouse development professionals and provided productivity improving and/or revenue enhancing tools to business units.

Igor has the following experience and skills in BI:

• Successfully designed and implemented a large-scale data warehouse and an enterprise Operational Data Store ODS
• En-depth knowledge of data Extraction, Transformation, and Load ETL Tools
• Led the gathering and documentation of requirements with the Company's CEO and CTO using IBM GS Methods
• Created the Technical Design documents using IBM GS methods
• Working with SOA and SOMA architecture, using IBM assets
• Data modeling skills with respect to VLDB's and data warehouses star and snowflake schemes
• 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
• Leading the development of strategic Operational and Informational Data Architecture supporting the Information Vision
• Defined, developed and supported the Meta Data Strategy and Repository
• 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
• Coordinates with Industry Value Teams in US as a unified expert resource pool
• Lead Solution Blueprint Rendering and provide industry process/architecture expertise into Technical Validation e.g., Integrated Demo with Technical Sales and Services
• Enables Geo Teams on IA USP methodologies
• Supports the interaction and transfer skills with practitioners in GBS, SWG and Partners Deployed in Banking and Financial Markets clients

SOMA and SOA Architect-Consultant

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. Has developed, evaluated, and designed to client non-functional requirements. Has designed and implemented SOA solutions.

Data Warehouse Consultant

• As a Data Warehouse Consultant, Igor focuses on the modeling, design, construction, implementation and testing of data warehousing solutions for clients across different industries:
• Advised clients and other Enterprise Architects and Lead Developers on database architecture decisions that impact the application and database architecture
• Defined database architecture deliverables and constructed plans to meet deliverables
• Provided guidance and mentoring to DBAs
• Performed logical and physical database design
• Designed and implemented data models based on object-oriented analysis design object to relational mapping
• Optimized data model based on usage patterns
• Served as a guide and mentor to elevate the level of fellow team members' skills in data warehouse and data mart development best practices
• Experienced in integrating external 3rd party and in-house applications and/or data stores IBM's IIW, CIIS, IAA .
• Designed and developed Business Intelligence reporting solutions by performing analysis of reporting requirements and providing plans for implementation of OLAP technology
• Analysis of business processes and requirements, data modeling, and OLAP for Data Warehouse
• Knowledge of OLAP, Data Warehousing, Modeling and report development tools
• Utilizes CASE Tools, Encyclopedia management, technical support, analysis, design and construction of different kind of applications, using Erwin, Info DataArchitect, PowerDesigner, Embarcadero, and Popkin's System Architect
• Very strong data modeling experience using CASE tools, teaching CASE tools and CASE methodology
• Experience programming, analyzing, designing, coding, and testing of application software.

Data Governance Consultant

Provides methodology and advised for Data Quality, Master Data Management, Meta Data 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. Provides contributions to the development of an enterprise wide data governance strategy.

Experience and Accomplishments

Confidential Executive IT Architect,

• 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. Successfully harnessing big data help to unleash the potential to achieve following critical objectives:
• Enhance exploration and production
• Improve refining and manufacturing efficiency
• Optimize global operations
• Enhance exploration and production
• Optimize extraction and effectively manage well operations with real-time interpretation of drilling information
• Improve reservoir performance by analyzing and acting on information from seismic studies and production systems
• Avoid disruptions and reduce production losses caused by equipment breakdowns or facility problems
• Improve refining and manufacturing efficiency
• Optimize the efficiency of a global supply chain and reduce expenses
• Facilitate intelligent, informed decision making
• Achieve compliance while controlling costs

Executive IT Architect, Confidential

• 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.
• Ensure data objects are in compliance with data architecture, quality, standards and structures.
• Leads the review and approval of change control requests for interfaces and application integration globally i.e. SAP, XI .
• Supports the development and maintenance of the Enterprise Architectural Framework and other global procedures.
• Maintains the architecture inventories in collaboration with Local Site Design Authority for business processes, data, applications and infrastructure.
• Compiles and maintains the Baseline Architecture Models defining the business, data, application and infrastructure of the enterprise and their relationships.
• Works with Business Organizations and Local Site Design Authority to develop and maintain high-level business and data models.
• Works with Local Site Design Authority to develop and maintain high-level application and infrastructure models.
• Provides leadership in defining enterprise information architecture in Data Architecture Process Standards, Metadata Management Infrastructure Strategy, Master Data Hub Technology Architecture and Business processes.
• Supports the development and maintenance of the Future Architecture Models defining the business, data, applications and infrastructure of the enterprise and their relationships.

Associate partner/ Executive Consultant / Lead Data Architect /

Confidential

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. .

Responsibilities:

• Provided technical leadership to BI/DW projects in the areas of optimal design patterns, models, standards and sample code to ensure consistency and realize benefits of a high-performing, secure, reliable and scalable architecture
• Collaborated with GS IT architecture team to develop a practical end state and reference architectures for BI/DW with considerations for distributed data, in-memory computing, cloud computing, visualization tools/platforms
• Provided early design guidance on projects by creating a high level design document in collaboration with the project technical staff and incorporating the patterns, models and standards previously identified
• Provided technical leadership in areas such as master data management and reference data management to reduce duplication and redundancy for core data objects
• Worked with the data governance team to ensure alignment of data definition, quality specifications, models and meta data management to technical implementations
• Responsible for pro-actively monitoring the effectiveness of technology governance in BI/IM projects and ensuring adjustments are made to the process in collaboration with the PMO group
• Oversaw the translation of logical data models to physical database designs
• Managed the designs of detailed data architectures project program related and designs and builds relational and dimensional databases
• Defined data-backup and recovery strategies and solution designs that meet business needs
• Used change management skills and knowledge to encourage adaption of current methods and adoption of new methods of information management
• Influenced senior leaders and all levels of business and IT staff on all areas of technology
• Maintain keen knowledge of technology trends in the industry in the areas related to databases, in-memory computing, distributed computing, SOA, Data Warehousing, Visualization tools, Self-service, ETL and MDM.
• Lead the effort to establish, define, maintain and communicate data architecture reference architectures, guidelines, standards and best practices within the ODS data model domain
• Provide technical leadership for solution architecture development and review with regard to data integration architecture design and implementation for all initiatives within the division. Develop and drive the review / approval of data integration specific Solution Definitions through the enterprise architecture review process.
• Own and manage the conceptual and logical data models for the ODS
• Collaborate with the Data Modeling Architect and Business Intelligence architects and maintain awareness to all changes in ODS, EDW and Data Mart structures
• Collaborate closely with business analysts and data subject matter experts to ensure the ODS data model will properly support business needs.
• Collaborate closely with other solution architects to define and implement effective and efficient solutions to business challenges and opportunities.
• Collaborate closely with Enterprise Architecture to ensure alignment of the EDW, ODS and Master Data Management data models are aligned as appropriate to ensure proper integration of data across the entire enterprise. This role will have significant role in influencing in the enterprise data model for the firm and will need to deliver data model designs using both Agile and Waterfall methodologies to multiple project teams
• Work closely with database administration to establish and maintain highly resilient, scalable and high performance architecture as the model is implemented physically on the target platform s .
• Establish and own the data dictionary, data repository and data governance/stewardship of the data model for the Enterprise ODS.
• Develop and maintain a technical roadmap and investment plan for the evolution of enterprise data model for the Enterprise ODS.

Examples of Projects:

• 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
• 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

Confidential

• 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

Confidential

• 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

Enterprise Database Analyst/ Architect

Confidential

• 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

Confidential

• 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.
• 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

Confidential

• 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

Confidential

• 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

Confidential

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.

Summary

Industries:

Insurance, Financial, Health care, Mortgage, Credit Card, Inventory, Distribution, Retail, Personnel, Payroll, and Transportation, IBM IAA and IIW, CRM, CIIS

Project Domain:

Data Warehouse implementation, ODS, Data Mining, Conceptual Data Modeling, Business Area Analysis.

Hardware:

IBM 3090, IBM /370, DEC/ VAX, IBM/PC, Macintosh

Operating Systems:

TSO/ISPF, MVS, VM/CMS, DOS/VSE, MS/DOS, OS/2, UNIX, Novell, VAX/ VMS, Windows any

Computer Languages:

XML, COBOL II, Visual Basic, COBOL MicroFocus COBOL, FORTRAN, C, SQL, JCL, Java

RDBMS:

DB2/390 and DB2UDB, Sybase, Oracle, Informix, SQL/ DS, SUPRA, LOTUS Approach

Development Tools:

Erwin, Bpwin, WBI, WBM, Rational Rose, Popkin's System Architect, PowerDesigner, Key for Workgroup, S-Designer, COOL: Gen, ADW, Key: Enterprise, Embarcadero, Popkin System Architect, PowerBuilder, Business Object, Cognos Impromptu, Power Play, MicroStrategy, Microsoft Project, SMS INVISION, EasyCase, Lotus Suite, Lotus Notes, MS Office, FileAid, Net Protocols TCP/IP, IPX/SPX .

Applications:

Siebel Analytics, Microsoft Office, Visio 2002, Project 2000

Training:

SOA, SOMA, Ab Initio, Project Workbench, Microsoft Project, PowerBuilder, FileAid, HBSI database, Java