Database Management Systems Resume

SUMMARY:

A PL/SQL Oracle database developer, with 3+ years of relevant experience.
Entity - Relationship diagram (ER diagram).
Logical and physical data modeling, stored procedures, functions, triggers, cursors, procedures, packages, performance tuning, explain plan, indexes, hints.

TECHNICAL SKILLS:

Database & Tools: Oracle 11g, SQL Server, MySQL, ErWin Data Modeler, Visio, SQL*Loader, SQL*Plus, TOAD, Explain Plan, SAS Base, Tableau, Excel, Putty, WinSCP, Informatica

Languages: PL/SQL, SQL, Unix shell scripting, Java, Hive Query Language (HiveQL) for Hadoop

Methodologies: SDLC, Agile, ITIL, ITSM, data warehouse design - Kimball, Inmon, crow-foot notation, chen notation

PROFESSIONAL EXPERIENCE:

Confidential

Database Management Systems

Responsibilities:

Designed solution for inventory control - reorder point using demand forecast, lead-time, safety stock
Performed business analysis - researched, developed business requirements for the hospital supply chain subsystem
Designed database system on Oracle 11g - logical and physical model, forward engineering using ErWin data modeler
Developed 26 tables, 4 procedures, 4 functions, 2 triggers- PL/SQL on TOAD, imported data into tables using SQL loader

Confidential

Datawarehousing

Responsibilities:

Designed model for data warehouse - star-schema, developed grain, fact and dimension tables using Kimball approach
Loaded large datasets into Oracle 11g using SQL Loader, performed ETL in SQL, dashboard and reports in Tableau 10.0

Confidential

Analyst

Responsibilities:

Implemented transformations in SQL, tested ETL output against specified business requirements for transformations
Loaded csv flat files from different systems, into the SQL Server database, initial cleanup to ready data for processing

Confidential

Software Engineer

Responsibilities:

Lead enterprise-level database changes, onsite coordinator, single point of contact (SPOC) for critical application, dealing with 8 other application systems to implement a Common Exchange Model (CEM) data across the enterprise
Documented high-level and low-level design solutions for database change requests, and problem requests
Designed normalized database tables using logical, physical data models for changes - Oracle 10g, Oracle 11g database
Compared data model for the application with existing database object implementation, corrected non-conforming objects
Created stored procedures - procedures, functions, packages, triggers and used dynamic SQL, cursors, DML, DDL to implement business logics and process bulk data - OLTP database
Developed test plan, strategy for database changes; performed unit test, system test, and system integration testing
Optimized reports by 30% - Performance tuning of SQL queries using EXPLAIN PLAN, indexes, hints, table partitions, rewriting query to avoid Cartesian joins
Drove a 40% decrease in completion time of a recurrent data deployment activity - created deployment plan, optimized data validation scripts, backup scripts, trained team members, validated data quality, built strategy to forward bulk data to other systems involving EDI and B2B, communicated with client, senior managers, other teams
Created, maintained - materialized views, data update via REFRESH - FAST, FORCED, COMPLETE, and performed DDL
Worked closely with data architect, solution architect, test manager, and business analyst to lead database solutions
Monitoring governance - 24x7 L2 support for critical incidents, post Go Live support for development release, patches
Acted as key database specialist for critical application, guided SLA team of 7 members - incident root cause analysis
Wrote job files in unix shell script, with SQL query and identifiers, to exchange data between two relational databases
Trained the team members from capgemini during project transition - application database, tools, business processes

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship