We provide IT Staff Augmentation Services!

Data Modeling, Data Architect Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • 16+ years of IT Experience in all phases of SDLC, Agile, business requirement gathering, analysis, design, development, testing, implementation and maintenance.
  • Experience in database design, data analysis, data model, data migration, data refresh, performance tuning, backend programming (PL/SQL), backup and recovery in Oracle 12c, 11g, 10g, 9i & 8 and SQL Server 2000.
  • Extensive experience in Relational Data Modeling for creating Logical and Physical Desgin of Database and ER Diagarams usig data modeling tools Erwin, Visio and Sybase PowerDesigner.
  • Expertise in SQL, PL/SQL and Knowledge of Data warehouse concepts & ETL Process.
  • Strong understanding of the concept and life cycle of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema mdeling.
  • Database Configuration and Administration, Tuning, Database Migrations, RAC, RMAN, ASM, Data Guard, Production and Standby configuration & maintenance and troubleshooting of various Oracle versions on different platforms covering Redhat Linux, Solaris, Unix and windows NT/2000.
  • Oracle Golden Gate Installation, Configuration and tuning.
  • Experience in Performance Optimization, Trouble Shooting and Risk Mitigation.
  • Performance tuning for optimized results using tools like AWR, ADDM, Statspack, Explain Plan, SQL Trace and TKPROF.
  • Proficient in use of tools like OEM, Quest Toad, Sql * Loader, EXPDP/IMPDP and DM tools Erwin, Visio and Power Designer (PDM).
  • Worked extensively on forward and reverse engineering of Data Models and created DDL Scripts for implementing Data Modeling changes.
  • Backups & Restore using RMAN and Manual (hot and cold backup).
  • Successfully upgraded and replicated 25 TB data from BRM 6.5 to BRM 7.4 by using Oracle Golden Gate.
  • Having domain knowledge in Banking, Telecommunication and Health Care.
  • Good Coding style that confirms to Software Quality Standards.
  • Oracle Certified Professional (OCP) 11g & 10g and Oracle Certified Associate (OCA) 9i.
  • Having around 6+ years of overseas experience in USA, Australia, UK & Singapore.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 5.8, AIX, Redhat Linux, UNIX, MS DOS & Windows NT/2000/XP.

Databases: Oracle 12c, Oracle 11gR2, 10g, 9i & 8i, SQL Server 2000 and Sybase

Products/Tools: Oracle Enterprise Manager (OEM), Oracle Golden Gate, Quest Toad, Erwin, VisioSybase Power Designer (PDM), SQL * Loader, EXPDP / IMPDP and EXP / IMP.

Languages: SQL, PLSQL, Visual Basic 6.0, PB 6.0 (PFC), C and C++

Reporting Tool: Actuate, Crystal Report 8.5, MS SQL Server Reporting Services

Web Tools and Servers: ASP 3.0, HTML/DHTML & XML, IIS and PWS.

Scripts: UNIX Shell script, Java Script and VB Script

Versioning Tool: Tortoise SVN, MS Visual Source Safe

Others: .Net Architecture, Install Shield, Windows Installer, HL7 and HIPPA

Business Domains: Banking, Tele communication and Healthcare Domain

PROFESSIONAL EXPERIENCE

Confidential

Data Modeling, Data Architect

Responsibilities:

  • Interact with Business Analysts to gain understanding of business needs, and provide technology solutions to meet those needs.
  • Create and Review technical designs in compliance to development standards and appropriate design choices.
  • Analyze requirements, Designing Conceptual, Logical & Physical Data Models using Erwin tool for OLTP & Data Warehousing Systems per Enterprise Modeling Standards and Best practices.
  • Create DDL Scripts for implementing Data Modeling changes to target database.
  • Creating tables, indexes, users, views, sequence, synonym, table/index partition, table spaces, etc. and granted access to the application and maintain the data dictionary application wise.
  • Maintain Data Dictionary, preparing DB capacity plan, growth analysis and reports.
  • Performance tuning batch SQL scripts and report all the tuning recommendations and rollout strategy.
  • Schema Creation and Data Refresh from higher environment to lower environment and masking PI Data.
  • Prepared Data Migration, Partitioning and Purging scripts, deployed into production environment.
  • Co - ordinate with the release management and operate team for UAT/PROD release.
  • Analyze and Troubleshoot DB performance issues and provide fix in a timely manner.
  • Monitor the performance of different servers and raise a flag in case of CPU starvation/slow down.
  • Making sure to prepare and maintain application wise documentation for each and every piece of work and share them in SharePoint.
  • Making sure to prepare operate run book and walkthrough with operate team for deployment UAT/PROD.

Confidential

Data Modeling, Data Architect

Responsibilities:

  • Involved database design, data quality analysis, development, testing, implementation and maintenance.
  • Understanding the upstream source system functionality and Business requirements towards creating Conceptual, Logical and Physical Data Model using Visio data Modeler tool.
  • Create DDL Scripts for implementing Data Modeling changes to target database.
  • As a development team member, interact with the end users and business analyst for gathering requirements and translate them into technical design and technical architecture vision and implementation/rollback plan.
  • Creating tables, indexes, users, views, sequence, synonym, table/index partition, table spaces, etc. and granted access to the application and maintain the data dictionary application wise.
  • Bulk User Creation and Maintenance of Role and Privileges of User at Database and Application Level.
  • Developed PL/SQL packages, stored procedures, functions and Triggers
  • Code Review, Integration Testing and Deployment on UAT/PROD.
  • Maintain Data Dictionary, preparing DB capacity plan, growth analysis and reports.
  • Implement data purging and data archival based on NFR.
  • Developed UNIX Shell Scripts for automated DBA tasks.
  • Performance tuning batch SQL scripts.
  • Report all the tuning recommendations and rollout strategy
  • Analyzing tables and indexes for performance tuning
  • Schema refresh from higher environment to lower environment and masking PI Data.
  • Prepared Data Migration, Partitioning and Purging scripts, deployed into production environment.
  • Co-ordinate with the release management and operate team for UAT/PROD release.
  • Analyze and Troubleshoot DB performance issues and provide fix in a timely manner.
  • Monitor the performance of different servers and raise a flag in case of CPU starvation/slow down.
  • Scheduling scrum call with team for review the JIRA’s status, ALM defect status, test evidence, ITSM tasks and change requests.
  • Making sure to prepare and maintain application wise documentation for each and every piece of work and share them in SharePoint.
  • Making sure to prepare operate run book and walkthrough with operate team for deployment UAT/PROD.

Confidential

Data Architect and Database Administration for Applications

Responsibilities:

  • Daily Monitoring and Administration of more than 20 Databases and ERP applications.
  • Interacted with SMEs and collected the business requirements, Data Analysis and Data Mapping for replicating data from source to target.
  • Oracle Golden Gate Installation, Configuration, Tuning and Monitoring.
  • Developed the GG Scripts and configure the GG Extract, Data Pump and Replicate process.
  • Analysis and fix the issues If GG Extract/Data Pump/ Replicate process got aborted.
  • Provide the database and application health check reports.
  • Performance monitoring and tuning of the databases and applications using tools like AWR, ADDM, Explain Plan, SQL * Trace and TKPROF.
  • Tuned the database by introducing indexes, adding parallelism tot tables and indexes, normalizing tables, partitioning high volume tables, releasing more memory to SGA etc.
  • Backup and Recovery using RMAN.
  • Deploy and Configure Oracle 12c OEM Agent on database servers.
  • Manually take Hot / Cold backups before SF Upgrade maintenance.
  • Data Refresh from multiple instance to single instance using EXPDP / IMPDP.
  • Applying all the security patches to the database as per the oracle recommendations to keep the databases safe.

Confidential

Data Modeling, Data Architect and Database Administration for Applications

Responsibilities:

  • Interacted with BAs and collected the business requirements, design document preparation, Analyze the BRM 6.5 and 7.4 Schema objects and mapping document preparation based on functional consideration.
  • Understanding the Functionality and Business requirements towards creating Logical and Physical Data Model using Erwin data Modeler tool.
  • Generate/Wrote DDL SQL scripts from physical data model and deployed to target databases (DEV, QA, UAT and PROD)
  • Maintain the Data Dictionary and Data Refresh from current production database to Development, Functional and Testing Environments.
  • Create tables, indexes, table partitions and Index partitions.
  • Oracle Golden Gate Installation, Configuration, Tuning and Monitoring.
  • Developed the GG Scripts and configure the GG Extract, Data Pump and Replicate process.
  • Developed the PL/SQL procedure, function and packages for the complex transformation.
  • Performance tuning of the database using STATSPACK, AWR, Explain Plan, SQL * Trace TKPROF.
  • SGA Size, All Parameters, User Objects, Invalid Objects, Indexes, Table Partitions, Index Partitions compare report (Current Production, Staging, Parallel Run and New production server).
  • Analysis and fix the issues If GG Extract/Data Pump/ Replicate process got aborted.
  • Developed shell scripts for Archive log copy and GG stats report.
  • Tablespace Management and shell scripting for database automation
  • Monitoring CPU utilization and IO performance using the Unix commands

Confidential

Data Modeling, Data Architect and Oracle Database Administration for Applications

Responsibilities:

  • Dimension and Fact table design for OLAP environment based on OLTP environment data model.
  • Providing Oracle Production Database support for above mentioned seven applications.
  • Creating table spaces, tables, indexes, users, etc. and granted access to the application,
  • Analyzing tables and indexes for performance tuning.
  • Optimized SQL scripts through Explain plans.
  • Schema refresh from production to pre-production environment using EXP/IMP.
  • Performance tuning in SQL Query, Table Partition Analyzed, Index partition Rebuilds and results of ETL jobs involved SQL query response time down from 7 hours to 3 minutes.
  • Performance tuning for optimized results using tools like Explain Plan, AWR, ADDM, SQL * Trace and TKPROF.
  • Shrink and lock the tablespace partitions for the past months and Partition builds for future months.
  • DB capacity planning and Database schema compare report (Production and Pre-Production).
  • Backups & Restore - RMAN and Manual (Hot / Cold backups).
  • Analysis and fix the issues If data load job got aborted.
  • Rebuild of indexes monthly when data load (ETL) job got completed.
  • Installing Oracle Database server 10g on Linux.
  • Creating databases for testing, development and production.
  • Applying patches whenever necessary.

Confidential

Oracle Database Administrator

Responsibilities:

  • Providing Primary DBA support for Oracle Production Database.
  • Daily monitoring and administration including databases sessions, locks, long running queries, waits, etc
  • Database reorganization and Backups and Restore using RMAN
  • Production and Standby server (around 6 Instances).
  • Monitoring production and standby servers are sync or not
  • Archive log files are registered manually whenever production and standby servers are not sync.
  • Physical standby setup with Data Guard and Applying Patches whenever necessary.
  • Performance monitoring and tuning for optimized results using tools like AWR, ADDM, Explain Plan, SQL * Trace and TKPROF.
  • Writing and Maintaining UNIX Shell Scripts for automated DBA tasks.

Confidential

Oracle Database Administrator

Responsibilities:

  • Review oracle PL/SQL packages, stored procedures, functions and Triggers for performance improvement.
  • Performance tuning SQL and PL/SQL for optimized results using tools like Explain Plan, SQL * Trace and TKPROF.
  • Performance tuning batch SQL scripts
  • Report all the tuning recommendations and rollout strategy

Confidential

Database Administration for Application

Responsibilities:

  • Understanding the Functionality and Business requirements towards creating Logical and Physical Data Model using Erwin data Modeler tool.
  • Creating tables, indexes, views, users, sequences, synonyms, constraints, etc.,
  • Developed PL/SQL packages, stored procedures, functions and Triggers.
  • Schema refresh from production to pre-production environment using EXP/IMP.
  • Tablespace Management
  • Monitoring CPU utilization and IO performance using the Unix commands
  • Data migration activities with respect to evolve skills, Qualification and Certification related data migrations schedules.
  • Implementing Complex business logic in the form of stored procedures.
  • Performance tuning in SQL, PL/SQL using STATSPACK, Explain Plan, SQL * Trace and TKPROF
  • Also involved in C# coding with Oracle PL/SQL for excel download reports
  • Designing the Actuate reports as per client requirement.

Confidential

Data Modeler and Database Administration for Applications

Responsibilities:

  • Create stored procedures and functions for both solutions. To optimize our stored procedures and functions that will give wonderful performance as we are going to handle large set of data in healthcare units. Migration
  • Migrate the existing iCM database to our Confidential database structure with mapping of valid data from iCM to Confidential application. Using functionalities of source and target application, we need to create flat file for target structure with source valid data after mapping between these two structures. DB Upgradation
  • Upgrade database with new schemas, stored procedures and functions with factory setting data for each and every build based on product build by using our own DB deployment tool and Bulk load tool
  • CDC Related data import and export by using DTS packages Solution Configuration
  • Customize the menus, tabs, links and wizard from our main product by using SQL Scripts
  • Import and Export the primary care Solution related factory setting data and non-factory setting data by using BCP SQL Server 2000.

Confidential

Data Modeler, Data Migration, PLSQL Programming and Performance tuning

Responsibilities:

  • Database Design based on functionality with legacy system.
  • Migration of 10 years data from Sybase Adaptive Server database to Oracle (Scripts SQL/PLSQL).
  • Involved in database tuning and monitoring
  • Perform Database Security and User administration using Roles, Profiles, Synonyms and Auditing.
  • Grants for objects in a common schema to other roles.
  • Creating custom Database Packages, Procedures, functions and Triggers.
  • Developed and implemented Backup & Recovery procedures that include off-line and on-line Backup, Export & Import

We'd love your feedback!