Arun Iyer Email & Phone Number

Calabasas, Ca, Us

Los Angles, Ca, Us

• Management of entire IT Portfolio, infrastructure, communications, governance strategies, vendor relationship and budget management. • Setup of IT infrastructure from scratch at 2 office locations, including setup of servers, VMs, firewalls, switches, network drops and access points.• Implemented and managed administration of ERP (Oracle NetSuite), CRM (HubSpot Sales, Service & Marketing) and allied systems• Single handedly managed complete migration of Service desk from Zendesk to HubSpot• Created an Enterprise Data Warehouse for Management reporting and data marts for Sales and Operations for departmental reporting using Sisense.• Setup a brand-new eCommerce platform for managing sales of UV disinfecting products • Implemented solutions for Cloud Security, Backup & Recovery and Single Sign-on• Consolidated multiple vendors providing similar solutions under a single vendor umbrella to ensure efficiencies of scale and huge cost savings.

Los Angles, Ca, Us

Dublin 2, Ie

Delivery Manager / Data Architect/Project Manager (Guidewire, Informatica, Snowflake)• Responsible for architecting, designing and project delivery to integrate Guidewire Policy Center application, and downstream data warehouse and data marts to ensure data from both legacy and modernized Guidewire application can be reported at an enterprise level. • Led an automation effort to automate the creation of test cases, scenarios and test data using python on Django framework, selenium using Java and Jenkins. • Successfully completed multiple proof-of-concepts on Snowflake (migration to the cloud), Exadata (migration from DB2-PDOA to Oracle-Exadata), Io-Tahoe (data governance tool for CCPA), Splunk Reporting etc. The PoC outcomes have helped the client layout the future business/IT roadmap.

Dublin 2, Ie

• Responsible for defining the claims data mart architecture for Farmers Insurance ensuring the road-map aligns with the long term strategic objective of the IT/Business organization and help in the realization of the end-state vision• Led the BI team in all aspects of BI solutions delivery with innovative architecture, infrastructure,performance, gap Analysis, identification of KPIs, for creation of a Claims Data Mart and a business intelligence platform for management reporting and analysis, resulting in competitive advantage• Architected and modelled the core claims subject areas starting from gathering and ratification of business requirements, creation of the Logical & Physical data models, data profiling, creation of design documents and source to target mappings.

Thousand Oaks, Ca, Us

Sr. Project Manager (Siebel CTMS, BizTalk, DataFlux)• Management of a multi-million dollar system portfolio to enable operational efficiency and business sustenance• Managing the Clinical Trial Management System in a highly validated and compliance heavy environment (GxP) • Managed team in executing a major upgrade to Siebel 8.1, move to a new data center and build out a disaster recovery environment

Woodland Hills, Ca, Us

Sr. Data Architect / Technical Project Manager (Oracle Business Intelligence, Siebel CRM, Informatica)• Created a Claims Data Mart for Farmers Claims group by integrating data across various Farmers-owned source systems like HR, Surveys, Claims and vendor systems like Call Audit, File Quality, Telephony, Investigation, Subro etc. Data was sourced from disparate databases like, Oracle, DB2, MS-SQL, MS-Access as well as excel files, flat files and vendor owned sources.• Created an Operational Data Store (ODS) on Oracle/OBIEE to capture data from Farmers HelpPoint Info group. ETLs were created in Informatica for full/incremental loads and the scheduling was implemented using DAC. Reports and Dashboards were created in Answers. Used ERwin for data modeling• Directed and designed the data migration strategy and ETL process to capture data from Siebel 6 and Siebel 8 into a single Cognos data mart to enable reporting from both sources and provide data to vendors and downstream systems. Mapped the diverse OLTP data models into a single end state data mart with emphasis on data de-duplication and data multiplexing

Woodland Hills, California, Us

OBIEE Specialist / CRM Technical Lead / Sr. Project Manager• Managed complete product development and release cycle, including product integration, change management, product verification and support for the projects, ensuring that the projects came in on time and at budget. • Demonstrated the capabilities of the Oracle BI and Siebel CRM to the CIO, CTO & CCO office, result of which, OBIEE was chosen as the analytical application of choice over Business Objects, and Siebel as the enterprise-wide application of choice in the Sales domain across all regions and sales segments resulting in a $15 million project• Implemented the Sales Analytics project resulting in increased revenue, profit margin and competitive advantage due to improved decision making based on more timely and accurate information, projected at a present value of $325,000

Sr. CRM ConsultantMCI WorldCom Colorado Springs, CO (consultant through Perot Systems, Inc.)• Created a service order system for the Global/National/Telecom customers of MCI catering to a customer base of around 100,000• Created an inventory tracking system for the Worldwide (International) customers of MCI catering to a customer base of around 40,000

Sr. Software Engineer• Created an independent data warehouse for the Baan Finance product• Developed APIs for various objects such as financial statements, payments processing, budgeting, etc., to integrate and facilitate ease of data exchange with external products • Developed an interface between Baan & Hyperion

Technical Management Program, Information Technology Project Management

Cfa & Dbm, Finance And Accounts

M.C.A, Computer Applications

Icwai, Budgeting & Cost Accounting

B. Com, Accounts & Finance