We provide IT Staff Augmentation Services!

Oracle Dba/developer Instructor Resume

0/5 (Submit Your Rating)

Los Angeles, CA

SUMMARY

  • Over 10 years of IT experience in the field of Business/Data analysis, ETL Development, Data Modeling, and Project Management
  • Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services and Configuration Management
  • Over 3 years of experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin, Toad Data Modelar and SQL Developer Data Modelar Ver 3.14
  • Strong background on Informatica Power Center 6.2/7.1/8.1.1 with expertise in installation on different platforms, Administration by Repository Manager/ Admin Console, and coding by Designer, Workflow Manager/ Monitor
  • Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
  • Expertise in extracting, transforming and loading the data in the Data Warehouse using Informatica Power Center/ Power Mart
  • Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies
  • Expertise in implementing complex business rules by creating re-usable transformations, and Mappings/Mapplets
  • Worked on Databases like Oracle 8.0/9.1/10g/11g, MS SQL Server, and IBM DB2
  • Worked on different platforms like Windows 95/windows/98/NT and UNIX
  • Experience in coding SQL/PL SQL using Procedures, Triggers and Packages
  • Experience in Data Mining with exposure to OLAP, OLTP, database administration, data warehouse development, System analysis and Design methods, development, maintenance and implementation
  • Experience in Working with different industries like Financial and Manufacturing

TECHNICAL SKILLS

Software: MS Excel, MS Word, MS FrontPage, MS Project, MS Outlook, Visual Studio .Net 2005, Smart Draw,Photoshop CS 5, Jgrasp, Net Beans, VM Ware, Notepad++, Crystal Reports

Languages: PL/SQL, SQL XML/XDK, Shell Scripting, Java, PHP, HTML, C, C++,PHPAction Script, HTML

Databases: Oracle 11g/10g/9i/ 8i/8/7.x/6.x, MS SQL Server 2005 & 2008, MYSQL, MS Access

Platforms: Linux, Sun Solaris, AIX, HP UNIX, Windows server 2008/NT/XP/98,Vista and Windows 7

Development: Developer Suite 10g, (Forms 10g/9i/6i/4.5), SQL NavigatorPLSQL Developer, SQL Developer, Warehouse Builder, Java DeveloperToad 8.5, Graphvz and Informatica 7, Toad 11.6

Data Modeling: ERwin 7.1/4.x/3.x, UML,MS Visio, Toad Data Modeler

Power Shell: Windows Power Shell command line utility i.e. PS Scripting, SQL Server PSGeneral task, scheduled Sripts, Creating database tables, Invoke SQLCMD etc.

PROFESSIONAL EXPERIENCE

ETL / Technical Database Specialist

Confidential, Pasadena, CA

Responsibilities:

  • Analyzed the existing operational system and designed the Dimensional Model approach for the Data Warehouse using Star Schema Model.
  • Draw the granularity for the fact and dimension tables and identified the relationships between them across each Star Schema
  • Created Logical/physical Data Model in Erwin and has done forward engineering to load the tables in the Data Warehouse
  • Worked extensively with the Toad Model Mart for version control
  • Extensively used Oracle Loader and PL/SQL for ETL
  • Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data
  • Optimized Query Performance, Session Performance and Reliability
  • Performance tuning of PL/SQL Scripts
  • Worked on Informatica tools - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations
  • Extensively used ETL to load from operational system (Oracle databases) and ASCII files into the Oracle target database
  • Worked on Extraction, Transformations, Loading, Conversions and Analysis of Data
  • Designed and developed scheduling and automation of load process using UNIX shell scripts.
  • Extensively involved in creating database procedures, functions and triggers using PL/SQL
  • Involved in the performance tuning of the SQL queries by restructuring the Joins, creation of indexes etc..

Oracle DBA/Developer Instructor

Confidential, Los Angeles, CA

Responsibilities:

  • Day to Day Database Administration, monitor Data files, performance tuning both server level and SQL level.
  • Provide PLSQL/SQL, ETL Development training for professionals.
  • Installation, tuning and upgrades the database.
  • Installation Red Hat Linux and provide training for Born and C Shell.
  • Training for MS Access / SQL Server Database, Word, Excel, Powerpoint and Visio.
  • ETL tool, download the data outside of the database into MS Access Database.
  • Provide PHP, JSP and HTML training.
  • Provide training oracle Java database programming.

ETL Developer

Confidential, Calabasas, CA

Responsibilities:

  • Creating and design ETL Process through Informatica ( Power Center) 7.1.4.
  • Installing and configuration Power Center client, configured repository, registering the Power Center server, Setting up the powercenter Metadata, connecting the database etc.
  • Managing the repository, folders, security, versioned objects, grouping, copying objects, exporting and importing objects, exchange metadata.
  • Work with Requirements Analysts and Subject Matter Experts to identify, understand and document business needs for the data flow.
  • Work closely with various financial and mortgage business teams in gathering the business requirements.
  • Work with the Project Management in the creation of project estimates.
  • Analysis of the data identifying source of data and data mappings of HCFG
  • Worked extensively in documenting the Source to Target Mapping documents with data transformation logic
  • Interact with the SME’s to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system
  • Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
  • Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
  • Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
  • Enforce standards to ensure that the data elements and attributes are properly named,
  • Work with the business and the ETL developers in the analysis and resolution of data related problem tickets.
  • Support development teams creating applications against supported databases.
  • Provide 24 x 7 problem management support to the development team.
  • Document various Data Quality mapping document, audit and security compliance adherence.
  • Perform small enhancements (SOR element additions, data cleansing/data quality).
  • Create various Data Mapping Repository documents as part of Metadata services (EMR).
  • Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
  • Provide support in developing and maintaining ETL processes that extract data from multiple SOR’s residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.

Senior ETL / PLSQL Developer

Confidential, Los Angeles, CA

Responsibilities:

  • Created PL/SQL stored procedures, functions, packages and triggers to transform and load staging table data into fact & dimension tables, by applying critical business needs of wireless industry.
  • Maintained log of unprocessed records by writing efficient exceptions in PL/SQL programs.
  • Responsible for interacting with business analysts to apply data transformation rules in PL/SQL programs.
  • Created and maintained Partitioned Tables and Indexes that helps in maintaining large tables efficiently.
  • Written functions and procedures for implementation of the business logic as per the client requirement
  • Created Materialized Views to leverage speed of extracting data from large fact tables.
  • Hand on experience on ETL and data integration experience in developing ETL mappings and scripts using Informatica (Power Center), TOAD and Warehouse Builder.
  • Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
  • Maintained data security by creating database triggers to populate audit trail columns in dimension, lookup and cross-reference tables.
  • Performed SQL & PL/SQL tuning using Explain Plan and TKPROF
  • Used TOAD Schema Browser to navigate through various objects and SQL Editor to test and tune complex SQL Queries
  • Designed database schema using Erwin tool.
  • Created the database schema objects like tables, views, synonyms, indexes, procedures, and functions. Written UNIX shell scripts to transform & load data from flat file to staging tables.
  • Involved in the Database design and Technical Design Specifications for enhancement applications using Designer 6i
  • Involved in the Data modeling of ER diagrams, Functional flow diagrams, Data Flow diagrams using Oracle Designer
  • Created tables spaces, tables, views, indexes, synonyms, and integrity constraints.
  • Designed and Developed the Master and Transaction Forms using Oracle Forms 10g/6i through Designer 10g/6i.
  • Designed and developed 25 Master forms, 100 Transaction Forms and 120 Reports using Oracle Forms 10g/6i Reports 10g/6i and PL/SQL
  • Wrote stand alone stored procedures, triggers, functions and packages using PL/SQL
  • Developed and executed Template form using Oracle Forms 6i and PL/SQL which is used throughout the application
  • Worked on Predefined, User-defined and System defined exceptions to handle different types of errors like NO DATA FOUND, DUP VAL ON INDEX, and PRAGMA EXCEPTION INIT etc.
  • Involved in the SQL query tuning of the application using TOAD, EXPLAIN Plan
  • Involved in major role of Conversion and Migration of the data from old system in the new System
  • Extensively worked in the Web Deployment of the application in the Front end forms using Web Logic Server and Eclipse
  • Involved in Testing of Unit, Functional Testing and Integration Testing

Senior Oracle Developer

Confidential

Responsibilities:

  • Designed various front-end screens of application using Oracle Designer 6 and Forms 6i
  • Developed various Reports in Oracle Designer 6i and Reports 6i.
  • Customized and developed program Libraries (PLL) for the application screens in Oracle Forms 6i
  • Developed and in corporate changes in various packages, libraries, procedures and functions to support and develop new application.
  • Designing and developing various modules of company new application from scratch which enable company to enter in international market using and Reports 6i.
  • Designed physical and logical database using Oracle Designer 6i and ERWIN data-modeling tools.
  • Designed and developed schemas, creating tables, views, and constraints based on international and national market manufacturing Industry business rules.
  • Performance tuning of queries and cursors using HINTS, Explain Plan and TKProf and PL/SQL Developer
  • Developed backend procedures, functions, libraries and triggers for Data validation, and parsing EDI files data into database.
  • Developed Advance PL/SQL packages, procedures, triggers and functions to implement business logic.
  • Generated Tech Documentation, detail designs, SDDs, DFDs, and user manuals of interfaces that are developed in customer service and billing and cash to help users and tester understand application while they test or use it.
  • Experience in converting and comparing large objects (LOB).
  • Actively used various Oracle Utilities and standard packages UTL File, Text IO, SQL*Loader, Export/Import etc.
  • Supported Oracle Apps customization and development
  • Assist and support users in user testing and helping to ensure accuracy Designed and developed schemas, tables, views, constraints, and triggers to make system automatic, Performed tuning and optimized complex queries using hints.
  • Developed complex packages, functions and procedures to convert and parse data from XML files to multiple database tables.
  • Worked as Senior Oracle Developer and Database Designer, supports very large database by developing routines at backend packages for company’s intranet application.
  • Worked closely with Production Database Administrators to implement new releases.

We'd love your feedback!