Kashyap Parekh

Role: Senior Data Engineer ● Designed and developed reliable and scalable data pipelines for Audience and Digital Ads measurement system to target customers and boost Ad sales by 10-20% ● Streamlined infrastructure required for optimal data integration of large data sets using SQL, Spark, Python and AWS ● Analyzed business requirements to identify deliverables, gaps and inconsistencies following Scaled Agile Framework (SAFe) ● Engineered Modern Data Architecture framework targeted to improve project execution speed and efficiency by 30% ● Implemented AWS CloudFormation scripts using Python to setup necessary AWS services like EC2, RDS, EMR, S3 and Redshift ● Devised accelerator process in UNIX Shell to configure individual components like Kafka, Airflow, Spark and Terraform ● Managed developed source code and continuous integration via Git and Jenkins ● Recognized as ‘Valuable Player’ in getting the MDA framework up and running by the Senior management

Role: Data Engineer ● Delivered custom data integration process from legacy mainframe P&C policy administration systems to IBM InfoSphere MDM ● Implemented a ‘Post-Event’ analysis system that resulted in 25% increase in ROI of trade promotions for the client ● Initiated and executed process enhancements: automate manual processes, optimize data loads, eliminate redundancies improving execution performance by 30% ● Identified gaps in functional specifications, data mappings and prepared technical documentation

Role: Graduate Assistant ● Worked on the project to automate the scholarship payments system as a liaison between Financial Aid office and Technical vendor team. Main tasks include understanding process flow, requirement gathering and designing the solution for automated payments of scholarships. ● Worked on the existing scholarship portal by educating users, conducting training sessions and help users troubleshoot the issues faced by them.

Role: Project Intern ● Collaborated with the client and the project team to gather requirements for a mobile application on an Android platform. ● Analyzed the project requirements, prepared project plan and tracker to monitor the progress of the project ● Worked with the development team in implementing the functionalities and test the application

Role: Data Integration Lead ● Delivered ETL pipelines using Informatica integrating data from SAP and Sabrix systems into Corporate tax reporting system ● Streamlined BI reports providing insights on tax payments and returns by bringing down discrete reports from 6 to 2 ● Designed process enhancements that reduced cost, reduced time and increased revenue by 8% ● Led data integration team of 6 members, reviewed code to ensure optimization and adherence to industry standard coding practices ● Conferred with ‘On the Spot’ award for noteworthy leadership in project delivery and exceeding client’s expectations

Role: ETL Lead/ Developer ● Delivered ETL solution to load data from multiple claims systems to the Claims Data mart ● Optimized ETL transformation logic and SQL queries of the data loads and achieved a reduction in total execution time by ~50% ● Accomplished successful data migration of clinical trials data from legacy system to Siebel CRM system ● Awarded as ‘Project Star’ for exemplary work towards project’s success

Role: Database Developer ● Developed management reporting solution using Oracle SQL and PL/SQL for customer service team ● Contributed in devising Mobile Number Portability(MNP) solution to handle customer port-in and port-out requests

Role: Project Intern ● Implemented Content Management System for website development using Java/JSP and MySQL.