Uploaded File
add photo
Arunkumar
vparunme1980@gmail.com
901-834-5095
13401 Sutton Park Dr S Apt 923
Jacksonville Beach, FL 32227
Principal Technical Lead
15 years experience W2
0
Recommendations
Average rating
15
Profile views
Summary

Professional Experience Summary

  • Around 15 years of IT experience in design and development of ETL solutions using Ab Initio, Oracle, Teradata, MSSQL, DB2 for supporting data migration, data transformations & processing in data warehouse and integrating BI analytics and reporting environments through ETL solutions.
  • 2.3 years experience in developing Big data solutions using Pyspark, Scala and Kafka
  • 3 years of experience in leading ETL solutions delivery of FedEx Sales management applications and nearly 3 years in Florida Blue Healthcare.
  • Hands on working experience in SDLC Life cycle and work experience in Agile-Scrum Methodology for 3 years.
  • Experience in Gitlab for Source code version control and Jenkins for Code Migration
  • Excellent knowledge of Data Warehousing and Business Intelligence concepts and working knowledge in Data Modeling Methodologies.
  • Extensive hands-on experience in core Ab Initio concepts like Parallelism, MFS.
  • Has experience working in Healthcare, Logistics, Telecom, Retail, Insurance and Finance domains.
  • Good experience in leading teams to build ETL solutions for business capabilities and in training and mentoring team members
  • Experience in using EME for version controls, impact analysis and dependency analysis.
  • Has working experience in Conduct>It for creating Ab Initio Plans and has good experience in creating generic reusable graphs and has work experience in AB Initio Continuous Flows
  • Developed generic Ab Initio graph for loading Teradata using Fast load or API based on data volume.
  • Has working knowledge on BRE and has exposure to Ab Initio suite of products- ACE, Metadata hub, Control Center & Express>It.
  • Experience working in Big data technologies to load the data to hive and Mongo databases
  • Experience in ETL tools like Informatica and has working knowledge in Hadoop concepts of HDFS, Hive and has undergone a training using Talend.
  • Hands on experience in Unix Shell Scripting and Scheduling tools.
  • Excellent knowledge in ETL interfacing of heterogeneous source systems like various RDBMS (Oracle, Teradata, Sybase, MS SQL Server, DB2), flat files and legacy system.
  • Expert in system analysis and troubleshooting, test plan strategy, release planning and has experience in all phases of SDLC starting from requirements collection till moving the code to Production.
  • Flexible, enthusiastic and team player with excellent communication and analytical skills, ability to grasp new concepts and implement productively.
  • Hands-on experience in improving performance and troubleshooting of Ab Initio graphs.
  • Worked in client interfacing roles for clients across various domains.
  • Experience in handling concurrent projects in an offshore-onsite development model.
  • Experience in Code versioning tools like GIT, EME and Code Migration using Jenkins 1 and 2
  • Experience in Agile, Waterfall model of ETL development
  • Applied modern principles, methodologies and tools to support changing business capabilities.

Core technical and tool competencies

  • Big Data tools : Pyspark, Scala
  • ETL tools : Ab Initio 3.1.6, Conduct IT,Metadata Hub, Informatica, Talend
  • Reporting tools : Business Objects, Brio
  • Scripting Languages : Unix shell scripting
  • Version Control tools : GIT, EME, RCS, CVS, Clearcase, Visual Source Safe
  • Code Migration tools : Jenkins 1, Jenkins 2
  • Databases : Hive, Teradata, Oracle, DB2, SQL Server
  • Nosql Database : Mongo
  • Defect Tracking Tool : HP Quality Center, ClearQuest
  • Operating Systems : HP Unix, Solaris, Windows 7
  • Schedulers : Control-M, Autosys, Dollar U, Maestro, Cron
  • Others : PDSM, Visio, ITSM, Service Manager

Experience
Principal Technical Architect
Healthcare
Mar 2017 - present
Jacksonville, FL

Projects worked: CX Measurements

Environment: Big data, Spark-Pyspark and Scala, Ab Initio GDE 3.1.3, Cooperating system-3.1.3, DB2, Oracle, Hive, Mongo, Kafka, EME, Unix, Control-M, SMARTIT, Service Manager

Responsibilities:

  • Work with project business analysts to understand requirements for CX Measurements project and create tasks for the various user stories based on the corresponding features in the project.
  • Lead the ETL team to successful delivery of various surveys in Customer Experience domain
  • Design and built Ab Initio graphs and calling graphs using control-m jobs to populate the metadata process utilized by all surveys
  • Generate Spark scripts using Pyspark for various surveys and the shell scripts calling python scripts and the Shell script is called from Control-M job
  • Currently working in Creating Spark scripts using Scala for MSRT tool for Phase-2 and Phase-1 scripts developed using Scala and Kafka and the Scala jars created are called from Shell script which in turn called by Control-m job.
  • Write Shell scripts call the Pyspark scripts and the shell scripts run using control-m
  • Working in Agile methodology and has good knowledge in waterfall methodology
  • Extract the various data sources i.e EDW tables for Individual and Group data and using Dataland as sources for HCC, Address, Segment and Funding Extracts, Telephone and Plan and RELD Extracts for Combined Metadata creation to be used for all surveys
  • Create Producer and Consumer code in Scala and write the Producer output in Kafka and read the data from Kafka for the Consumer Process.
  • Built ETL process using Pyspark for populating various tables for for Various Surveys-Transactional, Relationship, Onboarding and Retail surveys, Closed Loop Survey, Digital, Payment and Post Doctor Visit Survey.
  • Involved in working with Version Control tools like GIT and EME and Jenkins for Code Migration
  • The target tables are Hive tables for various survey and the target extracts are created in Hadoop server and SFTP'ed on their respective run frequency to Qualtrics External vendor which is used for reporting and analytics purpose.
  • Control-M jobs are created for various ETL jobs and run in unit, test and stage before migrating the jobs to Prod along with the code and respective configuration files.
  • Provide System, Integration and UAT support until migrating the code to Prod.
  • Provide production support for existing surveys in Prod environment.
Ab Initio, Spark, Hadoop DB2 ETL MongoDB Oracle Shell Scripts
Remove Skill
Technical Architect
Information Technology
Oct 2013 - Mar 2017
Collierville, TN

Projects worked Adoption of SE for CASH Environment: Ab Initio GDE 3.1.3, Cooperating system-3.1.3, Ab Initio Continuous Flows, Conduct>IT, Talend, Teradata, Oracle, EME, BRE, Unix, MQC, $UVIEW

Responsibilities:

  • Work with project business analysts to understand requirements for Adoption of SE and create ETL High Level and Low-Level Design documents.
  • Design and built Ab Initio graphs and calling graphs using Wrapper scripts to integrate PSETs based graph executions, establish dependencies with various modules, implemented resource pools.
  • Access the various data sources i.e EDW tables for Segmentation, join data sources for subsequent data analysis.
  • Write Validation tests that can detect null or blank values, valid and invalid values, data patterns, invalid data relationships and uniqueness of key values.
  • Built ETL graph for populating various tables for Segmentation process which includes Hierarchy, revenue, address and attribute table loading before loading segmentation table for 5 sectors in Oracle which is a truncate and load process
  • The segmentation process has Simulation and daily ETL processes where corresponding graphs and scripts created to populate the respective streams.
  • The Simulation process is loading the data for future quarter i.e for next quarter and at the end of the quarter flipped to the daily tables.
  • The Oracle tables are converted to EDW format and the files are FTP'ed to EDW acquisition server.
  • The acquisition server has load scripts to load the various EDW tables using the scripts.
  • The source is CVM application where the source tables are extracted from Teradata
  • The various sectors are US, CANADA, LAC, EMEA and APAC for which the data is segmented to segmentation tables-SEG_1_TB to SEG_5_tb using Segmentation ETL process.
  • The segmentation data is passed to alignments process where cash engine job runs and then runs cash alignment file process using Ab Initio graphs to create Quarterly Business Alignment files, Quarter End Alignment and SBA files (daily)
  • Perform dollar-U scheduler change, scripts to trigger plan for ETL process.
  • Defect support, environment scheduling, monitoring, job abend restart and root cause analysis for CASH WBA prod support.
  • Perform Month end revenue runs and then use the revenue details to run cash engine jobs to create Quarter End Alignment files at end of each month which are sent to CSI server
  • Prepare migration plan and production history load instructions.
ETL Oracle
Remove Skill
Ab Initio technical lead
Information Technology
May 2013 - Oct 2013
Franklin Lakes, NJ

Projects worked Claims Compare Environment: Ab Initio GDE 3.1.3, Cooperating system-3.1.3, DB2, Teradata, EME, Unix, BRE, MQC, Autosys

Responsibilities:

  • Based on the business requirements document enhancing the mappings and existing graphs based on Business requirements document
  • Starting from gathering requirements and analysis, design and development, System and Integration testing and Providing Production support
  • Executing Conduct IT plan to run for various iterations of a tier
  • Creating WHSEFULL files and RDX files and sending to be adjudicated by Mainframe and comparing east and west files and sending claim compare reports for business.
  • Performance Tuning of Ab Initio Graphs and supporting System testing, Integration test environment and Preparing Implementation Plan documents for Ab Initio Support team
Ab Initio Teradata
Remove Skill
Estimation for the Design
Information Technology
Jan 2011 - Oct 2013

Projects worked SBIS Flow Mart, Claims LMA R2 Conversion Environment: Ab Initio GDE 3.1.3, BRE, Conduct>IT, Cooperating system-3.1.3, DB2, Oracle, Teradata, MSSQL, Sybase, EME, Unix, MQC, Autosys

Responsibilities:

  • Estimation for the Design, Coding and Unit testing activities to fit into Project timelines and enhancing existing Ab Initio graphs as per Schema Mapping document
  • Prepare Design documents for various workstreams in the Project.
  • Coding, Unit testing of Ab Initio Code deliverables and Review of Code and involved in code promotions to higher environment.
  • Performance Tuning of Ab Initio Graphs and supporting System testing, Integration test environment and Preparing Implementation Plan documents for Ab Initio Support team
No skills were added
Remove Skill
Space Program
Information Technology
Jan 2010 - Jan 2011
London, AR

Environment: Ab Initio GDE 3.1.1, Cooperating system-3.1.1, DB2, Oracle, Teradata, MSSQL, Sybase, EME, Unix, MQC, Control-m

Responsibilities:

  • Understand the legal requirement for Flow Mart & Claims LMA R2 Conversion, Space Project and identified the impacted BI ETL processes and propose design solutions.
  • The Flow Mart Data Model is composed of 9 stars namely Account, Policy, Competitor, Transaction, Policy State, Location, Vehicle, Driver and Rule. In Flow Mart, a Type 1 indicates a column where a changed value would require an update to the record in place, and Type 2 indicates a column where a changed value would require an entirely new row to be inserted and played a key role in building the SBIS Flow Datamarts using the Type 1 and Type 2 Models.
  • Worked in SCD Type 2 dimensions and was working in a Star Schema data model.
  • Estimation for the Design, coding and Unit testing to fit into Flow Mart project timelines and completed design and development within the timelines
  • Developed ETL process using generic graph to extract various tables from differing sources i.e SQL Server and Oracle and Teradata.
  • LMA R2 Conversion is a project where existing Practice Manager (PM application is replaced with LMA i.e Litigation Management Application for creating, tracking storing the matters/cases and played a key role in incorporating the functions of PM.
  • Worked on trillium tool for standardizing Personal and Business Entity addresses.
  • Estimation for the Design, Coding and Unit testing activities for LMA R2 Conversion to fit into Project timelines and enhancing existing Ab Intio graphs as per Schema Mapping document
  • Space Program in Sainsburys comprises Product Inbound Interface where all Product tables extracted from Oracle and then transformed to generate Product Delta files which are loaded to JDA Product tables. Similarly Store Inbound interface extracts the store tables from Sybase and then transformed to generate store delta files loaded to JDA store tables and the JDA database is SQL Server Database.
  • Preparation of High-Level design and Low-Level Design documents
  • Coding, Unit testing of Ab Initio Code deliverables and Review of Code and involved in code promotions to higher environment.
  • Involved in Performance Tuning of Ab Initio ETL graphs, processes and load routines and supporting System testing, Integration test environment and Preparing Implementation Plan documents for Ab Initio Support team.
  • Developed customized shell scripts to trigger Ab Initio process in runtime.
  • Created mapping documents with the required transformation logic, sources tables & fields for loading the target tables.
  • Design and built job schedulers using Autosys.
  • Builf XML Metadata and handling XML feeds using Ab Initio
  • Provide warranty support post production, identify and fix known issues.
  • Release planning of ETL process with interfacing applications by sending release plan documents to ETL Support team.
No skills were added
Remove Skill
Senior Ab Initio Developer
Information Technology
May 2008 - Jan 2010

Environment: Ab Initio GDE 2.15, Cooperating system-2.15, Oracle, Teradata, EME, Unix, MQC, Maestro, RCS Responsibilities:

  • Analyzing and Gathering the requirements by direct interaction with clients.
  • Prepared Mapping documents for Source to Target Mapping.
  • Worked on Low level design based on the High-Level Design provided by ETL Tech lead in EDS.
  • Developed Abinitio graphs as per the design requirements and performed performance tuning of the graphs.
  • Involved in unit testing, generation of Unit test plan document and involved in code promotion to higher environments using RCS.
  • Good knowledge of RCS, EME Code versioning tools and RCS maintains the master copy of the objects.
  • Design and built job schedulers using Maestro scripts and set the dependencies between jobs.
  • Provide warranty support post production, identify and fix known issues.
  • Release planning of ETL process with interfacing applications by sending release plan documents to ETL Support team.
Ab Initio ETL Oracle Teradata UNIX
Remove Skill
Ab Initio Developer
Information Technology
Sep 2007 - Nov 2007
Nottingham, IN
(Consultant Projects worked: Coredata Environment: Ab Initio GDE 2.15, Cooperating system-2.15, Oracle, Teradata, EME, Unix, MQC, CVS Responsibilities:
  • Interpreting the requirements by direct interaction with clients.
  • Generating Low-level design and developing custom abinitio graphs as per the design requirements for 13 constraints
  • Involved in generating code using Data Elements Framework
  • Performed performance tuning of Ab Initio graphs and maintaining Ab Initio development standards and followed Ab Initio best practices.
  • Involved in unit testing, generating unit test plan documents and support manual documents and involved in code promotions to higher environments using CVS.
No skills were added
Remove Skill
Ab Initio Developer
Information Technology
Jan 2007 - Jul 2007
Nottingham, IN
Projects worked: Data Migration Environment: Ab Initio GDE 2.15, Cooperating system-2.15, Oracle, Teradata, EME, Unix, Control-m, Clearcase, Clearquest Responsibilities:
  • Interpreting the requirements by direct interaction with clients.
  • Involved in preparing the design document as per the technical architecture document.
  • Ab Initio graphs and scripts developed and executed from control-m for the csv file containing debit card transactions which are moved to Central Staging area and created to load newly created table in PCRANEUK database.
  • Generated Brio summary and exception reports using the table data in PCRANEUK database
  • Develop unit test scripts to validate the data file in the ETL server, compare the checksum value with the signal file.
  • Performed code version control using EME for checking in the code for CSA2 server and Clearcase is the version control tool for maintaining CSA1 objects.
  • Involved in enhancement of capitalize transform function.
No skills were added
Remove Skill
Ab Initio Developer
Information Technology
May 2005 - Jul 2007
Projects worked: Virtual Call Center, MRBS, Export Predominance Calculator Environment: Ab Initio GDE 2.15, Cooperating system-2.15, Plan>It, Continuous flows, Oracle, Teradata, EME, Unix, Cron, Informatica 7.1,6.2, Visual Source Safe, Business objects XI, Test Director Responsibilities:
  • Provide recommendation and code enhancements for the identified root cause of failure.
  • Develop Ab Initio graphs and wrapper scripts
  • Analyzed and fine-tuned Ab Initio graphs to reduce the job running time to enhance performance.
  • Month end runs run as per the schedule in Production.
  • Publish manual work effort statistics on a monthly, quarterly and yearly basis and recommend reoccurring issue resolutions to save manual effort put forth by team.
  • Created Generic Housekeeping script as a part of Enhancement activity to ensure multiple project teams can reuse it by supplying the parameters for running the script from scheduling tool
  • Setup automation alert scripts to monitor Server space, file system warning.
  • Involved in job monitoring of production jobs.
  • Handling rejections by analyzing the reason for rejections for the Ab Initio record Rejections in the reject file
  • Solving Help Desk tickets and servicing the tickets by providing the resolutions based on the Severity for the various legacy systems and has exposure to handling defects in PLSQL packages
  • Involved in Monitoring Informatica Sessions and Workflows
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Computer Science and Engineering
n/a
Record has not been verified.
Skills
ETL
2021
8
Oracle
2021
8
Ab Initio, Spark, Hadoop
2021
3
DB2
2021
3
MongoDB
2021
3
Shell Scripts
2021
3
Ab Initio
2013
2
Teradata
2013
2
UNIX
2010
1
Agile Methodology
0
1
Apache
0
1
AutoSys
2013
1
Biostatistics
2007
1
BMC Control-M
2011
1
BRIO
2007
1
Business Intelligence
2020
1
Business Objects
2007
1
Business Requirements
2013
1
C
2020
1
Call Center
2007
1
ClearCase
2007
1
ClearQuest
2007
1
Cron
2007
1
CVS
2007
1
Data Analytics
2017
1
Data Migration
2007
1
Data Modeling
0
1
Git
2020
1
Gitlab
0
1
Hive
2020
1
HP
0
1
Hubs
0
1
Informatica
2007
1
Integration Testing
2013
1
Jenkins
0
1
Logistics
2020
1
Metadata
2011
1
Microsoft SMS Server
2011
1
Offshore Drilling
0
1
OLAP
0
1
ORMS
0
1
Performance Tuning
2013
1
Problem Solving
0
1
Quality Assurance
0
1
RDBMS
2020
1
Requirements Gathering
2013
1
RHadoop
2020
1
Root Cause Analysis
2017
1
Sales
0
1
SAP Detailed Scheduling
2017
1
SAS/GRAPH
0
1
Scripting
0
1
Scrum
0
1
SDLC
2020
1
Solaris
0
1
Star Schema
2011
1
Sybase
2013
1
System Analysis
0
1
System Testing
2013
1
Telecommunications
0
1
Test Scripts
2007
1
Training
0
1
Unit Testing
2013
1
Version Control
2007
1
Visual Source Cafe
2007
1
Windows 7
0
1