Results-oriented individual with a passion for continuous learning and innovation. Known for leveraging analytical thinking and creativity to solve problems and deliver high-impact solutions in fast-paced environments.
Overview
14
14
years of professional experience
Work History
Data Modeler & Analyst
Citibank, NA
Irving, TX
01.2016 - Current
Developed data models to meet the business requirements of clients.
Implemented changes in data modeling techniques to improve system performance.
Collaborated with developers, analysts, and other IT professionals to ensure successful implementation of new designs.
Developed and managed enterprise-wide data analytics environments.
Designed conceptual, logical and physical data models for various databases.
Validated source systems for accuracy prior to creating a model from them.
Worked closely with stakeholders to define business requirements and design solutions that met their needs.
Created detailed documentation of all data models and processes used in the development process.
Created conceptual, logical and physical data models for use in different business areas.
Identified needs of customers promptly and efficiently.
Created entity-relationship diagrams to represent the structure of data.
PLSQL Developer & Oracle DBA
Hartford Insurance Group & British Telecom
Kolkata, West Bengal
10.2010 - 12.2015
Performed debugging of existing PLSQL code as part of bug fixing activities.
Involved in migrating the old version of Oracle database to newer versions with minimal downtime.
Implemented exception handling mechanism using error logging package in PLSQL.
Developed stored procedures, functions and packages using PLSQL to support the application development needs.
Involved in Performance Tuning activities like creating Indexes, Partitioning Tables.
Collaborated with IT security to audit database access and implement necessary compliance measures.
Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.
Implemented high availability solutions such as Oracle Data Guard, Streams replication, GoldenGate.
Monitored database performance and tuned SQL statements for optimal performance.
Implemented physical database design including tablespaces, storage optimization and partitioning.