Sr. Abinitio Developer with over 11 years of extensive expertise in designing, developing, and maintaining complex data warehousing and ETL solutions. Proficient in using tools such as Ab Initio, Hadoop, and Spark to drive data-driven results and optimize performance. Demonstrates strong skills in Unix, Linux, and SQL, with a focus on improving data processing efficiencies and ensuring high-quality data migration and analysis.
Overview
11
11
years of professional experience
Work History
Ab Initio/Big Data Hadoop Developer
Florida Blue
Jacksonville, United States
01.2015 - 03.2024
Engineered robust ETL pipelines using Ab Initio, integrating AWS S3, Databricks, and Hadoop ecosystems for seamless data processing and transformation workflows.
Implemented XML and JSON parsing solutions with Ab Initio components, enabling efficient data extraction from multiple queue systems and web services.
Architected cloud-based data solutions combining AWS Redshift, DB2 Purescale, and Postgres for optimized operational and analytical data management.
Partnered with application teams to deliver comprehensive Ab Initio project support, including monthly patching and real-time job monitoring.
Provided production support for all enterprise Abinitio projects ensuring reliability.
Worked extensively on Validation scripts and automated routine tasks using UNIX shell scripting and SQL.
Extensively working on design, development, and testing environments, working on vectors, and record formats for different graphs.
Created Psets to run a generic graph with different parameters.
Effectively used error, reject, and log ports to understand component behavior.
Extensively tested ETL (Ab Initio) part, using SQL queries for consistency and errors while extracting, transforming, and loading the data.
Ab Initio Developer
SunTrust
ATL
08.2013 - 12.2014
Designed and Developed various Ab Initio graphs using Ab Initio components like Partition by key, Partition by Round robin, Join, Reformat, Rollup, Sort, Filter by expression, Gather, Merge, Normalize etc.
Developed Complex XFRs to derive new fields and solve various business requirements.
Implemented Data Parallelism through graphs, which deals with data, divided into segments and operates on each segment simultaneously through the Ab Initio partition components to segment data.
Developed generic graphs.
Loaded the fact and dimension tables focused on performance.
Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check in and checkout were used for this purpose.
Worked on improving the performance of Ab Initio graphs by using various Ab Initio performance techniques.
Written user defined functions for business process to improve the performance of the application.
Worked with the application team to understand the project needs and provided the Ab Initio project setup support along with assisting monthly patching activities.
Used Read/write Hdfs and Read/write Hive components to read data from Hadoop and write to HIVE/Hbase.
Used AbInitio Queue components to read medicare application data from MQ's and parse the XML using Read XML components.
Used Read JSON and Write JSON components to parse the data after reading from Kafka Queue using Kafka Subscribe components.
Used Web service components to validate the legitimacy of a contract number coming on the application data from source vendors.
Used multiple MFS layouts depending on the data and projects performance needs.
Worked on creating scripts to create projects, migrate Ab Initio applications using TRMC and monitor/schedule real-time jobs on ControlCenter and Control-m.
Medicare Appeals & Grievances Coordinator at Florida Blue - Blue Cross Blue Shield Of FloridaMedicare Appeals & Grievances Coordinator at Florida Blue - Blue Cross Blue Shield Of Florida
Customer Service Representative at Florida Blue - Blue Cross Blue Shield Of FloridaCustomer Service Representative at Florida Blue - Blue Cross Blue Shield Of Florida
Customer Service Advocate at Blue Cross Blue Shield of Florida, Florida BlueCustomer Service Advocate at Blue Cross Blue Shield of Florida, Florida Blue
Business Support Analyst II at Florida Blue - Blue Cross Blue Shield Of FloridaBusiness Support Analyst II at Florida Blue - Blue Cross Blue Shield Of Florida