Orsan Kocak - Data Analyst, SCAN Health Plan

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Work Background

Global Benefits Group (GBG)AVP of Business Intelligence

Feb. 2022Foothill Ranch, California · On-site● Responsible and accountable for all Reporting and Analytics activities through the enterprise. ● Deploy multi-million-dollar initiatives utilizing a multi-continent matrixed team comprised of both associates and offshore partners. ● Responsible for Enterprise Datawarehouse Development and Enhancement Functions as well as DOMO & Python & Power BI & SQL Server Reporting Services (SSRS) Report Development and Administration. ● Overseeing data intake and validation jobs from 25 partners and 35 third party partners globally. ● Running the Enterprise Data Governance activities by leading Data Governance Management Committee (Group of all C and SVP Level individuals), and Data Governance Working Group functions. ● Supervising all Data Quality functions by Data Warehouse Packages, as well as Data Quality Reports. ● Successfully managed multi-million-dollar projects, delivering on time and within budget constraints. ● Reporting to COO, collaborated with C-level executives to define strategic goals and translate them into actionable reporting and analytics initiatives. ● Overseeing the development and maintenance of business intelligence systems, providing actionable insights to enhance decision-making processes. ● Implemented a data-driven culture by fostering collaboration between business units and IT teams. ● Management of design and deployment of dashboards and reports that improved operational efficiency and facilitated data-driven decision-making across the organization.

Global Benefits Group (GBG)Director Business Intelligence

Jun. 2019 - Feb. 2022Foothill Ranch, California · On-site● Played a pivotal role in the migration to a modern data warehouse, optimizing data storage, retrieval, and analysis processes by moving the Data Warehouse server structure to Azure Cloud. ● Oversaw the development and maintenance of business intelligence systems, providing actionable insights to enhance decision-making processes. ● Implemented a data-driven culture by fostering collaboration between business units and IT teams. ● Designed and deployed dashboards and reports that improved operational efficiency and facilitated data-driven decision making across the organization.

SCAN Health PlanManager of Business Intelligence

Nov. 2016 - Jun. 2019Long Beach, California · On-site● Tableau Administrative Functions, such as Vendor Management, Licensing, Report/Dashboard promotion to Production Environment, Access Management. Monitors Tableau system health and performance to ensure maximum availability and effectiveness for business users (developers and consumers). o Supported and administered a high functioning, collaborative community consisting of 76 Tableau developers and 300 Tableau Interactive users. o Managed and updated Standards, Guidelines and/or Policies & Procedures related to Tableau operations and content development. o Collaborated with Enterprise Data Warehouse (EDW) Team to ensure data sources are available and/or developed to support Tableau products. ● Initiated and executed a corporate data governance program while leading DG Counsel with executive leaders. ● Ensured the organizational effectiveness of BI solutions and promotes self-serve BI efforts. ● Served as primary liaison to BI vendors for product release management, testing, escalation management, product roadmap, etc. ● Managed report governance to ensure contents published to the entire organization are timely and accurate. ● Provided and promoted development guidelines to business/department report writers. ● Monitored and analyzed report utilization. Identified opportunities and gaps for BI within the organization. ● Draw upon full range of reporting features to design, develop, enhance, and support report visualizations including but not limited to highly interactive dashboards, scorecards and reports. Leveraged understanding of best practices around report development, data visualizations and visual analytics. ● Collaborated with BI team to ensure metrics, benchmarks and related content are accurately represented. ● Partnered with IT infrastructure team to ensure servers and environments are appropriate for current operations as well as strategically plan for future needs.

UnitedHealth GroupSupervisor - Analytics and Reporting Team

May. 2014 - Nov. 2016Cypress, California · On-siteSupervisor - Analytics and Reporting Team

UnitedHealth GroupSn. Business Systems Analyst

May. 2013 - Apr. 2014

MetLife InvestorsSn. Technology Liason

Jul. 2011 - Apr. 2013United States* Working under Business Intelligence & Reports Team. * Responsible with midsize projects for the in-house developed CRM Software. * Creating Reports & Analytics with MicroStrategy Business Intelligence Desktop Software. * Closely working with the Application Development Team for mainly database and warehousing projects.

MetLife InvestorsSn. Reports Analyst

Jun. 2010 - Jun. 2011* Working under "Sales Projects and Analysis" Department * Completed Segmentation Project for 160K+ Financial Advisors, and still responsible with updating and maintaining the project with report requests. * Creating and maintaining Regional Vice Presidents' and Internal Wholesalers' Scorecards * Periodically running Top Management Reports, including "Penetration", and "MoneyBook" Reports * Working closely with Marketing and Account Management Team, and running ad-hoc reports for these teams. * Working directly with Business & Technology Team on upgrading, and developing internal CRM Software called "iContact" * Reporting with SQL and MicroStrategy on AUM (Assets Under Management), Brokers' Book of Businesses, Demographic Data, Market Penetration, Money Book Cases (Potential Business Record Keeping) and other miscellaneous reports.

MetLife InvestorsTechnology Trainer

Feb. 2009 - Jun. 2010As a Technical Trainer for Business and Technology Department, I gave trainings to Sales Groups, including Internal and External Wholesalers by Net Meeting Tools. In order to start self-training practices, I had created Web Tutorials and eLearning Movies.As a business analyst, I created reports with Micro Strategy, SQL 2005 and 2008 Management Studio. For forecasting purposes, I had used Statistical Functions and Data Mining Tools to Support Business Decision Making Processes with 2008 SQL Server and 2007 MS Excel Data Mining Tools. With the “Website Initiatives” Project Team, we had developed web projects (Customer Originated Web based Applications like HYPERLINK "http://www.metlifeinvestors.com" www.metlifeinvestors.com, eService Corporate Application) I had worked with other Business Analysts to enhance and develop the In-house CRM Software (iContact) reporting to the Business and Operations Department Director.

Applebee’s InternationalBusiness and Systems Analyst

Jun. 2007 - Feb. 2009As a Business Analyst I had involved in various business operations and helped the organization to achieve cost-effective production with increased quality, efficiency and satisfied customer service. I had documented the business processes by identifying the requirements and finding the system requirements. Also took an active part in data modeling and business modeling and had experience in doing excellent documentation on business requirements with experience in gathering requirements for business enhancements.

IE Info. and Technology ConsultingIT and Business Analyst

May. 2005 - Jun. 2007Had analyzed and understood the current state processes to ensure that the clients and the project team understand the context and implications of change. As an Information Technology Analyst, I had developed an understanding of how present and future business needs will impact the solution and also identified the sources of requirements by examining how business roles help determine the relative validity of requirements. At the definition and archiving parts of the projects, I had identified and documented all technical, product and process requirements. As a decision maker, I helped my supervisor(s) to define acceptance criteria for completion of the solution.

California State University, San BernardinoTeaching Assistant

Sep. 2003 - Jan. 2005Taught 6 lab classes (in a 6 consecutive quarter-total of 900 students) of Statistics & Information Technology and graded students’ exams. I had Implemented Microsoft 2003 Excel statistics and mathematics formulas. Having Statistics the main subject, I gave real world examples to help understand the statistical applications. Also, I had supported students’ knowledge with online quizzes and lab assignments. In two projects for Prof. Bhatia, I helped him to analyze the statistical data and got reports to define the business needs for better decision making process.

3MIT Support Coordinator

Jun. 1999 - Jul. 2002I had developed 3M Turkey’s Web Site in the International Project of WCMS (Web Content Management System). As a Network Administrator, I had maintained current processes and upgraded Local Area Networks (LANs) and Wide Area Network (WAN). As a Helpdesk/Support Coordinator, I had supported the end user with related Hardware or Software Issues. Given the task as a project lead, I had took the responsibility of a Sales and Marketing Project with a team of 8 Marketing Supervisors to help collect the current business and market data in and outside the company. In order to help the end users to have a better understanding of Information Technology Tools, I gave a series of educational courses on different software packages.

Intch is a Professional Networking App for the Future of Work

100k+ people

130+ countries

AI matching

Get Intch if you'd like to

📝

Get Recommended to New Customers

👋

Connect with Like-Minded People

💸

Raise Capital

🚀