PerxTech: Elevating businesses with personalized loyalty programs and seamless interactions.

PerxTech is a platform specializing in customer engagement solutions. The company offers a platform for businesses to create personalized loyalty programs and seamless customer interactions.

• Efficiently collecting and aggregating Business Intelligence data, including API hits, customer onboarding counts, and campaign releases.
• Establishing a streamlined data warehousing solution for seamless visualization of metrics on the application dashboard.
• Managing load balancer and application access logs for resource optimization.
• Ensuring accurate and consistent data through the ETL (Extract, Transform, Load) process.

• We utilize AWS Glue to execute glue jobs, extracting business-related data from RDS and S3. 
• Amazon Redshift acts as the central repository for specific details, including platform metrics and tenant-related user and request counts. These data points are seamlessly integrated into dashboard formats, empowering clients with vital insights for informed decision-making.
• Amazon Redshift’s involvement ensures comprehensive log analysis and optimization, resulting in a significant enhancement in overall application performance and user experience.
• Within this data warehouse framework, we extract specific details, such as platform-related metrics and user and requests counts per tenant. These details are seamlessly integrated into dashboard formats, facilitating client understanding and decision-making.
• Through a combination of AWS Step Functions and other complementary services, including AWS Glue, we adeptly modify application and Elastic Load Balancer (ELB) logs. This synergy ensures comprehensive log analysis and optimization, enhancing the overall application performance and user experience.

• Maintained a job failure rate below 5% across all ETL processes.
• Achieved average job execution time of under 30 minutes for ETL processes.
• This solution has led to a cost savings of up to 40% compared to available managed solutions in the market. 
• Achieved a 30% decrease in API response time, improving user experience.
• Achieved a 99.9% data availability rate in Amazon Redshift, ensuring uninterrupted access to critical business intelligence and analytics, thereby enhancing data-driven decision-making capabilities.

• RDS: Perx utilizes an RDS instance to store customer and tenant-related data. Our data engineering team extracts raw data from RDS and performs ETL operations to achieve desired outcomes.
• RedShift: RedShift serves as our data warehousing solution. Processed data resides in RedShift, feeding various targets such as application dashboards, and other business analytics.
• S3 Bucket: We employ an S3 bucket to house ELB processed logs and store application logs. Additionally, artifacts are occasionally stored in these S3 buckets.
• Step Functions: Step Functions play a vital role in managing and executing glue jobs and lambda functions in a predefined sequence.
• API Gateway: API Gateway is employed for authenticating API requests, directing them to the backend, and retrieving OLAP-related data from the data warehouse.