Candidates About

Aram J. Dodakian 

Business Intelligence Solutions performance driven professional, with over 15+ years of experience driving results, leading and managing projects and teams, and helping companies achieve a sustainable competitive advantage. Extensive knowledge of Data Analytics, Dimensional Data Modeling, Data Extractions, Data Warehouse (ETL/ELT}, Report & Dashboard creation.  Multilingual in English, Italian, and French.

Core Competencies

Analyzed complex business requirements, translated them to data requirements, systems architecture and design documents, and multi dimensional data models. Implemented multiple complex data warehousing analytics solutions, master data management, and metadata governance. Created and scheduled T-SQL ETL SSIS packages. Developed project plan and lead project and cross functional teams from initiation through design and delivery. Monitored project schedule performance and budget, and delivered project on time and under budget.

SENIOR DATA MODELER | DATA WAREHOUSE ARCHITECT (2015 to 2017)

· Implemented data warehouse dimensional models, and authored an Erwin Data Modeling Standards document, providing a unified view of strategic data assets, detailed schema, and Dimensional Data Warehousing design.  Authored Erwin data models versioning document, to support collaborative modeling utilizing Microsoft Team Foundation Server (TFS), and Visual Studio 2016.  Saved 80% in development costs by versioning Erwin Models in TFS vs. CA Erwin Model manager.

· Managed project, cross-functional, and off-shore teams. Completed an HR, Share Point and Data Warehousing and SQL development project, with SQL Server 2016 SSIS packages and enhancements for JD Edwards’s financial applications, on time and 20% under budget. Re-designed and upgraded Data Warehouse architecture, infrastructure, virtual server configuration and SSIS ETL, resulting in significant improvements in availability, performance, integrity, stability, scalability and maintainability.

· Diagnosed root cause analysis of technical issues, and implemented optimal solutions and enhancements to Praxair's Advanced Logistics System (PALS), and Global Sales and Spend Data Warehouse using Microsoft ETL/data integration tools (SSIS and T-SQL scripts), integrated with Cognos Data Warehouse Data Manager Catalog, and Oracle JD Edwards.

Accenture - Consulting Position, New York, NY

Hired to assess business trends and requirements, develop appropriate technology solutions, and leverage existing technologies, selecting the most cost-effective solutions.

SENIOR CONSULTANT- DATA MANAGEMENT AND ANALYTICS (2015)

Four month assignment, assigned to engage in Business Intelligence and data warehousing solutions, and Informatica Sales Force Analytics.

SILA Solutions Group, Shelton, CT

Re-architected, designed and built Sikorsky’s Fleet Analytics from OLTP to OLAP (Cubes and MDX)

CONSULTANT-BUSINESS INTELLIGENCE SOLUTIONS ARCHITECT (2014)

Eight month assignment. Generated functional and technical design specs for logical and physical models for Fleet Analytics Data Warehouse, and built Semantic layer OLAP models.

· Created multi-dimensional Business Intelligence, Data Warehousing, OLAP data models, and OLAP Cubes with dimensions and facts, in a relational Star Schema with skipped and ragged hierarchies and type 2 slowly changing dimensions. Used MS SQL Server Analysis Services (SSAS), and visualization Reporting Services (SSRS) and Oracle OLAP, with QlikView and Oracle Databases. Performed optimization techniques to improve OLAP cube performance.

· Built database schemas with grants to OLAP_USER and OLAP_ADMIN. Administered OLAP database schema Analytic Workspace User and Temp resources.

IDG International Data Group, Framingham, MA

Migrated OBIEE from Linux platform to Windows on Amazon Cloud EC2 servers. Supported data analytic strategies across the organization and created insightful 3D Marketing Campaign Analytics Reports and Dashboards.

OBIEE-BUSINESS INTELLIGENCE SPECIALIST (2013 to 2014)

· Migrated Oracle OBIEE 11.1.1.6.1 Applications and Analytics from Linux 3.0 server, to OBIEE 11.1.1.7.1, on Amazon Elastic Compute Cloud (Amazon EC2) Windows platform. Installed Web Logic 11g, Repository Creation Utility (RCU) and deployed Amazon Web Services (AWS).  Configured Loopback Adapter to solve Amazon Cloud Direct Access elastic IP address issues, related to connection instances across the internet.

· Developed ETL Data Warehouse/BI Solution Architecture and Design. Built the OBIEE repository physical, business and presentation layers. Implemented Object Level and Data Level Security and BI Administration.

· Implemented various 3D OBIEE Interactive Data Visualization Dashboards and Reports, to measure the success of Google Analytics marketing data, depicting how well the sales qualified leads reached their scoring targets.

H. J. Baker & Bro. Inc., Westport, CT

Hired as the only OBIEE expert in the IT Department, to translate business requirements, and product vision into application architecture and Business Analytics and Reporting solutions, and built a BI solution from the ground up.

BUSINESS SYSTEMS, ORACLE BUSINESS INTELLIGENCE SPECIALIST (2009 to 2013)

Designed, architected and deployed an Oracle Financials BI solution. Performed Business Intelligence Database Schema Design, BI Administration, Customization and OBIEE performance tuning. Developed various OBIEE OLAP dimensional hierarchies (time, skip-level, ragged, parent-child) and URL drill down navigation. Set up security at data level & object level. Developed PL/SQL queries, stored procedures, and automated ETL processes. Provided OBIEE and BI Publisher visualization, and end-user training.

· Generated data warehouse and powerful Oracle E-Business Suite (EBS) derived BI Executive centric interactive dashboards and drill-down reports, with BI Delivers/Agents (iBots), Key Performance Indicators (KPI’s), time series forecasting, multi-dimensional analysis, trending, and scorecards.

· Developed functional and technical design documentation. Created materialized views to improve query performance, which resulted in reducing query execution time from 16 hours to less than 5 seconds.

· Shortened month-end Financial close & Balance Sheet processing by 88 %, by automating GL Wand retrieval of GL data into Oracle tables for auto refresh of GL postings, for Profit and Loss (P&L), and budget vs. actual corporate OBIEE dashboards. Minimized revenue losses by 10%.

· Installed Oracle UPK User Productivity Kit tool (UPK 3.6.1) and designed and launched a Website for training remote Oracle users, dramatically reducing time to deployment.

ISA Consulting, Blue Bell, PA

 BI CONSULTANT (2008 to 2009)

· Interviewed users, and created  Data Warehouse and Business Intelligence requirements document including  reporting enhancements, change requests and new functionality

Pfizer Inc., Peapack NJ

Created and implemented architecture, design, and development of Cognos Modeling, OLAP, Business Intelligence and Analytics Solutions, Java Development, Quality Assurance, and Project Management Services.

CONSULTANT (1998-2008)

Designed, developed, and implemented Cognos metadata models, Analytics solutions, Reports, and Visualization Dashboards, that drove up revenue for a Manufacturing, Accounting and Planning, System.

· Consolidated 50 manufacturing plants with the use of a Cognos Single Sign-On Kerberos server, supporting multiple site connections, which resulted in a savings of over $4M in operating costs.

· Automated Cognos Transformer OLAP Cube build process, utilizing JAVA SDK.

· Created Cognos metadata models, developing facts and dimensions and Power Play Transformer models and OLAP Cubes, using Star schemas.

· Designed, developed and deployed a Web based Help Desk System using Microsoft.NET Framework, ASP.NET, ADO.NET, Java Script and SQL Server. Configured and maintained the SQL server, and performed SQL Server DBA tasks.

· Boosted manufacturing lead time orders by 40% by designing a Java web based Purchase Order workflow, using Kerberos Single Sign-on, with automatic routing to proper managers for approval, rejection, or comment.

Previous work experience includes work for Flexi International as Director of Financial software development.

The Polytechnic Institute of New York, Westchester, NY

Master of Science Degree, Computer Science

New York University, New York, NY

Master of Science Degree, Electrical Engineering

City College of the City University of New York, New York, NY

     Bachelor of Science Degree, Electrical and Electronic Engineering

Professional Development

Oracle University Training: Oracle BI Applications - Develop a Data Warehouse (DAC and Informatica)

Oracle BI 11g: Build Repositories

Informatica Cloud Academy- Informatica Cloud for Sales force Analytics

Proficiencies

Oracle: Oracle E-Business Suite, JD Edwards, ODI, OBIEE, BI Publisher, RDBMS, Database 11g, OBIA, PL/SQL, Oracle SQL Developer, SQL*Plus, Toad, SQL Tuning. Report and dashboard design. Trained in Tableau desktop.

Cognos: Power Play Transformer Models, OLAP Cubes, Data Manager Report Net, Cognos BI-Framework Manager, Cognos Connection, Query Studio, Report Studio, SDK, MDX.

Other: Informatica, DAC, ETL/ELT Data Warehousing Architectures, CA Erwin r9.6 Data Modeler, Kimball Multi Dimensional Data Modeling, Data Mapping, Aggregative Designs, Data architecture – Star/Snowflake / physical and logical schemas, OLAP cubes, MOLAP Design, Reporting, Database Design, Metadata Management, Visual Basic, .Net Framework, ASP.NET, ADO.NET, C++, J2EE,  JFC/Swing, Java, Java Beans, NETBeans IDE, AWT, Applets, Apache Struts, Servlets, JSP, EJB, JavaScript, CSS, HTML, DHTML, XML, XSL, XSLT, Microsoft SQL Server, Microsoft SSMS and SSDT-BI – for building SSIS/SSAS/SSRS solutions. Application Servers BEA Weblogic IBM Websphere, Apache Tomcat, Amazon Web Services (AWS) Cloud computing, and MS Project.