Amit Kumar

Project 1: State Farm Finance

• Tools Used: Alteryx Designer, Alteryx Gallery, Redshift, S3, Tableau
• Description: Built a financial data infrastructure from the ground up to support enterprise-level reporting and analytics. The project involved designing a robust data warehouse and developing Tableau dashboards to visualize financial performance across departments.
• Responsibilities:
• Designed and implemented ETL workflows using Alteryx
• Created Redshift schemas for financial data storage
• Automated data ingestion from S3 and other sources
• Developed Tableau dashboards for executive-level reporting
• Partnered with finance stakeholders to define KPIs

Project 2: MSC Cruises

• Tools Used: Alteryx Designer, Alteryx Gallery, Redshift, S3, Datorama
• Description: Developed a centralized data processing system to track and report media spend across digital platforms. The solution enabled MSC Cruises to monitor campaign performance and optimize marketing budgets using Datorama dashboards.
• Responsibilities:
• Built ETL pipelines to consolidate media spend data
• Integrated data from multiple advertising platforms
• Maintained Redshift database for reporting accuracy
• Created Datorama dashboards for performance insights
• Ensured timely data refresh and validation

Project 3: Clorox

• Tools Used: Alteryx Designer, Alteryx Gallery, Redshift, S3, Tableau
• Description: Designed and deployed a data processing framework to analyze Clorox’s media investments across various channels. The project focused on building a reliable data warehouse and delivering actionable insights through Tableau dashboards.
• Responsibilities:
• Engineered ETL workflows for multi-source data integration
• Ensured data consistency and quality across platforms
• Developed Tableau dashboards for campaign analytics
• Supported ad-hoc reporting and data exploration

Project 4: Legal Zoom

• Tools Used: Alteryx Designer, Alteryx Gallery, Redshift, S3, Tableau
• Description: Created a scalable data solution to manage Legal Zoom’s marketing spend and performance metrics. The system enabled real-time reporting and strategic decision-making through interactive Tableau dashboards.
• Responsibilities:
• Built ETL pipelines for media spend data consolidation
• Integrated disparate data sources into Redshift
• Designed Tableau dashboards for marketing performance
• Conducted data audits and troubleshooting

• Built and maintained database to optimize company data functionality.
• Converted redundant data in Excel, CSV, and other formats into structured database tables.
• Extracted data per business requirements to support decision-making processes.
• Participated in business requirement meetings to gather and clarify project specifications.
• Created design documents, including high-level design (HLD) and low-level design (LLD).
• Developed new mappings and workflows incorporating relevant business logic.
• Conducted analysis, design, development, unit testing, and deployment of Alteryx Designer components.
• Managed unit testing, migration, and scheduling activities for efficient project execution.

• The project involved building the data warehouse from scratch for utilizing the functionalities of the data generated by the manufacturing-specific module. The project involved utilizing the data saved by the manufacturing company is in excel and other tables in redundant form and converting and saving them in proper tables in a data warehouse. The project involved staging area, loading dimension tables and fact tables. The manufacturing company has stored data in multiple excel files, which was getting difficult for the company to analyze.
• Involved in Business Requirement meetings.
• Involved in design documents creation, HLD, LLD.
• Creating new mappings and workflows with business logic.
• Analyzing, Designing, Development, Unit Testing and Deployment of the Informatica components.
• Involved in Unit testing, migration and scheduling activities.
• Worked on various transformations, Tasks in Informatica.
• Involved in implementation of SCD's.

• This project involves migrating complete code written in SQL to Informatica. Existing code which was present in SQL was giving issues because of data volume, complexity, performance etc. It was decided to migrate the project from SQL to Informatica.
• Understanding existing SQL/PL-SQL code.
• Involved in Business Requirement meetings.
• Involved in creating design document.
• Working on coding, unit testing.
• Involved in migration, scheduling activities.