SUMMARY:

• Having 14+ plus years of experience in Software Design, Development, Integration, Implementation in Oracle Technologies
• Expertise in Oracle PL/SQL, Forms and Reports.
• Have experienced to generate AWR Reports and analyzing the performance
• Experienced in Database Performance Tuning and Query tuning.
• Creating the tables and portioned the tables
• Design Data Modeling - Conceptual, Logical and Physical
• Database Design, Consultation and Architecting
• Database reverse engineering and forward engineering
• Define the Database Design as per the application requirement
• Experience in the development of a data strategy and associated policies
• Have Experienced in Requirement Gathering
• Oracle Application DBA Experience
• Define and Creating Oracle Schemas for Application Requirements
• Defining the required roles and grant the appropriate roles to Application database users
• Creating DDL scripts for table creation and other DB objects creation
• Export and Import the Oracle schemas
• Create tablespace, datafiles and Monitoring the tablespaces growth
• Monitoring the sessions and locking
• Managing database parameter values
• Tableau Reports Development
• Have experienced in JMeter Performance testing
• Identifying and documenting Risks, Issues, Assumptions and any Dependencies on Impact Analysis
• Experience in Production Application Support
• Experienced in Agile Software Development
• Knowledge on ETL Development

SKILLS:

• Oracle PL/SQL
• Data Modeling (ERWIN, Oracle SQL Data Modeler)
• Tableau Reports
• Oracle Forms and Reports 11G
• JMeter Performance Testing
• Metric Stream GRC
• MYSQL
• UNIX
• VB 6.0, HTML and ASP 3.0
• Open Office and Crystal Reports
• Telecom
• Transportation-Freight Forwarding/Logistics
• Manufacturing
• GRC-Policy and Document Management System & Compliance
• Warehousing Management System
• Application Modernization

WORK EXPERIENCE:

Confidential, Herndon, VA

Application DBA, Data Modeler, PL/SQL Developer

Responsibilities:

• Converts business requirements and specifications into Data Model using ERWIN and SQL Data Modeler
• Create data models and xml schemas at all levels including conceptual, logical, and physical for both relational and dimensional solutions. Models will include objects, entities, attributes, their inter-relationships and dependencies
• Have expertized in Reverse and Forward Engineered in Data Modelling
• Enforced Naming Standardization for Entities and Attributes by defining Glossary file
• Created and implemented ER models and dimensional models (star schemas).
• Involved in PL/SQL Development- Writing Complex Package, Procedures, Views, DBMS Schedulers, Function, Table Partitioning and complex queries with better performance
• Performed JMeter performance testing
• Generate DDL from Data Model for Physical Structure Creation in Database.
• Defined Appropriate Constraints and relationship between the entities
• Have experienced to define Domain Attributes to enforce appropriate datatypes
• Define the Database Design as per the application requirement
• Periodically Review data model with Customer
• Have Spitted model into appropriate Subject Areas
• Represented Data model on LLD Review
• Have Maintained Data Model with different Versions and Created Data Dictionary for meta data to understand attributes by other team members
• Prepared Data Mapping between different Application Sources
• Have been involving Application DBA Activities (Database schema users Creation, Tablespace Creation, Roles Creation, Database Backup, Database Scheduler Creation)
• Proposed New Database features to customer
• Have experienced Database Defragmentation by moving data to different tablespaces

Confidential, San Jose, USA.

PL/SQL Developer, GRC Consultant, Reports Developer

Project Environment: MetricStream GRC, Oracle Database, UNIX and Open Office Reports

Responsibilities:

• Involved in overall coordination regarding Installation, configuration and setup of MetricStream Out of Box Solution
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications
• Have migrated Data from previous system to out of box solution
• Have developed Customized Reports and Dashboards
• Have configured out of box solution to customer by defining all the initial setup.
• Have Prepared Documentation - SMTD and LLD
• Tracking Project Status and Preparing WSR Reports to present to customer.
• Collaborated with internal stakeholders to drive efficiency and effectiveness of the metrics and reporting
• Have involved in Impact Analysis on PL/SQL Development changes.
• Have involved MetricStream GRC Development
• Ensured from Customer for Sign-off for deliverable
• Have prepared User Guide and provided GRC training to End users
• Have prepared Test cases and well document including DR test cases
• Have Setup Disaster Recover by coordinating with DEVOPS Team
• Have experienced in Open Office Reports Development

Confidential

Oracle Application DBA, Data Modeler

Project Environment: ERWIN, Oracle Database

Responsibilities:

• Creating Oracle Users and Assigning related roles to the user
• Creating DDL script for Table creation
• Have Developed Conceptual, Logical and Physical Data Model
• Forward engineer physical models to create DDL scripts to implement new databases or database changes. Reverse engineer databases and synchronize data models with actual data implementations
• Create data dictionaries and business glossaries to document data lineages, data definitions and metadata for all business-critical data domains
• Capture business rules that govern how data is transformed, integrated, and used

Confidential

PL/SQL Developer, Data Modeler

Project Environment: Oracle Database, SQL Data Modeler and ETL

Responsibilities:

• Assisting with data analysis, strategy, and modeling
• Supporting users of the schema and the standard data models
• Review PL/SQL Code and provided feedback to improve performance
• Preparing Source and Target Data Mapping
• Prepared Data Dictionary

Confidential

PL/SQL Developer

Project Environment: Oracle Database and SSIS

Responsibilities:

• Have involved in POC for ETL between different databases
• Analyzing AWR Reports to identify database performances
• Have tuned complex Oracle SQL Queries
• Have experienced in Database Job Scheduler
• Have worked on PL/SQL Development and SSIS
• Have created data Modelling for ETL Process
• Experience in creating/reviewing Requirement Specification & Design documents
• Developed complex Oracle Database Procedures

Confidential, San Jose

PL/SQL Developer

Project Environment: Oracle PL/SQL and Oracle Apps Technical Consultant

Responsibilities:

• Have provided production Support
• Have Monitored Remedy Ticket system and assigned to Team Members
• Have Mentored the team to debug the issues
• Involved Deployment and Release Management Activities with different teams.

Confidential

Oracle Forms, PL/SQL Developer

Project Environment: ERWIN and Oracle

Responsibilities:

• Have developed Oracle Forms and Reports for Warehouse Management System
• Created Master detail forms and created template forms

Confidential

Oracle Application DBA, PL/SQL Developer, Data Modeler

Project Environment: Oracle PL/SQL, Forms, and Reports

Responsibilities:

• Experienced with conceptual data models
• Experienced in taking complex business problems and visualizing and simplifying them
• Experienced using Erwin to data model
• Experienced using a model repository to keep enterprise models updated
• Experienced with data movement technologies(ETL)
• Pl/SQL development (Stored Procs, Views & functions) in PL/SQL, Performance optimization and query tuning
• Have involved Deployment and Release Activities
• Have prepared technical and functional document
• Creating Views, Packages, Functions and Triggers
• Have created Types, PL/SQL tables and Exception Handling

Confidential

PL/SQL, Oracle Forms, Reports Developer, Data Modeler

Project Environment: Oracle PL/SQL, Forms, and Reports

Responsibilities:

• Have created New GUI Screen using Oracle Forms and Reports
• Have worked on PL/SQL Development by using Oracle Objects(Packages, Cursors, Procedures, Functions, Triggers, Views, Synonyms, Database Jobs, Dynamic SQL, Exception handling
• Have worked in PL/SQL Collections, Performance Tuning, Access Files using UTL FILE, Indexes, Constraints, Complex Joins, Analytic Functions and Aggregate Functions, Global Temporary Tables, Ref Cursor, Materialized Views, Materialized Views, Sequences, Different Loops)
• Have experienced for requirements analysis, design, development, testing, documentation, user training and support
• Have implemented Freight Forwarding Out of Box Solution to customers.
• Design and develop data models
• Identify business data entities and attributes
• Create physical and logical data model
• Create SQL scripts and procedures to enable interaction with the front end applications for data retrieval
• Create SQL scripts for data migration