JAYA DHARANI MERLA

Senior Data Engineer

+1-303-***-**** Raleigh, NC, 27606 ad038c@r.postjobfree.com www.linkedin.com/in/jayadharani/ PROFESSIONAL SUMMARY

Data Engineer with 3+ years of experience and master’s education looking for a Data Engineer position. Qualified by demonstrated competencies in Python, SQL, Machine Learning, Data Engineering, Data Management, Data Visualization and presentation capabilities to convey complex information.

PROFESSIONAL EXPERIENCE

Senior Data Engineer Arete IT Services India February 2020 – January 2022

Led and actively participated in migrating legacy mainframe systems to the cloud environment, leveraging Python, PySpark, and SQL for data processing and transformation, ensuring seamless transition and improved system efficiency.

Utilized SQL (Advanced Joins, Window functions, Stored procedures) to efficiently query and extract data from multiple databases, reducing data retrieval time by 40% and improving data accuracy.

Applied DevOps principles and practices to streamline data engineering processes, fostering continuous integration and deployment, thereby enhancing the reliability and efficiency of data pipelines.

Proficiently utilized AWS services, including EC2, S3, EMR, and Glue, to architect, implement, and optimize data pipelines, enabling scalable and cost-effective data processing and analysis in a cloud-native environment.

Used Power BI for data transformation (Power Query, M code) and data modeling (Power Pivot), decreasing the overall data size by 25% and enhancing report efficiency. Established and handled relationships between tables, creating a cohesive and interconnected data model, optimizing data analysis and data visualization.

Developed DAX measures to calculate KPIs and metrics, providing meaningful insights improving decision-making by 50%.

Designed comprehensive reports and dashboards using custom visualizations and by integrating Python in Power BI, leveraged machine learning models, and incorporated predictive analytics.

Calculated and interpreted summary statistics to provide insights into data distributions, helping to identify trends, outliers, and potential data issues.

Worked collaboratively in an Agile environment, participating in sprint planning, daily stand-ups, and sprint retrospectives to ensure efficient project execution and timely delivery of data analysis and reporting solutions. Software Engineer Intern ECIL India May 2019 – December 2019

Leveraged SQL, MS SQL Server, and Azure to extract and manipulate data, reducing data processing time by 30%.

Developed complex SQL queries, leading to a 25% improvement in data accuracy and completeness.

Maintained ETL pipelines in Microsoft Azure (Azure Data Factory), created Azure SQL databases and warehouses, connecting it to MS SQL Server Management Studio.

Built knowledge on all SQL Server tools, integrating data from different sources, Tabular models in SSAS and Reporting services. SKILLS

Programming Languages & Databases: Python, R, SQL, C/C++, HTML/CSS, Java, JavaScript, MySQL, Oracle, PostgreSQL, MongoDB, DevOps, XML.

Software Tools: SSRS, SSMS Apache Spark, STATA, JIRA, BigQuery, Hadoop, Matlab, MS Office, Tableau, Power BI, VBA and MS Excel.

Analytics and Machine Learning: Data Analytics pipeline, Data engineering pipeline (data governance, data mining, data collection, data profiling, data management, data storage, data warehouse, data modeling, data manipulation and data processing), Regression, Classification, Clustering, Neural Networks (CNN and DNN), NLP, Git and SDLC. ACCOMPLISHMENTS

1. Certified Advanced IoT Analytics with Machine Learning 2. Certified Data Scientist with IoT Analytics

3. SQL(Advanced) by Hacker rank

4. Led successful data migration projects, ensuring seamless integration of data from legacy systems into new databases. EDUCATION

Masters in Computer Science-Data Science at University of Missouri Kansas City January 2022 – May 2023