Siddartha Reddy

Infor
Global enterprise software company specializing in industry-specific cloud solutions.

Role Summary:
Architected and developed the BI module for the Infor XA ERP platform, ensuring high performance and functionality.

Key Contributions:

• Built data warehouses, cubes, reports, and dashboards using Infor tools and legacy systems (BAMF, DWD).
• Designed and implemented BIRST Analytics for sales, procurement, production, and GL reporting.
• Enhanced BIRST reporting for Infor Expense Management to improve UX and insights.
• Developed proof of concepts for Infor GEN AI initiatives to showcase innovative solutions.

Harte-Hanks
Leading provider of direct marketing strategies, enabling personalized customer engagement across the lifecycle.

Role Summary:
Handled end-to-end development and support of marketing databases, including data processing, issue resolution, and disaster recovery.

Clients: NEA, TD Bank, Sallie Mae, Toyota, TJX, Boscov's, Bed Bath & Beyond

Tech Stack: Ab Initio, UNIX, Oracle, Netezza, Trillium, UNICA, Control-M, Mantis

Microsoft (Client Project)
Provided third-level support and minor enhancements for Microsoft database applications.

Role Summary:
Handled data analysis, development support, and major data processing activities including issue resolution, disaster recovery, data and server migrations.

Key Contributions:

• Delivered third-level development support for client databases and processing systems.
• Performed troubleshooting, disaster recovery, and seamless data/server migrations.
• Executed data analysis and implemented minor enhancements to improve system performance.

Tech Stack: INFORMATICA, MS SQL Server, Azure

Global Product Reporting & Analysis Team
Focused on global product analysis, marketing insights, and product traceability through various sales channels, integrated into the Enterprise Data Warehouse.

Role Summary:
Collaborated with business teams for requirement gathering, documentation, and process design. Led architecture, design, and implementation of data objects and structures aligned with the enterprise data model and data marts.

Key Contributions:

• Analyzed dependencies, isolated and resolved data issues, and designed robust ETL processes.
• Developed and maintained data models, table structures, and entity relationships.
• Ensured seamless integration with existing enterprise repositories and reporting systems.

Tech Stack: HP AIX, Ab Initio, Teradata, ERWIN, AUTOSYS, MS SQL Server, UNIX, BTEQ, MicroStrategy

HCL Technologies – Readers Digest Project
HCL secured the contract to manage the complete IT infrastructure for Readers Digest, with a focus on delivering strategic marketing business intelligence solutions.

Role Summary:
Led the design, development, testing, and deployment of BI enhancements aligned with evolving business and marketing requirements. Architected and implemented functional modules across standardized environments.

Key Contributions:

• Developed and implemented BI solutions tailored to marketing operations.
• Designed scalable data processes and reporting frameworks.
• Collaborated cross-functionally to ensure seamless integration and performance optimization.

Tech Stack:
HP AIX, Ab Initio , TOAD, Cognos EVWEB, ERWIN, Oracle, MS SQL Server

Citigroup – Global Wealth Management Division
Centralized data services team supporting multiple departments across Citigroup’s Global Wealth Management division.

Role Summary:
Led data strategy, architecture, and services to support demographic and financial data analysis for MYFI accounts. Managed data integration from various systems into enterprise data marts.

Key Contributions:

• Captured and processed MYFI account data for analytical and reporting needs.
• Collaborated with business teams for requirements gathering, documentation, and process design.
• Identified and resolved data issues, ensuring high-quality data delivery across systems.

Tech Stack:
IBM AIX, DB2, Ab Initio , Linux, ERWIN, Oracle

GEICO – Enterprise Data Warehouse (EDW)
GEICO’s EDW hosts critical enterprise-wide data supporting key business decisions, with data marts exceeding 140 TB in size.

Role Summary:
Supported 24/7 EDW operations, including monitoring, error resolution, and process optimization. Collaborated with business teams for requirements gathering and process design.

Key Contributions:

• Ensured continuous operation and reliability of EDW processes through proactive monitoring and issue resolution.
• Analyzed dependencies, isolated data issues, and implemented corrective actions.
• Designed and documented data processes aligned with business needs.

Tech Stack:
IBM AIX, DB2, ERWIN, Ab Initio, MicroStrategy, Microsoft Visio

Citigroup/Smith Barney – Central Database (CDB) CDB serves as the central database for Citigroup/Smith Barney, supporting time-sensitive, business-critical operations.

Role Summary: Collaborated with downstream systems and business teams for requirements gathering, documentation, and process design. Developed Ab Initio graphs to meet evolving business needs.

Key Contributions:

• Designed and implemented data processes to support time-critical responses.
• Developed and enhanced Ab Initio ETL workflows based on business requirements.
• Ensured data accuracy and performance through close coordination with stakeholders.

Tech Stack:
Ab Initio, Linux, ERWIN, DB2EE 8.1, Oracle 10g, JDK 1.4

Georgia-Pacific
One of the world’s leading manufacturers and distributors of tissue, pulp, paper, packaging, building products, and related chemicals.

Role Summary:
Worked on enhancement initiatives guided by MBM (Market-Based Management) principles under Koch Industries. Focused on revising data models and automating data processes to align with evolving business needs.

Key Contributions:

• Updated existing data models to accommodate new business requirements.
• Designed and developed shell scripts for automation, process monitoring, exception alerts, remote execution, FTP, and iterative process runs.
• Ensured efficient and reliable data operations through proactive enhancements.

Tech Stack:
Ab Initio, HPUX11i, Control-M, ERWIN, Oracle 8i, SQL Server

Citigroup – CitiCapital
Formed to manage Citigroup’s commercial finance acquisitions, including The Associates, Copelco, and American Equipment Leasing.

Role Summary:
Developed automation scripts and provided production support for data processing systems. Investigated and documented data sources to support downstream reporting and analytics.

Key Contributions:

• Designed and tested shell scripts for automation, process monitoring, exception alerts, FTP, and remote execution.
• Authored technical specifications and user manuals for developed solutions.
• Analyzed and documented data transformations, filters, and aggregations to meet business requirements.

Tech Stack:
Ab Initio , HPUX, SQL Navigator, Maestro, Oracle 9i, Microsoft Project

Georgia-Pacific – Business Improvement Process (BIP) Initiative
A global leader in manufacturing and distributing tissue, pulp, paper, packaging, building products, and related chemicals.

Role Summary:
Contributed to the BIP initiative aimed at identifying cost savings within the North American Consumer Products Organization. Focused on developing custom ETL components and ensuring process reliability.

Key Contributions:

• Designed and developed custom components to support complex validation and conversion rules.
• Implemented checkpoint restarts in Ab Initio graphs to ensure process recoverability and stability.
• Supported automation and optimization of data workflows across platforms.

Tech Stack:
Ab Initio , HPUX11i, Oracle 8i, SQL Server

Harte-Hanks
A leader in direct marketing strategies, enabling deeper customer insights and personalized engagement.

Role Summary:
Led ETL process optimization and standardization across the enterprise. Focused on performance tuning, incremental loading, and quality control in Ab Initio environments.

Key Contributions:

• Reconstructed ETL graphs to improve performance and support incremental data loads.
• Disabled inefficient parallel updates and introduced auto QC checks in production workflows.
• Contributed reusable technical components and standards for enterprise-wide adoption.

Tech Stack:
Ab Initio, Red Hat Linux, Trillium, UNICA, ERWIN, Oracle

ETL Developer – Global Transaction Monitoring
Client: AMEX

Role Summary:
Supported the globalization, tracking, and monitoring of corporate customer transaction processing across international systems. Focused on automation and validation of data workflows.

Key Contributions:

• Gathered requirements and led the design, development, and testing of ETL processes.
• Created cron scripts to automate file pickups from Stratus servers and trigger Ab Initio workflows.
• Developed complex Ab Initio graphs to implement validation rules at structural, record, and field levels.

Tech Stack:
Ab Initio , Sun Solaris, IBM MQ-Series, IBM WebSphere, IBM Mainframes, Stratus Server, DB2

Sr. ETL Lead / Informatica Administrator
Client: SOURCEONE Health Care Systems
Project via CadenceQuest

Role Summary:
Led the customization of a BI solution integrated with JD Edwards OneWorld ERP, focusing on data warehousing and reporting for key business functions.

Key Contributions:

• Designed, developed, and tested data marts for Inventory, Sales, Manufacturing, Procurement, Finance (GL), and CRM.
• Created custom reports in MicroStrategy based on client-specific requirements.
• Managed the upgrade of Informatica from version 5.1 to 6.1, ensuring a smooth transition.

Tech Stack:
Informatica , MS SQL Server, Oracle, IBM DB2, JD Edwards OneWorld, MicroStrategy, ERWIN, Microsoft Visio, Windows NT/2K

Client: Southwest Airlines

Role Summary:
Gathered and transformed data from multiple sources to align with business logic and mapped it into the target Teradata database. Focused on optimizing data processing through parallelism.

Key Contributions:

• Collected and integrated data from diverse systems for enterprise reporting.
• Designed parallel data processing using Ab Initio partition components to enhance performance.
• Ensured accurate and efficient data transformation and loading into Teradata.

Tech Stack:
Ab Initio, IBM Mainframes, Oracle, Cognos, Teradata, Sun Solaris, Windows NT/2K