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