Parul Hatwar

About Parul Hatwar

PROFESSIONAL SUMMARY: Results-driven Senior Data Engineer with 8+ years of experience designing scalable data pipelines, migrating legacy systems to cloud platforms (GCP, AWS), and optimizing data infrastructure. Proven ability to lead cross-functional teams and deliver data solutions that drive business insights and operational efficiency.SKILLS AND COMPETENCIES:• Programming: Python, SQL, R, XML, HTML, C, C++, Java• Cloud: GCP (Cloud Composer, BigQuery, Cloud Functions, Pub/Sub, Dataflow, Data Fusion, Compute Engine, IAM, Cloud Identity, GCS Buckets, Data Catalog), AWS (Redshift, Lambda)• Databases: BigQuery, Snowflake, Netezza, SQL Server, Cloud SQL, Oracle DB, MySQL, PL/SQL• Software Tools: Gitlab, VS Code, Jupyter Notebooks, Google Cloud SDK, Tableau, Power BI, SSIS, SSAS, SSRS, QlikView, Alteryx, RStudio, SAP HANA, IBM Sterling OMS, Power Pivot, VBA, JIRA, MS-Office (Advanced Excel, PowerPoint, Word)• Methodologies: Agile (Scrum), CI/CD, DevOps principles

Experience

1. Senior Data Engineer

   Tenet Healthcare

   Mar 2022 — Present · Dallas, TX, US

   Led the successful migration of DataStage jobs for the DAAC project to Google Cloud Platform (GCP), creating 78 bundles to load 225 tables sourced from 86 libraries and producing bundle detail entries.• Reduced DAAC jobs runtime from 17 hours to 12 hours by optimizing bundle execution and post-deployment throttle tuning, significantly boosting operational efficiency and cutting costs.• Migrated stored procedures and 400 tables from SQL Server to BigQuery for the Supply Chain project, resolving complex issues during the transition and ensuring code integrity.• Initiated cost-reduction initiatives targeting Novus inefficiencies, saving an estimated $100K annually.• Designed and developed a custom pre-hook Cloud Function framework to extract zip folders and load all contained files into BigQuery tables via the file ingestion framework, addressing ingestion gaps and increasing automation.• Created and maintained comprehensive documentation, including reporting lineage, a DAAC user guide, Cloud Function guides, and 50+ reporting specifications to support the reporting team.• Managed all file ingestion tasks for the Supply Chain project, including testing and troubleshooting fixed-width, Excel, zip, and pattern-matching issues; stress-tested ingestion by loading 400+ files.• Represented the Data Analytics department in the internship committee; organized leadership sessions, participated in interviews, and coordinated intern onboarding and mentorship.• Demonstrated leadership by managing a team of 8 members and onboarding 10+ offshore resources, mentoring them on stored procedure conversions, GCP tools (Cloud Functions, Airflow), data validation testing (DVT), and ingestion frameworks, resulting in a 40% increase in team productivity and efficient project delivery.

Education

• G. H. Raisoni College of Engineering

  Bachelor of Engineering - BE, Compurter Science and Engineering

  2010 — 2014

• The University of Texas at Dallas

  Master of Science - MS, Information Technology Management

Skills

• Core Java
• C++
• C
• Ms Crm 2013
• Sterling Oms
• Business Analysis
• Data Warehousing
• Eclipse
• Microsoft Sql Server
• Computer Science
• Css
• Microsoft Excel
• Tableau