Hi, I’m
Arun Chidambaram
Manager Application Development / Technology Owner
Dublin,CA
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 CaliforniaSan 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 CaliforniaSan 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 CaliforniaSan 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, IncMountain 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, IncSan 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 SolutionsMinneapolis, 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, CDIMorristown, 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 MaterialsMorristown, 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 SMMorristown, 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 SMMorristown, 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 SolutionsChennai, 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 SolutionsChennai, 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 SolutionsChennai, 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
Lead the building of Actuarial data mart for DMX
Lead Metavance Core and in parallel built Formworks team to a 7 member team and executed complex projects
Lead role in RMB conversion and Delta Vision effort working with Small business/Mid-Large Business and Allied and VSP
Lead role in collaborating with Internal Audit, Security and Risk teams for Log securityExcellence in Business Intelligence Analysis, Data Mapping and Business Process mapping
Staffing requirements, Management and Training
Resource Allocation and Strategic planning
Continuous improvements in Delivery Quality
Training and mentoring
Project Management
Analytical and Critical Thinking
Adherence to Engineering Standards
Coaching and mentoring
Budgeting
Operations management
Leading complex Non Functional testing requirements
Roadmap Development and Backlog Management
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