SUNEEL KUMAR AARANI
Tampa,FL
Summary
Overall, 19 years of enterprise IT experience delivering large-scale solutions across Ab Initio, Tableau, Oracle PL/SQL, and enterprise data warehousing platforms within highly regulated environments. Strong experience integrating Ab Initio ETL pipelines with Oracle databases and external systems across multi-region enterprise environments. Broad experience in enterprise data warehousing and dimensional modeling, including star and snowflake schemas, ODS, data marts, fact and dimension tables. Extensive hands-on experience in Ab Initio ETL architecture and development, designing parameterized, reusable, and performance-optimized graphs for batch, near-real-time, and continuous-flow processing. Optimized a high-volume PL/SQL stored procedure by replacing cursor-based logic with set-based SQL and bulk processing, enabling partition-wise operations and reducing runtime significantly. Ability to lead and mentor technical teams, define development and coding standards, conduct detailed code reviews, and ensure production-ready deliverables. Hands-on experience in designing, developing, and delivering enterprise-grade BI and analytics solutions using Tableau Desktop, Tableau Server, and Tableau Online. Proven expertise in translating complex business requirements into high-impact dashboards, scorecards, and executive-level reports that enable data-driven decision-making across finance, sales, operations, and leadership teams. Extensive experience working with large, complex datasets sourced from relational databases (Oracle, SQL Server), cloud platforms, and flat files. Strong proficiency in advanced SQL for data extraction, transformation, and performance optimization, including joins, subqueries, window functions, and query tuning. Strong understanding of data visualization best practices to ensure clarity, accuracy, and usability for both technical and non-technical stakeholders. Strong experience in designing and developing interactive dashboards and reports, applying data visualization to deliver executive-level and operational insights. Expertise in advanced Tableau calculations, including LOD expressions, table calculations, calculated fields, sets, parameters, and actions to support complex business metrics. Hands-on experience in data modeling and data blending, working with both extracts and live connections, and implementing incremental refresh strategies for optimal performance and scalability. Hands-on experience in Tableau Server administration, including publishing and managing workbooks, scheduling extracts, setting up row-level security (RLS), user access controls, performance monitoring, and troubleshooting production issues. Optimized dashboard performance by minimizing over-fetching, reducing data granularity, leveraging context filters, and improving extract refresh strategies.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Senior ETL DW Developer | BI Engineer
CITIBANK
Tampa, FL
04.2019 - Current
- Modernized Excel-based EUC regulatory reporting by implementing centralized, governed Tableau dashboards on certified enterprise data sources, reducing operational risk and manual dependencies.
- Delivered regulatory and governance dashboards to track EUC remediation status, exceptions, SLA adherence, and audit readiness.
- Supported Enterprise Development Platform (EDP) governance by providing Tableau analytics for use-case registration, approval workflows, SDLC milestones, and ITESM compliance, enabling real-time visibility and improved decision-making.
- Designed and developed Ab Initio ETL graphs to process high-volume data from multiple source systems into enterprise data warehouses and downstream applications.
- Built complex batch and continuous flow graphs using joins, lookups, aggregations, rollups, partitions, and sort components to meet business and performance requirements.
- Developed reusable Ab Initio components, parameter files, and metadata-driven frameworks to support scalable and maintainable ETL solutions.
- Optimized Ab Initio job performance by applying parallelism, partitioning strategies, memory tuning, and efficient component design.
- Developed complex Ab Initio graphs in GDE using joins, rollups, aggregations, sorts, lookups, deduplication, and transformation components for enterprise DW and data mart loads.
- Built reusable and parameterized components using PSETS and PDL programming, significantly reducing duplicate code and improving development efficiency.
- Implemented meta-programming techniques to dynamically generate graphs and layouts based on metadata stored in EME.
- Implemented error handling, logging, and audit controls within ETL workflows to support operational support and regulatory requirements.
- Worked closely with business analysts, data modelers, and downstream reporting teams to align ETL logic with business rules and reporting needs.
- Designed end-to-end Tableau solutions by selecting the appropriate connection strategy (live vs extract) based on data volume, concurrency, and performance requirements.
- Developed complex Tableau dashboards using parameters, sets, calculated fields, LOD expressions, table calculations, and dynamic filters to support real-time business scenarios.
- Created reusable calculated fields and standardized KPI logic to ensure consistency across multiple dashboards and reports.
- Built drill-down and drill-through functionality using dashboard actions to allow users to navigate from summary views to transaction-level details.
- Designed efficient Tableau data models by joining multiple fact and dimension tables, validating grain alignment, and avoiding data duplication issues.
- Implemented row-level security using user filters, calculated fields, and security mapping tables to ensure data confidentiality across roles and regions.
- Optimized dashboard performance by reducing data granularity, limiting the use of high-cardinality dimensions, minimizing custom SQL, and leveraging context filters where appropriate.
- Created and managed Tableau extracts with incremental refresh strategies to reduce refresh time and system load.
- Published dashboards and data sources to Tableau Server or Tableau Cloud, managing projects, permissions, schedules, and extract refresh failures.
- Worked in Agile/Scrum environments, delivering Tableau development tasks within sprints and providing regular status updates to stakeholders.
- Deployed and managed databases on cloud platforms such as OCI and Azure, implementing cloud-native monitoring, backup, recovery, and security best practices.
- Handled change requests and enhancements by performing impact analysis on existing dashboards and implementing changes without breaking downstream dependencies.
- Provided post-production support, including root cause analysis for data mismatches and coordinating fixes with upstream data teams.
- Mentored junior Tableau developers by reviewing dashboards, improving calculation logic, and enforcing visualization and development best practices.
- Designed and developed complex Oracle PL/SQL packages, procedures, functions, triggers, and analytical queries supporting fact, dimension, and aggregate tables.
- Built high-availability and point-in-time reporting layers, enabling historical analysis and regulatory reporting.
- Extensive experience supporting Oracle Financials Procure-to-Pay (P2P) lifecycle, including requisitions, purchase orders, receiving, invoices, payments, and accounting flows, working closely with functional finance teams.
- Developed and customized EBS reports, interfaces, and integrations using PL/SQL, Oracle APIs, and standard EBS tables, ensuring compliance with accounting and audit requirements.
- Worked on Oracle Cloud development, including Autonomous Transaction Processing (ATP) database development, complex SQL/PLSQL logic, and exposure of data through REST APIs.
- Designed and implemented integrations using Oracle Cloud Integration (OCI/OIC) to connect Oracle EBS, Oracle Cloud Financials, and external systems.
- Built web-based and reporting applications using Oracle APEX, enabling internal users to access operational and financial data securely.
Senior Ab Initio Developer | PL/SQL Developer
CITIBANK
Tampa, FL
09.2012 - 03.2019
- Business Activity Warehouse is a Global Data warehouse that contains detailed expense information from a wide variety of sources, including supplier- and third-party-related spend and reimbursements.
- Authorized users can obtain detailed and summary expense reporting information based on their roles, privileges, and entitlements.
- BAW also has reporting capabilities that consolidate supplier spend with the vendor contract. This is used to negotiate leverage and plan sourcing strategies for sourcing managers.
- BAW offers complete visibility into spending across the corporation for supplier- and third-party-related spend and Travel & Expense (T&E) reimbursements.
- Expert-level mastery in designing and developing complex ETL mappings using multiple Ab Initio components.
- Worked closely with business analysts and source system teams to analyze functional requirements, data flows, and source system constraints, translating them into scalable Ab Initio ETL designs.
- Prepared High-Level Design (HLD) documents covering data ingestion strategy, subject areas, parallelism approach, and error-handling framework.
- Created Detailed ETL Design (LLD) including source-to-target mappings, transformation rules, data quality checks, lookup logic, reject handling, and reconciliation strategy.
- Developed complex Ab Initio graphs in GDE using joins, rollups, aggregations, sorts, lookups, deduplication, and transformation components for enterprise DW and data mart loads.
- Built reusable and parameterized components using PSETS and PDL programming, significantly reducing duplicate code and improving development efficiency.
- Implemented meta-programming techniques to dynamically generate graphs and layouts based on metadata stored in EME.
- Designed and implemented Ab Initio Plans to orchestrate dependent workflows, handle conditional execution, and support restartability.
- Actively used Ab Initio EME for metadata management, version control, tagging, promotion, and impact analysis.
- Ensured compliance with enterprise ETL standards, naming conventions, and metadata documentation requirements.
- Applied data, pipeline, component, and partition parallelism to handle multiterabyte data volumes within strict SLA windows.
- Designed partitioning strategies (hash, range, round-robin) based on join keys and data distribution patterns.
- Tuned ETL performance by optimizing join types, sort keys, file layouts, and partition counts.
Ab Initio Developer
CITIBANK
Tampa, FL
02.2011 - 08.2012
- There are three sources and eight warehouse units in this system that push GL information and reference data into the CBNA system.
- TGL Warehouse Unit, NACB Warehouse Unit, NAPGL Warehouse Units. GL data is loaded into the local Fact table as a destructive load for a particular month.
- Only stores one set of data per month and has a book date in the header. Reference data is loaded into the Dimensions and may or may not include the book date in the header; it is inserted/updated.
- Provided the knowledge transfer to the team members to analyze the issues.
- Expert-level mastery in designing and developing complex ETL mappings using multiple Ab Initio components.
- Developed complex Ab Initio graphs in GDE using joins, rollups, aggregations, sorts, lookups, deduplication, and transformation components for enterprise DW and data mart loads.
- Built reusable and parameterized components using PSETS and PDL programming, significantly reducing duplicate code and improving development efficiency.
- Implemented meta-programming techniques to dynamically generate graphs and layouts based on metadata stored in EME.
- Actively used Ab Initio EME for metadata management, version control, tagging, promotion, and impact analysis.
- Ensured compliance with enterprise ETL standards, naming conventions, and metadata documentation requirements.
- Applied data, pipeline, component, and partition parallelism to handle multiterabyte data volumes within strict SLA windows.
- Designed partitioning strategies (hash, range, round-robin) based on join keys and data distribution patterns.
- Tuned ETL performance by optimizing join types, sort keys, file layouts, and partition counts.
Ab Initio Developer
CITIBANK
US
03.2008 - 12.2010
- Business Activity Warehouse is a Global Data warehouse that contains detailed expense information from a wide variety of sources, including supplier- and third-party-related spend and reimbursements.
- Authorized users can obtain detailed and summary expense reports based on their roles, privileges, and entitlements.
- BAW also has reporting capabilities that consolidate supplier spend with the vendor contract. This is used to negotiate leverage and plan sourcing strategies for sourcing managers.
- Worked closely with business analysts and source system teams to analyze functional requirements, data flows, and source system constraints, translating them into scalable Ab Initio ETL designs.
- Prepared High-Level Design (HLD) documents covering data ingestion strategy, subject areas, parallelism approach, and error-handling framework.
- Created Detailed ETL Design (LLD) including source-to-target mappings, transformation rules, data quality checks, lookup logic, reject handling, and reconciliation strategy.
- Developed complex Ab Initio graphs in GDE using joins, rollups, aggregations, sorts, lookups, deduplication, and transformation components for enterprise DW and data mart loads.
- Built reusable and parameterized components using PSETS and PDL programming, significantly reducing duplicate code and improving development efficiency.
- Actively used Ab Initio EME for metadata management, version control, tagging, promotion, and impact analysis.
- Ensured compliance with enterprise ETL standards, naming conventions, and metadata documentation requirements.
- Design of Unit Test plan and involved in Unit Testing.
ETL Developer
CITIBANK
UK
09.2006 - 02.2008
- Legal Entity Aggregator (LEA) will enable the collection and aggregation of Credit Risk Weighted Assets (RWA) on a legal entity basis, validate the integrity of this information to the submitted financials for the legal entity, and support the reporting of Credit RWA by legal entity for all applicable entities within Citigroup.
- To start, LEA will support US Reporting only; in the future, the aim is to help both US Reporting and Local Legal Entity Reporting.
- This BASEL II reporting system has four sources: Wholesale, Retail, Equity, and Securitization.
- Extraction, Transformation, and Loading job of the data warehouse using Informatica.
- Creation of Ab Initio Graphs builds business rules to load data using various transformations.
- Developed ETL solutions using Informatica and Ab Initio for Basel II regulatory reporting.
- Designed mappings, transformations, workflows, and unit test cases.
- Integrated data from multiple source systems, including Wholesale, Retail, and Credit platforms.
Education
Bachelor of Technology - EEE
Skills
- ETL
- Data Integration
- Ab Initio
- Informatica
- DataStage
- Oracle
- SQL Server
- SQL Developer
- Erwin
- Tableau
- Business Objects
- Power BI
- PL/SQL
- SQL Packages
- Procedures
- Functions
- Triggers
- Ref Cursors
- Dynamic SQL
- Exception Handling
- ORDS
- OCI
- Oracle APEX
- Integration Cloud
- WebLogic
- Amazon Q
- GitHub Copilot
- Data Modeling
- OLTP
- OLAP
- Star Schemas
- Snowflake Schemas
- Data Marts
- ODS
- Autosys
- Control-M
- Cron
- Ops Console
- CI/CD
- Appian Application Packages
- Environment Promotion
- BFS
- Unix
- Linux
- Windows
- Microsoft Azure
- AWS
- Google Cloud Platform
- Azure DevOps
- RLM
- Git
- Bitbucket
Certification
- Achieved a one-year course certificate from NIIT for HWC (part of DNIIT), India.
- Gen AI Certified from Citi & Virtusa
Timeline
Senior ETL DW Developer | BI Engineer - CITIBANK
04.2019 - Current
Senior Ab Initio Developer | PL/SQL Developer - CITIBANK
09.2012 - 03.2019
Ab Initio Developer - CITIBANK
02.2011 - 08.2012
Ab Initio Developer - CITIBANK
03.2008 - 12.2010
ETL Developer - CITIBANK
09.2006 - 02.2008
Sri Venkateswara University - Bachelor of Technology, EEE