Mrinali Verma
Lucknow
Summary
Results-focused data professional equipped for impactful contributions. Expertise in designing, building, and optimizing complex data pipelines and ETL processes. Strong in SQL,Python, and cloud platforms, ensuring seamless data integration and robust data solutions. Known for excelling in collaborative environments, adapting swiftly to evolving needs, and driving team success.
Overview
7
7
years of professional experience
Work History
Data Engineer
Amdocs Development Centre
11.2022 - Current
- Designed and implemented a mechanism in PLSQL to replace over 200 million old IDs with new IDs including datatype change as well. Additionally, successfully converted Teradata scripts to Snowflake and developed new Java connectivity to seamlessly integrate with Snowflake
- Developed 150+ Snowflake SQL scripts. Used Snowflake features of handling files and unstructured data in external stages.
Developed file to table, table to table jobs and created stored procedures - Successfully modernized and migrated the legacy application to new technology(Azure, Java, PLSQL). Contributed in development and deployment phases.
- Created Python scripts to automate ETL process and jobs
- Also worked on Java code to incorporate enhancements ,MFA implementation and bug fixes.
- Developed and implemented Shell scripts to establish connectivity between Linux servers and Snowflake, facilitating data integration.
- Actively contributed to project planning and strategy development
- Collaborated with cross-functional teams to define project scope and timelines
- Assisted in the formulation of project plans, schedules, and resource allocation
Senior Engineer
OYO Corporate Office
07.2019 - 10.2022
- Automated the vendor onboarding process using spring boot and plsql
- E-invoicing Project - Designed entire framework of sending financial data to and from government portal for all the B2B transactions using plsql through rest APIs
- Mail Notification Framework - Designed a common mail sending framework in plsql through SMTP
- Deal Creation Mechanism - Created an automated system for deal creation and categorization while onboarding hotels using Springboot
- Contract Extention & Room Category and Amenities Creation - Streamlined the process of contract renewal and addition of new room categories in Hotel Onboarding
- Designed various rest APIs using Spring boot and POSTMAN
- Designed the CI/CD pipeline between Jenkins-Github-Oracle
- Designed various financial reporting systems and also financial process automations which had an impact of around 7000Cr
Intern
OYO Corporate Office
01.2019 - 07.2019
- Worked on Springboot to understand and fix bugs in the code. Used POSTMAN to work with APIs
- Designed web pages for internal OYO products using Ember.js
Education
BTech -
ABES Engineering College
01.2019
Skills
- PL SQL
- Snowflake
- Azure
- Linux
- ETL Development
- Python
- Java
- SpringBoot
- GitHub
- Performance tuning
- SQL programming
LANGUAGES
ENGLISH - Full Professional Proficiency
HINDI - Full Professional Proficiency
Hobbies and Interests
SINGING, BADMINTON, PAINTING
Timeline
Data Engineer
Amdocs Development Centre
11.2022 - Current
Senior Engineer
OYO Corporate Office
07.2019 - 10.2022
Intern
OYO Corporate Office
01.2019 - 07.2019
BTech -
ABES Engineering College
Similar Profiles
Prathibha Panneer SelvamPrathibha Panneer Selvam
Functional Test Engineer at Amdocs Development CentreFunctional Test Engineer at Amdocs Development Centre
Utsav OjhaUtsav Ojha
Software Developer at Amdocs Development Centre India LLPSoftware Developer at Amdocs Development Centre India LLP
Sumit PachahaSumit Pachaha
Software Developer at Amdocs Development Centre India LLPSoftware Developer at Amdocs Development Centre India LLP
Anurag ShuklaAnurag Shukla
Principal Lead Purchase at PN INTERNATIONAL PRIVATE LTDPrincipal Lead Purchase at PN INTERNATIONAL PRIVATE LTD
Rinki VishwakarmaRinki Vishwakarma
Obstetrics and Gynaecology at Veerangana Avanti Bai Mahila Chikbagwalaitsalaya Dufferin HospitalObstetrics and Gynaecology at Veerangana Avanti Bai Mahila Chikbagwalaitsalaya Dufferin Hospital