Dimple Bharadwaj
Data Engineer
Berlin
Summary
11 Years of experience as a Avaloq Consultant, Project Manager and Oracle PL/SQL Developer in Analysis, design and implementation of business applications using Oracle Relational Database Management System (RDBMS), Avaloq and Unix. Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
Experienced with database design, implementation, and maintenance. Utilizes SQL and other database management tools to ensure data integrity and optimize performance. Track record of enhancing system efficiency through performance tuning and query optimization.
Pursuing full-time role that presents professional challenges and leverages interpersonal skills, effective time management, and problem-solving expertise.
Results-oriented achiever with proven ability to exceed targets and drive success in fast-paced environments. Combines strategic thinking with hands-on experience to deliver impactful solutions and enhance organizational performance.
Detail-oriented individual with exceptional communication and project management skills. Proven ability to handle multiple tasks effectively and efficiently in fast-paced environments. Recognized for taking proactive approach to identifying and addressing issues, with focus on optimizing processes and supporting team objectives. Demonstrates strong analytical, communication, and teamwork skills, with proven ability to quickly adapt to new environments. Eager to contribute to team success and further develop professional skills. Brings positive attitude and commitment to continuous learning and growth.
Overview
11
11
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
Work History
Database Engineer
Avaloq
Berlin
12.2022 - Current
- Company Overview: Avaloq is complete wealth management solution with essential core banking functionality
- This product also provides great functionality to customize according to customer requirement
- Working on new requirements or change requests for different banks and investment industries
- Delivering hotfixes or urgent issues
- Delivering solutions for different tickets raised by banks
- Client Data Management for different banks according to their requirements
- Debugging and troubleshooting application
- Managing smooth implementation and testing and support of applications at client sites
- Managing technical walk through for Clients in POC's
- Avaloq is complete wealth management solution with essential core banking functionality
- This product also provides great functionality to customize according to customer requirement
- Language and Technologies used: Avaloq, PL SQL, Putty, SQL Developer, ICE, SmartClient
- Reduced query execution time by analyzing and fine-tuning SQL statements in complex applications.
- Developed more than 100 custom scripts to automate routine tasks, resulting in significant time savings for team.
- Contributed significantly to organization's productivity by maintaining high availability and reliability of critical database systems.
- Maximized efficiency by advising stakeholders on optimal database architecture and best practices.
- Streamlined approximately 200 data processes for faster retrieval and analysis through design of well-structured databases.
- Identified opportunities for cost savings through effective capacity planning and resource allocation decisions in large-scale database environments.
Lead Data Engineer & Project Manager
Capgemini
Bangalore
03.2022 - 11.2022
- Company Overview: Avaloq is complete wealth management solution with essential core banking functionality
- This product also provides great functionality to customize according to customer requirement
- Worked on Avaloq Securities Transaction module and MIFID-II Transaction Reporting
- Followed Agile dev ops model where teams are distributed over different geographies
- Doing new change requests (design & implementation) for Security Transaction module
- Involved in defect fixing for critical BAU and UAT defects for active and in-transition business units
- Participation in design review meetings with Geneva counterparts to synchronize business understanding
- Involved in defect fixing for critical BAU and UAT defects for multiple Business Units
- Managing Avaloq training sessions for non-Avaloq resources and actively playing role of trainer for most of modules
- Part of big migration projects and successfully migrated 4 legacy systems to Avaloq
- Also worked on regulatory projects on various models of Avaloq like AMI, reporting, CRS Implementation
- This product also provides great functionality to customize according to customer requirement
- Language and Technologies used: Avaloq, PL SQL, Putty, Unix, Data Loaders tool, ICE, SmartClient
- Mentored junior engineers on best practices in data engineering, fostering culture of continuous learning and improvement within team.
- Ensured compliance with relevant regulations related to data storage, privacy, security, and transmission standards by staying updated on legal developments impacting industry.
- Established strong working relationships with stakeholders across multiple departments, facilitating clear communication channels regarding project requirements and progress updates.
- Reduced latency in real-time analytics applications by optimizing query performance through indexing strategies and proper database design principles.
- Delivered high-quality code reviews for colleagues contributions following established coding standards and best practices, maintaining consistency throughout projects.
- Optimized data processing by implementing cutting-edge data engineering techniques and tools.
- Modeled predictions with feature selection algorithms.
- Developed polished visualizations to share results of data analyses.
- Applied loss functions and variance explanation techniques to compare performance metrics.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
- Improved data collection methods by designing surveys, polls and other instruments.
- Successfully managed multiple projects simultaneously by prioritizing tasks according to urgency, resource availability, and alignment with organizational goals.
- Established effective communication among team members for enhanced collaboration and successful project completion.
- Coordinated with cross-functional teams to resolve project issues and mitigate risks.
- Negotiated contracts with vendors and suppliers, securing quality materials at competitive prices for efficient use of resources.
- Developed and implemented project plans and budgets to ensure successful execution.
- Facilitated workshops to collect project requirements and user feedback.
- Aligned business objectives with technical requirements through close collaboration with product owners providing insights based on available data sources.
- Evaluated new technologies and industry trends to identify opportunities for enhancing current systems or developing innovative solutions.
Associate Data Analyst
DBS Bank
Hyderabad
11.2018 - 03.2022
- Company Overview: Banking system (Application) that uses Avaloq as its core tool contains various modules of wealth management
- Streamlined data analysis workflows for increased efficiency and reduced turnaround times.
- Facilitated knowledge sharing among team members through regular training sessions on best practices in data analytics techniques and tools.
- Developed custom analytical models to address specific business challenges and drive performance improvements.
- Conducted regular audits of internal databases, maintaining high levels of data integrity and reliability.
- Collaborated with cross-functional teams to develop optimized business strategies based on data insights.
- Implemented robust quality control measures for all incoming datasets, ensuring consistency across multiple sources.
- Identified trends and patterns within large datasets using advanced statistical techniques.
- Supported implementation of new data management system, ensuring seamless integration with existing infrastructure.
- Working on cross functional modules
- Fixing issues related to database and Avaloq Script
- Performance tuning (e.g - writing proper ddics, replace all hardcoded values, remove unnecessary calls of script packages, replace all intl_id with id etc, using CASE statement instead of IF ELSE statement, instead of nesting dot(.) operator use WITH clause to reduce number of calls of object within object)
- Upgrade Script from 4.8 to 4.9 during customization
- Part of Maintenance and Release Teams
- Part of Project Teams
- Design and implement reports
- (TASK DEF, REP DTM, REP FILE, TASK TEMPL, BTC, REP SCRIPT, INTF DEF)
- Maintaining user reports through UNIX handling
- Maintaining Jobs like daily or monthly run according to requirement
- Banking system (Application) that uses Avaloq as its core tool contains various modules of wealth management
- Language and Technologies used: Avaloq, PL SQL
- Ensured compliance with all applicable privacy laws and regulations while handling confidential customer information during analysis projects.
- Strengthened interdepartmental communication by serving as liaison between Data Analytics team and other business units within organization.
- Increased productivity by developing automated tools for routine data processing tasks.
- Reduced operational costs by identifying areas of inefficiency through targeted data analysis efforts.
- Evaluated various machine learning algorithms for their effectiveness in predicting future outcomes based on historical data patterns.
- Improved decision-making processes by presenting comprehensive data visualizations and reports to key stakeholders.
- Deployed predictive analytics models to forecast future trends.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Created data models to support decision-making processes.
- Developed and maintained data warehouses and data marts to support business operations.
Software Development Engineering - Analyst
Fiserv
Noida
05.2017 - 11.2018
- Company Overview: DNA is a financial application which deals with Loans and Deposits (Saving account) features
- Optimized approximately 5 product designs for enhanced performance and cost reduction through detailed analysis of materials and manufacturing methods.
- Implemented rigorous quality control measures to ensure reliable results during testing phases.
- With the UI features, it provides Apps to its users or customers and provides integrated Loans and Deposit applications according to the requirements of the Customers
- Handling Loans Module
- Working on new CR (Coding in pl sql)
- Fixing Bugs related to Database
- Part of Maintenance and Release Teams
- Part of Project Teams
- DNA is a financial application which deals with Loans and Deposits (Saving account) features
- Language and Technologies used: Database Developer (Oracle), SQR Developer
- Achievement: Awarded for delivery on time to the customers for efforts and hard work
- Reduced approximately 5 product's product development time by creating automated simulation models for different scenarios.
- Contributed to patent applications by documenting novel engineering solutions discovered through extensive research efforts.
Senior Software Engineer
Sopra Steria Group
Noida
05.2016 - 05.2017
- Company Overview: Mortgage market is all about agility and control
- Sopra Banking Lending - Mortgage & Savings Suite provides a platform that is known and trusted by some of the largest mortgage providers in UK
- Handling Oracle PL SQL Database coding
- Enhanced software functionality by identifying and resolving complex technical issues.
- Mentored junior developers, fostering professional growth and enhancing team productivity.
- Developed next generation integration platform for internal applications.
- Conducted data modeling, performance and integration testing.
- Optimized dust, temperature and humidity controls for installed systems.
- Developing test cases and testing features of Database
- Bug fixing related to Database
- Mortgage market is all about agility and control
- Sopra Banking Lending - Mortgage & Savings Suite provides a platform that is known and trusted by some of largest mortgage providers in UK
- Language and Technologies: Oracle Forms and Reports, Oracle PL SQL database, Power Builder
- Achievement: Created internal tool for team management
Database Engineering Analyst
Qualtech Consultant Software Pvt. Ltd.
Noida
06.2015 - 05.2016
- Company Overview: miFINTM Lending and Leasing Suite is comprehensive lending platform designed for banking and financial services industry to completely automate lending and leasing business process
- Responsible for handling Database coding
- Design and development of feature using PL SQL Database
- Performed risk assessments on potential projects, enabling informed decisions regarding feasibility and resource allocation.
- Trained approximately 30 junior analysts on best practices in engineering analysis techniques, fostering knowledgeable workforce.
- Developing test cases and testing features in Database
- Bug fixing related to database
- Adding new features or new changes in product related to database
- MiFINTM Lending and Leasing Suite is comprehensive lending platform designed for banking and financial services industry to completely automate lending and leasing business process
- Language and Technologies: Oracle PL SQL
- Achievement: Got chance to work on Jasper Reporting tool and design various important Business Reports
Software Engineer
Infozech Software Pvt. Ltd.
Delhi
08.2013 - 05.2015
- Company Overview: These were different tools created for managing, monitoring towers and tracking fuel consumption and also billing tower consumption as per consumption
- Responsible for handling Database coding and TCL Script
- Design and development of feature for Database and tcl script writing
- Developing test cases and testing features related to Database
- Bug fixing related to Database
- These were different tools created for managing, monitoring towers and tracking fuel consumption and also billing tower consumption as per consumption
- Language and Technologies used: Oracle, tcl writer, Unix scripting
Education
MCA - Computer Applications Development
Hindustan Institute of Management & Computer Studies
India 04.2010 - 04.2013
BCA - Computer Applications Development
Dr. BR Ambedkar University Agra
Agra, Uttar Pradesh 04.2007 - 04.2010
Skills
PL SQL
undefinedCertification
Avaloq Certified Customization Professional, CC001141
Accomplishments
- Awarded for delivery on time to the customers for efforts and hard work.
- Created an internal tool for team management.
- Got a chance to work on Jasper Reporting tool and design various important Business Reports.
Singing, Dancing
During my free time i like to explore my hobbies to keep myself motivated, positive and confident.
Timeline
Database Engineer
Avaloq
12.2022 - Current
Lead Data Engineer & Project Manager
Capgemini
03.2022 - 11.2022
Associate Data Analyst
DBS Bank
11.2018 - 03.2022
Software Development Engineering - Analyst
Fiserv
05.2017 - 11.2018
Senior Software Engineer
Sopra Steria Group
05.2016 - 05.2017
Database Engineering Analyst
Qualtech Consultant Software Pvt. Ltd.
06.2015 - 05.2016
Software Engineer
Infozech Software Pvt. Ltd.
08.2013 - 05.2015
MCA - Computer Applications Development
Hindustan Institute of Management & Computer Studies
04.2010 - 04.2013
BCA - Computer Applications Development
Dr. BR Ambedkar University Agra
04.2007 - 04.2010
Avaloq Certified Customization Professional, CC001141
Avaloq Foundation course
Introduction in ABR/s for Avaloq
Similar Profiles
MAUD VISINI CHISARIMAUD VISINI CHISARI
Senior Banking Service Manager at AvaloqSenior Banking Service Manager at Avaloq
Robert RottschalkRobert Rottschalk
Scrum Master - Transaction Reporting at Avaloq Sourcing EuropeScrum Master - Transaction Reporting at Avaloq Sourcing Europe
Gokulraj KumarasamyGokulraj Kumarasamy
Cloud Devops Specialist at Avaloq Asia Pte LtdCloud Devops Specialist at Avaloq Asia Pte Ltd