
Chintan Shah
techiechintan@gmail.com / LinkedIn / +91-9930701107
422275172414
Summary
AWS Certified Solutions Architect (Associate) with an experience of 8+ years working on DWH/ETL and BI solutions for multiple internal and external clients across various sub-domains like Cloud Operations, Commercial Pharma and R&amp;amp;D (Clinical Trials). Demonstrated history and experience in leading small-medium teams for technology delivery &amp;amp; operations projects.
431800180559
Experience
Senior Data Engineer
TIBCO Software &bull; PUNE, MAHARASHTRA
Platform Ops Initiatives (May 2021 &ndash; Present) :
As a Data Engineer, mainly responsible for designing, building and maintaining cloud-based integration data pipelines &amp;amp; reports
Consolidated disparate data sources (Jira/JSD, AWS costs, Azure costs, OpsGenie alerts) into a unified Redshift DW, by leveraging Lambda (Python), SQS and IaC (Terraform, Serverless)
Implemented Python-based solution (synthetic monitoring) to regularly track availability &amp;amp; latency indicators of REST-based endpoints and product web page performance (Selenium-based)
Built &amp;amp; maintained Spotfire dashboards based on the above data - to monitor trends, engage stakeholders &amp;amp; optimise cloud costs
Worked on integration (Jira, Slack &amp;amp; XRay), issue triaging and production migration, for rollout of a new release management tool
Business Technology Consultant
ZS Associates &bull; PUNE, MAHARASHTRA
R&amp;amp;D Clinical Data Ops (Apr 2019 &ndash; Feb 2021) :
Led the Offshore team for a Fortune-500 pharma company wherein the responsibilities included end-to-end management and communication for data ingestion, data standardisation and data publishing activities across 3 clinical applications
Interacted with different client stakeholders to plan and implement multiple enhancements &amp;amp; optimisations, which led to &amp;gt;50% reduction in manual efforts and delivery turnaround time across couple of applications
Also accountable for ensuring right access controls and governance processes are in place across the clinical applications, by performing regular usage reporting and auditing
Worked with different vendors/infra support teams for issue resolution/management and UAT support
Responsible for onboarding and mentoring new members in the team Commercial DW &amp;amp; BI solution (Feb 2016 &ndash; Mar 2019) :
Responsible for requirement gathering, data modelling, estimation/planning, development &amp;amp; deployment of multiple DW releases for EU region of a Fortune-500 pharma company, utilising AWS Redshift/RDS for MSTR analytical dashboards
Comparing the outcomes/metrics from the new releases with legacy solution, analysing the gaps encountered during the process and working with the clients to gain alignment on the justifications/reconciliations
Built a Training DB solution, which comprised of pseudonymised data and corresponding dashboards for onboarding new users CRM Solution Enhancement Release (Sep 2015 &ndash; Jan 2016) :
Responsible for building and testing process flows in Dell Boomi to automate data extraction from Salesforce (Veeva CRM) and placing the extracts on client&rsquo;s SFTP location
Utilised Informatica for creating ETL flows to fetch data from flat files, apply transformations and load them into Oracle tables
For all the above processes, ensured that relevant quality checks are in place to validate source data sanity
Overall, I am a self-motivated and well-organised IT professional, with strong written &amp;amp; verbal communication skills along with proven ability to work as a team player. Additionally, I am willing to travel/relocate based on job opportunities &ndash; I have previously travelled to Germany for a release demo &amp;amp; subsequent UAT support at client location and also possess an active US B1/B2 Visa.

Skills
DB/DW and ETL Technologies : AWS Lambda, AWS Redshift, AWS RDS (PostgreSQL, MySQL), AWS SQS, AWS S3, Tibco Scribe, Paxata, SnapLogic, Informatica, Salesforce Veeva (SOQL)
Scripting Technologies : Python, Selenium, Jupyter notebooks, Unix/Shell, Java
BI Technologies : Spotfire, Tableau, MicroStrategy
Data Modeling/Design : Erwin Data Modeler, Visio
Project Infra/ Management Tools : Jira, Git, Terraform, Serverless, ServiceNow, Aha, SharePoint, SVN, HP ALM
431800163103
Certifications, Awards &amp;amp; Publications
Career Essentials in Generative AI by Microsoft and LinkedIn &ndash; Jul 2023
AWS Partner: Accreditation (Technical) &ndash; Apr 2023
AWS Partner: Cloud Economics Accreditation &ndash; Apr 2023
TCA-TIBCO Spotfire&reg; &ndash; Dec 2021
AWS Certified Solutions Architect (Associate) &ndash; Mar 2021
Data Management for Clinical Research (Coursera) &ndash; Nov 2020
Design and Interpretation of Clinical Trials (Coursera) &ndash; Aug 2020
&ldquo;Leader in the making&rdquo; Award (ZS-client initiative) &ndash; Jul 2020
A Crash Course in Data Science (Coursera) &ndash; Jun 2020
Analysis and detection of eventful messages in IMs (published in IEEE) &ndash; Oct 2016
355600192779
Education
B.E. (Information Technology) &ndash; 75.27%
D. J. Sanghvi College of Engineering &bull; MUMBAI
2011 &ndash; 2015
HSC (12th Science) &ndash; 92.5%
T. P. Bhatia College of Science &bull; MUMBAI
2009 &ndash; 2011
CBSE (10th) &ndash; 93.2%
Ram Ratna Vidya Mandir &bull; MUMBAI
2007 &ndash; 2009
422275206245
Miscellaneous
Languages Known : English, Hindi, Gujarati
Current Place of Residence : Pune
Date of Birth : 04 Sep 1993
422275665044Hobbies : Travelling/Exploring new places, Listening music &amp;amp; podcasts, Playing basketball and cricket
