Data Modeling Database Developer

Experienced Lead Database Developer with over ** years of specialized expertise in database design, data modeling, implementation, and optimization, contributing to over 16 years of professional experience. Currently driving impactful projects at BNY Mellon, I excel in converting complex business requirements into scalable, efficient data solutions. My strategic focus on optimizing data architectures, while ensuring accuracy and integrity, consistently enhances organizational efficiency and supports long-term goals. I possess deep expertise in designing and developing sophisticated data models and solutions to meet complex business needs and inform strategic decision-making. Highly skilled in leveraging Oracle SQL and PL/SQL to design, implement, and optimize databases.

Skills

Database - Snowflake, Oracle SQL, PLSQL

Data Modeling: Erwin

Programming Languages: Python Operating System - Windows, Linux Version Control Tools - Git, SVN

Career Summary

Specialist in designing both logical and physical data models, tailored specifically to the complexities of banking environments. With deep expertise in database design, analysis, coding, development, testing, and query performance for large-scale banking datasets, I ensure robust and scalable solutions.

As a results-oriented Data Engineer, I excel in Oracle Performance Tuning, optimizing ETL processes, and refining data structures for efficient processing. My extensive knowledge spans Query Optimization, Execution Plans, Indexes, HINTS, and the analysis of Session History and SQL Plan Baselines. I effectively utilize performance tools like DBMS Profiler, SQL Tuning Advisor, and AWR Reports to achieve superior database performance.

Experienced in designing and implementing sophisticated ETL Workflows, with a focus on robust data modeling for effective banking data management.

Expert in deploying advanced Oracle database functionalities, including SQL Loader, External Tables, and UTL_FILE, to streamline and optimize data loading, manipulation, and file handling processes. My proficiency in these tools allows for efficient management of large volumes of data, ensuring seamless integration and processing within complex database environments. I am adept at configuring and tuning these functionalities to meet specific business requirements, reducing processing time, and enhancing overall data throughput.

My exceptional skills in diagnosing and resolving database issues are demonstrated through my ability to quickly identify root causes and implement effective solutions, minimizing downtime and maintaining system integrity. I consistently drive efficient and effective data management strategies, ensuring that database operations run smoothly and align with organizational goals.

Work History

May 2022 -

Current

Nov 2021 -

May 2022

Jun 2018 Feb 2021

Lead Database Developer

Bny Mellon, Project – WMKYC, PACE Data Engineering

Orchestrated developing and deploying intricate logical and physical data models using Erwin Data Modeler.

Architected optimized data structures tailored for complex financial datasets.

Led the seamless integration of Erwin-generated data models into existing systems, boosting operational efficiency.

Executed meticulous strategies to ensure data integrity and enhance storage and retrieval mechanisms.

Partnered with cross-functional teams to conduct comprehensive impact analysis on data model adjustments, effectively managing potential risks.

Harnessed Erwin Data Modeler's forward engineering features to transform logical designs into effective physical data models.

Applied reverse engineering techniques within Erwin to scrutinize and improve existing database structures, elevating performance.

Utilizing ePace tool capability, SQL Loader, and External Tables for different requirements within the project to efficiently load and integrate data from various sources into the central database, ensuring that all incoming data is accurately captured and consolidated.

Employing PL/SQL for complex data transformation and reconciliation tasks, including developing custom procedures and functions to handle intricate business logic and ensure data consistency across different systems.

Implementing advanced performance tuning strategies, such as optimizing SQL queries and using Indexes and Execution Plans, to enhance the efficiency of data processing and transformation. This includes analyzing Session History and SQL Plan Baselines to identify and address performance bottlenecks.

Senior Tech Lead

Xoriant Solution, Project – Qpharma

Applied data modeling expertise to design and implement robust structures for enhanced scalability and performance.

Spearheaded the integration of Snowflake into the data modeling workflow, ensuring optimal storage and retrieval mechanisms for QPharma's extensive datasets.

Utilized Snowflake's unique clustering and indexing features within data models, optimizing query performance and accelerating analytical processes.

Utilizing PL/SQL to develop stored procedures and triggers that automate order processing workflows. This includes handling order creation, validation, updates, and tracking, ensuring that all transactions are processed efficiently and accurately.

Senior Technology Lead

Fulcrum Digital, Project – Mastercard Pay by Bank App

Developed comprehensive logical and physical data models to optimize online payment processes, ensuring robust and reliable data architecture.

Designed and implemented scalable data structures to support users' banking apps.

Integrated data models seamless transactions through Payment origination systems for enhanced processing.

Ensured data integrity and efficiency in the storage and retrieval of payment-related information.

Design normalized tables to securely manage payment transactions, user accounts, and banking information. Implement materialized views for efficient data aggregation.

May 2016-

June 2018

July 2014-

May 2016

Design normalized tables to securely manage payment transactions, user accounts, and banking information. Implement materialized views for efficient data aggregation and standard views to simplify data access.

Develop stored procedures and functions to manage payment processing logic, including validation, fee calculation, and balance updates. Use PL/SQL for transaction control to ensure data integrity with commit and rollback operations.

Leverage SQL Tuning Advisor and Automatic Workload Repository (AWR) reports to analyze and optimize SQL queries. Apply recommendations from these tools to resolve performance bottlenecks and enhance query execution.

Tech Specialist

Tech Mahindra, Project- AT&T - DTI

Developed comprehensive logical and physical data models that support the receipt of batch and

near real-time data feeds from diverse sources, ensuring a robust and reliable data architecture

for enhanced performance and scalability.

Expertly designed and implemented complex SQL queries, stored procedures, functions,

packages, and database triggers, demonstrating advanced proficiency in SQL Loader to

support intricate data modeling tasks.

Played a pivotal role in enhancing data model efficiency by optimizing complex queries and

utilizing performance measurement tools such as DBMS Profiler, SQL Tuning Advisor, and

AWR reports. Ensured the effectiveness and efficiency of data models through targeted

performance tuning and rigorous analysis.

Led the team in database design and development, encompassing implementation and

performance tuning.

Tech Lead

Atos India, Project -Vamos

Led the development team to design and develop the entire Vamos application, a vital element of the Ordering Business chain.

Expertly designed and implemented SQL queries, stored procedures, functions, packages, and database triggers, demonstrating advanced proficiency in SQL Loader. Employed Scrum methodologies and Extreme Programming techniques to drive the delivery of efficient and robust solutions.

Developed a comprehensive solution that handles new subscriptions, order renewals, and order validation, and includes an intuitive GUI interface for store use in selling products and generating new orders.

Actively participated in various performance improvement initiatives, working hand-in-hand with the Production Support team to identify bottlenecks and implement streamlined processes.

Feb 2013- Tech Lead

Jun 2014

Infosys Ltd, Project – Barclays Finance- Ceased & Deceased(C&D)

Spearheaded the implementation of the OEDQ search engine, designed to perform comprehensive security checks to identify potential anti-social elements. Overseeing the detailed comparison of multiple screening processes, ensuring thorough vetting of customer lists against global watchlists.

Led the cross-referencing efforts of customer data with world checklists, enhancing the detection and flagging of potential threats.

Driving the enhancement of accuracy and efficiency in security checks by leveraging advanced search engine capabilities and optimizing performance metrics.

Developed a robust framework for ongoing security assessments, providing continuous protection against anti-social activities.

Nov 2010- I.T Analyst

Feb 2013

Tata Consultancy Services LTD.Project – Cisco- CSAPP

Engaged with stakeholders to gather and analyze detailed requirements for the CSAPP tool, focusing on features that support partner engagement and certification management.

Identified key business processes and user needs to ensure the tool effectively supports various partner levels and certifications.

Developed detailed technical specifications and design documents, outlining the necessary PL/SQL logic and database interactions required to support these features.

Created detailed technical specifications, wireframes, and user stories to guide the development process and ensure alignment with business objectives.

Led the implementation of new features and enhancements, ensuring seamless integration with existing systems and data sources.

Design relational tables to manage partnership levels, certifications, and customer interactions. Use tables to store detailed information about each partner's certification status, level, and associated attributes.

Develop procedures to manage processes such as assigning partnership levels, updating certification statuses, and tracking partner interactions. Use PL/SQL for data validation and business logic enforcement.

Use partitioning techniques to manage large datasets efficiently. Partition tables by criteria such as certification date or partner level to improve query performance and manageability.

July 2007- Production Exec -L1

Oct 2010

Rolta India LTD. –Ameron

Played a crucial role in the data migration project by leading the design, implementation, and optimization of data conversion processes. This involved meticulously mapping and transforming data from Ameren’s Framme environment to the G-Tech environment, ensuring data accuracy, integrity, and consistency throughout the migration.

Focused on resolving complex data issues and optimizing data flows to facilitate a smooth and seamless transition.

Developed and executed a comprehensive migration plan, which included detailed project milestones, timelines, and resource requirements. Coordinated cross-functional teams to align on objectives and ensure timely execution of the migration.

Implemented risk management strategies to address potential challenges and mitigate impacts, ensuring a successful data migration with minimal disruption to ongoing operations.

Personal Information

Education: Bachelor of Technology

Language Known: English, Hindi

Interests: Cloud Computing, Artificial Intelligence

Contact this candidate