Archana
Data Engineer
Ghaziabad
Summary
Archana is an IT professional with more than 8 year of experience in various area as Datawarehouse, ETL operations, Data Modelling, ERP/Application development, Report Development, implementation, application support and DBA activities. Looking for an opportunity to work where learning can be grabbed by utilizing the experience through serving the position.
Overview
11
11
years of professional experience
4
4
Certifications
2
2
Languages
Work History
Sr. Data Engineer
Waisl Ltd.
02.2023 - Current
- Data extract from different sources to Azure data lake, perform transformation and prepare data for end user consume by Power BI
- Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
- Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
Database Developer
Karexpert Pvt. Ltd.
06.2018 - 06.2021
- ETL operations, data modeling for data warehouse, including OLAP modeling, writing SQL queries, optimizing queries, develop Jasper Reports
- Supported business analytics initiatives with the creation of dynamic dashboards and detailed reports for data-driven decision-making processes.
- Ensured accurate reporting results with thorough validation of ETL processes, data transformations, and aggregations.
- Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
PLSQL Developer
Radian Softwares Pvt. Ltd.
06.2017 - 05.2018
- Writing PLSQL codes and develop BI Reports using Analytical/Windowing Functions
- Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
- Analyzed existing SQL queries to identify opportunities for improvements.
Oracle Apex PLSQL Developer
Siemens Technologies and Services Pvt. Ltd.
02.2015 - 05.2017
- Writing PLSQL Functions, Procedures, Triggers, views and Packages, writing SQL queries, development and customization of oracle forms and oracle reports in Apex
PLSQL Developer
Imax Technologies Pvt. Ltd.
03.2013 - 06.2014
- Splitting Data on three databases on three different servers through data link, creating Cursors functions, procedures, triggers for splitting, requirement gathering, project demonstration to client, Reports (statutory Reports) and forms development requirement gathering, testing of reports
Education
Master of Computer Applications - Computer Application
Institute of Technology And Science
Ghaziabad 04.2001 -
Skills
Data Warehousing Concepts
Partitioning and Indexing
ETL Process Development
Data Warehousing
SQL Query Optimization
Oracle Application Express
Database: Oracle,mysql,mongodb
SQL analytics
Business Intelligence
Certification
Azure Data Engineer Associate
Personal Qualifications
- MCA from U.P Technical University
- BCA from Chaudhary Charan Singh University
- Intermediate from UP. board
- High school from UP. board
Disclaimer
I hereby declare that all the above information is true to the best of my knowledge.
Timeline
Sr. Data Engineer
Waisl Ltd.
02.2023 - Current
Database Developer
Karexpert Pvt. Ltd.
06.2018 - 06.2021
PLSQL Developer
Radian Softwares Pvt. Ltd.
06.2017 - 05.2018
Oracle Apex PLSQL Developer
Siemens Technologies and Services Pvt. Ltd.
02.2015 - 05.2017
PLSQL Developer
Imax Technologies Pvt. Ltd.
03.2013 - 06.2014
Master of Computer Applications - Computer Application
Institute of Technology And Science
04.2001 -