Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Hi, I’m

Arun Chidambaram

Manager Application Development / Technology Owner
Dublin,CA
Arun Chidambaram

Summary

Technology leader with expertise in building, leading teams and planning , designing, creating, implementing, successfully rolling out complex migrations and data conversion solutions and maintaining/supporting projects for multiple industry areas/domains with a varied technology stack.

22 Years of Lead, Design, Development and programming experience with Management and Technical expertise in Cloud Migration, End to End Data Integration, Streaming data, Analytics, Data Warehousing, Data Marts, Decision support systems with special emphasis on, ETL Design, ETL Development, App Development, Business Intelligence Report Development, Conversion, Maintenance and Production support.


Successful Track record of lead, set up, manage, successfully launch and maintain major programs and/or cross platform efforts and lead the data conversion efforts for Member companies with excellent planning and multiple test runs with great business collaboration using Agile and Waterfall Methodologies in collaboration with Product management, Project management, Infrastructure, Security, Risk, Finance, Application Development and Delivery teams to get the business vision implemented.


Excellent people management, team building skills, problem-solving skills dedicated to streamlining development, support and operations to increase quality, decrease costs and promote organizational efficiency using independent decision-making skills and sound judgment to positively impact company success.


Collaborative leader with dedication to partnering with coworkers to promote engaged, empowering, equitable and sustainable work culture.

Overview

22
years of professional experience

Work History

Delta Dental of California
San Francisco, Oakland, CA

App Dev Manager/ Technology Owner
10.2016 - Current

Job overview

  • Lead critical and complex Metavance modernization project from Planning, Design, Development , Testing, Implementation, Team Building , Training and Support focusing on excellence and adherence to engineering/SDLC standards
  • Lead and Built Formworks team from 0.5 to 7 team members and accomplished multiple Business, Technology and Technology Currency priorities with solid back log for Automation and Process improvement
  • Lead Delta Vision Initiative from IT system impact and estimation perspective for offering Vision insurance in addition to Dental insurance by collaborating with Allied Administrators and VSP
  • Lead Delta Dental Member company - DDAZ conversion effort working with DDAZ business team and DDWI technology to convert Advantech data into Metavance and managed all dependencies with DDAZ business teams
  • Build Delta Dental Member Company - DDAZ support team for Maintenance and system support of DDAZ activities
  • Lead role in Delta Dental Member Company - DDCO conversion effort working with DDCO business team and DDVA technology to convert DCS 2000 system data into Metavance
  • Lead role in Tech Currency Prioritization effort for 2020
  • Lead role in Log cleanup effort based on findings from Internal Audit
  • Work with Infrastructure team for KTLO Shift activities for transitioning activities from DEV to EL2 teams

Delta Dental of California
San Francisco, CA

Technical Specialist
11.2013 - 10.2016

Job overview

  • Lead role in DMX Actuarial data mart effort to build data mart from scratch based on requirement to reconcile converted data using reports generated from data mart
  • Collaborate with DMX business to get requirements, design based on requirements, code, test, validate and cutover to production
  • Critical Lead Role in RMB billing conversion for RMB upgrade project
  • Designed and Coded ESP 2.0 MPNA PCP updates and patches
  • Performed monthly MTV patches for MPNA issues for DHMO Capitation Roster
  • Created and implemented Small Business rate updates
  • Development and Production support role for many critical Interfaces

Delta Dental of California
San Francisco, CA

ETL Lead Developer
10.2008 - 10.2013

Job overview

  • Created Design for complex Data Integration
  • Created Mappings in BODI/DS ETL tool based on Design
  • Created Unit Test Plan and Unit Test Case Documents
  • Created SQL scripts for validating with source data
  • Used ERWin to create Logical and Physical data model for design
  • Used HP QC/Mercury Quality Center tool to track test cases to closure
  • Used ClearQuest to track defects to closure
  • Performed Integration and System testing along with source and target systems
  • Tested complete job flow with other dependencies using TIDAL Scheduler
  • Created data and scripts to check for performance of BODI Job
  • Production Support and Job Monitoring during billing cycle
  • Environment/Tools: BODI XI R2 / BODS 12.1, SQL, PL/SQL, ERWin, HP/Mercury Quality Center, Clear Quest
  • RDBMS: Oracle 9i / 10 g
  • SOURCE/TARGET: Oracle Applications, Metavance, Legacy Input Files, XML, Oracle 9i

Symantec, Inc
Mountain View, CA

ETL Lead Developer
09.2007 - 09.2008

Job overview

  • Designed and created ETL code installations, aiding in transitions from one data warehouse to another,Design, Development and Testing of Informatica Mappings
  • Validated scheduled Jobs and Modules in Appworx Scheduler,Created PL/SQL Routines for validation of data,Created SQL scripts for validation with the source data

Cisco Systems, Inc
San Jose, CA

ETL Developer/ Reports Developer
12.2006 - 08.2007

Job overview

  • CA Entitlement Data warehouse Responsibilities:
  • Design, Development and Deployment of ETL routines in PL/SQL, SQL in Oracle 9i, Validated Data through different kinds of reports, Developed ETL Testing Strategy and Test Plans


Honeywell Automation and Control Solutions
Minneapolis, MN

ETL Developer
01.2006 - 12.2006

Job overview

  • Design, Development and Deployment ETL routines using PL/SQL
  • Created mappings using Pervasive Data Junction and BODI for data transfer from the local data mart to the Salesforce.com system
  • Created Data model using Erwin Tool, Design and Development of Data mart for Data transfer to Salesforce.com system, Validated Data through different kinds of reports, Used $Universe for the scheduling of the jobs for data transfer, Salesforce.com system testing for the reflection of the right relationship between various customer entities

Honeywell Corporate, CDI
Morristown, NJ

ETL Developer
04.2005 - 01.2006

Job overview

  • Created Design and Documentation for Source to Target Mappings
  • Designed the logical Data model using Erwin Tool, Design, Development and Deployment of Integration routines using PL/SQL and BODI, Enhancements to the existing BODI jobs for new data requirements, Developed & executed comprehensive test plans for Unit, Integration and System testing

Honeywell Specialty Materials
Morristown, NJ

DW Developer
07.2003 - 03.2005

Job overview

  • This project also involved handling the impact of the following on the Data Warehouse, Migration of target Databases from Oracle 8i/9I, Migration 7.x DB Links to 9I database,Migration of Source versions from SAP 4.0.B to 4.7, Fine tuning of data loads
  • Rollouts of existing source systems to SAP

Honeywell SM
Morristown, NJ

ETL Developer
04.2003 - 07.2003

Job overview

  • Creating fact and dimension tables based on specifications
  • Interact with business community and gathered requirements and incorporated identified factors into BODI (Data Integrator) mappings to build Data Mart, Design and create complex source to target mappings using various transformations,Developed the ETL specifications design and completed the development and implementation of the same using ACTA and PL/SQL


Honeywell SM
Morristown, NJ

MQL Developer /Java Developer
03.2003 - 04.2003

Job overview

  • Participate in the Design Team and user requirement gathering meetings
  • Interacting with onsite coordinator, identify user requirements and creating Functional Requirement Specification, Low level Design, Unit Test Document
  • Design and development of DB Scripts in MQL
  • Develop and deployment of JSP pages and integrating with the existing application
  • Review and Testing of the integrated environment
  • Environment/Tools: Sun Solaris 2.8(Hosting Web and Application servers), IBM AIX 4.3.3 (Hosting Database server), Websphere Application Server 3.5.4, eMatrix 9.5.0.4 with eMatrixServletRMI 9.5.0.4, Application Exchange Framework 9.2.0.2, Engineering Central Suite 9.0.3.3, Information Central Suite 9.0.1.1, Oracle 8.1.7, iPlanet Webserver 4.0, JDK 1.2.2.

GE Medical Systems Asia, Singapore, Mascot Systems, iGate Global Solutions
Chennai, India

SQL / Java Developer
09.2001 - 03.2003

Job overview

  • Collaborate with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts
  • Interacting with customers, identify user requirements and creating Functional Requirement Specification,Design and development of routines using PL/SQL for enhancements


GE Medical Systems, Mascot Systems, iGate Global Solutions
Chennai, India

PL/SQL Developer / Java Developer
06.2001 - 08.2001

Job overview

  • Developed Low Level Design and Unit Test Plan, Designed and Created tables in Oracle DB and PL/SQL stored procedures
  • Developed front-end code in Java and Pl/SQL procedures for backend processing of data

GE NBC, Mascot Systems, iGate Global Solutions
Chennai, India

PL/SQL Developer / Java Developer
03.2001 - 06.2001

Job overview

  • Developed Low Level Design and Unit Test Plan
  • Development of front-end code in Java and Pl/SQL procedures for backend processing of data

Education

Bachelor of Engineering from Electrical and Electronics

Skills

    Planned, Executed and Built teams as part of MTV Modernization and Major Conversion efforts

undefined

Accomplishments

  • Lead a team of 50 Staff Members (9 FT + 41 Contract/Vendor) staff members
  • Onboarded, Managed, Trained and Lead teams with varied skills to accomplish results in Core Platform, K8S/Linux, Test Automation, Business Analysis , Technical Program management
  • Lead, Documented and Completed items related to NFTs, Batch Tolerance which led to successful resolution of major asks from Senior Leaders
  • Collaborated with 4 Member companies and 2 External Organizations in the development of Member company conversions and Vision Implementation planning
  • Lead the Formworks Server and DB upgrade to completion by Collaborating with Infra, Product, Business , Support and Vendor teams during the MTV Modernization project by efficient planning, streamlined communication, Prioritization and testing for all possible options
  • Enabled an excellent rollback strategy for MTV Modernization and Formworks upgrade by planning for all possible outcomes in a Live environment
  • Created a strong succession plan with hands-on training for all resources in Metavance and Formworks to ensure Business/Technology continuity and access to growth/training opportunities
  • Directed and engaged with the team to align with all the Engineering Best Practices and defined a clear road map for implementing the expert recommendations
  • Directing and goal setting for the team members for training new technical skills, soft skills and having a better balance of work/life for best overall outcomes with quality deliverables

Timeline

App Dev Manager/ Technology Owner

Delta Dental of California
10.2016 - Current

Technical Specialist

Delta Dental of California
11.2013 - 10.2016

ETL Lead Developer

Delta Dental of California
10.2008 - 10.2013

ETL Lead Developer

Symantec, Inc
09.2007 - 09.2008

ETL Developer/ Reports Developer

Cisco Systems, Inc
12.2006 - 08.2007

ETL Developer

Honeywell Automation and Control Solutions
01.2006 - 12.2006

ETL Developer

Honeywell Corporate, CDI
04.2005 - 01.2006

DW Developer

Honeywell Specialty Materials
07.2003 - 03.2005

ETL Developer

Honeywell SM
04.2003 - 07.2003

MQL Developer /Java Developer

Honeywell SM
03.2003 - 04.2003

SQL / Java Developer

GE Medical Systems Asia, Singapore, Mascot Systems, iGate Global Solutions
09.2001 - 03.2003

PL/SQL Developer / Java Developer

GE Medical Systems, Mascot Systems, iGate Global Solutions
06.2001 - 08.2001

PL/SQL Developer / Java Developer

GE NBC, Mascot Systems, iGate Global Solutions
03.2001 - 06.2001

Bachelor of Engineering from Electrical and Electronics
Arun ChidambaramManager Application Development / Technology Owner