Data Modeling Specialist - Johnson & Johnson - New Brunswick, NJ
(2025-05)
Designed and developed logical and physical data models for enterprise applications, ensuring scalable database structures aligned with business rules, application workflows, and reporting requirements.
- Created and maintained DDL scripts for tables, views, indexes, triggers, stored procedures, and database objects across development, QA, UAT, and production environments.
- Developed complex DML SQL scripts to support data updates, data transformation, data correction, validation, reconciliation, and reporting needs across enterprise database systems.
- Prepared and maintained data conversion strategy plans, data mapping documents, gap analysis specifications, and source-to-target mapping documentation for application modernization and migration initiatives.
- Worked with project managers, solution architects, business analysts, application development teams, QA teams, and business stakeholders to review requirements and ensure quality of DDL/DML scripts.
- Performed SQL performance tuning by analyzing execution plans, indexes, stored procedures, query logic, joins, statistics, and database access patterns to improve query efficiency.
- Supported data movement, export/import processes, database refreshes, and validation activities to ensure accurate and consistent data across multiple environments.
- Used ER Studio Data Architect to design, update, and document logical and physical data models, entity relationships, data definitions, and database structures.
- Supported reporting and data integration processes using SSIS, SSRS, SQL Server Management Studio, QMF for Workstation, Redgate SQL Compare, and TSO.
- Created clear technical documentation describing data models, database objects, data usage, conversion rules, validation results, and application process flows.
- Investigated and resolved database-related issues, data discrepancies, SQL errors, performance problems, and deployment defects in collaboration with development and QA teams.
- Participated in database change management, release support, script validation, production deployment planning, and post-deployment verification to ensure stable database operations.
Data Modeling Specialist - JPMorgan Chase - Plano, TX
(2022-06 - 2025-03)
Designed and developed logical and physical data models for enterprise banking applications, supporting data architecture, application workflows, reporting needs, and business rule implementation.
- Created, reviewed, and maintained DDL scripts for tables, views, indexes, triggers, stored procedures, and database objects across Development, QA, UAT, and Production environments.
- Wrote complex DML SQL queries and scripts against SQL Server and DB2 databases to support data manipulation, validation, reconciliation, reporting, and application processing requirements.
- Developed and maintained data conversion strategy plans, data mapping documents, gap analysis specifications, and source-to-target mapping documentation for database migration and modernization initiatives.
- Worked closely with project managers, solution architects, business analysts, application development teams, QA teams, and business stakeholders to validate database requirements and ensure script quality.
- Performed SQL performance tuning for complex SQL queries, stored procedures, joins, indexes, execution plans, statistics, and database access patterns to improve application efficiency.
- Supported database implementation, data movement, export/import processes, environment refreshes, and release activities while ensuring data accuracy and deployment readiness.
- Used ER Studio Data Architect to maintain logical and physical data models, entity relationships, data definitions, and database design documentation.
- Supported reporting, data integration, and database comparison activities using SSMS, SSMS Job Scheduler, SSIS, SSRS, QMF for Workstation, Redgate SQL Compare, and TSO.
- Investigated and resolved database issues, SQL errors, data discrepancies, performance bottlenecks, and deployment defects across enterprise database environments.
- Created clear and accurate documentation for data models, database objects, data usage, conversion rules, validation results, and application process flows.
- Participated in change management, production deployment planning, script validation, release support, defect resolution, and post-deployment verification to maintain stable database operations.
Database Administrator - Walmart - Bentonville, AR
(2021-05 - 2022-05)
Supported enterprise SQL Server environments for Walmart's retail, e-commerce, inventory management, supply chain, and point-of-sale (POS) applications across Production, QA, UAT, and Development environments.
- Planned and executed database migration projects from on-premises SQL Server environments to AWS RDS for SQL Server, ensuring minimal downtime and data integrity.
- Worked closely with application developers and DevOps teams to support CI/CD database deployments, schema versioning, and release automation using Azure DevOps and Git.
- Designed and implemented database partitioning, compression, and archival strategies to improve query performance and efficiently manage large transactional datasets.
- Optimized ETL workloads by collaborating with data engineering teams, reducing batch processing time and improving data availability for business reporting.
- Configured and monitored AWS RDS parameter groups, option groups, snapshots, maintenance windows, Multi-AZ deployments, and storage auto-scaling.
- Developed PowerShell and T-SQL automation scripts to streamline environment provisioning, database health reporting, maintenance scheduling, and operational monitoring.
- Performed database performance analysis using Extended Events, Query Store, and Dynamic Management Views (DMVs), identifying bottlenecks and recommending tuning strategies.
- Collaborated with cybersecurity teams to implement database auditing, encryption, vulnerability remediation, and compliance controls for sensitive retail customer data.
- Partnered with infrastructure and cloud engineering teams to optimize SQL Server resource utilization, storage allocation, and high-availability configurations across enterprise environments.
Database Administrator - Vodafone Idea Limited - Hyderabad, India
(2020-11 - 2021-04)
Administered SQL Server 2017/2019 production databases supporting telecom billing, CRM, subscriber, and network management systems.
- Configured and maintained Always On Availability Groups, Log Shipping, and Replication to ensure high availability and disaster recovery.
