Gourab Das

• Technical Role - Data Engineer and Solution Design
• Functional Role - Team Lead, Product Owner
• Technology Specialization - Python, GCP, Bigquery, Bucket Data Lake & Data Warehouse, AWS, AWS, Redshift, S3, Glue, Lambda, Athena, Step function, Google AppScript, Rest API, Pyspark, Apache Airflow, Luigi, Openshift, Kubernetes, Docker, CI/CD.
• Industry - IT Field Marketing & Marketing Operations
• Accolades - Red hat Team Advocate(6), Red hat Peak Performer(3), Red Hat Multiplier(8), Red hat Collaborator(5)
• Key Achievements

- Developed Qualtrics & Wrike Integration API, reducing manual form integration effort by 120 hrs/month, streamlining workflow and enhancing efficiency, resulted in efficient digital campaign management and planning.

- Implemented Python and Google Sheets API to automate marketing data consolidation, reducing manual effort by 9 hours/week. Consolidated over 900 Google spreadsheets and tabs efficiently, resulting in near real time data for marketing analysis.

- Built Robust Data Quality framework using Python, MatPlotLib, Google AppScript to identify the health of data processed in each pipeline and showcase exact error log in case of failure. Automated email to send the status to key stakeholders. This resulted in near real time rectification of data issues.

• Technical Role - BI Developer
• Functional Role - Team Lead, Business Development
• Technology Specialization - SSIS, SSRS, SSAS, IBM Cognos, Power BI, SQL Server, Azure Data Warehouse, DAX
• Industry - Pharma, Oil & Gas, Retail
• Accolades - Super Team
• Key Achievements

- Successfully designed and implemented Version 2.0 of the Pearl BSC portal, resolving lag issues and introducing multiple interfaces for entering manual KPIs based on Monthly, Quarterly, and Annual targets. This enhancement received high praise and appreciation from the customer.

- Led the design and implementation of highly configurable Executive Dashboards for a prestigious client, incorporating all leadership KPIs to track progress throughout the year. Received special recognition from the client for delivering a valuable reporting tool.

- Developed Computer System Validation (CSV) scripts for applications and database migration, enabling a pharmaceutical client to move their in-house datacenter to a shared space. The scripts facilitated automated validation and generated reports for pre and post migration, resulting in completing the migration within 50% of the estimated timeline. This reduced turnaround time and minimized business impact.

• Technical Role - BI Developer
• Functional Role - Retail Accounting, Retail Merchandising
• Technology Specialization - SSIS, SSRS, SSAS, MS SQL Server
• Industry - Retail
• Accolades - Peak Performer of the Quarter, Guiding Light, Retail Innovator of the Year, Master Stroke, R&R, GEM, CZAR
• Key Achievements

- Built the XIMT Manual job automation code using SSIS, MS SQL Server with robust fault tolerant and rectification methods. Resulted in saving manual efforts by 150 hours/month.

- Developed Physical Inventory(PI) Automation code using SSIS, SSRS, ASP DotNet, MS Sql Server to automate the PI activity and saved 280 hours/per PI Activity. Resulted in saving lot of manual efforts and lesser turn around time for business in PI activities.