Results-driven Ab Initio Developer with 5.5 years of experience designing, building, and optimizing high-volume ETL pipelines using the Ab Initio suite. Proven expertise in developing robust data workflows, implementing complex business logic, and ensuring production stability in fast-paced environments. Skilled in Unix shell scripting, Autosys job scheduling, and end-to-end ETL lifecycle support. Known for quick adaptability, strong debugging skills, and collaborative problem-solving. Experienced across banking and healthcare domains, with hands-on delivery of regulatory, operational, and financial ETL solutions. Regularly collaborated with QA and business teams, conducted code reviews, and mentored junior developers in Ab Initio best practices.
Liquidity Coverage Ratio (LCR), Discover Financial Services, 16 months, 8, Ab Initio Developer, Ab Initio, Unix, Autosys, Developed regulatory ETL jobs from scratch using Ab Initio for liquidity ratio reporting., Applied data validations and transformations as per Fed compliance guidelines., Managed STTM documentation and coordinated with QA for validation coverage., Streamlined job scheduling with full error handling and dependency management. Standard Profitability Formula, Discover Financial Services, 10 months, 7, Developer / Reviewer, Ab Initio, Oracle, Unix, Rebuilt profitability report ETLs by consolidating 15 legacy apps into 2 optimized workflows., Created robust validation layers and automated error alerts for data integrity assurance., Supported migration testing and environment transitions to ensure continuity., Developed dynamic parameter-driven graphs to handle multiple product types and profitability models with a single reusable framework., Created lookup-based join logic using broadcast and partitioned datasets to improve transformation efficiency and minimize memory usage., Implemented row-level data tracing and reconciliation logic to enable end-to-end auditability between input sources and final profitability reports. Prescription Data Analytics (PDA), Walgreens, 3.3 years, 12, Ab Initio Consultant, Ab Initio, Oracle, Unix, Designed ETL processes for daily processing of pharmacy prescription data., Tuned performance using advanced Ab Initio features (max-core, partitioning, broadcast)., Maintained SLA-sensitive jobs with 24x7 support coverage during go-lives., Built custom validation frameworks using Ab Initio components to automate field-level checks, schema validations, and file-level controls before ingestion., Implemented audit trail logging and file-level metadata capture for traceability and compliance, reducing post-load reconciliation issues., Developed pre-processing shell scripts for data cleansing and dynamic file renaming, ensuring compatibility with graph-level ingestion rules.