Post Job Free

Resume

Sign in

Data Management

Location:
Overland Park, KS
Salary:
130K - negotiable
Posted:
November 26, 2018

Contact this candidate

Resume:

HAKAN M. ARSLANOGLU

***** ****** ******, ******** **** KS. 66213 Tel.: 913-***-****

DATA ARCHITECT

Senior Information Management Architect over 20 years of leadership experience spanning database design / architecture / planning / management, datawarehouse, business intelligence, applications design and development, in telecom, technology, insurance, manufacturing, eCommerce, health care and government industries. Technical and functional expertise in:

Data Warehousing

Business Intelligence/ Data Mining

Meta/Master Data Management

Data Architecture

Oracle

Database Design and Management

Oracle Designer/Forms/Reports

Data /Process / Function Modeling

SDLC, Agile Development

Business and Technical Design

OS (Windows, Unix, AIX, Linux)

Security Control Standards

Requirements Gathering

Project Management

Unix Development

Data flow diagramming and data mapping

Multiple Programming Languages (Java, PL/SQL, OO, C/C++, COBOL,)

Proactive, results-oriented problem solver, who designs and develops databases and leads to execute the Company strategy:

Led the design and implementation of Data Warehouse, Data Mart, Operational Data Store, and Utility databases – Led, designed, and implemented Oracle structures for reporting and operational applications to support the strategy. Designed the initial phase of the Enterprise Data Warehouse for a major US insurance carrier.

Managed the development, and implementation of Data Standards for a Data and Integration Strategy initiative for a major insurance US carrier. Worked with outside consultants assessing the current business and technical architecture, determining and documenting the future state, performing the gap analysis, and determining the future projects needed to close the gap.

Focused and multitasking team player who delivers results in a timely manner:

Led, designed, and implemented the database design and developed the web application to manage telecom broadband upgrade projects in 2 months – Oracle web application to manage telecom broadband upgrade projects. Held requirements meetings and gathered the data requirements to support the application. Developed the web application with the team of three. Utilized Oracle Designer case tool to manage both the data and application side to meet the client’s time constraint of two months.

PROFESSIONAL EXPERIENCE

Dst Systems. September 2006 – JULY 2018

Data ARCHITECT

Member of Data Management to analyze business requirements and gather data requirements to build moderately complex logical data or class models that include attributive entities, subtype and super-type entities and recursive relationships. Currently working enterprise initiatives around customer and product master data as well as addressing, remediating security control standards for the Data Management domain. Most recently designed a multiple star schema structure to facilitate health care claims reporting for data platform (data lake) built on Hadoop and hive. I have also designed relational structures to support the rewrite of a circuit management system for network infrastructure. Prior to that I was responsible for all product models (over 15) for DST Output, which includes a reporting system, a hybrid ODS, a master data repository, and numerous output related applications such as capacity planning, billing, electronic billing, file management, and print factory. Worked on projects to enhance the Mutual Fund Record Keeping system with over 1900 tables. Utilized ER/Studio to reverse-engineer an e-commerce application with over 200 tables and created a base logical model to conform this application to shop standards going forward. Administrator for ER/Studio, managing all aspects of the tool including licenses, users, enhancements, new releases, and vendor relationship. Leading security control procedures and compliance for Data Management domain. Leading analysis and design for a customer and product master data initiative.

Assurant Employee Benefits Inc. April 2003 – August 2006

Data/Enterprise Architect

Member of Enterprise Architecture team to define and govern enterprise wide strategies spanning application, infrastructure, tools, data, and integration. Managed and delivered operational, transactional, and analytical databases for various initiatives including customer facing portal applications. Managed a team of Information and Data Architects, defining guidelines to support IT and Business strategy and delivering data structures, data analysis, and ETL assistance for BI projects as well as other business projects. Enterprise leadership role for Data Architecture for both operational and data warehousing/business intelligence. Providing leadership to senior architects to document and implement data and integration strategy.

BV Solutions Group Inc. September 1997 – April 2003

Senior Systems Analyst

Provided technical and functional services to small, mid-size and Fortune 500 companies worldwide in database design/development, application development, and network management. Led the requirements gathering and designed/developed databases for web/client-server.

Deloitte & Touche -DRT Systems June 1997 – September 1997

Consultant

Consultant to support Oracle Applications (Financials and Human Resources) on a UNIX platform. Administered the system and developed SQL and PL/SQL applications for the system.

Osborn Laboratories, Inc. August 1990 – June 1997

Support Systems Manager

Managed a team of nine technical personnel consisting of analysts, programmers, and DBAs to support the Lab’s daily operations. Led data modeling sessions for Statistics and Marketing database/applications using Designer 2000.

Prior Experience 1987 – 1989 – Worked as a consultant on a contract for Istanbul Municipality leading the design and development of a statistical database for Istanbul’s Water and Sewer Department. During my twelve-month tenure as a Lieutenant Programmer Analyst, worked with Oracle RDBMS/ Forms, COBOL, and UNIX. Applications ranged from local office applications to national level military applications. I was also responsible for developing standards and procedures for software development.

ACCOMPLISHMENTS

Database Architecture / Management / Data Modeling / Data Integration

Led the streamlining efforts for data management processes.

Designed a relational database for a network circuit management system

Built system data flow diagrams and data mapping to aid in transformation efforts

Developed an enterprise data warehouse data model for an insurance company

Setup standards and processes for a customer communications data management practice

Published a Data Strategy document for an insurance company

Led the design of an ODS for customer facing applications.

Led the development of the database for a file tracking system through its lifecycle.

Led the development of the database to manage cable upgrade projects.

Reengineered a telecom operational database to incorporate the network planning requirements.

Reengineered and consulted on database issues for various BroadVision e-commerce projects.

Led the development of the database for a project tracking/document distribution system for engineering.

Led the development of the database design for an engineering estimating/costing system.

Managed and developed workflow and document management related databases

Led and documented a current state of customer data flow for a customer MDM solution

Mentored junior colleagues and was the resident database design consultant.

Planned, developed and delivered in-house training on data modeling and data practices for IT and business.

Reporting & Business Intelligence.

Designed star schema structures for a health care claims reporting on Hadoop/hive

Reengineered a resource management system to respond to market staffing demands on time.

Led a team of three for an Oracle procurement reporting system.

Developed reports for Oracle Applications purchasing, inventory, order entry.

Management / Project Management / Technical Leadership

Managed a team of four architects to support enterprise projects and promote enterprise data architecture.

Managed the data resources and provided estimates, tasks, deliverables to projects.

Developed selection criteria for third party tools, evaluated vendors, and made recommendations.

Active member of the Enterprise System Management Planning team for a $1.5 B insurance company

Led the development of enterprise data architecture.

Managed a team of nine to support applications and data for a reference laboratory.

Took over the maintenance of network management for a telecom client’s NOC.

Developed a strategy to purge Oracle Applications data.

Created technical designs for custom Oracle applications.

Responsible for Data Management compliance for the company security controls

Application Development

Led the development of a web application to manage telecom broadband upgrade projects in record time.

Led the development of a web application to manage cable upgrade projects.

Led the development of an Oracle Forms application to manage garment validation for a manufacturing client.

Led the development of an Oracle Forms application to manage data for a catalog web application.

Led the development of purges for Oracle Applications purchasing, inventory, order entry, BOM, WIP.

PROFESSIONAL PROFILE

Central Missouri State University, BS in BA (CIS), 1987

Oracle Masters, Systems Analyst, 1995

Data Warehousing in Depth (Kimball University), 2000

LOMA FLMI Designation, 2006

Certified Data Management Professional (CDMP), 2015

OTHER TECHNOLOGY EXPERTISE / MANAGEMENT PROFILE

Operating Systems/Platforms – Windows, NT, UNIX (System V, SCO), CICS, VMS, DEC Alpha, Honeywell 8

Databases/Data Warehouse – Oracle, SQLServer, MySQL, DB2 390, DB2 LUW, Greenplum, Apache Cassandra

Data Scrubbing/Transformation – Data Junction, DataStage, AuditStage

Databases/Data Warehouse Design/Management – Oracle Designer, TOAD, ERWin, BPWin, Bugzilla, RapidSQL, SQLNavigator, ER/Studio, Data Studio, SQL Server Management Studio

Business Intelligence Solutions – Oracle Discoverer, Business Objects

Hardware – VAX, Sun, Compaq, HP, AS/400, DEC Alpha

Application Languages – PL/SQL, COBOL, UNIX Shell, C

Network & Communications – TCP/IP, Windows NT, Novell, FTP

Network Management – Lucent TNM, HP OVC

Package Solutions – Oracle Apps, PeopleSoft, Salesforce, Archer, Remedy, Dell One Identity Manager

Methodologies – CASE, SDLC (SPLC), Agile Development

Productivity Tools – MS-Office (Word, Excel, Power Point), MS-Access, Visio, Lotus Notes, MS-Outlook



Contact this candidate