Information Technology Data Engineer

Kajal Papat

945-***-**** **********@*****.*** Dallas, TX www.linkedin.com/in/kajalpapat

SUMMARY

Data Engineer with over 3 years of experience in extracting, transforming, and analyzing complex datasets using SQL, Python, and data visualization tools. Proven track record of delivering actionable insights, optimizing data pipelines, and collaborating with cross-functional teams to improve decision-making efficiency. Pursuing a MS in Information Technology and Management at the UT Dallas.

EDUCATION

The University of Texas at Dallas, Texas (GPA 3.78) May 2026 Master’s in Information Technology and Management

Cummins College of Engineering for Women, India (GPA 3.4) Oct 2020 Bachelor of Technology in Information Technology

TECHNICAL SKILLS

Programming Languages : Python (Pandas, NumPy, Matplotlib), SQL, PL/SQL, Unix Shell Scripting, R Databases : Oracle 11g/12c, MySQL Workbench, PostgreSQL BI & Analytical Tools : Tableau, Power BI, MS Excel (Pivot Table, VLOOKUP) ETL Tools : Informatica Cloud (IICS), Informatica Power Center, Apache Airflow Cloud and Other Technologies: AWS S3, ServiceNow, JIRA, Tidal Scheduler, Microsoft Office Suite WORK EXPERIENCE

Accenture Pune, India

Data Engineering Analyst Mar 2023 – Jun 2024

• Developed and optimized 125+ ETL pipelines to transform and load data using Informatica Power Center and IICS from various sources including Salesforce, flat files, databases, spreadsheets, and APIs.

• Optimized SQL queries by refining joins, indexing strategies, and subqueries, enhancing database performance

• Supported the migration of 50+ Informatica jobs from on-premises to cloud infrastructure, improving operational efficiency.

• Collaborated with cross-functional teams to understand business needs and deliver 12+ custom dashboards in Tableau, improving stakeholder decision-making efficiency by 30% and reducing report turnaround time by 25%. Accenture Pune, India

Application Development Associate Dec 2020 – Mar 2023

• Provided production support for enterprise data pipelines, ensuring 98% issue resolution efficiency.

• Handled an average of 15 ad-hoc data requests and data analysis tasks per week, presenting findings to both technical and non-technical stakeholders, facilitating better decision-making across departments.

• Utilized advanced Excel functions, including pivot tables and VLOOKUP, to clean and manipulate datasets of 1M+ records for in-depth analysis, reducing data processing time by 30%.

• Worked closely with senior analysts and stakeholders to deliver clear, data-driven insights, facilitating better decision- making across departments and reducing decision latency by 25%. Goodtech Consulting Pune, India

Data Analyst Intern May 2019 – Jun 2019

• Conducted data collection, cleansing, and transformation using SQL, improving data accuracy by 25%.

• Designed and deployed interactive Power BI dashboards to monitor sales performance, enhancing decision-making speed and operational insights.

ACADEMIC EXPERIENCE

Sales Performance Dashboard

• Built an interactive dashboard using Python (Pandas, Matplotlib) and Tableau to analyze sales performance, improving data visualization efficiency by 25%.

• Developed predictive models using scikit-learn to forecast future sales trends, enhancing decision-making accuracy by 20%.

Weather Data Pipeline Automation

• Developed a weather ETL pipeline using Apache Airflow of real-time weather data from the Open-Meteo API, providing daily updates on temperature, wind speed, and other key weather metrics.

• Streamlined data extraction and transformation by leveraging Airflow's HTTP and PostgreSQL hooks, normalizing raw JSON data into structured formats and ensuring accurate data flow for weather analysis.

Contact this candidate